Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

26 Database Queries

19 Different statements

39.82 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.46 ms
(36.30%)

SELECT r0_.libelle AS libelle_0, r0_.slug AS slug_1, r0_.region_adm AS region_adm_2, r0_.ancienne AS ancienne_3, r0_.onglets AS onglets_4, r0_.id AS id_5, r0_.maj AS maj_6, r0_.pays_id AS pays_id_7 FROM region r0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.libelle AS libelle_0,
  r0_.slug AS slug_1,
  r0_.region_adm AS region_adm_2,
  r0_.ancienne AS ancienne_3,
  r0_.onglets AS onglets_4,
  r0_.id AS id_5,
  r0_.maj AS maj_6,
  r0_.pays_id AS pays_id_7
FROM
  region r0_

SELECT r0_.libelle AS libelle_0, r0_.slug AS slug_1, r0_.region_adm AS region_adm_2, r0_.ancienne AS ancienne_3, r0_.onglets AS onglets_4, r0_.id AS id_5, r0_.maj AS maj_6, r0_.pays_id AS pays_id_7 FROM region r0_;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 895)
3	Doctrine\DBAL\Connection->fetchAllAssociative (line 1141)
4	Doctrine\DBAL\Connection->executeCacheQuery (line 1072)
5	Doctrine\DBAL\Connection->executeQuery (line 31)
6	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
7	Doctrine\ORM\Query->_doExecute (line 1212)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
9	Doctrine\ORM\AbstractQuery->execute (line 901)
10	Doctrine\ORM\AbstractQuery->getResult (line 95)
11	App\Service\Slugify->findBySlug (line 57)
12	App\Service\Slugify->revealLieu (line 1635)
13	twig_get_attribute (line 94)
14	__TwigTemplate_425cc135202ac3d6d6d4e7bfd82a94a3acfa0510ef17d726bcdde2780af88092->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 932)
17	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->block_contexte (line 171)
18	Twig\Template->displayBlock (line 850)
19	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->block_body (line 171)
20	Twig\Template->displayBlock (line 343)
21	__TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 74)
24	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 40)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 258)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 472)
32	App\Controller\FicheController->index (line 163)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
35	Symfony\Component\HttpKernel\Kernel->handle (line 86)
36	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
38	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
39	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
41	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
42	Symfony\Component\HttpKernel\Kernel->handle (line 22)

8.11 ms
(20.36%)

SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = ?

Parameters:

[
  "75118"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.slug AS slug_1,
  t0.libelle AS libelle_2,
  t0.code_postal AS code_postal_3,
  t0.email_delegue AS email_delegue_4,
  t0.onglets AS onglets_5,
  t0.id AS id_6,
  t0.maj AS maj_7,
  t0.departement_id AS departement_id_8,
  t9.latitude AS latitude_10,
  t9.longitude AS longitude_11,
  t9.id AS id_12,
  t9.ville_id AS ville_id_13
FROM
  ville t0
  LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id
WHERE
  t0.id = ?

SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = '75118';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 207)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 219)
6	Closure->__invoke (line 219)
7	Proxies\__CG__\App\Entity\Ville->getLibelle (line 112)
8	App\Service\PathBuilder->buildFiche (line 136)
9	App\Controller\FicheController->index (line 163)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
12	Symfony\Component\HttpKernel\Kernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
15	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
19	Symfony\Component\HttpKernel\Kernel->handle (line 22)

4.95 ms
(12.44%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url AS url_3, t0.actif AS actif_4, t0.position AS position_5, t0.texte AS texte_6, t0.file_name AS file_name_7, t0.file_size AS file_size_8, t0.updated_at AS updated_at_9, t0.file_name_source AS file_name_source_10, t0.file_size_source AS file_size_source_11, t0.date_crea AS date_crea_12, t0.date_maj AS date_maj_13 FROM video t0 INNER JOIN video_etablissement ON t0.id = video_etablissement.video_id WHERE video_etablissement.etablissement_id = ?

Parameters:

[
  "ET075-480"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.url AS url_3,
  t0.actif AS actif_4,
  t0.position AS position_5,
  t0.texte AS texte_6,
  t0.file_name AS file_name_7,
  t0.file_size AS file_size_8,
  t0.updated_at AS updated_at_9,
  t0.file_name_source AS file_name_source_10,
  t0.file_size_source AS file_size_source_11,
  t0.date_crea AS date_crea_12,
  t0.date_maj AS date_maj_13
FROM
  video t0
  INNER JOIN video_etablissement ON t0.id = video_etablissement.video_id
WHERE
  video_etablissement.etablissement_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url AS url_3, t0.actif AS actif_4, t0.position AS position_5, t0.texte AS texte_6, t0.file_name AS file_name_7, t0.file_size AS file_size_8, t0.updated_at AS updated_at_9, t0.file_name_source AS file_name_source_10, t0.file_size_source AS file_size_source_11, t0.date_crea AS date_crea_12, t0.date_maj AS date_maj_13 FROM video t0 INNER JOIN video_etablissement ON t0.id = video_etablissement.video_id WHERE video_etablissement.etablissement_id = 'ET075-480';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 1064)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 986)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3041)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 38)
8	Doctrine\Common\Collections\AbstractLazyCollection->count (line 452)
9	Doctrine\ORM\PersistentCollection->count (line 1129)
10	twig_length_filter (line 250)
11	__TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 74)
14	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 258)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 472)
22	App\Controller\FicheController->index (line 163)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
25	Symfony\Component\HttpKernel\Kernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
28	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
32	Symfony\Component\HttpKernel\Kernel->handle (line 22)

3.58 ms
(9.00%)

SELECT e0_.type AS type_0, e0_.nombre_eleves AS nombre_eleves_1, e0_.url AS url_2, e0_.video AS video_3, e0_.mots_cles AS mots_cles_4, e0_.denomination AS denomination_5, e0_.denomination_sigle AS denomination_sigle_6, e0_.denomination_extension AS denomination_extension_7, e0_.denomination_abregee AS denomination_abregee_8, e0_.droit_page_web AS droit_page_web_9, e0_.droit_actualite AS droit_actualite_10, e0_.adresse1 AS adresse1_11, e0_.adresse2 AS adresse2_12, e0_.adresse3 AS adresse3_13, e0_.code_postal AS code_postal_14, e0_.cedex AS cedex_15, e0_.latitude AS latitude_16, e0_.longitude AS longitude_17, e0_.telephone_principal AS telephone_principal_18, e0_.fax AS fax_19, e0_.email_principal AS email_principal_20, e0_.logo_liste AS logo_liste_21, e0_.logo_fiche AS logo_fiche_22, e0_.diaporama_actif AS diaporama_actif_23, e0_.images_diaporama AS images_diaporama_24, e0_.participant AS participant_25, e0_.catholique AS catholique_26, e0_.age_admission AS age_admission_27, e0_.actif AS actif_28, e0_.internat AS internat_29, e0_.has_internat AS has_internat_30, e0_.types_internat AS types_internat_31, e0_.sous_contrat AS sous_contrat_32, e0_.alternance AS alternance_33, e0_.type_client AS type_client_34, e0_.bloque_txt_ref AS bloque_txt_ref_35, e0_.facebook AS facebook_36, e0_.bloque_bac2021 AS bloque_bac2021_37, e0_.presence_web AS presence_web_38, e0_.video_plus AS video_plus_39, e0_.diapo_plus AS diapo_plus_40, e0_.jpo_plus AS jpo_plus_41, e0_.doc_plus AS doc_plus_42, e0_.diplome_plus AS diplome_plus_43, e0_.refus AS refus_44, e0_.path AS path_45, e0_.composition_ensemble_scolaire AS composition_ensemble_scolaire_46, e0_.lva AS lva_47, e0_.lvb AS lvb_48, e0_.numero_administratif_uai AS numero_administratif_uai_49, e0_.siret AS siret_50, e0_.chiffres AS chiffres_51, e0_.id AS id_52, e0_.maj AS maj_53, v1_.slug AS slug_54, v1_.libelle AS libelle_55, v1_.code_postal AS code_postal_56, v1_.email_delegue AS email_delegue_57, v1_.onglets AS onglets_58, v1_.id AS id_59, v1_.maj AS maj_60, v2_.latitude AS latitude_61, v2_.longitude AS longitude_62, v2_.id AS id_63, d3_.slug AS slug_64, d3_.libelle AS libelle_65, d3_.onglets AS onglets_66, d3_.id AS id_67, d3_.maj AS maj_68, d4_.latitude AS latitude_69, d4_.longitude AS longitude_70, d4_.id AS id_71, a5_.slug AS slug_72, a5_.libelle AS libelle_73, a5_.id AS id_74, a5_.maj AS maj_75, r6_.libelle AS libelle_76, r6_.slug AS slug_77, r6_.region_adm AS region_adm_78, r6_.ancienne AS ancienne_79, r6_.onglets AS onglets_80, r6_.id AS id_81, r6_.maj AS maj_82, p7_.libelle AS libelle_83, p7_.id AS id_84, p7_.maj AS maj_85, c8_.libelle AS libelle_86, c8_.id AS id_87, c8_.maj AS maj_88, t9_.actif AS actif_89, t9_.contenu AS contenu_90, t9_.id AS id_91, d10_.id AS id_92, d10_.titre AS titre_93, d10_.texte AS texte_94, d10_.actif AS actif_95, d10_.position AS position_96, d10_.principal AS principal_97, d10_.date_crea AS date_crea_98, d10_.date_maj AS date_maj_99, d11_.id AS id_100, d11_.titre AS titre_101, d11_.legende AS legende_102, d11_.actif AS actif_103, d11_.position AS position_104, d11_.file_name AS file_name_105, d11_.file_size AS file_size_106, d11_.updated_at AS updated_at_107, d11_.file_name_source AS file_name_source_108, d11_.file_size_source AS file_size_source_109, v12_.id AS id_110, v12_.titre AS titre_111, v12_.url AS url_112, v12_.actif AS actif_113, v12_.position AS position_114, v12_.texte AS texte_115, v12_.file_name AS file_name_116, v12_.file_size AS file_size_117, v12_.updated_at AS updated_at_118, v12_.file_name_source AS file_name_source_119, v12_.file_size_source AS file_size_source_120, v12_.date_crea AS date_crea_121, v12_.date_maj AS date_maj_122, l13_.id AS id_123, l13_.file_name AS file_name_124, l13_.file_size AS file_size_125, l13_.updated_at AS updated_at_126, l13_.file_name_source AS file_name_source_127, l13_.file_size_source AS file_size_source_128, l13_.date_crea AS date_crea_129, l13_.date_maj AS date_maj_130, e0_.gestionnaire_id AS gestionnaire_id_131, e0_.ville_id AS ville_id_132, e0_.categorie_primaire_id AS categorie_primaire_id_133, e0_.region_id AS region_id_134, e0_.departement_id AS departement_id_135, e0_.categorie_organisme_id AS categorie_organisme_id_136, e0_.rubrique AS rubrique_137, e0_.internat2_id AS internat2_id_138, e0_.etablissement_lie_id AS etablissement_lie_id_139, e0_.logo_id AS logo_id_140, e0_.diapo_principal_id AS diapo_principal_id_141, v1_.departement_id AS departement_id_142, v2_.ville_id AS ville_id_143, d3_.ancienne_region_id AS ancienne_region_id_144, d3_.region_id AS region_id_145, d4_.departement_id AS departement_id_146, a5_.region_id AS region_id_147, r6_.pays_id AS pays_id_148, t9_.etablissement_id AS etablissement_id_149, t9_.template_id AS template_id_150, d11_.diaporama_id AS diaporama_id_151 FROM etablissement e0_ LEFT JOIN ville v1_ ON e0_.ville_id = v1_.id LEFT JOIN ville_coordonnees v2_ ON v1_.id = v2_.ville_id LEFT JOIN departement d3_ ON v1_.departement_id = d3_.id LEFT JOIN departement_coordonnees d4_ ON d3_.id = d4_.departement_id LEFT JOIN ancienne_region a5_ ON d3_.ancienne_region_id = a5_.id LEFT JOIN region r6_ ON a5_.region_id = r6_.id LEFT JOIN pays p7_ ON r6_.pays_id = p7_.id LEFT JOIN categorie c8_ ON e0_.categorie_primaire_id = c8_.id LEFT JOIN texte_referencement t9_ ON e0_.id = t9_.etablissement_id LEFT JOIN diaporama_etablissement d14_ ON e0_.id = d14_.etablissement_id LEFT JOIN diaporama d10_ ON d10_.id = d14_.diaporama_id LEFT JOIN diaporama_photo d11_ ON d10_.id = d11_.diaporama_id LEFT JOIN video_etablissement v15_ ON e0_.id = v15_.etablissement_id LEFT JOIN video v12_ ON v12_.id = v15_.video_id LEFT JOIN logo l13_ ON e0_.logo_id = l13_.id WHERE e0_.id IN (?) ORDER BY d11_.position ASC

Parameters:

