686e65894034a: GET https://stable.gymscope.com/au/type/small-medium-gym?IndexSearch[suburbLat]=-31.95&IndexSearch[suburbLon]=115.931&IndexSearch[suburb]=BELMONT,%20WA,%206104 at 2025-07-09 10:50:17 pm by 35.174.141.243
Log Messages
Total 45 items.
| # | Time | Level | Category | Message |
|---|---|---|---|---|
| 1 | 22:50:17.267 | info | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=gymstable2 |
| 2 | 22:50:17.267 | info | yii\db\Command::query | SELECT * FROM `type` WHERE `slug`='small-medium-gym' |
| 3 | 22:50:17.268 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `type` |
| 4 | 22:50:17.269 | info | 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 = 'type' AND kcu.table_name = 'type' |
| 5 | 22:50:17.271 | info | yii\db\Command::query | SELECT * FROM `meta` WHERE (`meta_type`='type') AND (`meta_id`=1) |
| 6 | 22:50:17.272 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `meta` |
| 7 | 22:50:17.272 | info | 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 = 'meta' AND kcu.table_name = 'meta' |
| 8 | 22:50:17.273 | info | yii\db\Command::query | SELECT `suburb`.* FROM `suburb` LEFT JOIN `gymDetail` ON suburb.id = gymDetail.suburbId WHERE (`gymDetail`.`status`=1) AND (`gymDetail`.`studioId`=1) |
| 9 | 22:50:17.273 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `suburb` |
| 10 | 22:50:17.273 | info | 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 = 'suburb' AND kcu.table_name = 'suburb' |
| 11 | 22:50:17.274 | info | yii\db\Command::query | SELECT `id`, `is_mini_list`, (6371 /1 * acos( cos(radians(-31.95)) * cos(radians(gymDetail.lat)) * cos(radians(gymDetail.lon) - radians(115.931)) + sin(radians(-31.95)) * sin(radians(gymDetail.lat)) ) ) AS `distance` FROM `gymDetail` WHERE (`status` = 1) AND (studioId=1) ORDER BY `gymDetail`.`is_mini_list`, `distance` LIMIT 10 |
| 12 | 22:50:17.275 | info | yii\db\Command::query | SELECT * FROM `gymDetail` WHERE `id` IN (-1, '143', '217', '229', '208', '165', '154') ORDER BY FIELD (id, -1,143,217,229,208,165,154) |
| 13 | 22:50:17.276 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `gymDetail` |
| 14 | 22:50:17.277 | info | 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 = 'gymDetail' AND kcu.table_name = 'gymDetail' |
| 15 | 22:50:17.278 | info | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id` IN (973, 2407, 8480, 11872, 279) |
| 16 | 22:50:17.278 | info | yii\db\Command::query | SELECT * FROM `gymDetailMedia` WHERE `gymDetailId` IN (143, 217, 229, 208, 165, 154) |
| 17 | 22:50:17.278 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `gymDetailMedia` |
| 18 | 22:50:17.279 | info | 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 = 'gymDetailMedia' AND kcu.table_name = 'gymDetailMedia' |
| 19 | 22:50:17.279 | info | yii\db\Command::query | SELECT * FROM `gymDetailImage` WHERE `gymDetailId` IN (143, 217, 229, 208, 165, 154) |
| 20 | 22:50:17.280 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `gymDetailImage` |
| 21 | 22:50:17.280 | info | 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 = 'gymDetailImage' AND kcu.table_name = 'gymDetailImage' |
| 22 | 22:50:17.281 | info | yii\db\Command::query | SELECT * FROM `gymDetailPrice` WHERE `gymDetailId` IN (143, 217, 229, 208, 165, 154) |
| 23 | 22:50:17.281 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `gymDetailPrice` |
| 24 | 22:50:17.282 | info | 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 = 'gymDetailPrice' AND kcu.table_name = 'gymDetailPrice' |
| 25 | 22:50:17.289 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 26 | 22:50:17.290 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 27 | 22:50:17.290 | info | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=973 |
| 28 | 22:50:17.292 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 29 | 22:50:17.292 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 30 | 22:50:17.292 | info | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=2407 |
| 31 | 22:50:17.293 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 32 | 22:50:17.293 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 33 | 22:50:17.294 | info | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=8480 |
| 34 | 22:50:17.295 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 35 | 22:50:17.295 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 36 | 22:50:17.295 | info | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=8480 |
| 37 | 22:50:17.296 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 38 | 22:50:17.296 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 39 | 22:50:17.297 | info | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=11872 |
| 40 | 22:50:17.298 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 41 | 22:50:17.298 | info | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 42 | 22:50:17.298 | info | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=279 |
| 43 | 22:50:17.300 | info | yii\db\Command::query | SHOW FULL COLUMNS FROM `url_meta` |
| 44 | 22:50:17.300 | info | 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 = 'url_meta' AND kcu.table_name = 'url_meta' |
| 45 | 22:50:17.301 | info | yii\db\Command::query | SELECT * FROM `url_meta` WHERE `url`='/type/small-medium-gym?IndexSearch%5BsuburbLat%5D=-31.95&IndexSearch%5BsuburbLon%5D=115.931&IndexSearch%5Bsuburb%5D=BELMONT%2C+WA%2C+6104' |