Performance Profiling

Total processing time: 40 ms; Peak memory: 3.300 MB. Show Profiling Timeline

Total 35 items.

Time	Duration	Category	Info

12:37:04.356	2.2 ms	yii\db\Command::query	SELECT COUNT(*) FROM `catalogue_items` LEFT JOIN `catalogue_items_to_categories` ON `catalogue_items`.`id` = `catalogue_items_to_categories`.`item_id` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE `catalogue_items`.`is_active`=1
12:37:04.359	1.9 ms	yii\db\Command::query	SELECT `catalogue_items`.* FROM `catalogue_items` LEFT JOIN `catalogue_items_to_categories` ON `catalogue_items`.`id` = `catalogue_items_to_categories`.`item_id` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE `catalogue_items`.`is_active`=1 ORDER BY `catalogue_items`.`id` LIMIT 60 OFFSET 600
12:37:04.361	0.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `catalogue_items`
12:37:04.355	0.6 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=sculptured
12:37:04.364	0.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `catalogue_items_to_categories`
12:37:04.365	0.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `catalogue_categories`
12:37:04.363	0.4 ms	yii\db\Command::query	SELECT `catalogue_items_to_categories`.* FROM `catalogue_items_to_categories` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE `catalogue_items_to_categories`.`item_id` IN (761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782)
12:37:04.362	0.4 ms	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'catalogue_items' AND `kcu`.`TABLE_NAME` = 'catalogue_items'
12:37:04.385	0.4 ms	yii\db\Command::query	SELECT * FROM `catalogue_categories`
12:37:04.364	0.3 ms	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'catalogue_items_to_categories' AND `kcu`.`TABLE_NAME` = 'catalogue_items_to_categories'
12:37:04.366	0.3 ms	yii\db\Command::query	SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'catalogue_categories' AND `kcu`.`TABLE_NAME` = 'catalogue_categories'
12:37:04.386	0.3 ms	yii\db\Command::query	SELECT COUNT(*) FROM `carts` WHERE `session_id`=''
12:37:04.369	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=761))
12:37:04.370	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=763))
12:37:04.380	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=777))
12:37:04.374	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=769))
12:37:04.380	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=778))
12:37:04.370	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=762))
12:37:04.365	0.2 ms	yii\db\Command::query	SELECT * FROM `catalogue_categories` WHERE `id`=10
12:37:04.375	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=770))
12:37:04.373	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=766))
12:37:04.377	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=772))
12:37:04.371	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=764))
12:37:04.377	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=773))
12:37:04.383	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=782))
12:37:04.382	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=781))
12:37:04.379	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=776))
12:37:04.382	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=780))
12:37:04.372	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=765))
12:37:04.381	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=779))
12:37:04.376	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=771))
12:37:04.373	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=767))
12:37:04.378	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=774))
12:37:04.374	0.1 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=768))
12:37:04.378	0.1 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=775))