09/04/2025 04:56:48.1591 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 06:07:16.5100 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 06:12:11.3482 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 06:31:00.1476 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 06:33:06.2194 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 06:37:27.3382 797 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 09/04/2025 06:43:13.8081 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 06:46:32.0888 722 ms. EXEC: update tabTerminalReceipt set trcProgressive = 14355, trcLastPrinted = '2500714355', trcLastDate = '2025-04-09 06:46:31' where trcStatus='V' and trcTerId = 18 09/04/2025 06:46:35.2089 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 06:57:20.7194 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 06:59:30.2801 1109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:00:28.8624 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:00:46.9304 670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:01:35.0281 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:02:36.7464 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:02:39.1180 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:03:11.7808 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:15:05.1226 1418 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-09 07:15:03' where traUID = 4656070124432750 and traStatus='V' and traEnabled=1 09/04/2025 07:21:32.3758 2068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:21:52.0410 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:23:01.8771 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:23:02.1603 990 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 07:38:54.5190 1624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:39:00.4020 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:44:37.0208 1281 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:46:42.8961 1250 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:47:00.4988 1520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 07:47:07.9208 1623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 08:00:56.6913 649 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 09/04/2025 08:01:05.0559 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 08:12:59.7238 1393 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-09 08:12:38',5,3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-09 08:12:38',5,3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 09/04/2025 08:39:04.7684 811 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/04/2025 08:53:38.1270 509 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/04/2025 09:01:34.7371 1835 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 09/04/2025 09:01:56.0553 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 09:04:44.1685 1145 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/04/2025 09:05:04.5261 544 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/04/2025 09:07:59.5523 571 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/04/2025 09:09:44.8435 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 09:20:22.2423 732 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 09:27:02.6804 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 09:28:01.4497 1300 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 09:28:06.2800 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 09:28:35.4735 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 09:33:42.1071 1275 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 09:33:40','V',5404009130969540,2025,'2025-04-09 09:33:39','457543441900327005012999',1,2,16,'I','',1,0,1,'','',4) 09/04/2025 09:39:18.8490 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 09:39:29.5491 554 ms. OPEN: show columns from tabParameters where Field = 'parReentrySeconds' 09/04/2025 09:45:34.7675 598 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 09:46:19.7116 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 09:48:00.7763 1695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 09:48:03.4071 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 09:48:06.0238 1106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 09:51:06.1023 1074 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 09/04/2025 09:51:23.5940 1480 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 09:56:07.8171 1770 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 09/04/2025 09:56:10.9933 666 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788205271' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 09/04/2025 09:57:50.2198 1347 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 09/04/2025 09:58:34.3563 582 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 09/04/2025 09:58:45.7529 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:01:09.4651 2246 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 425643 else acvFstPayId end),acvLstPayId = 425643 where acvSftId = 959 and acvCodeId = 3 09/04/2025 10:01:32.9258 1787 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/04/2025 10:01:54.0339 1879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:03:40.7673 1728 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 10:03:40.7683 1597 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 10:03:39','V',5122441610723210,2025,'2025-04-09 10:03:38','457543360900327001012999',2,2,2,'O','',0,'2025-04-09 10:03:39',1,'','',0) 09/04/2025 10:05:07.3842 562 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/04/2025 10:05:43.3233 1056 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 10:06:31.8568 1309 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:07:14.2131 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:08:25.8510 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:08:41.2183 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:08:55.0085 1333 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:14:39.2723 1141 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/04/2025 10:15:06.1993 1120 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:21:11.4817 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:23:02.1027 1386 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:23:22.5133 682 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/04/2025 10:23:24.1704 1654 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-09 10:23:22' where payTraUID = 4850313404087150 and payStatus='V' and payEnabled=1 09/04/2025 10:23:28.6454 1084 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 10:23:38.3889 728 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/04/2025 10:23:38.3959 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:27:49.1537 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:32:24.6060 2729 ms. EXEC: update payInventory set invCreation = '2025-04-09 10:32:21',invModify = '2025-04-09 10:32:21',invUseId=0,invStatus='V' where invId = 245888 09/04/2025 10:38:25.4173 1245 ms. EXEC: update tabTerminalReceipt set trcProgressive = 14368, trcLastPrinted = '2500714368', trcLastDate = '2025-04-09 10.38.24' where trcStatus='V' and trcTerId = 18 09/04/2025 10:39:44.9636 588 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-09 10.39.44' where payTraUID = 5231082116239630 and payStatus='V' and payEnabled=1 09/04/2025 10:39:51.1567 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 10:46:57.4909 559 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 10:54:46.7138 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 10:56:29.4255 2726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 11:00:20.8233 1482 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 11:00:22.4084 1294 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 11:00:21','V',5131714446845790,2025,'2025-04-09 11:00:18','457543961800327001012999',1,2,1,'I','',1,0,1,'','',4) 09/04/2025 11:02:09.1878 1222 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 11:08:36.4269 558 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-09 11:08:35' where traUID = 5456673346343100 and traStatus='V' and traEnabled=1 09/04/2025 11:08:56.6985 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 11:09:12.8233 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 11:15:40.0493 595 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 11:20:22.3914 1010 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 09/04/2025 11:27:46.2714 526 ms. EXEC: update payReceipt set recCreation = '2025-04-09 11.27.45',recModify = '2025-04-09 11.27.45',recUseId=0,recStatus='V' where recId = 369005 09/04/2025 11:33:02.9422 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 11:38:16.4116 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 11:40:14.9549 977 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 11:40:28.7291 524 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 11:40:28','V',5633827572672600,2025,'2025-04-09 11:40:26','457543929100327005012999',2,2,2,'O','',0,'2025-04-09 11:40:28',1,'','',0) 09/04/2025 11:41:49.5231 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 11:42:08.3207 660 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-04-09 11:42:07',0,'V',4667058273803880,5203162509086650,2025,'2025-04-09 11:42:07',18,1,0,4,'2025-04-09 11:57:07','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/04/2025 11:47:40.7935 629 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 11:47:40','V',5145920282221500,2025,'2025-04-09 11:47:38','457544175300327001012999',2,2,2,'O','',0,'2025-04-09 11:47:40',1,'','',0) 09/04/2025 11:47:48.3495 782 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 11:50:01.3495 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 11:50:18.1267 768 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4655867647303610,5062211245103370,2025,'2025-04-09 11:50:17','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/9/2025 11:36:23 AM Date : 4/9/2025 11:50:16 AM Code : 457544178300327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 09/04/2025 11:58:22.9886 3087 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 11:58:19','V',5513916630546550,2025,'2025-04-09 11:58:18','457544309800327005012999',1,2,16,'I','',1,0,1,'','',4) 09/04/2025 11:58:32.0176 519 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 09/04/2025 11:58:37.6144 1033 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 09/04/2025 11:58:48.8629 1003 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 12:02:20.0672 1965 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 12:14:49.6856 770 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 12:20:37.8573 2322 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/04/2025 12:20:37.8724 2082 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 09/04/2025 12:20:44.5939 789 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-09 12:20:43',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 09/04/2025 12:20:46.0068 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 12:22:52.9426 701 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/04/2025 12:25:59.5249 2293 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 12:29:52.3136 2285 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 09/04/2025 12:38:50.7675 892 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 12:46:23.9056 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 12:47:48.3721 1131 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5513916630546550,5319878234138100,2025,'2025-04-09 12:47:47','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 4/9/2025 11:58:18 AM Date : 4/9/2025 12:47:44 PM Code : 457544309800327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 09/04/2025 12:47:50.5146 2069 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-09 12:47:48',0,0,'V',4611847416097550,5513916630546550,2025,'2025-04-09 12:47:48',3,'KES',1,100,100,'N',''); 09/04/2025 12:47:51.8645 1150 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-09 12:47:48',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'; 09/04/2025 12:47:54.1950 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 12:49:59.5599 616 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/04/2025 12:51:57.5028 720 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 12:52:13.2353 757 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/04/2025 12:52:16.1313 786 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/04/2025 12:55:43.1378 621 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 12:55:42','V',4751604622066320,2025,'2025-04-09 12:55:41','457543888300327005012999',2,2,2,'O','',0,'2025-04-09 12:55:42',1,'','',0) 09/04/2025 13:02:05.1429 537 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-09 13:02:04',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'; 09/04/2025 13:02:42.5990 1146 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 13:04:26.3904 1588 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 09/04/2025 13:13:31.4431 991 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 13:15:33.2706 841 ms. EXEC: update tabTerminalReceipt set trcProgressive = 14396, trcLastPrinted = '2500714396', trcLastDate = '2025-04-09 13:15:32' where trcStatus='V' and trcTerId = 18 09/04/2025 13:17:07.0763 588 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-09 13:17:06' where payTraUID = 5720199238194160 and payStatus='V' and payEnabled=1 09/04/2025 13:20:46.1570 509 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-09 13:20:45',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-09 13:20:45',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 09/04/2025 13:21:13.8685 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 13:21:16.5723 928 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 09/04/2025 13:21:39.3245 516 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 13:24:33.0228 507 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/04/2025 13:28:37.1012 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 13:29:48.3138 626 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/04/2025 13:36:20.8717 503 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 13:47:00.7474 527 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/04/2025 13:48:51.4229 1632 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/04/2025 13:50:41.9899 1039 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:05:21.5756 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:06:47.7395 1023 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 14:06:53.5084 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 14:12:32.1640 1011 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 14:16:14.8667 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:16:15.5592 1220 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 14:16:14','V',4982560552460850,2025,'2025-04-09 13:44:13','457544945300327001031999',3,2,1,'I','',1,0,1,'','',0) 09/04/2025 14:21:56.9583 1295 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:29:16.9606 547 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4824065266185980,4635389825969960,2025,'2025-04-09 14:29:16',' Date: 4/9/2025 2:29:15 PM Code: 457545143500327005012999 Entry Date: 4/9/2025 2:17:15 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 # 2500714426 ',0) 09/04/2025 14:29:21.5437 2381 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:29:23.4319 1232 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-09 14:29:22',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 ('2025-04-09 14:29:22',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 09/04/2025 14:30:42.0736 2006 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:39:47.2304 945 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-09 14:39:46',4,1,'2025-04-09 14:39:46','457544732700327005012999','Payed (Credit Card ) Ticket ') 09/04/2025 14:39:59.6557 1235 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-04-09 14:39:58',0,'V',4941771827250680,5288524467129350,2025,'2025-04-09 14:39:58',18,1,0,4,'2025-04-09 14:54:58','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 09/04/2025 14:40:00.5443 876 ms. EXEC: update tabTerminalReceipt set trcProgressive = 14429, trcLastPrinted = '2500714429', trcLastDate = '2025-04-09 14:39:59' where trcStatus='V' and trcTerId = 18 09/04/2025 14:43:41.8274 1671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:45:51.1220 512 ms. EXEC: update paycash set casCreation = '2025-04-09 14:45:50',casModify = '2025-04-09 14:45:50',casUseId=0,casStatus='V' where casId = 217208 09/04/2025 14:49:19.4824 891 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-09 14.49.18' where payTraUID = 5557939287917620 and payStatus='V' and payEnabled=1 09/04/2025 14:54:26.2507 585 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 09/04/2025 14:56:29.9645 634 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 14:56:29','V',4745305954103990,2025,'2025-04-09 14:56:28','457544928300327005012999',2,2,2,'O','',0,'2025-04-09 14:56:29',1,'','',0) 09/04/2025 14:56:36.0856 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:56:37.6557 732 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-04-09 14:56:36',0,'V',4895931252510140,4772204494996990,2025,'2025-04-09 14:56:36',18,1,0,4,'2025-04-09 15:11:36','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 09/04/2025 14:58:01.4998 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:58:16.9751 1922 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:58:17.0092 2483 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-09 14:58:14',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 ('2025-04-09 14:58:14',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 09/04/2025 14:59:53.1945 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 14:59:56.3887 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 15:10:49.7842 613 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-04-09 15:10:49','0230004100967',0,0,4871380409575890,12,'0000-00-00 00:00:00','0000-00-00 00:00:00') 09/04/2025 15:10:52.0657 526 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-09 15:10:51' where traUID = 4738089503121270 and traStatus='V' and traEnabled=1 09/04/2025 15:16:24.6793 866 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 15:16:23','V',5446192371429410,2025,'2025-04-09 15:16:21','457545399600327005012999',2,2,2,'O','',0,'2025-04-09 15:16:23',1,'','',0) 09/04/2025 15:16:25.9842 689 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-09 15:16:24' where traUID = 5594140359006740 and traStatus='V' and traEnabled=1 09/04/2025 15:18:09.2853 507 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-09 15:18:08' where traUID = 5173689165424450 and traStatus='V' and traEnabled=1 09/04/2025 15:20:24.6659 1596 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 09/04/2025 15:23:42.0961 625 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/04/2025 15:31:03.7389 532 ms. OPEN: select * from tabTerminal where terId = 2 (WAIT TIME 10 ms.) 09/04/2025 15:40:33.6964 562 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-09 15:40:32',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-09 15:40:32',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 09/04/2025 15:49:19.2592 662 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 15:49:18','V',5697906684597130,2025,'2025-04-09 15:31:42','457545590200327001031999',3,2,1,'I','',1,0,1,'','',0) 09/04/2025 15:49:33.5688 959 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/04/2025 15:53:04.6010 1010 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/04/2025 15:53:28.0627 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 15:54:00.1742 571 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5617345903130870,5257256094841370,2025,'2025-04-09 15:53:59',' Date: 4/9/2025 3:53:59 PM Code: 457545530800327005012999 Entry Date: 4/9/2025 3:21:48 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 # 2500714449 ',0) 09/04/2025 15:58:41.3153 782 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 09/04/2025 15:58:43.9231 552 ms. EXEC: update payReceipt set recCreation = '2025-04-09 15:58:43',recModify = '2025-04-09 15:58:43',recUseId=0,recStatus='V' where recId = 369154 09/04/2025 16:04:07.4908 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 16:04:09.7633 713 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 16:04:09','V',5648360804253430,2025,'2025-04-09 16:04:08','457545189500327001031999',2,2,2,'O','',0,'2025-04-09 16:04:09',1,'','',0) 09/04/2025 16:11:14.1107 527 ms. EXEC: update abbCards set carLastDate = '2025-04-09 16:11:13',carLastDirection='I' where carStatus='V' and carId = 183 09/04/2025 16:11:25.0230 532 ms. EXEC: update payInventory set invCreation = '2025-04-09 16:11:24',invModify = '2025-04-09 16:11:24',invUseId=0,invStatus='V' where invId = 245966 09/04/2025 16:17:00.6866 1287 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 16:22:26.4028 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 16:37:11.3430 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 16:44:34.2053 857 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 09/04/2025 16:46:16.1595 940 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 16:46:26.8136 1127 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 16:53:38.6567 2158 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-04-09 16:53:36','V',5488895158613920,2025,'2025-04-09 16:22:23','457545894300327001031999',3,2,1,'I','',1,0,1,'','',0) 09/04/2025 17:02:42.1207 963 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/04/2025 17:04:27.9955 549 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-09 17:04:27',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'; 09/04/2025 17:04:29.1003 1102 ms. EXEC: update payInventory set invCreation = '2025-04-09 17:04:27',invModify = '2025-04-09 17:04:27',invUseId=0,invStatus='V' where invId = 245975 09/04/2025 17:44:11.3130 16878 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 09/04/2025 17:44:11.3630 16864 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 68 ms.) 09/04/2025 17:44:24.6396 12313 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 09/04/2025 17:44:24.7296 11247 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191867' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 09/04/2025 17:44:24.7937 11611 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788198671' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 09/04/2025 17:44:26.4208 695 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketDisabled' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 09/04/2025 17:44:27.4605 1030 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 13 09/04/2025 17:44:28.5662 1988 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-04-09 17.44.26','V',5081038100283980,2025,'2025-04-09 17.42.29','457546132800327002029999',2,1,2,'O','',1,0,1,'','0532370684175',158,0) 09/04/2025 17:44:28.5672 1101 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-04-09 17.44.27','V',5761504082882310,2025,'2025-04-09 17.43.45','457546132800327005029999',2,2,16,'I','',1,0,1,'','0532370677371',13,0) 09/04/2025 17:44:29.5038 926 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/04/2025 17:44:29.8080 5010 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/04/2025 17:44:32.4458 2637 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); 09/04/2025 17:46:49.0078 19046 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 09/04/2025 17:48:35.8068 709 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370676842' and traDirection='I' order by traId desc limit 1 09/04/2025 18:02:12.6239 1637 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 09/04/2025 18:08:38.6060 1318 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 09/04/2025 18:24:58.2007 1567 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 09/04/2025 18:30:45.2302 547 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/04/2025 18:35:50.1408 1915 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 11 order by traDateTime desc,traId desc 09/04/2025 18:52:06.5189 1329 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 09/04/2025 19:20:39.1498 1777 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 09/04/2025 19:28:12.3687 2062 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 09/04/2025 22:36:42.3277 1910 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 09/04/2025 22:49:41.6640 1283 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 09/04/2025 23:59:55.6770 502 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc