[ SQL ] SHOW COLUMNS FROM `zitu_wiki` [ RunTime:0.002395s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zitu_wiki` `a` INNER JOIN `zitu_user` `u` ON `a`.`user_id`=`u`.`id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND ( `a`.`post_title` LIKE '%https%' AND `a`.`post_type` = 1 ) [ RunTime:0.000698s ]
[ SQL ] SELECT `a`.*,`u`.`user_login`,`u`.`user_nickname`,`u`.`user_email` FROM `zitu_wiki` `a` INNER JOIN `zitu_user` `u` ON `a`.`user_id`=`u`.`id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND ( `a`.`post_title` LIKE '%https%' AND `a`.`post_type` = 1 ) ORDER BY `is_top` DESC,`published_time` DESC LIMIT 0,10 [ RunTime:0.000664s ]
[ SQL ] SELECT sc.search_content, count('a.search_content_id') as search_count FROM `zitu_wiki_search_log` `a` INNER JOIN `zitu_wiki_search_content` `sc` ON `a`.`search_content_id`=`sc`.`id` WHERE `sc`.`delete_time` = 0 AND `a`.`delete_time` = 0 GROUP BY `a`.`search_content_id` ORDER BY `search_count` DESC,`initial` ASC LIMIT 6 [ RunTime:0.004058s ]
