这是VFP的指导思想书籍,主要说明了开发软件时怎么样才做到界面与数据分离,从而在日后的维护中带来便利-This is the guiding ideology of books, mainly, the development of the software how to achieve just like interface and data separation, in order to safeguard the future brings convenience
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002201s ]
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.116095s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000849s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001226s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001207s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003227s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000960s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004993s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016776s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001219s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 322129 [ RunTime:0.015905s ]