Symfony Profiler

Query Metrics

24 Database Queries

16 Different statements

7.98 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.70 ms
(21.31%)

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

Parameters:

[
  "es"
]

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

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.id_idioma = '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 53)
4	App\Controller\Publica\PaginesModularsController->paginaModular (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)

1.12 ms
(14.05%)

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

Parameters:

[
  2
  "quienes-somos"
]

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

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.language_id = 2 AND t0.slug = 'quienes-somos' 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 56)
4	App\Controller\Publica\PaginesModularsController->paginaModular (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.68 ms
(8.52%)

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\getPaginesModularsControllerService::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.64 ms
(7.95%)

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 111)
14	__TwigTemplate_875e1bea7085bb34af520d3762869456->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 1493)
19	Twig\Extension\CoreExtension::include (line 54)
20	__TwigTemplate_4e7061716885e49ce369fe931206c201->doDisplay (line 388)
21	Twig\Template->yield (line 158)
22	__TwigTemplate_95e4a1d1ea82c647acfcbf5d4937d15b->block_container (line 432)
23	Twig\Template->yieldBlock (line 322)
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 55)
33	__TwigTemplate_95e4a1d1ea82c647acfcbf5d4937d15b->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 127)
42	App\Controller\Publica\PaginesModularsController->paginaModular (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.59 ms
(7.44%)

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 24)
8	App\Entity\TranslatableEntity->translation (line 271)
9	App\Entity\ProductCategory->translation (line 1882)
10	Twig\Extension\CoreExtension::getAttribute (line 48)
11	__TwigTemplate_fcbe5d88298af23d43b60facab016902->doDisplay (line 388)
12	Twig\Template->yield (line 111)
13	__TwigTemplate_875e1bea7085bb34af520d3762869456->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 1493)
18	Twig\Extension\CoreExtension::include (line 54)
19	__TwigTemplate_4e7061716885e49ce369fe931206c201->doDisplay (line 388)
20	Twig\Template->yield (line 158)
21	__TwigTemplate_95e4a1d1ea82c647acfcbf5d4937d15b->block_container (line 432)
22	Twig\Template->yieldBlock (line 322)
23	__TwigTemplate_d9a0cca901af529c20d3a94275741888->block_body (line 432)
24	Twig\Template->yieldBlock (line 477)
25	Twig\Template->yieldParentBlock (line 379)
26	__TwigTemplate_8a62cbe276d49502800bb023308a5655->block_body (line 432)
27	Twig\Template->yieldBlock (line 110)
28	__TwigTemplate_d9a0cca901af529c20d3a94275741888->doDisplay (line 388)
29	Twig\Template->yield (line 66)
30	__TwigTemplate_8a62cbe276d49502800bb023308a5655->doDisplay (line 388)
31	Twig\Template->yield (line 55)
32	__TwigTemplate_95e4a1d1ea82c647acfcbf5d4937d15b->doDisplay (line 388)
33	Twig\Template->yield (line 344)
34	Twig\Template->display (line 359)
35	Twig\Template->render (line 51)
36	Twig\TemplateWrapper->render (line 334)
37	Twig\Environment->render (line 448)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 127)
41	App\Controller\Publica\PaginesModularsController->paginaModular (line 181)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
44	Symfony\Component\HttpKernel\Kernel->handle (line 35)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
46	require_once (line 5)

