Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.url AS url_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.image_entete AS image_entete_6,
  t0.logo AS logo_7,
  t0.adresse AS adresse_8,
  t0.ville AS ville_9,
  t0.code_postal AS code_postal_10,
  t0.telephone AS telephone_11,
  t0.titre AS titre_12,
  t0.a_propos AS a_propos_13,
  t0.nom_contact_presse AS nom_contact_presse_14,
  t0.email_contact_presse AS email_contact_presse_15,
  t0.tel_contact_presse AS tel_contact_presse_16
FROM
  structure t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.url AS url_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.image_entete AS image_entete_6, t0.logo AS logo_7, t0.adresse AS adresse_8, t0.ville AS ville_9, t0.code_postal AS code_postal_10, t0.telephone AS telephone_11, t0.titre AS titre_12, t0.a_propos AS a_propos_13, t0.nom_contact_presse AS nom_contact_presse_14, t0.email_contact_presse AS email_contact_presse_15, t0.tel_contact_presse AS tel_contact_presse_16 FROM structure t0 WHERE t0.url = 'fight-impro.fr' LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.titre AS titre_1,
  e0_.date_debut AS date_debut_2,
  e0_.date_fin AS date_fin_3,
  e0_.doc_pdf AS doc_pdf_4,
  e0_.resume AS resume_5,
  e0_.texte AS texte_6,
  e0_.affiche AS affiche_7,
  e0_.structure_principale_id AS structure_principale_id_8
FROM
  evenement e0_
  LEFT JOIN structure s1_ ON e0_.structure_principale_id = s1_.id
  LEFT JOIN evenement_structure e3_ ON e0_.id = e3_.evenement_id
  LEFT JOIN structure s2_ ON s2_.id = e3_.structure_id
WHERE
  s1_.url = ?
  OR s2_.url = ?
ORDER BY
  e0_.date_fin DESC
LIMIT
  1

SELECT e0_.id AS id_0, e0_.titre AS titre_1, e0_.date_debut AS date_debut_2, e0_.date_fin AS date_fin_3, e0_.doc_pdf AS doc_pdf_4, e0_.resume AS resume_5, e0_.texte AS texte_6, e0_.affiche AS affiche_7, e0_.structure_principale_id AS structure_principale_id_8 FROM evenement e0_ LEFT JOIN structure s1_ ON e0_.structure_principale_id = s1_.id LEFT JOIN evenement_structure e3_ ON e0_.id = e3_.evenement_id LEFT JOIN structure s2_ ON s2_.id = e3_.structure_id WHERE s1_.url = 'fight-impro.fr' OR s2_.url = 'fight-impro.fr' ORDER BY e0_.date_fin DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.url AS url_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.image_entete AS image_entete_6,
  t0.logo AS logo_7,
  t0.adresse AS adresse_8,
  t0.ville AS ville_9,
  t0.code_postal AS code_postal_10,
  t0.telephone AS telephone_11,
  t0.titre AS titre_12,
  t0.a_propos AS a_propos_13,
  t0.nom_contact_presse AS nom_contact_presse_14,
  t0.email_contact_presse AS email_contact_presse_15,
  t0.tel_contact_presse AS tel_contact_presse_16
FROM
  structure t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.url AS url_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.image_entete AS image_entete_6, t0.logo AS logo_7, t0.adresse AS adresse_8, t0.ville AS ville_9, t0.code_postal AS code_postal_10, t0.telephone AS telephone_11, t0.titre AS titre_12, t0.a_propos AS a_propos_13, t0.nom_contact_presse AS nom_contact_presse_14, t0.email_contact_presse AS email_contact_presse_15, t0.tel_contact_presse AS tel_contact_presse_16 FROM structure t0 WHERE t0.id = 5;

SELECT
  'main'

SELECT 'main';

SELECT
  name AS table_name
FROM
  sqlite_master
WHERE
  type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT
  name
FROM
  sqlite_temp_master
WHERE
  type = 'table'
ORDER BY
  name

SELECT name AS table_name
FROM sqlite_master
WHERE type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT name
FROM sqlite_temp_master
WHERE type = 'table'
ORDER BY name;

SELECT
  'main'

SELECT 'main';

SELECT
  name AS table_name
FROM
  sqlite_master
WHERE
  type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT
  name
