[ 2017-03-20T15:17:41+08:00 ] ::1 /Sunshineshareweb/Site/index.html
DEBUG: 2017-03-20 15:17:41---------->SELECT s.id AS id,s.member_id AS member_id,s.cate_id AS cate_id,s.site_name AS site_name,s.site_domain AS site_domain,s.site_lang AS site_lang,s.price AS price,s.price_member AS price_member,s.show_type AS show_type,s.allow AS allow,s.state AS state,s.sort AS sort,s.remark AS remark,s.is_rec AS is_rec,s.is_best AS is_best,s.is_promote AS is_promote,s.http_code AS http_code,s.auto_link AS auto_link,s.refresh_time AS refresh_time,s.update_time AS update_time,s.add_time AS add_time,m.username AS username,c.name AS cate_name,st.pr AS pr,st.p_num AS p_num,st.br AS br,st.br_tools AS br_tools,st.b_num AS b_num,st.b_snapshot AS b_snapshot,st.outlink AS outlink,st.rank AS rank,st.sale AS sale FROM zb_site s LEFT JOIN zb_member m ON s.member_id=m.id LEFT JOIN zb_site_cate c ON s.cate_id=c.id LEFT JOIN zb_site_stat st ON s.id=st.site_id ORDER BY (case when s.state < 0 then 3 end) asc,s.id desc LIMIT 0,15