Total processing time: 59 ms; Peak memory: 5.121 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
14:21:53.635 | 1.6 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 |
14:21:53.638 | 0.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_items` |
14:21:53.637 | 0.6 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 |
14:21:53.634 | 0.6 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sculptured |
14:21:53.641 | 0.5 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 (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.642 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_items_to_categories` |
14:21:53.644 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_categories` |
14:21:53.639 | 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' AND `kcu`.`TABLE_NAME` = 'catalogue_items' |
14:21:53.642 | 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' |
14:21:53.644 | 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' |
14:21:53.643 | 0.2 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` WHERE `id` IN (1, 3) |
14:21:53.646 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=3)) |
14:21:53.682 | 0.2 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` |
14:21:53.652 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=14)) |
14:21:53.671 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=48)) |
14:21:53.659 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=26)) |
14:21:53.683 | 0.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `carts` WHERE `session_id`='' |
14:21:53.647 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=4)) |
14:21:53.669 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=45)) |
14:21:53.660 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=27)) |
14:21:53.648 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=5)) |
14:21:53.666 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=38)) |
14:21:53.669 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=44)) |
14:21:53.655 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=19)) |
14:21:53.649 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=7)) |
14:21:53.662 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=30)) |
14:21:53.679 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=61)) |
14:21:53.670 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=46)) |
14:21:53.664 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=33)) |
14:21:53.661 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=28)) |
14:21:53.658 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=23)) |
14:21:53.662 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=31)) |
14:21:53.675 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=54)) |
14:21:53.665 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=37)) |
14:21:53.681 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=65)) |
14:21:53.648 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=6)) |
14:21:53.674 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=52)) |
14:21:53.678 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=60)) |
14:21:53.653 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=15)) |
14:21:53.672 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=49)) |
14:21:53.678 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=59)) |
14:21:53.665 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=36)) |
14:21:53.672 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=50)) |
14:21:53.674 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=53)) |
14:21:53.651 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=12)) |
14:21:53.661 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=29)) |
14:21:53.671 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=47)) |
14:21:53.676 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=56)) |
14:21:53.659 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=25)) |
14:21:53.654 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=17)) |
14:21:53.677 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=57)) |
14:21:53.655 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=18)) |
14:21:53.681 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=64)) |
14:21:53.650 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=9)) |
14:21:53.656 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=20)) |
14:21:53.658 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=24)) |
14:21:53.675 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=55)) |
14:21:53.680 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=63)) |
14:21:53.652 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=13)) |
14:21:53.657 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=22)) |
14:21:53.667 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=39)) |
14:21:53.680 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=62)) |
14:21:53.667 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=40)) |
14:21:53.657 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=21)) |
14:21:53.663 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=32)) |
14:21:53.664 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=34)) |
14:21:53.673 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=51)) |
14:21:53.677 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=58)) |
14:21:53.654 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=16)) |
14:21:53.668 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=42)) |
14:21:53.649 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=8)) |
14:21:53.668 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=41)) |
14:21:53.651 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=10)) |