Performance Profiling

Total processing time: 155 ms; Peak memory: 4.079 MB. Show Profiling Timeline

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

Time	Duration	Category	Info

06:47:03.912	37.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:47:04.019	6.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:47:03.893	2.4 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`='1637') GROUP BY `post`.`post_id` HAVING COUNT(post_tag_assn.tag_id) >= 1 ORDER BY `post`.`published_dt` DESC
06:47:03.907	1.8 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`='1637') GROUP BY `post`.`post_id` HAVING COUNT(post_tag_assn.tag_id) >= 1 ORDER BY `post`.`published_dt` DESC LIMIT 20
06:47:03.901	1.1 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`='1637') GROUP BY `post`.`post_id` HAVING COUNT(post_tag_assn.tag_id) >= 1) `c`
06:47:04.029	1.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `page`
06:47:03.965	0.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `settings`
06:47:04.014	0.6 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=10615
06:47:03.892	0.6 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=bsr
06:47:04.017	0.6 ms	yii\db\Command::query	SELECT * FROM `settings` WHERE `id`=1
06:47:03.966	0.6 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 = 'settings' AND kcu.table_name = 'settings'
06:47:03.899	0.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tag`
06:47:04.009	0.5 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:47:04.030	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 = 'page' AND kcu.table_name = 'page'
06:47:03.952	0.5 ms	yii\db\Command::query	SELECT * FROM `post_tag_assn` WHERE `post_id` IN (11892, 11891, 11890, 11893, 11889)
06:47:03.953	0.5 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11892
06:47:03.955	0.5 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11891
06:47:03.957	0.5 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11890
06:47:03.963	0.5 ms	yii\db\Command::query	SELECT * FROM `world_rating` WHERE `type`='men' ORDER BY `year` DESC, `month` DESC
06:47:03.960	0.4 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11889
06:47:03.959	0.4 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=11893
06:47:04.031	0.4 ms	yii\db\Command::query	SELECT * FROM `page` WHERE `page`.`alias`='use_info'
06:47:04.027	0.4 ms	yii\db\Command::query	SELECT * FROM `page` WHERE `page`.`alias`='confidentiality'
06:47:03.962	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:47:04.032	0.4 ms	yii\db\Command::query	SELECT COUNT(*) FROM `partner`
06:47:03.964	0.4 ms	yii\db\Command::query	SELECT * FROM `world_rating_team` WHERE `rating_id`=24 ORDER BY `place`, `points` DESC
06:47:03.911	0.3 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:47:03.898	0.3 ms	yii\db\Command::query	SELECT * FROM `post_tag_assn` WHERE `post_id`=10615
06:47:03.910	0.2 ms	yii\db\Command::query	SELECT * FROM `tag` WHERE `tag_id`='1637'
06:47:03.900	0.2 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 = 'tag' AND kcu.table_name = 'tag'
06:47:03.953	0.2 ms	yii\db\Command::query	SELECT * FROM `tag` WHERE `tag_id` IN ('525', '587', '1536', '1882', '520', '523', '527', '571')
06:47:03.898	0.2 ms	yii\db\Command::query	SELECT * FROM `tag` WHERE `tag_id` IN ('1622', '1634', '1637')
06:47:03.964	0.2 ms	yii\db\Command::query	SELECT * FROM `settings`
06:47:03.962	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:47:03.910	0.1 ms	yii\db\Command::query	SELECT * FROM `post_tag_assn` WHERE `post_id`=10615
06:47:03.910	0.1 ms	yii\db\Command::query	SELECT * FROM `tag` WHERE `tag_id` IN ('1622', '1634', '1637')