Symfony Profiler

Query Metrics

287 Database Queries

22 Different statements

123.69 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

24.26 ms
(19.61%)

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p2_.titol AS titol_39, p2_.visible AS visible_40, p2_.datacreacio AS datacreacio_41, p2_.datamodificacio AS datamodificacio_42, p2_.slug AS slug_43, p3_.id AS id_44, p0_.marca AS marca_45, p0_.familia_id AS familia_id_46, p1_.product_id AS product_id_47, p3_.product_id AS product_id_48, p3_.category_id AS category_id_49 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id LEFT JOIN productos_marca p2_ ON p0_.marca = p2_.id INNER JOIN productos_apartats_ref p3_ ON p0_.id = p3_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p3_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p2_.id ORDER BY p2_.titol ASC, p1_.preubotiga ASC

Parameters:

[
  "1"
  "4"
  "5"
  "6"
  "2"
  "17"
  "72"
  "75"
  "76"
  "77"
  "24"
  "30"
  "31"
  "37"
  "41"
  "46"
  "32"
  "33"
  "34"
  "35"
  "71"
  "79"
  "44"
  "29"
  "47"
  "48"
  "49"
  "51"
  "74"
  "3"
  "80"
  "81"
  "8"
  "9"
  "10"
  "59"
  "70"
  "11"
  "12"
  "13"
  "14"
  "15"
  "16"
  "58"
  "63"
  "86"
  "18"
  "20"
  "19"
  "21"
  "22"
  "23"
  "25"
  "43"
  "36"
  "38"
  "39"
  "45"
  "40"
  "42"
  "56"
  "26"
  "27"
  "28"
  "50"
  "62"
  "82"
  "52"
  "53"
  "54"
  "55"
  "67"
  "60"
  "73"
  "64"
  "87"
  "88"
  "83"
  "84"
  "85"
  89
  90
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.datacreacio AS datacreacio_1,
  p0_.datamodificacio AS datamodificacio_2,
  p0_.visible AS visible_3,
  p0_.destacat AS destacat_4,
  p0_.premium AS premium_5,
  p0_.indexar AS indexar_6,
  p0_.ordre AS ordre_7,
  p0_.tipus_enllacat AS tipus_enllacat_8,
  p0_.type_stock AS type_stock_9,
  p0_.price_min AS price_min_10,
  p0_.price_max AS price_max_11,
  p1_.id AS id_12,
  p1_.ref AS ref_13,
  p1_.preubase AS preubase_14,
  p1_.preubotiga AS preubotiga_15,
  p1_.preuonline AS preuonline_16,
  p1_.preuonline2 AS preuonline2_17,
  p1_.preuonline3 AS preuonline3_18,
  p1_.oferta AS oferta_19,
  p1_.venda_online AS venda_online_20,
  p1_.preucost AS preucost_21,
  p1_.stock_infinit AS stock_infinit_22,
  p1_.stock_calculat_total AS stock_calculat_total_23,
  p1_.stock_calculat_online AS stock_calculat_online_24,
  p1_.stock_calculat_botiga AS stock_calculat_botiga_25,
  p1_.stock_minim AS stock_minim_26,
  p1_.weight AS weight_27,
  p1_.shipment_weight AS shipment_weight_28,
  p1_.length AS length_29,
  p1_.width AS width_30,
  p1_.height AS height_31,
  p1_.product_noapilable AS product_noapilable_32,
  p1_.product_normaa AS product_normaa_33,
  p1_.product_noencintable AS product_noencintable_34,
  p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35,
  p1_.plasticweight AS plasticweight_36,
  p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37,
  p2_.id AS id_38,
  p2_.titol AS titol_39,
  p2_.visible AS visible_40,
  p2_.datacreacio AS datacreacio_41,
  p2_.datamodificacio AS datamodificacio_42,
  p2_.slug AS slug_43,
  p3_.id AS id_44,
  p0_.marca AS marca_45,
  p0_.familia_id AS familia_id_46,
  p1_.product_id AS product_id_47,
  p3_.product_id AS product_id_48,
  p3_.category_id AS category_id_49
FROM
  productos p0_
  LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id
  LEFT JOIN productos_marca p2_ ON p0_.marca = p2_.id
  INNER JOIN productos_apartats_ref p3_ ON p0_.id = p3_.product_id
WHERE
  p0_.visible = 1
  AND p1_.venda_online <> 2
  AND p3_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )
GROUP BY
  p2_.id
ORDER BY
  p2_.titol ASC,
  p1_.preubotiga ASC

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p2_.titol AS titol_39, p2_.visible AS visible_40, p2_.datacreacio AS datacreacio_41, p2_.datamodificacio AS datamodificacio_42, p2_.slug AS slug_43, p3_.id AS id_44, p0_.marca AS marca_45, p0_.familia_id AS familia_id_46, p1_.product_id AS product_id_47, p3_.product_id AS product_id_48, p3_.category_id AS category_id_49 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id LEFT JOIN productos_marca p2_ ON p0_.marca = p2_.id INNER JOIN productos_apartats_ref p3_ ON p0_.id = p3_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p3_.category_id IN ('1', '4', '5', '6', '2', '17', '72', '75', '76', '77', '24', '30', '31', '37', '41', '46', '32', '33', '34', '35', '71', '79', '44', '29', '47', '48', '49', '51', '74', '3', '80', '81', '8', '9', '10', '59', '70', '11', '12', '13', '14', '15', '16', '58', '63', '86', '18', '20', '19', '21', '22', '23', '25', '43', '36', '38', '39', '45', '40', '42', '56', '26', '27', '28', '50', '62', '82', '52', '53', '54', '55', '67', '60', '73', '64', '87', '88', '83', '84', '85', 89, 90, 91) GROUP BY p2_.id ORDER BY p2_.titol ASC, p1_.preubotiga ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 211)
7	App\Repository\ProductRepository->findProductesCategoria (line 205)
8	App\Controller\Publica\ProductCategoryController->categoryDetail (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)

23.21 ms
(18.76%)

SELECT t0.id AS id_1, t0.titol AS titol_2, t0.des AS des_3, t0.text AS text_4, t0.info AS info_5, t0.titol_am AS titol_am_6, t0.keywords AS keywords_7, t0.product_id AS product_id_8, t0.language_id AS language_id_9 FROM productos_translation t0 WHERE t0.product_id = ?

Parameters:

[
  847
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titol AS titol_2,
  t0.des AS des_3,
  t0.text AS text_4,
  t0.info AS info_5,
  t0.titol_am AS titol_am_6,
  t0.keywords AS keywords_7,
  t0.product_id AS product_id_8,
  t0.language_id AS language_id_9
FROM
  productos_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.titol AS titol_2, t0.des AS des_3, t0.text AS text_4, t0.info AS info_5, t0.titol_am AS titol_am_6, t0.keywords AS keywords_7, t0.product_id AS product_id_8, t0.language_id AS language_id_9 FROM productos_translation t0 WHERE t0.product_id = 847;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 24)
