Symfony Profiler

SELECT
  t0.starts_at AS starts_at_1,
  t0.stops_at AS stops_at_2,
  t0.type AS type_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.enabled AS enabled_6,
  t0.created_by AS created_by_7
FROM
  business_week t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.starts_at AS starts_at_1, t0.stops_at AS stops_at_2, t0.type AS type_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.enabled AS enabled_6, t0.created_by AS created_by_7 FROM business_week t0 WHERE t0.type = 'TYPE_NORMAL' LIMIT 1;

SELECT
  *
FROM
  business_week
WHERE
  business_week.type = "TYPE_EXCEPTIONS"
  AND business_week.enabled = 1
  AND (
    (
      business_week.starts_at BETWEEN "2026-02-23 00:00:00"
      AND "2026-04-06 23:59:59"
    )
    OR (
      business_week.stops_at BETWEEN "2026-02-23 00:00:00"
      AND "2026-04-06 23:59:59"
    )
    OR (
      "2026-02-23 00:00:00" BETWEEN business_week.starts_at
      AND business_week.stops_at
    )
    OR (
      "2026-04-06 23:59:59" BETWEEN business_week.starts_at
      AND business_week.stops_at
    )
  )

SELECT *
            FROM business_week
            WHERE business_week.type = "TYPE_EXCEPTIONS"
            AND business_week.enabled = 1
            AND (
                (business_week.starts_at BETWEEN "2026-02-23 00:00:00" AND "2026-04-06 23:59:59")
                OR (business_week.stops_at BETWEEN "2026-02-23 00:00:00" AND "2026-04-06 23:59:59")
                OR ("2026-02-23 00:00:00" BETWEEN business_week.starts_at AND business_week.stops_at)
                OR ("2026-04-06 23:59:59" BETWEEN business_week.starts_at AND business_week.stops_at)
            );

SELECT
  *
FROM
  business_week
WHERE
  business_week.type = "TYPE_CLOSING"
  AND business_week.enabled = 1
  AND (
    (
      business_week.starts_at BETWEEN "2026-02-23 00:00:00"
      AND "2026-04-06 23:59:59"
    )
    OR (
      business_week.stops_at BETWEEN "2026-02-23 00:00:00"
      AND "2026-04-06 23:59:59"
    )
    OR (
      "2026-02-23 00:00:00" BETWEEN business_week.starts_at
      AND business_week.stops_at
    )
    OR (
      "2026-04-06 23:59:59" BETWEEN business_week.starts_at
      AND business_week.stops_at
    )
  )

SELECT *
            FROM business_week
            WHERE business_week.type = "TYPE_CLOSING"
            AND business_week.enabled = 1
            AND (
                (business_week.starts_at BETWEEN "2026-02-23 00:00:00" AND "2026-04-06 23:59:59")
                OR (business_week.stops_at BETWEEN "2026-02-23 00:00:00" AND "2026-04-06 23:59:59")
                OR ("2026-02-23 00:00:00" BETWEEN business_week.starts_at AND business_week.stops_at)
                OR ("2026-04-06 23:59:59" BETWEEN business_week.starts_at AND business_week.stops_at)
            );

SELECT
  t0.day_of_week AS day_of_week_1,
  t0.id AS id_2,
  t0.week_id AS week_id_3
FROM
  business_day t0
WHERE
  t0.week_id = ?
ORDER BY
  t0.day_of_week ASC

SELECT t0.day_of_week AS day_of_week_1, t0.id AS id_2, t0.week_id AS week_id_3 FROM business_day t0 WHERE t0.week_id = 61 ORDER BY t0.day_of_week ASC;

SELECT
  t0.starts_at AS starts_at_1,
  t0.stops_at AS stops_at_2,
  t0.id AS id_3,
  t0.day_id AS day_id_4
FROM
  business_hours t0
WHERE
  t0.day_id = ?
ORDER BY
  t0.starts_at ASC

SELECT t0.starts_at AS starts_at_1, t0.stops_at AS stops_at_2, t0.id AS id_3, t0.day_id AS day_id_4 FROM business_hours t0 WHERE t0.day_id = 61 ORDER BY t0.starts_at ASC;

SELECT
  t0.starts_at AS starts_at_1,
  t0.stops_at AS stops_at_2,
  t0.id AS id_3,
  t0.day_id AS day_id_4
FROM
  business_hours t0
WHERE
  t0.day_id = ?
ORDER BY
  t0.starts_at ASC

SELECT t0.starts_at AS starts_at_1, t0.stops_at AS stops_at_2, t0.id AS id_3, t0.day_id AS day_id_4 FROM business_hours t0 WHERE t0.day_id = 62 ORDER BY t0.starts_at ASC;

SELECT
  t0.starts_at AS starts_at_1,
  t0.stops_at AS stops_at_2,
  t0.id AS id_3,
  t0.day_id AS day_id_4
FROM
  business_hours t0
WHERE
  t0.day_id = ?
ORDER BY
  t0.starts_at ASC

SELECT t0.starts_at AS starts_at_1, t0.stops_at AS stops_at_2, t0.id AS id_3, t0.day_id AS day_id_4 FROM business_hours t0 WHERE t0.day_id = 63 ORDER BY t0.starts_at ASC;

SELECT
  t0.starts_at AS starts_at_1,
  t0.stops_at AS stops_at_2,
  t0.id AS id_3,
  t0.day_id AS day_id_4
FROM
  business_hours t0
WHERE
  t0.day_id = ?
ORDER BY
  t0.starts_at ASC

SELECT t0.starts_at AS starts_at_1, t0.stops_at AS stops_at_2, t0.id AS id_3, t0.day_id AS day_id_4 FROM business_hours t0 WHERE t0.day_id = 64 ORDER BY t0.starts_at ASC;

SELECT
  t0.starts_at AS starts_at_1,
  t0.stops_at AS stops_at_2,
  t0.id AS id_3,
  t0.day_id AS day_id_4
FROM
  business_hours t0
WHERE
  t0.day_id = ?
ORDER BY
  t0.starts_at ASC

SELECT t0.starts_at AS starts_at_1, t0.stops_at AS stops_at_2, t0.id AS id_3, t0.day_id AS day_id_4 FROM business_hours t0 WHERE t0.day_id = 65 ORDER BY t0.starts_at ASC;

SELECT
  t0.starts_at AS starts_at_1,
  t0.stops_at AS stops_at_2,
  t0.id AS id_3,
  t0.day_id AS day_id_4
FROM
  business_hours t0
WHERE
  t0.day_id = ?
ORDER BY
  t0.starts_at ASC

SELECT t0.starts_at AS starts_at_1, t0.stops_at AS stops_at_2, t0.id AS id_3, t0.day_id AS day_id_4 FROM business_hours t0 WHERE t0.day_id = 66 ORDER BY t0.starts_at ASC;

SELECT
  t0.starts_at AS starts_at_1,
  t0.stops_at AS stops_at_2,
  t0.id AS id_3,
  t0.day_id AS day_id_4
FROM
  business_hours t0
WHERE
  t0.day_id = ?
ORDER BY
  t0.starts_at ASC

SELECT t0.starts_at AS starts_at_1, t0.stops_at AS stops_at_2, t0.id AS id_3, t0.day_id AS day_id_4 FROM business_hours t0 WHERE t0.day_id = 67 ORDER BY t0.starts_at ASC;