Query:	SELECT *
	FROM phpbb_pa_cat
	ORDER BY cat_order ASC



id
select_type
table
type
possible_keys
key
key_len
ref
rows
affected_rows
Extra


1 
SIMPLE 
phpbb_pa_cat 
system 
 
 
 
 
0 
0 
const row not found 



Query:	SELECT *
	FROM phpbb_pa_files
	WHERE file_approved = '1'
	ORDER BY file_time DESC



id
select_type
table
type
possible_keys
key
key_len
ref
rows
affected_rows
Extra


1 
SIMPLE 
phpbb_pa_files 
ALL 
 
 
 
 
8 
0 
Using where; Using filesort 



Query:	SELECT *
	FROM phpbb_pa_cat
	ORDER BY cat_order ASC



id
select_type
table
type
possible_keys
key
key_len
ref
rows
affected_rows
Extra


1 
SIMPLE 
phpbb_pa_cat 
system 
 
 
 
 
0 
0 
const row not found 



pafiledb generated 3 queries,
spending 0.37200212478638 doing MySQL queries and 1.1924238204956 doing PHP things.