21/11/2024 06:29:12.3712 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 06:32:47.8592 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 06:32:47.9513 823 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 16 21/11/2024 06:32:51.0824 1408 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 06:42:02.6202 987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 06:43:06.0207 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 06:58:53.2744 1456 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 07:11:01.5260 927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 07:11:40.0488 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 07:25:01.3814 622 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/11/2024 07:31:51.7018 1095 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 21/11/2024 07:34:54.6663 1287 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 07:37:12.6708 643 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/11/2024 07:38:32.0661 1054 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 07:44:37.1409 621 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 07:44:58.7144 509 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-21 07:44:58' where subId = 198 21/11/2024 07:55:39.3011 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 07:57:40.0689 908 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 07:57:46.5863 903 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 08:00:39.2520 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:03:13.1091 2245 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/11/2024 08:05:54.5130 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:06:26.3313 1327 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:14',5,3,42101,0,50,-9,-450,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:14',5,3,42101,0,50,9,450,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:14',5,3,42101,0,100,-24,-2400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:14',5,3,42101,0,100,24,2400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:14',5,3,42101,0,200,-7,-1400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:14',5,3,42101,0,200,7,1400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:14',5,3,42101,0,500,-4,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:14',5,3,42101,0,500,4,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:14',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 21/11/2024 08:06:27.2219 602 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:21',5,3,42101,0,50,-11,-550,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:21',5,3,42101,0,100,-24,-2400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:21',5,3,42101,0,200,-7,-1400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:21',5,3,42101,0,500,-4,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-21 08:06:21',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 21/11/2024 08:09:16.5824 2088 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 08:15:57.1640 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:16:25.0347 1674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:17:08.1906 532 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 08:17:07','V',5571675171063820,2024,'2024-11-21 08:17:06','456152936100327005012999',2,2,2,'O','',0,'2024-11-21 08:17:07',1,'','',0) 21/11/2024 08:28:12.1484 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:40:29.3858 2192 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:44:44.0474 922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:46:45.3419 813 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 08:46:46.0433 515 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/11/2024 08:50:55.1273 1151 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:51:44.5925 1493 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:52:10.6529 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:53:05.9140 1373 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:54:44.7713 1057 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 08:54:43',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 21/11/2024 08:54:45.7269 953 ms. EXEC: update payInventory set invCreation = '2024-11-21 08:54:44',invModify = '2024-11-21 08:54:44',invUseId=0,invStatus='V' where invId = 220525 21/11/2024 08:54:48.1596 1706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 08:55:47.8957 957 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/11/2024 08:57:03.1592 592 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 08:57:02','V',4848286303185510,2024,'2024-11-21 08:57:01','456153160200327005012999',2,2,2,'O','',0,'2024-11-21 08:57:02',1,'','',0) 21/11/2024 08:57:14.1947 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 09:01:09.5035 676 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 09:07:37.4835 1194 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 09:07:47.7844 612 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 09:07:47','V',5095018976631680,2024,'2024-11-21 09:07:45','456153094400327005012999',2,2,2,'O','',0,'2024-11-21 09:07:47',1,'','',0) 21/11/2024 09:08:48.5115 657 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 09:08:51.6336 1025 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 09:08:57.1183 681 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 09:08:57.6827 565 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 21/11/2024 09:20:33.4104 623 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 09:20:32',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 21/11/2024 09:22:23.3228 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 09:36:21.6199 717 ms. OPEN: show columns from movRoutes where Field = 'rtsCarId' 21/11/2024 09:36:31.1784 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 09:37:26.6759 1996 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5715874022866310,4651604436534720,2024,'2024-11-21 09:37:24',' Date: 11/21/2024 9:37:24 AM Code: 456153213800327005012999 Entry Date: 11/21/2024 8:55:38 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400750384 ',0) 21/11/2024 09:41:39.3689 509 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-21 09:41:38','V',4879227090235670,2024,'2024-11-21 09:41:37','456153489700327001012999',1,2,1,'I','',1,0,1,'','0230004101216',10,0) 21/11/2024 09:41:39.9413 565 ms. EXECSCALAR: select count(parId) from tabParameters where parFiscalPrinter <> 0 and parStatus='V' nr: 0 21/11/2024 09:42:45.1184 923 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 09:51:04.8164 740 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-21 09:51:03' where traUID = 4998063893044880 and traStatus='V' and traEnabled=1 21/11/2024 09:51:28.1412 771 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 09:51:27','V',4933458151621500,2024,'2024-11-21 09:51:26','456153158900327005012999',2,2,2,'O','',0,'2024-11-21 09:51:27',1,'','',0) 21/11/2024 09:53:14.3281 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 09:53:49.3838 2288 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 09:55:32.0082 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 09:57:21.7505 778 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 09:59:08.9270 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:01:17.3799 740 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-21 10:01:16',0,'V',5309726172339200,5056905512362380,2024,'2024-11-21 10:01:16',18,1,0,4,'2024-11-21 10:16:16','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 21/11/2024 10:05:46.2067 1192 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:06:52.2004 509 ms. EXEC: update abbCards set carLastDate = '2024-11-21 10:06:51',carLastDirection='I' where carStatus='V' and carId = 25 21/11/2024 10:06:56.3742 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 10:07:50.6119 670 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/11/2024 10:10:40.8711 3145 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-21 10:10:37','V',5574888301971550,2024,'2024-11-21 10:10:37','456153663700327005012999',1,2,16,'I','',1,0,1,'','0230003957466',21,0) 21/11/2024 10:10:40.8721 3283 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-21 10:10:37' where subId = 18 21/11/2024 10:11:06.5635 570 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-21 10:11:05',0,'V',5014735495710170,5042443252512320,2024,'2024-11-21 10:11:05',3,1,0,4,'2024-11-21 10:26:05','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 21/11/2024 10:11:09.7546 2380 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-21 10:11:07',0,0,'V',5040074838634410,5042443252512320,2024,'2024-11-21 10:11:07',3,'KES',-1,50,-50,'N',''); 21/11/2024 10:13:19.2923 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 10:13:20.0938 990 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 10:13:19','V',5177036555577030,2024,'2024-11-21 10:13:14','456153311300327005012999',2,2,2,'O','',0,'2024-11-21 10:13:19',1,'','',0) 21/11/2024 10:13:20.7493 590 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 10:13:23.1479 4085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:13:35.3872 878 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:17:10.5277 3126 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:21:19.1179 1047 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 10:21:18','V',5245932913351590,2024,'2024-11-21 10:21:15','456153544300327005012999',2,2,2,'O','',0,'2024-11-21 10:21:18',1,'','',0) 21/11/2024 10:21:48.7159 1215 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-21 10:21:47',17,12,'2024-11-21 10:21:47','456153583900327005012999','Pagato (Contanti ) Biglietto ') 21/11/2024 10:26:14.6919 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:26:58.0942 1217 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 10:28:10.2060 3278 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 10:28:37.0031 1593 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 10:29:54.3295 2127 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:31:04.0296 903 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-21 10:31:03' where payTraUID = 4874236135231330 and payStatus='V' and payEnabled=1 21/11/2024 10:33:01.7172 2033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:35:15.5498 5426 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:38:45.0495 775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:39:56.8021 1061 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 10:42:17.3361 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:42:19.7197 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:44:12.7892 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 10:44:26.0442 3545 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/11/2024 10:44:26.1643 912 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/11/2024 10:45:01.8795 1384 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 10:48:42.2355 1348 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-21 10:48:40',0,'V',4954351357782720,4877120933803340,2024,'2024-11-21 10:48:40',18,1,0,4,'2024-11-21 11:03:40','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 21/11/2024 10:49:32.2464 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:01:57.1823 1634 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 11:02:24.3387 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:03:59.9894 1064 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-21 11:03:58' where payTraUID = 5672406331831670 and payStatus='V' and payEnabled=1 21/11/2024 11:16:03.4659 743 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-21 11:16:02' where traUID = 4718306534444520 and traStatus='V' and traEnabled=1 21/11/2024 11:18:41.9286 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:18:56.4154 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 11:19:00.2590 1112 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-21 11:18:59',0,16,'2024-11-21 11:18:59','','Unauthorized Transit Entry 2') 21/11/2024 11:20:09.7570 1754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:20:15.0916 14318 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 21/11/2024 11:24:06.8814 518 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 21/11/2024 11:24:18.6174 797 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 11:24:35.5598 639 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 11:24:34','V',5559842862302970,2024,'2024-11-21 11:24:34','456154107400327005012999',1,2,16,'I','',1,0,1,'','',4) 21/11/2024 11:27:08.6964 4076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:27:34.5529 760 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-21 11:27:33','0230004098588',0,0,5104548077640640,183,'0000-00-00 00:00:00','0000-00-00 00:00:00') 21/11/2024 11:27:48.2632 672 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-21 11:27:47',0,'V',4910392184785520,5047871433746480,2024,'2024-11-21 11:27:47',18,1,0,4,'2024-11-21 11:42:47','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 21/11/2024 11:27:49.9013 1074 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/11/2024 11:28:06.1303 896 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 11:28:12.2935 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:31:39.6878 781 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 11:31:46.3123 978 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 11:33:36.8250 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:36:22.0788 1252 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-21 11:36:20' where traUID = 5574888301971550 and traStatus='V' and traEnabled=1 21/11/2024 11:37:25.6759 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:37:35.1573 641 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 11:38:27.1484 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 11:40:28.7157 652 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 11:41:38.2878 1102 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 11:43:45.7610 1411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:48:55.0442 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:49:14.4154 1436 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:52:44.4485 616 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 373629 else acvFstPayId end),acvLstPayId = 373629 where acvSftId = 829 and acvCodeId = 3 21/11/2024 11:52:45.1329 684 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 16 21/11/2024 11:52:50.7117 670 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 11:52:55.4469 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:53:38.1208 2808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:54:02.1080 1341 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:58:33.6727 612 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 11:58:51.4377 1089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 11:59:12.2928 1389 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:01:53.2657 1026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:04:03.3167 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:04:04.1723 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:04:13.6667 858 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:04:28.8920 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:05:52.5666 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 12:06:53.5249 765 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 12:06:52',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 21/11/2024 12:08:58.6926 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:13:50.1217 2009 ms. EXEC: update payReceipt set recCreation = '2024-11-21 12:13:48',recModify = '2024-11-21 12:13:48',recUseId=0,recStatus='V' where recId = 324619 21/11/2024 12:15:05.2065 855 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 12:15:04',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 21/11/2024 12:16:00.7451 1073 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-21 12:15:59',0,'V',5663136686796100,4991758961928530,2024,'2024-11-21 12:15:59',18,1,0,4,'2024-11-21 12:30:59','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 21/11/2024 12:16:01.4756 671 ms. EXEC: update tabTerminalReceipt set trcProgressive = 50413, trcLastPrinted = '2400750413', trcLastDate = '2024-11-21 12:16:00' where trcStatus='V' and trcTerId = 18 21/11/2024 12:16:23.7317 669 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-21 12:16:22' where traUID = 5101788149118310 and traStatus='V' and traEnabled=1 21/11/2024 12:17:00.8268 734 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-21 12:16:59' where traUID = 5488744660617540 and traStatus='V' and traEnabled=1 21/11/2024 12:18:12.9585 927 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-21 12:18:12',4,6,'2024-11-21 12:18:12','456154197200327005012999','Payed (Credit Card ) Ticket ') 21/11/2024 12:18:15.3862 2316 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 373648 else acvFstPayId end),acvLstPayId = 373648 where acvSftId = 818 and acvCodeId = 3 21/11/2024 12:18:19.5670 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:18:28.0988 1768 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 12:18:28.8313 723 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-21 12:18:28' where payTraUID = 4991758961928530 and payStatus='V' and payEnabled=1 21/11/2024 12:19:11.6923 1712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:20:17.7640 2112 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:21:04.2514 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:23:42.6676 1776 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:24:33.3649 1909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:24:37.2906 2521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:24:59.4606 629 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 12:25:11.4927 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1 ms.) 21/11/2024 12:26:58.9384 1008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:27:38.2748 2544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:27:58.9136 1478 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 12:28:08.7752 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:28:49.0881 1263 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:31:15.0795 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 12:32:50.9094 611 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 12:32:52.5065 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 12 ms.) 21/11/2024 12:34:27.5149 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:34:40.3935 3145 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 12:35:28.6727 2435 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:35:31.8668 1593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:35:35.3301 938 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/11/2024 12:35:38.1660 1641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:35:43.9289 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:35:48.5249 1572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:36:00.9232 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:36:04.4346 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:36:07.3795 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:36:10.2004 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:36:19.3045 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:36:21.1507 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:36:55.4526 2356 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:37:12.7491 1239 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:37:22.3476 1417 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:37:45.8612 2093 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/11/2024 12:38:07.3015 4565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:38:26.7826 1427 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:39:16.7889 1090 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:40:42.1899 1375 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/11/2024 12:40:59.0061 1300 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-21 12:40:57' where subId = 198 21/11/2024 12:41:39.9965 3058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:41:57.9985 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:42:06.0899 1972 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:42:41.9689 908 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:42:56.7417 2973 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:43:37.7681 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:48:39.8818 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 12:48:50.3748 2246 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 12:48:53.7120 2638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:50:40.3872 615 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/11/2024 12:52:37.1782 1044 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/11/2024 12:53:50.1809 903 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:54:02.5212 1015 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 12:54:24.3337 522 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-21 12:54:23','V',5113712365393020,2024,'2024-11-21 12:54:23','456154646300327005012999',1,2,16,'I','',1,0,1,'','0230003944064',14,0) 21/11/2024 12:55:13.9439 979 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/11/2024 13:00:59.1073 1979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:01:01.7921 1399 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:01:58.2048 1289 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 13:05:29.3028 542 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-21 13:05:28','V',5252409382035260,2024,'2024-11-21 13:05:26','456154665000327005012999',2,2,2,'O','',0,'2024-11-21 13:05:28',1,'','0230003944081',15,0) 21/11/2024 13:05:48.6307 553 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-50,5),subLastDebit = '2024-11-21 13:05:48' where subId = 210 21/11/2024 13:05:49.5243 651 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-21 13:05:48',0,'V',4954316010248910,5666386370827570,2024,'2024-11-21 13:05:48',2,1,0,-1,'2024-11-21 14:05:48','S','KES',50,50,0,'','','',3,50,0,0,'',0,0) 21/11/2024 13:06:07.6704 1539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:06:41.1217 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:07:08.9233 874 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/11/2024 13:08:19.5655 1153 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:09:46.5586 947 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 13:13:24.4922 1751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:17:31.6463 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:25:36.9402 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:28:19.3515 1370 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:28:38.7225 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:29:41.3913 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:29:58.7519 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:30:23.8406 518 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/11/2024 13:31:48.1909 1588 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 13:32:18.5802 1121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:32:54.7073 691 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 13:33:12.9935 1608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:34:03.2991 1671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:35:55.6461 834 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 13:38:21.4474 1401 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 13:40:15.7097 4846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:41:02.4159 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:41:44.5460 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 13:41:56.7082 1021 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-21 13:41:54',0,'V',4806638752905540,5484268202228590,2024,'2024-11-21 13:41:54',3,1,0,4,'2024-11-21 13:56:54','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 21/11/2024 13:41:57.3366 579 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5484268202228590,4806638752905540,2024,'2024-11-21 13:41:56','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/21/2024 1:06:04 PM Date : 11/21/2024 1:41:54 PM Code : 456154716400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 21/11/2024 13:45:12.1727 678 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 13:45:11','V',5538964441622190,2024,'2024-11-21 13:45:09','456154881400327005012999',2,2,2,'O','',0,'2024-11-21 13:45:11',1,'','',0) 21/11/2024 13:45:17.1560 893 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 13:45:30.2457 1532 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 13:46:01.6987 1633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:48:51.7583 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:49:46.9131 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:51:02.8048 667 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-21 13:51:02',0,16,'2024-11-21 13:51:02','','Unauthorized Transit Entry 2') 21/11/2024 13:51:21.2221 963 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5204574904858630,5654499890546520,2024,'2024-11-21 13:51:20','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/21/2024 1:30:15 PM Date : 11/21/2024 1:51:18 PM Code : 456154861500327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 21/11/2024 13:53:37.1508 4751 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/11/2024 13:53:48.4654 684 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 13:53:47','V',5006329000395790,2024,'2024-11-21 13:53:47','456154861500327001012999',2,2,2,'O','',0,'2024-11-21 13:53:47',1,'','',0) 21/11/2024 13:53:55.4260 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 13:54:04.0038 2246 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:55:22.4401 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 13:55:52.3321 4269 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 21/11/2024 14:02:50.7203 2216 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 14:03:05.9574 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:05:43.4205 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:05:43.4596 2013 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 14:09:14.5965 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:09:16.5148 1029 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:09:23.8757 1279 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:09:27.5852 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:09:32.1912 1247 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:09:37.5418 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:11:13.4258 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:11:44.5846 713 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 14:11:58.1967 3539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:12:10.8762 1949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:12:59.3245 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:12:59.3485 744 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/11/2024 14:13:07.3058 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:16:24.8577 1448 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 14:16:24.9608 1183 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 14:20:38.9003 807 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 14:20:38','V',4957470828198480,2024,'2024-11-21 14:20:37','456155056800327005012999',2,2,2,'O','',0,'2024-11-21 14:20:38',1,'','',0) 21/11/2024 14:22:05.6092 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:22:07.5795 1713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:22:32.3270 642 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 14:23:04.6716 570 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 14:23:03',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 14:23:03',3,42101,0,100,-5,-500,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-5,5),curAmount=round(curAmount+-500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 14:23:03',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 21/11/2024 14:23:17.5832 586 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 14:26:29.7946 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:26:32.2382 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:26:57.6332 1493 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:28:01.4277 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:28:19.9251 1792 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456154545700327001012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 21/11/2024 14:29:10.1176 859 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-21 14:29:09' where traUID = 5318848887778930 and traStatus='V' and traEnabled=1 21/11/2024 14:29:26.9098 564 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/11/2024 14:32:37.9863 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:35:29.3878 643 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 14:37:45.8118 736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:38:19.9717 1095 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 14:38:18','V',5737311293253080,2024,'2024-11-21 14:38:17','456154934900327005012999',2,2,2,'O','',0,'2024-11-21 14:38:18',1,'','',0) 21/11/2024 14:38:23.2508 770 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 14:40:11.1979 1409 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 14:40:09','V',4830383548519830,2024,'2024-11-21 14:40:08','456154486300327005012999',2,2,2,'O','',0,'2024-11-21 14:40:09',1,'','',0) 21/11/2024 14:43:45.0227 860 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-21 14:43:44','0750009518612',0,0,5389162733111030,99,'0000-00-00 00:00:00','0000-00-00 00:00:00') 21/11/2024 14:43:46.5557 741 ms. EXEC: update abbCards set carLastDate = '2024-11-21 14:43:45',carLastDirection='O' where carStatus='V' and carId = 99 21/11/2024 14:48:03.4713 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:49:15.6004 1710 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-21 14:49:13' where subId = 16 21/11/2024 14:51:37.7644 992 ms. EXEC: update payReceipt set recCreation = '2024-11-21 14:51:36',recModify = '2024-11-21 14:51:36',recUseId=0,recStatus='V' where recId = 324687 21/11/2024 14:52:01.2571 1371 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5275622384161150,5416082038669360,2024,'2024-11-21 14:51:59',' Date: 11/21/2024 2:49:08 PM Code: 456155013100327005012999 Entry Date: 11/21/2024 1:55:31 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400416484 ',0) 21/11/2024 14:52:32.2948 632 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 21/11/2024 14:54:36.3747 731 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/11/2024 14:54:36.3927 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 14:55:31.4124 1164 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 14:56:21.7951 529 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4615229566096860,5331678103196940,2024,'2024-11-21 14:56:21','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/21/2024 2:38:15 PM Date : 11/21/2024 2:56:19 PM Code : 456155269500327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 21/11/2024 15:00:24.3391 579 ms. EXEC: update abbCards set carLastDate = '2024-11-21 15:00:23',carLastDirection='I' where carStatus='V' and carId = 190 21/11/2024 15:00:28.0145 2443 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 15:04:38.8091 763 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 15:04:37',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 21/11/2024 15:06:32.1838 765 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 15:06:31','V',5064460133995050,2024,'2024-11-21 15:06:29','456155129000327005012999',2,2,2,'O','',0,'2024-11-21 15:06:31',1,'','',0) 21/11/2024 15:06:32.8302 643 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 15:06:37.2392 716 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 15:08:40.8758 529 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-21 15:08:40',0,'V',5589323518171920,5652076918894860,2024,'2024-11-21 15:08:40',18,1,0,4,'2024-11-21 15:23:40','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 21/11/2024 15:09:10.3244 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 15:09:48.0677 641 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 15:10:01.1444 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 15:12:33.2410 1970 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 15:13:27.2111 3230 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 15:16:00.9038 946 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 15:16:09.4655 730 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/11/2024 15:16:09.6226 849 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/11/2024 15:17:20.1007 869 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 15:17:19',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 21/11/2024 15:18:11.0377 529 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-21 15:18:10',0,16,'2024-11-21 15:18:10','','Unauthorized Transit Entry 2') 21/11/2024 15:18:11.2388 756 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/11/2024 15:19:07.7896 540 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 15:19:08.4831 675 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 15:19:56.7914 2564 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 15:29:10.1160 615 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/11/2024 15:29:43.9296 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 15:33:25.6718 553 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-21 15:33:25',0,'V',4947628845577720,5666382911132720,2024,'2024-11-21 15:33:25',2,1,0,-1,'2024-11-21 16:33:25','S','KES',0,0,0,'','','',3,0,0) 21/11/2024 15:33:31.5888 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 15:34:05.5264 1046 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-21 15:34:04' where traUID = 5754059640198690 and traStatus='V' and traEnabled=1 21/11/2024 15:40:45.5726 520 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16490, trcLastPrinted = '2400416490', trcLastDate = '2024-11-21 15:40:45' where trcStatus='V' and trcTerId = 4 21/11/2024 15:44:06.6960 550 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 15:45:25.5457 1155 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/11/2024 15:46:47.6365 1937 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-21 15:46:45','V',5433172089561650,2024,'2024-11-21 15:46:44','456155269600327005029999',2,2,2,'O','',0,'2024-11-21 15:46:45',1,'','0560008304916',190,0) 21/11/2024 15:46:48.6872 886 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 15:52:26.7610 528 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 15:57:50.2512 1879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 15:58:10.3496 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 15:58:10.6868 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 15:59:10.1946 544 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 16:00:53.3505 580 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 16:02:29.1405 625 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-21 16:02:28',0,'V',4619166998663620,5481406125713530,2024,'2024-11-21 16:02:28',18,1,0,4,'2024-11-21 16:17:28','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 21/11/2024 16:07:10.2914 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:08:50.9486 1632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:11:49.0186 1551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:11:49.0836 1418 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 16:13:30.4203 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:13:53.2246 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:14:41.8320 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:16:12.1464 606 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 16:16:12.7868 553 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/11/2024 16:16:44.4299 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:17:21.3756 556 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-21 16:17:20',0,16,'2024-11-21 16:17:20','','Unauthorized Transit Entry 2') 21/11/2024 16:19:35.7034 1001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:23:50.0173 1748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:25:40.3790 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:26:12.4405 1297 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-21 16:26:11',0,'V',4978558363967390,5614602987292150,2024,'2024-11-21 16:26:11',2,1,0,-1,'2024-11-21 17:26:11','S','KES',0,0,0,'','','',3,0,0) 21/11/2024 16:26:13.9435 709 ms. EXEC: update abbCards set carLastDate = '2024-11-21 16:26:13',carLastDirection='O' where carStatus='V' and carId = 66 21/11/2024 16:32:34.2056 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:32:37.6288 1260 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:34:48.3822 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:39:44.9895 2859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:41:01.5186 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 16:49:15.3745 1096 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 16:58:56.9300 543 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 17:09:41.1713 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:10:24.0039 1310 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:13:19.4781 1633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:15:57.6688 2144 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:16:19.9397 1409 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:16:57.2807 2894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:21:03.7604 1219 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:22:47.7048 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:25:40.8215 1134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:34:38.6309 1423 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 17:41:54.1198 1453 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:44:29.0983 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:51:29.9095 1211 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 17:55:11.0893 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 18:07:18.1714 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 18:07:26.4519 3295 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 18:07:32.7351 1064 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/11/2024 18:08:29.0378 1215 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 18:12:42.3742 527 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 18:28:59.8997 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 18:29:46.5579 1670 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/11/2024 18:33:57.7318 1172 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 18:34:27.2735 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 18:34:27.2795 567 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/11/2024 18:36:27.0466 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 18:38:21.1148 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 18:48:00.7751 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 18:51:11.4855 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 18:52:08.6677 1274 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 21/11/2024 18:59:23.7274 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 19:06:11.0547 866 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5501980226195810,5069814232556100,2024,'2024-11-21 19:06:10','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/21/2024 6:15:03 PM Date : 11/21/2024 7:06:07 PM Code : 456156570300327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 21/11/2024 19:13:25.5974 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 19:14:07.8376 610 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-21 19:14:07' where subId = 204 21/11/2024 19:14:08.9724 505 ms. EXEC: update abbCards set carLastDate = '2024-11-21 19:14:08',carLastDirection='O' where carStatus='V' and carId = 188 21/11/2024 19:21:25.2211 1579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 19:25:03.7362 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 19:26:22.0315 664 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 19:26:21',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 21/11/2024 19:28:14.8930 521 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/11/2024 19:37:10.2569 507 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-21 19:37:09' where traUID = 4681987398517740 and traStatus='V' and traEnabled=1 21/11/2024 19:39:08.3208 574 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 19:39:09.4226 605 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-21 19:39:08' where traUID = 5338940703158040 and traStatus='V' and traEnabled=1 21/11/2024 19:40:38.1409 1160 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 19:44:01.8241 907 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-21 19:44:00' where payTraUID = 5430700786841860 and payStatus='V' and payEnabled=1 21/11/2024 19:45:51.3013 553 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 19:50:07.1783 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 19:58:54.8882 1645 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 20:00:47.6716 2150 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/11/2024 20:14:40.8608 727 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 20:14:44.9255 538 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 20:14:44',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 20:14:44',3,42101,0,100,-4,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-4,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 21/11/2024 20:18:08.2485 2051 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:18:41.9820 603 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 20:24:10.7369 1007 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/11/2024 20:27:44.1036 2522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:27:44.1036 1527 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 20:27:49.3241 2480 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:27:53.6510 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:27:58.2540 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:28:11.7000 585 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/11/2024 20:28:12.2544 7441 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:28:46.8305 1725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:31:37.9169 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:36:43.5453 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 20:39:14.0269 3126 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:39:19.3115 897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:40:09.8353 873 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-21 20:40:08',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 21/11/2024 20:40:26.2123 573 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-21 20:40:25' where subId = 198 21/11/2024 20:41:29.1464 878 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:41:43.7161 9740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:41:55.5960 8056 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/11/2024 20:41:55.5970 10565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:41:58.9963 1423 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:42:00.7915 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 20:43:35.2427 591 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-21 20:43:34' where payTraUID = 4690095296584130 and payStatus='V' and payEnabled=1 21/11/2024 20:43:36.2303 686 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '456157344200327005012999' 21/11/2024 20:53:16.2341 657 ms. EXEC: update abbCards set carLastDate = '2024-11-21 20:53:15',carLastDirection='O' where carStatus='V' and carId = 151 21/11/2024 20:54:34.4444 988 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 20:56:54.7863 2024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:05:06.3360 2344 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 21:05:57.7334 2767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:08:04.5742 933 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:09:16.7935 619 ms. EXEC: update paycash set casCreation = '2024-11-21 21:09:16',casModify = '2024-11-21 21:09:16',casUseId=0,casStatus='V' where casId = 196148 21/11/2024 21:09:19.7364 952 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:10:15.3336 2142 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:10:34.4364 2558 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-21 21:10:31' where traUID = 5305046847657750 and traStatus='V' and traEnabled=1 21/11/2024 21:10:58.9308 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:11:06.3827 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:15:40.0622 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:25:13.8209 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:25:38.0791 894 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-21 21:25:37' where payTraUID = 5396229582166120 and payStatus='V' and payEnabled=1 21/11/2024 21:30:02.4900 856 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-21 21:27:42',12,'V',4890341713612980,5649137610777390,2024,'2024-11-21 21:27:42',17,1,0,4,'2024-11-21 21:42:42','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 21/11/2024 21:30:03.4627 540 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 373863 else acvFstPayId end),acvLstPayId = 373863 where acvSftId = 829 and acvCodeId = 3 21/11/2024 21:31:20.3861 668 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-21 21:31:19' where payTraUID = 4641141265875780 and payStatus='V' and payEnabled=1 21/11/2024 21:31:43.8838 577 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 21:31:43','V',4824959356701230,2024,'2024-11-21 21:31:42','456157000400327005012999',2,2,2,'O','',0,'2024-11-21 21:31:43',1,'','',0) 21/11/2024 21:34:12.2301 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:39:25.6337 898 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 21:45:38.0048 1632 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 21:45:36','V',5061947292607780,2024,'2024-11-21 21:45:36','456157833600327005012999',1,2,16,'I','',1,0,1,'','',4) 21/11/2024 21:49:33.1040 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:49:40.9593 5612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:49:44.8569 3563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:49:52.8362 5294 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:49:56.3996 3360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:50:02.7598 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:50:11.8369 6079 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:50:27.4223 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:50:41.6128 8158 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:51:51.1343 503 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5532282814640130,4742581610940070,2024,'2024-11-21 21:51:50','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/21/2024 9:31:49 PM Date : 11/21/2024 9:51:49 PM Code : 456157750900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 500.00 KES Coin changed : 0.00 KES Note changed : 450.00 KES',0) 21/11/2024 21:51:53.4659 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:52:12.7097 1632 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/11/2024 21:52:12.7097 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:52:12.7097 515 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 21/11/2024 21:52:14.4569 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:52:15.7488 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:52:21.2455 1429 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:52:22.3872 939 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:52:49.4483 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:52:51.6818 2030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:52:52.4903 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:52:53.9823 1289 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:52:57.3286 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:53:02.6051 2374 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 21:53:33.0495 519 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-21 21:53:32','V',4830151388955400,2024,'2024-11-21 21:53:32','456156810500327005012999',2,2,2,'O','',0,'2024-11-21 21:53:32',1,'','',0) 21/11/2024 22:02:17.4042 602 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/11/2024 22:06:11.9331 1221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:20:07.9174 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 22:22:48.9922 615 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-21 22:22:48' where payTraUID = 5197784333282810 and payStatus='V' and payEnabled=1 21/11/2024 22:24:24.4831 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 22:24:25.7509 951 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-21 22:24:24',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 21/11/2024 22:25:54.3312 919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:26:08.6968 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:32:35.4276 1122 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/11/2024 22:32:35.6768 1782 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 21/11/2024 22:32:38.2785 1134 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/11/2024 22:34:20.0096 1426 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/11/2024 22:34:20.6820 669 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-21 22:34:20' where payTraUID = 5533167170859230 and payStatus='V' and payEnabled=1 21/11/2024 22:41:00.7708 731 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/11/2024 22:41:08.9973 1895 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 22:42:50.3331 7855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:42:54.6319 2345 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:43:01.5866 6617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:43:09.1186 6304 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:43:09.1196 5529 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/11/2024 22:43:17.2991 5008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:43:18.4859 5167 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/11/2024 22:43:20.0589 1572 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/11/2024 22:43:27.2818 1739 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/11/2024 22:43:27.3338 4542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:43:38.2641 3616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:44:50.5805 2415 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/11/2024 22:44:59.4294 5889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:46:09.8685 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:47:09.1101 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/11/2024 22:53:42.3332 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 22:54:42.2272 1059 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/11/2024 22:58:44.5073 1250 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/11/2024 23:01:04.0316 816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:01:22.1327 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:11:02.9252 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:13:23.6463 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:16:01.1457 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:17:05.5268 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:21:56.6345 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:25:15.2144 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:40:54.2778 2033 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:41:21.5761 2429 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:43:38.6148 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:46:42.7961 1997 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/11/2024 23:51:13.8315 1143 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1