Ежеминутное
Время выполнения крона: 0.40430998802185
Запросов к базе: 4+13=17
Запросы:
SELECT `var`,`val` FROM `config`0.00011610984802246
SELECT `cronid` FROM `cron` WHERE `nextrun`<'1519302416' AND `active`='1' AND `block`='0'0.00020790100097656
SELECT GET_LOCK('cron',1) AS `lock`0.00010800361633301
SELECT `cronid`,`filename`,`day`,`hour`,`minute`,`weekday`,`name`,`log` FROM `cron` WHERE `nextrun`<'1519302416' AND `active`='1' 0.00018596649169922
UPDATE `cron` SET `block`='1' WHERE `cronid`='1'0.00038790702819824
SELECT count(*) FROM `users` WHERE `lastactivity`>'1519301816'0.00012302398681641
SELECT count(`oid`) FROM `online` WHERE `date`>'1519301816'0.00015783309936523
SELECT count(*) AS c FROM `users` WHERE `lastactivity`>='1519246800'0.00020980834960938
SELECT count(*) AS c FROM `users` WHERE `joindate`>='1519246800'0.00020003318786621
SELECT count(*) FROM `users`0.00017595291137695
UPDATE `stat` SET `nowactive`='2',`todayactive`='1',`todayreg`='1',`countuser`='115821' WHERE 1=10.00047206878662109
SELECT `wmid`,`summ` FROM `subscribesumm` WHERE `sost`='0' AND `summ`<='51.52'0.00043606758117676
UPDATE `subscribesumm` SET `sost`='1',`dateend`='1519302416' WHERE `sost`='0' AND `summ`<='51.52'0.00037717819213867
DELETE FROM `online` WHERE `date`<'1503750416' LIMIT 100.00051522254943848
SELECT `wmd`,`datezay`,`inv`,`wmtrainid`,`creditid`,`pcode`,`day`,`resell`,`pribil`,`summ`,`mainurl`,r.wmz FROM `credit` AS `c`0.015608072280884
UPDATE `cron` SET `nextrun`='1519302420',`block`='0' WHERE `cronid`='1'0.00032901763916016
15:26:56