Symfony Profiler

Query Metrics

34 Database Queries

18 Different statements

287.78 ms Query time

0 Invalid entities

436 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

45.21 ms
(15.71%)

SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15, a0_.area_id AS area_id_16, a0_.depart_id AS depart_id_17, a0_.arrondissement_id AS arrondissement_id_18, a0_.metier_id AS metier_id_19 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = ? AND a0_.publie = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.raisonsocialeentreprise ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1,
  a0_.telephoneentreprise AS telephoneentreprise_2,
  a0_.emailentreprise AS emailentreprise_3,
  a0_.boiteposteentreprise AS boiteposteentreprise_4,
  a0_.faxentreprise AS faxentreprise_5,
  a0_.agrement AS agrement_6,
  a0_.delivrance AS delivrance_7,
  a0_.renouvellement AS renouvellement_8,
  a0_.valide AS valide_9,
  a0_.publie AS publie_10,
  a0_.vue AS vue_11,
  a0_.gerant AS gerant_12,
  a0_.accredite AS accredite_13,
  a0_.creele AS creele_14,
  a0_.modifiele AS modifiele_15,
  a0_.area_id AS area_id_16,
  a0_.depart_id AS depart_id_17,
  a0_.arrondissement_id AS arrondissement_id_18,
  a0_.metier_id AS metier_id_19
FROM
  agent_promoteuret_syndic a0_
WHERE
  a0_.raisonsocialeentreprise IS NOT NULL
  AND a0_.vue = ?
  AND a0_.publie = ?
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.raisonsocialeentreprise ASC

SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15, a0_.area_id AS area_id_16, a0_.depart_id AS depart_id_17, a0_.arrondissement_id AS arrondissement_id_18, a0_.metier_id AS metier_id_19 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = '1' AND a0_.id IN (483, 390, 317, 180, 285, 199, 469, 273, 289, 159, 555, 184, 182, 445, 506, 191, 224, 476, 479, 567, 336, 443, 217, 488, 448, 225, 197, 565, 564, 166, 208, 574, 196, 357, 334, 259, 219, 274, 326, 346, 200, 330, 302, 337, 380, 260, 353, 220, 511, 263, 355, 163, 348, 209, 254, 481, 360, 303, 202, 158, 515, 344, 264, 441, 457, 349, 319, 361, 245, 280, 466, 412, 240, 206, 450, 218, 249, 559, 301, 512, 189, 332, 461, 306, 253, 391, 453, 203, 482, 394, 505, 420, 424, 177, 416, 178, 467, 426, 498, 188) ORDER BY a0_.raisonsocialeentreprise ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 102)
8	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 299)
9	App\Twig\Extension\GlobalVarExtension->getStatFront (line 1909)
10	Twig\Extension\CoreExtension::getAttribute (line 109)
11	__TwigTemplate_f9780d7a859005272d59b5e4318cdb25->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1520)
16	Twig\Extension\CoreExtension::include (line 109)
17	__TwigTemplate_f107fd265be3dfab4397368e372eae9f->doDisplay (line 402)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_171fbb689d4b8511dbc707c80b81e27a->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 163)
28	App\Controller\FrontController->professionByRegion (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

27.95 ms
(9.71%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.surface AS surface_4, t0.lattitude AS lattitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.creele AS creele_8, t0.modifiele AS modifiele_9, t0.slug AS slug_10 FROM region t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "sud-ouest"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.surface AS surface_4,
  t0.lattitude AS lattitude_5,
  t0.longitude AS longitude_6,
  t0.description AS description_7,
  t0.creele AS creele_8,
  t0.modifiele AS modifiele_9,
  t0.slug AS slug_10
FROM
  region t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.surface AS surface_4, t0.lattitude AS lattitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.creele AS creele_8, t0.modifiele AS modifiele_9, t0.slug AS slug_10 FROM region t0 WHERE t0.slug = 'sud-ouest' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 129)
5	App\Controller\FrontController->App\Controller\{closure} (line 48)
6	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
7	Symfony\Component\Cache\LockRegistry::compute (line 102)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
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 126)
13	App\Controller\FrontController->professionByRegion (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

21.76 ms
(7.56%)

SELECT DISTINCT id_0, MIN(sclr_16) AS dctrn_minrownum FROM (SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15, ROW_NUMBER() OVER(ORDER BY a0_.raisonsocialeentreprise ASC) AS sclr_16 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = ? AND a0_.publie = ?) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 100

Parameters:

[
  1
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0,
  MIN(sclr_16) AS dctrn_minrownum
FROM
  (
    SELECT
      a0_.id AS id_0,
      a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1,
      a0_.telephoneentreprise AS telephoneentreprise_2,
      a0_.emailentreprise AS emailentreprise_3,
      a0_.boiteposteentreprise AS boiteposteentreprise_4,
      a0_.faxentreprise AS faxentreprise_5,
      a0_.agrement AS agrement_6,
      a0_.delivrance AS delivrance_7,
      a0_.renouvellement AS renouvellement_8,
      a0_.valide AS valide_9,
      a0_.publie AS publie_10,
      a0_.vue AS vue_11,
      a0_.gerant AS gerant_12,
      a0_.accredite AS accredite_13,
      a0_.creele AS creele_14,
      a0_.modifiele AS modifiele_15,
      ROW_NUMBER() OVER(
        ORDER BY
          a0_.raisonsocialeentreprise ASC
      ) AS sclr_16
    FROM
      agent_promoteuret_syndic a0_
    WHERE
      a0_.raisonsocialeentreprise IS NOT NULL
      AND a0_.vue = ?
      AND a0_.publie = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  100

SELECT DISTINCT id_0, MIN(sclr_16) AS dctrn_minrownum FROM (SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15, ROW_NUMBER() OVER(ORDER BY a0_.raisonsocialeentreprise ASC) AS sclr_16 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = '1') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 100;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 102)
8	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 299)
9	App\Twig\Extension\GlobalVarExtension->getStatFront (line 1909)
10	Twig\Extension\CoreExtension::getAttribute (line 109)
11	__TwigTemplate_f9780d7a859005272d59b5e4318cdb25->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1520)
16	Twig\Extension\CoreExtension::include (line 109)
17	__TwigTemplate_f107fd265be3dfab4397368e372eae9f->doDisplay (line 402)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_171fbb689d4b8511dbc707c80b81e27a->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 163)
28	App\Controller\FrontController->professionByRegion (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

18.40 ms
(6.39%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.surface AS surface_4, t0.lattitude AS lattitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.creele AS creele_8, t0.modifiele AS modifiele_9, t0.slug AS slug_10, t0.departement_id AS departement_id_11, t0.area_id AS area_id_12 FROM arrondissement t0 WHERE t0.id = ?

Parameters:

[
  386
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.surface AS surface_4,
  t0.lattitude AS lattitude_5,
  t0.longitude AS longitude_6,
  t0.description AS description_7,
  t0.creele AS creele_8,
  t0.modifiele AS modifiele_9,
  t0.slug AS slug_10,
  t0.departement_id AS departement_id_11,
  t0.area_id AS area_id_12
FROM
  arrondissement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.surface AS surface_4, t0.lattitude AS lattitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.creele AS creele_8, t0.modifiele AS modifiele_9, t0.slug AS slug_10, t0.departement_id AS departement_id_11, t0.area_id AS area_id_12 FROM arrondissement t0 WHERE t0.id = 386;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Arrondissement::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Arrondissement->__get (line 41)
8	App\Entity\Arrondissement->getLabel (line 112)
9	App\Services\InfoAssembler->formatCommune (line 58)
10	App\Services\InfoAssembler->formatAPS (line 138)
11	App\Controller\FrontController->App\Controller\{closure} (line 1)
12	array_map (line 138)
13	App\Controller\FrontController->App\Controller\{closure} (line 48)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
15	Symfony\Component\Cache\LockRegistry::compute (line 102)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
17	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
18	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
19	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
20	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 126)
21	App\Controller\FrontController->professionByRegion (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

18.01 ms
(6.26%)

SELECT a0_.metier_id AS sclr_0, p1_.label AS label_1, p1_.identifiant AS identifiant_2, COUNT(a0_.id) AS sclr_3, SUM(CASE WHEN a0_.accredite = true THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN a0_.accredite = false THEN 1 ELSE 0 END) AS sclr_5 FROM agent_promoteuret_syndic a0_ INNER JOIN profession p1_ ON a0_.metier_id = p1_.id AND (a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = ? AND a0_.publie = ?) GROUP BY a0_.metier_id, p1_.label, p1_.identifiant ORDER BY p1_.label ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.metier_id AS sclr_0,
  p1_.label AS label_1,
  p1_.identifiant AS identifiant_2,
  COUNT(a0_.id) AS sclr_3,
  SUM(
    CASE WHEN a0_.accredite = true THEN
      1
    ELSE
      0
    END
  ) AS sclr_4,
  SUM(
    CASE WHEN a0_.accredite = false THEN
      1
    ELSE
      0
    END
  ) AS sclr_5
FROM
  agent_promoteuret_syndic a0_
  INNER JOIN profession p1_ ON a0_.metier_id = p1_.id
  AND (
    a0_.raisonsocialeentreprise IS NOT NULL
    AND a0_.vue = ?
    AND a0_.publie = ?
  )
GROUP BY
  a0_.metier_id,
  p1_.label,
  p1_.identifiant
ORDER BY
  p1_.label ASC

SELECT a0_.metier_id AS sclr_0, p1_.label AS label_1, p1_.identifiant AS identifiant_2, COUNT(a0_.id) AS sclr_3, SUM(CASE WHEN a0_.accredite = true THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN a0_.accredite = false THEN 1 ELSE 0 END) AS sclr_5 FROM agent_promoteuret_syndic a0_ INNER JOIN profession p1_ ON a0_.metier_id = p1_.id AND (a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = 1) GROUP BY a0_.metier_id, p1_.label, p1_.identifiant ORDER BY p1_.label ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 200)
7	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 299)
8	App\Twig\Extension\GlobalVarExtension->getStatFront (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 109)
10	__TwigTemplate_f9780d7a859005272d59b5e4318cdb25->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1520)
15	Twig\Extension\CoreExtension::include (line 109)
16	__TwigTemplate_f107fd265be3dfab4397368e372eae9f->doDisplay (line 402)
17	Twig\Template->yield (line 55)
18	__TwigTemplate_171fbb689d4b8511dbc707c80b81e27a->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 163)
27	App\Controller\FrontController->professionByRegion (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

17.79 ms
(6.18%)

SELECT t0.id AS id_1, t0.raisonsocialeentreprise AS raisonsocialeentreprise_2, t0.telephoneentreprise AS telephoneentreprise_3, t0.emailentreprise AS emailentreprise_4, t0.boiteposteentreprise AS boiteposteentreprise_5, t0.faxentreprise AS faxentreprise_6, t0.agrement AS agrement_7, t0.delivrance AS delivrance_8, t0.renouvellement AS renouvellement_9, t0.valide AS valide_10, t0.publie AS publie_11, t0.vue AS vue_12, t0.gerant AS gerant_13, t0.accredite AS accredite_14, t0.creele AS creele_15, t0.modifiele AS modifiele_16, t0.area_id AS area_id_17, t0.depart_id AS depart_id_18, t0.arrondissement_id AS arrondissement_id_19, t0.metier_id AS metier_id_20 FROM agent_promoteuret_syndic t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.raisonsocialeentreprise AS raisonsocialeentreprise_2,
  t0.telephoneentreprise AS telephoneentreprise_3,
  t0.emailentreprise AS emailentreprise_4,
  t0.boiteposteentreprise AS boiteposteentreprise_5,
  t0.faxentreprise AS faxentreprise_6,
  t0.agrement AS agrement_7,
  t0.delivrance AS delivrance_8,
  t0.renouvellement AS renouvellement_9,
  t0.valide AS valide_10,
  t0.publie AS publie_11,
  t0.vue AS vue_12,
  t0.gerant AS gerant_13,
  t0.accredite AS accredite_14,
  t0.creele AS creele_15,
  t0.modifiele AS modifiele_16,
  t0.area_id AS area_id_17,
  t0.depart_id AS depart_id_18,
  t0.arrondissement_id AS arrondissement_id_19,
  t0.metier_id AS metier_id_20
FROM
  agent_promoteuret_syndic t0

SELECT t0.id AS id_1, t0.raisonsocialeentreprise AS raisonsocialeentreprise_2, t0.telephoneentreprise AS telephoneentreprise_3, t0.emailentreprise AS emailentreprise_4, t0.boiteposteentreprise AS boiteposteentreprise_5, t0.faxentreprise AS faxentreprise_6, t0.agrement AS agrement_7, t0.delivrance AS delivrance_8, t0.renouvellement AS renouvellement_9, t0.valide AS valide_10, t0.publie AS publie_11, t0.vue AS vue_12, t0.gerant AS gerant_13, t0.accredite AS accredite_14, t0.creele AS creele_15, t0.modifiele AS modifiele_16, t0.area_id AS area_id_17, t0.depart_id AS depart_id_18, t0.arrondissement_id AS arrondissement_id_19, t0.metier_id AS metier_id_20 FROM agent_promoteuret_syndic t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 242)
6	App\Services\EditService->checkAuthorisationDateValidity (line 121)
7	App\Controller\FrontController->professionByRegion (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

17.42 ms
(6.05%)

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE a0_.valide = ? AND a0_.vue = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  agent_promoteuret_syndic a0_
WHERE
  a0_.valide = ?
  AND a0_.vue = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE a0_.valide = 1 AND a0_.vue = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 204)
