can optimize these sql by follow methods: - change query logic or find other way to accomplish the aim - add indexes Ref: [collscan sql in explorer backend](http://wiki.bianjie.ai/pages/viewpage.action?pageId=15534159)
can optimize these sql by follow methods:
Ref: collscan sql in explorer backend