Teppan Dining Houki
鉄板ダイニング 法貴

Tourists, please contact us through the hotel concierge or tour guide

Please pay at the table

(default) 16 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `MstRemarkFixed`.`id`, `MstRemarkFixed`.`name_ja`, `MstRemarkFixed`.`name_en`, `MstRemarkFixed`.`name_zh-CN`, `MstRemarkFixed`.`name_zh-TW`, `MstRemarkFixed`.`name_ko`, `MstRemarkFixed`.`open_flg`, `MstRemarkFixed`.`delete_flg`, `MstRemarkFixed`.`created`, `MstRemarkFixed`.`modified` FROM `inbound_db`.`mst_remark_fixeds` AS `MstRemarkFixed` WHERE `MstRemarkFixed`.`open_flg` = 1 AND `MstRemarkFixed`.`delete_flg` = 0220
2SELECT `MstGoods`.`id`, `MstGoods`.`type`, `MstGoods`.`key`, `MstGoods`.`name`, `MstGoods`.`msg`, `MstGoods`.`amount_once`, `MstGoods`.`amount_fixed`, `MstGoods`.`fixed_period`, `MstGoods`.`fixed_cnt_1st`, `MstGoods`.`fixed_cnt_2nd`, `MstGoods`.`max_pt_1st`, `MstGoods`.`max_pt_2nd`, `MstGoods`.`date_s`, `MstGoods`.`date_e`, `MstGoods`.`open_flg`, `MstGoods`.`delete_flg`, `MstGoods`.`created`, `MstGoods`.`modified` FROM `inbound_db`.`mst_goods` AS `MstGoods` WHERE `MstGoods`.`open_flg` = 1 AND `MstGoods`.`delete_flg` = 0 AND ((`MstGoods`.`date_s` IS NULL) OR (`MstGoods`.`date_s` >= '2017-06-28 10:48:41')) AND ((`MstGoods`.`date_e` IS NULL) OR (`MstGoods`.`date_e` <= '2017-06-28 10:48:41'))440
3SELECT `Shop`.`id`, `Shop`.`preview_key`, `Shop`.`name_kana`, `Shop`.`name_alphabet`, `Shop`.`genre1`, `Shop`.`genre2`, `Shop`.`genre3`, `Shop`.`shop_no`, `Shop`.`color_id`, `Shop`.`map_lat`, `Shop`.`map_lng`, `Shop`.`map_zoom`, `Shop`.`open_start`, `Shop`.`open_end`, `Shop`.`open_flg`, `Shop`.`delete_flg`, `Shop`.`created`, `Shop`.`modified` FROM `inbound_db`.`shops` AS `Shop` WHERE `Shop`.`shop_no` = '4760769261' AND `Shop`.`delete_flg` = 0 AND ((`Shop`.`open_flg` = 1) AND (((((`Shop`.`open_start` IS NULL) OR (`Shop`.`open_start` <= '2017-06-28'))) AND (((`Shop`.`open_end` IS NULL) OR (`Shop`.`open_end` >= '2017-06-28')))))) LIMIT 1110
4SELECT `ShopLanguage`.`id`, `ShopLanguage`.`shop_id`, `ShopLanguage`.`language`, `ShopLanguage`.`name`, `ShopLanguage`.`msg`, `ShopLanguage`.`zip`, `ShopLanguage`.`address`, `ShopLanguage`.`business_hours`, `ShopLanguage`.`holiday`, `ShopLanguage`.`telno`, `ShopLanguage`.`remarks`, `ShopLanguage`.`delete_flg`, `ShopLanguage`.`created`, `ShopLanguage`.`modified` FROM `inbound_db`.`shop_languages` AS `ShopLanguage` WHERE `ShopLanguage`.`delete_flg` = 0 AND `ShopLanguage`.`shop_id` = (6) ORDER BY `ShopLanguage`.`id` ASC550
5SELECT `ShopSmoking`.`id`, `ShopSmoking`.`shop_id`, `ShopSmoking`.`smoking_id`, `ShopSmoking`.`delete_flg`, `ShopSmoking`.`created`, `ShopSmoking`.`modified` FROM `inbound_db`.`shop_smokings` AS `ShopSmoking` WHERE `ShopSmoking`.`delete_flg` = 0 AND `ShopSmoking`.`shop_id` = (6)110
6SELECT `ShopCard`.`id`, `ShopCard`.`shop_id`, `ShopCard`.`card_id`, `ShopCard`.`delete_flg`, `ShopCard`.`created`, `ShopCard`.`modified` FROM `inbound_db`.`shop_cards` AS `ShopCard` WHERE `ShopCard`.`delete_flg` = 0 AND `ShopCard`.`shop_id` = (6)440
7SELECT `ShopRemarkFixed`.`id`, `ShopRemarkFixed`.`shop_id`, `ShopRemarkFixed`.`remark_fixed_id`, `ShopRemarkFixed`.`delete_flg`, `ShopRemarkFixed`.`created`, `ShopRemarkFixed`.`modified` FROM `inbound_db`.`shop_remark_fixeds` AS `ShopRemarkFixed` WHERE `ShopRemarkFixed`.`delete_flg` = 0 AND `ShopRemarkFixed`.`shop_id` = (6)110
8SELECT `Menu`.`id`, `Menu`.`shop_id`, `Menu`.`flow`, `Menu`.`request_time`, `Menu`.`contract_id`, `Menu`.`pt`, `Menu`.`menu_type`, `Menu`.`number`, `Menu`.`sort`, `Menu`.`open_flg`, `Menu`.`delete_flg`, `Menu`.`created`, `Menu`.`modified` FROM `inbound_db`.`menus` AS `Menu` WHERE `Menu`.`open_flg` = 1 AND `Menu`.`delete_flg` = 0 AND `Menu`.`shop_id` = (6) ORDER BY `Menu`.`menu_type` ASC, `Menu`.`sort` ASC, `Menu`.`id` ASC22220
9SELECT `Image`.`id`, `Image`.`target_name`, `Image`.`target_id`, `Image`.`file_name`, `Image`.`file_extension`, `Image`.`sort`, `Image`.`created`, `Image`.`modified` FROM `inbound_db`.`images` AS `Image` WHERE `Image`.`target_name` = 'Shop' AND `Image`.`target_id` = (6) ORDER BY `Image`.`sort` ASC, `Image`.`id` ASC110
10SELECT `ShopRequestLog`.`id`, `ShopRequestLog`.`shop_id`, `ShopRequestLog`.`user_id`, `ShopRequestLog`.`msg`, `ShopRequestLog`.`file`, `ShopRequestLog`.`delete_flg`, `ShopRequestLog`.`created`, `ShopRequestLog`.`modified` FROM `inbound_db`.`shop_request_logs` AS `ShopRequestLog` WHERE `ShopRequestLog`.`delete_flg` = 0 AND `ShopRequestLog`.`shop_id` = (6) ORDER BY `ShopRequestLog`.`id` DESC000
11SELECT `ShopContract`.`id`, `ShopContract`.`shop_id`, `ShopContract`.`status`, `ShopContract`.`type`, `ShopContract`.`plan_name`, `ShopContract`.`language`, `ShopContract`.`date_s`, `ShopContract`.`date_e`, `ShopContract`.`plan_option`, `ShopContract`.`transfer_date`, `ShopContract`.`confirm_flg`, `ShopContract`.`delete_flg`, `ShopContract`.`created`, `ShopContract`.`modified` FROM `inbound_db`.`shop_contracts` AS `ShopContract` WHERE `ShopContract`.`delete_flg` = 0 AND `ShopContract`.`shop_id` = (6) ORDER BY `ShopContract`.`id` DESC110
12SELECT `ShopUser`.`id`, `ShopUser`.`shop_id`, `ShopUser`.`user_id`, `ShopUser`.`sort`, `ShopUser`.`delete_flg`, `ShopUser`.`created`, `ShopUser`.`modified` FROM `inbound_db`.`shop_users` AS `ShopUser` WHERE `ShopUser`.`delete_flg` = 0 AND `ShopUser`.`shop_id` = (6) ORDER BY `ShopUser`.`id` DESC000
13SELECT `Menu`.`id`, `Menu`.`shop_id`, `Menu`.`flow`, `Menu`.`request_time`, `Menu`.`contract_id`, `Menu`.`pt`, `Menu`.`menu_type`, `Menu`.`number`, `Menu`.`sort`, `Menu`.`open_flg`, `Menu`.`delete_flg`, `Menu`.`created`, `Menu`.`modified`, `Shop`.`id`, `Shop`.`preview_key`, `Shop`.`name_kana`, `Shop`.`name_alphabet`, `Shop`.`genre1`, `Shop`.`genre2`, `Shop`.`genre3`, `Shop`.`shop_no`, `Shop`.`color_id`, `Shop`.`map_lat`, `Shop`.`map_lng`, `Shop`.`map_zoom`, `Shop`.`open_start`, `Shop`.`open_end`, `Shop`.`open_flg`, `Shop`.`delete_flg`, `Shop`.`created`, `Shop`.`modified` FROM `inbound_db`.`menus` AS `Menu` LEFT JOIN `inbound_db`.`shops` AS `Shop` ON (`Menu`.`shop_id` = `Shop`.`id` AND `Shop`.`open_flg` = 1 AND `Shop`.`delete_flg` = 0) WHERE `Menu`.`shop_id` = 6 AND `Menu`.`delete_flg` = 0 AND `Menu`.`open_flg` = 1 ORDER BY `Menu`.`menu_type` ASC, `Menu`.`sort` ASC, `Menu`.`number` ASC22220
14SELECT `MenuIcon`.`id`, `MenuIcon`.`menu_id`, `MenuIcon`.`icon_id`, `MenuIcon`.`delete_flg`, `MenuIcon`.`created`, `MenuIcon`.`modified` FROM `inbound_db`.`menu_icons` AS `MenuIcon` WHERE `MenuIcon`.`delete_flg` = 0 AND `MenuIcon`.`menu_id` IN (74, 134, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 136, 135)33330
15SELECT `MenuLanguage`.`id`, `MenuLanguage`.`menu_id`, `MenuLanguage`.`language`, `MenuLanguage`.`name`, `MenuLanguage`.`amount`, `MenuLanguage`.`msg`, `MenuLanguage`.`msg_request`, `MenuLanguage`.`img_caption`, `MenuLanguage`.`delete_flg`, `MenuLanguage`.`created`, `MenuLanguage`.`modified` FROM `inbound_db`.`menu_languages` AS `MenuLanguage` WHERE `MenuLanguage`.`delete_flg` = 0 AND `MenuLanguage`.`menu_id` IN (74, 134, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 136, 135) ORDER BY `MenuLanguage`.`id` ASC1101101
16SELECT `Image`.`id`, `Image`.`target_name`, `Image`.`target_id`, `Image`.`file_name`, `Image`.`file_extension`, `Image`.`sort`, `Image`.`created`, `Image`.`modified` FROM `inbound_db`.`images` AS `Image` WHERE `Image`.`target_name` = 'Menu' AND `Image`.`target_id` IN (74, 134, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 136, 135) ORDER BY `Image`.`sort` ASC, `Image`.`id` ASC770