8	App\Entity\TranslatableEntity->translation (line 216)
9	App\Entity\Product->translation (line 1882)
10	Twig\Extension\CoreExtension::getAttribute (line 48)
11	__TwigTemplate_4d54ddf303c2427896748c4fec81b72b->doDisplay (line 388)
12	Twig\Template->yield (line 287)
13	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->block_container (line 432)
14	Twig\Template->yieldBlock (line 322)
15	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
16	Twig\Template->yieldBlock (line 477)
17	Twig\Template->yieldParentBlock (line 379)
18	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
19	Twig\Template->yieldBlock (line 110)
20	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
21	Twig\Template->yield (line 66)
22	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->doDisplay (line 388)
25	Twig\Template->yield (line 344)
26	Twig\Template->display (line 359)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 334)
29	Twig\Environment->render (line 448)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 309)
33	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

17.91 ms
(14.48%)

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.visiblecolproducte AS visiblecolproducte_5, t0.menusdesplegat AS menusdesplegat_6, t0.menucapdesplegat AS menucapdesplegat_7, t0.numvisites AS numvisites_8, t0.indexar AS indexar_9, t0.ordre AS ordre_10, t0.categorychildren AS categorychildren_11, t0.parent_id AS parent_id_12 FROM apartats t0 WHERE t0.parent_id = ? ORDER BY t0.ordre ASC

Parameters:

[
  89
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.visible AS visible_4,
  t0.visiblecolproducte AS visiblecolproducte_5,
  t0.menusdesplegat AS menusdesplegat_6,
  t0.menucapdesplegat AS menucapdesplegat_7,
  t0.numvisites AS numvisites_8,
  t0.indexar AS indexar_9,
  t0.ordre AS ordre_10,
  t0.categorychildren AS categorychildren_11,
  t0.parent_id AS parent_id_12
FROM
  apartats t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.visiblecolproducte AS visiblecolproducte_5, t0.menusdesplegat AS menusdesplegat_6, t0.menucapdesplegat AS menucapdesplegat_7, t0.numvisites AS numvisites_8, t0.indexar AS indexar_9, t0.ordre AS ordre_10, t0.categorychildren AS categorychildren_11, t0.parent_id AS parent_id_12 FROM apartats t0 WHERE t0.parent_id = 89 ORDER BY t0.ordre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 384)
8	App\Entity\ProductCategory->getPublicChildren (line 231)
9	App\Service\CategoryHelperService->constructMenuCategoriesArray (line 183)
10	App\Service\CategoryHelperService->App\Service\{closure} (line 48)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
12	Symfony\Component\Cache\LockRegistry::compute (line 104)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
17	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 184)
18	App\Service\CategoryHelperService->getMenuCategoriesArray (line 299)
19	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
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)

17.87 ms
(14.44%)

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.datacreacio AS datacreacio_3, t0.datamodificacio AS datamodificacio_4, t0.photo AS photo_5, t0.visible AS visible_6, t0.idpare AS idpare_7 FROM productos_photos t0 WHERE t0.idpare = ? ORDER BY t0.ordre ASC

Parameters:

[
  847
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.datacreacio AS datacreacio_3,
  t0.datamodificacio AS datamodificacio_4,
  t0.photo AS photo_5,
  t0.visible AS visible_6,
  t0.idpare AS idpare_7
FROM
  productos_photos t0
WHERE
  t0.idpare = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.datacreacio AS datacreacio_3, t0.datamodificacio AS datamodificacio_4, t0.photo AS photo_5, t0.visible AS visible_6, t0.idpare AS idpare_7 FROM productos_photos t0 WHERE t0.idpare = 847 ORDER BY t0.ordre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1)
9	count (line 409)
10	App\Entity\Product->getImage (line 1882)
11	Twig\Extension\CoreExtension::getAttribute (line 69)
12	__TwigTemplate_4d54ddf303c2427896748c4fec81b72b->doDisplay (line 388)
13	Twig\Template->yield (line 287)
14	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->block_container (line 432)
15	Twig\Template->yieldBlock (line 322)
16	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
17	Twig\Template->yieldBlock (line 477)
18	Twig\Template->yieldParentBlock (line 379)
19	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
20	Twig\Template->yieldBlock (line 110)
21	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
22	Twig\Template->yield (line 66)
23	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->doDisplay (line 388)
26	Twig\Template->yield (line 344)
27	Twig\Template->display (line 359)
28	Twig\Template->render (line 51)
29	Twig\TemplateWrapper->render (line 334)
30	Twig\Environment->render (line 448)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 309)
34	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

16.50 ms
(13.34%)

SELECT t0.id AS id_1, t0.titol AS titol_2, t0.text AS text_3, t0.des AS des_4, t0.info AS info_5, t0.titol_am AS titol_am_6, t0.keywords AS keywords_7, t0.apartat_id AS apartat_id_8, t0.language_id AS language_id_9 FROM apartats_translation t0 WHERE t0.apartat_id = ?

Parameters:

[
  89
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titol AS titol_2,
  t0.text AS text_3,
  t0.des AS des_4,
  t0.info AS info_5,
  t0.titol_am AS titol_am_6,
  t0.keywords AS keywords_7,
  t0.apartat_id AS apartat_id_8,
  t0.language_id AS language_id_9
FROM
  apartats_translation t0
WHERE
  t0.apartat_id = ?

SELECT t0.id AS id_1, t0.titol AS titol_2, t0.text AS text_3, t0.des AS des_4, t0.info AS info_5, t0.titol_am AS titol_am_6, t0.keywords AS keywords_7, t0.apartat_id AS apartat_id_8, t0.language_id AS language_id_9 FROM apartats_translation t0 WHERE t0.apartat_id = 89;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 204)
8	App\Service\CategoryHelperService->constructMenuCategoriesArray (line 183)
9	App\Service\CategoryHelperService->App\Service\{closure} (line 48)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
11	Symfony\Component\Cache\LockRegistry::compute (line 104)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
16	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 184)
17	App\Service\CategoryHelperService->getMenuCategoriesArray (line 299)
18	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

7.52 ms
(6.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.codi_pais = ? LIMIT 1

Parameters:

[
  "ES"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sendable AS sendable_3,
  t0.preuEnvioGratis AS preuEnvioGratis_4,
  t0.preu_apilable AS preu_apilable_5,
  t0.preu_no_encintable AS preu_no_encintable_6,
  t0.preu_fuera_norma_a AS preu_fuera_norma_a_7,
  t0.textshipment AS textshipment_8,
  t0.textinfoshipment AS textinfoshipment_9,
  t0.displaycetelem AS displaycetelem_10,
  t0.codi_pais AS codi_pais_11,
  t0.grams_max_product AS grams_max_product_12,
  t0.pot_sortir_dandorra AS pot_sortir_dandorra_13,
  t0.principal AS principal_14,
  t0.empresa_id AS empresa_id_15,
  t0.idioma_id AS idioma_id_16
FROM
  paisos t0
WHERE
  t0.codi_pais = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.codi_pais = 'ES' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 378)
4	App\Service\ProductHelperService->preuProducte (line 82)
5	App\Twig\PublicExtension->preuProducte (line 55)
6	__TwigTemplate_4d54ddf303c2427896748c4fec81b72b->doDisplay (line 388)
7	Twig\Template->yield (line 287)
8	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->block_container (line 432)
9	Twig\Template->yieldBlock (line 322)
10	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
11	Twig\Template->yieldBlock (line 477)
12	Twig\Template->yieldParentBlock (line 379)
13	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
14	Twig\Template->yieldBlock (line 110)
15	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
16	Twig\Template->yield (line 66)
17	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->doDisplay (line 388)
20	Twig\Template->yield (line 344)
21	Twig\Template->display (line 359)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 334)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 309)
28	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

