Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.date AS date_2,
  a0_.image AS image_3,
  a0_.imagedetails AS imagedetails_4,
  a0_.description AS description_5,
  a0_.desccourt AS desccourt_6,
  a0_.nbvue AS nbvue_7,
  a0_.nbcommentaire AS nbcommentaire_8,
  a0_.slug AS slug_9,
  a0_.type AS type_10
FROM
  actualite a0_
WHERE
  a0_.type IN (?, ?)
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.date AS date_2, a0_.image AS image_3, a0_.imagedetails AS imagedetails_4, a0_.description AS description_5, a0_.desccourt AS desccourt_6, a0_.nbvue AS nbvue_7, a0_.nbcommentaire AS nbcommentaire_8, a0_.slug AS slug_9, a0_.type AS type_10 FROM actualite a0_ WHERE a0_.type IN ('externe', 'mixte') ORDER BY a0_.id DESC;

SELECT
  e0_.id AS id_0,
  e0_.image AS image_1,
  e0_.titre AS titre_2,
  e0_.descriptionshort AS descriptionshort_3,
  e0_.description AS description_4,
  e0_.adresse AS adresse_5,
  e0_.starttime AS starttime_6,
  e0_.endtime AS endtime_7,
  e0_.date AS date_8,
  e0_.imgdetail AS imgdetail_9,
  e0_.mode AS mode_10,
  e0_.slug AS slug_11,
  e0_.liendrive AS liendrive_12,
  e0_.type AS type_13,
  e0_.prixpromo AS prixpromo_14,
  e0_.certeficatvierge AS certeficatvierge_15,
  e0_.is_archive AS is_archive_16,
  e0_.imgprog AS imgprog_17,
  e0_.liengithub AS liengithub_18,
  e0_.lienprog AS lienprog_19,
  e0_.discord AS discord_20,
  e0_.formation_id AS formation_id_21,
  e0_.formateur_id AS formateur_id_22
FROM
  evenement e0_
WHERE
  e0_.type = ?
  AND e0_.is_archive = ?
  AND e0_.endtime >= ?
ORDER BY
  e0_.id DESC

SELECT e0_.id AS id_0, e0_.image AS image_1, e0_.titre AS titre_2, e0_.descriptionshort AS descriptionshort_3, e0_.description AS description_4, e0_.adresse AS adresse_5, e0_.starttime AS starttime_6, e0_.endtime AS endtime_7, e0_.date AS date_8, e0_.imgdetail AS imgdetail_9, e0_.mode AS mode_10, e0_.slug AS slug_11, e0_.liendrive AS liendrive_12, e0_.type AS type_13, e0_.prixpromo AS prixpromo_14, e0_.certeficatvierge AS certeficatvierge_15, e0_.is_archive AS is_archive_16, e0_.imgprog AS imgprog_17, e0_.liengithub AS liengithub_18, e0_.lienprog AS lienprog_19, e0_.discord AS discord_20, e0_.formation_id AS formation_id_21, e0_.formateur_id AS formateur_id_22 FROM evenement e0_ WHERE e0_.type = 'Ordinaire' AND e0_.is_archive = 0 AND e0_.endtime >= '2026-08-22 15:48:21' ORDER BY e0_.id DESC;

SELECT
  e0_.id AS id_0,
  e0_.image AS image_1,
  e0_.titre AS titre_2,
  e0_.descriptionshort AS descriptionshort_3,
  e0_.description AS description_4,
  e0_.adresse AS adresse_5,
  e0_.starttime AS starttime_6,
  e0_.endtime AS endtime_7,
  e0_.date AS date_8,
  e0_.imgdetail AS imgdetail_9,
  e0_.mode AS mode_10,
  e0_.slug AS slug_11,
  e0_.liendrive AS liendrive_12,
  e0_.type AS type_13,
  e0_.prixpromo AS prixpromo_14,
  e0_.certeficatvierge AS certeficatvierge_15,
  e0_.is_archive AS is_archive_16,
  e0_.imgprog AS imgprog_17,
  e0_.liengithub AS liengithub_18,
  e0_.lienprog AS lienprog_19,
  e0_.discord AS discord_20,
  e0_.formation_id AS formation_id_21,
  e0_.formateur_id AS formateur_id_22
