Symfony Profiler

Query Metrics

125 Database Queries

31 Different statements

15.06 ms Query time

1 Invalid entities

75 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.85 ms
(12.28%)

SELECT t0.id AS id_1, t0.shipping_key AS shipping_key_2, t0.shipping_value AS shipping_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shipping_method_id AS shipping_method_id_6 FROM shipping_method_settings t0 WHERE t0.shipping_method_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.shipping_key AS shipping_key_2,
  t0.shipping_value AS shipping_value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.shipping_method_id AS shipping_method_id_6
FROM
  shipping_method_settings t0
WHERE
  t0.shipping_method_id = ?

SELECT t0.id AS id_1, t0.shipping_key AS shipping_key_2, t0.shipping_value AS shipping_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shipping_method_id AS shipping_method_id_6 FROM shipping_method_settings t0 WHERE t0.shipping_method_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 210)
5	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	handle (line 143)

1.75 ms
(11.61%)

SELECT c0_.id AS id_0, c0_.holiday_type AS holiday_type_1 FROM company_calendar c0_ WHERE DATE(c0_.start_date) = ? AND c0_.start_date IS NOT NULL AND c0_.end_date IS NULL AND (c0_.holiday_type = ? OR c0_.holiday_type = ?) LIMIT 1

Parameters:

[
  "2026-06-17"
  "holiday"
  "companyouttime"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.holiday_type AS holiday_type_1
FROM
  company_calendar c0_
WHERE
  DATE(c0_.start_date) = ?
  AND c0_.start_date IS NOT NULL
  AND c0_.end_date IS NULL
  AND (
    c0_.holiday_type = ?
    OR c0_.holiday_type = ?
  )
LIMIT
  1

SELECT c0_.id AS id_0, c0_.holiday_type AS holiday_type_1 FROM company_calendar c0_ WHERE DATE(c0_.start_date) = '2026-06-17' AND c0_.start_date IS NOT NULL AND c0_.end_date IS NULL AND (c0_.holiday_type = 'holiday' OR c0_.holiday_type = 'companyouttime') LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\Service\StockIndicatorService->getDelDateHolidaysCount (line 1388)
7	App\Service\StockIndicatorService->getDelDatecalculateSendOutDay (line 1277)
8	App\Service\StockIndicatorService->getDelDateCartCheckoutStockAndStockIndicators (line 1193)
9	App\Service\StockIndicator\IndicatorHelperService->systemAutoSaCheckAll (line 1760)
10	App\Service\StockIndicator\IndicatorHelperService->stockAndStockIndicator (line 76)
11	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 255)
12	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 197)
16	handle (line 143)

1.67 ms
(11.12%)

SELECT c0_.id AS id_0, c0_.holiday_type AS holiday_type_1 FROM company_calendar c0_ WHERE DATE(c0_.start_date) <= ? AND DATE(c0_.end_date) >= ? AND c0_.start_date IS NOT NULL AND c0_.end_date IS NOT NULL AND (c0_.holiday_type = ? OR c0_.holiday_type = ?) LIMIT 1

Parameters:

[
  "2026-06-17"
  "2026-06-17"
  "holiday"
  "companyouttime"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.holiday_type AS holiday_type_1
FROM
  company_calendar c0_
WHERE
  DATE(c0_.start_date) <= ?
  AND DATE(c0_.end_date) >= ?
  AND c0_.start_date IS NOT NULL
  AND c0_.end_date IS NOT NULL
  AND (
    c0_.holiday_type = ?
    OR c0_.holiday_type = ?
  )
LIMIT
  1

SELECT c0_.id AS id_0, c0_.holiday_type AS holiday_type_1 FROM company_calendar c0_ WHERE DATE(c0_.start_date) <= '2026-06-17' AND DATE(c0_.end_date) >= '2026-06-17' AND c0_.start_date IS NOT NULL AND c0_.end_date IS NOT NULL AND (c0_.holiday_type = 'holiday' OR c0_.holiday_type = 'companyouttime') LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\Service\StockIndicatorService->getDelDateHolidaysCount (line 1409)
7	App\Service\StockIndicatorService->getDelDatecalculateSendOutDay (line 1277)
8	App\Service\StockIndicatorService->getDelDateCartCheckoutStockAndStockIndicators (line 1193)
9	App\Service\StockIndicator\IndicatorHelperService->systemAutoSaCheckAll (line 1760)
10	App\Service\StockIndicator\IndicatorHelperService->stockAndStockIndicator (line 76)
11	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 255)
12	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 197)
16	handle (line 143)

1.38 ms
(9.17%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.is_default = ? AND t0.status = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.status AS status_4,
  t0.sort_order AS sort_order_5,
  t0.is_default AS is_default_6,
  t0.is_b2c AS is_b2c_7,
  t0.is_b2b AS is_b2b_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.courier_id AS courier_id_11
FROM
  shipping_method t0
WHERE
  t0.is_default = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.is_default = 1 AND t0.status = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 208)
4	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	handle (line 143)

0.79 ms
(5.22%)

SELECT t0.id AS id_1, t0.shipping_key AS shipping_key_2, t0.shipping_value AS shipping_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shipping_method_id AS shipping_method_id_6 FROM shipping_method_settings t0 WHERE t0.shipping_method_id = ? AND t0.shipping_key = ? LIMIT 1

Parameters:

[
  2
  "bufferDaysSetting"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.shipping_key AS shipping_key_2,
  t0.shipping_value AS shipping_value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.shipping_method_id AS shipping_method_id_6
FROM
  shipping_method_settings t0
WHERE
  t0.shipping_method_id = ?
  AND t0.shipping_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.shipping_key AS shipping_key_2, t0.shipping_value AS shipping_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shipping_method_id AS shipping_method_id_6 FROM shipping_method_settings t0 WHERE t0.shipping_method_id = 2 AND t0.shipping_key = 'bufferDaysSetting' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\StockIndicatorService->getDelDatecalculateSendOutDay (line 1269)
5	App\Service\StockIndicatorService->getDelDateCartCheckoutStockAndStockIndicators (line 1193)
6	App\Service\StockIndicator\IndicatorHelperService->systemAutoSaCheckAll (line 1760)
7	App\Service\StockIndicator\IndicatorHelperService->stockAndStockIndicator (line 76)
8	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 255)
9	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 143)

0.78 ms
(5.19%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.alias = ? AND t0.status = ? AND t0.is_b2c = ? LIMIT 1

Parameters:

[
  "nt-sd-ev"
  1
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.status AS status_4,
  t0.sort_order AS sort_order_5,
  t0.is_default AS is_default_6,
  t0.is_b2c AS is_b2c_7,
  t0.is_b2b AS is_b2b_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.courier_id AS courier_id_11
FROM
  shipping_method t0
WHERE
  t0.alias = ?
  AND t0.status = ?
  AND t0.is_b2c = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.alias = 'nt-sd-ev' AND t0.status = 1 AND t0.is_b2c = '1' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\ShippingMethodService->isNoTimeSameDayShipping (line 467)
4	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 187)
5	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	handle (line 143)

0.76 ms
(5.01%)

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.stock_place AS stock_place_3, t0.quantity1 AS quantity1_4, t0.quantity2 AS quantity2_5, t0.lamp AS lamp_6, t0.message AS message_7, t0.tooltip AS tooltip_8, t0.working_days AS working_days_9, t0.buffer_days_setting AS buffer_days_setting_10, t0.buffer_days AS buffer_days_11, t0.product_type AS product_type_12, t0.vct_stock_status AS vct_stock_status_13, t0.no_guarante AS no_guarante_14, t0.detail_link AS detail_link_15, t0.message1 AS message1_16, t0.message2 AS message2_17, t0.default_name AS default_name_18, t0.is_default AS is_default_19, t0.allow_add_to_cart AS allow_add_to_cart_20 FROM stock_indicators t0 WHERE t0.stock_place = ? AND t0.quantity1 = ? LIMIT 1

Parameters:

[
  "INT"
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.stock_place AS stock_place_3,
  t0.quantity1 AS quantity1_4,
  t0.quantity2 AS quantity2_5,
  t0.lamp AS lamp_6,
  t0.message AS message_7,
  t0.tooltip AS tooltip_8,
  t0.working_days AS working_days_9,
  t0.buffer_days_setting AS buffer_days_setting_10,
  t0.buffer_days AS buffer_days_11,
  t0.product_type AS product_type_12,
  t0.vct_stock_status AS vct_stock_status_13,
  t0.no_guarante AS no_guarante_14,
  t0.detail_link AS detail_link_15,
  t0.message1 AS message1_16,
  t0.message2 AS message2_17,
  t0.default_name AS default_name_18,
  t0.is_default AS is_default_19,
  t0.allow_add_to_cart AS allow_add_to_cart_20
FROM
  stock_indicators t0
WHERE
  t0.stock_place = ?
  AND t0.quantity1 = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.stock_place AS stock_place_3, t0.quantity1 AS quantity1_4, t0.quantity2 AS quantity2_5, t0.lamp AS lamp_6, t0.message AS message_7, t0.tooltip AS tooltip_8, t0.working_days AS working_days_9, t0.buffer_days_setting AS buffer_days_setting_10, t0.buffer_days AS buffer_days_11, t0.product_type AS product_type_12, t0.vct_stock_status AS vct_stock_status_13, t0.no_guarante AS no_guarante_14, t0.detail_link AS detail_link_15, t0.message1 AS message1_16, t0.message2 AS message2_17, t0.default_name AS default_name_18, t0.is_default AS is_default_19, t0.allow_add_to_cart AS allow_add_to_cart_20 FROM stock_indicators t0 WHERE t0.stock_place = 'INT' AND t0.quantity1 = 3 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\StockIndicatorService->getDelDateCartCheckoutStockAndStockIndicators (line 1183)
4	App\Service\StockIndicator\IndicatorHelperService->systemAutoSaCheckAll (line 1760)
5	App\Service\StockIndicator\IndicatorHelperService->stockAndStockIndicator (line 76)
6	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 255)
7	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 143)

0.68 ms
(4.51%)

SELECT s0_.price AS price_0, s0_.start_date AS start_date_1, s0_.expire_date AS expire_date_2 FROM special_price s0_ WHERE s0_.product_id = ? AND s0_.product_attribute_id = ? AND s0_.status = 1 LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.price AS price_0,
  s0_.start_date AS start_date_1,
  s0_.expire_date AS expire_date_2
