Total processing time: 62 ms; Peak memory: 5.121 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
17:07:05.020 | 1.7 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 |
17:07:05.023 | 0.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_items` |
17:07:05.022 | 0.7 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 |
17:07:05.026 | 0.6 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) |
17:07:05.027 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_items_to_categories` |
17:07:05.019 | 0.5 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sculptured |
17:07:05.029 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_categories` |
17:07:05.024 | 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' |
17:07:05.028 | 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' |
17:07:05.030 | 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' |
17:07:05.069 | 0.3 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` |
17:07:05.041 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=19)) |
17:07:05.032 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=3)) |
17:07:05.033 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=5)) |
17:07:05.042 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=20)) |
17:07:05.029 | 0.2 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` WHERE `id` IN (1, 3) |
17:07:05.047 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=29)) |
17:07:05.060 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=52)) |
17:07:05.059 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=50)) |
17:07:05.058 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=48)) |
17:07:05.068 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=65)) |
17:07:05.056 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=46)) |
17:07:05.060 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=51)) |
17:07:05.033 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=4)) |
17:07:05.051 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=36)) |
17:07:05.070 | 0.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `carts` WHERE `session_id`='' |
17:07:05.052 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=37)) |
17:07:05.056 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=45)) |
17:07:05.058 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=49)) |
17:07:05.035 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=7)) |
17:07:05.038 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=13)) |
17:07:05.049 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=32)) |
17:07:05.061 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=53)) |
17:07:05.048 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=30)) |
17:07:05.034 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=6)) |
17:07:05.040 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=17)) |
17:07:05.057 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=47)) |
17:07:05.064 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=58)) |
17:07:05.039 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=15)) |
17:07:05.043 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=21)) |
17:07:05.035 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=8)) |
17:07:05.044 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=24)) |
17:07:05.062 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=54)) |
17:07:05.063 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=57)) |
17:07:05.047 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=28)) |
17:07:05.038 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=14)) |
17:07:05.050 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=34)) |
17:07:05.052 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=38)) |
17:07:05.044 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=23)) |
17:07:05.039 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=16)) |
17:07:05.063 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=56)) |
17:07:05.065 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=59)) |
17:07:05.053 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=40)) |
17:07:05.055 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=44)) |
17:07:05.043 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=22)) |
17:07:05.053 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=39)) |
17:07:05.066 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=62)) |
17:07:05.055 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=42)) |
17:07:05.036 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=9)) |
17:07:05.046 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=26)) |
17:07:05.049 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=31)) |
17:07:05.045 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=25)) |
17:07:05.046 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=27)) |
17:07:05.054 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=41)) |
17:07:05.066 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=61)) |
17:07:05.065 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=60)) |
17:07:05.067 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=63)) |
17:07:05.068 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=64)) |
17:07:05.062 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=55)) |
17:07:05.050 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=33)) |
17:07:05.036 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=10)) |
17:07:05.037 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=12)) |
17:07:05.041 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=18)) |