Query Metrics
79
Database Queries
20
Different statements
72,83 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
27,70 ms (38,04%) |
46 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.catch_phrase AS catch_phrase_2, p0_.content AS content_3, p0_.image AS image_4, p0_.image_detail AS image_detail_5, p0_.rank AS rank_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_.call_to_action_label AS call_to_action_label_16, p0_.vertical_phrase AS vertical_phrase_17, p0_.ref_cfg_langues_id AS ref_cfg_langues_id_18, p0_.ref_cfg_themes_id AS ref_cfg_themes_id_19, p0_.ref_pages_id AS ref_pages_id_20 FROM pages p0_ WHERE p0_.is_active = 1 AND p0_.id = ? LIMIT 1
Parameters:
[
122
]
|
3,99 ms (5,48%) |
1 |
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_additionnal AS js_additionnal_10 FROM cfg_site t0 WHERE t0.id = ?
Parameters:
[
1
]
|
3,96 ms (5,44%) |
5 |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.rank AS rank_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 ASC
Parameters:
[
1
]
|
3,79 ms (5,20%) |
5 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.facts AS facts_2, s0_.catch_phrase AS catch_phrase_3, s0_.image AS image_4, s0_.link AS link_5, s0_.name_btn AS name_btn_6, s0_.color AS color_7, s0_.is_active AS is_active_8, s0_.ref_shortcuts_types_id AS ref_shortcuts_types_id_9, s0_.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM shortcuts s0_ WHERE s0_.ref_shortcuts_types_id = ? AND s0_.is_active = ? ORDER BY s0_.id ASC
Parameters:
[ 1 1 ] |
3,11 ms (4,27%) |
1 |
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_.image_detail AS image_detail_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_content AS meta_content_11, n0_.rewrite AS rewrite_12, n0_.date_update AS date_update_13, n0_.is_active AS is_active_14, n0_.ref_cfg_langues_id AS ref_cfg_langues_id_15, n0_.ref_news_types_id AS ref_news_types_id_16, n0_.ref_cfg_themes_id AS ref_cfg_themes_id_17 FROM news n0_ INNER JOIN cfg_langues c1_ ON n0_.ref_cfg_langues_id = c1_.id WHERE c1_.iso = ? AND n0_.is_top = 1 AND n0_.is_active = 1 ORDER BY n0_.date_add DESC LIMIT 3
Parameters:
[
"fr"
]
|
3,06 ms (4,20%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rank AS rank_3, t0.rewrite AS rewrite_4, t0.is_active AS is_active_5 FROM news_types t0 WHERE t0.id = ?
Parameters:
[
3
]
|
2,80 ms (3,85%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.rank AS rank_4, t0.is_active AS is_active_5 FROM cfg_themes t0 WHERE t0.id = ?
Parameters:
[
4
]
|
2,65 ms (3,64%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.catch_phrase AS catch_phrase_3, t0.content AS content_4, t0.image AS image_5, t0.image_detail AS image_detail_6, t0.rank AS rank_7, t0.is_active AS is_active_8, t0.meta_title AS meta_title_9, t0.meta_content AS meta_content_10, t0.meta_og_title AS meta_og_title_11, t0.meta_og_image AS meta_og_image_12, t0.meta_twitter_title AS meta_twitter_title_13, t0.meta_twitter_image AS meta_twitter_image_14, t0.rewrite AS rewrite_15, t0.date_update AS date_update_16, t0.call_to_action_label AS call_to_action_label_17, t0.vertical_phrase AS vertical_phrase_18, t0.ref_cfg_langues_id AS ref_cfg_langues_id_19, t0.ref_cfg_themes_id AS ref_cfg_themes_id_20, t0.ref_pages_id AS ref_pages_id_21 FROM pages t0 WHERE t0.id = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "44" 1 ] |
2,52 ms (3,46%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.image AS image_4 FROM reviews_sources t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2,46 ms (3,37%) |
2 |
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
]
|
2,31 ms (3,17%) |
1 |
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 = ? LIMIT 1
Parameters:
[
"menu_haut"
]
|
2,21 ms (3,03%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso AS iso_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.is_default AS is_default_6, t0.ref_pages_id AS ref_pages_id_7 FROM cfg_langues t0 WHERE t0.is_default = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ 1 1 ] |
2,10 ms (2,88%) |
1 |
SELECT r0_.id AS id_0, r0_.is_top AS is_top_1, r0_.is_active AS is_active_2, r0_.author AS author_3, r0_.rating AS rating_4, r0_.url AS url_5, r0_.content AS content_6, r0_.date_add AS date_add_7, r0_.unique_id AS unique_id_8, r0_.ref_reviews_sources_id AS ref_reviews_sources_id_9, r0_.ref_realisations_id AS ref_realisations_id_10 FROM reviews r0_ WHERE r0_.is_active = ? AND r0_.is_top = ? ORDER BY r0_.date_add DESC LIMIT 6
Parameters:
[ 1 1 ] |
2,01 ms (2,76%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.ref_cfg_langues_id AS ref_cfg_langues_id_4 FROM cfg_translations t0
Parameters:
[] |
1,85 ms (2,55%) |
1 |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.is_active AS is_active_2, n0_.mailjet_list_id AS mailjet_list_id_3 FROM newsletter n0_ WHERE n0_.id = ? AND n0_.is_active = ?
Parameters:
[ 1 1 ] |
1,85 ms (2,54%) |
1 |
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
]
|
1,82 ms (2,49%) |
1 |
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 FROM cfg_client t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1,44 ms (1,98%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rank AS rank_3, t0.color AS color_4, t0.is_active AS is_active_5 FROM cfg_blocs t0 WHERE t0.is_active = ? ORDER BY t0.rank ASC
Parameters:
[
1
]
|
0,72 ms (0,99%) |
1 |
SELECT c0_.id AS id_0, c0_.tag AS tag_1, c0_.name AS name_2, c0_.class AS class_3, c0_.has_parent_link AS has_parent_link_4, c0_.has_leveling AS has_leveling_5, c0_.has_ssmenu AS has_ssmenu_6, c0_.config AS config_7, c0_.is_in_sitemap AS is_in_sitemap_8, c0_.ref_cfg_langues_id AS ref_cfg_langues_id_9 FROM cfg_menus c0_ WHERE c0_.tag IN ('menu_bas_gauche', 'menu_bas_milieu', 'menu_bas_droite', 'menu_copyrights') ORDER BY c0_.id ASC
Parameters:
[] |
0,48 ms (0,66%) |
1 |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.is_active AS is_active_2, n0_.mailjet_list_id AS mailjet_list_id_3 FROM newsletter n0_ ORDER BY n0_.name ASC
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\CfgSite | No errors. |
App\Entity\CfgClient | No errors. |
App\Entity\CfgClientAddresses | No errors. |
App\Entity\CfgConstants | No errors. |
App\Entity\CfgTranslations | No errors. |
App\Entity\CfgLangues | No errors. |
App\Entity\CfgBlocs | No errors. |
App\Modules\Pages\Entity\Pages | No errors. |
App\Entity\CfgThemes | No errors. |
App\Modules\Shortcuts\Entity\Shortcuts | No errors. |
App\Modules\Shortcuts\Entity\ShortcutsTypes | No errors. |
App\Modules\Newsletter\Entity\Newsletter | No errors. |
App\Modules\Newsletter\Entity\NewsletterContacts | No errors. |
App\Modules\CfgMenus\Entity\CfgMenus | No errors. |
App\Modules\CfgMenus\Entity\Navigation | No errors. |
App\Modules\News\Entity\News | No errors. |
App\Modules\Realisations\Entity\Realisations | No errors. |
App\Modules\Faq\Entity\Faq | No errors. |
App\Entity\CfgMails | No errors. |
App\Modules\News\Entity\NewsTypes | No errors. |
App\Modules\Reviews\Entity\Reviews | No errors. |
App\Modules\Reviews\Entity\ReviewsSources | No errors. |