Query Metrics
19
Database Queries
8
Different statements
17.16 ms
Query time
0
Invalid entities
30
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.16 ms (30.07%) |
7 |
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"
]
|
||||||||||||||||||||||||||||
|
3.77 ms (21.98%) |
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"
]
|
||||||||||||||||||||||||||||
|
2.76 ms (16.11%) |
1 |
SELECT t0.id AS id_1, t0.titre_principal AS titre_principal_2, t0.slug AS slug_3, t0.contenu_principal AS contenu_principal_4, t0.code_image_principale AS code_image_principale_5, t0.code_fichier AS code_fichier_6, t0.date_ajout AS date_ajout_7, t0.date_modif AS date_modif_8, t0.date_publication AS date_publication_9, t0.date_event AS date_event_10, t0.visible_accueil AS visible_accueil_11, t0.type_principal AS type_principal_12, t0.type_secondaire AS type_secondaire_13, t0.sous_titre_principal AS sous_titre_principal_14, t0.lien_bouton_action1 AS lien_bouton_action1_15, t0.lien_bouton_action2 AS lien_bouton_action2_16, t0.lien_bouton_action3 AS lien_bouton_action3_17, t0.titre_bouton_action1 AS titre_bouton_action1_18, t0.titre_bouton_action2 AS titre_bouton_action2_19, t0.titre_bouton_action3 AS titre_bouton_action3_20, t0.description_detail_contact AS description_detail_contact_21, t0.description_detail_entreprise AS description_detail_entreprise_22, t0.autre_document_code_fichier AS autre_document_code_fichier_23, t0.auteur_id AS auteur_id_24, t0.categorie_id AS categorie_id_25 FROM actualite_evenement t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"us-africa-2025"
]
|
||||||||||||||||||||||||||||
|
2.20 ms (12.82%) |
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_.actualite_evenement_id = ? ORDER BY s0_.position_page ASC
Parameters:
[
22
]
|
||||||||||||||||||||||||||||
|
1.17 ms (6.81%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.date_ajout AS date_ajout_3, t0.parent_id AS parent_id_4 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||||
|
0.83 ms (4.87%) |
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.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.74 ms (4.31%) |
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_.actualite_evenement_id = ? ORDER BY s0_.position_page ASC
Parameters:
[
22
]
|
||||||||||||||||||||||||||||
|
0.52 ms (3.04%) |
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 = ?
Parameters:
[
"upXpLnHKOxKT5L5l"
]
|
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 | 21 |
| App\Entity\Menu | 6 |
| App\Entity\ActualiteEvenement | 1 |
| 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\Menu | No errors. |
| App\Entity\Files | No errors. |