Time: 0.16941905021667 secs

Memory Usage: 948,456 bytes - 0.90M / 128M PHP 8.4.23

Redis Gets: 172

Redis Sets: 0

Total Queries: 41

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=504356 ==> size: 366
select * from Group_Definition gd, Group_Member gm where gd.Group_Id = gm.Group_Id and gd.League_Id = 504356 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 League_Id = 504356 ==> size: 63
select * from Waiver_Wire_Info where League_Id=504356 ==> size: 53
select * FROM Team where League_Id = 504356 order by Name ==> size: 57
select * from Baseball_Timeline where Year=2026 order by Week asc ==> size: 65
select * from Deadlines where League_Id = 504356 ==> 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 Roto_Rules where League_Id = 504356 order by Sorder asc ==> size: 69
select * from Eligibility_Status where League_Id=504356 ==> size: 55
update Eligibility_Status set Status = 1 where League_Id=504356 ==> size: 63
select * from Player_Eligibility_Rules where League_Id = 504356 ==> size: 63
select * from Position_Activity as PA where Position_Id in (202,203,204,205,206,207,208,209,210,216) and Year=2026 and Games_Played>=5 and PA.Player_Id not in (select Player_Id from Eligible_Players where League_Id=504356 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 293
select * from Position_Activity as PA where Position_Id = 213 and Year=2026 and Games_Played>=1 and PA.Player_Id not in (select Player_Id from Eligible_Players where League_Id=504356 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 254
select * from Position_Activity as PA where Position_Id = 214 and Year=2026 and Games_Played>=5 and PA.Player_Id not in (select Player_Id from Eligible_Players where League_Id=504356 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 254
select * from Baseball_Player_View as BPV where BPV.Deleted = 0 and BPV.Make_Eligible = 1 and BPV.Primary_Position in (202,203,204,205,206,207,208,209,210,216) and BPV.Player_Id not in (select distinct Baseball_Player_View.Player_Id from Baseball_Player_View left outer join Position_Activity on (Baseball_Player_View.Player_Id = Position_Activity.Player_Id) where Baseball_Player_View.Deleted=0 and Baseball_Player_View.Make_Eligible=1 and Position_Activity.Position_Id in (202,203,204,205,206,207,208,209,210,216) and Position_Activity.Games_Played >=20 and Position_Activity.Year=2025) and BPV.Player_Id not in (select Player_Id from Eligible_Players where League_Id=504356 and Position_Id=BPV.Primary_Position and Player_Id=BPV.Player_Id) ==> size: 742
select * from Baseball_Player_View as BPV where BPV.Deleted = 0 and BPV.Make_Eligible = 1 and BPV.Primary_Position = 213 and BPV.Player_Id not in (select distinct Baseball_Player_View.Player_Id from Baseball_Player_View left outer join Position_Activity on (Baseball_Player_View.Player_Id = Position_Activity.Player_Id) where Baseball_Player_View.Deleted=0 and Baseball_Player_View.Make_Eligible=1 and Position_Activity.Position_Id = 213 and Position_Activity.Games_Played >=1 and Position_Activity.Year=2025) and BPV.Player_Id not in (select Player_Id from Eligible_Players where League_Id=504356 and Position_Id in (213,214,212) and Player_Id=BPV.Player_Id) ==> size: 659
select * from Baseball_Player_View as BPV where BPV.Deleted = 0 and BPV.Make_Eligible = 1 and BPV.Primary_Position = 214 and BPV.Player_Id not in (select distinct Baseball_Player_View.Player_Id from Baseball_Player_View left outer join Position_Activity on (Baseball_Player_View.Player_Id = Position_Activity.Player_Id) where Baseball_Player_View.Deleted=0 and Baseball_Player_View.Make_Eligible=1 and Position_Activity.Position_Id = 214 and Position_Activity.Games_Played >=20 and Position_Activity.Year=2025) and BPV.Player_Id not in (select Player_Id from Eligible_Players where League_Id=504356 and Position_Id in (213,214,212) and Player_Id=BPV.Player_Id) ==> size: 660
update Eligibility_Status set Status = 0, Last_Update=NOW() where League_Id=504356 ==> size: 82
select * from League_Stats where League_Id=504356 ==> size: 49
select * from League_Design where League_Id = 504356 ==> size: 52
select * from Waiver_Wire_Info where League_Id=504356 ==> size: 53
select * from Waiver_Wire_Schedule where League_Id = 504356 and Fantasy_Week = 7 and completed_time is null order by Waiver_Id asc ==> size: 130
select * from Transaction_Log, Player where Transaction_Log.Player_Id = Player.Player_Id and Transaction_Log.League_Id = 504356 order by Transaction_Time desc limit 5 ==> size: 167
select * FROM Trades WHERE League_Id=504356 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 = 183871 and Team_Id = 4661610 ==> size: 74
select * from Trade_Drops where Trade_Id = 183871 and Team_Id = 4661610 order by Drop_Order ==> size: 91
select * from Draft_Choices_Traded where Trade_Id = 183871 and Team_Id = 4661610 ==> size: 80
select * from Future_Picks FP,Future_Picks_Traded FPT where FP.Pick_Id = FPT.Pick_Id and Trade_Id = 183871 and Team_Id = 4661610 order by draft_year asc, draft_round asc ==> size: 169
select * from Players_Traded where Trade_Id = 183871 and Team_Id = 4661616 ==> size: 74
select * from Trade_Drops where Trade_Id = 183871 and Team_Id = 4661616 order by Drop_Order ==> size: 91
select * from Draft_Choices_Traded where Trade_Id = 183871 and Team_Id = 4661616 ==> size: 80
select * from Future_Picks FP,Future_Picks_Traded FPT where FP.Pick_Id = FPT.Pick_Id and Trade_Id = 183871 and Team_Id = 4661616 order by draft_year asc, draft_round asc ==> size: 169
select * from Players_Traded where Trade_Id = 183871 and Team_Id = 4661610 ==> size: 74
select * from Players_Traded where Trade_Id = 183871 and Team_Id = 4661616 ==> size: 74
select * from Team_Cumulative_Scoring_Stats where League_Id = 504356 and Year=2026 ==> size: 83
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=2 and Acquired>0 order by Acquired desc limit 10 ==> size: 107
select * from Metrics_Players where Week=6 and Player_Pool=2 and Released>0 order by Released desc limit 10 ==> size: 107
select * from Baseball_Game_Schedule where Start_Time > '2026-08-15' and Start_Time < '2026-08-16' and (Competition_Type = 'Regular Season') order by Start_Time asc ==> size: 164