Symfony Profiler

Last 10 Latest Search
Settings
Query Metrics

20 Database Queries
16 Different statements
43.38 ms Query time
0 Invalid entities
Queries

Group similar statements

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 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 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 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 FROM region r0_ WHERE r0_.ancienne IS NULL AND r0_.libelle IS NOT NULL AND r0_.slug IS NOT NULL ORDER BY r0_.pays_id DESC, r0_.libelle ASC
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 FROM departement d0_ LEFT JOIN departement_coordonnees d1_ ON d0_.id = d1_.departement_id WHERE d0_.region_id = ? AND d0_.id <> ? ORDER BY d0_.libelle ASC
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 FROM ville v0_ LEFT JOIN ville_coordonnees v1_ ON v0_.id = v1_.ville_id WHERE v0_.libelle IS NOT NULL AND v0_.departement_id = ? AND v0_.id IN (?) ORDER BY v0_.libelle ASC
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 IN (?) ORDER BY t0.libelle ASC
SELECT i0_.libelle AS libelle_0, i0_.libelle_mep AS libelle_mep_1, i0_.texte_defaut AS texte_defaut_2, i0_.onglet AS onglet_3, i0_.niveau AS niveau_4, i0_.formation AS formation_5, i0_.options AS options_6, i0_.libelle_web AS libelle_web_7, i0_.id AS id_8, i0_.maj AS maj_9 FROM items i0_ INNER JOIN items_insertion i1_ ON (i0_.id = i1_.pere) WHERE i0_.formation = 'oui' AND i0_.niveau = 3 AND i0_.id LIKE ? AND i0_.id IN (?) GROUP BY i0_.id ORDER BY i0_.libelle ASC
SELECT i0_.libelle AS libelle_0, i0_.libelle_mep AS libelle_mep_1, i0_.texte_defaut AS texte_defaut_2, i0_.onglet AS onglet_3, i0_.niveau AS niveau_4, i0_.formation AS formation_5, i0_.options AS options_6, i0_.libelle_web AS libelle_web_7, i0_.id AS id_8, i0_.maj AS maj_9 FROM items i0_ WHERE i0_.niveau = 4 AND i0_.id LIKE ? AND i0_.id IN (?) ORDER BY i0_.libelle ASC
SELECT s0_.id AS id_0, s0_.formation AS formation_1, s0_.secteur AS secteur_2, s0_.diplome AS diplome_3, s0_.titre_national AS titre_national_4, s0_.texte_national AS texte_national_5, s0_.titre_regional AS titre_regional_6, s0_.texte_regional AS texte_regional_7, s0_.titre_departemental AS titre_departemental_8, s0_.texte_departemental AS texte_departemental_9, s0_.titre_ville AS titre_ville_10, s0_.texte_ville AS texte_ville_11 FROM seo_texte_referencement_diplome s0_ WHERE s0_.formation = ? AND s0_.diplome IS NULL AND s0_.secteur IS NULL
SELECT z0_.zone AS zone_0, z0_.id AS id_1, z0_.maj AS maj_2, e1_.type AS type_3, e1_.nombre_eleves AS nombre_eleves_4, e1_.url AS url_5, e1_.video AS video_6, e1_.mots_cles AS mots_cles_7, e1_.denomination AS denomination_8, e1_.denomination_sigle AS denomination_sigle_9, e1_.denomination_extension AS denomination_extension_10, e1_.denomination_abregee AS denomination_abregee_11, e1_.droit_page_web AS droit_page_web_12, e1_.droit_actualite AS droit_actualite_13, e1_.adresse1 AS adresse1_14, e1_.adresse2 AS adresse2_15, e1_.adresse3 AS adresse3_16, e1_.code_postal AS code_postal_17, e1_.cedex AS cedex_18, e1_.latitude AS latitude_19, e1_.longitude AS longitude_20, e1_.telephone_principal AS telephone_principal_21, e1_.fax AS fax_22, e1_.email_principal AS email_principal_23, e1_.logo_liste AS logo_liste_24, e1_.logo_fiche AS logo_fiche_25, e1_.diaporama_actif AS diaporama_actif_26, e1_.images_diaporama AS images_diaporama_27, e1_.participant AS participant_28, e1_.catholique AS catholique_29, e1_.age_admission AS age_admission_30, e1_.actif AS actif_31, e1_.internat AS internat_32, e1_.has_internat AS has_internat_33, e1_.types_internat AS types_internat_34, e1_.sous_contrat AS sous_contrat_35, e1_.alternance AS alternance_36, e1_.type_client AS type_client_37, e1_.bloque_txt_ref AS bloque_txt_ref_38, e1_.facebook AS facebook_39, e1_.bloque_bac2021 AS bloque_bac2021_40, e1_.presence_web AS presence_web_41, e1_.video_plus AS video_plus_42, e1_.diapo_plus AS diapo_plus_43, e1_.jpo_plus AS jpo_plus_44, e1_.doc_plus AS doc_plus_45, e1_.diplome_plus AS diplome_plus_46, e1_.refus AS refus_47, e1_.path AS path_48, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_49, e1_.lva AS lva_50, e1_.lvb AS lvb_51, e1_.numero_administratif_uai AS numero_administratif_uai_52, e1_.siret AS siret_53, e1_.chiffres AS chiffres_54, e1_.id AS id_55, e1_.maj AS maj_56, t2_.actif AS actif_57, t2_.contenu AS contenu_58, t2_.id AS id_59, v3_.slug AS slug_60, v3_.libelle AS libelle_61, v3_.code_postal AS code_postal_62, v3_.email_delegue AS email_delegue_63, v3_.onglets AS onglets_64, v3_.id AS id_65, v3_.maj AS maj_66, v4_.latitude AS latitude_67, v4_.longitude AS longitude_68, v4_.id AS id_69, z0_.etablissement_id AS etablissement_id_70, e1_.gestionnaire_id AS gestionnaire_id_71, e1_.ville_id AS ville_id_72, e1_.categorie_primaire_id AS categorie_primaire_id_73, e1_.region_id AS region_id_74, e1_.departement_id AS departement_id_75, e1_.categorie_organisme_id AS categorie_organisme_id_76, e1_.rubrique AS rubrique_77, e1_.internat2_id AS internat2_id_78, e1_.etablissement_lie_id AS etablissement_lie_id_79, e1_.logo_id AS logo_id_80, e1_.diapo_principal_id AS diapo_principal_id_81, t2_.etablissement_id AS etablissement_id_82, t2_.template_id AS template_id_83, v3_.departement_id AS departement_id_84, v4_.ville_id AS ville_id_85 FROM zones_internat z0_ LEFT JOIN etablissement e1_ ON z0_.etablissement_id = e1_.id LEFT JOIN texte_referencement t2_ ON e1_.id = t2_.etablissement_id LEFT JOIN ville v3_ ON e1_.ville_id = v3_.id LEFT JOIN ville_coordonnees v4_ ON v3_.id = v4_.ville_id WHERE z0_.zone = ? GROUP BY z0_.etablissement_id ORDER BY z0_.id ASC
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.id AS id_1, t0.onglet AS onglet_2, t0.niveau AS niveau_3, t0.tag AS tag_4, t0.filiere AS filiere_5, t0.diplome AS diplome_6, t0.question AS question_7, t0.ordre AS ordre_8, t0.reponse AS reponse_9, t0.visible AS visible_10, t0.updated_at AS updated_at_11 FROM faq t0 WHERE t0.onglet = ? AND t0.niveau IS NULL AND t0.filiere IS NULL AND t0.diplome IS NULL AND t0.visible = ? ORDER BY t0.ordre ASC, t0.updated_at DESC
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 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 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 = ? 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 = ? LIMIT 1
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.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 = ?
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\Departement	No errors.
App\Entity\DepartementCoordonnees	No errors.
App\Entity\AncienneRegion	No errors.
App\Entity\Region	No errors.
App\Entity\Ville	No errors.
App\Entity\Etablissement	No errors.
App\Entity\VilleCoordonnees	No errors.
App\Entity\Pays	No errors.
App\Entity\Categorie	No errors.
App\Entity\TexteReferencement	No errors.
App\Entity\Diaporama	No errors.
App\Entity\DiaporamaPhoto	No errors.
App\Entity\Video	No errors.
App\Entity\Logo	No errors.
App\Entity\CategorieOrganisme	No errors.
App\Entity\RubriqueFournisseur	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\Produit	No errors.
App\Entity\EtablissementData	No errors.
App\Entity\VideoOnpc	No errors.
App\Entity\ActualiteOnpc	No errors.
App\Entity\Items	No errors.
App\Entity\SeoTexteReferencementDiplome	No errors.
App\Entity\ZonesInternat	No errors.
App\Entity\Faq	No errors.
Symfony Profiler

http://aep-beta.onpc.fr/annuaire-enseignement-prive/cotes-darmor-22?page=3

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
