ID |
SQL命令 |
[1] |
SELECT * FROM hd_link WHERE state=1 |
[2] |
SELECT COUNT( * ) FROM hd_content WHERE cid IN(16,17,12) |
[3] |
SELECT COUNT( * ) FROM hd_comment WHERE cid IN(16,17,12) |
[4] |
SELECT * FROM hd_category WHERE pid=0 AND cat_show=1 ORDER BY catorder ASC LIMIT 10 |
[5] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=1 LIMIT 1 |
[6] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=8 LIMIT 1 |
[7] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=13 LIMIT 1 |
[8] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=14 LIMIT 1 |
[9] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=15 LIMIT 1 |
[10] |
SELECT * FROM hd_category WHERE pid=0 AND cat_show=1 ORDER BY catorder ASC LIMIT 10 |
[11] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=1 LIMIT 1 |
[12] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=8 LIMIT 1 |
[13] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=13 LIMIT 1 |
[14] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=14 LIMIT 1 |
[15] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=15 LIMIT 1 |
[16] |
SELECT * FROM hd_category WHERE pid=0 AND cat_show=1 ORDER BY catorder ASC LIMIT 10 |
[17] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=1 LIMIT 1 |
[18] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=8 LIMIT 1 |
[19] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=13 LIMIT 1 |
[20] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=14 LIMIT 1 |
[21] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=15 LIMIT 1 |
[22] |
SELECT COUNT(hd_content.aid) 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(16,17,12) AND hd_content.content_state=1 ORDER BY arc_sort ASC |
[23] |
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(16,17,12) AND hd_content.content_state=1 ORDER BY arc_sort ASC ,aid DESC LIMIT 140,20 |
[24] |
SELECT * FROM hd_category WHERE pid=0 AND cat_show=1 ORDER BY catorder ASC LIMIT 10 |
[25] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=1 LIMIT 1 |
[26] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=8 LIMIT 1 |
[27] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=13 LIMIT 1 |
[28] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=14 LIMIT 1 |
[29] |
SELECT * FROM hd_content INNER JOIN hd_category ON hd_category.cid=hd_content.cid WHERE hd_category.cid=15 LIMIT 1 |