SHOW FULL COLUMNS FROM `xn_keyword` [ RunTime:0.012676s ]
SELECT * FROM `xn_keyword` WHERE `type` = 'hep' AND `type_resources` = 2 ORDER BY `sort` DESC [ RunTime:0.002791s ]
SHOW FULL COLUMNS FROM `xn_category` [ RunTime:0.007920s ]
SELECT * FROM `xn_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007255s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003982s ]
SELECT * FROM `xn_category` WHERE `type` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004955s ]
SELECT * FROM `xn_category` WHERE `type` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004125s ]
SHOW FULL COLUMNS FROM `xn_online` [ RunTime:0.008012s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 1 ORDER BY `sort` DESC [ RunTime:0.002690s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 2 ORDER BY `sort` DESC [ RunTime:0.002533s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 3 LIMIT 1 [ RunTime:0.002628s ]
SHOW FULL COLUMNS FROM `xn_hep_category` [ RunTime:0.007293s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 0 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002712s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 46 [ RunTime:0.002562s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 61 [ RunTime:0.002809s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 62 [ RunTime:0.002641s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 63 [ RunTime:0.002583s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 49 [ RunTime:0.002822s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 AND `category_type` = 'hep' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003503s ]
SHOW FULL COLUMNS FROM `xn_footer` [ RunTime:0.007569s ]
SELECT * FROM `xn_footer` ORDER BY `sort` DESC [ RunTime:0.002598s ]
SELECT * FROM `xn_footer` WHERE `type` = 1 ORDER BY `sort` DESC [ RunTime:0.002635s ]
SELECT * FROM `xn_footer` WHERE `type` = 2 ORDER BY `sort` DESC [ RunTime:0.002626s ]
SHOW FULL COLUMNS FROM `xn_main_banner` [ RunTime:0.007305s ]
SELECT * FROM `xn_main_banner` WHERE `category_id` = 275 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.002780s ]
SELECT * FROM `xn_main_banner` WHERE `category_id` = 276 ORDER BY `sort` DESC [ RunTime:0.002709s ]
SHOW FULL COLUMNS FROM `xn_books` [ RunTime:0.007876s ]
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 LIMIT 4 [ RunTime:0.002921s ]
SELECT `id` FROM `xn_category` WHERE `pid` = 0 AND `category_type` = 'hep' ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.002666s ]
SELECT * FROM `xn_category` WHERE `pid` = 0 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002823s ]
SELECT * FROM `xn_category` WHERE `pid` = 197 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002746s ]
SELECT * FROM `xn_category` WHERE `pid` = 1110 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002908s ]
SELECT * FROM `xn_category` WHERE `pid` = 1167 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002668s ]
SELECT * FROM `xn_category` WHERE `pid` = 1168 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002596s ]
SELECT * FROM `xn_category` WHERE `pid` = 1188 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002618s ]
SELECT * FROM `xn_category` WHERE `pid` = 1111 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002675s ]
SELECT * FROM `xn_category` WHERE `pid` = 1169 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002614s ]
SELECT * FROM `xn_category` WHERE `pid` = 1170 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002556s ]
SELECT * FROM `xn_category` WHERE `pid` = 1564 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002603s ]
SELECT * FROM `xn_category` WHERE `pid` = 1560 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002605s ]
SELECT * FROM `xn_category` WHERE `pid` = 1561 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002618s ]
SELECT * FROM `xn_category` WHERE `pid` = 1562 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002590s ]
SELECT * FROM `xn_category` WHERE `pid` = 1563 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002557s ]
SELECT * FROM `xn_category` WHERE `pid` = 1738 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002640s ]
SELECT * FROM `xn_category` WHERE `pid` = 1112 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002697s ]
SELECT * FROM `xn_category` WHERE `pid` = 1565 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002670s ]
SELECT * FROM `xn_category` WHERE `pid` = 1171 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002598s ]
SELECT * FROM `xn_category` WHERE `pid` = 1566 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002585s ]
SELECT * FROM `xn_category` WHERE `pid` = 1113 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002629s ]
SELECT * FROM `xn_category` WHERE `pid` = 1567 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002599s ]
SELECT * FROM `xn_category` WHERE `pid` = 1172 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002624s ]
SELECT * FROM `xn_category` WHERE `pid` = 1568 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002583s ]
SELECT * FROM `xn_category` WHERE `pid` = 1173 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002602s ]
SELECT * FROM `xn_category` WHERE `pid` = 1174 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002647s ]
SELECT * FROM `xn_category` WHERE `pid` = 1175 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002765s ]
SELECT * FROM `xn_category` WHERE `pid` = 1176 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002687s ]
SELECT * FROM `xn_category` WHERE `pid` = 1569 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002621s ]
SELECT * FROM `xn_category` WHERE `pid` = 1570 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002558s ]
SELECT * FROM `xn_category` WHERE `pid` = 1114 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002643s ]
SELECT * FROM `xn_category` WHERE `pid` = 1739 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002668s ]
SELECT * FROM `xn_category` WHERE `pid` = 1177 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002644s ]
SELECT * FROM `xn_category` WHERE `pid` = 1178 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002607s ]
SELECT * FROM `xn_category` WHERE `pid` = 1571 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002779s ]
SELECT * FROM `xn_category` WHERE `pid` = 1180 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002650s ]
SELECT * FROM `xn_category` WHERE `pid` = 1179 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002689s ]
SELECT * FROM `xn_category` WHERE `pid` = 1181 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002602s ]
SELECT * FROM `xn_category` WHERE `pid` = 1572 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002601s ]
SELECT * FROM `xn_category` WHERE `pid` = 1182 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002653s ]
SELECT * FROM `xn_category` WHERE `pid` = 1184 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002605s ]
SELECT * FROM `xn_category` WHERE `pid` = 1183 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002616s ]
SELECT * FROM `xn_category` WHERE `pid` = 1115 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002619s ]
SELECT * FROM `xn_category` WHERE `pid` = 1185 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002629s ]
SELECT * FROM `xn_category` WHERE `pid` = 1186 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002701s ]
SELECT * FROM `xn_category` WHERE `pid` = 1116 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002605s ]
SELECT * FROM `xn_category` WHERE `pid` = 1187 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002767s ]
SELECT * FROM `xn_category` WHERE `pid` = 206 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002693s ]
SELECT * FROM `xn_category` WHERE `pid` = 198 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002630s ]
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.004129s ]
SELECT * FROM `xn_category` WHERE `id` = 197 LIMIT 1 [ RunTime:0.002557s ]
0
样
