Query Metrics
80
Database Queries
26
Different statements
45.92 ms
Query time
0
Invalid entities
123
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.12 ms (19.87%) |
24 |
SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_value AS option_value_3, t0.option_label AS option_label_4, t0.option_type AS option_type_5 FROM options t0
Parameters:
[] |
|
5.22 ms (11.36%) |
13 |
SELECT t0.id AS id_1, t0.name_modele AS name_modele_2, t0.content_modele AS content_modele_3, t0.shortcode_modele AS shortcode_modele_4, t0.path_modele AS path_modele_5, t0.variable_modele AS variable_modele_6, t0.status_modele AS status_modele_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.fields AS fields_10, t0.class_sortable AS class_sortable_11, t0.is_new AS is_new_12, t0.content_system AS content_system_13, t0.image_preview_id AS image_preview_id_14 FROM modeles_post t0 WHERE t0.id = ?
Parameters:
[
31
]
|
|
5.03 ms (10.96%) |
1 |
SELECT p.id, p.post_title, p.post_name, p.post_parent, p.id_feature_image_id AS image, a1.id AS i1, a1.post_name AS n1, a1.post_parent AS p1, a2.id AS i2, a2.post_name AS n2, a2.post_parent AS p2, a3.id AS i3, a3.post_name AS n3, a3.post_parent AS p3, v.meta_value AS ville_id, TRIM(c.name) AS ville, TRIM(c.postal_code) AS postal_code, TRIM(dep.code) AS departement_code, TRIM(dep.name) AS departement, CASE WHEN t.meta_value = 'service_parent' THEN p.id WHEN t1.meta_value = 'service_parent' THEN a1.id WHEN t2.meta_value = 'service_parent' THEN a2.id WHEN t3.meta_value = 'service_parent' THEN a3.id ELSE CASE WHEN p.post_parent = 0 THEN p.id WHEN a1.post_parent = 0 THEN a1.id WHEN a2.post_parent = 0 THEN a2.id WHEN a3.post_parent = 0 THEN a3.id END END AS sujet FROM post p JOIN post_meta t ON t.id_post_id = p.id AND t.meta_key = ? LEFT JOIN post_meta v ON v.id_post_id = p.id AND v.meta_key = ? LEFT JOIN cities c ON c.id = v.meta_value LEFT JOIN post_meta d ON d.id_post_id = p.id AND d.meta_key = ? LEFT JOIN departments dep ON dep.id = d.meta_value LEFT JOIN post a1 ON a1.id = p.post_parent LEFT JOIN post a2 ON a2.id = a1.post_parent LEFT JOIN post a3 ON a3.id = a2.post_parent LEFT JOIN post_meta t1 ON t1.id_post_id = a1.id AND t1.meta_key = ? LEFT JOIN post_meta t2 ON t2.id_post_id = a2.id AND t2.meta_key = ? LEFT JOIN post_meta t3 ON t3.id_post_id = a3.id AND t3.meta_key = ? WHERE p.post_status = ? AND t.meta_value IN (?, ?) AND EXISTS (SELECT 1 FROM post_meta r WHERE r.id_post_id = p.id AND r.meta_key = ? AND r.meta_value = ?) AND (d.meta_value IS NULL OR d.meta_value <> ?) AND CASE WHEN t.meta_value = 'service_parent' THEN p.id WHEN t1.meta_value = 'service_parent' THEN a1.id WHEN t2.meta_value = 'service_parent' THEN a2.id WHEN t3.meta_value = 'service_parent' THEN a3.id ELSE CASE WHEN p.post_parent = 0 THEN p.id WHEN a1.post_parent = 0 THEN a1.id WHEN a2.post_parent = 0 THEN a2.id WHEN a3.post_parent = 0 THEN a3.id END END = ? ORDER BY dep.code ASC, (a1.id IS NOT NULL) + (a2.id IS NOT NULL) + (a3.id IS NOT NULL) ASC, p.id ASC LIMIT 32
Parameters:
[ "_type_page_post_uni" "_ville_postdata_post_uni" "_departement_postdata_post_uni" "_type_page_post_uni" "_type_page_post_uni" "_type_page_post_uni" "Publié" "departement" "sevices_departement" "_regions_postdata_post_uni" "8" "93" 232 ] |
|
3.53 ms (7.68%) |
3 |
SELECT t0.id AS id_1, t0.post_title AS post_title_2, t0.post_content AS post_content_3, t0.post_excerpt AS post_excerpt_4, t0.post_name AS post_name_5, t0.post_parent AS post_parent_6, t0.guide AS guide_7, t0.menu_ordre AS menu_ordre_8, t0.post_status AS post_status_9, t0.comment_status AS comment_status_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.post_content_2 AS post_content_2_13, t0.post_order_content AS post_order_content_14, t0.post_parent_migration AS post_parent_migration_15, t0.post_id__migration AS post_id__migration_16, t0.page_template AS page_template_17, t0.post_content_3 AS post_content_3_18, t0.post_content_4 AS post_content_4_19, t0.post_content_5 AS post_content_5_20, t0.post_order_content_preinsertion AS post_order_content_preinsertion_21, t0.is_draft AS is_draft_22, t0.page_menu AS page_menu_23, t0.sommaire AS sommaire_24, t0.is_index AS is_index_25, t0.is_follow AS is_follow_26, t0.post_meta_json AS post_meta_json_27, t0.post_meta_json_dev AS post_meta_json_dev_28, t0.modele_static AS modele_static_29, t0.id_feature_image_id AS id_feature_image_id_30, t0.post_type_id AS post_type_id_31, t0.page_template_id AS page_template_id_32, t0.creator_id AS creator_id_33, t0.author_id AS author_id_34 FROM post t0 WHERE t0.post_name = ? AND t0.post_status = ? AND t0.post_parent = ? LIMIT 1
Parameters:
[ "rideau-metallique" "Publié" 0 ] |
|
3.16 ms (6.88%) |
1 |
SELECT p.id, p.post_title, p.post_name, p.post_parent, p.id_feature_image_id AS image, a1.id AS i1, a1.post_name AS n1, a1.post_parent AS p1, a2.id AS i2, a2.post_name AS n2, a2.post_parent AS p2, a3.id AS i3, a3.post_name AS n3, a3.post_parent AS p3, v.meta_value AS ville_id, TRIM(c.name) AS ville, TRIM(c.postal_code) AS postal_code, TRIM(dep.code) AS departement_code, TRIM(dep.name) AS departement, CASE WHEN t.meta_value = 'service_parent' THEN p.id WHEN t1.meta_value = 'service_parent' THEN a1.id WHEN t2.meta_value = 'service_parent' THEN a2.id WHEN t3.meta_value = 'service_parent' THEN a3.id ELSE CASE WHEN p.post_parent = 0 THEN p.id WHEN a1.post_parent = 0 THEN a1.id WHEN a2.post_parent = 0 THEN a2.id WHEN a3.post_parent = 0 THEN a3.id END END AS sujet FROM post p JOIN post_meta t ON t.id_post_id = p.id AND t.meta_key = ? LEFT JOIN post_meta v ON v.id_post_id = p.id AND v.meta_key = ? LEFT JOIN cities c ON c.id = v.meta_value LEFT JOIN post_meta d ON d.id_post_id = p.id AND d.meta_key = ? LEFT JOIN departments dep ON dep.id = d.meta_value LEFT JOIN post a1 ON a1.id = p.post_parent LEFT JOIN post a2 ON a2.id = a1.post_parent LEFT JOIN post a3 ON a3.id = a2.post_parent LEFT JOIN post_meta t1 ON t1.id_post_id = a1.id AND t1.meta_key = ? LEFT JOIN post_meta t2 ON t2.id_post_id = a2.id AND t2.meta_key = ? LEFT JOIN post_meta t3 ON t3.id_post_id = a3.id AND t3.meta_key = ? WHERE p.post_status = ? AND t.meta_value IN (?, ?) AND d.meta_value = ? AND CASE WHEN t.meta_value = 'service_parent' THEN p.id WHEN t1.meta_value = 'service_parent' THEN a1.id WHEN t2.meta_value = 'service_parent' THEN a2.id WHEN t3.meta_value = 'service_parent' THEN a3.id ELSE CASE WHEN p.post_parent = 0 THEN p.id WHEN a1.post_parent = 0 THEN a1.id WHEN a2.post_parent = 0 THEN a2.id WHEN a3.post_parent = 0 THEN a3.id END END <> ? ORDER BY (a1.id IS NOT NULL) + (a2.id IS NOT NULL) + (a3.id IS NOT NULL) ASC, p.post_title ASC, p.id ASC LIMIT 24
Parameters:
[ "_type_page_post_uni" "_ville_postdata_post_uni" "_departement_postdata_post_uni" "_type_page_post_uni" "_type_page_post_uni" "_type_page_post_uni" "Publié" "departement" "sevices_departement" "93" 232 ] |
|
2.75 ms (5.99%) |
8 |
SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_value AS option_value_3, t0.option_label AS option_label_4, t0.option_type AS option_type_5 FROM options t0 WHERE t0.option_name = ? LIMIT 1
Parameters:
[
"_site_name"
]
|
|
2.64 ms (5.75%) |
6 |
SELECT t0.id AS id_1, t0.url_image AS url_image_2, t0.name_image AS name_image_3, t0.description_image AS description_image_4, t0.alt_image AS alt_image_5, t0.size AS size_6, t0.date_add AS date_add_7, t0.date_update AS date_update_8, t0.height AS height_9, t0.width AS width_10, t0.data AS data_11, t0.mime_type AS mime_type_12, t0.id_migration AS id_migration_13, t0.status AS status_14, t0.documentation_category_id AS documentation_category_id_15 FROM images t0 WHERE t0.id = ?
Parameters:
[
808
]
|
|
1.99 ms (4.34%) |
1 |
SELECT a1.id AS i1, a1.post_parent AS p1, t1.meta_value AS t1, a2.id AS i2, a2.post_parent AS p2, t2.meta_value AS t2, a3.id AS i3, a3.post_parent AS p3, t3.meta_value AS t3 FROM post p LEFT JOIN post a1 ON a1.id = p.post_parent LEFT JOIN post a2 ON a2.id = a1.post_parent LEFT JOIN post a3 ON a3.id = a2.post_parent LEFT JOIN post_meta t1 ON t1.id_post_id = a1.id AND t1.meta_key = ? LEFT JOIN post_meta t2 ON t2.id_post_id = a2.id AND t2.meta_key = ? LEFT JOIN post_meta t3 ON t3.id_post_id = a3.id AND t3.meta_key = ? WHERE p.id = ? LIMIT 1
Parameters:
[ "_type_page_post_uni" "_type_page_post_uni" "_type_page_post_uni" 372 ] |
|
1.81 ms (3.95%) |
1 |
SELECT p.id, p.post_title, p.post_name, p.post_parent, p.id_feature_image_id AS image, a1.id AS i1, a1.post_name AS n1, a1.post_parent AS p1, a2.id AS i2, a2.post_name AS n2, a2.post_parent AS p2, a3.id AS i3, a3.post_name AS n3, a3.post_parent AS p3, v.meta_value AS ville_id, TRIM(c.name) AS ville, TRIM(c.postal_code) AS postal_code, TRIM(dep.code) AS departement_code, TRIM(dep.name) AS departement, CASE WHEN t.meta_value = 'service_parent' THEN p.id WHEN t1.meta_value = 'service_parent' THEN a1.id WHEN t2.meta_value = 'service_parent' THEN a2.id WHEN t3.meta_value = 'service_parent' THEN a3.id ELSE CASE WHEN p.post_parent = 0 THEN p.id WHEN a1.post_parent = 0 THEN a1.id WHEN a2.post_parent = 0 THEN a2.id WHEN a3.post_parent = 0 THEN a3.id END END AS sujet FROM post p JOIN post_meta t ON t.id_post_id = p.id AND t.meta_key = ? LEFT JOIN post_meta v ON v.id_post_id = p.id AND v.meta_key = ? LEFT JOIN cities c ON c.id = v.meta_value LEFT JOIN post_meta d ON d.id_post_id = p.id AND d.meta_key = ? LEFT JOIN departments dep ON dep.id = d.meta_value LEFT JOIN post a1 ON a1.id = p.post_parent LEFT JOIN post a2 ON a2.id = a1.post_parent LEFT JOIN post a3 ON a3.id = a2.post_parent LEFT JOIN post_meta t1 ON t1.id_post_id = a1.id AND t1.meta_key = ? LEFT JOIN post_meta t2 ON t2.id_post_id = a2.id AND t2.meta_key = ? LEFT JOIN post_meta t3 ON t3.id_post_id = a3.id AND t3.meta_key = ? WHERE p.post_status = ? AND t.meta_value IN (?, ?) AND d.meta_value = ? AND CASE WHEN t.meta_value = 'service_parent' THEN p.id WHEN t1.meta_value = 'service_parent' THEN a1.id WHEN t2.meta_value = 'service_parent' THEN a2.id WHEN t3.meta_value = 'service_parent' THEN a3.id ELSE CASE WHEN p.post_parent = 0 THEN p.id WHEN a1.post_parent = 0 THEN a1.id WHEN a2.post_parent = 0 THEN a2.id WHEN a3.post_parent = 0 THEN a3.id END END = ? ORDER BY c.population IS NULL, c.population DESC, c.postal_code ASC, c.name ASC, (a1.id IS NOT NULL) + (a2.id IS NOT NULL) + (a3.id IS NOT NULL) ASC, p.id ASC LIMIT 24
Parameters:
[ "_type_page_post_uni" "_ville_postdata_post_uni" "_departement_postdata_post_uni" "_type_page_post_uni" "_type_page_post_uni" "_type_page_post_uni" "Publié" "villes" "services_ville" "93" 232 ] |
|
1.31 ms (2.84%) |
3 |
SELECT t0.id AS id_1, t0.name_menu AS name_menu_2, t0.menu_content AS menu_content_3, t0.status_menu AS status_menu_4, t0.date_add AS date_add_5, t0.date_update AS date_update_6, t0.template_menu_id AS template_menu_id_7, t0.user_id AS user_id_8 FROM menu t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
1.09 ms (2.38%) |
3 |
SELECT p0_.id AS id_0, p0_.post_name AS post_name_1, p0_.post_parent AS post_parent_2 FROM post p0_ WHERE p0_.id = ? LIMIT 1
Parameters:
[
372
]
|
|
0.90 ms (1.96%) |
1 |
SELECT t0.id AS id_1, t0.name_terms AS name_terms_2, t0.description_terms AS description_terms_3, t0.slug_terms AS slug_terms_4, t0.autre_taxonomy AS autre_taxonomy_5, t0.parent_terms AS parent_terms_6, t0.id_migration AS id_migration_7, t0.parent_migration AS parent_migration_8, t0.level AS level_9, t0.is_draft AS is_draft_10, t0.date AS date_11, t0.id_taxonomy_id AS id_taxonomy_id_12, t0.image_id AS image_id_13 FROM terms t0 INNER JOIN terms_post ON t0.id = terms_post.terms_id WHERE terms_post.post_id = ?
Parameters:
[
372
]
|
|
0.85 ms (1.84%) |
1 |
SELECT r0_.id AS id_0, r0_.old_root AS old_root_1, r0_.new_root AS new_root_2, r0_.id_migration AS id_migration_3, r0_.status AS status_4 FROM redirection r0_ WHERE r0_.old_root = ? LIMIT 1
Parameters:
[
"/rideau-metallique/depannage/hauts-de-seine/"
]
|
|
0.72 ms (1.57%) |
2 |
SELECT config_value FROM configuration WHERE config_name = 'logo_du_site'
Parameters:
[] |
|
0.70 ms (1.52%) |
1 |
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.mv_region AS mv_region_4, t0.mv_departement AS mv_departement_5, t0.mv_type_page AS mv_type_page_6, t0.id_post_id AS id_post_id_7, t0.acf_id AS acf_id_8 FROM post_meta t0 WHERE t0.id_post_id = ?
Parameters:
[
372
]
|
|
0.63 ms (1.36%) |
1 |
SELECT t0.id AS id_1, t0.post_title AS post_title_2, t0.post_content AS post_content_3, t0.post_excerpt AS post_excerpt_4, t0.post_name AS post_name_5, t0.post_parent AS post_parent_6, t0.guide AS guide_7, t0.menu_ordre AS menu_ordre_8, t0.post_status AS post_status_9, t0.comment_status AS comment_status_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.post_content_2 AS post_content_2_13, t0.post_order_content AS post_order_content_14, t0.post_parent_migration AS post_parent_migration_15, t0.post_id__migration AS post_id__migration_16, t0.page_template AS page_template_17, t0.post_content_3 AS post_content_3_18, t0.post_content_4 AS post_content_4_19, t0.post_content_5 AS post_content_5_20, t0.post_order_content_preinsertion AS post_order_content_preinsertion_21, t0.is_draft AS is_draft_22, t0.page_menu AS page_menu_23, t0.sommaire AS sommaire_24, t0.is_index AS is_index_25, t0.is_follow AS is_follow_26, t0.post_meta_json AS post_meta_json_27, t0.post_meta_json_dev AS post_meta_json_dev_28, t0.modele_static AS modele_static_29, t0.id_feature_image_id AS id_feature_image_id_30, t0.post_type_id AS post_type_id_31, t0.page_template_id AS page_template_id_32, t0.creator_id AS creator_id_33, t0.author_id AS author_id_34 FROM post t0 WHERE t0.id = ?
Parameters:
[
331
]
|
|
0.55 ms (1.19%) |
1 |
SELECT t0.id AS id_1, t0.name_taxonomy AS name_taxonomy_2, t0.slug_taxonomy AS slug_taxonomy_3, t0.description_taxonomy AS description_taxonomy_4, t0.parent_taxonomy AS parent_taxonomy_5, t0.autre_taxonomy AS autre_taxonomy_6, t0.order_taxonomy AS order_taxonomy_7, t0.statut_side_bar AS statut_side_bar_8, t0.statut_menu AS statut_menu_9, t0.is_draft AS is_draft_10, t0.date AS date_11, t0.id_migration AS id_migration_12, t0.parent_id_migration AS parent_id_migration_13, t0.use_in_documentation AS use_in_documentation_14, t0.posttype_id AS posttype_id_15 FROM taxonomy t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
0.51 ms (1.11%) |
1 |
SELECT t0.id AS id_1, t0.key_emplacement AS key_emplacement_2, t0.status AS status_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.menu_id AS menu_id_6, t0.user_id AS user_id_7 FROM emplacement t0 WHERE t0.key_emplacement IN (?, ?)
Parameters:
[ "footer-columns" "footer-legal" ] |
|
0.49 ms (1.06%) |
1 |
SELECT t0.id AS id_1, t0.key_emplacement AS key_emplacement_2, t0.status AS status_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.menu_id AS menu_id_6, t0.user_id AS user_id_7 FROM emplacement t0 WHERE t0.key_emplacement IN (?, ?, ?)
Parameters:
[ "top-header-bar" "primary" "burger-menu" ] |
|
0.46 ms (1.00%) |
1 |
SELECT t0.id AS id_1, t0.name_post_type AS name_post_type_2, t0.slug_post_type AS slug_post_type_3, t0.type_post_type AS type_post_type_4, t0.statut_menu_side_bar AS statut_menu_side_bar_5, t0.order_post_type AS order_post_type_6, t0.is_draft AS is_draft_7, t0.display_in_sitemap AS display_in_sitemap_8, t0.path_parent_sitemap AS path_parent_sitemap_9, t0.meta_title_seo_sitmap AS meta_title_seo_sitmap_10, t0.meta_description_seo_sitemap AS meta_description_seo_sitemap_11, t0.has_list AS has_list_12, t0.slug_in_url AS slug_in_url_13, t0.icone_dasbord AS icone_dasbord_14, t0.display_in_sidebar AS display_in_sidebar_15 FROM post_type t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.46 ms (0.99%) |
1 |
SELECT o0_.id AS id_0, o0_.option_name AS option_name_1, o0_.option_value AS option_value_2, o0_.option_label AS option_label_3, o0_.option_type AS option_type_4 FROM options o0_ WHERE o0_.option_name = ?
Parameters:
[
"favicon"
]
|
|
0.45 ms (0.98%) |
1 |
SELECT i0_.id AS id_0, i0_.url_image AS url_image_1, i0_.name_image AS name_image_2, i0_.description_image AS description_image_3, i0_.alt_image AS alt_image_4, i0_.size AS size_5, i0_.date_add AS date_add_6, i0_.date_update AS date_update_7, i0_.height AS height_8, i0_.width AS width_9, i0_.data AS data_10, i0_.mime_type AS mime_type_11, i0_.id_migration AS id_migration_12, i0_.status AS status_13, i0_.documentation_category_id AS documentation_category_id_14 FROM images i0_ WHERE i0_.id IN (NULL)
Parameters:
[] |
|
0.42 ms (0.91%) |
1 |
SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM configuration t0 WHERE t0.config_name = ? LIMIT 1
Parameters:
[
"logo_du_site"
]
|
|
0.42 ms (0.91%) |
1 |
SELECT TRIM(name) FROM departments WHERE id = ?
Parameters:
[
93
]
|
|
0.36 ms (0.79%) |
1 |
SELECT c0_.id AS id_0, c0_.config_name AS config_name_1, c0_.config_value AS config_value_2 FROM configuration c0_ WHERE c0_.config_name = ?
Parameters:
[
"logo_du_site"
]
|
|
0.36 ms (0.78%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.date AS date_4, t0.status AS status_5 FROM template_page t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Options | 36 |
| App\Entity\PostMeta | 35 |
| App\Entity\Images | 18 |
| App\Entity\ModelesPost | 13 |
| App\Entity\Emplacement | 5 |
| App\Entity\Post | 4 |
| App\Entity\Menu | 3 |
| App\Entity\PostType | 2 |
| App\Entity\TemplatePage | 2 |
| App\Entity\User | 2 |
| App\Entity\Terms | 1 |
| App\Entity\Taxonomy | 1 |
| App\Entity\Configuration | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Redirection | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Images | No errors. |
| App\Entity\PostType | No errors. |
| App\Entity\TemplatePage | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Commentaire | No errors. |
| App\Entity\PostMeta | No errors. |
| App\Entity\Terms | No errors. |
| App\Entity\PostModals | No errors. |
| App\Entity\Revision | No errors. |
| App\Entity\Taxonomy | No errors. |
| App\Entity\ModelesPost | No errors. |
| App\Entity\PostMetaFields | No errors. |
| App\Entity\Options | No errors. |
| App\Entity\Configuration | No errors. |
| App\Entity\Acf | No errors. |
| App\Entity\DocumentationCategory | No errors. |
| App\Entity\Emplacement | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\TemplateMenu | No errors. |