Symfony Profiler

Query Metrics

85 Database Queries

23 Different statements

48.26 ms Query time

0 Invalid entities

1839 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.66 ms
(30.37%)

SELECT t0.type AS type_1, t0.warranty_years AS warranty_years_2, t0.new AS new_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_category_id AS principal_category_id_7, t0.principal_image_id AS principal_image_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.product_class_id AS product_class_id_10, t0.stock_id AS stock_id_11, t12.sku AS sku_13, t12.quantity AS quantity_14, t12.quantity_unit AS quantity_unit_15, t12.ean_code AS ean_code_16, t12.availability AS availability_17, t12.`condition` AS condition_18, t12.importable AS importable_19, t12.tax_transferable AS tax_transferable_20, t12.sale_count AS sale_count_21, t12.disabled_at AS disabled_at_22, t12.id AS id_23, t12.created_at AS created_at_24, t12.updated_at AS updated_at_25, t12.enabled AS enabled_26, t12.group_id AS group_id_27 FROM product t0 LEFT JOIN stock t12 ON t0.stock_id = t12.id WHERE t0.stock_id = ?

Parameters:

[
  7327
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.type AS type_1,
  t0.warranty_years AS warranty_years_2,
  t0.new AS new_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.principal_category_id AS principal_category_id_7,
  t0.principal_image_id AS principal_image_id_8,
  t0.manufacturer_id AS manufacturer_id_9,
  t0.product_class_id AS product_class_id_10,
  t0.stock_id AS stock_id_11,
  t12.sku AS sku_13,
  t12.quantity AS quantity_14,
  t12.quantity_unit AS quantity_unit_15,
  t12.ean_code AS ean_code_16,
  t12.availability AS availability_17,
  t12.`condition` AS condition_18,
  t12.importable AS importable_19,
  t12.tax_transferable AS tax_transferable_20,
  t12.sale_count AS sale_count_21,
  t12.disabled_at AS disabled_at_22,
  t12.id AS id_23,
  t12.created_at AS created_at_24,
  t12.updated_at AS updated_at_25,
  t12.enabled AS enabled_26,
  t12.group_id AS group_id_27
FROM
  product t0
  LEFT JOIN stock t12 ON t0.stock_id = t12.id
WHERE
  t0.stock_id = ?

SELECT t0.type AS type_1, t0.warranty_years AS warranty_years_2, t0.new AS new_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_category_id AS principal_category_id_7, t0.principal_image_id AS principal_image_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.product_class_id AS product_class_id_10, t0.stock_id AS stock_id_11, t12.sku AS sku_13, t12.quantity AS quantity_14, t12.quantity_unit AS quantity_unit_15, t12.ean_code AS ean_code_16, t12.availability AS availability_17, t12.`condition` AS condition_18, t12.importable AS importable_19, t12.tax_transferable AS tax_transferable_20, t12.sale_count AS sale_count_21, t12.disabled_at AS disabled_at_22, t12.id AS id_23, t12.created_at AS created_at_24, t12.updated_at AS updated_at_25, t12.enabled AS enabled_26, t12.group_id AS group_id_27 FROM product t0 LEFT JOIN stock t12 ON t0.stock_id = t12.id WHERE t0.stock_id = 7327;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2444)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 438)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 170)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1001)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1795)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
11	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
12	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
13	Doctrine\ORM\PersistentCollection->initialize (line 39)
14	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
15	Doctrine\ORM\PersistentCollection->count (line 762)
16	App\Entity\Product->hasVariants (line 788)
17	App\Entity\Product->getQuantity (line 1909)
18	Twig\Extension\CoreExtension::getAttribute (line 314)
19	__TwigTemplate_713f804998f01d3ebe6aba3be151357f->{closure} (line 2106)
20	Twig\Extension\CoreExtension::captureOutput (line 287)
21	__TwigTemplate_713f804998f01d3ebe6aba3be151357f->macro_render_buyable_product (line 77)
22	__TwigTemplate_e896e59a8088230a79320efc1a39aed5->doDisplay (line 402)
23	Twig\Template->yield (line 358)
24	Twig\Template->display (line 373)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 1520)
27	Twig\Extension\CoreExtension::include (line 199)
28	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->block_content (line 446)
29	Twig\Template->yieldBlock (line 428)
30	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->block_body (line 446)
31	Twig\Template->yieldBlock (line 531)
32	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->block_context (line 446)
33	Twig\Template->yieldBlock (line 155)
34	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->doDisplay (line 402)
35	Twig\Template->yield (line 67)
36	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->doDisplay (line 402)
37	Twig\Template->yield (line 54)
38	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->doDisplay (line 402)
39	Twig\Template->yield (line 56)
40	__TwigTemplate_3942a16c5635c0f06a520f931ec7bcda->doDisplay (line 402)
41	Twig\Template->yield (line 358)
42	Twig\Template->display (line 373)
43	Twig\Template->render (line 51)
44	Twig\TemplateWrapper->render (line 333)
45	Twig\Environment->render (line 27)
46	App\Controller\Content\Product->show (line 181)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
49	Symfony\Component\HttpKernel\Kernel->handle (line 35)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
51	require_once (line 5)

10.74 ms
(22.25%)

SELECT m0_.alias AS alias_0, m0_.lft AS lft_1, m0_.rgt AS rgt_2, m0_.lvl AS lvl_3, m0_.root AS root_4, m0_.id AS id_5, c1_.main_template AS main_template_6, c1_.product_template AS product_template_7, c1_.filterable AS filterable_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.slug AS slug_12, c2_.title AS title_13, c2_.h1 AS h1_14, c2_.perex AS perex_15, c2_.description AS description_16, c2_.meta_title AS meta_title_17, c2_.meta_description AS meta_description_18, c2_.meta_keywords AS meta_keywords_19, c2_.locale AS locale_20, c2_.id AS id_21, i3_.name AS name_22, i3_.original_name AS original_name_23, i3_.mime_type AS mime_type_24, i3_.size AS size_25, i3_.width AS width_26, i3_.height AS height_27, i3_.id AS id_28, i3_.created_at AS created_at_29, i3_.updated_at AS updated_at_30, i4_.title AS title_31, i4_.keywords AS keywords_32, i4_.locale AS locale_33, i4_.id AS id_34, m0_.category_id AS category_id_35, m0_.parent_id AS parent_id_36, c1_.principal_image_id AS principal_image_id_37, c2_.translatable_id AS translatable_id_38, i4_.translatable_id AS translatable_id_39 FROM menu_sk m0_ LEFT JOIN category c1_ ON m0_.category_id = c1_.id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale IN (?)) LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN (?)) ORDER BY m0_.lft ASC

Parameters:

[
  "sk"
  "sk"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.alias AS alias_0,
  m0_.lft AS lft_1,
  m0_.rgt AS rgt_2,
  m0_.lvl AS lvl_3,
  m0_.root AS root_4,
  m0_.id AS id_5,
  c1_.main_template AS main_template_6,
  c1_.product_template AS product_template_7,
  c1_.filterable AS filterable_8,
  c1_.id AS id_9,
  c1_.created_at AS created_at_10,
  c1_.updated_at AS updated_at_11,
  c2_.slug AS slug_12,
  c2_.title AS title_13,
  c2_.h1 AS h1_14,
  c2_.perex AS perex_15,
  c2_.description AS description_16,
  c2_.meta_title AS meta_title_17,
  c2_.meta_description AS meta_description_18,
  c2_.meta_keywords AS meta_keywords_19,
  c2_.locale AS locale_20,
  c2_.id AS id_21,
  i3_.name AS name_22,
  i3_.original_name AS original_name_23,
  i3_.mime_type AS mime_type_24,
  i3_.size AS size_25,
  i3_.width AS width_26,
  i3_.height AS height_27,
  i3_.id AS id_28,
  i3_.created_at AS created_at_29,
  i3_.updated_at AS updated_at_30,
  i4_.title AS title_31,
  i4_.keywords AS keywords_32,
  i4_.locale AS locale_33,
  i4_.id AS id_34,
  m0_.category_id AS category_id_35,
  m0_.parent_id AS parent_id_36,
  c1_.principal_image_id AS principal_image_id_37,
  c2_.translatable_id AS translatable_id_38,
  i4_.translatable_id AS translatable_id_39
FROM
  menu_sk m0_
  LEFT JOIN category c1_ ON m0_.category_id = c1_.id
  LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id
  AND (
    c2_.locale IN (?)
  )
  LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id
  LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id
  AND (
    i4_.locale IN (?)
  )
ORDER BY
  m0_.lft ASC

SELECT m0_.alias AS alias_0, m0_.lft AS lft_1, m0_.rgt AS rgt_2, m0_.lvl AS lvl_3, m0_.root AS root_4, m0_.id AS id_5, c1_.main_template AS main_template_6, c1_.product_template AS product_template_7, c1_.filterable AS filterable_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.slug AS slug_12, c2_.title AS title_13, c2_.h1 AS h1_14, c2_.perex AS perex_15, c2_.description AS description_16, c2_.meta_title AS meta_title_17, c2_.meta_description AS meta_description_18, c2_.meta_keywords AS meta_keywords_19, c2_.locale AS locale_20, c2_.id AS id_21, i3_.name AS name_22, i3_.original_name AS original_name_23, i3_.mime_type AS mime_type_24, i3_.size AS size_25, i3_.width AS width_26, i3_.height AS height_27, i3_.id AS id_28, i3_.created_at AS created_at_29, i3_.updated_at AS updated_at_30, i4_.title AS title_31, i4_.keywords AS keywords_32, i4_.locale AS locale_33, i4_.id AS id_34, m0_.category_id AS category_id_35, m0_.parent_id AS parent_id_36, c1_.principal_image_id AS principal_image_id_37, c2_.translatable_id AS translatable_id_38, i4_.translatable_id AS translatable_id_39 FROM menu_sk m0_ LEFT JOIN category c1_ ON m0_.category_id = c1_.id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale IN ('sk')) LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN ('sk')) ORDER BY m0_.lft ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 25)
7	App\Menu\MenuBuilder->createMainMenu (line 39)
8	Knp\Menu\Provider\LazyProvider->get (line 26)
9	Knp\Menu\Provider\ChainProvider->get (line 43)
10	Knp\Menu\Twig\Helper->get (line 27)
11	Knp\Menu\Twig\MenuRuntimeExtension->get (line 77)
12	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->doDisplay (line 402)
13	Twig\Template->yield (line 67)
14	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->doDisplay (line 402)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->doDisplay (line 402)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_3942a16c5635c0f06a520f931ec7bcda->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 27)
24	App\Controller\Content\Product->show (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

4.22 ms
(8.74%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.principal_image_id AS principal_image_id_5, t0.product_id AS product_id_6, t0.stock_id AS stock_id_7, t8.sku AS sku_9, t8.quantity AS quantity_10, t8.quantity_unit AS quantity_unit_11, t8.ean_code AS ean_code_12, t8.availability AS availability_13, t8.`condition` AS condition_14, t8.importable AS importable_15, t8.tax_transferable AS tax_transferable_16, t8.sale_count AS sale_count_17, t8.disabled_at AS disabled_at_18, t8.id AS id_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.enabled AS enabled_22, t8.group_id AS group_id_23 FROM variant t0 LEFT JOIN stock t8 ON t0.stock_id = t8.id WHERE t0.product_id = ? ORDER BY t0.position ASC

Parameters:

[
  954
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.principal_image_id AS principal_image_id_5,
  t0.product_id AS product_id_6,
  t0.stock_id AS stock_id_7,
  t8.sku AS sku_9,
  t8.quantity AS quantity_10,
  t8.quantity_unit AS quantity_unit_11,
  t8.ean_code AS ean_code_12,
  t8.availability AS availability_13,
  t8.`condition` AS condition_14,
  t8.importable AS importable_15,
  t8.tax_transferable AS tax_transferable_16,
  t8.sale_count AS sale_count_17,
  t8.disabled_at AS disabled_at_18,
  t8.id AS id_19,
  t8.created_at AS created_at_20,
  t8.updated_at AS updated_at_21,
  t8.enabled AS enabled_22,
  t8.group_id AS group_id_23
FROM
  variant t0
  LEFT JOIN stock t8 ON t0.stock_id = t8.id
WHERE
  t0.product_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.principal_image_id AS principal_image_id_5, t0.product_id AS product_id_6, t0.stock_id AS stock_id_7, t8.sku AS sku_9, t8.quantity AS quantity_10, t8.quantity_unit AS quantity_unit_11, t8.ean_code AS ean_code_12, t8.availability AS availability_13, t8.`condition` AS condition_14, t8.importable AS importable_15, t8.tax_transferable AS tax_transferable_16, t8.sale_count AS sale_count_17, t8.disabled_at AS disabled_at_18, t8.id AS id_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.enabled AS enabled_22, t8.group_id AS group_id_23 FROM variant t0 LEFT JOIN stock t8 ON t0.stock_id = t8.id WHERE t0.product_id = 954 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 762)
9	App\Entity\Product->hasVariants (line 788)
10	App\Entity\Product->getQuantity (line 1909)
11	Twig\Extension\CoreExtension::getAttribute (line 314)
12	__TwigTemplate_713f804998f01d3ebe6aba3be151357f->{closure} (line 2106)
13	Twig\Extension\CoreExtension::captureOutput (line 287)
14	__TwigTemplate_713f804998f01d3ebe6aba3be151357f->macro_render_buyable_product (line 77)
15	__TwigTemplate_e896e59a8088230a79320efc1a39aed5->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 1520)
20	Twig\Extension\CoreExtension::include (line 199)
21	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->block_content (line 446)
22	Twig\Template->yieldBlock (line 428)
23	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->block_body (line 446)
24	Twig\Template->yieldBlock (line 531)
25	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->block_context (line 446)
26	Twig\Template->yieldBlock (line 155)
27	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->doDisplay (line 402)
28	Twig\Template->yield (line 67)
29	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->doDisplay (line 402)
30	Twig\Template->yield (line 54)
31	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->doDisplay (line 402)
32	Twig\Template->yield (line 56)
33	__TwigTemplate_3942a16c5635c0f06a520f931ec7bcda->doDisplay (line 402)
34	Twig\Template->yield (line 358)
35	Twig\Template->display (line 373)
36	Twig\Template->render (line 51)
37	Twig\TemplateWrapper->render (line 333)
38	Twig\Environment->render (line 27)
39	App\Controller\Content\Product->show (line 181)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 5)

3.23 ms
(6.70%)