FROM
  sqlite_temp_master
WHERE
  type = 'table'
ORDER BY
  name

SELECT name AS table_name
FROM sqlite_master
WHERE type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT name
FROM sqlite_temp_master
WHERE type = 'table'
ORDER BY name;

SELECT
  'main'

SELECT 'main';

SELECT
  t.name AS table_name,
  c.*
FROM
  sqlite_master t
  JOIN pragma_table_info(t.name) c
WHERE
  t.type = 'table'
  AND t.name NOT IN (
    'geometry_columns', 'spatial_ref_sys',
    'sqlite_sequence'
  )
  AND t.name = ?
ORDER BY
  t.name,
  c.cid

SELECT t.name AS table_name,
                   c.*
              FROM sqlite_master t
              JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'doctrine_migration_versions' ORDER BY t.name, c.cid;

SELECT
  sql
FROM
  (
    SELECT
      *
    FROM
      sqlite_master
    UNION ALL
    SELECT
      *
    FROM
      sqlite_temp_master
  )
WHERE
  type = 'table'
  AND name = ?

SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = 'doctrine_migration_versions';

SELECT
  'main'

SELECT 'main';

SELECT
  t.name AS table_name,
  i.*
FROM
  sqlite_master t
  JOIN pragma_index_list(t.name) i
WHERE
  t.type = 'table'
  AND t.name NOT IN (
    'geometry_columns', 'spatial_ref_sys',
    'sqlite_sequence'
  )
  AND t.name = ?
ORDER BY
  t.name,
  i.seq

SELECT t.name AS table_name,
                   i.*
              FROM sqlite_master t
              JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'doctrine_migration_versions' ORDER BY t.name, i.seq;

SELECT
  *
FROM
  PRAGMA_TABLE_INFO (?)

SELECT * FROM PRAGMA_TABLE_INFO ('doctrine_migration_versions');

SELECT
  t.name AS table_name,
  p.*
FROM
  sqlite_master t
  JOIN pragma_foreign_key_list(t.name) p ON p."seq" != '-1'
WHERE
  t.type = 'table'
  AND t.name NOT IN (
    'geometry_columns', 'spatial_ref_sys',
    'sqlite_sequence'
  )
  AND t.name = ?
ORDER BY
  t.name,
  p.id DESC,
  p.seq

SELECT t.name AS table_name,
                   p.*
              FROM sqlite_master t
              JOIN pragma_foreign_key_list(t.name) p
                ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'doctrine_migration_versions' ORDER BY t.name, p.id DESC, p.seq;

SELECT
  'main'

SELECT 'main';

SELECT
  sql
FROM
  (
    SELECT
      *
    FROM
      sqlite_master
    UNION ALL
    SELECT
      *
    FROM
      sqlite_temp_master
  )
WHERE
  type = 'table'
  AND name = ?

SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = 'doctrine_migration_versions';

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  'main'

SELECT 'main';

SELECT
  a0_.id AS id_0,
  a0_.date_debut AS date_debut_1,
  a0_.date_fin AS date_fin_2,
  a0_.nom_organisateur AS nom_organisateur_3,
  a0_.url_organisateur AS url_organisateur_4,
  a0_.url_billeterie AS url_billeterie_5,
  a0_.tel_reservation AS tel_reservation_6,
  a0_.en_ligne AS en_ligne_7,
  a0_.slug AS slug_8,
  a0_.event_status AS event_status_9,
  a0_.prive AS prive_10,
  a0_.high_price AS high_price_11,
  a0_.low_price AS low_price_12,
  a0_.low_price_texte AS low_price_texte_13,
  a0_.high_price_text AS high_price_text_14,
  a0_.availability AS availability_15,
  a0_.meta_description AS meta_description_16,
  a0_.date AS date_17,
  a0_.acces AS acces_18,
  a0_.raison_annulation AS raison_annulation_19,
  a0_.sous_titre AS sous_titre_20,
  a0_.description AS description_21,
  a0_.slug_texte AS slug_texte_22,
  a0_.lettre_diffusion AS lettre_diffusion_23,
  a0_.image_agenda AS image_agenda_24,
  a0_.inverse_titre_sous_titre AS inverse_titre_sous_titre_25,
  a0_.en_avant AS en_avant_26,
  a0_.resume AS resume_27,
  a0_.affiche AS affiche_28,
  a0_.old_slug AS old_slug_29,
  a0_.touteplage_horaire AS touteplage_horaire_30,
  a0_.texte_plage_horaire AS texte_plage_horaire_31,
  a0_.suitecrm_id AS suitecrm_id_32,
  a0_.spectacle_id AS spectacle_id_33,
  a0_.lieu_id AS lieu_id_34,
  a0_.structure_id AS structure_id_35,
  a0_.evenement_id AS evenement_id_36