8	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 299)
9	App\Twig\Extension\GlobalVarExtension->getStatFront (line 1909)
10	Twig\Extension\CoreExtension::getAttribute (line 109)
11	__TwigTemplate_f9780d7a859005272d59b5e4318cdb25->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1520)
16	Twig\Extension\CoreExtension::include (line 109)
17	__TwigTemplate_f107fd265be3dfab4397368e372eae9f->doDisplay (line 402)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_171fbb689d4b8511dbc707c80b81e27a->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 163)
28	App\Controller\FrontController->professionByRegion (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

16.17 ms
(5.62%)

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE a0_.publie = ? AND a0_.vue = ? AND a0_.accredite = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  agent_promoteuret_syndic a0_
WHERE
  a0_.publie = ?
  AND a0_.vue = ?
  AND a0_.accredite = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE a0_.publie = 1 AND a0_.vue = 1 AND a0_.accredite = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 201)
8	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 299)
9	App\Twig\Extension\GlobalVarExtension->getStatFront (line 1909)
10	Twig\Extension\CoreExtension::getAttribute (line 109)
11	__TwigTemplate_f9780d7a859005272d59b5e4318cdb25->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1520)
16	Twig\Extension\CoreExtension::include (line 109)
17	__TwigTemplate_f107fd265be3dfab4397368e372eae9f->doDisplay (line 402)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_171fbb689d4b8511dbc707c80b81e27a->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 163)
28	App\Controller\FrontController->professionByRegion (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

15.52 ms
(5.39%)

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE (a0_.valide = ? AND a0_.vue = ?) AND a0_.area_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  agent_promoteuret_syndic a0_
WHERE
  (
    a0_.valide = ?
    AND a0_.vue = ?
  )
  AND a0_.area_id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE (a0_.valide = 1 AND a0_.vue = 1) AND a0_.area_id = 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 204)
