Query Metrics

356 Database Queries
7 Different statements
362.08 ms Query time
0 Invalid entities
393 Managed entities

Grouped Statements

Show all queries

Time Count Info
172.68 ms
(47.69%)
166
SELECT t0.id AS id_1, t0.name AS name_2 FROM tv_languages t0 INNER JOIN channels_languages_pivot ON t0.id = channels_languages_pivot.language_id WHERE channels_languages_pivot.channel_id = ?
Parameters:
[
  2
]
159.70 ms
(44.10%)
166
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.ext AS ext_4, t0.mime AS mime_5, t0.public_path AS public_path_6, t0.size AS size_7 FROM images t0 WHERE t0.id = ?
Parameters:
[
  150
]
15.48 ms
(4.28%)
17
SELECT t0.id AS id_1, t0.name AS name_2 FROM tv_genres t0 WHERE t0.id = ?
Parameters:
[
  2
]
4.85 ms
(1.34%)
1
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.priority AS priority_2, t0_.is_digital AS is_digital_3, t0_.is_hbbtv AS is_hbbtv_4, t0_.is_multitv AS is_multitv_5, t0_.is_epg AS is_epg_6, t0_.is_hidden AS is_hidden_7, t0_.is_encoded AS is_encoded_8, t0_.has_subtitle AS has_subtitle_9, t0_.has_archive AS has_archive_10, t0_.website AS website_11, t0_.frequency AS frequency_12, t0_.description AS description_13, t0_.air_time AS air_time_14, t0_.analog_channel_number AS analog_channel_number_15, t0_.tv_genre_id AS tv_genre_id_16, t0_.tv_resolution_id AS tv_resolution_id_17, t0_.tv_modulation_id AS tv_modulation_id_18, t0_.tv_compression_id AS tv_compression_id_19, t0_.image_id AS image_id_20, t0_.tv_analog_norm_id AS tv_analog_norm_id_21, t0_.tv_genre_id AS tv_genre_id_22, t0_.tv_resolution_id AS tv_resolution_id_23, t0_.tv_modulation_id AS tv_modulation_id_24, t0_.tv_compression_id AS tv_compression_id_25, t0_.image_id AS image_id_26, t0_.tv_analog_norm_id AS tv_analog_norm_id_27 FROM tv_channels t0_ WHERE t0_.is_hidden = ? ORDER BY t0_.priority ASC
Parameters:
[
  0
]
4.08 ms
(1.13%)
4
SELECT t0.id AS id_1, t0.name AS name_2 FROM tv_resolutions t0 WHERE t0.id = ?
Parameters:
[
  2
]
3.57 ms
(0.99%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.backup AS backup_4, t0.slug AS slug_5, t0.seoMetaDescription AS seoMetaDescription_6, t0.seoTitleTag AS seoTitleTag_7, t0.seoOgImage AS seoOgImage_8, t0.seoOgTitle AS seoOgTitle_9, t0.seoOgDescription AS seoOgDescription_10, t0.isRemoveder AS isRemoveder_11, t0.showInWidget AS showInWidget_12 FROM custompage t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "program-raster"
]
1.72 ms
(0.48%)
1
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.priority AS priority_2, r0_.is_digital AS is_digital_3, r0_.is_hidden AS is_hidden_4, r0_.website AS website_5, r0_.frequency AS frequency_6, r0_.image_id AS image_id_7, r0_.image_id AS image_id_8 FROM radio_stations r0_ WHERE r0_.is_hidden = ? ORDER BY r0_.priority ASC
Parameters:
[
  0
]

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\Television\Channel 166
App\Entity\Image 166
App\Entity\Radio 26
App\Entity\Television\Genre 17
App\Entity\Television\Language 8
App\Entity\Television\Resolution 4
App\Entity\Television\Compression 3
App\Entity\CustomPage 1
App\Entity\Television\Modulation 1
App\Entity\Television\AnalogNorm 1