Time: 0.1615138053894 secs

Memory Usage: 957,136 bytes - 0.91M / 128M PHP 8.4.23

Redis Gets: 154

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=503843 ==> size: 366
select * from Group_Definition gd, Group_Member gm where gd.Group_Id = gm.Group_Id and gd.League_Id = 503843 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 Fantasy_Periods where League_Id=503843 order by Period ==> size: 68
select * from Player_Eligibility_Rules where League_Id = 503843 ==> size: 63
select * from Waiver_Wire_Info where League_Id=503843 ==> size: 53
select * FROM Team where League_Id = 503843 order by Name ==> size: 57
select * from Baseball_Timeline where Year=2026 order by Week asc ==> size: 65
select * from Deadlines where League_Id = 503843 ==> 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 League_Id=503843 ==> size: 55
update Eligibility_Status set Status = 1 where League_Id=503843 ==> size: 63
select * from Player_Eligibility_Rules where League_Id = 503843 ==> 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=503843 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 293
delete from Eligible_Players where League_Id=503843 and Position_Id=203 and Player_Id=9103 and Reason!=1 ==> size: 104
delete from Eligible_Players where League_Id=503843 and Position_Id=206 and Player_Id=10094 and Reason!=1 ==> size: 105
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=503843 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=503843 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 254
delete from Eligible_Players where League_Id=503843 and Position_Id=214 and Player_Id=9208 and Reason!=1 ==> size: 104
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=503843 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=503843 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=503843 and Position_Id in (213,214,212) and Player_Id=BPV.Player_Id) ==> size: 660
insert into Eligible_Players (Game_Id,League_Id,Position_Id,Player_Id,Reason) values (0,503843,203,9103,1) ==> size: 106
insert into Eligible_Players (Game_Id,League_Id,Position_Id,Player_Id,Reason) values (0,503843,206,10094,1) ==> size: 107
insert into Eligible_Players (Game_Id,League_Id,Position_Id,Player_Id,Reason) values (0,503843,214,9208,1) ==> size: 106
update Eligibility_Status set Status = 0, Last_Update=NOW() where League_Id=503843 ==> size: 82
select * from League_Stats where League_Id=503843 ==> size: 49
update League_Stats set Status = 1 where League_Id=503843 ==> size: 57
select * from Fantasy_Periods where League_Id=503843 order by Period ==> size: 68
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-16 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-17 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 * from Fantasy_Periods where League_Id=503843 order by Period ==> size: 68
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-23 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-24 00:00:00' and Start_Time < '2026-04-26 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=503843 and Status=1 ==> size: 87
select * from League_Design where League_Id = 503843 ==> size: 52
select * from Waiver_Wire_Info where League_Id=503843 ==> size: 53
select * from Waiver_Wire_Schedule where League_Id = 503843 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 = 503843 order by Transaction_Time desc limit 5 ==> size: 167
select * FROM Trades WHERE League_Id=503843 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 Team_Cumulative_Scoring_Stats where League_Id = 503843 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-15' and Start_Time < '2026-08-16' and (Competition_Type = 'Regular Season') order by Start_Time asc ==> size: 164