3.42 ms
(2.76%)

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p0_.marca AS marca_39, p0_.familia_id AS familia_id_40, p1_.product_id AS product_id_41, p2_.product_id AS product_id_42, p2_.category_id AS category_id_43 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.destacat <> 0 GROUP BY p0_.id ORDER BY p0_.type_stock ASC, p0_.datamodificacio DESC, p1_.preubotiga ASC LIMIT 8

Parameters:

[
  "1"
  "4"
  "5"
  "6"
  "2"
  "17"
  "72"
  "75"
  "76"
  "77"
  "24"
  "30"
  "31"
  "37"
  "41"
  "46"
  "32"
  "33"
  "34"
  "35"
  "71"
  "79"
  "44"
  "29"
  "47"
  "48"
  "49"
  "51"
  "74"
  "3"
  "80"
  "81"
  "8"
  "9"
  "10"
  "59"
  "70"
  "11"
  "12"
  "13"
  "14"
  "15"
  "16"
  "58"
  "63"
  "86"
  "18"
  "20"
  "19"
  "21"
  "22"
  "23"
  "25"
  "43"
  "36"
  "38"
  "39"
  "45"
  "40"
  "42"
  "56"
  "26"
  "27"
  "28"
  "50"
  "62"
  "82"
  "52"
  "53"
  "54"
  "55"
  "67"
  "60"
  "73"
  "64"
  "87"
  "88"
  "83"
  "84"
  "85"
  89
  90
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.datacreacio AS datacreacio_1,
  p0_.datamodificacio AS datamodificacio_2,
  p0_.visible AS visible_3,
  p0_.destacat AS destacat_4,
  p0_.premium AS premium_5,
  p0_.indexar AS indexar_6,
  p0_.ordre AS ordre_7,
  p0_.tipus_enllacat AS tipus_enllacat_8,
  p0_.type_stock AS type_stock_9,
  p0_.price_min AS price_min_10,
  p0_.price_max AS price_max_11,
  p1_.id AS id_12,
  p1_.ref AS ref_13,
  p1_.preubase AS preubase_14,
  p1_.preubotiga AS preubotiga_15,
  p1_.preuonline AS preuonline_16,
  p1_.preuonline2 AS preuonline2_17,
  p1_.preuonline3 AS preuonline3_18,
  p1_.oferta AS oferta_19,
  p1_.venda_online AS venda_online_20,
  p1_.preucost AS preucost_21,
  p1_.stock_infinit AS stock_infinit_22,
  p1_.stock_calculat_total AS stock_calculat_total_23,
  p1_.stock_calculat_online AS stock_calculat_online_24,
  p1_.stock_calculat_botiga AS stock_calculat_botiga_25,
  p1_.stock_minim AS stock_minim_26,
  p1_.weight AS weight_27,
  p1_.shipment_weight AS shipment_weight_28,
  p1_.length AS length_29,
  p1_.width AS width_30,
  p1_.height AS height_31,
  p1_.product_noapilable AS product_noapilable_32,
  p1_.product_normaa AS product_normaa_33,
  p1_.product_noencintable AS product_noencintable_34,
  p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35,
  p1_.plasticweight AS plasticweight_36,
  p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37,
  p2_.id AS id_38,
  p0_.marca AS marca_39,
  p0_.familia_id AS familia_id_40,
  p1_.product_id AS product_id_41,
  p2_.product_id AS product_id_42,
  p2_.category_id AS category_id_43
FROM
  productos p0_
  LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id
  INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id
WHERE
  p0_.visible = 1
  AND p1_.venda_online <> 2
  AND p2_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )
  AND p0_.destacat <> 0
GROUP BY
  p0_.id
ORDER BY
  p0_.type_stock ASC,
  p0_.datamodificacio DESC,
  p1_.preubotiga ASC
LIMIT
  8

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p0_.marca AS marca_39, p0_.familia_id AS familia_id_40, p1_.product_id AS product_id_41, p2_.product_id AS product_id_42, p2_.category_id AS category_id_43 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN ('1', '4', '5', '6', '2', '17', '72', '75', '76', '77', '24', '30', '31', '37', '41', '46', '32', '33', '34', '35', '71', '79', '44', '29', '47', '48', '49', '51', '74', '3', '80', '81', '8', '9', '10', '59', '70', '11', '12', '13', '14', '15', '16', '58', '63', '86', '18', '20', '19', '21', '22', '23', '25', '43', '36', '38', '39', '45', '40', '42', '56', '26', '27', '28', '50', '62', '82', '52', '53', '54', '55', '67', '60', '73', '64', '87', '88', '83', '84', '85', 89, 90, 91) AND p0_.destacat <> 0 GROUP BY p0_.id ORDER BY p0_.type_stock ASC, p0_.datamodificacio DESC, p1_.preubotiga ASC LIMIT 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 211)
7	App\Repository\ProductRepository->findProductesCategoria (line 275)
8	App\Controller\Publica\ProductCategoryController->categoryDetail (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)

2.73 ms
(2.21%)

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p0_.marca AS marca_39, p0_.familia_id AS familia_id_40, p1_.product_id AS product_id_41, p2_.product_id AS product_id_42, p2_.category_id AS category_id_43 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.premium <> 0 GROUP BY p0_.id ORDER BY p0_.type_stock ASC, p0_.datamodificacio DESC, p1_.preubotiga ASC LIMIT 8

Parameters:

