68256822c2fdb: GET https://unitrip.club/tours at 2025-05-15 04:05:54 am by 66.249.69.3
Performance Profiling
Total processing time: 64 ms; Peak memory: 2.369 MB. Show Profiling Timeline
Всего 33 записи.
| Time | Duration | Category | Info |
|---|---|---|---|
| 04:05:54.812 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `tour` |
| 04:05:54.843 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `user` |
| 04:05:54.820 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `tour_image` |
| 04:05:54.801 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `country` |
| 04:05:54.806 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `tour_category` |
| 04:05:54.822 | 1.6 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` = 'tour_image' AND `kcu`.`TABLE_NAME` = 'tour_image' |
| 04:05:54.814 | 1.5 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` = 'tour' AND `kcu`.`TABLE_NAME` = 'tour' |
| 04:05:54.803 | 1.5 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` = 'country' AND `kcu`.`TABLE_NAME` = 'country' |
| 04:05:54.808 | 1.5 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` = 'tour_category' AND `kcu`.`TABLE_NAME` = 'tour_category' |
| 04:05:54.818 | 1.5 ms | yii\db\Command::query | SELECT * FROM `tour_image` WHERE (`status`=1) AND (`is_main`=1) AND (`tour_id` IN (1, 2, 4, 5, 6, 8, 10, 12, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 31, 33, 34, 35, 36, 37, 38, 39)) |
| 04:05:54.835 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `tour_reviews` |
| 04:05:54.827 | 1.4 ms | yii\db\Command::query | SELECT * FROM `tour` WHERE (price_full > 0) AND (multi_days != 1) ORDER BY `price_full` LIMIT 27 |
| 04:05:54.837 | 1.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` = 'tour_reviews' AND `kcu`.`TABLE_NAME` = 'tour_reviews' |
| 04:05:54.845 | 1.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` = 'user' AND `kcu`.`TABLE_NAME` = 'user' |
| 04:05:54.840 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `tour_reviews_img` |
| 04:05:54.811 | 1.0 ms | yii\db\Command::query | SELECT * FROM `tour` WHERE (`status`=1) AND (`multi_days`=0) LIMIT 27 |
| 04:05:54.830 | 1.0 ms | yii\db\Command::query | SELECT * FROM `tour_image` WHERE (`status`=1) AND (`is_main`=1) AND (`tour_id` IN (165, 161, 152, 172, 149, 156, 166, 65, 80, 158, 154, 168, 160, 162, 167, 135, 63, 130, 105, 121, 67, 141, 76, 98, 164, 66, 111)) |
| 04:05:54.841 | 0.9 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` = 'tour_reviews_img' AND `kcu`.`TABLE_NAME` = 'tour_reviews_img' |
| 04:05:54.800 | 0.8 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=unitrip_db_9 |
| 04:05:54.826 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `tour` WHERE (`status`=1) AND (`multi_days`=0) |
| 04:05:54.825 | 0.6 ms | yii\db\Command::query | SELECT * FROM `tour_calendar` WHERE (`tc_day` > '2025-05-01') AND (`tc_tour_id` IN (1, 2, 4, 5, 6, 8, 10, 12, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 31, 33, 34, 35, 36, 37, 38, 39)) ORDER BY `tc_day` LIMIT 3 |
| 04:05:54.832 | 0.6 ms | yii\db\Command::query | SELECT * FROM `tour_calendar` WHERE (`tc_day` > '2025-05-01') AND (`tc_tour_id` IN (165, 161, 152, 172, 149, 156, 166, 65, 80, 158, 154, 168, 160, 162, 167, 135, 63, 130, 105, 121, 67, 141, 76, 98, 164, 66, 111)) ORDER BY `tc_day` LIMIT 3 |
| 04:05:54.835 | 0.5 ms | yii\db\Command::query | SELECT * FROM `tour_reviews` WHERE `r_tour_id` IN (1, 2, 4, 5, 6, 8, 10, 12, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 31, 33, 34, 35, 36, 37, 38, 39) ORDER BY `r_verified_person` DESC, `r_create` DESC LIMIT 10 |
| 04:05:54.833 | 0.5 ms | yii\db\Command::query | SELECT `id` FROM `tour` WHERE (price_full > 0) AND (multi_days != 1) ORDER BY `price_full` LIMIT 27 |
| 04:05:54.847 | 0.5 ms | yii\db\Command::query | SELECT * FROM `tour` WHERE `id` IN (21, 1, 20, 28, 5, 2) |
| 04:05:54.839 | 0.4 ms | yii\db\Command::query | SELECT * FROM `tour_reviews_img` WHERE `ri_r_id` IN (70, 71, 67, 56, 53, 54, 55, 52, 49, 44) |
| 04:05:54.801 | 0.4 ms | yii\db\Command::query | SELECT * FROM `country` ORDER BY `sort` DESC |
| 04:05:54.806 | 0.3 ms | yii\db\Command::query | SELECT * FROM `tour_category` ORDER BY `sort` DESC |
| 04:05:54.843 | 0.3 ms | yii\db\Command::query | SELECT * FROM `user` WHERE `id` IN (462, 465, 457) |
| 04:05:54.833 | 0.3 ms | yii\db\Command::query | SELECT * FROM `tours_seo` WHERE `ts_url`='/tours' |
| 04:05:54.848 | 0.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `tour_reviews` WHERE `r_tour_id` IN (1, 2, 4, 5, 6, 8, 10, 12, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 31, 33, 34, 35, 36, 37, 38, 39) |
| 04:05:54.834 | 0.3 ms | yii\db\Command::query | SELECT * FROM `faq` WHERE `faq_url`='/tours' ORDER BY `faq_order` |
| 04:05:54.849 | 0.2 ms | yii\db\Command::query | SELECT * FROM `tour_calendar` WHERE `tc_day` >= '2025-05-15' ORDER BY `tc_day` |