8	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 137)
9	App\Controller\FrontController->App\Controller\{closure} (line 48)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
11	Symfony\Component\Cache\LockRegistry::compute (line 102)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
16	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 126)
17	App\Controller\FrontController->professionByRegion (line 181)
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)

15.00 ms
(5.21%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = ? AND a0_.publie = ? AND a0_.area_id = ? ORDER BY a0_.raisonsocialeentreprise ASC) dctrn_result) dctrn_table

Parameters:

[
  1
  "1"
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1,
          a0_.telephoneentreprise AS telephoneentreprise_2,
          a0_.emailentreprise AS emailentreprise_3,
          a0_.boiteposteentreprise AS boiteposteentreprise_4,
          a0_.faxentreprise AS faxentreprise_5,
          a0_.agrement AS agrement_6,
          a0_.delivrance AS delivrance_7,
          a0_.renouvellement AS renouvellement_8,
          a0_.valide AS valide_9,
          a0_.publie AS publie_10,
          a0_.vue AS vue_11,
          a0_.gerant AS gerant_12,
          a0_.accredite AS accredite_13,
          a0_.creele AS creele_14,
          a0_.modifiele AS modifiele_15
        FROM
          agent_promoteuret_syndic a0_
        WHERE
          a0_.raisonsocialeentreprise IS NOT NULL
          AND a0_.vue = ?
          AND a0_.publie = ?
          AND a0_.area_id = ?
        ORDER BY
          a0_.raisonsocialeentreprise ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = '1' AND a0_.area_id = 9 ORDER BY a0_.raisonsocialeentreprise ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 103)
9	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 137)
10	App\Controller\FrontController->App\Controller\{closure} (line 48)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
12	Symfony\Component\Cache\LockRegistry::compute (line 102)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
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 126)
18	App\Controller\FrontController->professionByRegion (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

14.79 ms
(5.14%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = ? AND a0_.publie = ? ORDER BY a0_.raisonsocialeentreprise ASC) dctrn_result) dctrn_table

Parameters:

[
  1
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1,
          a0_.telephoneentreprise AS telephoneentreprise_2,
          a0_.emailentreprise AS emailentreprise_3,
          a0_.boiteposteentreprise AS boiteposteentreprise_4,
          a0_.faxentreprise AS faxentreprise_5,
          a0_.agrement AS agrement_6,
          a0_.delivrance AS delivrance_7,
          a0_.renouvellement AS renouvellement_8,
          a0_.valide AS valide_9,
          a0_.publie AS publie_10,
          a0_.vue AS vue_11,
          a0_.gerant AS gerant_12,
          a0_.accredite AS accredite_13,
          a0_.creele AS creele_14,
          a0_.modifiele AS modifiele_15
        FROM
          agent_promoteuret_syndic a0_
        WHERE
          a0_.raisonsocialeentreprise IS NOT NULL
          AND a0_.vue = ?
          AND a0_.publie = ?
        ORDER BY
          a0_.raisonsocialeentreprise ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = '1' ORDER BY a0_.raisonsocialeentreprise ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 103)
9	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 299)
10	App\Twig\Extension\GlobalVarExtension->getStatFront (line 1909)
11	Twig\Extension\CoreExtension::getAttribute (line 109)
12	__TwigTemplate_f9780d7a859005272d59b5e4318cdb25->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 1520)
17	Twig\Extension\CoreExtension::include (line 109)
18	__TwigTemplate_f107fd265be3dfab4397368e372eae9f->doDisplay (line 402)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_171fbb689d4b8511dbc707c80b81e27a->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
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 163)
29	App\Controller\FrontController->professionByRegion (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)

14.14 ms
(4.91%)

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE (a0_.publie = ? AND a0_.vue = ? AND a0_.accredite = ?) AND a0_.area_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  agent_promoteuret_syndic a0_
WHERE
  (
    a0_.publie = ?
    AND a0_.vue = ?
    AND a0_.accredite = ?
  )
  AND a0_.area_id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE (a0_.publie = 1 AND a0_.vue = 1 AND a0_.accredite = 1) AND a0_.area_id = 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 201)
8	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 137)
9	App\Controller\FrontController->App\Controller\{closure} (line 48)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
11	Symfony\Component\Cache\LockRegistry::compute (line 102)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
16	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 126)
17	App\Controller\FrontController->professionByRegion (line 181)
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)

10.57 ms
(3.67%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.surface AS surface_4, t0.lattitude AS lattitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.creele AS creele_8, t0.modifiele AS modifiele_9, t0.slug AS slug_10, t0.area_id AS area_id_11 FROM departement t0 WHERE t0.id = ?

Parameters:

[
  45
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.surface AS surface_4,
  t0.lattitude AS lattitude_5,
  t0.longitude AS longitude_6,
  t0.description AS description_7,
  t0.creele AS creele_8,
  t0.modifiele AS modifiele_9,
  t0.slug AS slug_10,
  t0.area_id AS area_id_11
FROM
  departement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.surface AS surface_4, t0.lattitude AS lattitude_5, t0.longitude AS longitude_6, t0.description AS description_7, t0.creele AS creele_8, t0.modifiele AS modifiele_9, t0.slug AS slug_10, t0.area_id AS area_id_11 FROM departement t0 WHERE t0.id = 45;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Departement::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Departement->__get (line 41)
8	App\Entity\Departement->getLabel (line 101)
9	App\Services\InfoAssembler->formatDepartement (line 114)
10	App\Services\InfoAssembler->formatCommune (line 58)
11	App\Services\InfoAssembler->formatAPS (line 138)
12	App\Controller\FrontController->App\Controller\{closure} (line 1)
13	array_map (line 138)
14	App\Controller\FrontController->App\Controller\{closure} (line 48)
15	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
16	Symfony\Component\Cache\LockRegistry::compute (line 102)
17	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
18	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
19	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
20	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
21	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 126)
22	App\Controller\FrontController->professionByRegion (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)

8.42 ms
(2.93%)

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE a0_.publie = ? AND a0_.vue = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  agent_promoteuret_syndic a0_
WHERE
  a0_.publie = ?
  AND a0_.vue = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE a0_.publie = 1 AND a0_.vue = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 203)
