Symfony Profiler

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 = ?

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 = 1;

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

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 = 'address_ofici' LIMIT 1;

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 = ?

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 = 1;

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

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 = 1 ORDER BY t0.id DESC LIMIT 10;

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

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 = 'active' AND p1_.end_date > '2026-07-03 03:15:34' ORDER BY p1_.end_date ASC LIMIT 10;

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 = ?

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 = 1;

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

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;

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

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;

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

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;

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

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;