Symfony Profiler

Query Metrics

178 Database Queries

6 Different statements

61.66 ms Query time

0 Invalid entities

221 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.20 ms
(24.65%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__activite t0
  INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id
WHERE
  sejour__sejour_activite.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 227)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 170)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->normalize (line 74)
13	App\Sejour\Controller\ApiController->list (line 105)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

14.84 ms
(24.07%)

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.sejour_id AS sejour_id_3, t0.champ_id AS champ_id_4 FROM sejour__champ_valeur t0 WHERE t0.sejour_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2,
  t0.sejour_id AS sejour_id_3,
  t0.champ_id AS champ_id_4
FROM
  sejour__champ_valeur t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.sejour_id AS sejour_id_3, t0.champ_id AS champ_id_4 FROM sejour__champ_valeur t0 WHERE t0.sejour_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 227)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 170)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->normalize (line 74)
13	App\Sejour\Controller\ApiController->list (line 105)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

14.61 ms
(23.70%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.path AS path_5, t0.sejour_id AS sejour_id_6 FROM sejour__media t0 WHERE t0.sejour_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.path AS path_5,
  t0.sejour_id AS sejour_id_6
FROM
  sejour__media t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.path AS path_5, t0.sejour_id AS sejour_id_6 FROM sejour__media t0 WHERE t0.sejour_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 227)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 170)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->normalize (line 74)
13	App\Sejour\Controller\ApiController->list (line 105)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

14.55 ms
(23.60%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__destination t0
  INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id
WHERE
  sejour__sejour_destination.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Symfony\Component\Serializer\Serializer->normalize (line 169)
8	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 227)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	Symfony\Component\Serializer\Serializer->normalize (line 170)
12	Symfony\Component\Serializer\Debug\TraceableSerializer->normalize (line 74)
13	App\Sejour\Controller\ApiController->list (line 105)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

2.09 ms
(3.39%)

SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.resume AS resume_3, s0_.accroche AS accroche_4, s0_.code_sejour AS code_sejour_5, s0_.nb_jours AS nb_jours_6, s0_.nb_nuits AS nb_nuits_7, s0_.nb_jours_activite AS nb_jours_activite_8, s0_.vignette AS vignette_9, s0_.img_principale AS img_principale_10, s0_.fiche_technique_pdf AS fiche_technique_pdf_11, s0_.mise_en_avant AS mise_en_avant_12, s0_.publie AS publie_13, s0_.prix_default AS prix_default_14, s0_.montant_acompte AS montant_acompte_15, s0_.pourcentage_acompte AS pourcentage_acompte_16, s0_.stock_default AS stock_default_17, s0_.coord_depart AS coord_depart_18, s0_.coord_arrivee AS coord_arrivee_19, s1_.id AS id_20, s1_.date_debut AS date_debut_21, s1_.date_fin AS date_fin_22, s1_.commentaire AS commentaire_23, s1_.prix AS prix_24, s1_.stock_initial AS stock_initial_25, s1_.stock AS stock_26, s1_.effectif_mini AS effectif_mini_27, s1_.statut AS statut_28, s2_.id AS id_29, s2_.libelle AS libelle_30, s3_.id AS id_31, s3_.libelle AS libelle_32, s0_.niveau_id AS niveau_id_33, s1_.sejour_id AS sejour_id_34 FROM sejour__sejour s0_ LEFT JOIN sejour__session s1_ ON s0_.id = s1_.sejour_id LEFT JOIN sejour__sejour_categorie s4_ ON s0_.id = s4_.sejour_id LEFT JOIN sejour__categorie s2_ ON s2_.id = s4_.categorie_id LEFT JOIN sejour__niveau s3_ ON s0_.niveau_id = s3_.id ORDER BY s0_.id ASC LIMIT 1000

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.nom AS nom_1,
  s0_.description AS description_2,
  s0_.resume AS resume_3,
  s0_.accroche AS accroche_4,
  s0_.code_sejour AS code_sejour_5,
  s0_.nb_jours AS nb_jours_6,
  s0_.nb_nuits AS nb_nuits_7,
  s0_.nb_jours_activite AS nb_jours_activite_8,
  s0_.vignette AS vignette_9,
  s0_.img_principale AS img_principale_10,
  s0_.fiche_technique_pdf AS fiche_technique_pdf_11,
  s0_.mise_en_avant AS mise_en_avant_12,
  s0_.publie AS publie_13,
  s0_.prix_default AS prix_default_14,
  s0_.montant_acompte AS montant_acompte_15,
  s0_.pourcentage_acompte AS pourcentage_acompte_16,
  s0_.stock_default AS stock_default_17,
  s0_.coord_depart AS coord_depart_18,
  s0_.coord_arrivee AS coord_arrivee_19,
  s1_.id AS id_20,
  s1_.date_debut AS date_debut_21,
  s1_.date_fin AS date_fin_22,
  s1_.commentaire AS commentaire_23,
  s1_.prix AS prix_24,
  s1_.stock_initial AS stock_initial_25,
  s1_.stock AS stock_26,
  s1_.effectif_mini AS effectif_mini_27,
  s1_.statut AS statut_28,
  s2_.id AS id_29,
  s2_.libelle AS libelle_30,
  s3_.id AS id_31,
  s3_.libelle AS libelle_32,
  s0_.niveau_id AS niveau_id_33,
  s1_.sejour_id AS sejour_id_34