8	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 299)
9	App\Twig\Extension\GlobalVarExtension->getStatFront (line 1909)
10	Twig\Extension\CoreExtension::getAttribute (line 109)
11	__TwigTemplate_f9780d7a859005272d59b5e4318cdb25->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1520)
16	Twig\Extension\CoreExtension::include (line 109)
17	__TwigTemplate_f107fd265be3dfab4397368e372eae9f->doDisplay (line 402)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_171fbb689d4b8511dbc707c80b81e27a->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 163)
28	App\Controller\FrontController->professionByRegion (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

8.17 ms
(2.84%)

SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15, a0_.area_id AS area_id_16, a0_.depart_id AS depart_id_17, a0_.arrondissement_id AS arrondissement_id_18, a0_.metier_id AS metier_id_19 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = ? AND a0_.publie = ? AND a0_.area_id = ? ORDER BY a0_.raisonsocialeentreprise ASC

Parameters:

[
  1
  "1"
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1,
  a0_.telephoneentreprise AS telephoneentreprise_2,
  a0_.emailentreprise AS emailentreprise_3,
  a0_.boiteposteentreprise AS boiteposteentreprise_4,
  a0_.faxentreprise AS faxentreprise_5,
  a0_.agrement AS agrement_6,
  a0_.delivrance AS delivrance_7,
  a0_.renouvellement AS renouvellement_8,
  a0_.valide AS valide_9,
  a0_.publie AS publie_10,
  a0_.vue AS vue_11,
  a0_.gerant AS gerant_12,
  a0_.accredite AS accredite_13,
  a0_.creele AS creele_14,
  a0_.modifiele AS modifiele_15,
  a0_.area_id AS area_id_16,
  a0_.depart_id AS depart_id_17,
  a0_.arrondissement_id AS arrondissement_id_18,
  a0_.metier_id AS metier_id_19
FROM
  agent_promoteuret_syndic a0_
WHERE
  a0_.raisonsocialeentreprise IS NOT NULL
  AND a0_.vue = ?
  AND a0_.publie = ?
  AND a0_.area_id = ?
ORDER BY
  a0_.raisonsocialeentreprise ASC

SELECT a0_.id AS id_0, a0_.raisonsocialeentreprise AS raisonsocialeentreprise_1, a0_.telephoneentreprise AS telephoneentreprise_2, a0_.emailentreprise AS emailentreprise_3, a0_.boiteposteentreprise AS boiteposteentreprise_4, a0_.faxentreprise AS faxentreprise_5, a0_.agrement AS agrement_6, a0_.delivrance AS delivrance_7, a0_.renouvellement AS renouvellement_8, a0_.valide AS valide_9, a0_.publie AS publie_10, a0_.vue AS vue_11, a0_.gerant AS gerant_12, a0_.accredite AS accredite_13, a0_.creele AS creele_14, a0_.modifiele AS modifiele_15, a0_.area_id AS area_id_16, a0_.depart_id AS depart_id_17, a0_.arrondissement_id AS arrondissement_id_18, a0_.metier_id AS metier_id_19 FROM agent_promoteuret_syndic a0_ WHERE a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = '1' AND a0_.area_id = 9 ORDER BY a0_.raisonsocialeentreprise ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 151)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 102)
8	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 137)
9	App\Controller\FrontController->App\Controller\{closure} (line 48)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
11	Symfony\Component\Cache\LockRegistry::compute (line 102)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
16	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 126)
17	App\Controller\FrontController->professionByRegion (line 181)
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)