FROM
  evenement e0_
WHERE
  e0_.type = ?
  AND e0_.is_archive = ?
  AND e0_.endtime < ?
ORDER BY
  e0_.id DESC

SELECT e0_.id AS id_0, e0_.image AS image_1, e0_.titre AS titre_2, e0_.descriptionshort AS descriptionshort_3, e0_.description AS description_4, e0_.adresse AS adresse_5, e0_.starttime AS starttime_6, e0_.endtime AS endtime_7, e0_.date AS date_8, e0_.imgdetail AS imgdetail_9, e0_.mode AS mode_10, e0_.slug AS slug_11, e0_.liendrive AS liendrive_12, e0_.type AS type_13, e0_.prixpromo AS prixpromo_14, e0_.certeficatvierge AS certeficatvierge_15, e0_.is_archive AS is_archive_16, e0_.imgprog AS imgprog_17, e0_.liengithub AS liengithub_18, e0_.lienprog AS lienprog_19, e0_.discord AS discord_20, e0_.formation_id AS formation_id_21, e0_.formateur_id AS formateur_id_22 FROM evenement e0_ WHERE e0_.type = 'Ordinaire' AND e0_.is_archive = 0 AND e0_.endtime < '2026-08-22 15:48:21' ORDER BY e0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.titre AS titre_3,
  t0.descriptionshort AS descriptionshort_4,
  t0.description AS description_5,
  t0.adresse AS adresse_6,
  t0.starttime AS starttime_7,
  t0.endtime AS endtime_8,
  t0.date AS date_9,
  t0.imgdetail AS imgdetail_10,
  t0.mode AS mode_11,
  t0.slug AS slug_12,
  t0.liendrive AS liendrive_13,
  t0.type AS type_14,
  t0.prixpromo AS prixpromo_15,
  t0.certeficatvierge AS certeficatvierge_16,
  t0.is_archive AS is_archive_17,
  t0.imgprog AS imgprog_18,
  t0.liengithub AS liengithub_19,
  t0.lienprog AS lienprog_20,
  t0.discord AS discord_21,
  t0.formation_id AS formation_id_22,
  t0.formateur_id AS formateur_id_23
FROM
  evenement t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.image AS image_2, t0.titre AS titre_3, t0.descriptionshort AS descriptionshort_4, t0.description AS description_5, t0.adresse AS adresse_6, t0.starttime AS starttime_7, t0.endtime AS endtime_8, t0.date AS date_9, t0.imgdetail AS imgdetail_10, t0.mode AS mode_11, t0.slug AS slug_12, t0.liendrive AS liendrive_13, t0.type AS type_14, t0.prixpromo AS prixpromo_15, t0.certeficatvierge AS certeficatvierge_16, t0.is_archive AS is_archive_17, t0.imgprog AS imgprog_18, t0.liengithub AS liengithub_19, t0.lienprog AS lienprog_20, t0.discord AS discord_21, t0.formation_id AS formation_id_22, t0.formateur_id AS formateur_id_23 FROM evenement t0 WHERE t0.slug = 'index.html' LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.adresse AS adresse_4,
  u0_.phone AS phone_5,
  u0_.options AS options_6,
  u0_.logo AS logo_7,
  u0_.nom AS nom_8,
  u0_.prenom AS prenom_9,
  u0_.phone1 AS phone1_10,
  u0_.fb AS fb_11,
  u0_.linkedin AS linkedin_12,
  u0_.biographie AS biographie_13,
  u0_.cv AS cv_14,
  u0_.poste AS poste_15,
  u0_.pays AS pays_16,
  u0_.type AS type_17,
  u0_.responsable AS responsable_18,
  u0_.siteweb AS siteweb_19,
  u0_.github AS github_20,
  u0_.twitter AS twitter_21,
  u0_.vue AS vue_22,
  u0_.date AS date_23,
  u0_.vu AS vu_24,
  u0_.ipadress AS ipadress_25,
  u0_.is_active AS is_active_26,
  u0_.nomsociete AS nomsociete_27,
  u0_.adressesociete AS adressesociete_28,
  u0_.matricule AS matricule_29
FROM
  user u0_
WHERE
  u0_.roles LIKE ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.adresse AS adresse_4, u0_.phone AS phone_5, u0_.options AS options_6, u0_.logo AS logo_7, u0_.nom AS nom_8, u0_.prenom AS prenom_9, u0_.phone1 AS phone1_10, u0_.fb AS fb_11, u0_.linkedin AS linkedin_12, u0_.biographie AS biographie_13, u0_.cv AS cv_14, u0_.poste AS poste_15, u0_.pays AS pays_16, u0_.type AS type_17, u0_.responsable AS responsable_18, u0_.siteweb AS siteweb_19, u0_.github AS github_20, u0_.twitter AS twitter_21, u0_.vue AS vue_22, u0_.date AS date_23, u0_.vu AS vu_24, u0_.ipadress AS ipadress_25, u0_.is_active AS is_active_26, u0_.nomsociete AS nomsociete_27, u0_.adressesociete AS adressesociete_28, u0_.matricule AS matricule_29 FROM user u0_ WHERE u0_.roles LIKE '%\"ROLE_COACH\"%';

SELECT
  *
FROM
  `video`
LIMIT
  4;

SELECT *  FROM `video` LIMIT 4;;

SELECT
  *
FROM
  `formation`
LIMIT
  3;

SELECT *  FROM `formation` LIMIT 3;;

SELECT
  l0_.id AS id_0,
  l0_.libelle AS libelle_1,
  l0_.quantite_initiale AS quantite_initiale_2,
  l0_.seuil_alerte AS seuil_alerte_3,
  l0_.date_generation AS date_generation_4,
  l0_.date_expiration AS date_expiration_5,
  l0_.stock AS stock_6,
  l0_.pourcentage AS pourcentage_7,
  l0_.is_actif AS is_actif_8,
  l0_.evenement_id AS evenement_id_9
FROM
  lot_coupon l0_
  LEFT JOIN coupon c1_ ON l0_.id = c1_.lot_coupon_id
WHERE
  l0_.evenement_id = ?
  AND l0_.is_actif = 1
  AND (
    l0_.date_expiration >= ?
    OR l0_.date_expiration IS NULL
  )
  AND (
    c1_.statut = ?
    OR c1_.statut IS NULL
  )
GROUP BY
  l0_.id
HAVING
  COUNT(c1_.id) > 0

SELECT l0_.id AS id_0, l0_.libelle AS libelle_1, l0_.quantite_initiale AS quantite_initiale_2, l0_.seuil_alerte AS seuil_alerte_3, l0_.date_generation AS date_generation_4, l0_.date_expiration AS date_expiration_5, l0_.stock AS stock_6, l0_.pourcentage AS pourcentage_7, l0_.is_actif AS is_actif_8, l0_.evenement_id AS evenement_id_9 FROM lot_coupon l0_ LEFT JOIN coupon c1_ ON l0_.id = c1_.lot_coupon_id WHERE l0_.evenement_id = NULL AND l0_.is_actif = 1 AND (l0_.date_expiration >= '2026-08-22 15:48:21' OR l0_.date_expiration IS NULL) AND (c1_.statut = 'valide' OR c1_.statut IS NULL) GROUP BY l0_.id HAVING COUNT(c1_.id) > 0;