Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.year AS year_1,
  m0_.month AS month_2,
  m0_.selection_open_at AS selection_open_at_3,
  m0_.selection_lock_at AS selection_lock_at_4,
  m0_.shipped_at AS shipped_at_5,
  m0_.created_at AS created_at_6,
  m0_.updated_at AS updated_at_7
FROM
  monthly_cycle m0_
WHERE
  m0_.selection_open_at <= ?
  AND m0_.selection_lock_at > ?
ORDER BY
  m0_.year DESC,
  m0_.month DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.year AS year_1, m0_.month AS month_2, m0_.selection_open_at AS selection_open_at_3, m0_.selection_lock_at AS selection_lock_at_4, m0_.shipped_at AS shipped_at_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7 FROM monthly_cycle m0_ WHERE m0_.selection_open_at <= '2026-06-28 00:34:31' AND m0_.selection_lock_at > '2026-06-28 00:34:31' ORDER BY m0_.year DESC, m0_.month DESC LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.year AS year_1,
  m0_.month AS month_2,
  m0_.selection_open_at AS selection_open_at_3,
  m0_.selection_lock_at AS selection_lock_at_4,
  m0_.shipped_at AS shipped_at_5,
  m0_.created_at AS created_at_6,
  m0_.updated_at AS updated_at_7
FROM
  monthly_cycle m0_
WHERE
  m0_.selection_open_at > ?
ORDER BY
  m0_.selection_open_at ASC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.year AS year_1, m0_.month AS month_2, m0_.selection_open_at AS selection_open_at_3, m0_.selection_lock_at AS selection_lock_at_4, m0_.shipped_at AS shipped_at_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7 FROM monthly_cycle m0_ WHERE m0_.selection_open_at > '2026-06-28 00:34:31' ORDER BY m0_.selection_open_at ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.color AS color_4,
  t0.family AS family_5,
  t0.appellation AS appellation_6,
  t0.country AS country_7,
  t0.vintage AS vintage_8,
  t0.description AS description_9,
  t0.description_nl AS description_nl_10,
  t0.description_domain AS description_domain_11,
  t0.description_domain_nl AS description_domain_nl_12,
  t0.image_url AS image_url_13,
  t0.price_shop AS price_shop_14,
  t0.price_pro AS price_pro_15,
  t0.price_cost AS price_cost_16,
  t0.supplier_reference AS supplier_reference_17,
  t0.is_available_in_shop AS is_available_in_shop_18,
  t0.is_available_in_pro_catalog AS is_available_in_pro_catalog_19,
  t0.is_available_in_pro_premium_catalog AS is_available_in_pro_premium_catalog_20,
  t0.winevizer_data AS winevizer_data_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.region_id AS region_id_24
FROM
  wine t0
  INNER JOIN monthly_cycle_prestige_wine ON t0.id = monthly_cycle_prestige_wine.wine_id
WHERE
  monthly_cycle_prestige_wine.monthly_cycle_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.color AS color_4, t0.family AS family_5, t0.appellation AS appellation_6, t0.country AS country_7, t0.vintage AS vintage_8, t0.description AS description_9, t0.description_nl AS description_nl_10, t0.description_domain AS description_domain_11, t0.description_domain_nl AS description_domain_nl_12, t0.image_url AS image_url_13, t0.price_shop AS price_shop_14, t0.price_pro AS price_pro_15, t0.price_cost AS price_cost_16, t0.supplier_reference AS supplier_reference_17, t0.is_available_in_shop AS is_available_in_shop_18, t0.is_available_in_pro_catalog AS is_available_in_pro_catalog_19, t0.is_available_in_pro_premium_catalog AS is_available_in_pro_premium_catalog_20, t0.winevizer_data AS winevizer_data_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.region_id AS region_id_24 FROM wine t0 INNER JOIN monthly_cycle_prestige_wine ON t0.id = monthly_cycle_prestige_wine.wine_id WHERE monthly_cycle_prestige_wine.monthly_cycle_id = 3;

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.domain AS domain_2,
  w0_.color AS color_3,
  w0_.family AS family_4,
  w0_.appellation AS appellation_5,
  w0_.country AS country_6,
  w0_.vintage AS vintage_7,
  w0_.description AS description_8,
  w0_.description_nl AS description_nl_9,
  w0_.description_domain AS description_domain_10,
  w0_.description_domain_nl AS description_domain_nl_11,
  w0_.image_url AS image_url_12,
  w0_.price_shop AS price_shop_13,
  w0_.price_pro AS price_pro_14,
  w0_.price_cost AS price_cost_15,
  w0_.supplier_reference AS supplier_reference_16,
  w0_.is_available_in_shop AS is_available_in_shop_17,
  w0_.is_available_in_pro_catalog AS is_available_in_pro_catalog_18,
  w0_.is_available_in_pro_premium_catalog AS is_available_in_pro_premium_catalog_19,
  w0_.winevizer_data AS winevizer_data_20,
  w0_.created_at AS created_at_21,
  w0_.updated_at AS updated_at_22,
  l1_.id AS id_23,
  l1_.level AS level_24,
  l1_.name AS name_25,
  l1_.name_nl AS name_nl_26,
  l1_.slug AS slug_27,
  l1_.description AS description_28,
  l1_.description_nl AS description_nl_29,
  w0_.region_id AS region_id_30,
  l1_.country_id AS country_id_31,
  l1_.parent_region_id AS parent_region_id_32