[
  [
    "ET075-674"
    "ET075-387"
    "ET075-359"
    "ET075-476"
    "ET093-33"
    "ET075-325"
  ]
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.type AS type_0,
  e0_.nombre_eleves AS nombre_eleves_1,
  e0_.url AS url_2,
  e0_.video AS video_3,
  e0_.mots_cles AS mots_cles_4,
  e0_.denomination AS denomination_5,
  e0_.denomination_sigle AS denomination_sigle_6,
  e0_.denomination_extension AS denomination_extension_7,
  e0_.denomination_abregee AS denomination_abregee_8,
  e0_.droit_page_web AS droit_page_web_9,
  e0_.droit_actualite AS droit_actualite_10,
  e0_.adresse1 AS adresse1_11,
  e0_.adresse2 AS adresse2_12,
  e0_.adresse3 AS adresse3_13,
  e0_.code_postal AS code_postal_14,
  e0_.cedex AS cedex_15,
  e0_.latitude AS latitude_16,
  e0_.longitude AS longitude_17,
  e0_.telephone_principal AS telephone_principal_18,
  e0_.fax AS fax_19,
  e0_.email_principal AS email_principal_20,
  e0_.logo_liste AS logo_liste_21,
  e0_.logo_fiche AS logo_fiche_22,
  e0_.diaporama_actif AS diaporama_actif_23,
  e0_.images_diaporama AS images_diaporama_24,
  e0_.participant AS participant_25,
  e0_.catholique AS catholique_26,
  e0_.age_admission AS age_admission_27,
  e0_.actif AS actif_28,
  e0_.internat AS internat_29,
  e0_.has_internat AS has_internat_30,
  e0_.types_internat AS types_internat_31,
  e0_.sous_contrat AS sous_contrat_32,
  e0_.alternance AS alternance_33,
  e0_.type_client AS type_client_34,
  e0_.bloque_txt_ref AS bloque_txt_ref_35,
  e0_.facebook AS facebook_36,
  e0_.bloque_bac2021 AS bloque_bac2021_37,
  e0_.presence_web AS presence_web_38,
  e0_.video_plus AS video_plus_39,
  e0_.diapo_plus AS diapo_plus_40,
  e0_.jpo_plus AS jpo_plus_41,
  e0_.doc_plus AS doc_plus_42,
  e0_.diplome_plus AS diplome_plus_43,
  e0_.refus AS refus_44,
  e0_.path AS path_45,
  e0_.composition_ensemble_scolaire AS composition_ensemble_scolaire_46,
  e0_.lva AS lva_47,
  e0_.lvb AS lvb_48,
  e0_.numero_administratif_uai AS numero_administratif_uai_49,
  e0_.siret AS siret_50,
  e0_.chiffres AS chiffres_51,
  e0_.id AS id_52,
  e0_.maj AS maj_53,
  v1_.slug AS slug_54,
  v1_.libelle AS libelle_55,
  v1_.code_postal AS code_postal_56,
  v1_.email_delegue AS email_delegue_57,
  v1_.onglets AS onglets_58,
  v1_.id AS id_59,
  v1_.maj AS maj_60,
  v2_.latitude AS latitude_61,
  v2_.longitude AS longitude_62,
  v2_.id AS id_63,
  d3_.slug AS slug_64,
  d3_.libelle AS libelle_65,
  d3_.onglets AS onglets_66,
  d3_.id AS id_67,
  d3_.maj AS maj_68,
  d4_.latitude AS latitude_69,
  d4_.longitude AS longitude_70,
  d4_.id AS id_71,
  a5_.slug AS slug_72,
  a5_.libelle AS libelle_73,
  a5_.id AS id_74,
  a5_.maj AS maj_75,
  r6_.libelle AS libelle_76,
  r6_.slug AS slug_77,
  r6_.region_adm AS region_adm_78,
  r6_.ancienne AS ancienne_79,
  r6_.onglets AS onglets_80,
  r6_.id AS id_81,
  r6_.maj AS maj_82,
  p7_.libelle AS libelle_83,
  p7_.id AS id_84,
  p7_.maj AS maj_85,
  c8_.libelle AS libelle_86,
  c8_.id AS id_87,
  c8_.maj AS maj_88,
  t9_.actif AS actif_89,
  t9_.contenu AS contenu_90,
  t9_.id AS id_91,
  d10_.id AS id_92,
  d10_.titre AS titre_93,
  d10_.texte AS texte_94,
  d10_.actif AS actif_95,
  d10_.position AS position_96,
  d10_.principal AS principal_97,
  d10_.date_crea AS date_crea_98,
  d10_.date_maj AS date_maj_99,
  d11_.id AS id_100,
  d11_.titre AS titre_101,
  d11_.legende AS legende_102,
  d11_.actif AS actif_103,
  d11_.position AS position_104,
  d11_.file_name AS file_name_105,
  d11_.file_size AS file_size_106,
  d11_.updated_at AS updated_at_107,
  d11_.file_name_source AS file_name_source_108,
  d11_.file_size_source AS file_size_source_109,
  v12_.id AS id_110,
  v12_.titre AS titre_111,
  v12_.url AS url_112,
  v12_.actif AS actif_113,
  v12_.position AS position_114,
  v12_.texte AS texte_115,
  v12_.file_name AS file_name_116,
  v12_.file_size AS file_size_117,
  v12_.updated_at AS updated_at_118,
  v12_.file_name_source AS file_name_source_119,
  v12_.file_size_source AS file_size_source_120,
  v12_.date_crea AS date_crea_121,
  v12_.date_maj AS date_maj_122,
  l13_.id AS id_123,
  l13_.file_name AS file_name_124,
  l13_.file_size AS file_size_125,
  l13_.updated_at AS updated_at_126,
  l13_.file_name_source AS file_name_source_127,
  l13_.file_size_source AS file_size_source_128,
  l13_.date_crea AS date_crea_129,
  l13_.date_maj AS date_maj_130,
  e0_.gestionnaire_id AS gestionnaire_id_131,
  e0_.ville_id AS ville_id_132,
  e0_.categorie_primaire_id AS categorie_primaire_id_133,
  e0_.region_id AS region_id_134,
  e0_.departement_id AS departement_id_135,
  e0_.categorie_organisme_id AS categorie_organisme_id_136,
  e0_.rubrique AS rubrique_137,
  e0_.internat2_id AS internat2_id_138,
  e0_.etablissement_lie_id AS etablissement_lie_id_139,
  e0_.logo_id AS logo_id_140,
  e0_.diapo_principal_id AS diapo_principal_id_141,
  v1_.departement_id AS departement_id_142,
  v2_.ville_id AS ville_id_143,
  d3_.ancienne_region_id AS ancienne_region_id_144,
  d3_.region_id AS region_id_145,
  d4_.departement_id AS departement_id_146,
  a5_.region_id AS region_id_147,
  r6_.pays_id AS pays_id_148,
  t9_.etablissement_id AS etablissement_id_149,
  t9_.template_id AS template_id_150,
  d11_.diaporama_id AS diaporama_id_151
FROM
  etablissement e0_
  LEFT JOIN ville v1_ ON e0_.ville_id = v1_.id
  LEFT JOIN ville_coordonnees v2_ ON v1_.id = v2_.ville_id
  LEFT JOIN departement d3_ ON v1_.departement_id = d3_.id
  LEFT JOIN departement_coordonnees d4_ ON d3_.id = d4_.departement_id
  LEFT JOIN ancienne_region a5_ ON d3_.ancienne_region_id = a5_.id
  LEFT JOIN region r6_ ON a5_.region_id = r6_.id
  LEFT JOIN pays p7_ ON r6_.pays_id = p7_.id
  LEFT JOIN categorie c8_ ON e0_.categorie_primaire_id = c8_.id
  LEFT JOIN texte_referencement t9_ ON e0_.id = t9_.etablissement_id
  LEFT JOIN diaporama_etablissement d14_ ON e0_.id = d14_.etablissement_id
  LEFT JOIN diaporama d10_ ON d10_.id = d14_.diaporama_id
  LEFT JOIN diaporama_photo d11_ ON d10_.id = d11_.diaporama_id
  LEFT JOIN video_etablissement v15_ ON e0_.id = v15_.etablissement_id
  LEFT JOIN video v12_ ON v12_.id = v15_.video_id
  LEFT JOIN logo l13_ ON e0_.logo_id = l13_.id
WHERE
  e0_.id IN (?)
ORDER BY
  d11_.position ASC

SELECT e0_.type AS type_0, e0_.nombre_eleves AS nombre_eleves_1, e0_.url AS url_2, e0_.video AS video_3, e0_.mots_cles AS mots_cles_4, e0_.denomination AS denomination_5, e0_.denomination_sigle AS denomination_sigle_6, e0_.denomination_extension AS denomination_extension_7, e0_.denomination_abregee AS denomination_abregee_8, e0_.droit_page_web AS droit_page_web_9, e0_.droit_actualite AS droit_actualite_10, e0_.adresse1 AS adresse1_11, e0_.adresse2 AS adresse2_12, e0_.adresse3 AS adresse3_13, e0_.code_postal AS code_postal_14, e0_.cedex AS cedex_15, e0_.latitude AS latitude_16, e0_.longitude AS longitude_17, e0_.telephone_principal AS telephone_principal_18, e0_.fax AS fax_19, e0_.email_principal AS email_principal_20, e0_.logo_liste AS logo_liste_21, e0_.logo_fiche AS logo_fiche_22, e0_.diaporama_actif AS diaporama_actif_23, e0_.images_diaporama AS images_diaporama_24, e0_.participant AS participant_25, e0_.catholique AS catholique_26, e0_.age_admission AS age_admission_27, e0_.actif AS actif_28, e0_.internat AS internat_29, e0_.has_internat AS has_internat_30, e0_.types_internat AS types_internat_31, e0_.sous_contrat AS sous_contrat_32, e0_.alternance AS alternance_33, e0_.type_client AS type_client_34, e0_.bloque_txt_ref AS bloque_txt_ref_35, e0_.facebook AS facebook_36, e0_.bloque_bac2021 AS bloque_bac2021_37, e0_.presence_web AS presence_web_38, e0_.video_plus AS video_plus_39, e0_.diapo_plus AS diapo_plus_40, e0_.jpo_plus AS jpo_plus_41, e0_.doc_plus AS doc_plus_42, e0_.diplome_plus AS diplome_plus_43, e0_.refus AS refus_44, e0_.path AS path_45, e0_.composition_ensemble_scolaire AS composition_ensemble_scolaire_46, e0_.lva AS lva_47, e0_.lvb AS lvb_48, e0_.numero_administratif_uai AS numero_administratif_uai_49, e0_.siret AS siret_50, e0_.chiffres AS chiffres_51, e0_.id AS id_52, e0_.maj AS maj_53, v1_.slug AS slug_54, v1_.libelle AS libelle_55, v1_.code_postal AS code_postal_56, v1_.email_delegue AS email_delegue_57, v1_.onglets AS onglets_58, v1_.id AS id_59, v1_.maj AS maj_60, v2_.latitude AS latitude_61, v2_.longitude AS longitude_62, v2_.id AS id_63, d3_.slug AS slug_64, d3_.libelle AS libelle_65, d3_.onglets AS onglets_66, d3_.id AS id_67, d3_.maj AS maj_68, d4_.latitude AS latitude_69, d4_.longitude AS longitude_70, d4_.id AS id_71, a5_.slug AS slug_72, a5_.libelle AS libelle_73, a5_.id AS id_74, a5_.maj AS maj_75, r6_.libelle AS libelle_76, r6_.slug AS slug_77, r6_.region_adm AS region_adm_78, r6_.ancienne AS ancienne_79, r6_.onglets AS onglets_80, r6_.id AS id_81, r6_.maj AS maj_82, p7_.libelle AS libelle_83, p7_.id AS id_84, p7_.maj AS maj_85, c8_.libelle AS libelle_86, c8_.id AS id_87, c8_.maj AS maj_88, t9_.actif AS actif_89, t9_.contenu AS contenu_90, t9_.id AS id_91, d10_.id AS id_92, d10_.titre AS titre_93, d10_.texte AS texte_94, d10_.actif AS actif_95, d10_.position AS position_96, d10_.principal AS principal_97, d10_.date_crea AS date_crea_98, d10_.date_maj AS date_maj_99, d11_.id AS id_100, d11_.titre AS titre_101, d11_.legende AS legende_102, d11_.actif AS actif_103, d11_.position AS position_104, d11_.file_name AS file_name_105, d11_.file_size AS file_size_106, d11_.updated_at AS updated_at_107, d11_.file_name_source AS file_name_source_108, d11_.file_size_source AS file_size_source_109, v12_.id AS id_110, v12_.titre AS titre_111, v12_.url AS url_112, v12_.actif AS actif_113, v12_.position AS position_114, v12_.texte AS texte_115, v12_.file_name AS file_name_116, v12_.file_size AS file_size_117, v12_.updated_at AS updated_at_118, v12_.file_name_source AS file_name_source_119, v12_.file_size_source AS file_size_source_120, v12_.date_crea AS date_crea_121, v12_.date_maj AS date_maj_122, l13_.id AS id_123, l13_.file_name AS file_name_124, l13_.file_size AS file_size_125, l13_.updated_at AS updated_at_126, l13_.file_name_source AS file_name_source_127, l13_.file_size_source AS file_size_source_128, l13_.date_crea AS date_crea_129, l13_.date_maj AS date_maj_130, e0_.gestionnaire_id AS gestionnaire_id_131, e0_.ville_id AS ville_id_132, e0_.categorie_primaire_id AS categorie_primaire_id_133, e0_.region_id AS region_id_134, e0_.departement_id AS departement_id_135, e0_.categorie_organisme_id AS categorie_organisme_id_136, e0_.rubrique AS rubrique_137, e0_.internat2_id AS internat2_id_138, e0_.etablissement_lie_id AS etablissement_lie_id_139, e0_.logo_id AS logo_id_140, e0_.diapo_principal_id AS diapo_principal_id_141, v1_.departement_id AS departement_id_142, v2_.ville_id AS ville_id_143, d3_.ancienne_region_id AS ancienne_region_id_144, d3_.region_id AS region_id_145, d4_.departement_id AS departement_id_146, a5_.region_id AS region_id_147, r6_.pays_id AS pays_id_148, t9_.etablissement_id AS etablissement_id_149, t9_.template_id AS template_id_150, d11_.diaporama_id AS diaporama_id_151 FROM etablissement e0_ LEFT JOIN ville v1_ ON e0_.ville_id = v1_.id LEFT JOIN ville_coordonnees v2_ ON v1_.id = v2_.ville_id LEFT JOIN departement d3_ ON v1_.departement_id = d3_.id LEFT JOIN departement_coordonnees d4_ ON d3_.id = d4_.departement_id LEFT JOIN ancienne_region a5_ ON d3_.ancienne_region_id = a5_.id LEFT JOIN region r6_ ON a5_.region_id = r6_.id LEFT JOIN pays p7_ ON r6_.pays_id = p7_.id LEFT JOIN categorie c8_ ON e0_.categorie_primaire_id = c8_.id LEFT JOIN texte_referencement t9_ ON e0_.id = t9_.etablissement_id LEFT JOIN diaporama_etablissement d14_ ON e0_.id = d14_.etablissement_id LEFT JOIN diaporama d10_ ON d10_.id = d14_.diaporama_id LEFT JOIN diaporama_photo d11_ ON d10_.id = d11_.diaporama_id LEFT JOIN video_etablissement v15_ ON e0_.id = v15_.etablissement_id LEFT JOIN video v12_ ON v12_.id = v15_.video_id LEFT JOIN logo l13_ ON e0_.logo_id = l13_.id WHERE e0_.id IN ('ET075-674', 'ET075-387', 'ET075-359', 'ET075-476', 'ET093-33', 'ET075-325') ORDER BY d11_.position ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 51)
7	FOS\ElasticaBundle\Doctrine\ORM\ElasticaToModelTransformer->findByIdentifiers (line 95)
8	FOS\ElasticaBundle\Doctrine\AbstractElasticaToModelTransformer->transform (line 40)
9	FOS\ElasticaBundle\Paginator\TransformedPartialResults->toArray (line 49)
10	FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items (line 117)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 93)
15	Knp\Component\Pager\Paginator->paginate (line 31)
16	Container2u3tDSD\PaginatorInterface_82dac15->paginate (line 107)
17	App\Elasticsearch\Moteur->cherche (line 162)
18	App\Controller\FicheController->index (line 163)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
21	Symfony\Component\HttpKernel\Kernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
24	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
28	Symfony\Component\HttpKernel\Kernel->handle (line 22)

