Symfony Profiler

Query Metrics

29 Database Queries

13 Different statements

6.15 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.05 ms
(17.05%)

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.titol AS titol_4, t0.menu_id AS menu_id_5, t0.language_id AS language_id_6 FROM menu_translation t0 WHERE t0.menu_id = ?

Parameters:

[
  1
]

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.titol AS titol_4,
  t0.menu_id AS menu_id_5,
  t0.language_id AS language_id_6
FROM
  menu_translation t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.titol AS titol_4, t0.menu_id AS menu_id_5, t0.language_id AS language_id_6 FROM menu_translation t0 WHERE t0.menu_id = 1;

#	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 342)
9	App\Entity\Menu->translation (line 49)
10	App\Twig\Runtime\MenuWebExtensionRuntime->App\Twig\Runtime\{closure} (line 131)
11	App\Service\CustomCacheService->App\Service\{closure} (line 48)
12	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
13	Symfony\Component\Cache\LockRegistry::compute (line 104)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
17	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
18	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 132)
19	App\Service\CustomCacheService->fromSiteCache (line 57)
20	App\Twig\Runtime\MenuWebExtensionRuntime->getMenuWebArrayCache (line 77)
21	__TwigTemplate_7548cdb7e662599c7da350217cb50f89->doDisplay (line 388)
22	Twig\Template->yield (line 349)
23	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_footer (line 432)
24	Twig\Template->yieldBlock (line 325)
25	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
26	Twig\Template->yieldBlock (line 477)
27	Twig\Template->yieldParentBlock (line 379)
28	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
29	Twig\Template->yieldBlock (line 110)
30	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
31	Twig\Template->yield (line 66)
32	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
33	Twig\Template->yield (line 53)
34	__TwigTemplate_20b7c9c617f5358eee489e64a019e11d->doDisplay (line 388)
35	Twig\Template->yield (line 344)
36	Twig\Template->display (line 359)
37	Twig\Template->render (line 51)
38	Twig\TemplateWrapper->render (line 334)
39	Twig\Environment->render (line 448)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 332)
43	App\Controller\Publica\UserPublicController->loginShop (line 181)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
46	Symfony\Component\HttpKernel\Kernel->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	require_once (line 5)

0.81 ms
(13.19%)

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.id = ? LIMIT 1

Parameters:

[
  1
]

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.id = ?
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.id = 1 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 133)
4	App\Twig\Runtime\MenuWebExtensionRuntime->getConstructLinkBotoMenu (line 51)
5	App\Twig\Runtime\MenuWebExtensionRuntime->App\Twig\Runtime\{closure} (line 131)
6	App\Service\CustomCacheService->App\Service\{closure} (line 48)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 104)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 132)
14	App\Service\CustomCacheService->fromSiteCache (line 57)
15	App\Twig\Runtime\MenuWebExtensionRuntime->getMenuWebArrayCache (line 77)
16	__TwigTemplate_7548cdb7e662599c7da350217cb50f89->doDisplay (line 388)
17	Twig\Template->yield (line 349)
18	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_footer (line 432)
19	Twig\Template->yieldBlock (line 325)
20	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
21	Twig\Template->yieldBlock (line 477)
22	Twig\Template->yieldParentBlock (line 379)
23	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
24	Twig\Template->yieldBlock (line 110)
25	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
26	Twig\Template->yield (line 66)
27	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
28	Twig\Template->yield (line 53)
29	__TwigTemplate_20b7c9c617f5358eee489e64a019e11d->doDisplay (line 388)
30	Twig\Template->yield (line 344)
31	Twig\Template->display (line 359)
32	Twig\Template->render (line 51)
33	Twig\TemplateWrapper->render (line 334)
34	Twig\Environment->render (line 448)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 332)
38	App\Controller\Publica\UserPublicController->loginShop (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

0.71 ms
(11.51%)

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:

[
  1
]

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 = 1 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 139)
10	App\Twig\Runtime\MenuWebExtensionRuntime->getConstructLinkBotoMenu (line 51)
11	App\Twig\Runtime\MenuWebExtensionRuntime->App\Twig\Runtime\{closure} (line 131)
12	App\Service\CustomCacheService->App\Service\{closure} (line 48)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
14	Symfony\Component\Cache\LockRegistry::compute (line 104)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
17	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
18	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
19	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 132)
20	App\Service\CustomCacheService->fromSiteCache (line 57)
21	App\Twig\Runtime\MenuWebExtensionRuntime->getMenuWebArrayCache (line 77)
22	__TwigTemplate_7548cdb7e662599c7da350217cb50f89->doDisplay (line 388)
23	Twig\Template->yield (line 349)
24	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_footer (line 432)
25	Twig\Template->yieldBlock (line 325)
26	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
27	Twig\Template->yieldBlock (line 477)
28	Twig\Template->yieldParentBlock (line 379)
29	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
30	Twig\Template->yieldBlock (line 110)
31	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
32	Twig\Template->yield (line 66)
33	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
34	Twig\Template->yield (line 53)
35	__TwigTemplate_20b7c9c617f5358eee489e64a019e11d->doDisplay (line 388)
36	Twig\Template->yield (line 344)
37	Twig\Template->display (line 359)
38	Twig\Template->render (line 51)
39	Twig\TemplateWrapper->render (line 334)
40	Twig\Environment->render (line 448)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 332)
44	App\Controller\Publica\UserPublicController->loginShop (line 181)
45	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
46	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
47	Symfony\Component\HttpKernel\Kernel->handle (line 35)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
49	require_once (line 5)

