| #254 | //$sql = "SELECT id FROM {$table_full} WHERE id >= ((SELECT MAX(id) FROM {$table_full})-(SELECT MIN(id) FROM {$table_full})) * RAND() + (SELECT MIN(id) FROM {$table_full}) LIMIT 1";//这个sql一直在小范围循环 |
| #255 | $sql = "SELECT t1.id FROM {$table_full} AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM {$table_full})) AS id) AS t2 WHERE t1.id >= t2.id LIMIT 1"; //这里不能是limit 多条，多条的话是连续的id |
| #256 | $arr = $run->db->fetch_first($sql); |
| #257 | if($arr && !in_array($arr['id'], $keys)){ |
| #258 | $keys[] = $arr['id']; |
| #259 | $i++; |
| #260 | } |
| #261 | } |
| #262 | // 读取内容列表 |
| #263 | $list_arr = $run->cms_content->mget($keys); |