FROM
  agenda a0_
  LEFT JOIN structure s1_ ON a0_.structure_id = s1_.id
  LEFT JOIN agenda_structure a3_ ON a0_.id = a3_.agenda_id
  LEFT JOIN structure s2_ ON s2_.id = a3_.structure_id
WHERE
  a0_.date_debut > ?
  AND a0_.en_ligne = ?
  AND (
    s1_.url = ?
    OR s2_.url = ?
  )
  AND a0_.prive = 0
ORDER BY
  a0_.date_debut ASC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.nom_organisateur AS nom_organisateur_3, a0_.url_organisateur AS url_organisateur_4, a0_.url_billeterie AS url_billeterie_5, a0_.tel_reservation AS tel_reservation_6, a0_.en_ligne AS en_ligne_7, a0_.slug AS slug_8, a0_.event_status AS event_status_9, a0_.prive AS prive_10, a0_.high_price AS high_price_11, a0_.low_price AS low_price_12, a0_.low_price_texte AS low_price_texte_13, a0_.high_price_text AS high_price_text_14, a0_.availability AS availability_15, a0_.meta_description AS meta_description_16, a0_.date AS date_17, a0_.acces AS acces_18, a0_.raison_annulation AS raison_annulation_19, a0_.sous_titre AS sous_titre_20, a0_.description AS description_21, a0_.slug_texte AS slug_texte_22, a0_.lettre_diffusion AS lettre_diffusion_23, a0_.image_agenda AS image_agenda_24, a0_.inverse_titre_sous_titre AS inverse_titre_sous_titre_25, a0_.en_avant AS en_avant_26, a0_.resume AS resume_27, a0_.affiche AS affiche_28, a0_.old_slug AS old_slug_29, a0_.touteplage_horaire AS touteplage_horaire_30, a0_.texte_plage_horaire AS texte_plage_horaire_31, a0_.suitecrm_id AS suitecrm_id_32, a0_.spectacle_id AS spectacle_id_33, a0_.lieu_id AS lieu_id_34, a0_.structure_id AS structure_id_35, a0_.evenement_id AS evenement_id_36 FROM agenda a0_ LEFT JOIN structure s1_ ON a0_.structure_id = s1_.id LEFT JOIN agenda_structure a3_ ON a0_.id = a3_.agenda_id LEFT JOIN structure s2_ ON s2_.id = a3_.structure_id WHERE a0_.date_debut > '2026-09-09 12:48:47' AND a0_.en_ligne = 1 AND (s1_.url = 'fight-impro.fr' OR s2_.url = 'fight-impro.fr') AND a0_.prive = 0 ORDER BY a0_.date_debut ASC LIMIT 3;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.date_debut AS date_debut_1,
          a0_.date_fin AS date_fin_2,
          a0_.nom_organisateur AS nom_organisateur_3,
          a0_.url_organisateur AS url_organisateur_4,
          a0_.url_billeterie AS url_billeterie_5,
          a0_.tel_reservation AS tel_reservation_6,
          a0_.en_ligne AS en_ligne_7,
          a0_.slug AS slug_8,
          a0_.event_status AS event_status_9,
          a0_.prive AS prive_10,
          a0_.high_price AS high_price_11,
          a0_.low_price AS low_price_12,
          a0_.low_price_texte AS low_price_texte_13,
          a0_.high_price_text AS high_price_text_14,
          a0_.availability AS availability_15,
          a0_.meta_description AS meta_description_16,
          a0_.date AS date_17,
          a0_.acces AS acces_18,
          a0_.raison_annulation AS raison_annulation_19,
          a0_.sous_titre AS sous_titre_20,
          a0_.description AS description_21,
          a0_.slug_texte AS slug_texte_22,
          a0_.lettre_diffusion AS lettre_diffusion_23,
          a0_.image_agenda AS image_agenda_24,
          a0_.inverse_titre_sous_titre AS inverse_titre_sous_titre_25,
          a0_.en_avant AS en_avant_26,
          a0_.resume AS resume_27,
          a0_.affiche AS affiche_28,
          a0_.old_slug AS old_slug_29,
          a0_.touteplage_horaire AS touteplage_horaire_30,
          a0_.texte_plage_horaire AS texte_plage_horaire_31,
          a0_.suitecrm_id AS suitecrm_id_32
        FROM
          agenda a0_
          LEFT JOIN structure s1_ ON a0_.structure_id = s1_.id
          LEFT JOIN agenda_structure a3_ ON a0_.id = a3_.agenda_id
          LEFT JOIN structure s2_ ON s2_.id = a3_.structure_id
        WHERE
          a0_.date_debut > ?
          AND a0_.en_ligne = ?
          AND (
            s1_.url = ?
            OR s2_.url = ?
          )
          AND a0_.prive = 0
        ORDER BY
          a0_.date_debut ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.date_fin AS date_fin_2, a0_.nom_organisateur AS nom_organisateur_3, a0_.url_organisateur AS url_organisateur_4, a0_.url_billeterie AS url_billeterie_5, a0_.tel_reservation AS tel_reservation_6, a0_.en_ligne AS en_ligne_7, a0_.slug AS slug_8, a0_.event_status AS event_status_9, a0_.prive AS prive_10, a0_.high_price AS high_price_11, a0_.low_price AS low_price_12, a0_.low_price_texte AS low_price_texte_13, a0_.high_price_text AS high_price_text_14, a0_.availability AS availability_15, a0_.meta_description AS meta_description_16, a0_.date AS date_17, a0_.acces AS acces_18, a0_.raison_annulation AS raison_annulation_19, a0_.sous_titre AS sous_titre_20, a0_.description AS description_21, a0_.slug_texte AS slug_texte_22, a0_.lettre_diffusion AS lettre_diffusion_23, a0_.image_agenda AS image_agenda_24, a0_.inverse_titre_sous_titre AS inverse_titre_sous_titre_25, a0_.en_avant AS en_avant_26, a0_.resume AS resume_27, a0_.affiche AS affiche_28, a0_.old_slug AS old_slug_29, a0_.touteplage_horaire AS touteplage_horaire_30, a0_.texte_plage_horaire AS texte_plage_horaire_31, a0_.suitecrm_id AS suitecrm_id_32 FROM agenda a0_ LEFT JOIN structure s1_ ON a0_.structure_id = s1_.id LEFT JOIN agenda_structure a3_ ON a0_.id = a3_.agenda_id LEFT JOIN structure s2_ ON s2_.id = a3_.structure_id WHERE a0_.date_debut > '2026-09-09 12:48:47' AND a0_.en_ligne = 1 AND (s1_.url = 'fight-impro.fr' OR s2_.url = 'fight-impro.fr') AND a0_.prive = 0 ORDER BY a0_.date_debut ASC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.resume AS resume_5,
  t0.description AS description_6,
  t0.slug AS slug_7,
  t0.en_ligne AS en_ligne_8,
  t0.archive AS archive_9,
  t0.annee_creation AS annee_creation_10,
  t0.jauge AS jauge_11,
  t0.slogan AS slogan_12,
  t0.resume_technique AS resume_technique_13,
  t0.duree AS duree_14,
  t0.genre_spectacle AS genre_spectacle_15,
  t0.video AS video_16,
  t0.priorite AS priorite_17,
  t0.url AS url_18,
  t0.argument_pro AS argument_pro_19,
  t0.argument_en_avant AS argument_en_avant_20,
  t0.titre_section_principale AS titre_section_principale_21,
  t0.derniere_modif AS derniere_modif_22,
  t0.structure_principal_id AS structure_principal_id_23,
  t0.image_entete_id AS image_entete_id_24,
  t0.affiche_id AS affiche_id_25,
  t0.affiche_spectacle_id AS affiche_spectacle_id_26,
  t0.compagnie_id AS compagnie_id_27,
  t0.gallerie_id AS gallerie_id_28,
  t0.dossier_gallerie_id AS dossier_gallerie_id_29