SELECT RAND() AS sclr_0, p0_.type AS type_1, p0_.warranty_years AS warranty_years_2, p0_.new AS new_3, p0_.id AS id_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, s1_.sku AS sku_7, s1_.quantity AS quantity_8, s1_.quantity_unit AS quantity_unit_9, s1_.ean_code AS ean_code_10, s1_.availability AS availability_11, s1_.`condition` AS condition_12, s1_.importable AS importable_13, s1_.tax_transferable AS tax_transferable_14, s1_.sale_count AS sale_count_15, s1_.disabled_at AS disabled_at_16, s1_.id AS id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s1_.enabled AS enabled_20, v2_.id AS id_21, v2_.position AS position_22, v2_.created_at AS created_at_23, v2_.updated_at AS updated_at_24, s3_.amount AS amount_25, s3_.tax_amount AS tax_amount_26, s3_.previous_amount AS previous_amount_27, s3_.previous_tax_amount AS previous_tax_amount_28, s3_.id AS id_29, s3_.created_at AS created_at_30, s3_.updated_at AS updated_at_31, t4_.rate AS rate_32, t4_.`precision` AS precision_33, t4_.id AS id_34, p5_.title AS title_35, p5_.h1 AS h1_36, p5_.perex AS perex_37, p5_.description AS description_38, p5_.text AS text_39, p5_.meta_title AS meta_title_40, p5_.meta_description AS meta_description_41, p5_.meta_keywords AS meta_keywords_42, p5_.slug AS slug_43, p5_.locale AS locale_44, p5_.id AS id_45, i6_.name AS name_46, i6_.original_name AS original_name_47, i6_.mime_type AS mime_type_48, i6_.size AS size_49, i6_.width AS width_50, i6_.height AS height_51, i6_.id AS id_52, i6_.created_at AS created_at_53, i6_.updated_at AS updated_at_54, i7_.title AS title_55, i7_.keywords AS keywords_56, i7_.locale AS locale_57, i7_.id AS id_58, p0_.principal_category_id AS principal_category_id_59, p0_.principal_image_id AS principal_image_id_60, p0_.manufacturer_id AS manufacturer_id_61, p0_.product_class_id AS product_class_id_62, p0_.stock_id AS stock_id_63, s1_.group_id AS group_id_64, v2_.principal_image_id AS principal_image_id_65, v2_.product_id AS product_id_66, v2_.stock_id AS stock_id_67, s3_.stock_id AS stock_id_68, s3_.store_id AS store_id_69, s3_.user_id AS user_id_70, s3_.tax_rate_id AS tax_rate_id_71, s3_.previous_tax_rate_id AS previous_tax_rate_id_72, t4_.store_id AS store_id_73, p5_.translatable_id AS translatable_id_74, i7_.translatable_id AS translatable_id_75 FROM product p0_ INNER JOIN stock s1_ ON p0_.stock_id = s1_.id LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id AND (s3_.store_id = ?) INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id AND (p5_.locale IN (?)) LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id AND (i7_.locale IN (?)) INNER JOIN product_category p8_ ON p0_.id = p8_.product_id INNER JOIN category c9_ ON p8_.category_id = c9_.id INNER JOIN recommended_category_category r11_ ON c9_.id = r11_.category_id INNER JOIN category c10_ ON c10_.id = r11_.recommended_id AND (c10_.id IN (?)) WHERE s1_.enabled = 1 AND p0_.id NOT IN (?) GROUP BY s1_.id ORDER BY sclr_0 ASC LIMIT 12

Parameters:

[
  1
  "sk"
  "sk"
  128
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  RAND() AS sclr_0,
  p0_.type AS type_1,
  p0_.warranty_years AS warranty_years_2,
  p0_.new AS new_3,
  p0_.id AS id_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6,
  s1_.sku AS sku_7,
  s1_.quantity AS quantity_8,
  s1_.quantity_unit AS quantity_unit_9,
  s1_.ean_code AS ean_code_10,
  s1_.availability AS availability_11,
  s1_.`condition` AS condition_12,
  s1_.importable AS importable_13,
  s1_.tax_transferable AS tax_transferable_14,
  s1_.sale_count AS sale_count_15,
  s1_.disabled_at AS disabled_at_16,
  s1_.id AS id_17,
  s1_.created_at AS created_at_18,
  s1_.updated_at AS updated_at_19,
  s1_.enabled AS enabled_20,
  v2_.id AS id_21,
  v2_.position AS position_22,
  v2_.created_at AS created_at_23,
  v2_.updated_at AS updated_at_24,
  s3_.amount AS amount_25,
  s3_.tax_amount AS tax_amount_26,
  s3_.previous_amount AS previous_amount_27,
  s3_.previous_tax_amount AS previous_tax_amount_28,
  s3_.id AS id_29,
  s3_.created_at AS created_at_30,
  s3_.updated_at AS updated_at_31,
  t4_.rate AS rate_32,
  t4_.`precision` AS precision_33,
  t4_.id AS id_34,
  p5_.title AS title_35,
  p5_.h1 AS h1_36,
  p5_.perex AS perex_37,
  p5_.description AS description_38,
  p5_.text AS text_39,
  p5_.meta_title AS meta_title_40,
  p5_.meta_description AS meta_description_41,
  p5_.meta_keywords AS meta_keywords_42,
  p5_.slug AS slug_43,
  p5_.locale AS locale_44,
  p5_.id AS id_45,
  i6_.name AS name_46,
  i6_.original_name AS original_name_47,
  i6_.mime_type AS mime_type_48,
  i6_.size AS size_49,
  i6_.width AS width_50,
  i6_.height AS height_51,
  i6_.id AS id_52,
  i6_.created_at AS created_at_53,
  i6_.updated_at AS updated_at_54,
  i7_.title AS title_55,
  i7_.keywords AS keywords_56,
  i7_.locale AS locale_57,
  i7_.id AS id_58,
  p0_.principal_category_id AS principal_category_id_59,
  p0_.principal_image_id AS principal_image_id_60,
  p0_.manufacturer_id AS manufacturer_id_61,
  p0_.product_class_id AS product_class_id_62,
  p0_.stock_id AS stock_id_63,
  s1_.group_id AS group_id_64,
  v2_.principal_image_id AS principal_image_id_65,
  v2_.product_id AS product_id_66,
  v2_.stock_id AS stock_id_67,
  s3_.stock_id AS stock_id_68,
  s3_.store_id AS store_id_69,
  s3_.user_id AS user_id_70,
  s3_.tax_rate_id AS tax_rate_id_71,
  s3_.previous_tax_rate_id AS previous_tax_rate_id_72,
  t4_.store_id AS store_id_73,
  p5_.translatable_id AS translatable_id_74,
  i7_.translatable_id AS translatable_id_75
FROM
  product p0_
  INNER JOIN stock s1_ ON p0_.stock_id = s1_.id
  LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id
  INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id
  AND (s3_.store_id = ?)
  INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id
  INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id
  AND (
    p5_.locale IN (?)
  )
  LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id
  LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id
  AND (
    i7_.locale IN (?)
  )
  INNER JOIN product_category p8_ ON p0_.id = p8_.product_id
  INNER JOIN category c9_ ON p8_.category_id = c9_.id
  INNER JOIN recommended_category_category r11_ ON c9_.id = r11_.category_id
  INNER JOIN category c10_ ON c10_.id = r11_.recommended_id
  AND (
    c10_.id IN (?)
  )
WHERE
  s1_.enabled = 1
  AND p0_.id NOT IN (?)
GROUP BY
  s1_.id
ORDER BY
  sclr_0 ASC
LIMIT
  12

SELECT RAND() AS sclr_0, p0_.type AS type_1, p0_.warranty_years AS warranty_years_2, p0_.new AS new_3, p0_.id AS id_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, s1_.sku AS sku_7, s1_.quantity AS quantity_8, s1_.quantity_unit AS quantity_unit_9, s1_.ean_code AS ean_code_10, s1_.availability AS availability_11, s1_.`condition` AS condition_12, s1_.importable AS importable_13, s1_.tax_transferable AS tax_transferable_14, s1_.sale_count AS sale_count_15, s1_.disabled_at AS disabled_at_16, s1_.id AS id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s1_.enabled AS enabled_20, v2_.id AS id_21, v2_.position AS position_22, v2_.created_at AS created_at_23, v2_.updated_at AS updated_at_24, s3_.amount AS amount_25, s3_.tax_amount AS tax_amount_26, s3_.previous_amount AS previous_amount_27, s3_.previous_tax_amount AS previous_tax_amount_28, s3_.id AS id_29, s3_.created_at AS created_at_30, s3_.updated_at AS updated_at_31, t4_.rate AS rate_32, t4_.`precision` AS precision_33, t4_.id AS id_34, p5_.title AS title_35, p5_.h1 AS h1_36, p5_.perex AS perex_37, p5_.description AS description_38, p5_.text AS text_39, p5_.meta_title AS meta_title_40, p5_.meta_description AS meta_description_41, p5_.meta_keywords AS meta_keywords_42, p5_.slug AS slug_43, p5_.locale AS locale_44, p5_.id AS id_45, i6_.name AS name_46, i6_.original_name AS original_name_47, i6_.mime_type AS mime_type_48, i6_.size AS size_49, i6_.width AS width_50, i6_.height AS height_51, i6_.id AS id_52, i6_.created_at AS created_at_53, i6_.updated_at AS updated_at_54, i7_.title AS title_55, i7_.keywords AS keywords_56, i7_.locale AS locale_57, i7_.id AS id_58, p0_.principal_category_id AS principal_category_id_59, p0_.principal_image_id AS principal_image_id_60, p0_.manufacturer_id AS manufacturer_id_61, p0_.product_class_id AS product_class_id_62, p0_.stock_id AS stock_id_63, s1_.group_id AS group_id_64, v2_.principal_image_id AS principal_image_id_65, v2_.product_id AS product_id_66, v2_.stock_id AS stock_id_67, s3_.stock_id AS stock_id_68, s3_.store_id AS store_id_69, s3_.user_id AS user_id_70, s3_.tax_rate_id AS tax_rate_id_71, s3_.previous_tax_rate_id AS previous_tax_rate_id_72, t4_.store_id AS store_id_73, p5_.translatable_id AS translatable_id_74, i7_.translatable_id AS translatable_id_75 FROM product p0_ INNER JOIN stock s1_ ON p0_.stock_id = s1_.id LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id AND (s3_.store_id = 1) INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id AND (p5_.locale IN ('sk')) LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id AND (i7_.locale IN ('sk')) INNER JOIN product_category p8_ ON p0_.id = p8_.product_id INNER JOIN category c9_ ON p8_.category_id = c9_.id INNER JOIN recommended_category_category r11_ ON c9_.id = r11_.category_id INNER JOIN category c10_ ON c10_.id = r11_.recommended_id AND (c10_.id IN (128)) WHERE s1_.enabled = 1 AND p0_.id NOT IN (2867) GROUP BY s1_.id ORDER BY sclr_0 ASC LIMIT 12;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 28)
7	App\Repository\QueryBuilder\AbstractQueryBuilder->find (line 109)
8	App\Provider\RecommendedProductsProvider->getRecommendationsForCategories (line 49)
9	App\Provider\RecommendedProductsProvider->getForProducts (line 26)
10	App\Provider\RecommendedProductsProvider->getForProduct (line 75)
11	App\Extension\Twig\ProductExtension->getRecommendedProducts (line 53)
12	__TwigTemplate_e896e59a8088230a79320efc1a39aed5->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 1520)
17	Twig\Extension\CoreExtension::include (line 199)
18	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->block_content (line 446)
19	Twig\Template->yieldBlock (line 428)
20	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->block_body (line 446)
21	Twig\Template->yieldBlock (line 531)
22	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->block_context (line 446)
23	Twig\Template->yieldBlock (line 155)
24	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->doDisplay (line 402)
25	Twig\Template->yield (line 67)
26	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->doDisplay (line 402)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->doDisplay (line 402)
29	Twig\Template->yield (line 56)
30	__TwigTemplate_3942a16c5635c0f06a520f931ec7bcda->doDisplay (line 402)
31	Twig\Template->yield (line 358)
32	Twig\Template->display (line 373)
33	Twig\Template->render (line 51)
34	Twig\TemplateWrapper->render (line 333)
35	Twig\Environment->render (line 27)
36	App\Controller\Content\Product->show (line 181)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

2.19 ms
(4.54%)

SELECT p0_.id AS id_0, v1_.id AS id_1, v1_.position AS position_2, v1_.created_at AS created_at_3, v1_.updated_at AS updated_at_4, s2_.sku AS sku_5, s2_.quantity AS quantity_6, s2_.quantity_unit AS quantity_unit_7, s2_.ean_code AS ean_code_8, s2_.availability AS availability_9, s2_.`condition` AS condition_10, s2_.importable AS importable_11, s2_.tax_transferable AS tax_transferable_12, s2_.sale_count AS sale_count_13, s2_.disabled_at AS disabled_at_14, s2_.id AS id_15, s2_.created_at AS created_at_16, s2_.updated_at AS updated_at_17, s2_.enabled AS enabled_18, p3_.type AS type_19, p3_.warranty_years AS warranty_years_20, p3_.new AS new_21, p3_.id AS id_22, p3_.created_at AS created_at_23, p3_.updated_at AS updated_at_24, s4_.amount AS amount_25, s4_.tax_amount AS tax_amount_26, s4_.previous_amount AS previous_amount_27, s4_.previous_tax_amount AS previous_tax_amount_28, s4_.id AS id_29, s4_.created_at AS created_at_30, s4_.updated_at AS updated_at_31, v5_.position AS position_32, a6_.id AS id_33, a6_.position AS position_34, a6_.created_at AS created_at_35, a6_.updated_at AS updated_at_36, a7_.title AS title_37, a7_.description AS description_38, a7_.slug AS slug_39, a7_.locale AS locale_40, a7_.id AS id_41, p0_.principal_category_id AS principal_category_id_42, p0_.principal_image_id AS principal_image_id_43, p0_.manufacturer_id AS manufacturer_id_44, p0_.product_class_id AS product_class_id_45, p0_.stock_id AS stock_id_46, v1_.principal_image_id AS principal_image_id_47, v1_.product_id AS product_id_48, v1_.stock_id AS stock_id_49, s2_.group_id AS group_id_50, p3_.principal_category_id AS principal_category_id_51, p3_.principal_image_id AS principal_image_id_52, p3_.manufacturer_id AS manufacturer_id_53, p3_.product_class_id AS product_class_id_54, p3_.stock_id AS stock_id_55, s4_.stock_id AS stock_id_56, s4_.store_id AS store_id_57, s4_.user_id AS user_id_58, s4_.tax_rate_id AS tax_rate_id_59, s4_.previous_tax_rate_id AS previous_tax_rate_id_60, v5_.variant_id AS variant_id_61, v5_.attribute_option_id AS attribute_option_id_62, a6_.attribute_id AS attribute_id_63, a6_.principal_image_id AS principal_image_id_64, a7_.translatable_id AS translatable_id_65 FROM product p0_ LEFT JOIN variant v1_ ON p0_.id = v1_.product_id LEFT JOIN stock s2_ ON v1_.stock_id = s2_.id LEFT JOIN product p3_ ON s2_.id = p3_.stock_id LEFT JOIN stock_price s4_ ON s2_.id = s4_.stock_id LEFT JOIN variant_attribute v5_ ON v1_.id = v5_.variant_id LEFT JOIN attribute_option a6_ ON v5_.attribute_option_id = a6_.id LEFT JOIN attribute_option_translation a7_ ON a6_.id = a7_.translatable_id WHERE p0_.id = ? ORDER BY v1_.position ASC, v5_.position ASC

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  v1_.id AS id_1,
  v1_.position AS position_2,
  v1_.created_at AS created_at_3,
  v1_.updated_at AS updated_at_4,
  s2_.sku AS sku_5,
  s2_.quantity AS quantity_6,
  s2_.quantity_unit AS quantity_unit_7,
  s2_.ean_code AS ean_code_8,
  s2_.availability AS availability_9,
  s2_.`condition` AS condition_10,
  s2_.importable AS importable_11,
  s2_.tax_transferable AS tax_transferable_12,
  s2_.sale_count AS sale_count_13,
  s2_.disabled_at AS disabled_at_14,
  s2_.id AS id_15,
  s2_.created_at AS created_at_16,
  s2_.updated_at AS updated_at_17,
  s2_.enabled AS enabled_18,
  p3_.type AS type_19,
  p3_.warranty_years AS warranty_years_20,
  p3_.new AS new_21,
  p3_.id AS id_22,
  p3_.created_at AS created_at_23,
  p3_.updated_at AS updated_at_24,
  s4_.amount AS amount_25,
  s4_.tax_amount AS tax_amount_26,
  s4_.previous_amount AS previous_amount_27,
  s4_.previous_tax_amount AS previous_tax_amount_28,
  s4_.id AS id_29,
  s4_.created_at AS created_at_30,
  s4_.updated_at AS updated_at_31,
  v5_.position AS position_32,
  a6_.id AS id_33,
  a6_.position AS position_34,
  a6_.created_at AS created_at_35,
  a6_.updated_at AS updated_at_36,
  a7_.title AS title_37,
  a7_.description AS description_38,
  a7_.slug AS slug_39,
  a7_.locale AS locale_40,
  a7_.id AS id_41,
  p0_.principal_category_id AS principal_category_id_42,
  p0_.principal_image_id AS principal_image_id_43,
  p0_.manufacturer_id AS manufacturer_id_44,
  p0_.product_class_id AS product_class_id_45,
  p0_.stock_id AS stock_id_46,
  v1_.principal_image_id AS principal_image_id_47,
  v1_.product_id AS product_id_48,
  v1_.stock_id AS stock_id_49,
  s2_.group_id AS group_id_50,
  p3_.principal_category_id AS principal_category_id_51,
  p3_.principal_image_id AS principal_image_id_52,
  p3_.manufacturer_id AS manufacturer_id_53,
  p3_.product_class_id AS product_class_id_54,
  p3_.stock_id AS stock_id_55,
  s4_.stock_id AS stock_id_56,
  s4_.store_id AS store_id_57,
  s4_.user_id AS user_id_58,
  s4_.tax_rate_id AS tax_rate_id_59,
  s4_.previous_tax_rate_id AS previous_tax_rate_id_60,
  v5_.variant_id AS variant_id_61,
  v5_.attribute_option_id AS attribute_option_id_62,
  a6_.attribute_id AS attribute_id_63,
  a6_.principal_image_id AS principal_image_id_64,
  a7_.translatable_id AS translatable_id_65
