Time: 0.16916513442993 secs

Memory Usage: 1,876,968 bytes - 1.79M / 128M PHP 8.4.23

Redis Gets: 72

Redis Sets: 0

Total Queries: 46

select L.*,C.Unique_Id, C.Last_Name, C.First_Name, C.Email, C.Email_2, C.Phone, C.Mobile_Phone, C.Logo_URL as Commish_Logo_URL,PL.Entry_Fee, PL.No_Prize, PL.Total_Teams, PL.Private, PL.Slow_Draft, PL.Draft_Date from Commissioner as C,League as L left outer join Pay_Leagues as PL on (PL.League_Id = L.League_Id) where L.League_Id = C.League_Id and L.League_Id=555420 ==> size: 366
select * from Group_Definition gd, Group_Member gm where gd.Group_Id = gm.Group_Id and gd.League_Id = 555420 and gd.Group_Type=0 order by gd.Sorder ==> size: 147
select * from Baseball_Timeline where start_date <= NOW() and NOW() < end_date and year = 2026 ==> size: 94
select * from Player_Eligibility_Rules where Game_Id = 4801 ==> size: 59
select * from Waiver_Wire_Info where League_Id=555420 ==> size: 53
select * FROM Team where League_Id = 555420 order by Name ==> size: 57
select * from Baseball_Timeline where Year=2026 order by Week asc ==> size: 65
select * from Deadlines where League_Id = 555420 ==> size: 48
select * from Baseball_Game_Schedule where Start_Time > '2026-04-30' and Start_Time < '2026-05-04' and (Competition_Type = 'Regular Season') order by Start_Time asc ==> size: 164
select * from Eligibility_Status where Game_Id=4801 ==> size: 51
select * from League_Stats where League_Id=555420 ==> size: 49
update League_Stats set Status = 1 where League_Id=555420 ==> size: 57
select Game_Id,Start_Time,Last_Update from Baseball_Game_Schedule where Year=2026 and Start_Time > '2026-04-13 00:00:00' and Start_Time < '2026-04-19 23:59:59' and (Competition_Type='Regular Season') and Competition_Status<>'scheduled' and Competition_Status<>'postponed' order by Last_Update desc ==> size: 297
select Game_Id,Start_Time,Last_Update from Baseball_Game_Schedule where Year=2026 and Start_Time > '2026-04-20 00:00:00' and Start_Time < '2026-04-29 23:59:59' and (Competition_Type='Regular Season') and Competition_Status<>'scheduled' and Competition_Status<>'postponed' order by Last_Update desc ==> size: 297
select Game_Id,Start_Time,Last_Update from Baseball_Game_Schedule where Year=2026 and Start_Time > '2026-04-30 00:00:00' and Start_Time < '2026-05-03 23:59:59' and (Competition_Type='Regular Season') and Competition_Status<>'scheduled' and Competition_Status<>'postponed' order by Last_Update desc ==> size: 297
update League_Stats set Status=0,Last_Checked=NOW() where League_Id=555420 and Status=1 ==> size: 87
select * from League_Design where League_Id = 555420 ==> size: 52
select * from Schedule where League_Id = 555420 and Fantasy_Week <= 26 order by fantasy_week, game_id ==> size: 101
select * from Transaction_Log, Player where Transaction_Log.Player_Id = Player.Player_Id and Transaction_Log.League_Id = 555420 order by Transaction_Time desc limit 5 ==> size: 167
select * FROM Trades WHERE League_Id=555420 and Trade_Status in (0,4,7,10,2) and Fantasy_Week >= 5 and Official = 1 order by Trade_Time desc limit 3 ==> size: 149
select * from Players_Traded where Trade_Id = 175870 and Team_Id = 4982046 ==> size: 74
select * from Trade_Drops where Trade_Id = 175870 and Team_Id = 4982046 order by Drop_Order ==> size: 91
select * from Draft_Choices_Traded where Trade_Id = 175870 and Team_Id = 4982046 ==> size: 80
select * from Draft_Board where Draft_Order_Id = 207469 ==> size: 55
select * from Future_Picks FP,Future_Picks_Traded FPT where FP.Pick_Id = FPT.Pick_Id and Trade_Id = 175870 and Team_Id = 4982046 order by draft_year asc, draft_round asc ==> size: 169
select * from Players_Traded where Trade_Id = 175870 and Team_Id = 4982030 ==> size: 74
select * from Trade_Drops where Trade_Id = 175870 and Team_Id = 4982030 order by Drop_Order ==> size: 91
select * from Draft_Choices_Traded where Trade_Id = 175870 and Team_Id = 4982030 ==> size: 80
select * from Draft_Board where Draft_Order_Id = 207494 ==> size: 55
select * from Draft_Board where Draft_Order_Id = 207518 ==> size: 55
select * from Future_Picks FP,Future_Picks_Traded FPT where FP.Pick_Id = FPT.Pick_Id and Trade_Id = 175870 and Team_Id = 4982030 order by draft_year asc, draft_round asc ==> size: 169
select * from Players_Traded where Trade_Id = 175870 and Team_Id = 4982046 ==> size: 74
select * from Players_Traded where Trade_Id = 175870 and Team_Id = 4982030 ==> size: 74
select * from Dynasty_Draft_Order where season = 2027 and league_id = 555420 order by slot asc ==> size: 94
select * from Pay_Team_Renewal where season = 2027 and league_id = 555420 ==> size: 73
select * from Pay_Team_4Sale where season = 2027 and league_id = 555420 ==> size: 71
select * from Baseball_Game_Schedule where Start_Time > '2026-04-30' and Start_Time < '2026-05-04' and (Competition_Type = 'Regular Season') order by Start_Time asc ==> size: 164
select * from Team_Weekly_Scoring_Stats where League_Id = 555420 and Fantasy_Week=6 and Year=2026 ==> size: 98
SELECT * FROM Standings_Rules WHERE League_Id = 555420 ==> size: 54
select * from Team_Cumulative_Scoring_Stats where League_Id = 555420 and Year=2026 ==> size: 83
select Fantasy_Week, count(Fantasy_Week) as Teams from Team_H2H_Scoring where League_Id = 555420 group by Fantasy_Week ==> size: 118
select Name,Owner,Division_Id,Team_H2H_Scoring.Team_Id,sum(Points) as Points,sum(Playoff_Points) as Playoff_Points,sum(Wins) as Wins,sum(Losses) as Losses,sum(Ties) as Ties,sum(Division_Wins) as Division_Wins,sum(Division_Losses) as Division_Losses,sum(Division_Ties) as Division_Ties,sum(Pts_For) as Pts_For,sum(Pts_Against) as Pts_Against from Team,Team_H2H_Scoring where Team.Team_Id = Team_H2H_Scoring.Team_Id and Team_H2H_Scoring.League_Id = 555420 group by Team_H2H_Scoring.Team_Id ==> size: 487
select * from Player_Notes where player_id > 0 and created > date_add(now(), interval -10 day) and headline = 1 and deleted=0 and published=1 order by created desc limit 20 ==> size: 173
select * from Metrics_Players where Week=6 and Player_Pool=0 and Acquired>0 order by Acquired desc limit 10 ==> size: 107
select * from Metrics_Players where Week=6 and Player_Pool=0 and Released>0 order by Released desc limit 10 ==> size: 107
select * from Baseball_Game_Schedule where Start_Time > '2026-08-14' and Start_Time < '2026-08-15' and (Competition_Type = 'Regular Season') order by Start_Time asc ==> size: 164