Home >Database >Mysql Tutorial >select-mysql语句查询时间过长如何优化?
select-mysql语句查询时间过长如何优化?
- WBOYOriginal
- 2016-06-06 09:37:111403browse
selectmysql数据sql优化
SELECT t1.id, t1.order_no, t1.order_status, t1.pay_status,t1.shipping_status,
t1.pay_method, t1.invoice, t1.remark, t1.seller, t1.buyer, t1.site_id, t1.order_time, t1.pay_time,
t1.sign_for_time, t1.delivery_time, t1.subtotal, t1.freight, t1.invitation, t1.cope, t1.is_comment,t1.pay_discount FROM zcwl_order t1 LEFT JOIN
zcwl_order_shipping_address t2 ON t2.order_id = t1.id
WHERE t1.site_id ORDER BY t1.order_time DESC
<code>这条sql语句需要查14秒 如何缩短时间?ps:大概有1W条数据</code>
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql-请问Jan 1, 2015 6:01:01 AM如何转化为datetime类型Next article：mysql双向触发器怎么样避免死循环