FROM
  product p0_
  LEFT JOIN variant v1_ ON p0_.id = v1_.product_id
  LEFT JOIN stock s2_ ON v1_.stock_id = s2_.id
  LEFT JOIN product p3_ ON s2_.id = p3_.stock_id
  LEFT JOIN stock_price s4_ ON s2_.id = s4_.stock_id
  LEFT JOIN variant_attribute v5_ ON v1_.id = v5_.variant_id
  LEFT JOIN attribute_option a6_ ON v5_.attribute_option_id = a6_.id
  LEFT JOIN attribute_option_translation a7_ ON a6_.id = a7_.translatable_id
WHERE
  p0_.id = ?
ORDER BY
  v1_.position ASC,
  v5_.position ASC

SELECT p0_.id AS id_0, v1_.id AS id_1, v1_.position AS position_2, v1_.created_at AS created_at_3, v1_.updated_at AS updated_at_4, s2_.sku AS sku_5, s2_.quantity AS quantity_6, s2_.quantity_unit AS quantity_unit_7, s2_.ean_code AS ean_code_8, s2_.availability AS availability_9, s2_.`condition` AS condition_10, s2_.importable AS importable_11, s2_.tax_transferable AS tax_transferable_12, s2_.sale_count AS sale_count_13, s2_.disabled_at AS disabled_at_14, s2_.id AS id_15, s2_.created_at AS created_at_16, s2_.updated_at AS updated_at_17, s2_.enabled AS enabled_18, p3_.type AS type_19, p3_.warranty_years AS warranty_years_20, p3_.new AS new_21, p3_.id AS id_22, p3_.created_at AS created_at_23, p3_.updated_at AS updated_at_24, s4_.amount AS amount_25, s4_.tax_amount AS tax_amount_26, s4_.previous_amount AS previous_amount_27, s4_.previous_tax_amount AS previous_tax_amount_28, s4_.id AS id_29, s4_.created_at AS created_at_30, s4_.updated_at AS updated_at_31, v5_.position AS position_32, a6_.id AS id_33, a6_.position AS position_34, a6_.created_at AS created_at_35, a6_.updated_at AS updated_at_36, a7_.title AS title_37, a7_.description AS description_38, a7_.slug AS slug_39, a7_.locale AS locale_40, a7_.id AS id_41, p0_.principal_category_id AS principal_category_id_42, p0_.principal_image_id AS principal_image_id_43, p0_.manufacturer_id AS manufacturer_id_44, p0_.product_class_id AS product_class_id_45, p0_.stock_id AS stock_id_46, v1_.principal_image_id AS principal_image_id_47, v1_.product_id AS product_id_48, v1_.stock_id AS stock_id_49, s2_.group_id AS group_id_50, p3_.principal_category_id AS principal_category_id_51, p3_.principal_image_id AS principal_image_id_52, p3_.manufacturer_id AS manufacturer_id_53, p3_.product_class_id AS product_class_id_54, p3_.stock_id AS stock_id_55, s4_.stock_id AS stock_id_56, s4_.store_id AS store_id_57, s4_.user_id AS user_id_58, s4_.tax_rate_id AS tax_rate_id_59, s4_.previous_tax_rate_id AS previous_tax_rate_id_60, v5_.variant_id AS variant_id_61, v5_.attribute_option_id AS attribute_option_id_62, a6_.attribute_id AS attribute_id_63, a6_.principal_image_id AS principal_image_id_64, a7_.translatable_id AS translatable_id_65 FROM product p0_ LEFT JOIN variant v1_ ON p0_.id = v1_.product_id LEFT JOIN stock s2_ ON v1_.stock_id = s2_.id LEFT JOIN product p3_ ON s2_.id = p3_.stock_id LEFT JOIN stock_price s4_ ON s2_.id = s4_.stock_id LEFT JOIN variant_attribute v5_ ON v1_.id = v5_.variant_id LEFT JOIN attribute_option a6_ ON v5_.attribute_option_id = a6_.id LEFT JOIN attribute_option_translation a7_ ON a6_.id = a7_.translatable_id WHERE p0_.id = 2867 ORDER BY v1_.position ASC, v5_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 397)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.53 ms
(3.17%)

SELECT p0_.id AS id_0, p1_.title AS title_1, p1_.h1 AS h1_2, p1_.perex AS perex_3, p1_.description AS description_4, p1_.text AS text_5, p1_.meta_title AS meta_title_6, p1_.meta_description AS meta_description_7, p1_.meta_keywords AS meta_keywords_8, p1_.slug AS slug_9, p1_.locale AS locale_10, p1_.id AS id_11, m2_.name AS name_12, m2_.slug AS slug_13, m2_.displayable AS displayable_14, m2_.id AS id_15, m2_.created_at AS created_at_16, m2_.updated_at AS updated_at_17, s3_.sku AS sku_18, s3_.quantity AS quantity_19, s3_.quantity_unit AS quantity_unit_20, s3_.ean_code AS ean_code_21, s3_.availability AS availability_22, s3_.`condition` AS condition_23, s3_.importable AS importable_24, s3_.tax_transferable AS tax_transferable_25, s3_.sale_count AS sale_count_26, s3_.disabled_at AS disabled_at_27, s3_.id AS id_28, s3_.created_at AS created_at_29, s3_.updated_at AS updated_at_30, s3_.enabled AS enabled_31, v4_.id AS id_32, v4_.position AS position_33, v4_.created_at AS created_at_34, v4_.updated_at AS updated_at_35, s5_.amount AS amount_36, s5_.tax_amount AS tax_amount_37, s5_.previous_amount AS previous_amount_38, s5_.previous_tax_amount AS previous_tax_amount_39, s5_.id AS id_40, s5_.created_at AS created_at_41, s5_.updated_at AS updated_at_42, p6_.id AS id_43, p6_.position AS position_44, p6_.created_at AS created_at_45, p6_.updated_at AS updated_at_46, p6_.enabled AS enabled_47, p7_.slug AS slug_48, p7_.title AS title_49, p7_.h1 AS h1_50, p7_.perex AS perex_51, p7_.description AS description_52, p7_.meta_title AS meta_title_53, p7_.meta_description AS meta_description_54, p7_.meta_keywords AS meta_keywords_55, p7_.locale AS locale_56, p7_.id AS id_57, p0_.principal_category_id AS principal_category_id_58, p0_.principal_image_id AS principal_image_id_59, p0_.manufacturer_id AS manufacturer_id_60, p0_.product_class_id AS product_class_id_61, p0_.stock_id AS stock_id_62, p1_.translatable_id AS translatable_id_63, m2_.principal_image_id AS principal_image_id_64, s3_.group_id AS group_id_65, v4_.principal_image_id AS principal_image_id_66, v4_.product_id AS product_id_67, v4_.stock_id AS stock_id_68, s5_.stock_id AS stock_id_69, s5_.store_id AS store_id_70, s5_.user_id AS user_id_71, s5_.tax_rate_id AS tax_rate_id_72, s5_.previous_tax_rate_id AS previous_tax_rate_id_73, p6_.principal_category_id AS principal_category_id_74, p6_.principal_image_id AS principal_image_id_75, p6_.manufacturer_id AS manufacturer_id_76, p6_.parent_id AS parent_id_77, p7_.translatable_id AS translatable_id_78 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN manufacturer m2_ ON p0_.manufacturer_id = m2_.id LEFT JOIN stock s3_ ON p0_.stock_id = s3_.id LEFT JOIN variant v4_ ON s3_.id = v4_.stock_id LEFT JOIN stock_price s5_ ON s3_.id = s5_.stock_id LEFT JOIN product_class p6_ ON p0_.product_class_id = p6_.id LEFT JOIN product_class_translation p7_ ON p6_.id = p7_.translatable_id WHERE p0_.id = ?

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p1_.title AS title_1,
  p1_.h1 AS h1_2,
  p1_.perex AS perex_3,
  p1_.description AS description_4,
  p1_.text AS text_5,
  p1_.meta_title AS meta_title_6,
  p1_.meta_description AS meta_description_7,
  p1_.meta_keywords AS meta_keywords_8,
  p1_.slug AS slug_9,
  p1_.locale AS locale_10,
  p1_.id AS id_11,
  m2_.name AS name_12,
  m2_.slug AS slug_13,
  m2_.displayable AS displayable_14,
  m2_.id AS id_15,
  m2_.created_at AS created_at_16,
  m2_.updated_at AS updated_at_17,
  s3_.sku AS sku_18,
  s3_.quantity AS quantity_19,
  s3_.quantity_unit AS quantity_unit_20,
  s3_.ean_code AS ean_code_21,
  s3_.availability AS availability_22,
  s3_.`condition` AS condition_23,
  s3_.importable AS importable_24,
  s3_.tax_transferable AS tax_transferable_25,
  s3_.sale_count AS sale_count_26,
  s3_.disabled_at AS disabled_at_27,
  s3_.id AS id_28,
  s3_.created_at AS created_at_29,
  s3_.updated_at AS updated_at_30,
  s3_.enabled AS enabled_31,
  v4_.id AS id_32,
  v4_.position AS position_33,
  v4_.created_at AS created_at_34,
  v4_.updated_at AS updated_at_35,
  s5_.amount AS amount_36,
  s5_.tax_amount AS tax_amount_37,
  s5_.previous_amount AS previous_amount_38,
  s5_.previous_tax_amount AS previous_tax_amount_39,
  s5_.id AS id_40,
  s5_.created_at AS created_at_41,
  s5_.updated_at AS updated_at_42,
  p6_.id AS id_43,
  p6_.position AS position_44,
  p6_.created_at AS created_at_45,
  p6_.updated_at AS updated_at_46,
  p6_.enabled AS enabled_47,
  p7_.slug AS slug_48,
  p7_.title AS title_49,
  p7_.h1 AS h1_50,
  p7_.perex AS perex_51,
  p7_.description AS description_52,
  p7_.meta_title AS meta_title_53,
  p7_.meta_description AS meta_description_54,
  p7_.meta_keywords AS meta_keywords_55,
  p7_.locale AS locale_56,
  p7_.id AS id_57,
  p0_.principal_category_id AS principal_category_id_58,
  p0_.principal_image_id AS principal_image_id_59,
  p0_.manufacturer_id AS manufacturer_id_60,
  p0_.product_class_id AS product_class_id_61,
  p0_.stock_id AS stock_id_62,
  p1_.translatable_id AS translatable_id_63,
  m2_.principal_image_id AS principal_image_id_64,
  s3_.group_id AS group_id_65,
  v4_.principal_image_id AS principal_image_id_66,
  v4_.product_id AS product_id_67,
  v4_.stock_id AS stock_id_68,
  s5_.stock_id AS stock_id_69,
  s5_.store_id AS store_id_70,
  s5_.user_id AS user_id_71,
  s5_.tax_rate_id AS tax_rate_id_72,
  s5_.previous_tax_rate_id AS previous_tax_rate_id_73,
  p6_.principal_category_id AS principal_category_id_74,
  p6_.principal_image_id AS principal_image_id_75,
  p6_.manufacturer_id AS manufacturer_id_76,
  p6_.parent_id AS parent_id_77,
  p7_.translatable_id AS translatable_id_78
FROM
  product p0_
  LEFT JOIN product_translation p1_ ON p0_.id = p1_.translatable_id
  LEFT JOIN manufacturer m2_ ON p0_.manufacturer_id = m2_.id
  LEFT JOIN stock s3_ ON p0_.stock_id = s3_.id
  LEFT JOIN variant v4_ ON s3_.id = v4_.stock_id
  LEFT JOIN stock_price s5_ ON s3_.id = s5_.stock_id
  LEFT JOIN product_class p6_ ON p0_.product_class_id = p6_.id
  LEFT JOIN product_class_translation p7_ ON p6_.id = p7_.translatable_id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p1_.title AS title_1, p1_.h1 AS h1_2, p1_.perex AS perex_3, p1_.description AS description_4, p1_.text AS text_5, p1_.meta_title AS meta_title_6, p1_.meta_description AS meta_description_7, p1_.meta_keywords AS meta_keywords_8, p1_.slug AS slug_9, p1_.locale AS locale_10, p1_.id AS id_11, m2_.name AS name_12, m2_.slug AS slug_13, m2_.displayable AS displayable_14, m2_.id AS id_15, m2_.created_at AS created_at_16, m2_.updated_at AS updated_at_17, s3_.sku AS sku_18, s3_.quantity AS quantity_19, s3_.quantity_unit AS quantity_unit_20, s3_.ean_code AS ean_code_21, s3_.availability AS availability_22, s3_.`condition` AS condition_23, s3_.importable AS importable_24, s3_.tax_transferable AS tax_transferable_25, s3_.sale_count AS sale_count_26, s3_.disabled_at AS disabled_at_27, s3_.id AS id_28, s3_.created_at AS created_at_29, s3_.updated_at AS updated_at_30, s3_.enabled AS enabled_31, v4_.id AS id_32, v4_.position AS position_33, v4_.created_at AS created_at_34, v4_.updated_at AS updated_at_35, s5_.amount AS amount_36, s5_.tax_amount AS tax_amount_37, s5_.previous_amount AS previous_amount_38, s5_.previous_tax_amount AS previous_tax_amount_39, s5_.id AS id_40, s5_.created_at AS created_at_41, s5_.updated_at AS updated_at_42, p6_.id AS id_43, p6_.position AS position_44, p6_.created_at AS created_at_45, p6_.updated_at AS updated_at_46, p6_.enabled AS enabled_47, p7_.slug AS slug_48, p7_.title AS title_49, p7_.h1 AS h1_50, p7_.perex AS perex_51, p7_.description AS description_52, p7_.meta_title AS meta_title_53, p7_.meta_description AS meta_description_54, p7_.meta_keywords AS meta_keywords_55, p7_.locale AS locale_56, p7_.id AS id_57, p0_.principal_category_id AS principal_category_id_58, p0_.principal_image_id AS principal_image_id_59, p0_.manufacturer_id AS manufacturer_id_60, p0_.product_class_id AS product_class_id_61, p0_.stock_id AS stock_id_62, p1_.translatable_id AS translatable_id_63, m2_.principal_image_id AS principal_image_id_64, s3_.group_id AS group_id_65, v4_.principal_image_id AS principal_image_id_66, v4_.product_id AS product_id_67, v4_.stock_id AS stock_id_68, s5_.stock_id AS stock_id_69, s5_.store_id AS store_id_70, s5_.user_id AS user_id_71, s5_.tax_rate_id AS tax_rate_id_72, s5_.previous_tax_rate_id AS previous_tax_rate_id_73, p6_.principal_category_id AS principal_category_id_74, p6_.principal_image_id AS principal_image_id_75, p6_.manufacturer_id AS manufacturer_id_76, p6_.parent_id AS parent_id_77, p7_.translatable_id AS translatable_id_78 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN manufacturer m2_ ON p0_.manufacturer_id = m2_.id LEFT JOIN stock s3_ ON p0_.stock_id = s3_.id LEFT JOIN variant v4_ ON s3_.id = v4_.stock_id LEFT JOIN stock_price s5_ ON s3_.id = s5_.stock_id LEFT JOIN product_class p6_ ON p0_.product_class_id = p6_.id LEFT JOIN product_class_translation p7_ ON p6_.id = p7_.translatable_id WHERE p0_.id = 2867;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 313)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.38 ms
