Performance Profiling

Total processing time: 49 ms; Peak memory: 3.358 MB.

Всего 8 записи.

#	Time	Duration	Category	Info

1	23:56:33.870	0.4 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=su
2	23:56:33.870	1.7 ms	yii\db\Command::query	SELECT * FROM `easyii_photos` WHERE (`class`='yii\\easyii\\modules\\gallery\\models\\Category') AND (item_id in (select category_id from easyii_gallery_categories where slug = 'proektno-analiticheskaya-sessiya-8-9-dekabrya-2016-goda')) ORDER BY `order_num` DESC LIMIT 100500
3	23:56:33.872	0.6 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `easyii_photos`
4	23:56:33.873	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 = 'easyii_photos' AND kcu.table_name = 'easyii_photos'
5	23:56:33.877	0.2 ms	yii\db\Command::query	SELECT COUNT(*) FROM `easyii_gallery_categories` WHERE slug='proektno-analiticheskaya-sessiya-8-9-dekabrya-2016-goda'
6	23:56:33.878	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `easyii_gallery_categories`
7	23:56:33.879	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 = 'easyii_gallery_categories' AND kcu.table_name = 'easyii_gallery_categories'
8	23:56:33.880	0.2 ms	yii\db\Command::query	SELECT * FROM `easyii_gallery_categories` WHERE slug='proektno-analiticheskaya-sessiya-8-9-dekabrya-2016-goda' ORDER BY `order_num` DESC LIMIT 20