[ DB ] CONNECT:[ UseTime:0.000305s ] mysql:host=127.0.0.1;dbname=aliwenan_net;charset=utf8mb4
[ SQL ]
explain
select
count(doc_list_id)
from
doc_list
where
doc_list_shelves='2'
and doc_list_delete='1' [ RunTime:0.000376s ]
[ SQL ]
explain
select
count(user_list_id)
from
user_list
where
user_list_delete='1' [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM doc_type WHERE doc_type_delete='1' ORDER BY doc_type_id [ RunTime:0.000312s ]
[ SQL ] SELECT doc_type_name FROM doc_type WHERE doc_type_delete='1' AND doc_type_id=27 LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT COUNT(*) AS cnt FROM doc_list a
WHERE a.doc_list_shelves='2' AND a.doc_list_delete='1'
AND a.doc_type_id = 27 [ RunTime:0.000832s ]
[ SQL ] SELECT
a.doc_list_id, a.doc_type_id, a.doc_list_title, a.doc_list_logo,
a.doc_list_drive, a.doc_list_path, a.doc_list_extension,
a.doc_list_price, a.doc_list_see,
FROM_UNIXTIME(a.doc_list_addtime) AS doc_list_time,
(SELECT COUNT(*) FROM doc_down WHERE doc_list_id = a.doc_list_id) AS doc_list_down
FROM doc_list a
WHERE a.doc_list_shelves='2' AND a.doc_list_delete='1'
AND a.doc_type_id = 27
ORDER BY a.doc_list_addtime desc
LIMIT 1100, 20 [ RunTime:0.005120s ]