[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`cate_id` IN ('10','11','2') AND `r`.`status` = 1 LIMIT 1 [ RunTime:0.000352s ]
[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`cate_id` IN ('10','11','2') AND `r`.`status` = 1 ORDER BY `views` DESC LIMIT 0,10 [ RunTime:0.000694s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_tui` = 1 AND `r`.`cate_id` IN ('10','11','2') LIMIT 1 [ RunTime:0.000337s ]
[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_tui` = 1 AND `r`.`cate_id` IN ('10','11','2') ORDER BY `pub_time` DESC LIMIT 0,10 [ RunTime:0.000685s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`cate_id` IN ('10','11','2') LIMIT 1 [ RunTime:0.000335s ]
[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`cate_id` IN ('10','11','2') ORDER BY `pub_time` DESC LIMIT 0,10 [ RunTime:0.000680s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_img` = 1 AND `r`.`cate_id` IN ('10','11','2') LIMIT 1 [ RunTime:0.000325s ]
[ SQL ] SELECT r.id,r.title,r.cate_id,r.photo,r.remark,r.keyword,r.content,r.views,r.type,r.is_tui,r.from,r.writer,r.ip,r.create_time,r.update_time,r.status,rc.name,r.music,r.is_pub,r.is_hot,r.is_img,r.pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,r.ora_content FROM `think_article` `r` INNER JOIN `think_article_cate` `rc` ON `r`.`cate_id`=`rc`.`id` WHERE `r`.`status` = 1 AND `r`.`is_img` = 1 AND `r`.`cate_id` IN ('10','11','2') ORDER BY `pub_time` DESC LIMIT 0,10 [ RunTime:0.000645s ]
[ SQL ] SELECT id,title,cate_id,photo,keyword,content,views,type,is_tui,writer,ip,create_time,update_time,status,is_pub,is_hot,is_img,pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,ora_content FROM `think_article` WHERE `status` = 1 AND `is_pub` = 1 AND `id` = 111 LIMIT 1 [ RunTime:0.000400s ]
[ SQL ] UPDATE `think_article` SET `views`=`views`+1 WHERE `id` = 111 [ RunTime:0.005120s ]
[ SQL ] SELECT id,title,cate_id,photo,keyword,content,views,type,is_tui,writer,ip,create_time,update_time,status,is_pub,is_hot,is_img,pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,ora_content FROM `think_article` WHERE `status` = 1 AND `is_pub` = 1 AND `id` = 110 LIMIT 1 [ RunTime:0.000428s ]
[ SQL ] SELECT id,title,cate_id,photo,keyword,content,views,type,is_tui,writer,ip,create_time,update_time,status,is_pub,is_hot,is_img,pub_time,DATE_FORMAT(pub_time,'%Y') as for_year,DATE_FORMAT(pub_time,'%m') as for_month,DATE_FORMAT(pub_time,'%d') as for_day,tags,ora_content FROM `think_article` WHERE `status` = 1 AND `is_pub` = 1 AND `id` = 112 LIMIT 1 [ RunTime:0.000382s ]
