Symfony Profiler

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 = ?
ORDER BY
  t0.FullName ASC

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 = 382 ORDER BY t0.FullName ASC;

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.author_id = ?

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.author_id = 382;

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.composer_id = ?

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.composer_id = 382;

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 = 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.arranger_id = ?

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.arranger_id = 382;

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;