[ DB ] CONNECT:[ UseTime:0.000562s ] mysql:host=127.0.0.1;port=3306;dbname=4pancn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `sk_users` [ RunTime:0.000707s ]
[ SQL ] SELECT * FROM `sk_users` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000266s ]
[ SQL ] SHOW COLUMNS FROM `sk_groups` [ RunTime:0.000616s ]
[ SQL ] SELECT * FROM `sk_groups` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000338s ]
[ SQL ] SHOW COLUMNS FROM `sk_shares` [ RunTime:0.000451s ]
[ 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 LEFT JOIN `sk_stores` `st` ON `s`.`source_id`=st.id AND s.type != 1 AND st.uid = s.uid [ RunTime:0.000539s ]
[ SQL ] SELECT s.id,s.code,s.type,s.source_id,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 LEFT JOIN `sk_stores` `st` ON `s`.`source_id`=st.id AND s.type != 1 AND st.uid = s.uid ORDER BY `id` DESC LIMIT 0,15 [ RunTime:0.000554s ]