Query Metrics
356
Database Queries
7
Different statements
362.08 ms
Query time
0
Invalid entities
393
Managed entities
Grouped Statements
| 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 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\CustomPage | No errors. |
| App\Entity\Television\Channel | No errors. |
| App\Entity\Television\Genre | No errors. |
| App\Entity\Television\Resolution | No errors. |
| App\Entity\Television\Modulation | No errors. |
| App\Entity\Television\Compression | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Television\AnalogNorm | No errors. |
| App\Entity\Television\Sound | No errors. |
| App\Entity\Television\Language | No errors. |
| App\Entity\Television\AspectRatio | No errors. |
| App\Entity\Radio | No errors. |