0.46 ms
(5.72%)

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 159)
10	App\Controller\Publica\PaginesModularsController->initParamsSeoTranslate (line 115)
11	App\Controller\Publica\PaginesModularsController->paginaModular (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.42 ms
(5.23%)

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.41 ms
(5.08%)

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.text AS text_6, t0.block_id AS block_id_7, t0.language_id AS language_id_8 FROM page_block_translation t0 WHERE t0.block_id = ?

Parameters:

[
  26
]

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.subtitle AS subtitle_5,
  t0.text AS text_6,
  t0.block_id AS block_id_7,
  t0.language_id AS language_id_8
FROM
  page_block_translation t0
WHERE
  t0.block_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.text AS text_6, t0.block_id AS block_id_7, t0.language_id AS language_id_8 FROM page_block_translation t0 WHERE t0.block_id = 26;

#	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 316)
9	App\Entity\PageBlock->translation (line 115)
10	App\Bloc\BlocSuperclass->getBasicTemplateData (line 21)
11	App\Bloc\Type\BlocTitleText->getTemplateData (line 82)
12	App\Controller\Publica\PaginesModularsController->paginaModular (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.38 ms
(4.77%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.fields_json AS fields_json_4 FROM page_block_type t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.fields_json AS fields_json_4
FROM
  page_block_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.fields_json AS fields_json_4 FROM page_block_type t0 WHERE t0.id = 2;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\PageBlockType::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\PageBlockType->__get (line 38)
8	App\Entity\PageBlockType->getSlug (line 79)
9	App\Controller\Publica\PaginesModularsController->paginaModular (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.26 ms
(3.30%)

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\getPaginesModularsControllerService::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.25 ms
(3.17%)

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 ORDER BY t0.ordre ASC

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
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.visible = 1 AND t0.parent_id IS NULL 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 39)
4	App\Bloc\Type\BlocLlistaCategories->getTemplateData (line 82)
5	App\Controller\Publica\PaginesModularsController->paginaModular (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.25 ms
(3.12%)

SELECT t0.key_directori AS key_directori_1, t0.id AS id_2, t0.created AS created_3, t0.updated AS updated_4, t0.ordernumber AS ordernumber_5, t0.image_filename AS image_filename_6, t0.image_filepath AS image_filepath_7, t0.attachment_filename AS attachment_filename_8, t0.attachment_filepath AS attachment_filepath_9, t0.bgcolor AS bgcolor_10, t0.custom_class AS custom_class_11, t0.custom_id AS custom_id_12, t0.extras AS extras_13, t0.page_id AS page_id_14, t0.type_id AS type_id_15 FROM page_block t0 WHERE t0.page_id = ? ORDER BY t0.ordernumber ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.key_directori AS key_directori_1,
  t0.id AS id_2,
  t0.created AS created_3,
  t0.updated AS updated_4,
  t0.ordernumber AS ordernumber_5,
  t0.image_filename AS image_filename_6,
  t0.image_filepath AS image_filepath_7,
  t0.attachment_filename AS attachment_filename_8,
  t0.attachment_filepath AS attachment_filepath_9,
  t0.bgcolor AS bgcolor_10,
  t0.custom_class AS custom_class_11,
  t0.custom_id AS custom_id_12,
  t0.extras AS extras_13,
  t0.page_id AS page_id_14,
  t0.type_id AS type_id_15
FROM
  page_block t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.ordernumber ASC

SELECT t0.key_directori AS key_directori_1, t0.id AS id_2, t0.created AS created_3, t0.updated AS updated_4, t0.ordernumber AS ordernumber_5, t0.image_filename AS image_filename_6, t0.image_filepath AS image_filepath_7, t0.attachment_filename AS attachment_filename_8, t0.attachment_filepath AS attachment_filepath_9, t0.bgcolor AS bgcolor_10, t0.custom_class AS custom_class_11, t0.custom_id AS custom_id_12, t0.extras AS extras_13, t0.page_id AS page_id_14, t0.type_id AS type_id_15 FROM page_block t0 WHERE t0.page_id = 1 ORDER BY t0.ordernumber 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 77)
8	App\Controller\Publica\PaginesModularsController->paginaModular (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.23 ms
(2.91%)

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 = ?

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 = ?

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;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Page::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Page->__get (line 112)
8	App\Entity\Page->getActive (line 65)
9	App\Controller\Publica\PaginesModularsController->paginaModular (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.23 ms
(2.89%)

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 246)
10	__TwigTemplate_95e4a1d1ea82c647acfcbf5d4937d15b->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 55)
16	__TwigTemplate_95e4a1d1ea82c647acfcbf5d4937d15b->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 127)
25	App\Controller\Publica\PaginesModularsController->paginaModular (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.20 ms
(2.45%)

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 135)
5	App\Controller\Publica\PaginesModularsController->initParamsSeoTranslate (line 115)
6	App\Controller\Publica\PaginesModularsController->paginaModular (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.17 ms
(2.08%)

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 55)
20	__TwigTemplate_95e4a1d1ea82c647acfcbf5d4937d15b->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 127)
29	App\Controller\Publica\PaginesModularsController->paginaModular (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)

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\PageTranslation	No errors.
App\Entity\Page	No errors.
App\Entity\PageBlock	No errors.
App\Entity\PageBlockType	No errors.
App\Entity\PageBlockLine	No errors.
App\Entity\PageBlockTranslation	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\ProductCategoryTranslation	No errors.
App\Entity\ProductCategoryImage	No errors.
App\Entity\Destacat	No errors.

Symfony Profiler

GET http://www.districlaror.com/es/quienes-somos

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping