686e4c352b69c: GET https://stable.gymscope.com/au/24-hour-gyms?IndexSearch[suburbLat]=-31.9386&IndexSearch[suburbLon]=115.946&IndexSearch[suburb]=REDCLIFFE,%2BWA,%2B6104 at 2025-07-09 09:02:13 pm by 18.215.77.19
Performance Profiling
Total processing time: 59 ms; Peak memory: 4.590 MB.
Total 68 items.
| # | Time | Duration | Category | Info |
|---|---|---|---|---|
| 1 | 21:02:13.181 | 0.4 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=gymstable2 |
| 2 | 21:02:13.181 | 0.1 ms | yii\db\Command::query | SELECT * FROM `page` WHERE `slug`='24-hour-gyms' |
| 3 | 21:02:13.183 | 0.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `page` |
| 4 | 21:02:13.183 | 0.3 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 = 'page' AND kcu.table_name = 'page' |
| 5 | 21:02:13.184 | 0.1 ms | yii\db\Command::query | SELECT * FROM `meta` WHERE (`meta_type`='page') AND (`meta_id`=2) |
| 6 | 21:02:13.184 | 0.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `meta` |
| 7 | 21:02:13.185 | 0.3 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 = 'meta' AND kcu.table_name = 'meta' |
| 8 | 21:02:13.185 | 0.1 ms | yii\db\Command::query | SELECT * FROM `page_type` WHERE `pageId`=2 |
| 9 | 21:02:13.185 | 0.1 ms | yii\db\Command::query | SELECT `suburb`.* FROM `suburb` LEFT JOIN `gymDetail` ON suburb.id = gymDetail.suburbId WHERE `gymDetail`.`status`=1 |
| 10 | 21:02:13.185 | 0.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `suburb` |
| 11 | 21:02:13.186 | 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 = 'suburb' AND kcu.table_name = 'suburb' |
| 12 | 21:02:13.187 | 0.3 ms | yii\db\Command::query | SELECT `id`, `is_mini_list`, (6371 /1 * acos( cos(radians(-31.9386)) * cos(radians(gymDetail.lat)) * cos(radians(gymDetail.lon) - radians(115.946)) + sin(radians(-31.9386)) * sin(radians(gymDetail.lat)) ) ) AS `distance` FROM `gymDetail` WHERE (`checkOpen24`=1) AND (`status` = 1) ORDER BY `gymDetail`.`is_mini_list`, `distance` LIMIT 10 |
| 13 | 21:02:13.187 | 0.3 ms | yii\db\Command::query | SELECT * FROM `gymDetail` WHERE `id` IN (-1, '143', '139', '134', '217', '153', '232', '210', '229', '165', '147') ORDER BY FIELD (id, -1,143,139,134,217,153,232,210,229,165,147) |
| 14 | 21:02:13.189 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `gymDetail` |
| 15 | 21:02:13.190 | 0.3 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 = 'gymDetail' AND kcu.table_name = 'gymDetail' |
| 16 | 21:02:13.191 | 0.2 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id` IN (973, 2407, 1607, 13863, 8480, 11872, 2463) |
| 17 | 21:02:13.191 | 0.3 ms | yii\db\Command::query | SELECT * FROM `gymDetailMedia` WHERE `gymDetailId` IN (143, 139, 134, 217, 153, 232, 210, 229, 165, 147) |
| 18 | 21:02:13.192 | 0.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `gymDetailMedia` |
| 19 | 21:02:13.192 | 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 = 'gymDetailMedia' AND kcu.table_name = 'gymDetailMedia' |
| 20 | 21:02:13.193 | 0.3 ms | yii\db\Command::query | SELECT * FROM `gymDetailImage` WHERE `gymDetailId` IN (143, 139, 134, 217, 153, 232, 210, 229, 165, 147) |
| 21 | 21:02:13.193 | 0.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `gymDetailImage` |
| 22 | 21:02:13.193 | 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 = 'gymDetailImage' AND kcu.table_name = 'gymDetailImage' |
| 23 | 21:02:13.194 | 0.4 ms | yii\db\Command::query | SELECT * FROM `gymDetailPrice` WHERE `gymDetailId` IN (143, 139, 134, 217, 153, 232, 210, 229, 165, 147) |
| 24 | 21:02:13.194 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `gymDetailPrice` |
| 25 | 21:02:13.195 | 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 = 'gymDetailPrice' AND kcu.table_name = 'gymDetailPrice' |
| 26 | 21:02:13.208 | 0.3 ms | yii\db\Command::query | SELECT `name` FROM `type` WHERE `id`=1 |
| 27 | 21:02:13.208 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `type` |
| 28 | 21:02:13.209 | 0.3 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 = 'type' AND kcu.table_name = 'type' |
| 29 | 21:02:13.211 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 30 | 21:02:13.211 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 31 | 21:02:13.211 | 0.1 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=973 |
| 32 | 21:02:13.213 | 0.1 ms | yii\db\Command::query | SELECT `name` FROM `type` WHERE `id`=2 |
| 33 | 21:02:13.213 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 34 | 21:02:13.213 | 0.0 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 35 | 21:02:13.213 | 0.1 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=973 |
| 36 | 21:02:13.214 | 0.1 ms | yii\db\Command::query | SELECT `name` FROM `type` WHERE `id`=4 |
| 37 | 21:02:13.215 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 38 | 21:02:13.215 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 39 | 21:02:13.215 | 0.1 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=2407 |
| 40 | 21:02:13.216 | 0.1 ms | yii\db\Command::query | SELECT `name` FROM `type` WHERE `id`=1 |
| 41 | 21:02:13.216 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 42 | 21:02:13.216 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 43 | 21:02:13.217 | 0.1 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=2407 |
| 44 | 21:02:13.218 | 0.1 ms | yii\db\Command::query | SELECT `name` FROM `type` WHERE `id`=2 |
| 45 | 21:02:13.218 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 46 | 21:02:13.218 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 47 | 21:02:13.218 | 0.1 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=1607 |
| 48 | 21:02:13.219 | 0.1 ms | yii\db\Command::query | SELECT `name` FROM `type` WHERE `id`=2 |
| 49 | 21:02:13.219 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 50 | 21:02:13.220 | 0.1 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=13863 |
| 51 | 21:02:13.220 | 0.1 ms | yii\db\Command::query | SELECT `name` FROM `type` WHERE `id`=10 |
| 52 | 21:02:13.221 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 53 | 21:02:13.221 | 0.0 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=8480 |
| 54 | 21:02:13.222 | 0.1 ms | yii\db\Command::query | SELECT `name` FROM `type` WHERE `id`=1 |
| 55 | 21:02:13.222 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 56 | 21:02:13.222 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 57 | 21:02:13.222 | 0.1 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=8480 |
| 58 | 21:02:13.223 | 0.1 ms | yii\db\Command::query | SELECT `name` FROM `type` WHERE `id`=1 |
| 59 | 21:02:13.224 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 60 | 21:02:13.224 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 61 | 21:02:13.224 | 0.1 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=11872 |
| 62 | 21:02:13.225 | 0.1 ms | yii\db\Command::query | SELECT `name` FROM `type` WHERE `id`=2 |
| 63 | 21:02:13.225 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 64 | 21:02:13.226 | 0.1 ms | yii\db\Command::query | SELECT `id`, `name` FROM `chain` |
| 65 | 21:02:13.226 | 0.1 ms | yii\db\Command::query | SELECT * FROM `suburb` WHERE `id`=2463 |
| 66 | 21:02:13.227 | 0.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `url_meta` |
| 67 | 21:02:13.228 | 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 = 'url_meta' AND kcu.table_name = 'url_meta' |
| 68 | 21:02:13.228 | 0.2 ms | yii\db\Command::query | SELECT * FROM `url_meta` WHERE `url`='/24-hour-gyms?IndexSearch%5BsuburbLat%5D=-31.9386&IndexSearch%5BsuburbLon%5D=115.946&IndexSearch%5Bsuburb%5D=REDCLIFFE%2C%2BWA%2C%2B6104' |