Total processing time: 52 ms; Peak memory: 4.686 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
12:37:29.518 | 1.8 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) AND (`slug`='parts') ORDER BY `catalogue_items`.`id` LIMIT 60 |
12:37:29.517 | 0.8 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) AND (`slug`='parts') |
12:37:29.515 | 0.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_categories` |
12:37:29.520 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_items` |
12:37:29.522 | 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 (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.514 | 0.5 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sculptured |
12:37:29.523 | 0.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_items_to_categories` |
12:37:29.516 | 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' |
12:37:29.515 | 0.3 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` WHERE `slug`='parts' |
12:37:29.520 | 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' |
12:37:29.523 | 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' |
12:37:29.540 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=754)) |
12:37:29.524 | 0.2 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` WHERE `id`=10 |
12:37:29.557 | 0.2 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` |
12:37:29.558 | 0.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `carts` WHERE `session_id`='' |
12:37:29.526 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=732)) |
12:37:29.533 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=744)) |
12:37:29.544 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=760)) |
12:37:29.541 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=756)) |
12:37:29.536 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=748)) |
12:37:29.537 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=749)) |
12:37:29.547 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=765)) |
12:37:29.549 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=770)) |
12:37:29.548 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=767)) |
12:37:29.532 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=742)) |
12:37:29.529 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=736)) |
12:37:29.534 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=745)) |
12:37:29.527 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=733)) |
12:37:29.541 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=755)) |
12:37:29.556 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=782)) |
12:37:29.539 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=753)) |
12:37:29.543 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=758)) |
12:37:29.556 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=781)) |
12:37:29.538 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=751)) |
12:37:29.544 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=761)) |
12:37:29.548 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=768)) |
12:37:29.533 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=743)) |
12:37:29.535 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=746)) |
12:37:29.551 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=772)) |
12:37:29.553 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=776)) |
12:37:29.549 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=769)) |
12:37:29.555 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=779)) |
12:37:29.542 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=757)) |
12:37:29.552 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=775)) |
12:37:29.547 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=766)) |
12:37:29.536 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=747)) |
12:37:29.530 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=739)) |
12:37:29.539 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=752)) |
12:37:29.527 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=734)) |
12:37:29.528 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=735)) |
12:37:29.529 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=737)) |
12:37:29.550 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=771)) |
12:37:29.538 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=750)) |
12:37:29.545 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=762)) |
12:37:29.554 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=778)) |
12:37:29.543 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=759)) |
12:37:29.552 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=774)) |
12:37:29.553 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=777)) |
12:37:29.551 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=773)) |
12:37:29.545 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=763)) |
12:37:29.555 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=780)) |
12:37:29.530 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=738)) |
12:37:29.531 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=740)) |
12:37:29.532 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=741)) |
12:37:29.546 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=764)) |