页面执行时间太长，请各位大大帮忙看看
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>订单统计</title> <link rel="stylesheet" type="text/css" href="css/ui-lightness/jquery-ui-1.8.2.custom.css" /><link rel="stylesheet" type="text/css" href="css/style.css" /> <script src="js/jquery.js" type="text/javascript"></script> <script src="js/i18n/grid.locale-ja.js" type="text/javascript"></script> <script type='text/javascript' src='js/picnet.table.filter.min.js'></script> <script type="text/javascript" src="js/jquery.ui.core.js"></script> <script type="text/javascript" src="js/jquery.ui.widget.js"></script> <script type="text/javascript" src="js/jquery.ui.position.js"></script> <script type="text/javascript" src="js/jquery.ui.autocomplete.js"></script><!--<link rel="stylesheet" type="text/css" href="css/css.css" />--><!--<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>--><!--<link rel="stylesheet" type="text/css" href="css/style.css" />--><style type="text/css"> * { padding:0; margin:0; } body { font-family:verdana; font-size:12px; margin-left: 0px; margin-top: 0px; } .content { width:1200px; margin:20px 10px; } .content h1 { font-family:'??'; font-size:18px; padding-bottom:5px; } table { width:100%; } th, td { padding:6px 0; } th { background-color:#accdf4; color:#ffffff; } tr { background-color:#FFFFFE; } .odd { background-color:#FFFAFF; } .highlight { background-color:#E0E0E0;}.STYLE1 {font-size: 14px}.STYLE2 {font-size: 16px}</style></head><body><?PHPclass runtime{ var $StartTime = 0; var $StopTime = 0; function get_microtime() { list($usec, $sec) = explode(' ', microtime()); return ((float)$usec + (float)$sec); } function start() { $this->StartTime = $this->get_microtime(); } function stop() { $this->StopTime = $this->get_microtime(); } function spent() { return round(($this->StopTime - $this->StartTime) * 1000, 1); } }$runtime= new runtime;$runtime->start();include("conn.php");$to_date=date('Y-m-d');//按包装区域来统计邮件总数function sale_address_package_statistics($date,$account,$package){$sql="select `number` from `sale_orders` where `account`='$account' and date(`upload_date`) ='$date' GROUP BY `number`";$Result = mysql_query($sql);$number="(`number`='' ";while($rs = mysql_fetch_array($Result)){$number.=" or `number`=".$rs[0];}$number.=")";$sql_order_address="SELECT * FROM `sale_orders` T ";$sql_order_address.="WHERE ".$number;$sql_order_address.="AND `account` ='$account' ";if($package=='MIX'){$sql_order_address.="AND 1<(select count(*) from `sale_orders` where ".$number." AND `account` ='$account' AND `recipient_name`=T.`recipient_name` AND `ship_address_1`=T.`ship_address_1`) ";}else{$sql_order_address.="AND 1=(select count(*) from `sale_orders` where ".$number." AND `account` ='$account' AND `recipient_name`=T.`recipient_name` AND `ship_address_1`=T.`ship_address_1`) ";$sql_order_address.="AND `package_area`='$package' ";}$sql_order_address.="GROUP BY `recipient_name` , `ship_address_1`";$result_label = mysql_query($sql_order_address);$order_address=mysql_affected_rows();if(empty($order_address)){return 0;}else{return $order_address;}}?><h2 id="订单统计">订单统计</h2><div class="digg"> <table width="200" border="0" cellspacing="0"> <tr> <td width="72%"><table width="95%" border="0" cellspacing="1" bgcolor="#dddddd"> <tr> <td width="15%" align="center"> </td> <td align="center" bgcolor="eeeeee" colspan="3">PM_AC</td> <td align="center" bgcolor="eeeeee" colspan="3">CO_AC</td> <td align="center" bgcolor="eeeeee" colspan="3">UK_AC</td> <td align="center" bgcolor="eeeeee" colspan="3">UK_FR</td> <td align="center" bgcolor="eeeeee" colspan="3">UK_DE</td> </tr> <tr> <td width="25%" align="center"> </td> <td width="5%" align="center" bgcolor="eeeeee">SZ</td> <td width="5%" align="center" bgcolor="eeeeee">HK</td> <td width="5%" align="center" bgcolor="eeeeee">MIX</td> <td width="5%" align="center" bgcolor="eeeeee">SZ</td> <td width="5%" align="center" bgcolor="eeeeee">HK</td> <td width="5%" align="center" bgcolor="eeeeee">MIX</td> <td width="5%" align="center" bgcolor="eeeeee">SZ</td> <td width="5%" align="center" bgcolor="eeeeee">HK</td> <td width="5%" align="center" bgcolor="eeeeee">MIX</td> <td width="5%" align="center" bgcolor="eeeeee">SZ</td> <td width="5%" align="center" bgcolor="eeeeee">HK</td> <td width="5%" align="center" bgcolor="eeeeee">MIX</td> <td width="5%" align="center" bgcolor="eeeeee">SZ</td> <td width="5%" align="center" bgcolor="eeeeee">HK</td> <td width="5%" align="center" bgcolor="eeeeee">MIX</td> </tr> <tr> <td align="center" bgcolor="eeeeee"><span class="STYLE1"><?PHP echo $to_date;?></span></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'PM_AC','SZ'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'PM_AC','HK'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'PM_AC','MIX'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'CO_AC','SZ'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'CO_AC','HK'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'CO_AC','MIX') ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'UK_AC','SZ'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'UK_AC','HK'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'UK_AC','MIX'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'UK_FR','SZ'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'UK_FR','HK'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'UK_FR','MIX'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'UK_DE','SZ'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'UK_DE','HK'); ?></td> <td align="center"><?PHP echo sale_address_package_statistics($to_date,'UK_DE','MIX'); ?></td> </tr> </table> <?PHP $runtime->stop(); $runtimea= new runtime;$runtimea->start(); ?> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p></td> <td width="28%"></td> </tr></table></div><?PHP $runtimea->stop();echo "邮件统计页面执行时间: ".$runtime->spent()." 毫秒,订单统计页面执行时间:".$runtimea->spent()." 毫秒"; ?></body></html>这个页执行要75秒左右，这还只是显示一天的数据，实际上我需要显示一个月的数据
主要是那个查询语句的问题，以下语句如果查询的记录在1700条左右的时候，需要35秒
SELECT * FROM `sale_orders` T
WHERE (`number`='' or `number`=81)
AND 1=(select count(*) from `sale_orders`
where (`number`='' or `number`=81)
AND `recipient_name`=T.`recipient_name`
AND `ship_address_1`=T.`ship_address_1`)
AND `package_area`='SZ'
GROUP BY `recipient_name` , `ship_address_1`
请问怎么优化啊？显示一天的数据需要75秒，那一个月的数据不是等吃一餐饭还没显示完
回复讨论(解决方案)
具体情况需具体分析，毕竟不是在做文字游戏
调试查询指令应听从 EXPLAIN 的建议
尽量少用select * ，需要哪个字段查哪个，还有，加索引
数据表需要优化。
可否desc给大家看看呢
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1376
52
Working with Flash Session Data in Laravel
Mar 12, 2025 pm 05:08 PM
Laravel simplifies handling temporary session data using its intuitive flash methods. This is perfect for displaying brief messages, alerts, or notifications within your application. Data persists only for the subsequent request by default: $request-
cURL in PHP: How to Use the PHP cURL Extension in REST APIs
Mar 14, 2025 am 11:42 AM
The PHP Client URL (cURL) extension is a powerful tool for developers, enabling seamless interaction with remote servers and REST APIs. By leveraging libcurl, a well-respected multi-protocol file transfer library, PHP cURL facilitates efficient execution of various network protocols, including HTTP, HTTPS, and FTP. This extension offers granular control over HTTP requests, supports multiple concurrent operations, and provides built-in security features.
Alipay PHP SDK transfer error: How to solve the problem of 'Cannot declare class SignData'?
Apr 01, 2025 am 07:21 AM
Alipay PHP...
Simplified HTTP Response Mocking in Laravel Tests
Mar 12, 2025 pm 05:09 PM
Laravel provides concise HTTP response simulation syntax, simplifying HTTP interaction testing. This approach significantly reduces code redundancy while making your test simulation more intuitive. The basic implementation provides a variety of response type shortcuts: use Illuminate\Support\Facades\Http; Http::fake([ 'google.com' => 'Hello World', 'github.com' => ['foo' => 'bar'], 'forge.laravel.com' =>
12 Best PHP Chat Scripts on CodeCanyon
Mar 13, 2025 pm 12:08 PM
Do you want to provide real-time, instant solutions to your customers' most pressing problems? Live chat lets you have real-time conversations with customers and resolve their problems instantly. It allows you to provide faster service to your custom
Explain the concept of late static binding in PHP.
Mar 21, 2025 pm 01:33 PM
Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo
Customizing/Extending Frameworks: How to add custom functionality.
Mar 28, 2025 pm 05:12 PM
The article discusses adding custom functionality to frameworks, focusing on understanding architecture, identifying extension points, and best practices for integration and debugging.
Framework Security Features: Protecting against vulnerabilities.
Mar 28, 2025 pm 05:11 PM
Article discusses essential security features in frameworks to protect against vulnerabilities, including input validation, authentication, and regular updates.
