Symfony Profiler

SELECT
  q0_.id AS id_0,
  q0_.sort_order AS sort_order_1,
  q0_.type AS type_2,
  q0_.created_at AS created_at_3,
  q0_.updated_at AS updated_at_4,
  q0_.deleted_at AS deleted_at_5,
  q0_.old_quote_id AS old_quote_id_6,
  q0_.display_date AS display_date_7,
  q0_.display_month AS display_month_8,
  q0_.display_day AS display_day_9,
  q0_.author_id AS author_id_10,
  q0_.book_id AS book_id_11,
  q0_.parent_quote_id AS parent_quote_id_12,
  q0_.created_by_id AS created_by_id_13
FROM
  quote q0_
  INNER JOIN author a1_ ON q0_.author_id = a1_.id
  LEFT JOIN author_translation a2_ ON a1_.id = a2_.author_id
WHERE
  q0_.display_date = ?
  AND q0_.deleted_at IS NULL
ORDER BY
  CASE WHEN a2_.name = ? THEN
    1
  ELSE
    0
  END ASC,
  q0_.id ASC

SELECT q0_.id AS id_0, q0_.sort_order AS sort_order_1, q0_.type AS type_2, q0_.created_at AS created_at_3, q0_.updated_at AS updated_at_4, q0_.deleted_at AS deleted_at_5, q0_.old_quote_id AS old_quote_id_6, q0_.display_date AS display_date_7, q0_.display_month AS display_month_8, q0_.display_day AS display_day_9, q0_.author_id AS author_id_10, q0_.book_id AS book_id_11, q0_.parent_quote_id AS parent_quote_id_12, q0_.created_by_id AS created_by_id_13 FROM quote q0_ INNER JOIN author a1_ ON q0_.author_id = a1_.id LEFT JOIN author_translation a2_ ON a1_.id = a2_.author_id WHERE q0_.display_date = '2026-05-06' AND q0_.deleted_at IS NULL ORDER BY CASE WHEN a2_.name = 'Unknown Author' THEN 1 ELSE 0 END ASC, q0_.id ASC;

SELECT
  q0_.id AS id_0,
  q0_.sort_order AS sort_order_1,
  q0_.type AS type_2,
  q0_.created_at AS created_at_3,
  q0_.updated_at AS updated_at_4,
  q0_.deleted_at AS deleted_at_5,
  q0_.old_quote_id AS old_quote_id_6,
  q0_.display_date AS display_date_7,
  q0_.display_month AS display_month_8,
  q0_.display_day AS display_day_9,
  q0_.author_id AS author_id_10,
  q0_.book_id AS book_id_11,
  q0_.parent_quote_id AS parent_quote_id_12,
  q0_.created_by_id AS created_by_id_13
FROM
  quote q0_
  INNER JOIN author a1_ ON q0_.author_id = a1_.id
  LEFT JOIN author_translation a2_ ON a1_.id = a2_.author_id
WHERE
  q0_.display_month = ?
  AND q0_.display_day = ?
  AND q0_.deleted_at IS NULL
ORDER BY
  CASE WHEN a2_.name = ? THEN
    1
  ELSE
    0
  END ASC,
  q0_.id ASC

SELECT q0_.id AS id_0, q0_.sort_order AS sort_order_1, q0_.type AS type_2, q0_.created_at AS created_at_3, q0_.updated_at AS updated_at_4, q0_.deleted_at AS deleted_at_5, q0_.old_quote_id AS old_quote_id_6, q0_.display_date AS display_date_7, q0_.display_month AS display_month_8, q0_.display_day AS display_day_9, q0_.author_id AS author_id_10, q0_.book_id AS book_id_11, q0_.parent_quote_id AS parent_quote_id_12, q0_.created_by_id AS created_by_id_13 FROM quote q0_ INNER JOIN author a1_ ON q0_.author_id = a1_.id LEFT JOIN author_translation a2_ ON a1_.id = a2_.author_id WHERE q0_.display_month = 5 AND q0_.display_day = 6 AND q0_.deleted_at IS NULL ORDER BY CASE WHEN a2_.name = 'Unknown Author' THEN 1 ELSE 0 END ASC, q0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.native_name AS native_name_4
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.native_name AS native_name_4 FROM language t0 WHERE t0.code = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.rotation_interval_seconds AS rotation_interval_seconds_2
FROM
  daily_quote_config t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.rotation_interval_seconds AS rotation_interval_seconds_2 FROM daily_quote_config t0 WHERE t0.id = 1;

