2020-08-16 17:16:21.1547 [Thread-9] DEBUG DBConnector - SELECT `user_id`, `email`, `password`, `name`, `company`, `department`, `phone_number`, `access_right`, `update_datetime`, `creation_datetime` FROM `eod_tool`.`table_account`; 2020-08-16 17:16:41.5922 [Thread-13] DEBUG IndexController - 테스트 2020-08-16 17:17:07.9985 [Thread-8] DEBUG DBConnector - SELECT `user_id`, `name`, `company`, `department`, `phone_number`, `access_right` FROM `eod_tool`.`table_account` WHERE (`email` = 'josoowoon@joongwongames.com') AND (`password` = 'c25vd21hbjEyMw==') LIMIT 1; 2020-08-16 17:17:15.1547 [Thread-8] DEBUG DBConnector - SELECT `no`, `type`, `message`, `area`, `condition`, `direct`, `speed`, `repeat`, `keep`, `term`, `send_datetime`, `disposer` FROM `eod_tool`.`table_notice`; 2020-08-16 17:17:31.5922 [Thread-9] DEBUG DBConnector - SELECT `no`, `coupon_group`, `count`, `reward1`, `count1`, `reward2`, `count2`, `reward3`, `count3`, `reward4`, `count4`, `reward5`, `count5`, `creation_datetime`, `expiration_date`, `reason_text`, `disposer` FROM `eod_tool`.`table_coupon`; 2020-08-16 17:17:31.6234 [Thread-9] DEBUG DBConnector - SELECT `no`, `keyword`, `reward1`, `count1`, `reward2`, `count2`, `reward3`, `count3`, `reward4`, `count4`, `reward5`, `count5`, `creation_datetime`, `expiration_date`, `reason_text`, `disposer` FROM `eod_tool`.`table_keyword_coupon`; 2020-08-16 17:17:31.6548 [Thread-9] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `campaign_key`, `valid_nickname_creation_date`, `reward1`, `count1`, `reward2`, `count2`, `reward3`, `count3`, `reward4`, `count4`, `reward5`, `count5`, `is_delete`, `deleted_administrator`, `deleted_datetime`, `disposer`, `reason_text`, `creation_datetime` FROM `eod_global`.`table_igaworks_coupon`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-08-16 17:19:43.2016 [Thread-9] DEBUG DBConnector - TRUNCATE TABLE `eod_community`.`table_coupon_temp`; 2020-08-16 17:19:43.3890 [Thread-9] DEBUG DBConnector - INSERT INTO `eod_community`.`table_coupon_temp` (`serial_number`) VALUES ('D001-E2WF-OCZG-HZWQ'), ('D001-NB9O-14P9-T9M7'), ('D001-Y2MV-136K-WLDW'), ('D001-NYCH-FJP8-TLVR'), ('D001-8YGJ-PFB1-YIFE'), ('D001-2XOW-BGI3-507X'), ('D001-DG56-QQO3-552D'), ('D001-RSH8-D4WK-TF88'), ('D001-9BR1-SL71-QB1U'), ('D001-M0OP-MM1T-73X5'); 2020-08-16 17:19:43.3890 [Thread-9] DEBUG DBConnector - SELECT COUNT(1) FROM `eod_community`.`table_coupon` AS t1 INNER JOIN `eod_community`.`table_coupon_temp` AS t2 ON t1.`serial_number` = t2.`serial_number`; 2020-08-16 17:19:43.4203 [Thread-9] DEBUG DBConnector - INSERT INTO `eod_community`.`table_coupon` (`serial_number`, `reward1`, `count1`, `reward2`, `count2`, `reward3`, `count3`, `reward4`, `count4`, `reward5`, `count5`, `expiration_date`) VALUES ('D001-E2WF-OCZG-HZWQ', 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-31 00:00:00'), ('D001-NB9O-14P9-T9M7', 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-31 00:00:00'), ('D001-Y2MV-136K-WLDW', 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-31 00:00:00'), ('D001-NYCH-FJP8-TLVR', 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-31 00:00:00'), ('D001-8YGJ-PFB1-YIFE', 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-31 00:00:00'), ('D001-2XOW-BGI3-507X', 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-31 00:00:00'), ('D001-DG56-QQO3-552D', 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-31 00:00:00'), ('D001-RSH8-D4WK-TF88', 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-31 00:00:00'), ('D001-9BR1-SL71-QB1U', 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-31 00:00:00'), ('D001-M0OP-MM1T-73X5', 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-31 00:00:00'); 2020-08-16 17:19:43.4359 [Thread-9] DEBUG DBConnector - INSERT INTO `eod_tool`.`table_coupon` (`coupon_group`, `count`, `reward1`, `count1`, `reward2`, `count2`, `reward3`, `count3`, `reward4`, `count4`, `reward5`, `count5`, `creation_datetime`, `expiration_date`, `reason_text`, `disposer`) VALUES ('D001', 10, 160004003, 5, 160001001, 1000, 0, 0, 0, 0, 0, 0, '2020-08-16 17:19:43', '2020-08-31 00:00:00', '테스트 쿠폰', '조수운'); 2020-08-16 17:19:43.4359 [Thread-9] DEBUG DBConnector - SELECT `no`, `coupon_group`, `count`, `reward1`, `count1`, `reward2`, `count2`, `reward3`, `count3`, `reward4`, `count4`, `reward5`, `count5`, `creation_datetime`, `expiration_date`, `reason_text`, `disposer` FROM `eod_tool`.`table_coupon`; 2020-08-16 17:20:33.7484 [Thread-9] DEBUG DBConnector - SELECT `no`, `type`, `addition`, `start_date`, `end_date`, `reason_text`, `disposer` FROM `eod_tool`.`table_in_game_event`; 2020-08-16 17:20:33.7641 [Thread-9] DEBUG DBConnector - SELECT `no`, `type`, `value`, `include_day_of_week`, `start_time`, `end_time`, `reason_text`, `disposer` FROM `eod_tool`.`table_in_game_always_event`; 2020-08-16 17:20:33.7953 [Thread-9] DEBUG DBConnector - SELECT `no`, `reward1`, `count1`, `reward2`, `count2`, `reward3`, `count3`, `reward4`, `count4`, `reward5`, `count5`, `start_date`, `end_date`, `reason_text`, `disposer` FROM `eod_tool`.`table_connect_event`; 2020-08-16 17:20:57.9047 [Thread-8] DEBUG DBConnector - SELECT `no`, `nickname`, `reward_code`, `reward_count`, `inserted_datetime`, `reason_text`, `disposer` FROM `eod_tool`.`table_bulk_insert`; 2020-08-16 17:23:03.2641 [Thread-13] DEBUG DBConnector - SELECT `no`, `coupon_group`, `count`, `reward1`, `count1`, `reward2`, `count2`, `reward3`, `count3`, `reward4`, `count4`, `reward5`, `count5`, `creation_datetime`, `expiration_date`, `reason_text`, `disposer` FROM `eod_tool`.`table_coupon`; 2020-08-16 17:23:03.2641 [Thread-13] DEBUG DBConnector - SELECT COUNT(1) FROM `eod_community`.`table_coupon` WHERE serial_number LIKE 'D001%';; 2020-08-16 17:23:03.2641 [Thread-13] DEBUG DBConnector - SELECT `no`, `keyword`, `reward1`, `count1`, `reward2`, `count2`, `reward3`, `count3`, `reward4`, `count4`, `reward5`, `count5`, `creation_datetime`, `expiration_date`, `reason_text`, `disposer` FROM `eod_tool`.`table_keyword_coupon`; 2020-08-16 17:23:03.2797 [Thread-13] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `campaign_key`, `valid_nickname_creation_date`, `reward1`, `count1`, `reward2`, `count2`, `reward3`, `count3`, `reward4`, `count4`, `reward5`, `count5`, `is_delete`, `deleted_administrator`, `deleted_datetime`, `disposer`, `reason_text`, `creation_datetime` FROM `eod_global`.`table_igaworks_coupon`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;