Query: SELECT *
FROM phpbb_pa_cat
ORDER BY cat_order ASC
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
affected_rows |
Extra |
phpbb_pa_cat |
ALL |
|
|
|
|
7 |
7 |
Using filesort |
Query: SELECT *
FROM phpbb_pa_files
WHERE file_approved = '1'
ORDER BY file_time DESC
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
affected_rows |
Extra |
phpbb_pa_files |
ALL |
|
|
|
|
15 |
15 |
where used; Using filesort |
Query: SELECT *
FROM phpbb_pa_cat
ORDER BY cat_order ASC
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
affected_rows |
Extra |
phpbb_pa_cat |
ALL |
|
|
|
|
7 |
7 |
Using filesort |
The pafiledb Mod generated 3 queries,
spending 0.173147797585 doing MySQL queries and 6.22473716736 doing PHP things.