SELECT * FROM `tag` WHERE `id` = 62525 LIMIT 1 [ RunTime:0.000636s ]
UPDATE `tag` SET `view_count` = `view_count` + 1 WHERE `id` = 62525 [ RunTime:0.000690s ]
SELECT * FROM `software_tag` WHERE `tag_id` = 62525 ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.000519s ]
SELECT * FROM `software` WHERE `id` = 149426 ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.000561s ]
SELECT COUNT(*) AS think_count FROM `software` WHERE `id` IN (13401,57666,77265,102913,149878) [ RunTime:0.000600s ]
SELECT * FROM `software` WHERE `id` IN (13401,57666,77265,102913,149878) ORDER BY `id` DESC LIMIT 0,5 [ RunTime:0.000793s ]
SELECT COUNT(*) AS think_count FROM `software` WHERE `id` IN (10071,22031,39613,57527,64799,79981,101954,110676,122671,146331,13675) [ RunTime:0.000716s ]
SELECT * FROM `software` WHERE `id` IN (10071,22031,39613,57527,64799,79981,101954,110676,122671,146331,13675) ORDER BY `id` DESC LIMIT 0,11 [ RunTime:0.000892s ]
SELECT COUNT(*) AS think_count FROM `software_tag` WHERE `tag_id` = 62525 [ RunTime:0.000501s ]
SELECT * FROM `software_tag` WHERE `tag_id` = 62525 ORDER BY `create_time` DESC LIMIT 0,40 [ RunTime:0.000452s ]
SELECT COUNT(*) AS think_count FROM `software` WHERE `id` = 149426 [ RunTime:0.000346s ]
SELECT * FROM `software` WHERE `id` = 149426 ORDER BY `create_time` DESC LIMIT 0,40 [ RunTime:0.000421s ]
SELECT COUNT(*) AS think_count FROM `tag` [ RunTime:0.014731s ]
SELECT * FROM `tag` ORDER BY `view_count` DESC LIMIT 179,50 [ RunTime:0.000723s ]
SELECT count(s.id) as count,`st`.`tag_id` FROM `software_tag` `st` INNER JOIN `software` `s` ON `st`.`software_id`=`s`.`id` WHERE `s`.`status` = '1' AND `st`.`tag_id` IN ('16963','100','8198','1327','5527','2397','9787','4941','3538','257','2470','3491','5127','1756','6260','392','1773','11063','197','18278','15597','4904','17311','5478','3676','1411','640','583','16537','12202') GROUP BY `st`.`tag_id` [ RunTime:0.014291s ]
