SHOW FULL COLUMNS FROM `xn_keyword` [ RunTime:0.015315s ]
SELECT * FROM `xn_keyword` WHERE `type` = 'hep' AND `type_resources` = 2 ORDER BY `sort` DESC [ RunTime:0.003419s ]
SHOW FULL COLUMNS FROM `xn_category` [ RunTime:0.014983s ]
SELECT * FROM `xn_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.009017s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004644s ]
SELECT * FROM `xn_category` WHERE `type` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.006117s ]
SELECT * FROM `xn_category` WHERE `type` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004847s ]
SHOW FULL COLUMNS FROM `xn_online` [ RunTime:0.015667s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 1 ORDER BY `sort` DESC [ RunTime:0.003297s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 2 ORDER BY `sort` DESC [ RunTime:0.003233s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 3 LIMIT 1 [ RunTime:0.003203s ]
SHOW FULL COLUMNS FROM `xn_hep_category` [ RunTime:0.015598s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 0 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.003357s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 46 [ RunTime:0.003208s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 61 [ RunTime:0.003228s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 62 [ RunTime:0.003182s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 63 [ RunTime:0.003188s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 49 [ RunTime:0.003218s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 AND `category_type` = 'hep' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004298s ]
SHOW FULL COLUMNS FROM `xn_footer` [ RunTime:0.014976s ]
SELECT * FROM `xn_footer` ORDER BY `sort` DESC [ RunTime:0.003330s ]
SELECT * FROM `xn_footer` WHERE `type` = 1 ORDER BY `sort` DESC [ RunTime:0.003251s ]
SELECT * FROM `xn_footer` WHERE `type` = 2 ORDER BY `sort` DESC [ RunTime:0.003256s ]
SELECT `id` FROM `xn_category` WHERE `pid` = 0 AND `category_type` = 'hep' ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.003257s ]
SELECT * FROM `xn_category` WHERE `id` = 197 LIMIT 1 [ RunTime:0.003236s ]
SELECT `title` FROM `xn_category` WHERE `id` = 197 LIMIT 1 [ RunTime:0.003201s ]
SELECT `title` FROM `xn_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003203s ]
SELECT `title` FROM `xn_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003170s ]
SELECT `title` FROM `xn_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003141s ]
SHOW FULL COLUMNS FROM `xn_books` [ RunTime:0.015183s ]
SELECT COUNT(*) AS think_count FROM `xn_books` WHERE `category_id` IN (197,1167,1168,1188,1110,1169,1170,1564,1111,1561,1560,1563,1738,1562,1565,1171,1566,1112,1567,1172,1568,1173,1174,1175,1176,1569,1570,1113,1739,1177,1178,1571,1180,1179,1181,1572,1182,1184,1183,1114,1185,1186,1115,1187,1116,198,206) LIMIT 1 [ RunTime:0.007748s ]
SELECT COUNT(*) AS think_count FROM `xn_books` WHERE `category_id` IN (197,1167,1168,1188,1110,1169,1170,1564,1111,1561,1560,1563,1738,1562,1565,1171,1566,1112,1567,1172,1568,1173,1174,1175,1176,1569,1570,1113,1739,1177,1178,1571,1180,1179,1181,1572,1182,1184,1183,1114,1185,1186,1115,1187,1116,198,206) LIMIT 1 [ RunTime:0.007581s ]
SELECT * FROM `xn_books` WHERE `category_id` IN (197,1167,1168,1188,1110,1169,1170,1564,1111,1561,1560,1563,1738,1562,1565,1171,1566,1112,1567,1172,1568,1173,1174,1175,1176,1569,1570,1113,1739,1177,1178,1571,1180,1179,1181,1572,1182,1184,1183,1114,1185,1186,1115,1187,1116,198,206) ORDER BY `sort` DESC,`create_time` DESC LIMIT 128,16 [ RunTime:0.011062s ]
SHOW FULL COLUMNS FROM `xn_main_banner` [ RunTime:0.015117s ]
SELECT * FROM `xn_main_banner` WHERE `category_id` = 279 ORDER BY `sort` DESC [ RunTime:0.003304s ]