Symfony Profiler

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
  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
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.prix AS prix_3,
  t0.description AS description_4,
  t0.contenu AS contenu_5,
  t0.affiche AS affiche_6,
  t0.duree AS duree_7,
  t0.slug AS slug_8,
  t0.texttt AS texttt_9,
  t0.totalinscrit AS totalinscrit_10,
  t0.nblike AS nblike_11,
  t0.nbavis AS nbavis_12,
  t0.niveau AS niveau_13,
  t0.categorie AS categorie_14,
  t0.nbheure AS nbheure_15,
  t0.desccourt AS desccourt_16,
  t0.photofront AS photofront_17,
  t0.is_populaire AS is_populaire_18,
  t0.planification_id AS planification_id_19,
  t0.formateur_id AS formateur_id_20
FROM
  formation t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.prix AS prix_3, t0.description AS description_4, t0.contenu AS contenu_5, t0.affiche AS affiche_6, t0.duree AS duree_7, t0.slug AS slug_8, t0.texttt AS texttt_9, t0.totalinscrit AS totalinscrit_10, t0.nblike AS nblike_11, t0.nbavis AS nbavis_12, t0.niveau AS niveau_13, t0.categorie AS categorie_14, t0.nbheure AS nbheure_15, t0.desccourt AS desccourt_16, t0.photofront AS photofront_17, t0.is_populaire AS is_populaire_18, t0.planification_id AS planification_id_19, t0.formateur_id AS formateur_id_20 FROM formation t0;

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 = 60 AND l0_.is_actif = 1 AND (l0_.date_expiration >= '2026-08-22 15:41:37' OR l0_.date_expiration IS NULL) AND (c1_.statut = 'valide' OR c1_.statut IS NULL) GROUP BY l0_.id HAVING COUNT(c1_.id) > 0;

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 = 'devops-mai-2026-60.html' LIMIT 1;

SELECT
  *
FROM
  `formation`
LIMIT
  3;

SELECT *  FROM `formation` LIMIT 3;;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.prix AS prix_3,
  t0.option1 AS option1_4,
  t0.option2 AS option2_5,
  t0.option3 AS option3_6,
  t0.option4 AS option4_7,
  t0.option5 AS option5_8,
  t0.duree AS duree_9,
  t0.dateexp AS dateexp_10,
  t0.affiche AS affiche_11,
  t0.description AS description_12,
  t0.slug AS slug_13,
  t0.imagefront AS imagefront_14,
  t0.valeurreduction AS valeurreduction_15
FROM
  offres t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.prix AS prix_3, t0.option1 AS option1_4, t0.option2 AS option2_5, t0.option3 AS option3_6, t0.option4 AS option4_7, t0.option5 AS option5_8, t0.duree AS duree_9, t0.dateexp AS dateexp_10, t0.affiche AS affiche_11, t0.description AS description_12, t0.slug AS slug_13, t0.imagefront AS imagefront_14, t0.valeurreduction AS valeurreduction_15 FROM offres t0;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.titre AS titre_3,
  t0.description AS description_4,
  t0.lienboutou AS lienboutou_5,
  t0.date AS date_6
FROM
  banniere t0

SELECT t0.id AS id_1, t0.image AS image_2, t0.titre AS titre_3, t0.description AS description_4, t0.lienboutou AS lienboutou_5, t0.date AS date_6 FROM banniere t0;

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:41:37' 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:41:37' ORDER BY e0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.service AS service_2,
  t0.descservice AS descservice_3,
  t0.descteam AS descteam_4,
  t0.logo AS logo_5,
  t0.lienfb AS lienfb_6,
  t0.lieninsta AS lieninsta_7,
  t0.lienyoutube AS lienyoutube_8,
  t0.lienlikedin AS lienlikedin_9,
  t0.contact AS contact_10,
  t0.map AS map_11,
  t0.icon AS icon_12,
  t0.description1 AS description1_13,
  t0.description2 AS description2_14,
  t0.temoinage AS temoinage_15,
  t0.texttemoigbage AS texttemoigbage_16,
  t0.liengit AS liengit_17,
  t0.footer1 AS footer1_18,
  t0.footer2 AS footer2_19,
  t0.titrestat AS titrestat_20,
  t0.descstat AS descstat_21,
  t0.descsousstat AS descsousstat_22,
  t0.adresse AS adresse_23,
  t0.numero AS numero_24,
  t0.imageapropos AS imageapropos_25,
  t0.favicon AS favicon_26,
  t0.nbrformation AS nbrformation_27,
  t0.formateurs AS formateurs_28,
  t0.membres AS membres_29,
  t0.pays AS pays_30,
  t0.logofooter AS logofooter_31,
  t0.nbmessage AS nbmessage_32,
  t0.whatsapp AS whatsapp_33,
  t0.tva AS tva_34,
  t0.nbip AS nbip_35
