Query Metrics
14
Database Queries
13
Different statements
49.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
16.06 ms (32.71%) |
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:
[
[
"49007"
"49092"
"49218"
"49301"
"49244"
"49023"
"49099"
"49331"
"49069"
"49328"
"49248"
"49373"
"49345"
"49050"
"49015"
"49035"
"49046"
"49086"
"49167"
"49176"
"49200"
"49220"
"49246"
"49261"
"49307"
"49353"
"49367"
"49002"
"49018"
"49020"
"49021"
"49022"
"49026"
"49027"
"49032"
"49036"
"49041"
"49054"
"49055"
"49058"
"49061"
"49063"
"49065"
"49068"
"49070"
"49080"
"49082"
"49089"
"49102"
"49109"
"49120"
"49125"
"49127"
"49129"
"49132"
"49135"
"49138"
"49144"
"49153"
"49160"
"49163"
"49178"
"49180"
"49183"
"49192"
"49193"
"49194"
"49195"
"49201"
"49205"
"49211"
"49214"
"49215"
"49222"
"49223"
"49224"
"49228"
"49231"
"49240"
"49247"
"49259"
"49260"
"49266"
"49267"
"49269"
"49278"
"49283"
"49284"
"49292"
"49294"
"49299"
"49310"
"49323"
"49329"
"49330"
"49332"
"49336"
"49337"
"49343"
"49347"
]
]
|
||||||||||||||||||||||||||||||||
|
12.84 ms (26.17%) |
2 |
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:
[
"valanjou-49670"
]
|
||||||||||||||||||||||||||||||||
|
7.83 ms (15.95%) |
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:
[ "49" "%ecole%" [ "49007" "49092" "49218" "49301" "49244" "49023" "49099" "49331" "49069" "49328" "49248" "49373" "49345" "49050" "49015" "49035" "49046" "49086" "49167" "49176" "49200" "49220" "49246" "49261" "49307" "49353" "49367" "49002" "49018" "49020" "49021" "49022" "49026" "49027" "49032" "49036" "49041" "49054" "49055" "49058" "49061" "49063" "49065" "49068" "49070" "49080" "49082" "49089" "49102" "49109" "49120" "49125" "49127" "49129" "49132" "49135" "49138" "49144" "49153" "49160" "49163" "49178" "49180" "49183" "49192" "49193" "49194" "49195" "49201" "49205" "49211" "49214" "49215" "49222" "49223" "49224" "49228" "49231" "49240" "49247" "49259" "49260" "49266" "49267" "49269" "49278" "49283" "49284" "49292" "49294" "49299" "49310" "49323" "49329" "49330" "49332" "49336" "49337" "49343" "49347" "49352" "49355" "49362" "49368" "49371" "49377" "49378" "49381" ] ] |
||||||||||||||||||||||||||||||||
|
4.85 ms (9.87%) |
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:
[
[
"ET049-21"
]
]
|
||||||||||||||||||||||||||||||||
|
3.87 ms (7.88%) |
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:
[
"ecole"
]
|
||||||||||||||||||||||||||||||||
|
1.00 ms (2.03%) |
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:
[ "ecole" "valanjou-49670" 1 ]
|
||||||||||||||||||||||||||||||||
|
0.80 ms (1.62%) |
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:
[] |
||||||||||||||||||||||||||||||||
|
0.44 ms (0.90%) |
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:
[] |
||||||||||||||||||||||||||||||||
|
0.36 ms (0.73%) |
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:
[] |
||||||||||||||||||||||||||||||||
|
0.34 ms (0.69%) |
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:
[ "ecole-%" [ "ECOLE-COORD" "ECOLE-COORD-ADR" "ECOLE-COORD-MAIL" "ECOLE-COORD-TEL" "ECOLE-ACCU" "ECOLE-ACCU-ADM" "ECOLE-ACCU-MIXT" "ECOLE-CLA" "ECOLE-CLA-MAT" "ECOLE-CLA-PRIM" "ECOLE-COORD-FAX" "ECOLE-COORD-WEB" "ECOLE-PRES" "ECOLE-PRES-CHE" "ECOLE-SPEC" "ECOLE-ACCU-ADM-2ANS" "ECOLE-ACCU-CANT" "ECOLE-ACCU-EXT" "ECOLE-ACCU-ORGA" "ECOLE-ACCU-PERI" "ECOLE-PRES-NBC" "ECOLE-PRES-NBE" "ECOLE-PRES-SCO" "ECOLE-PRES-TUT" "ECOLE-SPEC-INI" "ECOLE-SPEC-REPA" "ECOLE-ACCU-HOR_MT" "ECOLE-ACCU-ORGA-S4J" "ECOLE-ACCU-ORGA-S5J" "ECOLE-ACCU-TXTS" "ECOLE-PRES-DTRICE" "ECOLE-SPEC-ART" "ECOLE-SPEC-B2I" "ECOLE-SPEC-CDEC" "ECOLE-SPEC-EDU" "ECOLE-SPEC-EFF" "ECOLE-SPEC-SORT" "ECOLE-SPEC-SPOR" "ECOLE-SPEC-TICE" ] ] |
||||||||||||||||||||||||||||||||
|
0.27 ms (0.54%) |
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:
[
"%ecole%"
]
|
||||||||||||||||||||||||||||||||
|
0.25 ms (0.51%) |
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-%"
[]
]
|
||||||||||||||||||||||||||||||||
|
0.19 ms (0.38%) |
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:
[ "PAYS" "%ecole%" "BE" ] |
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. |