1.62 ms
(4.07%)

SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id IN (?)

Parameters:

[
  [
    "GE075-34"
    "GE075-123"
    "GE093-8"
  ]
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.type AS type_1,
  t0.nombre_eleves AS nombre_eleves_2,
  t0.url AS url_3,
  t0.video AS video_4,
  t0.mots_cles AS mots_cles_5,
  t0.denomination AS denomination_6,
  t0.denomination_sigle AS denomination_sigle_7,
  t0.denomination_extension AS denomination_extension_8,
  t0.denomination_abregee AS denomination_abregee_9,
  t0.droit_page_web AS droit_page_web_10,
  t0.droit_actualite AS droit_actualite_11,
  t0.adresse1 AS adresse1_12,
  t0.adresse2 AS adresse2_13,
  t0.adresse3 AS adresse3_14,
  t0.code_postal AS code_postal_15,
  t0.cedex AS cedex_16,
  t0.latitude AS latitude_17,
  t0.longitude AS longitude_18,
  t0.telephone_principal AS telephone_principal_19,
  t0.fax AS fax_20,
  t0.email_principal AS email_principal_21,
  t0.logo_liste AS logo_liste_22,
  t0.logo_fiche AS logo_fiche_23,
  t0.diaporama_actif AS diaporama_actif_24,
  t0.images_diaporama AS images_diaporama_25,
  t0.participant AS participant_26,
  t0.catholique AS catholique_27,
  t0.age_admission AS age_admission_28,
  t0.actif AS actif_29,
  t0.internat AS internat_30,
  t0.has_internat AS has_internat_31,
  t0.types_internat AS types_internat_32,
  t0.sous_contrat AS sous_contrat_33,
  t0.alternance AS alternance_34,
  t0.type_client AS type_client_35,
  t0.bloque_txt_ref AS bloque_txt_ref_36,
  t0.facebook AS facebook_37,
  t0.bloque_bac2021 AS bloque_bac2021_38,
  t0.presence_web AS presence_web_39,
  t0.video_plus AS video_plus_40,
  t0.diapo_plus AS diapo_plus_41,
  t0.jpo_plus AS jpo_plus_42,
  t0.doc_plus AS doc_plus_43,
  t0.diplome_plus AS diplome_plus_44,
  t0.refus AS refus_45,
  t0.path AS path_46,
  t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47,
  t0.lva AS lva_48,
  t0.lvb AS lvb_49,
  t0.numero_administratif_uai AS numero_administratif_uai_50,
  t0.siret AS siret_51,
  t0.chiffres AS chiffres_52,
  t0.id AS id_53,
  t0.maj AS maj_54,
  t0.gestionnaire_id AS gestionnaire_id_55,
  t56.type AS type_57,
  t56.nombre_eleves AS nombre_eleves_58,
  t56.url AS url_59,
  t56.video AS video_60,
  t56.mots_cles AS mots_cles_61,
  t56.denomination AS denomination_62,
  t56.denomination_sigle AS denomination_sigle_63,
  t56.denomination_extension AS denomination_extension_64,
  t56.denomination_abregee AS denomination_abregee_65,
  t56.droit_page_web AS droit_page_web_66,
  t56.droit_actualite AS droit_actualite_67,
  t56.adresse1 AS adresse1_68,
  t56.adresse2 AS adresse2_69,
  t56.adresse3 AS adresse3_70,
  t56.code_postal AS code_postal_71,
  t56.cedex AS cedex_72,
  t56.latitude AS latitude_73,
  t56.longitude AS longitude_74,
  t56.telephone_principal AS telephone_principal_75,
  t56.fax AS fax_76,
  t56.email_principal AS email_principal_77,
  t56.logo_liste AS logo_liste_78,
  t56.logo_fiche AS logo_fiche_79,
  t56.diaporama_actif AS diaporama_actif_80,
  t56.images_diaporama AS images_diaporama_81,
  t56.participant AS participant_82,
  t56.catholique AS catholique_83,
  t56.age_admission AS age_admission_84,
  t56.actif AS actif_85,
  t56.internat AS internat_86,
  t56.has_internat AS has_internat_87,
  t56.types_internat AS types_internat_88,
  t56.sous_contrat AS sous_contrat_89,
  t56.alternance AS alternance_90,
  t56.type_client AS type_client_91,
  t56.bloque_txt_ref AS bloque_txt_ref_92,
  t56.facebook AS facebook_93,
  t56.bloque_bac2021 AS bloque_bac2021_94,
  t56.presence_web AS presence_web_95,
  t56.video_plus AS video_plus_96,
  t56.diapo_plus AS diapo_plus_97,
  t56.jpo_plus AS jpo_plus_98,
  t56.doc_plus AS doc_plus_99,
  t56.diplome_plus AS diplome_plus_100,
  t56.refus AS refus_101,
  t56.path AS path_102,
  t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103,
  t56.lva AS lva_104,
  t56.lvb AS lvb_105,
  t56.numero_administratif_uai AS numero_administratif_uai_106,
  t56.siret AS siret_107,
  t56.chiffres AS chiffres_108,
  t56.id AS id_109,
  t56.maj AS maj_110,
  t56.gestionnaire_id AS gestionnaire_id_111,
  t56.ville_id AS ville_id_112,
  t56.categorie_primaire_id AS categorie_primaire_id_113,
  t56.region_id AS region_id_114,
  t56.departement_id AS departement_id_115,
  t56.categorie_organisme_id AS categorie_organisme_id_116,
  t56.rubrique AS rubrique_117,
  t56.internat2_id AS internat2_id_118,
  t56.etablissement_lie_id AS etablissement_lie_id_119,
  t56.logo_id AS logo_id_120,
  t56.diapo_principal_id AS diapo_principal_id_121,
  t0.ville_id AS ville_id_122,
  t123.actif AS actif_124,
  t123.contenu AS contenu_125,
  t123.id AS id_126,
  t123.etablissement_id AS etablissement_id_127,
  t123.template_id AS template_id_128,
  t0.categorie_primaire_id AS categorie_primaire_id_129,
  t0.region_id AS region_id_130,
  t0.departement_id AS departement_id_131,
  t0.categorie_organisme_id AS categorie_organisme_id_132,
  t0.rubrique AS rubrique_133,
  t0.internat2_id AS internat2_id_134,
  t0.etablissement_lie_id AS etablissement_lie_id_135,
  t0.logo_id AS logo_id_136,
  t0.diapo_principal_id AS diapo_principal_id_137
FROM
  etablissement t0
  LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id
  LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id
WHERE
  t0.id IN (?)

SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id IN ('GE075-34', 'GE075-123', 'GE093-8');

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3016)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
8	Doctrine\ORM\AbstractQuery->execute (line 51)
9	FOS\ElasticaBundle\Doctrine\ORM\ElasticaToModelTransformer->findByIdentifiers (line 95)
10	FOS\ElasticaBundle\Doctrine\AbstractElasticaToModelTransformer->transform (line 40)
11	FOS\ElasticaBundle\Paginator\TransformedPartialResults->toArray (line 49)
12	FOS\ElasticaBundle\Subscriber\PaginateElasticaQuerySubscriber->items (line 117)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 93)
17	Knp\Component\Pager\Paginator->paginate (line 31)
18	Container2u3tDSD\PaginatorInterface_82dac15->paginate (line 107)
19	App\Elasticsearch\Moteur->cherche (line 162)
20	App\Controller\FicheController->index (line 163)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
23	Symfony\Component\HttpKernel\Kernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
26	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
30	Symfony\Component\HttpKernel\Kernel->handle (line 22)