SELECT
  a0_.id AS id_0,
  a0_.created_at AS created_at_1,
  a0_.updated_at AS updated_at_2,
  a0_.deleted_at AS deleted_at_3,
  a0_.birth_date AS birth_date_4,
  a0_.death_date AS death_date_5,
  a0_.old_tag_id AS old_tag_id_6,
  a0_.image_path AS image_path_7,
  a0_.is_translator AS is_translator_8,
  a0_.created_by_id AS created_by_id_9
FROM
  author a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.birth_date IS NOT NULL
  AND SUBSTRING(
    a0_.birth_date
    FROM
      6 FOR 5
  ) = ?

SELECT a0_.id AS id_0, a0_.created_at AS created_at_1, a0_.updated_at AS updated_at_2, a0_.deleted_at AS deleted_at_3, a0_.birth_date AS birth_date_4, a0_.death_date AS death_date_5, a0_.old_tag_id AS old_tag_id_6, a0_.image_path AS image_path_7, a0_.is_translator AS is_translator_8, a0_.created_by_id AS created_by_id_9 FROM author a0_ WHERE a0_.deleted_at IS NULL AND a0_.birth_date IS NOT NULL AND SUBSTRING(a0_.birth_date FROM 6 FOR 5) = '05-06';

SELECT
  t0.id AS id_1,
  t0.quote_translation_count AS quote_translation_count_2,
  t0.book_translation_count AS book_translation_count_3,
  t0.total_votes_received AS total_votes_received_4,
  t0.positive_votes_received AS positive_votes_received_5,
  t0.average_rating AS average_rating_6,
  t0.first_translation_date AS first_translation_date_7,
  t0.last_translation_date AS last_translation_date_8,
  t0.last_calculated_at AS last_calculated_at_9,
  t0.translator_id AS translator_id_10
FROM
  translator_statistics t0
WHERE
  t0.translator_id = ?

SELECT t0.id AS id_1, t0.quote_translation_count AS quote_translation_count_2, t0.book_translation_count AS book_translation_count_3, t0.total_votes_received AS total_votes_received_4, t0.positive_votes_received AS positive_votes_received_5, t0.average_rating AS average_rating_6, t0.first_translation_date AS first_translation_date_7, t0.last_translation_date AS last_translation_date_8, t0.last_calculated_at AS last_calculated_at_9, t0.translator_id AS translator_id_10 FROM translator_statistics t0 WHERE t0.translator_id = 367;

SELECT
  t0.id AS id_1,
  t0.quote_translation_count AS quote_translation_count_2,
  t0.book_translation_count AS book_translation_count_3,
  t0.total_votes_received AS total_votes_received_4,
  t0.positive_votes_received AS positive_votes_received_5,
  t0.average_rating AS average_rating_6,
  t0.first_translation_date AS first_translation_date_7,
  t0.last_translation_date AS last_translation_date_8,
  t0.last_calculated_at AS last_calculated_at_9,
  t0.translator_id AS translator_id_10
FROM
  translator_statistics t0
WHERE
  t0.translator_id = ?

SELECT t0.id AS id_1, t0.quote_translation_count AS quote_translation_count_2, t0.book_translation_count AS book_translation_count_3, t0.total_votes_received AS total_votes_received_4, t0.positive_votes_received AS positive_votes_received_5, t0.average_rating AS average_rating_6, t0.first_translation_date AS first_translation_date_7, t0.last_translation_date AS last_translation_date_8, t0.last_calculated_at AS last_calculated_at_9, t0.translator_id AS translator_id_10 FROM translator_statistics t0 WHERE t0.translator_id = 518;

