Query Metrics
13
Database Queries
11
Different statements
6.01 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.96 ms (16.00%) |
2 |
SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 ORDER BY t0.nom_en ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
0.82 ms (13.57%) |
1 |
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.titre_de AS titre_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_de AS description_de_7, t0.contenus_id AS contenus_id_8, t0.qanda_id AS qanda_id_9 FROM accordeons t0 WHERE t0.qanda_id IN (NULL)
Parameters:
[]
|
||||||||||||||||||||||||||||
0.70 ms (11.65%) |
1 |
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.titre_de AS titre_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_de AS description_de_7, t0.date AS date_8, t0.image AS image_9, t0.lieu_fr AS lieu_fr_10, t0.lieu_en AS lieu_en_11, t0.lieu_de AS lieu_de_12, t0.affichage AS affichage_13, t0.savethedate AS savethedate_14, t0.seo_description_en AS seo_description_en_15, t0.seo_description_fr AS seo_description_fr_16, t0.seo_description_de AS seo_description_de_17, t0.link_form AS link_form_18 FROM events t0 ORDER BY t0.date DESC
Parameters:
[]
|
||||||||||||||||||||||||||||
0.51 ms (8.42%) |
2 |
SELECT t0.id AS id_1, t0.libelle_en AS libelle_en_2, t0.libelle_fr AS libelle_fr_3, t0.libelle_de AS libelle_de_4 FROM categories_expertises t0
Parameters:
[] |
||||||||||||||||||||||||||||
0.50 ms (8.29%) |
1 |
SELECT e0_.id AS id_0, e0_.titre_fr AS titre_fr_1, e0_.titre_en AS titre_en_2, e0_.titre_de AS titre_de_3, e0_.description_fr AS description_fr_4, e0_.description_en AS description_en_5, e0_.description_de AS description_de_6, e0_.date AS date_7, e0_.image AS image_8, e0_.lieu_fr AS lieu_fr_9, e0_.lieu_en AS lieu_en_10, e0_.lieu_de AS lieu_de_11, e0_.affichage AS affichage_12, e0_.savethedate AS savethedate_13, e0_.seo_description_en AS seo_description_en_14, e0_.seo_description_fr AS seo_description_fr_15, e0_.seo_description_de AS seo_description_de_16, e0_.link_form AS link_form_17 FROM events e0_ WHERE e0_.date >= ? AND e0_.savethedate = ? ORDER BY e0_.date ASC LIMIT 4
Parameters:
[ "2024-09-03" "Oui" ]
|
||||||||||||||||||||||||||||
0.47 ms (7.87%) |
1 |
SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 WHERE t0.affichage = ? ORDER BY t0.nom_en ASC
Parameters:
[
"Oui"
]
|
||||||||||||||||||||||||||||
0.45 ms (7.41%) |
1 |
SELECT t0.id AS id_1, t0.route AS route_2, t0.image_slider AS image_slider_3, t0.titre_fr_seo AS titre_fr_seo_4, t0.titre_en_seo AS titre_en_seo_5, t0.titre_de_seo AS titre_de_seo_6, t0.description_fr_seo AS description_fr_seo_7, t0.description_en_seo AS description_en_seo_8, t0.description_de_seo AS description_de_seo_9, t0.titre_fr AS titre_fr_10, t0.titre_en AS titre_en_11, t0.titre_de AS titre_de_12 FROM pages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
6
]
|
||||||||||||||||||||||||||||
0.44 ms (7.36%) |
1 |
SELECT e0_.id AS id_0, e0_.titre_fr AS titre_fr_1, e0_.titre_en AS titre_en_2, e0_.titre_de AS titre_de_3, e0_.description_fr AS description_fr_4, e0_.description_en AS description_en_5, e0_.description_de AS description_de_6, e0_.date AS date_7, e0_.image AS image_8, e0_.lieu_fr AS lieu_fr_9, e0_.lieu_en AS lieu_en_10, e0_.lieu_de AS lieu_de_11, e0_.affichage AS affichage_12, e0_.savethedate AS savethedate_13, e0_.seo_description_en AS seo_description_en_14, e0_.seo_description_fr AS seo_description_fr_15, e0_.seo_description_de AS seo_description_de_16, e0_.link_form AS link_form_17 FROM events e0_ WHERE e0_.date >= ? ORDER BY e0_.date ASC LIMIT 3
Parameters:
[
"2024-09-03"
]
|
||||||||||||||||||||||||||||
0.42 ms (7.06%) |
1 |
SELECT t0.id AS id_1, t0.titre_en AS titre_en_2, t0.titre_fr AS titre_fr_3, t0.titre_de AS titre_de_4, t0.intro_fr AS intro_fr_5, t0.intro_en AS intro_en_6, t0.intro_de AS intro_de_7, t0.page_id AS page_id_8, t0.expertise_id AS expertise_id_9, t0.event_id AS event_id_10, t0.award_id AS award_id_11 FROM qand_a t0 WHERE t0.page_id = ?
Parameters:
[
6
]
|
||||||||||||||||||||||||||||
0.41 ms (6.76%) |
1 |
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.titre_de AS titre_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_de AS description_de_7, t0.date AS date_8, t0.image AS image_9, t0.lieu_fr AS lieu_fr_10, t0.lieu_en AS lieu_en_11, t0.lieu_de AS lieu_de_12, t0.affichage AS affichage_13, t0.savethedate AS savethedate_14, t0.seo_description_en AS seo_description_en_15, t0.seo_description_fr AS seo_description_fr_16, t0.seo_description_de AS seo_description_de_17, t0.link_form AS link_form_18 FROM events t0 ORDER BY t0.date DESC LIMIT 2
Parameters:
[]
|
||||||||||||||||||||||||||||
0.34 ms (5.61%) |
1 |
SELECT t0.id AS id_1, t0.texte_fr AS texte_fr_2, t0.texte_en AS texte_en_3, t0.texte_de AS texte_de_4, t0.image AS image_5, t0.pages_id AS pages_id_6, t0.expertises_id AS expertises_id_7 FROM sliders t0 WHERE t0.pages_id = ?
Parameters:
[
6
]
|
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\Pages | No errors. |
App\Entity\Sections | No errors. |
App\Entity\QandA | No errors. |
App\Entity\Sliders | No errors. |
App\Entity\Quotes | No errors. |
App\Entity\Expertises | No errors. |
App\Entity\Events | No errors. |
App\Entity\Awards | No errors. |
App\Entity\Accordeons | No errors. |
App\Entity\Contenus | No errors. |
App\Entity\AvocatEvents | No errors. |
App\Entity\EventExpertises | No errors. |
App\Entity\SaveTheDate | No errors. |
App\Entity\CategoriesExpertises | No errors. |
App\Entity\ActuExpertises | No errors. |
App\Entity\AvocatExpertise | No errors. |
App\Entity\AwardExpertise | No errors. |
App\Entity\AvocatExpertiseEx | No errors. |
App\Entity\NewslettersExpertises | No errors. |