Query Metrics
3
Database Queries
3
Different statements
4.49 ms
Query time
0
Invalid entities
Queries
#▲ | 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:
[
"closing-hymns"
]
|
2 | 2.52 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:
[
"closing-hymns"
]
|
3 | 1.38 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. |