23:00:56.485 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
23:00:56.485 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\user\Bootstrap::bootstrap() |
23:00:56.485 | trace | yii\base\Module::getModule | Loading module: user |
23:00:56.487 | trace | yii\redis\Connection::open | Opening redis DB connection: localhost:6379, database=3 |
23:00:56.487 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: AUTH |
23:00:56.488 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
23:00:56.488 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
23:00:56.489 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\team\Bootstrap::bootstrap() |
23:00:56.489 | trace | yii\base\Module::getModule | Loading module: team |
23:00:56.489 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\tournament\Bootstrap::bootstrap() |
23:00:56.489 | trace | yii\base\Module::getModule | Loading module: tournament |
23:00:56.489 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\player\Bootstrap::bootstrap() |
23:00:56.489 | trace | yii\base\Module::getModule | Loading module: player |
23:00:56.489 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\hdbk\Bootstrap::bootstrap() |
23:00:56.489 | trace | yii\base\Module::getModule | Loading module: hdbk |
23:00:56.489 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\match\Bootstrap::bootstrap() |
23:00:56.489 | trace | yii\base\Module::getModule | Loading module: match |
23:00:56.489 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\redaction\Bootstrap::bootstrap() |
23:00:56.489 | trace | yii\base\Module::getModule | Loading module: redaction |
23:00:56.489 | trace | yii\base\Module::getModule | Loading module: debug |
23:00:56.490 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
23:00:56.491 | trace | yii\base\Module::getModule | Loading module: gii |
23:00:56.491 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
23:00:56.491 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=bsr |
23:00:56.492 | info | yii\db\Command::query | SELECT * FROM `hdbk_competition` WHERE `alias`='staff' |
23:00:56.492 | info | yii\db\Command::query | SELECT * FROM `tournament` WHERE `alias`='20' |
23:00:56.496 | trace | yii\web\Application::handleRequest | Route requested: 'staff/frontend/articles/index' |
23:00:56.496 | trace | yii\base\Module::getModule | Loading module: staff |
23:00:56.500 | trace | yii\base\Controller::runAction | Route to run: staff/frontend/articles/index |
23:00:56.500 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
23:00:56.500 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `staff` |
23:00:56.502 | 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 = 'staff' AND kcu.table_name = 'staff' |
23:00:56.502 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
23:00:56.503 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
23:00:56.503 | info | yii\db\Command::query | SELECT * FROM `staff` WHERE `staff_id`=20 |
23:00:56.505 | info | yii\db\Command::query | SELECT `stats_staff`.`staff_id`, `stats_staff`.`team_id`, `stats_staff`.`tournament_id`, SUM(stats_staff.games) AS `games`, SUM(stats_staff.wins) + SUM(stats_staff.wins_ot) + SUM(stats_staff.wins_so) AS `wins`, SUM(stats_staff.draws) AS `draws`, SUM(stats_staff.losses) + SUM(stats_staff.losses_ot) + SUM(stats_staff.losses_so) AS `losses` FROM `stats_staff` WHERE `staff_id`=20 GROUP BY `stats_staff`.`staff_id` ORDER BY `wins` DESC, `draws` DESC, `games` |
23:00:56.505 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
23:00:56.505 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `stats_staff` |
23:00:56.506 | 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 = 'stats_staff' AND kcu.table_name = 'stats_staff' |
23:00:56.507 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
23:00:56.507 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
23:00:56.507 | info | yii\db\Command::query | SELECT * FROM `staff` WHERE `staff_id`=20 |
23:00:56.508 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\staff\controllers\frontend\ArticlesController::actionIndex() |
23:00:56.508 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/staff/views/frontend/articles/index.php |
23:00:56.508 | info | yii\db\Command::query | SELECT * FROM `team_staff` WHERE (`team_staff`.`status`='accepted') AND (`staff_id`=20) ORDER BY `team_staff`.`in` DESC |
23:00:56.509 | info | yii\db\Command::query | SELECT * FROM `team` WHERE 0=1 ORDER BY `team`.`is_national` DESC |
23:00:56.509 | info | yii\db\Command::query | SELECT * FROM `tag` WHERE (`module`='staff') AND (`item_id`=20) |
23:00:56.510 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
23:00:56.510 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `tag` |
23:00:56.511 | 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' |
23:00:56.512 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
23:00:56.512 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
23:00:56.513 | info | yii\db\Command::query | SELECT COUNT(*) FROM (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`=1742) ORDER BY `published_dt` DESC) `c` |
23:00:56.513 | info | yii\db\Command::query | 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`=1742) ORDER BY `published_dt` DESC LIMIT 25 |
23:00:56.515 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
23:00:56.515 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `post` |
23:00:56.517 | 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 = 'post' AND kcu.table_name = 'post' |
23:00:56.517 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
23:00:56.518 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
23:00:56.561 | info | yii\db\Command::query | SELECT * FROM `post_tag_assn` WHERE `post_id`=12135 |
23:00:56.561 | info | yii\db\Command::query | SELECT * FROM `tag` WHERE `tag_id` IN ('514', '1535', '1742', '1775') |
23:00:56.562 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/redaction/widgets/posts/views/articles.php |
23:00:56.562 | info | yii\db\Command::query | SELECT * FROM `post` WHERE `post_id`=12135 |
23:00:56.564 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/staff/views/layouts/frontend/default.php |
23:00:56.564 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/staff/views/layouts/frontend/blocks/_staff-header.php |
23:00:56.564 | info | yii\db\Command::query | SELECT COUNT(*) FROM `post` INNER JOIN `post_tag_assn` ON post_tag_assn.post_id = post.post_id WHERE (`post`.`is_public`=1) AND (`post`.`in_ru`=1) AND (`post`.`type`='article') AND (`post_tag_assn`.`tag_id`=1742) |
23:00:56.565 | info | yii\db\Command::query | SELECT COUNT(*) FROM `post` INNER JOIN `post_tag_assn` ON post_tag_assn.post_id = post.post_id WHERE (`post`.`is_public`=1) AND (`post`.`in_ru`=1) AND (`post`.`type`='news') AND (`post_tag_assn`.`tag_id`=1742) |
23:00:56.566 | info | yii\db\Command::query | SELECT COUNT(*) FROM `album` INNER JOIN `album_tag_assn` ON album_tag_assn.album_id = album.album_id WHERE (`album`.`in_ru`=1) AND (`album_tag_assn`.`tag_id`=1742) |
23:00:56.576 | info | yii\db\Command::query | SELECT COUNT(*) FROM `video` INNER JOIN `video_tag_assn` ON video_tag_assn.video_id = video.video_id WHERE (`video`.`in_ru`=1) AND (`video_tag_assn`.`tag_id`=1742) |
23:00:56.580 | info | yii\db\Command::query | SELECT * FROM `hdbk_country` WHERE 0=1 |
23:00:56.580 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/SocialSidebar/views/social-sidebar.php |
23:00:56.581 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/SocialShare/views/social-share.php |
23:00:56.581 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/default.php |
23:00:56.581 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/blocks/_header.php |
23:00:56.581 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
23:00:56.582 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `settings` |
23:00:56.583 | 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 = 'settings' AND kcu.table_name = 'settings' |
23:00:56.583 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
23:00:56.583 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
23:00:56.625 | info | yii\db\Command::query | SELECT * FROM `settings` WHERE `id`=1 |
23:00:56.625 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
23:00:56.626 | 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 |
23:00:56.633 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/blocks/_footer.php |
23:00:56.633 | info | yii\db\Command::query | SELECT * FROM `page` WHERE `page`.`alias`='confidentiality' |
23:00:56.634 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
23:00:56.634 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `page` |
23:00:56.635 | 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 = 'page' AND kcu.table_name = 'page' |
23:00:56.635 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
23:00:56.635 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
23:00:56.635 | info | yii\db\Command::query | SELECT * FROM `page` WHERE `page`.`alias`='use_info' |
23:00:56.636 | info | yii\db\Command::query | SELECT COUNT(*) FROM `partner` |
23:00:56.636 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts/frontend/blocks/_socials.php |
23:00:56.637 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/YandexMetrika/views/yandex-metrika.php |
23:00:56.637 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/LiveInternet/views/live-internet.php |