(2.85%)

SELECT p0_.id AS id_0, p1_.`group` AS group_1, p1_.position AS position_2, p2_.type AS type_3, p2_.warranty_years AS warranty_years_4, p2_.new AS new_5, p2_.id AS id_6, p2_.created_at AS created_at_7, p2_.updated_at AS updated_at_8, p3_.title AS title_9, p3_.h1 AS h1_10, p3_.perex AS perex_11, p3_.description AS description_12, p3_.text AS text_13, p3_.meta_title AS meta_title_14, p3_.meta_description AS meta_description_15, p3_.meta_keywords AS meta_keywords_16, p3_.slug AS slug_17, p3_.locale AS locale_18, p3_.id AS id_19, s4_.sku AS sku_20, s4_.quantity AS quantity_21, s4_.quantity_unit AS quantity_unit_22, s4_.ean_code AS ean_code_23, s4_.availability AS availability_24, s4_.`condition` AS condition_25, s4_.importable AS importable_26, s4_.tax_transferable AS tax_transferable_27, s4_.sale_count AS sale_count_28, s4_.disabled_at AS disabled_at_29, s4_.id AS id_30, s4_.created_at AS created_at_31, s4_.updated_at AS updated_at_32, s4_.enabled AS enabled_33, v5_.id AS id_34, v5_.position AS position_35, v5_.created_at AS created_at_36, v5_.updated_at AS updated_at_37, s6_.amount AS amount_38, s6_.tax_amount AS tax_amount_39, s6_.previous_amount AS previous_amount_40, s6_.previous_tax_amount AS previous_tax_amount_41, s6_.id AS id_42, s6_.created_at AS created_at_43, s6_.updated_at AS updated_at_44, p0_.principal_category_id AS principal_category_id_45, p0_.principal_image_id AS principal_image_id_46, p0_.manufacturer_id AS manufacturer_id_47, p0_.product_class_id AS product_class_id_48, p0_.stock_id AS stock_id_49, p1_.parent_id AS parent_id_50, p1_.item_id AS item_id_51, p2_.principal_category_id AS principal_category_id_52, p2_.principal_image_id AS principal_image_id_53, p2_.manufacturer_id AS manufacturer_id_54, p2_.product_class_id AS product_class_id_55, p2_.stock_id AS stock_id_56, p3_.translatable_id AS translatable_id_57, s4_.group_id AS group_id_58, v5_.principal_image_id AS principal_image_id_59, v5_.product_id AS product_id_60, v5_.stock_id AS stock_id_61, s6_.stock_id AS stock_id_62, s6_.store_id AS store_id_63, s6_.user_id AS user_id_64, s6_.tax_rate_id AS tax_rate_id_65, s6_.previous_tax_rate_id AS previous_tax_rate_id_66 FROM product p0_ LEFT JOIN product_accessory p1_ ON p0_.id = p1_.parent_id LEFT JOIN product p2_ ON p1_.item_id = p2_.id LEFT JOIN product_translation p3_ ON p2_.id = p3_.translatable_id LEFT JOIN stock s4_ ON p2_.stock_id = s4_.id LEFT JOIN variant v5_ ON s4_.id = v5_.stock_id LEFT JOIN stock_price s6_ ON s4_.id = s6_.stock_id WHERE p0_.id = ? ORDER BY p1_.position ASC

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p1_.`group` AS group_1,
  p1_.position AS position_2,
  p2_.type AS type_3,
  p2_.warranty_years AS warranty_years_4,
  p2_.new AS new_5,
  p2_.id AS id_6,
  p2_.created_at AS created_at_7,
  p2_.updated_at AS updated_at_8,
  p3_.title AS title_9,
  p3_.h1 AS h1_10,
  p3_.perex AS perex_11,
  p3_.description AS description_12,
  p3_.text AS text_13,
  p3_.meta_title AS meta_title_14,
  p3_.meta_description AS meta_description_15,
  p3_.meta_keywords AS meta_keywords_16,
  p3_.slug AS slug_17,
  p3_.locale AS locale_18,
  p3_.id AS id_19,
  s4_.sku AS sku_20,
  s4_.quantity AS quantity_21,
  s4_.quantity_unit AS quantity_unit_22,
  s4_.ean_code AS ean_code_23,
  s4_.availability AS availability_24,
  s4_.`condition` AS condition_25,
  s4_.importable AS importable_26,
  s4_.tax_transferable AS tax_transferable_27,
  s4_.sale_count AS sale_count_28,
  s4_.disabled_at AS disabled_at_29,
  s4_.id AS id_30,
  s4_.created_at AS created_at_31,
  s4_.updated_at AS updated_at_32,
  s4_.enabled AS enabled_33,
  v5_.id AS id_34,
  v5_.position AS position_35,
  v5_.created_at AS created_at_36,
  v5_.updated_at AS updated_at_37,
  s6_.amount AS amount_38,
  s6_.tax_amount AS tax_amount_39,
  s6_.previous_amount AS previous_amount_40,
  s6_.previous_tax_amount AS previous_tax_amount_41,
  s6_.id AS id_42,
  s6_.created_at AS created_at_43,
  s6_.updated_at AS updated_at_44,
  p0_.principal_category_id AS principal_category_id_45,
  p0_.principal_image_id AS principal_image_id_46,
  p0_.manufacturer_id AS manufacturer_id_47,
  p0_.product_class_id AS product_class_id_48,
  p0_.stock_id AS stock_id_49,
  p1_.parent_id AS parent_id_50,
  p1_.item_id AS item_id_51,
  p2_.principal_category_id AS principal_category_id_52,
  p2_.principal_image_id AS principal_image_id_53,
  p2_.manufacturer_id AS manufacturer_id_54,
  p2_.product_class_id AS product_class_id_55,
  p2_.stock_id AS stock_id_56,
  p3_.translatable_id AS translatable_id_57,
  s4_.group_id AS group_id_58,
  v5_.principal_image_id AS principal_image_id_59,
  v5_.product_id AS product_id_60,
  v5_.stock_id AS stock_id_61,
  s6_.stock_id AS stock_id_62,
  s6_.store_id AS store_id_63,
  s6_.user_id AS user_id_64,
  s6_.tax_rate_id AS tax_rate_id_65,
  s6_.previous_tax_rate_id AS previous_tax_rate_id_66
FROM
  product p0_
  LEFT JOIN product_accessory p1_ ON p0_.id = p1_.parent_id
  LEFT JOIN product p2_ ON p1_.item_id = p2_.id
  LEFT JOIN product_translation p3_ ON p2_.id = p3_.translatable_id
  LEFT JOIN stock s4_ ON p2_.stock_id = s4_.id
  LEFT JOIN variant v5_ ON s4_.id = v5_.stock_id
  LEFT JOIN stock_price s6_ ON s4_.id = s6_.stock_id
WHERE
  p0_.id = ?
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p1_.`group` AS group_1, p1_.position AS position_2, p2_.type AS type_3, p2_.warranty_years AS warranty_years_4, p2_.new AS new_5, p2_.id AS id_6, p2_.created_at AS created_at_7, p2_.updated_at AS updated_at_8, p3_.title AS title_9, p3_.h1 AS h1_10, p3_.perex AS perex_11, p3_.description AS description_12, p3_.text AS text_13, p3_.meta_title AS meta_title_14, p3_.meta_description AS meta_description_15, p3_.meta_keywords AS meta_keywords_16, p3_.slug AS slug_17, p3_.locale AS locale_18, p3_.id AS id_19, s4_.sku AS sku_20, s4_.quantity AS quantity_21, s4_.quantity_unit AS quantity_unit_22, s4_.ean_code AS ean_code_23, s4_.availability AS availability_24, s4_.`condition` AS condition_25, s4_.importable AS importable_26, s4_.tax_transferable AS tax_transferable_27, s4_.sale_count AS sale_count_28, s4_.disabled_at AS disabled_at_29, s4_.id AS id_30, s4_.created_at AS created_at_31, s4_.updated_at AS updated_at_32, s4_.enabled AS enabled_33, v5_.id AS id_34, v5_.position AS position_35, v5_.created_at AS created_at_36, v5_.updated_at AS updated_at_37, s6_.amount AS amount_38, s6_.tax_amount AS tax_amount_39, s6_.previous_amount AS previous_amount_40, s6_.previous_tax_amount AS previous_tax_amount_41, s6_.id AS id_42, s6_.created_at AS created_at_43, s6_.updated_at AS updated_at_44, p0_.principal_category_id AS principal_category_id_45, p0_.principal_image_id AS principal_image_id_46, p0_.manufacturer_id AS manufacturer_id_47, p0_.product_class_id AS product_class_id_48, p0_.stock_id AS stock_id_49, p1_.parent_id AS parent_id_50, p1_.item_id AS item_id_51, p2_.principal_category_id AS principal_category_id_52, p2_.principal_image_id AS principal_image_id_53, p2_.manufacturer_id AS manufacturer_id_54, p2_.product_class_id AS product_class_id_55, p2_.stock_id AS stock_id_56, p3_.translatable_id AS translatable_id_57, s4_.group_id AS group_id_58, v5_.principal_image_id AS principal_image_id_59, v5_.product_id AS product_id_60, v5_.stock_id AS stock_id_61, s6_.stock_id AS stock_id_62, s6_.store_id AS store_id_63, s6_.user_id AS user_id_64, s6_.tax_rate_id AS tax_rate_id_65, s6_.previous_tax_rate_id AS previous_tax_rate_id_66 FROM product p0_ LEFT JOIN product_accessory p1_ ON p0_.id = p1_.parent_id LEFT JOIN product p2_ ON p1_.item_id = p2_.id LEFT JOIN product_translation p3_ ON p2_.id = p3_.translatable_id LEFT JOIN stock s4_ ON p2_.stock_id = s4_.id LEFT JOIN variant v5_ ON s4_.id = v5_.stock_id LEFT JOIN stock_price s6_ ON s4_.id = s6_.stock_id WHERE p0_.id = 2867 ORDER BY p1_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 328)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.37 ms
(2.84%)

SELECT RAND() AS sclr_0, p0_.type AS type_1, p0_.warranty_years AS warranty_years_2, p0_.new AS new_3, p0_.id AS id_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, s1_.sku AS sku_7, s1_.quantity AS quantity_8, s1_.quantity_unit AS quantity_unit_9, s1_.ean_code AS ean_code_10, s1_.availability AS availability_11, s1_.`condition` AS condition_12, s1_.importable AS importable_13, s1_.tax_transferable AS tax_transferable_14, s1_.sale_count AS sale_count_15, s1_.disabled_at AS disabled_at_16, s1_.id AS id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s1_.enabled AS enabled_20, v2_.id AS id_21, v2_.position AS position_22, v2_.created_at AS created_at_23, v2_.updated_at AS updated_at_24, s3_.amount AS amount_25, s3_.tax_amount AS tax_amount_26, s3_.previous_amount AS previous_amount_27, s3_.previous_tax_amount AS previous_tax_amount_28, s3_.id AS id_29, s3_.created_at AS created_at_30, s3_.updated_at AS updated_at_31, t4_.rate AS rate_32, t4_.`precision` AS precision_33, t4_.id AS id_34, p5_.title AS title_35, p5_.h1 AS h1_36, p5_.perex AS perex_37, p5_.description AS description_38, p5_.text AS text_39, p5_.meta_title AS meta_title_40, p5_.meta_description AS meta_description_41, p5_.meta_keywords AS meta_keywords_42, p5_.slug AS slug_43, p5_.locale AS locale_44, p5_.id AS id_45, i6_.name AS name_46, i6_.original_name AS original_name_47, i6_.mime_type AS mime_type_48, i6_.size AS size_49, i6_.width AS width_50, i6_.height AS height_51, i6_.id AS id_52, i6_.created_at AS created_at_53, i6_.updated_at AS updated_at_54, i7_.title AS title_55, i7_.keywords AS keywords_56, i7_.locale AS locale_57, i7_.id AS id_58, p0_.principal_category_id AS principal_category_id_59, p0_.principal_image_id AS principal_image_id_60, p0_.manufacturer_id AS manufacturer_id_61, p0_.product_class_id AS product_class_id_62, p0_.stock_id AS stock_id_63, s1_.group_id AS group_id_64, v2_.principal_image_id AS principal_image_id_65, v2_.product_id AS product_id_66, v2_.stock_id AS stock_id_67, s3_.stock_id AS stock_id_68, s3_.store_id AS store_id_69, s3_.user_id AS user_id_70, s3_.tax_rate_id AS tax_rate_id_71, s3_.previous_tax_rate_id AS previous_tax_rate_id_72, t4_.store_id AS store_id_73, p5_.translatable_id AS translatable_id_74, i7_.translatable_id AS translatable_id_75 FROM product p0_ INNER JOIN stock s1_ ON p0_.stock_id = s1_.id LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id AND (s3_.store_id = ?) INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id AND (p5_.locale IN (?)) LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id AND (i7_.locale IN (?)) INNER JOIN product_category p8_ ON p0_.id = p8_.product_id INNER JOIN category c9_ ON p8_.category_id = c9_.id INNER JOIN recommended_product_category r11_ ON c9_.id = r11_.category_id INNER JOIN product p10_ ON p10_.id = r11_.product_id AND (p10_.id IN (?)) WHERE s1_.enabled = 1 AND p0_.id NOT IN (?) GROUP BY s1_.id ORDER BY sclr_0 ASC LIMIT 12

Parameters:

