[ DB ] CONNECT:[ UseTime:0.000389s ] mysql:host=127.0.0.1;port=3306;dbname=4pancn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `sk_users` [ RunTime:0.000713s ]
[ SQL ] SELECT * FROM `sk_users` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000328s ]
[ SQL ] SHOW COLUMNS FROM `sk_groups` [ RunTime:0.001090s ]
[ SQL ] SELECT * FROM `sk_groups` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] SHOW COLUMNS FROM `sk_shares` [ RunTime:0.000613s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `sk_shares` `s` LEFT JOIN `sk_folders` `f` ON `s`.`source_id`=f.id AND s.type = 1 AND f.uid = s.uid AND f.delete_time IS NULL LEFT JOIN `sk_stores` `st` ON `s`.`source_id`=st.id AND s.type != 1 AND st.uid = s.uid AND st.delete_time IS NULL WHERE ( `f`.`id` IS NOT NULL OR ( `st`.`id` IS NOT NULL ) ) [ RunTime:0.000901s ]
[ SQL ] SELECT s.id,s.code,s.type,s.source_id,s.uid,CASE WHEN f.id IS NOT NULL THEN f.folder_name ELSE st.origin_name END AS title,CASE WHEN f.id IS NOT NULL THEN f.create_time ELSE st.create_time END AS create_time,COALESCE(f.`desc`, st.`desc`) AS `desc`,COALESCE(f.size, st.size) AS size,COALESCE(f.ext, st.ext) AS ext FROM `sk_shares` `s` LEFT JOIN `sk_folders` `f` ON `s`.`source_id`=f.id AND s.type = 1 AND f.uid = s.uid AND f.delete_time IS NULL LEFT JOIN `sk_stores` `st` ON `s`.`source_id`=st.id AND s.type != 1 AND st.uid = s.uid AND st.delete_time IS NULL WHERE ( `f`.`id` IS NOT NULL OR ( `st`.`id` IS NOT NULL ) ) ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000962s ]