Query Metrics
14
Database Queries
12
Different statements
7.11 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.72 ms (24.19%) |
3 |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_logo AS site_logo_3, t0.site_email AS site_email_4, t0.site_adresse AS site_adresse_5, t0.site_cp AS site_cp_6, t0.site_ville AS site_ville_7, t0.site_telephone AS site_telephone_8, t0.site_url AS site_url_9, t0.site_urlfull AS site_urlfull_10, t0.site_description AS site_description_11, t0.site_keywords AS site_keywords_12, t0.site_map AS site_map_13, t0.site_mentionslegales AS site_mentionslegales_14 FROM setting t0
Parameters:
[] |
0.76 ms (10.74%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.slug AS slug_5, t0.intro AS intro_6, t0.top_lefttitle AS top_lefttitle_7, t0.top_leftcontent AS top_leftcontent_8, t0.top_righttitle AS top_righttitle_9, t0.top_rightcontent AS top_rightcontent_10, t0.main_title AS main_title_11, t0.main_content AS main_content_12, t0.bottom_title AS bottom_title_13, t0.bottom_content AS bottom_content_14, t0.bottom_image AS bottom_image_15, t0.button_text AS button_text_16, t0.button_link AS button_link_17, t0.is_enabled AS is_enabled_18, t0.hero_image AS hero_image_19, t0.template_id AS template_id_20, t0.category_id AS category_id_21 FROM page t0 WHERE t0.category_id = ?
Parameters:
[
2
]
|
0.66 ms (9.31%) |
1 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.fonction AS fonction_3, t0.titre AS titre_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.parcours AS parcours_7, t0.specialisation AS specialisation_8, t0.competences AS competences_9, t0.note AS note_10, t0.telephone AS telephone_11, t0.fax AS fax_12, t0.button_text AS button_text_13, t0.button_link AS button_link_14, t0.sort_order AS sort_order_15 FROM avocat t0 INNER JOIN avocat_domaine ON t0.id = avocat_domaine.avocat_id WHERE avocat_domaine.domaine_id = ?
Parameters:
[
6
]
|
0.66 ms (9.27%) |
1 |
SELECT t0.id AS id_1, t0.main_title AS main_title_2, t0.main_subtitle AS main_subtitle_3, t0.logo AS logo_4, t0.hero_image AS hero_image_5, t0.apropos_title AS apropos_title_6, t0.apropos_content AS apropos_content_7, t0.apropos_buttontext AS apropos_buttontext_8, t0.apropos_buttonlink AS apropos_buttonlink_9, t0.apropos_image AS apropos_image_10, t0.chiffres_clescab AS chiffres_clescab_11, t0.chiffres_clescollab AS chiffres_clescollab_12, t0.chiffres_clesmedia AS chiffres_clesmedia_13, t0.chiffres_clesannees AS chiffres_clesannees_14, t0.equipe_title AS equipe_title_15, t0.equipe_content AS equipe_content_16, t0.equipe_buttontext AS equipe_buttontext_17, t0.equipe_buttonlink AS equipe_buttonlink_18, t0.equipe_image AS equipe_image_19, t0.ventes_title AS ventes_title_20, t0.ventes_content AS ventes_content_21, t0.ventes_buttontext AS ventes_buttontext_22, t0.ventes_buttonlink AS ventes_buttonlink_23, t0.ventes_image AS ventes_image_24, t0.honoraires_title AS honoraires_title_25, t0.honoraires_content AS honoraires_content_26, t0.honoraires_buttontext AS honoraires_buttontext_27, t0.honoraires_buttonlink AS honoraires_buttonlink_28, t0.honoraires_image AS honoraires_image_29, t0.contact_title AS contact_title_30, t0.contact_subtitle AS contact_subtitle_31, t0.contact_logo AS contact_logo_32, t0.contact_map AS contact_map_33, t0.contact_buttontext AS contact_buttontext_34, t0.contact_buttonlink AS contact_buttonlink_35, t0.domaines_title AS domaines_title_36, t0.domaines_content AS domaines_content_37, t0.chiffres_clestitle AS chiffres_clestitle_38, t0.chiffres_clescabtitle AS chiffres_clescabtitle_39, t0.chiffres_clescollabtitle AS chiffres_clescollabtitle_40, t0.chiffres_clesmediatitle AS chiffres_clesmediatitle_41, t0.chiffres_clesanneestitle AS chiffres_clesanneestitle_42 FROM homepage t0
Parameters:
[] |
0.57 ms (7.98%) |
1 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.fonction AS fonction_3, t0.titre AS titre_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.parcours AS parcours_7, t0.specialisation AS specialisation_8, t0.competences AS competences_9, t0.note AS note_10, t0.telephone AS telephone_11, t0.fax AS fax_12, t0.button_text AS button_text_13, t0.button_link AS button_link_14, t0.sort_order AS sort_order_15 FROM avocat t0 ORDER BY t0.sort_order ASC
Parameters:
[] |
0.52 ms (7.27%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.slug AS slug_5, t0.intro AS intro_6, t0.top_lefttitle AS top_lefttitle_7, t0.top_leftcontent AS top_leftcontent_8, t0.top_righttitle AS top_righttitle_9, t0.top_rightcontent AS top_rightcontent_10, t0.main_title AS main_title_11, t0.main_content AS main_content_12, t0.bottom_title AS bottom_title_13, t0.bottom_content AS bottom_content_14, t0.bottom_image AS bottom_image_15, t0.button_text AS button_text_16, t0.button_link AS button_link_17, t0.is_enabled AS is_enabled_18, t0.hero_image AS hero_image_19, t0.template_id AS template_id_20, t0.category_id AS category_id_21 FROM page t0 WHERE t0.is_enabled = ?
Parameters:
[
1
]
|
0.48 ms (6.69%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.title AS title_2, p0_.subtitle AS subtitle_3, p0_.slug AS slug_4, p0_.intro AS intro_5, p0_.top_lefttitle AS top_lefttitle_6, p0_.top_leftcontent AS top_leftcontent_7, p0_.top_righttitle AS top_righttitle_8, p0_.top_rightcontent AS top_rightcontent_9, p0_.main_title AS main_title_10, p0_.main_content AS main_content_11, p0_.bottom_title AS bottom_title_12, p0_.bottom_content AS bottom_content_13, p0_.bottom_image AS bottom_image_14, p0_.button_text AS button_text_15, p0_.button_link AS button_link_16, p0_.is_enabled AS is_enabled_17, p0_.hero_image AS hero_image_18, p0_.template_id AS template_id_19, p0_.category_id AS category_id_20 FROM page p0_ WHERE p0_.is_enabled = 1 AND p0_.slug = ?
Parameters:
[
"immobilier-et-construction"
]
|
0.43 ms (6.11%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.telephone AS telephone_6, t0.fax AS fax_7, t0.map AS map_8 FROM cabinet t0
Parameters:
[] |
0.38 ms (5.40%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.image AS image_4, t0.button_text AS button_text_5, t0.button_link AS button_link_6 FROM domaine t0
Parameters:
[] |
0.37 ms (5.19%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3 FROM honoraire t0
Parameters:
[] |
0.30 ms (4.25%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2 FROM category c0_ WHERE c0_.slug = ?
Parameters:
[
"nos-domaines-dintervention"
]
|
0.26 ms (3.61%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM category 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\Setting | No errors. |
App\Entity\Page | No errors. |
App\Entity\Template | No errors. |
App\Entity\Category | No errors. |
App\Entity\Media | No errors. |
App\Entity\Document | No errors. |
App\Entity\Homepage | No errors. |
App\Entity\Avocat | No errors. |
App\Entity\Domaine | No errors. |
App\Entity\Cabinet | No errors. |
App\Entity\Honoraire | No errors. |