1.15 ms
(2.88%)

SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?

Parameters:

[
  "ET075-480"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.type AS type_1,
  t0.nombre_eleves AS nombre_eleves_2,
  t0.url AS url_3,
  t0.video AS video_4,
  t0.mots_cles AS mots_cles_5,
  t0.denomination AS denomination_6,
  t0.denomination_sigle AS denomination_sigle_7,
  t0.denomination_extension AS denomination_extension_8,
  t0.denomination_abregee AS denomination_abregee_9,
  t0.droit_page_web AS droit_page_web_10,
  t0.droit_actualite AS droit_actualite_11,
  t0.adresse1 AS adresse1_12,
  t0.adresse2 AS adresse2_13,
  t0.adresse3 AS adresse3_14,
  t0.code_postal AS code_postal_15,
  t0.cedex AS cedex_16,
  t0.latitude AS latitude_17,
  t0.longitude AS longitude_18,
  t0.telephone_principal AS telephone_principal_19,
  t0.fax AS fax_20,
  t0.email_principal AS email_principal_21,
  t0.logo_liste AS logo_liste_22,
  t0.logo_fiche AS logo_fiche_23,
  t0.diaporama_actif AS diaporama_actif_24,
  t0.images_diaporama AS images_diaporama_25,
  t0.participant AS participant_26,
  t0.catholique AS catholique_27,
  t0.age_admission AS age_admission_28,
  t0.actif AS actif_29,
  t0.internat AS internat_30,
  t0.has_internat AS has_internat_31,
  t0.types_internat AS types_internat_32,
  t0.sous_contrat AS sous_contrat_33,
  t0.alternance AS alternance_34,
  t0.type_client AS type_client_35,
  t0.bloque_txt_ref AS bloque_txt_ref_36,
  t0.facebook AS facebook_37,
  t0.bloque_bac2021 AS bloque_bac2021_38,
  t0.presence_web AS presence_web_39,
  t0.video_plus AS video_plus_40,
  t0.diapo_plus AS diapo_plus_41,
  t0.jpo_plus AS jpo_plus_42,
  t0.doc_plus AS doc_plus_43,
  t0.diplome_plus AS diplome_plus_44,
  t0.refus AS refus_45,
  t0.path AS path_46,
  t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47,
  t0.lva AS lva_48,
  t0.lvb AS lvb_49,
  t0.numero_administratif_uai AS numero_administratif_uai_50,
  t0.siret AS siret_51,
  t0.chiffres AS chiffres_52,
  t0.id AS id_53,
  t0.maj AS maj_54,
  t0.gestionnaire_id AS gestionnaire_id_55,
  t56.type AS type_57,
  t56.nombre_eleves AS nombre_eleves_58,
  t56.url AS url_59,
  t56.video AS video_60,
  t56.mots_cles AS mots_cles_61,
  t56.denomination AS denomination_62,
  t56.denomination_sigle AS denomination_sigle_63,
  t56.denomination_extension AS denomination_extension_64,
  t56.denomination_abregee AS denomination_abregee_65,
  t56.droit_page_web AS droit_page_web_66,
  t56.droit_actualite AS droit_actualite_67,
  t56.adresse1 AS adresse1_68,
  t56.adresse2 AS adresse2_69,
  t56.adresse3 AS adresse3_70,
  t56.code_postal AS code_postal_71,
  t56.cedex AS cedex_72,
  t56.latitude AS latitude_73,
  t56.longitude AS longitude_74,
  t56.telephone_principal AS telephone_principal_75,
  t56.fax AS fax_76,
  t56.email_principal AS email_principal_77,
  t56.logo_liste AS logo_liste_78,
  t56.logo_fiche AS logo_fiche_79,
  t56.diaporama_actif AS diaporama_actif_80,
  t56.images_diaporama AS images_diaporama_81,
  t56.participant AS participant_82,
  t56.catholique AS catholique_83,
  t56.age_admission AS age_admission_84,
  t56.actif AS actif_85,
  t56.internat AS internat_86,
  t56.has_internat AS has_internat_87,
  t56.types_internat AS types_internat_88,
  t56.sous_contrat AS sous_contrat_89,
  t56.alternance AS alternance_90,
  t56.type_client AS type_client_91,
  t56.bloque_txt_ref AS bloque_txt_ref_92,
  t56.facebook AS facebook_93,
  t56.bloque_bac2021 AS bloque_bac2021_94,
  t56.presence_web AS presence_web_95,
  t56.video_plus AS video_plus_96,
  t56.diapo_plus AS diapo_plus_97,
  t56.jpo_plus AS jpo_plus_98,
  t56.doc_plus AS doc_plus_99,
  t56.diplome_plus AS diplome_plus_100,
  t56.refus AS refus_101,
  t56.path AS path_102,
  t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103,
  t56.lva AS lva_104,
  t56.lvb AS lvb_105,
  t56.numero_administratif_uai AS numero_administratif_uai_106,
  t56.siret AS siret_107,
  t56.chiffres AS chiffres_108,
  t56.id AS id_109,
  t56.maj AS maj_110,
  t56.gestionnaire_id AS gestionnaire_id_111,
  t56.ville_id AS ville_id_112,
  t56.categorie_primaire_id AS categorie_primaire_id_113,
  t56.region_id AS region_id_114,
  t56.departement_id AS departement_id_115,
  t56.categorie_organisme_id AS categorie_organisme_id_116,
  t56.rubrique AS rubrique_117,
  t56.internat2_id AS internat2_id_118,
  t56.etablissement_lie_id AS etablissement_lie_id_119,
  t56.logo_id AS logo_id_120,
  t56.diapo_principal_id AS diapo_principal_id_121,
  t0.ville_id AS ville_id_122,
  t123.actif AS actif_124,
  t123.contenu AS contenu_125,
  t123.id AS id_126,
  t123.etablissement_id AS etablissement_id_127,
  t123.template_id AS template_id_128,
  t0.categorie_primaire_id AS categorie_primaire_id_129,
  t0.region_id AS region_id_130,
  t0.departement_id AS departement_id_131,
  t0.categorie_organisme_id AS categorie_organisme_id_132,
  t0.rubrique AS rubrique_133,
  t0.internat2_id AS internat2_id_134,
  t0.etablissement_lie_id AS etablissement_lie_id_135,
  t0.logo_id AS logo_id_136,
  t0.diapo_principal_id AS diapo_principal_id_137
FROM
  etablissement t0
  LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id
  LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id
WHERE
  t0.id = ?

SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = 'ET075-480';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
5	Doctrine\ORM\EntityManager->find (line 144)
6	Container2u3tDSD\EntityManager_9a5be93->find (line 197)
7	Doctrine\ORM\EntityRepository->find (line 142)
8	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->find (line 91)
9	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply (line 84)
10	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter (line 48)
11	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply (line 72)
12	Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController (line 117)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 151)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
19	Symfony\Component\HttpKernel\Kernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
22	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
26	Symfony\Component\HttpKernel\Kernel->handle (line 22)

1.04 ms
(2.61%)

SELECT t0.identifiant AS identifiant_1, t0.onglet AS onglet_2, t0.libelle AS libelle_3, t0.options AS options_4, t0.niveau AS niveau_5, t0.pere AS pere_6, t0.libelle_specifique AS libelle_specifique_7, t0.options_specifique AS options_specifique_8, t0.texte AS texte_9, t0.tri AS tri_10, t0.complement_texte AS complement_texte_11, t0.complement_url_libelle AS complement_url_libelle_12, t0.complement_url AS complement_url_13, t0.complement_updated_at AS complement_updated_at_14, t0.libelle_mep AS libelle_mep_15, t0.slug AS slug_16, t0.formation AS formation_17, t0.ligne_secours AS ligne_secours_18, t0.updated_at AS updated_at_19, t0.diplome_plus AS diplome_plus_20, t0.valeur AS valeur_21, t0.id AS id_22, t0.etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0.etablissement_id = ? ORDER BY t0.tri ASC

Parameters:

