Performance Profiling

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

Total 73 items.
TimeDurationCategoryInfo
  
14:21:53.6351.6 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
14:21:53.6380.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `catalogue_items`
14:21:53.6370.6 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
14:21:53.6340.6 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;dbname=sculptured
14:21:53.6410.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 (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)
14:21:53.6420.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `catalogue_items_to_categories`
14:21:53.6440.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `catalogue_categories`
14:21:53.6390.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'
14:21:53.6420.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'
14:21:53.6440.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'
14:21:53.6430.2 msyii\db\Command::querySELECT * FROM `catalogue_categories` WHERE `id` IN (1, 3)
14:21:53.6460.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=3))
14:21:53.6820.2 msyii\db\Command::querySELECT * FROM `catalogue_categories`
14:21:53.6520.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=14))
14:21:53.6710.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=48))
14:21:53.6590.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=26))
14:21:53.6830.2 msyii\db\Command::querySELECT COUNT(*) FROM `carts` WHERE `session_id`=''
14:21:53.6470.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=4))
14:21:53.6690.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=45))
14:21:53.6600.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=27))
14:21:53.6480.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=5))
14:21:53.6660.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=38))
14:21:53.6690.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=44))
14:21:53.6550.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=19))
14:21:53.6490.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=7))
14:21:53.6620.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=30))
14:21:53.6790.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=61))
14:21:53.6700.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=46))
14:21:53.6640.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=33))
14:21:53.6610.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=28))
14:21:53.6580.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=23))
14:21:53.6620.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=31))
14:21:53.6750.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=54))
14:21:53.6650.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=37))
14:21:53.6810.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=65))
14:21:53.6480.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=6))
14:21:53.6740.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=52))
14:21:53.6780.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=60))
14:21:53.6530.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=15))
14:21:53.6720.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=49))
14:21:53.6780.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=59))
14:21:53.6650.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=36))
14:21:53.6720.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=50))
14:21:53.6740.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=53))
14:21:53.6510.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=12))
14:21:53.6610.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=29))
14:21:53.6710.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=47))
14:21:53.6760.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=56))
14:21:53.6590.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=25))
14:21:53.6540.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=17))
14:21:53.6770.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=57))
14:21:53.6550.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=18))
14:21:53.6810.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=64))
14:21:53.6500.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=9))
14:21:53.6560.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=20))
14:21:53.6580.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=24))
14:21:53.6750.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=55))
14:21:53.6800.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=63))
14:21:53.6520.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=13))
14:21:53.6570.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=22))
14:21:53.6670.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=39))
14:21:53.6800.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=62))
14:21:53.6670.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=40))
14:21:53.6570.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=21))
14:21:53.6630.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=32))
14:21:53.6640.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=34))
14:21:53.6730.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=51))
14:21:53.6770.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=58))
14:21:53.6540.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=16))
14:21:53.6680.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=42))
14:21:53.6490.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=8))
14:21:53.6680.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=41))
14:21:53.6510.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=10))