0.61 ms
(9.98%)

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 24)
11	ContainerP8M7PF8\getUserPublicControllerService::do (line 617)
12	ContainerP8M7PF8\App_KernelDevDebugContainer->load (line 229)
13	Symfony\Component\DependencyInjection\Container::make (line 211)
14	Symfony\Component\DependencyInjection\Container->get (line 40)
15	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
16	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
17	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
18	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
19	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.61 ms
(9.95%)

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 = ? AND t0.sendable = ? LIMIT 1

Parameters:

[
  "ES"
  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.codi_pais = ?
  AND t0.sendable = ?
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' AND t0.sendable = 1 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 106)
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.50 ms
(8.11%)

SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.updated AS updated_2, m0_.origin AS origin_3, m0_.origin_id AS origin_id_4, m0_.estat AS estat_5, m0_.ordre AS ordre_6, m0_.editable AS editable_7, m0_.link AS link_8, m0_.nova_pagina AS nova_pagina_9, m0_.name_route AS name_route_10, m0_.param_route AS param_route_11, m0_.pare_id AS pare_id_12, m0_.posicio_id AS posicio_id_13 FROM menu m0_ WHERE m0_.pare_id IS NULL AND m0_.posicio_id = ? AND m0_.estat = 1 ORDER BY m0_.ordre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.created AS created_1,
  m0_.updated AS updated_2,
  m0_.origin AS origin_3,
  m0_.origin_id AS origin_id_4,
  m0_.estat AS estat_5,
  m0_.ordre AS ordre_6,
  m0_.editable AS editable_7,
  m0_.link AS link_8,
  m0_.nova_pagina AS nova_pagina_9,
  m0_.name_route AS name_route_10,
  m0_.param_route AS param_route_11,
  m0_.pare_id AS pare_id_12,
  m0_.posicio_id AS posicio_id_13
FROM
  menu m0_
WHERE
  m0_.pare_id IS NULL
  AND m0_.posicio_id = ?
  AND m0_.estat = 1
ORDER BY
  m0_.ordre ASC

SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.updated AS updated_2, m0_.origin AS origin_3, m0_.origin_id AS origin_id_4, m0_.estat AS estat_5, m0_.ordre AS ordre_6, m0_.editable AS editable_7, m0_.link AS link_8, m0_.nova_pagina AS nova_pagina_9, m0_.name_route AS name_route_10, m0_.param_route AS param_route_11, m0_.pare_id AS pare_id_12, m0_.posicio_id AS posicio_id_13 FROM menu m0_ WHERE m0_.pare_id IS NULL AND m0_.posicio_id = 1 AND m0_.estat = 1 ORDER BY m0_.ordre 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 45)
7	App\Repository\MenuRepository->getLlistatMenuRoot (line 76)
8	App\Twig\Runtime\MenuWebExtensionRuntime->getMenusWeb (line 37)
9	App\Twig\Runtime\MenuWebExtensionRuntime->App\Twig\Runtime\{closure} (line 131)
10	App\Service\CustomCacheService->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 132)
18	App\Service\CustomCacheService->fromSiteCache (line 57)
19	App\Twig\Runtime\MenuWebExtensionRuntime->getMenuWebArrayCache (line 77)
20	__TwigTemplate_7548cdb7e662599c7da350217cb50f89->doDisplay (line 388)
21	Twig\Template->yield (line 349)
22	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_footer (line 432)
23	Twig\Template->yieldBlock (line 325)
24	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
25	Twig\Template->yieldBlock (line 477)
26	Twig\Template->yieldParentBlock (line 379)
27	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
28	Twig\Template->yieldBlock (line 110)
29	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
30	Twig\Template->yield (line 66)
31	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
32	Twig\Template->yield (line 53)
33	__TwigTemplate_20b7c9c617f5358eee489e64a019e11d->doDisplay (line 388)
34	Twig\Template->yield (line 344)
35	Twig\Template->display (line 359)
36	Twig\Template->render (line 51)
37	Twig\TemplateWrapper->render (line 334)
38	Twig\Environment->render (line 448)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 332)
42	App\Controller\Publica\UserPublicController->loginShop (line 181)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
45	Symfony\Component\HttpKernel\Kernel->handle (line 35)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
47	require_once (line 5)