[
  "1"
  "4"
  "5"
  "6"
  "2"
  "17"
  "72"
  "75"
  "76"
  "77"
  "24"
  "30"
  "31"
  "37"
  "41"
  "46"
  "32"
  "33"
  "34"
  "35"
  "71"
  "79"
  "44"
  "29"
  "47"
  "48"
  "49"
  "51"
  "74"
  "3"
  "80"
  "81"
  "8"
  "9"
  "10"
  "59"
  "70"
  "11"
  "12"
  "13"
  "14"
  "15"
  "16"
  "58"
  "63"
  "86"
  "18"
  "20"
  "19"
  "21"
  "22"
  "23"
  "25"
  "43"
  "36"
  "38"
  "39"
  "45"
  "40"
  "42"
  "56"
  "26"
  "27"
  "28"
  "50"
  "62"
  "82"
  "52"
  "53"
  "54"
  "55"
  "67"
  "60"
  "73"
  "64"
  "87"
  "88"
  "83"
  "84"
  "85"
  89
  90
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.datacreacio AS datacreacio_1,
  p0_.datamodificacio AS datamodificacio_2,
  p0_.visible AS visible_3,
  p0_.destacat AS destacat_4,
  p0_.premium AS premium_5,
  p0_.indexar AS indexar_6,
  p0_.ordre AS ordre_7,
  p0_.tipus_enllacat AS tipus_enllacat_8,
  p0_.type_stock AS type_stock_9,
  p0_.price_min AS price_min_10,
  p0_.price_max AS price_max_11,
  p1_.id AS id_12,
  p1_.ref AS ref_13,
  p1_.preubase AS preubase_14,
  p1_.preubotiga AS preubotiga_15,
  p1_.preuonline AS preuonline_16,
  p1_.preuonline2 AS preuonline2_17,
  p1_.preuonline3 AS preuonline3_18,
  p1_.oferta AS oferta_19,
  p1_.venda_online AS venda_online_20,
  p1_.preucost AS preucost_21,
  p1_.stock_infinit AS stock_infinit_22,
  p1_.stock_calculat_total AS stock_calculat_total_23,
  p1_.stock_calculat_online AS stock_calculat_online_24,
  p1_.stock_calculat_botiga AS stock_calculat_botiga_25,
  p1_.stock_minim AS stock_minim_26,
  p1_.weight AS weight_27,
  p1_.shipment_weight AS shipment_weight_28,
  p1_.length AS length_29,
  p1_.width AS width_30,
  p1_.height AS height_31,
  p1_.product_noapilable AS product_noapilable_32,
  p1_.product_normaa AS product_normaa_33,
  p1_.product_noencintable AS product_noencintable_34,
  p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35,
  p1_.plasticweight AS plasticweight_36,
  p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37,
  p2_.id AS id_38,
  p0_.marca AS marca_39,
  p0_.familia_id AS familia_id_40,
  p1_.product_id AS product_id_41,
  p2_.product_id AS product_id_42,
  p2_.category_id AS category_id_43
FROM
  productos p0_
  LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id
  INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id
WHERE
  p0_.visible = 1
  AND p1_.venda_online <> 2
  AND p2_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )
  AND p0_.premium <> 0
GROUP BY
  p0_.id
ORDER BY
  p0_.type_stock ASC,
  p0_.datamodificacio DESC,
  p1_.preubotiga ASC
LIMIT
  8

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p0_.marca AS marca_39, p0_.familia_id AS familia_id_40, p1_.product_id AS product_id_41, p2_.product_id AS product_id_42, p2_.category_id AS category_id_43 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN ('1', '4', '5', '6', '2', '17', '72', '75', '76', '77', '24', '30', '31', '37', '41', '46', '32', '33', '34', '35', '71', '79', '44', '29', '47', '48', '49', '51', '74', '3', '80', '81', '8', '9', '10', '59', '70', '11', '12', '13', '14', '15', '16', '58', '63', '86', '18', '20', '19', '21', '22', '23', '25', '43', '36', '38', '39', '45', '40', '42', '56', '26', '27', '28', '50', '62', '82', '52', '53', '54', '55', '67', '60', '73', '64', '87', '88', '83', '84', '85', 89, 90, 91) AND p0_.premium <> 0 GROUP BY p0_.id ORDER BY p0_.type_stock ASC, p0_.datamodificacio DESC, p1_.preubotiga ASC LIMIT 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 211)
7	App\Repository\ProductRepository->findProductesCategoria (line 267)
8	App\Controller\Publica\ProductCategoryController->categoryDetail (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)

2.49 ms
(2.01%)

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p0_.marca AS marca_39, p0_.familia_id AS familia_id_40, p1_.product_id AS product_id_41, p2_.product_id AS product_id_42, p2_.category_id AS category_id_43 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p0_.id ORDER BY p0_.type_stock ASC, p0_.datamodificacio DESC, p1_.preubotiga ASC LIMIT 20

Parameters:

[
  "1"
  "4"
  "5"
  "6"
  "2"
  "17"
  "72"
  "75"
  "76"
  "77"
  "24"
  "30"
  "31"
  "37"
  "41"
  "46"
  "32"
  "33"
  "34"
  "35"
  "71"
  "79"
  "44"
  "29"
  "47"
  "48"
  "49"
  "51"
  "74"
  "3"
  "80"
  "81"
  "8"
  "9"
  "10"
  "59"
  "70"
  "11"
  "12"
  "13"
  "14"
  "15"
  "16"
  "58"
  "63"
  "86"
  "18"
  "20"
  "19"
  "21"
  "22"
  "23"
  "25"
  "43"
  "36"
  "38"
  "39"
  "45"
  "40"
  "42"
  "56"
  "26"
  "27"
  "28"
  "50"
  "62"
  "82"
  "52"
  "53"
  "54"
  "55"
  "67"
  "60"
  "73"
  "64"
  "87"
  "88"
  "83"
  "84"
  "85"
  89
  90
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.datacreacio AS datacreacio_1,
  p0_.datamodificacio AS datamodificacio_2,
  p0_.visible AS visible_3,
  p0_.destacat AS destacat_4,
  p0_.premium AS premium_5,
  p0_.indexar AS indexar_6,
  p0_.ordre AS ordre_7,
  p0_.tipus_enllacat AS tipus_enllacat_8,
  p0_.type_stock AS type_stock_9,
  p0_.price_min AS price_min_10,
  p0_.price_max AS price_max_11,
  p1_.id AS id_12,
  p1_.ref AS ref_13,
  p1_.preubase AS preubase_14,
  p1_.preubotiga AS preubotiga_15,
  p1_.preuonline AS preuonline_16,
  p1_.preuonline2 AS preuonline2_17,
  p1_.preuonline3 AS preuonline3_18,
  p1_.oferta AS oferta_19,
  p1_.venda_online AS venda_online_20,
  p1_.preucost AS preucost_21,
  p1_.stock_infinit AS stock_infinit_22,
  p1_.stock_calculat_total AS stock_calculat_total_23,
  p1_.stock_calculat_online AS stock_calculat_online_24,
  p1_.stock_calculat_botiga AS stock_calculat_botiga_25,
  p1_.stock_minim AS stock_minim_26,
  p1_.weight AS weight_27,
  p1_.shipment_weight AS shipment_weight_28,
  p1_.length AS length_29,
  p1_.width AS width_30,
  p1_.height AS height_31,
  p1_.product_noapilable AS product_noapilable_32,
  p1_.product_normaa AS product_normaa_33,
  p1_.product_noencintable AS product_noencintable_34,
  p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35,
  p1_.plasticweight AS plasticweight_36,
  p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37,
  p2_.id AS id_38,
  p0_.marca AS marca_39,
  p0_.familia_id AS familia_id_40,
  p1_.product_id AS product_id_41,
  p2_.product_id AS product_id_42,
  p2_.category_id AS category_id_43
FROM
  productos p0_
  LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id
  INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id
WHERE
  p0_.visible = 1
  AND p1_.venda_online <> 2
  AND p2_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )
GROUP BY
  p0_.id
ORDER BY
  p0_.type_stock ASC,
  p0_.datamodificacio DESC,
  p1_.preubotiga ASC
