Symfony Profiler

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

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 = 2020561;

SELECT
  DISTINCT id_3
FROM
  (
    SELECT
      DISTINCT id_3,
      published_at_14
    FROM
      (
        SELECT
          b0_.has_photo AS has_photo_0,
          b0_.has_video AS has_video_1,
          b0_.image_handaled AS image_handaled_2,
          b0_.id AS id_3,
          b0_.created_at AS created_at_4,
          b0_.updated_at AS updated_at_5,
          b0_.system_deleted_at AS system_deleted_at_6,
          b0_.event_date AS event_date_7,
          b0_.event_title AS event_title_8,
          b0_.event_sub_title AS event_sub_title_9,
          b0_.title AS title_10,
          b0_.code AS code_11,
          b0_.auto_publish AS auto_publish_12,
          b0_.published AS published_13,
          b0_.published_at AS published_at_14,
          b0_.unpublished_at AS unpublished_at_15,
          b0_.ordering AS ordering_16,
          b0_.description AS description_17,
          b0_.seo_no_index AS seo_no_index_18,
          b0_.seo_canonical AS seo_canonical_19,
          b0_.seo_h1 AS seo_h1_20,
          b0_.seo_title AS seo_title_21,
          b0_.seo_description AS seo_description_22,
          b0_.seo_keywords AS seo_keywords_23,
          b0_.comments_enabled AS comments_enabled_24,
          b0_.content AS content_25,
          b0_.announce AS announce_26,
          b0_.external_id AS external_id_27,
          b0_.on_main_page AS on_main_page_28,
          b0_.analytics_views_per_day AS analytics_views_per_day_29,
          b0_.analytics_views_per_month AS analytics_views_per_month_30,
          b0_.analytics_views_total AS analytics_views_total_31,
          b0_.migrate_id AS migrate_id_32,
          b0_.migrate_info AS migrate_info_33,
          b0_.exclude_from_rss AS exclude_from_rss_34,
          b1_.id AS id_35,
          b1_.created_at AS created_at_36,
          b1_.updated_at AS updated_at_37,
          b1_.system_deleted_at AS system_deleted_at_38,
          b1_.title AS title_39,
          b1_.code AS code_40,
          b1_.published AS published_41,
          b1_.description AS description_42,
          b2_.id AS id_43,
          b2_.created_at AS created_at_44,
          b2_.updated_at AS updated_at_45,
          b2_.system_deleted_at AS system_deleted_at_46,
          b2_.title AS title_47,
          b2_.code AS code_48,
          b2_.published AS published_49,
          b2_.description AS description_50,
          b2_.migrate_id AS migrate_id_51,
          b2_.migrate_info AS migrate_info_52,
          b2_.ordering AS ordering_53,
          b2_.content AS content_54,
          b2_.exclude_from_rss AS exclude_from_rss_55,
          b3_.id AS id_56,
          b3_.created_at AS created_at_57,
          b3_.updated_at AS updated_at_58,
          b3_.system_deleted_at AS system_deleted_at_59,
          b3_.title AS title_60,
          b3_.published AS published_61,
          b3_.ordering AS ordering_62,
          b3_.description AS description_63,
          b3_.migrate_id AS migrate_id_64,
          b3_.migrate_info AS migrate_info_65,
          m4_.name AS name_66,
          m4_.description AS description_67,
          m4_.enabled AS enabled_68,
          m4_.provider_name AS provider_name_69,
          m4_.provider_status AS provider_status_70,
          m4_.provider_reference AS provider_reference_71,
          m4_.provider_metadata AS provider_metadata_72,
          m4_.width AS width_73,
          m4_.height AS height_74,
          m4_.length AS length_75,
          m4_.content_type AS content_type_76,
          m4_.content_size AS content_size_77,
          m4_.copyright AS copyright_78,
          m4_.author_name AS author_name_79,
          m4_.context AS context_80,
          m4_.cdn_is_flushable AS cdn_is_flushable_81,
          m4_.cdn_flush_identifier AS cdn_flush_identifier_82,
          m4_.cdn_flush_at AS cdn_flush_at_83,
          m4_.cdn_status AS cdn_status_84,
          m4_.updated_at AS updated_at_85,
          m4_.created_at AS created_at_86,
          m4_.id AS id_87,
          m5_.name AS name_88,
          m5_.description AS description_89,
          m5_.enabled AS enabled_90,
          m5_.provider_name AS provider_name_91,
          m5_.provider_status AS provider_status_92,
          m5_.provider_reference AS provider_reference_93,
          m5_.provider_metadata AS provider_metadata_94,
          m5_.width AS width_95,
          m5_.height AS height_96,
          m5_.length AS length_97,
          m5_.content_type AS content_type_98,
          m5_.content_size AS content_size_99,
          m5_.copyright AS copyright_100,
          m5_.author_name AS author_name_101,
          m5_.context AS context_102,
          m5_.cdn_is_flushable AS cdn_is_flushable_103,
          m5_.cdn_flush_identifier AS cdn_flush_identifier_104,
          m5_.cdn_flush_at AS cdn_flush_at_105,
          m5_.cdn_status AS cdn_status_106,
          m5_.updated_at AS updated_at_107,
          m5_.created_at AS created_at_108,
          m5_.id AS id_109,
          m6_.name AS name_110,
          m6_.description AS description_111,
          m6_.enabled AS enabled_112,
          m6_.provider_name AS provider_name_113,
          m6_.provider_status AS provider_status_114,
          m6_.provider_reference AS provider_reference_115,
          m6_.provider_metadata AS provider_metadata_116,
          m6_.width AS width_117,
          m6_.height AS height_118,
          m6_.length AS length_119,
          m6_.content_type AS content_type_120,
          m6_.content_size AS content_size_121,
          m6_.copyright AS copyright_122,
          m6_.author_name AS author_name_123,
          m6_.context AS context_124,
          m6_.cdn_is_flushable AS cdn_is_flushable_125,
          m6_.cdn_flush_identifier AS cdn_flush_identifier_126,
          m6_.cdn_flush_at AS cdn_flush_at_127,
          m6_.cdn_status AS cdn_status_128,
          m6_.updated_at AS updated_at_129,
          m6_.created_at AS created_at_130,
          m6_.id AS id_131
        FROM
          buckler_news_page b0_
          LEFT JOIN buckler_news_page_tag b7_ ON b0_.id = b7_.page_id
          LEFT JOIN buckler_tag b1_ ON b1_.id = b7_.tag_id
          LEFT JOIN buckler_news_page_group b8_ ON b0_.id = b8_.page_id
          LEFT JOIN buckler_news_group b2_ ON b2_.id = b8_.group_id
          LEFT JOIN buckler_news_page_file b3_ ON b0_.id = b3_.page_id
          LEFT JOIN media__media m4_ ON b3_.file_id = m4_.id
          LEFT JOIN media__media m5_ ON b0_.announce_picture_id = m5_.id
          LEFT JOIN media__media m6_ ON b0_.detail_picture_id = m6_.id
        WHERE
          b0_.published = ?
          AND b0_.on_main_page = ?
          AND b2_.code IN (?)
      ) dctrn_result_inner
    ORDER BY
      published_at_14 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, published_at_14 FROM (SELECT b0_.has_photo AS has_photo_0, b0_.has_video AS has_video_1, b0_.image_handaled AS image_handaled_2, b0_.id AS id_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.system_deleted_at AS system_deleted_at_6, b0_.event_date AS event_date_7, b0_.event_title AS event_title_8, b0_.event_sub_title AS event_sub_title_9, b0_.title AS title_10, b0_.code AS code_11, b0_.auto_publish AS auto_publish_12, b0_.published AS published_13, b0_.published_at AS published_at_14, b0_.unpublished_at AS unpublished_at_15, b0_.ordering AS ordering_16, b0_.description AS description_17, b0_.seo_no_index AS seo_no_index_18, b0_.seo_canonical AS seo_canonical_19, b0_.seo_h1 AS seo_h1_20, b0_.seo_title AS seo_title_21, b0_.seo_description AS seo_description_22, b0_.seo_keywords AS seo_keywords_23, b0_.comments_enabled AS comments_enabled_24, b0_.content AS content_25, b0_.announce AS announce_26, b0_.external_id AS external_id_27, b0_.on_main_page AS on_main_page_28, b0_.analytics_views_per_day AS analytics_views_per_day_29, b0_.analytics_views_per_month AS analytics_views_per_month_30, b0_.analytics_views_total AS analytics_views_total_31, b0_.migrate_id AS migrate_id_32, b0_.migrate_info AS migrate_info_33, b0_.exclude_from_rss AS exclude_from_rss_34, b1_.id AS id_35, b1_.created_at AS created_at_36, b1_.updated_at AS updated_at_37, b1_.system_deleted_at AS system_deleted_at_38, b1_.title AS title_39, b1_.code AS code_40, b1_.published AS published_41, b1_.description AS description_42, b2_.id AS id_43, b2_.created_at AS created_at_44, b2_.updated_at AS updated_at_45, b2_.system_deleted_at AS system_deleted_at_46, b2_.title AS title_47, b2_.code AS code_48, b2_.published AS published_49, b2_.description AS description_50, b2_.migrate_id AS migrate_id_51, b2_.migrate_info AS migrate_info_52, b2_.ordering AS ordering_53, b2_.content AS content_54, b2_.exclude_from_rss AS exclude_from_rss_55, b3_.id AS id_56, b3_.created_at AS created_at_57, b3_.updated_at AS updated_at_58, b3_.system_deleted_at AS system_deleted_at_59, b3_.title AS title_60, b3_.published AS published_61, b3_.ordering AS ordering_62, b3_.description AS description_63, b3_.migrate_id AS migrate_id_64, b3_.migrate_info AS migrate_info_65, m4_.name AS name_66, m4_.description AS description_67, m4_.enabled AS enabled_68, m4_.provider_name AS provider_name_69, m4_.provider_status AS provider_status_70, m4_.provider_reference AS provider_reference_71, m4_.provider_metadata AS provider_metadata_72, m4_.width AS width_73, m4_.height AS height_74, m4_.length AS length_75, m4_.content_type AS content_type_76, m4_.content_size AS content_size_77, m4_.copyright AS copyright_78, m4_.author_name AS author_name_79, m4_.context AS context_80, m4_.cdn_is_flushable AS cdn_is_flushable_81, m4_.cdn_flush_identifier AS cdn_flush_identifier_82, m4_.cdn_flush_at AS cdn_flush_at_83, m4_.cdn_status AS cdn_status_84, m4_.updated_at AS updated_at_85, m4_.created_at AS created_at_86, m4_.id AS id_87, m5_.name AS name_88, m5_.description AS description_89, m5_.enabled AS enabled_90, m5_.provider_name AS provider_name_91, m5_.provider_status AS provider_status_92, m5_.provider_reference AS provider_reference_93, m5_.provider_metadata AS provider_metadata_94, m5_.width AS width_95, m5_.height AS height_96, m5_.length AS length_97, m5_.content_type AS content_type_98, m5_.content_size AS content_size_99, m5_.copyright AS copyright_100, m5_.author_name AS author_name_101, m5_.context AS context_102, m5_.cdn_is_flushable AS cdn_is_flushable_103, m5_.cdn_flush_identifier AS cdn_flush_identifier_104, m5_.cdn_flush_at AS cdn_flush_at_105, m5_.cdn_status AS cdn_status_106, m5_.updated_at AS updated_at_107, m5_.created_at AS created_at_108, m5_.id AS id_109, m6_.name AS name_110, m6_.description AS description_111, m6_.enabled AS enabled_112, m6_.provider_name AS provider_name_113, m6_.provider_status AS provider_status_114, m6_.provider_reference AS provider_reference_115, m6_.provider_metadata AS provider_metadata_116, m6_.width AS width_117, m6_.height AS height_118, m6_.length AS length_119, m6_.content_type AS content_type_120, m6_.content_size AS content_size_121, m6_.copyright AS copyright_122, m6_.author_name AS author_name_123, m6_.context AS context_124, m6_.cdn_is_flushable AS cdn_is_flushable_125, m6_.cdn_flush_identifier AS cdn_flush_identifier_126, m6_.cdn_flush_at AS cdn_flush_at_127, m6_.cdn_status AS cdn_status_128, m6_.updated_at AS updated_at_129, m6_.created_at AS created_at_130, m6_.id AS id_131 FROM buckler_news_page b0_ LEFT JOIN buckler_news_page_tag b7_ ON b0_.id = b7_.page_id LEFT JOIN buckler_tag b1_ ON b1_.id = b7_.tag_id LEFT JOIN buckler_news_page_group b8_ ON b0_.id = b8_.page_id LEFT JOIN buckler_news_group b2_ ON b2_.id = b8_.group_id LEFT JOIN buckler_news_page_file b3_ ON b0_.id = b3_.page_id LEFT JOIN media__media m4_ ON b3_.file_id = m4_.id LEFT JOIN media__media m5_ ON b0_.announce_picture_id = m5_.id LEFT JOIN media__media m6_ ON b0_.detail_picture_id = m6_.id WHERE b0_.published = 1 AND b0_.on_main_page = 1 AND b2_.code IN ('news')) dctrn_result_inner ORDER BY published_at_14 DESC) dctrn_result LIMIT 20;

