绝对随机查询,效率有待考证,12W条数据查询20条耗时在0.29秒以内
SELECT * FROM `tbl_cosmetic` `t` WHERE t.id in (select ss.id from (select id from tbl_cosmetic order by rand() limit 20)as ss)
绝对随机查询,效率有待考证,12W条数据查询20条耗时在0.29秒以内
SELECT * FROM `tbl_cosmetic` `t` WHERE t.id in (select ss.id from (select id from tbl_cosmetic order by rand() limit 20)as ss)