Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.author_id AS author_id_5,
  t0.created_by_id AS created_by_id_6
FROM
  book t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.author_id AS author_id_5, t0.created_by_id AS created_by_id_6 FROM book t0 WHERE t0.id = '2';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_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.book_id AS book_id_9,
  t0.language_id AS language_id_10,
  t0.translator_id AS translator_id_11
FROM
  book_translation t0
WHERE
  t0.book_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_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.book_id AS book_id_9, t0.language_id AS language_id_10, t0.translator_id AS translator_id_11 FROM book_translation t0 WHERE t0.book_id = 2;

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 quote_translation q1_ ON q0_.id = q1_.quote_id
WHERE
  q1_.book_translation_id = ?
  AND q0_.parent_quote_id IS NULL
  AND q0_.deleted_at IS NULL
ORDER BY
  q0_.sort_order ASC,
  q0_.created_at 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 quote_translation q1_ ON q0_.id = q1_.quote_id WHERE q1_.book_translation_id = 15 AND q0_.parent_quote_id IS NULL AND q0_.deleted_at IS NULL ORDER BY q0_.sort_order ASC, q0_.created_at ASC;

SELECT
  t0_.id AS id_0,
  t0_.translation_type AS translation_type_1,
  t0_.translation_id AS translation_id_2,
  t0_.content AS content_3,
  t0_.is_resolved AS is_resolved_4,
  t0_.created_at AS created_at_5,
  t0_.updated_at AS updated_at_6,
  t0_.author_id AS author_id_7
FROM
  translation_comment t0_
WHERE
  t0_.translation_type = ?
  AND t0_.translation_id = ?
ORDER BY
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.translation_type AS translation_type_1, t0_.translation_id AS translation_id_2, t0_.content AS content_3, t0_.is_resolved AS is_resolved_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.author_id AS author_id_7 FROM translation_comment t0_ WHERE t0_.translation_type = 'book' AND t0_.translation_id = 15 ORDER BY t0_.created_at DESC;

