tocci是用C编写的建立在OCI基础之上的对ORACLE的接口进行调用,和OCCI操作类似,简化了OCI复杂的调用.在LINUX下使用.-C preparation is the establishment of the OCI on the basis of the Oracle interface calls, and similar operating with OCCI simplify complex OCI call. The use of Linux.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001393s ]
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.097532s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001364s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001940s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001378s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003706s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001238s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003493s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015367s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001610s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 263454 [ RunTime:0.001433s ]