SELECT
  t0.preview_image_url AS preview_image_url_1,
  t0.image_url AS image_url_2,
  t0.video_url AS video_url_3,
  t0.youtube_id AS youtube_id_4,
  t0.iframe AS iframe_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.system_deleted_at AS system_deleted_at_9,
  t0.published AS published_10,
  t0.ordering AS ordering_11,
  t0.description AS description_12,
  t0.migrate_id AS migrate_id_13,
  t0.migrate_info AS migrate_info_14,
  t0.title AS title_15,
  t0.preview_picture_id AS preview_picture_id_16,
  t0.gallery_id AS gallery_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.updated_by_id AS updated_by_id_19,
  t0.deleted_by_id AS deleted_by_id_20,
  t0.file_id AS file_id_21
FROM
  buckler_media_gallery_file t0
WHERE
  (
    t0.published = ?
    AND t0.gallery_id = ?
  )
ORDER BY
  t0.ordering DESC,
  t0.id DESC
LIMIT
  1

SELECT t0.preview_image_url AS preview_image_url_1, t0.image_url AS image_url_2, t0.video_url AS video_url_3, t0.youtube_id AS youtube_id_4, t0.iframe AS iframe_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.system_deleted_at AS system_deleted_at_9, t0.published AS published_10, t0.ordering AS ordering_11, t0.description AS description_12, t0.migrate_id AS migrate_id_13, t0.migrate_info AS migrate_info_14, t0.title AS title_15, t0.preview_picture_id AS preview_picture_id_16, t0.gallery_id AS gallery_id_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.deleted_by_id AS deleted_by_id_20, t0.file_id AS file_id_21 FROM buckler_media_gallery_file t0 WHERE (t0.published = 1 AND t0.gallery_id = 2709) ORDER BY t0.ordering DESC, t0.id DESC LIMIT 1;

