Query Metrics
48
Database Queries
4
Different statements
91.28 ms
Query time
0
Invalid entities
461
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
51.14 ms (56.02%) |
45 |
SELECT t0.id AS id_1, t0.song_name AS song_name_2, t0.composer AS composer_3, t0.arrangeur AS arrangeur_4, t0.composition_year AS composition_year_5, t0.duration AS duration_6, t0.background AS background_7, t0.keywords AS keywords_8, t0.etikett AS etikett_9, t0.etikett_color AS etikett_color_10, t0.etikett_number AS etikett_number_11, t0.folder AS folder_12, t0.dropboxlink AS dropboxlink_13, t0.is_aktuelle_proben AS is_aktuelle_proben_14, t0.aktuelle_dropboxlink AS aktuelle_dropboxlink_15, t0.sort_order AS sort_order_16, t0.parent_id AS parent_id_17 FROM song t0 WHERE t0.parent_id = ? ORDER BY t0.sort_order ASC, t0.song_name ASC
Parameters:
[
61
]
|
||||||||||||||||||||||||||||
|
36.42 ms (39.90%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.color AS color_3, s0_.color2 AS color2_4, s0_.image AS image_5, s1_.id AS id_6, s1_.song_name AS song_name_7, s1_.composer AS composer_8, s1_.arrangeur AS arrangeur_9, s1_.composition_year AS composition_year_10, s1_.duration AS duration_11, s1_.background AS background_12, s1_.keywords AS keywords_13, s1_.etikett AS etikett_14, s1_.etikett_color AS etikett_color_15, s1_.etikett_number AS etikett_number_16, s1_.folder AS folder_17, s1_.dropboxlink AS dropboxlink_18, s1_.is_aktuelle_proben AS is_aktuelle_proben_19, s1_.aktuelle_dropboxlink AS aktuelle_dropboxlink_20, s1_.sort_order AS sort_order_21, s2_.id AS id_22, s2_.song_name AS song_name_23, s2_.composer AS composer_24, s2_.arrangeur AS arrangeur_25, s2_.composition_year AS composition_year_26, s2_.duration AS duration_27, s2_.background AS background_28, s2_.keywords AS keywords_29, s2_.etikett AS etikett_30, s2_.etikett_color AS etikett_color_31, s2_.etikett_number AS etikett_number_32, s2_.folder AS folder_33, s2_.dropboxlink AS dropboxlink_34, s2_.is_aktuelle_proben AS is_aktuelle_proben_35, s2_.aktuelle_dropboxlink AS aktuelle_dropboxlink_36, s2_.sort_order AS sort_order_37, s1_.parent_id AS parent_id_38, s2_.parent_id AS parent_id_39 FROM style s0_ LEFT JOIN song_style s3_ ON s0_.id = s3_.style_id LEFT JOIN song s1_ ON s1_.id = s3_.song_keyword_id LEFT JOIN style_repertoire_songs s4_ ON s0_.id = s4_.style_id LEFT JOIN song s2_ ON s2_.id = s4_.song_id ORDER BY s0_.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
2.58 ms (2.83%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.subtitle AS subtitle_2, p0_.image_path AS image_path_3, p0_.paragraph AS paragraph_4, p0_.layout AS layout_5, p0_.is_main AS is_main_6, p0_.created_at AS created_at_7, p0_.page AS page_8, p0_.font_title AS font_title_9, p0_.font_title_size AS font_title_size_10, p0_.font_title_bold AS font_title_bold_11, p0_.font_title_italic AS font_title_italic_12, p0_.font_title_underline AS font_title_underline_13, p0_.font_subtitle AS font_subtitle_14, p0_.font_subtitle_size AS font_subtitle_size_15, p0_.font_subtitle_bold AS font_subtitle_bold_16, p0_.font_subtitle_italic AS font_subtitle_italic_17, p0_.font_subtitle_underline AS font_subtitle_underline_18, p0_.font_paragraph AS font_paragraph_19, p0_.font_paragraph_size AS font_paragraph_size_20, p0_.font_paragraph_bold AS font_paragraph_bold_21, p0_.font_paragraph_italic AS font_paragraph_italic_22, p0_.font_paragraph_underline AS font_paragraph_underline_23, p0_.position AS position_24, p0_.image_rotation AS image_rotation_25, p0_.date AS date_26 FROM post p0_ WHERE p0_.page = ? ORDER BY p0_.is_main DESC, p0_.position ASC, p0_.created_at DESC
Parameters:
[
"unser-repertoire"
]
|
||||||||||||||||||||||||||||
|
1.14 ms (1.25%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.reset_token AS reset_token_8, t0.reset_token_expires_at AS reset_token_expires_at_9, t0.login_count AS login_count_10, t0.last_login_at AS last_login_at_11, t0.last_seen_at AS last_seen_at_12 FROM `user` t0
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\SongKeyword | 402 |
| App\Entity\User | 38 |
| App\Entity\Style | 21 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Post | No errors. |
| App\Entity\Style | No errors. |
| App\Entity\SongKeyword | No errors. |
| App\Entity\Konzert | No errors. |
| App\Entity\SongLink | No errors. |
| App\Entity\User | No errors. |