Symfony Profiler

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;

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_;

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

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;

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 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 = '000' AND d0_.id <> 'BE' 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
  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

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 = '000' ORDER BY v0_.libelle ASC;

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

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;

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

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;

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

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 = 4878 ORDER BY t0.position ASC;

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

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 = 4891 ORDER BY t0.position ASC;