# | Time | Since previous | Level | Category | Message |
---|---|---|---|---|---|
1 | 03:56:47.704 | < 0ms > | info | yii\db\Connection::open | Opening DB connection: mysql:host=192.168.11.190;dbname=bombardirdb |
2 | 03:56:47.709 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `slug`='41069-sebastan-vasiliadis' | |
3 | 03:56:47.720 | info | yii\db\Command::query | SELECT * FROM `robot_agent` | |
4 | 03:56:47.723 | info | yii\db\Command::query | SELECT * FROM `nut_default_params` WHERE `name`='AB_TEST_SALT' | |
5 | 03:56:47.743 | info | yii\db\Command::query | SELECT * FROM `nut_default_params` WHERE `name`='block_on_main_page_count_main_news' | |
6 | 03:56:47.751 | info | yii\db\Command::query | SELECT * FROM `nut_default_params` WHERE `name`='block_on_main_page_count_all_news' | |
7 | 03:56:47.759 | info | yii\db\Command::query | SELECT * FROM `nut_default_params` WHERE `name`='block_on_main_page_count_discussed_news' | |
8 | 03:56:47.762 | info | yii\db\Command::query | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`image` <> '') AND (`StartDate` < 1742000207) AND ((`EndDate` > 1742000207) OR (`EndDate`=0)) | |
9 | 03:56:47.766 | info | 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-15 03:56:47') AND ((`end_date` >= '2025-03-15 03:56:47') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
10 | 03:56:47.770 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=1 | |
11 | 03:56:47.773 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=5 | |
12 | 03:56:47.774 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=5 | |
13 | 03:56:47.775 | info | 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-15 03:56:47') AND ((`end_date` >= '2025-03-15 03:56:47') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
14 | 03:56:47.777 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=1 | |
15 | 03:56:47.778 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=598 | |
16 | 03:56:47.779 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=598 | |
17 | 03:56:47.780 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' | |
18 | 03:56:47.781 | info | yii\db\Command::query | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`StartDate` < 1742000207) AND (`bottomImage` <> '') AND ((`EndDate` > 1742000207) OR (`EndDate`=0)) AND (`useBottom`=1) | |
19 | 03:56:47.785 | info | yii\db\Command::query | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `SectionID`=1 | |
20 | 03:56:47.786 | info | yii\db\Command::query | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `MenuID`='1' | |
21 | 03:56:47.787 | info | yii\db\Command::query | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE (`Url`='player/41069-sebastan-vasiliadis/stats') AND (`Parent`='1266') | |
22 | 03:56:47.788 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=41069 | |
23 | 03:56:47.790 | info | yii\db\Command::query | SELECT * FROM `ut_position_types` WHERE `PositionID`=3 | |
24 | 03:56:47.792 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
25 | 03:56:47.796 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
26 | 03:56:47.797 | info | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE `DivisionID`=38 ORDER BY `SectionID` DESC | |
27 | 03:56:47.803 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=41069 | |
28 | 03:56:47.804 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
29 | 03:56:47.805 | info | yii\db\Command::query | SELECT * FROM `ut_divisions` WHERE `DivisionID`=38 | |
30 | 03:56:47.808 | info | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=38) | |
31 | 03:56:47.810 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
32 | 03:56:47.811 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=41069 | |
33 | 03:56:47.813 | info | 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-15 03:56:47') AND ((`end_date` >= '2025-03-15 03:56:47') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
34 | 03:56:47.815 | info | yii\db\Command::query | SELECT * FROM `ut_countries` `country1` WHERE `CountryID`=57 | |
35 | 03:56:47.818 | info | yii\db\Command::query | SELECT * FROM `ut_countries` `country2` WHERE 0=1 | |
36 | 03:56:47.819 | info | yii\db\Command::query | SELECT * FROM `nut_transfer_players` WHERE `PlayerID`=41069 | |
37 | 03:56:47.821 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `nut_transfer_players` | |
38 | 03:56:47.822 | info | yii\db\Command::query | SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'nut_transfer_players' AND `kcu`.`TABLE_NAME` = 'nut_transfer_players' | |
39 | 03:56:47.826 | info | 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-15 03:56:47') AND ((`end_date` >= '2025-03-15 03:56:47') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
40 | 03:56:47.828 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=50 | |
41 | 03:56:47.829 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=169 | |
42 | 03:56:47.830 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=169 | |
43 | 03:56:47.831 | info | 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-15 03:56:47') AND ((`end_date` >= '2025-03-15 03:56:47') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
44 | 03:56:47.832 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_50' | |
45 | 03:56:47.833 | info | 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-15 03:56:47') AND ((`end_date` >= '2025-03-15 03:56:47') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
46 | 03:56:47.834 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=49 | |
47 | 03:56:47.835 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=165 | |
48 | 03:56:47.836 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=165 | |
49 | 03:56:47.837 | info | 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-15 03:56:47') AND ((`end_date` >= '2025-03-15 03:56:47') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
50 | 03:56:47.838 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_49' | |
51 | 03:56:47.841 | info | yii\db\Command::query | SELECT * FROM `nut_news_persons` WHERE (`PersonID`=41069) AND (`Type`='p') | |
52 | 03:56:47.843 | info | yii\db\Command::query | SELECT COUNT(*) FROM `nut_news` WHERE 0=1 | |
53 | 03:56:47.846 | info | yii\db\Command::query | SELECT * FROM `nut_articles_persons` WHERE (`PersonID`=41069) AND (`Type`='p') | |
54 | 03:56:47.847 | info | yii\db\Command::query | SELECT COUNT(*) FROM `nut_articles` WHERE (0=1) AND (`Active`=1) | |
55 | 03:56:47.850 | info | yii\db\Command::query | SELECT * FROM `nut_posts_persons` WHERE (`PersonID`=41069) AND (`Type`='p') | |
56 | 03:56:47.851 | info | yii\db\Command::query | SELECT COUNT(*) FROM `nut_posts` WHERE 0=1 | |
57 | 03:56:47.855 | info | 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=41069 and m.Date>unix_timestamp()-30*86400 AND m.StatusID != 0 group by MatchID order by m.Date desc,mr.MarkType desc | |
58 | 03:56:47.858 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID1=41069 AND MatchID='212224' ORDER BY Minute LIMIT 1 | |
59 | 03:56:47.859 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID2=41069 AND MatchID='212224' ORDER BY Minute LIMIT 1 | |
60 | 03:56:47.860 | info | yii\db\Command::query | SELECT Minute FROM ut_cards WHERE PlayerID=41069 AND MatchID='212224' AND CardType IN (1,3) ORDER BY Minute LIMIT 1 | |
61 | 03:56:47.861 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PlayerID=41069 AND MatchID='212224' ORDER BY MINUTE ASC | |
62 | 03:56:47.862 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PasPlayerID <> PlayerID AND PasPlayerID=41069 AND GoalType<7 AND MatchID='212224' ORDER BY MINUTE ASC | |
63 | 03:56:47.863 | info | yii\db\Command::query | SELECT * FROM ut_cards WHERE PlayerID=41069 AND MatchID='212224' ORDER BY MINUTE ASC | |
64 | 03:56:47.864 | info | yii\db\Command::query | SELECT * FROM ut_injury WHERE PlayerID=41069 AND MatchID='212224' ORDER BY MINUTE ASC | |
65 | 03:56:47.865 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='1715' | |
66 | 03:56:47.866 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='12854218' | |
67 | 03:56:47.868 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID1=41069 AND MatchID='212216' ORDER BY Minute LIMIT 1 | |
68 | 03:56:47.869 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID2=41069 AND MatchID='212216' ORDER BY Minute LIMIT 1 | |
69 | 03:56:47.870 | info | yii\db\Command::query | SELECT Minute FROM ut_cards WHERE PlayerID=41069 AND MatchID='212216' AND CardType IN (1,3) ORDER BY Minute LIMIT 1 | |
70 | 03:56:47.870 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PlayerID=41069 AND MatchID='212216' ORDER BY MINUTE ASC | |
71 | 03:56:47.872 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PasPlayerID <> PlayerID AND PasPlayerID=41069 AND GoalType<7 AND MatchID='212216' ORDER BY MINUTE ASC | |
72 | 03:56:47.873 | info | yii\db\Command::query | SELECT * FROM ut_cards WHERE PlayerID=41069 AND MatchID='212216' ORDER BY MINUTE ASC | |
73 | 03:56:47.874 | info | yii\db\Command::query | SELECT * FROM ut_injury WHERE PlayerID=41069 AND MatchID='212216' ORDER BY MINUTE ASC | |
74 | 03:56:47.875 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='136' | |
75 | 03:56:47.876 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='1715' | |
76 | 03:56:47.877 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID1=41069 AND MatchID='212203' ORDER BY Minute LIMIT 1 | |
77 | 03:56:47.878 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID2=41069 AND MatchID='212203' ORDER BY Minute LIMIT 1 | |
78 | 03:56:47.879 | info | yii\db\Command::query | SELECT Minute FROM ut_cards WHERE PlayerID=41069 AND MatchID='212203' AND CardType IN (1,3) ORDER BY Minute LIMIT 1 | |
79 | 03:56:47.880 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PlayerID=41069 AND MatchID='212203' ORDER BY MINUTE ASC | |
80 | 03:56:47.881 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PasPlayerID <> PlayerID AND PasPlayerID=41069 AND GoalType<7 AND MatchID='212203' ORDER BY MINUTE ASC | |
81 | 03:56:47.882 | info | yii\db\Command::query | SELECT * FROM ut_cards WHERE PlayerID=41069 AND MatchID='212203' ORDER BY MINUTE ASC | |
82 | 03:56:47.883 | info | yii\db\Command::query | SELECT * FROM ut_injury WHERE PlayerID=41069 AND MatchID='212203' ORDER BY MINUTE ASC | |
83 | 03:56:47.884 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='1715' | |
84 | 03:56:47.885 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='257' | |
85 | 03:56:47.886 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID1=41069 AND MatchID='212200' ORDER BY Minute LIMIT 1 | |
86 | 03:56:47.887 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID2=41069 AND MatchID='212200' ORDER BY Minute LIMIT 1 | |
87 | 03:56:47.888 | info | yii\db\Command::query | SELECT Minute FROM ut_cards WHERE PlayerID=41069 AND MatchID='212200' AND CardType IN (1,3) ORDER BY Minute LIMIT 1 | |
88 | 03:56:47.889 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PlayerID=41069 AND MatchID='212200' ORDER BY MINUTE ASC | |
89 | 03:56:47.890 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PasPlayerID <> PlayerID AND PasPlayerID=41069 AND GoalType<7 AND MatchID='212200' ORDER BY MINUTE ASC | |
90 | 03:56:47.891 | info | yii\db\Command::query | SELECT * FROM ut_cards WHERE PlayerID=41069 AND MatchID='212200' ORDER BY MINUTE ASC | |
91 | 03:56:47.892 | info | yii\db\Command::query | SELECT * FROM ut_injury WHERE PlayerID=41069 AND MatchID='212200' ORDER BY MINUTE ASC | |
92 | 03:56:47.893 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='2634' | |
93 | 03:56:47.894 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='1715' | |
94 | 03:56:47.895 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID1=41069 AND MatchID='212183' ORDER BY Minute LIMIT 1 | |
95 | 03:56:47.896 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID2=41069 AND MatchID='212183' ORDER BY Minute LIMIT 1 | |
96 | 03:56:47.897 | info | yii\db\Command::query | SELECT Minute FROM ut_cards WHERE PlayerID=41069 AND MatchID='212183' AND CardType IN (1,3) ORDER BY Minute LIMIT 1 | |
97 | 03:56:47.898 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PlayerID=41069 AND MatchID='212183' ORDER BY MINUTE ASC | |
98 | 03:56:47.900 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PasPlayerID <> PlayerID AND PasPlayerID=41069 AND GoalType<7 AND MatchID='212183' ORDER BY MINUTE ASC | |
99 | 03:56:47.901 | info | yii\db\Command::query | SELECT * FROM ut_cards WHERE PlayerID=41069 AND MatchID='212183' ORDER BY MINUTE ASC | |
100 | 03:56:47.902 | info | yii\db\Command::query | SELECT * FROM ut_injury WHERE PlayerID=41069 AND MatchID='212183' ORDER BY MINUTE ASC | |
101 | 03:56:47.903 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='1715' | |
102 | 03:56:47.904 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='12854408' | |
103 | 03:56:47.905 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID1=41069 AND MatchID='212180' ORDER BY Minute LIMIT 1 | |
104 | 03:56:47.906 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID2=41069 AND MatchID='212180' ORDER BY Minute LIMIT 1 | |
105 | 03:56:47.907 | info | yii\db\Command::query | SELECT Minute FROM ut_cards WHERE PlayerID=41069 AND MatchID='212180' AND CardType IN (1,3) ORDER BY Minute LIMIT 1 | |
106 | 03:56:47.908 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PlayerID=41069 AND MatchID='212180' ORDER BY MINUTE ASC | |
107 | 03:56:47.909 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PasPlayerID <> PlayerID AND PasPlayerID=41069 AND GoalType<7 AND MatchID='212180' ORDER BY MINUTE ASC | |
108 | 03:56:47.910 | info | yii\db\Command::query | SELECT * FROM ut_cards WHERE PlayerID=41069 AND MatchID='212180' ORDER BY MINUTE ASC | |
109 | 03:56:47.911 | info | yii\db\Command::query | SELECT * FROM ut_injury WHERE PlayerID=41069 AND MatchID='212180' ORDER BY MINUTE ASC | |
110 | 03:56:47.912 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='654' | |
111 | 03:56:47.913 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='1715' | |
112 | 03:56:47.917 | info | 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=41069 and r.Games>0 group by t.TournamentID order by StartYear desc,t.Name_rus asc | |
113 | 03:56:47.918 | info | yii\db\Command::query | select max(Date) as Date from ut_matches where TournamentID='1439' | |
114 | 03:56:47.919 | info | 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<='1743619500' and tn.YearOn>='1743619500' where r.TournamentID='1439' and r.PlayerID=41069 and r.Games<>0 group by r.TeamID order by r.Games desc | |
115 | 03:56:47.920 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='1715' | |
116 | 03:56:47.922 | info | 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<='1743619500' and tn1.YearOn>='1743619500' left join ut_teams t2 on m.TeamID2=t2.TeamID left join ut_teams_names tn2 on t2.TeamID=tn2.TeamID and tn2.YearSince<='1743619500' and tn2.YearOn>='1743619500' left join ut_subs subs ON subs.PlayerID2=mrk.PlayerID AND subs.MatchID = mrk.MatchID where m.TournamentID='1439' and mrk.PlayerID=41069 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<='1743619500' and tn1.YearOn>='1743619500' left join ut_teams t2 on m.TeamID2=t2.TeamID left join ut_teams_names tn2 on t2.TeamID=tn2.TeamID and tn2.YearSince<='1743619500' and tn2.YearOn>='1743619500' left join ut_subs subs ON subs.PlayerID2=mrk.PlayerID AND subs.MatchID = mrk.MatchID where m.TournamentID='1439' and mrk.PlayerID=41069 AND m.StatusID != 0 group by m.MatchID ) order by Date desc | |
117 | 03:56:47.924 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID1=41069 AND MatchID='200052' ORDER BY Minute LIMIT 1 | |
118 | 03:56:47.925 | info | yii\db\Command::query | SELECT Minute FROM ut_subs WHERE PlayerID2=41069 AND MatchID='200052' ORDER BY Minute LIMIT 1 | |
119 | 03:56:47.926 | info | yii\db\Command::query | SELECT Minute FROM ut_cards WHERE PlayerID=41069 AND MatchID='200052' AND CardType IN (1,3) ORDER BY Minute LIMIT 1 | |
120 | 03:56:47.927 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PlayerID=41069 AND MatchID='200052' ORDER BY MINUTE ASC | |
121 | 03:56:47.928 | info | yii\db\Command::query | SELECT * FROM ut_goals WHERE PasPlayerID <> PlayerID AND PasPlayerID=41069 AND GoalType<7 AND MatchID='200052' ORDER BY MINUTE ASC | |
122 | 03:56:47.929 | info | yii\db\Command::query | SELECT * FROM ut_cards WHERE PlayerID=41069 AND MatchID='200052' ORDER BY MINUTE ASC | |
123 | 03:56:47.930 | info | yii\db\Command::query | SELECT * FROM ut_injury WHERE PlayerID=41069 AND MatchID='200052' ORDER BY MINUTE ASC | |
124 | 03:56:47.931 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='1715' | |
125 | 03:56:47.932 | info | yii\db\Command::query | SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='253' | |
126 | 03:56:47.939 | info | yii\db\Command::query | SELECT `ut_marks`.* FROM `ut_marks` LEFT JOIN `ut_matches` ON `ut_marks`.`MatchID` = `ut_matches`.`MatchID` WHERE (`PlayerID`=41069) AND (`ut_matches`.`Date` >= 1739408207) AND (NOT (`ut_matches`.`StatusID`=0)) AND (`ut_marks`.`MarkType` IN (1, 2)) ORDER BY `ut_matches`.`Date` DESC, `ut_marks`.`MarkType` DESC | |
127 | 03:56:47.943 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=41069 | |
128 | 03:56:47.944 | info | yii\db\Command::query | SELECT * FROM `ut_matches` WHERE `MatchID` IN (212224, 212216, 212203, 212200, 212183, 212180) | |
129 | 03:56:47.952 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
130 | 03:56:47.954 | info | yii\db\Command::query | SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212224)) | |
131 | 03:56:47.955 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212224)) | |
132 | 03:56:47.956 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((41069, 212224)) | |
133 | 03:56:47.957 | info | yii\db\Command::query | SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((41069, 212224)) | |
134 | 03:56:47.960 | info | yii\db\Command::query | SELECT * FROM `ut_marks` WHERE (`MarkType`=2) AND ((`PlayerID`, `MatchID`) IN ((62723, 212224))) | |
135 | 03:56:47.961 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=62723 | |
136 | 03:56:47.963 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=62723 | |
137 | 03:56:47.964 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
138 | 03:56:47.965 | info | yii\db\Command::query | SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212224)) | |
139 | 03:56:47.966 | info | yii\db\Command::query | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=1498 | |
140 | 03:56:47.969 | info | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=38) | |
141 | 03:56:47.971 | info | yii\db\Command::query | SELECT * FROM `ut_section_photos` WHERE `section_id`=175 | |
142 | 03:56:47.974 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=1715 | |
143 | 03:56:47.975 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=12854218 | |
144 | 03:56:47.977 | info | yii\db\Command::query | SELECT * FROM `ut_match_statuses` WHERE `StatusID`=4 | |
145 | 03:56:47.979 | info | yii\db\Command::query | SELECT * FROM `ut_tours` WHERE `TourID`=29 | |
146 | 03:56:47.983 | info | yii\db\Command::query | SELECT * FROM `ut_reglaments` WHERE `ReglamentID`=1944 | |
147 | 03:56:47.987 | info | yii\db\Command::query | SELECT * FROM `ut_match_bookmaker_links` WHERE (`match_id`=212224) AND (`bookmaker_id`=6) ORDER BY `type` | |
148 | 03:56:47.991 | info | yii\db\Command::query | SELECT COUNT(*) FROM `ut_matches` WHERE (`ReglamentID`=1944) AND (NOT (`PlayoffPosition` IS NULL)) | |
149 | 03:56:47.995 | info | yii\db\Command::query | SELECT * FROM `ut_judges` WHERE `JudgeID`=2905 | |
150 | 03:56:47.998 | info | yii\db\Command::query | SELECT * FROM `ut_seasons` WHERE `SeasonID`=55 | |
151 | 03:56:48.001 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums` WHERE `StadiumID`=1930 | |
152 | 03:56:48.004 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums_names` WHERE (`0`, `1`) IN ((1930, 1930)) | |
153 | 03:56:48.005 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
154 | 03:56:48.007 | info | yii\db\Command::query | SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212216)) | |
155 | 03:56:48.010 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212216)) | |
156 | 03:56:48.011 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((41069, 212216)) | |
157 | 03:56:48.012 | info | yii\db\Command::query | SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((41069, 212216)) | |
158 | 03:56:48.013 | info | yii\db\Command::query | SELECT * FROM `ut_marks` WHERE (`MarkType`=2) AND ((`PlayerID`, `MatchID`) IN ((86131, 212216))) | |
159 | 03:56:48.014 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=86131 | |
160 | 03:56:48.016 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=86131 | |
161 | 03:56:48.017 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
162 | 03:56:48.018 | info | yii\db\Command::query | SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212216)) | |
163 | 03:56:48.019 | info | yii\db\Command::query | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=1498 | |
164 | 03:56:48.020 | info | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=38) | |
165 | 03:56:48.021 | info | yii\db\Command::query | SELECT * FROM `ut_section_photos` WHERE `section_id`=175 | |
166 | 03:56:48.023 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=136 | |
167 | 03:56:48.024 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=1715 | |
168 | 03:56:48.025 | info | yii\db\Command::query | SELECT * FROM `ut_match_statuses` WHERE `StatusID`=4 | |
169 | 03:56:48.027 | info | yii\db\Command::query | SELECT * FROM `ut_tours` WHERE `TourID`=28 | |
170 | 03:56:48.028 | info | yii\db\Command::query | SELECT * FROM `ut_reglaments` WHERE `ReglamentID`=1944 | |
171 | 03:56:48.030 | info | yii\db\Command::query | SELECT * FROM `ut_match_bookmaker_links` WHERE (`match_id`=212216) AND (`bookmaker_id`=6) ORDER BY `type` | |
172 | 03:56:48.032 | info | yii\db\Command::query | SELECT COUNT(*) FROM `ut_matches` WHERE (`ReglamentID`=1944) AND (NOT (`PlayoffPosition` IS NULL)) | |
173 | 03:56:48.034 | info | yii\db\Command::query | SELECT * FROM `ut_judges` WHERE `JudgeID`=1370 | |
174 | 03:56:48.035 | info | yii\db\Command::query | SELECT * FROM `ut_seasons` WHERE `SeasonID`=55 | |
175 | 03:56:48.036 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums` WHERE `StadiumID`=1920 | |
176 | 03:56:48.037 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums_names` WHERE (`0`, `1`) IN ((1920, 1920)) | |
177 | 03:56:48.039 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
178 | 03:56:48.040 | info | yii\db\Command::query | SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212203)) | |
179 | 03:56:48.041 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212203)) | |
180 | 03:56:48.044 | info | yii\db\Command::query | SELECT * FROM `ut_marks` WHERE (`PlayerID`, `MatchID`) IN ((32222, 212203)) | |
181 | 03:56:48.045 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=32222 | |
182 | 03:56:48.047 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=32222 | |
183 | 03:56:48.048 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
184 | 03:56:48.049 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((41069, 212203)) | |
185 | 03:56:48.050 | info | yii\db\Command::query | SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((41069, 212203)) | |
186 | 03:56:48.052 | info | yii\db\Command::query | SELECT * FROM `ut_marks` WHERE (`MarkType`=2) AND ((`PlayerID`, `MatchID`) IN ((62723, 212203))) | |
187 | 03:56:48.053 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=62723 | |
188 | 03:56:48.054 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
189 | 03:56:48.056 | info | yii\db\Command::query | SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212203)) | |
190 | 03:56:48.057 | info | yii\db\Command::query | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=1498 | |
191 | 03:56:48.058 | info | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=38) | |
192 | 03:56:48.059 | info | yii\db\Command::query | SELECT * FROM `ut_section_photos` WHERE `section_id`=175 | |
193 | 03:56:48.060 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=1715 | |
194 | 03:56:48.061 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=257 | |
195 | 03:56:48.063 | info | yii\db\Command::query | SELECT * FROM `ut_match_statuses` WHERE `StatusID`=4 | |
196 | 03:56:48.064 | info | yii\db\Command::query | SELECT * FROM `ut_tours` WHERE `TourID`=27 | |
197 | 03:56:48.066 | info | yii\db\Command::query | SELECT * FROM `ut_reglaments` WHERE `ReglamentID`=1944 | |
198 | 03:56:48.067 | info | yii\db\Command::query | SELECT * FROM `ut_match_bookmaker_links` WHERE (`match_id`=212203) AND (`bookmaker_id`=6) ORDER BY `type` | |
199 | 03:56:48.070 | info | yii\db\Command::query | SELECT COUNT(*) FROM `ut_matches` WHERE (`ReglamentID`=1944) AND (NOT (`PlayoffPosition` IS NULL)) | |
200 | 03:56:48.072 | info | yii\db\Command::query | SELECT * FROM `ut_judges` WHERE `JudgeID`=1633 | |
201 | 03:56:48.073 | info | yii\db\Command::query | SELECT * FROM `ut_seasons` WHERE `SeasonID`=55 | |
202 | 03:56:48.074 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums` WHERE `StadiumID`=1930 | |
203 | 03:56:48.075 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums_names` WHERE (`0`, `1`) IN ((1930, 1930)) | |
204 | 03:56:48.076 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
205 | 03:56:48.078 | info | yii\db\Command::query | SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212200)) | |
206 | 03:56:48.079 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212200)) | |
207 | 03:56:48.080 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((41069, 212200)) | |
208 | 03:56:48.082 | info | yii\db\Command::query | SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((41069, 212200)) | |
209 | 03:56:48.084 | info | yii\db\Command::query | SELECT * FROM `ut_marks` WHERE (`MarkType`=2) AND ((`PlayerID`, `MatchID`) IN ((24532, 212200))) | |
210 | 03:56:48.085 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=24532 | |
211 | 03:56:48.086 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=24532 | |
212 | 03:56:48.087 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
213 | 03:56:48.089 | info | yii\db\Command::query | SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212200)) | |
214 | 03:56:48.090 | info | yii\db\Command::query | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=1498 | |
215 | 03:56:48.091 | info | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=38) | |
216 | 03:56:48.092 | info | yii\db\Command::query | SELECT * FROM `ut_section_photos` WHERE `section_id`=175 | |
217 | 03:56:48.093 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=2634 | |
218 | 03:56:48.095 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=1715 | |
219 | 03:56:48.096 | info | yii\db\Command::query | SELECT * FROM `ut_match_statuses` WHERE `StatusID`=4 | |
220 | 03:56:48.097 | info | yii\db\Command::query | SELECT * FROM `ut_tours` WHERE `TourID`=26 | |
221 | 03:56:48.099 | info | yii\db\Command::query | SELECT * FROM `ut_reglaments` WHERE `ReglamentID`=1944 | |
222 | 03:56:48.100 | info | yii\db\Command::query | SELECT * FROM `ut_match_bookmaker_links` WHERE (`match_id`=212200) AND (`bookmaker_id`=6) ORDER BY `type` | |
223 | 03:56:48.103 | info | yii\db\Command::query | SELECT COUNT(*) FROM `ut_matches` WHERE (`ReglamentID`=1944) AND (NOT (`PlayoffPosition` IS NULL)) | |
224 | 03:56:48.105 | info | yii\db\Command::query | SELECT * FROM `ut_judges` WHERE `JudgeID`=2839 | |
225 | 03:56:48.106 | info | yii\db\Command::query | SELECT * FROM `ut_seasons` WHERE `SeasonID`=55 | |
226 | 03:56:48.107 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums` WHERE `StadiumID`=1929 | |
227 | 03:56:48.108 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums_names` WHERE (`0`, `1`) IN ((1929, 1929)) | |
228 | 03:56:48.109 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
229 | 03:56:48.111 | info | yii\db\Command::query | SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212183)) | |
230 | 03:56:48.112 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212183)) | |
231 | 03:56:48.113 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((41069, 212183)) | |
232 | 03:56:48.115 | info | yii\db\Command::query | SELECT * FROM `ut_marks` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212183)) | |
233 | 03:56:48.116 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=41069 | |
234 | 03:56:48.117 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
235 | 03:56:48.119 | info | yii\db\Command::query | SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((41069, 212183)) | |
236 | 03:56:48.120 | info | yii\db\Command::query | SELECT * FROM `ut_marks` WHERE (`MarkType`=2) AND ((`PlayerID`, `MatchID`) IN ((62723, 212183))) | |
237 | 03:56:48.121 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=62723 | |
238 | 03:56:48.122 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
239 | 03:56:48.124 | info | yii\db\Command::query | SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212183)) | |
240 | 03:56:48.125 | info | yii\db\Command::query | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=1498 | |
241 | 03:56:48.126 | info | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=38) | |
242 | 03:56:48.127 | info | yii\db\Command::query | SELECT * FROM `ut_section_photos` WHERE `section_id`=175 | |
243 | 03:56:48.128 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=1715 | |
244 | 03:56:48.129 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=12854408 | |
245 | 03:56:48.131 | info | yii\db\Command::query | SELECT * FROM `ut_match_statuses` WHERE `StatusID`=4 | |
246 | 03:56:48.132 | info | yii\db\Command::query | SELECT * FROM `ut_tours` WHERE `TourID`=25 | |
247 | 03:56:48.134 | info | yii\db\Command::query | SELECT * FROM `ut_reglaments` WHERE `ReglamentID`=1944 | |
248 | 03:56:48.135 | info | yii\db\Command::query | SELECT * FROM `ut_match_bookmaker_links` WHERE (`match_id`=212183) AND (`bookmaker_id`=6) ORDER BY `type` | |
249 | 03:56:48.138 | info | yii\db\Command::query | SELECT COUNT(*) FROM `ut_matches` WHERE (`ReglamentID`=1944) AND (NOT (`PlayoffPosition` IS NULL)) | |
250 | 03:56:48.140 | info | yii\db\Command::query | SELECT * FROM `ut_judges` WHERE `JudgeID`=2580 | |
251 | 03:56:48.141 | info | yii\db\Command::query | SELECT * FROM `ut_seasons` WHERE `SeasonID`=55 | |
252 | 03:56:48.142 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums` WHERE `StadiumID`=1930 | |
253 | 03:56:48.143 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums_names` WHERE (`0`, `1`) IN ((1930, 1930)) | |
254 | 03:56:48.144 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
255 | 03:56:48.146 | info | yii\db\Command::query | SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212180)) | |
256 | 03:56:48.147 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212180)) | |
257 | 03:56:48.148 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((41069, 212180)) | |
258 | 03:56:48.149 | info | yii\db\Command::query | SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((41069, 212180)) | |
259 | 03:56:48.150 | info | yii\db\Command::query | SELECT * FROM `ut_subs` WHERE (`PlayerID2`, `MatchID`) IN ((41069, 212180)) | |
260 | 03:56:48.151 | info | yii\db\Command::query | SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((41069, 212180)) | |
261 | 03:56:48.152 | info | yii\db\Command::query | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=1498 | |
262 | 03:56:48.153 | info | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=38) | |
263 | 03:56:48.154 | info | yii\db\Command::query | SELECT * FROM `ut_section_photos` WHERE `section_id`=175 | |
264 | 03:56:48.155 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=654 | |
265 | 03:56:48.157 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=1715 | |
266 | 03:56:48.158 | info | yii\db\Command::query | SELECT * FROM `ut_match_statuses` WHERE `StatusID`=4 | |
267 | 03:56:48.159 | info | yii\db\Command::query | SELECT * FROM `ut_tours` WHERE `TourID`=24 | |
268 | 03:56:48.161 | info | yii\db\Command::query | SELECT * FROM `ut_reglaments` WHERE `ReglamentID`=1944 | |
269 | 03:56:48.162 | info | yii\db\Command::query | SELECT * FROM `ut_match_bookmaker_links` WHERE (`match_id`=212180) AND (`bookmaker_id`=6) ORDER BY `type` | |
270 | 03:56:48.165 | info | yii\db\Command::query | SELECT COUNT(*) FROM `ut_matches` WHERE (`ReglamentID`=1944) AND (NOT (`PlayoffPosition` IS NULL)) | |
271 | 03:56:48.167 | info | yii\db\Command::query | SELECT * FROM `ut_judges` WHERE `JudgeID`=2581 | |
272 | 03:56:48.169 | info | yii\db\Command::query | SELECT * FROM `ut_seasons` WHERE `SeasonID`=55 | |
273 | 03:56:48.170 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums` WHERE `StadiumID`=1921 | |
274 | 03:56:48.171 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums_names` WHERE (`0`, `1`) IN ((1921, 1921)) | |
275 | 03:56:48.186 | info | yii\db\Command::query | SELECT `ut_marks`.* FROM `ut_marks` LEFT JOIN `ut_matches` ON `ut_marks`.`MatchID` = `ut_matches`.`MatchID` WHERE (`PlayerID`=41069) AND ((`ut_matches`.`TournamentID`=1439) AND (`ut_marks`.`MarkType` IN (1, 2))) AND (NOT (`ut_matches`.`StatusID`=0)) ORDER BY `ut_matches`.`Date` DESC, `ut_marks`.`MarkType` DESC | |
276 | 03:56:48.189 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=41069 | |
277 | 03:56:48.190 | info | yii\db\Command::query | SELECT * FROM `ut_matches` WHERE `MatchID`=200052 | |
278 | 03:56:48.191 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
279 | 03:56:48.193 | info | yii\db\Command::query | SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((41069, 200052)) | |
280 | 03:56:48.194 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((41069, 200052)) | |
281 | 03:56:48.195 | info | yii\db\Command::query | SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((41069, 200052)) | |
282 | 03:56:48.196 | info | yii\db\Command::query | SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((41069, 200052)) | |
283 | 03:56:48.197 | info | yii\db\Command::query | SELECT * FROM `ut_marks` WHERE (`MarkType`=2) AND ((`PlayerID`, `MatchID`) IN ((95023, 200052))) | |
284 | 03:56:48.198 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=95023 | |
285 | 03:56:48.200 | info | yii\db\Command::query | SELECT * FROM `ut_players` WHERE `PlayerID`=95023 | |
286 | 03:56:48.201 | info | yii\db\Command::query | SELECT * FROM `ut_teams` WHERE `TeamID`=1715 | |
287 | 03:56:48.202 | info | yii\db\Command::query | SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((41069, 200052)) | |
288 | 03:56:48.203 | info | yii\db\Command::query | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=1439 | |
289 | 03:56:48.204 | info | yii\db\Command::query | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=75) | |
290 | 03:56:48.205 | info | yii\db\Command::query | SELECT * FROM `ut_section_photos` WHERE `section_id`=49 | |
291 | 03:56:48.207 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=1715 | |
292 | 03:56:48.208 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=253 | |
293 | 03:56:48.209 | info | yii\db\Command::query | SELECT * FROM `ut_match_statuses` WHERE `StatusID`=4 | |
294 | 03:56:48.210 | info | yii\db\Command::query | SELECT * FROM `ut_tours` WHERE `TourID`=104 | |
295 | 03:56:48.212 | info | yii\db\Command::query | SELECT * FROM `ut_matches` WHERE `MatchID`=200052 | |
296 | 03:56:48.213 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=1715 | |
297 | 03:56:48.215 | info | yii\db\Command::query | SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=253 | |
298 | 03:56:48.218 | info | yii\db\Command::query | SELECT * FROM `ut_matches` WHERE (((`TeamID1`=1715) AND (`TeamID2`=253)) OR ((`TeamID1`=253) AND (`TeamID2`=1715))) AND (`StatusID` IN (4, 10, 11)) ORDER BY `Date` DESC | |
299 | 03:56:48.220 | info | yii\db\Command::query | SELECT * FROM `ut_matches` WHERE (((`TeamID1`=1715) AND (`TeamID2`=253)) OR ((`TeamID1`=253) AND (`TeamID2`=1715))) AND (NOT (`StatusID` IN (4, 10, 11, 9, 8))) ORDER BY `Date` | |
300 | 03:56:48.225 | info | yii\db\Command::query | SELECT * FROM `ut_reglaments` WHERE `ReglamentID`=1885 | |
301 | 03:56:48.226 | info | yii\db\Command::query | SELECT * FROM `ut_match_bookmaker_links` WHERE (`match_id`=200052) AND (`bookmaker_id`=6) ORDER BY `type` | |
302 | 03:56:48.228 | info | yii\db\Command::query | SELECT COUNT(*) FROM `ut_matches` WHERE (`ReglamentID`=1885) AND (NOT (`GroupID` IS NULL)) | |
303 | 03:56:48.232 | info | yii\db\Command::query | SELECT * FROM `ut_judges` WHERE `JudgeID`=465 | |
304 | 03:56:48.233 | info | yii\db\Command::query | SELECT * FROM `ut_seasons` WHERE `SeasonID`=55 | |
305 | 03:56:48.234 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums` WHERE `StadiumID`=1930 | |
306 | 03:56:48.235 | info | yii\db\Command::query | SELECT * FROM `ut_stadiums_names` WHERE (`0`, `1`) IN ((1930, 1930)) | |
307 | 03:56:48.239 | info | yii\db\Command::query | SELECT * FROM `nut_default_params` WHERE `name`='keywords' | |
308 | 03:56:48.241 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
309 | 03:56:48.242 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=57 | |
310 | 03:56:48.243 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=300 | |
311 | 03:56:48.244 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=300 | |
312 | 03:56:48.245 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
313 | 03:56:48.247 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
314 | 03:56:48.248 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
315 | 03:56:48.249 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
316 | 03:56:48.251 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=17 | |
317 | 03:56:48.252 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=303 | |
318 | 03:56:48.253 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=303 | |
319 | 03:56:48.254 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
320 | 03:56:48.255 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=17 | |
321 | 03:56:48.256 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=599 | |
322 | 03:56:48.257 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=599 | |
323 | 03:56:48.258 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_17' | |
324 | 03:56:48.263 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
325 | 03:56:48.265 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=1 | |
326 | 03:56:48.266 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=5 | |
327 | 03:56:48.267 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=5 | |
328 | 03:56:48.268 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
329 | 03:56:48.269 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=1 | |
330 | 03:56:48.270 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=598 | |
331 | 03:56:48.271 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=598 | |
332 | 03:56:48.272 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' | |
333 | 03:56:48.273 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
334 | 03:56:48.275 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=16 | |
335 | 03:56:48.276 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=159 | |
336 | 03:56:48.277 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=159 | |
337 | 03:56:48.278 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
338 | 03:56:48.279 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=16 | |
339 | 03:56:48.281 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=597 | |
340 | 03:56:48.282 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=597 | |
341 | 03:56:48.283 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_16' | |
342 | 03:56:48.284 | info | yii\db\Command::query | SELECT * FROM `robot_agent` | |
343 | 03:56:48.292 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
344 | 03:56:48.293 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=48 | |
345 | 03:56:48.294 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=305 | |
346 | 03:56:48.295 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=305 | |
347 | 03:56:48.296 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
348 | 03:56:48.297 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_48' | |
349 | 03:56:48.302 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
350 | 03:56:48.304 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `desktop_column_order`=3 ORDER BY `desktop_block_order` | |
351 | 03:56:48.307 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
352 | 03:56:48.309 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=3 | |
353 | 03:56:48.310 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=6 | |
354 | 03:56:48.311 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=6 | |
355 | 03:56:48.312 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
356 | 03:56:48.313 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=3 | |
357 | 03:56:48.314 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=600 | |
358 | 03:56:48.315 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=600 | |
359 | 03:56:48.316 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_3' | |
360 | 03:56:48.317 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name` IN ('main_news', 'ads3', 'ads4', 'ads2', 'ads30', 'ads', 'ads62', 'ads63') | |
361 | 03:56:48.319 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
362 | 03:56:48.320 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=3 | |
363 | 03:56:48.321 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=6 | |
364 | 03:56:48.322 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=6 | |
365 | 03:56:48.323 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
366 | 03:56:48.325 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=3 | |
367 | 03:56:48.326 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=600 | |
368 | 03:56:48.327 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=600 | |
369 | 03:56:48.328 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_3' | |
370 | 03:56:48.329 | info | yii\db\Command::query | SELECT * FROM `robot_agent` | |
371 | 03:56:48.331 | info | yii\db\Command::query | SELECT * FROM `robot_agent` | |
372 | 03:56:48.333 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
373 | 03:56:48.334 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
374 | 03:56:48.336 | info | yii\db\Command::query | SELECT * FROM `ad_places` WHERE `id`=11 | |
375 | 03:56:48.337 | info | yii\db\Command::query | SELECT * FROM `ad_photos` WHERE `ad_id`=4 | |
376 | 03:56:48.338 | info | yii\db\Command::query | SELECT * FROM `ad_logos` WHERE `ad_id`=4 | |
377 | 03:56:48.339 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) | |
378 | 03:56:48.340 | info | yii\db\Command::query | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_11' | |
379 | 03:56:48.342 | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) | |
380 | 03:56:48.344 | < 1ms > | info | 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-15 03:56:48') AND ((`end_date` >= '2025-03-15 03:56:48') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |