explain extended 获取mysql优化后的sql

最新推荐文章于 2024-07-23 13:12:50 发布

kf_panda

最新推荐文章于 2024-07-23 13:12:50 发布

阅读量926

点赞数 1

分类专栏： MYSQL索引&SQL优化&服务器优化

本文链接：https://blog.csdn.net/gua___gua/article/details/50818585

版权

MYSQL索引&SQL优化&服务器优化专栏收录该内容

26 篇文章 0 订阅

订阅专栏

explain extended 
SELECT
 jlbh,
 kkbh,
 hphm,
 jgsj,
 clsd
FROM
 sjkk_gcjl s
WHERE
 1 = 1
AND hphm LIKE '%77'
AND jgsj >= '2015-11-10 19:59:59'
AND jgsj <= '2015-11-10 23:59:59'
AND hpys = '2'
ORDER BY
 jgsj DESC,
 jlbh DESC
LIMIT 100;

+----+-------------+-------+------+-------------------------+---------+---------+-------+---------+----------+--------------------------+
| id | select_type | table | type | possible_keys           | key     | key_len | ref   | rows    | filtered | Extra                    |
+----+-------------+-------+------+-------------------------+---------+---------+-------+---------+----------+--------------------------+
|  1 | SIMPLE      | s     | ref  | index04,index10,index14 | index10 | 5       | const | 2394655 |   100.00 | Using where; Using index |
+----+-------------+-------+------+-------------------------+---------+---------+-------+---------+----------+--------------------------+

show warnings;

SELECT
 `pvd_50yi`.`s`.`jlbh` AS `jlbh`,
 `pvd_50yi`.`s`.`kkbh` AS `kkbh`,
 `pvd_50yi`.`s`.`hphm` AS `hphm`,
 `pvd_50yi`.`s`.`jgsj` AS `jgsj`,
 `pvd_50yi`.`s`.`clsd` AS `clsd`
FROM
 `pvd_50yi`.`sjkk_gcjl` `s`
WHERE
 (
  (
   `pvd_50yi`.`s`.`hphm` LIKE '%77'
  )
  AND (
   `pvd_50yi`.`s`.`jgsj` >= '2015-11-10 19:59:59'
  )
  AND (
   `pvd_50yi`.`s`.`jgsj` <= '2015-11-10 23:59:59'
  )
  AND (`pvd_50yi`.`s`.`hpys` = '2')
 )
ORDER BY
 `pvd_50yi`.`s`.`jgsj` DESC,
 `pvd_50yi`.`s`.`jlbh` DESC
LIMIT 100;