SELECT
  COUNT(t0_.id) AS sclr_0,
  SUM(
    CASE WHEN t0_.vote_value = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN t0_.vote_value = -1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(t0_.vote_value) AS sclr_3
FROM
  translation_vote t0_
WHERE
  t0_.translation_type = ?
  AND t0_.translation_id = ?

SELECT COUNT(t0_.id) AS sclr_0, SUM(CASE WHEN t0_.vote_value = 1 THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN t0_.vote_value = -1 THEN 1 ELSE 0 END) AS sclr_2, SUM(t0_.vote_value) AS sclr_3 FROM translation_vote t0_ WHERE t0_.translation_type = 'book' AND t0_.translation_id = 15;

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.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.birth_date AS birth_date_5,
  t0.death_date AS death_date_6,
  t0.old_tag_id AS old_tag_id_7,
  t0.image_path AS image_path_8,
  t0.is_translator AS is_translator_9,
  t0.created_by_id AS created_by_id_10,
  t11.id AS id_12,
  t11.quote_translation_count AS quote_translation_count_13,
  t11.book_translation_count AS book_translation_count_14,
  t11.total_votes_received AS total_votes_received_15,
  t11.positive_votes_received AS positive_votes_received_16,
  t11.average_rating AS average_rating_17,
  t11.first_translation_date AS first_translation_date_18,
  t11.last_translation_date AS last_translation_date_19,
  t11.last_calculated_at AS last_calculated_at_20,
  t11.translator_id AS translator_id_21
FROM
  author t0
  LEFT JOIN translator_statistics t11 ON t11.translator_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.birth_date AS birth_date_5, t0.death_date AS death_date_6, t0.old_tag_id AS old_tag_id_7, t0.image_path AS image_path_8, t0.is_translator AS is_translator_9, t0.created_by_id AS created_by_id_10, t11.id AS id_12, t11.quote_translation_count AS quote_translation_count_13, t11.book_translation_count AS book_translation_count_14, t11.total_votes_received AS total_votes_received_15, t11.positive_votes_received AS positive_votes_received_16, t11.average_rating AS average_rating_17, t11.first_translation_date AS first_translation_date_18, t11.last_translation_date AS last_translation_date_19, t11.last_calculated_at AS last_calculated_at_20, t11.translator_id AS translator_id_21 FROM author t0 LEFT JOIN translator_statistics t11 ON t11.translator_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.biography AS biography_3,
  t0.author_id AS author_id_4,
  t0.language_id AS language_id_5
FROM
  author_translation t0
WHERE
  t0.author_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.biography AS biography_3, t0.author_id AS author_id_4, t0.language_id AS language_id_5 FROM author_translation t0 WHERE t0.author_id = 1;

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 = 3;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4
FROM
  tag t0
  INNER JOIN quote_tags ON t0.id = quote_tags.tag_id
WHERE
  quote_tags.quote_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4 FROM tag t0 INNER JOIN quote_tags ON t0.id = quote_tags.tag_id WHERE quote_tags.quote_id = 3;

SELECT
  t0.id AS id_1,
  t0.audio_path AS audio_path_2,
  t0.extension AS extension_3,
  t0.file_size AS file_size_4,
  t0.duration AS duration_5,
  t0.created_at AS created_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.quote_translation_id AS quote_translation_id_8,
  t0.speaker_id AS speaker_id_9
FROM
  quote_audio t0
WHERE
  t0.quote_translation_id = ?

SELECT t0.id AS id_1, t0.audio_path AS audio_path_2, t0.extension AS extension_3, t0.file_size AS file_size_4, t0.duration AS duration_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.quote_translation_id AS quote_translation_id_8, t0.speaker_id AS speaker_id_9 FROM quote_audio t0 WHERE t0.quote_translation_id = 977;

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 = 4;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4
FROM
  tag t0
  INNER JOIN quote_tags ON t0.id = quote_tags.tag_id
WHERE
  quote_tags.quote_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4 FROM tag t0 INNER JOIN quote_tags ON t0.id = quote_tags.tag_id WHERE quote_tags.quote_id = 4;

SELECT
  t0.id AS id_1,
  t0.audio_path AS audio_path_2,
  t0.extension AS extension_3,
  t0.file_size AS file_size_4,
  t0.duration AS duration_5,
  t0.created_at AS created_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.quote_translation_id AS quote_translation_id_8,
  t0.speaker_id AS speaker_id_9
FROM
  quote_audio t0
WHERE
  t0.quote_translation_id = ?

SELECT t0.id AS id_1, t0.audio_path AS audio_path_2, t0.extension AS extension_3, t0.file_size AS file_size_4, t0.duration AS duration_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.quote_translation_id AS quote_translation_id_8, t0.speaker_id AS speaker_id_9 FROM quote_audio t0 WHERE t0.quote_translation_id = 978;

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 = 5;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4
FROM
  tag t0
  INNER JOIN quote_tags ON t0.id = quote_tags.tag_id
WHERE
  quote_tags.quote_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4 FROM tag t0 INNER JOIN quote_tags ON t0.id = quote_tags.tag_id WHERE quote_tags.quote_id = 5;

SELECT
  t0.id AS id_1,
  t0.audio_path AS audio_path_2,
  t0.extension AS extension_3,
  t0.file_size AS file_size_4,
  t0.duration AS duration_5,
  t0.created_at AS created_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.quote_translation_id AS quote_translation_id_8,
  t0.speaker_id AS speaker_id_9
FROM
  quote_audio t0
WHERE
  t0.quote_translation_id = ?

SELECT t0.id AS id_1, t0.audio_path AS audio_path_2, t0.extension AS extension_3, t0.file_size AS file_size_4, t0.duration AS duration_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.quote_translation_id AS quote_translation_id_8, t0.speaker_id AS speaker_id_9 FROM quote_audio t0 WHERE t0.quote_translation_id = 979;

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 = 6;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4
FROM
  tag t0
  INNER JOIN quote_tags ON t0.id = quote_tags.tag_id
WHERE
  quote_tags.quote_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4 FROM tag t0 INNER JOIN quote_tags ON t0.id = quote_tags.tag_id WHERE quote_tags.quote_id = 6;

SELECT
  t0.id AS id_1,
  t0.audio_path AS audio_path_2,
  t0.extension AS extension_3,
  t0.file_size AS file_size_4,
  t0.duration AS duration_5,
  t0.created_at AS created_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.quote_translation_id AS quote_translation_id_8,
  t0.speaker_id AS speaker_id_9
FROM
  quote_audio t0
WHERE
  t0.quote_translation_id = ?

SELECT t0.id AS id_1, t0.audio_path AS audio_path_2, t0.extension AS extension_3, t0.file_size AS file_size_4, t0.duration AS duration_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.quote_translation_id AS quote_translation_id_8, t0.speaker_id AS speaker_id_9 FROM quote_audio t0 WHERE t0.quote_translation_id = 980;