Symfony Profiler

SELECT
  a0_.ID AS ID_0,
  a0_.FullName AS FullName_1,
  a0_.FirstName AS FirstName_2,
  a0_.MiddleName AS MiddleName_3,
  a0_.LastName AS LastName_4,
  a0_.Suffix AS Suffix_5,
  a0_.BirthYYYY AS BirthYYYY_6,
  a0_.BirthMM AS BirthMM_7,
  a0_.BirthDD AS BirthDD_8,
  a0_.DeathYYYY AS DeathYYYY_9,
  a0_.DeathMM AS DeathMM_10,
  a0_.DeathDD AS DeathDD_11,
  a0_.Notes AS Notes_12,
  a0_.PictureCredits AS PictureCredits_13
FROM
  authcomp a0_
  INNER JOIN hymns h1_ ON (a0_.ID = h1_.author_id)
ORDER BY
  a0_.FullName ASC

SELECT a0_.ID AS ID_0, a0_.FullName AS FullName_1, a0_.FirstName AS FirstName_2, a0_.MiddleName AS MiddleName_3, a0_.LastName AS LastName_4, a0_.Suffix AS Suffix_5, a0_.BirthYYYY AS BirthYYYY_6, a0_.BirthMM AS BirthMM_7, a0_.BirthDD AS BirthDD_8, a0_.DeathYYYY AS DeathYYYY_9, a0_.DeathMM AS DeathMM_10, a0_.DeathDD AS DeathDD_11, a0_.Notes AS Notes_12, a0_.PictureCredits AS PictureCredits_13 FROM authcomp a0_ INNER JOIN hymns h1_ ON (a0_.ID = h1_.author_id) ORDER BY a0_.FullName ASC;

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;