07/11/2024 08:19:55.1935 719 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 07/11/2024 08:36:41.6109 631 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 07/11/2024 08:41:30.2972 501 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 18 order by traDateTime desc,traId desc 07/11/2024 08:53:14.1184 512 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 07/11/2024 09:14:18.5149 1491 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 07/11/2024 09:34:24.6050 528 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 07/11/2024 09:40:33.9237 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 07/11/2024 09:54:26.6885 559 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-07 09:54:26',0,16,'2024-11-07 09:54:26','','Unauthorized Transit Entry 2') 07/11/2024 10:13:31.0577 4773 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 07/11/2024 10:15:04.1940 884 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 07/11/2024 11:00:23.0146 2571 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 07/11/2024 11:00:24.6437 1610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 11:00:25.4262 781 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); 07/11/2024 11:07:34.6742 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 480 ms.) 07/11/2024 11:08:40.9103 1668 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-07 11:08:39' where payTraUID = 5278686330987720 and payStatus='V' and payEnabled=1 07/11/2024 11:13:14.4315 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 11:13:16.0576 544 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 11:13:15','V',4962324094930180,2024,'2024-11-07 11:13:14','456014039400327005012999',1,2,16,'I','',1,0,1,'','',4) 07/11/2024 11:15:22.1846 1117 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 11:12:52',1,'V',5509146260728050,5353857848404970,2024,'2024-11-07 11:12:52',4,1,0,4,'2024-11-07 11:27:52','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/11/2024 11:15:23.1182 542 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15696, trcLastPrinted = '2400415696', trcLastDate = '2024-11-07 11:15:22' where trcStatus='V' and trcTerId = 4 07/11/2024 11:20:44.6985 527 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-07 11:20:44',0,'V',5745456358910000,5269369684335510,2024,'2024-11-07 11:20:44',2,1,0,-1,'2024-11-07 12:20:44','S','KES',0,0,0,'','','',3,0,0) 07/11/2024 11:26:08.7473 1308 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 11:26:48.4398 558 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-07 11:26:47' where traUID = 4843536350015790 and traStatus='V' and traEnabled=1 07/11/2024 11:30:28.3543 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 11:30:29.6711 979 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5474852306489770,5729495787991830,2024,'2024-11-07 11:30:28','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/7/2024 10:57:16 AM Date : 11/7/2024 11:30:23 AM Code : 456013943600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 07/11/2024 11:30:43.0821 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 11:33:17.1207 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 11:40:01.2489 785 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4831784868559930,5245615854455820,2024,'2024-11-07 11:40:00',' Date: 11/7/2024 11:40:00 AM Code: 456013317400327005012999 Entry Date: 11/7/2024 9:12:54 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400748669 ',0) 07/11/2024 11:46:31.3978 512 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/11/2024 11:46:32.4155 1374 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 11:46:33.1410 725 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); 07/11/2024 11:47:04.4398 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 11:50:09.6001 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 11:50:58.1795 663 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-07 11:50:57',0,16,'2024-11-07 11:50:57','','Manual Open Barrier Entry 2') 07/11/2024 11:58:40.7386 1008 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-07 11:58:39',0,'V',5004605432947810,5415501487370620,2024,'2024-11-07 11:58:39',2,1,0,-1,'2024-11-07 12:58:39','S','KES',0,0,0,'','','',3,0,0) 07/11/2024 12:01:42.6348 1416 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 12:06:22.2343 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 12:10:58.7415 538 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '456013506900327005012999' 07/11/2024 12:11:08.7131 518 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 07/11/2024 12:11:09.5927 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 12:13:26.6610 1044 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/11/2024 12:14:39.0352 924 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 07/11/2024 12:18:43.1258 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 12:25:04.2787 1039 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/11/2024 12:26:56.7206 667 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 12:28:55.8930 591 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48677, trcLastPrinted = '2400748677', trcLastDate = '2024-11-07 12:28:55' where trcStatus='V' and trcTerId = 18 07/11/2024 12:28:57.6192 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 12:30:09.3429 585 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-07 12:30:08' where subId = 15 07/11/2024 12:30:28.1495 998 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 07/11/2024 12:32:17.7235 516 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 12:32:40.4876 701 ms. EXEC: update payReceipt set recCreation = '2024-11-07 12:32:39',recModify = '2024-11-07 12:32:39',recUseId=0,recStatus='V' where recId = 320068 07/11/2024 12:34:37.1864 1574 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-07 12:34:35','V',5205724864000860,2024,'2024-11-07 12:34:33','456014527300327001012999',1,2,1,'I','',1,0,1,'','0230003943530',44,0) 07/11/2024 12:36:49.1463 945 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6910, trcLastPrinted = '2400606910', trcLastDate = '2024-11-07 12:36:48' where trcStatus='V' and trcTerId = 17 07/11/2024 12:37:01.4865 877 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 12:37:00','V',5500368053487310,2024,'2024-11-07 12:36:59','456014124500327005012999',2,2,2,'O','',0,'2024-11-07 12:37:00',1,'','',0) 07/11/2024 12:37:19.7957 1749 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/11/2024 12:39:02.2349 1314 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentToConfirm' 07/11/2024 12:39:02.9994 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 12:40:06.6388 5621 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 07/11/2024 12:40:09.0634 722 ms. OPEN: select * from tabTerminal where terId = 2 07/11/2024 12:44:08.0086 1146 ms. EXEC: update payInventory set invCreation = '2024-11-07 12:44:06',invModify = '2024-11-07 12:44:06',invUseId=0,invStatus='V' where invId = 217750 07/11/2024 12:45:58.0889 707 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 12:45:57',0,'V',5012537713417230,5034033946260800,2024,'2024-11-07 12:45:57',18,1,0,4,'2024-11-07 13:00:57','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/11/2024 12:45:59.1967 1030 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48682, trcLastPrinted = '2400748682', trcLastDate = '2024-11-07 12:45:58' where trcStatus='V' and trcTerId = 18 07/11/2024 12:46:23.0456 596 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 12:46:22','V',5485629220469820,2024,'2024-11-07 12:46:21','456014512400327005031999',2,2,2,'O','',0,'2024-11-07 12:46:22',1,'','',0) 07/11/2024 12:47:10.0519 529 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/11/2024 12:48:00.1603 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 12:49:05.1716 2031 ms. EXEC: update payInventory set invCreation = '2024-11-07 12:49:03',invModify = '2024-11-07 12:49:03',invUseId=0,invStatus='V' where invId = 217751 07/11/2024 12:52:24.9176 1219 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/11/2024 12:53:09.1821 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 12:55:24.4662 582 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 12:55:23','V',5645071373357500,2024,'2024-11-07 12:55:23','456014652300327005012999',1,2,16,'I','',1,0,1,'','',4) 07/11/2024 12:57:22.2707 749 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/11/2024 12:59:22.9481 834 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 12:59:24.1089 628 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-07 12:59:23' where traUID = 4862318693741810 and traStatus='V' and traEnabled=1 07/11/2024 12:59:48.6612 989 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 12:59:59.4624 2874 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/11/2024 13:04:35.8105 694 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 13:02:35',12,'V',5759346997230600,5094399238198470,2024,'2024-11-07 13:02:35',17,1,0,4,'2024-11-07 13:17:35','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/11/2024 13:04:36.3989 566 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-07 13:04:35',17,12,'2024-11-07 13:04:35','456014593100327005012999','Pagato (Contanti ) Biglietto ') 07/11/2024 13:04:57.5320 1253 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:07:07.5376 729 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:08:46.3444 547 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 13:08:43',0,'V',5032139309781880,5511573605227970,2024,'2024-11-07 13:08:43',3,1,0,4,'2024-11-07 13:23:43','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 07/11/2024 13:08:48.1816 1281 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 13:08:46',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'; 07/11/2024 13:08:52.6326 876 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:11:17.2850 886 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:11:29.5311 2956 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:11:37.7436 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:12:40.9077 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:13:13.6895 1743 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/11/2024 13:13:14.8713 1034 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 13:13:13','V',5324828253101270,2024,'2024-11-07 13:13:11','456014759100327005012999',1,2,16,'I','',1,0,1,'','',4) 07/11/2024 13:13:17.0197 2146 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 13:14:58.0860 1050 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 13:15:26.5770 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:15:44.6451 623 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-07 13:15:44','V',4844740662682610,2024,'2024-11-07 13:15:41','456014658500327005012999',2,2,2,'O','',0,'2024-11-07 13:15:44',1,'','0810007108790',194,0) 07/11/2024 13:16:36.2494 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,'2024-11-07 13:16:35','V',5393188919197820,2024,'2024-11-07 13:15:43','456014774300327005031999',1,2,16,'I','',1,0,1,'','',4) 07/11/2024 13:17:45.6096 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:18:21.7197 1641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:18:23.2837 693 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/11/2024 13:20:13.9394 613 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4777434336102990,5443739660141880,2024,'2024-11-07 13:20:13','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/7/2024 11:40:05 AM Date : 11/7/2024 1:20:10 PM Code : 456014200500327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 07/11/2024 13:22:53.3046 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:23:31.0037 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:24:07.4500 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:24:18.2302 694 ms. EXECSCALAR: select terAddress from tabTerminal where terId = 16 nr: 5 07/11/2024 13:24:19.2138 596 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-07 13:24:18',0,0,'V',5373425255514700,4747881227110890,2024,'2024-11-07 13:24:18',3,'KES',1,50,50,'N',''); 07/11/2024 13:26:20.2805 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:26:31.2708 1350 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/11/2024 13:26:59.4616 2420 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 13:26:57','V',5085783802479780,2024,'2024-11-07 13:26:56','456014652300327005012999',2,2,2,'O','',0,'2024-11-07 13:26:57',1,'','',0) 07/11/2024 13:28:37.0906 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:28:48.4592 653 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-07 13:28:47' where traUID = 5040561652250400 and traStatus='V' and traEnabled=1 07/11/2024 13:28:54.9175 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:29:14.1933 2067 ms. EXEC: update payInventory set invCreation = '2024-11-07 13:29:12',invModify = '2024-11-07 13:29:12',invUseId=0,invStatus='V' where invId = 217760 07/11/2024 13:29:28.3668 2153 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-07 13:29:26' where traUID = 5453622444109840 and traStatus='V' and traEnabled=1 07/11/2024 13:30:15.6373 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:31:22.6269 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:31:39.2229 684 ms. EXEC: update payReceipt set recCreation = '2024-11-07 13:31:38',recModify = '2024-11-07 13:31:38',recUseId=0,recStatus='V' where recId = 320099 07/11/2024 13:31:39.9134 636 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-07 13:31:39',0,0,'V',4878166020759940,5665068780944370,2024,'2024-11-07 13:31:39',3,'KES',1,50,50,'N',''); 07/11/2024 13:31:45.1619 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:32:17.5455 889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:34:44.1391 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:35:59.6955 1063 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 298 ms.) 07/11/2024 13:36:39.5610 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:37:10.7208 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:37:35.8845 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:38:10.3035 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:39:07.7367 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:39:16.9559 826 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:40:33.3347 1725 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:41:40.8437 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:41:40.8447 644 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 17 and payDateTime = '2024-11-07 13:39:40' nr: 0 07/11/2024 13:41:41.7833 637 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/11/2024 13:41:42.4168 633 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 13:41:42.7540 1717 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 13:39:40',12,'V',4762319263197130,4987409735252270,2024,'2024-11-07 13:39:40',17,1,0,4,'2024-11-07 13:54:40','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) (WAIT TIME 1 ms.) 07/11/2024 13:41:44.6773 1732 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-07 13:41:42',17,12,'2024-11-07 13:41:42','456014405900327005012999','Pagato (Contanti ) Biglietto ') 07/11/2024 13:41:44.7283 1652 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 13:41:43','V',5306819356744880,2024,'2024-11-07 13:41:41','456014930100327001012999',1,2,1,'I','',1,0,1,'','',4) (WAIT TIME 51 ms.) 07/11/2024 13:41:45.8591 654 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6917, trcLastPrinted = '2400606917', trcLastDate = '2024-11-07 13:41:45' where trcStatus='V' and trcTerId = 17 07/11/2024 13:41:50.4551 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:43:20.2920 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:43:24.8400 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:43:25.3493 1097 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:43:37.3563 715 ms. EXEC: update payReceipt set recCreation = '2024-11-07 13:43:36',recModify = '2024-11-07 13:43:36',recUseId=0,recStatus='V' where recId = 320107 07/11/2024 13:43:57.9160 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:44:02.0748 1229 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 771431 07/11/2024 13:44:02.0978 1302 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 13:44:00','V',5608774225516650,2024,'2024-11-07 13:43:59','456014943900327005012999',1,2,16,'I','',1,0,1,'','',4) 07/11/2024 13:44:02.7342 551 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 13:42:01',12,'V',5628698532140180,5393188919197820,2024,'2024-11-07 13:42:01',17,1,0,4,'2024-11-07 13:57:01','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/11/2024 13:44:25.8156 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:44:28.8506 1779 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 13:44:43.9617 1654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:44:52.5184 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:46:59.7762 796 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 13:46:58','V',5074357579143860,2024,'2024-11-07 13:46:58','456014774300327005031999',2,2,2,'O','',0,'2024-11-07 13:46:58',1,'','',0) 07/11/2024 13:47:06.5987 836 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:47:17.0767 794 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-07 13:47:16',0,16,'2024-11-07 13:47:16','','Unauthorized Transit Entry 2') 07/11/2024 13:47:32.7621 1952 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:47:33.5056 538 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/11/2024 13:48:17.3148 1555 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4763585751746370,5653086501100550,2024,'2024-11-07 13:48:15',' Date: 11/7/2024 1:48:15 PM Code: 456014782100327005012999 Entry Date: 11/7/2024 1:17:01 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 # 2400748689 ',0) 07/11/2024 13:49:16.8855 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:49:31.5203 613 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4808710797342880,5017205816714150,2024,'2024-11-07 13:49:30','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/7/2024 12:41:45 PM Date : 11/7/2024 1:49:28 PM Code : 456014570500327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 07/11/2024 13:50:21.8158 542 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 13:50:21','V',5277122321058510,2024,'2024-11-07 13:50:19','456014981900327005012999',1,2,16,'I','',1,0,1,'','',4) 07/11/2024 13:51:47.8100 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:51:58.9445 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:52:21.9578 748 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-07 13:52:21' where traUID = 4856517072432590 and traStatus='V' and traEnabled=1 07/11/2024 13:52:30.3614 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:52:47.0345 512 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 13:55:40.1968 1559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:56:18.2892 810 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:56:28.1258 1557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 13:56:52.2298 617 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 13:56:51',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 07/11/2024 13:56:54.3242 1288 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:57:11.4967 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 13:57:53.2545 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:00:43.0516 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 14:01:14.9288 1332 ms. EXEC: update payReceipt set recCreation = '2024-11-07 14:01:13',recModify = '2024-11-07 14:01:13',recUseId=0,recStatus='V' where recId = 320119 07/11/2024 14:02:17.9278 1615 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 14:02:16',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 14:02:16',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'; 07/11/2024 14:02:27.1079 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:02:45.6963 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 14:04:52.3247 702 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 14:06:51.2179 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:07:55.9880 1796 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 771411 07/11/2024 14:07:56.9767 1610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:08:03.3019 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 14:09:04.5777 616 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/11/2024 14:09:04.6057 643 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 07/11/2024 14:09:05.7325 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 14:09:37.5907 520 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 14:09:45.1307 727 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 14:10:31.8879 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:10:36.9222 1145 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/11/2024 14:11:35.8725 1450 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/11/2024 14:11:35.8735 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:11:35.8825 872 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/11/2024 14:13:19.0102 1154 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/11/2024 14:13:19.7297 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 14:13:22.9278 2362 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:13:23.6463 873 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/11/2024 14:16:05.9864 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 14:20:47.8512 1444 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-07 14:20:45' where traUID = 4771956084833040 and traStatus='V' and traEnabled=1 07/11/2024 14:21:05.3508 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:21:12.2805 3004 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/11/2024 14:21:12.4225 1334 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:21:31.6744 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:23:44.5779 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:25:32.8110 1002 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-07 14:25:30',0,0,'V',5530140220364110,4810781600907630,2024,'2024-11-07 14:25:30',3,'KES',1,100,100,'N',''); (WAIT TIME 953 ms.) 07/11/2024 14:26:26.8850 1787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:28:50.6468 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:31:21.9386 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:33:58.5929 781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:34:19.2407 1037 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 14:34:17',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 07/11/2024 14:36:47.0341 506 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-07 14:36:46','V',5573806607890900,2024,'2024-11-07 14:36:32','456015197100327005029999',2,2,16,'I','',1,0,1,'','0532370673239',164,0) 07/11/2024 14:38:12.4200 1086 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:38:12.5571 1187 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/11/2024 14:41:08.2942 657 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-07 14:41:07' where traUID = 4647618769209040 and traStatus='V' and traEnabled=1 07/11/2024 14:43:18.2427 1889 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:44:05.0739 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:44:25.0552 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 14:46:06.3007 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 14:46:27.0465 661 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 14:46:23',0,'V',5761748137910010,5489729731000330,2024,'2024-11-07 14:46:23',3,1,0,4,'2024-11-07 15:01:23','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 07/11/2024 14:48:32.6562 1069 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:49:26.8943 618 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 14:50:28.4333 754 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 14:50:27',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 07/11/2024 14:52:25.0660 696 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 14:52:24','V',4686155378545190,2024,'2024-11-07 14:52:23','456015202600327005012999',2,2,2,'O','',0,'2024-11-07 14:52:24',1,'','',0) 07/11/2024 14:52:26.6751 934 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '456015202600327005012999' 07/11/2024 14:52:27.6477 972 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-07 14:52:25' where payTraUID = 5160765212301630 and payStatus='V' and payEnabled=1 07/11/2024 14:52:27.9789 2238 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:52:38.9793 670 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 14:54:31.5292 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:54:45.1233 1850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:55:41.2227 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:55:53.6940 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:56:35.8411 858 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:56:56.5719 2207 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-07 14:56:54' where traUID = 4696800792049620 and traStatus='V' and traEnabled=1 07/11/2024 14:58:40.1789 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 14:59:14.6118 584 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5485917793410240,5604405142120520,2024,'2024-11-07 14:59:14',' Date: 11/7/2024 2:59:13 PM Code: 456015379500327005012999 Entry Date: 11/7/2024 2:56:35 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 # 2400748699 ',0) 07/11/2024 15:00:01.7692 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:01:02.5657 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:01:58.4390 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:03:03.0410 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:04:09.3261 747 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 15:04:07',0,'V',4872592268472690,4908906906188580,2024,'2024-11-07 15:04:07',18,1,0,4,'2024-11-07 15:19:07','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/11/2024 15:04:10.1857 695 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4908906906188580,4872592268472690,2024,'2024-11-07 15:04:09',' Date: 11/7/2024 3:04:07 PM Code: 456015326600327005012999 Entry Date: 11/7/2024 2:47:46 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 # 2400748701 ',0) 07/11/2024 15:05:18.3882 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:06:10.4208 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:07:18.9755 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:08:44.9217 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:09:10.0114 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:10:11.9527 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:10:19.5828 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:10:41.0751 1579 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 07/11/2024 15:10:41.1051 2017 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:10:49.3977 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:11:12.8853 2468 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:11:14.8856 1186 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 15:12:01.9080 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:12:25.1614 1137 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 15:12:23',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 15:12:23',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 15:12:23',3,42101,0,500,-1,-500,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 07/11/2024 15:12:44.7485 1454 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 15:12:43','V',5313847854813040,2024,'2024-11-07 15:12:42','456015178000327001012999',2,2,2,'O','',0,'2024-11-07 15:12:43',1,'','',0) 07/11/2024 15:12:46.9410 1403 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-07 15:12:45' where traUID = 4995139511585290 and traStatus='V' and traEnabled=1 07/11/2024 15:14:57.7921 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:15:00.3098 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:15:18.7051 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:15:57.6450 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:17:23.7874 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:17:27.1106 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:17:55.8958 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:19:15.1386 562 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-07 15:19:14',4,1,'2024-11-07 15:19:14','456015186600327005012999','Payed (Credit Card ) Ticket ') 07/11/2024 15:19:16.8327 1231 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5063285923584020,5008529700531720,2024,'2024-11-07 15:19:15',' Date: 11/7/2024 3:16:45 PM Code: 456015186600327005012999 Entry Date: 11/7/2024 2:24:26 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400415724 ',0) 07/11/2024 15:19:17.7413 1459 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:25:42.8528 739 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 07/11/2024 15:27:23.8301 997 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/11/2024 15:27:41.2647 657 ms. EXEC: update payReceipt set recCreation = '2024-11-07 15:27:40',recModify = '2024-11-07 15:27:40',recUseId=0,recStatus='V' where recId = 320168 07/11/2024 15:28:12.1243 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:29:00.7056 518 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 15:28:59',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'; 07/11/2024 15:30:04.5922 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:30:37.6142 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:30:39.5595 876 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48708, trcLastPrinted = '2400748708', trcLastDate = '2024-11-07 15:30:38' where trcStatus='V' and trcTerId = 18 07/11/2024 15:30:47.7259 603 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 15:30:47','V',5490409103962690,2024,'2024-11-07 15:30:45','456015584500327001012999',1,2,1,'I','',1,0,1,'','',4) 07/11/2024 15:32:48.3793 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:33:25.5370 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:42:13.6569 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:44:02.8586 983 ms. EXEC: update paycash set casCreation = '2024-11-07 15:44:01',casModify = '2024-11-07 15:44:01',casUseId=0,casStatus='V' where casId = 193641 07/11/2024 15:45:10.8499 1157 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:47:17.6103 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:47:57.6270 831 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 15:47:56',0,'V',5092523532319750,5040960416165190,2024,'2024-11-07 15:47:56',2,1,0,-1,'2024-11-07 16:47:56','S','KES',50,50,0,'','','',3,50,0,0,'',0,0) 07/11/2024 15:50:22.7557 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:50:23.4611 817 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/11/2024 15:51:11.2600 1088 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 15:52:03.9060 978 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:53:24.9731 643 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15729, trcLastPrinted = '2400415729', trcLastDate = '2024-11-07 15:53:24' where trcStatus='V' and trcTerId = 4 07/11/2024 15:53:41.2079 1603 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/11/2024 15:53:50.2459 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:56:07.5423 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 15:56:07.6334 681 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 15:56:18.8139 594 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 07/11/2024 15:56:41.4749 1342 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:57:40.8315 533 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 15:57:51.0963 1301 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 15:58:24.9429 625 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/11/2024 15:58:30.3094 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:00:22.2080 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:01:11.9591 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:03:44.9350 560 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/11/2024 16:03:50.6138 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:09:45.2751 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:10:04.7561 1336 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:10:53.6546 737 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:16:14.2242 1219 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:17:17.7745 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:20:12.0746 844 ms. EXEC: update payReceipt set recCreation = '2024-11-07 16:20:11',recModify = '2024-11-07 16:20:11',recUseId=0,recStatus='V' where recId = 320193 07/11/2024 16:20:21.8782 642 ms. EXEC: update abbCards set carLastDate = '2024-11-07 16:20:21',carLastDirection='I' where carStatus='V' and carId = 15 07/11/2024 16:20:38.0519 1544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:21:33.4578 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:22:46.9508 512 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 07/11/2024 16:22:47.2590 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:23:21.6849 557 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 16:26:56.0147 1169 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 16:26:58.0721 624 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5604991775426750,5462567037507300,2024,'2024-11-07 16:26:57',' Date: 11/7/2024 4:26:57 PM Code: 456015473100327005012999 Entry Date: 11/7/2024 3:12:11 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 # 2400748720 ',0) 07/11/2024 16:29:57.6917 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:30:33.7518 2692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:31:58.7684 796 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 07/11/2024 16:33:15.3744 1688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:35:53.1745 1138 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1 ms.) 07/11/2024 16:36:04.6572 1436 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:38:59.3325 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:40:59.5616 580 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 16:41:07.5259 728 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5723908931196410,4847808342516550,2024,'2024-11-07 16:41:06',' Date: 11/7/2024 4:41:06 PM Code: 456015936200327005012999 Entry Date: 11/7/2024 4:29:22 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 # 2400748721 ',0) 07/11/2024 16:41:10.8301 2320 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/11/2024 16:41:21.7294 3657 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 16:41:36.9055 1071 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:46:59.3803 2212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:47:16.1005 2383 ms. OPEN: select * from payCurInventory where curTerId = 18 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 07/11/2024 16:47:16.2686 2101 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:48:20.4033 895 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48723, trcLastPrinted = '2400748723', trcLastDate = '2024-11-07 16:48:19' where trcStatus='V' and trcTerId = 18 07/11/2024 16:49:47.5504 1019 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 16:49:46','V',4727064749607860,2024,'2024-11-07 16:49:44','456016058400327005012999',1,2,16,'I','',1,0,1,'','',4) 07/11/2024 16:49:55.8599 1388 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 16:49:54','V',5495519218458920,2024,'2024-11-07 16:49:53','456015819700327001012999',2,2,2,'O','',0,'2024-11-07 16:49:54',1,'','',0) 07/11/2024 16:49:57.1147 774 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-07 16:49:56' where payTraUID = 5187079083732740 and payStatus='V' and payEnabled=1 07/11/2024 16:49:59.8586 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:50:03.2938 3779 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/11/2024 16:50:24.8162 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:54:06.7570 859 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 16:54:12.3628 1219 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:54:44.9114 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:54:59.7984 3755 ms. EXEC: update paycash set casCreation = '2024-11-07 16:54:56',casModify = '2024-11-07 16:54:56',casUseId=0,casStatus='V' where casId = 193657 07/11/2024 16:55:52.1602 547 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 16:56:06.0575 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:57:40.1242 883 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:57:47.4210 1821 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48725, trcLastPrinted = '2400748725', trcLastDate = '2024-11-07 16:57:45' where trcStatus='V' and trcTerId = 18 07/11/2024 16:58:12.8279 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 16:59:13.1521 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 16:59:25.6785 2014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:00:37.9656 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:01:58.9206 918 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 07/11/2024 17:01:58.9736 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:04:48.6286 1074 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/11/2024 17:04:49.3311 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 17:05:05.7570 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 17:06:01.1349 608 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/11/2024 17:08:13.8263 1325 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/11/2024 17:09:11.0784 1916 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 07/11/2024 17:11:20.7898 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 17:11:27.3802 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:15:14.0762 1563 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 07/11/2024 17:16:27.9595 806 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 17:16:26',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 17:16:26',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'; 07/11/2024 17:16:28.6890 727 ms. EXEC: update payInventory set invCreation = '2024-11-07 17:16:27',invModify = '2024-11-07 17:16:27',invUseId=0,invStatus='V' where invId = 217817 07/11/2024 17:16:30.1119 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:16:37.3367 702 ms. EXEC: update abbCards set carLastDate = '2024-11-07 17:16:36',carLastDirection='O' where carStatus='V' and carId = 19 07/11/2024 17:18:36.9474 557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:19:02.7806 582 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-07 17:19:02',0,'V',5697490101364260,5011651482537950,2024,'2024-11-07 17:19:02',2,1,0,-1,'2024-11-07 18:19:02','S','KES',0,0,0,'','','',3,0,0) 07/11/2024 17:19:08.7576 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 17:19:46.4107 993 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:19:51.8103 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:27:28.0932 669 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-07 17:27:27','0230004101194',0,0,5763533518997510,30,'0000-00-00 00:00:00','0000-00-00 00:00:00') 07/11/2024 17:27:59.6632 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 17:29:02.9844 1729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:31:51.9080 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:31:55.9396 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 17:32:38.5800 512 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 17:32:38','V',5005770052426370,2024,'2024-11-07 17:32:37','456016315700327005012999',1,2,16,'I','',1,0,1,'','',4) 07/11/2024 17:32:41.7001 2550 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15738, trcLastPrinted = '2400415738', trcLastDate = '2024-11-07 17:32:39' where trcStatus='V' and trcTerId = 4 07/11/2024 17:32:41.8732 2589 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/11/2024 17:36:55.2430 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 185 ms.) 07/11/2024 17:37:12.8708 2199 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:39:43.7953 1641 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 17:40:57.7105 526 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4727064749607860,5253592909395830,2024,'2024-11-07 17:40:57','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/7/2024 4:49:44 PM Date : 11/7/2024 5:40:56 PM Code : 456016058400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 07/11/2024 17:41:56.7058 935 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 17:42:02.4947 654 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 17:46:13.3188 801 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 17:46:23.3685 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 17:49:46.1275 1481 ms. EXEC: update abbCards set carLastDate = '2024-11-07 17:49:44',carLastDirection='O' where carStatus='V' and carId = 88 07/11/2024 17:52:30.5030 913 ms. EXEC: update abbCards set carLastDate = '2024-11-07 17:52:29',carLastDirection='O' where carStatus='V' and carId = 102 07/11/2024 17:59:59.1509 1021 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-07 17:59:58' where payTraUID = 5308334860054820 and payStatus='V' and payEnabled=1 07/11/2024 18:00:17.0498 831 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 368432 else acvFstPayId end),acvLstPayId = 368432 where acvSftId = 822 and acvCodeId = 3 07/11/2024 18:02:38.7903 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 18:03:18.5247 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:08:14.7320 1212 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/11/2024 18:08:20.6830 697 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 18:08:24.7217 1382 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/11/2024 18:08:51.0953 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:09:41.9822 1638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:09:47.2697 1422 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:10:00.2623 584 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 18:10:15.3374 1743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:11:47.4037 1404 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 18:12:48.4364 719 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-07 18:12:47',0,'V',5051523533945670,5253049547536940,2024,'2024-11-07 18:12:47',2,1,0,-1,'2024-11-07 19:12:47','S','KES',0,0,0,'','','',3,0,0) 07/11/2024 18:12:49.9914 1446 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 18:15:12.8776 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:17:09.5903 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 18:18:22.5229 2793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:18:22.6730 2346 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 18:18:20',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 07/11/2024 18:18:43.4238 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 18:20:21.5762 524 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 18:20:21',0,'V',4829803494632490,4975160305398870,2024,'2024-11-07 18:20:21',18,1,0,4,'2024-11-07 18:35:21','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 07/11/2024 18:20:34.2827 514 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-07 18:20:33' where payTraUID = 5060400574867780 and payStatus='V' and payEnabled=1 07/11/2024 18:23:17.7026 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:23:17.7026 717 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '456016362800327005012999' 07/11/2024 18:24:12.2369 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 18:26:39.8462 515 ms. OPEN: select * from tabTerminalReceipt where trcStatus='V' and trcTerId = 3 order by trcId desc limit 1 07/11/2024 18:26:41.6754 504 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 18:26:40',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'; 07/11/2024 18:28:24.7681 696 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/11/2024 18:28:24.8241 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:28:55.7587 864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:28:59.1380 1377 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 18:29:56.8785 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:31:17.2980 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:32:27.5198 954 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:34:13.2853 1603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:35:01.1912 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:38:17.4279 1590 ms. EXEC: update paycash set casCreation = '2024-11-07 18:38:15',casModify = '2024-11-07 18:38:15',casUseId=0,casStatus='V' where casId = 193669 07/11/2024 18:38:19.2161 1786 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-07 18:38:15',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 07/11/2024 18:38:55.5693 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:39:02.9092 950 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' (WAIT TIME 2 ms.) 07/11/2024 18:40:31.0229 2233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:41:39.7567 639 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 18:41:39','V',5321195174208370,2024,'2024-11-07 18:41:38','456015798700327005012999',2,2,2,'O','',0,'2024-11-07 18:41:39',1,'','',0) 07/11/2024 18:41:41.0576 1201 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/11/2024 18:41:45.8467 714 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 18:42:17.1196 596 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 07/11/2024 18:49:49.2608 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 18:54:09.3270 820 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-07 18:54:08','0750009518612',0,0,5413492433051620,99,'0000-00-00 00:00:00','0000-00-00 00:00:00') 07/11/2024 18:57:12.0948 667 ms. EXEC: update abbCards set carLastDate = '2024-11-07 18:57:11',carLastDirection='I' where carStatus='V' and carId = 15 07/11/2024 18:59:19.0323 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 18:59:41.1541 1172 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 19:02:52.3784 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 19:06:39.0354 861 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 19:13:21.8738 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 19:13:27.1523 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 19:17:27.8486 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 19:17:45.3093 553 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 19:20:13.7321 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 19:21:07.4049 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 19:21:08.0473 821 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/11/2024 19:21:08.7228 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 19:21:23.1344 689 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 19:21:22',0,'V',4849021501355300,4784516226851870,2024,'2024-11-07 19:21:22',18,1,0,4,'2024-11-07 19:36:22','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/11/2024 19:28:22.1975 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 19:38:51.4237 662 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 19:40:07.1401 793 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/11/2024 19:47:56.0635 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 19:51:41.2895 523 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-07 19:51:40' where payTraUID = 4855429413215570 and payStatus='V' and payEnabled=1 07/11/2024 19:51:54.3853 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 19:54:03.0660 1084 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 19:56:16.0396 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:01:28.4447 1231 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-07 20:01:27' where payTraUID = 5545878421013440 and payStatus='V' and payEnabled=1 07/11/2024 20:01:37.6988 1259 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-07 20:01:36','V',5428773420525790,2024,'2024-11-07 20:01:35','456017209500327005012999',1,2,16,'I','',1,0,1,'','0560008529778',171,0) 07/11/2024 20:01:43.9600 611 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 20:08:18.6619 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:13:38.7131 1916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:15:02.6511 1595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:15:17.3448 531 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 20:15:26.4369 653 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-07 20:15:25',0,16,'2024-11-07 20:15:25','','Unauthorized Transit Entry 2') 07/11/2024 20:15:54.0043 638 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/11/2024 20:21:20.8290 552 ms. EXEC: update payInventory set invCreation = '2024-11-07 20:21:20',invModify = '2024-11-07 20:21:20',invUseId=0,invStatus='V' where invId = 217836 07/11/2024 20:23:50.5707 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:25:05.6788 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:29:35.3014 589 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5136517229767600,4712522924454240,2024,'2024-11-07 20:29:34','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/7/2024 7:47:52 PM Date : 11/7/2024 8:29:33 PM Code : 456017127200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 07/11/2024 20:30:16.1776 628 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/11/2024 20:30:39.8354 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:31:46.1836 803 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 20:31:45','V',4683179829480790,2024,'2024-11-07 20:31:43','456017127200327005012999',2,2,2,'O','',0,'2024-11-07 20:31:45',1,'','',0) 07/11/2024 20:32:25.5118 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 20:32:57.8803 574 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-07 20:32:57' where subId = 185 07/11/2024 20:35:04.9920 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:35:17.2752 1013 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 20:37:32.1790 1106 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 20:37:29',0,'V',5666150730157630,4706517879113820,2024,'2024-11-07 20:37:29',3,1,0,4,'2024-11-07 20:52:29','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 07/11/2024 20:37:35.1070 878 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4706517879113820,5666150730157630,2024,'2024-11-07 20:37:34','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/7/2024 8:09:55 PM Date : 11/7/2024 8:37:29 PM Code : 456017259500327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 07/11/2024 20:38:13.5416 634 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/11/2024 20:38:23.1230 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 20:44:04.9647 833 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/11/2024 20:45:26.5570 951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:47:41.5170 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:48:43.3301 983 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 20:53:26.1405 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 20:54:49.1979 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 20:56:02.9380 726 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/11/2024 21:02:00.6192 649 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/11/2024 21:02:19.0996 930 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 21:02:19.2026 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:07:37.5607 1302 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:09:42.5980 2245 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:10:09.6120 555 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 21:10:10.3185 703 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/11/2024 21:14:14.0148 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:15:20.5992 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:18:20.1708 967 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/11/2024 21:19:34.8795 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:22:16.7614 625 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/11/2024 21:23:34.9074 851 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/11/2024 21:37:20.2823 840 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 21:38:09.0387 1771 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 07/11/2024 21:38:09.0457 2587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:39:13.3866 845 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 21:39:27.2859 839 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/11/2024 21:43:36.4398 2042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:45:22.9908 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:46:13.7246 2229 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:46:29.9164 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:49:50.5741 761 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 21:49:51.4386 1723 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/11/2024 21:49:51.4396 637 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 07/11/2024 21:50:26.8903 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:57:18.5585 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 21:59:01.7823 700 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:00:13.3399 1405 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:00:21.9236 791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:02:19.5440 739 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 07/11/2024 22:05:48.1189 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:06:37.2347 1321 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:10:05.7526 678 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-07 22:10:05','V',4984354777088410,2024,'2024-11-07 22:10:04','456017980400327005012999',1,2,16,'I','',1,0,1,'','',4) 07/11/2024 22:11:39.5020 615 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-07 22:11:38' where traUID = 5563677435527910 and traStatus='V' and traEnabled=1 07/11/2024 22:11:44.8486 513 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 22:11:45.1488 869 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 22:17:18.7400 611 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 07/11/2024 22:17:20.5732 1038 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 22:20:52.0771 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:21:33.8059 853 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:21:53.7772 545 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 22:21:53',0,'V',5517249969416720,5534906404318400,2024,'2024-11-07 22:21:53',18,1,0,4,'2024-11-07 22:36:53','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/11/2024 22:21:54.4587 544 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48760, trcLastPrinted = '2400748760', trcLastDate = '2024-11-07 22:21:53' where trcStatus='V' and trcTerId = 18 07/11/2024 22:21:55.5634 1083 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5534906404318400,5517249969416720,2024,'2024-11-07 22:21:54',' Date: 11/7/2024 10:21:53 PM Code: 456017742200327001012999 Entry Date: 11/7/2024 9:30:22 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400748760 ',0) 07/11/2024 22:24:32.9863 668 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-07 22:24:32',0,'V',5656290760723060,5554387278898870,2024,'2024-11-07 22:24:32',18,1,0,4,'2024-11-07 22:39:32','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/11/2024 22:32:28.8813 1606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:33:28.7592 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:34:37.5800 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:37:36.5562 1039 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 22:38:22.1526 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 22:39:46.8300 556 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/11/2024 22:39:50.9177 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 22:41:00.0108 1557 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 22:46:00.9683 686 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/11/2024 22:53:56.6471 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:11:21.9224 1834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:13:55.3526 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:16:47.8956 658 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 23:16:47.8976 583 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 23:19:46.6747 847 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-07 23:19:45',0,'V',5722466732860970,4729554199465680,2024,'2024-11-07 23:19:45',2,1,0,-1,'2024-11-08 00:19:45','S','KES',0,0,0,'','','',3,0,0) 07/11/2024 23:20:23.4572 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:22:42.7079 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:29:05.0677 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:31:57.8558 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:31:58.6513 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:32:06.7677 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:32:27.5986 1098 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:34:54.5204 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/11/2024 23:36:30.4543 727 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 07/11/2024 23:37:17.3856 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:43:35.7647 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:44:44.4204 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:48:17.9586 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:50:10.1054 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:51:29.8155 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:53:52.0122 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:53:56.7613 794 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/11/2024 23:53:56.7633 707 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 23:54:02.5742 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/11/2024 23:58:46.0210 2376 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/11/2024 23:59:50.1167 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1