underQL
It is a light-weight PHP script (One source file) that will help you to write your own PHP applications that in need to manipulate data that are stored in MySQL databases. However, you can write your queries in one line and fetch data in a simple manner. That"s it.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002085s ]
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.086332s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002585s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002106s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002096s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003602s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001841s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003301s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014516s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002274s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 101199 [ RunTime:0.001074s ]