Symfony Profiler

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

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;

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

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 = 1 AND (a0_.city_id IS NULL OR b2_.id IN (1814)) ORDER BY a0_.ordering DESC, a0_.id DESC LIMIT 50;

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 = ?

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 = 1 AND b0_.available_in_api = 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 = ?

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 = 1 AND b1_.published = 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

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 = 1 AND b0_.on_main_page = 1 ORDER BY b0_.ordering DESC LIMIT 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

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 = 1 AND b0_.playlist_id = 2 ORDER BY b0_.current_week_position ASC, b0_.ordering DESC, b0_.id DESC LIMIT 20;