[
  1
  "sk"
  "sk"
  2867
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  RAND() AS sclr_0,
  p0_.type AS type_1,
  p0_.warranty_years AS warranty_years_2,
  p0_.new AS new_3,
  p0_.id AS id_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6,
  s1_.sku AS sku_7,
  s1_.quantity AS quantity_8,
  s1_.quantity_unit AS quantity_unit_9,
  s1_.ean_code AS ean_code_10,
  s1_.availability AS availability_11,
  s1_.`condition` AS condition_12,
  s1_.importable AS importable_13,
  s1_.tax_transferable AS tax_transferable_14,
  s1_.sale_count AS sale_count_15,
  s1_.disabled_at AS disabled_at_16,
  s1_.id AS id_17,
  s1_.created_at AS created_at_18,
  s1_.updated_at AS updated_at_19,
  s1_.enabled AS enabled_20,
  v2_.id AS id_21,
  v2_.position AS position_22,
  v2_.created_at AS created_at_23,
  v2_.updated_at AS updated_at_24,
  s3_.amount AS amount_25,
  s3_.tax_amount AS tax_amount_26,
  s3_.previous_amount AS previous_amount_27,
  s3_.previous_tax_amount AS previous_tax_amount_28,
  s3_.id AS id_29,
  s3_.created_at AS created_at_30,
  s3_.updated_at AS updated_at_31,
  t4_.rate AS rate_32,
  t4_.`precision` AS precision_33,
  t4_.id AS id_34,
  p5_.title AS title_35,
  p5_.h1 AS h1_36,
  p5_.perex AS perex_37,
  p5_.description AS description_38,
  p5_.text AS text_39,
  p5_.meta_title AS meta_title_40,
  p5_.meta_description AS meta_description_41,
  p5_.meta_keywords AS meta_keywords_42,
  p5_.slug AS slug_43,
  p5_.locale AS locale_44,
  p5_.id AS id_45,
  i6_.name AS name_46,
  i6_.original_name AS original_name_47,
  i6_.mime_type AS mime_type_48,
  i6_.size AS size_49,
  i6_.width AS width_50,
  i6_.height AS height_51,
  i6_.id AS id_52,
  i6_.created_at AS created_at_53,
  i6_.updated_at AS updated_at_54,
  i7_.title AS title_55,
  i7_.keywords AS keywords_56,
  i7_.locale AS locale_57,
  i7_.id AS id_58,
  p0_.principal_category_id AS principal_category_id_59,
  p0_.principal_image_id AS principal_image_id_60,
  p0_.manufacturer_id AS manufacturer_id_61,
  p0_.product_class_id AS product_class_id_62,
  p0_.stock_id AS stock_id_63,
  s1_.group_id AS group_id_64,
  v2_.principal_image_id AS principal_image_id_65,
  v2_.product_id AS product_id_66,
  v2_.stock_id AS stock_id_67,
  s3_.stock_id AS stock_id_68,
  s3_.store_id AS store_id_69,
  s3_.user_id AS user_id_70,
  s3_.tax_rate_id AS tax_rate_id_71,
  s3_.previous_tax_rate_id AS previous_tax_rate_id_72,
  t4_.store_id AS store_id_73,
  p5_.translatable_id AS translatable_id_74,
  i7_.translatable_id AS translatable_id_75
FROM
  product p0_
  INNER JOIN stock s1_ ON p0_.stock_id = s1_.id
  LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id
  INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id
  AND (s3_.store_id = ?)
  INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id
  INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id
  AND (
    p5_.locale IN (?)
  )
  LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id
  LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id
  AND (
    i7_.locale IN (?)
  )
  INNER JOIN product_category p8_ ON p0_.id = p8_.product_id
  INNER JOIN category c9_ ON p8_.category_id = c9_.id
  INNER JOIN recommended_product_category r11_ ON c9_.id = r11_.category_id
  INNER JOIN product p10_ ON p10_.id = r11_.product_id
  AND (
    p10_.id IN (?)
  )
WHERE
  s1_.enabled = 1
  AND p0_.id NOT IN (?)
GROUP BY
  s1_.id
ORDER BY
  sclr_0 ASC
LIMIT
  12

SELECT RAND() AS sclr_0, p0_.type AS type_1, p0_.warranty_years AS warranty_years_2, p0_.new AS new_3, p0_.id AS id_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, s1_.sku AS sku_7, s1_.quantity AS quantity_8, s1_.quantity_unit AS quantity_unit_9, s1_.ean_code AS ean_code_10, s1_.availability AS availability_11, s1_.`condition` AS condition_12, s1_.importable AS importable_13, s1_.tax_transferable AS tax_transferable_14, s1_.sale_count AS sale_count_15, s1_.disabled_at AS disabled_at_16, s1_.id AS id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s1_.enabled AS enabled_20, v2_.id AS id_21, v2_.position AS position_22, v2_.created_at AS created_at_23, v2_.updated_at AS updated_at_24, s3_.amount AS amount_25, s3_.tax_amount AS tax_amount_26, s3_.previous_amount AS previous_amount_27, s3_.previous_tax_amount AS previous_tax_amount_28, s3_.id AS id_29, s3_.created_at AS created_at_30, s3_.updated_at AS updated_at_31, t4_.rate AS rate_32, t4_.`precision` AS precision_33, t4_.id AS id_34, p5_.title AS title_35, p5_.h1 AS h1_36, p5_.perex AS perex_37, p5_.description AS description_38, p5_.text AS text_39, p5_.meta_title AS meta_title_40, p5_.meta_description AS meta_description_41, p5_.meta_keywords AS meta_keywords_42, p5_.slug AS slug_43, p5_.locale AS locale_44, p5_.id AS id_45, i6_.name AS name_46, i6_.original_name AS original_name_47, i6_.mime_type AS mime_type_48, i6_.size AS size_49, i6_.width AS width_50, i6_.height AS height_51, i6_.id AS id_52, i6_.created_at AS created_at_53, i6_.updated_at AS updated_at_54, i7_.title AS title_55, i7_.keywords AS keywords_56, i7_.locale AS locale_57, i7_.id AS id_58, p0_.principal_category_id AS principal_category_id_59, p0_.principal_image_id AS principal_image_id_60, p0_.manufacturer_id AS manufacturer_id_61, p0_.product_class_id AS product_class_id_62, p0_.stock_id AS stock_id_63, s1_.group_id AS group_id_64, v2_.principal_image_id AS principal_image_id_65, v2_.product_id AS product_id_66, v2_.stock_id AS stock_id_67, s3_.stock_id AS stock_id_68, s3_.store_id AS store_id_69, s3_.user_id AS user_id_70, s3_.tax_rate_id AS tax_rate_id_71, s3_.previous_tax_rate_id AS previous_tax_rate_id_72, t4_.store_id AS store_id_73, p5_.translatable_id AS translatable_id_74, i7_.translatable_id AS translatable_id_75 FROM product p0_ INNER JOIN stock s1_ ON p0_.stock_id = s1_.id LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id AND (s3_.store_id = 1) INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id AND (p5_.locale IN ('sk')) LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id AND (i7_.locale IN ('sk')) INNER JOIN product_category p8_ ON p0_.id = p8_.product_id INNER JOIN category c9_ ON p8_.category_id = c9_.id INNER JOIN recommended_product_category r11_ ON c9_.id = r11_.category_id INNER JOIN product p10_ ON p10_.id = r11_.product_id AND (p10_.id IN (2867)) WHERE s1_.enabled = 1 AND p0_.id NOT IN (2867) GROUP BY s1_.id ORDER BY sclr_0 ASC LIMIT 12;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 28)
7	App\Repository\QueryBuilder\AbstractQueryBuilder->find (line 79)
8	App\Provider\RecommendedProductsProvider->getRecommendationsForProducts (line 37)
9	App\Provider\RecommendedProductsProvider->getForProducts (line 26)
10	App\Provider\RecommendedProductsProvider->getForProduct (line 75)
11	App\Extension\Twig\ProductExtension->getRecommendedProducts (line 53)
12	__TwigTemplate_e896e59a8088230a79320efc1a39aed5->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 1520)
17	Twig\Extension\CoreExtension::include (line 199)
18	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->block_content (line 446)
19	Twig\Template->yieldBlock (line 428)
20	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->block_body (line 446)
21	Twig\Template->yieldBlock (line 531)
22	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->block_context (line 446)
23	Twig\Template->yieldBlock (line 155)
24	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->doDisplay (line 402)
25	Twig\Template->yield (line 67)
26	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->doDisplay (line 402)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->doDisplay (line 402)
29	Twig\Template->yield (line 56)
30	__TwigTemplate_3942a16c5635c0f06a520f931ec7bcda->doDisplay (line 402)
31	Twig\Template->yield (line 358)
32	Twig\Template->display (line 373)
33	Twig\Template->render (line 51)
34	Twig\TemplateWrapper->render (line 333)
35	Twig\Environment->render (line 27)
36	App\Controller\Content\Product->show (line 181)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

0.96 ms
(1.99%)

SELECT p0_.id AS id_0, p1_.value AS value_1, p1_.on_listing AS on_listing_2, p1_.configurable AS configurable_3, p1_.id AS id_4, p1_.position AS position_5, a2_.alias AS alias_6, a2_.class AS class_7, a2_.icon AS icon_8, a2_.on_detail AS on_detail_9, a2_.on_listing AS on_listing_10, a2_.expanded AS expanded_11, a2_.id AS id_12, a2_.position AS position_13, a2_.created_at AS created_at_14, a2_.updated_at AS updated_at_15, a3_.title AS title_16, a3_.description AS description_17, a3_.unit AS unit_18, a3_.locale AS locale_19, a3_.id AS id_20, a4_.class AS class_21, a4_.id AS id_22, a4_.position AS position_23, a4_.created_at AS created_at_24, a4_.updated_at AS updated_at_25, a5_.title AS title_26, a5_.description AS description_27, a5_.locale AS locale_28, a5_.id AS id_29, p0_.principal_category_id AS principal_category_id_30, p0_.principal_image_id AS principal_image_id_31, p0_.manufacturer_id AS manufacturer_id_32, p0_.product_class_id AS product_class_id_33, p0_.stock_id AS stock_id_34, p1_.product_id AS product_id_35, p1_.attribute_id AS attribute_id_36, p1_.attribute_option_id AS attribute_option_id_37, p1_.principal_image_id AS principal_image_id_38, a2_.group_id AS group_id_39, a3_.translatable_id AS translatable_id_40, a4_.parent_id AS parent_id_41, a5_.translatable_id AS translatable_id_42 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN attribute a2_ ON p1_.attribute_id = a2_.id LEFT JOIN attribute_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN attribute_group a4_ ON a2_.group_id = a4_.id LEFT JOIN attribute_group_translation a5_ ON a4_.id = a5_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p1_.value AS value_1,
  p1_.on_listing AS on_listing_2,
  p1_.configurable AS configurable_3,
  p1_.id AS id_4,
  p1_.position AS position_5,
  a2_.alias AS alias_6,
  a2_.class AS class_7,
  a2_.icon AS icon_8,
  a2_.on_detail AS on_detail_9,
  a2_.on_listing AS on_listing_10,
  a2_.expanded AS expanded_11,
  a2_.id AS id_12,
  a2_.position AS position_13,
  a2_.created_at AS created_at_14,
  a2_.updated_at AS updated_at_15,
  a3_.title AS title_16,
  a3_.description AS description_17,
  a3_.unit AS unit_18,
  a3_.locale AS locale_19,
  a3_.id AS id_20,
  a4_.class AS class_21,
  a4_.id AS id_22,
  a4_.position AS position_23,
  a4_.created_at AS created_at_24,
  a4_.updated_at AS updated_at_25,
  a5_.title AS title_26,
  a5_.description AS description_27,
  a5_.locale AS locale_28,
  a5_.id AS id_29,
  p0_.principal_category_id AS principal_category_id_30,
  p0_.principal_image_id AS principal_image_id_31,
  p0_.manufacturer_id AS manufacturer_id_32,
  p0_.product_class_id AS product_class_id_33,
  p0_.stock_id AS stock_id_34,
  p1_.product_id AS product_id_35,
  p1_.attribute_id AS attribute_id_36,
  p1_.attribute_option_id AS attribute_option_id_37,
  p1_.principal_image_id AS principal_image_id_38,
  a2_.group_id AS group_id_39,
  a3_.translatable_id AS translatable_id_40,
  a4_.parent_id AS parent_id_41,
  a5_.translatable_id AS translatable_id_42
FROM
  product p0_
  LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id
  LEFT JOIN attribute a2_ ON p1_.attribute_id = a2_.id
  LEFT JOIN attribute_translation a3_ ON a2_.id = a3_.translatable_id
  LEFT JOIN attribute_group a4_ ON a2_.group_id = a4_.id
  LEFT JOIN attribute_group_translation a5_ ON a4_.id = a5_.translatable_id
WHERE
  p0_.id = ?
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p1_.value AS value_1, p1_.on_listing AS on_listing_2, p1_.configurable AS configurable_3, p1_.id AS id_4, p1_.position AS position_5, a2_.alias AS alias_6, a2_.class AS class_7, a2_.icon AS icon_8, a2_.on_detail AS on_detail_9, a2_.on_listing AS on_listing_10, a2_.expanded AS expanded_11, a2_.id AS id_12, a2_.position AS position_13, a2_.created_at AS created_at_14, a2_.updated_at AS updated_at_15, a3_.title AS title_16, a3_.description AS description_17, a3_.unit AS unit_18, a3_.locale AS locale_19, a3_.id AS id_20, a4_.class AS class_21, a4_.id AS id_22, a4_.position AS position_23, a4_.created_at AS created_at_24, a4_.updated_at AS updated_at_25, a5_.title AS title_26, a5_.description AS description_27, a5_.locale AS locale_28, a5_.id AS id_29, p0_.principal_category_id AS principal_category_id_30, p0_.principal_image_id AS principal_image_id_31, p0_.manufacturer_id AS manufacturer_id_32, p0_.product_class_id AS product_class_id_33, p0_.stock_id AS stock_id_34, p1_.product_id AS product_id_35, p1_.attribute_id AS attribute_id_36, p1_.attribute_option_id AS attribute_option_id_37, p1_.principal_image_id AS principal_image_id_38, a2_.group_id AS group_id_39, a3_.translatable_id AS translatable_id_40, a4_.parent_id AS parent_id_41, a5_.translatable_id AS translatable_id_42 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN attribute a2_ ON p1_.attribute_id = a2_.id LEFT JOIN attribute_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN attribute_group a4_ ON a2_.group_id = a4_.id LEFT JOIN attribute_group_translation a5_ ON a4_.id = a5_.translatable_id WHERE p0_.id = 2867 ORDER BY p1_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 356)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.83 ms
(1.72%)