[
  "ET075-480"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.identifiant AS identifiant_1,
  t0.onglet AS onglet_2,
  t0.libelle AS libelle_3,
  t0.options AS options_4,
  t0.niveau AS niveau_5,
  t0.pere AS pere_6,
  t0.libelle_specifique AS libelle_specifique_7,
  t0.options_specifique AS options_specifique_8,
  t0.texte AS texte_9,
  t0.tri AS tri_10,
  t0.complement_texte AS complement_texte_11,
  t0.complement_url_libelle AS complement_url_libelle_12,
  t0.complement_url AS complement_url_13,
  t0.complement_updated_at AS complement_updated_at_14,
  t0.libelle_mep AS libelle_mep_15,
  t0.slug AS slug_16,
  t0.formation AS formation_17,
  t0.ligne_secours AS ligne_secours_18,
  t0.updated_at AS updated_at_19,
  t0.diplome_plus AS diplome_plus_20,
  t0.valeur AS valeur_21,
  t0.id AS id_22,
  t0.etablissement_id AS etablissement_id_23
FROM
  items_insertion t0
WHERE
  t0.etablissement_id = ?
ORDER BY
  t0.tri ASC

SELECT t0.identifiant AS identifiant_1, t0.onglet AS onglet_2, t0.libelle AS libelle_3, t0.options AS options_4, t0.niveau AS niveau_5, t0.pere AS pere_6, t0.libelle_specifique AS libelle_specifique_7, t0.options_specifique AS options_specifique_8, t0.texte AS texte_9, t0.tri AS tri_10, t0.complement_texte AS complement_texte_11, t0.complement_url_libelle AS complement_url_libelle_12, t0.complement_url AS complement_url_13, t0.complement_updated_at AS complement_updated_at_14, t0.libelle_mep AS libelle_mep_15, t0.slug AS slug_16, t0.formation AS formation_17, t0.ligne_secours AS ligne_secours_18, t0.updated_at AS updated_at_19, t0.diplome_plus AS diplome_plus_20, t0.valeur AS valeur_21, t0.id AS id_22, t0.etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0.etablissement_id = 'ET075-480' ORDER BY t0.tri ASC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 198)
5	App\Controller\FicheController->index (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
10	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
11	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
15	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.93 ms
(2.33%)

SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = ?

Parameters:

[
  "GE075-125"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.actif AS actif_1,
  t0.contenu AS contenu_2,
  t0.id AS id_3,
  t0.etablissement_id AS etablissement_id_4,
  t0.template_id AS template_id_5
FROM
  texte_referencement t0
WHERE
  t0.etablissement_id = ?

SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = 'GE075-125';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 822)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2820)
5	Doctrine\ORM\UnitOfWork->createEntity (line 272)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 442)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 758)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 768)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
12	Doctrine\ORM\EntityManager->find (line 144)
13	Container2u3tDSD\EntityManager_9a5be93->find (line 197)
14	Doctrine\ORM\EntityRepository->find (line 142)
15	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->find (line 91)
16	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply (line 84)
17	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter (line 48)
18	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply (line 72)
19	Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController (line 117)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 151)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
26	Symfony\Component\HttpKernel\Kernel->handle (line 86)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
29	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
33	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.73 ms
(1.83%)

SELECT t0.id AS id_1, t0.field AS field_2, t0.value AS value_3, t0.etablissement_id AS etablissement_id_4 FROM etablissement_data t0 WHERE t0.etablissement_id = ?

Parameters:

[
  "ET075-480"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.field AS field_2,
  t0.value AS value_3,
  t0.etablissement_id AS etablissement_id_4
FROM
  etablissement_data t0
WHERE
  t0.etablissement_id = ?

SELECT t0.id AS id_1, t0.field AS field_2, t0.value AS value_3, t0.etablissement_id AS etablissement_id_4 FROM etablissement_data t0 WHERE t0.etablissement_id = 'ET075-480';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 38)
8	Doctrine\Common\Collections\AbstractLazyCollection->count (line 452)
9	Doctrine\ORM\PersistentCollection->count (line 1272)
10	twig_test_empty (line 589)
11	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->block_body (line 171)
12	Twig\Template->displayBlock (line 343)
13	__TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 74)
16	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 40)
20	Twig\TemplateWrapper->render (line 280)
21	Twig\Environment->render (line 258)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 472)
24	App\Controller\FicheController->index (line 163)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
27	Symfony\Component\HttpKernel\Kernel->handle (line 86)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
30	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
34	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.51 ms
(1.29%)

SELECT t0.id AS id_1, t0.texte AS texte_2, t0.url_libelle AS url_libelle_3, t0.url AS url_4, t0.updated_at AS updated_at_5, t0.identifiant AS identifiant_6, t0.etablissement_id AS etablissement_id_7 FROM donnee_complementaire t0 WHERE t0.etablissement_id = ?

Parameters:

[
  "ET075-480"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.texte AS texte_2,
  t0.url_libelle AS url_libelle_3,
  t0.url AS url_4,
  t0.updated_at AS updated_at_5,
  t0.identifiant AS identifiant_6,
  t0.etablissement_id AS etablissement_id_7
FROM
  donnee_complementaire t0
WHERE
  t0.etablissement_id = ?

SELECT t0.id AS id_1, t0.texte AS texte_2, t0.url_libelle AS url_libelle_3, t0.url AS url_4, t0.updated_at AS updated_at_5, t0.identifiant AS identifiant_6, t0.etablissement_id AS etablissement_id_7 FROM donnee_complementaire t0 WHERE t0.etablissement_id = 'ET075-480';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 916)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
4	Doctrine\ORM\EntityRepository->findBy (line 368)
5	Doctrine\ORM\EntityRepository->resolveMagicCall (line 272)
6	Doctrine\ORM\EntityRepository->__call (line 310)
7	App\Controller\FicheController->index (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
10	Symfony\Component\HttpKernel\Kernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
13	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
17	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.44 ms
(1.11%)

SELECT d0_.slug AS slug_0, d0_.libelle AS libelle_1, d0_.onglets AS onglets_2, d0_.id AS id_3, d0_.maj AS maj_4, d1_.latitude AS latitude_5, d1_.longitude AS longitude_6, d1_.id AS id_7, d0_.ancienne_region_id AS ancienne_region_id_8, d0_.region_id AS region_id_9, d1_.departement_id AS departement_id_10 FROM departement d0_ LEFT JOIN departement_coordonnees d1_ ON d0_.id = d1_.departement_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.slug AS slug_0,
  d0_.libelle AS libelle_1,
  d0_.onglets AS onglets_2,
  d0_.id AS id_3,
  d0_.maj AS maj_4,
  d1_.latitude AS latitude_5,
  d1_.longitude AS longitude_6,
  d1_.id AS id_7,
  d0_.ancienne_region_id AS ancienne_region_id_8,
  d0_.region_id AS region_id_9,
  d1_.departement_id AS departement_id_10
FROM
  departement d0_
  LEFT JOIN departement_coordonnees d1_ ON d0_.id = d1_.departement_id

SELECT d0_.slug AS slug_0, d0_.libelle AS libelle_1, d0_.onglets AS onglets_2, d0_.id AS id_3, d0_.maj AS maj_4, d1_.latitude AS latitude_5, d1_.longitude AS longitude_6, d1_.id AS id_7, d0_.ancienne_region_id AS ancienne_region_id_8, d0_.region_id AS region_id_9, d1_.departement_id AS departement_id_10 FROM departement d0_ LEFT JOIN departement_coordonnees d1_ ON d0_.id = d1_.departement_id;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 895)
3	Doctrine\DBAL\Connection->fetchAllAssociative (line 1141)
4	Doctrine\DBAL\Connection->executeCacheQuery (line 1072)
5	Doctrine\DBAL\Connection->executeQuery (line 31)
6	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
7	Doctrine\ORM\Query->_doExecute (line 1212)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
9	Doctrine\ORM\AbstractQuery->execute (line 901)
10	Doctrine\ORM\AbstractQuery->getResult (line 95)
11	App\Service\Slugify->findBySlug (line 57)
12	App\Service\Slugify->revealLieu (line 1635)
13	twig_get_attribute (line 94)
14	__TwigTemplate_425cc135202ac3d6d6d4e7bfd82a94a3acfa0510ef17d726bcdde2780af88092->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 932)
17	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->block_contexte (line 171)
18	Twig\Template->displayBlock (line 850)
19	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->block_body (line 171)
20	Twig\Template->displayBlock (line 343)
21	__TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 74)
24	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 40)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 258)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 472)
32	App\Controller\FicheController->index (line 163)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
35	Symfony\Component\HttpKernel\Kernel->handle (line 86)
36	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
38	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
39	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
41	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
42	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.43 ms
(1.07%)

SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ WHERE j0_.etablissement_id = ? AND j0_.date >= ? ORDER BY j0_.date ASC LIMIT 1

Parameters:

[
  "ET075-480"
  "2026-09-10"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.date_publidation AS date_publidation_0,
  j0_.date_actualisation AS date_actualisation_1,
  j0_.lieu AS lieu_2,
  j0_.contenu AS contenu_3,
  j0_.updated AS updated_4,
  j0_.date AS date_5,
  j0_.heure_debut AS heure_debut_6,
  j0_.heure_fin AS heure_fin_7,
  j0_.file_name AS file_name_8,
  j0_.file_size AS file_size_9,
  j0_.legende AS legende_10,
  j0_.id AS id_11,
  j0_.image1_name AS image1_name_12,
  j0_.image1_original_name AS image1_original_name_13,
  j0_.image1_mime_type AS image1_mime_type_14,
  j0_.image1_size AS image1_size_15,
  j0_.image1_dimensions AS image1_dimensions_16,
  j0_.image2_name AS image2_name_17,
  j0_.image2_original_name AS image2_original_name_18,
  j0_.image2_mime_type AS image2_mime_type_19,
  j0_.image2_size AS image2_size_20,
  j0_.image2_dimensions AS image2_dimensions_21,
  j0_.image3_name AS image3_name_22,
  j0_.image3_original_name AS image3_original_name_23,
  j0_.image3_mime_type AS image3_mime_type_24,
  j0_.image3_size AS image3_size_25,
  j0_.image3_dimensions AS image3_dimensions_26,
  j0_.etablissement_id AS etablissement_id_27
FROM
  jpo j0_
WHERE
  j0_.etablissement_id = ?
  AND j0_.date >= ?
ORDER BY
  j0_.date ASC
LIMIT
  1

SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ WHERE j0_.etablissement_id = 'ET075-480' AND j0_.date >= '2026-09-10' ORDER BY j0_.date ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 31)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 59)
8	App\Repository\JPORepository->getLastByEtablissement (line 286)
9	App\Controller\FicheController->index (line 163)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
12	Symfony\Component\HttpKernel\Kernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
15	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
19	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.36 ms
(0.91%)

SELECT t0.id_distant AS id_distant_1, t0.date_creation AS date_creation_2, t0.date_actualisation AS date_actualisation_3, t0.date_validite AS date_validite_4, t0.libelle AS libelle_5, t0.description AS description_6, t0.url AS url_7, t0.url_image AS url_image_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.etablissement_id AS etablissement_id_11, t0.profil_id AS profil_id_12, t0.contrat_id AS contrat_id_13 FROM offre_emploi t0 WHERE t0.etablissement_id = ? ORDER BY t0.date_actualisation DESC

Parameters:

[
  "ET075-480"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_distant AS id_distant_1,
  t0.date_creation AS date_creation_2,
  t0.date_actualisation AS date_actualisation_3,
  t0.date_validite AS date_validite_4,
  t0.libelle AS libelle_5,
  t0.description AS description_6,
  t0.url AS url_7,
  t0.url_image AS url_image_8,
  t0.json_ld AS json_ld_9,
  t0.id AS id_10,
  t0.etablissement_id AS etablissement_id_11,
  t0.profil_id AS profil_id_12,
  t0.contrat_id AS contrat_id_13
FROM
  offre_emploi t0
WHERE
  t0.etablissement_id = ?
ORDER BY
  t0.date_actualisation DESC

SELECT t0.id_distant AS id_distant_1, t0.date_creation AS date_creation_2, t0.date_actualisation AS date_actualisation_3, t0.date_validite AS date_validite_4, t0.libelle AS libelle_5, t0.description AS description_6, t0.url AS url_7, t0.url_image AS url_image_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.etablissement_id AS etablissement_id_11, t0.profil_id AS profil_id_12, t0.contrat_id AS contrat_id_13 FROM offre_emploi t0 WHERE t0.etablissement_id = 'ET075-480' ORDER BY t0.date_actualisation DESC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 168)
8	Doctrine\Common\Collections\AbstractLazyCollection->first (line 601)
9	App\Entity\Etablissement->getDateDerniereModification (line 89)
10	Symfony\Component\ExpressionLanguage\Node\GetAttrNode->evaluate (line 46)
11	Symfony\Component\ExpressionLanguage\Node\ConditionalNode->evaluate (line 67)
12	Symfony\Component\ExpressionLanguage\ExpressionLanguage->evaluate (line 55)
13	Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener->onKernelController (line 117)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 151)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
20	Symfony\Component\HttpKernel\Kernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
23	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
27	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.35 ms
(0.89%)

SELECT t0.id_distant AS id_distant_1, t0.date_importation AS date_importation_2, t0.date_publication AS date_publication_3, t0.date_actualisation AS date_actualisation_4, t0.titre AS titre_5, t0.resume AS resume_6, t0.contenu AS contenu_7, t0.url AS url_8, t0.url_image AS url_image_9, t0.id AS id_10, t0.etablissement_id AS etablissement_id_11 FROM actualite t0 WHERE t0.etablissement_id = ? ORDER BY t0.date_actualisation DESC

Parameters:

[
  "ET075-480"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_distant AS id_distant_1,
  t0.date_importation AS date_importation_2,
  t0.date_publication AS date_publication_3,
  t0.date_actualisation AS date_actualisation_4,
  t0.titre AS titre_5,
  t0.resume AS resume_6,
  t0.contenu AS contenu_7,
  t0.url AS url_8,
  t0.url_image AS url_image_9,
  t0.id AS id_10,
  t0.etablissement_id AS etablissement_id_11
FROM
  actualite t0
WHERE
  t0.etablissement_id = ?
ORDER BY
  t0.date_actualisation DESC

SELECT t0.id_distant AS id_distant_1, t0.date_importation AS date_importation_2, t0.date_publication AS date_publication_3, t0.date_actualisation AS date_actualisation_4, t0.titre AS titre_5, t0.resume AS resume_6, t0.contenu AS contenu_7, t0.url AS url_8, t0.url_image AS url_image_9, t0.id AS id_10, t0.etablissement_id AS etablissement_id_11 FROM actualite t0 WHERE t0.etablissement_id = 'ET075-480' ORDER BY t0.date_actualisation DESC;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 1863)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3037)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 168)
8	Doctrine\Common\Collections\AbstractLazyCollection->first (line 602)
9	App\Entity\Etablissement->getDateDerniereModification (line 89)
10	Symfony\Component\ExpressionLanguage\Node\GetAttrNode->evaluate (line 46)
11	Symfony\Component\ExpressionLanguage\Node\ConditionalNode->evaluate (line 67)
12	Symfony\Component\ExpressionLanguage\ExpressionLanguage->evaluate (line 55)
13	Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener->onKernelController (line 117)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 151)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
20	Symfony\Component\HttpKernel\Kernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
23	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
27	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.34 ms
(0.84%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3, t0.actif AS actif_4, t0.position AS position_5, t0.principal AS principal_6, t0.date_crea AS date_crea_7, t0.date_maj AS date_maj_8 FROM diaporama t0 INNER JOIN diaporama_etablissement ON t0.id = diaporama_etablissement.diaporama_id WHERE diaporama_etablissement.etablissement_id = ?

Parameters:

[
  "ET075-480"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.texte AS texte_3,
  t0.actif AS actif_4,
  t0.position AS position_5,
  t0.principal AS principal_6,
  t0.date_crea AS date_crea_7,
  t0.date_maj AS date_maj_8
FROM
  diaporama t0
  INNER JOIN diaporama_etablissement ON t0.id = diaporama_etablissement.diaporama_id
WHERE
  diaporama_etablissement.etablissement_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3, t0.actif AS actif_4, t0.position AS position_5, t0.principal AS principal_6, t0.date_crea AS date_crea_7, t0.date_maj AS date_maj_8 FROM diaporama t0 INNER JOIN diaporama_etablissement ON t0.id = diaporama_etablissement.diaporama_id WHERE diaporama_etablissement.etablissement_id = 'ET075-480';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 1064)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 986)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3041)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 698)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 213)
7	Doctrine\ORM\PersistentCollection->initialize (line 38)
8	Doctrine\Common\Collections\AbstractLazyCollection->count (line 452)
9	Doctrine\ORM\PersistentCollection->count (line 1129)
10	twig_length_filter (line 259)
11	__TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 74)
14	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 258)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 472)
22	App\Controller\FicheController->index (line 163)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
25	Symfony\Component\HttpKernel\Kernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
28	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
32	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.29 ms
(0.73%)

SELECT COUNT(*) FROM jpo t0 WHERE t0.etablissement_id = ?

Parameters:

[
  "ET075-480"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  jpo t0
WHERE
  t0.etablissement_id = ?

SELECT COUNT(*) FROM jpo t0 WHERE t0.etablissement_id = 'ET075-480';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 855)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 102)
4	Doctrine\ORM\Persisters\Collection\OneToManyPersister->count (line 449)
5	Doctrine\ORM\PersistentCollection->count (line 1)
6	count (line 293)
7	App\Controller\FicheController->index (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
10	Symfony\Component\HttpKernel\Kernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
13	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
17	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.23 ms
(0.57%)

SELECT t0.libelle AS libelle_1, t0.libelle_mep AS libelle_mep_2, t0.texte_defaut AS texte_defaut_3, t0.onglet AS onglet_4, t0.niveau AS niveau_5, t0.formation AS formation_6, t0.options AS options_7, t0.libelle_web AS libelle_web_8, t0.id AS id_9, t0.maj AS maj_10 FROM items t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "ECOLE-SPEC-ELANG"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.libelle AS libelle_1,
  t0.libelle_mep AS libelle_mep_2,
  t0.texte_defaut AS texte_defaut_3,
  t0.onglet AS onglet_4,
  t0.niveau AS niveau_5,
  t0.formation AS formation_6,
  t0.options AS options_7,
  t0.libelle_web AS libelle_web_8,
  t0.id AS id_9,
  t0.maj AS maj_10
FROM
  items t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.libelle AS libelle_1, t0.libelle_mep AS libelle_mep_2, t0.texte_defaut AS texte_defaut_3, t0.onglet AS onglet_4, t0.niveau AS niveau_5, t0.formation AS formation_6, t0.options AS options_7, t0.libelle_web AS libelle_web_8, t0.id AS id_9, t0.maj AS maj_10 FROM items t0 WHERE t0.id = 'ECOLE-SPEC-ELANG' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 750)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
4	Doctrine\ORM\EntityRepository->findOneBy (line 368)
5	Doctrine\ORM\EntityRepository->resolveMagicCall (line 276)
6	Doctrine\ORM\EntityRepository->__call (line 89)
7	App\Twig\ItemsInsertionExtension->itemIdLibelle (line 88)
8	__TwigTemplate_e6e92c44e7d5c2d0761863159fc58dc2e2c1729656cf5f7de2dafd1d364c4df3->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 56)
11	__TwigTemplate_dfc36ae3e9529162e5b16e0773a6e5b36eba52daded42460b73da665d0dde492->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 779)
14	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->block_body (line 171)
15	Twig\Template->displayBlock (line 343)
16	__TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 74)
19	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 379)
22	Twig\Template->render (line 40)
23	Twig\TemplateWrapper->render (line 280)
24	Twig\Environment->render (line 258)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 472)
27	App\Controller\FicheController->index (line 163)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
30	Symfony\Component\HttpKernel\Kernel->handle (line 86)
31	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
33	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
37	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.17 ms
(0.43%)

SELECT a0_.slug AS slug_0, a0_.libelle AS libelle_1, a0_.id AS id_2, a0_.maj AS maj_3, a0_.region_id AS region_id_4 FROM ancienne_region a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.slug AS slug_0,
  a0_.libelle AS libelle_1,
  a0_.id AS id_2,
  a0_.maj AS maj_3,
  a0_.region_id AS region_id_4
FROM
  ancienne_region a0_

SELECT a0_.slug AS slug_0, a0_.libelle AS libelle_1, a0_.id AS id_2, a0_.maj AS maj_3, a0_.region_id AS region_id_4 FROM ancienne_region a0_;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 895)
3	Doctrine\DBAL\Connection->fetchAllAssociative (line 1141)
4	Doctrine\DBAL\Connection->executeCacheQuery (line 1072)
5	Doctrine\DBAL\Connection->executeQuery (line 31)
6	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
7	Doctrine\ORM\Query->_doExecute (line 1212)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
9	Doctrine\ORM\AbstractQuery->execute (line 901)
10	Doctrine\ORM\AbstractQuery->getResult (line 95)
11	App\Service\Slugify->findBySlug (line 57)
12	App\Service\Slugify->revealLieu (line 1635)
13	twig_get_attribute (line 94)
14	__TwigTemplate_425cc135202ac3d6d6d4e7bfd82a94a3acfa0510ef17d726bcdde2780af88092->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 932)
17	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->block_contexte (line 171)
18	Twig\Template->displayBlock (line 850)
19	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->block_body (line 171)
20	Twig\Template->displayBlock (line 343)
21	__TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 74)
24	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 40)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 258)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 472)
32	App\Controller\FicheController->index (line 163)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
35	Symfony\Component\HttpKernel\Kernel->handle (line 86)
36	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
38	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
39	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
41	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
42	Symfony\Component\HttpKernel\Kernel->handle (line 22)

0.13 ms
(0.32%)

SELECT v0_.slug AS slug_0, v0_.libelle AS libelle_1, v0_.code_postal AS code_postal_2, v0_.email_delegue AS email_delegue_3, v0_.onglets AS onglets_4, v0_.id AS id_5, v0_.maj AS maj_6, v1_.latitude AS latitude_7, v1_.longitude AS longitude_8, v1_.id AS id_9, v0_.departement_id AS departement_id_10, v1_.ville_id AS ville_id_11 FROM ville v0_ LEFT JOIN ville_coordonnees v1_ ON v0_.id = v1_.ville_id WHERE v0_.slug = ? LIMIT 1

Parameters:

[
  "paris-18-75018"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.slug AS slug_0,
  v0_.libelle AS libelle_1,
  v0_.code_postal AS code_postal_2,
  v0_.email_delegue AS email_delegue_3,
  v0_.onglets AS onglets_4,
  v0_.id AS id_5,
  v0_.maj AS maj_6,
  v1_.latitude AS latitude_7,
  v1_.longitude AS longitude_8,
  v1_.id AS id_9,
  v0_.departement_id AS departement_id_10,
  v1_.ville_id AS ville_id_11
FROM
  ville v0_
  LEFT JOIN ville_coordonnees v1_ ON v0_.id = v1_.ville_id
WHERE
  v0_.slug = ?
LIMIT
  1

SELECT v0_.slug AS slug_0, v0_.libelle AS libelle_1, v0_.code_postal AS code_postal_2, v0_.email_delegue AS email_delegue_3, v0_.onglets AS onglets_4, v0_.id AS id_5, v0_.maj AS maj_6, v1_.latitude AS latitude_7, v1_.longitude AS longitude_8, v1_.id AS id_9, v0_.departement_id AS departement_id_10, v1_.ville_id AS ville_id_11 FROM ville v0_ LEFT JOIN ville_coordonnees v1_ ON v0_.id = v1_.ville_id WHERE v0_.slug = 'paris-18-75018' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1079)
2	Doctrine\DBAL\Connection->executeQuery (line 895)
3	Doctrine\DBAL\Connection->fetchAllAssociative (line 1141)
4	Doctrine\DBAL\Connection->executeCacheQuery (line 1072)
5	Doctrine\DBAL\Connection->executeQuery (line 31)
6	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
7	Doctrine\ORM\Query->_doExecute (line 1212)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
9	Doctrine\ORM\AbstractQuery->execute (line 953)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 83)
11	App\Service\Slugify->findVilleBySlug (line 63)
12	App\Service\Slugify->revealLieu (line 1635)
13	twig_get_attribute (line 94)
14	__TwigTemplate_425cc135202ac3d6d6d4e7bfd82a94a3acfa0510ef17d726bcdde2780af88092->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 932)
17	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->block_contexte (line 171)
18	Twig\Template->displayBlock (line 850)
19	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->block_body (line 171)
20	Twig\Template->displayBlock (line 343)
21	__TwigTemplate_c9a8f26e4c67e4400f6f1d1a93b2acd78733561fe27d3fd35277854386de8893->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 74)
24	__TwigTemplate_adfde8a2c181be34224da679610d8a5f379ebd5bbe29787c808990cc9c7f6724->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 379)
27	Twig\Template->render (line 40)
28	Twig\TemplateWrapper->render (line 280)
29	Twig\Environment->render (line 258)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 472)
32	App\Controller\FicheController->index (line 163)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
35	Symfony\Component\HttpKernel\Kernel->handle (line 86)
36	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 73)
38	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 452)
39	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 224)
41	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 193)
42	Symfony\Component\HttpKernel\Kernel->handle (line 22)

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\Etablissement	No errors.
App\Entity\Ville	No errors.
App\Entity\Categorie	No errors.
App\Entity\Region	No errors.
App\Entity\Departement	No errors.
App\Entity\CategorieOrganisme	No errors.
App\Entity\RubriqueFournisseur	No errors.
App\Entity\Logo	No errors.
App\Entity\Diaporama	No errors.
App\Entity\TexteReferencement	No errors.
App\Entity\TexteReferencementTemplate	No errors.
App\Entity\Insertion	No errors.
App\Entity\ItemsInsertion	No errors.
App\Entity\Actualite	No errors.
App\Entity\OffreEmploi	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\JPO	No errors.
App\Entity\SousTypesEtablissement	No errors.
App\Entity\Document	No errors.
App\Entity\Video	No errors.
App\Entity\Produit	No errors.
App\Entity\EtablissementData	No errors.
App\Entity\VideoOnpc	No errors.
App\Entity\ActualiteOnpc	No errors.
App\Entity\OffreEmploiProfil	No errors.
App\Entity\OffreEmploiContrat	No errors.
App\Entity\VilleCoordonnees	No errors.
App\Entity\DepartementCoordonnees	No errors.
App\Entity\AncienneRegion	No errors.
App\Entity\Pays	No errors.
App\Entity\DiaporamaPhoto	No errors.
App\Entity\DonneeComplementaire	No errors.
App\Entity\DemandeInformation	No errors.
App\Entity\Items	No errors.

Symfony Profiler

http://aep-beta.onpc.fr/fiche/ecole-privee-le-sacre-coeur-groupe-scolaire-la-madone-paris-18/ET075-480

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping