10.71 ms
(24.87%)
|
2 |
SELECT t0.post_id AS post_id_1, t0.recommended AS recommended_2, t0.important AS important_3, t0.detail_type AS detail_type_4, t0.link_url AS link_url_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.meta_h1 AS meta_h1_9, t0.custom_html AS custom_html_10, t0.is_imported AS is_imported_11, t0.period AS period_12, t0.list_text AS list_text_13, t0.public_date AS public_date_14, t0.customblock AS customblock_15, t0.id AS id_16, t0.sort_num AS sort_num_17, t0.status AS status_18, t0.publish_at AS publish_at_19, t0.expires_at AS expires_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.title AS title_23, t0.language_parent AS language_parent_24, t0.language_alias AS language_alias_25, t0.language_active AS language_active_26, t0.revision_parent AS revision_parent_27, t0.revision_version AS revision_version_28, t0.post_type AS post_type_29, t0.access_token AS access_token_30, t0.common_thumbnail AS common_thumbnail_31, t0.thumbnail AS thumbnail_32, t33.alt AS alt_34, t33.caption AS caption_35, t33.collation_code AS collation_code_36, t33.meta AS meta_37, t33.id AS id_38, t33.sort_num AS sort_num_39, t33.status AS status_40, t33.publish_at AS publish_at_41, t33.expires_at AS expires_at_42, t33.created_at AS created_at_43, t33.updated_at AS updated_at_44, t33.title AS title_45, t33.item_id AS item_id_46, t33.thumb_item_id AS thumb_item_id_47, t33.group_id AS group_id_48, t33.created_by AS created_by_49, t33.updated_by AS updated_by_50, t0.facility_id AS facility_id_51, t52.code AS code_53, t52.title AS title_54, t52.intro_text AS intro_text_55, t52.zip AS zip_56, t52.address AS address_57, t52.building AS building_58, t52.google_maps_url AS google_maps_url_59, t52.phone AS phone_60, t52.website AS website_61, t52.opening_hours AS opening_hours_62, t52.holiday AS holiday_63, t52.access AS access_64, t52.access_car AS access_car_65, t52.access_train AS access_train_66, t52.id AS id_67, t52.sort_num AS sort_num_68, t52.status AS status_69, t52.publish_at AS publish_at_70, t52.expires_at AS expires_at_71, t52.created_at AS created_at_72, t52.updated_at AS updated_at_73, t52.area_id AS area_id_74, t52.prefecture_id AS prefecture_id_75, t52.logo_image AS logo_image_76, t52.main_image AS main_image_77, t52.created_by AS created_by_78, t52.updated_by AS updated_by_79, t0.created_by AS created_by_80, t81.username AS username_82, t81.username_canonical AS username_canonical_83, t81.enabled AS enabled_84, t81.last_login AS last_login_85, t81.confirmation_token AS confirmation_token_86, t81.password_requested_at AS password_requested_at_87, t81.roles AS roles_88, t81.id AS id_89, t81.display_name AS display_name_90, t81.sort_num AS sort_num_91, t81.email AS email_92, t81.email_canonical AS email_canonical_93, t81.salt AS salt_94, t81.password AS password_95, t81.group_id AS group_id_96, t81.facility_id AS facility_id_97, t0.updated_by AS updated_by_98, t99.username AS username_100, t99.username_canonical AS username_canonical_101, t99.enabled AS enabled_102, t99.last_login AS last_login_103, t99.confirmation_token AS confirmation_token_104, t99.password_requested_at AS password_requested_at_105, t99.roles AS roles_106, t99.id AS id_107, t99.display_name AS display_name_108, t99.sort_num AS sort_num_109, t99.email AS email_110, t99.email_canonical AS email_canonical_111, t99.salt AS salt_112, t99.password AS password_113, t99.group_id AS group_id_114, t99.facility_id AS facility_id_115, t0.language_id AS language_id_116, t117.alias AS alias_118, t117.translate_key AS translate_key_119, t117.target_key AS target_key_120, t117.id AS id_121, t117.sort_num AS sort_num_122, t117.status AS status_123, t117.publish_at AS publish_at_124, t117.expires_at AS expires_at_125, t117.created_at AS created_at_126, t117.updated_at AS updated_at_127, t117.title AS title_128, t117.created_by AS created_by_129, t117.updated_by AS updated_by_130, t0.latest_approval_request_id AS latest_approval_request_id_131, t132.id AS id_133, t132.handler_name AS handler_name_134, t132.title AS title_135, t132.target_id AS target_id_136, t132.request_type AS request_type_137, t132.moderated_at AS moderated_at_138, t132.approval_status AS approval_status_139, t132.comment AS comment_140, t132.created_at AS created_at_141, t132.updated_at AS updated_at_142, t132.facility_id AS facility_id_143, t132.requested_by AS requested_by_144, t132.moderated_by AS moderated_by_145 FROM cms_mod_topics_posts t0 LEFT JOIN cms_media_item_details t33 ON t0.thumbnail = t33.id AND ((t33.status = 1 AND (t33.publish_at IS NULL OR t33.publish_at <= "2025-09-17 13:08:03") AND (t33.expires_at IS NULL OR t33.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_facility t52 ON t0.facility_id = t52.id AND ((t52.status = 1 AND (t52.publish_at IS NULL OR t52.publish_at <= "2025-09-17 13:08:03") AND (t52.expires_at IS NULL OR t52.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_user t81 ON t0.created_by = t81.id LEFT JOIN cms_user t99 ON t0.updated_by = t99.id LEFT JOIN cms_master_languages t117 ON t0.language_id = t117.id AND ((t117.status = 1 AND (t117.publish_at IS NULL OR t117.publish_at <= "2025-09-17 13:08:03") AND (t117.expires_at IS NULL OR t117.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_approval_requests t132 ON t0.latest_approval_request_id = t132.id INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.item_id WHERE cms_mod_topics_post_category.category_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17")))
SELECT
t0.post_id AS post_id_1,
t0.recommended AS recommended_2,
t0.important AS important_3,
t0.detail_type AS detail_type_4,
t0.link_url AS link_url_5,
t0.meta_title AS meta_title_6,
t0.meta_keywords AS meta_keywords_7,
t0.meta_description AS meta_description_8,
t0.meta_h1 AS meta_h1_9,
t0.custom_html AS custom_html_10,
t0.is_imported AS is_imported_11,
t0.period AS period_12,
t0.list_text AS list_text_13,
t0.public_date AS public_date_14,
t0.customblock AS customblock_15,
t0.id AS id_16,
t0.sort_num AS sort_num_17,
t0.status AS status_18,
t0.publish_at AS publish_at_19,
t0.expires_at AS expires_at_20,
t0.created_at AS created_at_21,
t0.updated_at AS updated_at_22,
t0.title AS title_23,
t0.language_parent AS language_parent_24,
t0.language_alias AS language_alias_25,
t0.language_active AS language_active_26,
t0.revision_parent AS revision_parent_27,
t0.revision_version AS revision_version_28,
t0.post_type AS post_type_29,
t0.access_token AS access_token_30,
t0.common_thumbnail AS common_thumbnail_31,
t0.thumbnail AS thumbnail_32,
t33.alt AS alt_34,
t33.caption AS caption_35,
t33.collation_code AS collation_code_36,
t33.meta AS meta_37,
t33.id AS id_38,
t33.sort_num AS sort_num_39,
t33.status AS status_40,
t33.publish_at AS publish_at_41,
t33.expires_at AS expires_at_42,
t33.created_at AS created_at_43,
t33.updated_at AS updated_at_44,
t33.title AS title_45,
t33.item_id AS item_id_46,
t33.thumb_item_id AS thumb_item_id_47,
t33.group_id AS group_id_48,
t33.created_by AS created_by_49,
t33.updated_by AS updated_by_50,
t0.facility_id AS facility_id_51,
t52.code AS code_53,
t52.title AS title_54,
t52.intro_text AS intro_text_55,
t52.zip AS zip_56,
t52.address AS address_57,
t52.building AS building_58,
t52.google_maps_url AS google_maps_url_59,
t52.phone AS phone_60,
t52.website AS website_61,
t52.opening_hours AS opening_hours_62,
t52.holiday AS holiday_63,
t52.access AS access_64,
t52.access_car AS access_car_65,
t52.access_train AS access_train_66,
t52.id AS id_67,
t52.sort_num AS sort_num_68,
t52.status AS status_69,
t52.publish_at AS publish_at_70,
t52.expires_at AS expires_at_71,
t52.created_at AS created_at_72,
t52.updated_at AS updated_at_73,
t52.area_id AS area_id_74,
t52.prefecture_id AS prefecture_id_75,
t52.logo_image AS logo_image_76,
t52.main_image AS main_image_77,
t52.created_by AS created_by_78,
t52.updated_by AS updated_by_79,
t0.created_by AS created_by_80,
t81.username AS username_82,
t81.username_canonical AS username_canonical_83,
t81.enabled AS enabled_84,
t81.last_login AS last_login_85,
t81.confirmation_token AS confirmation_token_86,
t81.password_requested_at AS password_requested_at_87,
t81.roles AS roles_88,
t81.id AS id_89,
t81.display_name AS display_name_90,
t81.sort_num AS sort_num_91,
t81.email AS email_92,
t81.email_canonical AS email_canonical_93,
t81.salt AS salt_94,
t81.password AS password_95,
t81.group_id AS group_id_96,
t81.facility_id AS facility_id_97,
t0.updated_by AS updated_by_98,
t99.username AS username_100,
t99.username_canonical AS username_canonical_101,
t99.enabled AS enabled_102,
t99.last_login AS last_login_103,
t99.confirmation_token AS confirmation_token_104,
t99.password_requested_at AS password_requested_at_105,
t99.roles AS roles_106,
t99.id AS id_107,
t99.display_name AS display_name_108,
t99.sort_num AS sort_num_109,
t99.email AS email_110,
t99.email_canonical AS email_canonical_111,
t99.salt AS salt_112,
t99.password AS password_113,
t99.group_id AS group_id_114,
t99.facility_id AS facility_id_115,
t0.language_id AS language_id_116,
t117.alias AS alias_118,
t117.translate_key AS translate_key_119,
t117.target_key AS target_key_120,
t117.id AS id_121,
t117.sort_num AS sort_num_122,
t117.status AS status_123,
t117.publish_at AS publish_at_124,
t117.expires_at AS expires_at_125,
t117.created_at AS created_at_126,
t117.updated_at AS updated_at_127,
t117.title AS title_128,
t117.created_by AS created_by_129,
t117.updated_by AS updated_by_130,
t0.latest_approval_request_id AS latest_approval_request_id_131,
t132.id AS id_133,
t132.handler_name AS handler_name_134,
t132.title AS title_135,
t132.target_id AS target_id_136,
t132.request_type AS request_type_137,
t132.moderated_at AS moderated_at_138,
t132.approval_status AS approval_status_139,
t132.comment AS comment_140,
t132.created_at AS created_at_141,
t132.updated_at AS updated_at_142,
t132.facility_id AS facility_id_143,
t132.requested_by AS requested_by_144,
t132.moderated_by AS moderated_by_145
FROM
cms_mod_topics_posts t0
LEFT JOIN cms_media_item_details t33 ON t0.thumbnail = t33.id
AND (
(
t33.status = 1
AND (
t33.publish_at IS NULL
OR t33.publish_at <= "2025-09-17 13:08:03"
)
AND (
t33.expires_at IS NULL
OR t33.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_facility t52 ON t0.facility_id = t52.id
AND (
(
t52.status = 1
AND (
t52.publish_at IS NULL
OR t52.publish_at <= "2025-09-17 13:08:03"
)
AND (
t52.expires_at IS NULL
OR t52.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_user t81 ON t0.created_by = t81.id
LEFT JOIN cms_user t99 ON t0.updated_by = t99.id
LEFT JOIN cms_master_languages t117 ON t0.language_id = t117.id
AND (
(
t117.status = 1
AND (
t117.publish_at IS NULL
OR t117.publish_at <= "2025-09-17 13:08:03"
)
AND (
t117.expires_at IS NULL
OR t117.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_approval_requests t132 ON t0.latest_approval_request_id = t132.id
INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.item_id
WHERE
cms_mod_topics_post_category.category_id = ?
AND (
(
t0.post_type IN ("master")
)
AND (
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 13:08:03"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 13:08:03"
)
AND (
t0.public_date IS NULL
OR t0.public_date <= "2025-09-17"
)
)
)
SELECT t0.post_id AS post_id_1, t0.recommended AS recommended_2, t0.important AS important_3, t0.detail_type AS detail_type_4, t0.link_url AS link_url_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.meta_h1 AS meta_h1_9, t0.custom_html AS custom_html_10, t0.is_imported AS is_imported_11, t0.period AS period_12, t0.list_text AS list_text_13, t0.public_date AS public_date_14, t0.customblock AS customblock_15, t0.id AS id_16, t0.sort_num AS sort_num_17, t0.status AS status_18, t0.publish_at AS publish_at_19, t0.expires_at AS expires_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.title AS title_23, t0.language_parent AS language_parent_24, t0.language_alias AS language_alias_25, t0.language_active AS language_active_26, t0.revision_parent AS revision_parent_27, t0.revision_version AS revision_version_28, t0.post_type AS post_type_29, t0.access_token AS access_token_30, t0.common_thumbnail AS common_thumbnail_31, t0.thumbnail AS thumbnail_32, t33.alt AS alt_34, t33.caption AS caption_35, t33.collation_code AS collation_code_36, t33.meta AS meta_37, t33.id AS id_38, t33.sort_num AS sort_num_39, t33.status AS status_40, t33.publish_at AS publish_at_41, t33.expires_at AS expires_at_42, t33.created_at AS created_at_43, t33.updated_at AS updated_at_44, t33.title AS title_45, t33.item_id AS item_id_46, t33.thumb_item_id AS thumb_item_id_47, t33.group_id AS group_id_48, t33.created_by AS created_by_49, t33.updated_by AS updated_by_50, t0.facility_id AS facility_id_51, t52.code AS code_53, t52.title AS title_54, t52.intro_text AS intro_text_55, t52.zip AS zip_56, t52.address AS address_57, t52.building AS building_58, t52.google_maps_url AS google_maps_url_59, t52.phone AS phone_60, t52.website AS website_61, t52.opening_hours AS opening_hours_62, t52.holiday AS holiday_63, t52.access AS access_64, t52.access_car AS access_car_65, t52.access_train AS access_train_66, t52.id AS id_67, t52.sort_num AS sort_num_68, t52.status AS status_69, t52.publish_at AS publish_at_70, t52.expires_at AS expires_at_71, t52.created_at AS created_at_72, t52.updated_at AS updated_at_73, t52.area_id AS area_id_74, t52.prefecture_id AS prefecture_id_75, t52.logo_image AS logo_image_76, t52.main_image AS main_image_77, t52.created_by AS created_by_78, t52.updated_by AS updated_by_79, t0.created_by AS created_by_80, t81.username AS username_82, t81.username_canonical AS username_canonical_83, t81.enabled AS enabled_84, t81.last_login AS last_login_85, t81.confirmation_token AS confirmation_token_86, t81.password_requested_at AS password_requested_at_87, t81.roles AS roles_88, t81.id AS id_89, t81.display_name AS display_name_90, t81.sort_num AS sort_num_91, t81.email AS email_92, t81.email_canonical AS email_canonical_93, t81.salt AS salt_94, t81.password AS password_95, t81.group_id AS group_id_96, t81.facility_id AS facility_id_97, t0.updated_by AS updated_by_98, t99.username AS username_100, t99.username_canonical AS username_canonical_101, t99.enabled AS enabled_102, t99.last_login AS last_login_103, t99.confirmation_token AS confirmation_token_104, t99.password_requested_at AS password_requested_at_105, t99.roles AS roles_106, t99.id AS id_107, t99.display_name AS display_name_108, t99.sort_num AS sort_num_109, t99.email AS email_110, t99.email_canonical AS email_canonical_111, t99.salt AS salt_112, t99.password AS password_113, t99.group_id AS group_id_114, t99.facility_id AS facility_id_115, t0.language_id AS language_id_116, t117.alias AS alias_118, t117.translate_key AS translate_key_119, t117.target_key AS target_key_120, t117.id AS id_121, t117.sort_num AS sort_num_122, t117.status AS status_123, t117.publish_at AS publish_at_124, t117.expires_at AS expires_at_125, t117.created_at AS created_at_126, t117.updated_at AS updated_at_127, t117.title AS title_128, t117.created_by AS created_by_129, t117.updated_by AS updated_by_130, t0.latest_approval_request_id AS latest_approval_request_id_131, t132.id AS id_133, t132.handler_name AS handler_name_134, t132.title AS title_135, t132.target_id AS target_id_136, t132.request_type AS request_type_137, t132.moderated_at AS moderated_at_138, t132.approval_status AS approval_status_139, t132.comment AS comment_140, t132.created_at AS created_at_141, t132.updated_at AS updated_at_142, t132.facility_id AS facility_id_143, t132.requested_by AS requested_by_144, t132.moderated_by AS moderated_by_145 FROM cms_mod_topics_posts t0 LEFT JOIN cms_media_item_details t33 ON t0.thumbnail = t33.id AND ((t33.status = 1 AND (t33.publish_at IS NULL OR t33.publish_at <= "2025-09-17 131:03") AND (t33.expires_at IS NULL OR t33.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_facility t52 ON t0.facility_id = t52.id AND ((t52.status = 1 AND (t52.publish_at IS NULL OR t52.publish_at <= "2025-09-17 13:08:03") AND (t52.expires_at IS NULL OR t52.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_user t81 ON t0.created_by = t81.id LEFT JOIN cms_user t99 ON t0.updated_by = t99.id LEFT JOIN cms_master_languages t117 ON t0.language_id = t117.id AND ((t117.status = 1 AND (t117.publish_at IS NULL OR t117.publish_at <= "2025-09-17 13:08:03") AND (t117.expires_at IS NULL OR t117.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_approval_requests t132 ON t0.latest_approval_request_id = t132.id INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.item_id WHERE cms_mod_topics_post_category.category_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17")));
|
4.97 ms
(11.54%)
|
2 |
SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2025-09-17 13:08:03") AND (t16.expires_at IS NULL OR t16.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2025-09-17 13:08:03") AND (t37.expires_at IS NULL OR t37.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2025-09-17 13:08:03") AND (t102.expires_at IS NULL OR t102.expires_at > "2025-09-17 13:08:03"))) WHERE t0.parent_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03"))) ORDER BY t0.sort_num ASC, t0.id ASC
SELECT
t0.is_root AS is_root_1,
t0.category_role AS category_role_2,
t0.id AS id_3,
t0.sort_num AS sort_num_4,
t0.status AS status_5,
t0.publish_at AS publish_at_6,
t0.expires_at AS expires_at_7,
t0.created_at AS created_at_8,
t0.updated_at AS updated_at_9,
t0.title AS title_10,
t0.language_parent AS language_parent_11,
t0.language_alias AS language_alias_12,
t0.language_active AS language_active_13,
t0.lock_flags AS lock_flags_14,
t0.parent_id AS parent_id_15,
t16.is_root AS is_root_17,
t16.category_role AS category_role_18,
t16.id AS id_19,
t16.sort_num AS sort_num_20,
t16.status AS status_21,
t16.publish_at AS publish_at_22,
t16.expires_at AS expires_at_23,
t16.created_at AS created_at_24,
t16.updated_at AS updated_at_25,
t16.title AS title_26,
t16.language_parent AS language_parent_27,
t16.language_alias AS language_alias_28,
t16.language_active AS language_active_29,
t16.lock_flags AS lock_flags_30,
t16.parent_id AS parent_id_31,
t16.facility_id AS facility_id_32,
t16.created_by AS created_by_33,
t16.updated_by AS updated_by_34,
t16.language_id AS language_id_35,
t0.facility_id AS facility_id_36,
t37.code AS code_38,
t37.title AS title_39,
t37.intro_text AS intro_text_40,
t37.zip AS zip_41,
t37.address AS address_42,
t37.building AS building_43,
t37.google_maps_url AS google_maps_url_44,
t37.phone AS phone_45,
t37.website AS website_46,
t37.opening_hours AS opening_hours_47,
t37.holiday AS holiday_48,
t37.access AS access_49,
t37.access_car AS access_car_50,
t37.access_train AS access_train_51,
t37.id AS id_52,
t37.sort_num AS sort_num_53,
t37.status AS status_54,
t37.publish_at AS publish_at_55,
t37.expires_at AS expires_at_56,
t37.created_at AS created_at_57,
t37.updated_at AS updated_at_58,
t37.area_id AS area_id_59,
t37.prefecture_id AS prefecture_id_60,
t37.logo_image AS logo_image_61,
t37.main_image AS main_image_62,
t37.created_by AS created_by_63,
t37.updated_by AS updated_by_64,
t0.created_by AS created_by_65,
t66.username AS username_67,
t66.username_canonical AS username_canonical_68,
t66.enabled AS enabled_69,
t66.last_login AS last_login_70,
t66.confirmation_token AS confirmation_token_71,
t66.password_requested_at AS password_requested_at_72,
t66.roles AS roles_73,
t66.id AS id_74,
t66.display_name AS display_name_75,
t66.sort_num AS sort_num_76,
t66.email AS email_77,
t66.email_canonical AS email_canonical_78,
t66.salt AS salt_79,
t66.password AS password_80,
t66.group_id AS group_id_81,
t66.facility_id AS facility_id_82,
t0.updated_by AS updated_by_83,
t84.username AS username_85,
t84.username_canonical AS username_canonical_86,
t84.enabled AS enabled_87,
t84.last_login AS last_login_88,
t84.confirmation_token AS confirmation_token_89,
t84.password_requested_at AS password_requested_at_90,
t84.roles AS roles_91,
t84.id AS id_92,
t84.display_name AS display_name_93,
t84.sort_num AS sort_num_94,
t84.email AS email_95,
t84.email_canonical AS email_canonical_96,
t84.salt AS salt_97,
t84.password AS password_98,
t84.group_id AS group_id_99,
t84.facility_id AS facility_id_100,
t0.language_id AS language_id_101,
t102.alias AS alias_103,
t102.translate_key AS translate_key_104,
t102.target_key AS target_key_105,
t102.id AS id_106,
t102.sort_num AS sort_num_107,
t102.status AS status_108,
t102.publish_at AS publish_at_109,
t102.expires_at AS expires_at_110,
t102.created_at AS created_at_111,
t102.updated_at AS updated_at_112,
t102.title AS title_113,
t102.created_by AS created_by_114,
t102.updated_by AS updated_by_115
FROM
cms_mod_topics_categories t0
LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id
AND (
(
t16.status = 1
AND (
t16.publish_at IS NULL
OR t16.publish_at <= "2025-09-17 13:08:03"
)
AND (
t16.expires_at IS NULL
OR t16.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id
AND (
(
t37.status = 1
AND (
t37.publish_at IS NULL
OR t37.publish_at <= "2025-09-17 13:08:03"
)
AND (
t37.expires_at IS NULL
OR t37.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_user t66 ON t0.created_by = t66.id
LEFT JOIN cms_user t84 ON t0.updated_by = t84.id
LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id
AND (
(
t102.status = 1
AND (
t102.publish_at IS NULL
OR t102.publish_at <= "2025-09-17 13:08:03"
)
AND (
t102.expires_at IS NULL
OR t102.expires_at > "2025-09-17 13:08:03"
)
)
)
WHERE
t0.parent_id = ?
AND (
(
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 13:08:03"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 13:08:03"
)
)
)
ORDER BY
t0.sort_num ASC,
t0.id ASC
SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2025-09-17 131:03") AND (t16.expires_at IS NULL OR t16.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2025-09-17 13:08:03") AND (t37.expires_at IS NULL OR t37.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2025-09-17 13:08:03") AND (t102.expires_at IS NULL OR t102.expires_at > "2025-09-17 13:08:03"))) WHERE t0.parent_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03"))) ORDER BY t0.sort_num ASC, t0.id ASC;
|
3.95 ms
(9.16%)
|
2 |
SELECT c0_.is_root AS is_root_0, c0_.category_role AS category_role_1, c0_.id AS id_2, c0_.sort_num AS sort_num_3, c0_.status AS status_4, c0_.publish_at AS publish_at_5, c0_.expires_at AS expires_at_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.title AS title_9, c0_.language_parent AS language_parent_10, c0_.language_alias AS language_alias_11, c0_.language_active AS language_active_12, c0_.lock_flags AS lock_flags_13, c0_.parent_id AS parent_id_14, c0_.facility_id AS facility_id_15, c0_.created_by AS created_by_16, c0_.updated_by AS updated_by_17, c0_.language_id AS language_id_18 FROM cms_mod_topics_categories c0_ WHERE (c0_.parent_id IS NULL) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2025-09-17 13:08:03") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2025-09-17 13:08:03")) ORDER BY c0_.sort_num ASC
SELECT c0_.is_root AS is_root_0, c0_.category_role AS category_role_1, c0_.id AS id_2, c0_.sort_num AS sort_num_3, c0_.status AS status_4, c0_.publish_at AS publish_at_5, c0_.expires_at AS expires_at_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.title AS title_9, c0_.language_parent AS language_parent_10, c0_.language_alias AS language_alias_11, c0_.language_active AS language_active_12, c0_.lock_flags AS lock_flags_13, c0_.parent_id AS parent_id_14, c0_.facility_id AS facility_id_15, c0_.created_by AS created_by_16, c0_.updated_by AS updated_by_17, c0_.language_id AS language_id_18 FROM cms_mod_topics_categories c0_ WHERE (c0_.parent_id IS NULL) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2025-09-17 13:08:03") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2025-09-17 13:08:03")) ORDER BY c0_.sort_num ASC;
|
3.34 ms
(7.76%)
|
1 |
SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2025-09-17 13:08:03") AND (t16.expires_at IS NULL OR t16.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2025-09-17 13:08:03") AND (t37.expires_at IS NULL OR t37.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2025-09-17 13:08:03") AND (t102.expires_at IS NULL OR t102.expires_at > "2025-09-17 13:08:03"))) INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id WHERE cms_mod_topics_post_category.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03"))) ORDER BY t0.sort_num ASC, t0.id ASC
SELECT
t0.is_root AS is_root_1,
t0.category_role AS category_role_2,
t0.id AS id_3,
t0.sort_num AS sort_num_4,
t0.status AS status_5,
t0.publish_at AS publish_at_6,
t0.expires_at AS expires_at_7,
t0.created_at AS created_at_8,
t0.updated_at AS updated_at_9,
t0.title AS title_10,
t0.language_parent AS language_parent_11,
t0.language_alias AS language_alias_12,
t0.language_active AS language_active_13,
t0.lock_flags AS lock_flags_14,
t0.parent_id AS parent_id_15,
t16.is_root AS is_root_17,
t16.category_role AS category_role_18,
t16.id AS id_19,
t16.sort_num AS sort_num_20,
t16.status AS status_21,
t16.publish_at AS publish_at_22,
t16.expires_at AS expires_at_23,
t16.created_at AS created_at_24,
t16.updated_at AS updated_at_25,
t16.title AS title_26,
t16.language_parent AS language_parent_27,
t16.language_alias AS language_alias_28,
t16.language_active AS language_active_29,
t16.lock_flags AS lock_flags_30,
t16.parent_id AS parent_id_31,
t16.facility_id AS facility_id_32,
t16.created_by AS created_by_33,
t16.updated_by AS updated_by_34,
t16.language_id AS language_id_35,
t0.facility_id AS facility_id_36,
t37.code AS code_38,
t37.title AS title_39,
t37.intro_text AS intro_text_40,
t37.zip AS zip_41,
t37.address AS address_42,
t37.building AS building_43,
t37.google_maps_url AS google_maps_url_44,
t37.phone AS phone_45,
t37.website AS website_46,
t37.opening_hours AS opening_hours_47,
t37.holiday AS holiday_48,
t37.access AS access_49,
t37.access_car AS access_car_50,
t37.access_train AS access_train_51,
t37.id AS id_52,
t37.sort_num AS sort_num_53,
t37.status AS status_54,
t37.publish_at AS publish_at_55,
t37.expires_at AS expires_at_56,
t37.created_at AS created_at_57,
t37.updated_at AS updated_at_58,
t37.area_id AS area_id_59,
t37.prefecture_id AS prefecture_id_60,
t37.logo_image AS logo_image_61,
t37.main_image AS main_image_62,
t37.created_by AS created_by_63,
t37.updated_by AS updated_by_64,
t0.created_by AS created_by_65,
t66.username AS username_67,
t66.username_canonical AS username_canonical_68,
t66.enabled AS enabled_69,
t66.last_login AS last_login_70,
t66.confirmation_token AS confirmation_token_71,
t66.password_requested_at AS password_requested_at_72,
t66.roles AS roles_73,
t66.id AS id_74,
t66.display_name AS display_name_75,
t66.sort_num AS sort_num_76,
t66.email AS email_77,
t66.email_canonical AS email_canonical_78,
t66.salt AS salt_79,
t66.password AS password_80,
t66.group_id AS group_id_81,
t66.facility_id AS facility_id_82,
t0.updated_by AS updated_by_83,
t84.username AS username_85,
t84.username_canonical AS username_canonical_86,
t84.enabled AS enabled_87,
t84.last_login AS last_login_88,
t84.confirmation_token AS confirmation_token_89,
t84.password_requested_at AS password_requested_at_90,
t84.roles AS roles_91,
t84.id AS id_92,
t84.display_name AS display_name_93,
t84.sort_num AS sort_num_94,
t84.email AS email_95,
t84.email_canonical AS email_canonical_96,
t84.salt AS salt_97,
t84.password AS password_98,
t84.group_id AS group_id_99,
t84.facility_id AS facility_id_100,
t0.language_id AS language_id_101,
t102.alias AS alias_103,
t102.translate_key AS translate_key_104,
t102.target_key AS target_key_105,
t102.id AS id_106,
t102.sort_num AS sort_num_107,
t102.status AS status_108,
t102.publish_at AS publish_at_109,
t102.expires_at AS expires_at_110,
t102.created_at AS created_at_111,
t102.updated_at AS updated_at_112,
t102.title AS title_113,
t102.created_by AS created_by_114,
t102.updated_by AS updated_by_115
FROM
cms_mod_topics_categories t0
LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id
AND (
(
t16.status = 1
AND (
t16.publish_at IS NULL
OR t16.publish_at <= "2025-09-17 13:08:03"
)
AND (
t16.expires_at IS NULL
OR t16.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id
AND (
(
t37.status = 1
AND (
t37.publish_at IS NULL
OR t37.publish_at <= "2025-09-17 13:08:03"
)
AND (
t37.expires_at IS NULL
OR t37.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_user t66 ON t0.created_by = t66.id
LEFT JOIN cms_user t84 ON t0.updated_by = t84.id
LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id
AND (
(
t102.status = 1
AND (
t102.publish_at IS NULL
OR t102.publish_at <= "2025-09-17 13:08:03"
)
AND (
t102.expires_at IS NULL
OR t102.expires_at > "2025-09-17 13:08:03"
)
)
)
INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id
WHERE
cms_mod_topics_post_category.item_id = ?
AND (
(
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 13:08:03"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 13:08:03"
)
)
)
ORDER BY
t0.sort_num ASC,
t0.id ASC
SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2025-09-17 1315:03") AND (t16.expires_at IS NULL OR t16.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2025-09-17 13:08:03") AND (t37.expires_at IS NULL OR t37.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2025-09-17 13:08:03") AND (t102.expires_at IS NULL OR t102.expires_at > "2025-09-17 13:08:03"))) INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id WHERE cms_mod_topics_post_category.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03"))) ORDER BY t0.sort_num ASC, t0.id ASC;
|
2.76 ms
(6.40%)
|
1 |
SELECT t0.post_id AS post_id_1, t0.recommended AS recommended_2, t0.important AS important_3, t0.detail_type AS detail_type_4, t0.link_url AS link_url_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.meta_h1 AS meta_h1_9, t0.custom_html AS custom_html_10, t0.is_imported AS is_imported_11, t0.period AS period_12, t0.list_text AS list_text_13, t0.public_date AS public_date_14, t0.customblock AS customblock_15, t0.id AS id_16, t0.sort_num AS sort_num_17, t0.status AS status_18, t0.publish_at AS publish_at_19, t0.expires_at AS expires_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.title AS title_23, t0.language_parent AS language_parent_24, t0.language_alias AS language_alias_25, t0.language_active AS language_active_26, t0.revision_parent AS revision_parent_27, t0.revision_version AS revision_version_28, t0.post_type AS post_type_29, t0.access_token AS access_token_30, t0.common_thumbnail AS common_thumbnail_31, t0.thumbnail AS thumbnail_32, t33.alt AS alt_34, t33.caption AS caption_35, t33.collation_code AS collation_code_36, t33.meta AS meta_37, t33.id AS id_38, t33.sort_num AS sort_num_39, t33.status AS status_40, t33.publish_at AS publish_at_41, t33.expires_at AS expires_at_42, t33.created_at AS created_at_43, t33.updated_at AS updated_at_44, t33.title AS title_45, t33.item_id AS item_id_46, t33.thumb_item_id AS thumb_item_id_47, t33.group_id AS group_id_48, t33.created_by AS created_by_49, t33.updated_by AS updated_by_50, t0.facility_id AS facility_id_51, t52.code AS code_53, t52.title AS title_54, t52.intro_text AS intro_text_55, t52.zip AS zip_56, t52.address AS address_57, t52.building AS building_58, t52.google_maps_url AS google_maps_url_59, t52.phone AS phone_60, t52.website AS website_61, t52.opening_hours AS opening_hours_62, t52.holiday AS holiday_63, t52.access AS access_64, t52.access_car AS access_car_65, t52.access_train AS access_train_66, t52.id AS id_67, t52.sort_num AS sort_num_68, t52.status AS status_69, t52.publish_at AS publish_at_70, t52.expires_at AS expires_at_71, t52.created_at AS created_at_72, t52.updated_at AS updated_at_73, t52.area_id AS area_id_74, t52.prefecture_id AS prefecture_id_75, t52.logo_image AS logo_image_76, t52.main_image AS main_image_77, t52.created_by AS created_by_78, t52.updated_by AS updated_by_79, t0.created_by AS created_by_80, t81.username AS username_82, t81.username_canonical AS username_canonical_83, t81.enabled AS enabled_84, t81.last_login AS last_login_85, t81.confirmation_token AS confirmation_token_86, t81.password_requested_at AS password_requested_at_87, t81.roles AS roles_88, t81.id AS id_89, t81.display_name AS display_name_90, t81.sort_num AS sort_num_91, t81.email AS email_92, t81.email_canonical AS email_canonical_93, t81.salt AS salt_94, t81.password AS password_95, t81.group_id AS group_id_96, t81.facility_id AS facility_id_97, t0.updated_by AS updated_by_98, t99.username AS username_100, t99.username_canonical AS username_canonical_101, t99.enabled AS enabled_102, t99.last_login AS last_login_103, t99.confirmation_token AS confirmation_token_104, t99.password_requested_at AS password_requested_at_105, t99.roles AS roles_106, t99.id AS id_107, t99.display_name AS display_name_108, t99.sort_num AS sort_num_109, t99.email AS email_110, t99.email_canonical AS email_canonical_111, t99.salt AS salt_112, t99.password AS password_113, t99.group_id AS group_id_114, t99.facility_id AS facility_id_115, t0.language_id AS language_id_116, t117.alias AS alias_118, t117.translate_key AS translate_key_119, t117.target_key AS target_key_120, t117.id AS id_121, t117.sort_num AS sort_num_122, t117.status AS status_123, t117.publish_at AS publish_at_124, t117.expires_at AS expires_at_125, t117.created_at AS created_at_126, t117.updated_at AS updated_at_127, t117.title AS title_128, t117.created_by AS created_by_129, t117.updated_by AS updated_by_130, t0.latest_approval_request_id AS latest_approval_request_id_131, t132.id AS id_133, t132.handler_name AS handler_name_134, t132.title AS title_135, t132.target_id AS target_id_136, t132.request_type AS request_type_137, t132.moderated_at AS moderated_at_138, t132.approval_status AS approval_status_139, t132.comment AS comment_140, t132.created_at AS created_at_141, t132.updated_at AS updated_at_142, t132.facility_id AS facility_id_143, t132.requested_by AS requested_by_144, t132.moderated_by AS moderated_by_145 FROM cms_mod_topics_posts t0 LEFT JOIN cms_media_item_details t33 ON t0.thumbnail = t33.id AND ((t33.status = 1 AND (t33.publish_at IS NULL OR t33.publish_at <= "2025-09-17 13:08:03") AND (t33.expires_at IS NULL OR t33.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_facility t52 ON t0.facility_id = t52.id AND ((t52.status = 1 AND (t52.publish_at IS NULL OR t52.publish_at <= "2025-09-17 13:08:03") AND (t52.expires_at IS NULL OR t52.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_user t81 ON t0.created_by = t81.id LEFT JOIN cms_user t99 ON t0.updated_by = t99.id LEFT JOIN cms_master_languages t117 ON t0.language_id = t117.id AND ((t117.status = 1 AND (t117.publish_at IS NULL OR t117.publish_at <= "2025-09-17 13:08:03") AND (t117.expires_at IS NULL OR t117.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_approval_requests t132 ON t0.latest_approval_request_id = t132.id WHERE t0.post_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17"))) LIMIT 1
SELECT
t0.post_id AS post_id_1,
t0.recommended AS recommended_2,
t0.important AS important_3,
t0.detail_type AS detail_type_4,
t0.link_url AS link_url_5,
t0.meta_title AS meta_title_6,
t0.meta_keywords AS meta_keywords_7,
t0.meta_description AS meta_description_8,
t0.meta_h1 AS meta_h1_9,
t0.custom_html AS custom_html_10,
t0.is_imported AS is_imported_11,
t0.period AS period_12,
t0.list_text AS list_text_13,
t0.public_date AS public_date_14,
t0.customblock AS customblock_15,
t0.id AS id_16,
t0.sort_num AS sort_num_17,
t0.status AS status_18,
t0.publish_at AS publish_at_19,
t0.expires_at AS expires_at_20,
t0.created_at AS created_at_21,
t0.updated_at AS updated_at_22,
t0.title AS title_23,
t0.language_parent AS language_parent_24,
t0.language_alias AS language_alias_25,
t0.language_active AS language_active_26,
t0.revision_parent AS revision_parent_27,
t0.revision_version AS revision_version_28,
t0.post_type AS post_type_29,
t0.access_token AS access_token_30,
t0.common_thumbnail AS common_thumbnail_31,
t0.thumbnail AS thumbnail_32,
t33.alt AS alt_34,
t33.caption AS caption_35,
t33.collation_code AS collation_code_36,
t33.meta AS meta_37,
t33.id AS id_38,
t33.sort_num AS sort_num_39,
t33.status AS status_40,
t33.publish_at AS publish_at_41,
t33.expires_at AS expires_at_42,
t33.created_at AS created_at_43,
t33.updated_at AS updated_at_44,
t33.title AS title_45,
t33.item_id AS item_id_46,
t33.thumb_item_id AS thumb_item_id_47,
t33.group_id AS group_id_48,
t33.created_by AS created_by_49,
t33.updated_by AS updated_by_50,
t0.facility_id AS facility_id_51,
t52.code AS code_53,
t52.title AS title_54,
t52.intro_text AS intro_text_55,
t52.zip AS zip_56,
t52.address AS address_57,
t52.building AS building_58,
t52.google_maps_url AS google_maps_url_59,
t52.phone AS phone_60,
t52.website AS website_61,
t52.opening_hours AS opening_hours_62,
t52.holiday AS holiday_63,
t52.access AS access_64,
t52.access_car AS access_car_65,
t52.access_train AS access_train_66,
t52.id AS id_67,
t52.sort_num AS sort_num_68,
t52.status AS status_69,
t52.publish_at AS publish_at_70,
t52.expires_at AS expires_at_71,
t52.created_at AS created_at_72,
t52.updated_at AS updated_at_73,
t52.area_id AS area_id_74,
t52.prefecture_id AS prefecture_id_75,
t52.logo_image AS logo_image_76,
t52.main_image AS main_image_77,
t52.created_by AS created_by_78,
t52.updated_by AS updated_by_79,
t0.created_by AS created_by_80,
t81.username AS username_82,
t81.username_canonical AS username_canonical_83,
t81.enabled AS enabled_84,
t81.last_login AS last_login_85,
t81.confirmation_token AS confirmation_token_86,
t81.password_requested_at AS password_requested_at_87,
t81.roles AS roles_88,
t81.id AS id_89,
t81.display_name AS display_name_90,
t81.sort_num AS sort_num_91,
t81.email AS email_92,
t81.email_canonical AS email_canonical_93,
t81.salt AS salt_94,
t81.password AS password_95,
t81.group_id AS group_id_96,
t81.facility_id AS facility_id_97,
t0.updated_by AS updated_by_98,
t99.username AS username_100,
t99.username_canonical AS username_canonical_101,
t99.enabled AS enabled_102,
t99.last_login AS last_login_103,
t99.confirmation_token AS confirmation_token_104,
t99.password_requested_at AS password_requested_at_105,
t99.roles AS roles_106,
t99.id AS id_107,
t99.display_name AS display_name_108,
t99.sort_num AS sort_num_109,
t99.email AS email_110,
t99.email_canonical AS email_canonical_111,
t99.salt AS salt_112,
t99.password AS password_113,
t99.group_id AS group_id_114,
t99.facility_id AS facility_id_115,
t0.language_id AS language_id_116,
t117.alias AS alias_118,
t117.translate_key AS translate_key_119,
t117.target_key AS target_key_120,
t117.id AS id_121,
t117.sort_num AS sort_num_122,
t117.status AS status_123,
t117.publish_at AS publish_at_124,
t117.expires_at AS expires_at_125,
t117.created_at AS created_at_126,
t117.updated_at AS updated_at_127,
t117.title AS title_128,
t117.created_by AS created_by_129,
t117.updated_by AS updated_by_130,
t0.latest_approval_request_id AS latest_approval_request_id_131,
t132.id AS id_133,
t132.handler_name AS handler_name_134,
t132.title AS title_135,
t132.target_id AS target_id_136,
t132.request_type AS request_type_137,
t132.moderated_at AS moderated_at_138,
t132.approval_status AS approval_status_139,
t132.comment AS comment_140,
t132.created_at AS created_at_141,
t132.updated_at AS updated_at_142,
t132.facility_id AS facility_id_143,
t132.requested_by AS requested_by_144,
t132.moderated_by AS moderated_by_145
FROM
cms_mod_topics_posts t0
LEFT JOIN cms_media_item_details t33 ON t0.thumbnail = t33.id
AND (
(
t33.status = 1
AND (
t33.publish_at IS NULL
OR t33.publish_at <= "2025-09-17 13:08:03"
)
AND (
t33.expires_at IS NULL
OR t33.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_facility t52 ON t0.facility_id = t52.id
AND (
(
t52.status = 1
AND (
t52.publish_at IS NULL
OR t52.publish_at <= "2025-09-17 13:08:03"
)
AND (
t52.expires_at IS NULL
OR t52.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_user t81 ON t0.created_by = t81.id
LEFT JOIN cms_user t99 ON t0.updated_by = t99.id
LEFT JOIN cms_master_languages t117 ON t0.language_id = t117.id
AND (
(
t117.status = 1
AND (
t117.publish_at IS NULL
OR t117.publish_at <= "2025-09-17 13:08:03"
)
AND (
t117.expires_at IS NULL
OR t117.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_approval_requests t132 ON t0.latest_approval_request_id = t132.id
WHERE
t0.post_id = ?
AND (
(
t0.post_type IN ("master")
)
AND (
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 13:08:03"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 13:08:03"
)
AND (
t0.public_date IS NULL
OR t0.public_date <= "2025-09-17"
)
)
)
LIMIT
1
SELECT t0.post_id AS post_id_1, t0.recommended AS recommended_2, t0.important AS important_3, t0.detail_type AS detail_type_4, t0.link_url AS link_url_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.meta_h1 AS meta_h1_9, t0.custom_html AS custom_html_10, t0.is_imported AS is_imported_11, t0.period AS period_12, t0.list_text AS list_text_13, t0.public_date AS public_date_14, t0.customblock AS customblock_15, t0.id AS id_16, t0.sort_num AS sort_num_17, t0.status AS status_18, t0.publish_at AS publish_at_19, t0.expires_at AS expires_at_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.title AS title_23, t0.language_parent AS language_parent_24, t0.language_alias AS language_alias_25, t0.language_active AS language_active_26, t0.revision_parent AS revision_parent_27, t0.revision_version AS revision_version_28, t0.post_type AS post_type_29, t0.access_token AS access_token_30, t0.common_thumbnail AS common_thumbnail_31, t0.thumbnail AS thumbnail_32, t33.alt AS alt_34, t33.caption AS caption_35, t33.collation_code AS collation_code_36, t33.meta AS meta_37, t33.id AS id_38, t33.sort_num AS sort_num_39, t33.status AS status_40, t33.publish_at AS publish_at_41, t33.expires_at AS expires_at_42, t33.created_at AS created_at_43, t33.updated_at AS updated_at_44, t33.title AS title_45, t33.item_id AS item_id_46, t33.thumb_item_id AS thumb_item_id_47, t33.group_id AS group_id_48, t33.created_by AS created_by_49, t33.updated_by AS updated_by_50, t0.facility_id AS facility_id_51, t52.code AS code_53, t52.title AS title_54, t52.intro_text AS intro_text_55, t52.zip AS zip_56, t52.address AS address_57, t52.building AS building_58, t52.google_maps_url AS google_maps_url_59, t52.phone AS phone_60, t52.website AS website_61, t52.opening_hours AS opening_hours_62, t52.holiday AS holiday_63, t52.access AS access_64, t52.access_car AS access_car_65, t52.access_train AS access_train_66, t52.id AS id_67, t52.sort_num AS sort_num_68, t52.status AS status_69, t52.publish_at AS publish_at_70, t52.expires_at AS expires_at_71, t52.created_at AS created_at_72, t52.updated_at AS updated_at_73, t52.area_id AS area_id_74, t52.prefecture_id AS prefecture_id_75, t52.logo_image AS logo_image_76, t52.main_image AS main_image_77, t52.created_by AS created_by_78, t52.updated_by AS updated_by_79, t0.created_by AS created_by_80, t81.username AS username_82, t81.username_canonical AS username_canonical_83, t81.enabled AS enabled_84, t81.last_login AS last_login_85, t81.confirmation_token AS confirmation_token_86, t81.password_requested_at AS password_requested_at_87, t81.roles AS roles_88, t81.id AS id_89, t81.display_name AS display_name_90, t81.sort_num AS sort_num_91, t81.email AS email_92, t81.email_canonical AS email_canonical_93, t81.salt AS salt_94, t81.password AS password_95, t81.group_id AS group_id_96, t81.facility_id AS facility_id_97, t0.updated_by AS updated_by_98, t99.username AS username_100, t99.username_canonical AS username_canonical_101, t99.enabled AS enabled_102, t99.last_login AS last_login_103, t99.confirmation_token AS confirmation_token_104, t99.password_requested_at AS password_requested_at_105, t99.roles AS roles_106, t99.id AS id_107, t99.display_name AS display_name_108, t99.sort_num AS sort_num_109, t99.email AS email_110, t99.email_canonical AS email_canonical_111, t99.salt AS salt_112, t99.password AS password_113, t99.group_id AS group_id_114, t99.facility_id AS facility_id_115, t0.language_id AS language_id_116, t117.alias AS alias_118, t117.translate_key AS translate_key_119, t117.target_key AS target_key_120, t117.id AS id_121, t117.sort_num AS sort_num_122, t117.status AS status_123, t117.publish_at AS publish_at_124, t117.expires_at AS expires_at_125, t117.created_at AS created_at_126, t117.updated_at AS updated_at_127, t117.title AS title_128, t117.created_by AS created_by_129, t117.updated_by AS updated_by_130, t0.latest_approval_request_id AS latest_approval_request_id_131, t132.id AS id_133, t132.handler_name AS handler_name_134, t132.title AS title_135, t132.target_id AS target_id_136, t132.request_type AS request_type_137, t132.moderated_at AS moderated_at_138, t132.approval_status AS approval_status_139, t132.comment AS comment_140, t132.created_at AS created_at_141, t132.updated_at AS updated_at_142, t132.facility_id AS facility_id_143, t132.requested_by AS requested_by_144, t132.moderated_by AS moderated_by_145 FROM cms_mod_topics_posts t0 LEFT JOIN cms_media_item_details t33 ON t0.thumbnail = t33.id AND ((t33.status = 1 AND (t33.publish_at IS NULL OR t33.publish_at <= "2025-09-17 13'2':03") AND (t33.expires_at IS NULL OR t33.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_facility t52 ON t0.facility_id = t52.id AND ((t52.status = 1 AND (t52.publish_at IS NULL OR t52.publish_at <= "2025-09-17 13:08:03") AND (t52.expires_at IS NULL OR t52.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_user t81 ON t0.created_by = t81.id LEFT JOIN cms_user t99 ON t0.updated_by = t99.id LEFT JOIN cms_master_languages t117 ON t0.language_id = t117.id AND ((t117.status = 1 AND (t117.publish_at IS NULL OR t117.publish_at <= "2025-09-17 13:08:03") AND (t117.expires_at IS NULL OR t117.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_approval_requests t132 ON t0.latest_approval_request_id = t132.id WHERE t0.post_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03") AND (t0.public_date IS NULL OR t0.public_date <= "2025-09-17"))) LIMIT 1;
|
2.54 ms
(5.90%)
|
1 |
SELECT t0.code AS code_1, t0.title AS title_2, t0.intro_text AS intro_text_3, t0.zip AS zip_4, t0.address AS address_5, t0.building AS building_6, t0.google_maps_url AS google_maps_url_7, t0.phone AS phone_8, t0.website AS website_9, t0.opening_hours AS opening_hours_10, t0.holiday AS holiday_11, t0.access AS access_12, t0.access_car AS access_car_13, t0.access_train AS access_train_14, t0.id AS id_15, t0.sort_num AS sort_num_16, t0.status AS status_17, t0.publish_at AS publish_at_18, t0.expires_at AS expires_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.area_id AS area_id_22, t0.prefecture_id AS prefecture_id_23, t0.logo_image AS logo_image_24, t0.main_image AS main_image_25, t0.created_by AS created_by_26, t27.username AS username_28, t27.username_canonical AS username_canonical_29, t27.enabled AS enabled_30, t27.last_login AS last_login_31, t27.confirmation_token AS confirmation_token_32, t27.password_requested_at AS password_requested_at_33, t27.roles AS roles_34, t27.id AS id_35, t27.display_name AS display_name_36, t27.sort_num AS sort_num_37, t27.email AS email_38, t27.email_canonical AS email_canonical_39, t27.salt AS salt_40, t27.password AS password_41, t27.group_id AS group_id_42, t27.facility_id AS facility_id_43, t0.updated_by AS updated_by_44, t45.username AS username_46, t45.username_canonical AS username_canonical_47, t45.enabled AS enabled_48, t45.last_login AS last_login_49, t45.confirmation_token AS confirmation_token_50, t45.password_requested_at AS password_requested_at_51, t45.roles AS roles_52, t45.id AS id_53, t45.display_name AS display_name_54, t45.sort_num AS sort_num_55, t45.email AS email_56, t45.email_canonical AS email_canonical_57, t45.salt AS salt_58, t45.password AS password_59, t45.group_id AS group_id_60, t45.facility_id AS facility_id_61 FROM cms_facility t0 LEFT JOIN cms_user t27 ON t0.created_by = t27.id LEFT JOIN cms_user t45 ON t0.updated_by = t45.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03")))
SELECT
t0.code AS code_1,
t0.title AS title_2,
t0.intro_text AS intro_text_3,
t0.zip AS zip_4,
t0.address AS address_5,
t0.building AS building_6,
t0.google_maps_url AS google_maps_url_7,
t0.phone AS phone_8,
t0.website AS website_9,
t0.opening_hours AS opening_hours_10,
t0.holiday AS holiday_11,
t0.access AS access_12,
t0.access_car AS access_car_13,
t0.access_train AS access_train_14,
t0.id AS id_15,
t0.sort_num AS sort_num_16,
t0.status AS status_17,
t0.publish_at AS publish_at_18,
t0.expires_at AS expires_at_19,
t0.created_at AS created_at_20,
t0.updated_at AS updated_at_21,
t0.area_id AS area_id_22,
t0.prefecture_id AS prefecture_id_23,
t0.logo_image AS logo_image_24,
t0.main_image AS main_image_25,
t0.created_by AS created_by_26,
t27.username AS username_28,
t27.username_canonical AS username_canonical_29,
t27.enabled AS enabled_30,
t27.last_login AS last_login_31,
t27.confirmation_token AS confirmation_token_32,
t27.password_requested_at AS password_requested_at_33,
t27.roles AS roles_34,
t27.id AS id_35,
t27.display_name AS display_name_36,
t27.sort_num AS sort_num_37,
t27.email AS email_38,
t27.email_canonical AS email_canonical_39,
t27.salt AS salt_40,
t27.password AS password_41,
t27.group_id AS group_id_42,
t27.facility_id AS facility_id_43,
t0.updated_by AS updated_by_44,
t45.username AS username_46,
t45.username_canonical AS username_canonical_47,
t45.enabled AS enabled_48,
t45.last_login AS last_login_49,
t45.confirmation_token AS confirmation_token_50,
t45.password_requested_at AS password_requested_at_51,
t45.roles AS roles_52,
t45.id AS id_53,
t45.display_name AS display_name_54,
t45.sort_num AS sort_num_55,
t45.email AS email_56,
t45.email_canonical AS email_canonical_57,
t45.salt AS salt_58,
t45.password AS password_59,
t45.group_id AS group_id_60,
t45.facility_id AS facility_id_61
FROM
cms_facility t0
LEFT JOIN cms_user t27 ON t0.created_by = t27.id
LEFT JOIN cms_user t45 ON t0.updated_by = t45.id
WHERE
t0.id IN (?)
AND (
(
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 13:08:03"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 13:08:03"
)
)
)
SELECT t0.code AS code_1, t0.title AS title_2, t0.intro_text AS intro_text_3, t0.zip AS zip_4, t0.address AS address_5, t0.building AS building_6, t0.google_maps_url AS google_maps_url_7, t0.phone AS phone_8, t0.website AS website_9, t0.opening_hours AS opening_hours_10, t0.holiday AS holiday_11, t0.access AS access_12, t0.access_car AS access_car_13, t0.access_train AS access_train_14, t0.id AS id_15, t0.sort_num AS sort_num_16, t0.status AS status_17, t0.publish_at AS publish_at_18, t0.expires_at AS expires_at_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.area_id AS area_id_22, t0.prefecture_id AS prefecture_id_23, t0.logo_image AS logo_image_24, t0.main_image AS main_image_25, t0.created_by AS created_by_26, t27.username AS username_28, t27.username_canonical AS username_canonical_29, t27.enabled AS enabled_30, t27.last_login AS last_login_31, t27.confirmation_token AS confirmation_token_32, t27.password_requested_at AS password_requested_at_33, t27.roles AS roles_34, t27.id AS id_35, t27.display_name AS display_name_36, t27.sort_num AS sort_num_37, t27.email AS email_38, t27.email_canonical AS email_canonical_39, t27.salt AS salt_40, t27.password AS password_41, t27.group_id AS group_id_42, t27.facility_id AS facility_id_43, t0.updated_by AS updated_by_44, t45.username AS username_46, t45.username_canonical AS username_canonical_47, t45.enabled AS enabled_48, t45.last_login AS last_login_49, t45.confirmation_token AS confirmation_token_50, t45.password_requested_at AS password_requested_at_51, t45.roles AS roles_52, t45.id AS id_53, t45.display_name AS display_name_54, t45.sort_num AS sort_num_55, t45.email AS email_56, t45.email_canonical AS email_canonical_57, t45.salt AS salt_58, t45.password AS password_59, t45.group_id AS group_id_60, t45.facility_id AS facility_id_61 FROM cms_facility t0 LEFT JOIN cms_user t27 ON t0.created_by = t27.id LEFT JOIN cms_user t45 ON t0.updated_by = t45.id WHERE t0.id IN (1) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03")));
|
2.38 ms
(5.53%)
|
1 |
SELECT c0_.post_id AS post_id_0, c0_.recommended AS recommended_1, c0_.important AS important_2, c0_.detail_type AS detail_type_3, c0_.link_url AS link_url_4, c0_.meta_title AS meta_title_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_description AS meta_description_7, c0_.meta_h1 AS meta_h1_8, c0_.custom_html AS custom_html_9, c0_.is_imported AS is_imported_10, c0_.period AS period_11, c0_.list_text AS list_text_12, c0_.public_date AS public_date_13, c0_.customblock AS customblock_14, c0_.id AS id_15, c0_.sort_num AS sort_num_16, c0_.status AS status_17, c0_.publish_at AS publish_at_18, c0_.expires_at AS expires_at_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, c0_.title AS title_22, c0_.language_parent AS language_parent_23, c0_.language_alias AS language_alias_24, c0_.language_active AS language_active_25, c0_.revision_parent AS revision_parent_26, c0_.revision_version AS revision_version_27, c0_.post_type AS post_type_28, c0_.access_token AS access_token_29, c0_.common_thumbnail AS common_thumbnail_30, c0_.thumbnail AS thumbnail_31, c0_.facility_id AS facility_id_32, c0_.created_by AS created_by_33, c0_.updated_by AS updated_by_34, c0_.language_id AS language_id_35, c0_.latest_approval_request_id AS latest_approval_request_id_36 FROM cms_mod_topics_posts c0_ WHERE (c0_.detail_type = ? AND c0_.id <> ? AND ((c0_.public_date = ? AND c0_.post_id < ?) OR c0_.public_date < ?)) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2025-09-17 13:08:03") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2025-09-17 13:08:03") AND (c0_.public_date IS NULL OR c0_.public_date <= "2025-09-17")) ORDER BY c0_.public_date DESC, c0_.post_id DESC LIMIT 1
Parameters: [
"article"
15
"2021-12-01 00:00:00"
"2"
"2021-12-01 00:00:00"
]
SELECT c0_.post_id AS post_id_0, c0_.recommended AS recommended_1, c0_.important AS important_2, c0_.detail_type AS detail_type_3, c0_.link_url AS link_url_4, c0_.meta_title AS meta_title_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_description AS meta_description_7, c0_.meta_h1 AS meta_h1_8, c0_.custom_html AS custom_html_9, c0_.is_imported AS is_imported_10, c0_.period AS period_11, c0_.list_text AS list_text_12, c0_.public_date AS public_date_13, c0_.customblock AS customblock_14, c0_.id AS id_15, c0_.sort_num AS sort_num_16, c0_.status AS status_17, c0_.publish_at AS publish_at_18, c0_.expires_at AS expires_at_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, c0_.title AS title_22, c0_.language_parent AS language_parent_23, c0_.language_alias AS language_alias_24, c0_.language_active AS language_active_25, c0_.revision_parent AS revision_parent_26, c0_.revision_version AS revision_version_27, c0_.post_type AS post_type_28, c0_.access_token AS access_token_29, c0_.common_thumbnail AS common_thumbnail_30, c0_.thumbnail AS thumbnail_31, c0_.facility_id AS facility_id_32, c0_.created_by AS created_by_33, c0_.updated_by AS updated_by_34, c0_.language_id AS language_id_35, c0_.latest_approval_request_id AS latest_approval_request_id_36 FROM cms_mod_topics_posts c0_ WHERE (c0_.detail_type = 'article' AND c0_.id <> 15 AND ((c0_.public_date = '2021-12-01 00:00:00' AND c0_.post_id < '2') OR c0_.public_date < '2021-12-01 00:00:00')) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2025-09-17 13:08:03") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2025-09-17 13:08:03") AND (c0_.public_date IS NULL OR c0_.public_date <= "2025-09-17")) ORDER BY c0_.public_date DESC, c0_.post_id DESC LIMIT 1;
|
2.37 ms
(5.50%)
|
1 |
SELECT DATE_FORMAT(c0_.public_date, '%Y-%m') AS sclr_0, COUNT(c0_.id) AS sclr_1 FROM cms_mod_topics_posts c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2025-09-17 13:08:03") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2025-09-17 13:08:03") AND (c0_.public_date IS NULL OR c0_.public_date <= "2025-09-17")) GROUP BY sclr_0 ORDER BY sclr_0 DESC
SELECT DATE_FORMAT(c0_.public_date, '%Y-%m') AS sclr_0, COUNT(c0_.id) AS sclr_1 FROM cms_mod_topics_posts c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2025-09-17 13:08:03") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2025-09-17 13:08:03") AND (c0_.public_date IS NULL OR c0_.public_date <= "2025-09-17")) GROUP BY sclr_0 ORDER BY sclr_0 DESC;
|
2.35 ms
(5.46%)
|
1 |
SELECT t0.alias AS alias_1, t0.path AS path_2, t0.mime AS mime_3, t0.file_size AS file_size_4, t0.width AS width_5, t0.height AS height_6, t0.alt AS alt_7, t0.caption AS caption_8, t0.link_url AS link_url_9, t0.content_data AS content_data_10, t0.thumb_path AS thumb_path_11, t0.hidden AS hidden_12, t0.collation_code AS collation_code_13, t0.is_locked AS is_locked_14, t0.meta AS meta_15, t0.cdn_domain AS cdn_domain_16, t0.id AS id_17, t0.sort_num AS sort_num_18, t0.status AS status_19, t0.publish_at AS publish_at_20, t0.expires_at AS expires_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.title AS title_24, t0.revision_parent AS revision_parent_25, t0.revision_version AS revision_version_26, t0.post_type AS post_type_27, t0.access_token AS access_token_28, t0.category AS category_29, t0.facility_id AS facility_id_30, t31.code AS code_32, t31.title AS title_33, t31.intro_text AS intro_text_34, t31.zip AS zip_35, t31.address AS address_36, t31.building AS building_37, t31.google_maps_url AS google_maps_url_38, t31.phone AS phone_39, t31.website AS website_40, t31.opening_hours AS opening_hours_41, t31.holiday AS holiday_42, t31.access AS access_43, t31.access_car AS access_car_44, t31.access_train AS access_train_45, t31.id AS id_46, t31.sort_num AS sort_num_47, t31.status AS status_48, t31.publish_at AS publish_at_49, t31.expires_at AS expires_at_50, t31.created_at AS created_at_51, t31.updated_at AS updated_at_52, t31.area_id AS area_id_53, t31.prefecture_id AS prefecture_id_54, t31.logo_image AS logo_image_55, t31.main_image AS main_image_56, t31.created_by AS created_by_57, t31.updated_by AS updated_by_58, t0.original_id AS original_id_59, t0.created_by AS created_by_60, t61.username AS username_62, t61.username_canonical AS username_canonical_63, t61.enabled AS enabled_64, t61.last_login AS last_login_65, t61.confirmation_token AS confirmation_token_66, t61.password_requested_at AS password_requested_at_67, t61.roles AS roles_68, t61.id AS id_69, t61.display_name AS display_name_70, t61.sort_num AS sort_num_71, t61.email AS email_72, t61.email_canonical AS email_canonical_73, t61.salt AS salt_74, t61.password AS password_75, t61.group_id AS group_id_76, t61.facility_id AS facility_id_77, t0.updated_by AS updated_by_78, t79.username AS username_80, t79.username_canonical AS username_canonical_81, t79.enabled AS enabled_82, t79.last_login AS last_login_83, t79.confirmation_token AS confirmation_token_84, t79.password_requested_at AS password_requested_at_85, t79.roles AS roles_86, t79.id AS id_87, t79.display_name AS display_name_88, t79.sort_num AS sort_num_89, t79.email AS email_90, t79.email_canonical AS email_canonical_91, t79.salt AS salt_92, t79.password AS password_93, t79.group_id AS group_id_94, t79.facility_id AS facility_id_95, t0.latest_approval_request_id AS latest_approval_request_id_96, t97.id AS id_98, t97.handler_name AS handler_name_99, t97.title AS title_100, t97.target_id AS target_id_101, t97.request_type AS request_type_102, t97.moderated_at AS moderated_at_103, t97.approval_status AS approval_status_104, t97.comment AS comment_105, t97.created_at AS created_at_106, t97.updated_at AS updated_at_107, t97.facility_id AS facility_id_108, t97.requested_by AS requested_by_109, t97.moderated_by AS moderated_by_110 FROM cms_media_items t0 LEFT JOIN cms_facility t31 ON t0.facility_id = t31.id AND ((t31.status = 1 AND (t31.publish_at IS NULL OR t31.publish_at <= "2025-09-17 13:08:03") AND (t31.expires_at IS NULL OR t31.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_user t61 ON t0.created_by = t61.id LEFT JOIN cms_user t79 ON t0.updated_by = t79.id LEFT JOIN cms_approval_requests t97 ON t0.latest_approval_request_id = t97.id WHERE t0.id IN (?) AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03")))
SELECT
t0.alias AS alias_1,
t0.path AS path_2,
t0.mime AS mime_3,
t0.file_size AS file_size_4,
t0.width AS width_5,
t0.height AS height_6,
t0.alt AS alt_7,
t0.caption AS caption_8,
t0.link_url AS link_url_9,
t0.content_data AS content_data_10,
t0.thumb_path AS thumb_path_11,
t0.hidden AS hidden_12,
t0.collation_code AS collation_code_13,
t0.is_locked AS is_locked_14,
t0.meta AS meta_15,
t0.cdn_domain AS cdn_domain_16,
t0.id AS id_17,
t0.sort_num AS sort_num_18,
t0.status AS status_19,
t0.publish_at AS publish_at_20,
t0.expires_at AS expires_at_21,
t0.created_at AS created_at_22,
t0.updated_at AS updated_at_23,
t0.title AS title_24,
t0.revision_parent AS revision_parent_25,
t0.revision_version AS revision_version_26,
t0.post_type AS post_type_27,
t0.access_token AS access_token_28,
t0.category AS category_29,
t0.facility_id AS facility_id_30,
t31.code AS code_32,
t31.title AS title_33,
t31.intro_text AS intro_text_34,
t31.zip AS zip_35,
t31.address AS address_36,
t31.building AS building_37,
t31.google_maps_url AS google_maps_url_38,
t31.phone AS phone_39,
t31.website AS website_40,
t31.opening_hours AS opening_hours_41,
t31.holiday AS holiday_42,
t31.access AS access_43,
t31.access_car AS access_car_44,
t31.access_train AS access_train_45,
t31.id AS id_46,
t31.sort_num AS sort_num_47,
t31.status AS status_48,
t31.publish_at AS publish_at_49,
t31.expires_at AS expires_at_50,
t31.created_at AS created_at_51,
t31.updated_at AS updated_at_52,
t31.area_id AS area_id_53,
t31.prefecture_id AS prefecture_id_54,
t31.logo_image AS logo_image_55,
t31.main_image AS main_image_56,
t31.created_by AS created_by_57,
t31.updated_by AS updated_by_58,
t0.original_id AS original_id_59,
t0.created_by AS created_by_60,
t61.username AS username_62,
t61.username_canonical AS username_canonical_63,
t61.enabled AS enabled_64,
t61.last_login AS last_login_65,
t61.confirmation_token AS confirmation_token_66,
t61.password_requested_at AS password_requested_at_67,
t61.roles AS roles_68,
t61.id AS id_69,
t61.display_name AS display_name_70,
t61.sort_num AS sort_num_71,
t61.email AS email_72,
t61.email_canonical AS email_canonical_73,
t61.salt AS salt_74,
t61.password AS password_75,
t61.group_id AS group_id_76,
t61.facility_id AS facility_id_77,
t0.updated_by AS updated_by_78,
t79.username AS username_80,
t79.username_canonical AS username_canonical_81,
t79.enabled AS enabled_82,
t79.last_login AS last_login_83,
t79.confirmation_token AS confirmation_token_84,
t79.password_requested_at AS password_requested_at_85,
t79.roles AS roles_86,
t79.id AS id_87,
t79.display_name AS display_name_88,
t79.sort_num AS sort_num_89,
t79.email AS email_90,
t79.email_canonical AS email_canonical_91,
t79.salt AS salt_92,
t79.password AS password_93,
t79.group_id AS group_id_94,
t79.facility_id AS facility_id_95,
t0.latest_approval_request_id AS latest_approval_request_id_96,
t97.id AS id_98,
t97.handler_name AS handler_name_99,
t97.title AS title_100,
t97.target_id AS target_id_101,
t97.request_type AS request_type_102,
t97.moderated_at AS moderated_at_103,
t97.approval_status AS approval_status_104,
t97.comment AS comment_105,
t97.created_at AS created_at_106,
t97.updated_at AS updated_at_107,
t97.facility_id AS facility_id_108,
t97.requested_by AS requested_by_109,
t97.moderated_by AS moderated_by_110
FROM
cms_media_items t0
LEFT JOIN cms_facility t31 ON t0.facility_id = t31.id
AND (
(
t31.status = 1
AND (
t31.publish_at IS NULL
OR t31.publish_at <= "2025-09-17 13:08:03"
)
AND (
t31.expires_at IS NULL
OR t31.expires_at > "2025-09-17 13:08:03"
)
)
)
LEFT JOIN cms_user t61 ON t0.created_by = t61.id
LEFT JOIN cms_user t79 ON t0.updated_by = t79.id
LEFT JOIN cms_approval_requests t97 ON t0.latest_approval_request_id = t97.id
WHERE
t0.id IN (?)
AND (
(
t0.post_type IN ("master")
)
AND (
t0.status = 1
AND (
t0.publish_at IS NULL
OR t0.publish_at <= "2025-09-17 13:08:03"
)
AND (
t0.expires_at IS NULL
OR t0.expires_at > "2025-09-17 13:08:03"
)
)
)
SELECT t0.alias AS alias_1, t0.path AS path_2, t0.mime AS mime_3, t0.file_size AS file_size_4, t0.width AS width_5, t0.height AS height_6, t0.alt AS alt_7, t0.caption AS caption_8, t0.link_url AS link_url_9, t0.content_data AS content_data_10, t0.thumb_path AS thumb_path_11, t0.hidden AS hidden_12, t0.collation_code AS collation_code_13, t0.is_locked AS is_locked_14, t0.meta AS meta_15, t0.cdn_domain AS cdn_domain_16, t0.id AS id_17, t0.sort_num AS sort_num_18, t0.status AS status_19, t0.publish_at AS publish_at_20, t0.expires_at AS expires_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.title AS title_24, t0.revision_parent AS revision_parent_25, t0.revision_version AS revision_version_26, t0.post_type AS post_type_27, t0.access_token AS access_token_28, t0.category AS category_29, t0.facility_id AS facility_id_30, t31.code AS code_32, t31.title AS title_33, t31.intro_text AS intro_text_34, t31.zip AS zip_35, t31.address AS address_36, t31.building AS building_37, t31.google_maps_url AS google_maps_url_38, t31.phone AS phone_39, t31.website AS website_40, t31.opening_hours AS opening_hours_41, t31.holiday AS holiday_42, t31.access AS access_43, t31.access_car AS access_car_44, t31.access_train AS access_train_45, t31.id AS id_46, t31.sort_num AS sort_num_47, t31.status AS status_48, t31.publish_at AS publish_at_49, t31.expires_at AS expires_at_50, t31.created_at AS created_at_51, t31.updated_at AS updated_at_52, t31.area_id AS area_id_53, t31.prefecture_id AS prefecture_id_54, t31.logo_image AS logo_image_55, t31.main_image AS main_image_56, t31.created_by AS created_by_57, t31.updated_by AS updated_by_58, t0.original_id AS original_id_59, t0.created_by AS created_by_60, t61.username AS username_62, t61.username_canonical AS username_canonical_63, t61.enabled AS enabled_64, t61.last_login AS last_login_65, t61.confirmation_token AS confirmation_token_66, t61.password_requested_at AS password_requested_at_67, t61.roles AS roles_68, t61.id AS id_69, t61.display_name AS display_name_70, t61.sort_num AS sort_num_71, t61.email AS email_72, t61.email_canonical AS email_canonical_73, t61.salt AS salt_74, t61.password AS password_75, t61.group_id AS group_id_76, t61.facility_id AS facility_id_77, t0.updated_by AS updated_by_78, t79.username AS username_80, t79.username_canonical AS username_canonical_81, t79.enabled AS enabled_82, t79.last_login AS last_login_83, t79.confirmation_token AS confirmation_token_84, t79.password_requested_at AS password_requested_at_85, t79.roles AS roles_86, t79.id AS id_87, t79.display_name AS display_name_88, t79.sort_num AS sort_num_89, t79.email AS email_90, t79.email_canonical AS email_canonical_91, t79.salt AS salt_92, t79.password AS password_93, t79.group_id AS group_id_94, t79.facility_id AS facility_id_95, t0.latest_approval_request_id AS latest_approval_request_id_96, t97.id AS id_98, t97.handler_name AS handler_name_99, t97.title AS title_100, t97.target_id AS target_id_101, t97.request_type AS request_type_102, t97.moderated_at AS moderated_at_103, t97.approval_status AS approval_status_104, t97.comment AS comment_105, t97.created_at AS created_at_106, t97.updated_at AS updated_at_107, t97.facility_id AS facility_id_108, t97.requested_by AS requested_by_109, t97.moderated_by AS moderated_by_110 FROM cms_media_items t0 LEFT JOIN cms_facility t31 ON t0.facility_id = t31.id AND ((t31.status = 1 AND (t31.publish_at IS NULL OR t31.publish_at <= "2025-09-17 1325:03") AND (t31.expires_at IS NULL OR t31.expires_at > "2025-09-17 13:08:03"))) LEFT JOIN cms_user t61 ON t0.created_by = t61.id LEFT JOIN cms_user t79 ON t0.updated_by = t79.id LEFT JOIN cms_approval_requests t97 ON t0.latest_approval_request_id = t97.id WHERE t0.id IN (?) AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2025-09-17 13:08:03") AND (t0.expires_at IS NULL OR t0.expires_at > "2025-09-17 13:08:03")));
|
2.24 ms
(5.20%)
|
1 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.roles AS roles_7, t0.id AS id_8, t0.display_name AS display_name_9, t0.sort_num AS sort_num_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.salt AS salt_13, t0.password AS password_14, t0.group_id AS group_id_15, t16.id AS id_17, t16.is_wheel AS is_wheel_18, t16.is_system_admin AS is_system_admin_19, t16.level AS level_20, t16.name AS name_21, t16.display_name AS display_name_22, t16.description AS description_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t0.facility_id AS facility_id_26, t27.code AS code_28, t27.title AS title_29, t27.intro_text AS intro_text_30, t27.zip AS zip_31, t27.address AS address_32, t27.building AS building_33, t27.google_maps_url AS google_maps_url_34, t27.phone AS phone_35, t27.website AS website_36, t27.opening_hours AS opening_hours_37, t27.holiday AS holiday_38, t27.access AS access_39, t27.access_car AS access_car_40, t27.access_train AS access_train_41, t27.id AS id_42, t27.sort_num AS sort_num_43, t27.status AS status_44, t27.publish_at AS publish_at_45, t27.expires_at AS expires_at_46, t27.created_at AS created_at_47, t27.updated_at AS updated_at_48, t27.area_id AS area_id_49, t27.prefecture_id AS prefecture_id_50, t27.logo_image AS logo_image_51, t27.main_image AS main_image_52, t27.created_by AS created_by_53, t27.updated_by AS updated_by_54 FROM cms_user t0 LEFT JOIN cms_user_groups t16 ON t0.group_id = t16.id LEFT JOIN cms_facility t27 ON t0.facility_id = t27.id AND ((t27.status = 1 AND (t27.publish_at IS NULL OR t27.publish_at <= "2025-09-17 13:08:03") AND (t27.expires_at IS NULL OR t27.expires_at > "2025-09-17 13:08:03"))) WHERE t0.id IN (?)
SELECT
t0.username AS username_1,
t0.username_canonical AS username_canonical_2,
t0.enabled AS enabled_3,
t0.last_login AS last_login_4,
t0.confirmation_token AS confirmation_token_5,
t0.password_requested_at AS password_requested_at_6,
t0.roles AS roles_7,
t0.id AS id_8,
t0.display_name AS display_name_9,
t0.sort_num AS sort_num_10,
t0.email AS email_11,
t0.email_canonical AS email_canonical_12,
t0.salt AS salt_13,
t0.password AS password_14,
t0.group_id AS group_id_15,
t16.id AS id_17,
t16.is_wheel AS is_wheel_18,
t16.is_system_admin AS is_system_admin_19,
t16.level AS level_20,
t16.name AS name_21,
t16.display_name AS display_name_22,
t16.description AS description_23,
t16.created_at AS created_at_24,
t16.updated_at AS updated_at_25,
t0.facility_id AS facility_id_26,
t27.code AS code_28,
t27.title AS title_29,
t27.intro_text AS intro_text_30,
t27.zip AS zip_31,
t27.address AS address_32,
t27.building AS building_33,
t27.google_maps_url AS google_maps_url_34,
t27.phone AS phone_35,
t27.website AS website_36,
t27.opening_hours AS opening_hours_37,
t27.holiday AS holiday_38,
t27.access AS access_39,
t27.access_car AS access_car_40,
t27.access_train AS access_train_41,
t27.id AS id_42,
t27.sort_num AS sort_num_43,
t27.status AS status_44,
t27.publish_at AS publish_at_45,
t27.expires_at AS expires_at_46,
t27.created_at AS created_at_47,
t27.updated_at AS updated_at_48,
t27.area_id AS area_id_49,
t27.prefecture_id AS prefecture_id_50,
t27.logo_image AS logo_image_51,
t27.main_image AS main_image_52,
t27.created_by AS created_by_53,
t27.updated_by AS updated_by_54
FROM
cms_user t0
LEFT JOIN cms_user_groups t16 ON t0.group_id = t16.id
LEFT JOIN cms_facility t27 ON t0.facility_id = t27.id
AND (
(
t27.status = 1
AND (
t27.publish_at IS NULL
OR t27.publish_at <= "2025-09-17 13:08:03"
)
AND (
t27.expires_at IS NULL
OR t27.expires_at > "2025-09-17 13:08:03"
)
)
)
WHERE
t0.id IN (?)
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.roles AS roles_7, t0.id AS id_8, t0.display_name AS display_name_9, t0.sort_num AS sort_num_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.salt AS salt_13, t0.password AS password_14, t0.group_id AS group_id_15, t16.id AS id_17, t16.is_wheel AS is_wheel_18, t16.is_system_admin AS is_system_admin_19, t16.level AS level_20, t16.name AS name_21, t16.display_name AS display_name_22, t16.description AS description_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t0.facility_id AS facility_id_26, t27.code AS code_28, t27.title AS title_29, t27.intro_text AS intro_text_30, t27.zip AS zip_31, t27.address AS address_32, t27.building AS building_33, t27.google_maps_url AS google_maps_url_34, t27.phone AS phone_35, t27.website AS website_36, t27.opening_hours AS opening_hours_37, t27.holiday AS holiday_38, t27.access AS access_39, t27.access_car AS access_car_40, t27.access_train AS access_train_41, t27.id AS id_42, t27.sort_num AS sort_num_43, t27.status AS status_44, t27.publish_at AS publish_at_45, t27.expires_at AS expires_at_46, t27.created_at AS created_at_47, t27.updated_at AS updated_at_48, t27.area_id AS area_id_49, t27.prefecture_id AS prefecture_id_50, t27.logo_image AS logo_image_51, t27.main_image AS main_image_52, t27.created_by AS created_by_53, t27.updated_by AS updated_by_54 FROM cms_user t0 LEFT JOIN cms_user_groups t16 ON t0.group_id = t16.id LEFT JOIN cms_facility t27 ON t0.facility_id = t27.id AND ((t27.status = 1 AND (t27.publish_at IS NULL OR t27.publish_at <= "2025-09-17 131:03") AND (t27.expires_at IS NULL OR t27.expires_at > "2025-09-17 13:08:03"))) WHERE t0.id IN (?);
|
2.15 ms
(4.99%)
|
1 |
SELECT c0_.post_id AS post_id_0, c0_.recommended AS recommended_1, c0_.important AS important_2, c0_.detail_type AS detail_type_3, c0_.link_url AS link_url_4, c0_.meta_title AS meta_title_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_description AS meta_description_7, c0_.meta_h1 AS meta_h1_8, c0_.custom_html AS custom_html_9, c0_.is_imported AS is_imported_10, c0_.period AS period_11, c0_.list_text AS list_text_12, c0_.public_date AS public_date_13, c0_.customblock AS customblock_14, c0_.id AS id_15, c0_.sort_num AS sort_num_16, c0_.status AS status_17, c0_.publish_at AS publish_at_18, c0_.expires_at AS expires_at_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, c0_.title AS title_22, c0_.language_parent AS language_parent_23, c0_.language_alias AS language_alias_24, c0_.language_active AS language_active_25, c0_.revision_parent AS revision_parent_26, c0_.revision_version AS revision_version_27, c0_.post_type AS post_type_28, c0_.access_token AS access_token_29, c0_.common_thumbnail AS common_thumbnail_30, c0_.thumbnail AS thumbnail_31, c0_.facility_id AS facility_id_32, c0_.created_by AS created_by_33, c0_.updated_by AS updated_by_34, c0_.language_id AS language_id_35, c0_.latest_approval_request_id AS latest_approval_request_id_36 FROM cms_mod_topics_posts c0_ WHERE (c0_.detail_type = ? AND c0_.id <> ? AND ((c0_.public_date = ? AND c0_.post_id > ?) OR c0_.public_date > ?)) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2025-09-17 13:08:03") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2025-09-17 13:08:03") AND (c0_.public_date IS NULL OR c0_.public_date <= "2025-09-17")) ORDER BY c0_.public_date ASC, c0_.post_id ASC LIMIT 1
Parameters: [
"article"
15
"2021-12-01 00:00:00"
"2"
"2021-12-01 00:00:00"
]
SELECT c0_.post_id AS post_id_0, c0_.recommended AS recommended_1, c0_.important AS important_2, c0_.detail_type AS detail_type_3, c0_.link_url AS link_url_4, c0_.meta_title AS meta_title_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_description AS meta_description_7, c0_.meta_h1 AS meta_h1_8, c0_.custom_html AS custom_html_9, c0_.is_imported AS is_imported_10, c0_.period AS period_11, c0_.list_text AS list_text_12, c0_.public_date AS public_date_13, c0_.customblock AS customblock_14, c0_.id AS id_15, c0_.sort_num AS sort_num_16, c0_.status AS status_17, c0_.publish_at AS publish_at_18, c0_.expires_at AS expires_at_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, c0_.title AS title_22, c0_.language_parent AS language_parent_23, c0_.language_alias AS language_alias_24, c0_.language_active AS language_active_25, c0_.revision_parent AS revision_parent_26, c0_.revision_version AS revision_version_27, c0_.post_type AS post_type_28, c0_.access_token AS access_token_29, c0_.common_thumbnail AS common_thumbnail_30, c0_.thumbnail AS thumbnail_31, c0_.facility_id AS facility_id_32, c0_.created_by AS created_by_33, c0_.updated_by AS updated_by_34, c0_.language_id AS language_id_35, c0_.latest_approval_request_id AS latest_approval_request_id_36 FROM cms_mod_topics_posts c0_ WHERE (c0_.detail_type = 'article' AND c0_.id <> 15 AND ((c0_.public_date = '2021-12-01 00:00:00' AND c0_.post_id > '2') OR c0_.public_date > '2021-12-01 00:00:00')) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2025-09-17 13:08:03") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2025-09-17 13:08:03") AND (c0_.public_date IS NULL OR c0_.public_date <= "2025-09-17")) ORDER BY c0_.public_date ASC, c0_.post_id ASC LIMIT 1;
|
1.66 ms
(3.86%)
|
1 |
SELECT t0.id AS id_1, t0.is_wheel AS is_wheel_2, t0.is_system_admin AS is_system_admin_3, t0.level AS level_4, t0.name AS name_5, t0.display_name AS display_name_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM cms_user_groups t0 WHERE t0.id IN (?)
SELECT t0.id AS id_1, t0.is_wheel AS is_wheel_2, t0.is_system_admin AS is_system_admin_3, t0.level AS level_4, t0.name AS name_5, t0.display_name AS display_name_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM cms_user_groups t0 WHERE t0.id IN (1);
|
1.64 ms
(3.82%)
|
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM cms_mod_topics_posts c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2025-09-17 13:08:03") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2025-09-17 13:08:03") AND (c0_.public_date IS NULL OR c0_.public_date <= "2025-09-17")) LIMIT 1
SELECT COUNT(c0_.id) AS sclr_0 FROM cms_mod_topics_posts c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2025-09-17 13:08:03") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2025-09-17 13:08:03") AND (c0_.public_date IS NULL OR c0_.public_date <= "2025-09-17")) LIMIT 1;
|