07:55:44.408 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
07:55:44.408 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\user\Bootstrap::bootstrap() |
07:55:44.408 | trace | yii\base\Module::getModule | Loading module: user |
07:55:44.409 | trace | yii\redis\Connection::open | Opening redis DB connection: localhost:6379, database=3 |
07:55:44.410 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: AUTH |
07:55:44.410 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
07:55:44.410 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.412 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\team\Bootstrap::bootstrap() |
07:55:44.412 | trace | yii\base\Module::getModule | Loading module: team |
07:55:44.412 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\tournament\Bootstrap::bootstrap() |
07:55:44.412 | trace | yii\base\Module::getModule | Loading module: tournament |
07:55:44.412 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\player\Bootstrap::bootstrap() |
07:55:44.412 | trace | yii\base\Module::getModule | Loading module: player |
07:55:44.412 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\hdbk\Bootstrap::bootstrap() |
07:55:44.412 | trace | yii\base\Module::getModule | Loading module: hdbk |
07:55:44.412 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\match\Bootstrap::bootstrap() |
07:55:44.412 | trace | yii\base\Module::getModule | Loading module: match |
07:55:44.412 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\redaction\Bootstrap::bootstrap() |
07:55:44.412 | trace | yii\base\Module::getModule | Loading module: redaction |
07:55:44.412 | trace | yii\base\Module::getModule | Loading module: debug |
07:55:44.414 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
07:55:44.414 | trace | yii\base\Module::getModule | Loading module: gii |
07:55:44.414 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
07:55:44.414 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=bsr |
07:55:44.415 | info | yii\db\Command::query | SELECT * FROM `hdbk_competition` WHERE `alias`='tournaments' |
07:55:44.416 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `alias`='alanya_beach_soccer_cup-2018-alanya_2018' |
07:55:44.421 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.421 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.422 | trace | yii\web\Application::handleRequest | Route requested: 'tournament/frontend/stats/index' |
07:55:44.422 | trace | yii\base\Controller::runAction | Route to run: tournament/frontend/stats/index |
07:55:44.422 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.423 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=451 ORDER BY `start_dt` DESC) `c` |
07:55:44.424 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=450 |
07:55:44.425 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `parent_tournament_id`=450 ORDER BY `start_dt` DESC |
07:55:44.427 | info | yii\db\Command::query | SELECT `stats_player`.`player_id`, `stats_player`.`team_id`, `stats_player`.`tournament_id`, SUM(stats_player.games) AS `games`, SUM(stats_player.gk_games) AS `gk_games`, SUM(stats_player.gk_minutes) AS `gk_minutes`, SUM(stats_player.goals) AS `goals`, SUM(stats_player.missed_goals) AS `missed_goals`, ROUND(SUM(stats_player.gk_minutes) / SUM(stats_player.missed_goals), 2) AS `missed_goals_avg`, SUM(stats_player.saves) AS `saves`, SUM(stats_player.shootouts) AS `shootouts`, SUM(stats_player.assists_hand) AS `assists_hand`, SUM(stats_player.assists_foot) AS `assists_foot`, SUM(stats_player.penalties) AS `penalties`, SUM(stats_player.assists) + SUM(stats_player.second_assists) AS `sumassists`, SUM(stats_player.assists) AS `assists`, SUM(stats_player.second_assists) AS `second_assists`, SUM(stats_player.yellow_cards) AS `yellow_cards`, SUM(stats_player.second_yellow_cards) AS `second_yellow_cards`, SUM(stats_player.red_cards) - SUM(stats_player.second_yellow_cards) AS `red_cards`, SUM(stats_player.autogoals) AS `autogoals`, SUM(stats_player.shoots) AS `shoots`, SUM(stats_player.freekicks) AS `freekicks`, SUM(stats_player.biciclets) AS `biciclets`, SUM(stats_player.corners) AS `corners`, SUM(stats_player.shoots_block) AS `shoots_block`, SUM(stats_player.shoots_bar) + SUM(stats_player.shoots_crossbar) AS `shoots_postbar`, ROUND(SUM(stats_player.goals) / SUM(stats_player.shoots), 4) * 100 AS `shoots_percent`, SUM(stats_player.red_cards) * 3 + SUM(stats_player.yellow_cards) AS `penalty`, SUM(stats_player.goals) + SUM(stats_player.assists) + SUM(stats_player.second_assists) AS `score`, SUM(stats_player.best_match_player) AS `best_match_player`, SUM(stats_player.best_team_player) AS `best_team_player` FROM `stats_player` WHERE `stats_player`.`tournament_id`=451 GROUP BY `stats_player`.`round_id` ORDER BY `score` DESC, `goals` DESC, `games`, `sumassists` DESC, `penalty` |
07:55:44.431 | info | yii\db\Command::query | SELECT `referee_id`, SUM(stats_referee.games) AS `games`, SUM(stats_referee.games_second) AS `games_second`, SUM(stats_referee.games_third) AS `games_third`, SUM(stats_referee.games_chron) AS `games_chron`, SUM(stats_referee.yellow_cards) AS `yellow_cards`, SUM(stats_referee.red_cards) AS `red_cards`, AVG(stats_referee.referee_mark) AS `referee_mark`, AVG(stats_referee.discipline_mark) AS `discipline_mark` FROM `stats_referee` WHERE `stats_referee`.`tournament_id`=451 GROUP BY `stats_referee`.`round_id` ORDER BY `games` DESC, 3 * red_cards + yellow_cards DESC, `referee_mark` DESC |
07:55:44.434 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\tournament\controllers\frontend\StatsController::actionIndex() |
07:55:44.435 | info | yii\db\Command::query | SELECT `stats_player`.`player_id`, `stats_player`.`team_id`, `stats_player`.`tournament_id`, SUM(stats_player.games) AS `games`, SUM(stats_player.goals) AS `goals`, SUM(stats_player.penalties) AS `penalties` FROM `stats_player` LEFT JOIN `player` ON `stats_player`.`player_id` = `player`.`player_id` LEFT JOIN `team` ON `stats_player`.`team_id` = `team`.`team_id` LEFT JOIN `tournament_team_player` ON `stats_player`.`tournament_id` = `tournament_team_player`.`tournament_id` AND `stats_player`.`team_id` = `tournament_team_player`.`team_id` AND `stats_player`.`player_id` = `tournament_team_player`.`player_id` WHERE `stats_player`.`tournament_id`=451 GROUP BY `stats_player`.`player_id` HAVING `goals` > 0 ORDER BY `goals` DESC, `penalties`, `games`, `include_dt` |
07:55:44.437 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.437 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.438 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id` IN (95, 3877, 290, 403, 2136, 273, 2004, 1931, 1914, 264, 3575, 2576, 4450, 3615, 4441, 405, 6080, 2231, 6876, 669, 67, 117, 404, 272, 8319, 97) |
07:55:44.446 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.446 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.456 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id` IN (29, 341, 366, 342) |
07:55:44.457 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.457 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.458 | info | yii\db\Command::query | SELECT * FROM `tournament_team_player` WHERE (`tournament_id`, `team_id`, `player_id`) IN ((451, 29, 95), (451, 341, 3877), (451, 29, 290), (451, 366, 403), (451, 342, 2136), (451, 342, 273), (451, 366, 2004), (451, 341, 1931), (451, 29, 1914), (451, 29, 264), (451, 341, 3575), (451, 29, 2576), (451, 341, 4450), (451, 342, 3615), (451, 342, 4441), (451, 366, 405), (451, 366, 6080), (451, 342, 2231), (451, 341, 6876), (451, 341, 669), (451, 342, 67), (451, 29, 117), (451, 366, 404), (451, 342, 272), (451, 341, 8319), (451, 29, 97)) ORDER BY `include_dt` |
07:55:44.460 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.460 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `tournament_team_player` |
07:55:44.462 | 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_player' AND kcu.table_name = 'tournament_team_player' |
07:55:44.463 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.463 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:55:44.465 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/stats/goals.php |
07:55:44.465 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/frontend/stats/_goals-table.php |
07:55:44.465 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=219 |
07:55:44.465 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.466 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.466 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.466 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=95 |
07:55:44.467 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=3 |
07:55:44.467 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.467 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `hdbk_player_position` |
07:55:44.468 | 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_player_position' AND kcu.table_name = 'hdbk_player_position' |
07:55:44.468 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.469 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:55:44.469 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=95) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.470 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.471 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
07:55:44.472 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.473 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 29)) |
07:55:44.473 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.473 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `tournament_team` |
07:55:44.474 | 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' |
07:55:44.474 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.475 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:55:44.475 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=298 |
07:55:44.476 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.476 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=3877 |
07:55:44.477 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=4 |
07:55:44.477 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=3877) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.478 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.478 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=341 |
07:55:44.479 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 341)) |
07:55:44.479 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=219 |
07:55:44.479 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.480 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=290 |
07:55:44.480 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=2 |
07:55:44.481 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=290) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.481 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.482 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
07:55:44.483 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 29)) |
07:55:44.483 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=409 |
07:55:44.484 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.485 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=403 |
07:55:44.486 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=3 |
07:55:44.486 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=403) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.487 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.488 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=366 |
07:55:44.489 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 366)) |
07:55:44.489 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=367 |
07:55:44.490 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.490 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=2136 |
07:55:44.491 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=2 |
07:55:44.491 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=2136) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.492 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.492 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=342 |
07:55:44.493 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 342)) |
07:55:44.494 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=367 |
07:55:44.494 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.494 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=273 |
07:55:44.495 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=3 |
07:55:44.495 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=273) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.496 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.496 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=342 |
07:55:44.497 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 342)) |
07:55:44.497 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=409 |
07:55:44.497 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.498 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=2004 |
07:55:44.498 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=2 |
07:55:44.499 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=2004) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.499 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.500 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=366 |
07:55:44.500 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 366)) |
07:55:44.500 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=298 |
07:55:44.501 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.501 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=1931 |
07:55:44.501 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=4 |
07:55:44.502 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=1931) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.502 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.503 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=341 |
07:55:44.503 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 341)) |
07:55:44.504 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=219 |
07:55:44.504 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.504 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=1914 |
07:55:44.505 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=4 |
07:55:44.505 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=1914) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.506 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.507 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
07:55:44.507 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 29)) |
07:55:44.507 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=219 |
07:55:44.508 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.508 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=264 |
07:55:44.509 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=3 |
07:55:44.509 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=264) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.510 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.510 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
07:55:44.511 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 29)) |
07:55:44.511 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=298 |
07:55:44.511 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.511 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=3575 |
07:55:44.512 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=4 |
07:55:44.512 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=3575) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.513 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.513 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=341 |
07:55:44.514 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 341)) |
07:55:44.514 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=219 |
07:55:44.515 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.515 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=2576 |
07:55:44.516 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=3 |
07:55:44.516 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=2576) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.517 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.517 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
07:55:44.518 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 29)) |
07:55:44.518 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=298 |
07:55:44.518 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.518 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=4450 |
07:55:44.519 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=4 |
07:55:44.519 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=4450) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.520 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.521 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=341 |
07:55:44.521 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 341)) |
07:55:44.521 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=251 |
07:55:44.522 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.522 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=3615 |
07:55:44.523 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=3615) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.524 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.524 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=342 |
07:55:44.525 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 342)) |
07:55:44.525 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=367 |
07:55:44.525 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.526 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=4441 |
07:55:44.526 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=4 |
07:55:44.526 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=4441) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.527 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.528 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=342 |
07:55:44.528 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 342)) |
07:55:44.529 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=409 |
07:55:44.529 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.529 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=405 |
07:55:44.530 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=3 |
07:55:44.530 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=405) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.531 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.531 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=366 |
07:55:44.532 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 366)) |
07:55:44.532 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=409 |
07:55:44.532 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.532 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=6080 |
07:55:44.533 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=6080) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.534 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.534 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=366 |
07:55:44.535 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 366)) |
07:55:44.535 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=367 |
07:55:44.535 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.536 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=2231 |
07:55:44.536 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=3 |
07:55:44.536 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=2231) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.537 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.538 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=342 |
07:55:44.538 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 342)) |
07:55:44.538 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=425 |
07:55:44.539 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.539 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=6876 |
07:55:44.540 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=1 |
07:55:44.540 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=6876) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.540 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.541 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=341 |
07:55:44.541 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 341)) |
07:55:44.542 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=298 |
07:55:44.542 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.542 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=669 |
07:55:44.551 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=2 |
07:55:44.551 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=669) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.552 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.553 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=341 |
07:55:44.553 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 341)) |
07:55:44.554 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=251 |
07:55:44.554 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.554 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=67 |
07:55:44.555 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=2 |
07:55:44.555 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=67) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.556 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.556 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=342 |
07:55:44.557 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 342)) |
07:55:44.557 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=219 |
07:55:44.557 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.558 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=117 |
07:55:44.558 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=2 |
07:55:44.558 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=117) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.559 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.560 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
07:55:44.560 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 29)) |
07:55:44.560 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=409 |
07:55:44.561 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.561 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=404 |
07:55:44.562 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=3 |
07:55:44.562 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=404) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.563 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.563 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=366 |
07:55:44.564 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 366)) |
07:55:44.564 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=367 |
07:55:44.564 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.564 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=272 |
07:55:44.565 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=4 |
07:55:44.565 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=272) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.566 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.566 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=342 |
07:55:44.567 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 342)) |
07:55:44.567 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=298 |
07:55:44.567 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.568 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=8319 |
07:55:44.568 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=4 |
07:55:44.569 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=8319) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.569 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.570 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=341 |
07:55:44.570 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 341)) |
07:55:44.570 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE `country_id`=219 |
07:55:44.571 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
07:55:44.571 | info | yii\db\Command::query | SELECT * FROM `player` WHERE `player_id`=97 |
07:55:44.571 | info | yii\db\Command::query | SELECT * FROM `hdbk_player_position` WHERE `position_id`=3 |
07:55:44.572 | info | yii\db\Command::query | SELECT `tournament_team_player`.* FROM `tournament_team_player` LEFT JOIN `tournament` ON `tournament_team_player`.`tournament_id` = `tournament`.`tournament_id` WHERE (`player_id`=97) AND ((`tournament`.`tournament_id`=451) AND (`tournament_team_player`.`status`='approved')) GROUP BY `team_id` ORDER BY `include_dt` |
07:55:44.572 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=451 |
07:55:44.573 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id`=29 |
07:55:44.573 | info | yii\db\Command::query | SELECT * FROM `tournament_team` WHERE (`tournament_id`, `team_id`) IN ((451, 29)) |
07:55:44.573 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/layouts/frontend/stats.php |
07:55:44.574 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/layouts/frontend/default.php |
07:55:44.575 | 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`=451) ORDER BY `match`.`start_dt` DESC LIMIT 1 |
07:55:44.576 | 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-18 05:00:00') AND (`tournament`.`in_schedule`=1) AND (`tournament`.`is_published`=1) AND (`tournament`.`in_ru`=1) AND (`tournament`.`tournament_id`=451) ORDER BY `match`.`start_dt` LIMIT 1 |
07:55:44.576 | 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`=451) OR (`tournament`.`parent_tournament_id`=451)) 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-17 05:00:00' AND '2025-01-18 05:00:00')) ORDER BY `tournament`.`order`, `tournament`.`full_name` |
07:55:44.578 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/Scoreboard/views/widget.php |
07:55:44.578 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/layouts/frontend/blocks/_tournament-header.php |
07:55:44.579 | info | yii\db\Command::query | SELECT * FROM `hdbk_competition` WHERE `competition_id`=68 |
07:55:44.579 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.579 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `hdbk_competition` |
07:55:44.581 | 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' |
07:55:44.581 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.581 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:55:44.581 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/tournament/views/layouts/frontend/blocks/_tournament-filter.php |
07:55:44.581 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.582 | 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`=68) AND (`tournament`.`is_published`=1) ORDER BY `start_dt` DESC, `season_id` DESC, `order` |
07:55:44.585 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.585 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.585 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`tournament`.`is_published`=1) AND (`season_id` IN (23, 15)) ORDER BY `order` |
07:55:44.616 | info | yii\db\Command::query | SELECT * FROM `hdbk_season` WHERE `season_id`=23 |
07:55:44.616 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=23) AND (`parent_tournament_id` IS NULL) AND (`is_published`=1) AND (`tournament`.`in_ru`=1) AND (`competition_id`=68) ORDER BY isnull(`order`), `order`, `start_dt` DESC |
07:55:44.617 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=23) AND (`is_published`=1) AND (`competition_id`=68) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
07:55:44.618 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`season_id`=15) AND (`is_published`=1) AND (`competition_id`=68) ORDER BY `start_dt` DESC, isnull(parent_tournament_id) |
07:55:44.619 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `tournament_id`=531 |
07:55:44.619 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=450 ORDER BY `start_dt` DESC) `c` |
07:55:44.620 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `parent_tournament_id`=450 ORDER BY `start_dt` DESC |
07:55:44.621 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`parent_tournament_id`=450) ORDER BY `start_dt` DESC |
07:55:44.622 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/frontend/common/_tournaments-select.php |
07:55:44.622 | info | yii\db\Command::query | SELECT MAX(updated_at) FROM tournament |
07:55:44.623 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:55:44.624 | info | yii\db\Command::query | SELECT * FROM `tournament_place` WHERE (`main`=1) AND (`tournament_id`=451) |
07:55:44.624 | 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`=451) |
07:55:44.625 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id` IN (29, 341, 342, 366) |
07:55:44.626 | 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`=451) |
07:55:44.626 | info | yii\db\Command::query | SELECT * FROM `team` WHERE `team_id` IN (29, 341, 342, 366) |
07:55:44.628 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM `team` WHERE `team_id` IN (29, 341, 342, 366) ORDER BY `full_name`) `c` |
07:55:44.628 | info | yii\db\Command::query | SELECT * FROM `tag` WHERE (`module`='tournament') AND (`item_id`=451) |
07:55:44.631 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.631 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `tag` |
07:55:44.632 | 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 = 'tag' AND kcu.table_name = 'tag' |
07:55:44.632 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.632 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:55:44.633 | 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`=451)) |
07:55:44.634 | 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`=451)) |
07:55:44.635 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/SocialSidebar/views/social-sidebar.php |
07:55:44.635 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/SocialShare/views/social-share.php |
07:55:44.636 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/default.php |
07:55:44.636 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/blocks/_header.php |
07:55:44.636 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.636 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.636 | info | yii\db\Command::query | SELECT * FROM `settings` WHERE `id`=1 |
07:55:44.637 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.637 | 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 |
07:55:44.638 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/blocks/_footer.php |
07:55:44.638 | info | yii\db\Command::query | SELECT * FROM `page` WHERE `page`.`alias`='confidentiality' |
07:55:44.639 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:55:44.642 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:55:44.642 | info | yii\db\Command::query | SELECT * FROM `page` WHERE `page`.`alias`='use_info' |
07:55:44.643 | info | yii\db\Command::query | SELECT COUNT(*) FROM `partner` |
07:55:44.643 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/blocks/_socials.php |
07:55:44.644 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/YandexMetrika/views/yandex-metrika.php |
07:55:44.644 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/LiveInternet/views/live-internet.php |