运行时间 : 0.3458s ( Load:0.0123s Init:0.0030s Exec:0.3142s Template:0.0164s )
为什么我的这个数据库查询时间这么长？我看了看我的所有sql语句 加起来的时间也是就0.08秒左右 为什么exec用了0.3142秒？
下面是我的sql语句
SHOW COLUMNS FROM `zwl_user` [ RunTime:0.0141s ]
SELECT * FROM `zwl_user` WHERE ( e_status=1 ) [ RunTime:0.0006s ]
SHOW COLUMNS FROM `zwl_department` [ RunTime:0.0093s ]
SELECT * FROM `zwl_department` [ RunTime:0.0003s ]
SHOW COLUMNS FROM `zwl_collectionarea` [ RunTime:0.0092s ]
SELECT * FROM `zwl_collectionarea` WHERE ( status=1 ) [ RunTime:0.0003s ]
SHOW COLUMNS FROM `zwl_client` [ RunTime:0.0107s ]
SELECT * FROM `zwl_client` WHERE ( status=1 ) [ RunTime:0.0003s ]
SHOW COLUMNS FROM `zwl_collectstatus` [ RunTime:0.0092s ]
SELECT * FROM `zwl_collectstatus` WHERE ( status=1 ) [ RunTime:0.0003s ]
SHOW COLUMNS FROM `zwl_casetype` [ RunTime:0.0058s ]
SELECT * FROM `zwl_casetype` WHERE ( status=1 ) [ RunTime:0.0003s ]
SHOW COLUMNS FROM `zwl_casebasis` [ RunTime:0.0102s ]
SELECT COUNT(zwl_casebasis.id) AS tp_count FROM `zwl_casebasis` LEFT JOIN zwl_batch ON zwl_casebasis.batchid=zwl_batch.id LEFT JOIN zwl_client ON zwl_client.id=zwl_batch.clientid LEFT JOIN zwl_collectionarea ON zwl_collectionarea.id=zwl_batch.collectionareaid LEFT JOIN zwl_collectstatus ON zwl_collectstatus.id=zwl_casebasis.collectionstatus_id LEFT JOIN zwl_casedetails ON zwl_casedetails.pid=zwl_casebasis.id LEFT JOIN zwl_user ON zwl_user.id=zwl_casebasis.userid LEFT JOIN zwl_casebacks ON zwl_casebacks.pid=zwl_casebasis.id LIMIT 1 [ RunTime:0.0301s ]
SELECT zwl_collectionarea.name as area,zwl_casebasis.id as id,zwl_collectstatus.name as collectstatus,zwl_batch.batchnum as batchnum,zwl_batch.dateofcommission,zwl_casebasis.case_name as casename,zwl_casebasis.receive_money,zwl_casebasis.receive_balance,zwl_user.name as username,zwl_casebasis.distributiontime,zwl_casebasis.ptp_money,zwl_casebasis.remind,zwl_casebasis.collection_count,zwl_casebasis.color,zwl_casebasis.status,zwl_casebasis.cp_money,zwl_casebasis.briefsummary FROM `zwl_casebasis` LEFT JOIN zwl_batch ON zwl_casebasis.batchid=zwl_batch.id LEFT JOIN zwl_client ON zwl_client.id=zwl_batch.clientid LEFT JOIN zwl_collectionarea ON zwl_collectionarea.id=zwl_batch.collectionareaid LEFT JOIN zwl_collectstatus ON zwl_collectstatus.id=zwl_casebasis.collectionstatus_id LEFT JOIN zwl_casedetails ON zwl_casedetails.pid=zwl_casebasis.id LEFT JOIN zwl_casebacks ON zwl_casebacks.pid=zwl_casebasis.id LEFT JOIN zwl_user ON zwl_user.id=zwl_casebasis.userid LIMIT 0,50 [ RunTime:0.0015s ]
select *,concat(path,'-',id) as apth from zwl_department order by apth,id [ RunTime:0.0005s ]
SELECT COUNT(*) as c FROM `zwl_user` WHERE departmentid = 47 [ RunTime:0.0003s ]
SELECT COUNT(*) as c FROM `zwl_user` WHERE departmentid = 48 [ RunTime:0.0002s ]
SELECT COUNT(*) as c FROM `zwl_user` WHERE departmentid = 49 [ RunTime:0.0002s ]
SELECT COUNT(*) as c FROM `zwl_user` WHERE departmentid = 50 [ RunTime:0.0002s ]
SELECT COUNT(*) as c FROM `zwl_user` WHERE departmentid = 51 [ RunTime:0.0002s ]
SELECT COUNT(*) as c FROM `zwl_user` WHERE departmentid = 52 [ RunTime:0.0003s ]
SELECT COUNT(*) as c FROM `zwl_user` WHERE departmentid = 99999 [ RunTime:0.0002s ]
SELECT COUNT(*) as c FROM `zwl_user` WHERE departmentid = 0 [ RunTime:0.0002s ]
最佳答案
