Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7,
  t0.date_ajout AS date_ajout_8,
  t0.date_modif AS date_modif_9,
  t0.photo_code_fichier AS photo_code_fichier_10,
  t0.tel AS tel_11
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.date_ajout AS date_ajout_8, t0.date_modif AS date_modif_9, t0.photo_code_fichier AS photo_code_fichier_10, t0.tel AS tel_11 FROM `user` t0 WHERE t0.email = 'admin@gmail.com' LIMIT 1;

SELECT
  COUNT(*)
FROM
  participant t0

SELECT COUNT(*) FROM participant t0;

SELECT
  COUNT(*)
FROM
  actualite_evenement t0
WHERE
  t0.type_principal = ?

SELECT COUNT(*) FROM actualite_evenement t0 WHERE t0.type_principal = 'evenement';

SELECT
  COUNT(*)
FROM
  actualite_evenement t0
WHERE
  t0.type_principal = ?

SELECT COUNT(*) FROM actualite_evenement t0 WHERE t0.type_principal = 'actualite';

SELECT
  COUNT(*)
FROM
  newsletter t0

SELECT COUNT(*) FROM newsletter t0;

SELECT
  COUNT(*)
FROM
  contact t0

SELECT COUNT(*) FROM contact t0;

SELECT
  COUNT(*)
FROM
  temoignage t0

SELECT COUNT(*) FROM temoignage t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.sexe AS sexe_4,
  t0.tel AS tel_5,
  t0.email AS email_6,
  t0.pays_origine AS pays_origine_7,
  t0.code_fichier AS code_fichier_8,
  t0.preference_langue AS preference_langue_9,
  t0.nom_entreprise AS nom_entreprise_10,
  t0.ville AS ville_11,
  t0.intitule_poste AS intitule_poste_12,
  t0.adresse AS adresse_13,
  t0.site_web_entreprise AS site_web_entreprise_14,
  t0.lien_facebook AS lien_facebook_15,
  t0.lien_linkedin AS lien_linkedin_16,
  t0.lien_twitter AS lien_twitter_17,
  t0.lien_youtube AS lien_youtube_18,
  t0.lien_instagram AS lien_instagram_19,
  t0.categorie_visiteur AS categorie_visiteur_20,
  t0.position AS position_21,
  t0.tel_portable_entreprise AS tel_portable_entreprise_22,
  t0.tel_fixe_entreprise AS tel_fixe_entreprise_23,
  t0.email_entreprise AS email_entreprise_24,
  t0.activite_commerciale AS activite_commerciale_25,
  t0.categorie_produit_vendu AS categorie_produit_vendu_26,
  t0.annee_creation_entreprise AS annee_creation_entreprise_27,
  t0.nombre_employe AS nombre_employe_28,
  t0.valeur_vente_annuelle_usd AS valeur_vente_annuelle_usd_29,
  t0.nombre_magasin AS nombre_magasin_30,
  t0.decideur_pour_achat AS decideur_pour_achat_31,
  t0.participation_salon AS participation_salon_32,
  t0.valeur_achat_annuelle_usd AS valeur_achat_annuelle_usd_33,
  t0.nombre_client_reseau_distribution AS nombre_client_reseau_distribution_34,
  t0.importer_vous AS importer_vous_35,
  t0.valeur_annuelle_importation_usd AS valeur_annuelle_importation_usd_36,
  t0.pays_importation AS pays_importation_37,
  t0.marque_importe AS marque_importe_38,
  t0.produit_importe AS produit_importe_39,
  t0.presentation_entreprise AS presentation_entreprise_40,
  t0.document_societe AS document_societe_41
FROM
  participant t0
ORDER BY
  t0.id DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.sexe AS sexe_4, t0.tel AS tel_5, t0.email AS email_6, t0.pays_origine AS pays_origine_7, t0.code_fichier AS code_fichier_8, t0.preference_langue AS preference_langue_9, t0.nom_entreprise AS nom_entreprise_10, t0.ville AS ville_11, t0.intitule_poste AS intitule_poste_12, t0.adresse AS adresse_13, t0.site_web_entreprise AS site_web_entreprise_14, t0.lien_facebook AS lien_facebook_15, t0.lien_linkedin AS lien_linkedin_16, t0.lien_twitter AS lien_twitter_17, t0.lien_youtube AS lien_youtube_18, t0.lien_instagram AS lien_instagram_19, t0.categorie_visiteur AS categorie_visiteur_20, t0.position AS position_21, t0.tel_portable_entreprise AS tel_portable_entreprise_22, t0.tel_fixe_entreprise AS tel_fixe_entreprise_23, t0.email_entreprise AS email_entreprise_24, t0.activite_commerciale AS activite_commerciale_25, t0.categorie_produit_vendu AS categorie_produit_vendu_26, t0.annee_creation_entreprise AS annee_creation_entreprise_27, t0.nombre_employe AS nombre_employe_28, t0.valeur_vente_annuelle_usd AS valeur_vente_annuelle_usd_29, t0.nombre_magasin AS nombre_magasin_30, t0.decideur_pour_achat AS decideur_pour_achat_31, t0.participation_salon AS participation_salon_32, t0.valeur_achat_annuelle_usd AS valeur_achat_annuelle_usd_33, t0.nombre_client_reseau_distribution AS nombre_client_reseau_distribution_34, t0.importer_vous AS importer_vous_35, t0.valeur_annuelle_importation_usd AS valeur_annuelle_importation_usd_36, t0.pays_importation AS pays_importation_37, t0.marque_importe AS marque_importe_38, t0.produit_importe AS produit_importe_39, t0.presentation_entreprise AS presentation_entreprise_40, t0.document_societe AS document_societe_41 FROM participant t0 ORDER BY t0.id DESC LIMIT 5;

SELECT
  SUBSTRING(
    a0_.date_ajout
    FROM
      1 FOR 7
  ) AS sclr_0,
  a0_.type_principal AS type_principal_1,
  COUNT(a0_.id) AS sclr_2
FROM
  actualite_evenement a0_
WHERE
  a0_.date_ajout >= ?
  AND a0_.type_principal IN (?, ?)
GROUP BY
  sclr_0,
  a0_.type_principal
ORDER BY
  sclr_0 ASC

SELECT SUBSTRING(a0_.date_ajout FROM 1 FOR 7) AS sclr_0, a0_.type_principal AS type_principal_1, COUNT(a0_.id) AS sclr_2 FROM actualite_evenement a0_ WHERE a0_.date_ajout >= '2025-04-01 00:00:00' AND a0_.type_principal IN ('actualite', 'evenement') GROUP BY sclr_0, a0_.type_principal ORDER BY sclr_0 ASC;

SELECT
  p0_.pays_origine AS pays_origine_0,
  COUNT(p0_.id) AS sclr_1
FROM
  participant p0_
WHERE
  p0_.pays_origine IS NOT NULL
  AND p0_.pays_origine <> ''
GROUP BY
  p0_.pays_origine
ORDER BY
  sclr_1 DESC
LIMIT
  4

SELECT p0_.pays_origine AS pays_origine_0, COUNT(p0_.id) AS sclr_1 FROM participant p0_ WHERE p0_.pays_origine IS NOT NULL AND p0_.pays_origine <> '' GROUP BY p0_.pays_origine ORDER BY sclr_1 DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.location AS location_5,
  t0.size AS size_6,
  t0.reference_code AS reference_code_7,
  t0.temp AS temp_8,
  t0.lien AS lien_9
FROM
  files t0
WHERE
  t0.reference_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = 'lW9uq31uSNRzuzo3' LIMIT 1;