CRITICAL - 2023-12-19 20:05:57 --> Access denied for user '****'@'121.133.173.232' (using password: YES) #0 D:\svn\balvenie\projectt-server\system\Database\BaseConnection.php(377): CodeIgniter\Database\MySQLi\Connection->connect(false) #1 D:\svn\balvenie\projectt-server\system\Database\BaseConnection.php(643): CodeIgniter\Database\BaseConnection->initialize() #2 D:\svn\balvenie\projectt-server\app\Controllers\BaseController.php(86): CodeIgniter\Database\BaseConnection->query('SELECT * FROM t...') #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(887): App\Controllers\BaseController->initController(Object(CodeIgniter\HTTP\IncomingRequest), Object(CodeIgniter\HTTP\Response), Object(CodeIgniter\Log\Logger)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(395): CodeIgniter\CodeIgniter->createController() #5 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #6 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #7 {main} INFO - 2023-12-19 20:08:01 --> ::::::::::::::: login keep_login_access_token : 7efcfc69-bf53-4aa5-8a51-cf5a0ebe7b9f id : dev2 CRITICAL - 2023-12-19 20:08:06 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 20:08:20 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 20:08:33 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:35:25 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:45:41 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:45:50 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:45:53 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-19 22:45:53 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start query :SELECT bet.bet_id, bet.fixture_id, bet.bet_base_line, bet.bet_line, bet.bet_name, bet.providers_id, IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) as bet_status, IF('ON' = bet.passivity_flag AND bet.bet_price_passivity is NOT NULL ,bet.bet_price_passivity,bet.bet_price) as bet_price, markets.id as markets_id, markets.name, markets.limit_bet_price, markets.max_bet_price, markets.display_order, markets.menu, fix.fixture_sport_id,sports.name as fixture_sport_name, fix.fixture_location_id, location.name as fixture_location_name, fix.fixture_league_id, league.display_name as fixture_league_name, IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) as fixture_start_date, IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) as display_status, p1.team_name as p1_team_name, p1.display_name as p1_display_name, p2.team_name as p2_team_name, p2.display_name as p2_display_name, league.display_name as league_display_name, league.image_path as league_image_path, location.image_path as location_image_path, location.name as location_display_name, location.name_en as location_name_en, div_policy.amount, div_policy.amount - (select sum_bet_money from fixtures_bet_sum as bet_sum where bet_sum.member_idx = '293' and bet_sum.fixture_id = fix.fixture_id and bet_sum.bet_type = 1) as leagues_m_bet_money FROM lsports_bet as bet LEFT JOIN lsports_fixtures as fix ON bet.fixture_id = fix.fixture_id LEFT JOIN lsports_participant as p1 ON fix.fixture_participants_1_id = p1.fp_id LEFT JOIN lsports_participant as p2 ON fix.fixture_participants_2_id = p2.fp_id LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id LEFT JOIN dividend_policy as div_policy ON league.dividend_rank = div_policy.rank LEFT JOIN lsports_locations as location ON fix.fixture_location_id = location.id LEFT JOIN lsports_markets as markets ON bet.markets_id = markets.id LEFT JOIN lsports_sports as sports ON sports.id = fix.fixture_sport_id WHERE IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) IN(1) AND bet.admin_bet_status = 'ON' AND bet.bet_type = 1 AND IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) IN(1) AND fix.fixture_id IN (11894585,11894576,11928943,11941879,11963635,11928900,11894573,11932896,11894572,11894582,11964702,11964701,11894574,11894575,11894571,11926071,11953858,11964818,11966766,11966767,11966912,11941878,11941876,11913751,11953878,11916100,11966911,11928907,11953884,11928935,11956530,11916777,11928898,11928933,11960524,11958266,11957689,11928857,11917353,11932895,11928878,11928954,11928902,11928918,11928937,11966781,11966811,11928854,11916126,11916101) AND fix.bet_type = 1 AND sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND markets.id IN (1,2,3,28,52,226,342) AND markets.bet_group = 1 AND markets.is_delete = 0 AND fix.fixture_sport_id = markets.sport_id AND div_policy.type = 20 AND div_policy.level = '1' ORDER BY fixture_start_date ,markets.display_order asc , league.display_name,IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) CRITICAL - 2023-12-19 22:45:53 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 CRITICAL - 2023-12-19 22:46:14 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString :3 CRITICAL - 2023-12-19 22:46:14 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString query :SELECT bet.bet_id, bet.fixture_id, bet.bet_base_line, bet.bet_line, bet.bet_name, bet.providers_id, IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) as bet_status, IF('ON' = bet.passivity_flag AND bet.bet_price_passivity is NOT NULL ,bet.bet_price_passivity,bet.bet_price) as bet_price, bet.last_update, bet.update_dt, markets.id as markets_id, markets.name, markets.limit_bet_price, markets.max_bet_price, fix.fixture_sport_id,sports.name as fixture_sport_name, fix.fixture_location_id, location.name as fixture_location_name, fix.fixture_league_id, league.display_name as fixture_league_name, IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) as fixture_start_date, IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) as display_status, p1.team_name as p1_team_name, p1.display_name as p1_display_name, p2.team_name as p2_team_name, p2.display_name as p2_display_name, league.display_name as league_display_name, league.image_path as league_image_path, location.image_path as location_image_path, location.name as location_display_name, location.name_en as location_name_en, div_policy.amount, div_policy.amount - (select sum_bet_money from fixtures_bet_sum as bet_sum where bet_sum.member_idx = 293 and bet_sum.fixture_id = fix.fixture_id and bet_sum.bet_type = 1) as leagues_m_bet_money FROM lsports_bet as bet LEFT JOIN lsports_fixtures as fix ON bet.fixture_id = fix.fixture_id LEFT JOIN lsports_participant as p1 ON fix.fixture_participants_1_id = p1.fp_id LEFT JOIN lsports_participant as p2 ON fix.fixture_participants_2_id = p2.fp_id LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id LEFT JOIN dividend_policy as div_policy ON league.dividend_rank = div_policy.rank LEFT JOIN lsports_locations as location ON fix.fixture_location_id = location.id LEFT JOIN lsports_markets as markets ON bet.markets_id = markets.id LEFT JOIN lsports_sports as sports ON sports.id = fix.fixture_sport_id WHERE ( IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 1 OR IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 AND NOW() BETWEEN DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -10 MINUTE) AND DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -1 MINUTE)) AND IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) = 1 AND bet.admin_bet_status = 'ON' AND bet.bet_type = 1 AND fix.fixture_id IN (11894576,11894585,11928943,11941879,11963635,11928900,11894573,11932896,11894572,11894582,11964701,11964702,11894574,11894575,11894571,11926071,11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11916777,11928898,11956530,11928933,11928935,11960524,11957689,11958266,11928857,11917353,11932895,11928954,11928878,11928902,11928918,11928937,11966781,11966811,11928854,11916101,11916126) AND fix.bet_type = 1 AND sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND markets.bet_group = 1 AND markets.is_delete = 0 AND fix.fixture_sport_id = markets.sport_id AND div_policy.type = 1 AND div_policy.level = 1 GROUP BY bet.bet_id, bet.fixture_id,IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) ORDER BY fixture_start_date asc ,fix.fixture_sport_id,league.display_name,bet.bet_name,bet.bet_base_line *1 CRITICAL - 2023-12-19 22:46:14 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 4 CRITICAL - 2023-12-19 22:46:17 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:55:04 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString :2 CRITICAL - 2023-12-19 22:55:04 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString query :SELECT bet.bet_id, bet.fixture_id, bet.bet_base_line, bet.bet_line, bet.bet_name, bet.providers_id, IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) as bet_status, IF('ON' = bet.passivity_flag AND bet.bet_price_passivity is NOT NULL ,bet.bet_price_passivity,bet.bet_price) as bet_price, bet.last_update, bet.update_dt, markets.id as markets_id, markets.name, markets.limit_bet_price, markets.max_bet_price, fix.fixture_sport_id,sports.name as fixture_sport_name, fix.fixture_location_id, location.name as fixture_location_name, fix.fixture_league_id, league.display_name as fixture_league_name, IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) as fixture_start_date, IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) as display_status, p1.team_name as p1_team_name, p1.display_name as p1_display_name, p2.team_name as p2_team_name, p2.display_name as p2_display_name, league.display_name as league_display_name, league.image_path as league_image_path, location.image_path as location_image_path, location.name as location_display_name, location.name_en as location_name_en, div_policy.amount, div_policy.amount - (select sum_bet_money from fixtures_bet_sum as bet_sum where bet_sum.member_idx = 293 and bet_sum.fixture_id = fix.fixture_id and bet_sum.bet_type = 1) as leagues_m_bet_money FROM lsports_bet as bet LEFT JOIN lsports_fixtures as fix ON bet.fixture_id = fix.fixture_id LEFT JOIN lsports_participant as p1 ON fix.fixture_participants_1_id = p1.fp_id LEFT JOIN lsports_participant as p2 ON fix.fixture_participants_2_id = p2.fp_id LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id LEFT JOIN dividend_policy as div_policy ON league.dividend_rank = div_policy.rank LEFT JOIN lsports_locations as location ON fix.fixture_location_id = location.id LEFT JOIN lsports_markets as markets ON bet.markets_id = markets.id LEFT JOIN lsports_sports as sports ON sports.id = fix.fixture_sport_id WHERE ( IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 1 OR IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 AND NOW() BETWEEN DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -10 MINUTE) AND DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -1 MINUTE)) AND IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) = 1 AND bet.admin_bet_status = 'ON' AND bet.bet_type = 1 AND fix.fixture_id IN (11894576,11894585,11928943,11941879,11963635,11928900,11894573,11932896,11894572,11894582,11964702,11964701,11894574,11894571,11894575,11926071,11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11916777,11928898,11956530,11928933,11928935,11960524,11957689,11958266,11928857,11917353,11932895,11928878,11928902,11928918,11928954,11928937,11966781,11966811,11928854,11916126,11916101) AND fix.bet_type = 1 AND sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND markets.bet_group = 1 AND markets.is_delete = 0 AND fix.fixture_sport_id = markets.sport_id AND div_policy.type = 1 AND div_policy.level = 1 GROUP BY bet.bet_id, bet.fixture_id,IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) ORDER BY fixture_start_date asc ,fix.fixture_sport_id,league.display_name,bet.bet_name,bet.bet_base_line *1 CRITICAL - 2023-12-19 22:55:04 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 CRITICAL - 2023-12-19 22:55:08 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:55:27 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:55:41 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:57:30 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:58:13 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString :2 CRITICAL - 2023-12-19 22:58:13 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString query :SELECT bet.bet_id, bet.fixture_id, bet.bet_base_line, bet.bet_line, bet.bet_name, bet.providers_id, IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) as bet_status, IF('ON' = bet.passivity_flag AND bet.bet_price_passivity is NOT NULL ,bet.bet_price_passivity,bet.bet_price) as bet_price, bet.last_update, bet.update_dt, markets.id as markets_id, markets.name, markets.limit_bet_price, markets.max_bet_price, fix.fixture_sport_id,sports.name as fixture_sport_name, fix.fixture_location_id, location.name as fixture_location_name, fix.fixture_league_id, league.display_name as fixture_league_name, IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) as fixture_start_date, IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) as display_status, p1.team_name as p1_team_name, p1.display_name as p1_display_name, p2.team_name as p2_team_name, p2.display_name as p2_display_name, league.display_name as league_display_name, league.image_path as league_image_path, location.image_path as location_image_path, location.name as location_display_name, location.name_en as location_name_en, div_policy.amount, div_policy.amount - (select sum_bet_money from fixtures_bet_sum as bet_sum where bet_sum.member_idx = 293 and bet_sum.fixture_id = fix.fixture_id and bet_sum.bet_type = 1) as leagues_m_bet_money FROM lsports_bet as bet LEFT JOIN lsports_fixtures as fix ON bet.fixture_id = fix.fixture_id LEFT JOIN lsports_participant as p1 ON fix.fixture_participants_1_id = p1.fp_id LEFT JOIN lsports_participant as p2 ON fix.fixture_participants_2_id = p2.fp_id LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id LEFT JOIN dividend_policy as div_policy ON league.dividend_rank = div_policy.rank LEFT JOIN lsports_locations as location ON fix.fixture_location_id = location.id LEFT JOIN lsports_markets as markets ON bet.markets_id = markets.id LEFT JOIN lsports_sports as sports ON sports.id = fix.fixture_sport_id WHERE ( IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 1 OR IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 AND NOW() BETWEEN DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -10 MINUTE) AND DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -1 MINUTE)) AND IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) = 1 AND bet.admin_bet_status = 'ON' AND bet.bet_type = 1 AND fix.fixture_id IN (11894576,11894585,11928943,11941879,11963635,11928900,11894573,11932896,11894572,11894582,11964701,11964702,11894574,11894571,11894575,11926071,11953858,11964818,11966912,11966766,11966767,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11928898,11956530,11928933,11928935,11916777,11960524,11957689,11958266,11928857,11917353,11932895,11928878,11928902,11928918,11928954,11928937,11966781,11966811,11928854,11916101,11916126) AND fix.bet_type = 1 AND sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND markets.bet_group = 1 AND markets.is_delete = 0 AND fix.fixture_sport_id = markets.sport_id AND div_policy.type = 1 AND div_policy.level = 1 GROUP BY bet.bet_id, bet.fixture_id,IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) ORDER BY fixture_start_date asc ,fix.fixture_sport_id,league.display_name,bet.bet_name,bet.bet_base_line *1 CRITICAL - 2023-12-19 22:58:17 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:58:23 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:58:29 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString :2 CRITICAL - 2023-12-19 22:58:29 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString query :SELECT bet.bet_id, bet.fixture_id, bet.bet_base_line, bet.bet_line, bet.bet_name, bet.providers_id, IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) as bet_status, IF('ON' = bet.passivity_flag AND bet.bet_price_passivity is NOT NULL ,bet.bet_price_passivity,bet.bet_price) as bet_price, bet.last_update, bet.update_dt, markets.id as markets_id, markets.name, markets.limit_bet_price, markets.max_bet_price, fix.fixture_sport_id,sports.name as fixture_sport_name, fix.fixture_location_id, location.name as fixture_location_name, fix.fixture_league_id, league.display_name as fixture_league_name, IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) as fixture_start_date, IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) as display_status, p1.team_name as p1_team_name, p1.display_name as p1_display_name, p2.team_name as p2_team_name, p2.display_name as p2_display_name, league.display_name as league_display_name, league.image_path as league_image_path, location.image_path as location_image_path, location.name as location_display_name, location.name_en as location_name_en, div_policy.amount, div_policy.amount - (select sum_bet_money from fixtures_bet_sum as bet_sum where bet_sum.member_idx = 293 and bet_sum.fixture_id = fix.fixture_id and bet_sum.bet_type = 1) as leagues_m_bet_money FROM lsports_bet as bet LEFT JOIN lsports_fixtures as fix ON bet.fixture_id = fix.fixture_id LEFT JOIN lsports_participant as p1 ON fix.fixture_participants_1_id = p1.fp_id LEFT JOIN lsports_participant as p2 ON fix.fixture_participants_2_id = p2.fp_id LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id LEFT JOIN dividend_policy as div_policy ON league.dividend_rank = div_policy.rank LEFT JOIN lsports_locations as location ON fix.fixture_location_id = location.id LEFT JOIN lsports_markets as markets ON bet.markets_id = markets.id LEFT JOIN lsports_sports as sports ON sports.id = fix.fixture_sport_id WHERE ( IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 1 OR IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 AND NOW() BETWEEN DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -10 MINUTE) AND DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -1 MINUTE)) AND IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) = 1 AND bet.admin_bet_status = 'ON' AND bet.bet_type = 1 AND fix.fixture_id IN (11894576,11894585,11928943,11941879,11963635,11928900,11894573,11932896,11894572,11894582,11964702,11964701,11894574,11894571,11894575,11926071,11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11916777,11928898,11956530,11928933,11928935,11960524,11957689,11958266,11928857,11917353,11932895,11928878,11928902,11928918,11928954,11928937,11966781,11966811,11928854,11916101,11916126) AND fix.bet_type = 1 AND sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND markets.bet_group = 1 AND markets.is_delete = 0 AND fix.fixture_sport_id = markets.sport_id AND div_policy.type = 1 AND div_policy.level = 1 GROUP BY bet.bet_id, bet.fixture_id,IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) ORDER BY fixture_start_date asc ,fix.fixture_sport_id,league.display_name,bet.bet_name,bet.bet_base_line *1 CRITICAL - 2023-12-19 22:58:29 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 CRITICAL - 2023-12-19 22:58:32 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:58:36 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:58:48 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} CRITICAL - 2023-12-19 22:59:19 --> 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다. #0 D:\svn\balvenie\projectt-server\app\Util\accessLogRedis.php(31): Redis->connect('210.175.73.182', 6380) #1 D:\svn\balvenie\projectt-server\app\Controllers\AccessLogController.php(72): App\Util\accessLogRedis->connect() #2 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(914): App\Controllers\AccessLogController->index() #3 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(400): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\AccessLogController)) #4 D:\svn\balvenie\projectt-server\system\CodeIgniter.php(308): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) #5 D:\svn\balvenie\projectt-server\public\index.php(47): CodeIgniter\CodeIgniter->run() #6 {main} INFO - 2023-12-19 23:00:44 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-19 23:00:44 --> current_page 1 CRITICAL - 2023-12-19 23:07:03 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString :2 CRITICAL - 2023-12-19 23:07:03 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString query :SELECT bet.bet_id, bet.fixture_id, bet.bet_base_line, bet.bet_line, bet.bet_name, bet.providers_id, IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) as bet_status, IF('ON' = bet.passivity_flag AND bet.bet_price_passivity is NOT NULL ,bet.bet_price_passivity,bet.bet_price) as bet_price, bet.last_update, bet.update_dt, markets.id as markets_id, markets.name, markets.limit_bet_price, markets.max_bet_price, fix.fixture_sport_id,sports.name as fixture_sport_name, fix.fixture_location_id, location.name as fixture_location_name, fix.fixture_league_id, league.display_name as fixture_league_name, IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) as fixture_start_date, IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) as display_status, p1.team_name as p1_team_name, p1.display_name as p1_display_name, p2.team_name as p2_team_name, p2.display_name as p2_display_name, league.display_name as league_display_name, league.image_path as league_image_path, location.image_path as location_image_path, location.name as location_display_name, location.name_en as location_name_en, div_policy.amount, div_policy.amount - (select sum_bet_money from fixtures_bet_sum as bet_sum where bet_sum.member_idx = 293 and bet_sum.fixture_id = fix.fixture_id and bet_sum.bet_type = 1) as leagues_m_bet_money FROM lsports_bet as bet LEFT JOIN lsports_fixtures as fix ON bet.fixture_id = fix.fixture_id LEFT JOIN lsports_participant as p1 ON fix.fixture_participants_1_id = p1.fp_id LEFT JOIN lsports_participant as p2 ON fix.fixture_participants_2_id = p2.fp_id LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id LEFT JOIN dividend_policy as div_policy ON league.dividend_rank = div_policy.rank LEFT JOIN lsports_locations as location ON fix.fixture_location_id = location.id LEFT JOIN lsports_markets as markets ON bet.markets_id = markets.id LEFT JOIN lsports_sports as sports ON sports.id = fix.fixture_sport_id WHERE ( IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 1 OR IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 AND NOW() BETWEEN DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -10 MINUTE) AND DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -1 MINUTE)) AND IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) = 1 AND bet.admin_bet_status = 'ON' AND bet.bet_type = 1 AND fix.fixture_id IN (11928900,11894573,11932896,11894572,11894582,11964702,11964701,11894574,11894571,11894575,11926071,11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11916777,11956530,11928898,11928933,11928935,11960524,11957689,11958266,11928857,11917353,11932895,11928878,11928902,11928918,11928954,11928937,11966781,11966811,11928854,11916101,11916126,11928858,11960832,11966910,11954400,11954401) AND fix.bet_type = 1 AND sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND markets.bet_group = 1 AND markets.is_delete = 0 AND fix.fixture_sport_id = markets.sport_id AND div_policy.type = 1 AND div_policy.level = 1 GROUP BY bet.bet_id, bet.fixture_id,IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) ORDER BY fixture_start_date asc ,fix.fixture_sport_id,league.display_name,bet.bet_name,bet.bet_base_line *1 INFO - 2023-12-19 23:07:04 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-19 23:07:04 --> current_page 1 INFO - 2023-12-19 23:07:23 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-19 23:07:23 --> current_page 1 INFO - 2023-12-19 23:07:43 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-19 23:07:43 --> current_page 1 INFO - 2023-12-19 23:13:25 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-19 23:13:25 --> current_page 1 INFO - 2023-12-19 23:15:21 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-19 23:15:21 --> current_page 1 CRITICAL - 2023-12-19 23:15:37 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString :2 CRITICAL - 2023-12-19 23:15:37 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString query :SELECT bet.bet_id, bet.fixture_id, bet.bet_base_line, bet.bet_line, bet.bet_name, bet.providers_id, IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) as bet_status, IF('ON' = bet.passivity_flag AND bet.bet_price_passivity is NOT NULL ,bet.bet_price_passivity,bet.bet_price) as bet_price, bet.last_update, bet.update_dt, markets.id as markets_id, markets.name, markets.limit_bet_price, markets.max_bet_price, fix.fixture_sport_id,sports.name as fixture_sport_name, fix.fixture_location_id, location.name as fixture_location_name, fix.fixture_league_id, league.display_name as fixture_league_name, IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) as fixture_start_date, IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) as display_status, p1.team_name as p1_team_name, p1.display_name as p1_display_name, p2.team_name as p2_team_name, p2.display_name as p2_display_name, league.display_name as league_display_name, league.image_path as league_image_path, location.image_path as location_image_path, location.name as location_display_name, location.name_en as location_name_en, div_policy.amount, div_policy.amount - (select sum_bet_money from fixtures_bet_sum as bet_sum where bet_sum.member_idx = 293 and bet_sum.fixture_id = fix.fixture_id and bet_sum.bet_type = 1) as leagues_m_bet_money FROM lsports_bet as bet LEFT JOIN lsports_fixtures as fix ON bet.fixture_id = fix.fixture_id LEFT JOIN lsports_participant as p1 ON fix.fixture_participants_1_id = p1.fp_id LEFT JOIN lsports_participant as p2 ON fix.fixture_participants_2_id = p2.fp_id LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id LEFT JOIN dividend_policy as div_policy ON league.dividend_rank = div_policy.rank LEFT JOIN lsports_locations as location ON fix.fixture_location_id = location.id LEFT JOIN lsports_markets as markets ON bet.markets_id = markets.id LEFT JOIN lsports_sports as sports ON sports.id = fix.fixture_sport_id WHERE ( IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 1 OR IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 AND NOW() BETWEEN DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -10 MINUTE) AND DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -1 MINUTE)) AND IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) = 1 AND bet.admin_bet_status = 'ON' AND bet.bet_type = 1 AND fix.fixture_id IN (11928900,11894573,11932896,11894572,11894582,11964701,11964702,11894574,11894571,11894575,11926071,11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11928933,11928935,11916777,11956530,11928898,11960524,11957689,11958266,11928857,11917353,11932895,11928954,11928878,11928902,11928918,11928937,11966781,11966811,11928854,11916101,11916126,11928858,11960832,11966910,11954400,11954401) AND fix.bet_type = 1 AND sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND markets.bet_group = 1 AND markets.is_delete = 0 AND fix.fixture_sport_id = markets.sport_id AND div_policy.type = 1 AND div_policy.level = 1 GROUP BY bet.bet_id, bet.fixture_id,IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) ORDER BY fixture_start_date asc ,fix.fixture_sport_id,league.display_name,bet.bet_name,bet.bet_base_line *1 INFO - 2023-12-19 23:15:38 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-19 23:15:38 --> current_page 1 INFO - 2023-12-19 23:16:28 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-19 23:16:28 --> current_page 1 CRITICAL - 2023-12-19 23:18:21 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString :2 CRITICAL - 2023-12-19 23:18:21 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString query :SELECT bet.bet_id, bet.fixture_id, bet.bet_base_line, bet.bet_line, bet.bet_name, bet.providers_id, IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) as bet_status, IF('ON' = bet.passivity_flag AND bet.bet_price_passivity is NOT NULL ,bet.bet_price_passivity,bet.bet_price) as bet_price, bet.last_update, bet.update_dt, markets.id as markets_id, markets.name, markets.limit_bet_price, markets.max_bet_price, fix.fixture_sport_id,sports.name as fixture_sport_name, fix.fixture_location_id, location.name as fixture_location_name, fix.fixture_league_id, league.display_name as fixture_league_name, IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) as fixture_start_date, IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) as display_status, p1.team_name as p1_team_name, p1.display_name as p1_display_name, p2.team_name as p2_team_name, p2.display_name as p2_display_name, league.display_name as league_display_name, league.image_path as league_image_path, location.image_path as location_image_path, location.name as location_display_name, location.name_en as location_name_en, div_policy.amount, div_policy.amount - (select sum_bet_money from fixtures_bet_sum as bet_sum where bet_sum.member_idx = 293 and bet_sum.fixture_id = fix.fixture_id and bet_sum.bet_type = 1) as leagues_m_bet_money FROM lsports_bet as bet LEFT JOIN lsports_fixtures as fix ON bet.fixture_id = fix.fixture_id LEFT JOIN lsports_participant as p1 ON fix.fixture_participants_1_id = p1.fp_id LEFT JOIN lsports_participant as p2 ON fix.fixture_participants_2_id = p2.fp_id LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.id LEFT JOIN dividend_policy as div_policy ON league.dividend_rank = div_policy.rank LEFT JOIN lsports_locations as location ON fix.fixture_location_id = location.id LEFT JOIN lsports_markets as markets ON bet.markets_id = markets.id LEFT JOIN lsports_sports as sports ON sports.id = fix.fixture_sport_id WHERE ( IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 1 OR IF('ON' = fix.passivity_flag AND fix.display_status_passivity is NOT NULL ,fix.display_status_passivity,fix.display_status) = 2 AND NOW() BETWEEN DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -10 MINUTE) AND DATE_ADD(IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) , INTERVAL -1 MINUTE)) AND IF('ON' = bet.passivity_flag AND bet.bet_status_passivity is NOT NULL ,bet.bet_status_passivity,bet.bet_status) = 1 AND bet.admin_bet_status = 'ON' AND bet.bet_type = 1 AND fix.fixture_id IN (11928900,11894573,11932896,11894572,11894582,11964701,11964702,11894574,11894571,11894575,11926071,11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11916777,11956530,11928898,11928933,11928935,11960524,11957689,11958266,11928857,11917353,11932895,11928878,11928902,11928918,11928954,11928937,11966781,11966811,11928854,11916126,11916101,11928858,11960832,11966910,11954400,11954401) AND fix.bet_type = 1 AND sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND markets.bet_group = 1 AND markets.is_delete = 0 AND fix.fixture_sport_id = markets.sport_id AND div_policy.type = 1 AND div_policy.level = 1 GROUP BY bet.bet_id, bet.fixture_id,IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) ORDER BY fixture_start_date asc ,fix.fixture_sport_id,league.display_name,bet.bet_name,bet.bet_base_line *1 CRITICAL - 2023-12-19 23:18:21 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 INFO - 2023-12-19 23:18:22 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-19 23:18:22 --> current_page 1 INFO - 2023-12-19 23:21:41 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-19 23:21:41 --> current_page 1