SELECT `pinyin` FROM `category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000583s ]
SELECT `pinyin` FROM `category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000367s ]
SELECT `pinyin` FROM `category` WHERE `id` = 101 LIMIT 1 [ RunTime:0.000543s ]
SELECT `pinyin` FROM `category` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000331s ]
SELECT `pinyin` FROM `category` WHERE `id` = 103 LIMIT 1 [ RunTime:0.000298s ]
SELECT `pinyin` FROM `category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.000312s ]
SELECT `pinyin` FROM `category` WHERE `id` = 105 LIMIT 1 [ RunTime:0.000285s ]
SELECT `pinyin` FROM `category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.000285s ]
SELECT `pinyin` FROM `category` WHERE `id` = 107 LIMIT 1 [ RunTime:0.000289s ]
SELECT `pinyin` FROM `category` WHERE `id` = 108 LIMIT 1 [ RunTime:0.000286s ]
SELECT `pinyin` FROM `category` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000279s ]
SELECT `pinyin` FROM `category` WHERE `id` = 110 LIMIT 1 [ RunTime:0.000291s ]
SELECT `pinyin` FROM `category` WHERE `id` = 111 LIMIT 1 [ RunTime:0.000275s ]
SELECT `pinyin` FROM `category` WHERE `id` = 201 LIMIT 1 [ RunTime:0.000276s ]
SELECT `pinyin` FROM `category` WHERE `id` = 202 LIMIT 1 [ RunTime:0.000280s ]
SELECT `pinyin` FROM `category` WHERE `id` = 203 LIMIT 1 [ RunTime:0.000277s ]
SELECT `pinyin` FROM `category` WHERE `id` = 204 LIMIT 1 [ RunTime:0.000325s ]
SELECT `pinyin` FROM `category` WHERE `id` = 205 LIMIT 1 [ RunTime:0.000282s ]
SELECT `pinyin` FROM `category` WHERE `id` = 206 LIMIT 1 [ RunTime:0.000277s ]
SELECT `pinyin` FROM `category` WHERE `id` = 207 LIMIT 1 [ RunTime:0.000276s ]
SELECT `pinyin` FROM `category` WHERE `id` = 208 LIMIT 1 [ RunTime:0.000286s ]
SELECT `pinyin` FROM `category` WHERE `id` = 209 LIMIT 1 [ RunTime:0.000275s ]
SELECT `pinyin` FROM `category` WHERE `id` = 210 LIMIT 1 [ RunTime:0.000218s ]
SELECT `pinyin` FROM `category` WHERE `id` = 211 LIMIT 1 [ RunTime:0.000219s ]
SELECT * FROM `category` [ RunTime:0.000266s ]
SELECT * FROM `tag` WHERE `id` = 63088 LIMIT 1 [ RunTime:0.000272s ]
UPDATE `tag` SET `view_count` = `view_count` + 1 WHERE `id` = 63088 [ RunTime:0.000458s ]
SELECT * FROM `software_tag` WHERE `tag_id` = 63088 ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.000356s ]
SELECT * FROM `software` WHERE `id` = 151814 ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.000379s ]
SELECT COUNT(*) AS think_count FROM `software` WHERE `id` IN (21774,57376,74104,119191,129626) [ RunTime:0.000391s ]
SELECT * FROM `software` WHERE `id` IN (21774,57376,74104,119191,129626) ORDER BY `id` DESC LIMIT 0,5 [ RunTime:0.000473s ]
SELECT COUNT(*) AS think_count FROM `software` WHERE `id` IN (21774,57376,74104,119191,129626) [ RunTime:0.000376s ]
SELECT * FROM `software` WHERE `id` IN (21774,57376,74104,119191,129626) ORDER BY `id` DESC LIMIT 0,5 [ RunTime:0.000491s ]
SELECT COUNT(*) AS think_count FROM `software` WHERE `id` IN (6174,27802,40234,46879,70551,90905,98686,111634,131293,137530,6732) [ RunTime:0.000466s ]
SELECT * FROM `software` WHERE `id` IN (6174,27802,40234,46879,70551,90905,98686,111634,131293,137530,6732) ORDER BY `id` DESC LIMIT 0,11 [ RunTime:0.000617s ]
SELECT COUNT(*) AS think_count FROM `software` WHERE `id` IN (6174,27802,40234,46879,70551,90905,98686,111634,131293,137530,6732) [ RunTime:0.000496s ]
SELECT * FROM `software` WHERE `id` IN (6174,27802,40234,46879,70551,90905,98686,111634,131293,137530,6732) ORDER BY `id` DESC LIMIT 0,11 [ RunTime:0.000613s ]
SELECT COUNT(*) AS think_count FROM `software_tag` WHERE `tag_id` = 63088 [ RunTime:0.000369s ]
SELECT * FROM `software_tag` WHERE `tag_id` = 63088 ORDER BY `create_time` DESC LIMIT 0,40 [ RunTime:0.000343s ]
SELECT COUNT(*) AS think_count FROM `software` WHERE `id` = 151814 [ RunTime:0.000263s ]
SELECT * FROM `software` WHERE `id` = 151814 ORDER BY `create_time` DESC LIMIT 0,40 [ RunTime:0.000380s ]
SELECT COUNT(*) AS think_count FROM `software` WHERE `id` = 151814 [ RunTime:0.000256s ]
SELECT * FROM `software` WHERE `id` = 151814 ORDER BY `create_time` DESC LIMIT 0,40 [ RunTime:0.000396s ]
SELECT COUNT(*) AS think_count FROM `tag` [ RunTime:0.013488s ]
SELECT * FROM `tag` ORDER BY `view_count` DESC LIMIT 179,50 [ RunTime:0.000559s ]
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','3392','1327','5527','2397','9787','4941','3538','257','12202','3491','5127','1756','6260','392','1773','11063','197','18278','15597','4904','17311','5478','3676','1411','640','583','16537','8198') GROUP BY `st`.`tag_id` [ RunTime:0.011237s ]