FROM
  spectacle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.resume AS resume_5, t0.description AS description_6, t0.slug AS slug_7, t0.en_ligne AS en_ligne_8, t0.archive AS archive_9, t0.annee_creation AS annee_creation_10, t0.jauge AS jauge_11, t0.slogan AS slogan_12, t0.resume_technique AS resume_technique_13, t0.duree AS duree_14, t0.genre_spectacle AS genre_spectacle_15, t0.video AS video_16, t0.priorite AS priorite_17, t0.url AS url_18, t0.argument_pro AS argument_pro_19, t0.argument_en_avant AS argument_en_avant_20, t0.titre_section_principale AS titre_section_principale_21, t0.derniere_modif AS derniere_modif_22, t0.structure_principal_id AS structure_principal_id_23, t0.image_entete_id AS image_entete_id_24, t0.affiche_id AS affiche_id_25, t0.affiche_spectacle_id AS affiche_spectacle_id_26, t0.compagnie_id AS compagnie_id_27, t0.gallerie_id AS gallerie_id_28, t0.dossier_gallerie_id AS dossier_gallerie_id_29 FROM spectacle t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.credits AS credits_3,
  t0.nom_fichier AS nom_fichier_4,
  t5.id AS id_6,
  t5.titre AS titre_7,
  t5.meta_title AS meta_title_8,
  t5.meta_description AS meta_description_9,
  t5.resume AS resume_10,
  t5.description AS description_11,
  t5.slug AS slug_12,
  t5.en_ligne AS en_ligne_13,
  t5.archive AS archive_14,
  t5.annee_creation AS annee_creation_15,
  t5.jauge AS jauge_16,
  t5.slogan AS slogan_17,
  t5.resume_technique AS resume_technique_18,
  t5.duree AS duree_19,
  t5.genre_spectacle AS genre_spectacle_20,
  t5.video AS video_21,
  t5.priorite AS priorite_22,
  t5.url AS url_23,
  t5.argument_pro AS argument_pro_24,
  t5.argument_en_avant AS argument_en_avant_25,
  t5.titre_section_principale AS titre_section_principale_26,
  t5.derniere_modif AS derniere_modif_27,
  t5.structure_principal_id AS structure_principal_id_28,
  t5.image_entete_id AS image_entete_id_29,
  t5.affiche_id AS affiche_id_30,
  t5.affiche_spectacle_id AS affiche_spectacle_id_31,
  t5.compagnie_id AS compagnie_id_32,
  t5.gallerie_id AS gallerie_id_33,
  t5.dossier_gallerie_id AS dossier_gallerie_id_34
