https://dev.ehymns.org/hymn/category/show/easter-hymns

Query Metrics

3 Database Queries
3 Different statements
5.23 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.59 ms
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 FROM hymn_category t0 WHERE t0.slug = ?
Parameters:
[
  "easter-hymns"
]
2 3.05 ms
SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.FirstLetter AS FirstLetter_2, v0_.slug AS slug_3, v0_.author_id AS author_id_4, v0_.LyricYYYY AS LyricYYYY_5, v0_.composer_id AS composer_id_6, v0_.MusicYYYY AS MusicYYYY_7, v0_.arranger_id AS arranger_id_8, v0_.ArrangedYYYY AS ArrangedYYYY_9, v0_.type_id AS type_id_10, v0_.type_title AS type_title_11, v0_.type_slug AS type_slug_12, v0_.type_description AS type_description_13, v0_.category_id AS category_id_14, v0_.category_title AS category_title_15, v0_.category_slug AS category_slug_16, v0_.category_description AS category_description_17, v0_.OtherNotes AS OtherNotes_18, v0_.text AS text_19, v0_.copyright AS copyright_20, v0_.hymn_hit_count AS hymn_hit_count_21, v0_.last_accessed AS last_accessed_22, v0_.created_at AS created_at_23, v0_.updated_at AS updated_at_24, v0_.HymnUrl AS HymnUrl_25, v0_.YearRecorded AS YearRecorded_26, v0_.ArtistId AS ArtistId_27, v0_.ArtistName AS ArtistName_28, v0_.ArtistUrl AS ArtistUrl_29 FROM v_hymns v0_ WHERE v0_.category_slug = ?
Parameters:
[
  "easter-hymns"
]
3 1.59 ms
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
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\HymnCategory No errors.
App\Entity\Hymns No errors.
App\Entity\HymnsView No errors.