Performance Profiling

Total processing time: 52 ms; Peak memory: 4.686 MB. Show Profiling Timeline

Total 65 items.
TimeDurationCategoryInfo
  
12:37:29.5181.8 msyii\db\Command::querySELECT `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) AND (`slug`='parts') ORDER BY `catalogue_items`.`id` LIMIT 60
12:37:29.5170.8 msyii\db\Command::querySELECT 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) AND (`slug`='parts')
12:37:29.5150.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `catalogue_categories`
12:37:29.5200.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `catalogue_items`
12:37:29.5220.5 msyii\db\Command::querySELECT `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 (732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782)
12:37:29.5140.5 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;dbname=sculptured
12:37:29.5230.4 msyii\db\Command::querySHOW FULL COLUMNS FROM `catalogue_items_to_categories`
12:37:29.5160.3 msyii\db\Command::querySELECT `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:29.5150.3 msyii\db\Command::querySELECT * FROM `catalogue_categories` WHERE `slug`='parts'
12:37:29.5200.3 msyii\db\Command::querySELECT `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:29.5230.3 msyii\db\Command::querySELECT `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:29.5400.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=754))
12:37:29.5240.2 msyii\db\Command::querySELECT * FROM `catalogue_categories` WHERE `id`=10
12:37:29.5570.2 msyii\db\Command::querySELECT * FROM `catalogue_categories`
12:37:29.5580.2 msyii\db\Command::querySELECT COUNT(*) FROM `carts` WHERE `session_id`=''
12:37:29.5260.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=732))
12:37:29.5330.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=744))
12:37:29.5440.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=760))
12:37:29.5410.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=756))
12:37:29.5360.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=748))
12:37:29.5370.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=749))
12:37:29.5470.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=765))
12:37:29.5490.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=770))
12:37:29.5480.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=767))
12:37:29.5320.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=742))
12:37:29.5290.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=736))
12:37:29.5340.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=745))
12:37:29.5270.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=733))
12:37:29.5410.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=755))
12:37:29.5560.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=782))
12:37:29.5390.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=753))
12:37:29.5430.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=758))
12:37:29.5560.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=781))
12:37:29.5380.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=751))
12:37:29.5440.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=761))
12:37:29.5480.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=768))
12:37:29.5330.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=743))
12:37:29.5350.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=746))
12:37:29.5510.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=772))
12:37:29.5530.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=776))
12:37:29.5490.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=769))
12:37:29.5550.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=779))
12:37:29.5420.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=757))
12:37:29.5520.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=775))
12:37:29.5470.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=766))
12:37:29.5360.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=747))
12:37:29.5300.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=739))
12:37:29.5390.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=752))
12:37:29.5270.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=734))
12:37:29.5280.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=735))
12:37:29.5290.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=737))
12:37:29.5500.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=771))
12:37:29.5380.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=750))
12:37:29.5450.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=762))
12:37:29.5540.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=778))
12:37:29.5430.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=759))
12:37:29.5520.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=774))
12:37:29.5530.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=777))
12:37:29.5510.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=773))
12:37:29.5450.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=763))
12:37:29.5550.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=780))
12:37:29.5300.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=738))
12:37:29.5310.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=740))
12:37:29.5320.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=741))
12:37:29.5460.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=764))