FROM
  special_price s0_
WHERE
  s0_.product_id = ?
  AND s0_.product_attribute_id = ?
  AND s0_.status = 1
LIMIT
  1

SELECT s0_.price AS price_0, s0_.start_date AS start_date_1, s0_.expire_date AS expire_date_2 FROM special_price s0_ WHERE s0_.product_id = 13507 AND s0_.product_attribute_id = 1095431 AND s0_.status = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\Service\StockIndicator\IndicatorHelperService->getSellingPrice (line 1594)
7	App\Service\StockIndicator\IndicatorHelperService->stockAndStockIndicator (line 75)
8	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 255)
9	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 143)

0.65 ms
(4.29%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.time_line AS time_line_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM order_timelines t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "customer order submit time"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.time_line AS time_line_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  order_timelines t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.time_line AS time_line_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM order_timelines t0 WHERE t0.name = 'customer order submit time' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\StockIndicatorService->getDelDatecalculateSendOutDay (line 1279)
5	App\Service\StockIndicatorService->getDelDateCartCheckoutStockAndStockIndicators (line 1193)
6	App\Service\StockIndicator\IndicatorHelperService->systemAutoSaCheckAll (line 1760)
7	App\Service\StockIndicator\IndicatorHelperService->stockAndStockIndicator (line 76)
8	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 255)
9	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 143)

0.51 ms
(3.36%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.product_attribute_id AS product_attribute_id_3, t0.category_product_characteristic_id AS category_product_characteristic_id_4, t0.category_product_characteristic_value_id AS category_product_characteristic_value_id_5 FROM child_product_characteristic_value t0 WHERE t0.product_attribute_id = ? AND t0.category_product_characteristic_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.product_attribute_id AS product_attribute_id_3,
  t0.category_product_characteristic_id AS category_product_characteristic_id_4,
  t0.category_product_characteristic_value_id AS category_product_characteristic_value_id_5
FROM
  child_product_characteristic_value t0
WHERE
  t0.product_attribute_id = ?
  AND t0.category_product_characteristic_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.product_attribute_id AS product_attribute_id_3, t0.category_product_characteristic_id AS category_product_characteristic_id_4, t0.category_product_characteristic_value_id AS category_product_characteristic_value_id_5 FROM child_product_characteristic_value t0 WHERE t0.product_attribute_id = 1095431 AND t0.category_product_characteristic_id = 275 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\User\ProductController->getProductAttributesAction (line 9988)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	handle (line 143)

0.39 ms
(2.60%)

SELECT s0_.id AS id_0, s0_.icon AS icon_1, s0_.stock_place AS stock_place_2, s0_.quantity1 AS quantity1_3, s0_.quantity2 AS quantity2_4, s0_.lamp AS lamp_5, s0_.message AS message_6, s0_.tooltip AS tooltip_7, s0_.working_days AS working_days_8, s0_.buffer_days_setting AS buffer_days_setting_9, s0_.buffer_days AS buffer_days_10, s0_.product_type AS product_type_11, s0_.vct_stock_status AS vct_stock_status_12, s0_.no_guarante AS no_guarante_13, s0_.detail_link AS detail_link_14, s0_.message1 AS message1_15, s0_.message2 AS message2_16, s0_.default_name AS default_name_17, s0_.is_default AS is_default_18, s0_.allow_add_to_cart AS allow_add_to_cart_19 FROM stock_indicators s0_ WHERE s0_.stock_place = ? AND s0_.quantity2 >= ? LIMIT 1

Parameters:

[
  "INT"
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.icon AS icon_1,
  s0_.stock_place AS stock_place_2,
  s0_.quantity1 AS quantity1_3,
  s0_.quantity2 AS quantity2_4,
  s0_.lamp AS lamp_5,
  s0_.message AS message_6,
  s0_.tooltip AS tooltip_7,
  s0_.working_days AS working_days_8,
  s0_.buffer_days_setting AS buffer_days_setting_9,
  s0_.buffer_days AS buffer_days_10,
  s0_.product_type AS product_type_11,
  s0_.vct_stock_status AS vct_stock_status_12,
  s0_.no_guarante AS no_guarante_13,
  s0_.detail_link AS detail_link_14,
  s0_.message1 AS message1_15,
  s0_.message2 AS message2_16,
  s0_.default_name AS default_name_17,
  s0_.is_default AS is_default_18,
  s0_.allow_add_to_cart AS allow_add_to_cart_19
FROM
  stock_indicators s0_
WHERE
  s0_.stock_place = ?
  AND s0_.quantity2 >= ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.icon AS icon_1, s0_.stock_place AS stock_place_2, s0_.quantity1 AS quantity1_3, s0_.quantity2 AS quantity2_4, s0_.lamp AS lamp_5, s0_.message AS message_6, s0_.tooltip AS tooltip_7, s0_.working_days AS working_days_8, s0_.buffer_days_setting AS buffer_days_setting_9, s0_.buffer_days AS buffer_days_10, s0_.product_type AS product_type_11, s0_.vct_stock_status AS vct_stock_status_12, s0_.no_guarante AS no_guarante_13, s0_.detail_link AS detail_link_14, s0_.message1 AS message1_15, s0_.message2 AS message2_16, s0_.default_name AS default_name_17, s0_.is_default AS is_default_18, s0_.allow_add_to_cart AS allow_add_to_cart_19 FROM stock_indicators s0_ WHERE s0_.stock_place = 'INT' AND s0_.quantity2 >= 3 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\Service\StockIndicatorService->getDelDateCartCheckoutStockAndStockIndicators (line 1191)
7	App\Service\StockIndicator\IndicatorHelperService->systemAutoSaCheckAll (line 1760)
8	App\Service\StockIndicator\IndicatorHelperService->stockAndStockIndicator (line 76)
9	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 255)
10	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 197)
14	handle (line 143)

0.39 ms
(2.56%)

SELECT 1 AS sclr_0 FROM product_attribute p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = ? AND p1_.deleted = 0 AND p0_.deleted = 0 AND p0_.type = ? AND p0_.characteristic_type = ? AND ((p0_.status = 1 OR p0_.is_manual_status <> 1)) LIMIT 1

Parameters:

