Query Metrics
324
Database Queries
10
Different statements
339.05 ms
Query time
0
Invalid entities
463
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
253.40 ms (74.74%) |
261 |
SELECT t0.is_main AS is_main_1, t0.has_history AS has_history_2, t0.history_file_path AS history_file_path_3, t0.stream_url AS stream_url_4, t0.stream_region_id AS stream_region_id_5, t0.color AS color_6, t0.music_history_path AS music_history_path_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.system_deleted_at AS system_deleted_at_11, t0.title AS title_12, t0.code AS code_13, t0.published AS published_14, t0.ordering AS ordering_15, t0.description AS description_16, t0.seo_no_index AS seo_no_index_17, t0.seo_canonical AS seo_canonical_18, t0.seo_h1 AS seo_h1_19, t0.seo_title AS seo_title_20, t0.seo_description AS seo_description_21, t0.seo_keywords AS seo_keywords_22, t0.content AS content_23, t0.migrate_id AS migrate_id_24, t0.migrate_info AS migrate_info_25, t0.city_id AS city_id_26, t0.created_by_id AS created_by_id_27, t0.updated_by_id AS updated_by_id_28, t0.deleted_by_id AS deleted_by_id_29, t0.picture_id AS picture_id_30, t0.region_id AS region_id_31 FROM app_radioshanson_music_stream t0 WHERE t0.city_id = ?
Parameters:
[
1814
]
|
|
38.61 ms (11.39%) |
44 |
SELECT t0.external_link AS external_link_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.system_deleted_at AS system_deleted_at_5, t0.title AS title_6, t0.code AS code_7, t0.published AS published_8, t0.url AS url_9, t0.ordering AS ordering_10, t0.description AS description_11, t0.menu_id AS menu_id_12, t0.parent_id AS parent_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.deleted_by_id AS deleted_by_id_16 FROM buckler_menu_item t0 WHERE (t0.published = ? AND t0.parent_id = ?) ORDER BY t0.ordering DESC, t0.id DESC
Parameters:
[ 1 1 ] |
|
19.16 ms (5.65%) |
1 |
SELECT b0_.international_title AS international_title_0, b0_.id AS id_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.system_deleted_at AS system_deleted_at_4, b0_.stream_url AS stream_url_5, b0_.stream_region_id AS stream_region_id_6, b0_.contacts AS contacts_7, b0_.contacts_code AS contacts_code_8, b0_.has_representation AS has_representation_9, b0_.audience AS audience_10, b0_.broadcast_frequency AS broadcast_frequency_11, b0_.title AS title_12, b0_.external_id AS external_id_13, b0_.published AS published_14, b0_.ordering AS ordering_15, b0_.latitude AS latitude_16, b0_.longitude AS longitude_17, b1_.phone_code AS phone_code_18, b1_.iso2 AS iso2_19, b1_.iso3 AS iso3_20, b1_.international_title AS international_title_21, b1_.id AS id_22, b1_.created_at AS created_at_23, b1_.updated_at AS updated_at_24, b1_.system_deleted_at AS system_deleted_at_25, b1_.has_representation AS has_representation_26, b1_.title AS title_27, b1_.code AS code_28, b1_.published AS published_29, b1_.ordering AS ordering_30, b2_.region_code AS region_code_31, b2_.international_title AS international_title_32, b2_.id AS id_33, b2_.created_at AS created_at_34, b2_.updated_at AS updated_at_35, b2_.system_deleted_at AS system_deleted_at_36, b2_.has_representation AS has_representation_37, b2_.title AS title_38, b2_.code AS code_39, b2_.published AS published_40, b2_.ordering AS ordering_41, b3_.id AS id_42, b3_.created_at AS created_at_43, b3_.updated_at AS updated_at_44, b3_.system_deleted_at AS system_deleted_at_45, b3_.title AS title_46, b3_.published AS published_47, b3_.ordering AS ordering_48, b0_.country_id AS country_id_49, b0_.region_id AS region_id_50, b0_.created_by_id AS created_by_id_51, b0_.updated_by_id AS updated_by_id_52, b0_.deleted_by_id AS deleted_by_id_53, b1_.currency_id AS currency_id_54, b1_.created_by_id AS created_by_id_55, b1_.updated_by_id AS updated_by_id_56, b1_.deleted_by_id AS deleted_by_id_57, b2_.country_id AS country_id_58, b2_.district_id AS district_id_59, b2_.created_by_id AS created_by_id_60, b2_.updated_by_id AS updated_by_id_61, b2_.deleted_by_id AS deleted_by_id_62, b3_.country_id AS country_id_63, b3_.created_by_id AS created_by_id_64, b3_.updated_by_id AS updated_by_id_65, b3_.deleted_by_id AS deleted_by_id_66 FROM buckler_geo_city b0_ LEFT JOIN buckler_geo_country b1_ ON b0_.country_id = b1_.id LEFT JOIN buckler_geo_region b2_ ON b0_.region_id = b2_.id LEFT JOIN buckler_geo_district b3_ ON b2_.district_id = b3_.id WHERE b0_.published = ? AND b1_.code = ? AND b0_.has_representation = ? ORDER BY b0_.ordering DESC, b0_.title ASC, b0_.id DESC LIMIT 500
Parameters:
[ 1 "ru" 1 ] |
|
7.72 ms (2.28%) |
12 |
SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = ?
Parameters:
[
2009331
]
|
|
6.41 ms (1.89%) |
1 |
SELECT a0_.is_main AS is_main_0, a0_.has_history AS has_history_1, a0_.history_file_path AS history_file_path_2, a0_.stream_url AS stream_url_3, a0_.stream_region_id AS stream_region_id_4, a0_.color AS color_5, a0_.music_history_path AS music_history_path_6, a0_.id AS id_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.system_deleted_at AS system_deleted_at_10, a0_.title AS title_11, a0_.code AS code_12, a0_.published AS published_13, a0_.ordering AS ordering_14, a0_.description AS description_15, a0_.seo_no_index AS seo_no_index_16, a0_.seo_canonical AS seo_canonical_17, a0_.seo_h1 AS seo_h1_18, a0_.seo_title AS seo_title_19, a0_.seo_description AS seo_description_20, a0_.seo_keywords AS seo_keywords_21, a0_.content AS content_22, a0_.migrate_id AS migrate_id_23, a0_.migrate_info AS migrate_info_24, m1_.name AS name_25, m1_.description AS description_26, m1_.enabled AS enabled_27, m1_.provider_name AS provider_name_28, m1_.provider_status AS provider_status_29, m1_.provider_reference AS provider_reference_30, m1_.provider_metadata AS provider_metadata_31, m1_.width AS width_32, m1_.height AS height_33, m1_.length AS length_34, m1_.content_type AS content_type_35, m1_.content_size AS content_size_36, m1_.copyright AS copyright_37, m1_.author_name AS author_name_38, m1_.context AS context_39, m1_.cdn_is_flushable AS cdn_is_flushable_40, m1_.cdn_flush_identifier AS cdn_flush_identifier_41, m1_.cdn_flush_at AS cdn_flush_at_42, m1_.cdn_status AS cdn_status_43, m1_.updated_at AS updated_at_44, m1_.created_at AS created_at_45, m1_.id AS id_46, b2_.international_title AS international_title_47, b2_.id AS id_48, b2_.created_at AS created_at_49, b2_.updated_at AS updated_at_50, b2_.system_deleted_at AS system_deleted_at_51, b2_.stream_url AS stream_url_52, b2_.stream_region_id AS stream_region_id_53, b2_.contacts AS contacts_54, b2_.contacts_code AS contacts_code_55, b2_.has_representation AS has_representation_56, b2_.audience AS audience_57, b2_.broadcast_frequency AS broadcast_frequency_58, b2_.title AS title_59, b2_.external_id AS external_id_60, b2_.published AS published_61, b2_.ordering AS ordering_62, b2_.latitude AS latitude_63, b2_.longitude AS longitude_64, b3_.region_code AS region_code_65, b3_.international_title AS international_title_66, b3_.id AS id_67, b3_.created_at AS created_at_68, b3_.updated_at AS updated_at_69, b3_.system_deleted_at AS system_deleted_at_70, b3_.has_representation AS has_representation_71, b3_.title AS title_72, b3_.code AS code_73, b3_.published AS published_74, b3_.ordering AS ordering_75, b4_.id AS id_76, b4_.created_at AS created_at_77, b4_.updated_at AS updated_at_78, b4_.system_deleted_at AS system_deleted_at_79, b4_.title AS title_80, b4_.published AS published_81, b4_.ordering AS ordering_82, b5_.phone_code AS phone_code_83, b5_.iso2 AS iso2_84, b5_.iso3 AS iso3_85, b5_.international_title AS international_title_86, b5_.id AS id_87, b5_.created_at AS created_at_88, b5_.updated_at AS updated_at_89, b5_.system_deleted_at AS system_deleted_at_90, b5_.has_representation AS has_representation_91, b5_.title AS title_92, b5_.code AS code_93, b5_.published AS published_94, b5_.ordering AS ordering_95, a0_.city_id AS city_id_96, a0_.created_by_id AS created_by_id_97, a0_.updated_by_id AS updated_by_id_98, a0_.deleted_by_id AS deleted_by_id_99, a0_.picture_id AS picture_id_100, a0_.region_id AS region_id_101, b2_.country_id AS country_id_102, b2_.region_id AS region_id_103, b2_.created_by_id AS created_by_id_104, b2_.updated_by_id AS updated_by_id_105, b2_.deleted_by_id AS deleted_by_id_106, b3_.country_id AS country_id_107, b3_.district_id AS district_id_108, b3_.created_by_id AS created_by_id_109, b3_.updated_by_id AS updated_by_id_110, b3_.deleted_by_id AS deleted_by_id_111, b4_.country_id AS country_id_112, b4_.created_by_id AS created_by_id_113, b4_.updated_by_id AS updated_by_id_114, b4_.deleted_by_id AS deleted_by_id_115, b5_.currency_id AS currency_id_116, b5_.created_by_id AS created_by_id_117, b5_.updated_by_id AS updated_by_id_118, b5_.deleted_by_id AS deleted_by_id_119 FROM app_radioshanson_music_stream a0_ LEFT JOIN media__media m1_ ON a0_.picture_id = m1_.id LEFT JOIN buckler_geo_city b2_ ON a0_.city_id = b2_.id LEFT JOIN buckler_geo_region b3_ ON b2_.region_id = b3_.id LEFT JOIN buckler_geo_district b4_ ON b3_.district_id = b4_.id LEFT JOIN buckler_geo_country b5_ ON b2_.country_id = b5_.id WHERE a0_.published = ? AND (a0_.city_id IS NULL OR b2_.id IN (?)) ORDER BY a0_.ordering DESC, a0_.id DESC LIMIT 50
Parameters:
[ 1 1814 ] |
|
6.02 ms (1.78%) |
1 |
SELECT b0_.vote_count AS vote_count_0, b0_.current_week_position AS current_week_position_1, b0_.last_week_position AS last_week_position_2, b0_.weeks_on_chart AS weeks_on_chart_3, b0_.id AS id_4, b0_.created_at AS created_at_5, b0_.updated_at AS updated_at_6, b0_.system_deleted_at AS system_deleted_at_7, b0_.ordering AS ordering_8, b0_.migrate_id AS migrate_id_9, b0_.migrate_info AS migrate_info_10, b0_.published_at AS published_at_11, b0_.auto_publish AS auto_publish_12, b0_.published AS published_13, b0_.unpublished_at AS unpublished_at_14, b1_.id AS id_15, b1_.created_at AS created_at_16, b1_.updated_at AS updated_at_17, b1_.system_deleted_at AS system_deleted_at_18, b1_.title AS title_19, b1_.code AS code_20, b1_.published AS published_21, b1_.description AS description_22, b1_.content AS content_23, b1_.seo_no_index AS seo_no_index_24, b1_.seo_canonical AS seo_canonical_25, b1_.seo_h1 AS seo_h1_26, b1_.seo_title AS seo_title_27, b1_.seo_description AS seo_description_28, b1_.seo_keywords AS seo_keywords_29, b1_.apple_music_link AS apple_music_link_30, b1_.yandex_music_link AS yandex_music_link_31, b1_.released_at AS released_at_32, b1_.migrate_id AS migrate_id_33, b1_.migrate_info AS migrate_info_34, b2_.id AS id_35, b2_.created_at AS created_at_36, b2_.updated_at AS updated_at_37, b2_.system_deleted_at AS system_deleted_at_38, b2_.ordering AS ordering_39, b2_.published AS published_40, b2_.migrate_id AS migrate_id_41, b2_.migrate_info AS migrate_info_42, b3_.is_person AS is_person_43, b3_.first_name AS first_name_44, b3_.last_name AS last_name_45, b3_.id AS id_46, b3_.created_at AS created_at_47, b3_.updated_at AS updated_at_48, b3_.system_deleted_at AS system_deleted_at_49, b3_.title AS title_50, b3_.code AS code_51, b3_.published AS published_52, b3_.content AS content_53, b3_.description AS description_54, b3_.seo_no_index AS seo_no_index_55, b3_.seo_canonical AS seo_canonical_56, b3_.seo_h1 AS seo_h1_57, b3_.seo_title AS seo_title_58, b3_.seo_description AS seo_description_59, b3_.seo_keywords AS seo_keywords_60, b3_.comments_enabled AS comments_enabled_61, b3_.on_main_page AS on_main_page_62, b3_.apple_music_link AS apple_music_link_63, b3_.yandex_music_link AS yandex_music_link_64, b3_.migrate_id AS migrate_id_65, b3_.migrate_info AS migrate_info_66, m4_.name AS name_67, m4_.description AS description_68, m4_.enabled AS enabled_69, m4_.provider_name AS provider_name_70, m4_.provider_status AS provider_status_71, m4_.provider_reference AS provider_reference_72, m4_.provider_metadata AS provider_metadata_73, m4_.width AS width_74, m4_.height AS height_75, m4_.length AS length_76, m4_.content_type AS content_type_77, m4_.content_size AS content_size_78, m4_.copyright AS copyright_79, m4_.author_name AS author_name_80, m4_.context AS context_81, m4_.cdn_is_flushable AS cdn_is_flushable_82, m4_.cdn_flush_identifier AS cdn_flush_identifier_83, m4_.cdn_flush_at AS cdn_flush_at_84, m4_.cdn_status AS cdn_status_85, m4_.updated_at AS updated_at_86, m4_.created_at AS created_at_87, m4_.id AS id_88, m5_.name AS name_89, m5_.description AS description_90, m5_.enabled AS enabled_91, m5_.provider_name AS provider_name_92, m5_.provider_status AS provider_status_93, m5_.provider_reference AS provider_reference_94, m5_.provider_metadata AS provider_metadata_95, m5_.width AS width_96, m5_.height AS height_97, m5_.length AS length_98, m5_.content_type AS content_type_99, m5_.content_size AS content_size_100, m5_.copyright AS copyright_101, m5_.author_name AS author_name_102, m5_.context AS context_103, m5_.cdn_is_flushable AS cdn_is_flushable_104, m5_.cdn_flush_identifier AS cdn_flush_identifier_105, m5_.cdn_flush_at AS cdn_flush_at_106, m5_.cdn_status AS cdn_status_107, m5_.updated_at AS updated_at_108, m5_.created_at AS created_at_109, m5_.id AS id_110, b6_.id AS id_111, b6_.created_at AS created_at_112, b6_.updated_at AS updated_at_113, b6_.system_deleted_at AS system_deleted_at_114, b6_.title AS title_115, b6_.code AS code_116, b6_.published AS published_117, b6_.content AS content_118, b6_.description AS description_119, b6_.seo_no_index AS seo_no_index_120, b6_.seo_canonical AS seo_canonical_121, b6_.seo_h1 AS seo_h1_122, b6_.seo_title AS seo_title_123, b6_.seo_description AS seo_description_124, b6_.seo_keywords AS seo_keywords_125, b7_.id AS id_126, b7_.created_at AS created_at_127, b7_.updated_at AS updated_at_128, b7_.system_deleted_at AS system_deleted_at_129, b7_.title AS title_130, b7_.code AS code_131, b7_.published AS published_132, b7_.content AS content_133, b7_.description AS description_134, b7_.seo_no_index AS seo_no_index_135, b7_.seo_canonical AS seo_canonical_136, b7_.seo_h1 AS seo_h1_137, b7_.seo_title AS seo_title_138, b7_.seo_description AS seo_description_139, b7_.seo_keywords AS seo_keywords_140, b0_.playlist_id AS playlist_id_141, b0_.song_id AS song_id_142, b0_.created_by_id AS created_by_id_143, b0_.updated_by_id AS updated_by_id_144, b0_.deleted_by_id AS deleted_by_id_145, b1_.created_by_id AS created_by_id_146, b1_.updated_by_id AS updated_by_id_147, b1_.deleted_by_id AS deleted_by_id_148, b1_.picture_id AS picture_id_149, b1_.audio_id AS audio_id_150, b2_.artist_id AS artist_id_151, b2_.song_id AS song_id_152, b2_.created_by_id AS created_by_id_153, b2_.updated_by_id AS updated_by_id_154, b2_.deleted_by_id AS deleted_by_id_155, b3_.created_by_id AS created_by_id_156, b3_.updated_by_id AS updated_by_id_157, b3_.deleted_by_id AS deleted_by_id_158, b3_.picture_id AS picture_id_159, b3_.country_id AS country_id_160, b6_.created_by_id AS created_by_id_161, b6_.updated_by_id AS updated_by_id_162, b6_.deleted_by_id AS deleted_by_id_163, b6_.picture_id AS picture_id_164, b7_.created_by_id AS created_by_id_165, b7_.updated_by_id AS updated_by_id_166, b7_.deleted_by_id AS deleted_by_id_167, b7_.picture_id AS picture_id_168 FROM buckler_music_playlist_song b0_ LEFT JOIN buckler_music_song b1_ ON b0_.song_id = b1_.id LEFT JOIN buckler_music_artist_song b2_ ON b1_.id = b2_.song_id LEFT JOIN buckler_music_artist b3_ ON b2_.artist_id = b3_.id LEFT JOIN media__media m4_ ON b3_.picture_id = m4_.id LEFT JOIN media__media m5_ ON b1_.picture_id = m5_.id LEFT JOIN buckler_music_song_genre b8_ ON b1_.id = b8_.song_id LEFT JOIN buckler_music_genre b6_ ON b6_.id = b8_.genre_id LEFT JOIN buckler_music_artist_genre b9_ ON b3_.id = b9_.artist_id LEFT JOIN buckler_music_genre b7_ ON b7_.id = b9_.genre_id WHERE b0_.published = ? AND b0_.playlist_id = ? ORDER BY b0_.current_week_position ASC, b0_.ordering DESC, b0_.id DESC LIMIT 20
Parameters:
[ 1 2 ] |
|
2.56 ms (0.76%) |
1 |
SELECT b0_.type AS type_0, b0_.value AS value_1, b0_.available_in_api AS available_in_api_2, b0_.disable_delete AS disable_delete_3, b0_.disable_code_edit AS disable_code_edit_4, b0_.id AS id_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.system_deleted_at AS system_deleted_at_8, b0_.title AS title_9, b0_.published AS published_10, b0_.code AS code_11, b0_.description AS description_12, b0_.group_id AS group_id_13, b0_.created_by_id AS created_by_id_14, b0_.updated_by_id AS updated_by_id_15, b0_.deleted_by_id AS deleted_by_id_16, b0_.file_id AS file_id_17, b0_.picture_id AS picture_id_18 FROM buckler_settings_setting b0_ LEFT JOIN buckler_settings_group b1_ ON b0_.group_id = b1_.id WHERE b0_.published = ? AND b0_.available_in_api = ?
Parameters:
[ 1 1 ] |
|
2.45 ms (0.72%) |
1 |
SELECT t0.international_title AS international_title_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.system_deleted_at AS system_deleted_at_5, t0.stream_url AS stream_url_6, t0.stream_region_id AS stream_region_id_7, t0.contacts AS contacts_8, t0.contacts_code AS contacts_code_9, t0.has_representation AS has_representation_10, t0.audience AS audience_11, t0.broadcast_frequency AS broadcast_frequency_12, t0.title AS title_13, t0.external_id AS external_id_14, t0.published AS published_15, t0.ordering AS ordering_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.country_id AS country_id_19, t0.region_id AS region_id_20, t0.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22, t0.deleted_by_id AS deleted_by_id_23 FROM buckler_geo_city t0 WHERE t0.title = ? LIMIT 1
Parameters:
[
"Москва"
]
|
|
1.41 ms (0.42%) |
1 |
SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.updated_at AS updated_at_2, b0_.system_deleted_at AS system_deleted_at_3, b0_.title AS title_4, b0_.code AS code_5, b0_.published AS published_6, b0_.description AS description_7, b1_.external_link AS external_link_8, b1_.id AS id_9, b1_.created_at AS created_at_10, b1_.updated_at AS updated_at_11, b1_.system_deleted_at AS system_deleted_at_12, b1_.title AS title_13, b1_.code AS code_14, b1_.published AS published_15, b1_.url AS url_16, b1_.ordering AS ordering_17, b1_.description AS description_18, b0_.created_by_id AS created_by_id_19, b0_.updated_by_id AS updated_by_id_20, b0_.deleted_by_id AS deleted_by_id_21, b1_.menu_id AS menu_id_22, b1_.parent_id AS parent_id_23, b1_.created_by_id AS created_by_id_24, b1_.updated_by_id AS updated_by_id_25, b1_.deleted_by_id AS deleted_by_id_26 FROM buckler_menu_menu b0_ LEFT JOIN buckler_menu_item b1_ ON b0_.id = b1_.menu_id WHERE b0_.published = ? AND b1_.published = ?
Parameters:
[ 1 1 ] |
|
1.30 ms (0.38%) |
1 |
SELECT b0_.vote_enabled AS vote_enabled_0, b0_.vote_handled_at AS vote_handled_at_1, b0_.id AS id_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.system_deleted_at AS system_deleted_at_5, b0_.title AS title_6, b0_.code AS code_7, b0_.published AS published_8, b0_.ordering AS ordering_9, b0_.content AS content_10, b0_.description AS description_11, b0_.seo_no_index AS seo_no_index_12, b0_.seo_canonical AS seo_canonical_13, b0_.seo_h1 AS seo_h1_14, b0_.seo_title AS seo_title_15, b0_.seo_description AS seo_description_16, b0_.seo_keywords AS seo_keywords_17, b0_.comments_enabled AS comments_enabled_18, b0_.on_main_page AS on_main_page_19, b0_.migrate_id AS migrate_id_20, b0_.migrate_info AS migrate_info_21, b1_.id AS id_22, b1_.created_at AS created_at_23, b1_.updated_at AS updated_at_24, b1_.system_deleted_at AS system_deleted_at_25, b1_.title AS title_26, b1_.code AS code_27, b1_.published AS published_28, b1_.content AS content_29, b1_.description AS description_30, b1_.seo_no_index AS seo_no_index_31, b1_.seo_canonical AS seo_canonical_32, b1_.seo_h1 AS seo_h1_33, b1_.seo_title AS seo_title_34, b1_.seo_description AS seo_description_35, b1_.seo_keywords AS seo_keywords_36, b0_.vote_playlist_id AS vote_playlist_id_37, b0_.created_by_id AS created_by_id_38, b0_.updated_by_id AS updated_by_id_39, b0_.deleted_by_id AS deleted_by_id_40, b0_.picture_id AS picture_id_41, b1_.created_by_id AS created_by_id_42, b1_.updated_by_id AS updated_by_id_43, b1_.deleted_by_id AS deleted_by_id_44, b1_.picture_id AS picture_id_45 FROM buckler_music_playlist b0_ LEFT JOIN buckler_music_playlist_genre b2_ ON b0_.id = b2_.playlist_id LEFT JOIN buckler_music_genre b1_ ON b1_.id = b2_.genre_id WHERE b0_.published = ? AND b0_.on_main_page = ? ORDER BY b0_.ordering DESC LIMIT 1
Parameters:
[ 1 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 |
|---|---|
| Buckler\Geo\Entity\City | 261 |
| Buckler\Geo\Entity\Region | 74 |
| Buckler\Media\Entity\Media | 22 |
| Buckler\Menu\Entity\Item | 22 |
| Buckler\Settings\Entity\Setting | 20 |
| Buckler\Music\Entity\PlaylistSong | 10 |
| Buckler\Music\Entity\Song | 10 |
| Buckler\Music\Entity\ArtistSong | 10 |
| Buckler\Music\Entity\Artist | 10 |
| Buckler\Geo\Entity\District | 9 |
| Buckler\User\Entity\User | 8 |
| Buckler\Menu\Entity\Menu | 3 |
| Buckler\Settings\Entity\Group | 2 |
| Buckler\Geo\Entity\Country | 1 |
| Buckler\Music\Entity\Playlist | 1 |