Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.beneficiaire AS beneficiaire_2,
  t0.date AS date_3,
  t0.video AS video_4,
  t0.url AS url_5,
  t0.video_type AS video_type_6,
  t0.type AS type_7,
  t0.description AS description_8,
  t0.image AS image_9
FROM
  temoignage t0

SELECT t0.id AS id_1, t0.beneficiaire AS beneficiaire_2, t0.date AS date_3, t0.video AS video_4, t0.url AS url_5, t0.video_type AS video_type_6, t0.type AS type_7, t0.description AS description_8, t0.image AS image_9 FROM temoignage t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.description AS description_4
FROM
  slider t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.description AS description_4 FROM slider t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3
FROM
  about t0
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM about t0 ORDER BY t0.id DESC LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.prix AS prix_2,
  a0_.quantite AS quantite_3,
  a0_.description AS description_4,
  a0_.image AS image_5,
  a0_.extrait AS extrait_6
FROM
  article a0_
ORDER BY
  a0_.id DESC
LIMIT
  5

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.prix AS prix_2, a0_.quantite AS quantite_3, a0_.description AS description_4, a0_.image AS image_5, a0_.extrait AS extrait_6 FROM article a0_ ORDER BY a0_.id DESC LIMIT 5;

SELECT
  t0.id AS id_5,
  t0.axe AS axe_6,
  t0.description AS description_7,
  t0.type
FROM
  service t0
  LEFT JOIN intervention_entreprise_service t1 ON t0.id = t1.id
  LEFT JOIN formations_service t2 ON t0.id = t2.id
  LEFT JOIN programme_formation_service t3 ON t0.id = t3.id
  LEFT JOIN other_service t4 ON t0.id = t4.id
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_5, t0.axe AS axe_6, t0.description AS description_7, t0.type FROM service t0 LEFT JOIN intervention_entreprise_service t1 ON t0.id = t1.id LEFT JOIN formations_service t2 ON t0.id = t2.id LEFT JOIN programme_formation_service t3 ON t0.id = t3.id LEFT JOIN other_service t4 ON t0.id = t4.id ORDER BY t0.id DESC LIMIT 1;

SELECT
  t1.id AS id_2,
  t1.axe AS axe_3,
  t1.description AS description_4,
  t1.type
FROM
  intervention_entreprise_service t0
  INNER JOIN service t1 ON t0.id = t1.id
ORDER BY
  t1.id DESC
LIMIT
  1

SELECT t1.id AS id_2, t1.axe AS axe_3, t1.description AS description_4, t1.type FROM intervention_entreprise_service t0 INNER JOIN service t1 ON t0.id = t1.id ORDER BY t1.id DESC LIMIT 1;

SELECT
  t1.id AS id_2,
  t1.axe AS axe_3,
  t1.description AS description_4,
  t1.type
FROM
  formations_service t0
  INNER JOIN service t1 ON t0.id = t1.id
ORDER BY
  t1.id DESC
LIMIT
  1

SELECT t1.id AS id_2, t1.axe AS axe_3, t1.description AS description_4, t1.type FROM formations_service t0 INNER JOIN service t1 ON t0.id = t1.id ORDER BY t1.id DESC LIMIT 1;

SELECT
  t1.id AS id_2,
  t1.axe AS axe_3,
  t1.description AS description_4,
  t1.type
FROM
  programme_formation_service t0
  INNER JOIN service t1 ON t0.id = t1.id
ORDER BY
  t1.id DESC
LIMIT
  1

SELECT t1.id AS id_2, t1.axe AS axe_3, t1.description AS description_4, t1.type FROM programme_formation_service t0 INNER JOIN service t1 ON t0.id = t1.id ORDER BY t1.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.diplome AS diplome_3,
  t0.poste AS poste_4,
  t0.experience AS experience_5,
  t0.regional AS regional_6,
  t0.unite AS unite_7,
  t0.image AS image_8
FROM
  equipe t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.diplome AS diplome_3, t0.poste AS poste_4, t0.experience AS experience_5, t0.regional AS regional_6, t0.unite AS unite_7, t0.image AS image_8 FROM equipe t0;

SELECT
  r0_.id AS id_0,
  r0_.categorie AS categorie_1,
  r0_.titre AS titre_2,
  r0_.auteur AS auteur_3,
  r0_.description AS description_4,
  r0_.is_public AS is_public_5,
  r0_.date_debut AS date_debut_6,
  r0_.date_expiration AS date_expiration_7,
  r0_.image AS image_8,
  r0_.ressource AS ressource_9,
  r0_.status AS status_10,
  r0_.user_id AS user_id_11
FROM
  ressources r0_
WHERE
  r0_.is_public = 1
  AND (
    r0_.date_expiration > ?
    OR r0_.date_expiration IS NULL
  )
ORDER BY
  r0_.id DESC
LIMIT
  3

SELECT r0_.id AS id_0, r0_.categorie AS categorie_1, r0_.titre AS titre_2, r0_.auteur AS auteur_3, r0_.description AS description_4, r0_.is_public AS is_public_5, r0_.date_debut AS date_debut_6, r0_.date_expiration AS date_expiration_7, r0_.image AS image_8, r0_.ressource AS ressource_9, r0_.status AS status_10, r0_.user_id AS user_id_11 FROM ressources r0_ WHERE r0_.is_public = 1 AND (r0_.date_expiration > '2026-03-12 10:37:53' OR r0_.date_expiration IS NULL) ORDER BY r0_.id DESC LIMIT 3;

SELECT
  t0.id AS id_8,
  t0.email AS email_9,
  t0.username AS username_10,
  t0.password AS password_11,
  t0.roles AS roles_12,
  t0.is_verified AS is_verified_13,
  t0.token_reset AS token_reset_14,
  t0.is_deleted AS is_deleted_15,
  t0.type,
  t1.nom AS nom_16,
  t1.prenom AS prenom_17,
  t1.tel AS tel_18,
  t1.fonction AS fonction_19,
  t1.autre AS autre_20,
  t1.fonctions AS fonctions_21,
  t1.gouvernorat_id AS gouvernorat_id_22,
  t2.type_partenaire AS type_partenaire_23,
  t2.nombre_entreprise AS nombre_entreprise_24,
  t2.cnsscnrps AS cnsscnrps_25,
  t2.code_cnss AS code_cnss_26,
  t2.secteur AS secteur_27,
  t2.branche AS branche_28,
  t2.fax AS fax_29,
  t2.tel AS tel_30,
  t2.nom_prenom_president AS nom_prenom_president_31,
  t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32,
  t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33,
  t2.nom AS nom_34,
  t2.file_name AS file_name_35,
  t2.original_file_name AS original_file_name_36,
  t2.gouvernorat_id AS gouvernorat_id_37,
  t2.delegation_id AS delegation_id_38,
  t3.matricule_fiscal AS matricule_fiscal_39,
  t3.nom_commercial AS nom_commercial_40,
  t3.fax AS fax_41,
  t3.code_cnss AS code_cnss_42,
  t3.cnsscnrps AS cnsscnrps_43,
  t3.secteur AS secteur_44,
  t3.branche AS branche_45,
  t3.produits_services_rendus AS produits_services_rendus_46,
  t3.statut AS statut_47,
  t3.exportatrice AS exportatrice_48,
  t3.off_shore AS off_shore_49,
  t3.taux_tfp AS taux_tfp_50,
  t3.regime_travail AS regime_travail_51,
  t3.tel AS tel_52,
  t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53,
  t3.raison_sociale AS raison_sociale_54,
  t3.montant AS montant_55,
  t3.adresse_siege_social AS adresse_siege_social_56,
  t3.adresse_site_production AS adresse_site_production_57,
  t3.gouvernorat_id AS gouvernorat_id_58,
  t3.delegation_id AS delegation_id_59,
  t4.tel AS tel_60,
  t4.nom AS nom_61,
  t4.prenom AS prenom_62,
  t4.ministere AS ministere_63,
  t4.direction AS direction_64,
  t4.gouvernorat_id AS gouvernorat_id_65,
  t5.nom AS nom_66,
  t5.prenom AS prenom_67,
  t5.tel AS tel_68,
  t5.unite_regional_id AS unite_regional_id_69,
  t6.nom AS nom_70,
  t6.prenom AS prenom_71,
  t6.tel AS tel_72,
  t6.nom_administration AS nom_administration_73,
  t6.regional AS regional_74,
  t6.unite AS unite_75,
  t6.fonction AS fonction_76,
  t7.nom AS nom_77,
  t7.prenom AS prenom_78,
  t7.tel AS tel_79,
  t7.gouvernorat_id AS gouvernorat_id_80
FROM
  user t0
  LEFT JOIN particulier t1 ON t0.id = t1.id
  LEFT JOIN partenaire t2 ON t0.id = t2.id
  LEFT JOIN entreprise t3 ON t0.id = t3.id
  LEFT JOIN dae t4 ON t0.id = t4.id
  LEFT JOIN charge_assistance t5 ON t0.id = t5.id
  LEFT JOIN agent_interne t6 ON t0.id = t6.id
  LEFT JOIN autres t7 ON t0.id = t7.id
WHERE
  t0.id = ?

SELECT t0.id AS id_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.roles AS roles_12, t0.is_verified AS is_verified_13, t0.token_reset AS token_reset_14, t0.is_deleted AS is_deleted_15, t0.type, t1.nom AS nom_16, t1.prenom AS prenom_17, t1.tel AS tel_18, t1.fonction AS fonction_19, t1.autre AS autre_20, t1.fonctions AS fonctions_21, t1.gouvernorat_id AS gouvernorat_id_22, t2.type_partenaire AS type_partenaire_23, t2.nombre_entreprise AS nombre_entreprise_24, t2.cnsscnrps AS cnsscnrps_25, t2.code_cnss AS code_cnss_26, t2.secteur AS secteur_27, t2.branche AS branche_28, t2.fax AS fax_29, t2.tel AS tel_30, t2.nom_prenom_president AS nom_prenom_president_31, t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32, t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33, t2.nom AS nom_34, t2.file_name AS file_name_35, t2.original_file_name AS original_file_name_36, t2.gouvernorat_id AS gouvernorat_id_37, t2.delegation_id AS delegation_id_38, t3.matricule_fiscal AS matricule_fiscal_39, t3.nom_commercial AS nom_commercial_40, t3.fax AS fax_41, t3.code_cnss AS code_cnss_42, t3.cnsscnrps AS cnsscnrps_43, t3.secteur AS secteur_44, t3.branche AS branche_45, t3.produits_services_rendus AS produits_services_rendus_46, t3.statut AS statut_47, t3.exportatrice AS exportatrice_48, t3.off_shore AS off_shore_49, t3.taux_tfp AS taux_tfp_50, t3.regime_travail AS regime_travail_51, t3.tel AS tel_52, t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53, t3.raison_sociale AS raison_sociale_54, t3.montant AS montant_55, t3.adresse_siege_social AS adresse_siege_social_56, t3.adresse_site_production AS adresse_site_production_57, t3.gouvernorat_id AS gouvernorat_id_58, t3.delegation_id AS delegation_id_59, t4.tel AS tel_60, t4.nom AS nom_61, t4.prenom AS prenom_62, t4.ministere AS ministere_63, t4.direction AS direction_64, t4.gouvernorat_id AS gouvernorat_id_65, t5.nom AS nom_66, t5.prenom AS prenom_67, t5.tel AS tel_68, t5.unite_regional_id AS unite_regional_id_69, t6.nom AS nom_70, t6.prenom AS prenom_71, t6.tel AS tel_72, t6.nom_administration AS nom_administration_73, t6.regional AS regional_74, t6.unite AS unite_75, t6.fonction AS fonction_76, t7.nom AS nom_77, t7.prenom AS prenom_78, t7.tel AS tel_79, t7.gouvernorat_id AS gouvernorat_id_80 FROM user t0 LEFT JOIN particulier t1 ON t0.id = t1.id LEFT JOIN partenaire t2 ON t0.id = t2.id LEFT JOIN entreprise t3 ON t0.id = t3.id LEFT JOIN dae t4 ON t0.id = t4.id LEFT JOIN charge_assistance t5 ON t0.id = t5.id LEFT JOIN agent_interne t6 ON t0.id = t6.id LEFT JOIN autres t7 ON t0.id = t7.id WHERE t0.id = 18;

SELECT
  s0_.id AS id_0,
  s0_.numsession AS numsession_1,
  s0_.titre AS titre_2,
  s0_.date_debut AS date_debut_3,
  s0_.date_fin AS date_fin_4,
  s0_.formateur AS formateur_5,
  s0_.adresse AS adresse_6,
  s0_.photo AS photo_7,
  s0_.document_prog AS document_prog_8,
  s0_.description AS description_9
FROM
  sessionsformation s0_
WHERE
  s0_.date_fin > ?
ORDER BY
  s0_.id DESC
LIMIT
  5

SELECT s0_.id AS id_0, s0_.numsession AS numsession_1, s0_.titre AS titre_2, s0_.date_debut AS date_debut_3, s0_.date_fin AS date_fin_4, s0_.formateur AS formateur_5, s0_.adresse AS adresse_6, s0_.photo AS photo_7, s0_.document_prog AS document_prog_8, s0_.description AS description_9 FROM sessionsformation s0_ WHERE s0_.date_fin > '2026-03-12 10:37:53' ORDER BY s0_.id DESC LIMIT 5;

SELECT
  AVG(f0_.stars) AS sclr_0
FROM
  feedback f0_
  INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id
WHERE
  d1_.service_id = ?

SELECT AVG(f0_.stars) AS sclr_0 FROM feedback f0_ INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id WHERE d1_.service_id = 3;

SELECT
  AVG(f0_.stars) AS sclr_0
FROM
  feedback f0_
  INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id
WHERE
  d1_.service_id = ?

SELECT AVG(f0_.stars) AS sclr_0 FROM feedback f0_ INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id WHERE d1_.service_id = 2;

SELECT
  AVG(f0_.stars) AS sclr_0
FROM
  feedback f0_
  INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id
WHERE
  d1_.service_id = ?

SELECT AVG(f0_.stars) AS sclr_0 FROM feedback f0_ INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id WHERE d1_.service_id = 6;

SELECT
  AVG(f0_.stars) AS sclr_0
FROM
  feedback f0_
  INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id
WHERE
  d1_.service_id = ?

SELECT AVG(f0_.stars) AS sclr_0 FROM feedback f0_ INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id WHERE d1_.service_id = 6;