INSERT INTO `log` (`equipment_id`, `datetime`, `state`)
VALUES (:eqId, NOW(), :state)
INSERT INTO `statistics` (`equipment_id`, `last_on`)
VALUES (:eqId, NOW(), 0)
ON DUPLICATE KEY UPDATE `last_on` = NOW()
UPDATE `statistics`
SET `total_time` = `total_time` + TIMESTAMPDIFF(SECOND, `last_on`, NOW()),
`last_on` = NULL
WHERE `equipment_id` = :eqId
php -v
Subject: =?UTF-8?B?0KLQtdC80LAg0L/QuNGB0YzQvNCw?=
Subject: =?UTF-8?Q?=D0=A2=D0=B5=D0=BC=D0=B0=20=D0=BF=D0=B8=D1=81=D1=8C?=
=?UTF-8?Q?=D0=BC=D0=B0?=