25/04/2025 06:34:41.2902 671 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 190 order by traDateTime desc,traId desc 25/04/2025 07:09:00.2286 1550 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 25/04/2025 07:39:10.5470 733 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 25/04/2025 07:47:42.6515 902 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 25/04/2025 08:00:04.7193 2124 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 25/04/2025 08:08:31.5228 522 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 25/04/2025 09:48:10.4726 574 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 25/04/2025 09:50:14.9903 4530 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 25/04/2025 10:47:07.6831 647 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16350, trcLastPrinted = '2500716350', trcLastDate = '2025-04-25 10.47.07' where trcStatus='V' and trcTerId = 18 25/04/2025 11:32:37.7634 547 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 25/04/2025 11:32:38.5189 753 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 11:32:39.4566 936 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 25/04/2025 12:20:24.7940 529 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5489370259551240,5594579486185460,2025,'2025-04-25 12:20:24',' Date: 4/25/2025 12:20:05 PM Code: 457704271300327005012999 Entry Date: 4/25/2025 11:51:53 AM 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 # 2500405160 ',0) 25/04/2025 12:44:57.8336 537 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4933228868554770,5208598120859430,2025,'2025-04-25 12:44:57',' Date: 4/25/2025 12:44:57 PM Code: 457704324700327005012999 Entry Date: 4/25/2025 12:00:47 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 # 2500716367 ',0) 25/04/2025 13:17:28.0853 1899 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 = 12 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 25/04/2025 14:34:42.8910 565 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-25 14:34:42',0,0,'V',5571394610905570,4637386447882850,2025,'2025-04-25 14:34:42',3,'KES',-1,50,-50,'N',''); 25/04/2025 15:40:26.9155 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 15:43:59.0074 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 15:44:00.1131 1295 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 15:44:27.6155 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 15:49:02.7086 1965 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 15:55:04.4029 1171 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 15:56:08.6298 935 ms. EXEC: update payReceipt set recCreation = '2025-04-25 15:56:07',recModify = '2025-04-25 15:56:07',recUseId=0,recStatus='V' where recId = 373471 25/04/2025 15:56:58.5211 538 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16408, trcLastPrinted = '2500716408', trcLastDate = '2025-04-25 15:56:57' where trcStatus='V' and trcTerId = 18 25/04/2025 15:58:14.9111 1393 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 16:10:41.3695 684 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16411, trcLastPrinted = '2500716411', trcLastDate = '2025-04-25 16:10:40' where trcStatus='V' and trcTerId = 18 25/04/2025 16:12:39.4894 627 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/04/2025 16:12:44.4607 1260 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/04/2025 16:13:10.1618 1760 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-25 16:13:08' where traUID = 5034345154525940 and traStatus='V' and traEnabled=1 25/04/2025 16:18:32.7032 1105 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 16:27:02.7307 578 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,'2025-04-25 16:27:02','V',5042647189241890,2025,'2025-04-25 16:27:01','457705229300327005012999',2,2,2,'O','',0,'2025-04-25 16:27:02',1,'','',0) 25/04/2025 16:28:19.6881 570 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-04-25 16:28:19' where subId = 12 25/04/2025 16:28:22.3239 797 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/04/2025 16:28:31.1488 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 16:28:32.0263 862 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/04/2025 16:34:12.1276 1295 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/04/2025 16:35:18.7821 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 16:38:19.6899 753 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/04/2025 16:38:24.9504 1382 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/04/2025 16:38:41.6295 571 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,'2025-04-25 16:38:41','V',5574990844484850,2025,'2025-04-25 16:38:39','457705991900327005012999',1,2,16,'I','',1,0,1,'','',4) 25/04/2025 16:40:17.8788 632 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-25 16:40:17' where payTraUID = 5563879511611790 and payStatus='V' and payEnabled=1 25/04/2025 16:40:19.0766 1188 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-25 16:40:17' where traUID = 5563879511611790 and traStatus='V' and traEnabled=1 25/04/2025 16:40:33.6273 532 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/04/2025 16:44:23.7931 707 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 25/04/2025 16:45:02.6731 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 16:46:07.4283 701 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-04-25 16:46:06','0230003900848',0,0,5478343625552710,211,'0000-00-00 00:00:00','0000-00-00 00:00:00') 25/04/2025 16:50:22.8588 643 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/04/2025 16:51:55.6908 613 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/04/2025 16:53:31.9151 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 16:53:47.9288 1192 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/04/2025 16:54:12.7453 606 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 25/04/2025 16:56:01.7381 1347 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 16:56:34.8392 748 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/04/2025 16:56:57.7245 1170 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/04/2025 16:57:11.7088 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 16:58:07.9884 963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 16:59:26.3579 672 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/04/2025 17:00:55.2852 750 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 ('2025-04-25 17:00:54',0,'V',5405346533744270,4715790585267570,2025,'2025-04-25 17:00:54',18,1,0,4,'2025-04-25 17:15:54','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 25/04/2025 17:01:12.1135 1854 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 25/04/2025 17:01:13.0411 769 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,'2025-04-25 17:01:12','V',5592760413637690,2025,'2025-04-25 17:01:10','457706127000327005012999',1,2,16,'I','',1,0,1,'','',4) 25/04/2025 17:02:11.2460 580 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/04/2025 17:02:11.8964 646 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/04/2025 17:10:03.6748 598 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/04/2025 17:10:14.8332 509 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/04/2025 17:11:09.6899 2214 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/04/2025 17:13:31.9178 549 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 25/04/2025 17:15:21.5520 765 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/04/2025 17:15:22.6447 1730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:15:27.0077 533 ms. OPEN: SELECT * FROM tabuser WHERE useBadId<>'' AND (useBadId = '457705489900327005012999' OR useBadId = '457705489900327005012999') 25/04/2025 17:17:26.2953 1411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:20:44.9810 2385 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 17:20:44.9860 948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:20:54.2331 4142 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/04/2025 17:23:49.4621 722 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-25 17:23:48' where traUID = 5398994751066290 and traStatus='V' and traEnabled=1 25/04/2025 17:29:21.9725 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:39:14.3340 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:40:02.5802 1057 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:45:37.6059 2371 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:45:40.3697 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 17:47:47.3495 649 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/04/2025 17:53:19.3722 922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:53:58.7095 1987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:54:36.8710 1169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:54:59.5391 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 17:55:46.6686 2088 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 25/04/2025 18:01:56.6249 1450 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/04/2025 18:02:14.7530 644 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/04/2025 18:02:17.9622 562 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 25/04/2025 18:04:42.4647 942 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/04/2025 18:05:38.3530 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:07:43.1453 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:07:46.8698 680 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/04/2025 18:09:03.0046 1000 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 18:09:29.2522 1047 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 18:10:22.7959 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:12:18.4111 1896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:19:12.7017 1609 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 (WAIT TIME 9 ms.) 25/04/2025 18:19:32.7231 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:20:12.2585 1149 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-25 18:20:11' where payTraUID = 4722568979625200 and payStatus='V' and payEnabled=1 25/04/2025 18:20:19.2351 3472 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 25/04/2025 18:22:55.1953 618 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/04/2025 18:27:50.6031 1563 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 25/04/2025 18:28:58.6285 940 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/04/2025 18:29:16.5335 1389 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,'2025-04-25 18:29:15','V',4991662936073010,2025,'2025-04-25 18:29:14','457706655400327005012999',1,2,16,'I','',1,0,1,'','',4) 25/04/2025 18:29:33.5188 856 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16452, trcLastPrinted = '2500716452', trcLastDate = '2025-04-25 18:29:32' where trcStatus='V' and trcTerId = 18 25/04/2025 18:29:54.8211 702 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5457673227649600,5241862722167220,2025,'2025-04-25 18:29:54','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/25/2025 4:28:26 PM Date : 4/25/2025 6:29:53 PM Code : 457705930600327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 100.00 KES',0) 25/04/2025 18:30:28.0763 1227 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:32:51.1418 545 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 25/04/2025 18:33:07.0054 625 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/04/2025 18:33:09.6441 1169 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:33:12.5060 1852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:33:16.2525 507 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,'2025-04-25 18:33:15','V',5618410824992210,2025,'2025-04-25 18:33:15','457706577700327005012999',2,2,2,'O','',0,'2025-04-25 18:33:15',1,'','',0) 25/04/2025 18:35:35.8017 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:35:42.1960 665 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/04/2025 18:39:50.2456 534 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-25 18:39:49' where traUID = 5397461899167070 and traStatus='V' and traEnabled=1 25/04/2025 18:45:46.1522 681 ms. EXEC: update payReceipt set recCreation = '2025-04-25 18:45:45',recModify = '2025-04-25 18:45:45',recUseId=0,recStatus='V' where recId = 373537 25/04/2025 18:45:51.5549 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:45:55.1042 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:45:56.1159 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:53:23.7859 1813 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 25/04/2025 18:53:25.1918 541 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 ('2025-04-25 18:53:24',0,'V',4762225225132900,4797415132779190,2025,'2025-04-25 18:53:24',2,1,0,-1,'2025-04-25 19:53:24','S','KES',0,0,0,'','','',3,0,0) 25/04/2025 18:53:30.3263 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 18:53:32.8760 585 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 ('2025-04-25 18:53:32',0,'V',5320934921859890,5762289042698300,2025,'2025-04-25 18:53:32',18,1,0,4,'2025-04-25 19:08:32','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/04/2025 18:56:55.2361 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:59:13.9597 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 18:59:22.9067 530 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 = 12 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 25/04/2025 18:59:24.5488 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:00:31.7837 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:00:42.7530 832 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 25/04/2025 19:01:06.3698 934 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 19:03:42.7302 1176 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 = 9 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 25/04/2025 19:04:29.9507 1103 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 25/04/2025 19:05:37.8850 1024 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 19:11:28.6994 709 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/04/2025 19:12:41.1688 1334 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/04/2025 19:13:02.8012 996 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 ('2025-04-25 19:13:01',0,'V',5170739751442490,4701976144890870,2025,'2025-04-25 19:13:01',18,1,0,4,'2025-04-25 19:28:01','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 25/04/2025 19:13:35.8653 1938 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 ('2025-04-25 19:13:33',0,'V',5525749641882750,5228336587353470,2025,'2025-04-25 19:13:33',2,1,0,-1,'2025-04-25 20:13:33','S','KES',50,50,0,'','','',3,50,0,0,'',0,0) 25/04/2025 19:13:39.0714 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 19:13:59.8563 804 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-25 19:13:59',4,9,'2025-04-25 19:13:59','457706363000327005012999','Payed (Credit Card ) Ticket ') 25/04/2025 19:14:01.3223 1437 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 431117 else acvFstPayId end),acvLstPayId = 431117 where acvSftId = 989 and acvCodeId = 3 25/04/2025 19:14:31.9257 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:14:49.7716 792 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/04/2025 19:20:56.1162 1027 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-25 19:20:55',0,16,'2025-04-25 19:20:55','','Unauthorized Transit Entry 2') 25/04/2025 19:20:59.4004 597 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 25/04/2025 19:21:14.8767 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:21:42.3901 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:21:53.0612 531 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/04/2025 19:22:05.8658 782 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/04/2025 19:22:05.9068 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:23:14.4295 965 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:26:13.3640 1325 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:31:38.3690 899 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 12 ms.) 25/04/2025 19:35:44.9907 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:44:31.9280 887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:45:58.5308 1127 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:49:02.6628 930 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 19:52:03.0612 680 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-25 19:52:02' where traUID = 5661858632785250 and traStatus='V' and traEnabled=1 25/04/2025 19:52:06.6737 764 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/04/2025 19:55:54.1175 949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:56:18.5628 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:56:38.1879 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 19:58:25.5726 736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:01:52.6119 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:06:00.7850 1351 ms. EXEC: update abbCards set carLastDate = '2025-04-25 20:05:59',carLastDirection='O' where carStatus='V' and carId = 29 25/04/2025 20:06:14.9535 605 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,'2025-04-25 20:06:14','V',5280530990113340,2025,'2025-04-25 20:06:13','457707086100327005012999',2,2,2,'O','',0,'2025-04-25 20:06:14',1,'','',0) 25/04/2025 20:06:23.8514 904 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/04/2025 20:07:59.0090 1303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:08:06.5190 1018 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 20:18:28.8955 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:19:50.4699 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 20:26:28.8129 1036 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 20:30:02.6897 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:30:45.0770 876 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:34:46.3681 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:38:36.5868 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:45:23.3469 944 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-25 20:45:22',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'; 25/04/2025 20:45:41.1478 755 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 20:47:18.1526 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:48:05.7023 1153 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/04/2025 20:48:37.0933 667 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/04/2025 20:49:01.0633 1067 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 ('2025-04-25 20:48:59',0,'V',5668310768474020,5153261189554380,2025,'2025-04-25 20:48:59',2,1,0,-1,'2025-04-25 21:48:59','S','KES',0,0,0,'','','',3,0,0) 25/04/2025 20:49:02.0629 956 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,'2025-04-25 20:49:01','V',5461809208652020,2025,'2025-04-25 20:48:59','457702334200327005012999',2,2,2,'O','',0,'2025-04-25 20:49:01',1,'','0560008516054',163,0) 25/04/2025 20:49:02.7134 647 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/04/2025 20:49:20.5913 831 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-25 20:49:19' where traUID = 5293119978138470 and traStatus='V' and traEnabled=1 25/04/2025 20:49:24.6170 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 20:49:31.4386 1536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:49:36.1417 2926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:50:53.3623 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:51:33.1328 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:51:36.3550 1443 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:51:44.5264 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:51:44.5334 919 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/04/2025 20:52:00.9524 747 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/04/2025 20:52:02.2022 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:53:12.2180 711 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-25 20:53:11' where payTraUID = 4676266967021560 and payStatus='V' and payEnabled=1 25/04/2025 20:53:15.6493 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 20:54:09.8224 2120 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 21:04:21.1516 1086 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 21:06:51.3519 716 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/04/2025 21:07:00.7372 689 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 25/04/2025 21:07:26.0511 793 ms. EXEC: update payReceipt set recCreation = '2025-04-25 21:07:25',recModify = '2025-04-25 21:07:25',recUseId=0,recStatus='V' where recId = 373583 25/04/2025 21:08:40.9100 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 21:18:12.6915 822 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 21:23:36.7929 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 21:24:02.0447 1007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 21:24:12.5858 1646 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,'2025-04-25 21:24:10','V',5406747941931970,2025,'2025-04-25 21:24:10','457707705000327005012999',1,2,16,'I','',1,0,1,'','',4) 25/04/2025 21:28:10.2635 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 21:28:44.3732 2052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 21:29:00.6991 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 21:34:51.1251 1006 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/04/2025 21:35:38.3386 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 21:35:57.6785 578 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/04/2025 21:36:16.6062 951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 21:39:35.0147 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 21:42:37.4812 502 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/04/2025 21:44:10.0540 857 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-25 21:44:09' where traUID = 4700147880096070 and traStatus='V' and traEnabled=1 25/04/2025 21:44:51.6228 815 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 21:44:55.7875 1257 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 25/04/2025 21:45:01.5144 2389 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/04/2025 21:46:52.2343 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,'2025-04-25 21:46:51','V',5683108228134130,2025,'2025-04-25 21:46:51','457707841100327005012999',1,2,16,'I','',1,0,1,'','',4) 25/04/2025 21:52:29.0772 1058 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/04/2025 21:54:03.5493 613 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-25 21:54:02' where payTraUID = 5179397946753960 and payStatus='V' and payEnabled=1 25/04/2025 21:55:05.2945 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 21:55:17.6027 822 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 ('2025-04-25 21:55:16',0,'V',4663928392733000,5554644854439800,2025,'2025-04-25 21:55:16',18,1,0,4,'2025-04-25 22:10:16','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 25/04/2025 21:55:23.4896 544 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-25 21:55:22' where traUID = 4692347392451860 and traStatus='V' and traEnabled=1 25/04/2025 21:58:24.1873 580 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-25 21:58:23' where payTraUID = 5380130562911060 and payStatus='V' and payEnabled=1 25/04/2025 21:59:36.0083 819 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/04/2025 21:59:37.4542 1290 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 25/04/2025 22:01:38.9293 677 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-25 22:01:38',0,16,'2025-04-25 22:01:38','','Unauthorized Transit Entry 2') 25/04/2025 22:01:41.0367 1329 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 22:03:04.8027 730 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,'2025-04-25 22:03:04','V',4636689909206040,2025,'2025-04-25 22:03:03','457707938300327005012999',1,2,16,'I','',1,0,1,'','',4) 25/04/2025 22:03:31.9298 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 22:04:05.3071 920 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,'2025-04-25 22:04:04','V',5046935272431490,2025,'2025-04-25 22:04:03','457707944300327005012999',1,2,16,'I','',1,0,1,'','',4) 25/04/2025 22:04:57.9762 963 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,'2025-04-25 22:04:57','V',5695675538286490,2025,'2025-04-25 22:04:56','457707949600327005012999',1,2,16,'I','',1,0,1,'','',4) 25/04/2025 22:04:59.2101 1227 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/04/2025 22:06:48.7542 1524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 22:07:35.4033 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 22:07:36.2289 538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 25/04/2025 22:07:38.3163 541 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/04/2025 22:07:39.1588 526 ms. OPEN: select * from tabClass where claPosition = 2 25/04/2025 22:10:55.3612 647 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/04/2025 22:11:03.7918 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 22:16:18.6351 2848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 22:16:22.1974 1352 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 22:16:25.5657 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 22:18:12.7182 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 22:19:16.6759 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 22:20:20.8288 570 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-04-25 22:18:29',1,'V',4987420479891660,4792201192005530,2025,'2025-04-25 22:18:29',17,1,0,4,'2025-04-25 22:33:29','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 25/04/2025 22:20:22.4128 1413 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 431194 else acvFstPayId end),acvLstPayId = 431194 where acvSftId = 992 and acvCodeId = 3 25/04/2025 22:23:22.5151 515 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/04/2025 22:27:06.1594 1011 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 25/04/2025 22:27:07.0380 863 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 25/04/2025 22:27:08.8272 1354 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-04-25 22:27:07','0230003944081',0,0,5442359458526560,15,'0000-00-00 00:00:00','0000-00-00 00:00:00') 25/04/2025 22:29:42.6119 510 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 ('2025-04-25 22:29:42',0,'V',5557818743710860,5393577810631010,2025,'2025-04-25 22:29:42',18,1,0,4,'2025-04-25 22:44:42','C','KES',150,150,0,'','','',1,150,0,0,'',0,0) 25/04/2025 22:32:02.0290 1162 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 25/04/2025 22:34:44.6035 1684 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 25/04/2025 22:35:41.4364 861 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 25/04/2025 22:44:12.9250 910 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/04/2025 22:44:44.5511 809 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-25 22:44:43' where traUID = 4662102195693310 and traStatus='V' and traEnabled=1 25/04/2025 22:44:53.7952 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 22:46:27.1716 625 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-04-25 22:46:26',0,'V',4963413354517750,5695675538286490,2025,'2025-04-25 22:46:26',18,1,0,4,'2025-04-25 23:01:26','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 25/04/2025 22:46:28.2984 949 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5695675538286490,4963413354517750,2025,'2025-04-25 22:46:27',' Date: 4/25/2025 10:46:26 PM Code: 457707949600327005012999 Entry Date: 4/25/2025 10:04:56 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 # 2500716503 ',0) 25/04/2025 22:47:14.7614 1132 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 25/04/2025 22:47:40.1053 998 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,'2025-04-25 22:47:39','V',4873489394600300,2025,'2025-04-25 22:47:37','457707949600327005012999',2,2,2,'O','',0,'2025-04-25 22:47:39',1,'','',0) 25/04/2025 22:47:41.6503 1139 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-25 22:47:40' where payTraUID = 5695675538286490 and payStatus='V' and payEnabled=1 25/04/2025 22:47:54.9522 700 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 25/04/2025 22:48:50.8755 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 25/04/2025 22:50:10.8249 917 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-04-25 22:50:09','0810007118543',0,0,5703228550913600,126,'0000-00-00 00:00:00','0000-00-00 00:00:00') 25/04/2025 22:51:28.0425 539 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5681355269638900,5465690590886110,2025,'2025-04-25 22:51:27',' Date: 4/25/2025 10:51:26 PM Code: 457708091100327005012999 Entry Date: 4/25/2025 10:28:31 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 # 2500716505 ',0) 25/04/2025 22:52:37.6500 1132 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 23:00:21.8799 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 23:00:28.5584 1234 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 23:02:54.2136 597 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 25/04/2025 23:04:27.8672 1482 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 23:06:12.4614 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 23:16:16.8619 619 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 25/04/2025 23:27:53.8463 1692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 23:28:41.6842 1516 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 25/04/2025 23:29:49.4625 577 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 25/04/2025 23:36:05.5556 665 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 ('2025-04-25 23:36:04',0,'V',4658025237127240,5527885707629890,2025,'2025-04-25 23:36:04',18,1,0,4,'2025-04-25 23:51:04','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 25/04/2025 23:38:40.0888 1401 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 23:39:26.3847 969 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-25 23:39:25' where traUID = 5357520431910830 and traStatus='V' and traEnabled=1 25/04/2025 23:39:26.4097 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 23:39:49.4751 748 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 25/04/2025 23:45:49.5906 647 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 25/04/2025 23:45:57.1726 556 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 ('2025-04-25 23:45:37',9,'V',5725243057052450,5289971119064830,2025,'2025-04-25 23:45:37',4,1,0,4,'2025-04-26 00:00:37','P','KES',150,150,0,'','','',1,150,0,0,'',0,0) 25/04/2025 23:46:28.6566 562 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,'2025-04-25 23:46:28','V',4943187953772760,2025,'2025-04-25 23:46:27','457707735800327005012999',2,2,2,'O','',0,'2025-04-25 23:46:28',1,'','',0) 25/04/2025 23:46:44.8395 697 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 25/04/2025 23:49:53.0491 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 23:53:51.5053 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 25/04/2025 23:54:21.2992 1517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1