ID |
SQL命令 |
[1] |
SELECT name,addons FROM hz_hooks WHERE status=1 |
[2] |
SELECT * FROM hz_category_access WHERE cid =151 |
[3] |
SELECT * FROM hz_content content INNER JOIN hz_category category ON category.cid=content.cid INNER JOIN hz_user user ON user.uid=content.uid INNER JOIN hz_model model ON model.mid=category.mid INNER JOIN hz_content_data content_data ON content.aid=content_data.aid WHERE content.aid = 1 |
[4] |
SELECT * FROM hz_content_tag ct JOIN hz_tag t ON ct.tid=t.tid WHERE ct.mid = 1 AND ct.aid = 1 |
[5] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=151 |
[6] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=154 |
[7] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=151 |
[8] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=152 |
[9] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=154 |
[10] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=151 |
[11] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=152 |
[12] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=154 |
[13] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=151 |
[14] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=152 |
[15] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=154 |
[16] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=151 |
[17] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=152 |
[18] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=154 |
[19] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=151 |
[20] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=152 |
[21] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=151 |
[22] |
SELECT count(*) AS c FROM hz_content content INNER JOIN hz_category category ON category.cid=content.cid INNER JOIN hz_user user ON user.uid=content.uid INNER JOIN hz_model model ON model.mid=category.mid WHERE category.cid IN(124,125,126,127,128,129,130,131,170,123) AND content_status=1 |
[23] |
SELECT * FROM hz_content content INNER JOIN hz_category category ON category.cid=content.cid INNER JOIN hz_user user ON user.uid=content.uid INNER JOIN hz_model model ON model.mid=category.mid WHERE category.cid IN(124,125,126,127,128,129,130,131,170,123) AND content_status=1 ORDER BY category.cid LIMIT 0,10 |
[24] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=151 |
[25] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=154 |
[26] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=151 |
[27] |
SELECT * FROM hz_category c JOIN hz_content t ON c.cid=t.cid WHERE c.cid=152 |