Performance Profiling

Total processing time: 137 ms; Peak memory: 2.727 MB. Show Profiling Timeline

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

Time	Duration	Category	Info

17:16:37.902	18.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT `p`. FROM `shop_products` `p` LEFT JOIN `shop_category_assignments` `ca` ON `p`.`id` = `ca`.`product_id` WHERE (`p`.`status`=1) AND ((`p`.`category_id`=3) OR (`ca`.`category_id`=3)) GROUP BY `p`.`id`) `c`
17:16:37.826	11.9 ms	yii\db\Command::query	SELECT * FROM `shop_categories` WHERE (`slug`='index') AND (`depth` > 0)
17:16:37.868	9.3 ms	yii\db\Command::query	SELECT * FROM `shop_categories` WHERE (`id`=3) AND (`depth` > 0)
17:16:37.847	8.0 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 = 'shop_categories' AND kcu.table_name = 'shop_categories'
17:16:37.921	0.9 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 = 'shop_products' AND kcu.table_name = 'shop_products'
17:16:37.825	0.6 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=sitegis_feniks
17:16:37.847	0.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `shop_categories`
17:16:37.894	0.4 ms	yii\db\Command::query	SELECT `id` FROM `shop_categories` WHERE (`shop_categories`.`lft` > 2) AND (`shop_categories`.`lft` < 3) ORDER BY `shop_categories`.`lft`
17:16:37.921	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `shop_products`
17:16:37.864	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_categories` WHERE (`shop_categories`.`lft` < 2) AND (`shop_categories`.`rgt` > 3) AND (`depth` > 0) ORDER BY `shop_categories`.`lft`
17:16:37.897	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_categories` WHERE (`shop_categories`.`lft` < 2) AND (`shop_categories`.`rgt` > 3) ORDER BY `shop_categories`.`lft`
17:16:37.898	0.3 ms	yii\db\Command::query	SELECT * FROM `shop_categories` WHERE (`shop_categories`.`lft` > 2) AND (`shop_categories`.`lft` < 3) AND (`shop_categories`.`depth` <= 2) ORDER BY `shop_categories`.`lft`