https://s61.captusite.cloud/

Query Metrics

79 Database Queries
20 Different statements
81,89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
28,35 ms
(34,61%)
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
]
9,07 ms
(11,08%)
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
]
4,41 ms
(5,38%)
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
]
4,20 ms
(5,13%)
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,54 ms
(4,32%)
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,14 ms
(3,83%)
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,07 ms
(3,75%)
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
]
2,83 ms
(3,45%)
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,82 ms
(3,45%)
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,64 ms
(3,23%)
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,46 ms
(3,00%)
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
]
2,27 ms
(2,78%)
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,21 ms
(2,70%)
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,17 ms
(2,65%)
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,14 ms
(2,61%)
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,89 ms
(2,31%)
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,65 ms
(2,02%)
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"
]
1,55 ms
(1,89%)
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:
[]
0,93 ms
(1,14%)
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,55 ms
(0,67%)
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.
App\Modules\Realisations\Entity\RealisationsTypes No errors.
App\Modules\Realisations\Entity\RealisationsTags No errors.
App\Modules\Realisations\Entity\RealisationsFeatures No errors.
App\Modules\Realisations\Entity\RealisationsTowns No errors.