| ID |
SQL命令 |
| [1] |
SELECT sundry_id FROM cms_t_n WHERE tag_id=31 |
| [2] |
SELECT name FROM cms_tag WHERE id=31 |
| [3] |
SELECT number FROM cms_tag WHERE id=31 |
| [4] |
UPDATE cms_tag SET `number`=748 WHERE id=31 |
| [5] |
SELECT sundry_id FROM cms_t_n WHERE tag_id=31 |
| [6] |
SELECT id as nid,title as ntitle,en_path as nen_path,imgpath as nimgpath,attr as nattr,style as nstyle,addtime as naddtime,click as nclick FROM cms_n_sundry WHERE verify='2' AND recycle='1' AND timing='1' AND id IN(120,139,179) AND id IN(select sundry_id from cms_c_n where class_type='1') ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,12 |
| [7] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE isshow="1" ORDER BY sort ASC,id ASC |
| [8] |
SELECT id,scription FROM cms_new WHERE id IN(179,139,120) |
| [9] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(179,139,120) AND class_type=1 |
| [10] |
SELECT sundry_id FROM cms_t_n WHERE tag_id=31 |
| [11] |
SELECT COUNT(id) AS id FROM cms_n_sundry WHERE verify='2' AND recycle='1' AND timing='1' AND id IN(120,139,179) AND id IN(select sundry_id from cms_c_n where class_type='1') |
| [12] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=8 |
| [13] |
SELECT id,parent FROM cms_class |
| [14] |
SELECT cms_n_sundry.id FROM cms_n_sundry LEFT JOIN cms_c_n ON cms_n_sundry.id=cms_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND (attr LIKE '%推荐%') AND class_id IN(1,9,10,11,13) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,8 |
| [15] |
SELECT id,scription,`key`,`source` FROM cms_new WHERE id IN(8,1) |
| [16] |
SELECT id,id AS nid,title AS ntitle,style AS nstyle,en_path AS nen_path,attr AS nattr,click AS nclick,addtime AS naddtime,imgpath AS nimgpath FROM cms_n_sundry WHERE id IN(8,1) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [17] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(8,1) AND class_type='1' |
| [18] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(9) |
| [19] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath FROM cms_class WHERE isshow="1" AND parent=0 AND phone IN('2','1') ORDER BY sort ASC,id DESC |
| [20] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=1 |
| [21] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=10 |
| [22] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=9 |
| [23] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=11 |
| [24] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=13 |
| [25] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=8 |
| [26] |
SELECT id,parent FROM cms_class |
| [27] |
SELECT cms_n_sundry.id FROM cms_n_sundry LEFT JOIN cms_c_n ON cms_n_sundry.id=cms_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND class_id IN(10) ORDER BY cms_n_sundry.id ASC LIMIT 0,30 |
| [28] |
SELECT id,scription,`key`,`source` FROM cms_new WHERE id IN(13,14,15,16,17,18,19,20,21,22,23,69,71) |
| [29] |
SELECT id,id AS nid,title AS ntitle,style AS nstyle,en_path AS nen_path,attr AS nattr,click AS nclick,addtime AS naddtime,imgpath AS nimgpath FROM cms_n_sundry WHERE id IN(13,14,15,16,17,18,19,20,21,22,23,69,71) ORDER BY cms_n_sundry.id ASC |
| [30] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(13,14,15,16,17,18,19,20,21,22,23,69,71) AND class_type='1' |
| [31] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(10) |
| [32] |
SELECT id,parent FROM cms_class |
| [33] |
SELECT cms_n_sundry.id FROM cms_n_sundry LEFT JOIN cms_c_n ON cms_n_sundry.id=cms_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND class_id IN(9) ORDER BY cms_n_sundry.id ASC LIMIT 0,30 |
| [34] |
SELECT id,scription,`key`,`source` FROM cms_new WHERE id IN(1,2,3,4,5,6,7,8,9,10,11,12,170) |
| [35] |
SELECT id,id AS nid,title AS ntitle,style AS nstyle,en_path AS nen_path,attr AS nattr,click AS nclick,addtime AS naddtime,imgpath AS nimgpath FROM cms_n_sundry WHERE id IN(1,2,3,4,5,6,7,8,9,10,11,12,170) ORDER BY cms_n_sundry.id ASC |
| [36] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(1,2,3,4,5,6,7,8,9,10,11,12,170) AND class_type='1' |
| [37] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(9) |
| [38] |
SELECT id,parent FROM cms_class |
| [39] |
SELECT cms_n_sundry.id FROM cms_n_sundry LEFT JOIN cms_c_n ON cms_n_sundry.id=cms_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND class_id IN(11) ORDER BY cms_n_sundry.id ASC LIMIT 0,30 |
| [40] |
SELECT id,scription,`key`,`source` FROM cms_new WHERE id IN(24,25,26,27,28,29,30) |
| [41] |
SELECT id,id AS nid,title AS ntitle,style AS nstyle,en_path AS nen_path,attr AS nattr,click AS nclick,addtime AS naddtime,imgpath AS nimgpath FROM cms_n_sundry WHERE id IN(24,25,26,27,28,29,30) ORDER BY cms_n_sundry.id ASC |
| [42] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(24,25,26,27,28,29,30) AND class_type='1' |
| [43] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(11) |
| [44] |
SELECT id,parent FROM cms_class |
| [45] |
SELECT cms_n_sundry.id FROM cms_n_sundry LEFT JOIN cms_c_n ON cms_n_sundry.id=cms_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND class_id IN(13) ORDER BY cms_n_sundry.id ASC LIMIT 0,30 |
| [46] |
SELECT id,scription,`key`,`source` FROM cms_new WHERE id IN(78,96,116) |
| [47] |
SELECT id,id AS nid,title AS ntitle,style AS nstyle,en_path AS nen_path,attr AS nattr,click AS nclick,addtime AS naddtime,imgpath AS nimgpath FROM cms_n_sundry WHERE id IN(78,96,116) ORDER BY cms_n_sundry.id ASC |
| [48] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(78,96,116) AND class_type='1' |
| [49] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(13) |
| [50] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath FROM cms_class WHERE isshow="1" AND parent=0 AND phone IN('2','1') ORDER BY sort ASC,id DESC |
