ログイン

ログインできない場合はお問い合わせフォームよりご連絡ください。

(default) 6 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` >= '2018-04-22 07:34:52')) AND ((`MstGoods`.`date_e` IS NULL) OR (`MstGoods`.`date_e` <= '2018-04-22 07:34:52'))14141
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'110
6SELECT `ShopContractTransfer`.`id`, `ShopContractTransfer`.`shop_contract_id`, `ShopContractTransfer`.`year`, `ShopContractTransfer`.`month`, `ShopContractTransfer`.`output_date`, `ShopContractTransfer`.`delete_flg`, `ShopContractTransfer`.`created`, `ShopContractTransfer`.`modified` FROM `inbound_db`.`shop_contract_transfers` AS `ShopContractTransfer` WHERE `ShopContractTransfer`.`delete_flg` = 0 AND `ShopContractTransfer`.`shop_contract_id` = (28) ORDER BY `ShopContractTransfer`.`year` ASC, `ShopContractTransfer`.`month` ASC, `ShopContractTransfer`.`id` ASC440