| ID |
SQL命令 |
| [1] |
SELECT id,name,class_id,en_name FROM tg_area WHERE id=8 |
| [2] |
SELECT name FROM tg_areaclass WHERE id=8 |
| [3] |
SELECT class_id FROM tg_c_n WHERE class_id=3 AND sundry_id=231 AND class_type='1' |
| [4] |
SELECT id,`title` FROM tg_n_sundry WHERE id=231 |
| [5] |
SELECT id,`key`,`scription`,`seo_title` FROM tg_new WHERE id=231 |
| [6] |
SELECT * FROM tg_class WHERE id=3 |
| [7] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE isshow="1" ORDER BY sort ASC,id ASC |
| [8] |
SELECT tg_class.id,en_name,classpath,newpath,href,ISHTML,weight FROM tg_c_n LEFT JOIN tg_class ON tg_class.id=tg_c_n.class_id WHERE tg_c_n.sundry_id=231 AND tg_c_n.class_type='1' |
| [9] |
SELECT tg_n_sundry.id AS nid,title AS ntitle,style AS nstyle,en_path AS nen_path,addtime AS naddtime FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_c_n ON tg_n_sundry.id=tg_c_n.sundry_id WHERE verify='2' AND recycle='1' AND timing='1' AND tg_c_n.class_id=3 AND tg_n_sundry.id>231 ORDER BY tg_n_sundry.id ASC LIMIT 1 |
| [10] |
SELECT tg_n_sundry.id AS nid,title AS ntitle,style AS nstyle,en_path AS nen_path,addtime AS naddtime FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_c_n ON tg_n_sundry.id=tg_c_n.sundry_id WHERE verify='2' AND recycle='1' AND timing='1' AND tg_c_n.class_id=3 AND tg_n_sundry.id<231 ORDER BY tg_n_sundry.id DESC LIMIT 1 |
| [11] |
SELECT tg_n_sundry.id,title,text,addtime,author FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_new ON tg_n_sundry.id=tg_new.id WHERE verify='2' AND tg_new.id=231 |
| [12] |
SELECT name,href,rate,opennew,isapply,number FROM tg_key WHERE isapply="1" ORDER BY rate DESC |
| [13] |
SELECT tg_n_sundry.id,title,text,addtime FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_new ON tg_n_sundry.id=tg_new.id WHERE verify='2' AND tg_new.id=231 |
| [14] |
SELECT name,href,rate,opennew,isapply,number FROM tg_key WHERE isapply="1" ORDER BY rate DESC |
| [15] |
SELECT title,resemble,`key` AS nkey FROM tg_n_sundry LEFT JOIN tg_new ON tg_n_sundry.id=tg_new.id WHERE tg_n_sundry.id=231 |
| [16] |
SELECT tg_n_sundry.id,class_id FROM tg_n_sundry LEFT JOIN tg_c_n ON tg_n_sundry.id=tg_c_n.sundry_id WHERE verify='2' AND recycle='1' AND tg_n_sundry.id IN(172,446,104,19,268,476,518,398,277,190) AND class_type='1' AND timing='1' AND tg_c_n.class_id IN(2,3,4,9,10,11) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC LIMIT 0,20 |
| [17] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM tg_n_sundry WHERE id IN(518,476,446,398,277,268,190,172,104,19) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC |
| [18] |
SELECT id FROM tg_new WHERE id IN(518,476,446,398,277,268,190,172,104,19) |
| [19] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE isshow="1" ORDER BY sort ASC,id ASC |
| [20] |
SELECT id,parent,phone FROM tg_class |
| [21] |
SELECT id,name FROM tg_class WHERE id in(2,3,4,9,10,11,15,16) |
| [22] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath FROM tg_class WHERE isshow="1" AND parent=0 AND phone IN('2','1') ORDER BY sort ASC,id DESC |
| [23] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id=8 |
| [24] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id=9 |
| [25] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id=10 |
| [26] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id=11 |
| [27] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id=16 |
| [28] |
SELECT id,parent,phone FROM tg_class |
| [29] |
SELECT tg_n_sundry.id FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_c_n ON tg_n_sundry.id=tg_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND class_id IN(9) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC LIMIT 0,15 |
| [30] |
SELECT id FROM tg_new WHERE id IN(2,51,1,178,55,4,3,438,217,207,5,385,295,248,62) |
| [31] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM tg_n_sundry WHERE id IN(2,51,1,178,55,4,3,438,217,207,5,385,295,248,62) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC |
| [32] |
SELECT sundry_id,class_id FROM tg_c_n WHERE sundry_id IN(2,51,1,178,55,4,3,438,217,207,5,385,295,248,62) AND class_type='1' |
| [33] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id IN(9) |
| [34] |
SELECT id,parent,phone FROM tg_class |
| [35] |
SELECT tg_n_sundry.id FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_c_n ON tg_n_sundry.id=tg_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND class_id IN(9) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC LIMIT 15,4 |
| [36] |
SELECT id FROM tg_new WHERE id IN(125,6,7) |
| [37] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM tg_n_sundry WHERE id IN(125,6,7) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC |
| [38] |
SELECT sundry_id,class_id FROM tg_c_n WHERE sundry_id IN(125,6,7) AND class_type='1' |
| [39] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id IN(9) |
| [40] |
SELECT id,parent,phone FROM tg_class |
| [41] |
SELECT tg_n_sundry.id FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_c_n ON tg_n_sundry.id=tg_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND class_id IN(10) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC LIMIT 0,30 |
| [42] |
SELECT id FROM tg_new WHERE id IN(8,215,494,12,11,10,9) |
| [43] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM tg_n_sundry WHERE id IN(8,215,494,12,11,10,9) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC |
| [44] |
SELECT sundry_id,class_id FROM tg_c_n WHERE sundry_id IN(8,215,494,12,11,10,9) AND class_type='1' |
| [45] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id IN(10) |
| [46] |
SELECT id,parent,phone FROM tg_class |
| [47] |
SELECT tg_n_sundry.id FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_c_n ON tg_n_sundry.id=tg_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND class_id IN(11) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC LIMIT 0,30 |
| [48] |
SELECT id FROM tg_new WHERE id IN(16,15,14,13) |
| [49] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM tg_n_sundry WHERE id IN(16,15,14,13) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC |
| [50] |
SELECT sundry_id,class_id FROM tg_c_n WHERE sundry_id IN(16,15,14,13) AND class_type='1' |
| [51] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id IN(11) |
| [52] |
SELECT tg_n_sundry.id FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_c_n ON tg_n_sundry.id=tg_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND tg_n_sundry.id IN(56) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC |
| [53] |
SELECT id FROM tg_new WHERE id IN(56) |
| [54] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM tg_n_sundry WHERE id IN(56) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC |
| [55] |
SELECT sundry_id,class_id FROM tg_c_n WHERE sundry_id IN(56) AND class_type='1' |
| [56] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id IN(2) |
| [57] |
SELECT tg_n_sundry.id FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_c_n ON tg_n_sundry.id=tg_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND tg_n_sundry.id IN(17) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC |
| [58] |
SELECT id FROM tg_new WHERE id IN(17) |
| [59] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM tg_n_sundry WHERE id IN(17) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC |
| [60] |
SELECT sundry_id,class_id FROM tg_c_n WHERE sundry_id IN(17) AND class_type='1' |
| [61] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id IN(2) |
| [62] |
SELECT id,parent,phone FROM tg_class |
| [63] |
SELECT tg_n_sundry.id FROM tg_n_sundry FORCE INDEX(sundrywhere) LEFT JOIN tg_c_n ON tg_n_sundry.id=tg_c_n.sundry_id WHERE verify='2' AND timing='1' AND recycle='1' AND class_id IN(16) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC LIMIT 0,30 |
| [64] |
SELECT id FROM tg_new WHERE id IN(687,670,549,501,498,454,453,339,335,185) |
| [65] |
SELECT id,id AS nid,title AS ntitle,en_path AS nen_path,addtime AS naddtime,state AS nstate FROM tg_n_sundry WHERE id IN(687,670,549,501,498,454,453,339,335,185) ORDER BY tg_n_sundry.sort ASC,tg_n_sundry.id DESC |
| [66] |
SELECT sundry_id,class_id FROM tg_c_n WHERE sundry_id IN(687,670,549,501,498,454,453,339,335,185) AND class_type='1' |
| [67] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath,newpath FROM tg_class WHERE id IN(16) |
| [68] |
SELECT tg_link.id AS lid,tg_link.name AS lname,tg_link.href AS lhref,tg_link.scription AS lscription FROM tg_link WHERE tg_link.link_id=2 ORDER BY tg_link.sort ASC,tg_link.id DESC |
| [69] |
SELECT id,name,en_name,href,parent,ISHTML,classpath,weight,modeltype,listpath FROM tg_class WHERE isshow="1" AND parent=0 AND phone IN('2','1') ORDER BY sort ASC,id DESC |
| [70] |
SELECT id,name,en_name FROM tg_area WHERE isshow=1 ORDER BY sort ASC,id DESC LIMIT 27 |
扫一扫 加微信报价
