select * from tp_domain where domain="www.youxila.net" order by id asc limit 1; [ RunTime:0.000315s ]
SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.000552s ]
SELECT * FROM `tp_category` WHERE `cate_path` = 'ziliao' ORDER BY `cate_id` DESC [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `tp_book` [ RunTime:0.000465s ]
SELECT * FROM `tp_book` WHERE `cate_id` = 11 ORDER BY `id` DESC LIMIT 6 [ RunTime:0.000291s ]
SELECT COUNT(*) AS think_count FROM `tp_book` WHERE `cate_id` = 11 LIMIT 1 [ RunTime:0.000206s ]
SELECT * FROM `tp_book` WHERE `cate_id` = 11 ORDER BY `id` DESC LIMIT 0,100 [ RunTime:0.000216s ]
SHOW FULL COLUMNS FROM `tp_download_log` [ RunTime:0.000437s ]
SELECT b.id, b.title, COUNT(*) as dl_count FROM `tp_download_log` `dl` INNER JOIN `tp_book` `b` ON `b`.`id`=dl.book_id AND b.status = 1 WHERE `dl`.`timestamp` > '1778696807' GROUP BY `dl`.`book_id` ORDER BY `dl_count` DESC LIMIT 10 [ RunTime:0.000238s ]
SELECT * FROM `tp_book` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000251s ]
SELECT `keyword` FROM `tp_book` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 100 [ RunTime:0.000228s ]
SELECT * FROM `tp_category` WHERE `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000224s ]
SELECT * FROM `tp_category` WHERE `menu_display` = 0 ORDER BY `level` ASC [ RunTime:0.000208s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 9 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000199s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 10 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000229s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 11 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000207s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 12 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000187s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 13 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000186s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 14 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000189s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 15 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000183s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 16 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000188s ]
SELECT `tag` FROM `tp_book` WHERE `status` = 1 AND `tag` <> '' ORDER BY `id` DESC LIMIT 30 [ RunTime:0.000181s ]