FROM
  setting t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.service AS service_2, t0.descservice AS descservice_3, t0.descteam AS descteam_4, t0.logo AS logo_5, t0.lienfb AS lienfb_6, t0.lieninsta AS lieninsta_7, t0.lienyoutube AS lienyoutube_8, t0.lienlikedin AS lienlikedin_9, t0.contact AS contact_10, t0.map AS map_11, t0.icon AS icon_12, t0.description1 AS description1_13, t0.description2 AS description2_14, t0.temoinage AS temoinage_15, t0.texttemoigbage AS texttemoigbage_16, t0.liengit AS liengit_17, t0.footer1 AS footer1_18, t0.footer2 AS footer2_19, t0.titrestat AS titrestat_20, t0.descstat AS descstat_21, t0.descsousstat AS descsousstat_22, t0.adresse AS adresse_23, t0.numero AS numero_24, t0.imageapropos AS imageapropos_25, t0.favicon AS favicon_26, t0.nbrformation AS nbrformation_27, t0.formateurs AS formateurs_28, t0.membres AS membres_29, t0.pays AS pays_30, t0.logofooter AS logofooter_31, t0.nbmessage AS nbmessage_32, t0.whatsapp AS whatsapp_33, t0.tva AS tva_34, t0.nbip AS nbip_35 FROM setting t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.duree AS duree_3,
  t0.formation_id AS formation_id_4
FROM
  section t0
WHERE
  t0.formation_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.duree AS duree_3, t0.formation_id AS formation_id_4 FROM section t0 WHERE t0.formation_id = 24;

SELECT
  t0.id AS id_1,
  t0.howitworks AS howitworks_2,
  t0.description AS description_3,
  t0.numero AS numero_4,
  t0.nom AS nom_5,
  t0.paragraphe AS paragraphe_6,
  t0.image AS image_7
FROM
  service t0

SELECT t0.id AS id_1, t0.howitworks AS howitworks_2, t0.description AS description_3, t0.numero AS numero_4, t0.nom AS nom_5, t0.paragraphe AS paragraphe_6, t0.image AS image_7 FROM service t0;

SELECT
  *
FROM
  `video`
LIMIT
  4;

SELECT *  FROM `video` LIMIT 4;;

SELECT
  t0.id AS id_1,
  t0.etoile AS etoile_2,
  t0.commentaire AS commentaire_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.profession AS profession_6,
  t0.nom AS nom_7,
  t0.prenom AS prenom_8,
  t0.poste AS poste_9,
  t0.pays AS pays_10
FROM
  temoignage t0

SELECT t0.id AS id_1, t0.etoile AS etoile_2, t0.commentaire AS commentaire_3, t0.description AS description_4, t0.image AS image_5, t0.profession AS profession_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.poste AS poste_9, t0.pays AS pays_10 FROM temoignage t0;

SELECT
  t0.id AS id_1,
  t0.formation AS formation_2,
  t0.inscrit AS inscrit_3,
  t0.formateur AS formateur_4,
  t0.pays AS pays_5
FROM
  statistique t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.formation AS formation_2, t0.inscrit AS inscrit_3, t0.formateur AS formateur_4, t0.pays AS pays_5 FROM statistique t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.image1 AS image1_2,
  t0.date AS date_3,
  t0.description AS description_4,
  t0.titre AS titre_5
FROM
  gallery t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.image1 AS image1_2, t0.date AS date_3, t0.description AS description_4, t0.titre AS titre_5 FROM gallery t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nomprenom AS nomprenom_2,
  t0.proffesion AS proffesion_3,
  t0.image AS image_4
FROM
  team t0

SELECT t0.id AS id_1, t0.nomprenom AS nomprenom_2, t0.proffesion AS proffesion_3, t0.image AS image_4 FROM team t0;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.slug AS slug_3
FROM
  categorie_elearning t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3 FROM categorie_elearning t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3
FROM
  sponsors t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3 FROM sponsors t0;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.nom AS nom_3,
  t0.adresse AS adresse_4
FROM
  partners t0

SELECT t0.id AS id_1, t0.image AS image_2, t0.nom AS nom_3, t0.adresse AS adresse_4 FROM partners t0;