Query Metrics
9
Database Queries
9
Different statements
9.01 ms
Query time
4
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.39 ms |
SELECT v0_.id AS id_0, v0_.titre AS titre_1, v0_.url_video AS url_video_2, v0_.url_image AS url_image_3, v0_.video_educative_patient AS video_educative_patient_4 FROM video v0_ ORDER BY v0_.id DESC LIMIT 1000
Parameters:
[] |
| 2 | 2.74 ms |
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
Parameters:
[] |
| 3 | 1.22 ms |
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"
]
|
| 4 | 0.50 ms |
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 DESC
Parameters:
[
"international"
]
|
| 5 | 0.86 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.poste_fr AS poste_fr_4, t0.facebook AS facebook_5, t0.twitter AS twitter_6, t0.linkedin AS linkedin_7, t0.instagram AS instagram_8, t0.photo AS photo_9, t0.poste_en AS poste_en_10 FROM comite t0
Parameters:
[] |
| 6 | 0.81 ms |
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:
[] |
| 7 | 0.40 ms |
SELECT t0.id AS id_1, t0.introduction AS introduction_2, t0.link AS link_3, t0.link2 AS link2_4, t0.text_btn2 AS text_btn2_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.status AS status_8, t0.image AS image_9, t0.label AS label_10, t0.language AS language_11 FROM slides t0 WHERE t0.language = ?
Parameters:
[
"en"
]
|
| 8 | 0.43 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.categorie_memnbre_comite_id AS categorie_memnbre_comite_id_4 FROM member_comite t0
Parameters:
[] |
| 9 | 0.65 ms |
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:
[
"1"
]
|
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\Event | No errors. |
| App\Entity\Slides | No errors. |
| App\Entity\Video | No errors. |
| App\Entity\Comite | No errors. |
| App\Entity\MemberComiteCategorie | No errors. |
| App\Entity\MemberComite | No errors. |
| App\Entity\Abstractt |
|
| App\Entity\Reviewers | No errors. |
| App\Entity\PresenceCongres |
|
| App\Entity\Participation | No errors. |
| App\Entity\PackCongres |
|
| App\Entity\Seo | No errors. |