Performance Profiling

Total processing time: 62 ms; Peak memory: 5.121 MB. Show Profiling Timeline

Total 73 items.
TimeDurationCategoryInfo
  
17:07:05.0201.7 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
17:07:05.0230.8 msyii\db\Command::querySHOW FULL COLUMNS FROM `catalogue_items`
17:07:05.0220.7 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 ORDER BY `catalogue_items`.`id` LIMIT 60
17:07:05.0260.6 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 (3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 36, 37, 38, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65)
17:07:05.0270.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `catalogue_items_to_categories`
17:07:05.0190.5 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;dbname=sculptured
17:07:05.0290.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `catalogue_categories`
17:07:05.0240.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'
17:07:05.0280.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'
17:07:05.0300.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'
17:07:05.0690.3 msyii\db\Command::querySELECT * FROM `catalogue_categories`
17:07:05.0410.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=19))
17:07:05.0320.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=3))
17:07:05.0330.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=5))
17:07:05.0420.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=20))
17:07:05.0290.2 msyii\db\Command::querySELECT * FROM `catalogue_categories` WHERE `id` IN (1, 3)
17:07:05.0470.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=29))
17:07:05.0600.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=52))
17:07:05.0590.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=50))
17:07:05.0580.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=48))
17:07:05.0680.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=65))
17:07:05.0560.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=46))
17:07:05.0600.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=51))
17:07:05.0330.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=4))
17:07:05.0510.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=36))
17:07:05.0700.2 msyii\db\Command::querySELECT COUNT(*) FROM `carts` WHERE `session_id`=''
17:07:05.0520.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=37))
17:07:05.0560.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=45))
17:07:05.0580.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=49))
17:07:05.0350.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=7))
17:07:05.0380.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=13))
17:07:05.0490.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=32))
17:07:05.0610.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=53))
17:07:05.0480.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=30))
17:07:05.0340.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=6))
17:07:05.0400.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=17))
17:07:05.0570.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=47))
17:07:05.0640.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=58))
17:07:05.0390.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=15))
17:07:05.0430.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=21))
17:07:05.0350.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=8))
17:07:05.0440.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=24))
17:07:05.0620.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=54))
17:07:05.0630.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=57))
17:07:05.0470.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=28))
17:07:05.0380.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=14))
17:07:05.0500.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=34))
17:07:05.0520.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=38))
17:07:05.0440.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=23))
17:07:05.0390.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=16))
17:07:05.0630.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=56))
17:07:05.0650.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=59))
17:07:05.0530.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=40))
17:07:05.0550.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=44))
17:07:05.0430.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=22))
17:07:05.0530.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=39))
17:07:05.0660.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=62))
17:07:05.0550.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=42))
17:07:05.0360.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=9))
17:07:05.0460.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=26))
17:07:05.0490.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=31))
17:07:05.0450.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=25))
17:07:05.0460.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=27))
17:07:05.0540.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=41))
17:07:05.0660.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=61))
17:07:05.0650.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=60))
17:07:05.0670.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=63))
17:07:05.0680.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=64))
17:07:05.0620.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=55))
17:07:05.0500.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=33))
17:07:05.0360.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=10))
17:07:05.0370.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=12))
17:07:05.0410.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=18))