SELECT p0_.id AS id_0, p1_.position AS position_1, a2_.class AS class_2, a2_.icon AS icon_3, a2_.id AS id_4, a2_.position AS position_5, a2_.created_at AS created_at_6, a2_.updated_at AS updated_at_7, a3_.title AS title_8, a3_.description AS description_9, a3_.locale AS locale_10, a3_.id AS id_11, a4_.class AS class_12, a4_.id AS id_13, a4_.position AS position_14, a4_.created_at AS created_at_15, a4_.updated_at AS updated_at_16, a5_.title AS title_17, a5_.description AS description_18, a5_.locale AS locale_19, a5_.id AS id_20, p0_.principal_category_id AS principal_category_id_21, p0_.principal_image_id AS principal_image_id_22, p0_.manufacturer_id AS manufacturer_id_23, p0_.product_class_id AS product_class_id_24, p0_.stock_id AS stock_id_25, p1_.product_id AS product_id_26, p1_.advantage_id AS advantage_id_27, a2_.group_id AS group_id_28, a3_.translatable_id AS translatable_id_29, a4_.parent_id AS parent_id_30, a5_.translatable_id AS translatable_id_31 FROM product p0_ LEFT JOIN product_advantage p1_ ON p0_.id = p1_.product_id LEFT JOIN advantage a2_ ON p1_.advantage_id = a2_.id LEFT JOIN advantage_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN advantage_group a4_ ON a2_.group_id = a4_.id LEFT JOIN advantage_group_translation a5_ ON a4_.id = a5_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p1_.position AS position_1,
  a2_.class AS class_2,
  a2_.icon AS icon_3,
  a2_.id AS id_4,
  a2_.position AS position_5,
  a2_.created_at AS created_at_6,
  a2_.updated_at AS updated_at_7,
  a3_.title AS title_8,
  a3_.description AS description_9,
  a3_.locale AS locale_10,
  a3_.id AS id_11,
  a4_.class AS class_12,
  a4_.id AS id_13,
  a4_.position AS position_14,
  a4_.created_at AS created_at_15,
  a4_.updated_at AS updated_at_16,
  a5_.title AS title_17,
  a5_.description AS description_18,
  a5_.locale AS locale_19,
  a5_.id AS id_20,
  p0_.principal_category_id AS principal_category_id_21,
  p0_.principal_image_id AS principal_image_id_22,
  p0_.manufacturer_id AS manufacturer_id_23,
  p0_.product_class_id AS product_class_id_24,
  p0_.stock_id AS stock_id_25,
  p1_.product_id AS product_id_26,
  p1_.advantage_id AS advantage_id_27,
  a2_.group_id AS group_id_28,
  a3_.translatable_id AS translatable_id_29,
  a4_.parent_id AS parent_id_30,
  a5_.translatable_id AS translatable_id_31
FROM
  product p0_
  LEFT JOIN product_advantage p1_ ON p0_.id = p1_.product_id
  LEFT JOIN advantage a2_ ON p1_.advantage_id = a2_.id
  LEFT JOIN advantage_translation a3_ ON a2_.id = a3_.translatable_id
  LEFT JOIN advantage_group a4_ ON a2_.group_id = a4_.id
  LEFT JOIN advantage_group_translation a5_ ON a4_.id = a5_.translatable_id
WHERE
  p0_.id = ?
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p1_.position AS position_1, a2_.class AS class_2, a2_.icon AS icon_3, a2_.id AS id_4, a2_.position AS position_5, a2_.created_at AS created_at_6, a2_.updated_at AS updated_at_7, a3_.title AS title_8, a3_.description AS description_9, a3_.locale AS locale_10, a3_.id AS id_11, a4_.class AS class_12, a4_.id AS id_13, a4_.position AS position_14, a4_.created_at AS created_at_15, a4_.updated_at AS updated_at_16, a5_.title AS title_17, a5_.description AS description_18, a5_.locale AS locale_19, a5_.id AS id_20, p0_.principal_category_id AS principal_category_id_21, p0_.principal_image_id AS principal_image_id_22, p0_.manufacturer_id AS manufacturer_id_23, p0_.product_class_id AS product_class_id_24, p0_.stock_id AS stock_id_25, p1_.product_id AS product_id_26, p1_.advantage_id AS advantage_id_27, a2_.group_id AS group_id_28, a3_.translatable_id AS translatable_id_29, a4_.parent_id AS parent_id_30, a5_.translatable_id AS translatable_id_31 FROM product p0_ LEFT JOIN product_advantage p1_ ON p0_.id = p1_.product_id LEFT JOIN advantage a2_ ON p1_.advantage_id = a2_.id LEFT JOIN advantage_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN advantage_group a4_ ON a2_.group_id = a4_.id LEFT JOIN advantage_group_translation a5_ ON a4_.id = a5_.translatable_id WHERE p0_.id = 2867 ORDER BY p1_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 342)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.82 ms
(1.70%)

SELECT s0_.name AS name_0, s0_.email AS email_1, s0_.url AS url_2, s0_.country AS country_3, s0_.locale AS locale_4, s0_.currency AS currency_5, s0_.order_base_number AS order_base_number_6, s0_.order_email AS order_email_7, s0_.id AS id_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM store s0_ ORDER BY s0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.email AS email_1,
  s0_.url AS url_2,
  s0_.country AS country_3,
  s0_.locale AS locale_4,
  s0_.currency AS currency_5,
  s0_.order_base_number AS order_base_number_6,
  s0_.order_email AS order_email_7,
  s0_.id AS id_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10
FROM
  store s0_
ORDER BY
  s0_.id ASC

SELECT s0_.name AS name_0, s0_.email AS email_1, s0_.url AS url_2, s0_.country AS country_3, s0_.locale AS locale_4, s0_.currency AS currency_5, s0_.order_base_number AS order_base_number_6, s0_.order_email AS order_email_7, s0_.id AS id_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM store s0_ ORDER BY s0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 36)
7	App\Repository\StoreRepository->findAll (line 56)
8	App\Context\StoreContext->getStores (line 88)
9	App\Context\StoreContext->getStoreByHost (line 44)
10	App\EventSubscriber\ResolveStoreSubscriber->onKernelRequest (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.76 ms
(1.57%)

SELECT p0_.id AS id_0, p1_.value AS value_1, p1_.on_listing AS on_listing_2, p1_.configurable AS configurable_3, p1_.id AS id_4, p1_.position AS position_5, p2_.amount AS amount_6, p2_.tax_amount AS tax_amount_7, p2_.previous_amount AS previous_amount_8, p2_.previous_tax_amount AS previous_tax_amount_9, p2_.id AS id_10, p2_.created_at AS created_at_11, p2_.updated_at AS updated_at_12, i3_.name AS name_13, i3_.original_name AS original_name_14, i3_.mime_type AS mime_type_15, i3_.size AS size_16, i3_.width AS width_17, i3_.height AS height_18, i3_.id AS id_19, i3_.created_at AS created_at_20, i3_.updated_at AS updated_at_21, i4_.title AS title_22, i4_.keywords AS keywords_23, i4_.locale AS locale_24, i4_.id AS id_25, p0_.principal_category_id AS principal_category_id_26, p0_.principal_image_id AS principal_image_id_27, p0_.manufacturer_id AS manufacturer_id_28, p0_.product_class_id AS product_class_id_29, p0_.stock_id AS stock_id_30, p1_.product_id AS product_id_31, p1_.attribute_id AS attribute_id_32, p1_.attribute_option_id AS attribute_option_id_33, p1_.principal_image_id AS principal_image_id_34, p2_.product_attribute_id AS product_attribute_id_35, p2_.store_id AS store_id_36, p2_.user_id AS user_id_37, p2_.tax_rate_id AS tax_rate_id_38, p2_.previous_tax_rate_id AS previous_tax_rate_id_39, i4_.translatable_id AS translatable_id_40 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_attribute_price p2_ ON p1_.id = p2_.product_attribute_id LEFT JOIN image i3_ ON p1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p1_.value AS value_1,
  p1_.on_listing AS on_listing_2,
  p1_.configurable AS configurable_3,
  p1_.id AS id_4,
  p1_.position AS position_5,
  p2_.amount AS amount_6,
  p2_.tax_amount AS tax_amount_7,
  p2_.previous_amount AS previous_amount_8,
  p2_.previous_tax_amount AS previous_tax_amount_9,
  p2_.id AS id_10,
  p2_.created_at AS created_at_11,
  p2_.updated_at AS updated_at_12,
  i3_.name AS name_13,
  i3_.original_name AS original_name_14,
  i3_.mime_type AS mime_type_15,
  i3_.size AS size_16,
  i3_.width AS width_17,
  i3_.height AS height_18,
  i3_.id AS id_19,
  i3_.created_at AS created_at_20,
  i3_.updated_at AS updated_at_21,
  i4_.title AS title_22,
  i4_.keywords AS keywords_23,
  i4_.locale AS locale_24,
  i4_.id AS id_25,
  p0_.principal_category_id AS principal_category_id_26,
  p0_.principal_image_id AS principal_image_id_27,
  p0_.manufacturer_id AS manufacturer_id_28,
  p0_.product_class_id AS product_class_id_29,
  p0_.stock_id AS stock_id_30,
  p1_.product_id AS product_id_31,
  p1_.attribute_id AS attribute_id_32,
  p1_.attribute_option_id AS attribute_option_id_33,
  p1_.principal_image_id AS principal_image_id_34,
  p2_.product_attribute_id AS product_attribute_id_35,
  p2_.store_id AS store_id_36,
  p2_.user_id AS user_id_37,
  p2_.tax_rate_id AS tax_rate_id_38,
  p2_.previous_tax_rate_id AS previous_tax_rate_id_39,
  i4_.translatable_id AS translatable_id_40
FROM
  product p0_
  LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id
  LEFT JOIN product_attribute_price p2_ ON p1_.id = p2_.product_attribute_id
  LEFT JOIN image i3_ ON p1_.principal_image_id = i3_.id
  LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id
WHERE
  p0_.id = ?
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p1_.value AS value_1, p1_.on_listing AS on_listing_2, p1_.configurable AS configurable_3, p1_.id AS id_4, p1_.position AS position_5, p2_.amount AS amount_6, p2_.tax_amount AS tax_amount_7, p2_.previous_amount AS previous_amount_8, p2_.previous_tax_amount AS previous_tax_amount_9, p2_.id AS id_10, p2_.created_at AS created_at_11, p2_.updated_at AS updated_at_12, i3_.name AS name_13, i3_.original_name AS original_name_14, i3_.mime_type AS mime_type_15, i3_.size AS size_16, i3_.width AS width_17, i3_.height AS height_18, i3_.id AS id_19, i3_.created_at AS created_at_20, i3_.updated_at AS updated_at_21, i4_.title AS title_22, i4_.keywords AS keywords_23, i4_.locale AS locale_24, i4_.id AS id_25, p0_.principal_category_id AS principal_category_id_26, p0_.principal_image_id AS principal_image_id_27, p0_.manufacturer_id AS manufacturer_id_28, p0_.product_class_id AS product_class_id_29, p0_.stock_id AS stock_id_30, p1_.product_id AS product_id_31, p1_.attribute_id AS attribute_id_32, p1_.attribute_option_id AS attribute_option_id_33, p1_.principal_image_id AS principal_image_id_34, p2_.product_attribute_id AS product_attribute_id_35, p2_.store_id AS store_id_36, p2_.user_id AS user_id_37, p2_.tax_rate_id AS tax_rate_id_38, p2_.previous_tax_rate_id AS previous_tax_rate_id_39, i4_.translatable_id AS translatable_id_40 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_attribute_price p2_ ON p1_.id = p2_.product_attribute_id LEFT JOIN image i3_ ON p1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id WHERE p0_.id = 2867 ORDER BY p1_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 368)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.74 ms
(1.53%)

SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.slug = ? AND s0_.locale IN (?)

Parameters:

[
  "terma-basic-zaoblene-madlo"
  "sk"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.content_id AS content_id_1,
  s0_.locale AS locale_2,
  s0_.slug AS slug_3,
  s0_.type AS type_4,
  s0_.previous_slug AS previous_slug_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7
FROM
  slug s0_
WHERE
  s0_.slug = ?
  AND s0_.locale IN (?)

SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.slug = 'terma-basic-zaoblene-madlo' AND s0_.locale IN ('sk');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 49)
7	App\Repository\SlugRepository->findOneBySlugAndLocale (line 81)
8	App\Routing\RouteProvider->findSlugsByCandidate (line 36)
9	App\Routing\RouteProvider->getRouteCollectionForRequest (line 97)
10	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
11	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
14	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
15	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.73 ms
(1.50%)

SELECT p0_.id AS id_0, p1_.value AS value_1, p1_.on_listing AS on_listing_2, p1_.configurable AS configurable_3, p1_.id AS id_4, p1_.position AS position_5, a2_.id AS id_6, a2_.position AS position_7, a2_.created_at AS created_at_8, a2_.updated_at AS updated_at_9, a3_.title AS title_10, a3_.description AS description_11, a3_.slug AS slug_12, a3_.locale AS locale_13, a3_.id AS id_14, i4_.name AS name_15, i4_.original_name AS original_name_16, i4_.mime_type AS mime_type_17, i4_.size AS size_18, i4_.width AS width_19, i4_.height AS height_20, i4_.id AS id_21, i4_.created_at AS created_at_22, i4_.updated_at AS updated_at_23, i5_.title AS title_24, i5_.keywords AS keywords_25, i5_.locale AS locale_26, i5_.id AS id_27, p0_.principal_category_id AS principal_category_id_28, p0_.principal_image_id AS principal_image_id_29, p0_.manufacturer_id AS manufacturer_id_30, p0_.product_class_id AS product_class_id_31, p0_.stock_id AS stock_id_32, p1_.product_id AS product_id_33, p1_.attribute_id AS attribute_id_34, p1_.attribute_option_id AS attribute_option_id_35, p1_.principal_image_id AS principal_image_id_36, a2_.attribute_id AS attribute_id_37, a2_.principal_image_id AS principal_image_id_38, a3_.translatable_id AS translatable_id_39, i5_.translatable_id AS translatable_id_40 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN attribute_option a2_ ON p1_.attribute_option_id = a2_.id LEFT JOIN attribute_option_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN image i4_ ON a2_.principal_image_id = i4_.id LEFT JOIN image_translation i5_ ON i4_.id = i5_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p1_.value AS value_1,
  p1_.on_listing AS on_listing_2,
  p1_.configurable AS configurable_3,
  p1_.id AS id_4,
  p1_.position AS position_5,
  a2_.id AS id_6,
  a2_.position AS position_7,
  a2_.created_at AS created_at_8,
  a2_.updated_at AS updated_at_9,
  a3_.title AS title_10,
  a3_.description AS description_11,
  a3_.slug AS slug_12,
  a3_.locale AS locale_13,
  a3_.id AS id_14,
  i4_.name AS name_15,
  i4_.original_name AS original_name_16,
  i4_.mime_type AS mime_type_17,
  i4_.size AS size_18,
  i4_.width AS width_19,
  i4_.height AS height_20,
  i4_.id AS id_21,
  i4_.created_at AS created_at_22,
  i4_.updated_at AS updated_at_23,
  i5_.title AS title_24,
  i5_.keywords AS keywords_25,
  i5_.locale AS locale_26,
  i5_.id AS id_27,
  p0_.principal_category_id AS principal_category_id_28,
  p0_.principal_image_id AS principal_image_id_29,
  p0_.manufacturer_id AS manufacturer_id_30,
  p0_.product_class_id AS product_class_id_31,
  p0_.stock_id AS stock_id_32,
  p1_.product_id AS product_id_33,
  p1_.attribute_id AS attribute_id_34,
  p1_.attribute_option_id AS attribute_option_id_35,
  p1_.principal_image_id AS principal_image_id_36,
  a2_.attribute_id AS attribute_id_37,
  a2_.principal_image_id AS principal_image_id_38,
  a3_.translatable_id AS translatable_id_39,
  i5_.translatable_id AS translatable_id_40
FROM
  product p0_
  LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id
  LEFT JOIN attribute_option a2_ ON p1_.attribute_option_id = a2_.id
  LEFT JOIN attribute_option_translation a3_ ON a2_.id = a3_.translatable_id
  LEFT JOIN image i4_ ON a2_.principal_image_id = i4_.id
  LEFT JOIN image_translation i5_ ON i4_.id = i5_.translatable_id
