GET https://kimevasion.com/

Query Metrics

32 Database Queries
11 Different statements
6.87 ms Query time
0 Invalid entities
42 Managed entities

Queries

Group similar statements

# Time Info
1 0.48 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"
]
2 0.33 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"
]
3 0.20 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"
]
4 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:
[
  "favicon"
]
5 0.38 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"
]
6 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:
[
  "secondaryColor"
]
7 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:
[
  "secondaryColor"
]
8 0.25 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:
[]
9 0.22 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"
]
10 0.19 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
]
11 0.20 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
]
12 0.13 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
]
13 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5 FROM product_category t0
Parameters:
[]
14 0.40 ms
SELECT p0_.id AS id_0 FROM product p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND COALESCE(p0_.is_disabled, 0) = 0
Parameters:
[]
15 0.45 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.gallery AS gallery_3, p0_.amount AS amount_4, p0_.is_enabled AS is_enabled_5, p0_.image AS image_6, p0_.max_quantity_in_cart AS max_quantity_in_cart_7, p0_.short_description AS short_description_8, p0_.is_recommanded AS is_recommanded_9, p0_.start_date AS start_date_10, p0_.end_date AS end_date_11, p0_.day_start AS day_start_12, p0_.day_end AS day_end_13, p0_.subscription_interval AS subscription_interval_14, p0_.price_id AS price_id_15, p0_.event_start_hour AS event_start_hour_16, p0_.event_end_time AS event_end_time_17, p0_.start_recurring AS start_recurring_18, p0_.end_recurring AS end_recurring_19, p0_.start_month AS start_month_20, p0_.end_month AS end_month_21, p0_.number_day_start AS number_day_start_22, p0_.number_day_end AS number_day_end_23, p0_.is_deleted AS is_deleted_24, p0_.disabled_dates AS disabled_dates_25, p0_.is_disabled AS is_disabled_26, p0_.product_category_id AS product_category_id_27, p0_.type_id AS type_id_28 FROM product p0_ WHERE p0_.id IN (?, ?) AND COALESCE(p0_.is_deleted, 0) = 0 AND COALESCE(p0_.is_disabled, 0) = 0
Parameters:
[
  5
  3
]
16 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
  8
]
17 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
  7
]
18 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.gallery AS gallery_4, t0.amount AS amount_5, t0.is_enabled AS is_enabled_6, t0.image AS image_7, t0.max_quantity_in_cart AS max_quantity_in_cart_8, t0.short_description AS short_description_9, t0.is_recommanded AS is_recommanded_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.day_start AS day_start_13, t0.day_end AS day_end_14, t0.subscription_interval AS subscription_interval_15, t0.price_id AS price_id_16, t0.event_start_hour AS event_start_hour_17, t0.event_end_time AS event_end_time_18, t0.start_recurring AS start_recurring_19, t0.end_recurring AS end_recurring_20, t0.start_month AS start_month_21, t0.end_month AS end_month_22, t0.number_day_start AS number_day_start_23, t0.number_day_end AS number_day_end_24, t0.is_deleted AS is_deleted_25, t0.disabled_dates AS disabled_dates_26, t0.is_disabled AS is_disabled_27, t0.product_category_id AS product_category_id_28, t0.type_id AS type_id_29 FROM product t0 WHERE t0.is_recommanded = ? LIMIT 1
Parameters:
[
  1
]
19 0.20 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.is_valid AS is_valid_3, t0.date_creation AS date_creation_4, t0.user_id AS user_id_5 FROM testimony t0 WHERE t0.is_valid = ? ORDER BY t0.date_creation DESC LIMIT 2
Parameters:
[
  1
]
20 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.is_valid AS is_valid_4, t0.description AS description_5, t0.url AS url_6 FROM partner t0
Parameters:
[]
21 0.20 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"
]
22 0.40 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"
]
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:
[
  "name"
]
24 0.17 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"
]
25 0.13 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"
]
26 0.13 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"
]
27 0.13 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"
]
28 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:
[
  "facebook"
]
29 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:
[
  "twitter"
]
30 0.12 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"
]
31 0.10 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"
]
32 0.12 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\ProductCategory 14
App\Entity\Parameter 11
App\Entity\Menu 4
App\Entity\PolicyTerm 4
App\Entity\Page 3
App\Entity\Product 3
App\Entity\ProductType 3

Entities Mapping

Class Mapping errors
App\Entity\Parameter No errors.
App\Entity\Menu No errors.
App\Entity\Page No errors.
App\Entity\ProductCategory No errors.
App\Entity\Product No errors.
App\Entity\ProductType No errors.
App\Entity\Ticket No errors.
App\Entity\Testimony No errors.
App\Entity\User No errors.
App\Entity\Partner No errors.
App\Entity\PolicyTerm No errors.