[ DB ] CONNECT:[ UseTime:0.000328s ] 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.000339s ]
[ SQL ]
explain
select
count(user_list_id)
from
user_list
where
user_list_delete='1' [ RunTime:0.004973s ]
[ SQL ] SELECT * FROM doc_type WHERE doc_type_delete='1' ORDER BY doc_type_id [ RunTime:0.000481s ]
[ SQL ] SELECT doc_type_name FROM doc_type WHERE doc_type_delete='1' AND doc_type_id=17 LIMIT 1 [ RunTime:0.000304s ]
[ 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 = 17 [ RunTime:0.002453s ]
[ 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 = 17
ORDER BY a.doc_list_addtime desc
LIMIT 2620, 20 [ RunTime:0.019593s ]