GET https://kimevasion.com/policy/cgu

Query Metrics

25 Database Queries
4 Different statements
20.09 ms Query time
0 Invalid entities
22 Managed entities

Queries

Group similar statements

# Time Info
1 0.64 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4 FROM policy_term t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "cgu"
]
2 0.77 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "principalColor"
]
3 0.54 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "name"
]
4 0.70 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "description"
]
5 0.42 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "favicon"
]
6 9.89 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "secondaryColor"
]
7 0.23 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "secondaryColor"
]
8 0.34 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "secondaryColor"
]
9 0.41 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 ORDER BY t0.ordre ASC
Parameters:
[]
10 0.37 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "logo_s"
]
11 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.content AS content_4, t0.image_bkg AS image_bkg_5, t0.header_image AS header_image_6, t0.subtitle AS subtitle_7 FROM page t0 WHERE t0.id = ?
Parameters:
[
  2
]
12 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.content AS content_4, t0.image_bkg AS image_bkg_5, t0.header_image AS header_image_6, t0.subtitle AS subtitle_7 FROM page t0 WHERE t0.id = ?
Parameters:
[
  4
]
13 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.content AS content_4, t0.image_bkg AS image_bkg_5, t0.header_image AS header_image_6, t0.subtitle AS subtitle_7 FROM page t0 WHERE t0.id = ?
Parameters:
[
  3
]
14 0.57 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "principalColor"
]
15 0.54 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "logo_s"
]
16 0.26 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "name"
]
17 0.58 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4 FROM policy_term t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "cgu"
]
18 1.61 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4 FROM policy_term t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "cgv"
]
19 0.24 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4 FROM policy_term t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "privacy"
]
20 0.23 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4 FROM policy_term t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "ml"
]
21 0.27 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "facebook"
]
22 0.18 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "twitter"
]
23 0.14 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "instagram"
]
24 0.19 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "linkedin"
]
25 0.17 ms
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "youtube"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Parameter 11
App\Entity\PolicyTerm 4
App\Entity\Menu 4
App\Entity\Page 3

Entities Mapping

Class Mapping errors
App\Entity\PolicyTerm No errors.
App\Entity\Parameter No errors.
App\Entity\Menu No errors.
App\Entity\Page No errors.