Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.35 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.63 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.denomination_social AS denomination_social_3, t0.creation AS creation_4, t0.rccm AS rccm_5, t0.idnat AS idnat_6, t0.impot AS impot_7, t0.dossier1 AS dossier1_8, t0.dossier2 AS dossier2_9, t0.dossier3 AS dossier3_10, t0.logo AS logo_11, t0.besoin_invest AS besoin_invest_12, t0.etape AS etape_13, t0.telephone AS telephone_14, t0.adresse AS adresse_15, t0.bancaire AS bancaire_16, t0.statut AS statut_17, t0.valide AS valide_18, t0.gerant_photo AS gerant_photo_19, t0.catalogue AS catalogue_20, t0.description AS description_21, t0.gerant_id AS gerant_id_22 FROM entreprise t0 WHERE t0.catalogue = ?

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.denomination_social AS denomination_social_3,
  t0.creation AS creation_4,
  t0.rccm AS rccm_5,
  t0.idnat AS idnat_6,
  t0.impot AS impot_7,
  t0.dossier1 AS dossier1_8,
  t0.dossier2 AS dossier2_9,
  t0.dossier3 AS dossier3_10,
  t0.logo AS logo_11,
  t0.besoin_invest AS besoin_invest_12,
  t0.etape AS etape_13,
  t0.telephone AS telephone_14,
  t0.adresse AS adresse_15,
  t0.bancaire AS bancaire_16,
  t0.statut AS statut_17,
  t0.valide AS valide_18,
  t0.gerant_photo AS gerant_photo_19,
  t0.catalogue AS catalogue_20,
  t0.description AS description_21,
  t0.gerant_id AS gerant_id_22
FROM
  entreprise t0
WHERE
  t0.catalogue = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.denomination_social AS denomination_social_3, t0.creation AS creation_4, t0.rccm AS rccm_5, t0.idnat AS idnat_6, t0.impot AS impot_7, t0.dossier1 AS dossier1_8, t0.dossier2 AS dossier2_9, t0.dossier3 AS dossier3_10, t0.logo AS logo_11, t0.besoin_invest AS besoin_invest_12, t0.etape AS etape_13, t0.telephone AS telephone_14, t0.adresse AS adresse_15, t0.bancaire AS bancaire_16, t0.statut AS statut_17, t0.valide AS valide_18, t0.gerant_photo AS gerant_photo_19, t0.catalogue AS catalogue_20, t0.description AS description_21, t0.gerant_id AS gerant_id_22 FROM entreprise t0 WHERE t0.catalogue = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 16)
4	App\Controller\IndexController->index (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.41 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM secteur t0 INNER JOIN secteur_entreprise ON t0.id = secteur_entreprise.secteur_id WHERE secteur_entreprise.entreprise_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3
FROM
  secteur t0
  INNER JOIN secteur_entreprise ON t0.id = secteur_entreprise.secteur_id
WHERE
  secteur_entreprise.entreprise_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM secteur t0 INNER JOIN secteur_entreprise ON t0.id = secteur_entreprise.secteur_id WHERE secteur_entreprise.entreprise_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1092)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3290)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 711)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 424)
8	__TwigTemplate_648b854ad6deb0a5270720664b29c902->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 19)
17	App\Controller\IndexController->index (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)

0.32 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM secteur t0 INNER JOIN secteur_entreprise ON t0.id = secteur_entreprise.secteur_id WHERE secteur_entreprise.entreprise_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3
FROM
  secteur t0
  INNER JOIN secteur_entreprise ON t0.id = secteur_entreprise.secteur_id
WHERE
  secteur_entreprise.entreprise_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM secteur t0 INNER JOIN secteur_entreprise ON t0.id = secteur_entreprise.secteur_id WHERE secteur_entreprise.entreprise_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1092)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3290)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 711)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 424)
8	__TwigTemplate_648b854ad6deb0a5270720664b29c902->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 19)
17	App\Controller\IndexController->index (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)

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\Entreprise	No errors.
App\Entity\User	No errors.
App\Entity\Secteur	No errors.
App\Entity\RendezVous	No errors.

Symfony Profiler

GET http://74.208.202.229/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping