67da84027851c: GET https://lepnoedelo.ru/catalog/pivobeers?from=2 at 2025-03-19 08:44:50 am by 43.157.202.235
Performance Profiling
Total processing time: 48 ms; Peak memory: 4.100 MB. Show Profiling Timeline
Total 54 items.
| Time | Duration | Category | Info |
|---|---|---|---|
| 08:44:50.498 | 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`='pivobeers') ORDER BY `catalogue_items`.`id` LIMIT 60 OFFSET 120 |
| 08:44:50.497 | 0.9 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') |
| 08:44:50.495 | 0.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_categories` |
| 08:44:50.494 | 0.5 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sculptured |
| 08:44:50.500 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_items` |
| 08:44:50.502 | 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 (498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537) |
| 08:44:50.503 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `catalogue_items_to_categories` |
| 08:44:50.495 | 0.3 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` WHERE `slug`='pivobeers' |
| 08:44:50.496 | 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' |
| 08:44:50.532 | 0.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `carts` WHERE `session_id`='' |
| 08:44:50.503 | 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' |
| 08:44:50.501 | 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' |
| 08:44:50.531 | 0.2 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` |
| 08:44:50.518 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=517)) |
| 08:44:50.522 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=524)) |
| 08:44:50.506 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=498)) |
| 08:44:50.522 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=523)) |
| 08:44:50.523 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=525)) |
| 08:44:50.521 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=522)) |
| 08:44:50.527 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=532)) |
| 08:44:50.504 | 0.2 ms | yii\db\Command::query | SELECT * FROM `catalogue_categories` WHERE `id`=9 |
| 08:44:50.517 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=516)) |
| 08:44:50.507 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=500)) |
| 08:44:50.528 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=534)) |
| 08:44:50.511 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=507)) |
| 08:44:50.515 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=513)) |
| 08:44:50.513 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=510)) |
| 08:44:50.516 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=514)) |
| 08:44:50.507 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=499)) |
| 08:44:50.517 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=515)) |
| 08:44:50.530 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=537)) |
| 08:44:50.508 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=501)) |
| 08:44:50.514 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=511)) |
| 08:44:50.524 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=526)) |
| 08:44:50.511 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=506)) |
| 08:44:50.518 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=518)) |
| 08:44:50.519 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=519)) |
| 08:44:50.513 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=509)) |
| 08:44:50.526 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=530)) |
| 08:44:50.520 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=521)) |
| 08:44:50.528 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=533)) |
| 08:44:50.515 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=512)) |
| 08:44:50.525 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=528)) |
| 08:44:50.512 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=508)) |
| 08:44:50.529 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=535)) |
| 08:44:50.508 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=502)) |
| 08:44:50.525 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=529)) |
| 08:44:50.530 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=536)) |
| 08:44:50.520 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=520)) |
| 08:44:50.524 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=527)) |
| 08:44:50.527 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=531)) |
| 08:44:50.510 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=505)) |
| 08:44:50.510 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=504)) |
| 08:44:50.509 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=503)) |