Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.prenom AS prenom_1,
  e0_.nom AS nom_2,
  e0_.bio AS bio_3,
  e0_.affiche AS affiche_4,
  e0_.url AS url_5,
  e0_.linkedin AS linkedin_6,
  e0_.photo_portrait AS photo_portrait_7,
  e0_.credit_photo AS credit_photo_8,
  e0_.archive AS archive_9,
  e0_.membre AS membre_10,
  e0_.facebook AS facebook_11,
  e0_.instagram AS instagram_12,
  e0_.lien_bio AS lien_bio_13
FROM
  equipe e0_
  LEFT JOIN equipe_structure e2_ ON e0_.id = e2_.equipe_id
  LEFT JOIN structure s1_ ON s1_.id = e2_.structure_id
WHERE
  e0_.affiche = 1
  AND e0_.membre = ?
  AND e0_.archive = ?
  AND s1_.url = ?
ORDER BY
  e0_.nom ASC

SELECT e0_.id AS id_0, e0_.prenom AS prenom_1, e0_.nom AS nom_2, e0_.bio AS bio_3, e0_.affiche AS affiche_4, e0_.url AS url_5, e0_.linkedin AS linkedin_6, e0_.photo_portrait AS photo_portrait_7, e0_.credit_photo AS credit_photo_8, e0_.archive AS archive_9, e0_.membre AS membre_10, e0_.facebook AS facebook_11, e0_.instagram AS instagram_12, e0_.lien_bio AS lien_bio_13 FROM equipe e0_ LEFT JOIN equipe_structure e2_ ON e0_.id = e2_.equipe_id LEFT JOIN structure s1_ ON s1_.id = e2_.structure_id WHERE e0_.affiche = 1 AND e0_.membre = 1 AND e0_.archive = 0 AND s1_.url = 'fight-impro.fr' ORDER BY e0_.nom ASC;

SELECT
  e0_.id AS id_0,
  e0_.prenom AS prenom_1,
  e0_.nom AS nom_2,
  e0_.bio AS bio_3,
  e0_.affiche AS affiche_4,
  e0_.url AS url_5,
  e0_.linkedin AS linkedin_6,
  e0_.photo_portrait AS photo_portrait_7,
  e0_.credit_photo AS credit_photo_8,
  e0_.archive AS archive_9,
  e0_.membre AS membre_10,
  e0_.facebook AS facebook_11,
  e0_.instagram AS instagram_12,
  e0_.lien_bio AS lien_bio_13
FROM
  equipe e0_
  LEFT JOIN equipe_structure e2_ ON e0_.id = e2_.equipe_id
  LEFT JOIN structure s1_ ON s1_.id = e2_.structure_id
WHERE
  e0_.affiche = 1
  AND e0_.membre = ?
  AND e0_.archive = ?
  AND s1_.url = ?
ORDER BY
  e0_.nom ASC

SELECT e0_.id AS id_0, e0_.prenom AS prenom_1, e0_.nom AS nom_2, e0_.bio AS bio_3, e0_.affiche AS affiche_4, e0_.url AS url_5, e0_.linkedin AS linkedin_6, e0_.photo_portrait AS photo_portrait_7, e0_.credit_photo AS credit_photo_8, e0_.archive AS archive_9, e0_.membre AS membre_10, e0_.facebook AS facebook_11, e0_.instagram AS instagram_12, e0_.lien_bio AS lien_bio_13 FROM equipe e0_ LEFT JOIN equipe_structure e2_ ON e0_.id = e2_.equipe_id LEFT JOIN structure s1_ ON s1_.id = e2_.structure_id WHERE e0_.affiche = 1 AND e0_.membre = 0 AND e0_.archive = 0 AND s1_.url = 'fight-impro.fr' ORDER BY e0_.nom ASC;

SELECT
  e0_.id AS id_0,
  e0_.prenom AS prenom_1,
  e0_.nom AS nom_2,
  e0_.bio AS bio_3,
  e0_.affiche AS affiche_4,
  e0_.url AS url_5,
  e0_.linkedin AS linkedin_6,
  e0_.photo_portrait AS photo_portrait_7,
  e0_.credit_photo AS credit_photo_8,
  e0_.archive AS archive_9,
  e0_.membre AS membre_10,
  e0_.facebook AS facebook_11,
  e0_.instagram AS instagram_12,
  e0_.lien_bio AS lien_bio_13
