Query Metrics
12
Database Queries
8
Different statements
29.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
24.84 ms (84.97%) |
1 |
SELECT d0_.id AS id_0, d0_.titre AS titre_1, d0_.texte AS texte_2, d0_.actif AS actif_3, d0_.position AS position_4, d0_.principal AS principal_5, d0_.date_crea AS date_crea_6, d0_.date_maj AS date_maj_7 FROM diaporama d0_ INNER JOIN diaporama_etablissement d2_ ON d0_.id = d2_.diaporama_id INNER JOIN etablissement e1_ ON e1_.id = d2_.etablissement_id INNER JOIN ville v3_ ON e1_.ville_id = v3_.id INNER JOIN departement d4_ ON v3_.departement_id = d4_.id INNER JOIN ancienne_region a5_ ON d4_.ancienne_region_id = a5_.id INNER JOIN region r6_ ON a5_.region_id = r6_.id WHERE e1_.diapo_plus = 1 ORDER BY d0_.date_crea DESC LIMIT 100
Parameters:
[] |
|
1.61 ms (5.49%) |
5 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.legende AS legende_3, t0.actif AS actif_4, t0.position AS position_5, t0.file_name AS file_name_6, t0.file_size AS file_size_7, t0.updated_at AS updated_at_8, t0.file_name_source AS file_name_source_9, t0.file_size_source AS file_size_source_10, t0.diaporama_id AS diaporama_id_11 FROM diaporama_photo t0 WHERE t0.diaporama_id = ? ORDER BY t0.position ASC
Parameters:
[
4878
]
|
|
0.91 ms (3.10%) |
1 |
SELECT d0_.id AS id_0, d0_.titre AS titre_1, d0_.texte AS texte_2, d0_.actif AS actif_3, d0_.position AS position_4, d0_.principal AS principal_5, d0_.date_crea AS date_crea_6, d0_.date_maj AS date_maj_7, e1_.type AS type_8, e1_.nombre_eleves AS nombre_eleves_9, e1_.url AS url_10, e1_.video AS video_11, e1_.mots_cles AS mots_cles_12, e1_.denomination AS denomination_13, e1_.denomination_sigle AS denomination_sigle_14, e1_.denomination_extension AS denomination_extension_15, e1_.denomination_abregee AS denomination_abregee_16, e1_.droit_page_web AS droit_page_web_17, e1_.droit_actualite AS droit_actualite_18, e1_.adresse1 AS adresse1_19, e1_.adresse2 AS adresse2_20, e1_.adresse3 AS adresse3_21, e1_.code_postal AS code_postal_22, e1_.cedex AS cedex_23, e1_.latitude AS latitude_24, e1_.longitude AS longitude_25, e1_.telephone_principal AS telephone_principal_26, e1_.fax AS fax_27, e1_.email_principal AS email_principal_28, e1_.logo_liste AS logo_liste_29, e1_.logo_fiche AS logo_fiche_30, e1_.diaporama_actif AS diaporama_actif_31, e1_.images_diaporama AS images_diaporama_32, e1_.participant AS participant_33, e1_.catholique AS catholique_34, e1_.age_admission AS age_admission_35, e1_.actif AS actif_36, e1_.internat AS internat_37, e1_.has_internat AS has_internat_38, e1_.types_internat AS types_internat_39, e1_.sous_contrat AS sous_contrat_40, e1_.alternance AS alternance_41, e1_.type_client AS type_client_42, e1_.bloque_txt_ref AS bloque_txt_ref_43, e1_.facebook AS facebook_44, e1_.bloque_bac2021 AS bloque_bac2021_45, e1_.presence_web AS presence_web_46, e1_.video_plus AS video_plus_47, e1_.diapo_plus AS diapo_plus_48, e1_.jpo_plus AS jpo_plus_49, e1_.doc_plus AS doc_plus_50, e1_.diplome_plus AS diplome_plus_51, e1_.refus AS refus_52, e1_.path AS path_53, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_54, e1_.lva AS lva_55, e1_.lvb AS lvb_56, e1_.numero_administratif_uai AS numero_administratif_uai_57, e1_.siret AS siret_58, e1_.chiffres AS chiffres_59, e1_.id AS id_60, e1_.maj AS maj_61, e2_.type AS type_62, e2_.nombre_eleves AS nombre_eleves_63, e2_.url AS url_64, e2_.video AS video_65, e2_.mots_cles AS mots_cles_66, e2_.denomination AS denomination_67, e2_.denomination_sigle AS denomination_sigle_68, e2_.denomination_extension AS denomination_extension_69, e2_.denomination_abregee AS denomination_abregee_70, e2_.droit_page_web AS droit_page_web_71, e2_.droit_actualite AS droit_actualite_72, e2_.adresse1 AS adresse1_73, e2_.adresse2 AS adresse2_74, e2_.adresse3 AS adresse3_75, e2_.code_postal AS code_postal_76, e2_.cedex AS cedex_77, e2_.latitude AS latitude_78, e2_.longitude AS longitude_79, e2_.telephone_principal AS telephone_principal_80, e2_.fax AS fax_81, e2_.email_principal AS email_principal_82, e2_.logo_liste AS logo_liste_83, e2_.logo_fiche AS logo_fiche_84, e2_.diaporama_actif AS diaporama_actif_85, e2_.images_diaporama AS images_diaporama_86, e2_.participant AS participant_87, e2_.catholique AS catholique_88, e2_.age_admission AS age_admission_89, e2_.actif AS actif_90, e2_.internat AS internat_91, e2_.has_internat AS has_internat_92, e2_.types_internat AS types_internat_93, e2_.sous_contrat AS sous_contrat_94, e2_.alternance AS alternance_95, e2_.type_client AS type_client_96, e2_.bloque_txt_ref AS bloque_txt_ref_97, e2_.facebook AS facebook_98, e2_.bloque_bac2021 AS bloque_bac2021_99, e2_.presence_web AS presence_web_100, e2_.video_plus AS video_plus_101, e2_.diapo_plus AS diapo_plus_102, e2_.jpo_plus AS jpo_plus_103, e2_.doc_plus AS doc_plus_104, e2_.diplome_plus AS diplome_plus_105, e2_.refus AS refus_106, e2_.path AS path_107, e2_.composition_ensemble_scolaire AS composition_ensemble_scolaire_108, e2_.lva AS lva_109, e2_.lvb AS lvb_110, e2_.numero_administratif_uai AS numero_administratif_uai_111, e2_.siret AS siret_112, e2_.chiffres AS chiffres_113, e2_.id AS id_114, e2_.maj AS maj_115, t3_.actif AS actif_116, t3_.contenu AS contenu_117, t3_.id AS id_118, v4_.slug AS slug_119, v4_.libelle AS libelle_120, v4_.code_postal AS code_postal_121, v4_.email_delegue AS email_delegue_122, v4_.onglets AS onglets_123, v4_.id AS id_124, v4_.maj AS maj_125, v5_.latitude AS latitude_126, v5_.longitude AS longitude_127, v5_.id AS id_128, d6_.slug AS slug_129, d6_.libelle AS libelle_130, d6_.onglets AS onglets_131, d6_.id AS id_132, d6_.maj AS maj_133, d7_.latitude AS latitude_134, d7_.longitude AS longitude_135, d7_.id AS id_136, a8_.slug AS slug_137, a8_.libelle AS libelle_138, a8_.id AS id_139, a8_.maj AS maj_140, r9_.libelle AS libelle_141, r9_.slug AS slug_142, r9_.region_adm AS region_adm_143, r9_.ancienne AS ancienne_144, r9_.onglets AS onglets_145, r9_.id AS id_146, r9_.maj AS maj_147, p10_.libelle AS libelle_148, p10_.id AS id_149, p10_.maj AS maj_150, c11_.libelle AS libelle_151, c11_.id AS id_152, c11_.maj AS maj_153, t12_.actif AS actif_154, t12_.contenu AS contenu_155, t12_.id AS id_156, e1_.gestionnaire_id AS gestionnaire_id_157, e1_.ville_id AS ville_id_158, e1_.categorie_primaire_id AS categorie_primaire_id_159, e1_.region_id AS region_id_160, e1_.departement_id AS departement_id_161, e1_.categorie_organisme_id AS categorie_organisme_id_162, e1_.rubrique AS rubrique_163, e1_.internat2_id AS internat2_id_164, e1_.etablissement_lie_id AS etablissement_lie_id_165, e1_.logo_id AS logo_id_166, e1_.diapo_principal_id AS diapo_principal_id_167, e2_.gestionnaire_id AS gestionnaire_id_168, e2_.ville_id AS ville_id_169, e2_.categorie_primaire_id AS categorie_primaire_id_170, e2_.region_id AS region_id_171, e2_.departement_id AS departement_id_172, e2_.categorie_organisme_id AS categorie_organisme_id_173, e2_.rubrique AS rubrique_174, e2_.internat2_id AS internat2_id_175, e2_.etablissement_lie_id AS etablissement_lie_id_176, e2_.logo_id AS logo_id_177, e2_.diapo_principal_id AS diapo_principal_id_178, t3_.etablissement_id AS etablissement_id_179, t3_.template_id AS template_id_180, v4_.departement_id AS departement_id_181, v5_.ville_id AS ville_id_182, d6_.ancienne_region_id AS ancienne_region_id_183, d6_.region_id AS region_id_184, d7_.departement_id AS departement_id_185, a8_.region_id AS region_id_186, r9_.pays_id AS pays_id_187, t12_.etablissement_id AS etablissement_id_188, t12_.template_id AS template_id_189 FROM diaporama d0_ INNER JOIN diaporama_etablissement d14_ ON d0_.id = d14_.diaporama_id INNER JOIN etablissement e13_ ON e13_.id = d14_.etablissement_id LEFT JOIN diaporama_etablissement d15_ ON d0_.id = d15_.diaporama_id LEFT JOIN etablissement e1_ ON e1_.id = d15_.etablissement_id LEFT JOIN etablissement e2_ ON e1_.gestionnaire_id = e2_.id LEFT JOIN texte_referencement t3_ ON e2_.id = t3_.etablissement_id LEFT JOIN ville v4_ ON e1_.ville_id = v4_.id LEFT JOIN ville_coordonnees v5_ ON v4_.id = v5_.ville_id LEFT JOIN departement d6_ ON v4_.departement_id = d6_.id LEFT JOIN departement_coordonnees d7_ ON d6_.id = d7_.departement_id LEFT JOIN ancienne_region a8_ ON d6_.ancienne_region_id = a8_.id LEFT JOIN region r9_ ON a8_.region_id = r9_.id LEFT JOIN pays p10_ ON r9_.pays_id = p10_.id LEFT JOIN categorie c11_ ON e1_.categorie_primaire_id = c11_.id LEFT JOIN texte_referencement t12_ ON e1_.id = t12_.etablissement_id WHERE e13_.diapo_plus = 1 ORDER BY d0_.date_crea DESC LIMIT 15
Parameters:
[] |
|
0.43 ms (1.45%) |
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.41 ms (1.41%) |
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_.id <> ? ORDER BY d0_.libelle ASC
Parameters:
[ "000" "BE" ] |
|
0.41 ms (1.39%) |
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.34 ms (1.16%) |
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 LEFT JOIN departement d2_ ON v0_.departement_id = d2_.id LEFT JOIN ancienne_region a3_ ON d2_.ancienne_region_id = a3_.id WHERE v0_.libelle IS NOT NULL AND a3_.region_id = ? ORDER BY v0_.libelle ASC
Parameters:
[
"000"
]
|
|
0.30 ms (1.02%) |
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_.ancienne IS NULL AND r0_.libelle IS NOT NULL AND r0_.slug IS NOT NULL AND r0_.libelle <> 'DEFAULT' AND r0_.region_adm IS NOT NULL ORDER BY r0_.libelle ASC
Parameters:
[] |
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\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\Pays | No errors. |
| App\Entity\VilleCoordonnees | No errors. |
| App\Entity\Diaporama | No errors. |
| App\Entity\DiaporamaPhoto | No errors. |
| App\Entity\TexteReferencement | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\CategorieOrganisme | No errors. |
| App\Entity\RubriqueFournisseur | No errors. |
| App\Entity\Logo | 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. |