mysql> explain
-> select SQL_CALC_FOUND_ROWS tbl_item.g_no, tbl_item.ctrl_rowid ,tbl_item.rank , g_priority_order
-> from tbl_item
-> where
-> match(g_name_key) against('+AA +BB CC' in boolean mode)
-> and tbl_item.g_end_int > 1249953400
-> and tbl_item.g_class not like '0025%'
-> order by g_priority_order desc, tbl_item.rank desc,tbl_item.g_post_time desc limit 0, 30\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: tbl_item
type: fulltext
possible_keys: ndx_g_end_int,ndx_g_name_key
key: ndx_g_name_key
key_len: 0
ref:
rows: 1
Extra: Using where; Using filesort
1 row in set (0.00 sec)
