4.32 ms
(62.32%)
|
1 |
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 b2_.code IN (?)) dctrn_result_inner ORDER BY published_at_14 DESC) dctrn_result LIMIT 48
Parameters: [
1
"sitemap.xml"
]
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 b2_.code IN (?)
) dctrn_result_inner
ORDER BY
published_at_14 DESC
) dctrn_result
LIMIT
48
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 b2_.code IN ('sitemap.xml')) dctrn_result_inner ORDER BY published_at_14 DESC) dctrn_result LIMIT 48;
|
2.61 ms
(37.68%)
|
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 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 b2_.code IN (?) ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table
Parameters: [
1
"sitemap.xml"
]
SELECT
COUNT(*) AS dctrn_count
FROM
(
SELECT
DISTINCT id_3
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 b2_.code IN (?)
ORDER BY
b0_.published_at DESC
) dctrn_result
) dctrn_table
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 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 b2_.code IN ('sitemap.xml') ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table;
|