Чистка неактивных.
Время выполнения крона: 5.8644890785217
Запросов к базе: 2+10=12
Запросы:
| connect | 0.00013279914855957 |
| SELECT `cronid` FROM `cron` WHERE `nextrun`<'1283909305' AND `active`='1' AND `block`='0' | 0.00051212310791016 |
| SELECT GET_LOCK('cron',1) AS `lock` | 4.9114227294922E-5 |
| SELECT `cronid`,`filename`,`day`,`hour`,`minute`,`weekday`,`name`,`log` FROM `cron` WHERE `nextrun`<'1283909305' AND `active`='1' | 0.00017714500427246 |
| UPDATE `cron` SET `block`='1' WHERE `cronid`='23' | 0.00095486640930176 |
| SELECT * FROM `users` WHERE `lastactivity`<'1276133305' AND `joindate`<'1276133305' AND `userid`>13 AND `usergroupid` NOT IN ('1', | 0.12566018104553 |
| DELETE FROM `transaction` WHERE `money`<'1.5' AND `date`<'1278725306' | 3.1111397743225 |
| DELETE FROM `transaction` WHERE `money`<'0.3' AND `date`<'1281317306' | 2.4953269958496 |
| DELETE FROM `paymailses` WHERE `datestart`<'1283304511' | 0.13103914260864 |
| DELETE FROM `achat` WHERE `date`<'1283304511' | 0.00018000602722168 |
| DELETE FROM `pm` WHERE `date`<'1276133311' | 6.3896179199219E-5 |
| UPDATE `cron` SET `nextrun`='1283909340',`block`='0' WHERE `cronid`='23' | 0.00057482719421387 |