WHERE
  p0_.id = ?
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p1_.value AS value_1, p1_.on_listing AS on_listing_2, p1_.configurable AS configurable_3, p1_.id AS id_4, p1_.position AS position_5, a2_.id AS id_6, a2_.position AS position_7, a2_.created_at AS created_at_8, a2_.updated_at AS updated_at_9, a3_.title AS title_10, a3_.description AS description_11, a3_.slug AS slug_12, a3_.locale AS locale_13, a3_.id AS id_14, i4_.name AS name_15, i4_.original_name AS original_name_16, i4_.mime_type AS mime_type_17, i4_.size AS size_18, i4_.width AS width_19, i4_.height AS height_20, i4_.id AS id_21, i4_.created_at AS created_at_22, i4_.updated_at AS updated_at_23, i5_.title AS title_24, i5_.keywords AS keywords_25, i5_.locale AS locale_26, i5_.id AS id_27, p0_.principal_category_id AS principal_category_id_28, p0_.principal_image_id AS principal_image_id_29, p0_.manufacturer_id AS manufacturer_id_30, p0_.product_class_id AS product_class_id_31, p0_.stock_id AS stock_id_32, p1_.product_id AS product_id_33, p1_.attribute_id AS attribute_id_34, p1_.attribute_option_id AS attribute_option_id_35, p1_.principal_image_id AS principal_image_id_36, a2_.attribute_id AS attribute_id_37, a2_.principal_image_id AS principal_image_id_38, a3_.translatable_id AS translatable_id_39, i5_.translatable_id AS translatable_id_40 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN attribute_option a2_ ON p1_.attribute_option_id = a2_.id LEFT JOIN attribute_option_translation a3_ ON a2_.id = a3_.translatable_id LEFT JOIN image i4_ ON a2_.principal_image_id = i4_.id LEFT JOIN image_translation i5_ ON i4_.id = i5_.translatable_id WHERE p0_.id = 2867 ORDER BY p1_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 381)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.60 ms
(1.24%)

SELECT p0_.id AS id_0, p1_.position AS position_1, i2_.name AS name_2, i2_.original_name AS original_name_3, i2_.mime_type AS mime_type_4, i2_.size AS size_5, i2_.width AS width_6, i2_.height AS height_7, i2_.id AS id_8, i2_.created_at AS created_at_9, i2_.updated_at AS updated_at_10, i3_.title AS title_11, i3_.keywords AS keywords_12, i3_.locale AS locale_13, i3_.id AS id_14, p0_.principal_category_id AS principal_category_id_15, p0_.principal_image_id AS principal_image_id_16, p0_.manufacturer_id AS manufacturer_id_17, p0_.product_class_id AS product_class_id_18, p0_.stock_id AS stock_id_19, p1_.product_id AS product_id_20, p1_.image_id AS image_id_21, i3_.translatable_id AS translatable_id_22 FROM product p0_ LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id LEFT JOIN image i2_ ON p1_.image_id = i2_.id LEFT JOIN image_translation i3_ ON i2_.id = i3_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p1_.position AS position_1,
  i2_.name AS name_2,
  i2_.original_name AS original_name_3,
  i2_.mime_type AS mime_type_4,
  i2_.size AS size_5,
  i2_.width AS width_6,
  i2_.height AS height_7,
  i2_.id AS id_8,
  i2_.created_at AS created_at_9,
  i2_.updated_at AS updated_at_10,
  i3_.title AS title_11,
  i3_.keywords AS keywords_12,
  i3_.locale AS locale_13,
  i3_.id AS id_14,
  p0_.principal_category_id AS principal_category_id_15,
  p0_.principal_image_id AS principal_image_id_16,
  p0_.manufacturer_id AS manufacturer_id_17,
  p0_.product_class_id AS product_class_id_18,
  p0_.stock_id AS stock_id_19,
  p1_.product_id AS product_id_20,
  p1_.image_id AS image_id_21,
  i3_.translatable_id AS translatable_id_22
FROM
  product p0_
  LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id
  LEFT JOIN image i2_ ON p1_.image_id = i2_.id
  LEFT JOIN image_translation i3_ ON i2_.id = i3_.translatable_id
WHERE
  p0_.id = ?
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p1_.position AS position_1, i2_.name AS name_2, i2_.original_name AS original_name_3, i2_.mime_type AS mime_type_4, i2_.size AS size_5, i2_.width AS width_6, i2_.height AS height_7, i2_.id AS id_8, i2_.created_at AS created_at_9, i2_.updated_at AS updated_at_10, i3_.title AS title_11, i3_.keywords AS keywords_12, i3_.locale AS locale_13, i3_.id AS id_14, p0_.principal_category_id AS principal_category_id_15, p0_.principal_image_id AS principal_image_id_16, p0_.manufacturer_id AS manufacturer_id_17, p0_.product_class_id AS product_class_id_18, p0_.stock_id AS stock_id_19, p1_.product_id AS product_id_20, p1_.image_id AS image_id_21, i3_.translatable_id AS translatable_id_22 FROM product p0_ LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id LEFT JOIN image i2_ ON p1_.image_id = i2_.id LEFT JOIN image_translation i3_ ON i2_.id = i3_.translatable_id WHERE p0_.id = 2867 ORDER BY p1_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 444)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.57 ms
(1.19%)

SELECT p0_.id AS id_0, c1_.main_template AS main_template_1, c1_.product_template AS product_template_2, c1_.filterable AS filterable_3, c1_.id AS id_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, c2_.slug AS slug_7, c2_.title AS title_8, c2_.h1 AS h1_9, c2_.perex AS perex_10, c2_.description AS description_11, c2_.meta_title AS meta_title_12, c2_.meta_description AS meta_description_13, c2_.meta_keywords AS meta_keywords_14, c2_.locale AS locale_15, c2_.id AS id_16, p0_.principal_category_id AS principal_category_id_17, p0_.principal_image_id AS principal_image_id_18, p0_.manufacturer_id AS manufacturer_id_19, p0_.product_class_id AS product_class_id_20, p0_.stock_id AS stock_id_21, c1_.principal_image_id AS principal_image_id_22, c2_.translatable_id AS translatable_id_23 FROM product p0_ LEFT JOIN recommended_product_category r3_ ON p0_.id = r3_.product_id LEFT JOIN category c1_ ON c1_.id = r3_.category_id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id WHERE p0_.id = ?

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  c1_.main_template AS main_template_1,
  c1_.product_template AS product_template_2,
  c1_.filterable AS filterable_3,
  c1_.id AS id_4,
  c1_.created_at AS created_at_5,
  c1_.updated_at AS updated_at_6,
  c2_.slug AS slug_7,
  c2_.title AS title_8,
  c2_.h1 AS h1_9,
  c2_.perex AS perex_10,
  c2_.description AS description_11,
  c2_.meta_title AS meta_title_12,
  c2_.meta_description AS meta_description_13,
  c2_.meta_keywords AS meta_keywords_14,
  c2_.locale AS locale_15,
  c2_.id AS id_16,
  p0_.principal_category_id AS principal_category_id_17,
  p0_.principal_image_id AS principal_image_id_18,
  p0_.manufacturer_id AS manufacturer_id_19,
  p0_.product_class_id AS product_class_id_20,
  p0_.stock_id AS stock_id_21,
  c1_.principal_image_id AS principal_image_id_22,
  c2_.translatable_id AS translatable_id_23
FROM
  product p0_
  LEFT JOIN recommended_product_category r3_ ON p0_.id = r3_.product_id
  LEFT JOIN category c1_ ON c1_.id = r3_.category_id
  LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, c1_.main_template AS main_template_1, c1_.product_template AS product_template_2, c1_.filterable AS filterable_3, c1_.id AS id_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, c2_.slug AS slug_7, c2_.title AS title_8, c2_.h1 AS h1_9, c2_.perex AS perex_10, c2_.description AS description_11, c2_.meta_title AS meta_title_12, c2_.meta_description AS meta_description_13, c2_.meta_keywords AS meta_keywords_14, c2_.locale AS locale_15, c2_.id AS id_16, p0_.principal_category_id AS principal_category_id_17, p0_.principal_image_id AS principal_image_id_18, p0_.manufacturer_id AS manufacturer_id_19, p0_.product_class_id AS product_class_id_20, p0_.stock_id AS stock_id_21, c1_.principal_image_id AS principal_image_id_22, c2_.translatable_id AS translatable_id_23 FROM product p0_ LEFT JOIN recommended_product_category r3_ ON p0_.id = r3_.product_id LEFT JOIN category c1_ ON c1_.id = r3_.category_id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id WHERE p0_.id = 2867;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 408)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.52 ms
(1.08%)

SELECT p0_.id AS id_0, p1_.position AS position_1, c2_.main_template AS main_template_2, c2_.product_template AS product_template_3, c2_.filterable AS filterable_4, c2_.id AS id_5, c2_.created_at AS created_at_6, c2_.updated_at AS updated_at_7, c3_.slug AS slug_8, c3_.title AS title_9, c3_.h1 AS h1_10, c3_.perex AS perex_11, c3_.description AS description_12, c3_.meta_title AS meta_title_13, c3_.meta_description AS meta_description_14, c3_.meta_keywords AS meta_keywords_15, c3_.locale AS locale_16, c3_.id AS id_17, p0_.principal_category_id AS principal_category_id_18, p0_.principal_image_id AS principal_image_id_19, p0_.manufacturer_id AS manufacturer_id_20, p0_.product_class_id AS product_class_id_21, p0_.stock_id AS stock_id_22, p1_.category_id AS category_id_23, p1_.product_id AS product_id_24, c2_.principal_image_id AS principal_image_id_25, c3_.translatable_id AS translatable_id_26 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.id = p1_.product_id LEFT JOIN category c2_ ON p1_.category_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id WHERE p0_.id = ?

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p1_.position AS position_1,
  c2_.main_template AS main_template_2,
  c2_.product_template AS product_template_3,
  c2_.filterable AS filterable_4,
  c2_.id AS id_5,
  c2_.created_at AS created_at_6,
  c2_.updated_at AS updated_at_7,
  c3_.slug AS slug_8,
  c3_.title AS title_9,
  c3_.h1 AS h1_10,
  c3_.perex AS perex_11,
  c3_.description AS description_12,
  c3_.meta_title AS meta_title_13,
  c3_.meta_description AS meta_description_14,
  c3_.meta_keywords AS meta_keywords_15,
  c3_.locale AS locale_16,
  c3_.id AS id_17,
  p0_.principal_category_id AS principal_category_id_18,
  p0_.principal_image_id AS principal_image_id_19,
  p0_.manufacturer_id AS manufacturer_id_20,
  p0_.product_class_id AS product_class_id_21,
  p0_.stock_id AS stock_id_22,
  p1_.category_id AS category_id_23,
  p1_.product_id AS product_id_24,
  c2_.principal_image_id AS principal_image_id_25,
  c3_.translatable_id AS translatable_id_26
FROM
  product p0_
  LEFT JOIN product_category p1_ ON p0_.id = p1_.product_id
  LEFT JOIN category c2_ ON p1_.category_id = c2_.id
  LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p1_.position AS position_1, c2_.main_template AS main_template_2, c2_.product_template AS product_template_3, c2_.filterable AS filterable_4, c2_.id AS id_5, c2_.created_at AS created_at_6, c2_.updated_at AS updated_at_7, c3_.slug AS slug_8, c3_.title AS title_9, c3_.h1 AS h1_10, c3_.perex AS perex_11, c3_.description AS description_12, c3_.meta_title AS meta_title_13, c3_.meta_description AS meta_description_14, c3_.meta_keywords AS meta_keywords_15, c3_.locale AS locale_16, c3_.id AS id_17, p0_.principal_category_id AS principal_category_id_18, p0_.principal_image_id AS principal_image_id_19, p0_.manufacturer_id AS manufacturer_id_20, p0_.product_class_id AS product_class_id_21, p0_.stock_id AS stock_id_22, p1_.category_id AS category_id_23, p1_.product_id AS product_id_24, c2_.principal_image_id AS principal_image_id_25, c3_.translatable_id AS translatable_id_26 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.id = p1_.product_id LEFT JOIN category c2_ ON p1_.category_id = c2_.id LEFT JOIN category_translation c3_ ON c2_.id = c3_.translatable_id WHERE p0_.id = 2867;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 420)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.51 ms
(1.05%)

SELECT p0_.id AS id_0, p1_.position AS position_1, d2_.name AS name_2, d2_.original_name AS original_name_3, d2_.mime_type AS mime_type_4, d2_.size AS size_5, d2_.id AS id_6, d2_.created_at AS created_at_7, d2_.updated_at AS updated_at_8, d3_.title AS title_9, d3_.description AS description_10, d3_.keywords AS keywords_11, d3_.locale AS locale_12, d3_.id AS id_13, p0_.principal_category_id AS principal_category_id_14, p0_.principal_image_id AS principal_image_id_15, p0_.manufacturer_id AS manufacturer_id_16, p0_.product_class_id AS product_class_id_17, p0_.stock_id AS stock_id_18, p1_.product_id AS product_id_19, p1_.document_id AS document_id_20, d3_.translatable_id AS translatable_id_21 FROM product p0_ LEFT JOIN product_document p1_ ON p0_.id = p1_.product_id LEFT JOIN document d2_ ON p1_.document_id = d2_.id LEFT JOIN document_translation d3_ ON d2_.id = d3_.translatable_id WHERE p0_.id = ? ORDER BY p1_.position ASC

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p1_.position AS position_1,
  d2_.name AS name_2,
  d2_.original_name AS original_name_3,
  d2_.mime_type AS mime_type_4,
  d2_.size AS size_5,
  d2_.id AS id_6,
  d2_.created_at AS created_at_7,
  d2_.updated_at AS updated_at_8,
  d3_.title AS title_9,
  d3_.description AS description_10,
  d3_.keywords AS keywords_11,
  d3_.locale AS locale_12,
  d3_.id AS id_13,
  p0_.principal_category_id AS principal_category_id_14,
  p0_.principal_image_id AS principal_image_id_15,
  p0_.manufacturer_id AS manufacturer_id_16,
  p0_.product_class_id AS product_class_id_17,
  p0_.stock_id AS stock_id_18,
  p1_.product_id AS product_id_19,
  p1_.document_id AS document_id_20,
  d3_.translatable_id AS translatable_id_21
FROM
  product p0_
  LEFT JOIN product_document p1_ ON p0_.id = p1_.product_id
  LEFT JOIN document d2_ ON p1_.document_id = d2_.id
  LEFT JOIN document_translation d3_ ON d2_.id = d3_.translatable_id
WHERE
  p0_.id = ?
ORDER BY
  p1_.position ASC

SELECT p0_.id AS id_0, p1_.position AS position_1, d2_.name AS name_2, d2_.original_name AS original_name_3, d2_.mime_type AS mime_type_4, d2_.size AS size_5, d2_.id AS id_6, d2_.created_at AS created_at_7, d2_.updated_at AS updated_at_8, d3_.title AS title_9, d3_.description AS description_10, d3_.keywords AS keywords_11, d3_.locale AS locale_12, d3_.id AS id_13, p0_.principal_category_id AS principal_category_id_14, p0_.principal_image_id AS principal_image_id_15, p0_.manufacturer_id AS manufacturer_id_16, p0_.product_class_id AS product_class_id_17, p0_.stock_id AS stock_id_18, p1_.product_id AS product_id_19, p1_.document_id AS document_id_20, d3_.translatable_id AS translatable_id_21 FROM product p0_ LEFT JOIN product_document p1_ ON p0_.id = p1_.product_id LEFT JOIN document d2_ ON p1_.document_id = d2_.id LEFT JOIN document_translation d3_ ON d2_.id = d3_.translatable_id WHERE p0_.id = 2867 ORDER BY p1_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 432)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.45 ms
(0.93%)

