67f3a65f7f408: GET https://smakbiryuki.com.ua/en/production at 2025-04-07 01:18:08 pm by 3.142.239.146
Performance Profiling
Total processing time: 559 ms; Peak memory: 9.134 MB.
Всего 35 записей.
| # | Time | Duration | Category | Info |
|---|---|---|---|---|
| 1 | 13:18:07.734 | 1.1 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=smachnitradytsyi |
| 2 | 13:18:07.735 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `module_production_category` |
| 3 | 13:18:07.753 | 0.9 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:18:07.782 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `module_production_category_lang` |
| 5 | 13:18:07.784 | 0.8 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:18:07.790 | 69.2 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`='en') ORDER BY `rank` |
| 7 | 13:18:07.876 | 0.9 ms | yii\db\Command::query | SELECT * FROM `module_production_category_lang` WHERE (`lang`='en') AND (`owner_id` IN (2, 3, 4, 7, 8, 9, 11, 12, 13, 14, 15, 16)) |
| 8 | 13:18:07.880 | 0.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `module_production` |
| 9 | 13:18:07.881 | 0.6 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:18:07.882 | 0.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `module_production_lang` |
| 11 | 13:18:07.884 | 0.6 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:18:07.885 | 83.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`=2)) AND (`lang`='en') ORDER BY `rank` |
| 13 | 13:18:07.973 | 0.6 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id` IN (13, 14, 15, 30, 31)) |
| 14 | 13:18:07.986 | 0.9 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`='en') ORDER BY `rank` |
| 15 | 13:18:07.994 | 1.0 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id` IN (27, 28, 29, 32, 33, 34, 39, 40, 41, 42, 43, 44)) |
| 16 | 13:18:07.999 | 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`=4)) AND (`lang`='en') ORDER BY `rank` |
| 17 | 13:18:08.005 | 0.7 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id` IN (6, 7, 8, 9, 10, 12, 46)) |
| 18 | 13:18:08.009 | 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`=7)) AND (`lang`='en') ORDER BY `rank` |
| 19 | 13:18:08.011 | 0.5 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id`=16) |
| 20 | 13:18:08.014 | 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`=8)) AND (`lang`='en') ORDER BY `rank` |
| 21 | 13:18:08.021 | 0.7 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id` IN (17, 18, 19, 47, 48, 49, 50, 51, 52, 53)) |
| 22 | 13:18:08.024 | 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`='en') ORDER BY `rank` |
| 23 | 13:18:08.026 | 0.4 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id`=20) |
| 24 | 13:18:08.027 | 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`='en') ORDER BY `rank` |
| 25 | 13:18:08.030 | 0.3 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id` IN (21, 22, 23, 24, 25, 45)) |
| 26 | 13:18:08.032 | 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`=12)) AND (`lang`='en') ORDER BY `rank` |
| 27 | 13:18:08.033 | 0.2 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id`=26) |
| 28 | 13:18:08.034 | 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`=13)) AND (`lang`='en') ORDER BY `rank` |
| 29 | 13:18:08.035 | 0.2 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id`=35) |
| 30 | 13:18:08.036 | 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`='en') ORDER BY `rank` |
| 31 | 13:18:08.037 | 0.2 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id`=36) |
| 32 | 13:18:08.038 | 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`=15)) AND (`lang`='en') ORDER BY `rank` |
| 33 | 13:18:08.039 | 0.2 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id`=37) |
| 34 | 13:18:08.039 | 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`=16)) AND (`lang`='en') ORDER BY `rank` |
| 35 | 13:18:08.040 | 0.2 ms | yii\db\Command::query | SELECT * FROM `module_production_lang` WHERE (`lang`='en') AND (`owner_id`=38) |