SHOW FULL COLUMNS FROM `xn_keyword` [ RunTime:0.010747s ]
SELECT * FROM `xn_keyword` WHERE `type` = 'main' AND `type_resources` = 2 ORDER BY `sort` DESC [ RunTime:0.002621s ]
SELECT * FROM `xn_keyword` WHERE `type` = 'main' AND `type_resources` = 3 ORDER BY `sort` DESC [ RunTime:0.002700s ]
SHOW FULL COLUMNS FROM `xn_category` [ RunTime:0.010649s ]
SELECT * FROM `xn_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007347s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003934s ]
SELECT * FROM `xn_category` WHERE `type` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004800s ]
SELECT * FROM `xn_category` WHERE `type` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003825s ]
SHOW FULL COLUMNS FROM `xn_online` [ RunTime:0.010519s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'index' AND `type` = 1 ORDER BY `sort` DESC [ RunTime:0.002547s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'index' AND `type` = 2 ORDER BY `sort` DESC [ RunTime:0.002604s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'index' AND `type` = 3 LIMIT 1 [ RunTime:0.002509s ]
SHOW FULL COLUMNS FROM `xn_main_category` [ RunTime:0.011501s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 0 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002498s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 46 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002477s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002513s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002501s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002440s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002459s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002442s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002457s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002539s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 50 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002379s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 51 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002401s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 52 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002429s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002375s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002446s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002463s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002469s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002459s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002442s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002407s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002442s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002452s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002378s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002441s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002426s ]
SHOW FULL COLUMNS FROM `xn_footer` [ RunTime:0.010324s ]
SELECT * FROM `xn_footer` ORDER BY `sort` DESC [ RunTime:0.002633s ]
SELECT * FROM `xn_footer` WHERE `type` = 1 ORDER BY `sort` DESC [ RunTime:0.002616s ]
SELECT * FROM `xn_footer` WHERE `type` = 2 ORDER BY `sort` DESC [ RunTime:0.002539s ]
SELECT * FROM `xn_category` WHERE `pid` = 382 [ RunTime:0.002474s ]
SELECT * FROM `xn_category` WHERE `pid` = 403 [ RunTime:0.002458s ]
SELECT * FROM `xn_category` WHERE `pid` = 404 [ RunTime:0.002421s ]
SELECT * FROM `xn_category` WHERE `pid` = 405 [ RunTime:0.002543s ]
SELECT * FROM `xn_category` WHERE `pid` = 406 [ RunTime:0.002422s ]
SELECT * FROM `xn_category` WHERE `pid` = 442 [ RunTime:0.002425s ]
SELECT * FROM `xn_category` WHERE `pid` = 443 [ RunTime:0.002439s ]
SELECT * FROM `xn_category` WHERE `pid` = 444 [ RunTime:0.002405s ]
SELECT * FROM `xn_category` WHERE `pid` = 445 [ RunTime:0.002427s ]
SELECT * FROM `xn_category` WHERE `pid` = 451 [ RunTime:0.002360s ]
SELECT `title` FROM `xn_category` WHERE `id` = 382 LIMIT 1 [ RunTime:0.002433s ]
SELECT `title` FROM `xn_category` WHERE `id` = 379 LIMIT 1 [ RunTime:0.002332s ]
SELECT `title` FROM `xn_category` WHERE `id` = 205 LIMIT 1 [ RunTime:0.002370s ]
SHOW FULL COLUMNS FROM `xn_books` [ RunTime:0.010141s ]
SELECT COUNT(*) AS think_count FROM `xn_books` WHERE `type` = 1 AND `category_id` IN (382,403,486,487,488,489,490,491,492,493,494,997,1060,404,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,405,547,548,549,674,675,676,677,678,679,680,681,682,683,684,685,875,883,1021,1022,1023,1024,1025,1026,1051,1052,1053,1065,1773,1774,406,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,640,825,442,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,443,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,1041,444,789,790,791,792,793,794,445,876,877,878,879,880,881,882,451,998,999,1000,1001,1002) LIMIT 1 [ RunTime:0.009582s ]
SELECT COUNT(*) AS think_count FROM `xn_books` WHERE `type` = 1 AND `category_id` IN (382,403,486,487,488,489,490,491,492,493,494,997,1060,404,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,405,547,548,549,674,675,676,677,678,679,680,681,682,683,684,685,875,883,1021,1022,1023,1024,1025,1026,1051,1052,1053,1065,1773,1774,406,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,640,825,442,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,443,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,1041,444,789,790,791,792,793,794,445,876,877,878,879,880,881,882,451,998,999,1000,1001,1002) LIMIT 1 [ RunTime:0.009455s ]
SELECT * FROM `xn_books` WHERE `type` = 1 AND `category_id` IN (382,403,486,487,488,489,490,491,492,493,494,997,1060,404,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,405,547,548,549,674,675,676,677,678,679,680,681,682,683,684,685,875,883,1021,1022,1023,1024,1025,1026,1051,1052,1053,1065,1773,1774,406,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,640,825,442,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,443,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,1041,444,789,790,791,792,793,794,445,876,877,878,879,880,881,882,451,998,999,1000,1001,1002) LIMIT 30,15 [ RunTime:0.006678s ]