| ID |
SQL命令 |
| [1] |
SELECT * FROM hd_category WHERE pid=0 AND cat_show=1 ORDER BY catorder ASC LIMIT 10 |
| [2] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=52 LIMIT 1 |
| [3] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=52 LIMIT 1 |
| [4] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=53 LIMIT 1 |
| [5] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=54 LIMIT 1 |
| [6] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=55 LIMIT 1 |
| [7] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=62 LIMIT 1 |
| [8] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=62 LIMIT 1 |
| [9] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=61 LIMIT 1 |
| [10] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=61 LIMIT 1 |
| [11] |
SELECT * FROM hd_category WHERE pid=0 AND cat_show=1 ORDER BY catorder ASC LIMIT 10 |
| [12] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=52 LIMIT 1 |
| [13] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=53 LIMIT 1 |
| [14] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=54 LIMIT 1 |
| [15] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=55 LIMIT 1 |
| [16] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=62 LIMIT 1 |
| [17] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=61 LIMIT 1 |
| [18] |
SELECT * FROM hd_category WHERE pid=0 AND cat_show=1 ORDER BY catorder ASC LIMIT 10 |
| [19] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=52 LIMIT 1 |
| [20] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=52 LIMIT 1 |
| [21] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=53 LIMIT 1 |
| [22] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=54 LIMIT 1 |
| [23] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=55 LIMIT 1 |
| [24] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=62 LIMIT 1 |
| [25] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=62 LIMIT 1 |
| [26] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=61 LIMIT 1 |
| [27] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=61 LIMIT 1 |
| [28] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid INNER JOIN hd_user ON hd_user.uid=hd_content.uid WHERE hd_content.cid IN(21) AND hd_content.content_state=1 GROUP BY hd_content.aid ORDER BY arc_sort ASC,updatetime DESC LIMIT 10 |
| [29] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid INNER JOIN hd_user ON hd_user.uid=hd_content.uid WHERE hd_content.cid IN(58) AND hd_content.content_state=1 GROUP BY hd_content.aid ORDER BY addtime desc ,arc_sort ASC,updatetime DESC LIMIT 6 |
| [30] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid INNER JOIN hd_user ON hd_user.uid=hd_content.uid WHERE hd_content.cid IN(57) AND hd_content.content_state=1 GROUP BY hd_content.aid ORDER BY addtime desc ,arc_sort ASC,updatetime DESC LIMIT 1 |
| [31] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid INNER JOIN hd_user ON hd_user.uid=hd_content.uid WHERE hd_content.cid IN(57) AND hd_content.content_state=1 GROUP BY hd_content.aid ORDER BY addtime desc ,arc_sort ASC,updatetime DESC LIMIT 4 |
| [32] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid INNER JOIN hd_user ON hd_user.uid=hd_content.uid WHERE hd_content.cid IN(56) AND hd_content.content_state=1 GROUP BY hd_content.aid ORDER BY addtime desc ,arc_sort ASC,updatetime DESC LIMIT 1 |
| [33] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid INNER JOIN hd_user ON hd_user.uid=hd_content.uid WHERE hd_content.cid IN(56) AND hd_content.content_state=1 GROUP BY hd_content.aid ORDER BY addtime desc ,arc_sort ASC,updatetime DESC LIMIT 4 |
| [34] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid INNER JOIN hd_user ON hd_user.uid=hd_content.uid WHERE hd_content.cid IN(52) AND hd_content.aid IN(59) AND hd_content.content_state=1 GROUP BY hd_content.aid ORDER BY addtime desc ,arc_sort ASC,updatetime DESC LIMIT 10 |
| [35] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=52 LIMIT 1 |
| [36] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid INNER JOIN hd_user ON hd_user.uid=hd_content.uid WHERE hd_content.cid IN(53) AND hd_content.aid IN(60) AND hd_content.content_state=1 GROUP BY hd_content.aid ORDER BY addtime desc ,arc_sort ASC,updatetime DESC LIMIT 10 |
| [37] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=53 LIMIT 1 |
| [38] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid INNER JOIN hd_user ON hd_user.uid=hd_content.uid WHERE hd_content.cid IN(60) AND hd_content.content_state=1 GROUP BY hd_content.aid ORDER BY addtime desc ,arc_sort ASC,updatetime DESC LIMIT 12 |
| [39] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid INNER JOIN hd_user ON hd_user.uid=hd_content.uid WHERE hd_content.cid IN(60) AND hd_content.content_state=1 GROUP BY hd_content.aid ORDER BY addtime desc ,arc_sort ASC,updatetime DESC LIMIT 12 |
| [40] |
SELECT * FROM hd_category WHERE pid=0 AND cat_show=1 ORDER BY catorder ASC LIMIT 10 |
| [41] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=52 LIMIT 1 |
| [42] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=53 LIMIT 1 |
| [43] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=54 LIMIT 1 |
| [44] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=55 LIMIT 1 |
| [45] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=62 LIMIT 1 |
| [46] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=61 LIMIT 1 |
