GET https://www.amai-group.com/

Query Metrics

39 Database Queries
10 Different statements
38.55 ms Query time
0 Invalid entities
62 Managed entities

Grouped Statements

Show all queries

Time Count Info
13.45 ms
(34.90%)
20
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:
[
  "jMIRwKfmnEhq5Wme"
]
5.90 ms
(15.31%)
6
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.code_fichier AS code_fichier_4, t0.position_contenu AS position_contenu_5, t0.sous_titre AS sous_titre_6, t0.lien_bouton_action1 AS lien_bouton_action1_7, t0.lien_bouton_action2 AS lien_bouton_action2_8, t0.lien_bouton_action3 AS lien_bouton_action3_9, t0.titre_bouton_action1 AS titre_bouton_action1_10, t0.titre_bouton_action2 AS titre_bouton_action2_11, t0.titre_bouton_action3 AS titre_bouton_action3_12, t0.autre_document_code_fichier AS autre_document_code_fichier_13, t0.section_id AS section_id_14 FROM disposition t0 WHERE t0.section_id = ?
Parameters:
[
  6
]
5.08 ms
(13.18%)
1
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 4
Parameters:
[
  "2026-03-27 15:07:11"
  "evenement"
]
4.27 ms
(11.09%)
6
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"
]
3.63 ms
(9.41%)
1
SELECT DISTINCT s0_.id AS id_0, s0_.titre_principal AS titre_principal_1, s0_.sous_titre_principal AS sous_titre_principal_2, s0_.contenu_principal AS contenu_principal_3, s0_.code_image_principale AS code_image_principale_4, s0_.position_page AS position_page_5, s0_.code_fichier AS code_fichier_6, s0_.position_template AS position_template_7, s0_.background_image AS background_image_8, s0_.background_color AS background_color_9, s0_.lien_bouton_action1 AS lien_bouton_action1_10, s0_.lien_bouton_action2 AS lien_bouton_action2_11, s0_.lien_bouton_action3 AS lien_bouton_action3_12, s0_.titre_bouton_action1 AS titre_bouton_action1_13, s0_.titre_bouton_action2 AS titre_bouton_action2_14, s0_.titre_bouton_action3 AS titre_bouton_action3_15, s0_.reference AS reference_16, s0_.autre_document_code_fichier AS autre_document_code_fichier_17, s0_.parent_id AS parent_id_18, s0_.menu_id AS menu_id_19, s0_.actualite_evenement_id AS actualite_evenement_id_20 FROM section s0_ INNER JOIN section s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s0_.menu_id = ? ORDER BY s0_.position_page ASC
Parameters:
[
  1
]
1.89 ms
(4.90%)
1
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_.visible_accueil = ? AND a0_.type_principal = ?) OR a0_.type_secondaire = ? ORDER BY a0_.date_publication DESC
Parameters:
[
  "2026-03-27 15:07:11"
  1
  "actualite"
  "actualite"
]
1.32 ms
(3.42%)
1
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 = ? LIMIT 1
Parameters:
[
  "accueil"
]
1.21 ms
(3.15%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_fichier AS code_fichier_3, t0.lien_site_web AS lien_site_web_4, t0.lien_facebook AS lien_facebook_5, t0.lien_linkedin AS lien_linkedin_6, t0.lien_twitter AS lien_twitter_7, t0.position AS position_8 FROM partenaire t0 ORDER BY t0.position ASC
Parameters:
[]
1.02 ms
(2.64%)
1
SELECT s0_.id AS id_0, s0_.titre_principal AS titre_principal_1, s0_.sous_titre_principal AS sous_titre_principal_2, s0_.contenu_principal AS contenu_principal_3, s0_.code_image_principale AS code_image_principale_4, s0_.position_page AS position_page_5, s0_.code_fichier AS code_fichier_6, s0_.position_template AS position_template_7, s0_.background_image AS background_image_8, s0_.background_color AS background_color_9, s0_.lien_bouton_action1 AS lien_bouton_action1_10, s0_.lien_bouton_action2 AS lien_bouton_action2_11, s0_.lien_bouton_action3 AS lien_bouton_action3_12, s0_.titre_bouton_action1 AS titre_bouton_action1_13, s0_.titre_bouton_action2 AS titre_bouton_action2_14, s0_.titre_bouton_action3 AS titre_bouton_action3_15, s0_.reference AS reference_16, s0_.autre_document_code_fichier AS autre_document_code_fichier_17, s0_.parent_id AS parent_id_18, s0_.menu_id AS menu_id_19, s0_.actualite_evenement_id AS actualite_evenement_id_20 FROM section s0_ LEFT JOIN section s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s1_.id IS NULL AND s0_.menu_id = ? ORDER BY s0_.position_page ASC
Parameters:
[
  1
]
0.78 ms
(2.01%)
1
SELECT t0.id AS id_1, t0.titre_principal AS titre_principal_2, t0.sous_titre_principal AS sous_titre_principal_3, t0.contenu_principal AS contenu_principal_4, t0.code_image_principale AS code_image_principale_5, t0.position_page AS position_page_6, t0.code_fichier AS code_fichier_7, t0.position_template AS position_template_8, t0.background_image AS background_image_9, t0.background_color AS background_color_10, t0.lien_bouton_action1 AS lien_bouton_action1_11, t0.lien_bouton_action2 AS lien_bouton_action2_12, t0.lien_bouton_action3 AS lien_bouton_action3_13, t0.titre_bouton_action1 AS titre_bouton_action1_14, t0.titre_bouton_action2 AS titre_bouton_action2_15, t0.titre_bouton_action3 AS titre_bouton_action3_16, t0.reference AS reference_17, t0.autre_document_code_fichier AS autre_document_code_fichier_18, t0.parent_id AS parent_id_19, t0.menu_id AS menu_id_20, t0.actualite_evenement_id AS actualite_evenement_id_21 FROM section t0 WHERE t0.parent_id = ?
Parameters:
[
  7
]

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 20
App\Entity\Disposition 17
App\Entity\Section 7
App\Entity\Menu 6
App\Entity\ActualiteEvenement 5
App\Entity\Partenaire 5
App\Entity\User 1
App\Entity\Categorie 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\Partenaire No errors.
App\Entity\Menu No errors.
App\Entity\Disposition No errors.
App\Entity\Files No errors.