select * from tp_domain where domain="www.youxila.net" order by id asc limit 1; [ RunTime:0.000330s ]
SHOW FULL COLUMNS FROM `tp_category` [ RunTime:0.000541s ]
SELECT * FROM `tp_category` WHERE `cate_path` = 'guoxue' ORDER BY `cate_id` DESC [ RunTime:0.000261s ]
SHOW FULL COLUMNS FROM `tp_book` [ RunTime:0.000477s ]
SELECT COUNT(*) AS think_count FROM `tp_book` WHERE `cate_id` = 9 LIMIT 1 [ RunTime:0.000229s ]
SELECT * FROM `tp_book` WHERE `cate_id` = 9 ORDER BY `id` DESC LIMIT 600,100 [ RunTime:0.001638s ]
SHOW FULL COLUMNS FROM `tp_download_log` [ RunTime:0.000469s ]
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` > '1778702900' GROUP BY `dl`.`book_id` ORDER BY `dl_count` DESC LIMIT 10 [ RunTime:0.000251s ]
SELECT * FROM `tp_book` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000248s ]
SELECT `keyword` FROM `tp_book` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 100 [ RunTime:0.000220s ]
SELECT * FROM `tp_category` WHERE `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000213s ]
SELECT * FROM `tp_category` WHERE `menu_display` = 0 ORDER BY `level` ASC [ RunTime:0.000200s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 9 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000201s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 10 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000203s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 11 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000201s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 12 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000188s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 13 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000193s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 14 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000185s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 15 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000185s ]
SELECT * FROM `tp_category` WHERE `parent_id` = 16 AND `menu_display` = 1 ORDER BY `level` ASC [ RunTime:0.000186s ]
SELECT `tag` FROM `tp_book` WHERE `status` = 1 AND `tag` <> '' ORDER BY `id` DESC LIMIT 30 [ RunTime:0.000196s ]
