PHP MYSQL精确测试SQL语句执行时间

来源：互联网发布：宁泽涛扒皮知乎编辑：程序博客网时间：2024/06/01 10:17

<?phprequire("database.php");$query = "select id,title,content,createtime from content order by createtime asc limit 5000";$result = mysql_query($query,$link);$queryb = "select unix_timestamp(now()) as starttime";$querye = "select unix_timestamp(now()) as endtime";$resultb = mysql_query($queryb,$link);$rowb = mysql_fetch_assoc($resultb);echo $rowb['starttime'];while($array = mysql_fetch_array($result)){?> <dl> <dt><?php echo $array['title']."--".$array['id']."发表时间：".$array['createtime'];?></dt> <dd><?php echo $array['content']; ?></dd> </dl><?php}$resulte = mysql_query($querye,$link);$rowe = mysql_fetch_assoc($resulte);echo $rowe['endtime'];$t = ($rowe['endtime'] - $rowb['starttime'])/1000;echo "<br/>执行时间为:".$t."s";mysql_close($link);?>

原文地址：http://purplegourd.com/2010/10/26/php-mysql%e7%b2%be%e7%a1%ae%e6%b5%8b%e8%af%95sql%e8%af%ad%e5%8f%a5%e6%89%a7%e8%a1%8c%e6%97%b6%e9%97%b4/