WINCC OPC VB开发通信方式 ,读取其中的变量和改变变量内容,根据变量名和分组名,服务器名字-WINCC OPC VB to develop means of communication, read them the contents of variables and changes in variables, grouped under the variable name and the name, server name
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001372s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.095273s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001364s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001947s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001249s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004304s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001104s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003310s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.017833s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001620s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 166165 [ RunTime:0.001358s ]