1 0.223 ms SELECT * FROM uchome_session WHERE uid='1'
Explain id select_type table type possible_keys key key_len ref rows Extra
uchome_session const PRIMARY PRIMARY 3 const 1 -
2 0.262 ms SELECT sf.*, s.* FROM uchome_space s LEFT JOIN uchome_spacefield sf ON sf.uid=s.uid WHERE s.uid='1'
Explain id select_type table type possible_keys key key_len ref rows Extra
s const PRIMARY PRIMARY 3 const 1 -
3 0.269 ms SELECT * FROM uchome_userapp WHERE uid='1' ORDER BY menuorder DESC
Explain id select_type table type possible_keys key key_len ref rows Extra
uchome_userapp ref uid,menuorder,displayorder uid 3 const 5 Using where; Using filesort