Query Metrics
17
Database Queries
16
Different statements
17.72 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.35 ms |
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:
[
3
]
|
||||||||||||||||||||||||||||||||
2 | 0.33 ms |
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.id = ? LIMIT 1
Parameters:
[
"12"
]
|
||||||||||||||||||||||||||||||||
3 | 0.53 ms |
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.expertise_id = ?
Parameters:
[
12
]
|
||||||||||||||||||||||||||||||||
4 | 0.60 ms |
SELECT t0.id AS id_1, t0.quote_en AS quote_en_2, t0.quote_fr AS quote_fr_3, t0.quote_de AS quote_de_4, t0.autor AS autor_5, t0.page_id AS page_id_6, t0.expertise_id AS expertise_id_7, t0.event_id AS event_id_8, t0.award_id AS award_id_9, t0.avocat_id AS avocat_id_10 FROM quotes t0 WHERE t0.expertise_id = ?
Parameters:
[
12
]
|
||||||||||||||||||||||||||||||||
5 | 0.75 ms |
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 (?)
Parameters:
[
37
]
|
||||||||||||||||||||||||||||||||
6 | 0.67 ms |
SELECT t0.id AS id_1, t0.color AS color_2, t0.image AS image_3, t0.ordre AS ordre_4, t0.pages_id AS pages_id_5, t0.actualites_id AS actualites_id_6, t0.expertises_id AS expertises_id_7, t0.avocats_id AS avocats_id_8, t0.events_id AS events_id_9, t0.awards_id AS awards_id_10 FROM sections t0 WHERE t0.expertises_id = ?
Parameters:
[
12
]
|
||||||||||||||||||||||||||||||||
7 | 0.36 ms |
SELECT t0.id AS id_1, t0.color AS color_2, t0.image AS image_3, t0.ordre AS ordre_4, t0.pages_id AS pages_id_5, t0.actualites_id AS actualites_id_6, t0.expertises_id AS expertises_id_7, t0.avocats_id AS avocats_id_8, t0.events_id AS events_id_9, t0.awards_id AS awards_id_10 FROM sections t0 WHERE t0.expertises_id = ? ORDER BY t0.ordre ASC
Parameters:
[
12
]
|
||||||||||||||||||||||||||||||||
8 | 3.50 ms |
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.description_en AS description_en_2, a0_.telephone AS telephone_3, a0_.linkedin AS linkedin_4, a0_.mail AS mail_5, a0_.image AS image_6, a0_.education_accordeon AS education_accordeon_7, a0_.language_accordeon AS language_accordeon_8, a0_.memberships_accordeon AS memberships_accordeon_9, a0_.date_admission_barreau AS date_admission_barreau_10, a0_.telephone_perso AS telephone_perso_11, a0_.vcard AS vcard_12, a0_.bio_pdf AS bio_pdf_13, a0_.qrcode AS qrcode_14, a0_.affichage AS affichage_15, a0_.affichage_liste AS affichage_liste_16, a0_.seo_description_en AS seo_description_en_17, a0_.seo_description_fr AS seo_description_fr_18, a0_.seo_description_de AS seo_description_de_19, a0_.role_change_en AS role_change_en_20, a0_.role_change_fr AS role_change_fr_21, a0_.role_change_de AS role_change_de_22, a0_.role_id AS role_id_23 FROM avocats a0_ INNER JOIN avocat_expertise a1_ ON a0_.id = a1_.avocat_id INNER JOIN roles_avocats r2_ ON a0_.role_id = r2_.id WHERE a1_.expertise_id = ? ORDER BY r2_.priority ASC, CASE WHEN a0_.date_admission_barreau IS NULL THEN 1 ELSE 0 END ASC, a0_.date_admission_barreau ASC, SUBSTRING(a0_.nom FROM LOCATE(' ', a0_.nom) + 1) ASC
Parameters:
[
"12"
]
|
||||||||||||||||||||||||||||||||
9 | 2.21 ms |
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.description_en AS description_en_2, a0_.telephone AS telephone_3, a0_.linkedin AS linkedin_4, a0_.mail AS mail_5, a0_.image AS image_6, a0_.education_accordeon AS education_accordeon_7, a0_.language_accordeon AS language_accordeon_8, a0_.memberships_accordeon AS memberships_accordeon_9, a0_.date_admission_barreau AS date_admission_barreau_10, a0_.telephone_perso AS telephone_perso_11, a0_.vcard AS vcard_12, a0_.bio_pdf AS bio_pdf_13, a0_.qrcode AS qrcode_14, a0_.affichage AS affichage_15, a0_.affichage_liste AS affichage_liste_16, a0_.seo_description_en AS seo_description_en_17, a0_.seo_description_fr AS seo_description_fr_18, a0_.seo_description_de AS seo_description_de_19, a0_.role_change_en AS role_change_en_20, a0_.role_change_fr AS role_change_fr_21, a0_.role_change_de AS role_change_de_22, a0_.role_id AS role_id_23 FROM avocats a0_ INNER JOIN avocat_expertise_ex a1_ ON a0_.id = a1_.avocat_id INNER JOIN roles_avocats r2_ ON a0_.role_id = r2_.id WHERE a1_.expertise_id = ? ORDER BY r2_.priority ASC, a0_.date_admission_barreau ASC, SUBSTRING(a0_.nom FROM LOCATE(' ', a0_.nom) + 1) ASC
Parameters:
[
"12"
]
|
||||||||||||||||||||||||||||||||
10 | 2.89 ms |
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_ LEFT JOIN event_expertises e1_ ON e0_.id = e1_.event_id WHERE e1_.expertise_id IN (?) AND e0_.id <> ? ORDER BY e0_.date DESC LIMIT 3
Parameters:
[ 12 12 ]
|
||||||||||||||||||||||||||||||||
11 | 2.17 ms |
SELECT a0_.id AS id_0, a0_.titre_en AS titre_en_1, a0_.date AS date_2, a0_.nb_vues AS nb_vues_3, a0_.image AS image_4, a0_.introduction_en AS introduction_en_5, a0_.affichage AS affichage_6, a0_.titre_fr AS titre_fr_7, a0_.introduction_fr AS introduction_fr_8, a0_.titre_de AS titre_de_9, a0_.introduction_de AS introduction_de_10, a0_.outside_publications AS outside_publications_11, a0_.seo_description_en AS seo_description_en_12, a0_.seo_description_fr AS seo_description_fr_13, a0_.seo_description_de AS seo_description_de_14, a0_.categories_id AS categories_id_15 FROM actualites a0_ INNER JOIN actu_expertises a1_ ON a0_.id = a1_.actualite_id INNER JOIN expertises e2_ ON a1_.expertise_id = e2_.id WHERE e2_.id = ? AND a0_.date >= ? ORDER BY a0_.date DESC
Parameters:
[ 12 ""2020-01-01"" ]
|
||||||||||||||||||||||||||||||||
12 | 1.45 ms |
SELECT a0_.id AS id_0, a0_.awards_fr AS awards_fr_1, a0_.awards_en AS awards_en_2, a0_.awards_de AS awards_de_3, a0_.image AS image_4, a0_.affichage AS affichage_5, a0_.lien AS lien_6, a0_.sous_titre_en AS sous_titre_en_7, a0_.sous_titre_fr AS sous_titre_fr_8, a0_.sous_titre_de AS sous_titre_de_9, a0_.affichage_home AS affichage_home_10, a0_.seo_description_de AS seo_description_de_11, a0_.seo_description_en AS seo_description_en_12, a0_.seo_description_fr AS seo_description_fr_13, a0_.affichage_expertise AS affichage_expertise_14, a0_.date AS date_15, a0_.categorie_id AS categorie_id_16 FROM awards a0_ LEFT JOIN award_expertise a1_ ON a0_.id = a1_.award_id LEFT JOIN expertises e2_ ON a1_.expertise_id = e2_.id WHERE e2_.id IN (?) AND a0_.id <> ?
Parameters:
[ 12 12 ]
|
||||||||||||||||||||||||||||||||
13 | 0.47 ms |
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.expertises_id = ?
Parameters:
[
"12"
]
|
||||||||||||||||||||||||||||||||
14 | 0.45 ms |
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:
[] |
||||||||||||||||||||||||||||||||
15 | 0.28 ms |
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:
[] |
||||||||||||||||||||||||||||||||
16 | 0.45 ms |
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"
]
|
||||||||||||||||||||||||||||||||
17 | 0.25 ms |
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:
[] |
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\CategoriesExpertises | No errors. |
App\Entity\ActuExpertises | No errors. |
App\Entity\AvocatExpertise | No errors. |
App\Entity\EventExpertises | No errors. |
App\Entity\AwardExpertise | No errors. |
App\Entity\AvocatExpertiseEx | No errors. |
App\Entity\NewslettersExpertises | No errors. |
App\Entity\Events | No errors. |
App\Entity\Awards | No errors. |
App\Entity\Accordeons | No errors. |
App\Entity\Avocats | No errors. |
App\Entity\Contenus | No errors. |
App\Entity\Actualites | No errors. |
App\Entity\Lignes | No errors. |
App\Entity\RolesAvocats | No errors. |
App\Entity\ActuAvocats | No errors. |
App\Entity\AvocatAwards | No errors. |
App\Entity\AvocatEvents | No errors. |
App\Entity\CareersAvocats | No errors. |
App\Entity\SaveTheDate | No errors. |
App\Entity\CategoriesActualites | No errors. |
App\Entity\CategoriesAwards | No errors. |