Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.token AS token_2
FROM
  bdd_api t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.token AS token_2 FROM bdd_api t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.lien AS lien_2,
  t0.name AS name_3,
  t0.nom AS nom_4,
  t0.numero AS numero_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.logo AS logo_8,
  t0.telephone AS telephone_9,
  t0.mail AS mail_10,
  t0.site_web AS site_web_11,
  t0.footer_text_x AS footer_text_x_12,
  t0.footer_text_second_x AS footer_text_second_x_13,
  t0.footer_text_y AS footer_text_y_14,
  t0.footer_text_second_y AS footer_text_second_y_15,
  t0.footer_text AS footer_text_16,
  t0.footer_text_second AS footer_text_second_17,
  t0.mail_envoi AS mail_envoi_18,
  t0.statut_actif AS statut_actif_19
FROM
  bdd_centres t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.name AS name_3, t0.nom AS nom_4, t0.numero AS numero_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.logo AS logo_8, t0.telephone AS telephone_9, t0.mail AS mail_10, t0.site_web AS site_web_11, t0.footer_text_x AS footer_text_x_12, t0.footer_text_second_x AS footer_text_second_x_13, t0.footer_text_y AS footer_text_y_14, t0.footer_text_second_y AS footer_text_second_y_15, t0.footer_text AS footer_text_16, t0.footer_text_second AS footer_text_second_17, t0.mail_envoi AS mail_envoi_18, t0.statut_actif AS statut_actif_19 FROM bdd_centres t0 WHERE t0.id = 1;

SELECT
  s0_.id AS id_0,
  s0_.numero AS numero_1,
  s0_.code AS code_2,
  s0_.etat AS etat_3,
  s0_.formation_id AS formation_id_4,
  s0_.type_id AS type_id_5,
  s0_.adresse_centre_id AS adresse_centre_id_6
FROM
  sessions s0_
  LEFT JOIN formations f1_ ON s0_.formation_id = f1_.id
  LEFT JOIN bdd_themes b2_ ON f1_.domaine_id = b2_.id
  LEFT JOIN session_dates s3_ ON s0_.id = s3_.session_id
WHERE
  s3_.premier_jour = ?
  AND s3_.date_start > ?
  AND f1_.domaine_id <> ?
  AND f1_.domaine_id <> ?
  AND f1_.domaine_id <> ?
  AND f1_.domaine_id <> ?
  AND s0_.type_id = ?
  AND s0_.adresse_centre_id IN (?, ?)
  AND s0_.etat = ?
GROUP BY
  s0_.id
ORDER BY
  s3_.date_start ASC

SELECT s0_.id AS id_0, s0_.numero AS numero_1, s0_.code AS code_2, s0_.etat AS etat_3, s0_.formation_id AS formation_id_4, s0_.type_id AS type_id_5, s0_.adresse_centre_id AS adresse_centre_id_6 FROM sessions s0_ LEFT JOIN formations f1_ ON s0_.formation_id = f1_.id LEFT JOIN bdd_themes b2_ ON f1_.domaine_id = b2_.id LEFT JOIN session_dates s3_ ON s0_.id = s3_.session_id WHERE s3_.premier_jour = 1 AND s3_.date_start > '2026-01-11 00:00:00' AND f1_.domaine_id <> 3 AND f1_.domaine_id <> 5 AND f1_.domaine_id <> 6 AND f1_.domaine_id <> 7 AND s0_.type_id = 1 AND s0_.adresse_centre_id IN (1, 14) AND s0_.etat = 1 GROUP BY s0_.id ORDER BY s3_.date_start ASC;

