Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.author_id AS author_id_4,
  t0.LyricYYYY AS LyricYYYY_5,
  t0.composer_id AS composer_id_6,
  t0.MusicYYYY AS MusicYYYY_7,
  t0.arranger_id AS arranger_id_8,
  t0.ArrangedYYYY AS ArrangedYYYY_9,
  t0.type_id AS type_id_10,
  t0.OtherNotes AS OtherNotes_11,
  t0.text AS text_12,
  t0.copyright AS copyright_13,
  t0.score_page_count AS score_page_count_14,
  t0.hymn_hit_count AS hymn_hit_count_15,
  t0.last_accessed AS last_accessed_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.type_id AS type_id_19,
  t0.author_id AS author_id_20,
  t0.composer_id AS composer_id_21,
  t0.arranger_id AS arranger_id_22
FROM
  hymns t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.author_id AS author_id_4, t0.LyricYYYY AS LyricYYYY_5, t0.composer_id AS composer_id_6, t0.MusicYYYY AS MusicYYYY_7, t0.arranger_id AS arranger_id_8, t0.ArrangedYYYY AS ArrangedYYYY_9, t0.type_id AS type_id_10, t0.OtherNotes AS OtherNotes_11, t0.text AS text_12, t0.copyright AS copyright_13, t0.score_page_count AS score_page_count_14, t0.hymn_hit_count AS hymn_hit_count_15, t0.last_accessed AS last_accessed_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.type_id AS type_id_19, t0.author_id AS author_id_20, t0.composer_id AS composer_id_21, t0.arranger_id AS arranger_id_22 FROM hymns t0 WHERE t0.slug = 'there-is-a-region-lovelier-far' LIMIT 1;

SELECT
  h0_.id AS id_0,
  h0_.title AS title_1,
  h0_.slug AS slug_2,
  h0_.author_id AS author_id_3,
  h0_.LyricYYYY AS LyricYYYY_4,
  h0_.composer_id AS composer_id_5,
  h0_.MusicYYYY AS MusicYYYY_6,
  h0_.arranger_id AS arranger_id_7,
  h0_.ArrangedYYYY AS ArrangedYYYY_8,
  h0_.type_id AS type_id_9,
  h0_.OtherNotes AS OtherNotes_10,
  h0_.text AS text_11,
  h0_.copyright AS copyright_12,
  h0_.score_page_count AS score_page_count_13,
  h0_.hymn_hit_count AS hymn_hit_count_14,
  h0_.last_accessed AS last_accessed_15,
  h0_.created_at AS created_at_16,
  h0_.updated_at AS updated_at_17,
  h0_.type_id AS type_id_18,
  h0_.author_id AS author_id_19,
  h0_.composer_id AS composer_id_20,
  h0_.arranger_id AS arranger_id_21
FROM
  hymns h0_
WHERE
  h0_.type_id = ?
  AND h0_.title < ?
ORDER BY
  h0_.title DESC
LIMIT
  1

SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.slug AS slug_2, h0_.author_id AS author_id_3, h0_.LyricYYYY AS LyricYYYY_4, h0_.composer_id AS composer_id_5, h0_.MusicYYYY AS MusicYYYY_6, h0_.arranger_id AS arranger_id_7, h0_.ArrangedYYYY AS ArrangedYYYY_8, h0_.type_id AS type_id_9, h0_.OtherNotes AS OtherNotes_10, h0_.text AS text_11, h0_.copyright AS copyright_12, h0_.score_page_count AS score_page_count_13, h0_.hymn_hit_count AS hymn_hit_count_14, h0_.last_accessed AS last_accessed_15, h0_.created_at AS created_at_16, h0_.updated_at AS updated_at_17, h0_.type_id AS type_id_18, h0_.author_id AS author_id_19, h0_.composer_id AS composer_id_20, h0_.arranger_id AS arranger_id_21 FROM hymns h0_ WHERE h0_.type_id = 1 AND h0_.title < 'There Is A Region Lovelier Far' ORDER BY h0_.title DESC LIMIT 1;

