https://dev.ehymns.org/top5

Query Metrics

1 Database Queries
1 Different statements
0.93 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.93 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.FirstLetter AS FirstLetter_3, t0.slug AS slug_4, t0.author_id AS author_id_5, t0.LyricYYYY AS LyricYYYY_6, t0.composer_id AS composer_id_7, t0.MusicYYYY AS MusicYYYY_8, t0.arranger_id AS arranger_id_9, t0.ArrangedYYYY AS ArrangedYYYY_10, t0.type_id AS type_id_11, t0.type_title AS type_title_12, t0.type_slug AS type_slug_13, t0.type_description AS type_description_14, t0.OtherNotes AS OtherNotes_15, t0.text AS text_16, t0.copyright AS copyright_17, t0.hymn_hit_count AS hymn_hit_count_18, t0.last_accessed AS last_accessed_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21 FROM v_hymntypes t0 ORDER BY t0.hymn_hit_count DESC, t0.last_accessed DESC
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\HymnTypesView No errors.