686e50f743fe3: GET https://stable.gymscope.com/au/location/st+james-wa-6102 at 2025-07-09 09:22:31 pm by 85.208.96.202
Database Queries
Total 54 items.
| # | Time | Duration | Type | Query |
|---|---|---|---|---|
| 1 | 21:22:31.282 | 4.9 ms | SELECT | SELECT `id` FROM `suburb` WHERE (`name`='ST JAMES') AND (`state`='WA') |
| 2 | 21:22:31.294 | 0.7 ms | SHOW | SHOW FULL COLUMNS FROM `gymDetailPrice` |
| 3 | 21:22:31.287 | 0.7 ms | SELECT | SELECT `meta`.* FROM `meta` INNER JOIN `location` `l` ON l.id = meta.meta_id WHERE `l`.`suburbId`='12464' ORDER BY `id` DESC |
| 4 | 21:22:31.290 | 0.6 ms | SHOW | SHOW FULL COLUMNS FROM `gymDetail` |
| 5 | 21:22:31.304 | 0.5 ms | SHOW | SHOW FULL COLUMNS FROM `type` |
| 6 | 21:22:31.281 | 0.5 ms | SHOW | SHOW FULL COLUMNS FROM `suburb` |
| 7 | 21:22:31.292 | 0.5 ms | SHOW | SHOW FULL COLUMNS FROM `gymDetailMedia` |
| 8 | 21:22:31.314 | 0.4 ms | SHOW | SHOW FULL COLUMNS FROM `location` |
| 9 | 21:22:31.313 | 0.4 ms | SELECT | SELECT * FROM `location` WHERE `id`=15 |
| 10 | 21:22:31.288 | 0.4 ms | SHOW | SHOW FULL COLUMNS FROM `meta` |
| 11 | 21:22:31.316 | 0.4 ms | SHOW | SHOW FULL COLUMNS FROM `url_meta` |
| 12 | 21:22:31.314 | 0.4 ms | SELECT | 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 = 'location' AND kcu.table_name = 'location' |
| 13 | 21:22:31.289 | 0.3 ms | SELECT | SELECT `id`, `is_mini_list`, (6371 /1 * acos( cos(radians(-31.9995)) * cos(radians(gymDetail.lat)) * cos(radians(gymDetail.lon) - radians(115.909)) + sin(radians(-31.9995)) * sin(radians(gymDetail.lat)) ) ) AS `distance` FROM `gymDetail` WHERE `status` = 1 HAVING `distance` < 10 ORDER BY `gymDetail`.`is_mini_list`, `distance` LIMIT 10 |
| 14 | 21:22:31.280 | 0.3 ms | SELECT | SELECT * FROM `suburb` WHERE (`name`='st james') AND (`state`='wa') AND (`zip`='6102') GROUP BY `name` |
| 15 | 21:22:31.293 | 0.3 ms | SHOW | SHOW FULL COLUMNS FROM `gymDetailImage` |
| 16 | 21:22:31.291 | 0.3 ms | SELECT | 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' |
| 17 | 21:22:31.281 | 0.3 ms | SELECT | 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' |
| 18 | 21:22:31.295 | 0.2 ms | SELECT | 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' |
| 19 | 21:22:31.305 | 0.2 ms | SELECT | 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' |
| 20 | 21:22:31.293 | 0.2 ms | SELECT | 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' |
| 21 | 21:22:31.288 | 0.2 ms | SELECT | 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' |
| 22 | 21:22:31.316 | 0.2 ms | SELECT | 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' |
| 23 | 21:22:31.294 | 0.2 ms | SELECT | 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' |
| 24 | 21:22:31.294 | 0.2 ms | SELECT | SELECT * FROM `gymDetailPrice` WHERE `gymDetailId` IN (167, 217, 134, 139, 143) |
| 25 | 21:22:31.316 | 0.1 ms | SELECT | SELECT * FROM `url_meta` WHERE `url`='/location/st+james-wa-6102' |
| 26 | 21:22:31.290 | 0.1 ms | SELECT | SELECT * FROM `gymDetail` WHERE `id` IN (-1, '167', '217', '134', '139', '143') ORDER BY FIELD (id, -1,167,217,134,139,143) |
| 27 | 21:22:31.312 | 0.1 ms | SELECT | SELECT `id`, `name` FROM `chain` |
| 28 | 21:22:31.304 | 0.1 ms | SELECT | SELECT `name` FROM `type` WHERE `id`=10 |
| 29 | 21:22:31.307 | 0.1 ms | SELECT | SELECT `id`, `name` FROM `chain` |
| 30 | 21:22:31.297 | 0.1 ms | SELECT | SELECT `name`, `type`.`id` FROM `type` WHERE `isDeleted`=0 |
| 31 | 21:22:31.293 | 0.1 ms | SELECT | SELECT * FROM `gymDetailImage` WHERE `gymDetailId` IN (167, 217, 134, 139, 143) |
| 32 | 21:22:31.308 | 0.1 ms | SELECT | SELECT * FROM `suburb` WHERE `id`=2407 |
| 33 | 21:22:31.311 | 0.1 ms | SELECT | SELECT * FROM `suburb` WHERE `id`=973 |
| 34 | 21:22:31.305 | 0.1 ms | SELECT | SELECT `id`, `name` FROM `chain` |
| 35 | 21:22:31.292 | 0.1 ms | SELECT | SELECT * FROM `suburb` WHERE `id` IN (2407, 973) |
| 36 | 21:22:31.312 | 0.1 ms | SELECT | SELECT `name` FROM `type` WHERE `id`=1 |
| 37 | 21:22:31.311 | 0.1 ms | SELECT | SELECT `id`, `name` FROM `chain` |
| 38 | 21:22:31.315 | 0.1 ms | SELECT | SELECT * FROM `location` WHERE `id`=15 |
| 39 | 21:22:31.292 | 0.1 ms | SELECT | SELECT * FROM `gymDetailMedia` WHERE `gymDetailId` IN (167, 217, 134, 139, 143) |
| 40 | 21:22:31.309 | 0.1 ms | SELECT | SELECT `id`, `name` FROM `chain` |
| 41 | 21:22:31.309 | 0.1 ms | SELECT | SELECT `name` FROM `type` WHERE `id`=4 |
| 42 | 21:22:31.307 | 0.1 ms | SELECT | SELECT `name` FROM `type` WHERE `id`=1 |
| 43 | 21:22:31.312 | 0.1 ms | SELECT | SELECT `id`, `name` FROM `chain` |
| 44 | 21:22:31.289 | 0.1 ms | SELECT | SELECT `meta`.* FROM `meta` INNER JOIN `location` `l` ON l.id = meta.meta_id WHERE `l`.`suburbId`='12464' ORDER BY `id` DESC |
| 45 | 21:22:31.306 | 0.1 ms | SELECT | SELECT * FROM `suburb` WHERE `id`=2407 |
| 46 | 21:22:31.309 | 0.1 ms | SELECT | SELECT `id`, `name` FROM `chain` |
| 47 | 21:22:31.309 | 0.1 ms | SELECT | SELECT * FROM `suburb` WHERE `id`=2407 |
| 48 | 21:22:31.310 | 0.1 ms | SELECT | SELECT `name` FROM `type` WHERE `id`=2 |
| 49 | 21:22:31.310 | 0.1 ms | SELECT | SELECT `id`, `name` FROM `chain` |
| 50 | 21:22:31.312 | 0.1 ms | SELECT | SELECT * FROM `suburb` WHERE `id`=973 |
| 51 | 21:22:31.307 | 0.1 ms | SELECT | SELECT `id`, `name` FROM `chain` |
| 52 | 21:22:31.305 | 0.0 ms | SELECT | SELECT `id`, `name` FROM `chain` |
| 53 | 21:22:31.315 | 0.0 ms | SELECT | SELECT * FROM `location` WHERE `id`=15 |
| 54 | 21:22:31.288 | 0.0 ms | SELECT | SELECT `id` FROM `suburb` WHERE (`name`='ST JAMES') AND (`state`='WA') |