SELECT
  t0.id AS id_1,
  t0.quote_translation_count AS quote_translation_count_2,
  t0.book_translation_count AS book_translation_count_3,
  t0.total_votes_received AS total_votes_received_4,
  t0.positive_votes_received AS positive_votes_received_5,
  t0.average_rating AS average_rating_6,
  t0.first_translation_date AS first_translation_date_7,
  t0.last_translation_date AS last_translation_date_8,
  t0.last_calculated_at AS last_calculated_at_9,
  t0.translator_id AS translator_id_10
FROM
  translator_statistics t0
WHERE
  t0.translator_id = ?

SELECT t0.id AS id_1, t0.quote_translation_count AS quote_translation_count_2, t0.book_translation_count AS book_translation_count_3, t0.total_votes_received AS total_votes_received_4, t0.positive_votes_received AS positive_votes_received_5, t0.average_rating AS average_rating_6, t0.first_translation_date AS first_translation_date_7, t0.last_translation_date AS last_translation_date_8, t0.last_calculated_at AS last_calculated_at_9, t0.translator_id AS translator_id_10 FROM translator_statistics t0 WHERE t0.translator_id = 578;

SELECT
  a0_.id AS id_0,
  a0_.created_at AS created_at_1,
  a0_.updated_at AS updated_at_2,
  a0_.deleted_at AS deleted_at_3,
  a0_.birth_date AS birth_date_4,
  a0_.death_date AS death_date_5,
  a0_.old_tag_id AS old_tag_id_6,
  a0_.image_path AS image_path_7,
  a0_.is_translator AS is_translator_8,
  a0_.created_by_id AS created_by_id_9
FROM
  author a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.death_date IS NOT NULL
  AND SUBSTRING(
    a0_.death_date
    FROM
      6 FOR 5
  ) = ?

SELECT a0_.id AS id_0, a0_.created_at AS created_at_1, a0_.updated_at AS updated_at_2, a0_.deleted_at AS deleted_at_3, a0_.birth_date AS birth_date_4, a0_.death_date AS death_date_5, a0_.old_tag_id AS old_tag_id_6, a0_.image_path AS image_path_7, a0_.is_translator AS is_translator_8, a0_.created_by_id AS created_by_id_9 FROM author a0_ WHERE a0_.deleted_at IS NULL AND a0_.death_date IS NOT NULL AND SUBSTRING(a0_.death_date FROM 6 FOR 5) = '05-06';

SELECT
  t0.id AS id_1,
  t0.quote_translation_count AS quote_translation_count_2,
  t0.book_translation_count AS book_translation_count_3,
  t0.total_votes_received AS total_votes_received_4,
  t0.positive_votes_received AS positive_votes_received_5,
  t0.average_rating AS average_rating_6,
  t0.first_translation_date AS first_translation_date_7,
  t0.last_translation_date AS last_translation_date_8,
  t0.last_calculated_at AS last_calculated_at_9,
  t0.translator_id AS translator_id_10
FROM
  translator_statistics t0
WHERE
  t0.translator_id = ?

SELECT t0.id AS id_1, t0.quote_translation_count AS quote_translation_count_2, t0.book_translation_count AS book_translation_count_3, t0.total_votes_received AS total_votes_received_4, t0.positive_votes_received AS positive_votes_received_5, t0.average_rating AS average_rating_6, t0.first_translation_date AS first_translation_date_7, t0.last_translation_date AS last_translation_date_8, t0.last_calculated_at AS last_calculated_at_9, t0.translator_id AS translator_id_10 FROM translator_statistics t0 WHERE t0.translator_id = 111;

SELECT
  t0.id AS id_1,
  t0.quote_translation_count AS quote_translation_count_2,
  t0.book_translation_count AS book_translation_count_3,
  t0.total_votes_received AS total_votes_received_4,
  t0.positive_votes_received AS positive_votes_received_5,
  t0.average_rating AS average_rating_6,
  t0.first_translation_date AS first_translation_date_7,
  t0.last_translation_date AS last_translation_date_8,
  t0.last_calculated_at AS last_calculated_at_9,
  t0.translator_id AS translator_id_10
FROM
  translator_statistics t0
WHERE
  t0.translator_id = ?

SELECT t0.id AS id_1, t0.quote_translation_count AS quote_translation_count_2, t0.book_translation_count AS book_translation_count_3, t0.total_votes_received AS total_votes_received_4, t0.positive_votes_received AS positive_votes_received_5, t0.average_rating AS average_rating_6, t0.first_translation_date AS first_translation_date_7, t0.last_translation_date AS last_translation_date_8, t0.last_calculated_at AS last_calculated_at_9, t0.translator_id AS translator_id_10 FROM translator_statistics t0 WHERE t0.translator_id = 142;

SELECT
  t0.id AS id_1,
  t0.quote_translation_count AS quote_translation_count_2,
  t0.book_translation_count AS book_translation_count_3,
  t0.total_votes_received AS total_votes_received_4,
  t0.positive_votes_received AS positive_votes_received_5,
  t0.average_rating AS average_rating_6,
  t0.first_translation_date AS first_translation_date_7,
  t0.last_translation_date AS last_translation_date_8,
  t0.last_calculated_at AS last_calculated_at_9,
  t0.translator_id AS translator_id_10
FROM
  translator_statistics t0
WHERE
  t0.translator_id = ?

SELECT t0.id AS id_1, t0.quote_translation_count AS quote_translation_count_2, t0.book_translation_count AS book_translation_count_3, t0.total_votes_received AS total_votes_received_4, t0.positive_votes_received AS positive_votes_received_5, t0.average_rating AS average_rating_6, t0.first_translation_date AS first_translation_date_7, t0.last_translation_date AS last_translation_date_8, t0.last_calculated_at AS last_calculated_at_9, t0.translator_id AS translator_id_10 FROM translator_statistics t0 WHERE t0.translator_id = 220;

SELECT
  q0_.id AS id_0,
  q0_.sort_order AS sort_order_1,
  q0_.type AS type_2,
  q0_.created_at AS created_at_3,
  q0_.updated_at AS updated_at_4,
  q0_.deleted_at AS deleted_at_5,
  q0_.old_quote_id AS old_quote_id_6,
  q0_.display_date AS display_date_7,
  q0_.display_month AS display_month_8,
  q0_.display_day AS display_day_9,
  q0_.author_id AS author_id_10,
  q0_.book_id AS book_id_11,
  q0_.parent_quote_id AS parent_quote_id_12,
  q0_.created_by_id AS created_by_id_13
FROM
  quote q0_
WHERE
  q0_.author_id = ?
  AND q0_.deleted_at IS NULL
LIMIT
  1

SELECT q0_.id AS id_0, q0_.sort_order AS sort_order_1, q0_.type AS type_2, q0_.created_at AS created_at_3, q0_.updated_at AS updated_at_4, q0_.deleted_at AS deleted_at_5, q0_.old_quote_id AS old_quote_id_6, q0_.display_date AS display_date_7, q0_.display_month AS display_month_8, q0_.display_day AS display_day_9, q0_.author_id AS author_id_10, q0_.book_id AS book_id_11, q0_.parent_quote_id AS parent_quote_id_12, q0_.created_by_id AS created_by_id_13 FROM quote q0_ WHERE q0_.author_id = 367 AND q0_.deleted_at IS NULL LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.sort_order AS sort_order_1,
  q0_.type AS type_2,
  q0_.created_at AS created_at_3,
  q0_.updated_at AS updated_at_4,
  q0_.deleted_at AS deleted_at_5,
  q0_.old_quote_id AS old_quote_id_6,
  q0_.display_date AS display_date_7,
  q0_.display_month AS display_month_8,
  q0_.display_day AS display_day_9,
  q0_.author_id AS author_id_10,
  q0_.book_id AS book_id_11,
  q0_.parent_quote_id AS parent_quote_id_12,
  q0_.created_by_id AS created_by_id_13
FROM
  quote q0_
WHERE
  q0_.author_id = ?
  AND q0_.deleted_at IS NULL
LIMIT
  1

SELECT q0_.id AS id_0, q0_.sort_order AS sort_order_1, q0_.type AS type_2, q0_.created_at AS created_at_3, q0_.updated_at AS updated_at_4, q0_.deleted_at AS deleted_at_5, q0_.old_quote_id AS old_quote_id_6, q0_.display_date AS display_date_7, q0_.display_month AS display_month_8, q0_.display_day AS display_day_9, q0_.author_id AS author_id_10, q0_.book_id AS book_id_11, q0_.parent_quote_id AS parent_quote_id_12, q0_.created_by_id AS created_by_id_13 FROM quote q0_ WHERE q0_.author_id = 518 AND q0_.deleted_at IS NULL LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.sort_order AS sort_order_1,
  q0_.type AS type_2,
  q0_.created_at AS created_at_3,
  q0_.updated_at AS updated_at_4,
  q0_.deleted_at AS deleted_at_5,
  q0_.old_quote_id AS old_quote_id_6,
  q0_.display_date AS display_date_7,
  q0_.display_month AS display_month_8,
  q0_.display_day AS display_day_9,
  q0_.author_id AS author_id_10,
  q0_.book_id AS book_id_11,
  q0_.parent_quote_id AS parent_quote_id_12,
  q0_.created_by_id AS created_by_id_13
FROM
  quote q0_
WHERE
  q0_.author_id = ?
  AND q0_.deleted_at IS NULL
LIMIT
  1

SELECT q0_.id AS id_0, q0_.sort_order AS sort_order_1, q0_.type AS type_2, q0_.created_at AS created_at_3, q0_.updated_at AS updated_at_4, q0_.deleted_at AS deleted_at_5, q0_.old_quote_id AS old_quote_id_6, q0_.display_date AS display_date_7, q0_.display_month AS display_month_8, q0_.display_day AS display_day_9, q0_.author_id AS author_id_10, q0_.book_id AS book_id_11, q0_.parent_quote_id AS parent_quote_id_12, q0_.created_by_id AS created_by_id_13 FROM quote q0_ WHERE q0_.author_id = 578 AND q0_.deleted_at IS NULL LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.sort_order AS sort_order_1,
  q0_.type AS type_2,
  q0_.created_at AS created_at_3,
  q0_.updated_at AS updated_at_4,
  q0_.deleted_at AS deleted_at_5,
  q0_.old_quote_id AS old_quote_id_6,
  q0_.display_date AS display_date_7,
  q0_.display_month AS display_month_8,
  q0_.display_day AS display_day_9,
  q0_.author_id AS author_id_10,
  q0_.book_id AS book_id_11,
  q0_.parent_quote_id AS parent_quote_id_12,
  q0_.created_by_id AS created_by_id_13
FROM
  quote q0_
WHERE
  q0_.author_id = ?
  AND q0_.deleted_at IS NULL
LIMIT
  1

SELECT q0_.id AS id_0, q0_.sort_order AS sort_order_1, q0_.type AS type_2, q0_.created_at AS created_at_3, q0_.updated_at AS updated_at_4, q0_.deleted_at AS deleted_at_5, q0_.old_quote_id AS old_quote_id_6, q0_.display_date AS display_date_7, q0_.display_month AS display_month_8, q0_.display_day AS display_day_9, q0_.author_id AS author_id_10, q0_.book_id AS book_id_11, q0_.parent_quote_id AS parent_quote_id_12, q0_.created_by_id AS created_by_id_13 FROM quote q0_ WHERE q0_.author_id = 111 AND q0_.deleted_at IS NULL LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.sort_order AS sort_order_1,
  q0_.type AS type_2,
  q0_.created_at AS created_at_3,
  q0_.updated_at AS updated_at_4,
  q0_.deleted_at AS deleted_at_5,
  q0_.old_quote_id AS old_quote_id_6,
  q0_.display_date AS display_date_7,
  q0_.display_month AS display_month_8,
  q0_.display_day AS display_day_9,
  q0_.author_id AS author_id_10,
  q0_.book_id AS book_id_11,
  q0_.parent_quote_id AS parent_quote_id_12,
  q0_.created_by_id AS created_by_id_13