SELECT
  te.id AS id,
  te.created_at AS created_at,
  te.updated_at AS updated_at,
  te.system_deleted_at AS system_deleted_at,
  te.title AS title,
  te.code AS code,
  te.published AS published,
  te.description AS description,
  te.seo_no_index AS seo_no_index,
  te.seo_canonical AS seo_canonical,
  te.seo_h1 AS seo_h1,
  te.seo_title AS seo_title,
  te.seo_description AS seo_description,
  te.seo_keywords AS seo_keywords,
  te.published_at AS published_at,
  te.external_id AS external_id,
  te.content AS content,
  te.ordering AS ordering,
  te.analytics_views_per_day AS analytics_views_per_day,
  te.analytics_views_per_month AS analytics_views_per_month,
  te.analytics_views_total AS analytics_views_total,
  te.on_main_page AS on_main_page,
  te.migrate_id AS migrate_id,
  te.migrate_info AS migrate_info,
  te.created_by_id AS created_by_id,
  te.updated_by_id AS updated_by_id,
  te.deleted_by_id AS deleted_by_id,
  te.picture_id AS picture_id,
  te.detail_picture_id AS detail_picture_id
FROM
  buckler_media_gallery te
  JOIN buckler_media_gallery_group t ON t.gallery_id = te.id