FROM
  affiche_spectacle t0
  LEFT JOIN spectacle t5 ON t5.affiche_spectacle_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.credits AS credits_3, t0.nom_fichier AS nom_fichier_4, t5.id AS id_6, t5.titre AS titre_7, t5.meta_title AS meta_title_8, t5.meta_description AS meta_description_9, t5.resume AS resume_10, t5.description AS description_11, t5.slug AS slug_12, t5.en_ligne AS en_ligne_13, t5.archive AS archive_14, t5.annee_creation AS annee_creation_15, t5.jauge AS jauge_16, t5.slogan AS slogan_17, t5.resume_technique AS resume_technique_18, t5.duree AS duree_19, t5.genre_spectacle AS genre_spectacle_20, t5.video AS video_21, t5.priorite AS priorite_22, t5.url AS url_23, t5.argument_pro AS argument_pro_24, t5.argument_en_avant AS argument_en_avant_25, t5.titre_section_principale AS titre_section_principale_26, t5.derniere_modif AS derniere_modif_27, t5.structure_principal_id AS structure_principal_id_28, t5.image_entete_id AS image_entete_id_29, t5.affiche_id AS affiche_id_30, t5.affiche_spectacle_id AS affiche_spectacle_id_31, t5.compagnie_id AS compagnie_id_32, t5.gallerie_id AS gallerie_id_33, t5.dossier_gallerie_id AS dossier_gallerie_id_34 FROM affiche_spectacle t0 LEFT JOIN spectacle t5 ON t5.affiche_spectacle_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.nom_fichier AS nom_fichier_3,
  t0.image_size AS image_size_4,
  t0.updated_at AS updated_at_5,
  t0.credits AS credits_6,
  t0.en_ligne AS en_ligne_7,
  t0.slug AS slug_8,
  t0.legende AS legende_9,
  t0.nom AS nom_10,
  t0.ordre AS ordre_11
