程序首先创建生产者,然后创建消费者,他们从共享数据结构存取数据,使用互斥信号量,可以有效保护共享数据。-Process begins to create producers, consumers and then create them from the shared data structure to access data, the use of mutex semaphores, shared data can be effectively protected.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.007826s ]
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.157945s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001357s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001925s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001535s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005682s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001430s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006922s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.028129s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001755s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 185804 [ RunTime:0.015773s ]