WHERE
  t.group_id = ?
  AND te.published = ?
ORDER BY
  ordering DESC,
  published_at DESC
LIMIT
  10

SELECT te.id AS id, te.created_at AS created_at, te.updated_at AS updated_at, te.system_deleted_at AS system_deleted_at, te.title AS title, te.code AS code, te.published AS published, te.description AS description, te.seo_no_index AS seo_no_index, te.seo_canonical AS seo_canonical, te.seo_h1 AS seo_h1, te.seo_title AS seo_title, te.seo_description AS seo_description, te.seo_keywords AS seo_keywords, te.published_at AS published_at, te.external_id AS external_id, te.content AS content, te.ordering AS ordering, te.analytics_views_per_day AS analytics_views_per_day, te.analytics_views_per_month AS analytics_views_per_month, te.analytics_views_total AS analytics_views_total, te.on_main_page AS on_main_page, te.migrate_id AS migrate_id, te.migrate_info AS migrate_info, te.created_by_id AS created_by_id, te.updated_by_id AS updated_by_id, te.deleted_by_id AS deleted_by_id, te.picture_id AS picture_id, te.detail_picture_id AS detail_picture_id FROM buckler_media_gallery te JOIN buckler_media_gallery_group t ON t.gallery_id = te.id WHERE t.group_id = 31 AND te.published = 1 ORDER BY ordering DESC, published_at DESC LIMIT 10;