FROM
  quote q0_
WHERE
  q0_.author_id = ?
  AND q0_.deleted_at IS NULL
LIMIT
  1

SELECT q0_.id AS id_0, q0_.sort_order AS sort_order_1, q0_.type AS type_2, q0_.created_at AS created_at_3, q0_.updated_at AS updated_at_4, q0_.deleted_at AS deleted_at_5, q0_.old_quote_id AS old_quote_id_6, q0_.display_date AS display_date_7, q0_.display_month AS display_month_8, q0_.display_day AS display_day_9, q0_.author_id AS author_id_10, q0_.book_id AS book_id_11, q0_.parent_quote_id AS parent_quote_id_12, q0_.created_by_id AS created_by_id_13 FROM quote q0_ WHERE q0_.author_id = 142 AND q0_.deleted_at IS NULL LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.sort_order AS sort_order_1,
  q0_.type AS type_2,
  q0_.created_at AS created_at_3,
  q0_.updated_at AS updated_at_4,
  q0_.deleted_at AS deleted_at_5,
  q0_.old_quote_id AS old_quote_id_6,
  q0_.display_date AS display_date_7,
  q0_.display_month AS display_month_8,
  q0_.display_day AS display_day_9,
  q0_.author_id AS author_id_10,
  q0_.book_id AS book_id_11,
  q0_.parent_quote_id AS parent_quote_id_12,
  q0_.created_by_id AS created_by_id_13
FROM
  quote q0_
WHERE
  q0_.author_id = ?
  AND q0_.deleted_at IS NULL
LIMIT
  1

SELECT q0_.id AS id_0, q0_.sort_order AS sort_order_1, q0_.type AS type_2, q0_.created_at AS created_at_3, q0_.updated_at AS updated_at_4, q0_.deleted_at AS deleted_at_5, q0_.old_quote_id AS old_quote_id_6, q0_.display_date AS display_date_7, q0_.display_month AS display_month_8, q0_.display_day AS display_day_9, q0_.author_id AS author_id_10, q0_.book_id AS book_id_11, q0_.parent_quote_id AS parent_quote_id_12, q0_.created_by_id AS created_by_id_13 FROM quote q0_ WHERE q0_.author_id = 220 AND q0_.deleted_at IS NULL LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.code AS code_1,
  l0_.name AS name_2,
  l0_.native_name AS native_name_3
FROM
  language l0_
  INNER JOIN quote_translation q1_ ON (q1_.language_id = l0_.id)
  INNER JOIN quote q2_ ON q1_.quote_id = q2_.id
WHERE
  q2_.deleted_at IS NULL
GROUP BY
  l0_.id
ORDER BY
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3 FROM language l0_ INNER JOIN quote_translation q1_ ON (q1_.language_id = l0_.id) INNER JOIN quote q2_ ON q1_.quote_id = q2_.id WHERE q2_.deleted_at IS NULL GROUP BY l0_.id ORDER BY l0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.title AS title_3,
  t0.variant AS variant_4,
  t0.vote_score AS vote_score_5,
  t0.comment_count AS comment_count_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.quote_id AS quote_id_9,
  t0.language_id AS language_id_10,
  t0.book_translation_id AS book_translation_id_11,
  t0.translator_id AS translator_id_12
FROM
  quote_translation t0
WHERE
  t0.quote_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.title AS title_3, t0.variant AS variant_4, t0.vote_score AS vote_score_5, t0.comment_count AS comment_count_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.quote_id AS quote_id_9, t0.language_id AS language_id_10, t0.book_translation_id AS book_translation_id_11, t0.translator_id AS translator_id_12 FROM quote_translation t0 WHERE t0.quote_id = 19658;