Total processing time: 395 ms; Peak memory: 10.159 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
02:13:36.856 | 9.0 ms | yii\db\Command::query | SELECT * FROM `ut_matches` WHERE (((`TeamID1`=1) AND (`TeamID2`=14)) OR ((`TeamID1`=14) AND (`TeamID2`=1))) AND (`StatusID` IN (4, 10, 11)) ORDER BY `Date` DESC |
02:13:36.865 | 7.3 ms | yii\db\Command::query | SELECT * FROM `ut_matches` WHERE (((`TeamID1`=1) AND (`TeamID2`=14)) OR ((`TeamID1`=14) AND (`TeamID2`=1))) AND (NOT (`StatusID` IN (4, 10, 11, 9, 8))) ORDER BY `Date` |
02:13:36.762 | 6.3 ms | yii\db\Command::query | SELECT * FROM `nut_articles_persons` WHERE (`PersonID`=34563) AND (`Type`='p') |
02:13:36.633 | 4.2 ms | yii\db\Connection::open | Opening DB connection: mysql:host=192.168.11.190;dbname=bombardirdb |
02:13:36.771 | 2.8 ms | yii\db\Command::query | SELECT * FROM `nut_posts_persons` WHERE (`PersonID`=34563) AND (`Type`='p') |
02:13:36.778 | 2.1 ms | yii\db\Command::query | select t1.Name_rus as TeamName1, t2.Name_rus as TeamName2, t1.City_rus as Team1City, t2.City_rus as Team2City, m.Goals1, m.Goals2, m.Penalty1, m.Penalty2, m.TeamID1, m.TeamID2, m.MatchID, t.TournamentID, t.Name_rus as Tournament, if(StartYear=EndYear,StartYear,concat(StartYear,'/',EndYear)) as Season, concat(t.TournamentID,'|',m.Tour), concat_ws(', ',t.Name_rus, if(r.Name_rus='',null,r.Name_rus), tr.Name, case m.Game when 1 then 'первый матч' when 2 then 'ответный матч' when 3 then 'повторный матч' else null end ) as TourName, m.MatchID as MatchID, m.Date as Date, max(mr.MarkType) MarkType, m.Duration Duration, subs.Minute as SubMinute from ut_marks as mr left join ut_matches as m using(MatchID) left join ut_teams t1 on t1.TeamID=m.TeamID1 left join ut_teams t2 on t2.TeamID=m.TeamID2 left join ut_tournaments t on m.TournamentID=t.TournamentID left join ut_seasons s on t.SeasonID=s.SeasonID left join ut_reglaments r on r.ReglamentID = m.ReglamentID left join ut_tours tr on m.Tour = tr.TourID and tr.IsDeleted = 0 left join ut_players p ON p.PlayerID=mr.PlayerID left join ut_subs subs ON subs.PlayerID2=mr.PlayerID AND subs.MatchID = mr.MatchID where mr.PlayerID=34563 and m.Date>unix_timestamp()-30*86400 AND m.StatusID != 0 group by MatchID order by m.Date desc,mr.MarkType desc |
02:13:36.787 | 1.9 ms | yii\db\Command::query | (select coalesce(tn1.Name,t1.Name_rus) as Team1, coalesce(tn2.Name,t2.Name_rus) as Team2, t1.TeamID as TeamID1, t2.TeamID as TeamID2, t1.City_rus as Team1City, t2.City_rus as Team2City, m.Goals1, m.Goals2, m.Penalty1, m.Penalty2, m.Date,m.MatchID,max(mrk.MarkType) MarkType,m.Duration Duration, subs.Minute as SubMinute from ut_marks mrk join ut_matches m on m.MatchID=mrk.MatchID left join ut_teams t1 on m.TeamID1=t1.TeamID left join ut_teams_names tn1 on t1.TeamID=tn1.TeamID and tn1.YearSince<='1493739900' and tn1.YearOn>='1493739900' left join ut_teams t2 on m.TeamID2=t2.TeamID left join ut_teams_names tn2 on t2.TeamID=tn2.TeamID and tn2.YearSince<='1493739900' and tn2.YearOn>='1493739900' left join ut_subs subs ON subs.PlayerID2=mrk.PlayerID AND subs.MatchID = mrk.MatchID where m.TournamentID='893' and mrk.PlayerID=34563 AND m.StatusID != 0 group by m.MatchID) union (select coalesce(tn1.Name,t1.Name_rus) as Team1, coalesce(tn2.Name,t2.Name_rus) as Team2, t1.TeamID as TeamID1, t2.TeamID as TeamID2, t1.City_rus as Team1City, t2.City_rus as Team2City, m.Goals1, m.Goals2, m.Penalty1, m.Penalty2, m.Date,m.MatchID,max(mrk.MarkType) MarkType,m.Duration Duration, subs.Minute as SubMinute from ut_marks_archive mrk join ut_matches m on m.MatchID=mrk.MatchID left join ut_teams t1 on m.TeamID1=t1.TeamID left join ut_teams_names tn1 on t1.TeamID=tn1.TeamID and tn1.YearSince<='1493739900' and tn1.YearOn>='1493739900' left join ut_teams t2 on m.TeamID2=t2.TeamID left join ut_teams_names tn2 on t2.TeamID=tn2.TeamID and tn2.YearSince<='1493739900' and tn2.YearOn>='1493739900' left join ut_subs subs ON subs.PlayerID2=mrk.PlayerID AND subs.MatchID = mrk.MatchID where m.TournamentID='893' and mrk.PlayerID=34563 AND m.StatusID != 0 group by m.MatchID ) order by Date desc |
02:13:36.688 | 1.6 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.927 | 1.6 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.808 | 1.6 ms | yii\db\Command::query | SELECT `ut_marks`.* FROM `ut_marks` LEFT JOIN `ut_matches` ON `ut_marks`.`MatchID` = `ut_matches`.`MatchID` WHERE (`PlayerID`=34563) AND ((`ut_matches`.`TournamentID`=893) AND (`ut_marks`.`MarkType` IN (1, 2))) AND (NOT (`ut_matches`.`StatusID`=0)) ORDER BY `ut_matches`.`Date` DESC, `ut_marks`.`MarkType` DESC |
02:13:36.996 | 1.5 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_11') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.804 | 1.5 ms | yii\db\Command::query | SELECT `ut_marks`.* FROM `ut_marks` LEFT JOIN `ut_matches` ON `ut_marks`.`MatchID` = `ut_matches`.`MatchID` WHERE (`PlayerID`=34563) AND (`ut_matches`.`Date` >= 1739056416) AND (NOT (`ut_matches`.`StatusID`=0)) AND (`ut_marks`.`MarkType` IN (1, 2)) ORDER BY `ut_matches`.`Date` DESC, `ut_marks`.`MarkType` DESC |
02:13:36.883 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `ut_matches` WHERE (`ReglamentID`=1251) AND (NOT (`PlayoffPosition` IS NULL)) |
02:13:36.932 | 1.4 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:36.697 | 1.4 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:37.001 | 1.3 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_11') AND (`start_date` <= '2025-03-11 02:13:37') AND ((`end_date` >= '2025-03-11 02:13:37') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:36.970 | 1.3 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_3') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.782 | 1.2 ms | yii\db\Command::query | select t.TournamentID,concat(t.Name_rus,' ',if(StartYear=EndYear,StartYear,concat(StartYear,'/',EndYear))) Name,coalesce(group_concat(distinct if(rg.ShowStats>0,1,null)),0) ShowStats from ut_tournaments t join ut_seasons s on t.SeasonID=s.SeasonID join ut_roster r on t.TournamentID=r.TournamentID join ut_reglaments rg on t.TournamentID=rg.TournamentID where r.PlayerID=34563 and r.Games>0 group by t.TournamentID order by StartYear desc,t.Name_rus asc |
02:13:36.729 | 1.2 ms | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=1) |
02:13:36.837 | 1.2 ms | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=71) |
02:13:36.906 | 1.2 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_57') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.955 | 1.2 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_48') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.981 | 1.2 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_3') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.742 | 1.2 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_50') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.724 | 1.2 ms | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=34563 |
02:13:36.965 | 1.2 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_61') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.785 | 1.2 ms | yii\db\Command::query | select coalesce(tn.Name,t.Name_rus) as TeamName, r.TeamID, r.Games Games, if(p.Position=1,if(r.Missed>0 and r.Goals>0,concat(-(r.Missed),'/',r.Goals),-(r.Missed)),if(r.Missed>0 and r.Goals>0,concat(r.Goals,'/',-(r.Missed)),r.Goals)) Goals, (r.YellowCards - r.YellowRedCards) YellowCards, (r.RedCards + r.YellowRedCards) RedCards, COALESCE(r.Passes,0) Passes from ut_roster r join ut_players p on r.PlayerID=p.PlayerID join ut_teams t on r.TeamID=t.TeamID left join ut_teams_names tn on t.TeamID=tn.TeamID and tn.YearSince<='1493739900' and tn.YearOn>='1493739900' where r.TournamentID='893' and r.PlayerID=34563 and r.Games<>0 group by r.TeamID order by r.Games desc |
02:13:36.938 | 1.1 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_16') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.995 | 1.1 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_34') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.914 | 1.1 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_17') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.942 | 1.1 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_16') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:36.975 | 1.1 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_3') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:36.812 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=34563 |
02:13:36.850 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_matches` WHERE `MatchID`=97491 |
02:13:36.818 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=14 |
02:13:36.831 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=14 |
02:13:36.827 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_marks` WHERE (`MarkType`=2) AND ((`PlayerID`, `MatchID`) IN ((28843, 97491))) |
02:13:36.731 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=14 |
02:13:36.749 | 1.1 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_49') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.986 | 1.1 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_3') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:36.783 | 1.1 ms | yii\db\Command::query | select max(Date) as Date from ut_matches where TournamentID='893' |
02:13:36.852 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=1 |
02:13:36.732 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=34563 |
02:13:36.841 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=1 |
02:13:36.813 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_matches` WHERE `MatchID`=97491 |
02:13:36.637 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `slug`='34563-roman-hodunov' |
02:13:36.918 | 1.1 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_17') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:36.792 | 1.1 ms | yii\db\Command::query | SELECT * FROM ut_goals WHERE PlayerID=34563 AND MatchID='97491' ORDER BY MINUTE ASC |
02:13:36.719 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE `SectionID`=22 |
02:13:36.734 | 1.1 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_7') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.714 | 1.1 ms | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=14 |
02:13:36.717 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=14 |
02:13:36.822 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((34563, 97491)) |
02:13:36.910 | 1.0 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_57') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:36.725 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=14 |
02:13:37.005 | 1.0 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_55') AND (`start_date` <= '2025-03-11 02:13:37') AND ((`end_date` >= '2025-03-11 02:13:37') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.959 | 1.0 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_48') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:36.753 | 1.0 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_49') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:36.747 | 1.0 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_50') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
02:13:36.830 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=28843 |
02:13:36.877 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_reglaments` WHERE `ReglamentID`=1251 |
02:13:36.853 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=14 |
02:13:37.004 | 1.0 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_25') AND (`start_date` <= '2025-03-11 02:13:37') AND ((`end_date` >= '2025-03-11 02:13:37') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.913 | 1.0 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_35') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.829 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=28843 |
02:13:36.912 | 1.0 ms | yii\db\Command::query | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_30') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
02:13:36.789 | 1.0 ms | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID1=34563 AND MatchID='97491' ORDER BY Minute LIMIT 1 |
02:13:36.894 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_stadiums_names` WHERE (`0`, `1`) IN ((232, 232)) |
02:13:36.710 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=34563 |
02:13:36.880 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_match_bookmaker_links` WHERE (`match_id`=97491) AND (`bookmaker_id`=6) ORDER BY `type` |
02:13:36.757 | 1.0 ms | yii\db\Command::query | SELECT * FROM `nut_news_persons` WHERE (`PersonID`=34563) AND (`Type`='p') |
02:13:36.685 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`image` <> '') AND (`StartDate` < 1741648416) AND ((`EndDate` > 1741648416) OR (`EndDate`=0)) |
02:13:36.843 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=14 |
02:13:36.891 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_stadiums` WHERE `StadiumID`=232 |
02:13:36.824 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((34563, 97491)) |
02:13:36.967 | 1.0 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `desktop_column_order`=3 ORDER BY `desktop_block_order` |
02:13:36.887 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_judges` WHERE `JudgeID`=398 |
02:13:36.794 | 1.0 ms | yii\db\Command::query | SELECT * FROM ut_cards WHERE PlayerID=34563 AND MatchID='97491' ORDER BY MINUTE ASC |
02:13:36.833 | 1.0 ms | yii\db\Command::query | SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((34563, 97491)) |
02:13:36.790 | 1.0 ms | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID2=34563 AND MatchID='97491' ORDER BY Minute LIMIT 1 |
02:13:36.745 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=169 |
02:13:36.793 | 0.9 ms | yii\db\Command::query | SELECT * FROM ut_goals WHERE PasPlayerID <> PlayerID AND PasPlayerID=34563 AND GoalType<7 AND MatchID='97491' ORDER BY MINUTE ASC |
02:13:36.823 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((34563, 97491)) |
02:13:36.795 | 0.9 ms | yii\db\Command::query | SELECT * FROM ut_injury WHERE PlayerID=34563 AND MatchID='97491' ORDER BY MINUTE ASC |
02:13:36.707 | 0.9 ms | yii\db\Command::query | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `SectionID`=1 |
02:13:36.791 | 0.9 ms | yii\db\Command::query | SELECT Minute FROM ut_cards WHERE PlayerID=34563 AND MatchID='97491' AND CardType IN (1,3) ORDER BY Minute LIMIT 1 |
02:13:36.819 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((34563, 97491)) |
02:13:36.703 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`StartDate` < 1741648416) AND (`bottomImage` <> '') AND ((`EndDate` > 1741648416) OR (`EndDate`=0)) AND (`useBottom`=1) |
02:13:36.872 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=893 |
02:13:36.990 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_3' |
02:13:36.936 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' |
02:13:36.972 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=6 |
02:13:36.838 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_section_photos` WHERE `section_id`=32 |
02:13:36.695 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=5 |
02:13:36.834 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=893 |
02:13:36.908 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=300 |
02:13:36.930 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=5 |
02:13:36.916 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=303 |
02:13:36.980 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name` IN ('main_news', 'ads3', 'ads4', 'ads2', 'ads30', 'ads', 'ads62', 'ads63') |
02:13:36.960 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_48' |
02:13:36.890 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_seasons` WHERE `SeasonID`=47 |
02:13:36.739 | 0.9 ms | yii\db\Command::query | SELECT * FROM `nut_transfer_players` WHERE `PlayerID`=34563 |
02:13:36.958 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=305 |
02:13:37.002 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_11' |
02:13:36.692 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=1 |
02:13:36.917 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=303 |
02:13:36.935 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=598 |
02:13:36.946 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_16' |
02:13:36.998 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=11 |
02:13:36.909 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=300 |
02:13:36.988 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=600 |
02:13:36.923 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_17' |
02:13:36.941 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=159 |
02:13:36.709 | 0.9 ms | yii\db\Command::query | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE (`Url`='player/34563-roman-hodunov/stats') AND (`Parent`='1266') |
02:13:36.979 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_3' |
02:13:36.701 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' |
02:13:36.934 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=1 |
02:13:36.907 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=57 |
02:13:36.920 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=17 |
02:13:36.973 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=6 |
02:13:36.940 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=159 |
02:13:37.000 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=307 |
02:13:36.736 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_countries` `country1` WHERE `CountryID`=129 |
02:13:36.748 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_50' |
02:13:36.984 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=6 |
02:13:36.976 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=3 |
02:13:36.921 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=599 |
02:13:36.754 | 0.9 ms | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_49' |
02:13:36.750 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=49 |
02:13:36.957 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=305 |
02:13:36.978 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=600 |
02:13:36.922 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=599 |
02:13:36.999 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=307 |
02:13:36.711 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_position_types` WHERE `PositionID`=3 |
02:13:36.929 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=1 |
02:13:36.956 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=48 |
02:13:36.989 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=600 |
02:13:36.943 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=16 |
02:13:36.971 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=3 |
02:13:36.977 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=600 |
02:13:36.985 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=6 |
02:13:36.944 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=597 |
02:13:36.983 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=3 |
02:13:36.696 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=5 |
02:13:36.931 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=5 |
02:13:36.987 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=3 |
02:13:36.939 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=16 |
02:13:36.915 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=17 |
02:13:36.945 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=597 |
02:13:36.936 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=598 |
02:13:36.726 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_divisions` WHERE `DivisionID`=1 |
02:13:36.751 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=165 |
02:13:36.847 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_tours` WHERE `TourID`=105 |
02:13:36.746 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=169 |
02:13:36.786 | 0.9 ms | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='14' |
02:13:36.744 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=50 |
02:13:36.844 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_match_statuses` WHERE `StatusID`=4 |
02:13:36.699 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=598 |
02:13:36.738 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ut_countries` `country2` WHERE `CountryID`=0 |
02:13:36.758 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `nut_news` WHERE 0=1 |
02:13:36.700 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=598 |
02:13:36.752 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=165 |
02:13:36.698 | 0.9 ms | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=1 |
02:13:36.796 | 0.9 ms | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='1' |
02:13:36.708 | 0.8 ms | yii\db\Command::query | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `MenuID`='1' |
02:13:36.797 | 0.8 ms | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='14' |
02:13:36.768 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `nut_articles` WHERE (0=1) AND (`Active`=1) |
02:13:36.774 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `nut_posts` WHERE 0=1 |