FROM
  photo_spectacle t0
  INNER JOIN spectacle_photo_spectacle ON t0.id = spectacle_photo_spectacle.photo_spectacle_id
WHERE
  spectacle_photo_spectacle.spectacle_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.nom_fichier AS nom_fichier_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5, t0.credits AS credits_6, t0.en_ligne AS en_ligne_7, t0.slug AS slug_8, t0.legende AS legende_9, t0.nom AS nom_10, t0.ordre AS ordre_11 FROM photo_spectacle t0 INNER JOIN spectacle_photo_spectacle ON t0.id = spectacle_photo_spectacle.photo_spectacle_id WHERE spectacle_photo_spectacle.spectacle_id = 1 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.credits AS credits_3,
  t0.fichier AS fichier_4,
  t0.nom AS nom_5
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.credits AS credits_3, t0.fichier AS fichier_4, t0.nom AS nom_5 FROM image t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.ville AS ville_4,
  t0.code_postal AS code_postal_5,
  t0.url_site AS url_site_6,
  t0.telephone AS telephone_7,
  t0.salle_spectacle AS salle_spectacle_8
FROM
  lieu t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.ville AS ville_4, t0.code_postal AS code_postal_5, t0.url_site AS url_site_6, t0.telephone AS telephone_7, t0.salle_spectacle AS salle_spectacle_8 FROM lieu t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.url AS url_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.image_entete AS image_entete_6,
  t0.logo AS logo_7,
  t0.adresse AS adresse_8,
  t0.ville AS ville_9,
  t0.code_postal AS code_postal_10,
  t0.telephone AS telephone_11,
  t0.titre AS titre_12,
  t0.a_propos AS a_propos_13,
  t0.nom_contact_presse AS nom_contact_presse_14,
  t0.email_contact_presse AS email_contact_presse_15,
  t0.tel_contact_presse AS tel_contact_presse_16
FROM
  structure t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.url AS url_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.image_entete AS image_entete_6, t0.logo AS logo_7, t0.adresse AS adresse_8, t0.ville AS ville_9, t0.code_postal AS code_postal_10, t0.telephone AS telephone_11, t0.titre AS titre_12, t0.a_propos AS a_propos_13, t0.nom_contact_presse AS nom_contact_presse_14, t0.email_contact_presse AS email_contact_presse_15, t0.tel_contact_presse AS tel_contact_presse_16 FROM structure t0 WHERE t0.url = 'fight-impro.fr' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.description AS description_2,
  a0_.date_debut AS date_debut_3,
  a0_.date_fin AS date_fin_4,
  a0_.jour AS jour_5,
  a0_.duree AS duree_6,
  a0_.duree_seance AS duree_seance_7,
  a0_.tarif AS tarif_8,
  a0_.horaire AS horaire_9,
  a0_.type AS type_10,
  a0_.url_inscription AS url_inscription_11,
  a0_.slug AS slug_12,
  a0_.meta_description AS meta_description_13,
  a0_.meta_title AS meta_title_14,
  a0_.en_ligne AS en_ligne_15,
  a0_.titre_court AS titre_court_16,
  a0_.age_min AS age_min_17,
  a0_.age_max AS age_max_18,
  a0_.affiche_sur_accueil AS affiche_sur_accueil_19,
  a0_.image_entete AS image_entete_20,
  a0_.resume AS resume_21,
  a0_.structure_principale_id AS structure_principale_id_22,
  a0_.lieu_id AS lieu_id_23,
  a0_.organisateur_id AS organisateur_id_24
FROM
  atelier a0_
  LEFT JOIN atelier_structure a2_ ON a0_.id = a2_.atelier_id
  LEFT JOIN structure s1_ ON s1_.id = a2_.structure_id
WHERE
  a0_.affiche_sur_accueil = ?
  AND a0_.date_debut >= ?
  AND (
    a0_.structure_principale_id = ?
    OR s1_.id = ?
  )
