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-06-02 18:26:50' ORDER BY e0_.id DESC;

SELECT
  *
FROM
  `video`
ORDER BY
  id DESC
LIMIT
  4

SELECT * FROM `video` ORDER BY id DESC LIMIT 4;

SELECT
  *
FROM
  `formation`
LIMIT
  3;

SELECT *  FROM `formation` LIMIT 3;;

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
  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
  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.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.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.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.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.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;

SELECT
  f0_.id AS id_0,
  f0_.titre AS titre_1,
  f0_.prix AS prix_2,
  f0_.description AS description_3,
  f0_.contenu AS contenu_4,
  f0_.affiche AS affiche_5,
  f0_.duree AS duree_6,
  f0_.slug AS slug_7,
  f0_.texttt AS texttt_8,
  f0_.totalinscrit AS totalinscrit_9,
  f0_.nblike AS nblike_10,
  f0_.nbavis AS nbavis_11,
  f0_.niveau AS niveau_12,
  f0_.categorie AS categorie_13,
  f0_.nbheure AS nbheure_14,
  f0_.desccourt AS desccourt_15,
  f0_.photofront AS photofront_16,
  f0_.is_populaire AS is_populaire_17,
  f0_.planification_id AS planification_id_18,
  f0_.formateur_id AS formateur_id_19
FROM
  formation f0_
WHERE
  f0_.is_populaire = ?
ORDER BY
  f0_.id DESC
LIMIT
  3

SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.prix AS prix_2, f0_.description AS description_3, f0_.contenu AS contenu_4, f0_.affiche AS affiche_5, f0_.duree AS duree_6, f0_.slug AS slug_7, f0_.texttt AS texttt_8, f0_.totalinscrit AS totalinscrit_9, f0_.nblike AS nblike_10, f0_.nbavis AS nbavis_11, f0_.niveau AS niveau_12, f0_.categorie AS categorie_13, f0_.nbheure AS nbheure_14, f0_.desccourt AS desccourt_15, f0_.photofront AS photofront_16, f0_.is_populaire AS is_populaire_17, f0_.planification_id AS planification_id_18, f0_.formateur_id AS formateur_id_19 FROM formation f0_ WHERE f0_.is_populaire = 1 ORDER BY f0_.id DESC 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
  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
  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.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
  INNER JOIN offres_formation ON t0.id = offres_formation.formation_id
WHERE
  offres_formation.offres_id = ?

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 INNER JOIN offres_formation ON t0.id = offres_formation.formation_id WHERE offres_formation.offres_id = 1;

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
  INNER JOIN offres_formation ON t0.id = offres_formation.formation_id
WHERE
  offres_formation.offres_id = ?

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 INNER JOIN offres_formation ON t0.id = offres_formation.formation_id WHERE offres_formation.offres_id = 2;

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
  INNER JOIN offres_formation ON t0.id = offres_formation.formation_id
WHERE
  offres_formation.offres_id = ?

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 INNER JOIN offres_formation ON t0.id = offres_formation.formation_id WHERE offres_formation.offres_id = 3;