Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

1.70 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.71 ms
(42.00%)

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.29 ms
(17.30%)

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 668)
10	ContainerP8M7PF8\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 2252)
11	ContainerP8M7PF8\App_KernelDevDebugContainer::getProfilerListenerService (line 1103)
12	ContainerP8M7PF8\App_KernelDevDebugContainer::ContainerP8M7PF8\{closure} (line 235)
13	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
14	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 276)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 133)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.27 ms
(15.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.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 668)
7	ContainerP8M7PF8\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 2252)
8	ContainerP8M7PF8\App_KernelDevDebugContainer::getProfilerListenerService (line 1103)
9	ContainerP8M7PF8\App_KernelDevDebugContainer::ContainerP8M7PF8\{closure} (line 235)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 276)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 133)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
14	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
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.22 ms
(13.00%)

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 59)
15	App\Controller\Publica\PublicController->preindex (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.20 ms
(11.75%)

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 ORDER BY t0.principal DESC, t0.id ASC LIMIT 1

Parameters:

[]

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
ORDER BY
  t0.principal DESC,
  t0.id ASC
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 ORDER BY t0.principal DESC, t0.id ASC 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 96)
4	App\Controller\Publica\PublicController->preindex (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.

Symfony Profiler

GET http://www.districlaror.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping