Question

### Error querying database. Cause: java.sql.SQLException: Query execution was interrupted

没有任何查询条件的时候分页查询比较慢，数据1000~2000条左右，服务器Linux+Tomcat，但是我搜索“广东”时查询时间更慢，还会报错，但是在数据量比较少的时候则没有问题，求解答。

09:25:38.527 [http-bio-4010-exec-80] ERROR c.w.o.f.web.FollowerControllers -
### Error querying database. Cause: java.sql.SQLException: Query execution was interrupted
### The error may exist in cn/wonhigh/o2o/follower/dal/database/FollowerMapper.xml
### The error may involve cn.wonhigh.o2o.follower.dal.database.FollowerMapper.getByFollower-Inline
### The error occurred while setting parameters
### SQL: SELECT distinct t.*,m.shop_nick_name,m.organiz_id,n.shop_province,n.shop_city,n.shop_area,n.shop_name FROM WEIXIN_FOLLOWER t LEFT JOIN WEIXIN_FOLLOWER_SHOP m ON t.userName = m.follower_user_name LEFT JOIN COMPANY_SHOP n ON n.shop_store_id = m.organiz_id LEFT JOIN COMPANY_ORGANIZATION org on org.organization_id=n.shop_store_id where 1=1 and n.shop_province like concat('%',?,'%') and t.state=1 and m.state=1 ORDER BY t.createTime desc limit 0,20
### Cause: java.sql.SQLException: Query execution was interrupted
; uncategorized SQLException for SQL []; SQL state [70100]; error code [1317]; Query execution was interrupted; nested exception is java.sql.SQLException: Query execution was interrupted

Answer 1

(N.SHOP_PROVINCE LIKE CONCAT('%','广东') OR N.SHOP_PROVINCE LIKE CONCAT('广东', '%'))
这样可能会快点点
其余的爱莫能助

因为不知道数据库的具体情况

Answer 2

Cause: java.sql.SQLException: Query execution was interrupted

查询操作被中断的意思。
应该是这个查询太占时间，被数据库给中断了，你应该优化一下sql，给表建一些索引等。

追问

这是sql语句，怎么进行优化?索引列表

追答

这个sql，在mysql客户端执行速度快吗？看看是sql原因，还是程序哪里写的有问题？