GET https://kimevasion.com/boutique/discovery

Query Metrics

29 Database Queries
9 Different statements
8.06 ms Query time
0 Invalid entities
38 Managed entities

Queries

Group similar statements

# Time Info
1 0.45 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 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "discovery"
]
2 0.38 ms
SELECT min(p0_.amount) AS sclr_0 FROM product p0_
Parameters:
[]
3 0.29 ms
SELECT max(p0_.amount) AS sclr_0 FROM product p0_
Parameters:
[]
4 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:
[
  "principalColor"
]
5 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:
[
  "name"
]
6 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:
[
  "description"
]
7 0.13 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"
]
8 0.50 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.31 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"
]
10 0.24 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"
]
11 0.40 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:
[]
12 0.39 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"
]
13 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
]
14 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:
[
  4
]
15 0.15 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
]
16 0.55 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:
[]
17 0.42 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
]
18 0.32 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"
]
19 0.68 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"
]
20 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:
[
  "name"
]
21 0.22 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"
]
22 0.20 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"
]
23 0.18 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"
]
24 0.18 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"
]
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:
[
  "facebook"
]
26 0.16 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"
]
27 0.15 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"
]
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:
[
  "linkedin"
]
29 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\ProductCategory 14
App\Entity\Parameter 11
App\Entity\Menu 4
App\Entity\PolicyTerm 4
App\Entity\Page 3
App\Entity\Product 1
App\Entity\ProductType 1

Entities Mapping

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