| ID |
SQL命令 |
| [1] |
SELECT cms_new.id,title,seo_title,`key`,scription FROM cms_n_sundry LEFT JOIN cms_new ON cms_n_sundry.id=cms_new.id WHERE cms_n_sundry.id=3 |
| [2] |
SELECT class_id FROM cms_c_n WHERE sundry_id=3 AND class_type='1' |
| [3] |
SELECT * FROM cms_class WHERE id=9 |
| [4] |
SELECT class_id FROM cms_c_n WHERE sundry_id=3 AND class_type=1 |
| [5] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE isshow="1" AND phone IN('2','1') ORDER BY sort ASC,id ASC |
| [6] |
SELECT cms_class.id,en_name,classpath,newpath,href,ISHTML,weight FROM cms_c_n LEFT JOIN cms_class ON cms_class.id=cms_c_n.class_id WHERE cms_c_n.sundry_id=3 AND cms_c_n.class_type='1' |
| [7] |
SELECT cms_n_sundry.id AS nid,title AS ntitle,style AS nstyle,en_path AS nen_path,addtime AS naddtime FROM cms_n_sundry LEFT JOIN cms_c_n ON cms_n_sundry.id=cms_c_n.sundry_id WHERE verify='2' AND recycle='1' AND timing='1' AND cms_c_n.class_id=9 AND cms_n_sundry.id>3 ORDER BY cms_n_sundry.id ASC LIMIT 1 |
| [8] |
SELECT cms_n_sundry.id AS nid,title AS ntitle,style AS nstyle,en_path AS nen_path,addtime AS naddtime FROM cms_n_sundry LEFT JOIN cms_c_n ON cms_n_sundry.id=cms_c_n.sundry_id WHERE verify='2' AND recycle='1' AND timing='1' AND cms_c_n.class_id=9 AND cms_n_sundry.id<3 ORDER BY cms_n_sundry.id DESC LIMIT 1 |
| [9] |
SELECT cms_n_sundry.id,title,style,author,attr,click,addtime,imgpath,scription,text,source FROM cms_n_sundry LEFT JOIN cms_new ON cms_n_sundry.id=cms_new.id WHERE verify='2' AND cms_n_sundry.id=3 |
| [10] |
SELECT name,href,rate,opennew,isapply,number FROM cms_key WHERE isapply="1" ORDER BY rate DESC |
| [11] |
SELECT cms_tag.id AS id,name,number FROM cms_t_n LEFT JOIN cms_tag ON cms_tag.id=cms_t_n.tag_id WHERE cms_t_n.sundry_id=3 |
| [12] |
SELECT resemble,`key` AS nkey FROM cms_n_sundry LEFT JOIN cms_new ON cms_n_sundry.id=cms_new.id WHERE cms_n_sundry.id=3 |
| [13] |
SELECT cms_n_sundry.id,class_id FROM cms_n_sundry LEFT JOIN cms_c_n ON cms_n_sundry.id=cms_c_n.sundry_id WHERE verify='2' AND recycle='1' AND cms_n_sundry.id IN(13,2,1,95,54) AND class_type='1' AND timing='1' AND cms_c_n.class_id IN(2,3) ORDER BY cms_n_sundry.id ASC LIMIT 0,4 |
| [14] |
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(54) ORDER BY cms_n_sundry.id ASC |
| [15] |
SELECT id,scription,`key` AS nkey FROM cms_new WHERE id IN(54) |
| [16] |
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 |
| [17] |
SELECT resemble,`key` AS nkey FROM cms_n_sundry LEFT JOIN cms_new ON cms_n_sundry.id=cms_new.id WHERE cms_n_sundry.id=3 |
| [18] |
SELECT cms_n_sundry.id,class_id FROM cms_n_sundry LEFT JOIN cms_c_n ON cms_n_sundry.id=cms_c_n.sundry_id WHERE verify='2' AND recycle='1' AND cms_n_sundry.id IN(13,2,1,95,54) AND class_type='1' AND timing='1' AND cms_c_n.class_id IN(1,9,10,11) AND imgpath<>'' ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,3 |
| [19] |
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,2,1) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [20] |
SELECT id,scription,`key` AS nkey FROM cms_new WHERE id IN(13,2,1) |
| [21] |
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 |
| [22] |
SELECT resemble,`key` AS nkey FROM cms_n_sundry LEFT JOIN cms_new ON cms_n_sundry.id=cms_new.id WHERE cms_n_sundry.id=3 |
| [23] |
SELECT cms_n_sundry.id,class_id FROM cms_n_sundry LEFT JOIN cms_c_n ON cms_n_sundry.id=cms_c_n.sundry_id WHERE verify='2' AND recycle='1' AND cms_n_sundry.id IN(13,2,1,95,54) AND class_type='1' AND timing='1' AND cms_c_n.class_id IN(2,3) ORDER BY cms_n_sundry.id ASC LIMIT 0,8 |
| [24] |
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(54) ORDER BY cms_n_sundry.id ASC |
| [25] |
SELECT id,scription,`key` AS nkey FROM cms_new WHERE id IN(54) |
| [26] |
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 |
| [27] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=8 |
| [28] |
SELECT id,parent FROM cms_class |
| [29] |
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 |
| [30] |
SELECT id,scription,`key`,`source` FROM cms_new WHERE id IN(8,1) |
| [31] |
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 |
| [32] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(8,1) AND class_type='1' |
| [33] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(9) |
| [34] |
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 |
| [35] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=1 |
| [36] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=10 |
| [37] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=9 |
| [38] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=11 |
| [39] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=13 |
| [40] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=8 |
| [41] |
SELECT id,parent FROM cms_class |
| [42] |
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 |
| [43] |
SELECT id,scription,`key`,`source` FROM cms_new WHERE id IN(13,14,15,16,17,18,19,20,21,22,23,69,71) |
| [44] |
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 |
| [45] |
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' |
| [46] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(10) |
| [47] |
SELECT id,parent FROM cms_class |
| [48] |
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 |
| [49] |
SELECT id,scription,`key`,`source` FROM cms_new WHERE id IN(1,2,3,4,5,6,7,8,9,10,11,12,170) |
| [50] |
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 |
| [51] |
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' |
| [52] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(9) |
| [53] |
SELECT id,parent FROM cms_class |
| [54] |
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 |
| [55] |
SELECT id,scription,`key`,`source` FROM cms_new WHERE id IN(24,25,26,27,28,29,30) |
| [56] |
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 |
| [57] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(24,25,26,27,28,29,30) AND class_type='1' |
| [58] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(11) |
| [59] |
SELECT id,parent FROM cms_class |
| [60] |
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 |
| [61] |
SELECT id,scription,`key`,`source` FROM cms_new WHERE id IN(78,96,116) |
| [62] |
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 |
| [63] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(78,96,116) AND class_type='1' |
| [64] |
SELECT id,name,en_name,href,parent,sort,isshow,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(13) |
| [65] |
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 |
