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

* 请到收银台结账

(default) 19 queries took 2 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-08-24 19:27:09')) AND ((`MstGoods`.`date_e` IS NULL) OR (`MstGoods`.`date_e` <= '2017-08-24 19:27:09'))14140
3SELECT `EntryGenre`.`id`, `EntryGenre`.`parent_id`, `EntryGenre`.`name_ja`, `EntryGenre`.`name_en`, `EntryGenre`.`sort`, `EntryGenre`.`delete_flg`, `EntryGenre`.`created`, `EntryGenre`.`modified` FROM `inbound_db`.`entry_genres` AS `EntryGenre` WHERE `EntryGenre`.`delete_flg` = 0 ORDER BY `EntryGenre`.`parent_id` ASC, `EntryGenre`.`sort` ASC, `EntryGenre`.`id` ASC1431430
4SELECT `EntryGenreSub`.`id`, `EntryGenreSub`.`parent_id`, `EntryGenreSub`.`name_ja`, `EntryGenreSub`.`name_en`, `EntryGenreSub`.`sort`, `EntryGenreSub`.`delete_flg`, `EntryGenreSub`.`created`, `EntryGenreSub`.`modified` FROM `inbound_db`.`entry_genres` AS `EntryGenreSub` WHERE `EntryGenreSub`.`delete_flg` = 0 AND `EntryGenreSub`.`parent_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143) ORDER BY `EntryGenreSub`.`sort` ASC, `EntryGenreSub`.`id` ASC99990
5SELECT `ShopContract`.`id`, `ShopContract`.`shop_id`, `ShopContract`.`status`, `ShopContract`.`type`, `ShopContract`.`plan_name`, `ShopContract`.`language`, `ShopContract`.`qty`, `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`.`status` = 'new' AND `ShopContract`.`delete_flg` = 0 AND `ShopContract`.`created` >= '2017-08-21 00:00:00'000
6SELECT `Shop`.`id`, `Shop`.`preview_key`, `Shop`.`name_kana`, `Shop`.`name_alphabet`, `Shop`.`genre1`, `Shop`.`genre2`, `Shop`.`genre3`, `Shop`.`seats`, `Shop`.`shop_no`, `Shop`.`color_id`, `Shop`.`map_lat`, `Shop`.`map_lng`, `Shop`.`map_zoom`, `Shop`.`remarks_tax`, `Shop`.`remarks_appetizer`, `Shop`.`remarks_bill`, `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-08-24'))) AND (((`Shop`.`open_end` IS NULL) OR (`Shop`.`open_end` >= '2017-08-24')))))) LIMIT 1110
7SELECT `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
8SELECT `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
9SELECT `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
10SELECT `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
11SELECT `Menu`.`id`, `Menu`.`shop_id`, `Menu`.`flow`, `Menu`.`request_time`, `Menu`.`contract_id`, `Menu`.`pt`, `Menu`.`ja_msg_flg`, `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
12SELECT `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
13SELECT `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` DESC001
14SELECT `ShopContract`.`id`, `ShopContract`.`shop_id`, `ShopContract`.`status`, `ShopContract`.`type`, `ShopContract`.`plan_name`, `ShopContract`.`language`, `ShopContract`.`qty`, `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
15SELECT `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
16SELECT `Menu`.`id`, `Menu`.`shop_id`, `Menu`.`flow`, `Menu`.`request_time`, `Menu`.`contract_id`, `Menu`.`pt`, `Menu`.`ja_msg_flg`, `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`.`seats`, `Shop`.`shop_no`, `Shop`.`color_id`, `Shop`.`map_lat`, `Shop`.`map_lng`, `Shop`.`map_zoom`, `Shop`.`remarks_tax`, `Shop`.`remarks_appetizer`, `Shop`.`remarks_bill`, `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
17SELECT `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
18SELECT `MenuLanguage`.`id`, `MenuLanguage`.`menu_id`, `MenuLanguage`.`language`, `MenuLanguage`.`name`, `MenuLanguage`.`name_init`, `MenuLanguage`.`amount`, `MenuLanguage`.`msg`, `MenuLanguage`.`msg_init`, `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
19SELECT `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