0.48 ms
(7.74%)

SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.updated AS updated_2, m0_.titol AS titol_3, m0_.tipus AS tipus_4, m0_.estat AS estat_5, m0_.nivell AS nivell_6 FROM menu_posicio m0_ WHERE m0_.tipus = ? LIMIT 1

Parameters:

[
  "footer"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.created AS created_1,
  m0_.updated AS updated_2,
  m0_.titol AS titol_3,
  m0_.tipus AS tipus_4,
  m0_.estat AS estat_5,
  m0_.nivell AS nivell_6
FROM
  menu_posicio m0_
WHERE
  m0_.tipus = ?
LIMIT
  1

SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.updated AS updated_2, m0_.titol AS titol_3, m0_.tipus AS tipus_4, m0_.estat AS estat_5, m0_.nivell AS nivell_6 FROM menu_posicio m0_ WHERE m0_.tipus = 'footer' LIMIT 1;

#	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 60)
7	App\Repository\MenuPosicioRepository->getPerTipusMenu (line 65)
8	App\Twig\Runtime\MenuWebExtensionRuntime->getMenusWeb (line 37)
9	App\Twig\Runtime\MenuWebExtensionRuntime->App\Twig\Runtime\{closure} (line 131)
10	App\Service\CustomCacheService->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 132)
18	App\Service\CustomCacheService->fromSiteCache (line 57)
19	App\Twig\Runtime\MenuWebExtensionRuntime->getMenuWebArrayCache (line 77)
20	__TwigTemplate_7548cdb7e662599c7da350217cb50f89->doDisplay (line 388)
21	Twig\Template->yield (line 349)
22	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_footer (line 432)
23	Twig\Template->yieldBlock (line 325)
24	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
25	Twig\Template->yieldBlock (line 477)
26	Twig\Template->yieldParentBlock (line 379)
27	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
28	Twig\Template->yieldBlock (line 110)
29	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
30	Twig\Template->yield (line 66)
31	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
32	Twig\Template->yield (line 53)
33	__TwigTemplate_20b7c9c617f5358eee489e64a019e11d->doDisplay (line 388)
34	Twig\Template->yield (line 344)
35	Twig\Template->display (line 359)
36	Twig\Template->render (line 51)
37	Twig\TemplateWrapper->render (line 334)
38	Twig\Environment->render (line 448)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 332)
42	App\Controller\Publica\UserPublicController->loginShop (line 181)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
45	Symfony\Component\HttpKernel\Kernel->handle (line 35)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
47	require_once (line 5)

