2020-10-10 23:35:10.9204 [Thread-14] INFO IndexController - Create new session. [Session ID] : mo554qydak0poux53ahq2vby 2020-10-10 23:35:10.9204 [Thread-14] INFO Service - [Response Start] ProtocolCode = [ScLogin], Request = [{"authenticationNumber":292425716464032,"userUid":13,"sgpUserId":"ljw755@daum.net","sgpUserPw":"Ljw@76102474"}] 2020-10-10 23:35:10.9204 [Thread-14] DEBUG DBConnector - SELECT COALESCE((SELECT 1 FROM `eod_game`.`table_player` WHERE (`authentication_number` = 292425716464032)), 0) 2020-10-10 23:35:10.9462 [Thread-14] DEBUG DBConnector - SELECT `user_id`, `authentication_number`, `nickname`, `notice_state`, `guardian_level`, `guardian_experience`, `guardian_stone_enhance_point`, `money_gamecash_by_bonus`, `money_gamecash_by_purchase`, `friendship_point`, `current_bought_premium_package`, `deletable_friend_count`, `last_accessed_datetime`, `last_played_character`, `enable_to_change_nickname`, `representative_character`, `enable_to_change_representative_character_datetime`, `joined_guild_id`, `guild_coin`, `mileage`, `cumulative_mileage`, `is_completed_tutorial`, `enable_to_guild_activity_datetime`, `guild_attendance_datetime`, `related_account_facebook` FROM `eod_game`.`table_player` WHERE (`authentication_number` = 292425716464032) LIMIT 1; 2020-10-10 23:35:10.9667 [Thread-14] DEBUG DBConnector - SELECT `character_id`, `owner_user_id`, `character_class_type`, `notice_state`, `title`, `title_color_key`, `level`, `experience`, `money_gameplay`, `admission`, `admission_recharge_datetime`, `rift_keystone`, `money_ruby`, `stage_effect_tickets`, `equipped_potion_gtc`, `item_inventory_extension_grade`, `skill_point_by_purchase`, `skill_point_reset_count`, `last_played_datetime` FROM `eod_game`.`table_player_character` WHERE (`character_id` = 21) LIMIT 1; 2020-10-10 23:35:10.9667 [Thread-14] INFO Service - scLogin : [Request] url = http://samsunggames.io/api/game/user/auth.do?gameUid=G202009110001&userUid=13&sgpUserId=ljw755@daum.net&sgpUserPw=Ljw@76102474 2020-10-10 23:35:11.1844 [Thread-14] INFO Service - [Response Error] ProtocolCode = [ScLogin], ErrorCode = [8002], Response = [SnowFamily.EvilOfDarkness.Protocol.Game.ScLogin+Response] 2020-10-10 23:35:11.1875 [Thread-14] ERROR ResponseContent - [Response] [ProtocolCode] : ScLogin [ErrorCode] : 8002 [content] : {"code":"401","userData":"/signup/view.do","playerNotice":0,"playerCharacterNotice":0,"nowTime":"0001-01-01T00:00:00"} 2020-10-10 23:35:34.0796 [Thread-10] INFO Service - [Response Start] ProtocolCode = [ScLogin], Request = [{"authenticationNumber":292425716464032,"userUid":13,"sgpUserId":"ljw755@naver.com","sgpUserPw":"Ljw@76102474"}] 2020-10-10 23:35:34.0796 [Thread-10] DEBUG DBConnector - SELECT COALESCE((SELECT 1 FROM `eod_game`.`table_player` WHERE (`authentication_number` = 292425716464032)), 0) 2020-10-10 23:35:34.0796 [Thread-10] INFO Service - scLogin : [Request] url = http://samsunggames.io/api/game/user/auth.do?gameUid=G202009110001&userUid=13&sgpUserId=ljw755@naver.com&sgpUserPw=Ljw@76102474 2020-10-10 23:35:34.1222 [Thread-10] INFO Service - [Response Success] ProtocolCode = [ScLogin], ErrorCode = [0], Response = [{"code":"200","userData":"","playerNotice":0,"playerCharacterNotice":0,"nowTime":"0001-01-01T00:00:00"}] 2020-10-10 23:39:57.3470 [Thread-14] INFO WebApiApplication - [Session End] [UserId] : 13 2020-10-10 23:39:57.3470 [Thread-14] INFO WebApiApplication - [Session End] [DateTime] : 2020-10-10 오후 11:39:57 2020-10-10 23:39:57.3470 [Thread-14] INFO WebApiApplication - Application_End() 2020-10-10 23:39:57.4587 [Thread-14] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `database_id`, `server_number`, `url`, `port`, `recently_access_count` FROM `eod_configuration`.`table_game_server` WHERE (`database_id` = 1) AND (`server_number` = 1) LIMIT 1; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-10 23:39:57.4736 [Thread-14] DEBUG DBConnector - UPDATE `eod_configuration`.`table_game_server` SET `recently_access_count` = 0 WHERE (`database_id` = 1) AND (`server_number` = 1); 2020-10-10 23:39:57.5684 [Thread-14] INFO WebApiApplication - End server successed! 2020-10-11 00:09:59.5508 [Thread-1] INFO WebApiApplication - Application_Start() 2020-10-11 00:10:01.1689 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `alchemy_id`, `alchemy_type`, `possible_conversion_type`, `item_division`, `equip_type`, `item_set_type`, `inventory_type`, `nox_item`, `grade`, `item_upgrade_level`, `alchemy_gold_cost`, `alchemy_material_group_id`, `need_guardian_stone_count`, `guardian_stone_lv`, `result_item_group_id` FROM `eod_configuration`.`data_alchemy_data`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.1911 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `alchemy_material_group_id`, `material_item_type_code`, `material_item_count` FROM `eod_configuration`.`data_alchemy_material`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.2092 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `gacha_item_group_code`, `item_code`, `item_count`, `required_class`, `equip_type`, `group_rate` FROM `eod_configuration`.`data_alchemy_result_item_group`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.2392 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `event_group_code`, `start_date`, `end_date` FROM `eod_configuration`.`data_attendance_event_group`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.2573 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `event_group_code`, `data_target`, `rounds`, `reward_item_code1`, `reward_item_count1`, `reward_item_code2`, `reward_item_count2` FROM `eod_configuration`.`data_attendance_event`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.2752 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `stage_type`, `stage_number_in_act`, `atk_ratio`, `def_ratio`, `stage_exp`, `guardian_exp`, `stage_gold`, `auto_connection_skill_gold`, `bgm_index`, `limit_time_second`, `recommend_level`, `reward_general_code`, `icon_image_code`, `reward_count_min`, `reward_count_max`, `party_reward_group_code`, `entry_cost_type`, `entry_cost_amount`, `entry_limit_type`, `entry_limit_count`, `monster_level`, `add_reward_group_code` FROM `eod_configuration`.`data_guardian_raid`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.2944 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_general_code`, `reward_type`, `rank_grade`, `require_point_min`, `require_point_max`, `min_count`, `max_count`, `min_rate`, `max_rate`, `season_item_reward_gtc`, `season_item_reward_count`, `season_item_reward2gtc`, `season_item_reward2_count`, `season_item_reward3gtc`, `season_item_reward3_count`, `season_item_reward4gtc`, `season_item_reward4_count`, `season_item_reward5gtc`, `season_item_reward5_count`, `icon_image_code` FROM `eod_configuration`.`data_guild_war_ranking`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.3153 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_type`, `reward_general_code`, `stage_general_code`, `rank_grade`, `required_class`, `general_type_code`, `item_min_count`, `item_max_count`, `drop_rate` FROM `eod_configuration`.`data_guild_war_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.3433 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `nox_item`, `equip_type`, `grade`, `value_flag`, `value_recalculate`, `value_pencentage`, `nox_grade_enchant_rate`, `enchant_material_gtc`, `enchant_material_counts` FROM `eod_configuration`.`data_item_nox_enchant`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.3901 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `g_stone_type_code`, `g_stone_upgrade_level` FROM `eod_configuration`.`data_needs_g_stone_group`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.4081 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `count`, `product1_type_code`, `product1_amount`, `product2_type_code`, `product2_amount`, `product3_type_code`, `product3_amount`, `product4_type_code`, `product4_amount` FROM `eod_configuration`.`data_gacha_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.4201 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `price_type`, `price`, `exchage_type_code`, `exchage_amount` FROM `eod_configuration`.`data_shop_mileage_exchnage`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.4360 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `price_type`, `price`, `exchage_type_code`, `exchage_amount` FROM `eod_configuration`.`data_shop_guild`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.4360 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `skill_code`, `projectile_division_index`, `skill_level`, `need_skill_point_type`, `need_skill_point` FROM `eod_configuration`.`data_skill_levelup`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.4900 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `open_condition`, `open_level`, `skill_level_limit`, `link_skill_upgrade_item`, `upgrad_item_code`, `upgrad_item_count` FROM `eod_configuration`.`data_succession_skill`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.5085 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `stage_type`, `act_number`, `stage_number_in_act`, `day_of_week`, `recommend_atk`, `atk_ratio`, `def_ratio`, `stage_exp`, `guardian_exp`, `stage_gold`, `auto_connection_skill_gold`, `limit_time_second`, `recommend_level`, `reward_general_code`, `reward_count_min`, `reward_count_max`, `entry_cost_type`, `entry_cost_amount`, `entry_limit_type`, `entry_limit_count`, `boss_monster_code`, `monster_level`, `auto_skill_cost`, `image_code`, `add_reward_group_code` FROM `eod_configuration`.`data_weekly_stage`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.5377 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_general_code`, `stage_general_code`, `required_class`, `act`, `stage_no`, `general_type_code`, `item_min_count`, `item_max_count`, `drop_rate`, `equip_type`, `grade` FROM `eod_configuration`.`data_weekly_stage_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.5642 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `quest_type`, `group_index`, `complete_index`, `quest_need_level`, `previous_tutorial_step_code`, `reward_item_info`, `reward_item_count`, `skip_state` FROM `eod_configuration`.`data_tutorial_data`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.5898 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `stage_type`, `stage_number_in_act`, `atk_ratio`, `def_ratio`, `stage_exp`, `guardian_exp`, `boss_spawn_hp_amount`, `stage_gold`, `auto_connection_skill_gold`, `bgm_index`, `limit_time_second`, `recommend_level`, `reward_general_code`, `reward_count_min`, `reward_count_max`, `first_reward_general_code`, `reward_general_code1`, `reward_count_min1`, `reward_count_max1`, `party_reward_group_code`, `entry_cost_type`, `entry_cost_amount`, `entry_limit_type`, `entry_limit_count`, `boss_monster_code`, `monster_level`, `auto_skill_cost`, `add_reward_group_code` FROM `eod_configuration`.`data_transcendent_stage`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.6253 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_general_code`, `stage_general_code`, `required_class`, `act`, `stage_no`, `general_type_code`, `item_min_count`, `item_max_count`, `drop_rate`, `equip_type`, `grade` FROM `eod_configuration`.`data_transcendent_stage_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.6971 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_general_code`, `stage_general_code`, `required_class`, `act`, `stage_no`, `general_type_code`, `item_min_count`, `item_max_count`, `drop_rate`, `equip_type`, `grade` FROM `eod_configuration`.`data_transcendent_guardian_stone_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.7212 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `stage_type`, `limit_time_second` FROM `eod_configuration`.`data_town`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.7423 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `required_class_type`, `need_char_level`, `reward_item_code`, `reward_item_count` FROM `eod_configuration`.`data_story_cutscene`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.7648 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `stage_type`, `act_number`, `stage_number_in_act`, `recommend_atk`, `atk_ratio`, `def_ratio`, `stage_exp`, `guardian_exp`, `stage_gold`, `auto_connection_skill_gold`, `bonus_type`, `bonus_value`, `limit_time_second`, `recommend_level_min`, `recommend_level_max`, `previous_stage_code`, `next_stage_code`, `reward_general_code`, `reward_count_min`, `reward_count_max`, `entry_cost_type`, `entry_cost_amount`, `entry_limit_type`, `entry_limit_count`, `boss_monster_code`, `monster_level`, `auto_skill_cost`, `add_reward_group_code` FROM `eod_configuration`.`data_stage`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.7959 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_general_code`, `stage_general_code`, `required_class`, `act`, `stage_no`, `general_type_code`, `item_min_count`, `item_max_count`, `drop_rate`, `equip_type`, `grade` FROM `eod_configuration`.`data_stage_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.8485 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_general_code`, `stage_general_code`, `required_class`, `act`, `stage_no`, `general_type_code`, `item_min_count`, `item_max_count`, `drop_rate`, `equip_type`, `grade` FROM `eod_configuration`.`data_elite_stage_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.9277 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_general_code`, `stage_general_code`, `required_class`, `act`, `stage_no`, `general_type_code`, `item_min_count`, `item_max_count`, `drop_rate`, `equip_type`, `grade` FROM `eod_configuration`.`data_rift_stage_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:01.9914 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_general_code`, `stage_general_code`, `required_class`, `act`, `stage_no`, `general_type_code`, `item_min_count`, `item_max_count`, `drop_rate`, `equip_type`, `grade` FROM `eod_configuration`.`data_transcendent_stage_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:02.0134 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_general_code`, `stage_general_code`, `required_class`, `act`, `stage_no`, `general_type_code`, `item_min_count`, `item_max_count`, `drop_rate`, `equip_type`, `grade` FROM `eod_configuration`.`data_weekly_stage_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:02.0134 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `reward_general_code`, `stage_general_code`, `required_class`, `act`, `stage_no`, `general_type_code`, `item_min_count`, `item_max_count`, `drop_rate`, `equip_type`, `grade` FROM `eod_configuration`.`data_guardian_raid_reward`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:02.0563 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `skill_code`, `skill_type`, `required_class`, `skill_level_limit`, `debuff_state_skill`, `add_skill_combo` FROM `eod_configuration`.`data_skill_type`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:02.0862 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `product_id`, `market_type`, `next_step_code`, `price_type`, `price`, `limited_num`, `mileage_type_code`, `mileage_amount`, `product1_type_code`, `product1_amount`, `product2_type_code`, `product2_amount`, `product3_type_code`, `product3_amount`, `product4_type_code`, `product4_amount`, `product5_type_code`, `product5_amount`, `product6_type_code`, `product6_amount` FROM `eod_configuration`.`data_shop_premium_package`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:02.1098 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `product_id`, `market_type`, `price_type`, `price`, `limited_num`, `mileage_type_code`, `mileage_amount`, `product1_type_code`, `product1_amount`, `product2_type_code`, `product2_amount`, `product3_type_code`, `product3_amount`, `product4_type_code`, `product4_amount`, `product5_type_code`, `product5_amount`, `product6_type_code`, `product6_amount` FROM `eod_configuration`.`data_shop_package`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:02.1354 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `product_id`, `market_type`, `character_lv`, `guardian_lv`, `price_type`, `price`, `limited_num`, `mileage_type_code`, `mileage_amount`, `product1_type_code`, `product1_amount`, `product2_type_code`, `product2_amount`, `product3_type_code`, `product3_amount`, `product4_type_code`, `product4_amount`, `product5_type_code`, `product5_amount`, `product6_type_code`, `product6_amount` FROM `eod_configuration`.`data_shop_levelup_package`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:02.1544 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `price_type`, `price`, `exchage_type_code`, `exchage_amount`, `mileage_type_code`, `mileage_amount` FROM `eod_configuration`.`data_shop_gold_exchange`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 2020-10-11 00:10:02.1741 [Thread-1] DEBUG DBConnector - SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SELECT `general_type_code`, `product_id`, `market_type`, `price_type`, `price`, `charge_type_code`, `charge_amount`, `add_amount`, `charge_type_code2`, `charge_amount2`, `add_amount2`, `mileage_type_code`, `mileage_amount`, `bonus1_type_code`, `bonus1_amount`, `bonus2_type_code`, `bonus2_amount`, `bonus3_type_code`, `bonus3_amount`, `bonus4_type_code`, `bonus4_amount`, `bonus5_type_code`, `bonus5_amount` FROM `eod_configuration`.`data_shop_gem_charge`; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;