在工程交通行业如测绘部门经常用到角度单位的转换,度分秒到度到弧度的转换,而且本代码可以实现批量的转换。-Industries such as traffic engineering departments often use the perspective of mapping units conversion, minutes and seconds to degrees conversion degrees to radians, and the bulk of the code conversion can be achieved.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001114s ]
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.084420s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001082s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002066s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001111s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003631s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000937s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003200s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014371s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001187s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 284423 [ RunTime:0.001379s ]