10/12/2024 00:12:48.6592 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 00:15:02.3162 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 00:45:13.6656 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 00:50:50.8276 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 01:10:38.8295 506 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-10 01:10:38' where payTraUID = 5389462608296680 and payStatus='V' and payEnabled=1 10/12/2024 01:12:49.2743 806 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 01:37:40.6914 2371 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 01:50:30.8799 636 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 01:53:08.8593 972 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 02:09:03.4234 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 02:20:09.9792 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 02:22:02.5279 816 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 02:47:26.3719 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 03:10:50.0879 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 03:16:38.1843 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 03:25:47.8604 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 03:34:01.6168 915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 03:44:53.5967 710 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/12/2024 03:47:34.2389 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 03:48:05.7341 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 04:29:11.2660 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 04:43:36.2023 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 04:49:43.1644 791 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 04:49:51.1508 723 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-12-10 04:49:50',0,'V',4958235745418030,5382413240681870,2024,'2024-12-10 04:49:50',18,1,0,4,'2024-12-10 05:04:50','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/12/2024 05:06:43.9626 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 05:22:39.5250 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 05:44:29.3268 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 06:15:22.5085 977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 06:24:04.3047 929 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-12-10 06:24:03','V',4828125289957250,2024,'2024-12-10 06:24:02','456342213900327005012999',2,2,2,'O','',0,'2024-12-10 06:24:03',1,'','',0) 10/12/2024 06:26:02.2411 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 06:30:23.7492 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 06:35:49.1173 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 06:41:01.5626 566 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 06:45:12.6887 1222 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 06:49:37.5030 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:08:45.8521 1669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:08:57.5109 978 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:09:37.1366 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:13:45.6439 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:17:41.7839 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 07:19:37.0095 1369 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:25:34.4541 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:27:46.5020 635 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/12/2024 07:33:25.2521 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:33:52.2773 615 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/12/2024 07:38:42.6838 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:39:21.8392 890 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/12/2024 07:40:19.0647 552 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-12-10 07:40:18','V',5682817635625620,2024,'2024-12-10 07:40:17','456342761700327005012999',1,2,16,'I','',1,0,1,'','0560008421760',192,0) 10/12/2024 07:41:50.1090 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:44:07.9358 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 07:54:14.9655 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 08:00:11.1543 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 08:00:33.5143 1192 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/12/2024 08:02:04.9229 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 08:02:59.5587 701 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/12/2024 08:06:33.3726 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 08:12:13.0123 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 08:17:12.2187 822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 08:20:01.5237 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 08:22:16.1683 678 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 08:22:15' where traUID = 5155844160208240 and traStatus='V' and traEnabled=1 10/12/2024 08:22:54.0268 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 08:23:17.2415 517 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/12/2024 08:23:17.9109 933 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 08:23:30.5024 661 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-12-10 08:23:29','V',4751785511513140,2024,'2024-12-10 08:23:27','456342850200327005012999',2,2,2,'O','',0,'2024-12-10 08:23:29',1,'','',0) 10/12/2024 08:27:18.5049 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 08:28:20.9449 557 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/12/2024 08:30:48.6294 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 08:31:09.8226 1640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 08:58:21.3811 701 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:00:27.9433 887 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-10 09:00:27','0230003939927',0,0,5567720390218090,164,'0000-00-00 00:00:00','0000-00-00 00:00:00') 10/12/2024 09:07:11.2448 813 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:07:38.8524 1548 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:07:37',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-12-10 09:07:37',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 10/12/2024 09:10:25.1844 632 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:11:19.6270 709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:12:01.7154 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 09:12:04.6944 1911 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-12-10 09:12:02','V',4807446662802210,2024,'2024-12-10 09:12:01','456343137800327005012999',2,2,2,'O','',0,'2024-12-10 09:12:02',1,'','',0) 10/12/2024 09:12:08.8832 703 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:18:34.3367 1535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 09:24:34.4542 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 09:25:52.9380 789 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:26:08.8217 762 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/12/2024 09:27:04.6052 706 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456343402300327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 10/12/2024 09:28:27.6902 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:33:52.0466 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:39:57.2915 684 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:43:18.2377 794 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/12/2024 09:43:19.1984 958 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-10 09:43:18' where payTraUID = 4953134327352380 and payStatus='V' and payEnabled=1 10/12/2024 09:43:23.4513 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:44:34.9274 512 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-12-10 09:44:34','V',5396954126668230,2024,'2024-12-10 09:44:33','456343507300327005012999',1,2,16,'I','',1,0,1,'','',4) 10/12/2024 09:47:51.1725 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 09:47:52.0901 769 ms. EXEC: update payCurInventory set curQuantity=round(curQuantity+10,8),curAmount=round(curAmount+2000,8) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N' 10/12/2024 09:47:52.8796 789 ms. EXEC: update payCurInventory set curQuantity=round(curQuantity+3,8),curAmount=round(curAmount+1500,8) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 500 and curType = 'N' 10/12/2024 09:47:53.6131 605 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:47:41',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-12-10 09:47:41',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-12-10 09:47:41',5,3,42101,0,100,-31,-3100,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:47:41',5,3,42101,0,100,31,3100,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:47:41',5,3,42101,0,200,-10,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:47:41',5,3,42101,0,200,10,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:47:41',5,3,42101,0,500,-3,-1500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:47:41',5,3,42101,0,500,3,1500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:47:41',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:47:41',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:47:41',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 10/12/2024 09:51:09.2769 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 09:52:29.9672 1130 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:52:24',5,3,42101,0,50,10,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+10,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-10 09:52:24',5,3,42101,0,100,5,500,1,'I','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'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 10/12/2024 09:59:50.9391 532 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 09:59:50' where traUID = 4794381951227810 and traStatus='V' and traEnabled=1 10/12/2024 09:59:56.5919 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 10:03:12.9761 899 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-12-10 09:59:58',1,'V',4887813404422450,4668104341476470,2024,'2024-12-10 09:59:58',4,1,0,4,'2024-12-10 10:14:58','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/12/2024 10:11:38.8667 1157 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-12-10 10:08:25',1,'V',5068985643388410,5396954126668230,2024,'2024-12-10 10:08:25',4,1,0,4,'2024-12-10 10:23:25','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/12/2024 10:21:50.5155 766 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/12/2024 10:22:08.5116 1612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 10:23:47.9566 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 10:32:34.6114 593 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17543, trcLastPrinted = '2400417543', trcLastDate = '2024-12-10 10:32:34' where trcStatus='V' and trcTerId = 4 10/12/2024 10:33:20.9546 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 10:33:33.4190 1056 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-12-10 10:33:32',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 10/12/2024 10:40:22.9477 814 ms. EXEC: update paycash set casCreation = '2024-12-10 10:40:22',casModify = '2024-12-10 10:40:22',casUseId=0,casStatus='V' where casId = 199209 10/12/2024 10:42:24.2444 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 10:45:56.8505 675 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/12/2024 10:45:57.7371 801 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 10:46:02.1431 893 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17544, trcLastPrinted = '2400417544', trcLastDate = '2024-12-10 10:46:01' where trcStatus='V' and trcTerId = 4 10/12/2024 10:48:05.9024 796 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 10:48:10.6616 618 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-12-10 10:48:09',0,'V',5360377195251970,4788030293271270,2024,'2024-12-10 10:48:09',18,1,0,4,'2024-12-10 11:03:09','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/12/2024 10:50:01.6993 593 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/12/2024 10:51:54.6454 783 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 10:57:35.7040 535 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 10/12/2024 10:57:36.1343 966 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 10:57:36.3915 650 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-12-10 09:57:35') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-10 10:57:35' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-10 10:57:35' and (resAreId = 1 or resAreId <= 0) nr: 0 10/12/2024 10:57:36.7997 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 11:03:32.1670 599 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-12-10 11:03:31','V',5677388559055430,2024,'2024-12-10 11:03:31','456343981100327005012999',1,2,16,'I','',1,0,1,'','',4) 10/12/2024 11:09:04.9881 527 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/12/2024 11:09:05.0211 5869 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 = 1 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 10/12/2024 11:10:17.6220 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 11:10:48.1155 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 11:12:58.3722 6131 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 10/12/2024 11:14:27.4682 866 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 11:16:17.6534 607 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/12/2024 11:17:54.6196 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 11:18:38.3871 1331 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-12-10 11:15:59',1,'V',4756953362870680,4615306778613230,2024,'2024-12-10 11:15:59',17,1,0,4,'2024-12-10 11:30:59','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/12/2024 11:18:53.7514 507 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-12-10 11:18:51',0,'V',5695220721313240,4707747910297250,2024,'2024-12-10 11:18:51',3,1,0,4,'2024-12-10 11:33:51','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 10/12/2024 11:21:25.1133 1325 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 11:23:41.6573 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 11:27:27.1426 873 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 10/12/2024 11:28:44.4937 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 11:33:15.3120 803 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 11:37:39.0826 595 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/12/2024 11:37:39.2787 837 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 11:39:29.6350 855 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-12-10 11:39:28','V',4889821436485310,2024,'2024-12-10 11:39:27','456344196700327005012999',1,2,16,'I','',1,0,1,'','',4) 10/12/2024 11:39:30.5956 734 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/12/2024 11:44:59.8553 522 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5244838663888110,5454788128894090,2024,'2024-12-10 11:44:59','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/10/2024 10:44:33 AM Date : 12/10/2024 11:44:58 AM Code : 456343867300327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 10/12/2024 11:47:14.5250 790 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-10 11:47:13',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'; 10/12/2024 11:48:43.1737 2120 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-12-10 11:46:02',1,'V',5483788153913670,5015383478245340,2024,'2024-12-10 11:46:02',17,1,0,4,'2024-12-10 12:01:02','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/12/2024 11:48:48.3181 905 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 6 ms.) 10/12/2024 11:49:35.4188 694 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5057742527705500,4922271910357590,2024,'2024-12-10 11:49:34','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/10/2024 11:24:06 AM Date : 12/10/2024 11:49:33 AM Code : 456344104600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 10/12/2024 11:49:51.7268 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 11:49:58.0941 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 11:53:09.7702 510 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/12/2024 11:53:51.5253 768 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-10 11:53:50',0,16,'2024-12-10 11:53:50','','Unauthorized Transit Entry 2') 10/12/2024 11:56:44.7169 1007 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 11:57:53.2580 1477 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 10/12/2024 11:57:54.1436 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 11:58:21.5701 521 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/12/2024 11:58:32.2313 611 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/12/2024 12:02:21.5957 833 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/12/2024 12:07:10.9805 907 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 12:11:05.8977 581 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-12-10 12:11:05',0,'V',5694736695518130,5034187997736550,2024,'2024-12-10 12:11:05',18,1,0,4,'2024-12-10 12:26:05','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/12/2024 12:27:00.7395 2599 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-12-10 12:26:55',0,'V',5208718949040270,5490509852659720,2024,'2024-12-10 12:26:55',3,1,0,4,'2024-12-10 12:41:55','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 10/12/2024 12:38:06.9220 704 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-12-10 12:38:06','V',5446857166808780,2024,'2024-12-10 12:38:05','456344548500327005012999',1,2,16,'I','',1,0,1,'','',4) 10/12/2024 12:41:23.5534 1259 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 12:41:23.8246 821 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 12:46:07.4495 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 12:46:07.6006 524 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/12/2024 12:46:17.5513 762 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/12/2024 12:47:10.3088 832 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4630224844324160,5573428838513700,2024,'2024-12-10 12:47:09',' Date: 12/10/2024 12:43:50 PM Code: 456344568700327005012999 Entry Date: 12/10/2024 12:41:27 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 # 2400417551 ',0) 10/12/2024 12:54:18.2620 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 12:55:47.1886 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 12:56:38.1674 635 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-12-10 12:56:37',0,'V',5321415885453670,5474272713184770,2024,'2024-12-10 12:56:37',18,1,0,4,'2024-12-10 13:11:37','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 10/12/2024 12:59:37.1591 771 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 7 ms.) 10/12/2024 13:04:51.7970 586 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/12/2024 13:06:12.9566 537 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 10/12/2024 13:06:14.2055 747 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-12-10 13:06:13','V',5508006561120670,2024,'2024-12-10 13:06:12','456344128600327005012999',2,2,2,'O','',0,'2024-12-10 13:06:13',1,'','',0) 10/12/2024 13:10:51.7270 912 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 13:11:05.8725 1581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:12:44.2196 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 13:17:37.8130 507 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 13:17:37' where traUID = 5680860429754030 and traStatus='V' and traEnabled=1 10/12/2024 13:18:03.1430 1016 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:18:08.3605 510 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52868, trcLastPrinted = '2400752868', trcLastDate = '2024-12-10 13:18:07' where trcStatus='V' and trcTerId = 18 10/12/2024 13:18:09.3672 974 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5159908553478710,5465926433136930,2024,'2024-12-10 13:18:08',' Date: 12/10/2024 1:18:06 PM Code: 456344194000327005012999 Entry Date: 12/10/2024 11:39:00 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400752868 ',0) 10/12/2024 13:18:09.8896 520 ms. EXEC: update payReceipt set recCreation = '2024-12-10 13:18:09',recModify = '2024-12-10 13:18:09',recUseId=0,recStatus='V' where recId = 330872 10/12/2024 13:20:31.4338 576 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-10 13:20:30' where payTraUID = 5298443604766180 and payStatus='V' and payEnabled=1 10/12/2024 13:20:37.7460 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:21:54.1974 750 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:22:30.1236 660 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52869, trcLastPrinted = '2400752869', trcLastDate = '2024-12-10 13:22:29' where trcStatus='V' and trcTerId = 18 10/12/2024 13:22:38.3501 606 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-10 13:22:37' where payTraUID = 5682529113830030 and payStatus='V' and payEnabled=1 10/12/2024 13:23:12.7192 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 13:23:14.3633 1079 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/12/2024 13:23:56.6217 1102 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-12-10 13:23:55','V',5377167431592620,2024,'2024-12-10 13:23:53','456344742500327005012999',2,2,2,'O','',0,'2024-12-10 13:23:55',1,'','',0) 10/12/2024 13:23:57.8816 703 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-10 13:23:57' where payTraUID = 4787130377458760 and payStatus='V' and payEnabled=1 10/12/2024 13:25:10.1542 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:25:43.0213 1173 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-10 13:25:41' where payTraUID = 4667316143321520 and payStatus='V' and payEnabled=1 10/12/2024 13:25:49.4486 931 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:26:14.4755 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:29:29.5205 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 13:29:37.3557 1863 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-10 13:29:35',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-12-10 13:29:35',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'; 10/12/2024 13:31:02.0926 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:33:02.2652 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:39:01.8966 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:40:53.3304 765 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:41:15.1691 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 13:47:19.6716 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 13:48:40.7930 714 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:49:36.0290 749 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:50:14.1856 741 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/12/2024 13:55:12.9279 933 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-12-10 13:55:11',0,'V',5480647196242880,4732935010838200,2024,'2024-12-10 13:55:11',18,1,0,4,'2024-12-10 14:10:11','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/12/2024 13:56:59.0661 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 13:57:03.4521 523 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 10/12/2024 13:57:16.5078 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 14:00:01.3144 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:02:21.1203 722 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:02:35.7732 523 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52878, trcLastPrinted = '2400752878', trcLastDate = '2024-12-10 14:02:35' where trcStatus='V' and trcTerId = 18 10/12/2024 14:04:24.0082 795 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52881, trcLastPrinted = '2400752881', trcLastDate = '2024-12-10 14:04:23' where trcStatus='V' and trcTerId = 18 10/12/2024 14:04:24.0142 752 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-12-10 14:04:23',0,'V',5307822219729400,4776437875309980,2024,'2024-12-10 14:04:23',18,1,0,4,'2024-12-10 14:19:23','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/12/2024 14:04:25.9355 1814 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52882, trcLastPrinted = '2400752882', trcLastDate = '2024-12-10 14:04:24' where trcStatus='V' and trcTerId = 18 10/12/2024 14:04:25.9615 1756 ms. EXEC: update payReceipt set recCreation = '2024-12-10 14:04:24',recModify = '2024-12-10 14:04:24',recUseId=0,recStatus='V' where recId = 330909 10/12/2024 14:05:11.5421 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:06:03.8983 596 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 14:06:03.9503 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:07:43.8284 858 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:08:13.0210 840 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-12-10 14:08:12','V',5230371931253210,2024,'2024-12-10 14:08:11','456345089100327005012999',1,2,16,'I','',1,0,1,'','',4) 10/12/2024 14:11:43.7155 949 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/12/2024 14:11:49.3182 918 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 14:11:49.6315 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:14:53.2427 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:16:38.2572 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:18:46.0991 600 ms. EXEC: update tabTerminalExtraMem SET extLoop1 = 0, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '', extCode = '' where extStatus='V' and extTerId = 16 10/12/2024 14:18:46.1281 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 14:18:46.3803 881 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:22:05.6605 871 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:29:47.8199 667 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-12-10 14:29:47','V',4764031044220190,2024,'2024-12-10 14:29:46','456345218600327005012999',1,2,16,'I','',1,0,1,'','',4) 10/12/2024 14:31:27.1546 695 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 14:31:26' where traUID = 5735581226009710 and traStatus='V' and traEnabled=1 10/12/2024 14:36:33.0552 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:36:43.2810 573 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 14:37:14.8702 748 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:41:03.7147 579 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 14:41:03' where traUID = 5012869138762310 and traStatus='V' and traEnabled=1 10/12/2024 14:41:21.5417 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 14:42:01.3154 824 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 381024 else acvFstPayId end),acvLstPayId = 381024 where acvSftId = 836 and acvCodeId = 3 10/12/2024 14:44:03.1161 1028 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:44:03.3873 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 14:46:01.1243 669 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:46:19.1454 532 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/12/2024 14:46:20.2131 679 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/12/2024 14:49:39.5989 589 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-10 14:49:38',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'; 10/12/2024 14:54:04.3236 796 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 14:54:27.2870 909 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-12-10 14:51:08',6,'V',5102705821624210,4764031044220190,2024,'2024-12-10 14:51:08',4,1,0,4,'2024-12-10 15:06:08','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/12/2024 14:54:44.8778 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 15:00:23.0079 919 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5218997847516200,5006287232996400,2024,'2024-12-10 15:00:22',' Date: 12/10/2024 3:00:21 PM Code: 456345255500327005012999 Entry Date: 12/10/2024 2:35:55 PM 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 # 2400752892 ',0) 10/12/2024 15:03:25.8886 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:03:27.9250 588 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-12-10 15:03:27','V',5282504484151910,2024,'2024-12-10 15:03:18','456344979800327005012999',2,2,2,'O','',0,'2024-12-10 15:03:27',1,'','0230003939927',164,0) 10/12/2024 15:06:42.4755 593 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 15:07:36.0164 655 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:09:01.5048 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:12:00.2136 927 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:12:08.4612 504 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/12/2024 15:12:46.1605 776 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:14:10.0908 844 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-10 15:14:09' where subId = 15 10/12/2024 15:18:44.9174 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 15:19:47.7074 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 15:19:50.8865 722 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 15:19:50' where traUID = 5183644567560210 and traStatus='V' and traEnabled=1 10/12/2024 15:20:13.1283 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:25:32.6156 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:29:02.6148 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:33:47.9316 714 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-12-10 15:33:47','V',5354748944363010,2024,'2024-12-10 15:33:46','456345602600327005012999',1,2,16,'I','',1,0,1,'','',4) 10/12/2024 15:35:36.0212 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:37:20.4855 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:41:58.8614 1299 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-12-10 15:41:57','V',5453867113792990,2024,'2024-12-10 15:41:56','456345506800327005012999',2,2,2,'O','',0,'2024-12-10 15:41:57',1,'','',0) 10/12/2024 15:42:04.0909 828 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:44:44.0421 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:45:18.1538 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:45:52.3716 921 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:49:25.9779 742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 15:49:26.0719 905 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:51:37.1703 1363 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 15:52:46.9768 638 ms. EXEC: update payReceipt set recCreation = '2024-12-10 15:52:46',recModify = '2024-12-10 15:52:46',recUseId=0,recStatus='V' where recId = 330978 10/12/2024 15:52:49.5035 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 15:53:12.6839 609 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/12/2024 15:53:13.7577 763 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 15:53:12' where traUID = 5549232362320810 and traStatus='V' and traEnabled=1 10/12/2024 15:53:19.3344 839 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:53:20.0609 697 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/12/2024 15:56:29.9286 855 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 15:56:54.0787 604 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-10 15:56:53','0560008336102',0,0,5427707669106210,185,'0000-00-00 00:00:00','0000-00-00 00:00:00') 10/12/2024 15:56:57.9183 3324 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-12-10 15:56:54','V',5459105242562690,2024,'2024-12-10 15:56:51','456345428600327005012999',2,2,2,'O','',0,'2024-12-10 15:56:54',1,'','0560008336102',185,0) 10/12/2024 15:56:58.8509 912 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/12/2024 15:58:04.5168 886 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 16:01:21.3604 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 16:04:33.3579 753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 16:07:10.2490 579 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-12-10 16:03:53',6,'V',4924656255800200,5672573911242760,2024,'2024-12-10 16:03:53',4,1,0,4,'2024-12-10 16:18:53','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/12/2024 16:09:21.8092 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 16:09:56.7567 526 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-10 16:09:56' where payTraUID = 5412767127497690 and payStatus='V' and payEnabled=1 10/12/2024 16:13:17.5653 1504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 16:14:38.7656 760 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 16:15:51.2041 1249 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 16:18:47.9243 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 16:19:28.2033 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 16:22:51.3582 956 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 16:29:50.2017 748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 16:31:40.0812 1319 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 16:32:14.2030 683 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/12/2024 16:32:14.8604 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 16:33:07.7478 1596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 16:34:48.8634 640 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/12/2024 16:35:08.3704 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 16:35:52.8482 689 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 16:38:01.7215 598 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 16:41:09.4482 823 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 16:41:08' where traUID = 5172617967459190 and traStatus='V' and traEnabled=1 10/12/2024 16:48:36.4559 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 16:53:17.2964 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 17:01:46.9715 1234 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 17:10:44.7026 1058 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/12/2024 17:12:41.1818 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 17:21:04.6223 889 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 17:29:22.5892 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 17:31:37.5217 1992 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-12-10 17:31:31',0,'V',5076474229280680,5027467896688930,2024,'2024-12-10 17:31:31',3,1,0,4,'2024-12-10 17:46:31','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 10/12/2024 17:31:37.5667 2125 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 17:31:38.6835 1058 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5027467896688930,5076474229280680,2024,'2024-12-10 17:31:37','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/10/2024 5:10:20 PM Date : 12/10/2024 5:31:31 PM Code : 456346182000327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 50.00 KES Coin : 0.00 KES Unavailable : 0.00 KES',0) 10/12/2024 17:31:39.4009 709 ms. EXEC: update payReceipt set recCreation = '2024-12-10 17:31:38',recModify = '2024-12-10 17:31:38',recUseId=0,recStatus='V' where recId = 331017 10/12/2024 17:31:42.5240 2645 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-10 17:31:39',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'; 10/12/2024 17:34:16.0980 512 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-10 17:34:15','0230003941812',0,0,5484669574319100,181,'0000-00-00 00:00:00','0000-00-00 00:00:00') 10/12/2024 17:34:58.9658 1751 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 17:34:57' where traUID = 5027467896688930 and traStatus='V' and traEnabled=1 10/12/2024 17:35:06.2136 1135 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 17:42:41.9784 699 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 17:45:20.2776 785 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 17:46:08.9682 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 17:48:03.1599 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 17:48:21.3691 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 17:51:27.1215 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 17:55:20.7270 584 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/12/2024 18:06:41.6713 1156 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 18:06:40' where traUID = 5140260308519330 and traStatus='V' and traEnabled=1 10/12/2024 18:06:45.8361 1431 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 18:08:51.6084 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 18:11:54.0887 1448 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 18:15:17.9643 538 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 18:20:16.2794 938 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 18:20:59.1511 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 18:28:32.8308 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 18:47:42.6493 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 18:57:50.7359 1072 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 18:58:26.5668 1654 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-12-10 18:58:24','V',5520192195774300,2024,'2024-12-10 18:58:23','456345972400327005012999',2,2,2,'O','',0,'2024-12-10 18:58:24',1,'','',0) 10/12/2024 18:58:32.4577 1029 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 19:02:29.5630 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 19:09:23.8442 524 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 10/12/2024 19:09:24.1695 772 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/12/2024 19:09:24.9760 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 19:12:45.5865 992 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 1 10/12/2024 19:20:05.5268 514 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-12-10 19:20:05','V',5160952915417210,2024,'2024-12-10 19:20:04','456346960400327005012999',1,2,16,'I','',1,0,1,'','',4) 10/12/2024 19:20:06.6165 885 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5039655325703410,5383431186121090,2024,'2024-12-10 19:20:05',' Date: 12/10/2024 7:20:05 PM Code: 456346570400327005012999 Entry Date: 12/10/2024 6:15:04 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400752937 ',0) 10/12/2024 19:20:06.6856 852 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/12/2024 19:35:27.9985 888 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/12/2024 19:35:29.1943 893 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 19:38:05.0036 934 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 19:38:51.4778 658 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-10 19:38:50' where payTraUID = 4983295931836060 and payStatus='V' and payEnabled=1 10/12/2024 19:38:56.6812 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 19:42:21.8197 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 19:43:30.9410 968 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 19:44:49.7458 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 19:45:04.1785 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 19:45:19.0695 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 19:49:08.9775 1208 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 19:51:00.2960 1871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 19:51:39.5793 731 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/12/2024 19:51:40.3178 736 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-10 19:51:39' where payTraUID = 5408153887941240 and payStatus='V' and payEnabled=1 10/12/2024 19:51:44.0473 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 19:53:17.4859 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 19:55:32.8696 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 20:02:57.0104 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 20:04:43.2897 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 20:05:31.2990 830 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 20:12:58.7320 625 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/12/2024 20:13:44.7470 735 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 20:22:36.8137 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 20:24:18.0368 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 20:30:37.2312 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 20:33:40.6055 665 ms. OPEN: select * from tabClass where claPosition = 2 and claStatus='V' 10/12/2024 20:33:42.4887 1459 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 20:33:42.5007 654 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/12/2024 20:33:42.6939 818 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/12/2024 20:36:43.7816 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 20:36:44.2379 1141 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 20:37:06.0806 2918 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-12-10 20:37:02',0,'V',4943360414090820,4818046881536190,2024,'2024-12-10 20:37:02',18,1,0,4,'2024-12-10 20:52:02','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/12/2024 20:37:06.6690 541 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52948, trcLastPrinted = '2400752948', trcLastDate = '2024-12-10 20:37:06' where trcStatus='V' and trcTerId = 18 10/12/2024 20:40:46.6129 1604 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/12/2024 20:48:24.3180 817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 20:48:53.1504 737 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 20:52:51.4326 531 ms. EXEC: update payInventory set invCreation = '2024-12-10 20:52:50',invModify = '2024-12-10 20:52:50',invUseId=0,invStatus='V' where invId = 224425 10/12/2024 20:53:15.8970 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 20:53:16.0451 642 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 20:58:57.9760 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 20:58:58.1642 510 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/12/2024 21:00:49.1568 524 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-12-10 20:58:11',9,'V',5571710449610180,4788318447129570,2024,'2024-12-10 20:58:11',17,1,0,4,'2024-12-10 21:13:11','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/12/2024 21:01:24.4395 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 21:01:55.0091 712 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-10 21:01:54',0,16,'2024-12-10 21:01:54','','Unauthorized Transit Entry 2') 10/12/2024 21:11:20.8015 752 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 21:12:31.6031 1213 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-12-10 21:12:30','V',4745552681917840,2024,'2024-12-10 21:12:29','456347634900327005012999',1,2,16,'I','',1,0,1,'','',4) 10/12/2024 21:17:02.3732 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 21:21:14.2655 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 21:23:45.9885 844 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 21:24:42.8758 1618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 21:26:01.4876 765 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/12/2024 21:26:02.1661 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 21:28:29.7273 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 21:31:47.6454 564 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-12-10 21:31:47','V',5645471992284670,2024,'2024-12-10 21:31:45','456347539000327005012999',2,2,2,'O','',0,'2024-12-10 21:31:47',1,'','',0) 10/12/2024 21:31:51.9733 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 21:35:35.8839 936 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/12/2024 21:48:46.6315 543 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-10 21:48:45',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'; 10/12/2024 21:51:13.3052 902 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 22:00:11.1258 857 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 22:00:27.9101 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 22:02:33.8437 511 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-12-10 22:02:33','V',5012149109743990,2024,'2024-12-10 22:02:30','456347777800327005012999',2,2,2,'O','',0,'2024-12-10 22:02:33',1,'','',0) 10/12/2024 22:02:35.1696 736 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 22:02:34' where traUID = 5624120905535290 and traStatus='V' and traEnabled=1 10/12/2024 22:02:41.1386 993 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 22:02:43.6944 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 22:03:47.4072 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 22:04:52.9803 711 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 167 ms.) 10/12/2024 22:11:46.1911 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 22:24:26.8206 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 22:25:16.5860 647 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/12/2024 22:25:47.3437 1064 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 22:28:00.4572 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 22:29:40.1652 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 22:33:29.2773 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 22:37:01.9613 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 22:40:21.1963 817 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/12/2024 22:44:39.3859 737 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 22:52:53.2329 513 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-10 22:52:52' where traUID = 4985660452369670 and traStatus='V' and traEnabled=1 10/12/2024 22:52:59.2339 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 22:59:09.0436 762 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/12/2024 23:24:54.9570 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 23:35:05.3054 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/12/2024 23:54:56.5464 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1