Query Metrics

156 Database Queries
12 Different statements
180.38 ms Query time
0 Invalid entities
383 Managed entities

Grouped Statements

Show all queries

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