SHOW FULL COLUMNS FROM `xn_keyword` [ RunTime:0.011824s ]
SELECT * FROM `xn_keyword` WHERE `type` = 'hep' AND `type_resources` = 2 ORDER BY `sort` DESC [ RunTime:0.002713s ]
SHOW FULL COLUMNS FROM `xn_category` [ RunTime:0.007311s ]
SELECT * FROM `xn_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.007380s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003823s ]
SELECT * FROM `xn_category` WHERE `type` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005358s ]
SELECT * FROM `xn_category` WHERE `type` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003760s ]
SHOW FULL COLUMNS FROM `xn_online` [ RunTime:0.011322s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 1 ORDER BY `sort` DESC [ RunTime:0.002559s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 2 ORDER BY `sort` DESC [ RunTime:0.002542s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'hep' AND `type` = 3 LIMIT 1 [ RunTime:0.002431s ]
SHOW FULL COLUMNS FROM `xn_hep_category` [ RunTime:0.007356s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 0 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002588s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 46 [ RunTime:0.002478s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 61 [ RunTime:0.002414s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 62 [ RunTime:0.002468s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 63 [ RunTime:0.002427s ]
SELECT * FROM `xn_hep_category` WHERE `pid` = 49 [ RunTime:0.002415s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 AND `category_type` = 'hep' ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003476s ]
SHOW FULL COLUMNS FROM `xn_footer` [ RunTime:0.007460s ]
SELECT * FROM `xn_footer` ORDER BY `sort` DESC [ RunTime:0.002575s ]
SELECT * FROM `xn_footer` WHERE `type` = 1 ORDER BY `sort` DESC [ RunTime:0.002508s ]
SELECT * FROM `xn_footer` WHERE `type` = 2 ORDER BY `sort` DESC [ RunTime:0.002414s ]
SHOW FULL COLUMNS FROM `xn_main_banner` [ RunTime:0.007197s ]
SELECT * FROM `xn_main_banner` WHERE `category_id` = 275 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.002556s ]
SELECT * FROM `xn_main_banner` WHERE `category_id` = 276 ORDER BY `sort` DESC [ RunTime:0.002460s ]
SHOW FULL COLUMNS FROM `xn_books` [ RunTime:0.007430s ]
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.002959s ]
SELECT `id` FROM `xn_category` WHERE `pid` = 0 AND `category_type` = 'hep' ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.002531s ]
SELECT * FROM `xn_category` WHERE `pid` = 0 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002504s ]
SELECT * FROM `xn_category` WHERE `pid` = 197 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002477s ]
SELECT * FROM `xn_category` WHERE `pid` = 1110 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002465s ]
SELECT * FROM `xn_category` WHERE `pid` = 1167 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002550s ]
SELECT * FROM `xn_category` WHERE `pid` = 1168 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002550s ]
SELECT * FROM `xn_category` WHERE `pid` = 1188 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002498s ]
SELECT * FROM `xn_category` WHERE `pid` = 1111 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002566s ]
SELECT * FROM `xn_category` WHERE `pid` = 1169 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002573s ]
SELECT * FROM `xn_category` WHERE `pid` = 1170 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002661s ]
SELECT * FROM `xn_category` WHERE `pid` = 1564 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002456s ]
SELECT * FROM `xn_category` WHERE `pid` = 1560 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002479s ]
SELECT * FROM `xn_category` WHERE `pid` = 1561 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002516s ]
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.002531s ]
SELECT * FROM `xn_category` WHERE `pid` = 1738 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002517s ]
SELECT * FROM `xn_category` WHERE `pid` = 1112 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002504s ]
SELECT * FROM `xn_category` WHERE `pid` = 1565 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002446s ]
SELECT * FROM `xn_category` WHERE `pid` = 1171 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002483s ]
SELECT * FROM `xn_category` WHERE `pid` = 1566 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002455s ]
SELECT * FROM `xn_category` WHERE `pid` = 1113 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002642s ]
SELECT * FROM `xn_category` WHERE `pid` = 1567 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002515s ]
SELECT * FROM `xn_category` WHERE `pid` = 1172 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002585s ]
SELECT * FROM `xn_category` WHERE `pid` = 1568 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002558s ]
SELECT * FROM `xn_category` WHERE `pid` = 1173 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002543s ]
SELECT * FROM `xn_category` WHERE `pid` = 1174 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002637s ]
SELECT * FROM `xn_category` WHERE `pid` = 1175 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002620s ]
SELECT * FROM `xn_category` WHERE `pid` = 1176 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002680s ]
SELECT * FROM `xn_category` WHERE `pid` = 1569 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002546s ]
SELECT * FROM `xn_category` WHERE `pid` = 1570 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002542s ]
SELECT * FROM `xn_category` WHERE `pid` = 1114 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002692s ]
SELECT * FROM `xn_category` WHERE `pid` = 1739 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002566s ]
SELECT * FROM `xn_category` WHERE `pid` = 1177 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002513s ]
SELECT * FROM `xn_category` WHERE `pid` = 1178 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002539s ]
SELECT * FROM `xn_category` WHERE `pid` = 1571 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002599s ]
SELECT * FROM `xn_category` WHERE `pid` = 1180 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002509s ]
SELECT * FROM `xn_category` WHERE `pid` = 1179 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002554s ]
SELECT * FROM `xn_category` WHERE `pid` = 1181 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002479s ]
SELECT * FROM `xn_category` WHERE `pid` = 1572 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002504s ]
SELECT * FROM `xn_category` WHERE `pid` = 1182 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002528s ]
SELECT * FROM `xn_category` WHERE `pid` = 1184 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002484s ]
SELECT * FROM `xn_category` WHERE `pid` = 1183 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002488s ]
SELECT * FROM `xn_category` WHERE `pid` = 1115 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002481s ]
SELECT * FROM `xn_category` WHERE `pid` = 1185 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002480s ]
SELECT * FROM `xn_category` WHERE `pid` = 1186 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002515s ]
SELECT * FROM `xn_category` WHERE `pid` = 1116 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002503s ]
SELECT * FROM `xn_category` WHERE `pid` = 1187 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002540s ]
SELECT * FROM `xn_category` WHERE `pid` = 206 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002474s ]
SELECT * FROM `xn_category` WHERE `pid` = 198 AND `category_type` = 'hep' ORDER BY `sort` ASC [ RunTime:0.002496s ]
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.004051s ]
SELECT * FROM `xn_category` WHERE `id` = 197 LIMIT 1 [ RunTime:0.002549s ]
0
样