0.28 ms
(4.52%)

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.ordre AS ordre_5, t0.destacat AS destacat_6, t0.tipus_pagina AS tipus_pagina_7, t0.parent_id AS parent_id_8, t0.replaced_with_id AS replaced_with_id_9 FROM pagines t0 WHERE t0.visible = ? AND t0.tipus_pagina = ?

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.ordre AS ordre_5,
  t0.destacat AS destacat_6,
  t0.tipus_pagina AS tipus_pagina_7,
  t0.parent_id AS parent_id_8,
  t0.replaced_with_id AS replaced_with_id_9
FROM
  pagines t0
WHERE
  t0.visible = ?
  AND t0.tipus_pagina = ?

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.ordre AS ordre_5, t0.destacat AS destacat_6, t0.tipus_pagina AS tipus_pagina_7, t0.parent_id AS parent_id_8, t0.replaced_with_id AS replaced_with_id_9 FROM pagines t0 WHERE t0.visible = 1 AND t0.tipus_pagina = 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 34)
4	App\Form\ClientSimpleRegisterType->__construct (line 25)
5	ContainerP8M7PF8\getClientSimpleRegisterTypeService::do (line 617)
6	ContainerP8M7PF8\App_KernelDevDebugContainer->load (line 404)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 46)
9	Symfony\Component\Form\Extension\DependencyInjection\DependencyInjectionExtension->getType (line 64)
10	Symfony\Component\Form\FormRegistry->getType (line 43)
11	Symfony\Component\Form\FormFactory->createBuilder (line 28)
12	Symfony\Component\Form\FormFactory->create (line 340)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 589)
14	App\Controller\Publica\UserPublicController->getRegisterForm (line 321)
15	App\Controller\Publica\UserPublicController->loginShop (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.27 ms
(4.41%)

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 24)
8	ContainerP8M7PF8\getUserPublicControllerService::do (line 617)
9	ContainerP8M7PF8\App_KernelDevDebugContainer->load (line 229)
10	Symfony\Component\DependencyInjection\Container::make (line 211)
11	Symfony\Component\DependencyInjection\Container->get (line 40)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.23 ms
(3.77%)

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.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.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.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 78)
4	App\Service\CustomCacheService->App\Service\{closure} (line 131)
5	App\Service\CustomCacheService->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 132)
13	App\Service\CustomCacheService->fromSiteCache (line 92)
14	App\Service\CustomCacheService->getAllVisibleLanguages (line 75)
15	App\EventSubscriber\StateIdiomaEventSubscriber->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.21 ms
(3.40%)

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 53)
20	__TwigTemplate_20b7c9c617f5358eee489e64a019e11d->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 332)
29	App\Controller\Publica\UserPublicController->loginShop (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.21 ms
(3.38%)

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 112)
9	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
10	Twig\Template->yield (line 66)
11	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
12	Twig\Template->yield (line 53)
13	__TwigTemplate_20b7c9c617f5358eee489e64a019e11d->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 334)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 332)
22	App\Controller\Publica\UserPublicController->loginShop (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.19 ms
(3.01%)

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 629)
5	App\Controller\Publica\UserPublicController->initParamsSeoTranslate (line 325)
6	App\Controller\Publica\UserPublicController->loginShop (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)

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\Language	No errors.
App\Entity\States	No errors.
App\Entity\Empresa	No errors.
App\Entity\StatesShipment	No errors.
App\Entity\StockHouse	No errors.
App\Entity\PaymentMethods	No errors.
App\Entity\ProductProviderInvoice	No errors.
App\Entity\Pagines	No errors.
App\Entity\Page	No errors.
App\Entity\Destacat	No errors.
App\Entity\MenuPosicio	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuTranslation	No errors.
App\Entity\PageBlock	No errors.
App\Entity\PageTranslation	No errors.

Symfony Profiler

GET http://www.districlaror.com/es/acceder

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping