http://aep-beta.onpc.fr/onglet/superieur/niveau/bac-3-licence/pessac-33600

Method
GET
HTTP Status
200
IP
216.73.217.94
Profiled on
Token
a82acb

Query Metrics

33 Database Queries
19 Different statements
181.46 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
82.48 ms
(45.45%) 		1 
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: 
[
  [
    "ET033-171"
    "ET033-152"
    "ET033-184"
    "ET033-185"
    "ET033-173"
    "ET033-163"
    "ET033-193"
    "ET033-89"
    "ET033-234"
    "ET033-240"
    "ET033-126"
    "ET033-155"
  ]
]
View formatted query    View runnable query    Explain query    View query backtrace
21.42 ms
(11.81%) 		4 
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: 
[
  "pessac-33600"
]
View formatted query    View runnable query    Explain query    View query backtrace
18.45 ms
(10.17%) 		2 
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-151"
    "GE033-28"
    "GE033-13"
    "GE033-49"
    "GE033-45"
    "GE033-30"
    "GE033-55"
    "GE033-10"
    "GE033-11"
    "GE033-48"
    "GE049-39"
  ]
]
View formatted query    View runnable query    Explain query    View query backtrace
10.59 ms
(5.83%) 		8 
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.diplome_plus ASC
Parameters: 
[
  "ET033-171"
]
View formatted query    View runnable query    Explain query    View query backtrace
10.01 ms
(5.52%) 		1 
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
7.03 ms
(3.88%) 		1 
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 = ? AND t0.filiere IS NULL AND t0.diplome IS NULL AND t0.visible = ? ORDER BY t0.ordre ASC, t0.updated_at DESC
Parameters: 
[
  "superieur"
  "bac-3-licence"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
5.71 ms
(3.15%) 		1 
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_.onglets LIKE ? AND 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
Parameters: 
[
  "%superieur%"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.44 ms
(2.45%) 		1 
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
Parameters: 
[
  [
    "33063"
    "33539"
    "33550"
  ]
]
View formatted query    View runnable query    Explain query    View query backtrace
3.57 ms
(1.97%) 		4 
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: 
[
  "85252"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.54 ms
(1.40%) 		1 
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
Parameters: 
[
  "PBAC-BAC3"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.28 ms
(1.25%) 		1 
SELECT i0_.identifiant AS identifiant_0, i0_.onglet AS onglet_1, i0_.libelle AS libelle_2, i0_.options AS options_3, i0_.niveau AS niveau_4, i0_.pere AS pere_5, i0_.libelle_specifique AS libelle_specifique_6, i0_.options_specifique AS options_specifique_7, i0_.texte AS texte_8, i0_.tri AS tri_9, i0_.complement_texte AS complement_texte_10, i0_.complement_url_libelle AS complement_url_libelle_11, i0_.complement_url AS complement_url_12, i0_.complement_updated_at AS complement_updated_at_13, i0_.libelle_mep AS libelle_mep_14, i0_.slug AS slug_15, i0_.formation AS formation_16, i0_.ligne_secours AS ligne_secours_17, i0_.updated_at AS updated_at_18, i0_.diplome_plus AS diplome_plus_19, i0_.valeur AS valeur_20, i0_.id AS id_21, i0_.etablissement_id AS etablissement_id_22 FROM items_insertion i0_ WHERE i0_.etablissement_id IN (?) AND i0_.diplome_plus = 1 ORDER BY RAND() ASC
Parameters: 
[
  [
    "ET033-171"
    "ET033-152"
    "ET033-184"
    "ET033-185"
    "ET033-173"
    "ET033-163"
    "ET033-193"
    "ET033-89"
    "ET033-234"
    "ET033-240"
    "ET033-126"
    "ET033-155"
  ]
]
View formatted query    View runnable query    Explain query    View query backtrace
2.18 ms
(1.20%) 		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 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_.onglets LIKE ? AND v0_.id IN (?) ORDER BY v0_.libelle ASC
Parameters: 
[
  "33"
  "%superieur%"
  [
    "33063"
    "33539"
    "33550"
  ]
]
View formatted query    View runnable query    Explain query    View query backtrace
2.11 ms
(1.16%) 		1 
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_.onglets LIKE ? AND d0_.id <> ? ORDER BY d0_.libelle ASC
Parameters: 
[
  "NOUV"
  "%superieur%"
  "BE"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.07 ms
(1.14%) 		1 
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
2.00 ms
(1.10%) 		1 
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
Parameters: 
[
  "PBAC-BAC3-%"
  [
    "PBAC-COORD"
    "PBAC-COORD-ADR"
    "PBAC-COORD-MAIL"
    "PBAC-COORD-TEL"
    "PBAC-COORD-WEB"
    "PBAC-PRES"
    "PBAC-ACCU"
    "PBAC-BAC2-CDV"
    "PBAC-SPEC"
    "PBAC-PRES-CHE"
    "PBAC-SPEC-TXTS"
    "PBAC-ACCU-EXT"
    "PBAC-SPEC-CAMP"
    "PBAC-SPEC-ENTR"
    "PBAC-ACCU-BOUR"
    "PBAC-ACCU-MIXT"
    "PBAC-BAC2-CDV-BTSMA"
    "PBAC-BAC3-CDV"
    "PBAC-BAC3-PUB"
    "PBAC-COORD-FAX"
    "PBAC-PRES-DTEUR"
    "PBAC-PRES-TUT"
    "PBAC-ACCU-CAF"
    "PBAC-ACCU-CANT"
    "PBAC-BAC2"
    "PBAC-BAC2-CDV-BTSAVSPI"
    "PBAC-BAC2-GADF"
    "PBAC-BAC2-PUB"
    "PBAC-BAC3-ENV"
    "PBAC-BAC3-GADF"
    "PBAC-PRES-NBE"
    "PBAC-SPEC-IGEN"
    "PBAC-SPEC-INTE"
    "PBAC-ACCU-ACCE"
    "PBAC-ACCU-HAND_MT"
    "PBAC-ACCU-INTA"
    "PBAC-ACCU-TXTS54"
    "PBAC-BAC2-AGRI"
    "PBAC-BAC2-BTP"
    "PBAC-BAC2-BTP-BTSBAT"
    "PBAC-BAC2-BTP-BTSMA"
    "PBAC-BAC2-BTP-BTSTPU"
    "PBAC-BAC2-CDV-BTSCOMI"
    "PBAC-BAC2-ELEC"
    "PBAC-BAC2-ELEC-BTSELEC"
    "PBAC-BAC2-GADF-BTSGE"
    "PBAC-BAC2-PUB-BTSCOM"
    "PBAC-BAC2-SASO"
    "PBAC-BAC2-SPOR"
    "PBAC-BAC2-SPOR-BTSTOU"
    "PBAC-BAC2-TXTS"
    "PBAC-BAC3"
    "PBAC-BAC3-ART"
    "PBAC-BAC3-PUB-BACHE"
    "PBAC-BAC3-SASO"
    "PBAC-BAC45-GADF"
    "PBAC-PRES-DTRICE"
    "PBAC-PRES-NID"
    "PBAC-PRES-SCO"
    "PBAC-SPEC-ADMI"
    "PBAC-TARIFS"
    "PBAC-TARIFS-RCOMPL"
    "PBAC"
    "PBAC-ACCU-HEB"
    "PBAC-BAC2-AGRI-ANASTRENA"
    "PBAC-BAC2-AGRI-BTSAOE"
    "PBAC-BAC2-AGRO"
    "PBAC-BAC2-AGRO-BTSAB"
    "PBAC-BAC2-ART"
    "PBAC-BAC2-ART-BTSAVEX"
    "PBAC-BAC2-ART-BTSAVIM"
    "PBAC-BAC2-ART-BTSAVMP"
    "PBAC-BAC2-ART-BTSAVPR"
    "PBAC-BAC2-ART-BTSAVSO"
    "PBAC-BAC2-AUT"
    "PBAC-BAC2-AUT-BTSPIND"
    "PBAC-BAC2-AUT-BTSTEIN"
    "PBAC-BAC2-BAI"
    "PBAC-BAC2-BAI-BANQU"
    "PBAC-BAC2-BTP-TECHN"
    "PBAC-BAC2-CDV-BTSNE"
    "PBAC-BAC2-ENV"
    "PBAC-BAC2-ENV-BTSAEAU"
    "PBAC-BAC2-GADF-BTSCO"
    "PBAC-BAC2-PUB-BTSER"
    "PBAC-BAC2-SASO-BTSESF"
    "PBAC-BAC2-SASO-BTSSASO"
    "PBAC-BAC2-TXTS0"
    "PBAC-BAC2-WEB"
    "PBAC-BAC2-WEB-BTSCI"
    "PBAC-BAC3-AGRO"
    "PBAC-BAC3-AGRO-GESPRO"
    "PBAC-BAC3-ART-BACHE5"
    "PBAC-BAC3-ART-DESIG"
    "PBAC-BAC3-ART-DIPLO4"
    "PBAC-BAC3-ART-DIPLO6"
    "PBAC-BAC3-ART-DIPLO7"
    "PBAC-BAC3-ART-DIPLO9"
    "PBAC-BAC3-ART-DNMAD"
    "PBAC-BAC3-BTP"
    "PBAC-BAC3-BTP-CQPCO"
    "PBAC-BAC3-BTP-CQPCP"
    "PBAC-BAC3-CDV-BACHE16"
    "PBAC-BAC3-CDV-BACHE22"
    "PBAC-BAC3-CDV-BACHE6"
    "PBAC-BAC3-CDV-COMDI"
    "PBAC-BAC3-CDV-LPCPS"
    "PBAC-BAC3-ENS"
    "PBAC-BAC3-ENS-LE1"
    "PBAC-BAC3-ENV-BACHE0"
    "PBAC-BAC3-ENV-EESTE"
    "PBAC-BAC3-ENV-PENVGES"
    "PBAC-BAC3-ENV-RESPO"
    "PBAC-BAC3-GADF-BACHE13"
    "PBAC-BAC3-GADF-BACHE2"
    "PBAC-BAC3-GADF-DCG"
    "PBAC-BAC3-PUB-GRAPH"
    "PBAC-BAC3-PUB-RESPO"
    "PBAC-BAC3-SASO-CESF"
    "PBAC-BAC3-SASO-DTSRTH"
    "PBAC-BAC3-SECU"
    "PBAC-BAC3-SECU-ASMS"
    "PBAC-BAC3-SPOR"
    "PBAC-BAC3-SPOR-TPRES"
    "PBAC-BAC3-TXTS"
    "PBAC-BAC3-TXTS0"
    "PBAC-BAC45"
    "PBAC-BAC45-CDV"
    "PBAC-BAC45-CDV-MANAG"
    "PBAC-BAC45-GADF-DSCG"
    "PBAC-BAC45-GADF-MASTE5"
    "PBAC-BAC45-GADF-TMRH"
    "PBAC-BAC45-TXTS0"
    "PBAC-FPC"
    "PBAC-FPC-BTPARC"
    "PBAC-FPC-BTPARC-BTSBA"
    "PBAC-FPC-BTPARC-BTSMA"
    "PBAC-FPC-BTPARC-BTSTR"
    "PBAC-FPC-BTPARC-CQPCO"
    "PBAC-FPC-ELEC"
    "PBAC-FPC-ELEC-BTSEL"
    "PBAC-FPC-INF"
    "PBAC-FPC-INF-BTSCI"
    "PBAC-FPC-TXTS0"
    "PBAC-PREPA-ART"
    "PBAC-PREPA-ART-PREPA0"
    "PBAC-PRES-AUTR1_MT"
    "PBAC-PRES-AUTR2_MT"
    "PBAC-PRES-TXTS"
    "PBAC-SPEC-TXTS51"
    "PBAC-TEXTC1_MT"
  ]
]
View formatted query    View runnable query    Explain query    View query backtrace
1.99 ms
(1.10%) 		1 
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
Parameters: 
[
  "LYC-FORMA2021-SPEC-%"
  []
]
View formatted query    View runnable query    Explain query    View query backtrace
1.55 ms
(0.85%) 		1 
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: 
[
  "GE088-10"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.88 ms
(0.48%) 		1 
SELECT i0_.identifiant AS identifiant_0, i0_.onglet AS onglet_1, i0_.libelle AS libelle_2, i0_.options AS options_3, i0_.niveau AS niveau_4, i0_.pere AS pere_5, i0_.libelle_specifique AS libelle_specifique_6, i0_.options_specifique AS options_specifique_7, i0_.texte AS texte_8, i0_.tri AS tri_9, i0_.complement_texte AS complement_texte_10, i0_.complement_url_libelle AS complement_url_libelle_11, i0_.complement_url AS complement_url_12, i0_.complement_updated_at AS complement_updated_at_13, i0_.libelle_mep AS libelle_mep_14, i0_.slug AS slug_15, i0_.formation AS formation_16, i0_.ligne_secours AS ligne_secours_17, i0_.updated_at AS updated_at_18, i0_.diplome_plus AS diplome_plus_19, i0_.valeur AS valeur_20, i0_.id AS id_21, i0_.etablissement_id AS etablissement_id_22 FROM items_insertion i0_ WHERE i0_.identifiant LIKE ? OR i0_.slug LIKE ? LIMIT 1
Parameters: 
[
  "bac-3-licence%"
  "bac-3-licence%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.09%) 		1 
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

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\Pays No errors.
App\Entity\VilleCoordonnees 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\Faq No errors.