Symfony Profiler

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
FROM
  hymns h0_
ORDER BY
  h0_.created_at DESC
LIMIT
  10

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 FROM hymns h0_ ORDER BY h0_.created_at DESC LIMIT 10;

SELECT
  v0_.id AS id_0,
  v0_.title AS title_1,
  v0_.hymn_slug AS hymn_slug_2,
  v0_.author_id AS author_id_3,
  v0_.LyricYYYY AS LyricYYYY_4,
  v0_.composer_id AS composer_id_5,
  v0_.MusicYYYY AS MusicYYYY_6,
  v0_.arranger_id AS arranger_id_7,
  v0_.ArrangedYYYY AS ArrangedYYYY_8,
  v0_.type_id AS type_id_9,
  v0_.OtherNotes AS OtherNotes_10,
  v0_.text AS text_11,
  v0_.copyright AS copyright_12,
  v0_.hymn_hit_count AS hymn_hit_count_13,
  v0_.last_accessed AS last_accessed_14,
  v0_.created_at AS created_at_15,
  v0_.updated_at AS updated_at_16,
  v0_.HymnUrl AS HymnUrl_17,
  v0_.YearRecorded AS YearRecorded_18,
  v0_.ArtistId AS ArtistId_19,
  v0_.ArtistName AS ArtistName_20,
  v0_.ArtistSlug AS ArtistSlug_21,
  v0_.ArtistUrl AS ArtistUrl_22
FROM
  v_artist_hymns v0_
WHERE
  v0_.type_id = ?
  AND v0_.hymn_slug = ?
ORDER BY
  v0_.last_accessed DESC

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.hymn_slug AS hymn_slug_2, v0_.author_id AS author_id_3, v0_.LyricYYYY AS LyricYYYY_4, v0_.composer_id AS composer_id_5, v0_.MusicYYYY AS MusicYYYY_6, v0_.arranger_id AS arranger_id_7, v0_.ArrangedYYYY AS ArrangedYYYY_8, v0_.type_id AS type_id_9, v0_.OtherNotes AS OtherNotes_10, v0_.text AS text_11, v0_.copyright AS copyright_12, v0_.hymn_hit_count AS hymn_hit_count_13, v0_.last_accessed AS last_accessed_14, v0_.created_at AS created_at_15, v0_.updated_at AS updated_at_16, v0_.HymnUrl AS HymnUrl_17, v0_.YearRecorded AS YearRecorded_18, v0_.ArtistId AS ArtistId_19, v0_.ArtistName AS ArtistName_20, v0_.ArtistSlug AS ArtistSlug_21, v0_.ArtistUrl AS ArtistUrl_22 FROM v_artist_hymns v0_ WHERE v0_.type_id = '3' AND v0_.hymn_slug = 'a-mighty-fortress-bshop' ORDER BY v0_.last_accessed DESC;

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

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 = 'a-mighty-fortress-bshop' 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 = 3 AND h0_.title < 'A Mighty Fortress' 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 = ?
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 = 3 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 = 3 AND h0_.title > 'A Mighty Fortress' ORDER BY h0_.title ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  hymntypes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM hymntypes t0 WHERE t0.id = 3;

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

SELECT
  t0.id AS id_1,
  t0.hymn_id AS hymn_id_2,
  t0.comment_date AS comment_date_3,
  t0.user_id AS user_id_4,
  t0.user_name AS user_name_5,
  t0.ip_address AS ip_address_6,
  t0.comment AS comment_7,
  t0.Referring_URL AS Referring_URL_8,
  t0.HTTP_Agent AS HTTP_Agent_9,
  t0.email AS email_10
FROM
  user_comments t0
WHERE
  t0.hymn_id = ?
ORDER BY
  t0.comment_date DESC

SELECT t0.id AS id_1, t0.hymn_id AS hymn_id_2, t0.comment_date AS comment_date_3, t0.user_id AS user_id_4, t0.user_name AS user_name_5, t0.ip_address AS ip_address_6, t0.comment AS comment_7, t0.Referring_URL AS Referring_URL_8, t0.HTTP_Agent AS HTTP_Agent_9, t0.email AS email_10 FROM user_comments t0 WHERE t0.hymn_id = 1250 ORDER BY t0.comment_date DESC;