已测试MYSQL随机数据

SELECT * FROM `ff_vod` WHERE vod_id >= (SELECT floor(RAND() * (SELECT MAX(vod_id) FROM `ff_vod`)))  ORDER BY vod_id LIMIT 10
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0225 秒。) [vod_id: 567... - 2342...]
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0189 秒。) [vod_id: 569... - 2200...]

SELECT * FROM `ff_vod` WHERE vod_id >= (SELECT floor( RAND() * ((SELECT MAX(vod_id) FROM `ff_vod`)-(SELECT MIN(vod_id) FROM `ff_vod`)) + (SELECT MIN(vod_id)FROM `ff_vod`)))  ORDER BY vod_id LIMIT 10
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0144 秒。) [vod_id: 433... - 1648...]
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0243 秒。) [vod_id: 708... - 2721...]


SELECT * FROM `ff_vod` WHERE vod_id >= (SELECT floor( RAND() * ((SELECT MAX(vod_id) FROM `ff_vod`)-(SELECT MIN(vod_id) FROM `ff_vod`)) + (SELECT MIN(vod_id) FROM `ff_vod`))) and vod_addtime > '1539040000' ORDER BY vod_id LIMIT 10
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0483 秒。) [vod_id: 1118... - 4746...]
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0421 秒。) [vod_id: 1729... - 5039...]

SELECT * FROM `ff_vod` WHERE vod_id >= (SELECT floor( RAND() * ((SELECT MAX(vod_id) FROM `ff_vod`)-(SELECT MIN(vod_id) FROM `ff_vod`)) + (SELECT MIN(vod_id) FROM `ff_vod`))) and  `vod_cid` = '14' ORDER BY vod_id LIMIT 10
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.1213 秒。) [vod_id: 2350... - 10022...]
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0793 秒。) [vod_id: 3439... - 9172...]

SELECT * FROM `ff_vod`WHERE vod_id >= (SELECT floor(RAND() * (SELECT MAX(vod_id) FROM `ff_vod`))) ORDER BY vod_id LIMIT 10
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0206 秒。) [vod_id: 289... - 2377...]
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0232 秒。) [vod_id: 765... - 2317...]

SELECT * FROM `ff_vod` WHERE vod_id >= (SELECT floor( RAND() * ((SELECT MAX(vod_id) FROM `ff_vod`)-(SELECT MIN(vod_id) FROM `ff_vod`)) + (SELECT MIN(vod_id) FROM `ff_vod`))) ORDER BY vod_id LIMIT 10
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0173 秒。) [vod_id: 1157... - 2165...]
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0261 秒。) [vod_id: 788... - 2425...]

SELECT * FROM `ff_vod` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(vod_id) FROM `ff_vod`)-(SELECT MIN(vod_id) FROM `ff_vod`))+(SELECT MIN(vod_id) FROM `ff_vod`)) AS vod_id) AS t2 WHERE t1.vod_id >= t2.vod_id ORDER BY t1.vod_id LIMIT 10
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0011 秒。) [vod_id: 296042... - 296051...]
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0018 秒。) [vod_id: 222839... - 222848...]

SELECT * FROM `ff_vod` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(vod_id) FROM `ff_vod`)-(SELECT MIN(vod_id) FROM `ff_vod`))+(SELECT MIN(vod_id) FROM `ff_vod`)) AS vod_id) AS t2 WHERE t1.vod_id >= t2.vod_id and vod_addtime > '1539040000'ORDER BY t1.vod_id LIMIT 10
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.1225 秒。) [vod_id: 224576... - 227085...]
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0011 秒。) [vod_id: 4034... - 4043...]

搜索 vod_cid = 14 和 时间>1539040000  (2018-10-09 07:06:40)
SELECT * FROM `ff_vod` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(vod_id) FROM `ff_vod`)-(SELECT MIN(vod_id) FROM `ff_vod`))+(SELECT MIN(vod_id) FROM `ff_vod`)) AS vod_id) AS t2 WHERE t1.vod_id >= t2.vod_id and vod_addtime > '1539040000' AND `vod_cid`= '14' ORDER BY t1.vod_id LIMIT 10
正在显示第 0 - 9 行 (共 10 行, 查询花费 0.0623 秒。) [vod_id: 228164... - 228844...]

 

相关推荐

网友评论(0)