[2020-10-13 00:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602518657' WHERE PBXPid=1 [2020-10-13 00:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602518647 [2020-10-13 00:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602518657,`PBXCuid`=1602518657 [2020-10-13 00:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602518957' WHERE PBXPid=1 [2020-10-13 00:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602518947 [2020-10-13 00:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602518957,`PBXCuid`=1602518957 [2020-10-13 00:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602519257' WHERE PBXPid=1 [2020-10-13 00:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602519247 [2020-10-13 00:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602519257,`PBXCuid`=1602519257 [2020-10-13 00:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602519557' WHERE PBXPid=1 [2020-10-13 00:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602519547 [2020-10-13 00:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602519557,`PBXCuid`=1602519557 [2020-10-13 00:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602519857' WHERE PBXPid=1 [2020-10-13 00:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602519847 [2020-10-13 00:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602519857,`PBXCuid`=1602519857 [2020-10-13 00:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602520157' WHERE PBXPid=1 [2020-10-13 00:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602520147 [2020-10-13 00:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602520157,`PBXCuid`=1602520157 [2020-10-13 00:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602520457' WHERE PBXPid=1 [2020-10-13 00:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602520447 [2020-10-13 00:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602520457,`PBXCuid`=1602520457 [2020-10-13 00:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602520757' WHERE PBXPid=1 [2020-10-13 00:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602520747 [2020-10-13 00:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602520757,`PBXCuid`=1602520757 [2020-10-13 00:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602521057' WHERE PBXPid=1 [2020-10-13 00:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602521047 [2020-10-13 00:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602521057,`PBXCuid`=1602521057 [2020-10-13 00:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602521357' WHERE PBXPid=1 [2020-10-13 00:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602521347 [2020-10-13 00:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602521357,`PBXCuid`=1602521357 [2020-10-13 00:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602521657' WHERE PBXPid=1 [2020-10-13 00:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602521647 [2020-10-13 00:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602521657,`PBXCuid`=1602521657 [2020-10-13 00:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602521957' WHERE PBXPid=1 [2020-10-13 00:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602521947 [2020-10-13 00:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602521957,`PBXCuid`=1602521957 [2020-10-13 01:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602522257' WHERE PBXPid=1 [2020-10-13 01:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602522247 [2020-10-13 01:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602522257,`PBXCuid`=1602522257 [2020-10-13 01:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602522557' WHERE PBXPid=1 [2020-10-13 01:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602522547 [2020-10-13 01:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602522557,`PBXCuid`=1602522557 [2020-10-13 01:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602522857' WHERE PBXPid=1 [2020-10-13 01:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602522847 [2020-10-13 01:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602522857,`PBXCuid`=1602522857 [2020-10-13 01:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602523157' WHERE PBXPid=1 [2020-10-13 01:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602523147 [2020-10-13 01:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602523157,`PBXCuid`=1602523157 [2020-10-13 01:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602523457' WHERE PBXPid=1 [2020-10-13 01:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602523447 [2020-10-13 01:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602523457,`PBXCuid`=1602523457 [2020-10-13 01:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602523757' WHERE PBXPid=1 [2020-10-13 01:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602523747 [2020-10-13 01:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602523757,`PBXCuid`=1602523757 [2020-10-13 01:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602524057' WHERE PBXPid=1 [2020-10-13 01:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602524047 [2020-10-13 01:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602524057,`PBXCuid`=1602524057 [2020-10-13 01:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602524357' WHERE PBXPid=1 [2020-10-13 01:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602524347 [2020-10-13 01:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602524357,`PBXCuid`=1602524357 [2020-10-13 01:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602524657' WHERE PBXPid=1 [2020-10-13 01:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602524647 [2020-10-13 01:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602524657,`PBXCuid`=1602524657 [2020-10-13 01:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602524957' WHERE PBXPid=1 [2020-10-13 01:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602524947 [2020-10-13 01:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602524957,`PBXCuid`=1602524957 [2020-10-13 01:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602525257' WHERE PBXPid=1 [2020-10-13 01:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602525247 [2020-10-13 01:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602525257,`PBXCuid`=1602525257 [2020-10-13 01:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602525557' WHERE PBXPid=1 [2020-10-13 01:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602525547 [2020-10-13 01:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602525557,`PBXCuid`=1602525557 [2020-10-13 02:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602525857' WHERE PBXPid=1 [2020-10-13 02:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602525847 [2020-10-13 02:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602525857,`PBXCuid`=1602525857 [2020-10-13 02:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602526157' WHERE PBXPid=1 [2020-10-13 02:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602526147 [2020-10-13 02:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602526157,`PBXCuid`=1602526157 [2020-10-13 02:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602526457' WHERE PBXPid=1 [2020-10-13 02:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602526447 [2020-10-13 02:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602526457,`PBXCuid`=1602526457 [2020-10-13 02:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602526757' WHERE PBXPid=1 [2020-10-13 02:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602526747 [2020-10-13 02:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602526757,`PBXCuid`=1602526757 [2020-10-13 02:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602527057' WHERE PBXPid=1 [2020-10-13 02:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602527047 [2020-10-13 02:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602527057,`PBXCuid`=1602527057 [2020-10-13 02:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602527357' WHERE PBXPid=1 [2020-10-13 02:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602527347 [2020-10-13 02:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602527357,`PBXCuid`=1602527357 [2020-10-13 02:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602527657' WHERE PBXPid=1 [2020-10-13 02:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602527647 [2020-10-13 02:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602527657,`PBXCuid`=1602527657 [2020-10-13 02:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602527957' WHERE PBXPid=1 [2020-10-13 02:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602527947 [2020-10-13 02:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602527957,`PBXCuid`=1602527957 [2020-10-13 02:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602528257' WHERE PBXPid=1 [2020-10-13 02:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602528247 [2020-10-13 02:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602528257,`PBXCuid`=1602528257 [2020-10-13 02:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602528557' WHERE PBXPid=1 [2020-10-13 02:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602528547 [2020-10-13 02:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602528557,`PBXCuid`=1602528557 [2020-10-13 02:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602528857' WHERE PBXPid=1 [2020-10-13 02:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602528847 [2020-10-13 02:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602528857,`PBXCuid`=1602528857 [2020-10-13 02:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602529157' WHERE PBXPid=1 [2020-10-13 02:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602529147 [2020-10-13 02:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602529157,`PBXCuid`=1602529157 [2020-10-13 03:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602529457' WHERE PBXPid=1 [2020-10-13 03:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602529447 [2020-10-13 03:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602529457,`PBXCuid`=1602529457 [2020-10-13 03:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602529757' WHERE PBXPid=1 [2020-10-13 03:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602529747 [2020-10-13 03:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602529757,`PBXCuid`=1602529757 [2020-10-13 03:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602530057' WHERE PBXPid=1 [2020-10-13 03:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602530047 [2020-10-13 03:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602530057,`PBXCuid`=1602530057 [2020-10-13 03:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602530357' WHERE PBXPid=1 [2020-10-13 03:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602530347 [2020-10-13 03:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602530357,`PBXCuid`=1602530357 [2020-10-13 03:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602530657' WHERE PBXPid=1 [2020-10-13 03:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602530647 [2020-10-13 03:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602530657,`PBXCuid`=1602530657 [2020-10-13 03:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602530957' WHERE PBXPid=1 [2020-10-13 03:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602530947 [2020-10-13 03:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602530957,`PBXCuid`=1602530957 [2020-10-13 03:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602531257' WHERE PBXPid=1 [2020-10-13 03:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602531247 [2020-10-13 03:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602531257,`PBXCuid`=1602531257 [2020-10-13 03:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602531557' WHERE PBXPid=1 [2020-10-13 03:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602531547 [2020-10-13 03:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602531557,`PBXCuid`=1602531557 [2020-10-13 03:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602531857' WHERE PBXPid=1 [2020-10-13 03:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602531847 [2020-10-13 03:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602531857,`PBXCuid`=1602531857 [2020-10-13 03:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602532157' WHERE PBXPid=1 [2020-10-13 03:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602532147 [2020-10-13 03:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602532157,`PBXCuid`=1602532157 [2020-10-13 03:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602532457' WHERE PBXPid=1 [2020-10-13 03:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602532447 [2020-10-13 03:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602532457,`PBXCuid`=1602532457 [2020-10-13 03:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602532757' WHERE PBXPid=1 [2020-10-13 03:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602532747 [2020-10-13 03:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602532757,`PBXCuid`=1602532757 [2020-10-13 04:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602533057' WHERE PBXPid=1 [2020-10-13 04:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602533047 [2020-10-13 04:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602533057,`PBXCuid`=1602533057 [2020-10-13 04:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602533357' WHERE PBXPid=1 [2020-10-13 04:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602533347 [2020-10-13 04:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602533357,`PBXCuid`=1602533357 [2020-10-13 04:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602533657' WHERE PBXPid=1 [2020-10-13 04:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602533647 [2020-10-13 04:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602533657,`PBXCuid`=1602533657 [2020-10-13 04:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602533957' WHERE PBXPid=1 [2020-10-13 04:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602533947 [2020-10-13 04:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602533957,`PBXCuid`=1602533957 [2020-10-13 04:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602534257' WHERE PBXPid=1 [2020-10-13 04:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602534247 [2020-10-13 04:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602534257,`PBXCuid`=1602534257 [2020-10-13 04:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602534557' WHERE PBXPid=1 [2020-10-13 04:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602534547 [2020-10-13 04:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602534557,`PBXCuid`=1602534557 [2020-10-13 04:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602534857' WHERE PBXPid=1 [2020-10-13 04:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602534847 [2020-10-13 04:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602534857,`PBXCuid`=1602534857 [2020-10-13 04:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602535157' WHERE PBXPid=1 [2020-10-13 04:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602535147 [2020-10-13 04:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602535157,`PBXCuid`=1602535157 [2020-10-13 04:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602535457' WHERE PBXPid=1 [2020-10-13 04:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602535447 [2020-10-13 04:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602535457,`PBXCuid`=1602535457 [2020-10-13 04:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602535757' WHERE PBXPid=1 [2020-10-13 04:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602535747 [2020-10-13 04:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602535757,`PBXCuid`=1602535757 [2020-10-13 04:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602536057' WHERE PBXPid=1 [2020-10-13 04:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602536047 [2020-10-13 04:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602536057,`PBXCuid`=1602536057 [2020-10-13 04:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602536357' WHERE PBXPid=1 [2020-10-13 04:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602536347 [2020-10-13 04:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602536357,`PBXCuid`=1602536357 [2020-10-13 05:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602536657' WHERE PBXPid=1 [2020-10-13 05:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602536647 [2020-10-13 05:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602536657,`PBXCuid`=1602536657 [2020-10-13 05:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602536957' WHERE PBXPid=1 [2020-10-13 05:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602536947 [2020-10-13 05:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602536957,`PBXCuid`=1602536957 [2020-10-13 05:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602537257' WHERE PBXPid=1 [2020-10-13 05:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602537247 [2020-10-13 05:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602537257,`PBXCuid`=1602537257 [2020-10-13 05:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602537557' WHERE PBXPid=1 [2020-10-13 05:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602537547 [2020-10-13 05:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602537557,`PBXCuid`=1602537557 [2020-10-13 05:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602537857' WHERE PBXPid=1 [2020-10-13 05:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602537847 [2020-10-13 05:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602537857,`PBXCuid`=1602537857 [2020-10-13 05:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602538157' WHERE PBXPid=1 [2020-10-13 05:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602538147 [2020-10-13 05:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602538157,`PBXCuid`=1602538157 [2020-10-13 05:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602538457' WHERE PBXPid=1 [2020-10-13 05:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602538447 [2020-10-13 05:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602538457,`PBXCuid`=1602538457 [2020-10-13 05:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602538757' WHERE PBXPid=1 [2020-10-13 05:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602538747 [2020-10-13 05:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602538757,`PBXCuid`=1602538757 [2020-10-13 05:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602539057' WHERE PBXPid=1 [2020-10-13 05:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602539047 [2020-10-13 05:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602539057,`PBXCuid`=1602539057 [2020-10-13 05:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602539357' WHERE PBXPid=1 [2020-10-13 05:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602539347 [2020-10-13 05:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602539357,`PBXCuid`=1602539357 [2020-10-13 05:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602539657' WHERE PBXPid=1 [2020-10-13 05:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602539647 [2020-10-13 05:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602539657,`PBXCuid`=1602539657 [2020-10-13 05:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602539957' WHERE PBXPid=1 [2020-10-13 05:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602539947 [2020-10-13 05:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602539957,`PBXCuid`=1602539957 [2020-10-13 06:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602540257' WHERE PBXPid=1 [2020-10-13 06:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602540247 [2020-10-13 06:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602540257,`PBXCuid`=1602540257 [2020-10-13 06:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602540557' WHERE PBXPid=1 [2020-10-13 06:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602540547 [2020-10-13 06:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602540557,`PBXCuid`=1602540557 [2020-10-13 06:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602540857' WHERE PBXPid=1 [2020-10-13 06:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602540847 [2020-10-13 06:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602540857,`PBXCuid`=1602540857 [2020-10-13 06:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602541157' WHERE PBXPid=1 [2020-10-13 06:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602541147 [2020-10-13 06:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602541157,`PBXCuid`=1602541157 [2020-10-13 06:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602541457' WHERE PBXPid=1 [2020-10-13 06:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602541447 [2020-10-13 06:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602541457,`PBXCuid`=1602541457 [2020-10-13 06:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602541757' WHERE PBXPid=1 [2020-10-13 06:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602541747 [2020-10-13 06:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602541757,`PBXCuid`=1602541757 [2020-10-13 06:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602542057' WHERE PBXPid=1 [2020-10-13 06:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602542047 [2020-10-13 06:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602542057,`PBXCuid`=1602542057 [2020-10-13 06:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602542357' WHERE PBXPid=1 [2020-10-13 06:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602542347 [2020-10-13 06:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602542357,`PBXCuid`=1602542357 [2020-10-13 06:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602542657' WHERE PBXPid=1 [2020-10-13 06:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602542647 [2020-10-13 06:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602542657,`PBXCuid`=1602542657 [2020-10-13 06:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602542957' WHERE PBXPid=1 [2020-10-13 06:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602542947 [2020-10-13 06:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602542957,`PBXCuid`=1602542957 [2020-10-13 06:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602543257' WHERE PBXPid=1 [2020-10-13 06:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602543247 [2020-10-13 06:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602543257,`PBXCuid`=1602543257 [2020-10-13 06:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602543557' WHERE PBXPid=1 [2020-10-13 06:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602543547 [2020-10-13 06:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602543557,`PBXCuid`=1602543557 [2020-10-13 07:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602543857' WHERE PBXPid=1 [2020-10-13 07:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602543847 [2020-10-13 07:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602543857,`PBXCuid`=1602543857 [2020-10-13 07:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602544157' WHERE PBXPid=1 [2020-10-13 07:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602544147 [2020-10-13 07:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602544157,`PBXCuid`=1602544157 [2020-10-13 07:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602544457' WHERE PBXPid=1 [2020-10-13 07:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602544447 [2020-10-13 07:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602544457,`PBXCuid`=1602544457 [2020-10-13 07:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602544757' WHERE PBXPid=1 [2020-10-13 07:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602544747 [2020-10-13 07:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602544757,`PBXCuid`=1602544757 [2020-10-13 07:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602545057' WHERE PBXPid=1 [2020-10-13 07:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602545047 [2020-10-13 07:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602545057,`PBXCuid`=1602545057 [2020-10-13 07:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602545357' WHERE PBXPid=1 [2020-10-13 07:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602545347 [2020-10-13 07:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602545357,`PBXCuid`=1602545357 [2020-10-13 07:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602545657' WHERE PBXPid=1 [2020-10-13 07:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602545647 [2020-10-13 07:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602545657,`PBXCuid`=1602545657 [2020-10-13 07:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602545957' WHERE PBXPid=1 [2020-10-13 07:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602545947 [2020-10-13 07:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602545957,`PBXCuid`=1602545957 [2020-10-13 07:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602546257' WHERE PBXPid=1 [2020-10-13 07:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602546247 [2020-10-13 07:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602546257,`PBXCuid`=1602546257 [2020-10-13 07:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602546557' WHERE PBXPid=1 [2020-10-13 07:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602546547 [2020-10-13 07:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602546557,`PBXCuid`=1602546557 [2020-10-13 07:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602546857' WHERE PBXPid=1 [2020-10-13 07:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602546847 [2020-10-13 07:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602546857,`PBXCuid`=1602546857 [2020-10-13 07:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602547157' WHERE PBXPid=1 [2020-10-13 07:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602547147 [2020-10-13 07:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602547157,`PBXCuid`=1602547157 [2020-10-13 08:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602547457' WHERE PBXPid=1 [2020-10-13 08:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602547447 [2020-10-13 08:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602547457,`PBXCuid`=1602547457 [2020-10-13 08:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602547757' WHERE PBXPid=1 [2020-10-13 08:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602547747 [2020-10-13 08:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602547757,`PBXCuid`=1602547757 [2020-10-13 08:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602548057' WHERE PBXPid=1 [2020-10-13 08:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602548047 [2020-10-13 08:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602548057,`PBXCuid`=1602548057 [2020-10-13 08:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602548357' WHERE PBXPid=1 [2020-10-13 08:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602548347 [2020-10-13 08:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602548357,`PBXCuid`=1602548357 [2020-10-13 08:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602548657' WHERE PBXPid=1 [2020-10-13 08:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602548647 [2020-10-13 08:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602548657,`PBXCuid`=1602548657 [2020-10-13 08:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602548957' WHERE PBXPid=1 [2020-10-13 08:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602548947 [2020-10-13 08:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602548957,`PBXCuid`=1602548957 [2020-10-13 08:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602549257' WHERE PBXPid=1 [2020-10-13 08:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602549247 [2020-10-13 08:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602549257,`PBXCuid`=1602549257 [2020-10-13 08:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602549557' WHERE PBXPid=1 [2020-10-13 08:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602549547 [2020-10-13 08:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602549557,`PBXCuid`=1602549557 [2020-10-13 08:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602549857' WHERE PBXPid=1 [2020-10-13 08:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602549847 [2020-10-13 08:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602549857,`PBXCuid`=1602549857 [2020-10-13 08:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602550157' WHERE PBXPid=1 [2020-10-13 08:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602550147 [2020-10-13 08:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602550157,`PBXCuid`=1602550157 [2020-10-13 08:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602550457' WHERE PBXPid=1 [2020-10-13 08:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602550447 [2020-10-13 08:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602550457,`PBXCuid`=1602550457 [2020-10-13 08:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602550757' WHERE PBXPid=1 [2020-10-13 08:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602550747 [2020-10-13 08:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602550757,`PBXCuid`=1602550757 [2020-10-13 09:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602551057' WHERE PBXPid=1 [2020-10-13 09:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602551047 [2020-10-13 09:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602551057,`PBXCuid`=1602551057 [2020-10-13 09:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602551357' WHERE PBXPid=1 [2020-10-13 09:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602551347 [2020-10-13 09:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602551357,`PBXCuid`=1602551357 [2020-10-13 09:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602551657' WHERE PBXPid=1 [2020-10-13 09:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602551647 [2020-10-13 09:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602551657,`PBXCuid`=1602551657 [2020-10-13 09:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602551957' WHERE PBXPid=1 [2020-10-13 09:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602551947 [2020-10-13 09:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602551957,`PBXCuid`=1602551957 [2020-10-13 09:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602552257' WHERE PBXPid=1 [2020-10-13 09:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602552247 [2020-10-13 09:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602552257,`PBXCuid`=1602552257 [2020-10-13 09:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602552557' WHERE PBXPid=1 [2020-10-13 09:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602552547 [2020-10-13 09:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602552557,`PBXCuid`=1602552557 [2020-10-13 09:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602552857' WHERE PBXPid=1 [2020-10-13 09:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602552847 [2020-10-13 09:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602552857,`PBXCuid`=1602552857 [2020-10-13 09:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602553157' WHERE PBXPid=1 [2020-10-13 09:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602553147 [2020-10-13 09:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602553157,`PBXCuid`=1602553157 [2020-10-13 09:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602553457' WHERE PBXPid=1 [2020-10-13 09:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602553447 [2020-10-13 09:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602553457,`PBXCuid`=1602553457 [2020-10-13 09:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602553757' WHERE PBXPid=1 [2020-10-13 09:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602553747 [2020-10-13 09:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602553757,`PBXCuid`=1602553757 [2020-10-13 09:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602554057' WHERE PBXPid=1 [2020-10-13 09:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602554047 [2020-10-13 09:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602554057,`PBXCuid`=1602554057 [2020-10-13 09:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602554357' WHERE PBXPid=1 [2020-10-13 09:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602554347 [2020-10-13 09:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602554357,`PBXCuid`=1602554357 [2020-10-13 10:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602554657' WHERE PBXPid=1 [2020-10-13 10:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602554647 [2020-10-13 10:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602554657,`PBXCuid`=1602554657 [2020-10-13 10:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602554957' WHERE PBXPid=1 [2020-10-13 10:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602554947 [2020-10-13 10:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602554957,`PBXCuid`=1602554957 [2020-10-13 10:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602555257' WHERE PBXPid=1 [2020-10-13 10:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602555247 [2020-10-13 10:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602555257,`PBXCuid`=1602555257 [2020-10-13 10:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602555557' WHERE PBXPid=1 [2020-10-13 10:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602555547 [2020-10-13 10:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602555557,`PBXCuid`=1602555557 [2020-10-13 10:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602555857' WHERE PBXPid=1 [2020-10-13 10:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602555847 [2020-10-13 10:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602555857,`PBXCuid`=1602555857 [2020-10-13 10:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602556157' WHERE PBXPid=1 [2020-10-13 10:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602556147 [2020-10-13 10:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602556157,`PBXCuid`=1602556157 [2020-10-13 10:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602556457' WHERE PBXPid=1 [2020-10-13 10:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602556447 [2020-10-13 10:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602556457,`PBXCuid`=1602556457 [2020-10-13 10:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602556757' WHERE PBXPid=1 [2020-10-13 10:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602556747 [2020-10-13 10:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602556757,`PBXCuid`=1602556757 [2020-10-13 10:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602557057' WHERE PBXPid=1 [2020-10-13 10:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602557047 [2020-10-13 10:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602557057,`PBXCuid`=1602557057 [2020-10-13 10:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602557357' WHERE PBXPid=1 [2020-10-13 10:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602557347 [2020-10-13 10:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602557357,`PBXCuid`=1602557357 [2020-10-13 10:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602557657' WHERE PBXPid=1 [2020-10-13 10:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602557647 [2020-10-13 10:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602557657,`PBXCuid`=1602557657 [2020-10-13 10:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602557957' WHERE PBXPid=1 [2020-10-13 10:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602557947 [2020-10-13 10:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602557957,`PBXCuid`=1602557957 [2020-10-13 11:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602558257' WHERE PBXPid=1 [2020-10-13 11:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602558247 [2020-10-13 11:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602558257,`PBXCuid`=1602558257 [2020-10-13 11:08:15] UPDATE sales SET login_ip='119.247.119.15', login_time='16025584952390' WHERE Sid='104' LIMIT 1 [2020-10-13 11:08:15] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-10-13 11:08:15',104,'119.247.119.15',1,2) [2020-10-13 11:08:15] UPDATE sales SET lastlogindate='2020-10-13 11:08:15' WHERE Sid='104' LIMIT 1 [2020-10-13 11:08:15] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 11:08:15] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 11:08:15] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 11:08:16] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 11:08:16] UPDATE sales SET lastlogindate='2020-10-13 11:08:16' WHERE Sid='104' LIMIT 1 [2020-10-13 11:08:16] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 11:08:16] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 11:08:16] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 11:08:16] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 11:08:17] UPDATE sales SET lastlogindate='2020-10-13 11:08:17' WHERE Sid='104' LIMIT 1 [2020-10-13 11:08:17] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 11:08:17] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 11:08:17] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 11:08:17] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 11:08:20] UPDATE sales SET lastlogindate='2020-10-13 11:08:20' WHERE Sid='104' LIMIT 1 [2020-10-13 11:08:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 11:08:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 11:08:20] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 11:08:21] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 11:08:21] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 11:08:21] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 11:09:08] UPDATE sales SET lastlogindate='2020-10-13 11:09:08' WHERE Sid='104' LIMIT 1 [2020-10-13 11:09:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 11:09:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 11:09:08] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 11:09:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 11:09:08] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 11:09:09] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 11:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602558557' WHERE PBXPid=1 [2020-10-13 11:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602558547 [2020-10-13 11:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602558557,`PBXCuid`=1602558557 [2020-10-13 11:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602558857' WHERE PBXPid=1 [2020-10-13 11:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602558847 [2020-10-13 11:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602558857,`PBXCuid`=1602558857 [2020-10-13 11:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602559157' WHERE PBXPid=1 [2020-10-13 11:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602559147 [2020-10-13 11:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602559157,`PBXCuid`=1602559157 [2020-10-13 11:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602559457' WHERE PBXPid=1 [2020-10-13 11:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602559447 [2020-10-13 11:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602559457,`PBXCuid`=1602559457 [2020-10-13 11:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602559757' WHERE PBXPid=1 [2020-10-13 11:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602559747 [2020-10-13 11:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602559757,`PBXCuid`=1602559757 [2020-10-13 11:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602560057' WHERE PBXPid=1 [2020-10-13 11:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602560047 [2020-10-13 11:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602560057,`PBXCuid`=1602560057 [2020-10-13 11:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602560357' WHERE PBXPid=1 [2020-10-13 11:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602560347 [2020-10-13 11:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602560357,`PBXCuid`=1602560357 [2020-10-13 11:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602560657' WHERE PBXPid=1 [2020-10-13 11:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602560647 [2020-10-13 11:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602560657,`PBXCuid`=1602560657 [2020-10-13 11:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602560957' WHERE PBXPid=1 [2020-10-13 11:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602560947 [2020-10-13 11:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602560957,`PBXCuid`=1602560957 [2020-10-13 11:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602561257' WHERE PBXPid=1 [2020-10-13 11:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602561247 [2020-10-13 11:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602561257,`PBXCuid`=1602561257 [2020-10-13 11:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602561557' WHERE PBXPid=1 [2020-10-13 11:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602561547 [2020-10-13 11:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602561557,`PBXCuid`=1602561557 [2020-10-13 12:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602561857' WHERE PBXPid=1 [2020-10-13 12:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602561847 [2020-10-13 12:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602561857,`PBXCuid`=1602561857 [2020-10-13 12:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602562157' WHERE PBXPid=1 [2020-10-13 12:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602562147 [2020-10-13 12:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602562157,`PBXCuid`=1602562157 [2020-10-13 12:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602562457' WHERE PBXPid=1 [2020-10-13 12:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602562447 [2020-10-13 12:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602562457,`PBXCuid`=1602562457 [2020-10-13 12:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602562757' WHERE PBXPid=1 [2020-10-13 12:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602562747 [2020-10-13 12:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602562757,`PBXCuid`=1602562757 [2020-10-13 12:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602563057' WHERE PBXPid=1 [2020-10-13 12:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602563047 [2020-10-13 12:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602563057,`PBXCuid`=1602563057 [2020-10-13 12:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602563357' WHERE PBXPid=1 [2020-10-13 12:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602563347 [2020-10-13 12:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602563357,`PBXCuid`=1602563357 [2020-10-13 12:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602563657' WHERE PBXPid=1 [2020-10-13 12:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602563647 [2020-10-13 12:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602563657,`PBXCuid`=1602563657 [2020-10-13 12:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602563957' WHERE PBXPid=1 [2020-10-13 12:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602563947 [2020-10-13 12:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602563957,`PBXCuid`=1602563957 [2020-10-13 12:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602564257' WHERE PBXPid=1 [2020-10-13 12:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602564247 [2020-10-13 12:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602564257,`PBXCuid`=1602564257 [2020-10-13 12:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602564557' WHERE PBXPid=1 [2020-10-13 12:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602564547 [2020-10-13 12:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602564557,`PBXCuid`=1602564557 [2020-10-13 12:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602564857' WHERE PBXPid=1 [2020-10-13 12:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602564847 [2020-10-13 12:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602564857,`PBXCuid`=1602564857 [2020-10-13 12:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602565157' WHERE PBXPid=1 [2020-10-13 12:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602565147 [2020-10-13 12:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602565157,`PBXCuid`=1602565157 [2020-10-13 13:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602565457' WHERE PBXPid=1 [2020-10-13 13:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602565447 [2020-10-13 13:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602565457,`PBXCuid`=1602565457 [2020-10-13 13:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602565757' WHERE PBXPid=1 [2020-10-13 13:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602565747 [2020-10-13 13:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602565757,`PBXCuid`=1602565757 [2020-10-13 13:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602566057' WHERE PBXPid=1 [2020-10-13 13:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602566047 [2020-10-13 13:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602566057,`PBXCuid`=1602566057 [2020-10-13 13:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602566357' WHERE PBXPid=1 [2020-10-13 13:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602566347 [2020-10-13 13:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602566357,`PBXCuid`=1602566357 [2020-10-13 13:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602566657' WHERE PBXPid=1 [2020-10-13 13:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602566647 [2020-10-13 13:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602566657,`PBXCuid`=1602566657 [2020-10-13 13:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602566957' WHERE PBXPid=1 [2020-10-13 13:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602566947 [2020-10-13 13:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602566957,`PBXCuid`=1602566957 [2020-10-13 13:32:51] UPDATE sales SET login_ip='119.247.228.39', login_time='16025671715356' WHERE Sid='1' LIMIT 1 [2020-10-13 13:32:51] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-10-13 13:32:51',1,'119.247.228.39',1,2) [2020-10-13 13:32:51] UPDATE sales SET lastlogindate='2020-10-13 13:32:51' WHERE Sid='1' LIMIT 1 [2020-10-13 13:32:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:32:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:32:51] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:32:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:32:52] UPDATE sales SET lastlogindate='2020-10-13 13:32:52' WHERE Sid='1' LIMIT 1 [2020-10-13 13:32:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:32:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:32:52] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:32:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:32:56] UPDATE sales SET lastlogindate='2020-10-13 13:32:56' WHERE Sid='1' LIMIT 1 [2020-10-13 13:32:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:32:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:32:56] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:32:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:33:21] UPDATE sales SET lastlogindate='2020-10-13 13:33:21' WHERE Sid='1' LIMIT 1 [2020-10-13 13:33:21] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:33:21] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:33:21] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:33:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602567257' WHERE PBXPid=1 [2020-10-13 13:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602567247 [2020-10-13 13:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602567257,`PBXCuid`=1602567257 [2020-10-13 13:34:36] UPDATE sales SET lastlogindate='2020-10-13 13:34:36' WHERE Sid='1' LIMIT 1 [2020-10-13 13:34:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:34:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:34:36] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:34:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:34:40] UPDATE sales SET lastlogindate='2020-10-13 13:34:40' WHERE Sid='1' LIMIT 1 [2020-10-13 13:34:40] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:34:40] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:34:40] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:34:41] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:34:48] UPDATE sales SET lastlogindate='2020-10-13 13:34:48' WHERE Sid='1' LIMIT 1 [2020-10-13 13:34:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:34:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:34:49] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:34:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:35:02] UPDATE sales SET lastlogindate='2020-10-13 13:35:02' WHERE Sid='1' LIMIT 1 [2020-10-13 13:35:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:02] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:35:02] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:35:02] UPDATE sales SET `Ssort`='42',`Sname`='ANNIE LAU',`Sstatus`='1',`Gid`='4',`Bid`='2',`Ssaldate`='7',`Sindate`='2020-09-23',`Soutdate`=NULL,`Stcname`='劉少冰',`Stename`='LAU SIU BING ANNIE',`Snickname`=NULL,`Stitle`='Account Manager',`Shkid`='D263353(2)',`Sbirth`='1961-03-06',`Slicense`='S-620128',`Saddr`='沙田火炭駿洋邨駿湖樓1607室',`Semail`=NULL,`Sremark1`='匯豐 004008-753238-833',`Sremark2`=NULL,`Slicensedate`='2021-09-24',`Ssalesid`='042',`login`='ANNIE',`level`=NULL,`grade`=NULL,`Sreadlevel`=NULL,`Stel1`=NULL,`Stel2`='55239937',`iplimit`=NULL,`Sbasicsalary`=NULL,`Sbasicsalary_mpf`=NULL,`SdoubleGrain`=NULL,`Sbonus`=NULL,`SdirectorBonus`=NULL,`SHAllowance`=NULL,`STAllowance`=NULL,`SotherIncome`=NULL,`SMPFexpenditure`=NULL,`Sminsalary`=NULL,`pbxmobileno`='55239937',`pbxinternivr`='661',`Bid_multi`=NULL WHERE Sid=109 [2020-10-13 13:35:02] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2020-10-13 13:35:02',1,'119.247.228.39',3,'sales','',109,2) [2020-10-13 13:35:02] UPDATE project SET Pstatus=2 WHERE Sid=109 [2020-10-13 13:35:02] UPDATE project SET Pstatus2=2 WHERE Sid=109 [2020-10-13 13:35:02] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2020-10-13 13:35:02] UPDATE sales SET lastlogindate='2020-10-13 13:35:02' WHERE Sid='1' LIMIT 1 [2020-10-13 13:35:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:03] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:35:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:35:14] UPDATE sales SET lastlogindate='2020-10-13 13:35:14' WHERE Sid='1' LIMIT 1 [2020-10-13 13:35:14] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:14] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:14] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:35:15] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:35:21] UPDATE sales SET lastlogindate='2020-10-13 13:35:21' WHERE Sid='1' LIMIT 1 [2020-10-13 13:35:21] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:21] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:21] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:35:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:35:29] UPDATE sales SET lastlogindate='2020-10-13 13:35:29' WHERE Sid='1' LIMIT 1 [2020-10-13 13:35:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:29] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:35:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:35:35] UPDATE sales SET lastlogindate='2020-10-13 13:35:35' WHERE Sid='1' LIMIT 1 [2020-10-13 13:35:35] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:35] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:35] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:35:36] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:35:42] UPDATE sales SET lastlogindate='2020-10-13 13:35:42' WHERE Sid='1' LIMIT 1 [2020-10-13 13:35:42] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:42] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:42] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:35:43] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:35:46] UPDATE sales SET lastlogindate='2020-10-13 13:35:46' WHERE Sid='1' LIMIT 1 [2020-10-13 13:35:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:35:46] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:35:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:36:00] UPDATE sales SET lastlogindate='2020-10-13 13:36:00' WHERE Sid='1' LIMIT 1 [2020-10-13 13:36:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:36:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:36:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:36:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:36:14] UPDATE sales SET lastlogindate='2020-10-13 13:36:14' WHERE Sid='1' LIMIT 1 [2020-10-13 13:36:14] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:36:14] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:36:14] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:36:14] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:36:23] UPDATE sales SET lastlogindate='2020-10-13 13:36:23' WHERE Sid='1' LIMIT 1 [2020-10-13 13:36:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:36:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:36:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:36:24] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602567557' WHERE PBXPid=1 [2020-10-13 13:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602567547 [2020-10-13 13:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602567557,`PBXCuid`=1602567557 [2020-10-13 13:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602567857' WHERE PBXPid=1 [2020-10-13 13:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602567847 [2020-10-13 13:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602567857,`PBXCuid`=1602567857 [2020-10-13 13:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602568157' WHERE PBXPid=1 [2020-10-13 13:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602568147 [2020-10-13 13:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602568157,`PBXCuid`=1602568157 [2020-10-13 13:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602568457' WHERE PBXPid=1 [2020-10-13 13:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602568447 [2020-10-13 13:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602568457,`PBXCuid`=1602568457 [2020-10-13 13:57:38] UPDATE sales SET login_ip='119.247.72.9', login_time='16025686589288' WHERE Sid='111' LIMIT 1 [2020-10-13 13:57:38] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-10-13 13:57:38',111,'119.247.72.9',1,2) [2020-10-13 13:57:38] UPDATE sales SET lastlogindate='2020-10-13 13:57:38' WHERE Sid='111' LIMIT 1 [2020-10-13 13:57:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:57:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 13:57:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 13:57:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 13:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602568757' WHERE PBXPid=1 [2020-10-13 13:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602568747 [2020-10-13 13:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602568757,`PBXCuid`=1602568757 [2020-10-13 14:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602569057' WHERE PBXPid=1 [2020-10-13 14:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602569047 [2020-10-13 14:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602569057,`PBXCuid`=1602569057 [2020-10-13 14:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602569357' WHERE PBXPid=1 [2020-10-13 14:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602569347 [2020-10-13 14:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602569357,`PBXCuid`=1602569357 [2020-10-13 14:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602569657' WHERE PBXPid=1 [2020-10-13 14:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602569647 [2020-10-13 14:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602569657,`PBXCuid`=1602569657 [2020-10-13 14:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602569957' WHERE PBXPid=1 [2020-10-13 14:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602569947 [2020-10-13 14:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602569957,`PBXCuid`=1602569957 [2020-10-13 14:23:13] UPDATE sales SET lastlogindate='2020-10-13 14:23:13' WHERE Sid='111' LIMIT 1 [2020-10-13 14:23:13] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:23:13] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:23:13] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:23:13] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602570257' WHERE PBXPid=1 [2020-10-13 14:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602570247 [2020-10-13 14:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602570257,`PBXCuid`=1602570257 [2020-10-13 14:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602570557' WHERE PBXPid=1 [2020-10-13 14:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602570547 [2020-10-13 14:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602570557,`PBXCuid`=1602570557 [2020-10-13 14:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602570857' WHERE PBXPid=1 [2020-10-13 14:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602570847 [2020-10-13 14:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602570857,`PBXCuid`=1602570857 [2020-10-13 14:36:51] UPDATE sales SET lastlogindate='2020-10-13 14:36:51' WHERE Sid='1' LIMIT 1 [2020-10-13 14:36:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:36:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:36:51] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:36:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:36:52] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:36:52] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:38:36] UPDATE sales SET lastlogindate='2020-10-13 14:38:36' WHERE Sid='1' LIMIT 1 [2020-10-13 14:38:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:38:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:38:36] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:38:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:38:37] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:38:37] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602571157' WHERE PBXPid=1 [2020-10-13 14:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602571147 [2020-10-13 14:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602571157,`PBXCuid`=1602571157 [2020-10-13 14:39:45] UPDATE sales SET lastlogindate='2020-10-13 14:39:45' WHERE Sid='1' LIMIT 1 [2020-10-13 14:39:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:39:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:39:45] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:39:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:39:46] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:39:46] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:40:26] UPDATE sales SET lastlogindate='2020-10-13 14:40:26' WHERE Sid='1' LIMIT 1 [2020-10-13 14:40:26] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:40:26] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:40:26] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:40:27] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:40:27] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:40:27] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:40:45] UPDATE sales SET lastlogindate='2020-10-13 14:40:45' WHERE Sid='1' LIMIT 1 [2020-10-13 14:40:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:40:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:40:46] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:40:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:40:46] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:40:46] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:41:11] UPDATE sales SET lastlogindate='2020-10-13 14:41:11' WHERE Sid='1' LIMIT 1 [2020-10-13 14:41:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:41:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:41:12] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:41:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:41:12] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:41:12] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:41:31] UPDATE sales SET lastlogindate='2020-10-13 14:41:31' WHERE Sid='1' LIMIT 1 [2020-10-13 14:41:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:41:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:41:31] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:41:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:41:32] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:41:32] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:42:17] UPDATE sales SET lastlogindate='2020-10-13 14:42:17' WHERE Sid='1' LIMIT 1 [2020-10-13 14:42:17] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:42:17] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:42:17] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:42:18] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:42:18] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:42:18] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602571457' WHERE PBXPid=1 [2020-10-13 14:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602571447 [2020-10-13 14:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602571457,`PBXCuid`=1602571457 [2020-10-13 14:49:01] UPDATE sales SET lastlogindate='2020-10-13 14:49:01' WHERE Sid='1' LIMIT 1 [2020-10-13 14:49:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:49:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:49:01] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:49:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:49:01] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:49:01] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:49:07] UPDATE project SET PeditAdminType='2', PeditAdminID='1', PeditStartDate=NOW() WHERE Pid='13627' LIMIT 1 [2020-10-13 14:49:10] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13627' LIMIT 1 [2020-10-13 14:49:10] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13627' LIMIT 1 [2020-10-13 14:49:10] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13627' LIMIT 1 [2020-10-13 14:49:11] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13627' LIMIT 1 [2020-10-13 14:49:13] UPDATE sales SET lastlogindate='2020-10-13 14:49:13' WHERE Sid='1' LIMIT 1 [2020-10-13 14:49:13] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:49:13] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:49:14] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:49:14] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:49:14] UPDATE project SET `Pdate`=NULL,`Pname`=NULL,`Poname`=NULL,`Poremark`=NULL,`Pbname`=NULL,`Pbremark`=NULL,`Pprice`='0.00',`Popay`='0.00',`Pbpay`='0.00',`Premark`=NULL,`Bid`=NULL,`Sid`=NULL,`Pstatus`=NULL,`Potype`=NULL,`Popaytype`=NULL,`Popaydate`=NULL,`Popaymethod`=NULL,`Pobankno`=NULL,`Popayremark`=NULL,`Pbtype`=NULL,`Pbpaytype`=NULL,`Pbpaydate`=NULL,`Pbpaymethod`=NULL,`Pbbankno`=NULL,`Pbpayremark`=NULL,`Ptype`='1',`Pexdate1`=NULL,`Pexdate2`=NULL,`Poexdate1`='2020-09-28',`Pbexdate1`='2020-09-28',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='12',`Poadminid`=NULL,`Pbadminid`=NULL,`Pocooperate`=NULL,`Pbcooperate`=NULL,`Pstatus2`=NULL,`Pstepcount`='1',`Polawyermore`=NULL,`Pblawyermore`=NULL,`Pextra1`=NULL,`Pextra2`=NULL,`Pextra3`=NULL,`Pextra4`=NULL,`Pextra5`=NULL,`Pextra6`=NULL,`Pextra7`=NULL,`Pextra8`=NULL,`Pextra9`=NULL,`Pextra10`=NULL,`Pextra11`=NULL,`Pname2`='德瑞樓',`Pflat`='22',`Pfloor`='24',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='37',`PBDcarea`=NULL,`PBDsarea`='443',`PBDinterval`=NULL,`PBDmfees`=NULL,`PBDrfees`=NULL,`PBDtype`='1',`PBDlandscape`=NULL,`PBDdecorating`='屋邨類別： 租者置其屋計劃 入伙年份： 1991 樓宇類型： 新長型、非標準型、小型家庭大廈、Y3型、Y4型 樓宇座數： 9 樓宇名稱： 第1座 德敬樓 第2座 德禮樓 第3座 德義樓 第4座 德樂樓 第5座 德瑞樓 第7座 德盛樓 第8座 德隆樓 德康樓(租住屋邨) 德欣樓(租住屋邨) 單位租住數目： 2 100 * 截至2016年6月30日的情況 單位面積 (平方米)： 單位建築面積（平方米）：15.3 - 73.3 單位實用面積（平方米）：11.8 - 55.6 住戶數目： 2 000 * 截至2016年6月30日的情況 認可人口： 3 900 * 截至2016年6月30日的情況 屋邨管理諮詢委員會： 不適用（已成立業主立案法團） 分區租約事務管理辦事處 / 屋邨辦事處： 房屋署東九龍(九)區租約事務管理處 九龍藍田德田邨德敬樓地下 電話：2772 6840 傳真：2347 3847 屋邨物業管理： 業主立案法團委派 (除德欣樓外) 創毅物業服務顧問有限公司 (只限德欣樓) 藍田德田邨德欣樓7樓 電話：2177 6363 傳真：2177 6603 網站：www.creativepsc.com.hk 首次出售時大約折扣率：49%-56% ***凶宅*** 德樂樓4樓凶宅層 22/7/2020 事發在今早8時許，一名男子在德田邨德盛樓墮樓，其後證實不治。據了解，37歲的死者是一名休班警員，駐守警察總部，平日主要負責內勤工作。該名警員患有肌肉疾病及早期柏金遜症，去年曾請2個月病假。同事得悉其墮樓的消息後，均感到婉惜。',`PBDdescription`='2000年首次發售',`Pcustom`=NULL,`PBDaddress`=NULL,`PBDroom`='2',`PBDhall`=NULL,`PBDsuite`=NULL,`PBDcarspac`=NULL,`PBDmaidroom`=NULL,`PBDtoilet`=NULL,`PBDstorerooms`=NULL,`PBDkitchen`=NULL,`PBDwindowsill`=NULL,`PBDrooftop`=NULL,`PBDgarden`=NULL,`PBDstatus`='1',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`=NULL,`PtmpBid`='2',`PtmpSid`='1',`Cid`=NULL,`Oid`=NULL,`PBDsources`='8',`Prpice`=NULL,`Poremarkmulti`='|2020-10-13 14:49:12::2::1::KP||2020-09-25 11:07:17::2::1::OS 綠表288萬，2000年首次發售，未有証|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`=NULL,`Prent`='288',`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`='*',`Pexdate3`=NULL,`Pcreatedate`='2020-09-25 11:07:45',`Pmodifydate`='2020-10-13 14:49:14',`Pmobile_status`=NULL,`Pmobile_pprice`=NULL,`Pmobile_pprice_s`=NULL,`Pmobile_pprice_t`=NULL,`Pmobiler_rent`=NULL,`Pmobiler_rent_s`=NULL,`Pmobiler_rent_t`=NULL,`Pmobile_top`=NULL,`PBDterrace`=NULL,`PBDwork_platform`=NULL,`PBDcarspac_no`=NULL,`PBDkey_no`=NULL,`PBDmobiler_desc`=NULL,`PBDyoutube`=NULL,`Pmobile_sno`=NULL,`PBDopeninterval`=NULL,`PBDceiling`=NULL,`PBDdoorwidth`=NULL,`PBDpoweredby`=NULL,`PBDgas`=NULL,`Prpice2`=NULL,`PgroupID`=NULL,`Pcompany`=NULL,`Pbrname`=NULL,`Pbrtel`=NULL,`Pdirection`=NULL,`Pocontactmulti`='陳小姐####::(手提)61355992',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`='8447' WHERE Pid=13627 [2020-10-13 14:49:14] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`other`) VALUE ('13627','2020-10-13 14:49:14','1','2','1','Poremarkmulti') [2020-10-13 14:49:14] DELETE FROM projectalert WHERE PAPid='13627' && PAadmin='1' && PAtype='2' && PAalert=1 [2020-10-13 14:49:14] UPDATE project SET PeditAdminType=NULL, PeditAdminID=NULL, PeditStartDate=NULL WHERE Pid='13627' LIMIT 1 [2020-10-13 14:49:14] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2020-10-13 14:49:14',1,'119.247.228.39',3,'project','樓盤︰藍田 - 德田村 座: 德瑞樓, 單位: 22, 層: 24, 地段編號: *',13627,2) [2020-10-13 14:49:14] UPDATE projectshare SET Pname='' WHERE Pid=13627 [2020-10-13 14:49:14] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=13627 [2020-10-13 14:49:14] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=13627 [2020-10-13 14:49:14] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2020-10-13 14:49:14] UPDATE project SET Pstatus=2 WHERE Pid=13627 [2020-10-13 14:49:14] UPDATE project SET Pstatus2=2 WHERE Pid=13627 [2020-10-13 14:49:14] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2020-10-13 14:49:14] UPDATE sales SET lastlogindate='2020-10-13 14:49:14' WHERE Sid='1' LIMIT 1 [2020-10-13 14:49:14] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:49:14] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 14:49:15] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:49:15] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:49:15] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 14:49:15] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 14:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602571757' WHERE PBXPid=1 [2020-10-13 14:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602571747 [2020-10-13 14:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602571757,`PBXCuid`=1602571757 [2020-10-13 14:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602572057' WHERE PBXPid=1 [2020-10-13 14:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602572047 [2020-10-13 14:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602572057,`PBXCuid`=1602572057 [2020-10-13 14:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602572357' WHERE PBXPid=1 [2020-10-13 14:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602572347 [2020-10-13 14:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602572357,`PBXCuid`=1602572357 [2020-10-13 15:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602572657' WHERE PBXPid=1 [2020-10-13 15:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602572647 [2020-10-13 15:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602572657,`PBXCuid`=1602572657 [2020-10-13 15:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602572957' WHERE PBXPid=1 [2020-10-13 15:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602572947 [2020-10-13 15:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602572957,`PBXCuid`=1602572957 [2020-10-13 15:10:11] UPDATE sales SET lastlogindate='2020-10-13 15:10:11' WHERE Sid='111' LIMIT 1 [2020-10-13 15:10:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 15:10:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 15:10:11] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 15:10:11] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 15:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602573257' WHERE PBXPid=1 [2020-10-13 15:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602573247 [2020-10-13 15:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602573257,`PBXCuid`=1602573257 [2020-10-13 15:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602573557' WHERE PBXPid=1 [2020-10-13 15:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602573547 [2020-10-13 15:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602573557,`PBXCuid`=1602573557 [2020-10-13 15:20:16] UPDATE sales SET lastlogindate='2020-10-13 15:20:16' WHERE Sid='111' LIMIT 1 [2020-10-13 15:20:16] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 15:20:16] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 15:20:16] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 15:20:17] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 15:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602573857' WHERE PBXPid=1 [2020-10-13 15:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602573847 [2020-10-13 15:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602573857,`PBXCuid`=1602573857 [2020-10-13 15:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602574157' WHERE PBXPid=1 [2020-10-13 15:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602574147 [2020-10-13 15:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602574157,`PBXCuid`=1602574157 [2020-10-13 15:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602574457' WHERE PBXPid=1 [2020-10-13 15:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602574447 [2020-10-13 15:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602574457,`PBXCuid`=1602574457 [2020-10-13 15:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602574757' WHERE PBXPid=1 [2020-10-13 15:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602574747 [2020-10-13 15:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602574757,`PBXCuid`=1602574757 [2020-10-13 15:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602575057' WHERE PBXPid=1 [2020-10-13 15:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602575047 [2020-10-13 15:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602575057,`PBXCuid`=1602575057 [2020-10-13 15:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602575357' WHERE PBXPid=1 [2020-10-13 15:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602575347 [2020-10-13 15:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602575357,`PBXCuid`=1602575357 [2020-10-13 15:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602575657' WHERE PBXPid=1 [2020-10-13 15:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602575647 [2020-10-13 15:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602575657,`PBXCuid`=1602575657 [2020-10-13 15:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602575957' WHERE PBXPid=1 [2020-10-13 15:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602575947 [2020-10-13 15:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602575957,`PBXCuid`=1602575957 [2020-10-13 16:02:07] UPDATE sales SET login_ip='113.253.28.254', login_time='16025761277922' WHERE Sid='95' LIMIT 1 [2020-10-13 16:02:07] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-10-13 16:02:07',95,'113.253.28.254',1,2) [2020-10-13 16:02:07] UPDATE sales SET lastlogindate='2020-10-13 16:02:07' WHERE Sid='95' LIMIT 1 [2020-10-13 16:02:07] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 16:02:07] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 16:02:08] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 16:02:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 16:02:08] UPDATE sales SET lastlogindate='2020-10-13 16:02:08' WHERE Sid='95' LIMIT 1 [2020-10-13 16:02:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 16:02:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 16:02:08] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 16:02:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 16:02:25] UPDATE sales SET lastlogindate='2020-10-13 16:02:25' WHERE Sid='95' LIMIT 1 [2020-10-13 16:02:25] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 16:02:25] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 16:02:25] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 16:02:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 16:02:26] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 16:02:26] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 16:02:52] UPDATE sales SET lastlogindate='2020-10-13 16:02:52' WHERE Sid='95' LIMIT 1 [2020-10-13 16:02:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 16:02:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 16:02:53] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 16:02:53] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 16:02:53] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 16:02:53] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 16:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602576257' WHERE PBXPid=1 [2020-10-13 16:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602576247 [2020-10-13 16:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602576257,`PBXCuid`=1602576257 [2020-10-13 16:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602576557' WHERE PBXPid=1 [2020-10-13 16:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602576547 [2020-10-13 16:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602576557,`PBXCuid`=1602576557 [2020-10-13 16:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602576857' WHERE PBXPid=1 [2020-10-13 16:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602576847 [2020-10-13 16:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602576857,`PBXCuid`=1602576857 [2020-10-13 16:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602577157' WHERE PBXPid=1 [2020-10-13 16:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602577147 [2020-10-13 16:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602577157,`PBXCuid`=1602577157 [2020-10-13 16:23:46] UPDATE sales SET lastlogindate='2020-10-13 16:23:46' WHERE Sid='111' LIMIT 1 [2020-10-13 16:23:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 16:23:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 16:23:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 16:23:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 16:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602577457' WHERE PBXPid=1 [2020-10-13 16:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602577447 [2020-10-13 16:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602577457,`PBXCuid`=1602577457 [2020-10-13 16:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602577757' WHERE PBXPid=1 [2020-10-13 16:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602577747 [2020-10-13 16:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602577757,`PBXCuid`=1602577757 [2020-10-13 16:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602578057' WHERE PBXPid=1 [2020-10-13 16:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602578047 [2020-10-13 16:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602578057,`PBXCuid`=1602578057 [2020-10-13 16:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602578357' WHERE PBXPid=1 [2020-10-13 16:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602578347 [2020-10-13 16:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602578357,`PBXCuid`=1602578357 [2020-10-13 16:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602578657' WHERE PBXPid=1 [2020-10-13 16:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602578647 [2020-10-13 16:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602578657,`PBXCuid`=1602578657 [2020-10-13 16:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602578957' WHERE PBXPid=1 [2020-10-13 16:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602578947 [2020-10-13 16:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602578957,`PBXCuid`=1602578957 [2020-10-13 16:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602579257' WHERE PBXPid=1 [2020-10-13 16:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602579247 [2020-10-13 16:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602579257,`PBXCuid`=1602579257 [2020-10-13 16:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602579557' WHERE PBXPid=1 [2020-10-13 16:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602579547 [2020-10-13 16:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602579557,`PBXCuid`=1602579557 [2020-10-13 17:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602579857' WHERE PBXPid=1 [2020-10-13 17:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602579847 [2020-10-13 17:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602579857,`PBXCuid`=1602579857 [2020-10-13 17:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602580157' WHERE PBXPid=1 [2020-10-13 17:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602580147 [2020-10-13 17:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602580157,`PBXCuid`=1602580157 [2020-10-13 17:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602580457' WHERE PBXPid=1 [2020-10-13 17:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602580447 [2020-10-13 17:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602580457,`PBXCuid`=1602580457 [2020-10-13 17:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602580757' WHERE PBXPid=1 [2020-10-13 17:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602580747 [2020-10-13 17:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602580757,`PBXCuid`=1602580757 [2020-10-13 17:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602581057' WHERE PBXPid=1 [2020-10-13 17:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602581047 [2020-10-13 17:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602581057,`PBXCuid`=1602581057 [2020-10-13 17:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602581357' WHERE PBXPid=1 [2020-10-13 17:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602581347 [2020-10-13 17:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602581357,`PBXCuid`=1602581357 [2020-10-13 17:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602581657' WHERE PBXPid=1 [2020-10-13 17:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602581647 [2020-10-13 17:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602581657,`PBXCuid`=1602581657 [2020-10-13 17:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602581957' WHERE PBXPid=1 [2020-10-13 17:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602581947 [2020-10-13 17:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602581957,`PBXCuid`=1602581957 [2020-10-13 17:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602582257' WHERE PBXPid=1 [2020-10-13 17:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602582247 [2020-10-13 17:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602582257,`PBXCuid`=1602582257 [2020-10-13 17:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602582557' WHERE PBXPid=1 [2020-10-13 17:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602582547 [2020-10-13 17:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602582557,`PBXCuid`=1602582557 [2020-10-13 17:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602582857' WHERE PBXPid=1 [2020-10-13 17:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602582847 [2020-10-13 17:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602582857,`PBXCuid`=1602582857 [2020-10-13 17:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602583157' WHERE PBXPid=1 [2020-10-13 17:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602583147 [2020-10-13 17:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602583157,`PBXCuid`=1602583157 [2020-10-13 18:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602583457' WHERE PBXPid=1 [2020-10-13 18:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602583447 [2020-10-13 18:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602583457,`PBXCuid`=1602583457 [2020-10-13 18:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602583757' WHERE PBXPid=1 [2020-10-13 18:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602583747 [2020-10-13 18:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602583757,`PBXCuid`=1602583757 [2020-10-13 18:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602584057' WHERE PBXPid=1 [2020-10-13 18:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602584047 [2020-10-13 18:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602584057,`PBXCuid`=1602584057 [2020-10-13 18:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602584357' WHERE PBXPid=1 [2020-10-13 18:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602584347 [2020-10-13 18:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602584357,`PBXCuid`=1602584357 [2020-10-13 18:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602584657' WHERE PBXPid=1 [2020-10-13 18:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602584647 [2020-10-13 18:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602584657,`PBXCuid`=1602584657 [2020-10-13 18:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602584957' WHERE PBXPid=1 [2020-10-13 18:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602584947 [2020-10-13 18:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602584957,`PBXCuid`=1602584957 [2020-10-13 18:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602585257' WHERE PBXPid=1 [2020-10-13 18:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602585247 [2020-10-13 18:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602585257,`PBXCuid`=1602585257 [2020-10-13 18:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602585557' WHERE PBXPid=1 [2020-10-13 18:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602585547 [2020-10-13 18:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602585557,`PBXCuid`=1602585557 [2020-10-13 18:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602585557' WHERE PBXPid=1 [2020-10-13 18:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602585547 [2020-10-13 18:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602585557,`PBXCuid`=1602585557 [2020-10-13 18:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602585857' WHERE PBXPid=1 [2020-10-13 18:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602585847 [2020-10-13 18:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602585857,`PBXCuid`=1602585857 [2020-10-13 18:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602586157' WHERE PBXPid=1 [2020-10-13 18:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602586147 [2020-10-13 18:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602586157,`PBXCuid`=1602586157 [2020-10-13 18:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602586457' WHERE PBXPid=1 [2020-10-13 18:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602586447 [2020-10-13 18:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602586457,`PBXCuid`=1602586457 [2020-10-13 18:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602586757' WHERE PBXPid=1 [2020-10-13 18:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602586747 [2020-10-13 18:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602586757,`PBXCuid`=1602586757 [2020-10-13 19:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602587057' WHERE PBXPid=1 [2020-10-13 19:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602587047 [2020-10-13 19:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602587057,`PBXCuid`=1602587057 [2020-10-13 19:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602587357' WHERE PBXPid=1 [2020-10-13 19:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602587347 [2020-10-13 19:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602587357,`PBXCuid`=1602587357 [2020-10-13 19:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602587657' WHERE PBXPid=1 [2020-10-13 19:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602587647 [2020-10-13 19:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602587657,`PBXCuid`=1602587657 [2020-10-13 19:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602587957' WHERE PBXPid=1 [2020-10-13 19:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602587947 [2020-10-13 19:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602587957,`PBXCuid`=1602587957 [2020-10-13 19:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602588257' WHERE PBXPid=1 [2020-10-13 19:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602588247 [2020-10-13 19:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602588257,`PBXCuid`=1602588257 [2020-10-13 19:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602588557' WHERE PBXPid=1 [2020-10-13 19:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602588547 [2020-10-13 19:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602588557,`PBXCuid`=1602588557 [2020-10-13 19:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602588857' WHERE PBXPid=1 [2020-10-13 19:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602588847 [2020-10-13 19:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602588857,`PBXCuid`=1602588857 [2020-10-13 19:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602589157' WHERE PBXPid=1 [2020-10-13 19:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602589147 [2020-10-13 19:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602589157,`PBXCuid`=1602589157 [2020-10-13 19:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602589457' WHERE PBXPid=1 [2020-10-13 19:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602589447 [2020-10-13 19:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602589457,`PBXCuid`=1602589457 [2020-10-13 19:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602589757' WHERE PBXPid=1 [2020-10-13 19:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602589747 [2020-10-13 19:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602589757,`PBXCuid`=1602589757 [2020-10-13 19:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602590057' WHERE PBXPid=1 [2020-10-13 19:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602590047 [2020-10-13 19:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602590057,`PBXCuid`=1602590057 [2020-10-13 19:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602590357' WHERE PBXPid=1 [2020-10-13 19:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602590347 [2020-10-13 19:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602590357,`PBXCuid`=1602590357 [2020-10-13 20:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602590657' WHERE PBXPid=1 [2020-10-13 20:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602590647 [2020-10-13 20:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602590657,`PBXCuid`=1602590657 [2020-10-13 20:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602590957' WHERE PBXPid=1 [2020-10-13 20:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602590947 [2020-10-13 20:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602590957,`PBXCuid`=1602590957 [2020-10-13 20:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602591257' WHERE PBXPid=1 [2020-10-13 20:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602591247 [2020-10-13 20:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602591257,`PBXCuid`=1602591257 [2020-10-13 20:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602591557' WHERE PBXPid=1 [2020-10-13 20:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602591547 [2020-10-13 20:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602591557,`PBXCuid`=1602591557 [2020-10-13 20:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602591857' WHERE PBXPid=1 [2020-10-13 20:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602591847 [2020-10-13 20:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602591857,`PBXCuid`=1602591857 [2020-10-13 20:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602592157' WHERE PBXPid=1 [2020-10-13 20:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602592147 [2020-10-13 20:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602592157,`PBXCuid`=1602592157 [2020-10-13 20:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602592457' WHERE PBXPid=1 [2020-10-13 20:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602592447 [2020-10-13 20:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602592457,`PBXCuid`=1602592457 [2020-10-13 20:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602592757' WHERE PBXPid=1 [2020-10-13 20:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602592747 [2020-10-13 20:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602592757,`PBXCuid`=1602592757 [2020-10-13 20:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602593057' WHERE PBXPid=1 [2020-10-13 20:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602593047 [2020-10-13 20:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602593057,`PBXCuid`=1602593057 [2020-10-13 20:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602593357' WHERE PBXPid=1 [2020-10-13 20:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602593347 [2020-10-13 20:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602593357,`PBXCuid`=1602593357 [2020-10-13 20:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602593657' WHERE PBXPid=1 [2020-10-13 20:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602593647 [2020-10-13 20:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602593657,`PBXCuid`=1602593657 [2020-10-13 20:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602593957' WHERE PBXPid=1 [2020-10-13 20:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602593947 [2020-10-13 20:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602593957,`PBXCuid`=1602593957 [2020-10-13 21:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602594257' WHERE PBXPid=1 [2020-10-13 21:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602594247 [2020-10-13 21:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602594257,`PBXCuid`=1602594257 [2020-10-13 21:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602594557' WHERE PBXPid=1 [2020-10-13 21:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602594547 [2020-10-13 21:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602594557,`PBXCuid`=1602594557 [2020-10-13 21:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602594857' WHERE PBXPid=1 [2020-10-13 21:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602594847 [2020-10-13 21:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602594857,`PBXCuid`=1602594857 [2020-10-13 21:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602595157' WHERE PBXPid=1 [2020-10-13 21:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602595147 [2020-10-13 21:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602595157,`PBXCuid`=1602595157 [2020-10-13 21:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602595457' WHERE PBXPid=1 [2020-10-13 21:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602595447 [2020-10-13 21:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602595457,`PBXCuid`=1602595457 [2020-10-13 21:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602595757' WHERE PBXPid=1 [2020-10-13 21:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602595747 [2020-10-13 21:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602595757,`PBXCuid`=1602595757 [2020-10-13 21:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602596057' WHERE PBXPid=1 [2020-10-13 21:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602596047 [2020-10-13 21:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602596057,`PBXCuid`=1602596057 [2020-10-13 21:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602596357' WHERE PBXPid=1 [2020-10-13 21:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602596347 [2020-10-13 21:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602596357,`PBXCuid`=1602596357 [2020-10-13 21:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602596657' WHERE PBXPid=1 [2020-10-13 21:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602596647 [2020-10-13 21:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602596657,`PBXCuid`=1602596657 [2020-10-13 21:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602596957' WHERE PBXPid=1 [2020-10-13 21:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602596947 [2020-10-13 21:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602596957,`PBXCuid`=1602596957 [2020-10-13 21:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602597257' WHERE PBXPid=1 [2020-10-13 21:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602597247 [2020-10-13 21:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602597257,`PBXCuid`=1602597257 [2020-10-13 21:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602597557' WHERE PBXPid=1 [2020-10-13 21:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602597547 [2020-10-13 21:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602597557,`PBXCuid`=1602597557 [2020-10-13 22:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602597857' WHERE PBXPid=1 [2020-10-13 22:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602597847 [2020-10-13 22:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602597857,`PBXCuid`=1602597857 [2020-10-13 22:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602598157' WHERE PBXPid=1 [2020-10-13 22:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602598147 [2020-10-13 22:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602598157,`PBXCuid`=1602598157 [2020-10-13 22:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602598457' WHERE PBXPid=1 [2020-10-13 22:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602598447 [2020-10-13 22:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602598457,`PBXCuid`=1602598457 [2020-10-13 22:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602598757' WHERE PBXPid=1 [2020-10-13 22:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602598747 [2020-10-13 22:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602598757,`PBXCuid`=1602598757 [2020-10-13 22:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602599057' WHERE PBXPid=1 [2020-10-13 22:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602599047 [2020-10-13 22:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602599057,`PBXCuid`=1602599057 [2020-10-13 22:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602599357' WHERE PBXPid=1 [2020-10-13 22:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602599347 [2020-10-13 22:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602599357,`PBXCuid`=1602599357 [2020-10-13 22:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602599657' WHERE PBXPid=1 [2020-10-13 22:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602599647 [2020-10-13 22:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602599657,`PBXCuid`=1602599657 [2020-10-13 22:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602599957' WHERE PBXPid=1 [2020-10-13 22:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602599947 [2020-10-13 22:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602599957,`PBXCuid`=1602599957 [2020-10-13 22:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602600257' WHERE PBXPid=1 [2020-10-13 22:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602600247 [2020-10-13 22:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602600257,`PBXCuid`=1602600257 [2020-10-13 22:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602600557' WHERE PBXPid=1 [2020-10-13 22:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602600547 [2020-10-13 22:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602600557,`PBXCuid`=1602600557 [2020-10-13 22:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602600857' WHERE PBXPid=1 [2020-10-13 22:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602600847 [2020-10-13 22:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602600857,`PBXCuid`=1602600857 [2020-10-13 22:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602601157' WHERE PBXPid=1 [2020-10-13 22:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602601147 [2020-10-13 22:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602601157,`PBXCuid`=1602601157 [2020-10-13 23:00:31] UPDATE sales SET login_ip='110.235.51.61', login_time='16026012317517' WHERE Sid='88' LIMIT 1 [2020-10-13 23:00:31] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-10-13 23:00:31',88,'110.235.51.61',1,2) [2020-10-13 23:00:31] UPDATE sales SET lastlogindate='2020-10-13 23:00:31' WHERE Sid='88' LIMIT 1 [2020-10-13 23:00:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:00:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:00:31] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:00:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:00:32] UPDATE sales SET lastlogindate='2020-10-13 23:00:32' WHERE Sid='88' LIMIT 1 [2020-10-13 23:00:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:00:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:00:32] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:00:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:00:34] UPDATE sales SET lastlogindate='2020-10-13 23:00:34' WHERE Sid='88' LIMIT 1 [2020-10-13 23:00:34] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:00:34] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:00:35] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:00:35] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:00:35] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:00:35] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:00:54] UPDATE sales SET lastlogindate='2020-10-13 23:00:54' WHERE Sid='88' LIMIT 1 [2020-10-13 23:00:54] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:00:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:00:54] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:00:55] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:00:55] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:00:55] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:01:04] UPDATE sales SET lastlogindate='2020-10-13 23:01:04' WHERE Sid='88' LIMIT 1 [2020-10-13 23:01:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:01:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:01:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:01:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:01:05] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:01:05] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:01:46] UPDATE sales SET lastlogindate='2020-10-13 23:01:46' WHERE Sid='88' LIMIT 1 [2020-10-13 23:01:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:01:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:01:46] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:01:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:01:47] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:01:47] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:03:16] UPDATE sales SET lastlogindate='2020-10-13 23:03:16' WHERE Sid='88' LIMIT 1 [2020-10-13 23:03:16] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:03:17] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:03:17] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:03:17] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:03:17] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:03:17] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:03:34] UPDATE sales SET lastlogindate='2020-10-13 23:03:34' WHERE Sid='88' LIMIT 1 [2020-10-13 23:03:34] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:03:34] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:03:34] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:03:34] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:03:34] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:03:34] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:04:11] UPDATE sales SET lastlogindate='2020-10-13 23:04:11' WHERE Sid='88' LIMIT 1 [2020-10-13 23:04:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:04:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:04:11] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:04:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:04:12] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:04:12] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:04:17] UPDATE pbxsetting SET lastupdatetimestamp='1602601457' WHERE PBXPid=1 [2020-10-13 23:04:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602601447 [2020-10-13 23:04:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602601457,`PBXCuid`=1602601457 [2020-10-13 23:04:38] UPDATE sales SET lastlogindate='2020-10-13 23:04:38' WHERE Sid='88' LIMIT 1 [2020-10-13 23:04:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:04:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:04:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:04:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:04:39] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:04:39] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:05:41] UPDATE sales SET lastlogindate='2020-10-13 23:05:41' WHERE Sid='88' LIMIT 1 [2020-10-13 23:05:41] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:05:41] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-10-13 23:05:41] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:05:42] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:05:42] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-10-13 23:05:42] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-10-13 23:09:17] UPDATE pbxsetting SET lastupdatetimestamp='1602601757' WHERE PBXPid=1 [2020-10-13 23:09:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602601747 [2020-10-13 23:09:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602601757,`PBXCuid`=1602601757 [2020-10-13 23:14:17] UPDATE pbxsetting SET lastupdatetimestamp='1602602057' WHERE PBXPid=1 [2020-10-13 23:14:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602602047 [2020-10-13 23:14:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602602057,`PBXCuid`=1602602057 [2020-10-13 23:19:17] UPDATE pbxsetting SET lastupdatetimestamp='1602602357' WHERE PBXPid=1 [2020-10-13 23:19:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602602347 [2020-10-13 23:19:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602602357,`PBXCuid`=1602602357 [2020-10-13 23:24:17] UPDATE pbxsetting SET lastupdatetimestamp='1602602657' WHERE PBXPid=1 [2020-10-13 23:24:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602602647 [2020-10-13 23:24:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602602657,`PBXCuid`=1602602657 [2020-10-13 23:29:17] UPDATE pbxsetting SET lastupdatetimestamp='1602602957' WHERE PBXPid=1 [2020-10-13 23:29:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602602947 [2020-10-13 23:29:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602602957,`PBXCuid`=1602602957 [2020-10-13 23:34:17] UPDATE pbxsetting SET lastupdatetimestamp='1602603257' WHERE PBXPid=1 [2020-10-13 23:34:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602603247 [2020-10-13 23:34:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602603257,`PBXCuid`=1602603257 [2020-10-13 23:39:17] UPDATE pbxsetting SET lastupdatetimestamp='1602603557' WHERE PBXPid=1 [2020-10-13 23:39:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602603547 [2020-10-13 23:39:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602603557,`PBXCuid`=1602603557 [2020-10-13 23:44:17] UPDATE pbxsetting SET lastupdatetimestamp='1602603857' WHERE PBXPid=1 [2020-10-13 23:44:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602603847 [2020-10-13 23:44:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602603857,`PBXCuid`=1602603857 [2020-10-13 23:49:17] UPDATE pbxsetting SET lastupdatetimestamp='1602604157' WHERE PBXPid=1 [2020-10-13 23:49:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602604147 [2020-10-13 23:49:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602604157,`PBXCuid`=1602604157 [2020-10-13 23:54:17] UPDATE pbxsetting SET lastupdatetimestamp='1602604457' WHERE PBXPid=1 [2020-10-13 23:54:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602604447 [2020-10-13 23:54:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602604457,`PBXCuid`=1602604457 [2020-10-13 23:59:17] UPDATE pbxsetting SET lastupdatetimestamp='1602604757' WHERE PBXPid=1 [2020-10-13 23:59:17] DELETE FROM `pbxconnecting` WHERE `PBXPid`=1 AND `PBXCtime`<1602604747 [2020-10-13 23:59:17] INSERT INTO `pbxconnecting` SET `PBXPid`=1,`PBXCtime`=1602604757,`PBXCuid`=1602604757