Query Metrics
31
Database Queries
17
Different statements
20,18 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1,15 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.iso AS iso_2, c0_.image AS image_3, c0_.is_active AS is_active_4, c0_.is_default AS is_default_5, c0_.ref_pages_id AS ref_pages_id_6 FROM cfg_langues c0_ WHERE c0_.is_active = ? AND c0_.iso IS NOT NULL AND c0_.ref_pages_id IS NOT NULL ORDER BY c0_.is_default DESC
Parameters:
[
1
]
|
| 2 | 0,88 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.tinymce_classes AS tinymce_classes_3, t0.analytics AS analytics_4, t0.password AS password_5, t0.captcha_key AS captcha_key_6, t0.captcha_key_secret AS captcha_key_secret_7, t0.is_active AS is_active_8, t0.ips_auth AS ips_auth_9, t0.js_additional AS js_additional_10 FROM cfg_site t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 3 | 0,76 ms |
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.favicon AS favicon_3, t0.email AS email_4, t0.name AS name_5, t0.seo_baseline AS seo_baseline_6, t0.social_linked_in AS social_linked_in_7, t0.social_facebook AS social_facebook_8, t0.social_twitter AS social_twitter_9, t0.social_youtube AS social_youtube_10, t0.social_instagram AS social_instagram_11, t0.social_snapchat AS social_snapchat_12, t0.social_tik_tok AS social_tik_tok_13, t0.maintenance_background AS maintenance_background_14, t0.maintenance_color AS maintenance_color_15, t0.maintenance_content AS maintenance_content_16 FROM cfg_client t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 4 | 0,58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.address_comp AS address_comp_4, t0.zip_code AS zip_code_5, t0.town AS town_6, t0.country AS country_7, t0.coordinates AS coordinates_8, t0.phone AS phone_9, t0.phone2 AS phone2_10, t0.fax AS fax_11, t0.is_active AS is_active_12 FROM cfg_client_addresses t0 WHERE t0.is_active = ?
Parameters:
[
1
]
|
| 5 | 0,55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.commentary AS commentary_4, t0.is_active AS is_active_5 FROM cfg_constants t0 WHERE t0.is_active = ?
Parameters:
[
1
]
|
| 6 | 0,44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.address_comp AS address_comp_4, t0.zip_code AS zip_code_5, t0.town AS town_6, t0.country AS country_7, t0.coordinates AS coordinates_8, t0.phone AS phone_9, t0.phone2 AS phone2_10, t0.fax AS fax_11, t0.is_active AS is_active_12 FROM cfg_client_addresses t0 WHERE t0.is_active = ?
Parameters:
[
1
]
|
| 7 | 0,60 ms |
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.name AS name_3, t0.class AS class_4, t0.has_parent_link AS has_parent_link_5, t0.has_leveling AS has_leveling_6, t0.has_ssmenu AS has_ssmenu_7, t0.config AS config_8, t0.is_in_sitemap AS is_in_sitemap_9, t0.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM cfg_menus t0 WHERE t0.tag = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ "menu_haut" 1 ] |
| 8 | 0,65 ms |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.rank_order AS rank_order_2, n0_.is_target_blank AS is_target_blank_3, n0_.link_type AS link_type_4, n0_.image AS image_5, n0_.custom AS custom_6, n0_.link AS link_7, n0_.ref_cfg_menus_id AS ref_cfg_menus_id_8, n0_.ref_navigation_id AS ref_navigation_id_9 FROM navigation n0_ WHERE n0_.ref_cfg_menus_id = ? ORDER BY n0_.rank_order ASC
Parameters:
[
1
]
|
| 9 | 0,73 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.site_name AS site_name_2, p0_.content_small AS content_small_3, p0_.content AS content_4, p0_.image AS image_5, p0_.rank_order AS rank_order_6, p0_.is_active AS is_active_7, p0_.meta_title AS meta_title_8, p0_.meta_content AS meta_content_9, p0_.meta_og_title AS meta_og_title_10, p0_.meta_og_image AS meta_og_image_11, p0_.meta_twitter_title AS meta_twitter_title_12, p0_.meta_twitter_image AS meta_twitter_image_13, p0_.rewrite AS rewrite_14, p0_.date_update AS date_update_15, p0_.ref_pages_id AS ref_pages_id_16, p0_.ref_cfg_langues_id AS ref_cfg_langues_id_17 FROM pages p0_ LEFT JOIN cfg_langues c1_ ON p0_.ref_cfg_langues_id = c1_.id WHERE p0_.is_active = 1 AND p0_.id = ? AND c1_.iso = ? LIMIT 1
Parameters:
[ 12 "fr" ] |
| 10 | 0,52 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.site_name AS site_name_2, p0_.content_small AS content_small_3, p0_.content AS content_4, p0_.image AS image_5, p0_.rank_order AS rank_order_6, p0_.is_active AS is_active_7, p0_.meta_title AS meta_title_8, p0_.meta_content AS meta_content_9, p0_.meta_og_title AS meta_og_title_10, p0_.meta_og_image AS meta_og_image_11, p0_.meta_twitter_title AS meta_twitter_title_12, p0_.meta_twitter_image AS meta_twitter_image_13, p0_.rewrite AS rewrite_14, p0_.date_update AS date_update_15, p0_.ref_pages_id AS ref_pages_id_16, p0_.ref_cfg_langues_id AS ref_cfg_langues_id_17 FROM pages p0_ LEFT JOIN cfg_langues c1_ ON p0_.ref_cfg_langues_id = c1_.id WHERE p0_.is_active = 1 AND p0_.id = ? AND c1_.iso = ? LIMIT 1
Parameters:
[ 13 "fr" ] |
| 11 | 0,51 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.content AS content_4, t0.meta_title AS meta_title_5, t0.meta_content AS meta_content_6, t0.url_rewrite AS url_rewrite_7, t0.is_active AS is_active_8, t0.content_small AS content_small_9, t0.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM sector t0 WHERE t0.id = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ 2 1 ] |
| 12 | 0,54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.content AS content_4, t0.meta_title AS meta_title_5, t0.meta_content AS meta_content_6, t0.url_rewrite AS url_rewrite_7, t0.is_active AS is_active_8, t0.content_small AS content_small_9, t0.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM sector t0 WHERE t0.id = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ 4 1 ] |
| 13 | 0,42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.content AS content_4, t0.meta_title AS meta_title_5, t0.meta_content AS meta_content_6, t0.url_rewrite AS url_rewrite_7, t0.is_active AS is_active_8, t0.content_small AS content_small_9, t0.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM sector t0 WHERE t0.id = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ 3 1 ] |
| 14 | 0,49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.content AS content_4, t0.meta_title AS meta_title_5, t0.meta_content AS meta_content_6, t0.url_rewrite AS url_rewrite_7, t0.is_active AS is_active_8, t0.content_small AS content_small_9, t0.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM sector t0 WHERE t0.id = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ 5 1 ] |
| 15 | 0,43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.content AS content_4, t0.meta_title AS meta_title_5, t0.meta_content AS meta_content_6, t0.url_rewrite AS url_rewrite_7, t0.is_active AS is_active_8, t0.content_small AS content_small_9, t0.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM sector t0 WHERE t0.id = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ 6 1 ] |
| 16 | 0,40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.content AS content_4, t0.meta_title AS meta_title_5, t0.meta_content AS meta_content_6, t0.url_rewrite AS url_rewrite_7, t0.is_active AS is_active_8, t0.content_small AS content_small_9, t0.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM sector t0 WHERE t0.id = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ 7 1 ] |
| 17 | 0,59 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.name AS name_3, t0.image AS image_4, t0.content AS content_5, t0.content_small AS content_small_6, t0.utilization AS utilization_7, t0.benefit AS benefit_8, t0.packaging AS packaging_9, t0.color AS color_10, t0.meta_title AS meta_title_11, t0.meta_content AS meta_content_12, t0.url_rewrite AS url_rewrite_13, t0.is_active AS is_active_14, t0.ref_cfg_langues_id AS ref_cfg_langues_id_15, t0.ref_product_type_id AS ref_product_type_id_16 FROM product t0 WHERE t0.id = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ 1 1 ] |
| 18 | 0,49 ms |
SELECT t0.id AS id_1, t0.url_rewrite AS url_rewrite_2, t0.name AS name_3, t0.ref_cfg_langues_id AS ref_cfg_langues_id_4 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 19 | 0,46 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.name AS name_3, t0.image AS image_4, t0.content AS content_5, t0.content_small AS content_small_6, t0.utilization AS utilization_7, t0.benefit AS benefit_8, t0.packaging AS packaging_9, t0.color AS color_10, t0.meta_title AS meta_title_11, t0.meta_content AS meta_content_12, t0.url_rewrite AS url_rewrite_13, t0.is_active AS is_active_14, t0.ref_cfg_langues_id AS ref_cfg_langues_id_15, t0.ref_product_type_id AS ref_product_type_id_16 FROM product t0 WHERE t0.id = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ 2 1 ] |
| 20 | 0,44 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.name AS name_3, t0.image AS image_4, t0.content AS content_5, t0.content_small AS content_small_6, t0.utilization AS utilization_7, t0.benefit AS benefit_8, t0.packaging AS packaging_9, t0.color AS color_10, t0.meta_title AS meta_title_11, t0.meta_content AS meta_content_12, t0.url_rewrite AS url_rewrite_13, t0.is_active AS is_active_14, t0.ref_cfg_langues_id AS ref_cfg_langues_id_15, t0.ref_product_type_id AS ref_product_type_id_16 FROM product t0 WHERE t0.id = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ 3 1 ] |
| 21 | 0,52 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.site_name AS site_name_2, p0_.content_small AS content_small_3, p0_.content AS content_4, p0_.image AS image_5, p0_.rank_order AS rank_order_6, p0_.is_active AS is_active_7, p0_.meta_title AS meta_title_8, p0_.meta_content AS meta_content_9, p0_.meta_og_title AS meta_og_title_10, p0_.meta_og_image AS meta_og_image_11, p0_.meta_twitter_title AS meta_twitter_title_12, p0_.meta_twitter_image AS meta_twitter_image_13, p0_.rewrite AS rewrite_14, p0_.date_update AS date_update_15, p0_.ref_pages_id AS ref_pages_id_16, p0_.ref_cfg_langues_id AS ref_cfg_langues_id_17 FROM pages p0_ LEFT JOIN cfg_langues c1_ ON p0_.ref_cfg_langues_id = c1_.id WHERE p0_.is_active = 1 AND p0_.id = ? AND c1_.iso = ? LIMIT 1
Parameters:
[ 8 "fr" ] |
| 22 | 0,61 ms |
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.name AS name_3, t0.class AS class_4, t0.has_parent_link AS has_parent_link_5, t0.has_leveling AS has_leveling_6, t0.has_ssmenu AS has_ssmenu_7, t0.config AS config_8, t0.is_in_sitemap AS is_in_sitemap_9, t0.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM cfg_menus t0 WHERE t0.tag = ? AND t0.ref_cfg_langues_id = ? LIMIT 1
Parameters:
[ "menu_bas" 1 ] |
| 23 | 0,63 ms |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.rank_order AS rank_order_2, n0_.is_target_blank AS is_target_blank_3, n0_.link_type AS link_type_4, n0_.image AS image_5, n0_.custom AS custom_6, n0_.link AS link_7, n0_.ref_cfg_menus_id AS ref_cfg_menus_id_8, n0_.ref_navigation_id AS ref_navigation_id_9 FROM navigation n0_ WHERE n0_.ref_cfg_menus_id = ? ORDER BY n0_.rank_order ASC
Parameters:
[
2
]
|
| 24 | 0,57 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.site_name AS site_name_2, p0_.content_small AS content_small_3, p0_.content AS content_4, p0_.image AS image_5, p0_.rank_order AS rank_order_6, p0_.is_active AS is_active_7, p0_.meta_title AS meta_title_8, p0_.meta_content AS meta_content_9, p0_.meta_og_title AS meta_og_title_10, p0_.meta_og_image AS meta_og_image_11, p0_.meta_twitter_title AS meta_twitter_title_12, p0_.meta_twitter_image AS meta_twitter_image_13, p0_.rewrite AS rewrite_14, p0_.date_update AS date_update_15, p0_.ref_pages_id AS ref_pages_id_16, p0_.ref_cfg_langues_id AS ref_cfg_langues_id_17 FROM pages p0_ LEFT JOIN cfg_langues c1_ ON p0_.ref_cfg_langues_id = c1_.id WHERE p0_.is_active = 1 AND p0_.id = ? AND c1_.iso = ? LIMIT 1
Parameters:
[ 12 "fr" ] |
| 25 | 0,54 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.site_name AS site_name_2, p0_.content_small AS content_small_3, p0_.content AS content_4, p0_.image AS image_5, p0_.rank_order AS rank_order_6, p0_.is_active AS is_active_7, p0_.meta_title AS meta_title_8, p0_.meta_content AS meta_content_9, p0_.meta_og_title AS meta_og_title_10, p0_.meta_og_image AS meta_og_image_11, p0_.meta_twitter_title AS meta_twitter_title_12, p0_.meta_twitter_image AS meta_twitter_image_13, p0_.rewrite AS rewrite_14, p0_.date_update AS date_update_15, p0_.ref_pages_id AS ref_pages_id_16, p0_.ref_cfg_langues_id AS ref_cfg_langues_id_17 FROM pages p0_ LEFT JOIN cfg_langues c1_ ON p0_.ref_cfg_langues_id = c1_.id WHERE p0_.is_active = 1 AND p0_.id = ? AND c1_.iso = ? LIMIT 1
Parameters:
[ 13 "fr" ] |
| 26 | 0,78 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image AS image_2, p0_.link AS link_3, p0_.is_active AS is_active_4 FROM partner p0_ WHERE p0_.is_active = ? ORDER BY p0_.id ASC
Parameters:
[
1
]
|
| 27 | 0,52 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image AS image_2, s0_.content AS content_3, s0_.meta_title AS meta_title_4, s0_.meta_content AS meta_content_5, s0_.url_rewrite AS url_rewrite_6, s0_.is_active AS is_active_7, s0_.content_small AS content_small_8, s0_.ref_cfg_langues_id AS ref_cfg_langues_id_9 FROM sector s0_ WHERE s0_.is_active = ? ORDER BY s0_.id ASC
Parameters:
[
1
]
|
| 28 | 0,70 ms |
SELECT n0_.id AS id_0, n0_.is_top AS is_top_1, n0_.name AS name_2, n0_.catch_phrase AS catch_phrase_3, n0_.content AS content_4, n0_.date_add AS date_add_5, n0_.link AS link_6, n0_.image_list AS image_list_7, n0_.meta_title AS meta_title_8, n0_.meta_keywords AS meta_keywords_9, n0_.meta_content AS meta_content_10, n0_.rewrite AS rewrite_11, n0_.date_update AS date_update_12, n0_.is_active AS is_active_13, n0_.ref_cfg_langues_id AS ref_cfg_langues_id_14 FROM news n0_ INNER JOIN cfg_langues c1_ ON n0_.ref_cfg_langues_id = c1_.id WHERE c1_.id = ? AND n0_.is_top = 1 AND n0_.is_active = 1 ORDER BY n0_.date_add DESC LIMIT 3
Parameters:
[
1
]
|
| 29 | 0,74 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.image AS image_2, c0_.file AS file_3, c0_.rank_order AS rank_order_4, c0_.is_active AS is_active_5, c0_.ref_cfg_langues_id AS ref_cfg_langues_id_6 FROM certification c0_ INNER JOIN cfg_langues c1_ ON c0_.ref_cfg_langues_id = c1_.id WHERE c1_.id = ? AND c0_.is_active = ? ORDER BY c0_.rank_order ASC
Parameters:
[ 1 1 ] |
| 30 | 0,57 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image AS image_2, s0_.content AS content_3, s0_.meta_title AS meta_title_4, s0_.meta_content AS meta_content_5, s0_.url_rewrite AS url_rewrite_6, s0_.is_active AS is_active_7, s0_.content_small AS content_small_8, s0_.ref_cfg_langues_id AS ref_cfg_langues_id_9 FROM sector s0_ WHERE s0_.url_rewrite = ? AND s0_.is_active = ?
Parameters:
[ "energie" 1 ] |
| 31 | 2,38 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.image AS image_2, a0_.content AS content_3, a0_.is_active AS is_active_4, a0_.application_support AS application_support_5, a0_.finish AS finish_6, a0_.technical_file AS technical_file_7, a0_.meta_title AS meta_title_8, a0_.meta_content AS meta_content_9, a0_.url_rewrite AS url_rewrite_10, a0_.ref_cfg_langues_id AS ref_cfg_langues_id_11, a0_.ref_sector_id AS ref_sector_id_12 FROM application a0_ WHERE a0_.is_active = ? AND a0_.ref_sector_id = ? ORDER BY a0_.id ASC
Parameters:
[ 1 4 ] |
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.