7.46 ms
(2.59%)

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE (a0_.publie = ? AND a0_.vue = ?) AND a0_.area_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  agent_promoteuret_syndic a0_
WHERE
  (
    a0_.publie = ?
    AND a0_.vue = ?
  )
  AND a0_.area_id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM agent_promoteuret_syndic a0_ WHERE (a0_.publie = 1 AND a0_.vue = 1) AND a0_.area_id = 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 203)
8	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 137)
9	App\Controller\FrontController->App\Controller\{closure} (line 48)
10	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
11	Symfony\Component\Cache\LockRegistry::compute (line 102)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
16	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 126)
17	App\Controller\FrontController->professionByRegion (line 181)
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)

6.40 ms
(2.22%)

SELECT a0_.metier_id AS sclr_0, p1_.label AS label_1, p1_.identifiant AS identifiant_2, COUNT(a0_.id) AS sclr_3, SUM(CASE WHEN a0_.accredite = true THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN a0_.accredite = false THEN 1 ELSE 0 END) AS sclr_5 FROM agent_promoteuret_syndic a0_ INNER JOIN profession p1_ ON a0_.metier_id = p1_.id AND (a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = ? AND a0_.publie = ?) WHERE a0_.area_id = ? GROUP BY a0_.metier_id, p1_.label, p1_.identifiant ORDER BY p1_.label ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.metier_id AS sclr_0,
  p1_.label AS label_1,
  p1_.identifiant AS identifiant_2,
  COUNT(a0_.id) AS sclr_3,
  SUM(
    CASE WHEN a0_.accredite = true THEN
      1
    ELSE
      0
    END
  ) AS sclr_4,
  SUM(
    CASE WHEN a0_.accredite = false THEN
      1
    ELSE
      0
    END
  ) AS sclr_5
FROM
  agent_promoteuret_syndic a0_
  INNER JOIN profession p1_ ON a0_.metier_id = p1_.id
  AND (
    a0_.raisonsocialeentreprise IS NOT NULL
    AND a0_.vue = ?
    AND a0_.publie = ?
  )
WHERE
  a0_.area_id = ?
GROUP BY
  a0_.metier_id,
  p1_.label,
  p1_.identifiant
ORDER BY
  p1_.label ASC

SELECT a0_.metier_id AS sclr_0, p1_.label AS label_1, p1_.identifiant AS identifiant_2, COUNT(a0_.id) AS sclr_3, SUM(CASE WHEN a0_.accredite = true THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN a0_.accredite = false THEN 1 ELSE 0 END) AS sclr_5 FROM agent_promoteuret_syndic a0_ INNER JOIN profession p1_ ON a0_.metier_id = p1_.id AND (a0_.raisonsocialeentreprise IS NOT NULL AND a0_.vue = 1 AND a0_.publie = 1) WHERE a0_.area_id = 9 GROUP BY a0_.metier_id, p1_.label, p1_.identifiant ORDER BY p1_.label ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 200)
7	App\Repository\AgentPromoteuretSyndicRepository->getAps (line 137)
8	App\Controller\FrontController->App\Controller\{closure} (line 48)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
10	Symfony\Component\Cache\LockRegistry::compute (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
15	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 126)
16	App\Controller\FrontController->professionByRegion (line 181)
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)

4.60 ms
(1.60%)

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.label AS label_3, t0.description AS description_4, t0.creele AS creele_5, t0.modifiele AS modifiele_6 FROM profession t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifiant AS identifiant_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.creele AS creele_5,
  t0.modifiele AS modifiele_6
FROM
  profession t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.label AS label_3, t0.description AS description_4, t0.creele AS creele_5, t0.modifiele AS modifiele_6 FROM profession t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Profession::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Profession->__get (line 71)
8	App\Entity\Profession->getIdentifiant (line 246)
9	App\Services\EditService->checkAuthorisationDateValidity (line 121)
10	App\Controller\FrontController->professionByRegion (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\AgentPromoteuretSyndic	394
App\Entity\Arrondissement	16
App\Entity\Departement	14
App\Entity\Region	9
App\Entity\Profession	3

Entities Mapping

Class	Mapping errors
App\Entity\AgentPromoteuretSyndic	No errors.
App\Entity\Region	No errors.
App\Entity\Departement	No errors.
App\Entity\Arrondissement	No errors.
App\Entity\Profession	No errors.

Symfony Profiler

GET https://www.minhdu.gov.cm/promotion-immobiliere/home/region_sud-ouest

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping