火车头mysql入库_火车头采集器使用‘导入数据库’形式发布数据到帝国CMS数据库的过程（原创）适用于......

落日映苍穹つ 2022-10-28 12:28 229阅读 0赞

mysql> SELECT \* from mysql.general\_log ORDER BY event\_time DESC;

\+----------------------------+------------------------------+-----------+-----------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| 2018-10-11 13:45:14.338256 | root\[root\] @ localhost \[::1\] | 1344 | 1 | Query | SET GLOBAL general\_log = 'OFF' |

| 2018-10-11 13:45:09.951519 | root\[root\] @ localhost \[::1\] | 1653 | 1 | Quit | |

| 2018-10-11 13:45:09.949531 | root\[root\] @ localhost \[::1\] | 1653 | 1 | Query | select andauth from phome\_enewsuserloginck where userid='1' |

| 2018-10-11 13:45:09.948513 | root\[root\] @ localhost \[::1\] | 1653 | 1 | Query | select userid,groupid,classid,userprikey,uprnd from phome\_enewsuser where userid='1' and username='admin' and rnd='og7Q9XlQgP4v7l4Aq1mQ' and checked=0 limit 1 |

| 2018-10-11 13:45:09.947509 | root\[root\] @ localhost \[::1\] | 1653 | 1 | Init DB | empirecms |

| 2018-10-11 13:45:09.946506 | root\[root\] @ localhost \[::1\] | 1653 | 1 | Query | SET character\_set\_connection=utf8,character\_set\_results=utf8,character\_set\_client=binary,sql\_mode='' |

| 2018-10-11 13:45:09.945504 | \[root\] @ localhost \[::1\] | 1653 | 1 | Connect | root@localhost on using TCP/IP |

| 2018-10-11 13:45:09.888351 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Quit | |

| 2018-10-11 13:45:09.886346 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select sitename from phome\_enewsbefrom |

| 2018-10-11 13:45:09.885342 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select writer from phome\_enewswriter |

| 2018-10-11 13:45:09.884339 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select firsttitlename,isgoodname from phome\_enewspublic limit 1 |

| 2018-10-11 13:45:09.883337 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select typeid,tname from phome\_enewsinfotype where mid='1' order by myorder |

| 2018-10-11 13:45:09.883337 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select tempid,tempname from phome\_enewsnewstemp order by modid,tempid |

| 2018-10-11 13:45:09.883337 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select tempid,tempname from phome\_enewsvotetemp order by tempid |

| 2018-10-11 13:45:09.882334 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select definfovoteid from phome\_enewsclass where classid='2' |

| 2018-10-11 13:45:09.882334 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select ttids from phome\_enewsclassadd where classid='2' |

| 2018-10-11 13:45:09.880329 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select groupid,adminclass from phome\_enewsuser where userid='1' limit 1 |

| 2018-10-11 13:45:09.880329 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select doall,doselfinfo,doaddinfo,doeditinfo,dodelinfo,docheckinfo,dogoodinfo,dodocinfo,domoveinfo,domustcheck,docheckedit from phome\_enewsgroup where groupid='1' |

| 2018-10-11 13:45:09.880329 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select groupid,groupname from phome\_enewsmembergroup order by level |

| 2018-10-11 13:45:09.879326 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select userid,groupid,classid,userprikey,uprnd from phome\_enewsuser where userid='1' and username='admin' and rnd='og7Q9XlQgP4v7l4Aq1mQ' and checked=0 limit 1 |

| 2018-10-11 13:45:09.879326 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | select andauth from phome\_enewsuserloginck where userid='1' |

| 2018-10-11 13:45:09.878323 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Query | SET character\_set\_connection=utf8,character\_set\_results=utf8,character\_set\_client=binary,sql\_mode='' |

| 2018-10-11 13:45:09.878323 | root\[root\] @ localhost \[::1\] | 1652 | 1 | Init DB | empirecms |

| 2018-10-11 13:45:09.877320 | \[root\] @ localhost \[::1\] | 1652 | 1 | Connect | root@localhost on using TCP/IP |

| 2018-10-11 13:45:07.798427 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Quit | |

| 2018-10-11 13:45:07.796423 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | insert into phome\_enewsdolog(username,logip,logtime,enews,doing,pubid,ipport) values('admin','::1','2018-10-11 13:45:07','AddNews','classid=2  
id=2  
title=title','1000010000000002','63863') |

| 2018-10-11 13:45:07.794417 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select id,classid,ttid,onclick,plnum,totaldown,newspath,filename,userid,username,firsttitle,isgood,ispic,istop,isqf,ismember,isurl,truetime,lastdotime,havehtml,groupid,userfen,titlefont,titleurl,stb,fstb,restb,keyboard,title,ftitle,newstime,titlepic,smalltext,diggtop from phome\_ecms\_news where isgood>0 and ispic=1 order by newstime desc limit 4 |

| 2018-10-11 13:45:07.793414 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select tempid,modid,temptext,showdate,listvar,subnews,rownum,docode from phome\_enewsbqtemp where tempid='12' |

| 2018-10-11 13:45:07.793414 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select classid,classname,islast,sonclass,tbname,intro,classimg,infos from phome\_enewsclass where bclassid='0' and showclass=0 order by myorder,classid |

| 2018-10-11 13:45:07.790407 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select bq,funname from phome\_enewsbq where isclose=0 order by bqid |

| 2018-10-11 13:45:07.789403 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select temptext,showdate from phome\_enewsnewstemp where tempid='1' limit 1 |

| 2018-10-11 13:45:07.789403 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select myvar,varvalue from phome\_enewstempvar where isclose=0 order by myorder desc,varid |

| 2018-10-11 13:45:07.788401 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select ttid,onclick,plnum,totaldown,newspath,filename,userid,username,firsttitle,isgood,ispic,istop,isqf,ismember,isurl,truetime,lastdotime,havehtml,groupid,userfen,titlefont,titleurl,stb,fstb,restb,keyboard,title,titlepic,newstime,ftitle,smalltext,diggtop from phome\_ecms\_news where id='2' limit 1 |

| 2018-10-11 13:45:07.788401 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select keyid,dokey,newstempid,closepl,infotags,writer,befrom,newstext from phome\_ecms\_news\_data\_1 where id='2' limit 1 |

| 2018-10-11 13:45:07.787398 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | update phome\_enewspublic\_update set lastnuminfo=lastnuminfo+1,lastnuminfotb='|1,38|',todaynuminfo=todaynuminfo+1 limit 1 |

| 2018-10-11 13:45:07.787398 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | update phome\_enewsfile\_1 set pubid='1000010000000002',classid='2',id='2',cjid=0 where cjid='1539236638' |

| 2018-10-11 13:45:07.787398 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | update phome\_ecms\_news set filename='2',titleurl='/youhua/seo/2018-10-11/2.html' where id='2' |

| 2018-10-11 13:45:07.787398 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select count(\*) as total from phome\_enewsinfovote where pubid='1000010000000002' limit 1 |

| 2018-10-11 13:45:07.786395 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | update phome\_enewsclass set allinfos=allinfos+1,infos=infos+1 where classid='2' limit 1 |

| 2018-10-11 13:45:07.786395 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select lasttimeinfo,lastnuminfotb,todaytimeinfo,todaytimepl,todaynuminfo,todaynumpl from phome\_enewspublic\_update limit 1 |

| 2018-10-11 13:45:07.785392 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | insert into phome\_ecms\_news(id,classid,ttid,onclick,plnum,totaldown,newspath,filename,userid,username,firsttitle,isgood,ispic,istop,isqf,ismember,isurl,truetime,lastdotime,havehtml,groupid,userfen,titlefont,titleurl,stb,fstb,restb,keyboard,title,ftitle,newstime,titlepic,smalltext) values('2','2','0','0',0,'0','2018-10-11','','1','admin','0','0','0','0','0',0,'0','1539236707','1539236707','1','0','0','','','1','1','1','keyword','title','fubiao','1539236638','','content desc') |

| 2018-10-11 13:45:07.785392 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | insert into phome\_ecms\_news\_data\_1(id,classid,keyid,dokey,newstempid,closepl,haveaddfen,infotags,writer,befrom,newstext) values('2','2','','1','0','0',0,'','','','

content content content content content content content content content content content content

') |

| 2018-10-11 13:45:07.784391 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | insert into phome\_ecms\_news\_index(classid,checked,newstime,truetime,lastdotime,havehtml) values('2','1','1539236638','1539236707','1539236707','1') |

| 2018-10-11 13:45:07.783387 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select sonclass from phome\_enewsmod where mid='1' |

| 2018-10-11 13:45:07.783387 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select id from phome\_ecms\_news where (title like '%keyword%') and (classid in (2)) and id<>0 order by newstime desc limit 10 |

| 2018-10-11 13:45:07.781381 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select groupid,adminclass from phome\_enewsuser where userid='1' limit 1 |

| 2018-10-11 13:45:07.781381 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select doall,doselfinfo,doaddinfo,doeditinfo,dodelinfo,docheckinfo,dogoodinfo,dodocinfo,domoveinfo,domustcheck,docheckedit from phome\_enewsgroup where groupid='1' |

| 2018-10-11 13:45:07.781381 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select classid,modid,listdt,haddlist,sametitle,addreinfo,wburl,repreinfo from phome\_enewsclass where classid='2' and islast=1 limit 1 |

| 2018-10-11 13:45:07.773361 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select userid,groupid,classid,userprikey,uprnd from phome\_enewsuser where userid='1' and username='admin' and rnd='og7Q9XlQgP4v7l4Aq1mQ' and checked=0 limit 1 |

| 2018-10-11 13:45:07.773361 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | select andauth from phome\_enewsuserloginck where userid='1' |

| 2018-10-11 13:45:07.772358 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Query | SET character\_set\_connection=utf8,character\_set\_results=utf8,character\_set\_client=binary,sql\_mode='' |

| 2018-10-11 13:45:07.772358 | root\[root\] @ localhost \[::1\] | 1651 | 1 | Init DB | empirecms |

| 2018-10-11 13:45:07.768348 | \[root\] @ localhost \[::1\] | 1651 | 1 | Connect | root@localhost on using TCP/IP