LIMIT
  20

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p0_.marca AS marca_39, p0_.familia_id AS familia_id_40, p1_.product_id AS product_id_41, p2_.product_id AS product_id_42, p2_.category_id AS category_id_43 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN ('1', '4', '5', '6', '2', '17', '72', '75', '76', '77', '24', '30', '31', '37', '41', '46', '32', '33', '34', '35', '71', '79', '44', '29', '47', '48', '49', '51', '74', '3', '80', '81', '8', '9', '10', '59', '70', '11', '12', '13', '14', '15', '16', '58', '63', '86', '18', '20', '19', '21', '22', '23', '25', '43', '36', '38', '39', '45', '40', '42', '56', '26', '27', '28', '50', '62', '82', '52', '53', '54', '55', '67', '60', '73', '64', '87', '88', '83', '84', '85', 89, 90, 91) GROUP BY p0_.id ORDER BY p0_.type_stock ASC, p0_.datamodificacio DESC, p1_.preubotiga ASC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 211)
7	App\Repository\ProductRepository->findProductesCategoria (line 239)
8	App\Controller\Publica\ProductCategoryController->categoryDetail (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)

2.14 ms
(1.73%)

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p0_.marca AS marca_39, p0_.familia_id AS familia_id_40, p1_.product_id AS product_id_41, p2_.product_id AS product_id_42, p2_.category_id AS category_id_43 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p1_.oferta <> 0 GROUP BY p0_.id ORDER BY p0_.type_stock ASC, p0_.datamodificacio DESC, p1_.preubotiga ASC LIMIT 8

Parameters:

[
  "1"
  "4"
  "5"
  "6"
  "2"
  "17"
  "72"
  "75"
  "76"
  "77"
  "24"
  "30"
  "31"
  "37"
  "41"
  "46"
  "32"
  "33"
  "34"
  "35"
  "71"
  "79"
  "44"
  "29"
  "47"
  "48"
  "49"
  "51"
  "74"
  "3"
  "80"
  "81"
  "8"
  "9"
  "10"
  "59"
  "70"
  "11"
  "12"
  "13"
  "14"
  "15"
  "16"
  "58"
  "63"
  "86"
  "18"
  "20"
  "19"
  "21"
  "22"
  "23"
  "25"
  "43"
  "36"
  "38"
  "39"
  "45"
  "40"
  "42"
  "56"
  "26"
  "27"
  "28"
  "50"
  "62"
  "82"
  "52"
  "53"
  "54"
  "55"
  "67"
  "60"
  "73"
  "64"
  "87"
  "88"
  "83"
  "84"
  "85"
  89
  90
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.datacreacio AS datacreacio_1,
  p0_.datamodificacio AS datamodificacio_2,
  p0_.visible AS visible_3,
  p0_.destacat AS destacat_4,
  p0_.premium AS premium_5,
  p0_.indexar AS indexar_6,
  p0_.ordre AS ordre_7,
  p0_.tipus_enllacat AS tipus_enllacat_8,
  p0_.type_stock AS type_stock_9,
  p0_.price_min AS price_min_10,
  p0_.price_max AS price_max_11,
  p1_.id AS id_12,
  p1_.ref AS ref_13,
  p1_.preubase AS preubase_14,
  p1_.preubotiga AS preubotiga_15,
  p1_.preuonline AS preuonline_16,
  p1_.preuonline2 AS preuonline2_17,
  p1_.preuonline3 AS preuonline3_18,
  p1_.oferta AS oferta_19,
  p1_.venda_online AS venda_online_20,
  p1_.preucost AS preucost_21,
  p1_.stock_infinit AS stock_infinit_22,
  p1_.stock_calculat_total AS stock_calculat_total_23,
  p1_.stock_calculat_online AS stock_calculat_online_24,
  p1_.stock_calculat_botiga AS stock_calculat_botiga_25,
  p1_.stock_minim AS stock_minim_26,
  p1_.weight AS weight_27,
  p1_.shipment_weight AS shipment_weight_28,
  p1_.length AS length_29,
  p1_.width AS width_30,
  p1_.height AS height_31,
  p1_.product_noapilable AS product_noapilable_32,
  p1_.product_normaa AS product_normaa_33,
  p1_.product_noencintable AS product_noencintable_34,
  p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35,
  p1_.plasticweight AS plasticweight_36,
  p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37,
  p2_.id AS id_38,
  p0_.marca AS marca_39,
  p0_.familia_id AS familia_id_40,
  p1_.product_id AS product_id_41,
  p2_.product_id AS product_id_42,
  p2_.category_id AS category_id_43
FROM
  productos p0_
  LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id
  INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id
WHERE
  p0_.visible = 1
  AND p1_.venda_online <> 2
  AND p2_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )
  AND p1_.oferta <> 0
GROUP BY
  p0_.id
ORDER BY
  p0_.type_stock ASC,
  p0_.datamodificacio DESC,
  p1_.preubotiga ASC
LIMIT
  8

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p0_.marca AS marca_39, p0_.familia_id AS familia_id_40, p1_.product_id AS product_id_41, p2_.product_id AS product_id_42, p2_.category_id AS category_id_43 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN ('1', '4', '5', '6', '2', '17', '72', '75', '76', '77', '24', '30', '31', '37', '41', '46', '32', '33', '34', '35', '71', '79', '44', '29', '47', '48', '49', '51', '74', '3', '80', '81', '8', '9', '10', '59', '70', '11', '12', '13', '14', '15', '16', '58', '63', '86', '18', '20', '19', '21', '22', '23', '25', '43', '36', '38', '39', '45', '40', '42', '56', '26', '27', '28', '50', '62', '82', '52', '53', '54', '55', '67', '60', '73', '64', '87', '88', '83', '84', '85', 89, 90, 91) AND p1_.oferta <> 0 GROUP BY p0_.id ORDER BY p0_.type_stock ASC, p0_.datamodificacio DESC, p1_.preubotiga ASC LIMIT 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 211)
7	App\Repository\ProductRepository->findProductesCategoria (line 259)
8	App\Controller\Publica\ProductCategoryController->categoryDetail (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
(1.11%)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM productos p0_ INNER JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "1"
  "4"
  "5"
  "6"
  "2"
  "17"
  "72"
  "75"
  "76"
  "77"
  "24"
  "30"
  "31"
  "37"
  "41"
  "46"
  "32"
  "33"
  "34"
  "35"
  "71"
  "79"
  "44"
  "29"
  "47"
  "48"
  "49"
  "51"
  "74"
  "3"
  "80"
  "81"
  "8"
  "9"
  "10"
  "59"
  "70"
  "11"
  "12"
  "13"
  "14"
  "15"
  "16"
  "58"
  "63"
  "86"
  "18"
  "20"
  "19"
  "21"
  "22"
  "23"
  "25"
  "43"
  "36"
  "38"
  "39"
  "45"
  "40"
  "42"
  "56"
  "26"
  "27"
  "28"
  "50"
  "62"
  "82"
  "52"
  "53"
  "54"
  "55"
  "67"
  "60"
  "73"
  "64"
  "87"
  "88"
  "83"
  "84"
  "85"
  89
  90
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  productos p0_
  INNER JOIN productos_preu p1_ ON p0_.id = p1_.product_id
  INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id
WHERE
  p0_.visible = 1
  AND p1_.venda_online <> 2
  AND p2_.category_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM productos p0_ INNER JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN ('1', '4', '5', '6', '2', '17', '72', '75', '76', '77', '24', '30', '31', '37', '41', '46', '32', '33', '34', '35', '71', '79', '44', '29', '47', '48', '49', '51', '74', '3', '80', '81', '8', '9', '10', '59', '70', '11', '12', '13', '14', '15', '16', '58', '63', '86', '18', '20', '19', '21', '22', '23', '25', '43', '36', '38', '39', '45', '40', '42', '56', '26', '27', '28', '50', '62', '82', '52', '53', '54', '55', '67', '60', '73', '64', '87', '88', '83', '84', '85', 89, 90, 91);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 290)
