67f3ae705ddd4: GET https://smakbiryuki.com.ua/ru/production/ at 2025-04-07 01:52:33 pm by 40.77.167.79
Performance Profiling
Total processing time: 799 ms; Peak memory: 9.138 MB.
Всего 35 записей.
| # | Time | Duration | Category | Info |
|---|---|---|---|---|
| 1 | 13:52:32.687 | 1.1 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=smachnitradytsyi |
| 2 | 13:52:32.688 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `module_production_category` |
| 3 | 13:52:32.691 | 0.7 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'module_production_category' AND kcu.table_name = 'module_production_category' |
| 4 | 13:52:32.738 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `module_production_category_lang` |
| 5 | 13:52:32.740 | 0.7 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'module_production_category_lang' AND kcu.table_name = 'module_production_category_lang' |
| 6 | 13:52:32.745 | 109.6 ms | yii\db\Command::query | SELECT `module_production_category`.* FROM `module_production_category` LEFT JOIN `module_production_category_lang` ON `module_production_category`.`id` = `module_production_category_lang`.`owner_id` WHERE (`is_active`=1) AND (`lang`='ru') ORDER BY `rank` |
| 7 | 13:52:32.863 | 0.3 ms | yii\db\Command::query | SELECT * FROM `module_production_category_lang` WHERE (`lang`='ru') AND (`owner_id` IN (2, 3, 4, 7, 8, 9, 11, 12, 13, 14, 15, 16)) |
| 8 | 13:52:32.864 | 0.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `module_production` |
| 9 | 13:52:32.865 | 0.2 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'module_production' AND kcu.table_name = 'module_production' |
| 10 | 13:52:32.865 | 0.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `module_production_lang` |
| 11 | 13:52:32.865 | 0.1 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'module_production_lang' AND kcu.table_name = 'module_production_lang' |
| 12 | 13:52:32.866 | 113.3 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=2)) AND (`lang`='ru') ORDER BY `rank` |
| 13 | 13:52:32.984 | 0.8 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id` IN (13, 14, 15, 30, 31)) |
| 14 | 13:52:32.990 | 1.1 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=3)) AND (`lang`='ru') ORDER BY `rank` |
| 15 | 13:52:33.000 | 1.1 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id` IN (27, 28, 29, 32, 33, 34, 39, 40, 41, 42, 43, 44)) |
| 16 | 13:52:33.007 | 0.8 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=4)) AND (`lang`='ru') ORDER BY `rank` |
| 17 | 13:52:33.013 | 0.8 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id` IN (6, 7, 8, 9, 10, 12, 46)) |
| 18 | 13:52:33.018 | 0.7 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=7)) AND (`lang`='ru') ORDER BY `rank` |
| 19 | 13:52:33.020 | 0.6 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id`=16) |
| 20 | 13:52:33.023 | 0.6 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=8)) AND (`lang`='ru') ORDER BY `rank` |
| 21 | 13:52:33.028 | 0.6 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id` IN (17, 18, 19, 47, 48, 49, 50, 51, 52, 53)) |
| 22 | 13:52:33.031 | 0.4 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=9)) AND (`lang`='ru') ORDER BY `rank` |
| 23 | 13:52:33.033 | 0.3 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id`=20) |
| 24 | 13:52:33.034 | 0.4 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=11)) AND (`lang`='ru') ORDER BY `rank` |
| 25 | 13:52:33.036 | 0.4 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id` IN (21, 22, 23, 24, 25, 45)) |
| 26 | 13:52:33.038 | 0.3 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=12)) AND (`lang`='ru') ORDER BY `rank` |
| 27 | 13:52:33.039 | 0.2 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id`=26) |
| 28 | 13:52:33.040 | 0.2 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=13)) AND (`lang`='ru') ORDER BY `rank` |
| 29 | 13:52:33.041 | 0.2 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id`=35) |
| 30 | 13:52:33.042 | 0.2 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=14)) AND (`lang`='ru') ORDER BY `rank` |
| 31 | 13:52:33.043 | 0.1 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id`=36) |
| 32 | 13:52:33.043 | 0.1 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=15)) AND (`lang`='ru') ORDER BY `rank` |
| 33 | 13:52:33.044 | 0.1 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id`=37) |
| 34 | 13:52:33.045 | 0.1 ms | yii\db\Command::query | SELECT `module_production`.* FROM `module_production` LEFT JOIN `module_production_lang` ON `module_production`.`id` = `module_production_lang`.`owner_id` WHERE ((`is_active`=1) AND (`category_id`=16)) AND (`lang`='ru') ORDER BY `rank` |
| 35 | 13:52:33.046 | 0.1 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='ru') AND (`owner_id`=38) |