Performance Profiling

Total processing time: 115 ms; Peak memory: 4.054 MB. Show Profiling Timeline

Всего 36 записей.

Time	Duration	Category	Info

06:13:34.127	35.6 ms	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`
06:13:34.101	5.2 ms	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`='1890') GROUP BY `post`.`post_id` HAVING COUNT(post_tag_assn.tag_id) >= 1 ORDER BY `post`.`published_dt` DESC
06:13:34.191	4.1 ms	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
06:13:34.120	1.2 ms	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`='1890') GROUP BY `post`.`post_id` HAVING COUNT(post_tag_assn.tag_id) >= 1 ORDER BY `post`.`published_dt` DESC LIMIT 20
06:13:34.166	1.2 ms	yii\db\Command::query	SELECT * FROM `post_tag_assn` WHERE `post_id` IN (11892, 11891, 11890, 11893, 11889)
06:13:34.114	1.2 ms	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`='1890') GROUP BY `post`.`post_id` HAVING COUNT(post_tag_assn.tag_id) >= 1) `c`
06:13:34.108	1.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `post`
06:13:34.123	1.1 ms	yii\db\Command::query	SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-before-main-events') ORDER BY `number`, `banner_id` DESC
06:13:34.112	1.1 ms	yii\db\Command::query	SELECT * FROM `post_tag_assn` WHERE `post_id`=11804
06:13:34.179	1.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `world_rating`
06:13:34.125	0.9 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `banner`
06:13:34.100	0.6 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=bsr
06:13:34.174	0.6 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11890
06:13:34.171	0.6 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11891
06:13:34.169	0.6 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11892
06:13:34.182	0.6 ms	yii\db\Command::query	SELECT * FROM `world_rating_team` WHERE `rating_id`=24 ORDER BY `place`, `points` DESC
06:13:34.176	0.5 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11893
06:13:34.110	0.5 ms	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'
06:13:34.167	0.5 ms	yii\db\Command::query	SELECT * FROM `tag` WHERE `tag_id` IN ('525', '587', '1536', '1882', '520', '523', '527', '571')
06:13:34.177	0.4 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11889
06:13:34.181	0.4 ms	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'
06:13:34.126	0.4 ms	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'
06:13:34.189	0.4 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11804
06:13:34.197	0.4 ms	yii\db\Command::query	SELECT * FROM `page` WHERE `page`.`alias`='confidentiality'
06:13:34.178	0.4 ms	yii\db\Command::query	SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-after-main-events') ORDER BY `number`, `banner_id` DESC
06:13:34.183	0.3 ms	yii\db\Command::query	SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-after-world-rating') ORDER BY `number`, `banner_id` DESC
06:13:34.191	0.3 ms	yii\db\Command::query	SELECT * FROM `settings` WHERE `id`=1
06:13:34.179	0.3 ms	yii\db\Command::query	SELECT * FROM `world_rating` WHERE `type`='men' ORDER BY `year` DESC, `month` DESC
06:13:34.198	0.3 ms	yii\db\Command::query	SELECT * FROM `page` WHERE `page`.`alias`='use_info'
06:13:34.113	0.2 ms	yii\db\Command::query	SELECT * FROM `tag` WHERE `tag_id` IN ('577', '1536', '1882', '1890')
06:13:34.122	0.2 ms	yii\db\Command::query	SELECT * FROM `tag` WHERE `tag_id`='1890'
06:13:34.182	0.2 ms	yii\db\Command::query	SELECT * FROM `settings`
06:13:34.178	0.2 ms	yii\db\Command::query	SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-before-world-rating') ORDER BY `number`, `banner_id` DESC
06:13:34.199	0.2 ms	yii\db\Command::query	SELECT COUNT(*) FROM `partner`
06:13:34.122	0.1 ms	yii\db\Command::query	SELECT * FROM `post_tag_assn` WHERE `post_id`=11804
06:13:34.122	0.1 ms	yii\db\Command::query	SELECT * FROM `tag` WHERE `tag_id` IN ('577', '1536', '1882', '1890')