SELECT
  t0.preview_image_url AS preview_image_url_1,
  t0.image_url AS image_url_2,
  t0.video_url AS video_url_3,
  t0.youtube_id AS youtube_id_4,
  t0.iframe AS iframe_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.system_deleted_at AS system_deleted_at_9,
  t0.published AS published_10,
  t0.ordering AS ordering_11,
  t0.description AS description_12,
  t0.migrate_id AS migrate_id_13,
  t0.migrate_info AS migrate_info_14,
  t0.title AS title_15,
  t0.preview_picture_id AS preview_picture_id_16,
  t0.gallery_id AS gallery_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.updated_by_id AS updated_by_id_19,
  t0.deleted_by_id AS deleted_by_id_20,
  t0.file_id AS file_id_21
FROM
  buckler_media_gallery_file t0
WHERE
  t0.gallery_id = ?

SELECT t0.preview_image_url AS preview_image_url_1, t0.image_url AS image_url_2, t0.video_url AS video_url_3, t0.youtube_id AS youtube_id_4, t0.iframe AS iframe_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.system_deleted_at AS system_deleted_at_9, t0.published AS published_10, t0.ordering AS ordering_11, t0.description AS description_12, t0.migrate_id AS migrate_id_13, t0.migrate_info AS migrate_info_14, t0.title AS title_15, t0.preview_picture_id AS preview_picture_id_16, t0.gallery_id AS gallery_id_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.deleted_by_id AS deleted_by_id_20, t0.file_id AS file_id_21 FROM buckler_media_gallery_file t0 WHERE t0.gallery_id = 2709;

SELECT
  t0.content AS content_1,
  t0.id AS id_2,
  t0.locale AS locale_3,
  t0.field AS field_4,
  t0.object_id AS object_id_5
FROM
  buckler_news_translation_page t0
WHERE
  t0.object_id = ?

