GET https://centre-rac.com/page/apropos

Query Metrics

30 Database Queries
9 Different statements
6.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.image_bkg AS image_bkg_3, p0_.header_image AS header_image_4, p0_.subtitle AS subtitle_5, p0_.is_home AS is_home_6, p0_.header_type AS header_type_7, p0_.header_detail AS header_detail_8, p0_.keywords AS keywords_9, p0_.content AS content_10, p0_.is_deleted AS is_deleted_11 FROM PAGE p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.code = ?
Parameters:
[
  "apropos"
]
2 0.18 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_
Parameters:
[]
3 0.26 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "name"
]
4 0.20 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "slogan"
]
5 0.19 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "keyword"
]
6 0.20 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "description"
]
7 0.18 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "favicon"
]
8 0.18 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "logo"
]
9 0.21 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "logo_s"
]
10 0.18 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "principalColor"
]
11 0.17 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "secondaryColor"
]
12 0.20 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "algoliaIndex"
]
13 0.22 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "name"
]
14 0.17 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "logo_s"
]
15 0.14 ms
SELECT t0.id AS id_1, t0.link_name AS link_name_2, t0.url AS url_3, t0.on_top AS on_top_4, t0.ordre AS ordre_5, t0.visibility AS visibility_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8 FROM menu t0
Parameters:
[]
16 0.17 ms
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.options AS options_3, f0_.price AS price_4, f0_.is_subscription_open AS is_subscription_open_5, f0_.payment_configuration AS payment_configuration_6, f0_.price_ht AS price_ht_7, f0_.is_in_top_bar AS is_in_top_bar_8, f0_.top_bar_message AS top_bar_message_9, f0_.is_deleted AS is_deleted_10, f0_.subscription_class_id AS subscription_class_id_11, f0_.product_type_id AS product_type_id_12 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.is_in_top_bar = ?
Parameters:
[
  1
]
17 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM PAGE t0 WHERE t0.id = ?
Parameters:
[
  4
]
18 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM PAGE t0 WHERE t0.id = ?
Parameters:
[
  3
]
19 0.48 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
Parameters:
[
  "text"
]
20 0.25 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
Parameters:
[
  "title"
]
21 0.24 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
Parameters:
[
  "textList"
]
22 0.17 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
Parameters:
[
  "title"
]
23 0.17 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
Parameters:
[
  "button"
]
24 0.26 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.image_bkg AS image_bkg_3, p0_.header_image AS header_image_4, p0_.subtitle AS subtitle_5, p0_.is_home AS is_home_6, p0_.header_type AS header_type_7, p0_.header_detail AS header_detail_8, p0_.keywords AS keywords_9, p0_.content AS content_10, p0_.is_deleted AS is_deleted_11 FROM PAGE p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.id = ?
Parameters:
[
  4
]
25 0.23 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "facebook"
]
26 0.22 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "twitter"
]
27 0.18 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "instagram"
]
28 0.25 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "linkedin"
]
29 0.20 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "youtube"
]
30 0.21 ms
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.footer_name AS footer_name_3, p0_.content AS content_4, p0_.is_deleted AS is_deleted_5 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0
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.