FROM
  wine w0_
  LEFT JOIN location_region l1_ ON w0_.region_id = l1_.id
WHERE
  w0_.is_available_in_shop = 1
  AND w0_.price_shop >= ?
  AND w0_.price_shop < ?
ORDER BY
  w0_.updated_at DESC
LIMIT
  10

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.domain AS domain_2, w0_.color AS color_3, w0_.family AS family_4, w0_.appellation AS appellation_5, w0_.country AS country_6, w0_.vintage AS vintage_7, w0_.description AS description_8, w0_.description_nl AS description_nl_9, w0_.description_domain AS description_domain_10, w0_.description_domain_nl AS description_domain_nl_11, w0_.image_url AS image_url_12, w0_.price_shop AS price_shop_13, w0_.price_pro AS price_pro_14, w0_.price_cost AS price_cost_15, w0_.supplier_reference AS supplier_reference_16, w0_.is_available_in_shop AS is_available_in_shop_17, w0_.is_available_in_pro_catalog AS is_available_in_pro_catalog_18, w0_.is_available_in_pro_premium_catalog AS is_available_in_pro_premium_catalog_19, w0_.winevizer_data AS winevizer_data_20, w0_.created_at AS created_at_21, w0_.updated_at AS updated_at_22, l1_.id AS id_23, l1_.level AS level_24, l1_.name AS name_25, l1_.name_nl AS name_nl_26, l1_.slug AS slug_27, l1_.description AS description_28, l1_.description_nl AS description_nl_29, w0_.region_id AS region_id_30, l1_.country_id AS country_id_31, l1_.parent_region_id AS parent_region_id_32 FROM wine w0_ LEFT JOIN location_region l1_ ON w0_.region_id = l1_.id WHERE w0_.is_available_in_shop = 1 AND w0_.price_shop >= '30.00' AND w0_.price_shop < '100.00' ORDER BY w0_.updated_at DESC LIMIT 10;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.category AS category_3,
  n0_.status AS status_4,
  n0_.summary AS summary_5,
  n0_.body AS body_6,
  n0_.hero_image_url AS hero_image_url_7,
  n0_.author_name AS author_name_8,
  n0_.published_at AS published_at_9,
  n0_.meta_title AS meta_title_10,
  n0_.meta_description AS meta_description_11,
  n0_.created_at AS created_at_12,
  n0_.updated_at AS updated_at_13
FROM
  news_article n0_
WHERE
  n0_.status = ?
  AND (
    n0_.published_at IS NOT NULL
    AND n0_.published_at <= ?
  )
ORDER BY
  n0_.published_at DESC
LIMIT
  3

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.category AS category_3, n0_.status AS status_4, n0_.summary AS summary_5, n0_.body AS body_6, n0_.hero_image_url AS hero_image_url_7, n0_.author_name AS author_name_8, n0_.published_at AS published_at_9, n0_.meta_title AS meta_title_10, n0_.meta_description AS meta_description_11, n0_.created_at AS created_at_12, n0_.updated_at AS updated_at_13 FROM news_article n0_ WHERE n0_.status = 'published' AND (n0_.published_at IS NOT NULL AND n0_.published_at <= '2026-06-28 00:34:31') ORDER BY n0_.published_at DESC LIMIT 3;