The EXPLAIN QUERY PLAN SQL command is used to obtain a high-level description of the strategy or plan that SQLite uses to implement a specific SQL query. Most significantly, EXPLAIN QUERY PLAN reports on the way in which the query uses database indices
第一个工具目测是Navicat for MySQL,这工具这SQL查询客户端(当然mysql官方工具也挺好用),
用它来打开sqlite.db文件很方便,要在Andorid或iOS建本地库前,可以用这玩意先建库、测试查询语句等,测试ok后再放到android或ios代码里去建库就不会因为各种低级错误而费劲巴拉地去调试了。