GET https://centre-rac.com/policy/cgv

Query Metrics

25 Database Queries
7 Different statements
4.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.35 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 AND p0_.code = ?
Parameters:
[
  "cgv"
]
2 0.16 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.16 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.16 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.15 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.13 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.14 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.13 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.13 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.12 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.13 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.16 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.16 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.15 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.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:
[
  2
]
18 0.16 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
]
19 0.12 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
]
20 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:
[
  "facebook"
]
21 0.16 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"
]
22 0.15 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"
]
23 0.16 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"
]
24 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:
[
  "youtube"
]
25 0.13 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.