ORDER BY
  a0_.date_debut ASC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.description AS description_2, a0_.date_debut AS date_debut_3, a0_.date_fin AS date_fin_4, a0_.jour AS jour_5, a0_.duree AS duree_6, a0_.duree_seance AS duree_seance_7, a0_.tarif AS tarif_8, a0_.horaire AS horaire_9, a0_.type AS type_10, a0_.url_inscription AS url_inscription_11, a0_.slug AS slug_12, a0_.meta_description AS meta_description_13, a0_.meta_title AS meta_title_14, a0_.en_ligne AS en_ligne_15, a0_.titre_court AS titre_court_16, a0_.age_min AS age_min_17, a0_.age_max AS age_max_18, a0_.affiche_sur_accueil AS affiche_sur_accueil_19, a0_.image_entete AS image_entete_20, a0_.resume AS resume_21, a0_.structure_principale_id AS structure_principale_id_22, a0_.lieu_id AS lieu_id_23, a0_.organisateur_id AS organisateur_id_24 FROM atelier a0_ LEFT JOIN atelier_structure a2_ ON a0_.id = a2_.atelier_id LEFT JOIN structure s1_ ON s1_.id = a2_.structure_id WHERE a0_.affiche_sur_accueil = 1 AND a0_.date_debut >= '2026-09-09 00:00:00' AND (a0_.structure_principale_id = 1 OR s1_.id = 1) ORDER BY a0_.date_debut ASC;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.description AS description_2,
  a0_.resume AS resume_3,
  a0_.meta_description AS meta_description_4,
  a0_.meta_title AS meta_title_5,
  a0_.corps AS corps_6,
  a0_.slug AS slug_7,
  a0_.date AS date_8,
  a0_.date_revision AS date_revision_9,
  a0_.en_avant AS en_avant_10,
  a0_.en_ligne AS en_ligne_11,
  a0_.image_article AS image_article_12,
  a0_.credit_image AS credit_image_13,
  a0_.lettre_diffusion AS lettre_diffusion_14,
  a0_.legende_image AS legende_image_15,
  a0_.source_fichier AS source_fichier_16,
  a0_.structure_principale_id AS structure_principale_id_17,
  a0_.rubrique_id AS rubrique_id_18,
  a0_.image_entete_id AS image_entete_id_19,
  a0_.photo_spectacle_id AS photo_spectacle_id_20,
  a0_.spectacle_id AS spectacle_id_21,
  a0_.gallerie_id AS gallerie_id_22,
  a0_.dossier_gallerie_id AS dossier_gallerie_id_23
FROM
  article a0_
  LEFT JOIN structure s1_ ON a0_.structure_principale_id = s1_.id
  LEFT JOIN article_structure a3_ ON a0_.id = a3_.article_id
  LEFT JOIN structure s2_ ON s2_.id = a3_.structure_id
WHERE
  a0_.en_ligne = 1
  AND a0_.en_avant = 1
  AND (
    s1_.url = ?
    OR s2_.url = ?
  )
ORDER BY
  a0_.date DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.description AS description_2, a0_.resume AS resume_3, a0_.meta_description AS meta_description_4, a0_.meta_title AS meta_title_5, a0_.corps AS corps_6, a0_.slug AS slug_7, a0_.date AS date_8, a0_.date_revision AS date_revision_9, a0_.en_avant AS en_avant_10, a0_.en_ligne AS en_ligne_11, a0_.image_article AS image_article_12, a0_.credit_image AS credit_image_13, a0_.lettre_diffusion AS lettre_diffusion_14, a0_.legende_image AS legende_image_15, a0_.source_fichier AS source_fichier_16, a0_.structure_principale_id AS structure_principale_id_17, a0_.rubrique_id AS rubrique_id_18, a0_.image_entete_id AS image_entete_id_19, a0_.photo_spectacle_id AS photo_spectacle_id_20, a0_.spectacle_id AS spectacle_id_21, a0_.gallerie_id AS gallerie_id_22, a0_.dossier_gallerie_id AS dossier_gallerie_id_23 FROM article a0_ LEFT JOIN structure s1_ ON a0_.structure_principale_id = s1_.id LEFT JOIN article_structure a3_ ON a0_.id = a3_.article_id LEFT JOIN structure s2_ ON s2_.id = a3_.structure_id WHERE a0_.en_ligne = 1 AND a0_.en_avant = 1 AND (s1_.url = 'fight-impro.fr' OR s2_.url = 'fight-impro.fr') ORDER BY a0_.date DESC LIMIT 3;