| ID |
SQL命令 |
| [1] |
SELECT en_name,id,modeltype FROM cms_class WHERE en_name='henan' |
| [2] |
SELECT en_name,id FROM cms_area WHERE en_name='' |
| [3] |
SELECT en_name,id,modeltype FROM cms_class WHERE en_name='57' |
| [4] |
SELECT en_name,id FROM cms_area WHERE en_name='henan' |
| [5] |
SELECT id,name,class_id,en_name FROM cms_area WHERE id=11 |
| [6] |
SELECT name FROM cms_areaclass WHERE id=11 |
| [7] |
SELECT cms_link.id AS lid,cms_link.name AS lname,cms_link.href AS lhref,cms_link.scription AS lscription FROM cms_link WHERE cms_link.link_id=1 ORDER BY cms_link.sort ASC,cms_link.id DESC |
| [8] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=1 |
| [9] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=5 |
| [10] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=3 |
| [11] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=5 |
| [12] |
SELECT id,name,en_name FROM cms_area WHERE class_id IN(10) AND isshow=1 ORDER BY sort ASC,id DESC LIMIT 100 |
| [13] |
SELECT id,parent,phone FROM cms_class |
| [14] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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(2,12,10,11) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,28 |
| [15] |
SELECT id,attachNew FROM cms_new WHERE id IN(79,78,77,52,37,110,106,103,97,96,76,75,74,73,72,71,63,61,60,59,58,57,54,53,43,41,40,39) |
| [16] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate,imgpath AS nimgpath FROM cms_n_sundry WHERE id IN(79,78,77,52,37,110,106,103,97,96,76,75,74,73,72,71,63,61,60,59,58,57,54,53,43,41,40,39) 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(79,78,77,52,37,110,106,103,97,96,76,75,74,73,72,71,63,61,60,59,58,57,54,53,43,41,40,39) AND class_type='1' |
| [18] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(10,12,11,2) |
| [19] |
SELECT id,parent,phone FROM cms_class |
| [20] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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(2,12,10,11) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,10 |
| [21] |
SELECT id FROM cms_new WHERE id IN(79,78,77,52,37,110,106,103,97,96) |
| [22] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate,imgpath AS nimgpath FROM cms_n_sundry WHERE id IN(79,78,77,52,37,110,106,103,97,96) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [23] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(79,78,77,52,37,110,106,103,97,96) AND class_type='1' |
| [24] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(10,2,12) |
| [25] |
SELECT id,parent,phone FROM cms_class |
| [26] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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(4) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,4 |
| [27] |
SELECT id,scription FROM cms_new WHERE id IN(23,22,21,20) |
| [28] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate,imgpath AS nimgpath FROM cms_n_sundry WHERE id IN(23,22,21,20) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [29] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(23,22,21,20) AND class_type='1' |
| [30] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(4) |
| [31] |
SELECT id,parent,phone FROM cms_class |
| [32] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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(5) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,3 |
| [33] |
SELECT id,scription FROM cms_new WHERE id IN(111,94,89) |
| [34] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM cms_n_sundry WHERE id IN(111,94,89) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [35] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(111,94,89) AND class_type='1' |
| [36] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(5) |
| [37] |
SELECT id,parent,phone FROM cms_class |
| [38] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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(3) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,1 |
| [39] |
SELECT id,scription FROM cms_new WHERE id IN(109) |
| [40] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate,imgpath AS nimgpath FROM cms_n_sundry WHERE id IN(109) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [41] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(109) AND class_type='1' |
| [42] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(3) |
| [43] |
SELECT id,parent,phone FROM cms_class |
| [44] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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(3) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 1,6 |
| [45] |
SELECT id FROM cms_new WHERE id IN(105,104,102,101,100,99) |
| [46] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM cms_n_sundry WHERE id IN(105,104,102,101,100,99) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [47] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(105,104,102,101,100,99) AND class_type='1' |
| [48] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(3) |
| [49] |
SELECT id,parent,phone FROM cms_class |
| [50] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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(5) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,1 |
| [51] |
SELECT id,scription FROM cms_new WHERE id IN(111) |
| [52] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate,imgpath AS nimgpath FROM cms_n_sundry WHERE id IN(111) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [53] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(111) AND class_type='1' |
| [54] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(5) |
| [55] |
SELECT id,parent,phone FROM cms_class |
| [56] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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(5) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 1,6 |
| [57] |
SELECT id FROM cms_new WHERE id IN(94,89,84,33,32,31) |
| [58] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM cms_n_sundry WHERE id IN(94,89,84,33,32,31) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [59] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(94,89,84,33,32,31) AND class_type='1' |
| [60] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(5) |
| [61] |
SELECT id,name FROM cms_tag ORDER BY sort ASC,number DESC LIMIT 0,100 |
| [62] |
SELECT id,name,en_name,href,parent,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 |
| [63] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=10 |
| [64] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=11 |
| [65] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=12 |
| [66] |
SELECT id,parent,phone FROM cms_class |
| [67] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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.sort ASC,cms_n_sundry.id DESC LIMIT 0,16 |
| [68] |
SELECT id FROM cms_new WHERE id IN(79,78,77,52,37,63,53,40,64,67,66,65,38) |
| [69] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM cms_n_sundry WHERE id IN(79,78,77,52,37,63,53,40,64,67,66,65,38) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [70] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(79,78,77,52,37,63,53,40,64,67,66,65,38) AND class_type='1' |
| [71] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(10) |
| [72] |
SELECT id,parent,phone FROM cms_class |
| [73] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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.sort ASC,cms_n_sundry.id DESC LIMIT 0,16 |
| [74] |
SELECT id FROM cms_new WHERE id IN(72,54,43,41,36,55,44) |
| [75] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM cms_n_sundry WHERE id IN(72,54,43,41,36,55,44) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [76] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(72,54,43,41,36,55,44) AND class_type='1' |
| [77] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(11) |
| [78] |
SELECT id,parent,phone FROM cms_class |
| [79] |
SELECT cms_n_sundry.id FROM cms_n_sundry FORCE INDEX(sundrywhere) 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(12) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,16 |
| [80] |
SELECT id FROM cms_new WHERE id IN(106,76,75,74,73,71,61,60,59,58,57,39) |
| [81] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM cms_n_sundry WHERE id IN(106,76,75,74,73,71,61,60,59,58,57,39) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [82] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(106,76,75,74,73,71,61,60,59,58,57,39) AND class_type='1' |
| [83] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(12) |