SELECT
  h0_.id AS id_0,
  h0_.title AS title_1,
  h0_.slug AS slug_2,
  h0_.author_id AS author_id_3,
  h0_.LyricYYYY AS LyricYYYY_4,
  h0_.composer_id AS composer_id_5,
  h0_.MusicYYYY AS MusicYYYY_6,
  h0_.arranger_id AS arranger_id_7,
  h0_.ArrangedYYYY AS ArrangedYYYY_8,
  h0_.type_id AS type_id_9,
  h0_.OtherNotes AS OtherNotes_10,
  h0_.text AS text_11,
  h0_.copyright AS copyright_12,
  h0_.score_page_count AS score_page_count_13,
  h0_.hymn_hit_count AS hymn_hit_count_14,
  h0_.last_accessed AS last_accessed_15,
  h0_.created_at AS created_at_16,
  h0_.updated_at AS updated_at_17,
  h0_.type_id AS type_id_18,
  h0_.author_id AS author_id_19,
  h0_.composer_id AS composer_id_20,
  h0_.arranger_id AS arranger_id_21
FROM
  hymns h0_
WHERE
  h0_.type_id = ?
  AND h0_.title > ?
ORDER BY
  h0_.title ASC
LIMIT
  1

SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.slug AS slug_2, h0_.author_id AS author_id_3, h0_.LyricYYYY AS LyricYYYY_4, h0_.composer_id AS composer_id_5, h0_.MusicYYYY AS MusicYYYY_6, h0_.arranger_id AS arranger_id_7, h0_.ArrangedYYYY AS ArrangedYYYY_8, h0_.type_id AS type_id_9, h0_.OtherNotes AS OtherNotes_10, h0_.text AS text_11, h0_.copyright AS copyright_12, h0_.score_page_count AS score_page_count_13, h0_.hymn_hit_count AS hymn_hit_count_14, h0_.last_accessed AS last_accessed_15, h0_.created_at AS created_at_16, h0_.updated_at AS updated_at_17, h0_.type_id AS type_id_18, h0_.author_id AS author_id_19, h0_.composer_id AS composer_id_20, h0_.arranger_id AS arranger_id_21 FROM hymns h0_ WHERE h0_.type_id = 1 AND h0_.title > 'There Is A Region Lovelier Far' ORDER BY h0_.title ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.hymns_id AS hymns_id_2,
  t0.hymn_category_id AS hymn_category_id_3
FROM
  hymns_hymn_category t0
WHERE
  t0.hymns_id = ?

SELECT t0.id AS id_1, t0.hymns_id AS hymns_id_2, t0.hymn_category_id AS hymn_category_id_3 FROM hymns_hymn_category t0 WHERE t0.hymns_id = 1265;

SELECT
  t0.ID AS ID_1,
  t0.FullName AS FullName_2,
  t0.FirstName AS FirstName_3,
  t0.MiddleName AS MiddleName_4,
  t0.LastName AS LastName_5,
  t0.Suffix AS Suffix_6,
  t0.BirthYYYY AS BirthYYYY_7,
  t0.BirthMM AS BirthMM_8,
  t0.BirthDD AS BirthDD_9,
  t0.DeathYYYY AS DeathYYYY_10,
  t0.DeathMM AS DeathMM_11,
  t0.DeathDD AS DeathDD_12,
  t0.Notes AS Notes_13,
  t0.PictureCredits AS PictureCredits_14
FROM
  authcomp t0
WHERE
  t0.ID = ?

SELECT t0.ID AS ID_1, t0.FullName AS FullName_2, t0.FirstName AS FirstName_3, t0.MiddleName AS MiddleName_4, t0.LastName AS LastName_5, t0.Suffix AS Suffix_6, t0.BirthYYYY AS BirthYYYY_7, t0.BirthMM AS BirthMM_8, t0.BirthDD AS BirthDD_9, t0.DeathYYYY AS DeathYYYY_10, t0.DeathMM AS DeathMM_11, t0.DeathDD AS DeathDD_12, t0.Notes AS Notes_13, t0.PictureCredits AS PictureCredits_14 FROM authcomp t0 WHERE t0.ID = 918;