GET https://mtsexotique.cloud/

Query Metrics

30 Database Queries
10 Different statements
12.19 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.99 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.extra AS extra_3, t0.slug AS slug_4, t0.description AS description_5, t0.origin AS origin_6, t0.price AS price_7, t0.stock AS stock_8, t0.hiboutik_reference AS hiboutik_reference_9, t0.weight AS weight_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.reference AS reference_13, t0.status AS status_14, t0.is_mts_product AS is_mts_product_15, t0.is_featured AS is_featured_16, t0.long_distance_delivery AS long_distance_delivery_17, t0.brand_id AS brand_id_18, t0.category_id AS category_id_19, t0.subcategory_id AS subcategory_id_20 FROM product t0 WHERE t0.is_mts_product = ? ORDER BY t0.id DESC LIMIT 10
Parameters:
[
  1
]
2 0.74 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.hiboutik_reference AS hiboutik_reference_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14, p0_.is_featured AS is_featured_15, p0_.long_distance_delivery AS long_distance_delivery_16, p0_.brand_id AS brand_id_17, p0_.category_id AS category_id_18, p0_.subcategory_id AS subcategory_id_19 FROM product p0_ INNER JOIN promotion p1_ ON p0_.id = p1_.product_id WHERE p1_.status = ? AND p1_.end_date > ? ORDER BY p1_.end_date ASC LIMIT 10
Parameters:
[
  "active"
  "2026-07-03 03:15:34"
]
3 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.extra AS extra_3, t0.slug AS slug_4, t0.description AS description_5, t0.origin AS origin_6, t0.price AS price_7, t0.stock AS stock_8, t0.hiboutik_reference AS hiboutik_reference_9, t0.weight AS weight_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.reference AS reference_13, t0.status AS status_14, t0.is_mts_product AS is_mts_product_15, t0.is_featured AS is_featured_16, t0.long_distance_delivery AS long_distance_delivery_17, t0.brand_id AS brand_id_18, t0.category_id AS category_id_19, t0.subcategory_id AS subcategory_id_20 FROM product t0 WHERE t0.is_featured = ?
Parameters:
[
  1
]
4 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.cover AS cover_3, t0.posted_at AS posted_at_4, t0.slug AS slug_5, t0.persons AS persons_6, t0.level AS level_7, t0.video AS video_8, t0.category AS category_9, t0.cooking_time AS cooking_time_10, t0.description AS description_11 FROM recipe t0 ORDER BY t0.id DESC LIMIT 4
Parameters:
[]
5 0.34 ms
SELECT t0.id AS id_1, t0.img AS img_2, t0.link AS link_3, t0.position AS position_4, t0.created_at AS created_at_5 FROM slider t0 ORDER BY t0.position ASC
Parameters:
[]
6 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.created_at AS created_at_4 FROM actuality t0 ORDER BY t0.id DESC LIMIT 3
Parameters:
[]
7 0.31 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "address_ofici"
]
8 0.35 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "contact_email"
]
9 0.24 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "contact_phone"
]
10 0.25 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "facebook_link"
]
11 0.31 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "instagram_link"
]
12 0.23 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "linkedin_link"
]
13 0.28 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "x_link"
]
14 0.33 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "tiktok_link"
]
15 0.28 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "youtube_link"
]
16 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 ORDER BY t0.position ASC
Parameters:
[]
17 0.46 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.final_price AS final_price_4, t0.end_date AS end_date_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.ended_at AS ended_at_8, t0.product_id AS product_id_9, t0.created_by_id AS created_by_id_10, t0.ended_by_id AS ended_by_id_11 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
18 0.41 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
19 0.60 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.final_price AS final_price_4, t0.end_date AS end_date_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.ended_at AS ended_at_8, t0.product_id AS product_id_9, t0.created_by_id AS created_by_id_10, t0.ended_by_id AS ended_by_id_11 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
20 0.33 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
21 0.57 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.final_price AS final_price_4, t0.end_date AS end_date_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.ended_at AS ended_at_8, t0.product_id AS product_id_9, t0.created_by_id AS created_by_id_10, t0.ended_by_id AS ended_by_id_11 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
22 0.29 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
23 0.43 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.final_price AS final_price_4, t0.end_date AS end_date_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.ended_at AS ended_at_8, t0.product_id AS product_id_9, t0.created_by_id AS created_by_id_10, t0.ended_by_id AS ended_by_id_11 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
  8
]
24 0.25 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
  8
]
25 0.34 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.final_price AS final_price_4, t0.end_date AS end_date_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.ended_at AS ended_at_8, t0.product_id AS product_id_9, t0.created_by_id AS created_by_id_10, t0.ended_by_id AS ended_by_id_11 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
  9
]
26 0.28 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
  9
]
27 0.90 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.final_price AS final_price_4, t0.end_date AS end_date_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.ended_at AS ended_at_8, t0.product_id AS product_id_9, t0.created_by_id AS created_by_id_10, t0.ended_by_id AS ended_by_id_11 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
28 0.41 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
29 0.50 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.percentage AS percentage_3, t0.final_price AS final_price_4, t0.end_date AS end_date_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.ended_at AS ended_at_8, t0.product_id AS product_id_9, t0.created_by_id AS created_by_id_10, t0.ended_by_id AS ended_by_id_11 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
30 0.32 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
  3
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\Brand No errors.
App\Entity\Category No errors.
App\Entity\Subcategory No errors.
App\Entity\Image No errors.
App\Entity\Promotion No errors.
App\Entity\OrderItem No errors.
App\Entity\Recipe No errors.
App\Entity\Step No errors.
App\Entity\Ingredient No errors.
App\Entity\Slider No errors.
App\Entity\Actuality No errors.
App\Entity\SiteSetting No errors.
App\Entity\User No errors.
App\Entity\Admin No errors.