8	App\Repository\ProductRepository->totalProductesCategoria (line 220)
9	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.73 ms
(0.59%)

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.visiblecolproducte AS visiblecolproducte_5, t0.menusdesplegat AS menusdesplegat_6, t0.menucapdesplegat AS menucapdesplegat_7, t0.numvisites AS numvisites_8, t0.indexar AS indexar_9, t0.ordre AS ordre_10, t0.categorychildren AS categorychildren_11, t0.parent_id AS parent_id_12 FROM apartats t0 WHERE t0.parent_id IS NULL AND t0.visible = ? AND t0.visiblecolproducte = ? ORDER BY t0.ordre ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.visible AS visible_4,
  t0.visiblecolproducte AS visiblecolproducte_5,
  t0.menusdesplegat AS menusdesplegat_6,
  t0.menucapdesplegat AS menucapdesplegat_7,
  t0.numvisites AS numvisites_8,
  t0.indexar AS indexar_9,
  t0.ordre AS ordre_10,
  t0.categorychildren AS categorychildren_11,
  t0.parent_id AS parent_id_12
FROM
  apartats t0
WHERE
  t0.parent_id IS NULL
  AND t0.visible = ?
  AND t0.visiblecolproducte = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.visiblecolproducte AS visiblecolproducte_5, t0.menusdesplegat AS menusdesplegat_6, t0.menucapdesplegat AS menucapdesplegat_7, t0.numvisites AS numvisites_8, t0.indexar AS indexar_9, t0.ordre AS ordre_10, t0.categorychildren AS categorychildren_11, t0.parent_id AS parent_id_12 FROM apartats t0 WHERE t0.parent_id IS NULL AND t0.visible = 1 AND t0.visiblecolproducte = 1 ORDER BY t0.ordre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 198)
4	App\Service\CategoryHelperService->constructMenuCategoriesArray (line 183)
5	App\Service\CategoryHelperService->App\Service\{closure} (line 48)
6	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
7	Symfony\Component\Cache\LockRegistry::compute (line 104)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
12	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 184)
13	App\Service\CategoryHelperService->getMenuCategoriesArray (line 299)
14	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
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.64 ms
(0.52%)

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.datacreacio AS datacreacio_3, t0.datamodificacio AS datamodificacio_4, t0.photo AS photo_5, t0.visible AS visible_6, t0.idpare AS idpare_7 FROM apartats_photos t0 WHERE t0.idpare = ? ORDER BY t0.ordre ASC

Parameters:

[
  89
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.datacreacio AS datacreacio_3,
  t0.datamodificacio AS datamodificacio_4,
  t0.photo AS photo_5,
  t0.visible AS visible_6,
  t0.idpare AS idpare_7
FROM
  apartats_photos t0
WHERE
  t0.idpare = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.datacreacio AS datacreacio_3, t0.datamodificacio AS datamodificacio_4, t0.photo AS photo_5, t0.visible AS visible_6, t0.idpare AS idpare_7 FROM apartats_photos t0 WHERE t0.idpare = 89 ORDER BY t0.ordre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1)
9	count (line 332)
10	App\Entity\ProductCategory->getImage (line 1882)
11	Twig\Extension\CoreExtension::getAttribute (line 64)
12	__TwigTemplate_fcbe5d88298af23d43b60facab016902->doDisplay (line 388)
13	Twig\Template->yield (line 224)
14	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->block_container (line 432)
15	Twig\Template->yieldBlock (line 322)
16	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
17	Twig\Template->yieldBlock (line 477)
18	Twig\Template->yieldParentBlock (line 379)
19	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
20	Twig\Template->yieldBlock (line 110)
21	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
22	Twig\Template->yield (line 66)
23	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->doDisplay (line 388)
26	Twig\Template->yield (line 344)
27	Twig\Template->display (line 359)
28	Twig\Template->render (line 51)
29	Twig\TemplateWrapper->render (line 334)
30	Twig\Environment->render (line 448)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 309)
34	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

0.61 ms
(0.50%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_intern AS nom_intern_3, t0.nif AS nif_4, t0.adreca AS adreca_5, t0.adreca2 AS adreca2_6, t0.codi_postal AS codi_postal_7, t0.poblacio AS poblacio_8, t0.provincia AS provincia_9, t0.pais AS pais_10, t0.telf_empresa AS telf_empresa_11, t0.mail AS mail_12, t0.iva AS iva_13, t0.nom_impost AS nom_impost_14, t0.lletra_factura AS lletra_factura_15, t0.lletra_factura_simplificada AS lletra_factura_simplificada_16, t0.mail_contacto AS mail_contacto_17, t0.dades_factura AS dades_factura_18, t0.traspasinici AS traspasinici_19, t0.traspasfinal AS traspasfinal_20, t0.sii_enviar_factures AS sii_enviar_factures_21, t0.sii_codi_pais AS sii_codi_pais_22, t0.sii_entregues_exportacions_intracomunitaries AS sii_entregues_exportacions_intracomunitaries_23, t0.proveidor AS proveidor_24, t0.quin_preu_base_online AS quin_preu_base_online_25, t0.mostrar_impost AS mostrar_impost_26, t0.traspas AS traspas_27, t0.stockhouse_id AS stockhouse_id_28, t0.tpv_type_id AS tpv_type_id_29 FROM empresa t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_intern AS nom_intern_3,
  t0.nif AS nif_4,
  t0.adreca AS adreca_5,
  t0.adreca2 AS adreca2_6,
  t0.codi_postal AS codi_postal_7,
  t0.poblacio AS poblacio_8,
  t0.provincia AS provincia_9,
  t0.pais AS pais_10,
  t0.telf_empresa AS telf_empresa_11,
  t0.mail AS mail_12,
  t0.iva AS iva_13,
  t0.nom_impost AS nom_impost_14,
  t0.lletra_factura AS lletra_factura_15,
  t0.lletra_factura_simplificada AS lletra_factura_simplificada_16,
  t0.mail_contacto AS mail_contacto_17,
  t0.dades_factura AS dades_factura_18,
  t0.traspasinici AS traspasinici_19,
  t0.traspasfinal AS traspasfinal_20,
  t0.sii_enviar_factures AS sii_enviar_factures_21,
  t0.sii_codi_pais AS sii_codi_pais_22,
  t0.sii_entregues_exportacions_intracomunitaries AS sii_entregues_exportacions_intracomunitaries_23,
  t0.proveidor AS proveidor_24,
  t0.quin_preu_base_online AS quin_preu_base_online_25,
  t0.mostrar_impost AS mostrar_impost_26,
  t0.traspas AS traspas_27,
  t0.stockhouse_id AS stockhouse_id_28,
  t0.tpv_type_id AS tpv_type_id_29
FROM
  empresa t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_intern AS nom_intern_3, t0.nif AS nif_4, t0.adreca AS adreca_5, t0.adreca2 AS adreca2_6, t0.codi_postal AS codi_postal_7, t0.poblacio AS poblacio_8, t0.provincia AS provincia_9, t0.pais AS pais_10, t0.telf_empresa AS telf_empresa_11, t0.mail AS mail_12, t0.iva AS iva_13, t0.nom_impost AS nom_impost_14, t0.lletra_factura AS lletra_factura_15, t0.lletra_factura_simplificada AS lletra_factura_simplificada_16, t0.mail_contacto AS mail_contacto_17, t0.dades_factura AS dades_factura_18, t0.traspasinici AS traspasinici_19, t0.traspasfinal AS traspasfinal_20, t0.sii_enviar_factures AS sii_enviar_factures_21, t0.sii_codi_pais AS sii_codi_pais_22, t0.sii_entregues_exportacions_intracomunitaries AS sii_entregues_exportacions_intracomunitaries_23, t0.proveidor AS proveidor_24, t0.quin_preu_base_online AS quin_preu_base_online_25, t0.mostrar_impost AS mostrar_impost_26, t0.traspas AS traspas_27, t0.stockhouse_id AS stockhouse_id_28, t0.tpv_type_id AS tpv_type_id_29 FROM empresa t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 74)
