[1] |
SELECT en_name,id,modeltype FROM cms_class WHERE en_name='about' |
[2] |
SELECT en_name,id FROM cms_area WHERE en_name='gansu' |
[3] |
SELECT id,name,class_id,en_name FROM cms_area WHERE id=8 |
[4] |
SELECT name FROM cms_areaclass WHERE id=8 |
[5] |
SELECT * FROM cms_class WHERE id=1 |
[6] |
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 |
[7] |
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 |
[8] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=10 |
[9] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=11 |
[10] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id=12 |
[11] |
SELECT id,parent,phone FROM cms_class |
[12] |
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 |
[13] |
SELECT id FROM cms_new WHERE id IN(52,37,79,78,77,63,53,40,64,67,66,65,38) |
[14] |
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 |
[15] |
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' |
[16] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(10) |
[17] |
SELECT id,parent,phone FROM cms_class |
[18] |
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 |
[19] |
SELECT id FROM cms_new WHERE id IN(72,54,43,41,36,55,44) |
[20] |
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 |
[21] |
SELECT sundry_id,class_id FROM cms_c_n WHERE sundry_id IN(72,54,43,41,36,55,44) AND class_type='1' |
[22] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(11) |
[23] |
SELECT id,parent,phone FROM cms_class |
[24] |
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 |
[25] |
SELECT id FROM cms_new WHERE id IN(76,75,74,73,71,61,60,59,58,57,39) |
[26] |
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 |
[27] |
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' |
[28] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM cms_class WHERE id IN(12) |
[29] |
SELECT id,name,en_name FROM cms_area WHERE class_id IN(10) AND isshow=1 ORDER BY sort ASC,id DESC LIMIT 100 |