Time: 0.02531099319458 secs

Memory Usage: 938,864 bytes - 0.90M / 128M PHP 8.4.23

Redis Gets: 187

Redis Sets: 0

Total Queries: 31

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=554570 ==> size: 366
select * from Group_Definition gd, Group_Member gm where gd.Group_Id = gm.Group_Id and gd.League_Id = 554570 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 = 4600 ==> size: 59
select * FROM Team where League_Id = 554570 order by Name ==> size: 57
select * from Baseball_Timeline where Year=2026 order by Week asc ==> size: 65
select * from Deadlines where League_Id = 554570 ==> 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 = 554570 order by Sorder asc ==> size: 69
select * from Eligibility_Status where Game_Id=4600 ==> size: 51
update Eligibility_Status set Status = 1 where Game_Id=4600 ==> size: 59
select * from Player_Eligibility_Rules where Game_Id = 4600 ==> size: 59
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>=10 and PA.Player_Id not in (select Player_Id from Eligible_Players where Game_Id=4600 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 290
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 Game_Id=4600 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 250
select * from Position_Activity as PA where Position_Id = 214 and Year=2026 and Games_Played>=1 and PA.Player_Id not in (select Player_Id from Eligible_Players where Game_Id=4600 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 250
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 >=10 and Position_Activity.Year=2025) and BPV.Player_Id not in (select Player_Id from Eligible_Players where Game_Id=4600 and Position_Id=BPV.Primary_Position and Player_Id=BPV.Player_Id) ==> size: 738
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 Game_Id=4600 and Position_Id in (213,214,212) and Player_Id=BPV.Player_Id) ==> size: 655
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 >=10 and Position_Activity.Year=2025) and BPV.Player_Id not in (select Player_Id from Eligible_Players where Game_Id=4600 and Position_Id in (213,214,212) and Player_Id=BPV.Player_Id) ==> size: 656
update Eligibility_Status set Status = 0, Last_Update=NOW() where Game_Id=4600 ==> size: 78
select * from League_Stats where League_Id=554570 ==> size: 49
update League_Stats set Status = 1 where League_Id=554570 ==> 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=554570 and Status=1 ==> size: 87
select * from League_Design where League_Id = 554570 ==> size: 52
select * from Team_Cumulative_Scoring_Stats where League_Id = 554570 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=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-17' and Start_Time < '2026-08-18' and (Competition_Type = 'Regular Season') order by Start_Time asc ==> size: 164