SELECT
  SUM(
    CASE WHEN s0_.statut_id = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN s0_.statut_id = 2 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1
FROM
  sessions s1_
  LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id
WHERE
  s1_.id = ?
  AND s1_.etat = ?
ORDER BY
  s1_.id DESC

SELECT SUM(CASE WHEN s0_.statut_id = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN s0_.statut_id = 2 THEN 1 ELSE 0 END) AS sclr_1 FROM sessions s1_ LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id WHERE s1_.id = 3268 AND s1_.etat = 1 ORDER BY s1_.id DESC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.capacite AS capacite_4,
  t0.nombre_jour AS nombre_jour_5,
  t0.nombre_heure AS nombre_heure_6,
  t0.statut AS statut_7,
  t0.domaine_id AS domaine_id_8
FROM
  formations t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.capacite AS capacite_4, t0.nombre_jour AS nombre_jour_5, t0.nombre_heure AS nombre_heure_6, t0.statut AS statut_7, t0.domaine_id AS domaine_id_8 FROM formations t0 WHERE t0.id = 2627;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.heure_debut AS heure_debut_3,
  t0.heure_debut_fin AS heure_debut_fin_4,
  t0.heure_fin AS heure_fin_5,
  t0.heure_fin_fin AS heure_fin_fin_6,
  t0.heure_am AS heure_am_7,
  t0.heure_pm AS heure_pm_8,
  t0.dernier_jour AS dernier_jour_9,
  t0.premier_jour AS premier_jour_10,
  t0.session_id AS session_id_11
FROM
  session_dates t0
WHERE
  t0.session_id = ?
ORDER BY
  t0.date_start ASC

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.heure_debut AS heure_debut_3, t0.heure_debut_fin AS heure_debut_fin_4, t0.heure_fin AS heure_fin_5, t0.heure_fin_fin AS heure_fin_fin_6, t0.heure_am AS heure_am_7, t0.heure_pm AS heure_pm_8, t0.dernier_jour AS dernier_jour_9, t0.premier_jour AS premier_jour_10, t0.session_id AS session_id_11 FROM session_dates t0 WHERE t0.session_id = 3268 ORDER BY t0.date_start ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.filename AS filename_4,
  t0.url AS url_5,
  t0.type AS type_6,
  t0.theme_id AS theme_id_7
FROM
  media_categorie_programme t0
  INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id
WHERE
  formations_media_categorie_programme.formations_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.filename AS filename_4, t0.url AS url_5, t0.type AS type_6, t0.theme_id AS theme_id_7 FROM media_categorie_programme t0 INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id WHERE formations_media_categorie_programme.formations_id = 2627;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.background AS background_4,
  t0.color_event AS color_event_5,
  t0.background_event AS background_event_6,
  t0.type_session AS type_session_7,
  t0.filename AS filename_8
FROM
  bdd_themes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.background AS background_4, t0.color_event AS color_event_5, t0.background_event AS background_event_6, t0.type_session AS type_session_7, t0.filename AS filename_8 FROM bdd_themes t0 WHERE t0.id = 10;

SELECT
  SUM(
    CASE WHEN s0_.statut_id = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN s0_.statut_id = 2 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1
FROM
  sessions s1_
  LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id
WHERE
  s1_.id = ?
  AND s1_.etat = ?
ORDER BY
  s1_.id DESC

SELECT SUM(CASE WHEN s0_.statut_id = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN s0_.statut_id = 2 THEN 1 ELSE 0 END) AS sclr_1 FROM sessions s1_ LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id WHERE s1_.id = 3649 AND s1_.etat = 1 ORDER BY s1_.id DESC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.capacite AS capacite_4,
  t0.nombre_jour AS nombre_jour_5,
  t0.nombre_heure AS nombre_heure_6,
  t0.statut AS statut_7,
  t0.domaine_id AS domaine_id_8
FROM
  formations t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.capacite AS capacite_4, t0.nombre_jour AS nombre_jour_5, t0.nombre_heure AS nombre_heure_6, t0.statut AS statut_7, t0.domaine_id AS domaine_id_8 FROM formations t0 WHERE t0.id = 1179;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.heure_debut AS heure_debut_3,
  t0.heure_debut_fin AS heure_debut_fin_4,
  t0.heure_fin AS heure_fin_5,
  t0.heure_fin_fin AS heure_fin_fin_6,
  t0.heure_am AS heure_am_7,
  t0.heure_pm AS heure_pm_8,
  t0.dernier_jour AS dernier_jour_9,
  t0.premier_jour AS premier_jour_10,
  t0.session_id AS session_id_11
FROM
  session_dates t0
WHERE
  t0.session_id = ?
ORDER BY
  t0.date_start ASC

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.heure_debut AS heure_debut_3, t0.heure_debut_fin AS heure_debut_fin_4, t0.heure_fin AS heure_fin_5, t0.heure_fin_fin AS heure_fin_fin_6, t0.heure_am AS heure_am_7, t0.heure_pm AS heure_pm_8, t0.dernier_jour AS dernier_jour_9, t0.premier_jour AS premier_jour_10, t0.session_id AS session_id_11 FROM session_dates t0 WHERE t0.session_id = 3649 ORDER BY t0.date_start ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.filename AS filename_4,
  t0.url AS url_5,
  t0.type AS type_6,
  t0.theme_id AS theme_id_7
FROM
  media_categorie_programme t0
  INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id
WHERE
  formations_media_categorie_programme.formations_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.filename AS filename_4, t0.url AS url_5, t0.type AS type_6, t0.theme_id AS theme_id_7 FROM media_categorie_programme t0 INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id WHERE formations_media_categorie_programme.formations_id = 1179;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.background AS background_4,
  t0.color_event AS color_event_5,
  t0.background_event AS background_event_6,
  t0.type_session AS type_session_7,
  t0.filename AS filename_8
FROM
  bdd_themes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.background AS background_4, t0.color_event AS color_event_5, t0.background_event AS background_event_6, t0.type_session AS type_session_7, t0.filename AS filename_8 FROM bdd_themes t0 WHERE t0.id = 8;

SELECT
  SUM(
    CASE WHEN s0_.statut_id = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN s0_.statut_id = 2 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1
FROM
  sessions s1_
  LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id
WHERE
  s1_.id = ?
  AND s1_.etat = ?
ORDER BY
  s1_.id DESC

SELECT SUM(CASE WHEN s0_.statut_id = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN s0_.statut_id = 2 THEN 1 ELSE 0 END) AS sclr_1 FROM sessions s1_ LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id WHERE s1_.id = 2768 AND s1_.etat = 1 ORDER BY s1_.id DESC;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.heure_debut AS heure_debut_3,
  t0.heure_debut_fin AS heure_debut_fin_4,
  t0.heure_fin AS heure_fin_5,
  t0.heure_fin_fin AS heure_fin_fin_6,
  t0.heure_am AS heure_am_7,
  t0.heure_pm AS heure_pm_8,
  t0.dernier_jour AS dernier_jour_9,
  t0.premier_jour AS premier_jour_10,
  t0.session_id AS session_id_11
FROM
  session_dates t0
WHERE
  t0.session_id = ?
ORDER BY
  t0.date_start ASC

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.heure_debut AS heure_debut_3, t0.heure_debut_fin AS heure_debut_fin_4, t0.heure_fin AS heure_fin_5, t0.heure_fin_fin AS heure_fin_fin_6, t0.heure_am AS heure_am_7, t0.heure_pm AS heure_pm_8, t0.dernier_jour AS dernier_jour_9, t0.premier_jour AS premier_jour_10, t0.session_id AS session_id_11 FROM session_dates t0 WHERE t0.session_id = 2768 ORDER BY t0.date_start ASC;

SELECT
  SUM(
    CASE WHEN s0_.statut_id = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN s0_.statut_id = 2 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1
FROM
  sessions s1_
  LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id
WHERE
  s1_.id = ?
  AND s1_.etat = ?
ORDER BY
  s1_.id DESC

SELECT SUM(CASE WHEN s0_.statut_id = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN s0_.statut_id = 2 THEN 1 ELSE 0 END) AS sclr_1 FROM sessions s1_ LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id WHERE s1_.id = 3570 AND s1_.etat = 1 ORDER BY s1_.id DESC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.capacite AS capacite_4,
  t0.nombre_jour AS nombre_jour_5,
  t0.nombre_heure AS nombre_heure_6,
  t0.statut AS statut_7,
  t0.domaine_id AS domaine_id_8
FROM
  formations t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.capacite AS capacite_4, t0.nombre_jour AS nombre_jour_5, t0.nombre_heure AS nombre_heure_6, t0.statut AS statut_7, t0.domaine_id AS domaine_id_8 FROM formations t0 WHERE t0.id = 1633;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.heure_debut AS heure_debut_3,
  t0.heure_debut_fin AS heure_debut_fin_4,
  t0.heure_fin AS heure_fin_5,
  t0.heure_fin_fin AS heure_fin_fin_6,
  t0.heure_am AS heure_am_7,
  t0.heure_pm AS heure_pm_8,
  t0.dernier_jour AS dernier_jour_9,
  t0.premier_jour AS premier_jour_10,
  t0.session_id AS session_id_11
FROM
  session_dates t0
WHERE
  t0.session_id = ?
ORDER BY
  t0.date_start ASC

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.heure_debut AS heure_debut_3, t0.heure_debut_fin AS heure_debut_fin_4, t0.heure_fin AS heure_fin_5, t0.heure_fin_fin AS heure_fin_fin_6, t0.heure_am AS heure_am_7, t0.heure_pm AS heure_pm_8, t0.dernier_jour AS dernier_jour_9, t0.premier_jour AS premier_jour_10, t0.session_id AS session_id_11 FROM session_dates t0 WHERE t0.session_id = 3570 ORDER BY t0.date_start ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.filename AS filename_4,
  t0.url AS url_5,
  t0.type AS type_6,
  t0.theme_id AS theme_id_7
FROM
  media_categorie_programme t0
  INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id
WHERE
  formations_media_categorie_programme.formations_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.filename AS filename_4, t0.url AS url_5, t0.type AS type_6, t0.theme_id AS theme_id_7 FROM media_categorie_programme t0 INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id WHERE formations_media_categorie_programme.formations_id = 1633;

SELECT
  SUM(
    CASE WHEN s0_.statut_id = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN s0_.statut_id = 2 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1
FROM
  sessions s1_
  LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id
WHERE
  s1_.id = ?
  AND s1_.etat = ?
ORDER BY
  s1_.id DESC

SELECT SUM(CASE WHEN s0_.statut_id = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN s0_.statut_id = 2 THEN 1 ELSE 0 END) AS sclr_1 FROM sessions s1_ LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id WHERE s1_.id = 3681 AND s1_.etat = 1 ORDER BY s1_.id DESC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.capacite AS capacite_4,
  t0.nombre_jour AS nombre_jour_5,
  t0.nombre_heure AS nombre_heure_6,
  t0.statut AS statut_7,
  t0.domaine_id AS domaine_id_8
FROM
  formations t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.capacite AS capacite_4, t0.nombre_jour AS nombre_jour_5, t0.nombre_heure AS nombre_heure_6, t0.statut AS statut_7, t0.domaine_id AS domaine_id_8 FROM formations t0 WHERE t0.id = 1181;

SELECT
  t0.id AS id_1,
  t0.date_start AS date_start_2,
  t0.heure_debut AS heure_debut_3,
  t0.heure_debut_fin AS heure_debut_fin_4,
  t0.heure_fin AS heure_fin_5,
  t0.heure_fin_fin AS heure_fin_fin_6,
  t0.heure_am AS heure_am_7,
  t0.heure_pm AS heure_pm_8,
  t0.dernier_jour AS dernier_jour_9,
  t0.premier_jour AS premier_jour_10,
  t0.session_id AS session_id_11
FROM
  session_dates t0
WHERE
  t0.session_id = ?
ORDER BY
  t0.date_start ASC

SELECT t0.id AS id_1, t0.date_start AS date_start_2, t0.heure_debut AS heure_debut_3, t0.heure_debut_fin AS heure_debut_fin_4, t0.heure_fin AS heure_fin_5, t0.heure_fin_fin AS heure_fin_fin_6, t0.heure_am AS heure_am_7, t0.heure_pm AS heure_pm_8, t0.dernier_jour AS dernier_jour_9, t0.premier_jour AS premier_jour_10, t0.session_id AS session_id_11 FROM session_dates t0 WHERE t0.session_id = 3681 ORDER BY t0.date_start ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.updated_at AS updated_at_3,
  t0.filename AS filename_4,
  t0.url AS url_5,
  t0.type AS type_6,
  t0.theme_id AS theme_id_7
FROM
  media_categorie_programme t0
  INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id
WHERE
  formations_media_categorie_programme.formations_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.filename AS filename_4, t0.url AS url_5, t0.type AS type_6, t0.theme_id AS theme_id_7 FROM media_categorie_programme t0 INNER JOIN formations_media_categorie_programme ON t0.id = formations_media_categorie_programme.media_categorie_programme_id WHERE formations_media_categorie_programme.formations_id = 1181;

SELECT
  SUM(
    CASE WHEN s0_.statut_id = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN s0_.statut_id = 2 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1
FROM
  sessions s1_
  LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id
WHERE
  s1_.id = ?
  AND s1_.etat = ?
ORDER BY
  s1_.id DESC

SELECT SUM(CASE WHEN s0_.statut_id = 1 THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN s0_.statut_id = 2 THEN 1 ELSE 0 END) AS sclr_1 FROM sessions s1_ LEFT JOIN session_stagiaire s0_ ON s1_.id = s0_.session_id WHERE s1_.id = 2846 AND s1_.etat = 1 ORDER BY s1_.id DESC;