Query Metrics
5
Database Queries
5
Different statements
9.06 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.97 ms (54.85%) |
1 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.label AS label_3, t0.label_en AS label_en_4, t0.type_congres AS type_congres_5, t0.partners AS partners_6, t0.lien_pdf AS lien_pdf_7, t0.date_debut AS date_debut_8, t0.date_fin AS date_fin_9, t0.date_soumission AS date_soumission_10, t0.date_notification AS date_notification_11, t0.date_poster AS date_poster_12, t0.prgrm_scientifique AS prgrm_scientifique_13, t0.sponsor AS sponsor_14, t0.speakers AS speakers_15, t0.mot_du_president AS mot_du_president_16, t0.info_general AS info_general_17, t0.registration AS registration_18, t0.lieu AS lieu_19, t0.inscription AS inscription_20 FROM congres t0 ORDER BY t0.id DESC
Parameters:
[] |
|
1.51 ms (16.64%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.titre AS titre_3, t0.image AS image_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.location AS location_7, t0.location_en AS location_en_8, t0.content AS content_9, t0.content_en AS content_en_10, t0.categorie AS categorie_11, t0.pdf AS pdf_12, t0.lien AS lien_13, t0.inscription AS inscription_14 FROM event t0 WHERE t0.categorie = ? ORDER BY t0.start_date ASC
Parameters:
[
"national"
]
|
|
0.97 ms (10.75%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.nom_president AS nom_president_3, t0.prenom_president AS prenom_president_4, t0.icone_svg AS icone_svg_5, t0.icone_fontawesome AS icone_fontawesome_6, t0.photo AS photo_7, t0.title AS title_8 FROM member_comite_categorie t0
Parameters:
[] |
|
0.87 ms (9.59%) |
1 |
SELECT YEAR(c0_.date_debut) AS sclr_0, c0_.id AS id_1, c0_.label AS label_2 FROM congres c0_ WHERE YEAR(c0_.date_debut) <= YEAR(CURRENT_DATE) ORDER BY YEAR(c0_.date_debut) DESC LIMIT 10
Parameters:
[] |
|
0.74 ms (8.18%) |
1 |
SELECT t0.id AS id_1, t0.page AS page_2, t0.title AS title_3, t0.titre AS titre_4, t0.metatitle AS metatitle_5, t0.metatitre AS metatitre_6, t0.metadescription AS metadescription_7, t0.metadescription_en AS metadescription_en_8 FROM seo t0 WHERE t0.id = ?
Parameters:
[
"16"
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Congres |
|
| App\Entity\MemberComiteCategorie | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\Abstractt |
|
| App\Entity\Reviewers | No errors. |
| App\Entity\PresenceCongres |
|
| App\Entity\Participation | No errors. |
| App\Entity\PackCongres |
|
| App\Entity\MemberComite | No errors. |
| App\Entity\Seo | No errors. |