leeos is an embedded OS holds full features as unix-like OSs,it is small and fast enough ,suitable for RISC CPUs.
this project is example codes that come from leeos,with little feature but show you what is inside the OS,how does it work.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001211s ]
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.155627s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001053s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001162s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001042s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003762s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000829s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004426s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.028341s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001094s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 292221 [ RunTime:0.359499s ]
