INFO - 2023-12-20 00:31:06 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 00:31:06 --> current_page 1 INFO - 2023-12-20 00:32:02 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 00:32:02 --> current_page 1 INFO - 2023-12-20 00:32:20 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 00:32:20 --> current_page 1 CRITICAL - 2023-12-20 00:32:45 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-20 00:32:45 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11894572,11894582,11964702,11964701,11894574,11894571,11894575,11926071,11953858,11964818,11966766,11966767,11966912,11941878,11941876,11913751,11953878,11916100,11966911,11928907,11953884,11956530,11928898,11928935,11928933,11916777,11960524,11957689,11958266,11928857,11917353,11932895,11928878,11928902,11928918,11928954,11928937,11966781,11966811,11928854,11916101,11916126,11928858,11960832,11966910,11954400,11954405,11954403,11954408,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.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) INFO - 2023-12-20 00:32:45 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 00:32:45 --> current_page 1 INFO - 2023-12-20 00:47:30 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 00:47:30 --> current_page 1 INFO - 2023-12-20 00:57:53 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 00:57:53 --> current_page 1 INFO - 2023-12-20 00:58:17 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 00:58:17 --> current_page 1 INFO - 2023-12-20 01:00:15 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:00:15 --> current_page 1 INFO - 2023-12-20 01:01:00 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:01:00 --> current_page 1 INFO - 2023-12-20 01:01:58 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:01:58 --> current_page 1 INFO - 2023-12-20 01:03:03 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:03:03 --> current_page 1 CRITICAL - 2023-12-20 01:03:06 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-20 01:03:06 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11894574,11894571,11894575,11926071,11953858,11964818,11966767,11966912,11966766,11941878,11941876,11913751,11953878,11916100,11966911,11928907,11953884,11928898,11956530,11928935,11928933,11916777,11960524,11957689,11958266,11928857,11917353,11932895,11928954,11928878,11928902,11928918,11928937,11966781,11966811,11928854,11916101,11916126,11928858,11960832,11966910,11954400,11954405,11954403,11954408,11954401,11954406,11954404,11954409,11954402) 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-20 01:03:06 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 CRITICAL - 2023-12-20 01:04:06 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :3 CRITICAL - 2023-12-20 01:04:06 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11894574,11894575,11894571,11926071,11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11928933,11916777,11956530,11928898,11928935,11960524,11957689,11958266,11928857,11917353,11932895,11928878,11928902,11928918,11928954,11928937,11966781,11966811,11928854,11916126,11916101,11928858,11960832,11966910,11954403,11954408,11954401,11954406,11954404,11954409,11954402,11954407,11954400) 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-20 01:04:06 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 INFO - 2023-12-20 01:04:07 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:04:07 --> current_page 1 CRITICAL - 2023-12-20 01:04:12 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-20 01:04:12 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11926071,11953858,11941878,11941876,11913751,11953878,11916100,11928907,11953884,11956530,11928898,11928935,11928933,11916777,11960524,11957689,11958266,11917353,11932895,11928954,11928878,11928902,11928918,11916101,11916126,11960832,11954407,11954400,11954405,11954403,11954408,11954401,11954406,11954404,11954409,11954402,11928911,11928923,11928930,11928864,11928926,11928924,11928936,11806721,11937499,11942632,11933153,11806723,11928895,11801989) 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-20 01:04:18 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :3 CRITICAL - 2023-12-20 01:04:18 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11894574,11894575,11894571,11926071,11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11928933,11916777,11956530,11928898,11928935,11960524,11957689,11958266,11928857,11917353,11932895,11928902,11928918,11928954,11928878,11928937,11966781,11966811,11928854,11916126,11916101,11928858,11960832,11966910,11954401,11954406,11954404,11954409,11954402,11954407,11954400,11954405,11954403) 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-20 01:04:18 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 INFO - 2023-12-20 01:05:49 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:05:49 --> current_page 1 INFO - 2023-12-20 01:07:02 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:07:02 --> current_page 1 CRITICAL - 2023-12-20 01:07:11 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-20 01:07:11 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11926071,11953858,11941876,11941878,11913751,11953878,11916100,11928907,11953884,11928933,11916777,11928898,11956530,11928935,11960524,11957689,11958266,11917353,11932895,11928902,11928918,11928954,11928878,11916126,11916101,11960832,11954401,11954406,11954404,11954409,11954402,11954407,11954400,11954405,11954403,11954408,11928911,11928923,11928930,11928924,11928864,11928926,11928936,11933153,11806723,11806721,11937499,11942632,11928895,11801989) 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-20 01:07:16 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-20 01:07:16 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11894574,11894575,11894571,11926071,11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11928933,11916777,11956530,11928898,11928935,11960524,11957689,11958266,11928857,11917353,11932895,11928878,11928902,11928918,11928954,11928937,11966781,11966811,11928854,11916126,11916101,11928858,11960832,11966910,11954403,11954408,11954401,11954406,11954404,11954409,11954402,11954407,11954400) 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-20 01:07:33 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-20 01:07:33 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11894574,11894575,11894571,11926071,11953858,11964818,11966767,11966912,11966766,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11928898,11956530,11928935,11928933,11916777,11960524,11957689,11958266,11928857,11917353,11932895,11928878,11928902,11928918,11928954,11928937,11966781,11966811,11928854,11916126,11916101,11928858,11960832,11966910,11954405,11954403,11954408,11954401,11954406,11954404,11954409,11954402,11954407) 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) INFO - 2023-12-20 01:08: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-20 01:08:22 --> current_page 1 INFO - 2023-12-20 01:08: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-20 01:08:43 --> current_page 1 INFO - 2023-12-20 01:08:58 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:08:58 --> current_page 1 CRITICAL - 2023-12-20 01:09:51 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-20 01:09:51 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11894571,11894575,11926071,11953858,11964818,11966766,11966767,11966912,11941878,11941876,11913751,11953878,11916100,11966911,11928907,11953884,11956530,11928898,11928935,11928933,11916777,11960524,11957689,11958266,11928857,11917353,11932895,11928954,11928878,11928902,11928918,11928937,11966781,11966811,11928854,11916101,11916126,11928858,11960832,11966910,11954400,11954405,11954403,11954408,11954401,11954406,11954404,11954409,11954402,11954407) 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-20 01:10:04 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgClassicAllCountQueryString_start : 2 CRITICAL - 2023-12-20 01:10:04 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgClassicAllCountQueryString_start query : SELECT fix.fixture_id, fix.fixture_sport_id, fix.fixture_location_id, fix.fixture_league_id, IF(league.display_name is NOT NULL,league.display_name,league.name) as fixture_league_name, league.image_path as fixture_league_image_path, IF(locations.display_name is NOT NULL,locations.display_name,locations.name) as fixture_location_name, locations.image_path as fixture_location_image_path FROM lsports_fixtures as fix LEFT JOIN lsports_leagues as league ON fix.fixture_league_id = league.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_sports as sports ON fix.fixture_sport_id = sports.id LEFT JOIN lsports_bet as bet ON fix.fixture_id = bet.fixture_id LEFT JOIN lsports_markets as markets ON bet.markets_id = markets.id LEFT JOIN lsports_locations as locations ON fix.fixture_location_id = locations.id WHERE fix.bet_type = 1 AND IF('ON' = fix.passivity_flag AND fix.fixture_start_date_passivity is NOT NULL ,fix.fixture_start_date_passivity,fix.fixture_start_date) BETWEEN ? AND ? 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.admin_bet_status = 'ON' AND bet.bet_type = 1 AND 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 sports.is_use = 1 and sports.bet_type = 1 AND league.is_use = 1 and league.bet_type = 1 AND markets.id IN (1,52,226) AND markets.bet_group = 1 AND markets.is_delete = 0 AND markets.sport_id = fix.fixture_sport_id GROUP BY fix.fixture_id ORDER BY fixture_start_date 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-20 01:10:06 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-20 01:10:06 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11926071,11953858,11941876,11941878,11913751,11953878,11916100,11928907,11953884,11928933,11916777,11956530,11928898,11928935,11960524,11957689,11958266,11917353,11932895,11928878,11928902,11928918,11928954,11916126,11916101,11960832,11954403,11954408,11954401,11954406,11954404,11954409,11954402,11954407,11954400,11954405,11928911,11928930,11928923,11928924,11928864,11928926,11928936,11942632,11933153,11806723,11806721,11937499,11928895,11801989) 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-20 01:10:06 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 4 CRITICAL - 2023-12-20 01:10:13 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-20 01:10:13 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11894575,11894571,11926071,11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11928933,11916777,11928898,11956530,11928935,11960524,11957689,11958266,11928857,11917353,11932895,11928878,11928902,11928918,11928954,11928937,11966811,11966781,11928854,11916126,11916101,11928858,11960832,11966910,11954403,11954408,11954401,11954406,11954404,11954409,11954402,11954407,11954400,11954405) 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) INFO - 2023-12-20 01:12:34 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:12:34 --> current_page 1 INFO - 2023-12-20 01:13: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-20 01:13:21 --> current_page 1 INFO - 2023-12-20 01:14:01 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:14:01 --> current_page 1 INFO - 2023-12-20 01:28:16 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:28:16 --> current_page 1 INFO - 2023-12-20 01:28:53 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:28:53 --> current_page 1 INFO - 2023-12-20 01:29:35 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:29:35 --> current_page 1 INFO - 2023-12-20 01:31: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-20 01:31:25 --> current_page 1 INFO - 2023-12-20 01:36:08 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:36:08 --> current_page 1 INFO - 2023-12-20 01:46:34 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:46:34 --> current_page 1 INFO - 2023-12-20 01:47:20 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:47:20 --> current_page 1 CRITICAL - 2023-12-20 01:48:30 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgMainClassicQueryString_start :2 CRITICAL - 2023-12-20 01:48:30 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11953858,11941876,11941878,11913751,11953878,11916100,11928907,11953884,11928933,11956530,11928898,11928935,11916777,11960524,11957689,11958266,11917353,11932895,11928902,11928918,11928954,11928878,11916101,11916126,11960832,11954401,11954406,11954404,11954409,11954402,11954407,11954400,11954405,11954403,11954408,11928911,11928930,11928923,11928924,11928864,11928926,11928936,11942632,11806721,11933153,11937499,11806723,11928895,11801989,11806722) 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) INFO - 2023-12-20 01:50:48 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:50:48 --> current_page 1 INFO - 2023-12-20 01:52:05 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:52:05 --> current_page 1 CRITICAL - 2023-12-20 01:53:32 --> !!!!!!!!!!!!!!!!!! ***************** sports t_getAvgSportsQueryString :3 CRITICAL - 2023-12-20 01:53:32 --> !!!!!!!!!!!!!!!!!! ***************** 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 (11953858,11964818,11966766,11966767,11966912,11941876,11941878,11913751,11953878,11916100,11966911,11928907,11953884,11916777,11956530,11928898,11928933,11928935,11960524,11957689,11958266,11928857,11917353,11932895,11928954,11928878,11928902,11928918,11928937,11966781,11966811,11928854,11916101,11916126,11928858,11960832,11966910,11954400,11954401,11954402,11954403,11954404,11954405,11954406,11954407,11954408,11954409,11928911,11928923,11928930) 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-20 01:53:32 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 4 INFO - 2023-12-20 01:53:33 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:53:33 --> current_page 1 INFO - 2023-12-20 01:54:08 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:54:08 --> current_page 1 INFO - 2023-12-20 01:54: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-20 01:54:22 --> current_page 1 CRITICAL - 2023-12-20 01:54:28 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 INFO - 2023-12-20 01:54:29 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:54:29 --> current_page 1 INFO - 2023-12-20 01:54: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-20 01:54:41 --> current_page 1 INFO - 2023-12-20 01:58:01 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 01:58:01 --> current_page 1 INFO - 2023-12-20 01:59: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-20 01:59:23 --> current_page 1 INFO - 2023-12-20 02:00:27 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:00:27 --> current_page 1 INFO - 2023-12-20 02:01:00 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:01:00 --> current_page 1 INFO - 2023-12-20 02:01:33 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:01:33 --> current_page 1 INFO - 2023-12-20 02:03:24 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:03:24 --> current_page 1 INFO - 2023-12-20 02:05:09 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:05:09 --> current_page 1 INFO - 2023-12-20 02:06:59 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:06:59 --> current_page 1 INFO - 2023-12-20 02:08:48 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:08:48 --> current_page 1 INFO - 2023-12-20 02:09:06 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:09:06 --> current_page 1 INFO - 2023-12-20 02:09:24 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:09:24 --> current_page 1 INFO - 2023-12-20 02:11:51 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:11:51 --> current_page 1 INFO - 2023-12-20 02:13:36 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:13:36 --> current_page 1 INFO - 2023-12-20 02:14:33 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:14:33 --> current_page 1 INFO - 2023-12-20 02:14:51 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:14:51 --> current_page 1 INFO - 2023-12-20 02:15:27 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:15:27 --> current_page 1 INFO - 2023-12-20 02:15:52 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:15:52 --> current_page 1 CRITICAL - 2023-12-20 02:17:17 --> !!!!!!!!!!!!!!!!!! ***************** sports Time : 3 INFO - 2023-12-20 02:17:18 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:17:18 --> current_page 1 INFO - 2023-12-20 02:17:27 --> current_page sql :select * from tb_both_bet_user_list where member_idx = '293' order by create_dt desc limit 1 INFO - 2023-12-20 02:17:27 --> current_page 1 INFO - 2023-12-20 02:17: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-20 02:17:38 --> current_page 1