67da76741bac9: GET https://lepnoedelo.ru/catalog/pivobeers?from=1 at 2025-03-19 07:47:00 am by 170.106.167.214
Performance Profiling
Total processing time: 71 ms; Peak memory: 5.130 MB. Show Profiling Timeline
Total 74 items.
| Time | Duration | Category | Info |
|---|---|---|---|
| 07:47:00.120 | 1.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) AND (`slug`='pivobeers') ORDER BY `catalogue_items`.`id` LIMIT 60 OFFSET 60 |
| 07:47:00.119 | 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) AND (`slug`='pivobeers') |
| 07:47:00.116 | 1.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_categories` |
| 07:47:00.122 | 0.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_items` |
| 07:47:00.126 | 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 (438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497) |
| 07:47:00.115 | 0.6 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sculptured |
| 07:47:00.126 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_items_to_categories` |
| 07:47:00.116 | 0.5 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` WHERE `slug`='pivobeers' |
| 07:47:00.118 | 0.4 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' |
| 07:47:00.123 | 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' |
| 07:47:00.172 | 0.3 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` |
| 07:47:00.170 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=496)) |
| 07:47:00.127 | 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' |
| 07:47:00.160 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=483)) |
| 07:47:00.173 | 0.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `carts` WHERE `session_id`='' |
| 07:47:00.143 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=458)) |
| 07:47:00.130 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=438)) |
| 07:47:00.165 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=489)) |
| 07:47:00.167 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=492)) |
| 07:47:00.170 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=497)) |
| 07:47:00.163 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=487)) |
| 07:47:00.164 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=488)) |
| 07:47:00.169 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=495)) |
| 07:47:00.166 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=491)) |
| 07:47:00.162 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=486)) |
| 07:47:00.132 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=441)) |
| 07:47:00.162 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=485)) |
| 07:47:00.161 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=484)) |
| 07:47:00.165 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=490)) |
| 07:47:00.128 | 0.2 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` WHERE `id`=9 |
| 07:47:00.168 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=494)) |
| 07:47:00.145 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=462)) |
| 07:47:00.168 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=493)) |
| 07:47:00.132 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=440)) |
| 07:47:00.133 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=442)) |
| 07:47:00.135 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=446)) |
| 07:47:00.145 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=461)) |
| 07:47:00.155 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=475)) |
| 07:47:00.131 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=439)) |
| 07:47:00.143 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=459)) |
| 07:47:00.147 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=465)) |
| 07:47:00.150 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=469)) |
| 07:47:00.154 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=474)) |
| 07:47:00.153 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=473)) |
| 07:47:00.146 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=463)) |
| 07:47:00.156 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=476)) |
| 07:47:00.147 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=464)) |
| 07:47:00.138 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=450)) |
| 07:47:00.137 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=448)) |
| 07:47:00.136 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=447)) |
| 07:47:00.152 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=472)) |
| 07:47:00.140 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=454)) |
| 07:47:00.151 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=471)) |
| 07:47:00.160 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=482)) |
| 07:47:00.150 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=470)) |
| 07:47:00.157 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=477)) |
| 07:47:00.134 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=443)) |
| 07:47:00.141 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=455)) |
| 07:47:00.148 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=466)) |
| 07:47:00.158 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=480)) |
| 07:47:00.139 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=452)) |
| 07:47:00.149 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=467)) |
| 07:47:00.159 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=481)) |
| 07:47:00.149 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=468)) |
| 07:47:00.157 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=478)) |
| 07:47:00.158 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=479)) |
| 07:47:00.140 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=453)) |
| 07:47:00.134 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=444)) |
| 07:47:00.141 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=456)) |
| 07:47:00.144 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=460)) |
| 07:47:00.135 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=445)) |
| 07:47:00.137 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=449)) |
| 07:47:00.138 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=451)) |
| 07:47:00.142 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=457)) |