127.0.0.1.37968 > server: ACK

127.0.0.1.37968 > server: Handshake (new auth)

server > 127.0.0.1.37968: ACK

server > 127.0.0.1.37968: OK

127.0.0.1.37968 > server: COM_INIT_DB: webdb

server > 127.0.0.1.37968: OK

127.0.0.1.37968 > server: COM_QUERY: SET NAMES ‘gbk’

server > 127.0.0.1.37968: OK

127.0.0.1.37968 > server: COM_QUERY: SET sql_mode=”

server > 127.0.0.1.37968: OK

127.0.0.1.37968 > server: COM_QUERY: SELECT cpmdeduction,cpcdeduction,cpadeduction,cpsdeduction,cpvdeduction,cpczlink,cpazlink,cpszlink FROM zyads_users

WHERE uid=770 AND status=2 limit 0,1

server > 127.0.0.1.37968: 8 Fields

Field: webdb.zyads_users.cpmdeduction

Field: webdb.zyads_users.cpcdeduction

Field: webdb.zyads_users.cpadeduction

Field: webdb.zyads_users.cpsdeduction

Field: webdb.zyads_users.cpvdeduction

Field: webdb.zyads_users.cpczlink

Field: webdb.zyads_users.cpazlink

Field: webdb.zyads_users.cpszlink

End

|| 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 ||

End

127.0.0.1.37968 > server: COM_QUERY: SELECT a.adsid,a.url,a.status,adstype,p.planid,p.deduction,p.plantype,p.price,p.priceadv,p.uid,p.expire,p.clearing,p.budget,u.money As advmoney,u.uid AS advuid FROM zyads_ads AS a ,zyads_plan As p ,zyads_users As u

WHERE a.adsid=26 AND a.planid=p.planid AND p.uid=u.uid AND p.status = 1 AND a.status = 3 AND u.status=2 limit 0,1

server > 127.0.0.1.37968: 15 Fields

Field: webdb.a.adsid

Field: webdb.a.url