FROM
  equipe e0_
  LEFT JOIN equipe_structure e2_ ON e0_.id = e2_.equipe_id
  LEFT JOIN structure s1_ ON s1_.id = e2_.structure_id
WHERE
  e0_.affiche = 1
  AND e0_.membre = ?
  AND e0_.archive = ?
  AND s1_.url = ?
ORDER BY
  e0_.nom ASC

SELECT e0_.id AS id_0, e0_.prenom AS prenom_1, e0_.nom AS nom_2, e0_.bio AS bio_3, e0_.affiche AS affiche_4, e0_.url AS url_5, e0_.linkedin AS linkedin_6, e0_.photo_portrait AS photo_portrait_7, e0_.credit_photo AS credit_photo_8, e0_.archive AS archive_9, e0_.membre AS membre_10, e0_.facebook AS facebook_11, e0_.instagram AS instagram_12, e0_.lien_bio AS lien_bio_13 FROM equipe e0_ LEFT JOIN equipe_structure e2_ ON e0_.id = e2_.equipe_id LEFT JOIN structure s1_ ON s1_.id = e2_.structure_id WHERE e0_.affiche = 1 AND e0_.membre = 0 AND e0_.archive = 1 AND s1_.url = 'fight-impro.fr' ORDER BY e0_.nom ASC;

SELECT
  e0_.prenom AS prenom_0,
  e0_.nom AS nom_1,
  e0_.id AS id_2,
  e0_.photo_portrait AS photo_portrait_3
FROM
  agenda a1_
  LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id
  LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id
  LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id
WHERE
  a1_.spectacle_id = 1
  AND (
    a1_.date_debut BETWEEN ?
    AND ?
  )
GROUP BY
  e0_.prenom

SELECT e0_.prenom AS prenom_0, e0_.nom AS nom_1, e0_.id AS id_2, e0_.photo_portrait AS photo_portrait_3 FROM agenda a1_ LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id WHERE a1_.spectacle_id = 1 AND (a1_.date_debut BETWEEN '2026-08-01 00:00:00' AND '2027-08-01 00:00:00') GROUP BY e0_.prenom;

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
  e0_.prenom AS prenom_0,
  e0_.nom AS nom_1,
  e0_.id AS id_2,
  e0_.photo_portrait AS photo_portrait_3
FROM
  agenda a1_
  LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id
  LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id
  LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id
WHERE
  a1_.spectacle_id = 1
  AND (
    a1_.date_debut BETWEEN ?
    AND ?
  )
GROUP BY
  e0_.prenom

SELECT e0_.prenom AS prenom_0, e0_.nom AS nom_1, e0_.id AS id_2, e0_.photo_portrait AS photo_portrait_3 FROM agenda a1_ LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id WHERE a1_.spectacle_id = 1 AND (a1_.date_debut BETWEEN '2025-08-01 00:00:00' AND '2026-08-01 00:00:00') GROUP BY e0_.prenom;

SELECT
  e0_.prenom AS prenom_0,
  e0_.nom AS nom_1,
  e0_.id AS id_2,
  e0_.photo_portrait AS photo_portrait_3
FROM
  agenda a1_
  LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id
  LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id
  LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id
WHERE
  a1_.spectacle_id = 1
  AND (
    a1_.date_debut BETWEEN ?
    AND ?
  )
GROUP BY
  e0_.prenom

SELECT e0_.prenom AS prenom_0, e0_.nom AS nom_1, e0_.id AS id_2, e0_.photo_portrait AS photo_portrait_3 FROM agenda a1_ LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id WHERE a1_.spectacle_id = 1 AND (a1_.date_debut BETWEEN '2024-08-01 00:00:00' AND '2025-08-01 00:00:00') GROUP BY e0_.prenom;

SELECT
  e0_.prenom AS prenom_0,
  e0_.nom AS nom_1,
  e0_.id AS id_2,
  e0_.photo_portrait AS photo_portrait_3
FROM
  agenda a1_
  LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id
  LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id
  LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id
WHERE
  a1_.spectacle_id = 1
  AND (
    a1_.date_debut BETWEEN ?
    AND ?
  )
GROUP BY
  e0_.prenom

SELECT e0_.prenom AS prenom_0, e0_.nom AS nom_1, e0_.id AS id_2, e0_.photo_portrait AS photo_portrait_3 FROM agenda a1_ LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id WHERE a1_.spectacle_id = 1 AND (a1_.date_debut BETWEEN '2023-08-01 00:00:00' AND '2024-08-01 00:00:00') GROUP BY e0_.prenom;

SELECT
  e0_.prenom AS prenom_0,
  e0_.nom AS nom_1,
  e0_.id AS id_2,
  e0_.photo_portrait AS photo_portrait_3
FROM
  agenda a1_
  LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id
  LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id
  LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id
WHERE
  a1_.spectacle_id = 1
  AND (
    a1_.date_debut BETWEEN ?
    AND ?
  )
GROUP BY
  e0_.prenom

SELECT e0_.prenom AS prenom_0, e0_.nom AS nom_1, e0_.id AS id_2, e0_.photo_portrait AS photo_portrait_3 FROM agenda a1_ LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id WHERE a1_.spectacle_id = 1 AND (a1_.date_debut BETWEEN '2022-08-01 00:00:00' AND '2023-08-01 00:00:00') GROUP BY e0_.prenom;

SELECT
  e0_.prenom AS prenom_0,
  e0_.nom AS nom_1,
  e0_.id AS id_2,
  e0_.photo_portrait AS photo_portrait_3
FROM
  agenda a1_
  LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id
  LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id
  LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id
WHERE
  a1_.spectacle_id = 1
  AND (
    a1_.date_debut BETWEEN ?
    AND ?
  )
GROUP BY
  e0_.prenom

SELECT e0_.prenom AS prenom_0, e0_.nom AS nom_1, e0_.id AS id_2, e0_.photo_portrait AS photo_portrait_3 FROM agenda a1_ LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id WHERE a1_.spectacle_id = 1 AND (a1_.date_debut BETWEEN '2021-08-01 00:00:00' AND '2022-08-01 00:00:00') GROUP BY e0_.prenom;

SELECT
  e0_.prenom AS prenom_0,
  e0_.nom AS nom_1,
  e0_.id AS id_2,
  e0_.photo_portrait AS photo_portrait_3
FROM
  agenda a1_
  LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id
  LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id
  LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id
WHERE
  a1_.spectacle_id = 1
  AND (
    a1_.date_debut BETWEEN ?
    AND ?
  )
GROUP BY
  e0_.prenom

SELECT e0_.prenom AS prenom_0, e0_.nom AS nom_1, e0_.id AS id_2, e0_.photo_portrait AS photo_portrait_3 FROM agenda a1_ LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id WHERE a1_.spectacle_id = 1 AND (a1_.date_debut BETWEEN '2020-08-01 00:00:00' AND '2021-08-01 00:00:00') GROUP BY e0_.prenom;

SELECT
  e0_.prenom AS prenom_0,
  e0_.nom AS nom_1,
  e0_.id AS id_2,
  e0_.photo_portrait AS photo_portrait_3
FROM
  agenda a1_
  LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id
  LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id
  LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id
WHERE
  a1_.spectacle_id = 1
  AND (
    a1_.date_debut BETWEEN ?
    AND ?
  )
GROUP BY
  e0_.prenom

SELECT e0_.prenom AS prenom_0, e0_.nom AS nom_1, e0_.id AS id_2, e0_.photo_portrait AS photo_portrait_3 FROM agenda a1_ LEFT JOIN distribution_agenda d3_ ON a1_.id = d3_.agenda_id LEFT JOIN distribution d2_ ON d2_.id = d3_.distribution_id LEFT JOIN equipe e0_ ON d2_.personne_id = e0_.id WHERE a1_.spectacle_id = 1 AND (a1_.date_debut BETWEEN '2019-08-01 00:00:00' AND '2020-08-01 00:00:00') GROUP BY e0_.prenom;