SELECT t0.content AS content_1, t0.id AS id_2, t0.locale AS locale_3, t0.field AS field_4, t0.object_id AS object_id_5 FROM buckler_news_translation_page t0 WHERE t0.object_id = 6905;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.system_deleted_at AS system_deleted_at_4,
  t0.title AS title_5,
  t0.published AS published_6,
  t0.ordering AS ordering_7,
  t0.description AS description_8,
  t0.migrate_id AS migrate_id_9,
  t0.migrate_info AS migrate_info_10,
  t0.page_id AS page_id_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.deleted_by_id AS deleted_by_id_14,
  t0.file_id AS file_id_15
FROM
  buckler_news_page_image t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.system_deleted_at AS system_deleted_at_4, t0.title AS title_5, t0.published AS published_6, t0.ordering AS ordering_7, t0.description AS description_8, t0.migrate_id AS migrate_id_9, t0.migrate_info AS migrate_info_10, t0.page_id AS page_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14, t0.file_id AS file_id_15 FROM buckler_news_page_image t0 WHERE t0.page_id = 6905;

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
  INNER JOIN buckler_news_page_geo_city ON t0.id = buckler_news_page_geo_city.city_id
WHERE
  buckler_news_page_geo_city.page_id = ?

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 INNER JOIN buckler_news_page_geo_city ON t0.id = buckler_news_page_geo_city.city_id WHERE buckler_news_page_geo_city.page_id = 6905;

SELECT
  te.id AS id,
  te.created_at AS created_at,
  te.updated_at AS updated_at,
  te.system_deleted_at AS system_deleted_at,
  te.title AS title,
  te.code AS code,
  te.published AS published,
  te.description AS description,
  te.seo_no_index AS seo_no_index,
  te.seo_canonical AS seo_canonical,
  te.seo_h1 AS seo_h1,
  te.seo_title AS seo_title,
  te.seo_description AS seo_description,
  te.seo_keywords AS seo_keywords,
  te.published_at AS published_at,
  te.external_id AS external_id,
  te.content AS content,
  te.ordering AS ordering,
  te.analytics_views_per_day AS analytics_views_per_day,
  te.analytics_views_per_month AS analytics_views_per_month,
  te.analytics_views_total AS analytics_views_total,
  te.on_main_page AS on_main_page,
  te.migrate_id AS migrate_id,
  te.migrate_info AS migrate_info,
  te.created_by_id AS created_by_id,
  te.updated_by_id AS updated_by_id,
  te.deleted_by_id AS deleted_by_id,
  te.picture_id AS picture_id,
  te.detail_picture_id AS detail_picture_id
FROM
  buckler_media_gallery te
  JOIN buckler_media_gallery_group t ON t.gallery_id = te.id
WHERE
  t.group_id = ?
  AND te.published = ?
  AND te.on_main_page = ?
ORDER BY
  ordering DESC,
  published_at DESC
LIMIT
  10

SELECT te.id AS id, te.created_at AS created_at, te.updated_at AS updated_at, te.system_deleted_at AS system_deleted_at, te.title AS title, te.code AS code, te.published AS published, te.description AS description, te.seo_no_index AS seo_no_index, te.seo_canonical AS seo_canonical, te.seo_h1 AS seo_h1, te.seo_title AS seo_title, te.seo_description AS seo_description, te.seo_keywords AS seo_keywords, te.published_at AS published_at, te.external_id AS external_id, te.content AS content, te.ordering AS ordering, te.analytics_views_per_day AS analytics_views_per_day, te.analytics_views_per_month AS analytics_views_per_month, te.analytics_views_total AS analytics_views_total, te.on_main_page AS on_main_page, te.migrate_id AS migrate_id, te.migrate_info AS migrate_info, te.created_by_id AS created_by_id, te.updated_by_id AS updated_by_id, te.deleted_by_id AS deleted_by_id, te.picture_id AS picture_id, te.detail_picture_id AS detail_picture_id FROM buckler_media_gallery te JOIN buckler_media_gallery_group t ON t.gallery_id = te.id WHERE t.group_id = 31 AND te.published = 1 AND te.on_main_page = 1 ORDER BY ordering DESC, published_at DESC LIMIT 10;