SELECT t0.rate AS rate_1, t0.`precision` AS precision_2, t0.id AS id_3, t0.store_id AS store_id_4 FROM tax_rate t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.rate AS rate_1,
  t0.`precision` AS precision_2,
  t0.id AS id_3,
  t0.store_id AS store_id_4
FROM
  tax_rate t0
WHERE
  t0.id = ?

SELECT t0.rate AS rate_1, t0.`precision` AS precision_2, t0.id AS id_3, t0.store_id AS store_id_4 FROM tax_rate t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\TaxRate::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\TaxRate->__get (line 53)
8	App\Entity\TaxRate->getRate (line 180)
9	App\Entity\StockPrice->toPrice (line 54)
10	App\DataLayer\Transformer\ProductEventTransformer->transformData (line 25)
11	App\DataLayer\Transformer\ProductEventTransformer->transform (line 41)
12	App\DataLayer\EventSubscriber\PushEventViewItem->onShowContent (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 25)
17	App\Controller\Content\Product->show (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.44 ms
(0.91%)

SELECT p0_.id AS id_0, v1_.provider AS provider_1, v1_.id AS id_2, v1_.created_at AS created_at_3, v1_.updated_at AS updated_at_4, v2_.url AS url_5, v2_.title AS title_6, v2_.embed_code AS embed_code_7, v2_.locale AS locale_8, v2_.id AS id_9, p0_.principal_category_id AS principal_category_id_10, p0_.principal_image_id AS principal_image_id_11, p0_.manufacturer_id AS manufacturer_id_12, p0_.product_class_id AS product_class_id_13, p0_.stock_id AS stock_id_14, v2_.translatable_id AS translatable_id_15 FROM product p0_ LEFT JOIN product_video p3_ ON p0_.id = p3_.product_id LEFT JOIN video v1_ ON v1_.id = p3_.video_id LEFT JOIN video_translation v2_ ON v1_.id = v2_.translatable_id WHERE p0_.id = ?

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  v1_.provider AS provider_1,
  v1_.id AS id_2,
  v1_.created_at AS created_at_3,
  v1_.updated_at AS updated_at_4,
  v2_.url AS url_5,
  v2_.title AS title_6,
  v2_.embed_code AS embed_code_7,
  v2_.locale AS locale_8,
  v2_.id AS id_9,
  p0_.principal_category_id AS principal_category_id_10,
  p0_.principal_image_id AS principal_image_id_11,
  p0_.manufacturer_id AS manufacturer_id_12,
  p0_.product_class_id AS product_class_id_13,
  p0_.stock_id AS stock_id_14,
  v2_.translatable_id AS translatable_id_15
FROM
  product p0_
  LEFT JOIN product_video p3_ ON p0_.id = p3_.product_id
  LEFT JOIN video v1_ ON v1_.id = p3_.video_id
  LEFT JOIN video_translation v2_ ON v1_.id = v2_.translatable_id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, v1_.provider AS provider_1, v1_.id AS id_2, v1_.created_at AS created_at_3, v1_.updated_at AS updated_at_4, v2_.url AS url_5, v2_.title AS title_6, v2_.embed_code AS embed_code_7, v2_.locale AS locale_8, v2_.id AS id_9, p0_.principal_category_id AS principal_category_id_10, p0_.principal_image_id AS principal_image_id_11, p0_.manufacturer_id AS manufacturer_id_12, p0_.product_class_id AS product_class_id_13, p0_.stock_id AS stock_id_14, v2_.translatable_id AS translatable_id_15 FROM product p0_ LEFT JOIN product_video p3_ ON p0_.id = p3_.product_id LEFT JOIN video v1_ ON v1_.id = p3_.video_id LEFT JOIN video_translation v2_ ON v1_.id = v2_.translatable_id WHERE p0_.id = 2867;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 455)
7	App\Repository\ProductRepository->findByIdOptimized (line 24)
8	App\Controller\Content\Product->show (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.40 ms
(0.82%)

SELECT t0.type AS type_1, t0.warranty_years AS warranty_years_2, t0.new AS new_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_category_id AS principal_category_id_7, t0.principal_image_id AS principal_image_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.product_class_id AS product_class_id_10, t0.stock_id AS stock_id_11, t12.sku AS sku_13, t12.quantity AS quantity_14, t12.quantity_unit AS quantity_unit_15, t12.ean_code AS ean_code_16, t12.availability AS availability_17, t12.`condition` AS condition_18, t12.importable AS importable_19, t12.tax_transferable AS tax_transferable_20, t12.sale_count AS sale_count_21, t12.disabled_at AS disabled_at_22, t12.id AS id_23, t12.created_at AS created_at_24, t12.updated_at AS updated_at_25, t12.enabled AS enabled_26, t12.group_id AS group_id_27 FROM product t0 LEFT JOIN stock t12 ON t0.stock_id = t12.id WHERE t0.id = ?

Parameters:

[
  2867
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.type AS type_1,
  t0.warranty_years AS warranty_years_2,
  t0.new AS new_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.principal_category_id AS principal_category_id_7,
  t0.principal_image_id AS principal_image_id_8,
  t0.manufacturer_id AS manufacturer_id_9,
  t0.product_class_id AS product_class_id_10,
  t0.stock_id AS stock_id_11,
  t12.sku AS sku_13,
  t12.quantity AS quantity_14,
  t12.quantity_unit AS quantity_unit_15,
  t12.ean_code AS ean_code_16,
  t12.availability AS availability_17,
  t12.`condition` AS condition_18,
  t12.importable AS importable_19,
  t12.tax_transferable AS tax_transferable_20,
  t12.sale_count AS sale_count_21,
  t12.disabled_at AS disabled_at_22,
  t12.id AS id_23,
  t12.created_at AS created_at_24,
  t12.updated_at AS updated_at_25,
  t12.enabled AS enabled_26,
  t12.group_id AS group_id_27
FROM
  product t0
  LEFT JOIN stock t12 ON t0.stock_id = t12.id
WHERE
  t0.id = ?

SELECT t0.type AS type_1, t0.warranty_years AS warranty_years_2, t0.new AS new_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_category_id AS principal_category_id_7, t0.principal_image_id AS principal_image_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.product_class_id AS product_class_id_10, t0.stock_id AS stock_id_11, t12.sku AS sku_13, t12.quantity AS quantity_14, t12.quantity_unit AS quantity_unit_15, t12.ean_code AS ean_code_16, t12.availability AS availability_17, t12.`condition` AS condition_18, t12.importable AS importable_19, t12.tax_transferable AS tax_transferable_20, t12.sale_count AS sale_count_21, t12.disabled_at AS disabled_at_22, t12.id AS id_23, t12.created_at AS created_at_24, t12.updated_at AS updated_at_25, t12.enabled AS enabled_26, t12.group_id AS group_id_27 FROM product t0 LEFT JOIN stock t12 ON t0.stock_id = t12.id WHERE t0.id = 2867;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 79)
7	App\Repository\SlugRepository->findContent (line 73)
8	App\Routing\RouteProvider->findContent (line 39)
9	App\Routing\RouteProvider->getRouteCollectionForRequest (line 97)
10	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
11	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
14	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
15	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.36 ms
(0.75%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.principal_image_id AS principal_image_id_5, t0.product_id AS product_id_6, t0.stock_id AS stock_id_7, t8.sku AS sku_9, t8.quantity AS quantity_10, t8.quantity_unit AS quantity_unit_11, t8.ean_code AS ean_code_12, t8.availability AS availability_13, t8.`condition` AS condition_14, t8.importable AS importable_15, t8.tax_transferable AS tax_transferable_16, t8.sale_count AS sale_count_17, t8.disabled_at AS disabled_at_18, t8.id AS id_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.enabled AS enabled_22, t8.group_id AS group_id_23 FROM variant t0 LEFT JOIN stock t8 ON t0.stock_id = t8.id WHERE t0.stock_id = ?

Parameters:

[
  3758
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.principal_image_id AS principal_image_id_5,
  t0.product_id AS product_id_6,
  t0.stock_id AS stock_id_7,
  t8.sku AS sku_9,
  t8.quantity AS quantity_10,
  t8.quantity_unit AS quantity_unit_11,
  t8.ean_code AS ean_code_12,
  t8.availability AS availability_13,
  t8.`condition` AS condition_14,
  t8.importable AS importable_15,
  t8.tax_transferable AS tax_transferable_16,
  t8.sale_count AS sale_count_17,
  t8.disabled_at AS disabled_at_18,
  t8.id AS id_19,
  t8.created_at AS created_at_20,
  t8.updated_at AS updated_at_21,
  t8.enabled AS enabled_22,
  t8.group_id AS group_id_23
FROM
  variant t0
  LEFT JOIN stock t8 ON t0.stock_id = t8.id
WHERE
  t0.stock_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.principal_image_id AS principal_image_id_5, t0.product_id AS product_id_6, t0.stock_id AS stock_id_7, t8.sku AS sku_9, t8.quantity AS quantity_10, t8.quantity_unit AS quantity_unit_11, t8.ean_code AS ean_code_12, t8.availability AS availability_13, t8.`condition` AS condition_14, t8.importable AS importable_15, t8.tax_transferable AS tax_transferable_16, t8.sale_count AS sale_count_17, t8.disabled_at AS disabled_at_18, t8.id AS id_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.enabled AS enabled_22, t8.group_id AS group_id_23 FROM variant t0 LEFT JOIN stock t8 ON t0.stock_id = t8.id WHERE t0.stock_id = 3758;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2444)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 438)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 170)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 744)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
11	Doctrine\ORM\EntityManager->find (line 86)
12	Doctrine\ORM\EntityRepository->find (line 61)
13	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 79)
14	App\Repository\SlugRepository->findContent (line 73)
15	App\Routing\RouteProvider->findContent (line 39)
16	App\Routing\RouteProvider->getRouteCollectionForRequest (line 97)
17	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
18	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
19	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
20	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
21	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
22	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.27 ms
(0.56%)

SELECT t0.code AS code_1, t0.title AS title_2, t0.description AS description_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM stock_group t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  stock_group t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.title AS title_2, t0.description AS description_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM stock_group t0 WHERE t0.id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\StockGroup::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\StockGroup->__get (line 49)
8	App\Entity\StockGroup->getCode (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 198)
10	__TwigTemplate_1c3024ce6dc170e606b9ddaba8137b8c->block_to_cart (line 446)
11	Twig\Template->yieldBlock (line 81)
12	__TwigTemplate_1c3024ce6dc170e606b9ddaba8137b8c->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 1520)
17	Twig\Extension\CoreExtension::include (line 118)
18	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->block_content (line 446)
19	Twig\Template->yieldBlock (line 428)
20	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->block_body (line 446)
21	Twig\Template->yieldBlock (line 531)
22	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->block_context (line 446)
23	Twig\Template->yieldBlock (line 155)
24	__TwigTemplate_7370bf4a9a545c88587dc7f5e69c20dc->doDisplay (line 402)
25	Twig\Template->yield (line 67)
26	__TwigTemplate_ac67665180b24e02fc3bd98d70fe3ec1->doDisplay (line 402)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_cebdb44706ea107bd9732c685a7bce42->doDisplay (line 402)
29	Twig\Template->yield (line 56)
30	__TwigTemplate_3942a16c5635c0f06a520f931ec7bcda->doDisplay (line 402)
31	Twig\Template->yield (line 358)
32	Twig\Template->display (line 373)
33	Twig\Template->render (line 51)
34	Twig\TemplateWrapper->render (line 333)
35	Twig\Environment->render (line 27)
36	App\Controller\Content\Product->show (line 181)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

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\MenuSk	413
App\Entity\CategoryTranslation	322
App\Entity\Category	320
App\Entity\Image	271
App\Entity\ImageTranslation	251
App\Entity\Stock	69
App\Entity\Variant	56
App\Entity\StockPrice	40
App\Entity\AttributeOptionTranslation	21
App\Entity\ProductTranslation	15
App\Entity\Product	13
App\Entity\AttributeOption	7
App\Entity\Store	6
App\Entity\VariantAttribute	6
App\Entity\TaxRate	5
App\User\Entity\User	4
App\Entity\VideoTranslation	4
App\Entity\Manufacturer	3
App\Entity\Attribute	3
App\Entity\AttributeTranslation	3
App\Entity\ProductImage	2
App\Entity\Slug	1
App\Entity\StockGroup	1
App\Entity\ProductAttribute	1
App\Entity\ProductCategory	1
App\Entity\Video	1

Entities Mapping

Class	Mapping errors
App\Entity\Store	No errors.
App\Entity\TaxRate	No errors.
App\Entity\Slug	No errors.
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\Image	No errors.
App\Entity\Manufacturer	No errors.
App\Entity\ProductClass	No errors.
App\Entity\Stock	No errors.
App\Entity\StockGroup	No errors.
App\Entity\ProductAccessory	No errors.
App\Entity\ProductAdvantage	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\ProductDocument	No errors.
App\Entity\ProductImage	No errors.
App\Entity\Variant	No errors.
App\Entity\Video	No errors.
App\Entity\ProductTranslation	No errors.
App\Entity\StockPrice	No errors.
App\Entity\StockPriceHistory	No errors.
App\Entity\ProductSet	No errors.
App\Entity\TaxTransferRule	No errors.
App\Entity\StockUpdateLog	No errors.
App\Entity\ProductClassTranslation	No errors.
App\User\Entity\User	No errors.
MsgPhp\User\Credential\EmailPassword	No errors.
App\Entity\Advantage	No errors.
App\Entity\AdvantageTranslation	No errors.
App\Entity\AdvantageGroup	No errors.
App\Entity\AdvantageGroupTranslation	No errors.
App\Entity\Attribute	No errors.
App\Entity\AttributeTranslation	No errors.
App\Entity\AttributeGroup	No errors.
App\Entity\AttributeGroupTranslation	No errors.
App\Entity\AttributeOption	No errors.
App\Entity\ProductAttributePrice	No errors.
App\Entity\ProductAttributePriceHistory	No errors.
App\Search\Entity\Filter	No errors.
App\Entity\ImageTranslation	No errors.
App\Entity\AttributeOptionTranslation	No errors.
App\Entity\VariantAttribute	No errors.
App\Entity\VariantImage	No errors.
App\Entity\CategoryTranslation	No errors.
App\Entity\CategoryDocument	No errors.
App\Entity\CategoryImage	No errors.
App\Search\Entity\CategoryFilter	No errors.
App\Entity\Document	No errors.
App\Entity\DocumentTranslation	No errors.
App\Entity\ProductClassImage	No errors.
App\Entity\ReferenceImage	No errors.
App\Entity\SliderImage	No errors.
App\Entity\Reference	No errors.
App\Entity\VideoTranslation	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuSk	No errors.
App\Entity\Customer	No errors.
App\User\Entity\UserRole	No errors.
App\Entity\Slider	No errors.
App\Entity\ReferenceTranslation	No errors.

Symfony Profiler

GET https://sandbox.dobraklima.sk/terma-basic-zaoblene-madlo

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping