Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

6.28 ms Query time

0 Invalid entities

6 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

5.12 ms

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.nom AS nom_2, c0_.type AS type_3, c0_.actif AS actif_4, c0_.sync_auto AS sync_auto_5, c0_.ordre AS ordre_6, c0_.base_url AS base_url_7, c0_.api_key AS api_key_8, c0_.language_id AS language_id_9, c0_.shop_id AS shop_id_10, c0_.root_category_id AS root_category_id_11, c0_.tax_rules_group_id AS tax_rules_group_id_12, c0_.zone_id AS zone_id_13 FROM canal c0_ INNER JOIN zone z1_ ON c0_.zone_id = z1_.id WHERE c0_.type = ? AND z1_.code = ? AND c0_.actif = true LIMIT 1

Parameters:

[
  "PARTENAIRES"
  "METROPOLE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.nom AS nom_2,
  c0_.type AS type_3,
  c0_.actif AS actif_4,
  c0_.sync_auto AS sync_auto_5,
  c0_.ordre AS ordre_6,
  c0_.base_url AS base_url_7,
  c0_.api_key AS api_key_8,
  c0_.language_id AS language_id_9,
  c0_.shop_id AS shop_id_10,
  c0_.root_category_id AS root_category_id_11,
  c0_.tax_rules_group_id AS tax_rules_group_id_12,
  c0_.zone_id AS zone_id_13
FROM
  canal c0_
  INNER JOIN zone z1_ ON c0_.zone_id = z1_.id
WHERE
  c0_.type = ?
  AND z1_.code = ?
  AND c0_.actif = true
LIMIT
  1

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.nom AS nom_2, c0_.type AS type_3, c0_.actif AS actif_4, c0_.sync_auto AS sync_auto_5, c0_.ordre AS ordre_6, c0_.base_url AS base_url_7, c0_.api_key AS api_key_8, c0_.language_id AS language_id_9, c0_.shop_id AS shop_id_10, c0_.root_category_id AS root_category_id_11, c0_.tax_rules_group_id AS tax_rules_group_id_12, c0_.zone_id AS zone_id_13 FROM canal c0_ INNER JOIN zone z1_ ON c0_.zone_id = z1_.id WHERE c0_.type = 'PARTENAIRES' AND z1_.code = 'METROPOLE' AND c0_.actif = true LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\CanalResolver->canalPourZone (line 57)
7	App\Service\CanalResolver->canalCourant (line 44)
8	Twig\Extension\CoreExtension->getAttribute (line 1996)
9	__TwigTemplate_3fea28a49aa03a1a3df94bf85aeac24d::doDisplay (line 53)
10	Twig\Template->yield (line 461)
11	__TwigTemplate_d663638966586b366c7db526c45bf66a->block_header (line 248)
12	Twig\Template->yieldBlock (line 493)
13	__TwigTemplate_d663638966586b366c7db526c45bf66a->doDisplay (line 85)
14	Twig\Template->yield (line 461)
15	__TwigTemplate_067c6b42072a0e9843a7c8e113a00f91->doDisplay (line 59)
16	Twig\Template->yield (line 461)
17	Twig\Template->display (line 416)
18	Twig\Template->render (line 431)
19	Twig\TemplateWrapper->render (line 53)
20	Twig\Environment->render (line 343)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Site\LegalController->page (line 33)
25	App\Controller\Site\LegalController->confidentialite (line 27)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	require_once (line 5)

0.55 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.type AS type_4, t0.actif AS actif_5, t0.sync_auto AS sync_auto_6, t0.ordre AS ordre_7, t0.base_url AS base_url_8, t0.api_key AS api_key_9, t0.language_id AS language_id_10, t0.shop_id AS shop_id_11, t0.root_category_id AS root_category_id_12, t0.tax_rules_group_id AS tax_rules_group_id_13, t0.zone_id AS zone_id_14 FROM canal t0 WHERE t0.type = ? AND t0.actif = ? ORDER BY t0.ordre ASC

Parameters:

[
  "PARTENAIRES"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.type AS type_4,
  t0.actif AS actif_5,
  t0.sync_auto AS sync_auto_6,
  t0.ordre AS ordre_7,
  t0.base_url AS base_url_8,
  t0.api_key AS api_key_9,
  t0.language_id AS language_id_10,
  t0.shop_id AS shop_id_11,
  t0.root_category_id AS root_category_id_12,
  t0.tax_rules_group_id AS tax_rules_group_id_13,
  t0.zone_id AS zone_id_14
FROM
  canal t0
WHERE
  t0.type = ?
  AND t0.actif = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.type AS type_4, t0.actif AS actif_5, t0.sync_auto AS sync_auto_6, t0.ordre AS ordre_7, t0.base_url AS base_url_8, t0.api_key AS api_key_9, t0.language_id AS language_id_10, t0.shop_id AS shop_id_11, t0.root_category_id AS root_category_id_12, t0.tax_rules_group_id AS tax_rules_group_id_13, t0.zone_id AS zone_id_14 FROM canal t0 WHERE t0.type = 'PARTENAIRES' AND t0.actif = 1 ORDER BY t0.ordre ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	App\Service\CanalResolver->canauxPartenaires (line 63)
4	Twig\Extension\CoreExtension->getAttribute (line 1996)
5	__TwigTemplate_3fea28a49aa03a1a3df94bf85aeac24d::doDisplay (line 78)
6	Twig\Template->yield (line 461)
7	__TwigTemplate_d663638966586b366c7db526c45bf66a->block_header (line 248)
8	Twig\Template->yieldBlock (line 493)
9	__TwigTemplate_d663638966586b366c7db526c45bf66a->doDisplay (line 85)
10	Twig\Template->yield (line 461)
11	__TwigTemplate_067c6b42072a0e9843a7c8e113a00f91->doDisplay (line 59)
12	Twig\Template->yield (line 461)
13	Twig\Template->display (line 416)
14	Twig\Template->render (line 431)
15	Twig\TemplateWrapper->render (line 53)
16	Twig\Environment->render (line 343)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\Site\LegalController->page (line 33)
21	App\Controller\Site\LegalController->confidentialite (line 27)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

0.34 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.actif AS actif_4, t0.taxe_id AS taxe_id_5 FROM zone t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.actif AS actif_4,
  t0.taxe_id AS taxe_id_5
FROM
  zone t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.actif AS actif_4, t0.taxe_id AS taxe_id_5 FROM zone t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	Twig\Extension\CoreExtension::getAttribute (line 1869)
5	__TwigTemplate_3fea28a49aa03a1a3df94bf85aeac24d::doDisplay (line 98)
6	Twig\Template->yield (line 461)
7	__TwigTemplate_d663638966586b366c7db526c45bf66a->block_header (line 248)
8	Twig\Template->yieldBlock (line 493)
9	__TwigTemplate_d663638966586b366c7db526c45bf66a->doDisplay (line 85)
10	Twig\Template->yield (line 461)
11	__TwigTemplate_067c6b42072a0e9843a7c8e113a00f91->doDisplay (line 59)
12	Twig\Template->yield (line 461)
13	Twig\Template->display (line 416)
14	Twig\Template->render (line 431)
15	Twig\TemplateWrapper->render (line 53)
16	Twig\Environment->render (line 343)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\Site\LegalController->page (line 33)
21	App\Controller\Site\LegalController->confidentialite (line 27)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

0.26 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.actif AS actif_4, t0.taxe_id AS taxe_id_5 FROM zone t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.actif AS actif_4,
  t0.taxe_id AS taxe_id_5
FROM
  zone t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.actif AS actif_4, t0.taxe_id AS taxe_id_5 FROM zone t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	Twig\Extension\CoreExtension::getAttribute (line 1869)
5	__TwigTemplate_3fea28a49aa03a1a3df94bf85aeac24d::doDisplay (line 98)
6	Twig\Template->yield (line 461)
7	__TwigTemplate_d663638966586b366c7db526c45bf66a->block_header (line 248)
8	Twig\Template->yieldBlock (line 493)
9	__TwigTemplate_d663638966586b366c7db526c45bf66a->doDisplay (line 85)
10	Twig\Template->yield (line 461)
11	__TwigTemplate_067c6b42072a0e9843a7c8e113a00f91->doDisplay (line 59)
12	Twig\Template->yield (line 461)
13	Twig\Template->display (line 416)
14	Twig\Template->render (line 431)
15	Twig\TemplateWrapper->render (line 53)
16	Twig\Environment->render (line 343)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\Site\LegalController->page (line 33)
21	App\Controller\Site\LegalController->confidentialite (line 27)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
strapi	doctrine.dbal.strapi_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Canal	2
App\Entity\Zone	2
App\Entity\Taxe	2

Entities Mapping

Class	Mapping errors
App\Entity\Canal	No errors.
App\Entity\Zone	No errors.
App\Entity\Taxe	No errors.
App\Entity\Country	No errors.

Symfony Profiler

GET http://melgav2.conception-jc.fr/politique-de-confidentialite

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping