| ID |
SQL命令 |
| [1] |
SELECT en_name,id,modeltype FROM cms_class WHERE en_name='yt' |
| [2] |
SELECT id,name,class_id,en_name FROM cms_area WHERE id=25 |
| [3] |
SELECT name FROM cms_areaclass WHERE id=25 |
| [4] |
SELECT class_id FROM cms_c_n WHERE class_id=12 AND sundry_id=61 AND class_type='1' |
| [5] |
SELECT id,`title` FROM cms_n_sundry WHERE id=61 |
| [6] |
SELECT id,`key`,`scription`,`seo_title` FROM cms_new WHERE id=61 |
| [7] |
SELECT * FROM cms_class WHERE id=12 |
| [8] |
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=61 AND cms_c_n.class_type='1' |
| [9] |
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 FORCE INDEX(sundrywhere) 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=12 AND cms_n_sundry.id>61 ORDER BY cms_n_sundry.id ASC LIMIT 1 |
| [10] |
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 FORCE INDEX(sundrywhere) 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=12 AND cms_n_sundry.id<61 ORDER BY cms_n_sundry.id DESC LIMIT 1 |
| [11] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE isshow="1" ORDER BY sort ASC,id ASC |
| [12] |
SELECT cms_n_sundry.id,title,text,addtime,attachNew FROM cms_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN cms_new ON cms_n_sundry.id=cms_new.id WHERE verify='2' AND cms_new.id=61 |
| [13] |
SELECT name,href,rate,opennew,isapply,number FROM cms_key WHERE isapply="1" ORDER BY rate DESC |
| [14] |
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=61 |
| [15] |
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=61 |
| [16] |
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 (title LIKE '%通风网%') AND class_type='1' AND timing='1' AND cms_c_n.class_id IN(2) AND imgpath<>'' ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC LIMIT 0,10 |
| [17] |
SELECT id,title,path FROM cms_shopimg WHERE shopclass_id IN(1) AND sundry_id IN(61) ORDER BY sort ASC LIMIT 0,10 |
| [18] |
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 |
| [19] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=10 |
| [20] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=11 |
| [21] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=12 |
| [22] |
SELECT id,parent,phone FROM cms_class |
| [23] |
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 |
| [24] |
SELECT id FROM cms_new WHERE id IN(52,37,79,78,77,63,53,40,64,67,66,65,38) |
| [25] |
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(52,37,79,78,77,63,53,40,64,67,66,65,38) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [26] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(52,37,79,78,77,63,53,40,64,67,66,65,38) AND class_type='1' |
| [27] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(10) |
| [28] |
SELECT id,parent,phone FROM cms_class |
| [29] |
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 |
| [30] |
SELECT id FROM cms_new WHERE id IN(72,54,43,41,36,55,44) |
| [31] |
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 |
| [32] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(72,54,43,41,36,55,44) AND class_type='1' |
| [33] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(11) |
| [34] |
SELECT id,parent,phone FROM cms_class |
| [35] |
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 |
| [36] |
SELECT id FROM cms_new WHERE id IN(76,75,74,73,71,61,60,59,58,57,39) |
| [37] |
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(76,75,74,73,71,61,60,59,58,57,39) ORDER BY cms_n_sundry.sort ASC,cms_n_sundry.id DESC |
| [38] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(76,75,74,73,71,61,60,59,58,57,39) AND class_type='1' |
| [39] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(12) |
| [40] |
SELECT id,name,en_name FROM cms_area WHERE class_id IN(10) AND isshow=1 ORDER BY sort ASC,id DESC LIMIT 100 |
