Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.primary_category AS primary_category_4
FROM
  shop_item_category t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.primary_category AS primary_category_4 FROM shop_item_category t0 WHERE t0.active = 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.price AS price_2,
  s0_.image AS image_3,
  s0_.summary AS summary_4,
  s0_.description AS description_5,
  COALESCE(
    MIN(s1_.count),
    s2_.count
  ) AS sclr_6
FROM
  shop_item s0_
  LEFT JOIN shop_item_shop_item s4_ ON s0_.id = s4_.shop_item_source
  LEFT JOIN shop_item s3_ ON s3_.id = s4_.shop_item_target
  LEFT JOIN shop_stock s2_ ON s0_.id = s2_.item_id
  LEFT JOIN shop_stock s1_ ON s3_.id = s1_.item_id
WHERE
  s0_.category_id = ?
  AND s0_.public = 1
GROUP BY
  s0_.id,
  s0_.name,
  s0_.price,
  s0_.image,
  s0_.summary,
  s0_.description,
  s2_.count

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2, s0_.image AS image_3, s0_.summary AS summary_4, s0_.description AS description_5, COALESCE(MIN(s1_.count), s2_.count) AS sclr_6 FROM shop_item s0_ LEFT JOIN shop_item_shop_item s4_ ON s0_.id = s4_.shop_item_source LEFT JOIN shop_item s3_ ON s3_.id = s4_.shop_item_target LEFT JOIN shop_stock s2_ ON s0_.id = s2_.item_id LEFT JOIN shop_stock s1_ ON s3_.id = s1_.item_id WHERE s0_.category_id = '1' AND s0_.public = 1 GROUP BY s0_.id, s0_.name, s0_.price, s0_.image, s0_.summary, s0_.description, s2_.count;

SELECT
  MIN(s0_.price) AS sclr_0
FROM
  shop_price_history s0_
WHERE
  s0_.item_id = ?
  AND s0_.updated_at >= ?

SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = 1 AND s0_.updated_at >= '2024-10-25 17:09:12';

SELECT
  s0_.id AS id_0,
  s0_.promotion_type AS promotion_type_1,
  s0_.value AS value_2,
  s0_.start_at AS start_at_3,
  s0_.expired_at AS expired_at_4,
  s0_.max_use AS max_use_5,
  s0_.item_id AS item_id_6
FROM
  shop_promotions s0_
WHERE
  s0_.item_id = ?
  AND s0_.start_at <= ?
  AND s0_.expired_at >= ?

SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = 1 AND s0_.start_at <= '2024-11-24 17:09:12' AND s0_.expired_at >= '2024-11-24 17:09:12';

SELECT
  MIN(s0_.price) AS sclr_0
FROM
  shop_price_history s0_
WHERE
  s0_.item_id = ?
  AND s0_.updated_at >= ?

SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = 2 AND s0_.updated_at >= '2024-10-25 17:09:12';

SELECT
  s0_.id AS id_0,
  s0_.promotion_type AS promotion_type_1,
  s0_.value AS value_2,
  s0_.start_at AS start_at_3,
  s0_.expired_at AS expired_at_4,
  s0_.max_use AS max_use_5,
  s0_.item_id AS item_id_6
FROM
  shop_promotions s0_
WHERE
  s0_.item_id = ?
  AND s0_.start_at <= ?
  AND s0_.expired_at >= ?

SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = 2 AND s0_.start_at <= '2024-11-24 17:09:12' AND s0_.expired_at >= '2024-11-24 17:09:12';

SELECT
  MIN(s0_.price) AS sclr_0
FROM
  shop_price_history s0_
WHERE
  s0_.item_id = ?
  AND s0_.updated_at >= ?

SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = 3 AND s0_.updated_at >= '2024-10-25 17:09:12';

SELECT
  s0_.id AS id_0,
  s0_.promotion_type AS promotion_type_1,
  s0_.value AS value_2,
  s0_.start_at AS start_at_3,
  s0_.expired_at AS expired_at_4,
  s0_.max_use AS max_use_5,
  s0_.item_id AS item_id_6
FROM
  shop_promotions s0_
WHERE
  s0_.item_id = ?
  AND s0_.start_at <= ?
  AND s0_.expired_at >= ?

SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = 3 AND s0_.start_at <= '2024-11-24 17:09:12' AND s0_.expired_at >= '2024-11-24 17:09:12';

SELECT
  MIN(s0_.price) AS sclr_0
FROM
  shop_price_history s0_
WHERE
  s0_.item_id = ?
  AND s0_.updated_at >= ?

SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = 4 AND s0_.updated_at >= '2024-10-25 17:09:12';

SELECT
  s0_.id AS id_0,
  s0_.promotion_type AS promotion_type_1,
  s0_.value AS value_2,
  s0_.start_at AS start_at_3,
  s0_.expired_at AS expired_at_4,
  s0_.max_use AS max_use_5,
  s0_.item_id AS item_id_6
FROM
  shop_promotions s0_
WHERE
  s0_.item_id = ?
  AND s0_.start_at <= ?
  AND s0_.expired_at >= ?

SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = 4 AND s0_.start_at <= '2024-11-24 17:09:12' AND s0_.expired_at >= '2024-11-24 17:09:12';

SELECT
  MIN(s0_.price) AS sclr_0
FROM
  shop_price_history s0_
WHERE
  s0_.item_id = ?
  AND s0_.updated_at >= ?

SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = 5 AND s0_.updated_at >= '2024-10-25 17:09:12';

SELECT
  s0_.id AS id_0,
  s0_.promotion_type AS promotion_type_1,
  s0_.value AS value_2,
  s0_.start_at AS start_at_3,
  s0_.expired_at AS expired_at_4,
  s0_.max_use AS max_use_5,
  s0_.item_id AS item_id_6
FROM
  shop_promotions s0_
WHERE
  s0_.item_id = ?
  AND s0_.start_at <= ?
  AND s0_.expired_at >= ?

SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = 5 AND s0_.start_at <= '2024-11-24 17:09:12' AND s0_.expired_at >= '2024-11-24 17:09:12';

SELECT
  MIN(s0_.price) AS sclr_0
FROM
  shop_price_history s0_
WHERE
  s0_.item_id = ?
  AND s0_.updated_at >= ?

SELECT MIN(s0_.price) AS sclr_0 FROM shop_price_history s0_ WHERE s0_.item_id = 6 AND s0_.updated_at >= '2024-10-25 17:09:12';

SELECT
  s0_.id AS id_0,
  s0_.promotion_type AS promotion_type_1,
  s0_.value AS value_2,
  s0_.start_at AS start_at_3,
  s0_.expired_at AS expired_at_4,
  s0_.max_use AS max_use_5,
  s0_.item_id AS item_id_6
FROM
  shop_promotions s0_
WHERE
  s0_.item_id = ?
  AND s0_.start_at <= ?
  AND s0_.expired_at >= ?

SELECT s0_.id AS id_0, s0_.promotion_type AS promotion_type_1, s0_.value AS value_2, s0_.start_at AS start_at_3, s0_.expired_at AS expired_at_4, s0_.max_use AS max_use_5, s0_.item_id AS item_id_6 FROM shop_promotions s0_ WHERE s0_.item_id = 6 AND s0_.start_at <= '2024-11-24 17:09:12' AND s0_.expired_at >= '2024-11-24 17:09:12';

SELECT
  t0.id AS id_1,
  t0.edition AS edition_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.current AS current_5,
  t0.main_graphic AS main_graphic_6,
  t0.short_description AS short_description_7,
  t0.public AS public_8,
  t9.id AS id_10,
  t9.address AS address_11,
  t9.city AS city_12,
  t9.map_link AS map_link_13,
  t9.public_transport AS public_transport_14,
  t9.parking_info AS parking_info_15,
  t9.train_station AS train_station_16,
  t9.additional_info AS additional_info_17,
  t9.festival_id AS festival_id_18
FROM
  festival t0
  LEFT JOIN festival_location t9 ON t9.festival_id = t0.id
WHERE
  t0.current = ?
  AND t0.public = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.edition AS edition_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.current AS current_5, t0.main_graphic AS main_graphic_6, t0.short_description AS short_description_7, t0.public AS public_8, t9.id AS id_10, t9.address AS address_11, t9.city AS city_12, t9.map_link AS map_link_13, t9.public_transport AS public_transport_14, t9.parking_info AS parking_info_15, t9.train_station AS train_station_16, t9.additional_info AS additional_info_17, t9.festival_id AS festival_id_18 FROM festival t0 LEFT JOIN festival_location t9 ON t9.festival_id = t0.id WHERE t0.current = 1 AND t0.public = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.index_position AS index_position_3,
  t0.route AS route_4,
  t0.type AS type_5,
  t0.slug AS slug_6,
  t0.in_footer AS in_footer_7,
  t0.parent_id AS parent_id_8
FROM
  menu_item t0
ORDER BY
  t0.index_position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.index_position AS index_position_3, t0.route AS route_4, t0.type AS type_5, t0.slug AS slug_6, t0.in_footer AS in_footer_7, t0.parent_id AS parent_id_8 FROM menu_item t0 ORDER BY t0.index_position ASC;

SELECT
  t0.id AS id_1,
  t0.additional_text AS additional_text_2,
  t0.active AS active_3
FROM
  footer t0
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.additional_text AS additional_text_2, t0.active AS active_3 FROM footer t0 WHERE t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.index_position AS index_position_3,
  t0.route AS route_4,
  t0.type AS type_5,
  t0.slug AS slug_6,
  t0.in_footer AS in_footer_7,
  t0.parent_id AS parent_id_8
FROM
  menu_item t0
WHERE
  t0.in_footer = ?
ORDER BY
  t0.index_position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.index_position AS index_position_3, t0.route AS route_4, t0.type AS type_5, t0.slug AS slug_6, t0.in_footer AS in_footer_7, t0.parent_id AS parent_id_8 FROM menu_item t0 WHERE t0.in_footer = 1 ORDER BY t0.index_position ASC;