[
  13507
  "characteristic"
  "product_option"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 AS sclr_0
FROM
  product_attribute p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
WHERE
  p1_.id = ?
  AND p1_.deleted = 0
  AND p0_.deleted = 0
  AND p0_.type = ?
  AND p0_.characteristic_type = ?
  AND (
    (
      p0_.status = 1
      OR p0_.is_manual_status <> 1
    )
  )
LIMIT
  1

SELECT 1 AS sclr_0 FROM product_attribute p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = 13507 AND p1_.deleted = 0 AND p0_.deleted = 0 AND p0_.type = 'characteristic' AND p0_.characteristic_type = 'product_option' AND ((p0_.status = 1 OR p0_.is_manual_status <> 1)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\Service\StockIndicator\IndicatorHelperService->stockAndStockIndicator (line 120)
7	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 255)
8	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	handle (line 143)

0.36 ms
(2.41%)

SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = ?

Parameters:

[
  31378
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_specific_option_value AS product_specific_option_value_2,
  t0.product_filter_specific_option_value AS product_filter_specific_option_value_3,
  t0.product_tech_specific_option_value AS product_tech_specific_option_value_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.category_product_characteristic_id AS category_product_characteristic_id_7,
  t0.product_characteristic_value_id AS product_characteristic_value_id_8
FROM
  category_product_characteristic_value t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.product_specific_option_value AS product_specific_option_value_2, t0.product_filter_specific_option_value AS product_filter_specific_option_value_3, t0.product_tech_specific_option_value AS product_tech_specific_option_value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_product_characteristic_id AS category_product_characteristic_id_7, t0.product_characteristic_value_id AS product_characteristic_value_id_8 FROM category_product_characteristic_value t0 WHERE t0.id = 31378;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\CategoryProductCharacteristicValue::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\CategoryProductCharacteristicValue->__get (line 184)
7	App\Entity\CategoryProductCharacteristicValue->getProductCharacteristicValue (line 110)
8	App\Controller\User\ProductController->getProductAttributesAction (line 9926)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	handle (line 143)

0.36 ms
(2.37%)

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.price_mode AS price_mode_4, t0.discount_rate AS discount_rate_5, t0.price AS price_6, t0.net_price AS net_price_7, t0.start_date AS start_date_8, t0.expire_date AS expire_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.product_id AS product_id_13, t0.currency_id AS currency_id_14, t0.product_attribute_id AS product_attribute_id_15, t0.tax_id AS tax_id_16 FROM special_price t0 WHERE t0.product_attribute_id = ? AND t0.status = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.ip AS ip_3,
  t0.price_mode AS price_mode_4,
  t0.discount_rate AS discount_rate_5,
  t0.price AS price_6,
  t0.net_price AS net_price_7,
  t0.start_date AS start_date_8,
  t0.expire_date AS expire_date_9,
  t0.status AS status_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.product_id AS product_id_13,
  t0.currency_id AS currency_id_14,
  t0.product_attribute_id AS product_attribute_id_15,
  t0.tax_id AS tax_id_16
FROM
  special_price t0
WHERE
  t0.product_attribute_id = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.ip AS ip_3, t0.price_mode AS price_mode_4, t0.discount_rate AS discount_rate_5, t0.price AS price_6, t0.net_price AS net_price_7, t0.start_date AS start_date_8, t0.expire_date AS expire_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.product_id AS product_id_13, t0.currency_id AS currency_id_14, t0.product_attribute_id AS product_attribute_id_15, t0.tax_id AS tax_id_16 FROM special_price t0 WHERE t0.product_attribute_id = 1095431 AND t0.status = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Tool\User\Functions->isProductDS (line 4619)
4	App\Tool\User\Functions->getProductQuantity (line 4721)
5	App\Controller\User\ProductController->getProductAttributesAction (line 9911)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	handle (line 143)

0.32 ms
(2.13%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = ?

Parameters:

[
  246
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.product_characteristic_id AS product_characteristic_id_3
FROM
  product_characteristic_value t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0.id = 246;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\ProductCharacteristicValue::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\ProductCharacteristicValue->__get (line 184)
7	App\Entity\ProductCharacteristicValue->getValue (line 34)
8	App\Controller\User\ProductController->getProductAttributesAction (line 9926)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	handle (line 143)

0.28 ms
(1.89%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.characteristic_type AS characteristic_type_3, t0.alias AS alias_4, t0.code AS code_5, t0.mpn_code AS mpn_code_6, t0.ean_code AS ean_code_7, t0.iean_code AS iean_code_8, t0.sean_code AS sean_code_9, t0.is_iean_print AS is_iean_print_10, t0.is_cean_print AS is_cean_print_11, t0.is_sean_print AS is_sean_print_12, t0.sean AS sean_13, t0.org_supplier_id AS org_supplier_id_14, t0.price AS price_15, t0.price_gross AS price_gross_16, t0.msrp AS msrp_17, t0.distri_price AS distri_price_18, t0.stock_item_value AS stock_item_value_19, t0.prefix AS prefix_20, t0.stock_place AS stock_place_21, t0.product_type AS product_type_22, t0.quantity AS quantity_23, t0.minimum_stock AS minimum_stock_24, t0.minimum_stock_status AS minimum_stock_status_25, t0.mins_last_status AS mins_last_status_26, t0.is_force_mins AS is_force_mins_27, t0.is_ds AS is_ds_28, t0.is_force_ds AS is_force_ds_29, t0.int_stockyard AS int_stockyard_30, t0.vct_stock_quantity AS vct_stock_quantity_31, t0.vct_stock_status AS vct_stock_status_32, t0.expected_delivery_date AS expected_delivery_date_33, t0.seller_item_id AS seller_item_id_34, t0.other_seller_item_id AS other_seller_item_id_35, t0.other_supplier_id AS other_supplier_id_36, t0.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_37, t0.cost_price AS cost_price_38, t0.abroad_base_price AS abroad_base_price_39, t0.base_price AS base_price_40, t0.item_discount AS item_discount_41, t0.purchase_price AS purchase_price_42, t0.returnable AS returnable_43, t0.supplier_tax_category AS supplier_tax_category_44, t0.stock_shelf AS stock_shelf_45, t0.shelf_place AS shelf_place_46, t0.extra_charge AS extra_charge_47, t0.session_id AS session_id_48, t0.ip AS ip_49, t0.sort_order AS sort_order_50, t0.profit AS profit_51, t0.margin AS margin_52, t0.b2b_profit AS b2b_profit_53, t0.b2b_margin AS b2b_margin_54, t0.deleted AS deleted_55, t0.status AS status_56, t0.manual_status AS manual_status_57, t0.is_manual_status AS is_manual_status_58, t0.display_stock_report AS display_stock_report_59, t0.publish_date AS publish_date_60, t0.expire_date AS expire_date_61, t0.is_unite AS is_unite_62, t0.supplier_cart_id AS supplier_cart_id_63, t0.created_at AS created_at_64, t0.updated_at AS updated_at_65, t0.product_id AS product_id_66, t0.child_product_id AS child_product_id_67, t0.child_product_attribute_id AS child_product_attribute_id_68, t0.stock_indicators_id AS stock_indicators_id_69, t0.category_product_characteristic_id AS category_product_characteristic_id_70, t0.category_product_characteristic_value_id AS category_product_characteristic_value_id_71, t0.supplier_id AS supplier_id_72, t0.return_rule_id AS return_rule_id_73 FROM product_attribute t0 WHERE t0.product_id = ? AND t0.characteristic_type = ? AND t0.status = ? AND t0.deleted = ? ORDER BY t0.sort_order ASC

Parameters:

[
  "13507"
  "product_option"
  1
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.characteristic_type AS characteristic_type_3,
  t0.alias AS alias_4,
  t0.code AS code_5,
  t0.mpn_code AS mpn_code_6,
  t0.ean_code AS ean_code_7,
  t0.iean_code AS iean_code_8,
  t0.sean_code AS sean_code_9,
  t0.is_iean_print AS is_iean_print_10,
  t0.is_cean_print AS is_cean_print_11,
  t0.is_sean_print AS is_sean_print_12,
  t0.sean AS sean_13,
  t0.org_supplier_id AS org_supplier_id_14,
  t0.price AS price_15,
  t0.price_gross AS price_gross_16,
  t0.msrp AS msrp_17,
  t0.distri_price AS distri_price_18,
  t0.stock_item_value AS stock_item_value_19,
  t0.prefix AS prefix_20,
  t0.stock_place AS stock_place_21,
  t0.product_type AS product_type_22,
  t0.quantity AS quantity_23,
  t0.minimum_stock AS minimum_stock_24,
  t0.minimum_stock_status AS minimum_stock_status_25,
  t0.mins_last_status AS mins_last_status_26,
  t0.is_force_mins AS is_force_mins_27,
  t0.is_ds AS is_ds_28,
  t0.is_force_ds AS is_force_ds_29,
  t0.int_stockyard AS int_stockyard_30,
  t0.vct_stock_quantity AS vct_stock_quantity_31,
  t0.vct_stock_status AS vct_stock_status_32,
  t0.expected_delivery_date AS expected_delivery_date_33,
  t0.seller_item_id AS seller_item_id_34,
  t0.other_seller_item_id AS other_seller_item_id_35,
  t0.other_supplier_id AS other_supplier_id_36,
  t0.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_37,
  t0.cost_price AS cost_price_38,
  t0.abroad_base_price AS abroad_base_price_39,
  t0.base_price AS base_price_40,
  t0.item_discount AS item_discount_41,
  t0.purchase_price AS purchase_price_42,
  t0.returnable AS returnable_43,
  t0.supplier_tax_category AS supplier_tax_category_44,
  t0.stock_shelf AS stock_shelf_45,
  t0.shelf_place AS shelf_place_46,
  t0.extra_charge AS extra_charge_47,
  t0.session_id AS session_id_48,
  t0.ip AS ip_49,
  t0.sort_order AS sort_order_50,
  t0.profit AS profit_51,
  t0.margin AS margin_52,
  t0.b2b_profit AS b2b_profit_53,
  t0.b2b_margin AS b2b_margin_54,
  t0.deleted AS deleted_55,
  t0.status AS status_56,
  t0.manual_status AS manual_status_57,
  t0.is_manual_status AS is_manual_status_58,
  t0.display_stock_report AS display_stock_report_59,
  t0.publish_date AS publish_date_60,
  t0.expire_date AS expire_date_61,
  t0.is_unite AS is_unite_62,
  t0.supplier_cart_id AS supplier_cart_id_63,
  t0.created_at AS created_at_64,
  t0.updated_at AS updated_at_65,
  t0.product_id AS product_id_66,
  t0.child_product_id AS child_product_id_67,
  t0.child_product_attribute_id AS child_product_attribute_id_68,
  t0.stock_indicators_id AS stock_indicators_id_69,
  t0.category_product_characteristic_id AS category_product_characteristic_id_70,
  t0.category_product_characteristic_value_id AS category_product_characteristic_value_id_71,
  t0.supplier_id AS supplier_id_72,
  t0.return_rule_id AS return_rule_id_73
FROM
  product_attribute t0
WHERE
  t0.product_id = ?
  AND t0.characteristic_type = ?
  AND t0.status = ?
  AND t0.deleted = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.characteristic_type AS characteristic_type_3, t0.alias AS alias_4, t0.code AS code_5, t0.mpn_code AS mpn_code_6, t0.ean_code AS ean_code_7, t0.iean_code AS iean_code_8, t0.sean_code AS sean_code_9, t0.is_iean_print AS is_iean_print_10, t0.is_cean_print AS is_cean_print_11, t0.is_sean_print AS is_sean_print_12, t0.sean AS sean_13, t0.org_supplier_id AS org_supplier_id_14, t0.price AS price_15, t0.price_gross AS price_gross_16, t0.msrp AS msrp_17, t0.distri_price AS distri_price_18, t0.stock_item_value AS stock_item_value_19, t0.prefix AS prefix_20, t0.stock_place AS stock_place_21, t0.product_type AS product_type_22, t0.quantity AS quantity_23, t0.minimum_stock AS minimum_stock_24, t0.minimum_stock_status AS minimum_stock_status_25, t0.mins_last_status AS mins_last_status_26, t0.is_force_mins AS is_force_mins_27, t0.is_ds AS is_ds_28, t0.is_force_ds AS is_force_ds_29, t0.int_stockyard AS int_stockyard_30, t0.vct_stock_quantity AS vct_stock_quantity_31, t0.vct_stock_status AS vct_stock_status_32, t0.expected_delivery_date AS expected_delivery_date_33, t0.seller_item_id AS seller_item_id_34, t0.other_seller_item_id AS other_seller_item_id_35, t0.other_supplier_id AS other_supplier_id_36, t0.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_37, t0.cost_price AS cost_price_38, t0.abroad_base_price AS abroad_base_price_39, t0.base_price AS base_price_40, t0.item_discount AS item_discount_41, t0.purchase_price AS purchase_price_42, t0.returnable AS returnable_43, t0.supplier_tax_category AS supplier_tax_category_44, t0.stock_shelf AS stock_shelf_45, t0.shelf_place AS shelf_place_46, t0.extra_charge AS extra_charge_47, t0.session_id AS session_id_48, t0.ip AS ip_49, t0.sort_order AS sort_order_50, t0.profit AS profit_51, t0.margin AS margin_52, t0.b2b_profit AS b2b_profit_53, t0.b2b_margin AS b2b_margin_54, t0.deleted AS deleted_55, t0.status AS status_56, t0.manual_status AS manual_status_57, t0.is_manual_status AS is_manual_status_58, t0.display_stock_report AS display_stock_report_59, t0.publish_date AS publish_date_60, t0.expire_date AS expire_date_61, t0.is_unite AS is_unite_62, t0.supplier_cart_id AS supplier_cart_id_63, t0.created_at AS created_at_64, t0.updated_at AS updated_at_65, t0.product_id AS product_id_66, t0.child_product_id AS child_product_id_67, t0.child_product_attribute_id AS child_product_attribute_id_68, t0.stock_indicators_id AS stock_indicators_id_69, t0.category_product_characteristic_id AS category_product_characteristic_id_70, t0.category_product_characteristic_value_id AS category_product_characteristic_value_id_71, t0.supplier_id AS supplier_id_72, t0.return_rule_id AS return_rule_id_73 FROM product_attribute t0 WHERE t0.product_id = '13507' AND t0.characteristic_type = 'product_option' AND t0.status = 1 AND t0.deleted = 0 ORDER BY t0.sort_order ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\User\ProductController->getProductAttributesAction (line 9890)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	handle (line 143)

0.25 ms
(1.63%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.ecp AS ecp_3, t0.is_bulky AS is_bulky_4, t0.new_name AS new_name_5, t0.icp_name AS icp_name_6, t0.code AS code_7, t0.mpn_code AS mpn_code_8, t0.ean_code AS ean_code_9, t0.iean_code AS iean_code_10, t0.sean_code AS sean_code_11, t0.is_iean_print AS is_iean_print_12, t0.is_cean_print AS is_cean_print_13, t0.is_sean_print AS is_sean_print_14, t0.sean AS sean_15, t0.org_supplier_id AS org_supplier_id_16, t0.is_retail_hold AS is_retail_hold_17, t0.description AS description_18, t0.type AS type_19, t0.tags AS tags_20, t0.product_custom_label AS product_custom_label_21, t0.product_label_active_days AS product_label_active_days_22, t0.required_configuration AS required_configuration_23, t0.price AS price_24, t0.price_gross AS price_gross_25, t0.msrp AS msrp_26, t0.distri_price AS distri_price_27, t0.stock_item_value AS stock_item_value_28, t0.stock_place AS stock_place_29, t0.product_type AS product_type_30, t0.quantity AS quantity_31, t0.minimum_stock AS minimum_stock_32, t0.minimum_stock_status AS minimum_stock_status_33, t0.mins_last_status AS mins_last_status_34, t0.is_force_mins AS is_force_mins_35, t0.is_ds AS is_ds_36, t0.is_force_ds AS is_force_ds_37, t0.int_stockyard AS int_stockyard_38, t0.vct_stock_quantity AS vct_stock_quantity_39, t0.vct_stock_status AS vct_stock_status_40, t0.expected_delivery_date AS expected_delivery_date_41, t0.seller_item_id AS seller_item_id_42, t0.other_seller_item_id AS other_seller_item_id_43, t0.other_supplier_id AS other_supplier_id_44, t0.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_45, t0.cost_price AS cost_price_46, t0.abroad_base_price AS abroad_base_price_47, t0.base_price AS base_price_48, t0.item_discount AS item_discount_49, t0.purchase_price AS purchase_price_50, t0.supplier_tax_category AS supplier_tax_category_51, t0.publish_date AS publish_date_52, t0.expire_date AS expire_date_53, t0.require_shipping AS require_shipping_54, t0.returnable AS returnable_55, t0.stock_shelf AS stock_shelf_56, t0.shelf_place AS shelf_place_57, t0.package_width AS package_width_58, t0.package_height AS package_height_59, t0.package_depth AS package_depth_60, t0.package_weight AS package_weight_61, t0.related_product AS related_product_62, t0.spare_parts AS spare_parts_63, t0.components AS components_64, t0.up_selling_product AS up_selling_product_65, t0.cross_selling_product AS cross_selling_product_66, t0.attachment AS attachment_67, t0.seo_title AS seo_title_68, t0.seo_description AS seo_description_69, t0.seo_keyword AS seo_keyword_70, t0.seo_url AS seo_url_71, t0.old_seo_url AS old_seo_url_72, t0.show_extra_fields AS show_extra_fields_73, t0.status AS status_74, t0.manual_status AS manual_status_75, t0.is_manual_status AS is_manual_status_76, t0.import AS import_77, t0.display_stock_report AS display_stock_report_78, t0.display_front_status_change AS display_front_status_change_79, t0.deleted AS deleted_80, t0.incomplete_product AS incomplete_product_81, t0.assign_incomplete_product AS assign_incomplete_product_82, t0.incomplete_to_assign_product AS incomplete_to_assign_product_83, t0.incomplete_assign_product_id AS incomplete_assign_product_id_84, t0.sort_order AS sort_order_85, t0.profit AS profit_86, t0.margin AS margin_87, t0.b2b_profit AS b2b_profit_88, t0.b2b_margin AS b2b_margin_89, t0.catalogue_status AS catalogue_status_90, t0.is_unite AS is_unite_91, t0.supplier_cart_id AS supplier_cart_id_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.tax_id AS tax_id_95, t0.stock_indicators_id AS stock_indicators_id_96, t0.return_rule_id AS return_rule_id_97, t0.category_id AS category_id_98, t0.supplier_id AS supplier_id_99, t0.manufacturer_id AS manufacturer_id_100, t0.courier_id AS courier_id_101, t0.sub_shipping_method_id AS sub_shipping_method_id_102, t0.currency_id AS currency_id_103, t0.product_label_id AS product_label_id_104 FROM product t0 WHERE t0.id = ?

Parameters:

[
  13507
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ecp AS ecp_3,
  t0.is_bulky AS is_bulky_4,
  t0.new_name AS new_name_5,
  t0.icp_name AS icp_name_6,
  t0.code AS code_7,
  t0.mpn_code AS mpn_code_8,
  t0.ean_code AS ean_code_9,
  t0.iean_code AS iean_code_10,
  t0.sean_code AS sean_code_11,
  t0.is_iean_print AS is_iean_print_12,
  t0.is_cean_print AS is_cean_print_13,
  t0.is_sean_print AS is_sean_print_14,
  t0.sean AS sean_15,
  t0.org_supplier_id AS org_supplier_id_16,
  t0.is_retail_hold AS is_retail_hold_17,
  t0.description AS description_18,
  t0.type AS type_19,
  t0.tags AS tags_20,
  t0.product_custom_label AS product_custom_label_21,
  t0.product_label_active_days AS product_label_active_days_22,
  t0.required_configuration AS required_configuration_23,
  t0.price AS price_24,
  t0.price_gross AS price_gross_25,
  t0.msrp AS msrp_26,
  t0.distri_price AS distri_price_27,
  t0.stock_item_value AS stock_item_value_28,
  t0.stock_place AS stock_place_29,
  t0.product_type AS product_type_30,
  t0.quantity AS quantity_31,
  t0.minimum_stock AS minimum_stock_32,
  t0.minimum_stock_status AS minimum_stock_status_33,
  t0.mins_last_status AS mins_last_status_34,
  t0.is_force_mins AS is_force_mins_35,
  t0.is_ds AS is_ds_36,
  t0.is_force_ds AS is_force_ds_37,
  t0.int_stockyard AS int_stockyard_38,
  t0.vct_stock_quantity AS vct_stock_quantity_39,
  t0.vct_stock_status AS vct_stock_status_40,
  t0.expected_delivery_date AS expected_delivery_date_41,
  t0.seller_item_id AS seller_item_id_42,
  t0.other_seller_item_id AS other_seller_item_id_43,
  t0.other_supplier_id AS other_supplier_id_44,
  t0.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_45,
  t0.cost_price AS cost_price_46,
  t0.abroad_base_price AS abroad_base_price_47,
  t0.base_price AS base_price_48,
  t0.item_discount AS item_discount_49,
  t0.purchase_price AS purchase_price_50,
  t0.supplier_tax_category AS supplier_tax_category_51,
  t0.publish_date AS publish_date_52,
  t0.expire_date AS expire_date_53,
  t0.require_shipping AS require_shipping_54,
  t0.returnable AS returnable_55,
  t0.stock_shelf AS stock_shelf_56,
  t0.shelf_place AS shelf_place_57,
  t0.package_width AS package_width_58,
  t0.package_height AS package_height_59,
  t0.package_depth AS package_depth_60,
  t0.package_weight AS package_weight_61,
  t0.related_product AS related_product_62,
  t0.spare_parts AS spare_parts_63,
  t0.components AS components_64,
  t0.up_selling_product AS up_selling_product_65,
  t0.cross_selling_product AS cross_selling_product_66,
  t0.attachment AS attachment_67,
  t0.seo_title AS seo_title_68,
  t0.seo_description AS seo_description_69,
  t0.seo_keyword AS seo_keyword_70,
  t0.seo_url AS seo_url_71,
  t0.old_seo_url AS old_seo_url_72,
  t0.show_extra_fields AS show_extra_fields_73,
  t0.status AS status_74,
  t0.manual_status AS manual_status_75,
  t0.is_manual_status AS is_manual_status_76,
  t0.import AS import_77,
  t0.display_stock_report AS display_stock_report_78,
  t0.display_front_status_change AS display_front_status_change_79,
  t0.deleted AS deleted_80,
  t0.incomplete_product AS incomplete_product_81,
  t0.assign_incomplete_product AS assign_incomplete_product_82,
  t0.incomplete_to_assign_product AS incomplete_to_assign_product_83,
  t0.incomplete_assign_product_id AS incomplete_assign_product_id_84,
  t0.sort_order AS sort_order_85,
  t0.profit AS profit_86,
  t0.margin AS margin_87,
  t0.b2b_profit AS b2b_profit_88,
  t0.b2b_margin AS b2b_margin_89,
  t0.catalogue_status AS catalogue_status_90,
  t0.is_unite AS is_unite_91,
  t0.supplier_cart_id AS supplier_cart_id_92,
  t0.created_at AS created_at_93,
  t0.updated_at AS updated_at_94,
  t0.tax_id AS tax_id_95,
  t0.stock_indicators_id AS stock_indicators_id_96,
  t0.return_rule_id AS return_rule_id_97,
  t0.category_id AS category_id_98,
  t0.supplier_id AS supplier_id_99,
  t0.manufacturer_id AS manufacturer_id_100,
  t0.courier_id AS courier_id_101,
  t0.sub_shipping_method_id AS sub_shipping_method_id_102,
  t0.currency_id AS currency_id_103,
  t0.product_label_id AS product_label_id_104
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ecp AS ecp_3, t0.is_bulky AS is_bulky_4, t0.new_name AS new_name_5, t0.icp_name AS icp_name_6, t0.code AS code_7, t0.mpn_code AS mpn_code_8, t0.ean_code AS ean_code_9, t0.iean_code AS iean_code_10, t0.sean_code AS sean_code_11, t0.is_iean_print AS is_iean_print_12, t0.is_cean_print AS is_cean_print_13, t0.is_sean_print AS is_sean_print_14, t0.sean AS sean_15, t0.org_supplier_id AS org_supplier_id_16, t0.is_retail_hold AS is_retail_hold_17, t0.description AS description_18, t0.type AS type_19, t0.tags AS tags_20, t0.product_custom_label AS product_custom_label_21, t0.product_label_active_days AS product_label_active_days_22, t0.required_configuration AS required_configuration_23, t0.price AS price_24, t0.price_gross AS price_gross_25, t0.msrp AS msrp_26, t0.distri_price AS distri_price_27, t0.stock_item_value AS stock_item_value_28, t0.stock_place AS stock_place_29, t0.product_type AS product_type_30, t0.quantity AS quantity_31, t0.minimum_stock AS minimum_stock_32, t0.minimum_stock_status AS minimum_stock_status_33, t0.mins_last_status AS mins_last_status_34, t0.is_force_mins AS is_force_mins_35, t0.is_ds AS is_ds_36, t0.is_force_ds AS is_force_ds_37, t0.int_stockyard AS int_stockyard_38, t0.vct_stock_quantity AS vct_stock_quantity_39, t0.vct_stock_status AS vct_stock_status_40, t0.expected_delivery_date AS expected_delivery_date_41, t0.seller_item_id AS seller_item_id_42, t0.other_seller_item_id AS other_seller_item_id_43, t0.other_supplier_id AS other_supplier_id_44, t0.manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_45, t0.cost_price AS cost_price_46, t0.abroad_base_price AS abroad_base_price_47, t0.base_price AS base_price_48, t0.item_discount AS item_discount_49, t0.purchase_price AS purchase_price_50, t0.supplier_tax_category AS supplier_tax_category_51, t0.publish_date AS publish_date_52, t0.expire_date AS expire_date_53, t0.require_shipping AS require_shipping_54, t0.returnable AS returnable_55, t0.stock_shelf AS stock_shelf_56, t0.shelf_place AS shelf_place_57, t0.package_width AS package_width_58, t0.package_height AS package_height_59, t0.package_depth AS package_depth_60, t0.package_weight AS package_weight_61, t0.related_product AS related_product_62, t0.spare_parts AS spare_parts_63, t0.components AS components_64, t0.up_selling_product AS up_selling_product_65, t0.cross_selling_product AS cross_selling_product_66, t0.attachment AS attachment_67, t0.seo_title AS seo_title_68, t0.seo_description AS seo_description_69, t0.seo_keyword AS seo_keyword_70, t0.seo_url AS seo_url_71, t0.old_seo_url AS old_seo_url_72, t0.show_extra_fields AS show_extra_fields_73, t0.status AS status_74, t0.manual_status AS manual_status_75, t0.is_manual_status AS is_manual_status_76, t0.import AS import_77, t0.display_stock_report AS display_stock_report_78, t0.display_front_status_change AS display_front_status_change_79, t0.deleted AS deleted_80, t0.incomplete_product AS incomplete_product_81, t0.assign_incomplete_product AS assign_incomplete_product_82, t0.incomplete_to_assign_product AS incomplete_to_assign_product_83, t0.incomplete_assign_product_id AS incomplete_assign_product_id_84, t0.sort_order AS sort_order_85, t0.profit AS profit_86, t0.margin AS margin_87, t0.b2b_profit AS b2b_profit_88, t0.b2b_margin AS b2b_margin_89, t0.catalogue_status AS catalogue_status_90, t0.is_unite AS is_unite_91, t0.supplier_cart_id AS supplier_cart_id_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.tax_id AS tax_id_95, t0.stock_indicators_id AS stock_indicators_id_96, t0.return_rule_id AS return_rule_id_97, t0.category_id AS category_id_98, t0.supplier_id AS supplier_id_99, t0.manufacturer_id AS manufacturer_id_100, t0.courier_id AS courier_id_101, t0.sub_shipping_method_id AS sub_shipping_method_id_102, t0.currency_id AS currency_id_103, t0.product_label_id AS product_label_id_104 FROM product t0 WHERE t0.id = 13507;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Product::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Product->__get (line 184)
7	App\Entity\Product->getIsBulky (line 422)
8	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 50)
9	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 143)

0.22 ms
(1.49%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortcut_name AS shortcut_name_3, t0.legal_name AS legal_name_4, t0.street AS street_5, t0.zipcode AS zipcode_6, t0.supplier_location AS supplier_location_7, t0.country AS country_8, t0.email1 AS email1_9, t0.email1_for AS email1_for_10, t0.email2 AS email2_11, t0.email2_for AS email2_for_12, t0.phone1 AS phone1_13, t0.phone1_for AS phone1_for_14, t0.phone2 AS phone2_15, t0.phone2_for AS phone2_for_16, t0.dataimport AS dataimport_17, t0.veloconnect AS veloconnect_18, t0.veloconnect_url AS veloconnect_url_19, t0.veloconnect_username AS veloconnect_username_20, t0.veloconnect_password AS veloconnect_password_21, t0.is_ds AS is_ds_22, t0.ext_available AS ext_available_23, t0.ext_nonavailable AS ext_nonavailable_24, t0.vct_available AS vct_available_25, t0.vct_nonavailable AS vct_nonavailable_26, t0.location AS location_27, t0.shipping_cost AS shipping_cost_28, t0.free_shipping_from AS free_shipping_from_29, t0.cash_discount AS cash_discount_30, t0.packing_fee AS packing_fee_31, t0.hek_markup AS hek_markup_32, t0.days AS days_33, t0.custom_clearance AS custom_clearance_34, t0.custom_duties AS custom_duties_35, t0.allow_automatic AS allow_automatic_36, t0.excution_time AS excution_time_37, t0.excution_days AS excution_days_38, t0.dropshipping AS dropshipping_39, t0.sa_delivery AS sa_delivery_40, t0.no_fallback AS no_fallback_41, t0.value_under AS value_under_42, t0.co_disallow AS co_disallow_43, t0.co_disallow_swell AS co_disallow_swell_44, t0.is_return AS is_return_45, t0.return_timeframe AS return_timeframe_46, t0.is_order_id_obli AS is_order_id_obli_47, t0.is_invoice_id_obli AS is_invoice_id_obli_48, t0.is_delivery_id_obli AS is_delivery_id_obli_49, t0.custom_order_file AS custom_order_file_50, t0.headerline AS headerline_51, t0.headerline_value AS headerline_value_52, t0.file_format AS file_format_53, t0.column_separation AS column_separation_54, t0.ds_fee AS ds_fee_55, t0.basic_ds_swell AS basic_ds_swell_56, t0.fields AS fields_57, t0.quantity_fields AS quantity_fields_58, t0.optional_fields AS optional_fields_59, t0.import_products AS import_products_60, t0.import_quantity AS import_quantity_61, t0.import_images AS import_images_62, t0.bridge_type AS bridge_type_63, t0.ftp_host AS ftp_host_64, t0.ftp_username AS ftp_username_65, t0.ftp_password AS ftp_password_66, t0.ftp_filepath AS ftp_filepath_67, t0.ftp_quantity_filepath AS ftp_quantity_filepath_68, t0.ftp_filename AS ftp_filename_69, t0.web_url AS web_url_70, t0.web_quantity_url AS web_quantity_url_71, t0.authentication AS authentication_72, t0.web_username AS web_username_73, t0.web_password AS web_password_74, t0.xml_url AS xml_url_75, t0.xml_username AS xml_username_76, t0.xml_password AS xml_password_77, t0.last_order AS last_order_78, t0.created_at AS created_at_79, t0.updated_at AS updated_at_80, t0.currency_id AS currency_id_81, t0.ds_stock_indicator_id AS ds_stock_indicator_id_82 FROM supplier t0 WHERE t0.id = ?

Parameters:

[
  94
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortcut_name AS shortcut_name_3,
  t0.legal_name AS legal_name_4,
  t0.street AS street_5,
  t0.zipcode AS zipcode_6,
  t0.supplier_location AS supplier_location_7,
  t0.country AS country_8,
  t0.email1 AS email1_9,
  t0.email1_for AS email1_for_10,
  t0.email2 AS email2_11,
  t0.email2_for AS email2_for_12,
  t0.phone1 AS phone1_13,
  t0.phone1_for AS phone1_for_14,
  t0.phone2 AS phone2_15,
  t0.phone2_for AS phone2_for_16,
  t0.dataimport AS dataimport_17,
  t0.veloconnect AS veloconnect_18,
  t0.veloconnect_url AS veloconnect_url_19,
  t0.veloconnect_username AS veloconnect_username_20,
  t0.veloconnect_password AS veloconnect_password_21,
  t0.is_ds AS is_ds_22,
  t0.ext_available AS ext_available_23,
  t0.ext_nonavailable AS ext_nonavailable_24,
  t0.vct_available AS vct_available_25,
  t0.vct_nonavailable AS vct_nonavailable_26,
  t0.location AS location_27,
  t0.shipping_cost AS shipping_cost_28,
  t0.free_shipping_from AS free_shipping_from_29,
  t0.cash_discount AS cash_discount_30,
  t0.packing_fee AS packing_fee_31,
  t0.hek_markup AS hek_markup_32,
  t0.days AS days_33,
  t0.custom_clearance AS custom_clearance_34,
  t0.custom_duties AS custom_duties_35,
  t0.allow_automatic AS allow_automatic_36,
  t0.excution_time AS excution_time_37,
  t0.excution_days AS excution_days_38,
  t0.dropshipping AS dropshipping_39,
  t0.sa_delivery AS sa_delivery_40,
  t0.no_fallback AS no_fallback_41,
  t0.value_under AS value_under_42,
  t0.co_disallow AS co_disallow_43,
  t0.co_disallow_swell AS co_disallow_swell_44,
  t0.is_return AS is_return_45,
  t0.return_timeframe AS return_timeframe_46,
  t0.is_order_id_obli AS is_order_id_obli_47,
  t0.is_invoice_id_obli AS is_invoice_id_obli_48,
  t0.is_delivery_id_obli AS is_delivery_id_obli_49,
  t0.custom_order_file AS custom_order_file_50,
  t0.headerline AS headerline_51,
  t0.headerline_value AS headerline_value_52,
  t0.file_format AS file_format_53,
  t0.column_separation AS column_separation_54,
  t0.ds_fee AS ds_fee_55,
  t0.basic_ds_swell AS basic_ds_swell_56,
  t0.fields AS fields_57,
  t0.quantity_fields AS quantity_fields_58,
  t0.optional_fields AS optional_fields_59,
  t0.import_products AS import_products_60,
  t0.import_quantity AS import_quantity_61,
  t0.import_images AS import_images_62,
  t0.bridge_type AS bridge_type_63,
  t0.ftp_host AS ftp_host_64,
  t0.ftp_username AS ftp_username_65,
  t0.ftp_password AS ftp_password_66,
  t0.ftp_filepath AS ftp_filepath_67,
  t0.ftp_quantity_filepath AS ftp_quantity_filepath_68,
  t0.ftp_filename AS ftp_filename_69,
  t0.web_url AS web_url_70,
  t0.web_quantity_url AS web_quantity_url_71,
  t0.authentication AS authentication_72,
  t0.web_username AS web_username_73,
  t0.web_password AS web_password_74,
  t0.xml_url AS xml_url_75,
  t0.xml_username AS xml_username_76,
  t0.xml_password AS xml_password_77,
  t0.last_order AS last_order_78,
  t0.created_at AS created_at_79,
  t0.updated_at AS updated_at_80,
  t0.currency_id AS currency_id_81,
  t0.ds_stock_indicator_id AS ds_stock_indicator_id_82
FROM
  supplier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortcut_name AS shortcut_name_3, t0.legal_name AS legal_name_4, t0.street AS street_5, t0.zipcode AS zipcode_6, t0.supplier_location AS supplier_location_7, t0.country AS country_8, t0.email1 AS email1_9, t0.email1_for AS email1_for_10, t0.email2 AS email2_11, t0.email2_for AS email2_for_12, t0.phone1 AS phone1_13, t0.phone1_for AS phone1_for_14, t0.phone2 AS phone2_15, t0.phone2_for AS phone2_for_16, t0.dataimport AS dataimport_17, t0.veloconnect AS veloconnect_18, t0.veloconnect_url AS veloconnect_url_19, t0.veloconnect_username AS veloconnect_username_20, t0.veloconnect_password AS veloconnect_password_21, t0.is_ds AS is_ds_22, t0.ext_available AS ext_available_23, t0.ext_nonavailable AS ext_nonavailable_24, t0.vct_available AS vct_available_25, t0.vct_nonavailable AS vct_nonavailable_26, t0.location AS location_27, t0.shipping_cost AS shipping_cost_28, t0.free_shipping_from AS free_shipping_from_29, t0.cash_discount AS cash_discount_30, t0.packing_fee AS packing_fee_31, t0.hek_markup AS hek_markup_32, t0.days AS days_33, t0.custom_clearance AS custom_clearance_34, t0.custom_duties AS custom_duties_35, t0.allow_automatic AS allow_automatic_36, t0.excution_time AS excution_time_37, t0.excution_days AS excution_days_38, t0.dropshipping AS dropshipping_39, t0.sa_delivery AS sa_delivery_40, t0.no_fallback AS no_fallback_41, t0.value_under AS value_under_42, t0.co_disallow AS co_disallow_43, t0.co_disallow_swell AS co_disallow_swell_44, t0.is_return AS is_return_45, t0.return_timeframe AS return_timeframe_46, t0.is_order_id_obli AS is_order_id_obli_47, t0.is_invoice_id_obli AS is_invoice_id_obli_48, t0.is_delivery_id_obli AS is_delivery_id_obli_49, t0.custom_order_file AS custom_order_file_50, t0.headerline AS headerline_51, t0.headerline_value AS headerline_value_52, t0.file_format AS file_format_53, t0.column_separation AS column_separation_54, t0.ds_fee AS ds_fee_55, t0.basic_ds_swell AS basic_ds_swell_56, t0.fields AS fields_57, t0.quantity_fields AS quantity_fields_58, t0.optional_fields AS optional_fields_59, t0.import_products AS import_products_60, t0.import_quantity AS import_quantity_61, t0.import_images AS import_images_62, t0.bridge_type AS bridge_type_63, t0.ftp_host AS ftp_host_64, t0.ftp_username AS ftp_username_65, t0.ftp_password AS ftp_password_66, t0.ftp_filepath AS ftp_filepath_67, t0.ftp_quantity_filepath AS ftp_quantity_filepath_68, t0.ftp_filename AS ftp_filename_69, t0.web_url AS web_url_70, t0.web_quantity_url AS web_quantity_url_71, t0.authentication AS authentication_72, t0.web_username AS web_username_73, t0.web_password AS web_password_74, t0.xml_url AS xml_url_75, t0.xml_username AS xml_username_76, t0.xml_password AS xml_password_77, t0.last_order AS last_order_78, t0.created_at AS created_at_79, t0.updated_at AS updated_at_80, t0.currency_id AS currency_id_81, t0.ds_stock_indicator_id AS ds_stock_indicator_id_82 FROM supplier t0 WHERE t0.id = 94;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Supplier::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Supplier->__get (line 184)
7	App\Entity\Supplier->getDataimport (line 410)
8	App\Tool\User\Functions->getProductQuantity (line 4719)
9	App\Controller\User\ProductController->getProductAttributesAction (line 9911)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 143)

0.17 ms
(1.14%)

SELECT s0_.id AS id_0, s0_.store_name AS store_name_1, s0_.store_owner AS store_owner_2, s0_.store_url AS store_url_3, s0_.address AS address_4, s0_.city AS city_5, s0_.zipcode AS zipcode_6, s0_.store_owner_country AS store_owner_country_7, s0_.email AS email_8, s0_.btob_email AS btob_email_9, s0_.sos_fail_email AS sos_fail_email_10, s0_.phone AS phone_11, s0_.fax AS fax_12, s0_.sender_email AS sender_email_13, s0_.sender_name AS sender_name_14, s0_.admin_email AS admin_email_15, s0_.intrum_user_id AS intrum_user_id_16, s0_.intrum_client_id AS intrum_client_id_17, s0_.intrum_password AS intrum_password_18, s0_.intrum_mode AS intrum_mode_19, s0_.barcode_username AS barcode_username_20, s0_.barcode_password AS barcode_password_21, s0_.barcode_franking_license AS barcode_franking_license_22, s0_.seo_title AS seo_title_23, s0_.seo_keywords AS seo_keywords_24, s0_.seo_description AS seo_description_25, s0_.auto_update_currency AS auto_update_currency_26, s0_.current_timezone AS current_timezone_27, s0_.catalog_items_per_page AS catalog_items_per_page_28, s0_.product_extra_fields AS product_extra_fields_29, s0_.admin_items_per_page AS admin_items_per_page_30, s0_.allow_reviews AS allow_reviews_31, s0_.allow_downloads AS allow_downloads_32, s0_.vat_no AS vat_no_33, s0_.exchange_policy AS exchange_policy_34, s0_.shipping_costs_policy AS shipping_costs_policy_35, s0_.deadline_policy AS deadline_policy_36, s0_.return_refund_policy AS return_refund_policy_37, s0_.store_logo AS store_logo_38, s0_.category_image_size AS category_image_size_39, s0_.product_thumb_image_size AS product_thumb_image_size_40, s0_.product_detail_image_size AS product_detail_image_size_41, s0_.product_list_image_size AS product_list_image_size_42, s0_.compare_image_size AS compare_image_size_43, s0_.wishlist_image_size AS wishlist_image_size_44, s0_.cart_image_size AS cart_image_size_45, s0_.use_ssl AS use_ssl_46, s0_.maintenance_mode AS maintenance_mode_47, s0_.status AS status_48, s0_.created_at AS created_at_49, s0_.updated_at AS updated_at_50, s0_.language_id AS language_id_51, s0_.currency_id AS currency_id_52, s0_.weight_id AS weight_id_53, s0_.length_id AS length_id_54, s0_.order_status_id AS order_status_id_55, s0_.complete_order_status_id AS complete_order_status_id_56, s0_.return_status_id AS return_status_id_57 FROM settings s0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.store_name AS store_name_1,
  s0_.store_owner AS store_owner_2,
  s0_.store_url AS store_url_3,
  s0_.address AS address_4,
  s0_.city AS city_5,
  s0_.zipcode AS zipcode_6,
  s0_.store_owner_country AS store_owner_country_7,
  s0_.email AS email_8,
  s0_.btob_email AS btob_email_9,
  s0_.sos_fail_email AS sos_fail_email_10,
  s0_.phone AS phone_11,
  s0_.fax AS fax_12,
  s0_.sender_email AS sender_email_13,
  s0_.sender_name AS sender_name_14,
  s0_.admin_email AS admin_email_15,
  s0_.intrum_user_id AS intrum_user_id_16,
  s0_.intrum_client_id AS intrum_client_id_17,
  s0_.intrum_password AS intrum_password_18,
  s0_.intrum_mode AS intrum_mode_19,
  s0_.barcode_username AS barcode_username_20,
  s0_.barcode_password AS barcode_password_21,
  s0_.barcode_franking_license AS barcode_franking_license_22,
  s0_.seo_title AS seo_title_23,
  s0_.seo_keywords AS seo_keywords_24,
  s0_.seo_description AS seo_description_25,
  s0_.auto_update_currency AS auto_update_currency_26,
  s0_.current_timezone AS current_timezone_27,
  s0_.catalog_items_per_page AS catalog_items_per_page_28,
  s0_.product_extra_fields AS product_extra_fields_29,
  s0_.admin_items_per_page AS admin_items_per_page_30,
  s0_.allow_reviews AS allow_reviews_31,
  s0_.allow_downloads AS allow_downloads_32,
  s0_.vat_no AS vat_no_33,
  s0_.exchange_policy AS exchange_policy_34,
  s0_.shipping_costs_policy AS shipping_costs_policy_35,
  s0_.deadline_policy AS deadline_policy_36,
  s0_.return_refund_policy AS return_refund_policy_37,
  s0_.store_logo AS store_logo_38,
  s0_.category_image_size AS category_image_size_39,
  s0_.product_thumb_image_size AS product_thumb_image_size_40,
  s0_.product_detail_image_size AS product_detail_image_size_41,
  s0_.product_list_image_size AS product_list_image_size_42,
  s0_.compare_image_size AS compare_image_size_43,
  s0_.wishlist_image_size AS wishlist_image_size_44,
  s0_.cart_image_size AS cart_image_size_45,
  s0_.use_ssl AS use_ssl_46,
  s0_.maintenance_mode AS maintenance_mode_47,
  s0_.status AS status_48,
  s0_.created_at AS created_at_49,
  s0_.updated_at AS updated_at_50,
  s0_.language_id AS language_id_51,
  s0_.currency_id AS currency_id_52,
  s0_.weight_id AS weight_id_53,
  s0_.length_id AS length_id_54,
  s0_.order_status_id AS order_status_id_55,
  s0_.complete_order_status_id AS complete_order_status_id_56,
  s0_.return_status_id AS return_status_id_57
FROM
  settings s0_
LIMIT
  1

SELECT s0_.id AS id_0, s0_.store_name AS store_name_1, s0_.store_owner AS store_owner_2, s0_.store_url AS store_url_3, s0_.address AS address_4, s0_.city AS city_5, s0_.zipcode AS zipcode_6, s0_.store_owner_country AS store_owner_country_7, s0_.email AS email_8, s0_.btob_email AS btob_email_9, s0_.sos_fail_email AS sos_fail_email_10, s0_.phone AS phone_11, s0_.fax AS fax_12, s0_.sender_email AS sender_email_13, s0_.sender_name AS sender_name_14, s0_.admin_email AS admin_email_15, s0_.intrum_user_id AS intrum_user_id_16, s0_.intrum_client_id AS intrum_client_id_17, s0_.intrum_password AS intrum_password_18, s0_.intrum_mode AS intrum_mode_19, s0_.barcode_username AS barcode_username_20, s0_.barcode_password AS barcode_password_21, s0_.barcode_franking_license AS barcode_franking_license_22, s0_.seo_title AS seo_title_23, s0_.seo_keywords AS seo_keywords_24, s0_.seo_description AS seo_description_25, s0_.auto_update_currency AS auto_update_currency_26, s0_.current_timezone AS current_timezone_27, s0_.catalog_items_per_page AS catalog_items_per_page_28, s0_.product_extra_fields AS product_extra_fields_29, s0_.admin_items_per_page AS admin_items_per_page_30, s0_.allow_reviews AS allow_reviews_31, s0_.allow_downloads AS allow_downloads_32, s0_.vat_no AS vat_no_33, s0_.exchange_policy AS exchange_policy_34, s0_.shipping_costs_policy AS shipping_costs_policy_35, s0_.deadline_policy AS deadline_policy_36, s0_.return_refund_policy AS return_refund_policy_37, s0_.store_logo AS store_logo_38, s0_.category_image_size AS category_image_size_39, s0_.product_thumb_image_size AS product_thumb_image_size_40, s0_.product_detail_image_size AS product_detail_image_size_41, s0_.product_list_image_size AS product_list_image_size_42, s0_.compare_image_size AS compare_image_size_43, s0_.wishlist_image_size AS wishlist_image_size_44, s0_.cart_image_size AS cart_image_size_45, s0_.use_ssl AS use_ssl_46, s0_.maintenance_mode AS maintenance_mode_47, s0_.status AS status_48, s0_.created_at AS created_at_49, s0_.updated_at AS updated_at_50, s0_.language_id AS language_id_51, s0_.currency_id AS currency_id_52, s0_.weight_id AS weight_id_53, s0_.length_id AS length_id_54, s0_.order_status_id AS order_status_id_55, s0_.complete_order_status_id AS complete_order_status_id_56, s0_.return_status_id AS return_status_id_57 FROM settings s0_ LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Tool\User\Functions->storeSetting (line 84)
7	App\Controller\User\ProductController->getSettings (line 11974)
8	App\Controller\User\ProductController->getProductAttributesAction (line 10016)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	handle (line 143)

0.16 ms
(1.06%)

SELECT t0.id AS id_1, t0.product_option AS product_option_2, t0.filter_navigation AS filter_navigation_3, t0.tech_specification AS tech_specification_4, t0.display_front AS display_front_5, t0.ecp AS ecp_6, t0.product_option_sort_order AS product_option_sort_order_7, t0.tech_specification_sort_order AS tech_specification_sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.product_id AS product_id_11, t0.category_product_characteristic_id AS category_product_characteristic_id_12 FROM product_attribute_options t0 WHERE t0.product_id = ? AND t0.product_option = ? ORDER BY t0.product_option_sort_order ASC

Parameters:

[
  "13507"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_option AS product_option_2,
  t0.filter_navigation AS filter_navigation_3,
  t0.tech_specification AS tech_specification_4,
  t0.display_front AS display_front_5,
  t0.ecp AS ecp_6,
  t0.product_option_sort_order AS product_option_sort_order_7,
  t0.tech_specification_sort_order AS tech_specification_sort_order_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.product_id AS product_id_11,
  t0.category_product_characteristic_id AS category_product_characteristic_id_12
FROM
  product_attribute_options t0
WHERE
  t0.product_id = ?
  AND t0.product_option = ?
ORDER BY
  t0.product_option_sort_order ASC

SELECT t0.id AS id_1, t0.product_option AS product_option_2, t0.filter_navigation AS filter_navigation_3, t0.tech_specification AS tech_specification_4, t0.display_front AS display_front_5, t0.ecp AS ecp_6, t0.product_option_sort_order AS product_option_sort_order_7, t0.tech_specification_sort_order AS tech_specification_sort_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.product_id AS product_id_11, t0.category_product_characteristic_id AS category_product_characteristic_id_12 FROM product_attribute_options t0 WHERE t0.product_id = '13507' AND t0.product_option = 1 ORDER BY t0.product_option_sort_order ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\User\ProductController->getProductAttributesAction (line 9891)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 197)
7	handle (line 143)

0.15 ms
(1.02%)

SELECT t0.id AS id_1, t0.ip AS ip_2 FROM customer_ban_ip t0 WHERE t0.ip = ?

Parameters:

[
  "81.221.205.224"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2
FROM
  customer_ban_ip t0
WHERE
  t0.ip = ?

SELECT t0.id AS id_1, t0.ip AS ip_2 FROM customer_ban_ip t0 WHERE t0.ip = '81.221.205.224';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\EventListener\User\BeforeControllerListener->onKernelController (line 103)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 169)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 143)

0.15 ms
(1.02%)

SELECT s0_.current_timezone AS current_timezone_0 FROM settings s0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.current_timezone AS current_timezone_0
FROM
  settings s0_
LIMIT
  1

SELECT s0_.current_timezone AS current_timezone_0 FROM settings s0_ LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\EventListener\User\BeforeControllerListener->onKernelController (line 124)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 169)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 197)
14	handle (line 143)

0.15 ms
(0.99%)

SELECT m0_.id AS id_0 FROM product p1_ INNER JOIN manufacturer m0_ ON p1_.manufacturer_id = m0_.id WHERE p1_.id = ? LIMIT 1

Parameters:

[
  "13507"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0
FROM
  product p1_
  INNER JOIN manufacturer m0_ ON p1_.manufacturer_id = m0_.id
WHERE
  p1_.id = ?
LIMIT
  1

SELECT m0_.id AS id_0 FROM product p1_ INNER JOIN manufacturer m0_ ON p1_.manufacturer_id = m0_.id WHERE p1_.id = '13507' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 802)
7	App\Controller\User\ProductController->getProductAttributesAction (line 9889)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	handle (line 143)

0.13 ms
(0.89%)

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.stock_place AS stock_place_3, t0.quantity1 AS quantity1_4, t0.quantity2 AS quantity2_5, t0.lamp AS lamp_6, t0.message AS message_7, t0.tooltip AS tooltip_8, t0.working_days AS working_days_9, t0.buffer_days_setting AS buffer_days_setting_10, t0.buffer_days AS buffer_days_11, t0.product_type AS product_type_12, t0.vct_stock_status AS vct_stock_status_13, t0.no_guarante AS no_guarante_14, t0.detail_link AS detail_link_15, t0.message1 AS message1_16, t0.message2 AS message2_17, t0.default_name AS default_name_18, t0.is_default AS is_default_19, t0.allow_add_to_cart AS allow_add_to_cart_20 FROM stock_indicators t0 WHERE t0.default_name = ? AND t0.is_default = ? LIMIT 1

Parameters:

[
  "backorder_cart_ord"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.stock_place AS stock_place_3,
  t0.quantity1 AS quantity1_4,
  t0.quantity2 AS quantity2_5,
  t0.lamp AS lamp_6,
  t0.message AS message_7,
  t0.tooltip AS tooltip_8,
  t0.working_days AS working_days_9,
  t0.buffer_days_setting AS buffer_days_setting_10,
  t0.buffer_days AS buffer_days_11,
  t0.product_type AS product_type_12,
  t0.vct_stock_status AS vct_stock_status_13,
  t0.no_guarante AS no_guarante_14,
  t0.detail_link AS detail_link_15,
  t0.message1 AS message1_16,
  t0.message2 AS message2_17,
  t0.default_name AS default_name_18,
  t0.is_default AS is_default_19,
  t0.allow_add_to_cart AS allow_add_to_cart_20
FROM
  stock_indicators t0
WHERE
  t0.default_name = ?
  AND t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.stock_place AS stock_place_3, t0.quantity1 AS quantity1_4, t0.quantity2 AS quantity2_5, t0.lamp AS lamp_6, t0.message AS message_7, t0.tooltip AS tooltip_8, t0.working_days AS working_days_9, t0.buffer_days_setting AS buffer_days_setting_10, t0.buffer_days AS buffer_days_11, t0.product_type AS product_type_12, t0.vct_stock_status AS vct_stock_status_13, t0.no_guarante AS no_guarante_14, t0.detail_link AS detail_link_15, t0.message1 AS message1_16, t0.message2 AS message2_17, t0.default_name AS default_name_18, t0.is_default AS is_default_19, t0.allow_add_to_cart AS allow_add_to_cart_20 FROM stock_indicators t0 WHERE t0.default_name = 'backorder_cart_ord' AND t0.is_default = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\StockIndicator\IndicatorHelperService->stockAndStockIndicator (line 162)
4	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 255)
5	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	handle (line 143)

0.12 ms
(0.79%)

SELECT c0_.id AS id_0, c0_.product_id AS product_id_1, c0_.product_attribute_id AS product_attribute_id_2, c0_.category_product_characteristic_id AS category_product_characteristic_id_3, c0_.category_product_characteristic_value_id AS category_product_characteristic_value_id_4 FROM child_product_characteristic_value c0_ WHERE c0_.product_attribute_id IN (1095431, 1095459, 1095515)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.product_id AS product_id_1,
  c0_.product_attribute_id AS product_attribute_id_2,
  c0_.category_product_characteristic_id AS category_product_characteristic_id_3,
  c0_.category_product_characteristic_value_id AS category_product_characteristic_value_id_4
FROM
  child_product_characteristic_value c0_
WHERE
  c0_.product_attribute_id IN (1095431, 1095459, 1095515)

SELECT c0_.id AS id_0, c0_.product_id AS product_id_1, c0_.product_attribute_id AS product_attribute_id_2, c0_.category_product_characteristic_id AS category_product_characteristic_id_3, c0_.category_product_characteristic_value_id AS category_product_characteristic_value_id_4 FROM child_product_characteristic_value c0_ WHERE c0_.product_attribute_id IN (1095431, 1095459, 1095515);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\User\ProductController->getProductAttributesAction (line 9919)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	handle (line 143)

0.12 ms
(0.77%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort AS sort_5, t0.image AS image_6, t0.is_default AS is_default_7, t0.barcode_username AS barcode_username_8, t0.barcode_password AS barcode_password_9, t0.barcode_franking_license AS barcode_franking_license_10, t0.sd_barcode_username AS sd_barcode_username_11, t0.sd_barcode_password AS sd_barcode_password_12, t0.sd_barcode_franking_license AS sd_barcode_franking_license_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM courier t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.status AS status_4,
  t0.sort AS sort_5,
  t0.image AS image_6,
  t0.is_default AS is_default_7,
  t0.barcode_username AS barcode_username_8,
  t0.barcode_password AS barcode_password_9,
  t0.barcode_franking_license AS barcode_franking_license_10,
  t0.sd_barcode_username AS sd_barcode_username_11,
  t0.sd_barcode_password AS sd_barcode_password_12,
  t0.sd_barcode_franking_license AS sd_barcode_franking_license_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  courier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort AS sort_5, t0.image AS image_6, t0.is_default AS is_default_7, t0.barcode_username AS barcode_username_8, t0.barcode_password AS barcode_password_9, t0.barcode_franking_license AS barcode_franking_license_10, t0.sd_barcode_username AS sd_barcode_username_11, t0.sd_barcode_password AS sd_barcode_password_12, t0.sd_barcode_franking_license AS sd_barcode_franking_license_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM courier t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Courier::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Courier->__get (line 184)
7	App\Entity\Courier->getAlias (line 81)
8	App\Service\StockIndicator\StockAndStockIndicatorService->getStockAndStockIndicators (line 79)
9	App\Controller\User\ProductController->getProductAttributesAction (line 10012)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 143)

0.11 ms
(0.76%)

SELECT s0_.id AS id_0, s0_.session_id AS session_id_1, s0_.ip AS ip_2, s0_.price_mode AS price_mode_3, s0_.discount_rate AS discount_rate_4, s0_.price AS price_5, s0_.net_price AS net_price_6, s0_.start_date AS start_date_7, s0_.expire_date AS expire_date_8, s0_.status AS status_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.product_id AS product_id_12, s0_.currency_id AS currency_id_13, s0_.product_attribute_id AS product_attribute_id_14, s0_.tax_id AS tax_id_15 FROM special_price s0_ WHERE s0_.product_id = ? AND s0_.status = 1

Parameters:

[
  "13507"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.session_id AS session_id_1,
  s0_.ip AS ip_2,
  s0_.price_mode AS price_mode_3,
  s0_.discount_rate AS discount_rate_4,
  s0_.price AS price_5,
  s0_.net_price AS net_price_6,
  s0_.start_date AS start_date_7,
  s0_.expire_date AS expire_date_8,
  s0_.status AS status_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.product_id AS product_id_12,
  s0_.currency_id AS currency_id_13,
  s0_.product_attribute_id AS product_attribute_id_14,
  s0_.tax_id AS tax_id_15
FROM
  special_price s0_
WHERE
  s0_.product_id = ?
  AND s0_.status = 1

SELECT s0_.id AS id_0, s0_.session_id AS session_id_1, s0_.ip AS ip_2, s0_.price_mode AS price_mode_3, s0_.discount_rate AS discount_rate_4, s0_.price AS price_5, s0_.net_price AS net_price_6, s0_.start_date AS start_date_7, s0_.expire_date AS expire_date_8, s0_.status AS status_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.product_id AS product_id_12, s0_.currency_id AS currency_id_13, s0_.product_attribute_id AS product_attribute_id_14, s0_.tax_id AS tax_id_15 FROM special_price s0_ WHERE s0_.product_id = '13507' AND s0_.status = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\User\ProductController->getProductAttributesAction (line 9955)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	handle (line 143)

0.11 ms
(0.76%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.value AS value_4, t0.status AS status_5, t0.default_length AS default_length_6 FROM length t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unit AS unit_3,
  t0.value AS value_4,
  t0.status AS status_5,
  t0.default_length AS default_length_6
FROM
  length t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.value AS value_4, t0.status AS status_5, t0.default_length AS default_length_6 FROM length t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Length::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Length->__get (line 184)
7	App\Entity\Length->getUnit (line 54)
8	App\Controller\User\ProductController->getSettings (line 11982)
9	App\Controller\User\ProductController->getProductAttributesAction (line 10016)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 143)

0.10 ms
(0.67%)

SELECT c0_.id AS id_0, c0_.product_id AS product_id_1, c0_.product_attribute_id AS product_attribute_id_2, c0_.category_product_characteristic_id AS category_product_characteristic_id_3, c0_.category_product_characteristic_value_id AS category_product_characteristic_value_id_4 FROM child_product_characteristic_value c0_ WHERE c0_.product_attribute_id IN (1095431, 1095459)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.product_id AS product_id_1,
  c0_.product_attribute_id AS product_attribute_id_2,
  c0_.category_product_characteristic_id AS category_product_characteristic_id_3,
  c0_.category_product_characteristic_value_id AS category_product_characteristic_value_id_4
FROM
  child_product_characteristic_value c0_
WHERE
  c0_.product_attribute_id IN (1095431, 1095459)

SELECT c0_.id AS id_0, c0_.product_id AS product_id_1, c0_.product_attribute_id AS product_attribute_id_2, c0_.category_product_characteristic_id AS category_product_characteristic_id_3, c0_.category_product_characteristic_value_id AS category_product_characteristic_value_id_4 FROM child_product_characteristic_value c0_ WHERE c0_.product_attribute_id IN (1095431, 1095459);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\User\ProductController->getProductAttributesAction (line 9973)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	handle (line 143)

0.10 ms
(0.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.symbol AS symbol_4, t0.position AS position_5, t0.symbol_left AS symbol_left_6, t0.symbol_right AS symbol_right_7, t0.decimal_places AS decimal_places_8, t0.markup AS markup_9, t0.value AS value_10, t0.status AS status_11, t0.default_currency AS default_currency_12 FROM currency t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.symbol AS symbol_4,
  t0.position AS position_5,
  t0.symbol_left AS symbol_left_6,
  t0.symbol_right AS symbol_right_7,
  t0.decimal_places AS decimal_places_8,
  t0.markup AS markup_9,
  t0.value AS value_10,
  t0.status AS status_11,
  t0.default_currency AS default_currency_12
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.symbol AS symbol_4, t0.position AS position_5, t0.symbol_left AS symbol_left_6, t0.symbol_right AS symbol_right_7, t0.decimal_places AS decimal_places_8, t0.markup AS markup_9, t0.value AS value_10, t0.status AS status_11, t0.default_currency AS default_currency_12 FROM currency t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Currency::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Currency->__get (line 184)
7	App\Entity\Currency->getSymbol (line 81)
8	App\Controller\User\ProductController->getSettings (line 11999)
9	App\Controller\User\ProductController->getProductAttributesAction (line 10016)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 143)

0.09 ms
(0.60%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.value AS value_4, t0.status AS status_5, t0.default_weight AS default_weight_6 FROM weight t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unit AS unit_3,
  t0.value AS value_4,
  t0.status AS status_5,
  t0.default_weight AS default_weight_6
FROM
  weight t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.value AS value_4, t0.status AS status_5, t0.default_weight AS default_weight_6 FROM weight t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Weight::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Weight->__get (line 184)
7	App\Entity\Weight->getUnit (line 54)
8	App\Controller\User\ProductController->getSettings (line 11991)
9	App\Controller\User\ProductController->getProductAttributesAction (line 10016)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	handle (line 143)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ShippingMethodSettings	31
App\Entity\ChildProductCharacteristicValue	6
App\Entity\CategoryProductCharacteristicValue	4
App\Entity\ProductCharacteristicValue	4
App\Entity\ProductAttribute	3
App\Entity\ProductAttributeOptions	2
App\Entity\CategoryProductCharacteristic	2
App\Entity\Currency	2
App\Entity\SpecialPrice	2
App\Entity\ProductCharacteristic	2
App\Entity\StockIndicators	2
App\Entity\Product	1
App\Entity\Supplier	1
App\Entity\ReturnRule	1
App\Entity\Taxes	1
App\Entity\Category	1
App\Entity\Manufacturer	1
App\Entity\Courier	1
App\Entity\ShippingMethod	1
App\Entity\OrderTimelines	1
App\Entity\Settings	1
App\Entity\Language	1
App\Entity\Weight	1
App\Entity\Length	1
App\Entity\OrderStatus	1
App\Entity\ReturnStatus	1

Entities Mapping

Class	Mapping errors
App\Entity\CustomerBanIp	No errors.
App\Entity\Settings	No errors.
App\Entity\SpecialPrice	No errors.
App\Entity\Product	The field App\Entity\Product#productAttributes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProductAttribute#product does not contain the required 'inversedBy: "productAttributes"' attribute.
App\Entity\Manufacturer	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\StockIndicators	No errors.
App\Entity\CategoryProductCharacteristic	No errors.
App\Entity\CategoryProductCharacteristicValue	No errors.
App\Entity\Supplier	No errors.
App\Entity\ReturnRule	No errors.
App\Entity\ProductAttributeOptions	No errors.
App\Entity\Currency	No errors.
App\Entity\Taxes	No errors.
App\Entity\ChildProductCharacteristicValue	No errors.
App\Entity\ProductCharacteristicValue	No errors.
App\Entity\ProductCharacteristic	No errors.
App\Entity\Category	No errors.
App\Entity\Courier	No errors.
App\Entity\ShippingMethod	No errors.
App\Entity\ProductLabel	No errors.
App\Entity\ShippingMethodSettings	No errors.
App\Entity\CompanyCalendar	No errors.
App\Entity\OrderTimelines	No errors.
App\Entity\SupplierStock	No errors.
App\Entity\Language	No errors.
App\Entity\Weight	No errors.
App\Entity\Length	No errors.
App\Entity\OrderStatus	No errors.
App\Entity\ReturnStatus	No errors.

Symfony Profiler

POST https://upgrade.mountainbike-parts.ch/get-product-attributes

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping