30/12/2024 00:02:26.5600 2917 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 00:17:49.9401 694 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 30/12/2024 00:24:11.5545 572 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-12-30 00:24:10',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 30/12/2024 00:24:12.1278 538 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-30 00:24:11',1,2,'2024-12-30 00:24:11','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 30/12/2024 00:28:46.1900 977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 00:29:50.0037 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 00:33:05.2012 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 00:35:57.9134 886 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 00:47:28.3602 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 00:59:50.3389 1014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 01:03:41.5044 952 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/12/2024 01:05:35.5596 1396 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 01:08:09.0943 899 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 01:10:07.4133 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 01:10:47.2850 1626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 01:30:27.4452 970 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 01:31:34.5630 1154 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 01:58:58.9001 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 02:00:41.3946 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 02:03:01.8255 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 02:05:04.2944 1119 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 02:18:49.8522 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 02:29:12.5284 1400 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 02:43:07.6350 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 02:48:56.1411 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 02:57:56.3411 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 02:58:11.8046 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 03:31:52.9426 1189 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 03:48:14.3562 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 03:51:20.6968 1693 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 30/12/2024 03:51:20.6998 1698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 03:51:23.9820 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 04:11:07.3455 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 04:52:18.5064 926 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/12/2024 05:16:39.5729 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 05:26:45.9461 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 05:46:22.6416 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 05:47:33.4931 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 05:51:24.6758 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 05:57:48.0469 784 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 30/12/2024 06:11:54.6560 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 06:25:19.8902 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 06:31:29.4479 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 06:36:16.9210 829 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 30/12/2024 06:46:53.9704 1555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 06:57:51.5695 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 06:58:45.5426 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 07:04:14.1814 530 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/12/2024 07:04:29.5377 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 07:12:23.3134 1607 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-30 07:12:19',0,'V',5269989893939510,5361597696372890,2024,'2024-12-30 07:12:19',3,1,0,2,'2024-12-30 07:27:19','C','KES',500,0,0,'',' ',' ',98,500,0,0,'',0,0) 30/12/2024 07:18:01.9934 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 07:31:42.7770 1688 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 30/12/2024 07:42:52.4676 615 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 183 order by traDateTime desc,traId desc 30/12/2024 07:47:12.1722 1000 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 17 order by traDateTime desc,traId desc 30/12/2024 07:48:15.9390 769 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-30 07:48:19',9,'V',5303854884245420,5453147812297730,2024,'2024-12-30 07:48:19',4,1,0,4,'2024-12-30 08:03:19','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/12/2024 07:49:36.5669 1285 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 08:10:23.4653 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 08:13:07.4039 526 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 08:12:55',5,3,42101,0,50,-12,-600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 08:12:55',5,3,42101,0,50,12,600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 08:12:55',5,3,42101,0,100,-34,-3400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 08:12:55',5,3,42101,0,100,34,3400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 08:12:55',5,3,42101,0,200,-4,-800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 08:12:55',5,3,42101,0,200,4,800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 08:12:55',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 30/12/2024 08:45:54.5316 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 08:46:11.8702 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 08:46:15.9909 822 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/12/2024 08:46:20.9202 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 08:59:49.1029 733 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:07:14.6837 601 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 30/12/2024 09:09:43.8072 1220 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:10:24.3233 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 09:10:40.5222 1543 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 30/12/2024 09:12:10.5262 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:12:11.1296 873 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/12/2024 09:15:11.4241 686 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 09:15:12.1556 689 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 09:18:50.5738 1006 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:19:57.7568 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:22:07.6596 1086 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-30 09:22:05',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'; 30/12/2024 09:24:05.7920 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 09:24:16.1039 827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:28:51.7393 507 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 30/12/2024 09:28:57.0508 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 09:28:57.3791 1035 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 30/12/2024 09:31:51.6515 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:32:01.3820 1986 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 09:33:01.9218 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:37:02.8383 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:37:43.2455 635 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-30 09:37:42',0,0,'V',4784076206802830,4888412596024360,2024,'2024-12-30 09:37:42',3,'KES',1,50,50,'N',''); 30/12/2024 09:38:20.3897 1684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:38:41.4128 1251 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:41:53.4920 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:42:11.7732 925 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 09:45:43.4995 565 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 30/12/2024 09:46:10.4318 604 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-30 09:46:09','V',5194893962372310,2024,'2024-12-30 09:46:08','456543429000327005012999',2,2,2,'O','',0,'2024-12-30 09:46:09',1,'','',0) 30/12/2024 09:49:31.9082 761 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 09:49:30',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 30/12/2024 09:51:49.2533 803 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 09:51:48' where traUID = 5444806003952460 and traStatus='V' and traEnabled=1 30/12/2024 09:51:54.0095 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 09:51:59.5372 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:57:00.1871 1385 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 09:58:48.6146 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 10:01:14.5211 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 10:02:44.8565 2586 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-30 10:02:42','V',4649034287739410,2024,'2024-12-30 10:02:40','456543616000327005012999',1,2,16,'I','',1,0,1,'','',4) 30/12/2024 10:02:47.2461 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 10:03:08.1591 1010 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 10:06:50.3532 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 10:07:58.5678 541 ms. OPEN: select * from tabCustomer inner join abbSubscriptions on subCusId = cusId left join tabAbbGroups on cusAbgId = abgId where subId = 27 and cusStatus='V' 30/12/2024 10:07:59.8186 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,payVatPercent,payVatAmount) VALUES ('2024-12-30 10:07:59',0,'V',4818949710003570,5626492158520340,2024,'2024-12-30 10:07:59',2,1,0,-1,'2024-12-30 11:07:59','S','KES',0,0,0,'','','',3,0,0) 30/12/2024 10:14:31.3574 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 10:20:12.5975 1310 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 30/12/2024 10:24:32.2910 1136 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 10:24:30',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N'; 30/12/2024 10:24:33.2447 811 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 10:24:32',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-30 10:24:32',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'; 30/12/2024 10:26:53.0754 533 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-30 10:26:51',0,'V',5395738017368210,5007082825399110,2024,'2024-12-30 10:26:51',3,1,0,4,'2024-12-30 10:41:51','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 30/12/2024 10:27:16.2009 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 10:27:17.0965 617 ms. OPEN: show columns from tabTerminalExtraMem where Field = 'extcode' 30/12/2024 10:27:17.3326 1293 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 10:27:22.8503 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 10:28:43.9095 972 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 10:32:08.1390 963 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 30/12/2024 10:33:28.8029 10044 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 30/12/2024 10:33:46.3997 1178 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 30/12/2024 10:33:47.1722 740 ms. OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2024-12-28 11:26:38' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal 30/12/2024 10:36:13.7973 837 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 10:37:07.9986 1025 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-30 10:37:06',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-30 10:37:06',3,42101,0,100,-1,-100,1,'O','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'; 30/12/2024 10:41:19.5229 1199 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 10:41:54.8659 883 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 10:44:30.2397 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 10:45:08.6884 558 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/12/2024 10:45:14.7645 826 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 10:50:10.8744 772 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 30/12/2024 10:51:08.9512 1521 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4621754562893410,4853845616768660,2024,'2024-12-30 10:51:07','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/30/2024 10:24:06 AM Date : 12/30/2024 10:51:06 AM Code : 456543744600327005012999 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) 30/12/2024 10:51:10.3692 629 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 10:51:09',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-30 10:51:09',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'; 30/12/2024 10:55:25.9250 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 10:55:44.9918 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 10:59:34.9205 822 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 10:59:45.6386 763 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4702418926035310,4849499306827750,2024,'2024-12-30 10:59:44',' Date: 12/30/2024 10:59:44 AM Code: 456543709300327005012999 Entry Date: 12/30/2024 10:18:13 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 # 2400755639 ',0) 30/12/2024 10:59:59.3206 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 11:00:06.5594 705 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 11:00:05' where traUID = 4702418926035310 and traStatus='V' and traEnabled=1 30/12/2024 11:01:03.5610 890 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 30/12/2024 11:01:31.5577 892 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 11:01:41.3893 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 11:03:05.2093 1936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 11:03:28.8411 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 11:03:37.4789 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 11:07:53.8183 1085 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 11:15:07.3641 694 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 11:24:37.8264 830 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 11:29:09.0066 812 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-30 11:29:08','V',5178893098895020,2024,'2024-12-30 11:29:06','456544111200327005012999',2,2,2,'O','',0,'2024-12-30 11:29:08',1,'','',0) 30/12/2024 11:29:14.3922 868 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 11:31:39.8785 586 ms. EXEC: update payInventory set invCreation = '2024-12-30 11:31:39',invModify = '2024-12-30 11:31:39',invUseId=0,invStatus='V' where invId = 228267 30/12/2024 11:31:41.0803 688 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 11:31:39',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-30 11:31:39',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'; 30/12/2024 11:34:56.9092 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 11:36:32.9774 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 11:42:26.3749 615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 12:00:03.5064 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 12:01:08.3913 520 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/12/2024 12:01:32.1611 725 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-30 12:01:31' where payTraUID = 4808316600935740 and payStatus='V' and payEnabled=1 30/12/2024 12:01:37.0164 716 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 12:04:37.3990 1134 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 12:04:46.0387 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 12:06:37.7106 1537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 64 ms.) 30/12/2024 12:07:13.3594 1443 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 12:07:13.3594 516 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/12/2024 12:10:26.0686 1654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 12:10:48.2344 1314 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 12:19:19.6427 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 12:21:10.7560 1709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 12:22:12.1100 1735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 12:22:58.3309 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 12:23:09.7245 1354 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 12:23:48.6846 1340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 12:23:56.0065 736 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 12:30:00.4852 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 12:30:13.1877 890 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/12/2024 12:34:49.8096 764 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/12/2024 12:35:42.7841 2090 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-30 12:35:39',0,'V',5154666252790070,5156600402950160,2024,'2024-12-30 12:35:39',3,1,0,4,'2024-12-30 12:50:39','C','KES',100,200,100,'',' ',' ',1,100,0,0,'',0,0) 30/12/2024 12:38:35.0407 1312 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-30 12:38:33',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 30/12/2024 12:38:51.5408 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 12:39:56.1088 1151 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/12/2024 12:39:57.8609 516 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 388541 else acvFstPayId end),acvLstPayId = 388541 where acvSftId = 872 and acvCodeId = 3 30/12/2024 12:40:17.8363 600 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 12:40:17' where traUID = 5126422818569690 and traStatus='V' and traEnabled=1 30/12/2024 12:41:45.9411 509 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/12/2024 12:41:46.6835 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 12:46:54.4749 612 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-30 12:46:52',0,'V',4806234436384260,4912452017999110,2024,'2024-12-30 12:46:52',3,1,0,4,'2024-12-30 13:01:52','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 30/12/2024 12:49:57.0798 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 12:55:51.2410 879 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 13:03:38.4710 540 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-30 13:03:37','V',5201154308737730,2024,'2024-12-30 13:03:37','456544701700327005012999',1,2,16,'I','',1,0,1,'','',4) 30/12/2024 13:08:59.7167 676 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 13:12:45.0602 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 13:12:54.8627 1404 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:13:02.7320 1682 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-30 13:13:01','V',5578395952517080,2024,'2024-12-30 13:12:59','456544757900327001012999',1,2,1,'I','',1,0,1,'','',4) 30/12/2024 13:13:29.9952 512 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/12/2024 13:13:35.3458 1346 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 30/12/2024 13:15:23.9815 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:16:26.6483 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:18:12.0648 603 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 13:18:11' where traUID = 5201154308737730 and traStatus='V' and traEnabled=1 30/12/2024 13:18:18.1669 807 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 13:20:19.9203 609 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/12/2024 13:24:05.7493 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:24:35.8805 1089 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:25:46.0774 654 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 13:26:20.9897 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 13:31:46.4141 3259 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 30/12/2024 13:33:40.6245 1071 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/12/2024 13:37:56.6548 781 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 13:37:55' where traUID = 5224128543294090 and traStatus='V' and traEnabled=1 30/12/2024 13:38:02.6268 920 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 13:38:02.9080 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:38:02.9780 664 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/12/2024 13:43:11.7222 899 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/12/2024 13:43:20.1248 661 ms. EXEC: update payReceipt set recCreation = '2024-12-30 13:43:19',recModify = '2024-12-30 13:43:19',recUseId=0,recStatus='V' where recId = 337413 30/12/2024 13:44:02.3230 515 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-30 13:44:01','0810007113876',0,0,5399343039422470,103,'0000-00-00 00:00:00','0000-00-00 00:00:00') 30/12/2024 13:44:10.3714 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 13:48:39.3531 2220 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 13:49:37.0347 1854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:50:00.2482 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:50:19.9644 1378 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-30 13:50:18','V',4974874142990110,2024,'2024-12-30 13:50:16','456544981600327001012999',1,2,1,'I','',1,0,1,'','',4) (WAIT TIME 105 ms.) 30/12/2024 13:50:55.6172 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:52:03.6197 1634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:52:32.1237 1134 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-30 13:52:30','V',4659842541492270,2024,'2024-12-30 13:52:29','456544994900327005012999',1,2,16,'I','',1,0,1,'','',4) 30/12/2024 13:55:37.3455 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 13:57:44.6086 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 13:59:35.8568 600 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-30 13:59:35','V',5516265469803210,2024,'2024-12-30 13:59:34','456544669200327001012999',2,2,2,'O','',0,'2024-12-30 13:59:35',1,'','',0) 30/12/2024 14:03:25.3684 1367 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:06:05.8271 531 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-30 14:06:05',0,'V',4825779961610710,5350346683753450,2024,'2024-12-30 14:06:05',18,1,0,4,'2024-12-30 14:21:05','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/12/2024 14:07:47.3399 521 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-30 14:07:46','V',5341629017222960,2024,'2024-12-30 14:07:43','456545086300327001012999',1,2,1,'I','',1,0,1,'','0230004098588',183,0) 30/12/2024 14:07:53.5381 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:08:55.0152 555 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/12/2024 14:09:01.1723 789 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:10:53.0231 709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:12:07.8631 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 14:17:03.8639 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 14:17:26.6372 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:21:05.1152 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 14:21:48.8675 552 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 388588 else acvFstPayId end),acvLstPayId = 388588 where acvSftId = 871 and acvCodeId = 3 30/12/2024 14:21:56.5446 695 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/12/2024 14:21:58.0756 966 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 14:22:16.7801 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:22:17.3815 570 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 14:22:57.2452 632 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:23:22.8493 704 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 14:23:27.0691 557 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 30/12/2024 14:24:14.7850 4899 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 30/12/2024 14:24:29.3137 716 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-30 14:24:28',0,'V',5486523620871890,5669864285415800,2024,'2024-12-30 14:24:28',18,1,0,4,'2024-12-30 14:39:28','C','KES',300,300,0,'','','',1,300,0,0,'',0,0) 30/12/2024 14:25:51.2405 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:26:17.6571 1174 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-30 14:26:16' where payTraUID = 5524895515192080 and payStatus='V' and payEnabled=1 30/12/2024 14:27:08.0798 712 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:27:08.9904 817 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 14:27:51.2607 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-12-30 14:27:50',0,'V',4632012035764240,5698440240142780,2024,'2024-12-30 14:27:50',18,1,0,4,'2024-12-30 14:42:50','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/12/2024 14:28:55.0263 560 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 30/12/2024 14:28:55.3005 699 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:29:09.1508 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 14:32:08.8839 1258 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/12/2024 14:32:09.0020 1380 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:36:01.5494 677 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-30 14:35:59',0,'V',5732437061276650,4697746599833340,2024,'2024-12-30 14:35:59',3,1,0,4,'2024-12-30 14:50:59','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 30/12/2024 14:36:03.2606 983 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-30 14:36:02',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'; 30/12/2024 14:36:28.3013 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 14:39:52.1446 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 14:42:04.7481 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 14:46:54.8293 531 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/12/2024 14:46:58.6849 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:06:22.2103 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-12-30 15:06:21','V',5339897728771590,2024,'2024-12-30 15:06:20','456545301800327005012999',2,2,2,'O','',0,'2024-12-30 15:06:21',1,'','',0) 30/12/2024 15:06:56.3351 695 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 15:06:55' where traUID = 5091951401101180 and traStatus='V' and traEnabled=1 30/12/2024 15:09:37.9265 791 ms. EXEC: update payReceipt set recCreation = '2024-12-30 15:09:37',recModify = '2024-12-30 15:09:37',recUseId=0,recStatus='V' where recId = 337459 30/12/2024 15:15:08.5752 573 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-30 15:15:07',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'; 30/12/2024 15:16:51.3379 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:23:58.1605 694 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:24:13.7969 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:24:14.1482 851 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 15:24:14.1512 607 ms. OPEN: show columns from tabArea where Field = 'areBookingReserved' 30/12/2024 15:24:31.0044 1450 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/12/2024 15:24:31.8660 751 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:24:33.1639 1262 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 15:24:39.0788 518 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-30 15:24:38','V',5341258091487400,2024,'2024-12-30 15:24:36','456544873100327005012999',2,2,2,'O','',0,'2024-12-30 15:24:38',1,'','',0) 30/12/2024 15:24:41.3513 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 15:27:45.7856 797 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/12/2024 15:28:46.6905 880 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:28:46.7506 790 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 30/12/2024 15:28:51.7849 528 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 30/12/2024 15:29:58.6028 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:31:47.4476 832 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-30 15:31:46','V',4762665870864270,2024,'2024-12-30 15:31:45','456545590500327005012999',1,2,16,'I','',1,0,1,'','',4) 30/12/2024 15:32:04.0907 629 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/12/2024 15:32:04.9593 815 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/12/2024 15:32:48.3253 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:33:17.1676 1815 ms. EXEC: update tabTerminalReceipt set trcProgressive = 8397, trcLastPrinted = '2400608397', trcLastDate = '2024-12-30 15:33:15' where trcStatus='V' and trcTerId = 17 30/12/2024 15:35:17.0752 760 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:36:53.8125 593 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/12/2024 15:45:57.1462 910 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 15:45:56',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-30 15:45:56',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'; 30/12/2024 15:48:37.7235 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:48:38.4951 1141 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 15:50:00.4288 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:53:17.5546 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 15:55:30.1202 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 15:55:32.2236 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 15:57:39.0474 588 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-30 15:57:38','V',5589262191468120,2024,'2024-12-30 15:57:36','456545745600327001012999',1,2,1,'I','',1,0,1,'','',4) 30/12/2024 16:03:59.1335 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 16:05:29.9932 698 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:06:37.4083 958 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:09:24.7171 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 16:09:31.8178 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 16:11:51.9718 1370 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:12:55.4883 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:14:09.1818 529 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/12/2024 16:14:19.3957 990 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-30 16:14:17',0,'V',4934825684519730,5109183723524000,2024,'2024-12-30 16:14:17',3,1,0,4,'2024-12-30 16:29:17','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 30/12/2024 16:14:20.0611 656 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5109183723524000,4934825684519730,2024,'2024-12-30 16:14:19','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/30/2024 4:09:57 PM Date : 12/30/2024 4:14:17 PM Code : 456545819700327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 30/12/2024 16:14:47.6435 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:16:55.1914 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 16:18:30.9725 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:19:13.1688 614 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 16:20:19.8274 732 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/12/2024 16:20:48.7974 892 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:21:32.1852 639 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/12/2024 16:23:09.9445 741 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55699, trcLastPrinted = '2400755699', trcLastDate = '2024-12-30 16:23:09' where trcStatus='V' and trcTerId = 18 30/12/2024 16:25:27.0995 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:25:27.7449 609 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 16:25:28.7906 1500 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 16:26:13.9438 855 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:26:26.6293 763 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5649083337325170,4646196601770970,2024,'2024-12-30 16:26:25',' Date: 12/30/2024 4:26:25 PM Code: 456545648500327005012999 Entry Date: 12/30/2024 3:41:25 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 # 2400755701 ',0) 30/12/2024 16:27:41.1239 529 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-30 16:27:40' where payTraUID = 5384898219571980 and payStatus='V' and payEnabled=1 30/12/2024 16:31:12.6482 508 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 16:31:11' where traUID = 5649083337325170 and traStatus='V' and traEnabled=1 30/12/2024 16:31:18.0848 975 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/12/2024 16:31:18.7333 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 16:31:18.9584 829 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:31:23.6456 541 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-30 16:31:23',0,0,'V',5537924022406210,5639509840207460,2024,'2024-12-30 16:31:23',3,'KES',1,500,500,'N',''); 30/12/2024 16:44:17.7324 822 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:46:27.4431 610 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 30/12/2024 16:47:43.0250 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:56:42.7745 782 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 16:58:32.8414 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 17:01:42.4883 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:05:57.6508 952 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 17:06:15.8082 540 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 17:06:15' where traUID = 4874630476873700 and traStatus='V' and traEnabled=1 30/12/2024 17:08:27.5170 1943 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 30/12/2024 17:11:39.7619 2001 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/12/2024 17:11:41.1688 1078 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:14:10.2430 872 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/12/2024 17:14:27.3044 1555 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/12/2024 17:19:10.3143 1099 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55716, trcLastPrinted = '2400755716', trcLastDate = '2024-12-30 17:19:09' where trcStatus='V' and trcTerId = 18 30/12/2024 17:19:56.3051 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 17:20:15.6480 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:20:45.8842 1721 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-30 17:20:41',0,'V',4682131940737330,5603278210773930,2024,'2024-12-30 17:20:41',3,1,0,4,'2024-12-30 17:35:41','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 30/12/2024 17:22:47.0932 674 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:23:39.6483 1025 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-30 17:23:38','V',5061888645887450,2024,'2024-12-30 17:23:37','456545769800327001012999',2,2,2,'O','',0,'2024-12-30 17:23:38',1,'','',0) 30/12/2024 17:25:59.8501 679 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-30 17:25:59',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-30 17:25:59',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'; 30/12/2024 17:29:42.6132 605 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:29:47.2833 835 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:33:21.5591 669 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/12/2024 17:33:22.3487 662 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-30 17:33:21' where payTraUID = 4894140349445600 and payStatus='V' and payEnabled=1 30/12/2024 17:33:27.8213 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:35:47.1436 13935 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 30/12/2024 17:35:50.0645 637 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-30 17:35:49','V',4739475744137510,2024,'2024-12-30 17:35:32','456546333200327005012999',1,2,16,'I','',1,0,1,'','0230003943530',44,0) 30/12/2024 17:36:01.1439 840 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 30/12/2024 17:36:01.6112 944 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 153 ms.) 30/12/2024 17:38:13.2272 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:38:45.0385 510 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-30 17:38:44','V',4627515386612910,2024,'2024-12-30 17:38:43','456546239100327005012999',2,2,2,'O','',0,'2024-12-30 17:38:44',1,'','',0) 30/12/2024 17:40:29.0690 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 17:41:00.9373 875 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:44:58.2830 1041 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:47:16.9467 776 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:49:11.1090 788 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 17:49:10' where traUID = 4953578067094220 and traStatus='V' and traEnabled=1 30/12/2024 17:49:16.4305 801 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:53:08.9640 2284 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/12/2024 17:55:22.1130 1487 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/12/2024 17:55:22.8475 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 17:56:18.6758 1775 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-30 17:56:16',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'; 30/12/2024 17:57:22.0181 747 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/12/2024 17:57:23.0888 914 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/12/2024 17:59:14.4603 551 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 17:59:13' where traUID = 4656661406261370 and traStatus='V' and traEnabled=1 30/12/2024 18:00:47.8767 620 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-30 18:00:47','V',4946116133215630,2024,'2024-12-30 18:00:46','456546261100327005012999',2,2,2,'O','',0,'2024-12-30 18:00:47',1,'','',0) 30/12/2024 18:04:44.8643 603 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 30/12/2024 18:06:54.7289 515 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 30/12/2024 18:09:49.7112 645 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/12/2024 18:10:00.0231 870 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/12/2024 18:10:03.7476 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 18:10:05.1875 869 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 18:23:44.1510 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 18:26:16.0546 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 18:26:55.4289 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 18:27:10.1817 501 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-30 18:27:09',1,2,'2024-12-30 18:27:09','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 30/12/2024 18:29:34.1890 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 18:34:59.2229 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 18:42:41.0352 772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 18:46:55.2371 663 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 18:46:54' where traUID = 4724168635304930 and traStatus='V' and traEnabled=1 30/12/2024 18:46:58.3162 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 18:51:36.7389 585 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4775468144989100,4833887100495520,2024,'2024-12-30 18:51:36',' Date: 12/30/2024 6:51:35 PM Code: 456546307900327005012999 Entry Date: 12/30/2024 5:31:19 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 # 2400755732 ',0) 30/12/2024 18:52:22.0142 818 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 18:54:54.9484 1408 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-30 18:54:53',0,16,'2024-12-30 18:54:53','','Unauthorized Transit Entry 2') 30/12/2024 18:54:57.7513 2109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 18:54:57.8233 1590 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 30/12/2024 18:58:23.4928 1144 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 18:58:24.9548 1008 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/12/2024 18:59:48.5524 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 19:02:04.5253 2414 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 19:02:04.5263 2351 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/12/2024 19:02:57.6738 582 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/12/2024 19:02:58.4003 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 19:03:02.9243 1166 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 30/12/2024 19:03:34.8257 1245 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 19:05:29.5654 1219 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 19:10:46.9168 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 19:15:52.4719 938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 19:17:02.0575 836 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 19:17:03.2863 1186 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 19:34:54.8826 547 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/12/2024 19:35:47.6098 1155 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 19:39:05.3930 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 19:51:19.1424 864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 19:53:35.6854 788 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 19:53:59.8456 817 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/12/2024 20:00:31.9943 1428 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 20:01:19.1919 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 20:15:53.5357 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 20:17:16.7744 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 20:21:17.2946 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 20:33:19.0967 841 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 20:33:19.4270 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 20:34:05.4167 1124 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 20:41:39.8005 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 20:42:36.1842 654 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/12/2024 21:00:38.4801 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 21:08:38.5989 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 21:17:03.5184 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 21:17:03.7455 543 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/12/2024 21:17:27.2463 667 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/12/2024 21:17:27.8397 511 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 21:17:27' where traUID = 5713495670279800 and traStatus='V' and traEnabled=1 30/12/2024 21:17:57.7336 853 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-30 21:17:56','V',5304683493231000,2024,'2024-12-30 21:17:55','456546432800327005012999',2,2,2,'O','',0,'2024-12-30 21:17:56',1,'','0790005719031',46,0) 30/12/2024 21:19:58.0110 1430 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 21:22:44.7555 1028 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 21:23:29.8546 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 21:25:12.4082 577 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-30 21:25:11',0,'V',5655662441981780,5467087967917260,2024,'2024-12-30 21:25:11',18,1,0,4,'2024-12-30 21:40:11','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 30/12/2024 21:25:13.1117 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 21:28:31.2791 605 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 21:28:30' where traUID = 4632610468872290 and traStatus='V' and traEnabled=1 30/12/2024 21:38:04.8248 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 21:44:15.8057 1062 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 21:52:13.3319 581 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/12/2024 22:13:48.6820 687 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-30 22:13:47','V',4924102952993050,2024,'2024-12-30 22:13:47','456547646800327005012999',2,2,2,'O','',0,'2024-12-30 22:13:47',1,'','',0) 30/12/2024 22:13:53.1459 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 22:25:39.4529 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 22:26:23.3145 919 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-30 22:26:22','V',4833523995297470,2024,'2024-12-30 22:26:21','456548078100327005012999',1,2,16,'I','',1,0,1,'','',4) 30/12/2024 22:26:24.4665 678 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/12/2024 22:28:55.1395 708 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 30/12/2024 22:29:53.9848 1082 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-30 22:29:52' where traUID = 4833523995297470 and traStatus='V' and traEnabled=1 30/12/2024 22:30:00.3501 1098 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/12/2024 22:30:01.3938 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/12/2024 22:41:48.3090 955 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 22:57:51.2814 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 22:58:08.5509 1652 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4624447258414100,4637499265742600,2024,'2024-12-30 22:58:06',' Date: 12/30/2024 10:58:06 PM Code: 456547512800327005012999 Entry Date: 12/30/2024 8:52:08 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 # 2400755766 ',0) 30/12/2024 23:01:39.0607 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 23:05:04.6557 1031 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/12/2024 23:05:05.9746 1099 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 30/12/2024 23:07:05.6171 584 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 30/12/2024 23:10:22.4989 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/12/2024 23:33:19.6309 938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1