SHOW FULL COLUMNS FROM `xn_keyword` [ RunTime:0.015132s ]
SELECT * FROM `xn_keyword` WHERE `type` = 'hep' AND `type_resources` = 2 ORDER BY `sort` DESC [ RunTime:0.003221s ]
SHOW FULL COLUMNS FROM `xn_category` [ RunTime:0.015259s ]
SELECT * FROM `xn_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.116337s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.084168s ]
SELECT * FROM `xn_category` WHERE `type` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.413620s ]
SELECT * FROM `xn_category` WHERE `type` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.032266s ]
SHOW FULL COLUMNS FROM `xn_online` [ RunTime:0.015394s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 1 ORDER BY `sort` DESC [ RunTime:0.003080s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 2 ORDER BY `sort` DESC [ RunTime:0.003014s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 3 LIMIT 1 [ RunTime:0.003018s ]
SHOW FULL COLUMNS FROM `xn_hep_category` [ RunTime:0.015028s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 0 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.003089s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 46 [ RunTime:0.002998s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 61 [ RunTime:0.062982s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 62 [ RunTime:0.003007s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 63 [ RunTime:0.003002s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 49 [ RunTime:0.002958s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 AND `category_type` = 'hep' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004005s ]
SHOW FULL COLUMNS FROM `xn_footer` [ RunTime:0.014848s ]
SELECT * FROM `xn_footer` ORDER BY `sort` DESC [ RunTime:0.003112s ]
SELECT * FROM `xn_footer` WHERE `type` = 1 ORDER BY `sort` DESC [ RunTime:0.003033s ]
SELECT * FROM `xn_footer` WHERE `type` = 2 ORDER BY `sort` DESC [ RunTime:0.003043s ]
SELECT `id` FROM `xn_category` WHERE `pid` = 0 AND `category_type` = 'hep' ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.003073s ]
SELECT * FROM `xn_category` WHERE `id` = 197 LIMIT 1 [ RunTime:0.003029s ]
SELECT `title` FROM `xn_category` WHERE `id` = 197 LIMIT 1 [ RunTime:0.002985s ]
SELECT `title` FROM `xn_category` WHERE `id` = 1113 LIMIT 1 [ RunTime:0.002985s ]
SELECT `title` FROM `xn_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002953s ]
SELECT `title` FROM `xn_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002943s ]
SHOW FULL COLUMNS FROM `xn_books` [ RunTime:0.015083s ]
SELECT COUNT(*) AS think_count FROM `xn_books` WHERE `category_id` IN (1113,1567,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1172,1568,1431,1432,1433,1434,1435,1436,1437,1438,1521,1173,1174,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1554,1175,1520,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1176,1569,1570) LIMIT 1 [ RunTime:0.005761s ]
SELECT COUNT(*) AS think_count FROM `xn_books` WHERE `category_id` IN (1113,1567,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1172,1568,1431,1432,1433,1434,1435,1436,1437,1438,1521,1173,1174,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1554,1175,1520,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1176,1569,1570) LIMIT 1 [ RunTime:0.124458s ]
SELECT * FROM `xn_books` WHERE `category_id` IN (1113,1567,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1172,1568,1431,1432,1433,1434,1435,1436,1437,1438,1521,1173,1174,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1554,1175,1520,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1176,1569,1570) ORDER BY `sort` DESC,`create_time` DESC LIMIT 96,16 [ RunTime:2.488377s ]
SHOW FULL COLUMNS FROM `xn_main_banner` [ RunTime:0.015216s ]
SELECT * FROM `xn_main_banner` WHERE `category_id` = 279 ORDER BY `sort` DESC [ RunTime:0.003178s ]