Symfony Profiler

Query Metrics

20 Database Queries

14 Different statements

64.85 ms Query time

0 Invalid entities

Queries


SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")))
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 <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")))
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.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 <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")))
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 <= "2024-11-15 18:00:14") AND (t27.expires_at IS NULL OR t27.expires_at > "2024-11-15 18:00:14"))) WHERE t0.id IN (?)
SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_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_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.thumbnail AS thumbnail_17, c0_.facility_id AS facility_id_18, c0_.created_by AS created_by_19, c0_.updated_by AS updated_by_20, c0_.language_id AS language_id_21, c0_.latest_approval_request_id AS latest_approval_request_id_22 FROM cms_mod_restaurant_time_by_cars c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC
SELECT c0_.alias AS alias_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.thumbnail AS thumbnail_18, c0_.facility_id AS facility_id_19, c0_.created_by AS created_by_20, c0_.updated_by AS updated_by_21, c0_.language_id AS language_id_22, c0_.latest_approval_request_id AS latest_approval_request_id_23 FROM cms_mod_restaurant_scenes c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.background_color AS background_color_3, c0_.public_date AS public_date_4, c0_.customblock AS customblock_5, c0_.id AS id_6, c0_.sort_num AS sort_num_7, c0_.status AS status_8, c0_.publish_at AS publish_at_9, c0_.expires_at AS expires_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.title AS title_13, c0_.language_parent AS language_parent_14, c0_.language_alias AS language_alias_15, c0_.language_active AS language_active_16, c0_.revision_parent AS revision_parent_17, c0_.revision_version AS revision_version_18, c0_.post_type AS post_type_19, c0_.access_token AS access_token_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_feature c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC
SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC
SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_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_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.image AS image_17, c0_.time_by_car AS time_by_car_18, c0_.scene AS scene_19, c0_.thumbnail AS thumbnail_20, c0_.facility_id AS facility_id_21, c0_.created_by AS created_by_22, c0_.updated_by AS updated_by_23, c0_.language_id AS language_id_24, c0_.latest_approval_request_id AS latest_approval_request_id_25 FROM cms_mod_top_gourmet_pickup_items c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")))
SELECT t0.public_date AS public_date_1, t0.customblock AS customblock_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.revision_parent AS revision_parent_14, t0.revision_version AS revision_version_15, t0.post_type AS post_type_16, t0.access_token AS access_token_17, t0.thumbnail AS thumbnail_18, t19.alt AS alt_20, t19.caption AS caption_21, t19.collation_code AS collation_code_22, t19.meta AS meta_23, t19.id AS id_24, t19.sort_num AS sort_num_25, t19.status AS status_26, t19.publish_at AS publish_at_27, t19.expires_at AS expires_at_28, t19.created_at AS created_at_29, t19.updated_at AS updated_at_30, t19.title AS title_31, t19.item_id AS item_id_32, t19.thumb_item_id AS thumb_item_id_33, t19.group_id AS group_id_34, t19.created_by AS created_by_35, t19.updated_by AS updated_by_36, t0.facility_id AS facility_id_37, t38.code AS code_39, t38.title AS title_40, t38.intro_text AS intro_text_41, t38.zip AS zip_42, t38.address AS address_43, t38.building AS building_44, t38.google_maps_url AS google_maps_url_45, t38.phone AS phone_46, t38.website AS website_47, t38.opening_hours AS opening_hours_48, t38.holiday AS holiday_49, t38.access AS access_50, t38.access_car AS access_car_51, t38.access_train AS access_train_52, t38.id AS id_53, t38.sort_num AS sort_num_54, t38.status AS status_55, t38.publish_at AS publish_at_56, t38.expires_at AS expires_at_57, t38.created_at AS created_at_58, t38.updated_at AS updated_at_59, t38.area_id AS area_id_60, t38.prefecture_id AS prefecture_id_61, t38.logo_image AS logo_image_62, t38.main_image AS main_image_63, t38.created_by AS created_by_64, t38.updated_by AS updated_by_65, t0.created_by AS created_by_66, t67.username AS username_68, t67.username_canonical AS username_canonical_69, t67.enabled AS enabled_70, t67.last_login AS last_login_71, t67.confirmation_token AS confirmation_token_72, t67.password_requested_at AS password_requested_at_73, t67.roles AS roles_74, t67.id AS id_75, t67.display_name AS display_name_76, t67.sort_num AS sort_num_77, t67.email AS email_78, t67.email_canonical AS email_canonical_79, t67.salt AS salt_80, t67.password AS password_81, t67.group_id AS group_id_82, t67.facility_id AS facility_id_83, t0.updated_by AS updated_by_84, t85.username AS username_86, t85.username_canonical AS username_canonical_87, t85.enabled AS enabled_88, t85.last_login AS last_login_89, t85.confirmation_token AS confirmation_token_90, t85.password_requested_at AS password_requested_at_91, t85.roles AS roles_92, t85.id AS id_93, t85.display_name AS display_name_94, t85.sort_num AS sort_num_95, t85.email AS email_96, t85.email_canonical AS email_canonical_97, t85.salt AS salt_98, t85.password AS password_99, t85.group_id AS group_id_100, t85.facility_id AS facility_id_101, t0.language_id AS language_id_102, t103.alias AS alias_104, t103.translate_key AS translate_key_105, t103.target_key AS target_key_106, t103.id AS id_107, t103.sort_num AS sort_num_108, t103.status AS status_109, t103.publish_at AS publish_at_110, t103.expires_at AS expires_at_111, t103.created_at AS created_at_112, t103.updated_at AS updated_at_113, t103.title AS title_114, t103.created_by AS created_by_115, t103.updated_by AS updated_by_116, t0.latest_approval_request_id AS latest_approval_request_id_117, t118.id AS id_119, t118.handler_name AS handler_name_120, t118.title AS title_121, t118.target_id AS target_id_122, t118.request_type AS request_type_123, t118.moderated_at AS moderated_at_124, t118.approval_status AS approval_status_125, t118.comment AS comment_126, t118.created_at AS created_at_127, t118.updated_at AS updated_at_128, t118.facility_id AS facility_id_129, t118.requested_by AS requested_by_130, t118.moderated_by AS moderated_by_131 FROM cms_mod_restaurant_time_by_cars t0 LEFT JOIN cms_media_item_details t19 ON t0.thumbnail = t19.id AND ((t19.status = 1 AND (t19.publish_at IS NULL OR t19.publish_at <= "2024-11-15 18:00:14") AND (t19.expires_at IS NULL OR t19.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_facility t38 ON t0.facility_id = t38.id AND ((t38.status = 1 AND (t38.publish_at IS NULL OR t38.publish_at <= "2024-11-15 18:00:14") AND (t38.expires_at IS NULL OR t38.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t67 ON t0.created_by = t67.id LEFT JOIN cms_user t85 ON t0.updated_by = t85.id LEFT JOIN cms_master_languages t103 ON t0.language_id = t103.id AND ((t103.status = 1 AND (t103.publish_at IS NULL OR t103.publish_at <= "2024-11-15 18:00:14") AND (t103.expires_at IS NULL OR t103.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_approval_requests t118 ON t0.latest_approval_request_id = t118.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 <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15")))
SELECT c0_.catch_copy AS catch_copy_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.restaurant AS restaurant_18, c0_.image AS image_19, c0_.thumbnail AS thumbnail_20, c0_.facility_id AS facility_id_21, c0_.created_by AS created_by_22, c0_.updated_by AS updated_by_23, c0_.language_id AS language_id_24, c0_.latest_approval_request_id AS latest_approval_request_id_25 FROM cms_mod_top_restaurant_pickup_items c0_ INNER JOIN cms_mod_restaurant_restaurants c1_ ON c0_.restaurant = c1_.id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14") AND (c1_.public_date IS NULL OR c1_.public_date <= "2024-11-15")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")))
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_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14")) WHERE (c0_.important = 1) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.public_date DESC LIMIT 1
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")))
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_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.public_date DESC LIMIT 5
SELECT c0_.link_url AS link_url_0, c0_.target AS target_1, c0_.public_date AS public_date_2, c0_.customblock AS customblock_3, c0_.id AS id_4, c0_.sort_num AS sort_num_5, c0_.status AS status_6, c0_.publish_at AS publish_at_7, c0_.expires_at AS expires_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.title AS title_11, c0_.language_parent AS language_parent_12, c0_.language_alias AS language_alias_13, c0_.language_active AS language_active_14, c0_.revision_parent AS revision_parent_15, c0_.revision_version AS revision_version_16, c0_.post_type AS post_type_17, c0_.access_token AS access_token_18, c0_.image AS image_19, c0_.image_sp AS image_sp_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_top_banners c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC LIMIT 1
SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")))

#▲	Time	Info
1	3.48 ms	SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE ( c0_.post_type IN ("master") ) AND ( c0_.status = 1 AND ( c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14" ) AND ( c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14" ) AND ( c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15" ) ) ORDER BY c0_.sort_num ASC, c0_.id ASC SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC;
2	6.19 ms	SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14"))) Parameters: [`[ 405 406 409 410 413 414 ]`] View formatted query View runnable query Explain query SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ( ( t14.post_type IN ("master") ) AND ( t14.status = 1 AND ( t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14" ) AND ( t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ( ( t50.post_type IN ("master") ) AND ( t50.status = 1 AND ( t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14" ) AND ( t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ( ( t0.status = 1 AND ( t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14" ) AND ( t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14" ) ) ) SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18405, 406, 409, 410, 413, 414:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")));
3	2.67 ms	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 <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14"))) Parameters: [`[ 1 ]`] View formatted query View runnable query Explain query 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 <= "2024-11-15 18:00:14" ) AND ( t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14" ) ) ) 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 <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")));
4	2.11 ms	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 (?) Parameters: [`[ 1 ]`] View formatted query View runnable query Explain query 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);
5	3.07 ms	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 <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14"))) Parameters: [`[ 1 ]`] View formatted query View runnable query Explain query 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 <= "2024-11-15 18:00:14" ) AND ( t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14" ) ) ) 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 <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")));
6	2.66 ms	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 <= "2024-11-15 18:00:14") AND (t27.expires_at IS NULL OR t27.expires_at > "2024-11-15 18:00:14"))) WHERE t0.id IN (?) Parameters: [`[ 1 ]`] View formatted query View runnable query Explain query 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 <= "2024-11-15 18:00:14" ) AND ( t27.expires_at IS NULL OR t27.expires_at > "2024-11-15 18:00:14" ) ) ) 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 <= "2024-11-15 181:14") AND (t27.expires_at IS NULL OR t27.expires_at > "2024-11-15 18:00:14"))) WHERE t0.id IN (?);
7	2.47 ms	SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_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_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.thumbnail AS thumbnail_17, c0_.facility_id AS facility_id_18, c0_.created_by AS created_by_19, c0_.updated_by AS updated_by_20, c0_.language_id AS language_id_21, c0_.latest_approval_request_id AS latest_approval_request_id_22 FROM cms_mod_restaurant_time_by_cars c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_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_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.thumbnail AS thumbnail_17, c0_.facility_id AS facility_id_18, c0_.created_by AS created_by_19, c0_.updated_by AS updated_by_20, c0_.language_id AS language_id_21, c0_.latest_approval_request_id AS latest_approval_request_id_22 FROM cms_mod_restaurant_time_by_cars c0_ WHERE ( c0_.post_type IN ("master") ) AND ( c0_.status = 1 AND ( c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14" ) AND ( c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14" ) AND ( c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15" ) ) ORDER BY c0_.sort_num ASC, c0_.id ASC SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_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_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.thumbnail AS thumbnail_17, c0_.facility_id AS facility_id_18, c0_.created_by AS created_by_19, c0_.updated_by AS updated_by_20, c0_.language_id AS language_id_21, c0_.latest_approval_request_id AS latest_approval_request_id_22 FROM cms_mod_restaurant_time_by_cars c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC;
8	2.41 ms	SELECT c0_.alias AS alias_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.thumbnail AS thumbnail_18, c0_.facility_id AS facility_id_19, c0_.created_by AS created_by_20, c0_.updated_by AS updated_by_21, c0_.language_id AS language_id_22, c0_.latest_approval_request_id AS latest_approval_request_id_23 FROM cms_mod_restaurant_scenes c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT c0_.alias AS alias_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.thumbnail AS thumbnail_18, c0_.facility_id AS facility_id_19, c0_.created_by AS created_by_20, c0_.updated_by AS updated_by_21, c0_.language_id AS language_id_22, c0_.latest_approval_request_id AS latest_approval_request_id_23 FROM cms_mod_restaurant_scenes c0_ WHERE ( c0_.post_type IN ("master") ) AND ( c0_.status = 1 AND ( c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14" ) AND ( c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14" ) AND ( c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15" ) ) ORDER BY c0_.sort_num ASC, c0_.id ASC SELECT c0_.alias AS alias_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.thumbnail AS thumbnail_18, c0_.facility_id AS facility_id_19, c0_.created_by AS created_by_20, c0_.updated_by AS updated_by_21, c0_.language_id AS language_id_22, c0_.latest_approval_request_id AS latest_approval_request_id_23 FROM cms_mod_restaurant_scenes c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC;
9	2.34 ms	SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.background_color AS background_color_3, c0_.public_date AS public_date_4, c0_.customblock AS customblock_5, c0_.id AS id_6, c0_.sort_num AS sort_num_7, c0_.status AS status_8, c0_.publish_at AS publish_at_9, c0_.expires_at AS expires_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.title AS title_13, c0_.language_parent AS language_parent_14, c0_.language_alias AS language_alias_15, c0_.language_active AS language_active_16, c0_.revision_parent AS revision_parent_17, c0_.revision_version AS revision_version_18, c0_.post_type AS post_type_19, c0_.access_token AS access_token_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_feature c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.background_color AS background_color_3, c0_.public_date AS public_date_4, c0_.customblock AS customblock_5, c0_.id AS id_6, c0_.sort_num AS sort_num_7, c0_.status AS status_8, c0_.publish_at AS publish_at_9, c0_.expires_at AS expires_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.title AS title_13, c0_.language_parent AS language_parent_14, c0_.language_alias AS language_alias_15, c0_.language_active AS language_active_16, c0_.revision_parent AS revision_parent_17, c0_.revision_version AS revision_version_18, c0_.post_type AS post_type_19, c0_.access_token AS access_token_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_feature c0_ WHERE ( c0_.post_type IN ("master") ) AND ( c0_.status = 1 AND ( c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14" ) AND ( c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14" ) AND ( c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15" ) ) ORDER BY c0_.sort_num ASC, c0_.id ASC SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.background_color AS background_color_3, c0_.public_date AS public_date_4, c0_.customblock AS customblock_5, c0_.id AS id_6, c0_.sort_num AS sort_num_7, c0_.status AS status_8, c0_.publish_at AS publish_at_9, c0_.expires_at AS expires_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.title AS title_13, c0_.language_parent AS language_parent_14, c0_.language_alias AS language_alias_15, c0_.language_active AS language_active_16, c0_.revision_parent AS revision_parent_17, c0_.revision_version AS revision_version_18, c0_.post_type AS post_type_19, c0_.access_token AS access_token_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_restaurant_feature c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC;
10	2.51 ms	SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE ( c0_.post_type IN ("master") ) AND ( c0_.status = 1 AND ( c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14" ) AND ( c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14" ) AND ( c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15" ) ) ORDER BY c0_.sort_num ASC, c0_.id ASC SELECT c0_.title_for_list AS title_for_list_0, c0_.alias AS alias_1, c0_.show_in_list AS show_in_list_2, c0_.public_date AS public_date_3, c0_.customblock AS customblock_4, c0_.id AS id_5, c0_.sort_num AS sort_num_6, c0_.status AS status_7, c0_.publish_at AS publish_at_8, c0_.expires_at AS expires_at_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.title AS title_12, c0_.language_parent AS language_parent_13, c0_.language_alias AS language_alias_14, c0_.language_active AS language_active_15, c0_.revision_parent AS revision_parent_16, c0_.revision_version AS revision_version_17, c0_.post_type AS post_type_18, c0_.access_token AS access_token_19, c0_.image_pc AS image_pc_20, c0_.image_sp AS image_sp_21, c0_.thumbnail AS thumbnail_22, c0_.facility_id AS facility_id_23, c0_.created_by AS created_by_24, c0_.updated_by AS updated_by_25, c0_.language_id AS language_id_26, c0_.latest_approval_request_id AS latest_approval_request_id_27 FROM cms_mod_restaurant_genres c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC, c0_.id ASC;
11	2.47 ms	SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_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_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.image AS image_17, c0_.time_by_car AS time_by_car_18, c0_.scene AS scene_19, c0_.thumbnail AS thumbnail_20, c0_.facility_id AS facility_id_21, c0_.created_by AS created_by_22, c0_.updated_by AS updated_by_23, c0_.language_id AS language_id_24, c0_.latest_approval_request_id AS latest_approval_request_id_25 FROM cms_mod_top_gourmet_pickup_items c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC Parameters: [] View formatted query View runnable query Explain query SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_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_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.image AS image_17, c0_.time_by_car AS time_by_car_18, c0_.scene AS scene_19, c0_.thumbnail AS thumbnail_20, c0_.facility_id AS facility_id_21, c0_.created_by AS created_by_22, c0_.updated_by AS updated_by_23, c0_.language_id AS language_id_24, c0_.latest_approval_request_id AS latest_approval_request_id_25 FROM cms_mod_top_gourmet_pickup_items c0_ WHERE ( c0_.post_type IN ("master") ) AND ( c0_.status = 1 AND ( c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14" ) AND ( c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14" ) AND ( c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15" ) ) ORDER BY c0_.sort_num ASC SELECT c0_.public_date AS public_date_0, c0_.customblock AS customblock_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_.revision_parent AS revision_parent_13, c0_.revision_version AS revision_version_14, c0_.post_type AS post_type_15, c0_.access_token AS access_token_16, c0_.image AS image_17, c0_.time_by_car AS time_by_car_18, c0_.scene AS scene_19, c0_.thumbnail AS thumbnail_20, c0_.facility_id AS facility_id_21, c0_.created_by AS created_by_22, c0_.updated_by AS updated_by_23, c0_.language_id AS language_id_24, c0_.latest_approval_request_id AS latest_approval_request_id_25 FROM cms_mod_top_gourmet_pickup_items c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC;
12	3.21 ms	SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14"))) Parameters: [`[ 626 628 590 ]`] View formatted query View runnable query Explain query SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ( ( t14.post_type IN ("master") ) AND ( t14.status = 1 AND ( t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14" ) AND ( t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ( ( t50.post_type IN ("master") ) AND ( t50.status = 1 AND ( t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14" ) AND ( t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ( ( t0.status = 1 AND ( t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14" ) AND ( t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14" ) ) ) SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18626, 628, 590:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")));
13	3.30 ms	SELECT t0.public_date AS public_date_1, t0.customblock AS customblock_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.revision_parent AS revision_parent_14, t0.revision_version AS revision_version_15, t0.post_type AS post_type_16, t0.access_token AS access_token_17, t0.thumbnail AS thumbnail_18, t19.alt AS alt_20, t19.caption AS caption_21, t19.collation_code AS collation_code_22, t19.meta AS meta_23, t19.id AS id_24, t19.sort_num AS sort_num_25, t19.status AS status_26, t19.publish_at AS publish_at_27, t19.expires_at AS expires_at_28, t19.created_at AS created_at_29, t19.updated_at AS updated_at_30, t19.title AS title_31, t19.item_id AS item_id_32, t19.thumb_item_id AS thumb_item_id_33, t19.group_id AS group_id_34, t19.created_by AS created_by_35, t19.updated_by AS updated_by_36, t0.facility_id AS facility_id_37, t38.code AS code_39, t38.title AS title_40, t38.intro_text AS intro_text_41, t38.zip AS zip_42, t38.address AS address_43, t38.building AS building_44, t38.google_maps_url AS google_maps_url_45, t38.phone AS phone_46, t38.website AS website_47, t38.opening_hours AS opening_hours_48, t38.holiday AS holiday_49, t38.access AS access_50, t38.access_car AS access_car_51, t38.access_train AS access_train_52, t38.id AS id_53, t38.sort_num AS sort_num_54, t38.status AS status_55, t38.publish_at AS publish_at_56, t38.expires_at AS expires_at_57, t38.created_at AS created_at_58, t38.updated_at AS updated_at_59, t38.area_id AS area_id_60, t38.prefecture_id AS prefecture_id_61, t38.logo_image AS logo_image_62, t38.main_image AS main_image_63, t38.created_by AS created_by_64, t38.updated_by AS updated_by_65, t0.created_by AS created_by_66, t67.username AS username_68, t67.username_canonical AS username_canonical_69, t67.enabled AS enabled_70, t67.last_login AS last_login_71, t67.confirmation_token AS confirmation_token_72, t67.password_requested_at AS password_requested_at_73, t67.roles AS roles_74, t67.id AS id_75, t67.display_name AS display_name_76, t67.sort_num AS sort_num_77, t67.email AS email_78, t67.email_canonical AS email_canonical_79, t67.salt AS salt_80, t67.password AS password_81, t67.group_id AS group_id_82, t67.facility_id AS facility_id_83, t0.updated_by AS updated_by_84, t85.username AS username_86, t85.username_canonical AS username_canonical_87, t85.enabled AS enabled_88, t85.last_login AS last_login_89, t85.confirmation_token AS confirmation_token_90, t85.password_requested_at AS password_requested_at_91, t85.roles AS roles_92, t85.id AS id_93, t85.display_name AS display_name_94, t85.sort_num AS sort_num_95, t85.email AS email_96, t85.email_canonical AS email_canonical_97, t85.salt AS salt_98, t85.password AS password_99, t85.group_id AS group_id_100, t85.facility_id AS facility_id_101, t0.language_id AS language_id_102, t103.alias AS alias_104, t103.translate_key AS translate_key_105, t103.target_key AS target_key_106, t103.id AS id_107, t103.sort_num AS sort_num_108, t103.status AS status_109, t103.publish_at AS publish_at_110, t103.expires_at AS expires_at_111, t103.created_at AS created_at_112, t103.updated_at AS updated_at_113, t103.title AS title_114, t103.created_by AS created_by_115, t103.updated_by AS updated_by_116, t0.latest_approval_request_id AS latest_approval_request_id_117, t118.id AS id_119, t118.handler_name AS handler_name_120, t118.title AS title_121, t118.target_id AS target_id_122, t118.request_type AS request_type_123, t118.moderated_at AS moderated_at_124, t118.approval_status AS approval_status_125, t118.comment AS comment_126, t118.created_at AS created_at_127, t118.updated_at AS updated_at_128, t118.facility_id AS facility_id_129, t118.requested_by AS requested_by_130, t118.moderated_by AS moderated_by_131 FROM cms_mod_restaurant_time_by_cars t0 LEFT JOIN cms_media_item_details t19 ON t0.thumbnail = t19.id AND ((t19.status = 1 AND (t19.publish_at IS NULL OR t19.publish_at <= "2024-11-15 18:00:14") AND (t19.expires_at IS NULL OR t19.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_facility t38 ON t0.facility_id = t38.id AND ((t38.status = 1 AND (t38.publish_at IS NULL OR t38.publish_at <= "2024-11-15 18:00:14") AND (t38.expires_at IS NULL OR t38.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t67 ON t0.created_by = t67.id LEFT JOIN cms_user t85 ON t0.updated_by = t85.id LEFT JOIN cms_master_languages t103 ON t0.language_id = t103.id AND ((t103.status = 1 AND (t103.publish_at IS NULL OR t103.publish_at <= "2024-11-15 18:00:14") AND (t103.expires_at IS NULL OR t103.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_approval_requests t118 ON t0.latest_approval_request_id = t118.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 <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15"))) Parameters: [`[ 1 ]`] View formatted query View runnable query Explain query SELECT t0.public_date AS public_date_1, t0.customblock AS customblock_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.revision_parent AS revision_parent_14, t0.revision_version AS revision_version_15, t0.post_type AS post_type_16, t0.access_token AS access_token_17, t0.thumbnail AS thumbnail_18, t19.alt AS alt_20, t19.caption AS caption_21, t19.collation_code AS collation_code_22, t19.meta AS meta_23, t19.id AS id_24, t19.sort_num AS sort_num_25, t19.status AS status_26, t19.publish_at AS publish_at_27, t19.expires_at AS expires_at_28, t19.created_at AS created_at_29, t19.updated_at AS updated_at_30, t19.title AS title_31, t19.item_id AS item_id_32, t19.thumb_item_id AS thumb_item_id_33, t19.group_id AS group_id_34, t19.created_by AS created_by_35, t19.updated_by AS updated_by_36, t0.facility_id AS facility_id_37, t38.code AS code_39, t38.title AS title_40, t38.intro_text AS intro_text_41, t38.zip AS zip_42, t38.address AS address_43, t38.building AS building_44, t38.google_maps_url AS google_maps_url_45, t38.phone AS phone_46, t38.website AS website_47, t38.opening_hours AS opening_hours_48, t38.holiday AS holiday_49, t38.access AS access_50, t38.access_car AS access_car_51, t38.access_train AS access_train_52, t38.id AS id_53, t38.sort_num AS sort_num_54, t38.status AS status_55, t38.publish_at AS publish_at_56, t38.expires_at AS expires_at_57, t38.created_at AS created_at_58, t38.updated_at AS updated_at_59, t38.area_id AS area_id_60, t38.prefecture_id AS prefecture_id_61, t38.logo_image AS logo_image_62, t38.main_image AS main_image_63, t38.created_by AS created_by_64, t38.updated_by AS updated_by_65, t0.created_by AS created_by_66, t67.username AS username_68, t67.username_canonical AS username_canonical_69, t67.enabled AS enabled_70, t67.last_login AS last_login_71, t67.confirmation_token AS confirmation_token_72, t67.password_requested_at AS password_requested_at_73, t67.roles AS roles_74, t67.id AS id_75, t67.display_name AS display_name_76, t67.sort_num AS sort_num_77, t67.email AS email_78, t67.email_canonical AS email_canonical_79, t67.salt AS salt_80, t67.password AS password_81, t67.group_id AS group_id_82, t67.facility_id AS facility_id_83, t0.updated_by AS updated_by_84, t85.username AS username_86, t85.username_canonical AS username_canonical_87, t85.enabled AS enabled_88, t85.last_login AS last_login_89, t85.confirmation_token AS confirmation_token_90, t85.password_requested_at AS password_requested_at_91, t85.roles AS roles_92, t85.id AS id_93, t85.display_name AS display_name_94, t85.sort_num AS sort_num_95, t85.email AS email_96, t85.email_canonical AS email_canonical_97, t85.salt AS salt_98, t85.password AS password_99, t85.group_id AS group_id_100, t85.facility_id AS facility_id_101, t0.language_id AS language_id_102, t103.alias AS alias_104, t103.translate_key AS translate_key_105, t103.target_key AS target_key_106, t103.id AS id_107, t103.sort_num AS sort_num_108, t103.status AS status_109, t103.publish_at AS publish_at_110, t103.expires_at AS expires_at_111, t103.created_at AS created_at_112, t103.updated_at AS updated_at_113, t103.title AS title_114, t103.created_by AS created_by_115, t103.updated_by AS updated_by_116, t0.latest_approval_request_id AS latest_approval_request_id_117, t118.id AS id_119, t118.handler_name AS handler_name_120, t118.title AS title_121, t118.target_id AS target_id_122, t118.request_type AS request_type_123, t118.moderated_at AS moderated_at_124, t118.approval_status AS approval_status_125, t118.comment AS comment_126, t118.created_at AS created_at_127, t118.updated_at AS updated_at_128, t118.facility_id AS facility_id_129, t118.requested_by AS requested_by_130, t118.moderated_by AS moderated_by_131 FROM cms_mod_restaurant_time_by_cars t0 LEFT JOIN cms_media_item_details t19 ON t0.thumbnail = t19.id AND ( ( t19.status = 1 AND ( t19.publish_at IS NULL OR t19.publish_at <= "2024-11-15 18:00:14" ) AND ( t19.expires_at IS NULL OR t19.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_facility t38 ON t0.facility_id = t38.id AND ( ( t38.status = 1 AND ( t38.publish_at IS NULL OR t38.publish_at <= "2024-11-15 18:00:14" ) AND ( t38.expires_at IS NULL OR t38.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_user t67 ON t0.created_by = t67.id LEFT JOIN cms_user t85 ON t0.updated_by = t85.id LEFT JOIN cms_master_languages t103 ON t0.language_id = t103.id AND ( ( t103.status = 1 AND ( t103.publish_at IS NULL OR t103.publish_at <= "2024-11-15 18:00:14" ) AND ( t103.expires_at IS NULL OR t103.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_approval_requests t118 ON t0.latest_approval_request_id = t118.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 <= "2024-11-15 18:00:14" ) AND ( t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14" ) AND ( t0.public_date IS NULL OR t0.public_date <= "2024-11-15" ) ) ) SELECT t0.public_date AS public_date_1, t0.customblock AS customblock_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.revision_parent AS revision_parent_14, t0.revision_version AS revision_version_15, t0.post_type AS post_type_16, t0.access_token AS access_token_17, t0.thumbnail AS thumbnail_18, t19.alt AS alt_20, t19.caption AS caption_21, t19.collation_code AS collation_code_22, t19.meta AS meta_23, t19.id AS id_24, t19.sort_num AS sort_num_25, t19.status AS status_26, t19.publish_at AS publish_at_27, t19.expires_at AS expires_at_28, t19.created_at AS created_at_29, t19.updated_at AS updated_at_30, t19.title AS title_31, t19.item_id AS item_id_32, t19.thumb_item_id AS thumb_item_id_33, t19.group_id AS group_id_34, t19.created_by AS created_by_35, t19.updated_by AS updated_by_36, t0.facility_id AS facility_id_37, t38.code AS code_39, t38.title AS title_40, t38.intro_text AS intro_text_41, t38.zip AS zip_42, t38.address AS address_43, t38.building AS building_44, t38.google_maps_url AS google_maps_url_45, t38.phone AS phone_46, t38.website AS website_47, t38.opening_hours AS opening_hours_48, t38.holiday AS holiday_49, t38.access AS access_50, t38.access_car AS access_car_51, t38.access_train AS access_train_52, t38.id AS id_53, t38.sort_num AS sort_num_54, t38.status AS status_55, t38.publish_at AS publish_at_56, t38.expires_at AS expires_at_57, t38.created_at AS created_at_58, t38.updated_at AS updated_at_59, t38.area_id AS area_id_60, t38.prefecture_id AS prefecture_id_61, t38.logo_image AS logo_image_62, t38.main_image AS main_image_63, t38.created_by AS created_by_64, t38.updated_by AS updated_by_65, t0.created_by AS created_by_66, t67.username AS username_68, t67.username_canonical AS username_canonical_69, t67.enabled AS enabled_70, t67.last_login AS last_login_71, t67.confirmation_token AS confirmation_token_72, t67.password_requested_at AS password_requested_at_73, t67.roles AS roles_74, t67.id AS id_75, t67.display_name AS display_name_76, t67.sort_num AS sort_num_77, t67.email AS email_78, t67.email_canonical AS email_canonical_79, t67.salt AS salt_80, t67.password AS password_81, t67.group_id AS group_id_82, t67.facility_id AS facility_id_83, t0.updated_by AS updated_by_84, t85.username AS username_86, t85.username_canonical AS username_canonical_87, t85.enabled AS enabled_88, t85.last_login AS last_login_89, t85.confirmation_token AS confirmation_token_90, t85.password_requested_at AS password_requested_at_91, t85.roles AS roles_92, t85.id AS id_93, t85.display_name AS display_name_94, t85.sort_num AS sort_num_95, t85.email AS email_96, t85.email_canonical AS email_canonical_97, t85.salt AS salt_98, t85.password AS password_99, t85.group_id AS group_id_100, t85.facility_id AS facility_id_101, t0.language_id AS language_id_102, t103.alias AS alias_104, t103.translate_key AS translate_key_105, t103.target_key AS target_key_106, t103.id AS id_107, t103.sort_num AS sort_num_108, t103.status AS status_109, t103.publish_at AS publish_at_110, t103.expires_at AS expires_at_111, t103.created_at AS created_at_112, t103.updated_at AS updated_at_113, t103.title AS title_114, t103.created_by AS created_by_115, t103.updated_by AS updated_by_116, t0.latest_approval_request_id AS latest_approval_request_id_117, t118.id AS id_119, t118.handler_name AS handler_name_120, t118.title AS title_121, t118.target_id AS target_id_122, t118.request_type AS request_type_123, t118.moderated_at AS moderated_at_124, t118.approval_status AS approval_status_125, t118.comment AS comment_126, t118.created_at AS created_at_127, t118.updated_at AS updated_at_128, t118.facility_id AS facility_id_129, t118.requested_by AS requested_by_130, t118.moderated_by AS moderated_by_131 FROM cms_mod_restaurant_time_by_cars t0 LEFT JOIN cms_media_item_details t19 ON t0.thumbnail = t19.id AND ((t19.status = 1 AND (t19.publish_at IS NULL OR t19.publish_at <= "2024-11-15 181:14") AND (t19.expires_at IS NULL OR t19.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_facility t38 ON t0.facility_id = t38.id AND ((t38.status = 1 AND (t38.publish_at IS NULL OR t38.publish_at <= "2024-11-15 18:00:14") AND (t38.expires_at IS NULL OR t38.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t67 ON t0.created_by = t67.id LEFT JOIN cms_user t85 ON t0.updated_by = t85.id LEFT JOIN cms_master_languages t103 ON t0.language_id = t103.id AND ((t103.status = 1 AND (t103.publish_at IS NULL OR t103.publish_at <= "2024-11-15 18:00:14") AND (t103.expires_at IS NULL OR t103.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_approval_requests t118 ON t0.latest_approval_request_id = t118.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 <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-15")));
14	2.67 ms	SELECT c0_.catch_copy AS catch_copy_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.restaurant AS restaurant_18, c0_.image AS image_19, c0_.thumbnail AS thumbnail_20, c0_.facility_id AS facility_id_21, c0_.created_by AS created_by_22, c0_.updated_by AS updated_by_23, c0_.language_id AS language_id_24, c0_.latest_approval_request_id AS latest_approval_request_id_25 FROM cms_mod_top_restaurant_pickup_items c0_ INNER JOIN cms_mod_restaurant_restaurants c1_ ON c0_.restaurant = c1_.id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14") AND (c1_.public_date IS NULL OR c1_.public_date <= "2024-11-15")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC Parameters: [] View formatted query View runnable query Explain query SELECT c0_.catch_copy AS catch_copy_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.restaurant AS restaurant_18, c0_.image AS image_19, c0_.thumbnail AS thumbnail_20, c0_.facility_id AS facility_id_21, c0_.created_by AS created_by_22, c0_.updated_by AS updated_by_23, c0_.language_id AS language_id_24, c0_.latest_approval_request_id AS latest_approval_request_id_25 FROM cms_mod_top_restaurant_pickup_items c0_ INNER JOIN cms_mod_restaurant_restaurants c1_ ON c0_.restaurant = c1_.id AND ( c1_.post_type IN ("master") ) AND ( c1_.status = 1 AND ( c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14" ) AND ( c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14" ) AND ( c1_.public_date IS NULL OR c1_.public_date <= "2024-11-15" ) ) WHERE ( c0_.post_type IN ("master") ) AND ( c0_.status = 1 AND ( c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14" ) AND ( c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14" ) AND ( c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15" ) ) ORDER BY c0_.sort_num ASC SELECT c0_.catch_copy AS catch_copy_0, c0_.public_date AS public_date_1, c0_.customblock AS customblock_2, c0_.id AS id_3, c0_.sort_num AS sort_num_4, c0_.status AS status_5, c0_.publish_at AS publish_at_6, c0_.expires_at AS expires_at_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.title AS title_10, c0_.language_parent AS language_parent_11, c0_.language_alias AS language_alias_12, c0_.language_active AS language_active_13, c0_.revision_parent AS revision_parent_14, c0_.revision_version AS revision_version_15, c0_.post_type AS post_type_16, c0_.access_token AS access_token_17, c0_.restaurant AS restaurant_18, c0_.image AS image_19, c0_.thumbnail AS thumbnail_20, c0_.facility_id AS facility_id_21, c0_.created_by AS created_by_22, c0_.updated_by AS updated_by_23, c0_.language_id AS language_id_24, c0_.latest_approval_request_id AS latest_approval_request_id_25 FROM cms_mod_top_restaurant_pickup_items c0_ INNER JOIN cms_mod_restaurant_restaurants c1_ ON c0_.restaurant = c1_.id AND (c1_.post_type IN ("master")) AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14") AND (c1_.public_date IS NULL OR c1_.public_date <= "2024-11-15")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC;
15	3.01 ms	SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14"))) Parameters: [`[ 674 592 ]`] View formatted query View runnable query Explain query SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ( ( t14.post_type IN ("master") ) AND ( t14.status = 1 AND ( t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14" ) AND ( t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ( ( t50.post_type IN ("master") ) AND ( t50.status = 1 AND ( t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14" ) AND ( t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ( ( t0.status = 1 AND ( t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14" ) AND ( t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14" ) ) ) SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18674, 592:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")));
16	5.86 ms	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_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14")) WHERE (c0_.important = 1) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.public_date DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query 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_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND ( c1_.status = 1 AND ( c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14" ) AND ( c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14" ) ) WHERE (c0_.important = 1) AND ( c0_.post_type IN ("master") ) AND ( c0_.status = 1 AND ( c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14" ) AND ( c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14" ) AND ( c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15" ) ) ORDER BY c0_.public_date DESC LIMIT 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_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14")) WHERE (c0_.important = 1) AND (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.public_date DESC LIMIT 1;
17	3.10 ms	SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14"))) Parameters: [`[ 618 ]`] View formatted query View runnable query Explain query SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ( ( t14.post_type IN ("master") ) AND ( t14.status = 1 AND ( t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14" ) AND ( t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ( ( t50.post_type IN ("master") ) AND ( t50.status = 1 AND ( t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14" ) AND ( t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ( ( t0.status = 1 AND ( t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14" ) AND ( t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14" ) ) ) SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18618:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")));
18	5.47 ms	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_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.public_date DESC LIMIT 5 Parameters: [] View formatted query View runnable query Explain query 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_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND ( c1_.status = 1 AND ( c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14" ) AND ( c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14" ) ) WHERE ( c0_.post_type IN ("master") ) AND ( c0_.status = 1 AND ( c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14" ) AND ( c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14" ) AND ( c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15" ) ) ORDER BY c0_.public_date DESC LIMIT 5 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_ INNER JOIN cms_mod_topics_post_category c2_ ON c0_.id = c2_.item_id INNER JOIN cms_mod_topics_categories c1_ ON c1_.id = c2_.category_id AND (c1_.status = 1 AND (c1_.publish_at IS NULL OR c1_.publish_at <= "2024-11-15 18:00:14") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-15 18:00:14")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.public_date DESC LIMIT 5;
19	2.47 ms	SELECT c0_.link_url AS link_url_0, c0_.target AS target_1, c0_.public_date AS public_date_2, c0_.customblock AS customblock_3, c0_.id AS id_4, c0_.sort_num AS sort_num_5, c0_.status AS status_6, c0_.publish_at AS publish_at_7, c0_.expires_at AS expires_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.title AS title_11, c0_.language_parent AS language_parent_12, c0_.language_alias AS language_alias_13, c0_.language_active AS language_active_14, c0_.revision_parent AS revision_parent_15, c0_.revision_version AS revision_version_16, c0_.post_type AS post_type_17, c0_.access_token AS access_token_18, c0_.image AS image_19, c0_.image_sp AS image_sp_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_top_banners c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT c0_.link_url AS link_url_0, c0_.target AS target_1, c0_.public_date AS public_date_2, c0_.customblock AS customblock_3, c0_.id AS id_4, c0_.sort_num AS sort_num_5, c0_.status AS status_6, c0_.publish_at AS publish_at_7, c0_.expires_at AS expires_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.title AS title_11, c0_.language_parent AS language_parent_12, c0_.language_alias AS language_alias_13, c0_.language_active AS language_active_14, c0_.revision_parent AS revision_parent_15, c0_.revision_version AS revision_version_16, c0_.post_type AS post_type_17, c0_.access_token AS access_token_18, c0_.image AS image_19, c0_.image_sp AS image_sp_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_top_banners c0_ WHERE ( c0_.post_type IN ("master") ) AND ( c0_.status = 1 AND ( c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14" ) AND ( c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14" ) AND ( c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15" ) ) ORDER BY c0_.sort_num ASC LIMIT 1 SELECT c0_.link_url AS link_url_0, c0_.target AS target_1, c0_.public_date AS public_date_2, c0_.customblock AS customblock_3, c0_.id AS id_4, c0_.sort_num AS sort_num_5, c0_.status AS status_6, c0_.publish_at AS publish_at_7, c0_.expires_at AS expires_at_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.title AS title_11, c0_.language_parent AS language_parent_12, c0_.language_alias AS language_alias_13, c0_.language_active AS language_active_14, c0_.revision_parent AS revision_parent_15, c0_.revision_version AS revision_version_16, c0_.post_type AS post_type_17, c0_.access_token AS access_token_18, c0_.image AS image_19, c0_.image_sp AS image_sp_20, c0_.thumbnail AS thumbnail_21, c0_.facility_id AS facility_id_22, c0_.created_by AS created_by_23, c0_.updated_by AS updated_by_24, c0_.language_id AS language_id_25, c0_.latest_approval_request_id AS latest_approval_request_id_26 FROM cms_mod_top_banners c0_ WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-15 18:00:14") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-15 18:00:14") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-15")) ORDER BY c0_.sort_num ASC LIMIT 1;
20	3.40 ms	SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14"))) Parameters: [`[ 635 636 ]`] View formatted query View runnable query Explain query SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ( ( t14.post_type IN ("master") ) AND ( t14.status = 1 AND ( t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18:00:14" ) AND ( t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ( ( t50.post_type IN ("master") ) AND ( t50.status = 1 AND ( t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14" ) AND ( t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14" ) ) ) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ( ( t0.status = 1 AND ( t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14" ) AND ( t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14" ) ) ) SELECT t0.alt AS alt_1, t0.caption AS caption_2, t0.collation_code AS collation_code_3, t0.meta AS meta_4, t0.id AS id_5, t0.sort_num AS sort_num_6, t0.status AS status_7, t0.publish_at AS publish_at_8, t0.expires_at AS expires_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.title AS title_12, t0.item_id AS item_id_13, t14.alias AS alias_15, t14.path AS path_16, t14.mime AS mime_17, t14.file_size AS file_size_18, t14.width AS width_19, t14.height AS height_20, t14.alt AS alt_21, t14.caption AS caption_22, t14.link_url AS link_url_23, t14.content_data AS content_data_24, t14.thumb_path AS thumb_path_25, t14.hidden AS hidden_26, t14.collation_code AS collation_code_27, t14.is_locked AS is_locked_28, t14.meta AS meta_29, t14.cdn_domain AS cdn_domain_30, t14.id AS id_31, t14.sort_num AS sort_num_32, t14.status AS status_33, t14.publish_at AS publish_at_34, t14.expires_at AS expires_at_35, t14.created_at AS created_at_36, t14.updated_at AS updated_at_37, t14.title AS title_38, t14.revision_parent AS revision_parent_39, t14.revision_version AS revision_version_40, t14.post_type AS post_type_41, t14.access_token AS access_token_42, t14.category AS category_43, t14.facility_id AS facility_id_44, t14.original_id AS original_id_45, t14.created_by AS created_by_46, t14.updated_by AS updated_by_47, t14.latest_approval_request_id AS latest_approval_request_id_48, t0.thumb_item_id AS thumb_item_id_49, t50.alias AS alias_51, t50.path AS path_52, t50.mime AS mime_53, t50.file_size AS file_size_54, t50.width AS width_55, t50.height AS height_56, t50.alt AS alt_57, t50.caption AS caption_58, t50.link_url AS link_url_59, t50.content_data AS content_data_60, t50.thumb_path AS thumb_path_61, t50.hidden AS hidden_62, t50.collation_code AS collation_code_63, t50.is_locked AS is_locked_64, t50.meta AS meta_65, t50.cdn_domain AS cdn_domain_66, t50.id AS id_67, t50.sort_num AS sort_num_68, t50.status AS status_69, t50.publish_at AS publish_at_70, t50.expires_at AS expires_at_71, t50.created_at AS created_at_72, t50.updated_at AS updated_at_73, t50.title AS title_74, t50.revision_parent AS revision_parent_75, t50.revision_version AS revision_version_76, t50.post_type AS post_type_77, t50.access_token AS access_token_78, t50.category AS category_79, t50.facility_id AS facility_id_80, t50.original_id AS original_id_81, t50.created_by AS created_by_82, t50.updated_by AS updated_by_83, t50.latest_approval_request_id AS latest_approval_request_id_84, t0.group_id AS group_id_85, t0.created_by AS created_by_86, t87.username AS username_88, t87.username_canonical AS username_canonical_89, t87.enabled AS enabled_90, t87.last_login AS last_login_91, t87.confirmation_token AS confirmation_token_92, t87.password_requested_at AS password_requested_at_93, t87.roles AS roles_94, t87.id AS id_95, t87.display_name AS display_name_96, t87.sort_num AS sort_num_97, t87.email AS email_98, t87.email_canonical AS email_canonical_99, t87.salt AS salt_100, t87.password AS password_101, t87.group_id AS group_id_102, t87.facility_id AS facility_id_103, t0.updated_by AS updated_by_104, t105.username AS username_106, t105.username_canonical AS username_canonical_107, t105.enabled AS enabled_108, t105.last_login AS last_login_109, t105.confirmation_token AS confirmation_token_110, t105.password_requested_at AS password_requested_at_111, t105.roles AS roles_112, t105.id AS id_113, t105.display_name AS display_name_114, t105.sort_num AS sort_num_115, t105.email AS email_116, t105.email_canonical AS email_canonical_117, t105.salt AS salt_118, t105.password AS password_119, t105.group_id AS group_id_120, t105.facility_id AS facility_id_121 FROM cms_media_item_details t0 LEFT JOIN cms_media_items t14 ON t0.item_id = t14.id AND ((t14.post_type IN ("master")) AND (t14.status = 1 AND (t14.publish_at IS NULL OR t14.publish_at <= "2024-11-15 18635, 636:14") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_media_items t50 ON t0.thumb_item_id = t50.id AND ((t50.post_type IN ("master")) AND (t50.status = 1 AND (t50.publish_at IS NULL OR t50.publish_at <= "2024-11-15 18:00:14") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-15 18:00:14"))) LEFT JOIN cms_user t87 ON t0.created_by = t87.id LEFT JOIN cms_user t105 ON t0.updated_by = t105.id WHERE t0.id IN (?) AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-15 18:00:14") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-15 18:00:14")));

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
AppBundle\Entity\Base\Base	No errors.
Mod\RestaurantBundle\Entity\Genre	No errors.
AppBundle\Entity\Media\ItemDetail	No errors.
AppBundle\Entity\Master\Facility	No errors.
FOS\UserBundle\Model\User	No errors.
AppBundle\Entity\User	No errors.
AppBundle\Entity\Master\Language	No errors.
AppBundle\Entity\Approval\ApprovalRequest	No errors.
Mod\RestaurantBundle\Entity\Restaurant	No errors.
Mod\TopBundle\Entity\GourmetPickup	No errors.
AppBundle\Entity\Media\Item	No errors.
AppBundle\Entity\Media\Category	No errors.
AppBundle\Entity\Media\Group	No errors.
AppBundle\Entity\Master\UserGroup	No errors.
AppBundle\Entity\Media\Tag	No errors.
AppBundle\Entity\Media\Usage	No errors.
AppBundle\Entity\Master\Area	No errors.
AppBundle\Entity\Master\Prefecture	No errors.
AppBundle\Entity\Master\UserPrivilege	No errors.
Mod\RestaurantBundle\Entity\TimeByCar	No errors.
Mod\RestaurantBundle\Entity\Scene	No errors.
Mod\RestaurantBundle\Entity\Feature	No errors.
Mod\TopBundle\Entity\RestaurantPickup	No errors.
Mod\TopicsBundle\Entity\Item	No errors.
Mod\TopicsBundle\Entity\Category	No errors.
Mod\TopicsBundle\Entity\Tag	No errors.
Mod\TopBundle\Entity\Banner	No errors.

Symfony Profiler

http://194.91.3.31/

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping