Symfony Profiler

SELECT
  b0_.type AS type_0,
  b0_.apply_deadline AS apply_deadline_1,
  b0_.college_deadline AS college_deadline_2,
  b0_.id AS id_3,
  b0_.name AS name_4,
  b0_.open AS open_5
FROM
  batch b0_
WHERE
  b0_.open <= ?
  AND b0_.apply_deadline >= ?
ORDER BY
  b0_.open DESC

SELECT b0_.type AS type_0, b0_.apply_deadline AS apply_deadline_1, b0_.college_deadline AS college_deadline_2, b0_.id AS id_3, b0_.name AS name_4, b0_.open AS open_5 FROM batch b0_ WHERE b0_.open <= '2025-06-20 00:00:00' AND b0_.apply_deadline >= '2025-06-20 00:00:00' ORDER BY b0_.open DESC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.content AS content_2,
  a0_.published_at AS published_at_3,
  a0_.created_at AS created_at_4,
  a0_.updated_at AS updated_at_5,
  a0_.valid AS valid_6
FROM
  announcement a0_
WHERE
  a0_.valid = 1
ORDER BY
  a0_.published_at DESC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.content AS content_2, a0_.published_at AS published_at_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.valid AS valid_6 FROM announcement a0_ WHERE a0_.valid = 1 ORDER BY a0_.published_at DESC LIMIT 10;

SELECT
  t0.current AS current_1,
  t0.id AS id_2,
  t0.name AS name_3
FROM
  review_batch t0
WHERE
  t0.current = ?
LIMIT
  1

SELECT t0.current AS current_1, t0.id AS id_2, t0.name AS name_3 FROM review_batch t0 WHERE t0.current = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.published_at AS published_at_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.batch_id AS batch_id_7
FROM
  notice t0
WHERE
  t0.batch_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published_at AS published_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.batch_id AS batch_id_7 FROM notice t0 WHERE t0.batch_id = 36;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.published_at AS published_at_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.batch_id AS batch_id_7
FROM
  notice t0
WHERE
  t0.batch_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published_at AS published_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.batch_id AS batch_id_7 FROM notice t0 WHERE t0.batch_id = 35;