网站打开慢排查基本思想

多次执行，查看慢查询

show full processlist

SHOW VARIABLES like '%pro%'

查看字段条件列的唯一性

SELECT COUNT(DISTINCT id) FROM nr_order

SELECT ADDTIME from nr_order limit 5