SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.000814s ]
SELECT `id`,`topid`,`cate_name` FROM `tp_category` ORDER BY `sortrank` ASC [ RunTime:0.000322s ]
SELECT * FROM `tp_category` WHERE `id` = 247 LIMIT 1 [ RunTime:0.000434s ]
SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (247) And FIND_IN_SET('cf', arc.flag)>0 ORDER BY arc.id DESC LIMIT 0,4 [ RunTime:0.000491s ]
SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (247) And FIND_IN_SET('cr', arc.flag)>0 ORDER BY arc.id DESC LIMIT 0,10 [ RunTime:0.000512s ]
SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (247) ORDER BY arc.click DESC LIMIT 0,10 [ RunTime:0.000416s ]
SELECT `id`,`topid`,`cate_name` FROM `tp_category` WHERE `id` = 247 LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`topid`,`cate_name` FROM `tp_category` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000305s ]
SELECT arc.*,tp.cate_name FROM `tp_archives` arc LEFT JOIN `tp_category` tp on arc.typeid=tp.id WHERE arc.typeid IN (247) And FIND_IN_SET('ch', arc.flag)>0 ORDER BY arc.id DESC LIMIT 0,6 [ RunTime:0.000434s ]
SHOW FULL COLUMNS FROM `tp_archives` [ RunTime:0.000707s ]
SELECT COUNT(*) AS think_count FROM `tp_archives` WHERE `typeid` = 247 LIMIT 1 [ RunTime:0.000371s ]
SELECT * FROM `tp_archives` WHERE `typeid` = 247 ORDER BY `id` DESC LIMIT 0,25 [ RunTime:0.000382s ]
SELECT `topid` FROM `tp_category` WHERE `id` = 247 LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`cate_name` FROM `tp_category` WHERE `topid` = 29 ORDER BY `sortrank` ASC [ RunTime:0.000266s ]
