A standalone, user-friendly, powerful, and secure utility for managing any database given the appropriate permissions. This is especially useful when phpMyAdmin is too cumbersome or cPanel gets in the way of managing databases across multiple accounts.
sqlMin is a product of Borja Webs, The Thomas Edison of Advanced Web Development Services.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001690s ]
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.096709s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001433s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001633s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001241s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004419s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001105s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004709s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.017717s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001341s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 100610 [ RunTime:0.014037s ]
