56,677
社区成员
发帖
与我相关
我的任务
分享
id select_type table type possible_keys key key_len ref rows Extra
------ ----------- ------ ------ --------------------------- --------- ------- ------ ------ ---------------------------
1 SIMPLE btitle ref BoardID_1,BoardID_2,deleted BoardID_2 1002 const 73468 Using where; Using filesort
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
-------- ---------- --------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- -------
bbstitle 0 PRIMARY 1 id A 47539 (NULL) (NULL) BTREE
bbstitle 1 BoardID_2 1 BoardID_2 A (NULL) 333 (NULL) YES BTREE
bbstitle 1 titleType 1 titleType A (NULL) (NULL) (NULL) YES BTREE
bbstitle 1 deleted 1 deleted A (NULL) (NULL) (NULL) YES BTREE
bbstitle 1 BoardID_1 1 BoardID_1 A (NULL) 333 (NULL) YES BTREE
bbstitle 1 user_id 1 user_id A (NULL) 333 (NULL) YES BTREE
select * from bbstitle where BoardID_1=? and BoardID_2=? and deleted=0 group by top desc,date desc limit ?,2;