08:48:22.946 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
08:48:22.947 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\user\Bootstrap::bootstrap() |
08:48:22.947 | trace | yii\base\Module::getModule | Loading module: user |
08:48:22.948 | trace | yii\redis\Connection::open | Opening redis DB connection: localhost:6379, database=3 |
08:48:22.948 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: AUTH |
08:48:22.948 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
08:48:22.948 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:22.950 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\team\Bootstrap::bootstrap() |
08:48:22.950 | trace | yii\base\Module::getModule | Loading module: team |
08:48:22.950 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\tournament\Bootstrap::bootstrap() |
08:48:22.950 | trace | yii\base\Module::getModule | Loading module: tournament |
08:48:22.950 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\player\Bootstrap::bootstrap() |
08:48:22.950 | trace | yii\base\Module::getModule | Loading module: player |
08:48:22.950 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\hdbk\Bootstrap::bootstrap() |
08:48:22.950 | trace | yii\base\Module::getModule | Loading module: hdbk |
08:48:22.950 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\match\Bootstrap::bootstrap() |
08:48:22.950 | trace | yii\base\Module::getModule | Loading module: match |
08:48:22.950 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\redaction\Bootstrap::bootstrap() |
08:48:22.950 | trace | yii\base\Module::getModule | Loading module: redaction |
08:48:22.950 | trace | yii\base\Module::getModule | Loading module: debug |
08:48:22.952 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
08:48:22.952 | trace | yii\base\Module::getModule | Loading module: gii |
08:48:22.952 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
08:48:22.953 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=bsr |
08:48:22.954 | info | yii\db\Command::query | SELECT * FROM `hdbk_competition` WHERE `alias`='tournaments' |
08:48:22.954 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `alias`='cup_russia-2011-main' |
08:48:22.955 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:22.956 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:22.956 | trace | yii\web\Application::handleRequest | Route requested: 'tournament/frontend/tables/index' |
08:48:22.957 | trace | yii\base\Controller::runAction | Route to run: tournament/frontend/tables/index |
08:48:22.957 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=67 |
08:48:22.958 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=67 ORDER BY `start_dt` DESC) `c` |
08:48:22.960 | info | yii\db\Command::query | SELECT * FROM `round` WHERE `tournament_id`=67 ORDER BY `order` |
08:48:22.963 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:22.963 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `round` |
08:48:22.964 | info | yii\db\Command::query | SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.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 = 'round' AND kcu.table_name = 'round' |
08:48:22.965 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:22.965 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
08:48:22.965 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\tournament\controllers\frontend\TablesController::actionIndex() |
08:48:22.965 | info | yii\db\Command::query | SELECT `match`.* FROM `match` INNER JOIN `round` ON round.round_id = match.round_id WHERE round.tournament_id = 67 ORDER BY `match`.`start_dt` DESC |
08:48:22.968 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:22.968 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:22.968 | info | yii\db\Command::query | SELECT * FROM `round` WHERE `round_id`=1161 |
08:48:22.969 | info | yii\db\Command::query | SELECT * FROM `round` WHERE (`type_id` IN (3, 4)) AND (`tournament_id`=67) ORDER BY `round`.`order`, `round`.`name` |
08:48:22.969 | info | yii\db\Command::query | SELECT COUNT(*) FROM `round_team` WHERE `round_id`=1161 |
08:48:22.972 | info | yii\db\Command::query | SELECT * FROM `round_tree` WHERE `round_id`=1161 ORDER BY `target` |
08:48:22.974 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:22.974 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `round_tree` |
08:48:22.975 | info | yii\db\Command::query | SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.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 = 'round_tree' AND kcu.table_name = 'round_tree' |
08:48:22.976 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:22.976 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
08:48:22.976 | info | yii\db\Command::query | SELECT * FROM `round_tour` WHERE `round_id`=1161 ORDER BY `tour_number` |
08:48:22.982 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:22.982 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `round_tour` |
08:48:22.983 | info | yii\db\Command::query | SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.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 = 'round_tour' AND kcu.table_name = 'round_tour' |
08:48:22.983 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:22.983 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
08:48:22.984 | info | yii\db\Command::query | SELECT `match_series`.* FROM `match_series` INNER JOIN `match` ON `match_series`.`series_id` = `match`.`series_id` INNER JOIN `round_tour` ON `match_series`.`tour_id` = `round_tour`.`tour_id` WHERE `match_series`.`tree_id`=501 ORDER BY `round_tour`.`tour_number`, `match`.`start_dt` |
08:48:22.995 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:22.995 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `match_series` |
08:48:22.997 | info | yii\db\Command::query | SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.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 = 'match_series' AND kcu.table_name = 'match_series' |
08:48:22.997 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:22.997 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
08:48:23.041 | info | yii\db\Command::query | SELECT * FROM `match` WHERE `series_id` IN (1578, 1576, 1577, 1572, 1573, 1575, 1574) |
08:48:23.063 | info | yii\db\Command::query | SELECT * FROM `round_tour` WHERE `tour_id` IN (6173, 6172, 6171) |
08:48:23.064 | info | yii\db\Command::query | SELECT `match_series`.* FROM `match_series` INNER JOIN `round_tour` ON `match_series`.`tour_id` = `round_tour`.`tour_id` WHERE (`tour_number`=1) AND (`match_series`.`tree_id`=501) |
08:48:23.066 | info | yii\db\Command::query | SELECT * FROM `match_series` WHERE `series_id`=1576 |
08:48:23.067 | info | yii\db\Command::query | SELECT * FROM `match_series` WHERE `series_id`=1577 |
08:48:23.067 | info | yii\db\Command::query | SELECT * FROM `round_tour` WHERE (`tour_number`=1) AND (`tour_id`=6173) |
08:48:23.068 | info | yii\db\Command::query | SELECT * FROM `match_series` WHERE `series_id`=1572 |
08:48:23.068 | info | yii\db\Command::query | SELECT * FROM `match_series` WHERE `series_id`=1575 |
08:48:23.069 | info | yii\db\Command::query | SELECT * FROM `match_series` WHERE `series_id`=1573 |
08:48:23.069 | info | yii\db\Command::query | SELECT * FROM `match_series` WHERE `series_id`=1574 |
08:48:23.070 | info | yii\db\Command::query | SELECT `match_series`.* FROM `match_series` INNER JOIN `match` ON `match_series`.`series_id` = `match`.`series_id` INNER JOIN `round_tour` ON `match_series`.`tour_id` = `round_tour`.`tour_id` WHERE `match_series`.`tree_id`=502 ORDER BY `round_tour`.`tour_number`, `match`.`start_dt` |
08:48:23.081 | info | yii\db\Command::query | SELECT * FROM `match` WHERE `series_id`=1579 |
08:48:23.097 | info | yii\db\Command::query | SELECT * FROM `round_tour` WHERE `tour_id`=6174 |
08:48:23.097 | info | yii\db\Command::query | SELECT `match_series`.* FROM `match_series` INNER JOIN `round_tour` ON `match_series`.`tour_id` = `round_tour`.`tour_id` WHERE (`tour_number`=1) AND (`match_series`.`tree_id`=502) |
08:48:23.099 | info | yii\db\Command::query | SELECT * FROM `match_series` WHERE `series_id`=1576 |
08:48:23.100 | info | yii\db\Command::query | SELECT * FROM `match_series` WHERE `series_id`=1577 |
08:48:23.100 | info | yii\db\Command::query | SELECT * FROM `round_tour` WHERE (`tour_number`=1) AND (`tour_id`=6174) |
08:48:23.101 | info | yii\db\Command::query | SELECT * FROM `round` WHERE (`type_id` IN (3, 4)) AND (`tournament_id`=67) ORDER BY `order`, `name` |
08:48:23.102 | info | yii\db\Command::query | SELECT * FROM `round_tree` WHERE `round_id`=1161 |
08:48:23.102 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM `round` WHERE ((`type_id` IN (1, 2)) OR (((`type_id`=5) AND (`has_table`=1)))) AND (`tournament_id`=67) ORDER BY `order`, `name`) `c` |
08:48:23.103 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/playoff.php |
08:48:23.104 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/_tabs.php |
08:48:23.104 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=67 |
08:48:23.106 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/playoff.php |
08:48:23.106 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=67 |
08:48:23.107 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_grid.php |
08:48:23.107 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_match.php |
08:48:23.107 | info | yii\db\Command::query | SELECT * FROM `match` WHERE `series_id`=1572 |
08:48:23.126 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.126 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=49 |
08:48:23.127 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.127 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:23.128 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=49) ORDER BY `since` DESC |
08:48:23.128 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE `tournament_id`=67 |
08:48:23.129 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.129 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `tournament_team` |
08:48:23.130 | info | yii\db\Command::query | SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.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 = 'tournament_team' AND kcu.table_name = 'tournament_team' |
08:48:23.131 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:23.131 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
08:48:23.132 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=67 |
08:48:23.133 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.133 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=160 |
08:48:23.134 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=160) ORDER BY `since` DESC |
08:48:23.134 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_match.php |
08:48:23.134 | info | yii\db\Command::query | SELECT * FROM `match` WHERE `series_id`=1575 |
08:48:23.152 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.152 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
08:48:23.153 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=29) ORDER BY `since` DESC |
08:48:23.153 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.153 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=3 |
08:48:23.154 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=3) ORDER BY `since` DESC |
08:48:23.154 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_match.php |
08:48:23.154 | info | yii\db\Command::query | SELECT * FROM `match` WHERE `series_id`=1573 |
08:48:23.169 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.169 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=50 |
08:48:23.170 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=50) ORDER BY `since` DESC |
08:48:23.171 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.171 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=92 |
08:48:23.172 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=92) ORDER BY `since` DESC |
08:48:23.172 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_match.php |
08:48:23.172 | info | yii\db\Command::query | SELECT * FROM `match` WHERE `series_id`=1574 |
08:48:23.190 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.190 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=89 |
08:48:23.191 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=89) ORDER BY `since` DESC |
08:48:23.191 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.191 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=162 |
08:48:23.192 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=162) ORDER BY `since` DESC |
08:48:23.192 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_match.php |
08:48:23.192 | info | yii\db\Command::query | SELECT * FROM `match` WHERE `series_id`=1576 |
08:48:23.208 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.208 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=49 |
08:48:23.209 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=49) ORDER BY `since` DESC |
08:48:23.210 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.210 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
08:48:23.211 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=29) ORDER BY `since` DESC |
08:48:23.211 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_match.php |
08:48:23.211 | info | yii\db\Command::query | SELECT * FROM `match` WHERE `series_id`=1577 |
08:48:23.229 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.230 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=50 |
08:48:23.230 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=50) ORDER BY `since` DESC |
08:48:23.231 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.231 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=162 |
08:48:23.232 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=162) ORDER BY `since` DESC |
08:48:23.232 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_match.php |
08:48:23.232 | info | yii\db\Command::query | SELECT * FROM `match` WHERE `series_id`=1578 |
08:48:23.249 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.249 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
08:48:23.250 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=29) ORDER BY `since` DESC |
08:48:23.250 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.250 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=50 |
08:48:23.251 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=50) ORDER BY `since` DESC |
08:48:23.251 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_match.php |
08:48:23.251 | info | yii\db\Command::query | SELECT * FROM `match` WHERE `series_id`=1579 |
08:48:23.252 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.252 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=49 |
08:48:23.252 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=49) ORDER BY `since` DESC |
08:48:23.253 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_team-row.php |
08:48:23.253 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=162 |
08:48:23.253 | info | yii\db\Command::query | SELECT * FROM `team_history` WHERE (`since` <= '2011-09-26') AND ((`to` IS NULL) OR (`to` >= '2011-09-26')) AND (`team_id`=162) ORDER BY `since` DESC |
08:48:23.254 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/calendar.php |
08:48:23.254 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_calendar-table.php |
08:48:23.254 | info | yii\db\Command::query | SELECT * FROM `round` WHERE `round_id`=1161 |
08:48:23.255 | info | yii\db\Command::query | SELECT * FROM `round_tree` WHERE `tree_id`=501 |
08:48:23.255 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_calendar-matches.php |
08:48:23.256 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=49 |
08:48:23.257 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=160 |
08:48:23.258 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=50 |
08:48:23.259 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=92 |
08:48:23.260 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
08:48:23.261 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=3 |
08:48:23.262 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=89 |
08:48:23.263 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=162 |
08:48:23.263 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_calendar-table.php |
08:48:23.263 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_calendar-matches.php |
08:48:23.264 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=49 |
08:48:23.264 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
08:48:23.266 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=50 |
08:48:23.266 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=162 |
08:48:23.267 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_calendar-table.php |
08:48:23.267 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_calendar-matches.php |
08:48:23.267 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
08:48:23.268 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=50 |
08:48:23.268 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_calendar-table.php |
08:48:23.268 | info | yii\db\Command::query | SELECT * FROM `round_tree` WHERE `tree_id`=502 |
08:48:23.269 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/tables/blocks/playoff/_calendar-matches.php |
08:48:23.269 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=49 |
08:48:23.269 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=162 |
08:48:23.270 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/layouts/frontend/default.php |
08:48:23.270 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=65 |
08:48:23.271 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `parent_tournament_id`=65 ORDER BY `start_dt` DESC |
08:48:23.272 | info | yii\db\Command::query | SELECT `match`.`start_dt` FROM `match` INNER JOIN `tournament` ON `match`.`tournament_id` = `tournament`.`tournament_id` WHERE (`match`.`start_dt` < '2025-01-16 05:00:00') AND (`tournament`.`in_schedule`=1) AND (`tournament`.`is_published`=1) AND (`tournament`.`in_ru`=1) AND (`tournament`.`tournament_id` IN (67, 66)) ORDER BY `match`.`start_dt` DESC LIMIT 1 |
08:48:23.294 | info | yii\db\Command::query | SELECT `match`.`start_dt` FROM `match` INNER JOIN `tournament` ON `match`.`tournament_id` = `tournament`.`tournament_id` WHERE (`match`.`start_dt` > '2025-01-17 05:00:00') AND (`tournament`.`in_schedule`=1) AND (`tournament`.`is_published`=1) AND (`tournament`.`in_ru`=1) AND (`tournament`.`tournament_id` IN (67, 66)) ORDER BY `match`.`start_dt` LIMIT 1 |
08:48:23.295 | info | yii\db\Command::query | SELECT `tournament`.* FROM `tournament` INNER JOIN `match` ON `tournament`.`tournament_id` = `match`.`tournament_id` WHERE (`tournament`.`in_ru`=1) AND (`tournament`.`is_published`=1) AND (`tournament`.`in_schedule`=1) AND ((`tournament`.`tournament_id` IN (67, 66)) OR (`tournament`.`parent_tournament_id` IN (67, 66))) AND ((NOT (`match`.`start_dt` IS NULL)) AND ((NOT (`team1_id` IS NULL)) OR (NOT (`team1_placeholder` IS NULL))) AND ((NOT (`team2_id` IS NULL)) OR (NOT (`team2_placeholder` IS NULL))) AND (`match`.`start_dt` BETWEEN '2025-01-16 05:00:00' AND '2025-01-17 05:00:00')) ORDER BY `tournament`.`order`, `tournament`.`full_name` |
08:48:23.297 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/Scoreboard/views/widget.php |
08:48:23.297 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/layouts/frontend/blocks/_tournament-header.php |
08:48:23.297 | info | yii\db\Command::query | SELECT * FROM `hdbk_competition` WHERE `competition_id`=6 |
08:48:23.298 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.298 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `hdbk_competition` |
08:48:23.299 | info | yii\db\Command::query | SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.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 = 'hdbk_competition' AND kcu.table_name = 'hdbk_competition' |
08:48:23.300 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:23.300 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
08:48:23.300 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/layouts/frontend/blocks/_tournament-filter.php |
08:48:23.300 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.301 | info | yii\db\Command::query | SELECT `hdbk_season`.* FROM `hdbk_season` INNER JOIN `tournament` ON `hdbk_season`.`season_id` = `tournament`.`season_id` WHERE (`tournament`.`competition_id`=6) AND (`tournament`.`is_published`=1) ORDER BY `start_dt` DESC, `season_id` DESC, `order` |
08:48:23.304 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.304 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:23.306 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`tournament`.`is_published`=1) AND (`season_id` IN (24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13)) ORDER BY `order` |
08:48:23.418 | info | yii\db\Command::query | SELECT * FROM `hdbk_season` WHERE `season_id`=16 |
08:48:23.418 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=16) AND (`parent_tournament_id` IS NULL) AND (`is_published`=1) AND (`tournament`.`in_ru`=1) AND (`competition_id`=6) ORDER BY isnull(`order`), `order`, `start_dt` DESC |
08:48:23.419 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=24) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.420 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=558 |
08:48:23.421 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=23) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.422 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=437 |
08:48:23.423 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=22) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.424 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=366 |
08:48:23.424 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=21) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.427 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=288 |
08:48:23.428 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=20) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.429 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=159 |
08:48:23.429 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=19) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.431 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=105 |
08:48:23.432 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=18) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.433 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=19 |
08:48:23.434 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=17) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.436 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=70 |
08:48:23.436 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=16) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.438 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=15) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.438 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=64 |
08:48:23.439 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=14) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.440 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=174 |
08:48:23.441 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=13) AND (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
08:48:23.442 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=62 |
08:48:23.442 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=65 ORDER BY `start_dt` DESC) `c` |
08:48:23.443 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `parent_tournament_id`=65 ORDER BY `start_dt` DESC |
08:48:23.444 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`parent_tournament_id`=65) ORDER BY `start_dt` DESC |
08:48:23.445 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/frontend/common/_tournaments-select.php |
08:48:23.446 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=66 |
08:48:23.446 | info | yii\db\Command::query | SELECT MAX(updated_at) FROM tournament |
08:48:23.447 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
08:48:23.448 | info | yii\db\Command::query | SELECT * FROM `tournament_place` WHERE (`main`=1) AND (`tournament_id`=67) |
08:48:23.449 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.449 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `tournament_place` |
08:48:23.450 | info | yii\db\Command::query | SELECT
kcu.constraint_name,
kcu.column_name,
kcu.referenced_table_name,
kcu.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 = 'tournament_place' AND kcu.table_name = 'tournament_place' |
08:48:23.450 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:23.450 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
08:48:23.450 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=219 |
08:48:23.451 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.451 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:23.451 | info | yii\db\Command::query | SELECT * FROM `hdbk_city` WHERE `city_id`=18076 |
08:48:23.451 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.451 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:23.452 | info | yii\db\Command::query | SELECT `tournament_team`.* FROM `tournament_team` LEFT JOIN `team` ON `tournament_team`.`team_id` = `team`.`team_id` WHERE (`status`='approved') AND (`tournament_team`.`tournament_id`=67) |
08:48:23.453 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id` IN (3, 7, 8, 29, 49, 50, 55, 89, 92, 99, 157, 158, 159, 160, 161, 162) |
08:48:23.458 | info | yii\db\Command::query | SELECT `tournament_team`.* FROM `tournament_team` LEFT JOIN `team` ON `tournament_team`.`team_id` = `team`.`team_id` WHERE (`status`='approved') AND (`tournament_team`.`tournament_id`=67) |
08:48:23.459 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id` IN (3, 7, 8, 29, 49, 50, 55, 89, 92, 99, 157, 158, 159, 160, 161, 162) |
08:48:23.464 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM `team` WHERE `team_id` IN (3, 7, 8, 29, 49, 50, 55, 89, 92, 99, 157, 158, 159, 160, 161, 162) ORDER BY `full_name`) `c` |
08:48:23.465 | info | yii\db\Command::query | SELECT * FROM `tag` WHERE (`module`='tournament') AND (`item_id`=67) |
08:48:23.465 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.465 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:23.466 | info | yii\db\Command::query | SELECT EXISTS(SELECT `post`.* FROM `post` INNER JOIN `post_tag_assn` ON post_tag_assn.post_id = post.post_id WHERE (`post`.`type`='news') AND (`post`.`in_ru`=1) AND (`post`.`is_public`=1) AND (`post_tag_assn`.`tag_id`=67)) |
08:48:23.466 | info | yii\db\Command::query | SELECT EXISTS(SELECT `post`.* FROM `post` INNER JOIN `post_tag_assn` ON post_tag_assn.post_id = post.post_id WHERE (`post`.`type`='article') AND (`post`.`in_ru`=1) AND (`post`.`is_public`=1) AND (`post_tag_assn`.`tag_id`=67)) |
08:48:23.467 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/SocialSidebar/views/social-sidebar.php |
08:48:23.467 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/SocialShare/views/social-share.php |
08:48:23.468 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/default.php |
08:48:23.468 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/blocks/_header.php |
08:48:23.468 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.469 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:23.469 | info | yii\db\Command::query | SELECT * FROM `settings` WHERE `id`=1 |
08:48:23.469 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.469 | info | yii\db\Command::query | SELECT
COUNT(*)
FROM
hdbk_competition AS c
INNER JOIN
tournament AS t ON t.competition_id = c.competition_id
INNER JOIN
round AS r ON r.tournament_id = t.tournament_id |
08:48:23.470 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/blocks/_footer.php |
08:48:23.470 | info | yii\db\Command::query | SELECT * FROM `page` WHERE `page`.`alias`='confidentiality' |
08:48:23.470 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
08:48:23.471 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
08:48:23.471 | info | yii\db\Command::query | SELECT * FROM `page` WHERE `page`.`alias`='use_info' |
08:48:23.471 | info | yii\db\Command::query | SELECT COUNT(*) FROM `partner` |
08:48:23.471 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/blocks/_socials.php |
08:48:23.472 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/YandexMetrika/views/yandex-metrika.php |
08:48:23.472 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/LiveInternet/views/live-internet.php |