http://194.91.3.31/

Method
GET
HTTP Status
200
IP
45.156.128.37
Profiled on
Sat, 16 Nov 2024 06:53:06 +0900
Token
82069d

Query Metrics

37 Database Queries
19 Different statements
139.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
20.19 ms
(14.51%) 		4 
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.public_date AS public_date_4, t0.customblock AS customblock_5, t0.id AS id_6, t0.sort_num AS sort_num_7, t0.status AS status_8, t0.publish_at AS publish_at_9, t0.expires_at AS expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.title AS title_13, t0.language_parent AS language_parent_14, t0.language_alias AS language_alias_15, t0.language_active AS language_active_16, t0.revision_parent AS revision_parent_17, t0.revision_version AS revision_version_18, t0.post_type AS post_type_19, t0.access_token AS access_token_20, t0.image_pc AS image_pc_21, t22.alt AS alt_23, t22.caption AS caption_24, t22.collation_code AS collation_code_25, t22.meta AS meta_26, t22.id AS id_27, t22.sort_num AS sort_num_28, t22.status AS status_29, t22.publish_at AS publish_at_30, t22.expires_at AS expires_at_31, t22.created_at AS created_at_32, t22.updated_at AS updated_at_33, t22.title AS title_34, t22.item_id AS item_id_35, t22.thumb_item_id AS thumb_item_id_36, t22.group_id AS group_id_37, t22.created_by AS created_by_38, t22.updated_by AS updated_by_39, t0.image_sp AS image_sp_40, t41.alt AS alt_42, t41.caption AS caption_43, t41.collation_code AS collation_code_44, t41.meta AS meta_45, t41.id AS id_46, t41.sort_num AS sort_num_47, t41.status AS status_48, t41.publish_at AS publish_at_49, t41.expires_at AS expires_at_50, t41.created_at AS created_at_51, t41.updated_at AS updated_at_52, t41.title AS title_53, t41.item_id AS item_id_54, t41.thumb_item_id AS thumb_item_id_55, t41.group_id AS group_id_56, t41.created_by AS created_by_57, t41.updated_by AS updated_by_58, t0.thumbnail AS thumbnail_59, t60.alt AS alt_61, t60.caption AS caption_62, t60.collation_code AS collation_code_63, t60.meta AS meta_64, t60.id AS id_65, t60.sort_num AS sort_num_66, t60.status AS status_67, t60.publish_at AS publish_at_68, t60.expires_at AS expires_at_69, t60.created_at AS created_at_70, t60.updated_at AS updated_at_71, t60.title AS title_72, t60.item_id AS item_id_73, t60.thumb_item_id AS thumb_item_id_74, t60.group_id AS group_id_75, t60.created_by AS created_by_76, t60.updated_by AS updated_by_77, t0.facility_id AS facility_id_78, t79.code AS code_80, t79.title AS title_81, t79.intro_text AS intro_text_82, t79.zip AS zip_83, t79.address AS address_84, t79.building AS building_85, t79.google_maps_url AS google_maps_url_86, t79.phone AS phone_87, t79.website AS website_88, t79.opening_hours AS opening_hours_89, t79.holiday AS holiday_90, t79.access AS access_91, t79.access_car AS access_car_92, t79.access_train AS access_train_93, t79.id AS id_94, t79.sort_num AS sort_num_95, t79.status AS status_96, t79.publish_at AS publish_at_97, t79.expires_at AS expires_at_98, t79.created_at AS created_at_99, t79.updated_at AS updated_at_100, t79.area_id AS area_id_101, t79.prefecture_id AS prefecture_id_102, t79.logo_image AS logo_image_103, t79.main_image AS main_image_104, t79.created_by AS created_by_105, t79.updated_by AS updated_by_106, t0.created_by AS created_by_107, t108.username AS username_109, t108.username_canonical AS username_canonical_110, t108.enabled AS enabled_111, t108.last_login AS last_login_112, t108.confirmation_token AS confirmation_token_113, t108.password_requested_at AS password_requested_at_114, t108.roles AS roles_115, t108.id AS id_116, t108.display_name AS display_name_117, t108.sort_num AS sort_num_118, t108.email AS email_119, t108.email_canonical AS email_canonical_120, t108.salt AS salt_121, t108.password AS password_122, t108.group_id AS group_id_123, t108.facility_id AS facility_id_124, t0.updated_by AS updated_by_125, t126.username AS username_127, t126.username_canonical AS username_canonical_128, t126.enabled AS enabled_129, t126.last_login AS last_login_130, t126.confirmation_token AS confirmation_token_131, t126.password_requested_at AS password_requested_at_132, t126.roles AS roles_133, t126.id AS id_134, t126.display_name AS display_name_135, t126.sort_num AS sort_num_136, t126.email AS email_137, t126.email_canonical AS email_canonical_138, t126.salt AS salt_139, t126.password AS password_140, t126.group_id AS group_id_141, t126.facility_id AS facility_id_142, t0.language_id AS language_id_143, t144.alias AS alias_145, t144.translate_key AS translate_key_146, t144.target_key AS target_key_147, t144.id AS id_148, t144.sort_num AS sort_num_149, t144.status AS status_150, t144.publish_at AS publish_at_151, t144.expires_at AS expires_at_152, t144.created_at AS created_at_153, t144.updated_at AS updated_at_154, t144.title AS title_155, t144.created_by AS created_by_156, t144.updated_by AS updated_by_157, t0.latest_approval_request_id AS latest_approval_request_id_158, t159.id AS id_160, t159.handler_name AS handler_name_161, t159.title AS title_162, t159.target_id AS target_id_163, t159.request_type AS request_type_164, t159.moderated_at AS moderated_at_165, t159.approval_status AS approval_status_166, t159.comment AS comment_167, t159.created_at AS created_at_168, t159.updated_at AS updated_at_169, t159.facility_id AS facility_id_170, t159.requested_by AS requested_by_171, t159.moderated_by AS moderated_by_172 FROM cms_mod_restaurant_genres t0 LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id AND ((t22.status = 1 AND (t22.publish_at IS NULL OR t22.publish_at <= "2024-11-16 06:53:06") AND (t22.expires_at IS NULL OR t22.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id AND ((t41.status = 1 AND (t41.publish_at IS NULL OR t41.publish_at <= "2024-11-16 06:53:06") AND (t41.expires_at IS NULL OR t41.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id AND ((t60.status = 1 AND (t60.publish_at IS NULL OR t60.publish_at <= "2024-11-16 06:53:06") AND (t60.expires_at IS NULL OR t60.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2024-11-16 06:53:06") AND (t79.expires_at IS NULL OR t79.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_user t108 ON t0.created_by = t108.id LEFT JOIN cms_user t126 ON t0.updated_by = t126.id LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id AND ((t144.status = 1 AND (t144.publish_at IS NULL OR t144.publish_at <= "2024-11-16 06:53:06") AND (t144.expires_at IS NULL OR t144.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id INNER JOIN cms_mod_top_gourmet_pickup_items_genres ON t0.id = cms_mod_top_gourmet_pickup_items_genres.genre_id WHERE cms_mod_top_gourmet_pickup_items_genres.gourmet_pickup_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-16 06:53:06") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-16 06:53:06") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-16"))) ORDER BY t0.sort_num ASC, t0.id ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
19.25 ms
(13.83%) 		5 
SELECT t0.is_root AS is_root_1, t0.category_role AS category_role_2, t0.id AS id_3, t0.sort_num AS sort_num_4, t0.status AS status_5, t0.publish_at AS publish_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.title AS title_10, t0.language_parent AS language_parent_11, t0.language_alias AS language_alias_12, t0.language_active AS language_active_13, t0.lock_flags AS lock_flags_14, t0.parent_id AS parent_id_15, t16.is_root AS is_root_17, t16.category_role AS category_role_18, t16.id AS id_19, t16.sort_num AS sort_num_20, t16.status AS status_21, t16.publish_at AS publish_at_22, t16.expires_at AS expires_at_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t16.title AS title_26, t16.language_parent AS language_parent_27, t16.language_alias AS language_alias_28, t16.language_active AS language_active_29, t16.lock_flags AS lock_flags_30, t16.parent_id AS parent_id_31, t16.facility_id AS facility_id_32, t16.created_by AS created_by_33, t16.updated_by AS updated_by_34, t16.language_id AS language_id_35, t0.facility_id AS facility_id_36, t37.code AS code_38, t37.title AS title_39, t37.intro_text AS intro_text_40, t37.zip AS zip_41, t37.address AS address_42, t37.building AS building_43, t37.google_maps_url AS google_maps_url_44, t37.phone AS phone_45, t37.website AS website_46, t37.opening_hours AS opening_hours_47, t37.holiday AS holiday_48, t37.access AS access_49, t37.access_car AS access_car_50, t37.access_train AS access_train_51, t37.id AS id_52, t37.sort_num AS sort_num_53, t37.status AS status_54, t37.publish_at AS publish_at_55, t37.expires_at AS expires_at_56, t37.created_at AS created_at_57, t37.updated_at AS updated_at_58, t37.area_id AS area_id_59, t37.prefecture_id AS prefecture_id_60, t37.logo_image AS logo_image_61, t37.main_image AS main_image_62, t37.created_by AS created_by_63, t37.updated_by AS updated_by_64, t0.created_by AS created_by_65, t66.username AS username_67, t66.username_canonical AS username_canonical_68, t66.enabled AS enabled_69, t66.last_login AS last_login_70, t66.confirmation_token AS confirmation_token_71, t66.password_requested_at AS password_requested_at_72, t66.roles AS roles_73, t66.id AS id_74, t66.display_name AS display_name_75, t66.sort_num AS sort_num_76, t66.email AS email_77, t66.email_canonical AS email_canonical_78, t66.salt AS salt_79, t66.password AS password_80, t66.group_id AS group_id_81, t66.facility_id AS facility_id_82, t0.updated_by AS updated_by_83, t84.username AS username_85, t84.username_canonical AS username_canonical_86, t84.enabled AS enabled_87, t84.last_login AS last_login_88, t84.confirmation_token AS confirmation_token_89, t84.password_requested_at AS password_requested_at_90, t84.roles AS roles_91, t84.id AS id_92, t84.display_name AS display_name_93, t84.sort_num AS sort_num_94, t84.email AS email_95, t84.email_canonical AS email_canonical_96, t84.salt AS salt_97, t84.password AS password_98, t84.group_id AS group_id_99, t84.facility_id AS facility_id_100, t0.language_id AS language_id_101, t102.alias AS alias_103, t102.translate_key AS translate_key_104, t102.target_key AS target_key_105, t102.id AS id_106, t102.sort_num AS sort_num_107, t102.status AS status_108, t102.publish_at AS publish_at_109, t102.expires_at AS expires_at_110, t102.created_at AS created_at_111, t102.updated_at AS updated_at_112, t102.title AS title_113, t102.created_by AS created_by_114, t102.updated_by AS updated_by_115 FROM cms_mod_topics_categories t0 LEFT JOIN cms_mod_topics_categories t16 ON t0.parent_id = t16.id AND ((t16.status = 1 AND (t16.publish_at IS NULL OR t16.publish_at <= "2024-11-16 06:53:06") AND (t16.expires_at IS NULL OR t16.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_facility t37 ON t0.facility_id = t37.id AND ((t37.status = 1 AND (t37.publish_at IS NULL OR t37.publish_at <= "2024-11-16 06:53:06") AND (t37.expires_at IS NULL OR t37.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_user t66 ON t0.created_by = t66.id LEFT JOIN cms_user t84 ON t0.updated_by = t84.id LEFT JOIN cms_master_languages t102 ON t0.language_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2024-11-16 06:53:06") AND (t102.expires_at IS NULL OR t102.expires_at > "2024-11-16 06:53:06"))) INNER JOIN cms_mod_topics_post_category ON t0.id = cms_mod_topics_post_category.category_id WHERE cms_mod_topics_post_category.item_id = ? AND ((t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-16 06:53:06") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-16 06:53:06"))) ORDER BY t0.sort_num ASC, t0.id ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
18.37 ms
(13.20%) 		5 
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-16 06:53:06") AND (t14.expires_at IS NULL OR t14.expires_at > "2024-11-16 06:53:06"))) 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-16 06:53:06") AND (t50.expires_at IS NULL OR t50.expires_at > "2024-11-16 06:53:06"))) 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-16 06:53:06") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-16 06:53:06")))
Parameters: 
[
  [
    405
    406
    409
    410
    413
    414
  ]
]
View formatted query    View runnable query    Explain query
16.06 ms
(11.54%) 		4 
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.background_color AS background_color_4, t0.public_date AS public_date_5, t0.customblock AS customblock_6, t0.id AS id_7, t0.sort_num AS sort_num_8, t0.status AS status_9, t0.publish_at AS publish_at_10, t0.expires_at AS expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.title AS title_14, t0.language_parent AS language_parent_15, t0.language_alias AS language_alias_16, t0.language_active AS language_active_17, t0.revision_parent AS revision_parent_18, t0.revision_version AS revision_version_19, t0.post_type AS post_type_20, t0.access_token AS access_token_21, t0.thumbnail AS thumbnail_22, t23.alt AS alt_24, t23.caption AS caption_25, t23.collation_code AS collation_code_26, t23.meta AS meta_27, t23.id AS id_28, t23.sort_num AS sort_num_29, t23.status AS status_30, t23.publish_at AS publish_at_31, t23.expires_at AS expires_at_32, t23.created_at AS created_at_33, t23.updated_at AS updated_at_34, t23.title AS title_35, t23.item_id AS item_id_36, t23.thumb_item_id AS thumb_item_id_37, t23.group_id AS group_id_38, t23.created_by AS created_by_39, t23.updated_by AS updated_by_40, t0.facility_id AS facility_id_41, t42.code AS code_43, t42.title AS title_44, t42.intro_text AS intro_text_45, t42.zip AS zip_46, t42.address AS address_47, t42.building AS building_48, t42.google_maps_url AS google_maps_url_49, t42.phone AS phone_50, t42.website AS website_51, t42.opening_hours AS opening_hours_52, t42.holiday AS holiday_53, t42.access AS access_54, t42.access_car AS access_car_55, t42.access_train AS access_train_56, t42.id AS id_57, t42.sort_num AS sort_num_58, t42.status AS status_59, t42.publish_at AS publish_at_60, t42.expires_at AS expires_at_61, t42.created_at AS created_at_62, t42.updated_at AS updated_at_63, t42.area_id AS area_id_64, t42.prefecture_id AS prefecture_id_65, t42.logo_image AS logo_image_66, t42.main_image AS main_image_67, t42.created_by AS created_by_68, t42.updated_by AS updated_by_69, t0.created_by AS created_by_70, t71.username AS username_72, t71.username_canonical AS username_canonical_73, t71.enabled AS enabled_74, t71.last_login AS last_login_75, t71.confirmation_token AS confirmation_token_76, t71.password_requested_at AS password_requested_at_77, t71.roles AS roles_78, t71.id AS id_79, t71.display_name AS display_name_80, t71.sort_num AS sort_num_81, t71.email AS email_82, t71.email_canonical AS email_canonical_83, t71.salt AS salt_84, t71.password AS password_85, t71.group_id AS group_id_86, t71.facility_id AS facility_id_87, t0.updated_by AS updated_by_88, t89.username AS username_90, t89.username_canonical AS username_canonical_91, t89.enabled AS enabled_92, t89.last_login AS last_login_93, t89.confirmation_token AS confirmation_token_94, t89.password_requested_at AS password_requested_at_95, t89.roles AS roles_96, t89.id AS id_97, t89.display_name AS display_name_98, t89.sort_num AS sort_num_99, t89.email AS email_100, t89.email_canonical AS email_canonical_101, t89.salt AS salt_102, t89.password AS password_103, t89.group_id AS group_id_104, t89.facility_id AS facility_id_105, t0.language_id AS language_id_106, t107.alias AS alias_108, t107.translate_key AS translate_key_109, t107.target_key AS target_key_110, t107.id AS id_111, t107.sort_num AS sort_num_112, t107.status AS status_113, t107.publish_at AS publish_at_114, t107.expires_at AS expires_at_115, t107.created_at AS created_at_116, t107.updated_at AS updated_at_117, t107.title AS title_118, t107.created_by AS created_by_119, t107.updated_by AS updated_by_120, t0.latest_approval_request_id AS latest_approval_request_id_121, t122.id AS id_123, t122.handler_name AS handler_name_124, t122.title AS title_125, t122.target_id AS target_id_126, t122.request_type AS request_type_127, t122.moderated_at AS moderated_at_128, t122.approval_status AS approval_status_129, t122.comment AS comment_130, t122.created_at AS created_at_131, t122.updated_at AS updated_at_132, t122.facility_id AS facility_id_133, t122.requested_by AS requested_by_134, t122.moderated_by AS moderated_by_135 FROM cms_mod_restaurant_feature t0 LEFT JOIN cms_media_item_details t23 ON t0.thumbnail = t23.id AND ((t23.status = 1 AND (t23.publish_at IS NULL OR t23.publish_at <= "2024-11-16 06:53:06") AND (t23.expires_at IS NULL OR t23.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_facility t42 ON t0.facility_id = t42.id AND ((t42.status = 1 AND (t42.publish_at IS NULL OR t42.publish_at <= "2024-11-16 06:53:06") AND (t42.expires_at IS NULL OR t42.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_user t71 ON t0.created_by = t71.id LEFT JOIN cms_user t89 ON t0.updated_by = t89.id LEFT JOIN cms_master_languages t107 ON t0.language_id = t107.id AND ((t107.status = 1 AND (t107.publish_at IS NULL OR t107.publish_at <= "2024-11-16 06:53:06") AND (t107.expires_at IS NULL OR t107.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_approval_requests t122 ON t0.latest_approval_request_id = t122.id INNER JOIN cms_mod_top_gourmet_pickup_items_features ON t0.id = cms_mod_top_gourmet_pickup_items_features.feature_id WHERE cms_mod_top_gourmet_pickup_items_features.gourmet_pickup_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-16 06:53:06") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-16 06:53:06") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-16"))) ORDER BY t0.sort_num ASC, t0.id ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
10.71 ms
(7.69%) 		2 
SELECT t0.this_month_recommendation AS this_month_recommendation_1, t0.title_kana AS title_kana_2, t0.business_hours AS business_hours_3, t0.business_hours_supplement AS business_hours_supplement_4, t0.holiday AS holiday_5, t0.holiday_supplement AS holiday_supplement_6, t0.description AS description_7, t0.map_url AS map_url_8, t0.route AS route_9, t0.tabelog_reserve AS tabelog_reserve_10, t0.hotpepper_reserve AS hotpepper_reserve_11, t0.ikyu_reserve AS ikyu_reserve_12, t0.contact_etc AS contact_etc_13, t0.tel AS tel_14, t0.information AS information_15, t0.budget AS budget_16, t0.address AS address_17, t0.access AS access_18, t0.parking AS parking_19, t0.seats AS seats_20, t0.private_room AS private_room_21, t0.payment AS payment_22, t0.site_url_1 AS site_url_1_23, t0.site_url_2 AS site_url_2_24, t0.site_url_3 AS site_url_3_25, t0.map_iframe AS map_iframe_26, t0.public_date AS public_date_27, t0.customblock AS customblock_28, t0.id AS id_29, t0.sort_num AS sort_num_30, t0.status AS status_31, t0.publish_at AS publish_at_32, t0.expires_at AS expires_at_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.title AS title_36, t0.language_parent AS language_parent_37, t0.language_alias AS language_alias_38, t0.language_active AS language_active_39, t0.revision_parent AS revision_parent_40, t0.revision_version AS revision_version_41, t0.post_type AS post_type_42, t0.access_token AS access_token_43, t0.main_image AS main_image_44, t45.meta AS meta_46, t45.id AS id_47, t45.sort_num AS sort_num_48, t45.status AS status_49, t45.publish_at AS publish_at_50, t45.expires_at AS expires_at_51, t45.created_at AS created_at_52, t45.updated_at AS updated_at_53, t45.title AS title_54, t45.created_by AS created_by_55, t45.updated_by AS updated_by_56, t0.time_by_car_id AS time_by_car_id_57, t58.public_date AS public_date_59, t58.customblock AS customblock_60, t58.id AS id_61, t58.sort_num AS sort_num_62, t58.status AS status_63, t58.publish_at AS publish_at_64, t58.expires_at AS expires_at_65, t58.created_at AS created_at_66, t58.updated_at AS updated_at_67, t58.title AS title_68, t58.language_parent AS language_parent_69, t58.language_alias AS language_alias_70, t58.language_active AS language_active_71, t58.revision_parent AS revision_parent_72, t58.revision_version AS revision_version_73, t58.post_type AS post_type_74, t58.access_token AS access_token_75, t58.thumbnail AS thumbnail_76, t58.facility_id AS facility_id_77, t58.created_by AS created_by_78, t58.updated_by AS updated_by_79, t58.language_id AS language_id_80, t58.latest_approval_request_id AS latest_approval_request_id_81, t0.thumbnail AS thumbnail_82, t83.alt AS alt_84, t83.caption AS caption_85, t83.collation_code AS collation_code_86, t83.meta AS meta_87, t83.id AS id_88, t83.sort_num AS sort_num_89, t83.status AS status_90, t83.publish_at AS publish_at_91, t83.expires_at AS expires_at_92, t83.created_at AS created_at_93, t83.updated_at AS updated_at_94, t83.title AS title_95, t83.item_id AS item_id_96, t83.thumb_item_id AS thumb_item_id_97, t83.group_id AS group_id_98, t83.created_by AS created_by_99, t83.updated_by AS updated_by_100, t0.facility_id AS facility_id_101, t102.code AS code_103, t102.title AS title_104, t102.intro_text AS intro_text_105, t102.zip AS zip_106, t102.address AS address_107, t102.building AS building_108, t102.google_maps_url AS google_maps_url_109, t102.phone AS phone_110, t102.website AS website_111, t102.opening_hours AS opening_hours_112, t102.holiday AS holiday_113, t102.access AS access_114, t102.access_car AS access_car_115, t102.access_train AS access_train_116, t102.id AS id_117, t102.sort_num AS sort_num_118, t102.status AS status_119, t102.publish_at AS publish_at_120, t102.expires_at AS expires_at_121, t102.created_at AS created_at_122, t102.updated_at AS updated_at_123, t102.area_id AS area_id_124, t102.prefecture_id AS prefecture_id_125, t102.logo_image AS logo_image_126, t102.main_image AS main_image_127, t102.created_by AS created_by_128, t102.updated_by AS updated_by_129, t0.created_by AS created_by_130, t131.username AS username_132, t131.username_canonical AS username_canonical_133, t131.enabled AS enabled_134, t131.last_login AS last_login_135, t131.confirmation_token AS confirmation_token_136, t131.password_requested_at AS password_requested_at_137, t131.roles AS roles_138, t131.id AS id_139, t131.display_name AS display_name_140, t131.sort_num AS sort_num_141, t131.email AS email_142, t131.email_canonical AS email_canonical_143, t131.salt AS salt_144, t131.password AS password_145, t131.group_id AS group_id_146, t131.facility_id AS facility_id_147, t0.updated_by AS updated_by_148, t149.username AS username_150, t149.username_canonical AS username_canonical_151, t149.enabled AS enabled_152, t149.last_login AS last_login_153, t149.confirmation_token AS confirmation_token_154, t149.password_requested_at AS password_requested_at_155, t149.roles AS roles_156, t149.id AS id_157, t149.display_name AS display_name_158, t149.sort_num AS sort_num_159, t149.email AS email_160, t149.email_canonical AS email_canonical_161, t149.salt AS salt_162, t149.password AS password_163, t149.group_id AS group_id_164, t149.facility_id AS facility_id_165, t0.language_id AS language_id_166, t167.alias AS alias_168, t167.translate_key AS translate_key_169, t167.target_key AS target_key_170, t167.id AS id_171, t167.sort_num AS sort_num_172, t167.status AS status_173, t167.publish_at AS publish_at_174, t167.expires_at AS expires_at_175, t167.created_at AS created_at_176, t167.updated_at AS updated_at_177, t167.title AS title_178, t167.created_by AS created_by_179, t167.updated_by AS updated_by_180, t0.latest_approval_request_id AS latest_approval_request_id_181, t182.id AS id_183, t182.handler_name AS handler_name_184, t182.title AS title_185, t182.target_id AS target_id_186, t182.request_type AS request_type_187, t182.moderated_at AS moderated_at_188, t182.approval_status AS approval_status_189, t182.comment AS comment_190, t182.created_at AS created_at_191, t182.updated_at AS updated_at_192, t182.facility_id AS facility_id_193, t182.requested_by AS requested_by_194, t182.moderated_by AS moderated_by_195 FROM cms_mod_restaurant_restaurants t0 LEFT JOIN cms_media_groups t45 ON t0.main_image = t45.id AND ((t45.status = 1 AND (t45.publish_at IS NULL OR t45.publish_at <= "2024-11-16 06:53:06") AND (t45.expires_at IS NULL OR t45.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_mod_restaurant_time_by_cars t58 ON t0.time_by_car_id = t58.id AND ((t58.post_type IN ("master")) AND (t58.status = 1 AND (t58.publish_at IS NULL OR t58.publish_at <= "2024-11-16 06:53:06") AND (t58.expires_at IS NULL OR t58.expires_at > "2024-11-16 06:53:06") AND (t58.public_date IS NULL OR t58.public_date <= "2024-11-16"))) LEFT JOIN cms_media_item_details t83 ON t0.thumbnail = t83.id AND ((t83.status = 1 AND (t83.publish_at IS NULL OR t83.publish_at <= "2024-11-16 06:53:06") AND (t83.expires_at IS NULL OR t83.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_facility t102 ON t0.facility_id = t102.id AND ((t102.status = 1 AND (t102.publish_at IS NULL OR t102.publish_at <= "2024-11-16 06:53:06") AND (t102.expires_at IS NULL OR t102.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_user t131 ON t0.created_by = t131.id LEFT JOIN cms_user t149 ON t0.updated_by = t149.id LEFT JOIN cms_master_languages t167 ON t0.language_id = t167.id AND ((t167.status = 1 AND (t167.publish_at IS NULL OR t167.publish_at <= "2024-11-16 06:53:06") AND (t167.expires_at IS NULL OR t167.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_approval_requests t182 ON t0.latest_approval_request_id = t182.id WHERE t0.id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-16 06:53:06") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-16 06:53:06") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-16")))
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
8.79 ms
(6.32%) 		2 
SELECT t0.title_for_list AS title_for_list_1, t0.alias AS alias_2, t0.show_in_list AS show_in_list_3, t0.public_date AS public_date_4, t0.customblock AS customblock_5, t0.id AS id_6, t0.sort_num AS sort_num_7, t0.status AS status_8, t0.publish_at AS publish_at_9, t0.expires_at AS expires_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.title AS title_13, t0.language_parent AS language_parent_14, t0.language_alias AS language_alias_15, t0.language_active AS language_active_16, t0.revision_parent AS revision_parent_17, t0.revision_version AS revision_version_18, t0.post_type AS post_type_19, t0.access_token AS access_token_20, t0.image_pc AS image_pc_21, t22.alt AS alt_23, t22.caption AS caption_24, t22.collation_code AS collation_code_25, t22.meta AS meta_26, t22.id AS id_27, t22.sort_num AS sort_num_28, t22.status AS status_29, t22.publish_at AS publish_at_30, t22.expires_at AS expires_at_31, t22.created_at AS created_at_32, t22.updated_at AS updated_at_33, t22.title AS title_34, t22.item_id AS item_id_35, t22.thumb_item_id AS thumb_item_id_36, t22.group_id AS group_id_37, t22.created_by AS created_by_38, t22.updated_by AS updated_by_39, t0.image_sp AS image_sp_40, t41.alt AS alt_42, t41.caption AS caption_43, t41.collation_code AS collation_code_44, t41.meta AS meta_45, t41.id AS id_46, t41.sort_num AS sort_num_47, t41.status AS status_48, t41.publish_at AS publish_at_49, t41.expires_at AS expires_at_50, t41.created_at AS created_at_51, t41.updated_at AS updated_at_52, t41.title AS title_53, t41.item_id AS item_id_54, t41.thumb_item_id AS thumb_item_id_55, t41.group_id AS group_id_56, t41.created_by AS created_by_57, t41.updated_by AS updated_by_58, t0.thumbnail AS thumbnail_59, t60.alt AS alt_61, t60.caption AS caption_62, t60.collation_code AS collation_code_63, t60.meta AS meta_64, t60.id AS id_65, t60.sort_num AS sort_num_66, t60.status AS status_67, t60.publish_at AS publish_at_68, t60.expires_at AS expires_at_69, t60.created_at AS created_at_70, t60.updated_at AS updated_at_71, t60.title AS title_72, t60.item_id AS item_id_73, t60.thumb_item_id AS thumb_item_id_74, t60.group_id AS group_id_75, t60.created_by AS created_by_76, t60.updated_by AS updated_by_77, t0.facility_id AS facility_id_78, t79.code AS code_80, t79.title AS title_81, t79.intro_text AS intro_text_82, t79.zip AS zip_83, t79.address AS address_84, t79.building AS building_85, t79.google_maps_url AS google_maps_url_86, t79.phone AS phone_87, t79.website AS website_88, t79.opening_hours AS opening_hours_89, t79.holiday AS holiday_90, t79.access AS access_91, t79.access_car AS access_car_92, t79.access_train AS access_train_93, t79.id AS id_94, t79.sort_num AS sort_num_95, t79.status AS status_96, t79.publish_at AS publish_at_97, t79.expires_at AS expires_at_98, t79.created_at AS created_at_99, t79.updated_at AS updated_at_100, t79.area_id AS area_id_101, t79.prefecture_id AS prefecture_id_102, t79.logo_image AS logo_image_103, t79.main_image AS main_image_104, t79.created_by AS created_by_105, t79.updated_by AS updated_by_106, t0.created_by AS created_by_107, t108.username AS username_109, t108.username_canonical AS username_canonical_110, t108.enabled AS enabled_111, t108.last_login AS last_login_112, t108.confirmation_token AS confirmation_token_113, t108.password_requested_at AS password_requested_at_114, t108.roles AS roles_115, t108.id AS id_116, t108.display_name AS display_name_117, t108.sort_num AS sort_num_118, t108.email AS email_119, t108.email_canonical AS email_canonical_120, t108.salt AS salt_121, t108.password AS password_122, t108.group_id AS group_id_123, t108.facility_id AS facility_id_124, t0.updated_by AS updated_by_125, t126.username AS username_127, t126.username_canonical AS username_canonical_128, t126.enabled AS enabled_129, t126.last_login AS last_login_130, t126.confirmation_token AS confirmation_token_131, t126.password_requested_at AS password_requested_at_132, t126.roles AS roles_133, t126.id AS id_134, t126.display_name AS display_name_135, t126.sort_num AS sort_num_136, t126.email AS email_137, t126.email_canonical AS email_canonical_138, t126.salt AS salt_139, t126.password AS password_140, t126.group_id AS group_id_141, t126.facility_id AS facility_id_142, t0.language_id AS language_id_143, t144.alias AS alias_145, t144.translate_key AS translate_key_146, t144.target_key AS target_key_147, t144.id AS id_148, t144.sort_num AS sort_num_149, t144.status AS status_150, t144.publish_at AS publish_at_151, t144.expires_at AS expires_at_152, t144.created_at AS created_at_153, t144.updated_at AS updated_at_154, t144.title AS title_155, t144.created_by AS created_by_156, t144.updated_by AS updated_by_157, t0.latest_approval_request_id AS latest_approval_request_id_158, t159.id AS id_160, t159.handler_name AS handler_name_161, t159.title AS title_162, t159.target_id AS target_id_163, t159.request_type AS request_type_164, t159.moderated_at AS moderated_at_165, t159.approval_status AS approval_status_166, t159.comment AS comment_167, t159.created_at AS created_at_168, t159.updated_at AS updated_at_169, t159.facility_id AS facility_id_170, t159.requested_by AS requested_by_171, t159.moderated_by AS moderated_by_172 FROM cms_mod_restaurant_genres t0 LEFT JOIN cms_media_item_details t22 ON t0.image_pc = t22.id AND ((t22.status = 1 AND (t22.publish_at IS NULL OR t22.publish_at <= "2024-11-16 06:53:06") AND (t22.expires_at IS NULL OR t22.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_media_item_details t41 ON t0.image_sp = t41.id AND ((t41.status = 1 AND (t41.publish_at IS NULL OR t41.publish_at <= "2024-11-16 06:53:06") AND (t41.expires_at IS NULL OR t41.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_media_item_details t60 ON t0.thumbnail = t60.id AND ((t60.status = 1 AND (t60.publish_at IS NULL OR t60.publish_at <= "2024-11-16 06:53:06") AND (t60.expires_at IS NULL OR t60.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_facility t79 ON t0.facility_id = t79.id AND ((t79.status = 1 AND (t79.publish_at IS NULL OR t79.publish_at <= "2024-11-16 06:53:06") AND (t79.expires_at IS NULL OR t79.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_user t108 ON t0.created_by = t108.id LEFT JOIN cms_user t126 ON t0.updated_by = t126.id LEFT JOIN cms_master_languages t144 ON t0.language_id = t144.id AND ((t144.status = 1 AND (t144.publish_at IS NULL OR t144.publish_at <= "2024-11-16 06:53:06") AND (t144.expires_at IS NULL OR t144.expires_at > "2024-11-16 06:53:06"))) LEFT JOIN cms_approval_requests t159 ON t0.latest_approval_request_id = t159.id INNER JOIN cms_mod_restaurant_restaurants_genres ON t0.id = cms_mod_restaurant_restaurants_genres.genre_id WHERE cms_mod_restaurant_restaurants_genres.restaurant_id = ? AND ((t0.post_type IN ("master")) AND (t0.status = 1 AND (t0.publish_at IS NULL OR t0.publish_at <= "2024-11-16 06:53:06") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-16 06:53:06") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-16"))) ORDER BY t0.sort_num ASC, t0.id ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
5.89 ms
(4.23%) 		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-16 06:53:06") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-16 06:53:06")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-16 06:53:06") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 06:53:06") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.public_date DESC LIMIT 5
Parameters: 
[]
View formatted query    View runnable query    Explain query
5.85 ms
(4.20%) 		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-16 06:53:06") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-16 06:53:06")) 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-16 06:53:06") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 06:53:06") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.public_date DESC LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
5.46 ms
(3.92%) 		2 
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-16 06:53:06") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 06:53:06") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.sort_num ASC, c0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
5.36 ms
(3.85%) 		2 
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-16 06:53:06") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-16 06:53:06")))
Parameters: 
[
  [
    1
  ]
]
View formatted query    View runnable query    Explain query
3.20 ms
(2.30%) 		1 
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-16 06:53:06") AND (t19.expires_at IS NULL OR t19.expires_at > "2024-11-16 06:53:06"))) 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-16 06:53:06") AND (t38.expires_at IS NULL OR t38.expires_at > "2024-11-16 06:53:06"))) 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-16 06:53:06") AND (t103.expires_at IS NULL OR t103.expires_at > "2024-11-16 06:53:06"))) 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-16 06:53:06") AND (t0.expires_at IS NULL OR t0.expires_at > "2024-11-16 06:53:06") AND (t0.public_date IS NULL OR t0.public_date <= "2024-11-16")))
Parameters: 
[
  [
    1
  ]
]
View formatted query    View runnable query    Explain query
2.75 ms
(1.98%) 		1 
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-16 06:53:06") AND (c1_.expires_at IS NULL OR c1_.expires_at > "2024-11-16 06:53:06") AND (c1_.public_date IS NULL OR c1_.public_date <= "2024-11-16")) WHERE (c0_.post_type IN ("master")) AND (c0_.status = 1 AND (c0_.publish_at IS NULL OR c0_.publish_at <= "2024-11-16 06:53:06") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 06:53:06") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.sort_num ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.59 ms
(1.86%) 		1 
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.roles AS roles_7, t0.id AS id_8, t0.display_name AS display_name_9, t0.sort_num AS sort_num_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.salt AS salt_13, t0.password AS password_14, t0.group_id AS group_id_15, t16.id AS id_17, t16.is_wheel AS is_wheel_18, t16.is_system_admin AS is_system_admin_19, t16.level AS level_20, t16.name AS name_21, t16.display_name AS display_name_22, t16.description AS description_23, t16.created_at AS created_at_24, t16.updated_at AS updated_at_25, t0.facility_id AS facility_id_26, t27.code AS code_28, t27.title AS title_29, t27.intro_text AS intro_text_30, t27.zip AS zip_31, t27.address AS address_32, t27.building AS building_33, t27.google_maps_url AS google_maps_url_34, t27.phone AS phone_35, t27.website AS website_36, t27.opening_hours AS opening_hours_37, t27.holiday AS holiday_38, t27.access AS access_39, t27.access_car AS access_car_40, t27.access_train AS access_train_41, t27.id AS id_42, t27.sort_num AS sort_num_43, t27.status AS status_44, t27.publish_at AS publish_at_45, t27.expires_at AS expires_at_46, t27.created_at AS created_at_47, t27.updated_at AS updated_at_48, t27.area_id AS area_id_49, t27.prefecture_id AS prefecture_id_50, t27.logo_image AS logo_image_51, t27.main_image AS main_image_52, t27.created_by AS created_by_53, t27.updated_by AS updated_by_54 FROM cms_user t0 LEFT JOIN cms_user_groups t16 ON t0.group_id = t16.id LEFT JOIN cms_facility t27 ON t0.facility_id = t27.id AND ((t27.status = 1 AND (t27.publish_at IS NULL OR t27.publish_at <= "2024-11-16 06:53:06") AND (t27.expires_at IS NULL OR t27.expires_at > "2024-11-16 06:53:06"))) WHERE t0.id IN (?)
Parameters: 
[
  [
    1
  ]
]
View formatted query    View runnable query    Explain query
2.59 ms
(1.86%) 		1 
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-16 06:53:06") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 06:53:06") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.sort_num ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.52 ms
(1.81%) 		1 
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-16 06:53:06") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 06:53:06") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.sort_num ASC, c0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.50 ms
(1.80%) 		1 
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-16 06:53:06") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 06:53:06") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.sort_num ASC, c0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.49 ms
(1.79%) 		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-16 06:53:06") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 06:53:06") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.sort_num ASC LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.43 ms
(1.75%) 		1 
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-16 06:53:06") AND (c0_.expires_at IS NULL OR c0_.expires_at > "2024-11-16 06:53:06") AND (c0_.public_date IS NULL OR c0_.public_date <= "2024-11-16")) ORDER BY c0_.sort_num ASC, c0_.id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.20 ms
(1.58%) 		1 
SELECT t0.id AS id_1, t0.is_wheel AS is_wheel_2, t0.is_system_admin AS is_system_admin_3, t0.level AS level_4, t0.name AS name_5, t0.display_name AS display_name_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM cms_user_groups t0 WHERE t0.id IN (?)
Parameters: 
[
  [
    1
  ]
]
View formatted query    View runnable query    Explain query

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.