[ SQL ] SHOW COLUMNS FROM `zitu_wiki` [ RunTime:0.001597s ]
[ 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 '%邮件%' AND `a`.`post_type` = 1 ) [ RunTime:0.000761s ]
[ 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 '%邮件%' AND `a`.`post_type` = 1 ) ORDER BY `is_top` DESC,`published_time` DESC LIMIT 0,10 [ RunTime:0.001740s ]
[ 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.004066s ]
[ SQL ] SHOW COLUMNS FROM `zitu_wiki_category_post` [ RunTime:0.000872s ]
[ SQL ] SHOW COLUMNS FROM `zitu_wiki_category` [ RunTime:0.000739s ]
[ SQL ] SELECT `zitu_wiki_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `zitu_wiki_category` INNER JOIN `zitu_wiki_category_post` `pivot` ON `pivot`.`category_id`=`zitu_wiki_category`.`id` WHERE `pivot`.`post_id` = 46 [ RunTime:0.000410s ]
[ SQL ] SELECT `zitu_wiki_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `zitu_wiki_category` INNER JOIN `zitu_wiki_category_post` `pivot` ON `pivot`.`category_id`=`zitu_wiki_category`.`id` WHERE `pivot`.`post_id` = 45 [ RunTime:0.000415s ]
[ SQL ] SELECT `zitu_wiki_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `zitu_wiki_category` INNER JOIN `zitu_wiki_category_post` `pivot` ON `pivot`.`category_id`=`zitu_wiki_category`.`id` WHERE `pivot`.`post_id` = 36 [ RunTime:0.000478s ]
[ SQL ] SELECT `zitu_wiki_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `zitu_wiki_category` INNER JOIN `zitu_wiki_category_post` `pivot` ON `pivot`.`category_id`=`zitu_wiki_category`.`id` WHERE `pivot`.`post_id` = 20 [ RunTime:0.000321s ]
[ SQL ] SELECT `zitu_wiki_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `zitu_wiki_category` INNER JOIN `zitu_wiki_category_post` `pivot` ON `pivot`.`category_id`=`zitu_wiki_category`.`id` WHERE `pivot`.`post_id` = 19 [ RunTime:0.000383s ]
[ SQL ] SELECT `zitu_wiki_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `zitu_wiki_category` INNER JOIN `zitu_wiki_category_post` `pivot` ON `pivot`.`category_id`=`zitu_wiki_category`.`id` WHERE `pivot`.`post_id` = 14 [ RunTime:0.000314s ]