FROM
  sejour__sejour s0_
  LEFT JOIN sejour__session s1_ ON s0_.id = s1_.sejour_id
  LEFT JOIN sejour__sejour_categorie s4_ ON s0_.id = s4_.sejour_id
  LEFT JOIN sejour__categorie s2_ ON s2_.id = s4_.categorie_id
  LEFT JOIN sejour__niveau s3_ ON s0_.niveau_id = s3_.id
ORDER BY
  s0_.id ASC
LIMIT
  1000

SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.resume AS resume_3, s0_.accroche AS accroche_4, s0_.code_sejour AS code_sejour_5, s0_.nb_jours AS nb_jours_6, s0_.nb_nuits AS nb_nuits_7, s0_.nb_jours_activite AS nb_jours_activite_8, s0_.vignette AS vignette_9, s0_.img_principale AS img_principale_10, s0_.fiche_technique_pdf AS fiche_technique_pdf_11, s0_.mise_en_avant AS mise_en_avant_12, s0_.publie AS publie_13, s0_.prix_default AS prix_default_14, s0_.montant_acompte AS montant_acompte_15, s0_.pourcentage_acompte AS pourcentage_acompte_16, s0_.stock_default AS stock_default_17, s0_.coord_depart AS coord_depart_18, s0_.coord_arrivee AS coord_arrivee_19, s1_.id AS id_20, s1_.date_debut AS date_debut_21, s1_.date_fin AS date_fin_22, s1_.commentaire AS commentaire_23, s1_.prix AS prix_24, s1_.stock_initial AS stock_initial_25, s1_.stock AS stock_26, s1_.effectif_mini AS effectif_mini_27, s1_.statut AS statut_28, s2_.id AS id_29, s2_.libelle AS libelle_30, s3_.id AS id_31, s3_.libelle AS libelle_32, s0_.niveau_id AS niveau_id_33, s1_.sejour_id AS sejour_id_34 FROM sejour__sejour s0_ LEFT JOIN sejour__session s1_ ON s0_.id = s1_.sejour_id LEFT JOIN sejour__sejour_categorie s4_ ON s0_.id = s4_.sejour_id LEFT JOIN sejour__categorie s2_ ON s2_.id = s4_.categorie_id LEFT JOIN sejour__niveau s3_ ON s0_.niveau_id = s3_.id ORDER BY s0_.id ASC LIMIT 1000;

#	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->getResult (line 688)
6	App\Sejour\Controller\ApiController->list (line 73)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.37 ms
(0.60%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.type AS type_3, t0.options AS options_4 FROM sejour__champ t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.type AS type_3,
  t0.options AS options_4
FROM
  sejour__champ t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.type AS type_3, t0.options AS options_4 FROM sejour__champ t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Sejour\Entity\Champ::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Sejour\Entity\Champ->__get (line 153)
7	App\Sejour\Entity\Champ->getType (line 61)
8	App\Sejour\Entity\ChampValeur->getValeur (line 65)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
11	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 147)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 199)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Serializer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->normalize (line 170)
16	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 227)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Serializer->normalize (line 152)
19	Symfony\Component\Serializer\Serializer->normalize (line 170)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->normalize (line 74)
21	App\Sejour\Controller\ApiController->list (line 105)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	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\Sejour\Entity\Media	80
App\Sejour\Entity\Session	47
App\Sejour\Entity\Sejour	44
App\Sejour\Entity\ChampValeur	44
App\Sejour\Entity\Destination	5
App\Sejour\Entity\Champ	1

Entities Mapping

Class	Mapping errors
App\Sejour\Entity\Sejour	No errors.
App\Sejour\Entity\Session	No errors.
App\Sejour\Entity\Categorie	No errors.
App\Sejour\Entity\Niveau	No errors.
App\Sejour\Entity\Activite	No errors.
App\Sejour\Entity\Destination	No errors.
App\Sejour\Entity\Media	No errors.
App\Sejour\Entity\ChampValeur	No errors.
App\Sejour\Entity\Champ	No errors.

Symfony Profiler

GET https://deltavia.yuhina.fr/sejour/api/export-sejours/json

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping