SHOW FULL COLUMNS FROM `xn_keyword` [ RunTime:0.015227s ]
SELECT * FROM `xn_keyword` WHERE `type` = 'hep' AND `type_resources` = 2 ORDER BY `sort` DESC [ RunTime:0.003235s ]
SHOW FULL COLUMNS FROM `xn_category` [ RunTime:0.014754s ]
SELECT * FROM `xn_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008585s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004394s ]
SELECT * FROM `xn_category` WHERE `type` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005459s ]
SELECT * FROM `xn_category` WHERE `type` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004507s ]
SHOW FULL COLUMNS FROM `xn_online` [ RunTime:0.015197s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 1 ORDER BY `sort` DESC [ RunTime:0.003091s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 2 ORDER BY `sort` DESC [ RunTime:0.002913s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 3 LIMIT 1 [ RunTime:0.002882s ]
SHOW FULL COLUMNS FROM `xn_hep_category` [ RunTime:0.014740s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 0 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002970s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 46 [ RunTime:0.002924s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 61 [ RunTime:0.002890s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 62 [ RunTime:0.002835s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 63 [ RunTime:0.002868s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 49 [ RunTime:0.002906s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 AND `category_type` = 'hep' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003983s ]
SHOW FULL COLUMNS FROM `xn_footer` [ RunTime:0.014803s ]
SELECT * FROM `xn_footer` ORDER BY `sort` DESC [ RunTime:0.003029s ]
SELECT * FROM `xn_footer` WHERE `type` = 1 ORDER BY `sort` DESC [ RunTime:0.002987s ]
SELECT * FROM `xn_footer` WHERE `type` = 2 ORDER BY `sort` DESC [ RunTime:0.003044s ]
SHOW FULL COLUMNS FROM `xn_main_banner` [ RunTime:0.014758s ]
SELECT * FROM `xn_main_banner` WHERE `category_id` = 275 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.003118s ]
SELECT * FROM `xn_main_banner` WHERE `category_id` = 276 ORDER BY `sort` DESC [ RunTime:0.002976s ]
SHOW FULL COLUMNS FROM `xn_books` [ RunTime:0.014864s ]
SELECT `b`.`is_recommend`,`b`.`id`,`b`.`image`,`b`.`title`,`b`.`author`,`b`.`book_number`,`b`.`price`,`b`.`publish_time`,`b`.`cid`,`b`.`type`,`r`.`location`,r.sort as rsort FROM `xn_books` `b` INNER JOIN `xn_books_recommend` `r` ON `r`.`book_id`=`b`.`id` WHERE `b`.`type` = '1' AND `b`.`cid` = '5' AND `r`.`location` = '2' AND `r`.`category_name` = 'hep' ORDER BY `r`.`sort` ASC,`b`.`sort` DESC,`b`.`create_time` DESC LIMIT 4 [ RunTime:0.003786s ]
SELECT `id` FROM `xn_category` WHERE `pid` = 0 AND `category_type` = 'hep' ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.002989s ]
SELECT * FROM `xn_category` WHERE `pid` = 0 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003088s ]
SELECT * FROM `xn_category` WHERE `pid` = 197 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003093s ]
SELECT * FROM `xn_category` WHERE `pid` = 1110 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003004s ]
SELECT * FROM `xn_category` WHERE `pid` = 1167 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003057s ]
SELECT * FROM `xn_category` WHERE `pid` = 1168 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003025s ]
SELECT * FROM `xn_category` WHERE `pid` = 1188 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002976s ]
SELECT * FROM `xn_category` WHERE `pid` = 1111 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003015s ]
SELECT * FROM `xn_category` WHERE `pid` = 1169 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002965s ]
SELECT * FROM `xn_category` WHERE `pid` = 1170 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003008s ]
SELECT * FROM `xn_category` WHERE `pid` = 1564 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003002s ]
SELECT * FROM `xn_category` WHERE `pid` = 1560 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002962s ]
SELECT * FROM `xn_category` WHERE `pid` = 1561 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002969s ]
SELECT * FROM `xn_category` WHERE `pid` = 1562 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002960s ]
SELECT * FROM `xn_category` WHERE `pid` = 1563 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002921s ]
SELECT * FROM `xn_category` WHERE `pid` = 1738 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003007s ]
SELECT * FROM `xn_category` WHERE `pid` = 1112 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002970s ]
SELECT * FROM `xn_category` WHERE `pid` = 1565 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002932s ]
SELECT * FROM `xn_category` WHERE `pid` = 1171 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002963s ]
SELECT * FROM `xn_category` WHERE `pid` = 1566 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002955s ]
SELECT * FROM `xn_category` WHERE `pid` = 1113 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003011s ]
SELECT * FROM `xn_category` WHERE `pid` = 1567 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002960s ]
SELECT * FROM `xn_category` WHERE `pid` = 1172 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002978s ]
SELECT * FROM `xn_category` WHERE `pid` = 1568 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002959s ]
SELECT * FROM `xn_category` WHERE `pid` = 1173 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003023s ]
SELECT * FROM `xn_category` WHERE `pid` = 1174 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002982s ]
SELECT * FROM `xn_category` WHERE `pid` = 1175 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003003s ]
SELECT * FROM `xn_category` WHERE `pid` = 1176 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003071s ]
SELECT * FROM `xn_category` WHERE `pid` = 1569 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003013s ]
SELECT * FROM `xn_category` WHERE `pid` = 1570 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002967s ]
SELECT * FROM `xn_category` WHERE `pid` = 1114 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003020s ]
SELECT * FROM `xn_category` WHERE `pid` = 1739 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002964s ]
SELECT * FROM `xn_category` WHERE `pid` = 1177 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002986s ]
SELECT * FROM `xn_category` WHERE `pid` = 1178 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002966s ]
SELECT * FROM `xn_category` WHERE `pid` = 1571 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002913s ]
SELECT * FROM `xn_category` WHERE `pid` = 1180 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002951s ]
SELECT * FROM `xn_category` WHERE `pid` = 1179 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.003019s ]
SELECT * FROM `xn_category` WHERE `pid` = 1181 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002939s ]
SELECT * FROM `xn_category` WHERE `pid` = 1572 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002932s ]
SELECT * FROM `xn_category` WHERE `pid` = 1182 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002918s ]
SELECT * FROM `xn_category` WHERE `pid` = 1184 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002928s ]
SELECT * FROM `xn_category` WHERE `pid` = 1183 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002982s ]
SELECT * FROM `xn_category` WHERE `pid` = 1115 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002966s ]
SELECT * FROM `xn_category` WHERE `pid` = 1185 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002948s ]
SELECT * FROM `xn_category` WHERE `pid` = 1186 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002949s ]
SELECT * FROM `xn_category` WHERE `pid` = 1116 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002956s ]
SELECT * FROM `xn_category` WHERE `pid` = 1187 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002944s ]
SELECT * FROM `xn_category` WHERE `pid` = 206 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002942s ]
SELECT * FROM `xn_category` WHERE `pid` = 198 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002928s ]
SELECT `b`.`is_recommend`,`b`.`id`,`b`.`image`,`b`.`title`,`b`.`author`,`b`.`book_number`,`b`.`price`,`b`.`publish_time`,`b`.`cid`,`b`.`type`,`b`.`category_id`,`r`.`location`,r.sort as rsort,`r`.`book_id` FROM `xn_books` `b` INNER JOIN `xn_books_recommend` `r` ON `r`.`book_id`=`b`.`id` WHERE `b`.`type` = '1' AND `b`.`category_id` IN ('197','1110','1167','1390','1391','1392','1393','1394','1395','1396','1397','1398','1399','1547','1548','1549','1550','1551','1552','1556','1168','1400','1401','1402','1403','1404','1405','1553','1188','1559','1111','1169','1406','1407','1408','1409','1410','1411','1170','1412','1413','1414','1415','1416','1417','1418','1419','1564','1560','1561','1562','1563','1738','1112','1565','1171','1420','1566','1113','1567','1172','1421','1422','1423','1424','1425','1426','1427','1428','1429','1430','1568','1173','1431','1432','1433','1434','1435','1436','1437','1438','1521','1174','1175','1439','1440','1441','1442','1443','1444','1445','1446','1447','1448','1449','1450','1451','1452','1453','1554','1176','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','1569','1570','1114','1739','1177','1454','1455','1456','1457','1178','1458','1459','1460','1461','1571','1180','1477','1478','1479','1480','1481','1482','1483','1484','1485','1486','1487','1488','1489','1179','1462','1463','1464','1465','1466','1467','1468','1469','1470','1471','1472','1473','1474','1475','1476','1517','1518','1519','1555','1557','1558','1181','1490','1491','1572','1182','1492','1493','1494','1495','1496','1184','1502','1503','1183','1497','1498','1499','1500','1501','1115','1185','1504','1505','1506','1507','1508','1186','1509','1510','1511','1512','1116','1187','1513','1514','1515','1516','1546','206','198','199','200','201','202','203','204') AND `b`.`cid` = '5' AND `r`.`location` = '3' AND `r`.`category_name` = 'hep' ORDER BY `r`.`sort` ASC LIMIT 6 [ RunTime:0.004329s ]
SELECT * FROM `xn_category` WHERE `id` = 197 LIMIT 1 [ RunTime:0.002911s ]
0
样
