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
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
  t0.slug AS slug_1,
  t0.libelle AS libelle_2,
  t0.id AS id_3,
  t0.maj AS maj_4,
  t0.region_id AS region_id_5
FROM
  ancienne_region t0
WHERE
  t0.id = ?

SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.id AS id_3, t0.maj AS maj_4, t0.region_id AS region_id_5 FROM ancienne_region t0 WHERE t0.id = 'GRAN';

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 = 'GRAN' AND d0_.id <> 'BE' ORDER BY d0_.libelle ASC;

SELECT
  j0_.date_publidation AS date_publidation_0,
  j0_.date_actualisation AS date_actualisation_1,
  j0_.lieu AS lieu_2,
  j0_.contenu AS contenu_3,
  j0_.updated AS updated_4,
  j0_.date AS date_5,
  j0_.heure_debut AS heure_debut_6,
  j0_.heure_fin AS heure_fin_7,
  j0_.file_name AS file_name_8,
  j0_.file_size AS file_size_9,
  j0_.legende AS legende_10,
  j0_.id AS id_11,
  j0_.image1_name AS image1_name_12,
  j0_.image1_original_name AS image1_original_name_13,
  j0_.image1_mime_type AS image1_mime_type_14,
  j0_.image1_size AS image1_size_15,
  j0_.image1_dimensions AS image1_dimensions_16,
  j0_.image2_name AS image2_name_17,
  j0_.image2_original_name AS image2_original_name_18,
  j0_.image2_mime_type AS image2_mime_type_19,
  j0_.image2_size AS image2_size_20,
  j0_.image2_dimensions AS image2_dimensions_21,
  j0_.image3_name AS image3_name_22,
  j0_.image3_original_name AS image3_original_name_23,
  j0_.image3_mime_type AS image3_mime_type_24,
  j0_.image3_size AS image3_size_25,
  j0_.image3_dimensions AS image3_dimensions_26,
  j0_.etablissement_id AS etablissement_id_27
FROM
  jpo j0_
  INNER JOIN etablissement e1_ ON j0_.etablissement_id = e1_.id
  INNER JOIN ville v2_ ON e1_.ville_id = v2_.id
  INNER JOIN departement d3_ ON v2_.departement_id = d3_.id
  INNER JOIN ancienne_region a4_ ON d3_.ancienne_region_id = a4_.id
  INNER JOIN region r5_ ON a4_.region_id = r5_.id
WHERE
  j0_.date >= ?
  AND d3_.id = ?
ORDER BY
  j0_.date ASC
LIMIT
  900

SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ INNER JOIN etablissement e1_ ON j0_.etablissement_id = e1_.id INNER JOIN ville v2_ ON e1_.ville_id = v2_.id INNER JOIN departement d3_ ON v2_.departement_id = d3_.id INNER JOIN ancienne_region a4_ ON d3_.ancienne_region_id = a4_.id INNER JOIN region r5_ ON a4_.region_id = r5_.id WHERE j0_.date >= '2026-09-10' AND d3_.id = '55' ORDER BY j0_.date ASC LIMIT 900;

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 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 = 'jpo' AND s0_.diplome IS NULL AND s0_.secteur IS NULL;

SELECT
  j0_.date_publidation AS date_publidation_0,
  j0_.date_actualisation AS date_actualisation_1,
  j0_.lieu AS lieu_2,
  j0_.contenu AS contenu_3,
  j0_.updated AS updated_4,
  j0_.date AS date_5,
  j0_.heure_debut AS heure_debut_6,
  j0_.heure_fin AS heure_fin_7,
  j0_.file_name AS file_name_8,
  j0_.file_size AS file_size_9,
  j0_.legende AS legende_10,
  j0_.id AS id_11,
  j0_.image1_name AS image1_name_12,
  j0_.image1_original_name AS image1_original_name_13,
  j0_.image1_mime_type AS image1_mime_type_14,
  j0_.image1_size AS image1_size_15,
  j0_.image1_dimensions AS image1_dimensions_16,
  j0_.image2_name AS image2_name_17,
  j0_.image2_original_name AS image2_original_name_18,
  j0_.image2_mime_type AS image2_mime_type_19,
  j0_.image2_size AS image2_size_20,
  j0_.image2_dimensions AS image2_dimensions_21,
  j0_.image3_name AS image3_name_22,
  j0_.image3_original_name AS image3_original_name_23,
  j0_.image3_mime_type AS image3_mime_type_24,
  j0_.image3_size AS image3_size_25,
  j0_.image3_dimensions AS image3_dimensions_26,
  j0_.etablissement_id AS etablissement_id_27
FROM
  jpo j0_
  INNER JOIN etablissement e1_ ON j0_.etablissement_id = e1_.id
WHERE
  e1_.jpo_plus = 1
  AND j0_.date >= ?
ORDER BY
  j0_.date ASC
LIMIT
  35

SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ INNER JOIN etablissement e1_ ON j0_.etablissement_id = e1_.id WHERE e1_.jpo_plus = 1 AND j0_.date >= '2026-09-10' ORDER BY j0_.date ASC LIMIT 35;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'aep'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'aep'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'aep' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'aep' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'aep' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'aep' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  c.COLUMN_NAME AS field,
  c.COLUMN_TYPE AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE        AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'aep' AND t.TABLE_SCHEMA = 'aep' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  DATABASE()

SELECT DATABASE();