6	App\Entity\Shop\ShopCart::fromSession (line 71)
7	App\Service\ShoppingCartService->__construct (line 1451)
8	ContainerP8M7PF8\App_KernelDevDebugContainer::getShoppingCartServiceService (line 2662)
9	ContainerP8M7PF8\App_KernelDevDebugContainer::getTwigService (line 1403)
10	ContainerP8M7PF8\App_KernelDevDebugContainer::getParamsSeoBreadcrumbsLanguageService (line 23)
11	ContainerP8M7PF8\getCategoryHelperServiceService::do (line 617)
12	ContainerP8M7PF8\App_KernelDevDebugContainer->load (line 24)
13	ContainerP8M7PF8\getProductCategoryController2Service::do (line 617)
14	ContainerP8M7PF8\App_KernelDevDebugContainer->load (line 229)
15	Symfony\Component\DependencyInjection\Container::make (line 211)
16	Symfony\Component\DependencyInjection\Container->get (line 40)
17	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
18	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
19	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
20	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
21	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.38 ms
(0.31%)

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.datapublicacio AS datapublicacio_4, t0.datadespublicacio AS datadespublicacio_5, t0.visible AS visible_6 FROM destacat t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.datapublicacio AS datapublicacio_4,
  t0.datadespublicacio AS datadespublicacio_5,
  t0.visible AS visible_6
FROM
  destacat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.datapublicacio AS datapublicacio_4, t0.datadespublicacio AS datadespublicacio_5, t0.visible AS visible_6 FROM destacat t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	App\Twig\PublicExtension->showDestacat (line 264)
7	__TwigTemplate_98ad91c65a13a52aeae7af67287229e0->doDisplay (line 388)
8	Twig\Template->yield (line 303)
9	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_header (line 432)
10	Twig\Template->yieldBlock (line 319)
11	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
12	Twig\Template->yieldBlock (line 477)
13	Twig\Template->yieldParentBlock (line 379)
14	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
15	Twig\Template->yieldBlock (line 110)
16	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
17	Twig\Template->yield (line 66)
18	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 309)
29	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.33 ms
(0.27%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.sendable = ? ORDER BY t0.principal DESC LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sendable AS sendable_3,
  t0.preuEnvioGratis AS preuEnvioGratis_4,
  t0.preu_apilable AS preu_apilable_5,
  t0.preu_no_encintable AS preu_no_encintable_6,
  t0.preu_fuera_norma_a AS preu_fuera_norma_a_7,
  t0.textshipment AS textshipment_8,
  t0.textinfoshipment AS textinfoshipment_9,
  t0.displaycetelem AS displaycetelem_10,
  t0.codi_pais AS codi_pais_11,
  t0.grams_max_product AS grams_max_product_12,
  t0.pot_sortir_dandorra AS pot_sortir_dandorra_13,
  t0.principal AS principal_14,
  t0.empresa_id AS empresa_id_15,
  t0.idioma_id AS idioma_id_16
FROM
  paisos t0
WHERE
  t0.sendable = ?
ORDER BY
  t0.principal DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.sendable = 1 ORDER BY t0.principal DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 168)
4	App\EventSubscriber\StateIdiomaEventSubscriber->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
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.31 ms
(0.25%)

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.visiblecolproducte AS visiblecolproducte_5, t0.menusdesplegat AS menusdesplegat_6, t0.menucapdesplegat AS menucapdesplegat_7, t0.numvisites AS numvisites_8, t0.indexar AS indexar_9, t0.ordre AS ordre_10, t0.categorychildren AS categorychildren_11, t0.parent_id AS parent_id_12 FROM apartats t0 WHERE t0.visible = ? AND t0.parent_id IS NULL

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.visible AS visible_4,
  t0.visiblecolproducte AS visiblecolproducte_5,
  t0.menusdesplegat AS menusdesplegat_6,
  t0.menucapdesplegat AS menucapdesplegat_7,
  t0.numvisites AS numvisites_8,
  t0.indexar AS indexar_9,
  t0.ordre AS ordre_10,
  t0.categorychildren AS categorychildren_11,
  t0.parent_id AS parent_id_12
FROM
  apartats t0
WHERE
  t0.visible = ?
  AND t0.parent_id IS NULL

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.visiblecolproducte AS visiblecolproducte_5, t0.menusdesplegat AS menusdesplegat_6, t0.menucapdesplegat AS menucapdesplegat_7, t0.numvisites AS numvisites_8, t0.indexar AS indexar_9, t0.ordre AS ordre_10, t0.categorychildren AS categorychildren_11, t0.parent_id AS parent_id_12 FROM apartats t0 WHERE t0.visible = 1 AND t0.parent_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 106)
4	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.29 ms
(0.23%)

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.active AS active_4, t0.internal AS internal_5, t0.meta_robots AS meta_robots_6, t0.show_breadcrumbs AS show_breadcrumbs_7, t0.show_h1_title AS show_h1_title_8, t0.homepage AS homepage_9, t0.special_type AS special_type_10 FROM page t0 WHERE t0.active = ? AND t0.special_type = ? LIMIT 1

Parameters:

[
  1
  "cookies"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.active AS active_4,
  t0.internal AS internal_5,
  t0.meta_robots AS meta_robots_6,
  t0.show_breadcrumbs AS show_breadcrumbs_7,
  t0.show_h1_title AS show_h1_title_8,
  t0.homepage AS homepage_9,
  t0.special_type AS special_type_10
FROM
  page t0
WHERE
  t0.active = ?
  AND t0.special_type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.active AS active_4, t0.internal AS internal_5, t0.meta_robots AS meta_robots_6, t0.show_breadcrumbs AS show_breadcrumbs_7, t0.show_h1_title AS show_h1_title_8, t0.homepage AS homepage_9, t0.special_type AS special_type_10 FROM page t0 WHERE t0.active = 1 AND t0.special_type = 'cookies' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 152)
