SHOW FULL COLUMNS FROM `qy_article` [ RunTime:0.007263s ]
SELECT * FROM `qy_article` WHERE `id` = 44602 AND `status` = 2 LIMIT 1 [ RunTime:0.025827s ]
SELECT `id`,`title`,`author`,`source`,`publishTime`,`tagId`,`gameId`,`columnId`,`detail`,`description` FROM `qy_article` WHERE `id` = 44602 LIMIT 1 [ RunTime:0.004222s ]
UPDATE `qy_article` SET `read` = `read` + 1 WHERE `id` = 44602 [ RunTime:0.056589s ]
SHOW FULL COLUMNS FROM `qy_column` [ RunTime:0.001951s ]
SELECT `title` FROM `qy_column` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `qy_game` [ RunTime:0.002430s ]
SELECT `id`,`name`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 5337 LIMIT 1 [ RunTime:0.000826s ]
SHOW FULL COLUMNS FROM `qy_tag` [ RunTime:0.002186s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (32,79) [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `qy_game_reply` [ RunTime:0.002140s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 5337 [ RunTime:0.011426s ]
SELECT `id`,`title` FROM `qy_tag` WHERE `id` IN (759,12182,45273) [ RunTime:0.000485s ]
SELECT `id`,`tagId` FROM `qy_article` WHERE `status` = 2 AND `id` <> 44602 ORDER BY `publishTime` DESC LIMIT 5000 [ RunTime:0.421752s ]
SELECT `id`,`title`,`read`,poster as src,`publishTime`,`description` FROM `qy_article` WHERE `id` IN (130434,130433,130326,130311,130279,130280,130277,130203,130201,130162,130161,130160,130156,130155,130154,130147,130138,130136,130135,130133,130132,130126,129982,129923,129921,129920,129919,129918,129917,129821,129818,129806,129621,129524,129406,129347,129074,129072,129071,129070,129069,129061,129031,128973,128667,128428,128279,128278,128223,128252,128092) AND `status` = 2 AND `poster` <> '' ORDER BY `publishTime` DESC LIMIT 0,4 [ RunTime:0.022916s ]
SHOW FULL COLUMNS FROM `qy_recommend` [ RunTime:0.022712s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7715 LIMIT 1 [ RunTime:0.004520s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (12,15,16,19,29,63,64,65,67,68) [ RunTime:0.001053s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7715 [ RunTime:0.001253s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7719 LIMIT 1 [ RunTime:0.005200s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (11,12,15,67,69) [ RunTime:0.014570s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7719 [ RunTime:0.010899s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7528 LIMIT 1 [ RunTime:0.012689s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (20,79,87) [ RunTime:0.010850s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7528 [ RunTime:0.027172s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 5202 LIMIT 1 [ RunTime:0.019873s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 14 [ RunTime:0.009903s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 5202 [ RunTime:0.007554s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7596 LIMIT 1 [ RunTime:0.006821s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 27 [ RunTime:0.005109s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7596 [ RunTime:0.013551s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 5337 LIMIT 1 [ RunTime:0.012238s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (32,79) [ RunTime:0.010352s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 5337 [ RunTime:0.016826s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7626 LIMIT 1 [ RunTime:0.016963s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 31 [ RunTime:0.010761s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7626 [ RunTime:0.010239s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7771 LIMIT 1 [ RunTime:0.012133s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (11,12,15,69) [ RunTime:0.024833s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7771 [ RunTime:0.001158s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7617 LIMIT 1 [ RunTime:0.000580s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 30 [ RunTime:0.000473s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7617 [ RunTime:0.000543s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7497 LIMIT 1 [ RunTime:0.000487s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 12 [ RunTime:0.000377s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7497 [ RunTime:0.000410s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7807 LIMIT 1 [ RunTime:0.000427s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (10,15,63,67,68) [ RunTime:0.000527s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7807 [ RunTime:0.000428s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7472 LIMIT 1 [ RunTime:0.000438s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 6 [ RunTime:0.000303s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7472 [ RunTime:0.000482s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7624 LIMIT 1 [ RunTime:0.000317s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 31 [ RunTime:0.000289s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7624 [ RunTime:0.000305s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7757 LIMIT 1 [ RunTime:0.011197s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (16,63,64,65,67) [ RunTime:0.000530s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7757 [ RunTime:0.000354s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 5653 LIMIT 1 [ RunTime:0.000311s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 12 [ RunTime:0.000308s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 5653 [ RunTime:0.000310s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7619 LIMIT 1 [ RunTime:0.009554s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 30 [ RunTime:0.000421s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7619 [ RunTime:0.000402s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 6745 LIMIT 1 [ RunTime:0.000455s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (42,68,78) [ RunTime:0.000440s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 6745 [ RunTime:0.000393s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7724 LIMIT 1 [ RunTime:0.013243s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (15,16,63,75,76) [ RunTime:0.000527s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7724 [ RunTime:0.000473s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7682 LIMIT 1 [ RunTime:0.000430s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (16,32,78) [ RunTime:0.000425s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7682 [ RunTime:0.000372s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7714 LIMIT 1 [ RunTime:0.000430s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (16,19,29,63,67) [ RunTime:0.000466s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7714 [ RunTime:0.000365s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7560 LIMIT 1 [ RunTime:0.000428s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 23 [ RunTime:0.000320s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7560 [ RunTime:0.000426s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7629 LIMIT 1 [ RunTime:0.000339s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (31,70,83) [ RunTime:0.000459s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7629 [ RunTime:0.000446s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 5668 LIMIT 1 [ RunTime:0.000342s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 6 [ RunTime:0.000361s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 5668 [ RunTime:0.000400s ]
SELECT `id`,name as title,`memo`,`icon`,`score`,`tag_id` FROM `qy_game` WHERE `id` = 7474 LIMIT 1 [ RunTime:0.000346s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` = 6 [ RunTime:0.000385s ]
SELECT COUNT(`id`) AS think_count FROM `qy_game_reply` WHERE `gid` = 7474 [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `qy_collect` [ RunTime:0.002348s ]
SELECT COUNT(*) AS think_count FROM `qy_collect` WHERE `status` = 2 [ RunTime:0.000511s ]
SELECT `id`,name as title,`icon`,`poster`,`score`,`tag_id`,`memo` FROM `qy_game` WHERE `id` IN (7962,7961,7959,7950,7948,7935,7938,7940,7922,7920,7902,7846,7711,7934,7928,7930,7881,7876,7879,7826,7682,5337) ORDER BY `createTime` DESC,`score` DESC LIMIT 5 [ RunTime:0.000853s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (6,69) [ RunTime:0.000524s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (12,19,21,36) [ RunTime:0.000497s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (12,15,19,43,67) [ RunTime:0.000446s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (14,30,31,71,83) [ RunTime:0.000516s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (15,28,42) [ RunTime:0.000534s ]
SELECT `id`,name as title,`icon`,`poster`,`score`,`tag_id`,`memo` FROM `qy_game` WHERE `id` IN (7935,7933,7929,7930,7922,5337,6745,7770,6747,7771,7715,5668,7711,7757,6002,7889,7883,7846,7849,7833,7832,7831,7729) ORDER BY `createTime` DESC,`score` DESC LIMIT 5 [ RunTime:0.000833s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (19,24,29,71,83) [ RunTime:0.000524s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (12,14,67,71,74) [ RunTime:0.000449s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (19,29,31,64,72) [ RunTime:0.000501s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (6,8,19,71,77) [ RunTime:0.000509s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (6,7,8,19,24) [ RunTime:0.000477s ]
SELECT `id`,name as title,`icon`,`poster`,`score`,`tag_id`,`memo` FROM `qy_game` WHERE `id` IN (7935,7932,7930,7928,7926,7927,7901,7902,7895,7893,7888,7889,7827,7826,7822,7817,7818,7624,7724,6447,1816,7771,7770,7757,7756,7753,3223,3308,2842,7745,7735,7715,7714,7720,7721,7678,7682) ORDER BY `createTime` DESC,`score` DESC LIMIT 5 [ RunTime:0.001045s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (19,24,29,71,83) [ RunTime:0.000486s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (12,15,16,42,71) [ RunTime:0.000649s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (19,29,31,64,72) [ RunTime:0.000552s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (14,15,16,19,29) [ RunTime:0.000504s ]
SELECT `title` FROM `qy_tag` WHERE `area` = 2 AND `id` IN (13,29,64,71,74) [ RunTime:0.000471s ]