SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.001130s ]
SELECT `id`,`topid`,`cate_name` FROM `tp_category` ORDER BY `sortrank` ASC [ RunTime:0.000386s ]
SHOW FULL COLUMNS FROM `tp_archives` [ RunTime:0.001054s ]
SELECT `id` FROM `tp_archives` WHERE `id` = 2647 LIMIT 1 [ RunTime:0.000528s ]
SELECT `a`.*,`b`.`body` FROM `tp_archives` `a` INNER JOIN `tp_addonarticle` `b` ON `a`.`id`=`b`.`aid` WHERE `a`.`id` = '2647' LIMIT 1 [ RunTime:0.000606s ]
SHOW FULL COLUMNS FROM `tp_officweb` [ RunTime:0.000962s ]
SELECT `offic_name`,`web_url` FROM `tp_officweb` WHERE `id` = 24 LIMIT 1 [ RunTime:0.000377s ]
SELECT * FROM `tp_archives` WHERE `id` > 2647 AND `typeid` = 26 LIMIT 1 [ RunTime:0.001965s ]
SELECT * FROM `tp_archives` WHERE `id` < 2647 AND `typeid` = 26 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.id < 2647 AND typeid = 26 ORDER BY arc.id DESC LIMIT 1,12 [ RunTime:0.001691s ]
SELECT `id`,`topid`,`cate_name` FROM `tp_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`topid`,`cate_name` FROM `tp_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000277s ]
SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (26) And FIND_IN_SET('cr', arc.flag)>0 And arc.id != 2647 ORDER BY arc.id DESC LIMIT 0,10 [ RunTime:0.013115s ]
SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (26) And arc.id != 2647 ORDER BY arc.click DESC LIMIT 0,10 [ RunTime:0.001813s ]