07:30:14.739 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
07:30:14.740 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\user\Bootstrap::bootstrap() |
07:30:14.740 | trace | yii\base\Module::getModule | Loading module: user |
07:30:14.741 | trace | yii\redis\Connection::open | Opening redis DB connection: localhost:6379, database=3 |
07:30:14.741 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: AUTH |
07:30:14.742 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
07:30:14.742 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:30:14.743 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\team\Bootstrap::bootstrap() |
07:30:14.743 | trace | yii\base\Module::getModule | Loading module: team |
07:30:14.743 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\tournament\Bootstrap::bootstrap() |
07:30:14.743 | trace | yii\base\Module::getModule | Loading module: tournament |
07:30:14.744 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\player\Bootstrap::bootstrap() |
07:30:14.744 | trace | yii\base\Module::getModule | Loading module: player |
07:30:14.744 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\hdbk\Bootstrap::bootstrap() |
07:30:14.744 | trace | yii\base\Module::getModule | Loading module: hdbk |
07:30:14.744 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\match\Bootstrap::bootstrap() |
07:30:14.744 | trace | yii\base\Module::getModule | Loading module: match |
07:30:14.744 | trace | yii\base\Application::bootstrap | Bootstrap with app\modules\redaction\Bootstrap::bootstrap() |
07:30:14.744 | trace | yii\base\Module::getModule | Loading module: redaction |
07:30:14.744 | trace | yii\base\Module::getModule | Loading module: debug |
07:30:14.745 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
07:30:14.745 | trace | yii\base\Module::getModule | Loading module: gii |
07:30:14.745 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
07:30:14.746 | trace | yii\web\Application::handleRequest | Route requested: 'frontend/search/tags' |
07:30:14.746 | trace | yii\base\Controller::runAction | Route to run: frontend/search/tags |
07:30:14.746 | trace | yii\base\InlineAction::runWithParams | Running action: app\controllers\frontend\SearchController::actionTags() |
07:30:14.746 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=bsr |
07:30:14.747 | 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`.`is_public`=1) AND (`post`.`in_en`=1) AND (`post`.`type`='article') AND (`post_tag_assn`.`tag_id`='1607') GROUP BY `post`.`post_id` HAVING COUNT(post_tag_assn.tag_id) >= 1 ORDER BY `post`.`published_dt` DESC |
07:30:14.774 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:30:14.775 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `post` |
07:30:14.777 | 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' |
07:30:14.778 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:30:14.778 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:30:14.779 | info | yii\db\Command::query | SELECT * FROM `post_tag_assn` WHERE `post_id`=11905 |
07:30:14.780 | info | yii\db\Command::query | SELECT * FROM `tag` WHERE `tag_id` IN ('520', '1536', '1607', '1612', '1658', '1882') |
07:30:14.780 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:30:14.780 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `tag` |
07:30:14.782 | 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:30:14.782 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:30:14.783 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:30:14.783 | 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`.`is_public`=1) AND (`post`.`in_en`=1) AND (`post`.`type`='article') AND (`post_tag_assn`.`tag_id`='1607') GROUP BY `post`.`post_id` HAVING COUNT(post_tag_assn.tag_id) >= 1) `c` |
07:30:14.791 | 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`.`is_public`=1) AND (`post`.`in_en`=1) AND (`post`.`type`='article') AND (`post_tag_assn`.`tag_id`='1607') GROUP BY `post`.`post_id` HAVING COUNT(post_tag_assn.tag_id) >= 1 ORDER BY `post`.`published_dt` DESC LIMIT 20 |
07:30:14.793 | info | yii\db\Command::query | SELECT * FROM `post_tag_assn` WHERE `post_id`=11905 |
07:30:14.793 | info | yii\db\Command::query | SELECT * FROM `tag` WHERE `tag_id` IN ('520', '1536', '1607', '1612', '1658', '1882') |
07:30:14.794 | info | yii\db\Command::query | SELECT * FROM `tag` WHERE `tag_id`='1607' |
07:30:14.794 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/frontend/search/tags.php |
07:30:14.795 | info | yii\db\Command::query | SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-before-main-events') ORDER BY `number`, `banner_id` DESC |
07:30:14.795 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:30:14.795 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `banner` |
07:30:14.796 | 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 = 'banner' AND kcu.table_name = 'banner' |
07:30:14.797 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:30:14.797 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:30:14.797 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/redaction/widgets/banner/views/banner.php |
07:30:14.797 | info | yii\db\Command::query | SELECT * FROM `post` WHERE (`post`.`type`='news') AND (`post`.`in_en`=1) AND (`post`.`is_public`=1) AND (NOT (`position_en_id` IS NULL)) ORDER BY `position_en_id` |
07:30:15.356 | info | yii\db\Command::query | SELECT * FROM `post_tag_assn` WHERE `post_id` IN (11892, 11891, 11890, 11893, 11889) |
07:30:15.357 | info | yii\db\Command::query | SELECT * FROM `tag` WHERE `tag_id` IN ('525', '587', '1536', '1882', '520', '523', '527', '571') |
07:30:15.358 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/redaction/widgets/posts/views/main-news.php |
07:30:15.358 | info | yii\db\Command::query | SELECT * FROM `post` WHERE `post_id`=11892 |
07:30:15.359 | info | yii\db\Command::query | SELECT * FROM `post` WHERE `post_id`=11891 |
07:30:15.361 | info | yii\db\Command::query | SELECT * FROM `post` WHERE `post_id`=11890 |
07:30:15.363 | info | yii\db\Command::query | SELECT * FROM `post` WHERE `post_id`=11893 |
07:30:15.364 | info | yii\db\Command::query | SELECT * FROM `post` WHERE `post_id`=11889 |
07:30:15.366 | info | yii\db\Command::query | SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-after-main-events') ORDER BY `number`, `banner_id` DESC |
07:30:15.366 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/redaction/widgets/banner/views/banner.php |
07:30:15.366 | info | yii\db\Command::query | SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-before-world-rating') ORDER BY `number`, `banner_id` DESC |
07:30:15.366 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/redaction/widgets/banner/views/banner.php |
07:30:15.367 | info | yii\db\Command::query | SELECT * FROM `world_rating` WHERE `type`='men' ORDER BY `year` DESC, `month` DESC |
07:30:15.369 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:30:15.369 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `world_rating` |
07:30:15.370 | 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 = 'world_rating' AND kcu.table_name = 'world_rating' |
07:30:15.371 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:30:15.371 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:30:15.371 | info | yii\db\Command::query | SELECT * FROM `world_rating_team` WHERE `rating_id`=24 ORDER BY `place`, `points` DESC |
07:30:15.374 | info | yii\db\Command::query | SELECT * FROM `settings` |
07:30:15.375 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:30:15.375 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `settings` |
07:30:15.376 | 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' |
07:30:15.377 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:30:15.377 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:30:15.421 | info | yii\db\Command::query | SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-after-world-rating') ORDER BY `number`, `banner_id` DESC |
07:30:15.422 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/modules/redaction/widgets/banner/views/banner.php |
07:30:15.422 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/frontend/search/../common/_filter-tags.php |
07:30:15.423 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/frontend/common/_filter-dates.php |
07:30:15.424 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/frontend/search/_results.php |
07:30:15.424 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/frontend/search/_articles.php |
07:30:15.425 | info | yii\db\Command::query | SELECT * FROM `post` WHERE `post_id`=11905 |
07:30:15.427 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts//frontend/default.php |
07:30:15.427 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts//frontend/blocks/_header.php |
07:30:15.428 | info | yii\db\Command::query | SELECT * FROM `settings` WHERE `id`=1 |
07:30:15.428 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:30:15.428 | 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:30:15.430 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/SocialIframe/views/fb.php |
07:30:15.430 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts//frontend/blocks/_footer.php |
07:30:15.430 | info | yii\db\Command::query | SELECT * FROM `page` WHERE `page`.`alias`='confidentiality' |
07:30:15.431 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
07:30:15.431 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `page` |
07:30:15.432 | 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' |
07:30:15.433 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
07:30:15.433 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
07:30:15.433 | info | yii\db\Command::query | SELECT * FROM `page` WHERE `page`.`alias`='use_info' |
07:30:15.434 | info | yii\db\Command::query | SELECT COUNT(*) FROM `partner` |
07:30:15.434 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/views/layouts//frontend/blocks/_socials.php |
07:30:15.434 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/YandexMetrika/views/yandex-metrika.php |
07:30:15.434 | trace | yii\base\View::renderFile | Rendering view file: /var/www/bsrussia/web/widgets/LiveInternet/views/live-internet.php |