Ежеминутное
Время выполнения крона: 7.4089410305023
Запросов к базе: 4+13=17
Запросы:
SELECT `var`,`val` FROM `config`0.00018811225891113
SELECT `cronid` FROM `cron` WHERE `nextrun`<'1534795869' AND `active`='1' AND `block`='0'0.00049805641174316
SELECT GET_LOCK('cron',1) AS `lock`0.00015115737915039
SELECT `cronid`,`filename`,`day`,`hour`,`minute`,`weekday`,`name`,`log` FROM `cron` WHERE `nextrun`<'1534795869' AND `active`='1' 0.00030303001403809
UPDATE `cron` SET `block`='1' WHERE `cronid`='1'0.00063991546630859
SELECT count(*) FROM `users` WHERE `lastactivity`>'1534795269'0.0002591609954834
SELECT count(`oid`) FROM `online` WHERE `date`>'1534795269'0.00028777122497559
SELECT count(*) AS c FROM `users` WHERE `lastactivity`>='1534712400'9.2983245849609E-5
SELECT count(*) AS c FROM `users` WHERE `joindate`>='1534712400'0.00016283988952637
SELECT count(*) FROM `users`0.00013089179992676
UPDATE `stat` SET `nowactive`='3',`todayactive`='0',`todayreg`='0',`countuser`='115989' WHERE 1=10.00026917457580566
SELECT `wmid`,`summ` FROM `subscribesumm` WHERE `sost`='0' AND `summ`<='58.33'0.00091981887817383
UPDATE `subscribesumm` SET `sost`='1',`dateend`='1534795876' WHERE `sost`='0' AND `summ`<='58.33'0.00037312507629395
DELETE FROM `online` WHERE `date`<'1519243869' LIMIT 100.00090599060058594
SELECT `wmd`,`datezay`,`inv`,`wmtrainid`,`creditid`,`pcode`,`day`,`resell`,`pribil`,`summ`,`mainurl`,r.wmz FROM `credit` AS `c`0.015161037445068
UPDATE `cron` SET `nextrun`='1534795920',`block`='0' WHERE `cronid`='1'0.00028705596923828
23:11:16