Performance Profiling

Total processing time: 30 ms; Peak memory: 3.596 MB.

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

#	Time	Duration	Category	Info

1	11:18:13.065	0.4 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=su
2	11:18:13.065	13.5 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-23-25-marta-2017-goda')) ORDER BY `order_num` DESC LIMIT 100500
3	11:18:13.079	0.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `easyii_photos`
4	11:18:13.080	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	11:18:13.083	0.1 ms	yii\db\Command::query	SELECT COUNT(*) FROM `easyii_gallery_categories` WHERE slug='proektno-analiticheskaya-sessiya-23-25-marta-2017-goda'
6	11:18:13.084	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `easyii_gallery_categories`
7	11:18:13.084	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	11:18:13.085	0.1 ms	yii\db\Command::query	SELECT * FROM `easyii_gallery_categories` WHERE slug='proektno-analiticheskaya-sessiya-23-25-marta-2017-goda' ORDER BY `order_num` DESC LIMIT 20