SELECT
  b0_.has_photo AS has_photo_0,
  b0_.has_video AS has_video_1,
  b0_.image_handaled AS image_handaled_2,
  b0_.id AS id_3,
  b0_.created_at AS created_at_4,
  b0_.updated_at AS updated_at_5,
  b0_.system_deleted_at AS system_deleted_at_6,
  b0_.event_date AS event_date_7,
  b0_.event_title AS event_title_8,
  b0_.event_sub_title AS event_sub_title_9,
  b0_.title AS title_10,
  b0_.code AS code_11,
  b0_.auto_publish AS auto_publish_12,
  b0_.published AS published_13,
  b0_.published_at AS published_at_14,
  b0_.unpublished_at AS unpublished_at_15,
  b0_.ordering AS ordering_16,
  b0_.description AS description_17,
  b0_.seo_no_index AS seo_no_index_18,
  b0_.seo_canonical AS seo_canonical_19,
  b0_.seo_h1 AS seo_h1_20,
  b0_.seo_title AS seo_title_21,
  b0_.seo_description AS seo_description_22,
  b0_.seo_keywords AS seo_keywords_23,
  b0_.comments_enabled AS comments_enabled_24,
  b0_.content AS content_25,
  b0_.announce AS announce_26,
  b0_.external_id AS external_id_27,
  b0_.on_main_page AS on_main_page_28,
  b0_.analytics_views_per_day AS analytics_views_per_day_29,
  b0_.analytics_views_per_month AS analytics_views_per_month_30,
  b0_.analytics_views_total AS analytics_views_total_31,
  b0_.migrate_id AS migrate_id_32,
  b0_.migrate_info AS migrate_info_33,
  b0_.exclude_from_rss AS exclude_from_rss_34,
  b1_.id AS id_35,
  b1_.created_at AS created_at_36,
  b1_.updated_at AS updated_at_37,
  b1_.system_deleted_at AS system_deleted_at_38,
  b1_.title AS title_39,
  b1_.code AS code_40,
  b1_.published AS published_41,
  b1_.description AS description_42,
  b2_.id AS id_43,
  b2_.created_at AS created_at_44,
  b2_.updated_at AS updated_at_45,
  b2_.system_deleted_at AS system_deleted_at_46,
  b2_.title AS title_47,
  b2_.code AS code_48,
  b2_.published AS published_49,
  b2_.description AS description_50,
  b2_.migrate_id AS migrate_id_51,
  b2_.migrate_info AS migrate_info_52,
  b2_.ordering AS ordering_53,
  b2_.content AS content_54,
  b2_.exclude_from_rss AS exclude_from_rss_55,
  b3_.id AS id_56,
  b3_.created_at AS created_at_57,
  b3_.updated_at AS updated_at_58,
  b3_.system_deleted_at AS system_deleted_at_59,
  b3_.title AS title_60,
  b3_.published AS published_61,
  b3_.ordering AS ordering_62,
  b3_.description AS description_63,
  b3_.migrate_id AS migrate_id_64,
  b3_.migrate_info AS migrate_info_65,
  m4_.name AS name_66,
  m4_.description AS description_67,
  m4_.enabled AS enabled_68,
  m4_.provider_name AS provider_name_69,
  m4_.provider_status AS provider_status_70,
  m4_.provider_reference AS provider_reference_71,
  m4_.provider_metadata AS provider_metadata_72,
  m4_.width AS width_73,
  m4_.height AS height_74,
  m4_.length AS length_75,
  m4_.content_type AS content_type_76,
  m4_.content_size AS content_size_77,
  m4_.copyright AS copyright_78,
  m4_.author_name AS author_name_79,
  m4_.context AS context_80,
  m4_.cdn_is_flushable AS cdn_is_flushable_81,
  m4_.cdn_flush_identifier AS cdn_flush_identifier_82,
  m4_.cdn_flush_at AS cdn_flush_at_83,
  m4_.cdn_status AS cdn_status_84,
  m4_.updated_at AS updated_at_85,
  m4_.created_at AS created_at_86,
  m4_.id AS id_87,
  m5_.name AS name_88,
  m5_.description AS description_89,
  m5_.enabled AS enabled_90,
  m5_.provider_name AS provider_name_91,
  m5_.provider_status AS provider_status_92,
  m5_.provider_reference AS provider_reference_93,
  m5_.provider_metadata AS provider_metadata_94,
  m5_.width AS width_95,
  m5_.height AS height_96,
  m5_.length AS length_97,
  m5_.content_type AS content_type_98,
  m5_.content_size AS content_size_99,
  m5_.copyright AS copyright_100,
  m5_.author_name AS author_name_101,
  m5_.context AS context_102,
  m5_.cdn_is_flushable AS cdn_is_flushable_103,
  m5_.cdn_flush_identifier AS cdn_flush_identifier_104,
  m5_.cdn_flush_at AS cdn_flush_at_105,
  m5_.cdn_status AS cdn_status_106,
  m5_.updated_at AS updated_at_107,
  m5_.created_at AS created_at_108,
  m5_.id AS id_109,
  m6_.name AS name_110,
  m6_.description AS description_111,
  m6_.enabled AS enabled_112,
  m6_.provider_name AS provider_name_113,
  m6_.provider_status AS provider_status_114,
  m6_.provider_reference AS provider_reference_115,
  m6_.provider_metadata AS provider_metadata_116,
  m6_.width AS width_117,
  m6_.height AS height_118,
  m6_.length AS length_119,
  m6_.content_type AS content_type_120,
  m6_.content_size AS content_size_121,
  m6_.copyright AS copyright_122,
  m6_.author_name AS author_name_123,
  m6_.context AS context_124,
  m6_.cdn_is_flushable AS cdn_is_flushable_125,
  m6_.cdn_flush_identifier AS cdn_flush_identifier_126,
  m6_.cdn_flush_at AS cdn_flush_at_127,
  m6_.cdn_status AS cdn_status_128,
  m6_.updated_at AS updated_at_129,
  m6_.created_at AS created_at_130,
  m6_.id AS id_131,
  b0_.created_by_id AS created_by_id_132,
  b0_.updated_by_id AS updated_by_id_133,
  b0_.deleted_by_id AS deleted_by_id_134,
  b0_.background_picture_id AS background_picture_id_135,
  b0_.announce_picture_id AS announce_picture_id_136,
  b0_.social_network_picture_id AS social_network_picture_id_137,
  b0_.detail_picture_id AS detail_picture_id_138,
  b1_.created_by_id AS created_by_id_139,
  b1_.updated_by_id AS updated_by_id_140,
  b1_.deleted_by_id AS deleted_by_id_141,
  b2_.created_by_id AS created_by_id_142,
  b2_.updated_by_id AS updated_by_id_143,
  b2_.deleted_by_id AS deleted_by_id_144,
  b3_.page_id AS page_id_145,
  b3_.created_by_id AS created_by_id_146,
  b3_.updated_by_id AS updated_by_id_147,
  b3_.deleted_by_id AS deleted_by_id_148,
  b3_.file_id AS file_id_149
FROM
  buckler_news_page b0_
  LEFT JOIN buckler_news_page_tag b7_ ON b0_.id = b7_.page_id
  LEFT JOIN buckler_tag b1_ ON b1_.id = b7_.tag_id
  LEFT JOIN buckler_news_page_group b8_ ON b0_.id = b8_.page_id
  LEFT JOIN buckler_news_group b2_ ON b2_.id = b8_.group_id
  LEFT JOIN buckler_news_page_file b3_ ON b0_.id = b3_.page_id
  LEFT JOIN media__media m4_ ON b3_.file_id = m4_.id
  LEFT JOIN media__media m5_ ON b0_.announce_picture_id = m5_.id
  LEFT JOIN media__media m6_ ON b0_.detail_picture_id = m6_.id
WHERE
  b0_.published = ?
  AND b0_.on_main_page = ?
  AND b2_.code IN (?)
  AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.published_at DESC