4	App\Twig\PublicExtension->getPaginaCookies (line 53)
5	__TwigTemplate_371bef684a0dfd8f7c2021dee8451d5f->doDisplay (line 388)
6	Twig\Template->yield (line 542)
7	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_javascripts (line 432)
8	Twig\Template->yieldBlock (line 477)
9	Twig\Template->yieldParentBlock (line 647)
10	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->block_javascripts (line 432)
11	Twig\Template->yieldBlock (line 112)
12	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
13	Twig\Template->yield (line 66)
14	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 309)
25	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.25 ms
(0.20%)

SELECT t0.id AS id_1, t0.id_idioma AS id_idioma_2, t0.nom AS nom_3, t0.principal AS principal_4, t0.visible AS visible_5, t0.code_iso AS code_iso_6 FROM idioma_gestor t0 WHERE t0.visible = ? ORDER BY t0.principal DESC, t0.nom ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.id_idioma AS id_idioma_2,
  t0.nom AS nom_3,
  t0.principal AS principal_4,
  t0.visible AS visible_5,
  t0.code_iso AS code_iso_6
FROM
  idioma_gestor t0
WHERE
  t0.visible = ?
ORDER BY
  t0.principal DESC,
  t0.nom ASC

SELECT t0.id AS id_1, t0.id_idioma AS id_idioma_2, t0.nom AS nom_3, t0.principal AS principal_4, t0.visible AS visible_5, t0.code_iso AS code_iso_6 FROM idioma_gestor t0 WHERE t0.visible = 1 ORDER BY t0.principal DESC, t0.nom ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 34)
4	App\Repository\LanguageRepository->findAllVisible (line 318)
5	App\Controller\Publica\ProductCategoryController->initParamsSeoTranslate (line 289)
6	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.25 ms
(0.20%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.id = ? ORDER BY t0.id ASC LIMIT 1

Parameters:

[
  219
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sendable AS sendable_3,
  t0.preuEnvioGratis AS preuEnvioGratis_4,
  t0.preu_apilable AS preu_apilable_5,
  t0.preu_no_encintable AS preu_no_encintable_6,
  t0.preu_fuera_norma_a AS preu_fuera_norma_a_7,
  t0.textshipment AS textshipment_8,
  t0.textinfoshipment AS textinfoshipment_9,
  t0.displaycetelem AS displaycetelem_10,
  t0.codi_pais AS codi_pais_11,
  t0.grams_max_product AS grams_max_product_12,
  t0.pot_sortir_dandorra AS pot_sortir_dandorra_13,
  t0.principal AS principal_14,
  t0.empresa_id AS empresa_id_15,
  t0.idioma_id AS idioma_id_16
FROM
  paisos t0
WHERE
  t0.id = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.id = 219 ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 103)
4	App\Service\ShoppingCartService->__construct (line 1451)
5	ContainerP8M7PF8\App_KernelDevDebugContainer::getShoppingCartServiceService (line 2662)
6	ContainerP8M7PF8\App_KernelDevDebugContainer::getTwigService (line 1403)
7	ContainerP8M7PF8\App_KernelDevDebugContainer::getParamsSeoBreadcrumbsLanguageService (line 23)
8	ContainerP8M7PF8\getCategoryHelperServiceService::do (line 617)
9	ContainerP8M7PF8\App_KernelDevDebugContainer->load (line 24)
10	ContainerP8M7PF8\getProductCategoryController2Service::do (line 617)
11	ContainerP8M7PF8\App_KernelDevDebugContainer->load (line 229)
12	Symfony\Component\DependencyInjection\Container::make (line 211)
13	Symfony\Component\DependencyInjection\Container->get (line 40)
14	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
15	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
17	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
18	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.25 ms
(0.20%)

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.title AS title_4, t0.slug AS slug_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.page_id AS page_id_8, t0.language_id AS language_id_9 FROM page_translation t0 WHERE t0.page_id = ? ORDER BY t0.language_id ASC

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.title AS title_4,
  t0.slug AS slug_5,
  t0.meta_keywords AS meta_keywords_6,
  t0.meta_description AS meta_description_7,
  t0.page_id AS page_id_8,
  t0.language_id AS language_id_9
FROM
  page_translation t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.language_id ASC

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.title AS title_4, t0.slug AS slug_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.page_id AS page_id_8, t0.language_id AS language_id_9 FROM page_translation t0 WHERE t0.page_id = 5 ORDER BY t0.language_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 24)
8	App\Entity\TranslatableEntity->translation (line 176)
9	App\Entity\Page->translation (line 1882)
10	Twig\Extension\CoreExtension::getAttribute (line 62)
11	__TwigTemplate_371bef684a0dfd8f7c2021dee8451d5f->doDisplay (line 388)
12	Twig\Template->yield (line 542)
13	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_javascripts (line 432)
14	Twig\Template->yieldBlock (line 477)
15	Twig\Template->yieldParentBlock (line 647)
16	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->block_javascripts (line 432)
17	Twig\Template->yieldBlock (line 112)
18	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
19	Twig\Template->yield (line 66)
20	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_c259cfc841056d5b11beaf68338f10b1->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 309)
31	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.24 ms
(0.19%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.sendable = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sendable AS sendable_3,
  t0.preuEnvioGratis AS preuEnvioGratis_4,
  t0.preu_apilable AS preu_apilable_5,
  t0.preu_no_encintable AS preu_no_encintable_6,
  t0.preu_fuera_norma_a AS preu_fuera_norma_a_7,
  t0.textshipment AS textshipment_8,
  t0.textinfoshipment AS textinfoshipment_9,
  t0.displaycetelem AS displaycetelem_10,
  t0.codi_pais AS codi_pais_11,
  t0.grams_max_product AS grams_max_product_12,
  t0.pot_sortir_dandorra AS pot_sortir_dandorra_13,
  t0.principal AS principal_14,
  t0.empresa_id AS empresa_id_15,
  t0.idioma_id AS idioma_id_16
FROM
  paisos t0
WHERE
  t0.sendable = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.sendable = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 182)
4	App\Controller\Publica\ProductCategoryController->categoryDetail (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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.

Entities Mapping

Class	Mapping errors
App\Entity\States	No errors.
App\Entity\Empresa	No errors.
App\Entity\Language	No errors.
App\Entity\StatesShipment	No errors.
App\Entity\StockHouse	No errors.
App\Entity\PaymentMethods	No errors.
App\Entity\ProductProviderInvoice	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\ProductCategoryTranslation	No errors.
App\Entity\ProductCategoryImage	No errors.
App\Entity\Product	No errors.
App\Entity\ProductPrice	No errors.
App\Entity\ProductBrand	No errors.
App\Entity\ProductCategoryRelation	No errors.
App\Entity\ProductFamily	No errors.
App\Entity\ProductTranslation	No errors.
App\Entity\ProductImage	No errors.
App\Entity\ProductArxius	No errors.
App\Entity\ProductVinculats	No errors.
App\Entity\ProductPriceTranslation	No errors.
App\Entity\ProductEnllacat	No errors.
App\Entity\Destacat	No errors.
App\Entity\ProductImageTranslation	No errors.
App\Entity\Page	No errors.
App\Entity\PageBlock	No errors.
App\Entity\PageTranslation	No errors.

Symfony Profiler

GET http://www.districlaror.com/es/tienda-on-line.html

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping