GET https://amai-group.com/actualite-evenement

Query Metrics

31 Database Queries
6 Different statements
25.40 ms Query time
0 Invalid entities
38 Managed entities

Queries

Group similar statements

# Time Info
1 5.37 ms
SELECT a0_.id AS id_0, a0_.titre_principal AS titre_principal_1, a0_.slug AS slug_2, a0_.contenu_principal AS contenu_principal_3, a0_.code_image_principale AS code_image_principale_4, a0_.code_fichier AS code_fichier_5, a0_.date_ajout AS date_ajout_6, a0_.date_modif AS date_modif_7, a0_.date_publication AS date_publication_8, a0_.date_event AS date_event_9, a0_.visible_accueil AS visible_accueil_10, a0_.type_principal AS type_principal_11, a0_.type_secondaire AS type_secondaire_12, a0_.sous_titre_principal AS sous_titre_principal_13, a0_.lien_bouton_action1 AS lien_bouton_action1_14, a0_.lien_bouton_action2 AS lien_bouton_action2_15, a0_.lien_bouton_action3 AS lien_bouton_action3_16, a0_.titre_bouton_action1 AS titre_bouton_action1_17, a0_.titre_bouton_action2 AS titre_bouton_action2_18, a0_.titre_bouton_action3 AS titre_bouton_action3_19, a0_.description_detail_contact AS description_detail_contact_20, a0_.description_detail_entreprise AS description_detail_entreprise_21, a0_.autre_document_code_fichier AS autre_document_code_fichier_22, u1_.id AS id_23, u1_.email AS email_24, u1_.roles AS roles_25, u1_.password AS password_26, u1_.is_verified AS is_verified_27, u1_.nom AS nom_28, u1_.prenom AS prenom_29, u1_.date_ajout AS date_ajout_30, u1_.date_modif AS date_modif_31, u1_.photo_code_fichier AS photo_code_fichier_32, u1_.tel AS tel_33, c2_.id AS id_34, c2_.nom AS nom_35, c2_.date_ajout AS date_ajout_36, a0_.auteur_id AS auteur_id_37, a0_.categorie_id AS categorie_id_38, c2_.parent_id AS parent_id_39 FROM actualite_evenement a0_ LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id LEFT JOIN categorie c2_ ON a0_.categorie_id = c2_.id WHERE a0_.date_publication <= ? AND a0_.date_event > ? AND a0_.type_principal = ? ORDER BY a0_.date_event ASC
Parameters:
[
  "2026-03-27 19:19:07"
  "2026-03-27 19:19:07"
  "evenement"
]
2 1.63 ms
SELECT a0_.id AS id_0, a0_.titre_principal AS titre_principal_1, a0_.slug AS slug_2, a0_.contenu_principal AS contenu_principal_3, a0_.code_image_principale AS code_image_principale_4, a0_.code_fichier AS code_fichier_5, a0_.date_ajout AS date_ajout_6, a0_.date_modif AS date_modif_7, a0_.date_publication AS date_publication_8, a0_.date_event AS date_event_9, a0_.visible_accueil AS visible_accueil_10, a0_.type_principal AS type_principal_11, a0_.type_secondaire AS type_secondaire_12, a0_.sous_titre_principal AS sous_titre_principal_13, a0_.lien_bouton_action1 AS lien_bouton_action1_14, a0_.lien_bouton_action2 AS lien_bouton_action2_15, a0_.lien_bouton_action3 AS lien_bouton_action3_16, a0_.titre_bouton_action1 AS titre_bouton_action1_17, a0_.titre_bouton_action2 AS titre_bouton_action2_18, a0_.titre_bouton_action3 AS titre_bouton_action3_19, a0_.description_detail_contact AS description_detail_contact_20, a0_.description_detail_entreprise AS description_detail_entreprise_21, a0_.autre_document_code_fichier AS autre_document_code_fichier_22, u1_.id AS id_23, u1_.email AS email_24, u1_.roles AS roles_25, u1_.password AS password_26, u1_.is_verified AS is_verified_27, u1_.nom AS nom_28, u1_.prenom AS prenom_29, u1_.date_ajout AS date_ajout_30, u1_.date_modif AS date_modif_31, u1_.photo_code_fichier AS photo_code_fichier_32, u1_.tel AS tel_33, c2_.id AS id_34, c2_.nom AS nom_35, c2_.date_ajout AS date_ajout_36, a0_.auteur_id AS auteur_id_37, a0_.categorie_id AS categorie_id_38, c2_.parent_id AS parent_id_39 FROM actualite_evenement a0_ LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id LEFT JOIN categorie c2_ ON a0_.categorie_id = c2_.id WHERE a0_.date_event <= ? AND a0_.type_principal = ? ORDER BY a0_.date_event DESC LIMIT 6
Parameters:
[
  "2026-03-27 19:19:07"
  "evenement"
]
3 0.56 ms
SELECT count(a0_.id) AS sclr_0 FROM actualite_evenement a0_ WHERE a0_.date_event <= ? AND a0_.type_principal = ?
Parameters:
[
  "2026-03-27 19:19:07"
  "evenement"
]
4 1.24 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.fonction AS fonction_4, t0.message AS message_5, t0.approuve AS approuve_6, t0.code_fichier AS code_fichier_7, t0.date_ajout AS date_ajout_8 FROM temoignage t0 WHERE t0.approuve = ? ORDER BY t0.nom ASC, t0.prenom ASC, t0.fonction ASC
Parameters:
[
  1
]
5 1.42 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "accueil"
]
6 0.42 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "opportunites"
]
7 0.54 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "solutions"
]
8 0.44 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "evenements"
]
9 0.44 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "a-propos"
]
10 0.47 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "contact"
]
11 2.01 ms
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
Parameters:
[
  "jgM9pjNPZvN5IHGx"
]
12 0.54 ms
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
Parameters:
[
  "jgM9pjNPZvN5IHGx"
]
13 0.60 ms
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
Parameters:
[
  "hJDrYhXaIrY4xycp"
]
14 0.45 ms
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
Parameters:
[
  "hJDrYhXaIrY4xycp"
]
15 0.44 ms
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
Parameters:
[
  "hseIQfoOjKzeaAXs"
]
16 0.59 ms
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
Parameters:
[
  "hseIQfoOjKzeaAXs"
]
17 0.58 ms
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
Parameters:
[
  "C5tDqLQ81SjlAgbT"
]
18 0.65 ms
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
Parameters:
[
  "C5tDqLQ81SjlAgbT"
]
19 0.51 ms
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
Parameters:
[
  "WeN6VF9ZDpBqzcH2"
]
20 0.50 ms
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
Parameters:
[
  "WeN6VF9ZDpBqzcH2"
]
21 0.49 ms
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
Parameters:
[
  "P68Yn2iEv9iFpJwm"
]
22 0.52 ms
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
Parameters:
[
  "P68Yn2iEv9iFpJwm"
]
23 0.53 ms
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
Parameters:
[
  "QG8h3SjfJlE5YDdd"
]
24 0.66 ms
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
Parameters:
[
  "QG8h3SjfJlE5YDdd"
]
25 0.60 ms
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
Parameters:
[
  "AXEJ5F15FDj9SjWI"
]
26 0.59 ms
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
Parameters:
[
  "dV4zPwgRItXjSgiE"
]
27 0.54 ms
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
Parameters:
[
  "BAPvxDp8SiXHCmpo"
]
28 0.56 ms
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
Parameters:
[
  "i1H3VHBkhorVAT8K"
]
29 0.54 ms
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
Parameters:
[
  "5CEmJ33TJ2U9NF2A"
]
30 0.49 ms
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
Parameters:
[
  "x8cj3yVHmmlYPWvV"
]
31 0.49 ms
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
Parameters:
[
  "quEVYTGVgZPC6qsj"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Files 14
App\Entity\ActualiteEvenement 7
App\Entity\Temoignage 7
App\Entity\Menu 6
App\Entity\Categorie 3
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\ActualiteEvenement No errors.
App\Entity\User No errors.
App\Entity\Categorie No errors.
App\Entity\EvenementParticipant No errors.
App\Entity\Section No errors.
App\Entity\Temoignage No errors.
App\Entity\Menu No errors.
App\Entity\Files No errors.