tp5查询

时间:2025-02-23 07:35:58
写个循环验证下 
$time1 = time(); 
for ($i=0; $i<=10000; $i++) { 
Db::table('oa_test')->where('status',1)->select(); 

$time2 = time(); 
$time = $time2-$time1; 
var_dump($time); 
大概用时4秒。 
跟这样写效果一样的 
$time1 = time(); 
for ($i=0; $i<=10000; $i++) { 
$a = db('test', [], false)->where('status',1)->select(); 

$time2 = time(); 
$time = $time2-$time1; 
var_dump($time); 
如果这么写: 
$time1 = time(); 
for ($i=0; $i<=10000; $i++) { 
$a = db('test')->where('status',1)->select(); 

$time2 = time(); 
$time = $time2-$time1; 
var_dump($time); 
直接超时报错了,所以频繁查询建议db('test', [], false)->where('status',1)->select();