Query Metrics
156
Database Queries
12
Different statements
180.38 ms
Query time
0
Invalid entities
383
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
78.93 ms (43.76%) |
83 |
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:
[
182
]
|
28.69 ms (15.90%) |
16 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.is_digital AS is_digital_4, t0.is_hbbtv AS is_hbbtv_5, t0.is_multitv AS is_multitv_6, t0.is_epg AS is_epg_7, t0.is_hidden AS is_hidden_8, t0.is_encoded AS is_encoded_9, t0.has_subtitle AS has_subtitle_10, t0.has_archive AS has_archive_11, t0.website AS website_12, t0.frequency AS frequency_13, t0.description AS description_14, t0.air_time AS air_time_15, t0.analog_channel_number AS analog_channel_number_16, t0.tv_genre_id AS tv_genre_id_17, t0.tv_resolution_id AS tv_resolution_id_18, t0.tv_modulation_id AS tv_modulation_id_19, t0.tv_compression_id AS tv_compression_id_20, t0.image_id AS image_id_21, t0.tv_analog_norm_id AS tv_analog_norm_id_22, t0.tv_genre_id AS tv_genre_id_23, t0.tv_resolution_id AS tv_resolution_id_24, t0.tv_modulation_id AS tv_modulation_id_25, t0.tv_compression_id AS tv_compression_id_26, t0.image_id AS image_id_27, t0.tv_analog_norm_id AS tv_analog_norm_id_28 FROM tv_channels t0 INNER JOIN channels_packages_pivot ON t0.id = channels_packages_pivot.channel_id WHERE channels_packages_pivot.package_id = ? ORDER BY t0.priority ASC
Parameters:
[
14
]
|
19.97 ms (11.07%) |
16 |
SELECT t0.id AS id_1, t0.pricing_id AS pricing_id_2, t0.subscription_id AS subscription_id_3, t0.price_type_id AS price_type_id_4, t0.technology_type_id AS technology_type_id_5, t0.fee_type_id AS fee_type_id_6, t0.building_type_id AS building_type_id_7, t0.value AS value_8, t0.partner_id AS partner_id_9, t0.subscription_id AS subscription_id_10, t0.price_type_id AS price_type_id_11, t0.technology_type_id AS technology_type_id_12, t0.fee_type_id AS fee_type_id_13, t0.building_type_id AS building_type_id_14, t0.pricing_id AS pricing_id_15 FROM prices t0 WHERE t0.pricing_id = ?
Parameters:
[
40
]
|
18.60 ms (10.31%) |
16 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.is_digital AS is_digital_4, t0.is_hidden AS is_hidden_5, t0.website AS website_6, t0.frequency AS frequency_7, t0.image_id AS image_id_8, t0.image_id AS image_id_9 FROM radio_stations t0 INNER JOIN radios_packages_pivot ON t0.id = radios_packages_pivot.radio_id WHERE radios_packages_pivot.package_id = ? ORDER BY t0.priority ASC
Parameters:
[
14
]
|
14.22 ms (7.88%) |
16 |
SELECT t0.id AS id_1 FROM pricings t0 WHERE t0.id = ?
Parameters:
[
40
]
|
7.06 ms (3.92%) |
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
Parameters:
[] |
4.22 ms (2.34%) |
2 |
SELECT t0_.id AS id_0, t0_.is_hidden AS is_hidden_1, t0_.is_digital AS is_digital_2, t0_.is_favorite AS is_favorite_3, t0_.is_company AS is_company_4, t0_.specific_symbol AS specific_symbol_5, t0_.free_packages AS free_packages_6, t0_.priority AS priority_7, t0_.description AS description_8, t0_.description_price_policy AS description_price_policy_9, t0_.new AS new_10, t0_.name AS name_11, t0_.analog_radio AS analog_radio_12, t0_.digital_radio AS digital_radio_13, t0_.pricing_id AS pricing_id_14, t0_.product_category_id AS product_category_id_15, t0_.tv_package_type_id AS tv_package_type_id_16, t0_.pricing_id AS pricing_id_17, t0_.product_category_id AS product_category_id_18, t0_.tv_package_type_id AS tv_package_type_id_19 FROM tv_packages t0_ INNER JOIN tv_package_types t1_ ON t0_.tv_package_type_id = t1_.id WHERE t1_.name = ? AND t0_.is_hidden = 0 AND t0_.is_digital = 1 AND t0_.is_company = ? ORDER BY t0_.priority ASC
Parameters:
[ "Tematický balíček" 0 ] |
4.01 ms (2.22%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.months AS months_3 FROM subscriptions t0 WHERE t0.months = ? LIMIT 1
Parameters:
[
0
]
|
1.31 ms (0.73%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.position AS position_4, t0.navigation_id AS navigation_id_5, t0.navigation_item_id AS navigation_item_id_6 FROM navigation_items t0 WHERE t0.navigation_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
1.21 ms (0.67%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM navigations t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.18 ms (0.66%) |
1 |
SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.description AS description_4, t0.category_id AS category_id_5 FROM mainsettings t0 WHERE t0.key = ? LIMIT 1
Parameters:
[
"SOCIAL_SITE_FACEBOOK"
]
|
0.97 ms (0.54%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.superiority_index AS superiority_index_3 FROM technology_types t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Price | 104 |
App\Entity\Television\Channel | 83 |
App\Entity\Image | 83 |
App\Entity\NavigationItem | 26 |
App\Entity\CustomPage | 25 |
App\Entity\Television\Package | 16 |
App\Entity\Pricing | 16 |
App\Entity\Television\Genre | 11 |
App\Entity\Subscription | 3 |
App\Entity\PriceType | 3 |
App\Entity\Television\PackageType | 2 |
App\Entity\TechnologyType | 2 |
App\Entity\Television\Resolution | 2 |
App\Entity\Television\Compression | 2 |
App\Entity\Navigation | 1 |
App\Entity\FeeType | 1 |
App\Entity\Television\Modulation | 1 |
App\Entity\MainSettings | 1 |
App\Entity\MainSettingsCategory | 1 |