Performance Profiling

Total processing time: 37 ms; Peak memory: 3.401 MB. Show Profiling Timeline

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

Time	Duration	Category	Info

23:59:27.063	1.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `post`
23:59:27.070	1.6 ms	yii\db\Command::query	SELECT * FROM `post` WHERE (`post`.`type`='article') AND (`post`.`in_ru`=1) AND (`post`.`is_public`=1) AND (NOT (`position_id` IS NULL)) AND (NOT (`post`.`post_id`=344)) ORDER BY `position_id` LIMIT 5
23:59:27.068	0.9 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tag`
23:59:27.061	0.7 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`='344'
23:59:27.079	0.6 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=13330
23:59:27.065	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 = 'post' AND kcu.table_name = 'post'
23:59:27.074	0.6 ms	yii\db\Command::query	SELECT * FROM `post_tag_assn` WHERE `post_id` IN (13330, 13336, 13325, 13327, 13316)
23:59:27.061	0.5 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=bsr
23:59:27.076	0.5 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=344
23:59:27.082	0.5 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=13325
23:59:27.083	0.4 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=13327
23:59:27.081	0.4 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=13336
23:59:27.069	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 = 'tag' AND kcu.table_name = 'tag'
23:59:27.067	0.4 ms	yii\db\Command::query	SELECT * FROM `post_tag_assn` WHERE `post_id`=344
23:59:27.084	0.4 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=13316
23:59:27.075	0.4 ms	yii\db\Command::query	SELECT * FROM `tag` WHERE `tag_id` IN ('737', '1661', '1988', '2033', '523', '520', '539', '571', '1641', '1888', '1953', '1536', '2035', '522', '1823')
23:59:27.067	0.2 ms	yii\db\Command::query	SELECT * FROM `tag` WHERE `tag_id`='515'
23:59:27.086	0.2 ms	yii\db\Command::query	SELECT * FROM `post` WHERE `post_id`=344