05/11/2024 00:05:43.5517 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 00:06:46.5027 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 00:18:04.5394 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 00:25:38.9187 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 00:45:18.6022 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 00:48:20.1604 566 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/11/2024 01:50:27.4406 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 02:03:33.6424 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 02:31:05.0248 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 02:45:22.0059 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 02:45:23.2107 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 03:24:25.0810 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 03:31:48.0187 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 03:39:49.6252 519 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/11/2024 03:52:32.7807 1029 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 03:54:45.1931 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 03:57:39.3903 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 04:08:54.0677 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 04:10:18.4811 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 04:39:35.9273 561 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 04:41:32.4771 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 04:45:39.5460 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 04:50:04.0636 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 05:43:00.8043 1205 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 05:56:48.1716 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 05:56:51.4828 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 05:58:36.4699 1091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 06:08:20.0664 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 06:09:52.1749 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 06:21:37.8000 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 06:49:02.5610 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 06:51:24.9120 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 06:54:44.0849 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 06:57:27.5681 1217 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:00:14.5986 862 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 07:00:59.5916 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:12:08.4841 979 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 07:12:55.9078 785 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 05/11/2024 07:12:55.9398 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:13:49.9299 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:14:54.8232 1322 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:15:56.8556 1252 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:17:41.8167 1293 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 07:17:40',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-05 07:17:40',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'; 05/11/2024 07:18:25.2557 1566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:19:04.7850 1680 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 05/11/2024 07:21:34.0597 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 07:23:41.5288 1407 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/11/2024 07:25:55.0219 1147 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:37:01.9551 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:37:10.0645 1001 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 07:40:33.1271 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 07:43:46.0469 773 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-05 07:41:15',6,'V',4685366107688470,5211214782076500,2024,'2024-11-05 07:41:15',4,1,0,4,'2024-11-05 07:56:15','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 07:43:50.1996 2310 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/11/2024 07:45:56.4940 2955 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 07:45:57.8529 1262 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 07:48:29.2509 522 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-05 07:48:27',0,'V',4642844433758820,5682680803224390,2024,'2024-11-05 07:48:27',3,1,0,4,'2024-11-05 08:03:27','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 05/11/2024 07:49:15.3157 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:49:20.2049 563 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48328, trcLastPrinted = '2400748328', trcLastDate = '2024-11-05 07:49:19' where trcStatus='V' and trcTerId = 18 05/11/2024 07:51:04.9999 894 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/11/2024 07:52:17.3872 1660 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 07:52:18.4890 1086 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 07:52:46.5277 1076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 07:55:47.7547 782 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:00:06.4564 2196 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 08:00:04' where traUID = 5298119516773460 and traStatus='V' and traEnabled=1 05/11/2024 08:00:41.3617 1381 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-05 08:00:39',0,16,'2024-11-05 08:00:39','','Unauthorized Transit Entry 2') 05/11/2024 08:03:39.5816 1302 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:03:43.1290 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:08:05.4101 1121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:09:23.0419 1911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:12:47.2903 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:13:21.1108 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:14:05.6866 873 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-05 08:11:35',6,'V',5511215437153090,5674590498353840,2024,'2024-11-05 08:11:35',4,1,0,4,'2024-11-05 08:26:35','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/11/2024 08:17:51.6674 562 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-05 08:17:51','V',5457820052200710,2024,'2024-11-05 08:17:44','455992986400327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 08:17:53.3806 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:17:54.5053 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:18:11.4477 1292 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 08:19:03.7596 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:22:27.8308 1076 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 08:24:57.0444 614 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 08:24:56' where traUID = 5474551170494740 and traStatus='V' and traEnabled=1 05/11/2024 08:28:13.1513 525 ms. EXEC: update abbCards set carLastDate = '2024-11-05 08:28:12',carLastDirection='I' where carStatus='V' and carId = 156 05/11/2024 08:28:13.1934 514 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5184447123155230,5672019524213860,2024,'2024-11-05 08:28:12',' Date: 11/5/2024 8:28:12 AM Code: 455992929100327005012999 Entry Date: 11/5/2024 8:08:11 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400748330 ',0) 05/11/2024 08:30:27.6241 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:30:49.1715 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:35:05.1614 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:37:59.9520 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:40:19.9735 1283 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:41:03.5056 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:45:38.5552 979 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-05 08:45:37','V',5592226856093180,2024,'2024-11-05 08:45:36','455992967900327005012999',2,2,2,'O','',0,'2024-11-05 08:45:37',1,'','',0) 05/11/2024 08:50:08.3223 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:56:38.8280 1270 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 08:57:37.9955 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:02:16.6295 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:10:17.8077 965 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 09:13:25.2208 644 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 09:13:49.6051 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 09:14:21.9226 649 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 09:14:35.7148 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:14:49.1958 769 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-05 09:14:48','V',5727142523273610,2024,'2024-11-05 09:14:46','455993136400327001012999',2,2,2,'O','',0,'2024-11-05 09:14:48',1,'','',0) 05/11/2024 09:15:01.8283 532 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 09:17:41.0836 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:19:56.6641 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:20:36.3926 1021 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:20:40.3773 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:25:02.2261 1243 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,0,50,-11,-550,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,0,50,11,550,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,0,100,-35,-3500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,0,100,35,3500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,0,200,-4,-800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,0,200,4,800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,0,500,-4,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,0,500,4,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:24:44',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 05/11/2024 09:25:06.0246 724 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/11/2024 09:25:13.0183 1636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:25:13.0193 1642 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 09:28:15.5181 1251 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/11/2024 09:28:52.1946 949 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:28:47',5,3,42101,0,50,12,600,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+12,5),curAmount=round(curAmount+600,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 09:28:47',5,3,42101,0,100,4,400,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+4,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 05/11/2024 09:29:01.9161 645 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-05 09:29:01','V',4786391401626110,2024,'2024-11-05 09:28:59','455990000100327003229999',22,22,3,'I','',1,0,1,'','',2) 05/11/2024 09:29:10.9761 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:31:49.0146 1347 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:32:39.4943 1046 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 09:32:53.3806 605 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 09:33:47.4737 1221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:33:50.5278 1959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:36:03.2383 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:37:08.1887 807 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 05/11/2024 09:37:24.6897 779 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/11/2024 09:37:27.0503 706 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 09:37:33.8388 1804 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 09:37:34.1670 676 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-05 09:37:33',0,'V',5403674699028220,4814265579304930,2024,'2024-11-05 09:37:33',18,1,0,4,'2024-11-05 09:52:33','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 09:37:34.8945 594 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4814265579304930,5403674699028220,2024,'2024-11-05 09:37:34',' Date: 11/5/2024 9:37:33 AM Code: 455993299300327005012999 Entry Date: 11/5/2024 9:09:53 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400748331 ',0) 05/11/2024 09:37:36.3215 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:38:47.0737 934 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 09:38:47.8863 570 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 09:38:47' where payTraUID = 4814265579304930 and payStatus='V' and payEnabled=1 05/11/2024 09:38:52.3452 1451 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:38:52.3452 921 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 09:38:55.9346 2742 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/11/2024 09:41:55.1343 994 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 09:41:55.5695 782 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc 05/11/2024 09:41:55.9678 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:41:55.9728 718 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 05/11/2024 09:41:56.2160 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 09:44:07.7858 502 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 09:44:28.0113 688 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5685679048183000,4832652394149590,2024,'2024-11-05 09:44:27','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/5/2024 8:50:05 AM Date : 11/5/2024 9:44:26 AM Code : 455993180500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 05/11/2024 09:44:29.3872 754 ms. EXEC: update paycash set casCreation = '2024-11-05 09:44:28',casModify = '2024-11-05 09:44:28',casUseId=0,casStatus='V' where casId = 193286 05/11/2024 09:44:48.0307 1030 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' 05/11/2024 09:45:26.1571 1246 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 09:45:26.1942 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:47:49.2957 1499 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:50:04.1147 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 09:50:37.0747 707 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-05 09:50:36',0,16,'2024-11-05 09:50:36','','Unauthorized Transit Entry 2') 05/11/2024 09:50:44.7978 1142 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 09:51:00.4333 541 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/11/2024 09:52:14.1615 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:54:30.8507 590 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-05 09:54:30','V',5232972834972010,2024,'2024-11-05 09:54:28','455993566800327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 09:54:40.5232 917 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:55:21.7657 911 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-05 09:55:20','V',5422557224612130,2024,'2024-11-05 09:55:18','455993571800327005012999',1,2,16,'I','',1,0,1,'','0810007113876',103,0) 05/11/2024 09:57:50.3259 1365 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 09:59:05.4941 777 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/11/2024 09:59:51.2646 661 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5310217756262240,5234647029433690,2024,'2024-11-05 09:59:50','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/5/2024 9:14:53 AM Date : 11/5/2024 9:59:50 AM Code : 455993329300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 05/11/2024 10:00:47.2510 561 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-05 10:00:46','V',5582941775039930,2024,'2024-11-05 10:00:44','455993604400327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 05/11/2024 10:00:49.1943 602 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 10:02:58.6467 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:03:16.1134 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:05:37.8445 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:05:42.1834 1318 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 10:05:47.5630 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 10:05:48.4586 793 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); (WAIT TIME 85 ms.) 05/11/2024 10:05:48.9919 533 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/11/2024 10:08:10.5164 1197 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:08:58.9628 1461 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 10:09:04.3804 661 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-05 10:09:03','V',4654364909866530,2024,'2024-11-05 10:09:02','455993654200327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 10:10:11.9635 741 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 10:10:15.7620 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 10:10:48.4769 1189 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 10:10:53.5593 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:11:00.5139 595 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 10:11:00.7371 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:11:48.8662 1595 ms. OPEN: select * from movtransit where traUID = 4824696850974180 and traStatus='V' 05/11/2024 10:11:48.9022 2160 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-05 10:11:46','V',5742809370716700,2024,'2024-11-05 10:11:45','455993670500327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 10:12:00.7751 1577 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 10:14:05.2873 510 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 10:14:09.9974 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 10:14:10.5328 991 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:15:11.5355 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 10:15:45.8654 643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:19:45.3503 910 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-05 10:19:44','V',4625269650232920,2024,'2024-11-05 10:19:42','455993668600327005012999',2,2,2,'O','',0,'2024-11-05 10:19:44',1,'','',0) 05/11/2024 10:19:57.9417 520 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 10:20:22.3119 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 10:20:25.5551 1192 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15568, trcLastPrinted = '2400415568', trcLastDate = '2024-11-05 10:20:24' where trcStatus='V' and trcTerId = 4 05/11/2024 10:25:30.8299 829 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-05 10:25:30',4,6,'2024-11-05 10:25:30','455993545600327005012999','Payed (Credit Card ) Ticket ') 05/11/2024 10:25:44.5741 767 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-05 10:25:43',4,6,'2024-11-05 10:25:43','455993610000327005012999','Payed (Credit Card ) Ticket ') 05/11/2024 10:25:59.1298 524 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 10:26:56.9924 1172 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:28:26.8444 632 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-05 10:28:26','V',4889244819191410,2024,'2024-11-05 10:28:25','455993721600327005012999',2,2,2,'O','',0,'2024-11-05 10:28:26',1,'','',0) 05/11/2024 10:28:30.5018 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 10:29:09.1616 1148 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-05 10:26:38',6,'V',5102198763743060,4963477106026410,2024,'2024-11-05 10:26:38',4,1,0,4,'2024-11-05 10:41:38','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 10:31:23.5614 2228 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-05 10:31:21',0,'V',5356601678937600,5597676866790790,2024,'2024-11-05 10:31:21',18,1,0,4,'2024-11-05 10:46:21','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) (WAIT TIME 5 ms.) 05/11/2024 10:32:48.1548 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:34:04.2897 545 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 10:35:32.1523 1146 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 10:36:22.6060 778 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:36:29.7668 1911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:37:26.8309 573 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 10:37:26' where payTraUID = 5742809370716700 and payStatus='V' and payEnabled=1 05/11/2024 10:37:30.9506 765 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 10:38:58.1248 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:39:34.6502 1298 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 10:41:07.9855 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:41:14.0375 2197 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 10:43:14.3579 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:44:10.8766 2296 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5457820052200710,5138260951081120,2024,'2024-11-05 10:44:08','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/5/2024 8:17:44 AM Date : 11/5/2024 10:44:07 AM Code : 455992986400327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 05/11/2024 10:44:15.7498 2379 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/11/2024 10:45:20.4110 959 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-05 10:45:19','V',4864137158763470,2024,'2024-11-05 10:45:18','455993871800327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 10:45:51.1725 511 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 10:46:04.9377 1093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:47:15.9291 1003 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 10:47:14' where traUID = 5217580292200090 and traStatus='V' and traEnabled=1 05/11/2024 10:51:16.8890 2315 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 10:51:56.5745 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:52:05.3453 1493 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-05 10:52:03',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-05 10:52:03',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'; 05/11/2024 10:54:07.6590 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:55:42.7935 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:55:54.4283 3128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:57:02.4367 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:57:03.3763 694 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 10:57:02' where payTraUID = 5679893051926990 and payStatus='V' and payEnabled=1 (WAIT TIME 241 ms.) 05/11/2024 10:57:19.5451 884 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:57:45.2262 728 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 10:57:51.7746 604 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-05 10:57:51',0,'V',4789883952873020,5582941775039930,2024,'2024-11-05 10:57:51',2,1,0,-1,'2024-11-05 11:57:51','S','KES',0,0,0,'','','',3,0,0) 05/11/2024 10:58:28.4471 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:58:33.8357 2071 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 10:58:58.4691 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 14 ms.) 05/11/2024 10:59:15.7597 1092 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 10:59:44.8711 1617 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-05 10:59:42',0,'V',5642139954933590,5224852877644510,2024,'2024-11-05 10:59:42',3,1,0,4,'2024-11-05 11:14:42','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 05/11/2024 11:00:34.5633 2061 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-05 11:00:32','V',4953369382128770,2024,'2024-11-05 11:00:30','455993963000327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 11:01:35.2738 740 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:02:00.4176 2203 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 05/11/2024 11:02:49.4143 871 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-05 11:02:48','V',4965934136016620,2024,'2024-11-05 11:02:47','455993763800327005012999',2,2,2,'O','',0,'2024-11-05 11:02:48',1,'','',0) 05/11/2024 11:03:26.6421 1081 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-05 11:03:25','V',5395757589172300,2024,'2024-11-05 11:03:24','455993848900327005012999',2,2,2,'O','',0,'2024-11-05 11:03:25',1,'','',0) 05/11/2024 11:03:28.6755 1337 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 11:03:27' where traUID = 4768922065548100 and traStatus='V' and traEnabled=1 05/11/2024 11:03:31.2332 1048 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:04:06.7739 1445 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-05 11:04:05','V',5707850647941120,2024,'2024-11-05 11:04:04','455993984400327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 11:04:10.3313 825 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 11:04:10.6165 1102 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 05/11/2024 11:04:20.1559 1335 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/11/2024 11:04:24.6509 1061 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-05 11:04:23',0,0,'V',4619622425925220,5577939200318540,2024,'2024-11-05 11:04:23',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-05 11:04:23',0,0,'V',4619622425925220,5577939200318540,2024,'2024-11-05 11:04:23',3,'KES',-1,100,-100,'N',''); 05/11/2024 11:04:25.5354 825 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 11:04: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-05 11:04:23',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'; 05/11/2024 11:05:50.5852 1419 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:06:14.2450 1885 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 11:06:45.8021 659 ms. OPEN: show columns from tabAbbGroups where Field = 'abgAbbType' 05/11/2024 11:06:55.2964 552 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15576, trcLastPrinted = '2400415576', trcLastDate = '2024-11-05 11:06:54' where trcStatus='V' and trcTerId = 4 05/11/2024 11:06:56.2901 610 ms. EXEC: update payReceipt set recCreation = '2024-11-05 11:06:55',recModify = '2024-11-05 11:06:55',recUseId=0,recStatus='V' where recId = 319353 05/11/2024 11:07:25.7437 1072 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 11:07:40.3685 1036 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-05 11:07:39',4,6,'2024-11-05 11:07:39','455993675000327005012999','Payed (Credit Card ) Ticket ') 05/11/2024 11:08:23.4913 2121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:08:23.4913 1896 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 05/11/2024 11:08:59.0881 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:09:12.6781 2415 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 11:09:10' where traUID = 4787173138265540 and traStatus='V' and traEnabled=1 05/11/2024 11:09:16.6378 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:09:17.5134 1285 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:09:17.5134 1264 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 05/11/2024 11:09:24.9803 966 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 11:10:18.3240 1633 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 11:10:21.6472 1194 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:10:32.0511 814 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 11:10:33.4461 858 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 11:10:34.1615 543 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 11:10:40.2776 570 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 11:12:31.3648 1545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:12:40.9962 1257 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:12:48.2520 1135 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:15:13.6541 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:15:23.5317 2425 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 11:15:53.3056 652 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 11:16:29.3386 1011 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-05 11:16:28',0,'V',4830893721768960,5506034005889740,2024,'2024-11-05 11:16:28',3,1,0,4,'2024-11-05 11:31:28','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 05/11/2024 11:16:50.4077 543 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 11:16:53.5398 1118 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 11:16:57.8607 2530 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 05/11/2024 11:17:12.6615 720 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:17:46.7083 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:18:02.1146 674 ms. OPEN: show columns from payPayment where Field = 'payVatAmount' 05/11/2024 11:18:04.6112 1571 ms. EXEC: update payInventory set invCreation = '2024-11-05 11:18:03',invModify = '2024-11-05 11:18:03',invUseId=0,invStatus='V' where invId = 217407 05/11/2024 11:18:05.3617 568 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 11:18:04',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'; 05/11/2024 11:19:14.9332 807 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-05 11:19:13',0,'V',4772254196654190,4648855477813530,2024,'2024-11-05 11:19:13',3,1,0,4,'2024-11-05 11:34:13','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 05/11/2024 11:19:29.2027 978 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 11:19:51.8018 2167 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-05 11:19:49','V',5720565937899330,2024,'2024-11-05 11:19:48','455994078800327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 11:19:52.4412 635 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 11:19:58.7274 2175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:20:04.1680 1315 ms. EXEC: update paycash set casCreation = '2024-11-05 11:20:02',casModify = '2024-11-05 11:20:02',casUseId=0,casStatus='V' where casId = 193308 05/11/2024 11:20:07.5923 2991 ms. EXEC: update payInventory set invCreation = '2024-11-05 11:20:04',invModify = '2024-11-05 11:20:04',invUseId=0,invStatus='V' where invId = 217411 05/11/2024 11:20:07.9576 2866 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 11:21:00.7628 535 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 367389 else acvFstPayId end),acvLstPayId = 367389 where acvSftId = 818 and acvCodeId = 3 05/11/2024 11:23:11.1989 1075 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 11:23:28.9387 1108 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 11:23:34.1722 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:23:46.2663 550 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 11:24:16.1392 614 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 11:24:17.3561 770 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 11:24:16' where traUID = 5239450278912920 and traStatus='V' and traEnabled=1 05/11/2024 11:24:43.4565 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:25:32.7234 888 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 11:26:01.5316 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:28:04.4517 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:28:04.5827 570 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 11:28:08.6074 565 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-05 11:25:39',6,'V',4823111519672360,5248995561026690,2024,'2024-11-05 11:25:39',4,1,0,4,'2024-11-05 11:40:39','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 11:28:52.7519 801 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside + 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 05/11/2024 11:31:18.2190 556 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '455993873500327005012999' 05/11/2024 11:31:19.8741 1654 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 11:31:17' where payTraUID = 5248995561026690 and payStatus='V' and payEnabled=1 05/11/2024 11:32:25.4899 1363 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 11:32:25.4919 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:32:36.2771 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:32:36.6804 558 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-05 10:32:36') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-05 11:32:36' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-05 11:32:36' and (resAreId = 1 or resAreId <= 0) nr: 0 05/11/2024 11:33:22.2328 787 ms. EXEC: update paycash set casCreation = '2024-11-05 11:33:21',casModify = '2024-11-05 11:33:21',casUseId=0,casStatus='V' where casId = 193310 05/11/2024 11:33:23.1994 505 ms. EXEC: update payInventory set invCreation = '2024-11-05 11:33:22',invModify = '2024-11-05 11:33:22',invUseId=0,invStatus='V' where invId = 217412 05/11/2024 11:33:25.4720 876 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 11:34:18.8086 969 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/11/2024 11:34:29.9430 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:34:57.6155 2148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:35:45.3403 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:37:21.7537 681 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 11:37:20',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'; 05/11/2024 11:37:34.9515 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:37:52.7224 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:37:58.6623 3212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:37:58.7104 1187 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 11:38:00.8368 1797 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-05 11:37:59','V',4904453481763720,2024,'2024-11-05 11:37:57','455994187700327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 11:38:10.8575 2609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:38:17.5199 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:38:21.1123 1659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:38:41.3328 1167 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 11:38:39',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 05/11/2024 11:39:03.9989 578 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5194208984885220,5561225559486440,2024,'2024-11-05 11:39:03',' Date: 11/5/2024 11:39:03 AM Code: 455994076600327005012999 Entry Date: 11/5/2024 11:19:26 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400748350 ',0) 05/11/2024 11:39:38.9683 892 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-05 11:39:38','V',5634337000215080,2024,'2024-11-05 11:39:33','455994076600327005012999',2,2,2,'O','',0,'2024-11-05 11:39:38',1,'','',0) 05/11/2024 11:39:39.0063 689 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-05 11:39:38','V',5215942456739600,2024,'2024-11-05 11:39:36','455994197600327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 05/11/2024 11:40:52.2692 701 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/11/2024 11:41:06.2215 1010 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 11:41:27.5218 1008 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/11/2024 11:41:43.8737 830 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 05/11/2024 11:45:16.5336 2493 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 11:45:55.5917 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:46:20.1221 999 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 11:48:18.0648 618 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-05 11:48:17',0,'V',5125121339836180,5738011534014110,2024,'2024-11-05 11:48:17',3,1,0,4,'2024-11-05 12:03:17','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 05/11/2024 11:49:53.4045 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:49:53.6987 655 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:50:06.0369 1232 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:50:18.0149 918 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:50:30.8765 2138 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:52:12.9356 1170 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:52:32.6157 636 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '455994274900327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 05/11/2024 11:53:32.3946 876 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-05 11:53:31','V',4736805551731910,2024,'2024-11-05 11:53:30','455993543900327005012999',2,2,2,'O','',0,'2024-11-05 11:53:31',1,'','',0) 05/11/2024 11:55:23.8470 753 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCarId = 12 05/11/2024 11:55:24.5755 703 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 11:55:23' where traUID = 5699052693034730 and traStatus='V' and traEnabled=1 05/11/2024 11:55:31.1369 656 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 11:56:23.5619 1217 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 11:56:55.3041 1157 ms. EXEC: update payReceipt set recCreation = '2024-11-05 11:56:54',recModify = '2024-11-05 11:56:54',recUseId=0,recStatus='V' where recId = 319378 05/11/2024 11:57:59.1037 693 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-05 11:57:58',0,'V',5744959045819230,5489365732407060,2024,'2024-11-05 11:57:58',3,1,0,4,'2024-11-05 12:12:58','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 05/11/2024 11:58:00.3765 1177 ms. EXEC: update payReceipt set recCreation = '2024-11-05 11:57:59',recModify = '2024-11-05 11:57:59',recUseId=0,recStatus='V' where recId = 319379 05/11/2024 11:58:02.7621 1741 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 11:58:00',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-05 11:58:00',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'; 05/11/2024 11:59:00.3716 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:00:58.0191 2912 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 12:01:53.0178 2327 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-05 12:01:50',0,'V',4621751127482350,5720565937899330,2024,'2024-11-05 12:01:50',3,1,0,4,'2024-11-05 12:16:50','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) (WAIT TIME 386 ms.) 05/11/2024 12:01:55.9018 1109 ms. OPEN: select terDefaultClass from tabTerminal where terStatus='V' and terId = 16 05/11/2024 12:01:56.0499 2373 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 12:01:53',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'; 05/11/2024 12:02:11.7794 858 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 12:02:14.7303 534 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 05/11/2024 12:02:38.0219 1431 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 05/11/2024 12:02:51.1296 989 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-05 12:00:49',12,'V',5249550658406760,4636472167443400,2024,'2024-11-05 12:00:49',17,1,0,4,'2024-11-05 12:15:49','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 12:02:53.0169 1636 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 367413 else acvFstPayId end),acvLstPayId = 367413 where acvSftId = 816 and acvCodeId = 3 05/11/2024 12:02:55.4165 1428 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:03:12.3488 638 ms. EXEC: update payInventory set invCreation = '2024-11-05 12:03:11',invModify = '2024-11-05 12:03:11',invUseId=0,invStatus='V' where invId = 217425 (WAIT TIME 30 ms.) 05/11/2024 12:03:14.5453 2065 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 12:03:12',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'; (WAIT TIME 9 ms.) 05/11/2024 12:03:14.6183 1995 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 82 ms.) 05/11/2024 12:03:15.3648 818 ms. EXEC: update payInventory set invCreation = '2024-11-05 12:03:14',invModify = '2024-11-05 12:03:14',invUseId=0,invStatus='V' where invId = 217426 05/11/2024 12:03:24.1937 2017 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 12:04:04.3485 522 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 12:04:04.3515 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:04:08.6944 1364 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/11/2024 12:07:08.4754 868 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/11/2024 12:07:12.0408 3354 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 12:07:13.9391 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:07:37.7750 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:07:51.6903 558 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 05/11/2024 12:07:54.1519 553 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 12:07:53' where payTraUID = 5215942456739600 and payStatus='V' and payEnabled=1 05/11/2024 12:08:06.4101 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:09:30.8705 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:12:22.8213 700 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 12:16:01.7194 547 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 12:16:30.9869 2133 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:18:09.5657 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:20:39.9762 843 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:20:45.6750 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:20:46.4745 712 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 12:21:02.8744 717 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-05 12:21:02' where subId = 108 05/11/2024 12:21:03.6780 672 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-05 12:21:02',0,'V',4822161233531010,5618944728097950,2024,'2024-11-05 12:21:02',2,1,0,-1,'2024-11-05 13:21:02','S','KES',0,0,0,'','','',3,0,0) 05/11/2024 12:22:32.5803 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:22:42.0336 822 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/11/2024 12:22:48.5020 514 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 12:22:47' where payTraUID = 5374862906940110 and payStatus='V' and payEnabled=1 05/11/2024 12:23:02.8515 2975 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:24:03.1478 1899 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-05 12:24:01','V',5086224305182300,2024,'2024-11-05 12:24:00','455994320700327005012999',2,2,2,'O','',0,'2024-11-05 12:24:01',1,'','',0) 05/11/2024 12:24:04.0924 644 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 12:24:03' where traUID = 4784517234888110 and traStatus='V' and traEnabled=1 05/11/2024 12:24:09.5150 993 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 05/11/2024 12:26:48.4531 2668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:26:52.6810 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:27:02.8307 5181 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:27:29.4055 1958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:29:22.3199 1112 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 12:29:23.0423 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:30:39.1221 1504 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/11/2024 12:31:30.0521 1100 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 05/11/2024 12:31:46.3340 1731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:32:20.2997 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:32:22.0078 814 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:33:30.2454 967 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-05 12:33:27',0,'V',5428288879280200,5706312302129490,2024,'2024-11-05 12:33:27',3,1,0,4,'2024-11-05 12:48:27','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 05/11/2024 12:33:52.4752 3331 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:34:26.0776 2102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:34:26.0786 1977 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/11/2024 12:34:35.3258 5495 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-05 12:34:29','V',5294641887024600,2024,'2024-11-05 12:34:29','455994377300327005012999',2,2,2,'O','',0,'2024-11-05 12:34:29',1,'','',0) 05/11/2024 12:35:22.4433 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:36:26.4110 531 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-05 12:36:25','V',4648451570110460,2024,'2024-11-05 12:36:23','455994538300327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 12:37:22.0741 773 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5080398192448950,4880031159068540,2024,'2024-11-05 12:37:21','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/5/2024 12:12:04 PM Date : 11/5/2024 12:37:20 PM Code : 455994392400327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 1000.00 KES Coin changed : 0.00 KES Note changed : 950.00 KES',0) 05/11/2024 12:39:42.8401 719 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-05 12:39:42','V',5004809759614230,2024,'2024-11-05 12:39:40','455994392400327001012999',2,2,2,'O','',0,'2024-11-05 12:39:42',1,'','',0) 05/11/2024 12:40:02.3011 682 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 12:40:03.6750 1290 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:40:44.9305 694 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 12:40:44',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'; 05/11/2024 12:42:49.0124 714 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:43:05.4403 1134 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 12:43:28.8430 699 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 12:43:28' where payTraUID = 5504600227128840 and payStatus='V' and payEnabled=1 05/11/2024 12:45:15.7463 620 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-05 12:43:14',12,'V',5008899474272950,4774543484621340,2024,'2024-11-05 12:43:14',17,1,0,4,'2024-11-05 12:58:14','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 12:45:33.9995 1056 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/11/2024 12:45:34.0675 1128 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-05 12:45:29',0,'V',4734969613782890,5662835104228400,2024,'2024-11-05 12:45:29',3,1,0,4,'2024-11-05 13:00:29','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 05/11/2024 12:45:54.2350 522 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/11/2024 12:46:13.3998 1091 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 12:47:13.5600 2522 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 12:47:10' where traUID = 5662835104228400 and traStatus='V' and traEnabled=1 05/11/2024 12:47:53.2545 581 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-05 12:47:52','V',5142404509227650,2024,'2024-11-05 12:47:50','455994607000327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 12:49:05.7899 1586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:49:28.9433 2605 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-05 12:49:26','V',4857416672688360,2024,'2024-11-05 12:49:20','455994331300327005012999',2,2,2,'O','',0,'2024-11-05 12:49:26',1,'','',0) 05/11/2024 12:50:55.7483 1227 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-05 12:50:54',0,'V',5429776414051950,5462071655851210,2024,'2024-11-05 12:50:54',18,1,0,4,'2024-11-05 13:05:54','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 12:51:21.5135 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:53:03.3855 746 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-05 12:53:02','V',5011674091703770,2024,'2024-11-05 12:52:57','455994300100327005012999',2,2,2,'O','',0,'2024-11-05 12:53:02',1,'','',0) 05/11/2024 12:53:09.3315 5357 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 12:53:03' where traUID = 5036471030150200 and traStatus='V' and traEnabled=1 05/11/2024 12:53:14.4979 2088 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/11/2024 12:54:33.0283 893 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-05 12:54:32',0,'V',4931338923645820,4667301003063740,2024,'2024-11-05 12:54:32',18,1,0,4,'2024-11-05 13:09:32','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 12:54:51.6438 2533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:55:03.2155 3780 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-05 12:54:59' where subId = 16 05/11/2024 12:55:26.8403 504 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 12:55:51.9470 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:56:42.7529 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:57:17.9334 725 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 12:58:47.0979 1464 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 12:58:47.9465 1175 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 12:58:53.1060 1297 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 12:58:58.3875 3891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:00:46.3195 589 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-05 13:00:45','V',4746235513337290,2024,'2024-11-05 13:00:43','455994378700327005012999',2,2,2,'O','',0,'2024-11-05 13:00:45',1,'','',0) 05/11/2024 13:00:47.1401 812 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 13:00:47.9026 615 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 13:00:47' where traUID = 4667301003063740 and traStatus='V' and traEnabled=1 05/11/2024 13:01:21.2809 1535 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 05/11/2024 13:01:21.9993 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:02:26.9107 525 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 13:02:27.1188 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:04:47.6706 530 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 13:06:53.0353 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:07:20.9880 522 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-05 13:07:20','V',5416396161842380,2024,'2024-11-05 13:07:18','455994602400327005012999',2,2,2,'O','',0,'2024-11-05 13:07:20',1,'','',0) 05/11/2024 13:07:21.7115 638 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 13:07:28.8272 920 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:08:25.7582 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:11:36.7107 1317 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:12:38.1937 818 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-05 13:12:37',0,'V',5109772946782740,4731968652025470,2024,'2024-11-05 13:12:37',3,1,0,4,'2024-11-05 13:27:37','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 05/11/2024 13:13:44.0737 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:15:01.5735 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:16:39.2106 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:16:54.1676 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:17:24.1176 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:17:25.9018 502 ms. OPEN: select last_insert_id() as vLast 05/11/2024 13:17:26.6863 778 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 13:17:27.4969 783 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 13:17:30.5699 2966 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 13:17:27' where payTraUID = 5590410438336550 and payStatus='V' and payEnabled=1 05/11/2024 13:17:31.1903 619 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 13:17:27' where traUID = 5590410438336550 and traStatus='V' and traEnabled=1 05/11/2024 13:17:32.7564 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:19:35.4143 1982 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-05 13:19:33',4,6,'2024-11-05 13:19:33','455993767800327005012999','Payed (Credit Card ) Ticket ') 05/11/2024 13:20:47.4093 824 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4894260915959920,5742661480705630,2024,'2024-11-05 13:20:46',' Data: 11/5/2024 1:18:44 PM Codice: 455994733200327005012999 Ingresso: 11/5/2024 1:08:52 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400606860 ',0) 05/11/2024 13:20:48.7372 1327 ms. EXEC: update payReceipt set recCreation = '2024-11-05 13:20:47',recModify = '2024-11-05 13:20:47',recUseId=0,recStatus='V' where recId = 319428 05/11/2024 13:21:37.0375 1143 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 13:21:37.2686 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:21:55.5088 757 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 13:22:13.9481 801 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-05 13:22:13','V',5278244882323830,2024,'2024-11-05 13:22:10','455994733200327005012999',2,2,2,'O','',0,'2024-11-05 13:22:13',1,'','',0) 05/11/2024 13:22:18.4111 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:22:58.1266 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:23:16.9421 2323 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 13:23:49.7430 607 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 13:23:54.8845 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:24:57.2601 874 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 13:25:36.9546 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:25:44.0654 732 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-05 13:25:43','V',5743302539958310,2024,'2024-11-05 13:25:40','455994654800327005012999',2,2,2,'O','',0,'2024-11-05 13:25:43',1,'','',0) 05/11/2024 13:25:51.1051 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:25:55.0437 1851 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-05 13:25:53',0,0,'V',5663569558455520,5466386645759840,2024,'2024-11-05 13:25:53',3,'KES',-1,50,-50,'N',''); 05/11/2024 13:25:58.1648 3121 ms. EXEC: update paycash set casCreation = '2024-11-05 13:25:55',casModify = '2024-11-05 13:25:55',casUseId=0,casStatus='V' where casId = 193349 05/11/2024 13:26:01.2288 2508 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 13:26:02.0153 3849 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 13:25:53',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'; 05/11/2024 13:27:57.6525 716 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 13:28:30.6896 1316 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 13:28:31.7543 1055 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 13:28:30' where payTraUID = 5466386645759840 and payStatus='V' and payEnabled=1 05/11/2024 13:28:38.2176 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:28:38.2967 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:28:40.3831 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:29:42.5826 3550 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 13:29:39' where payTraUID = 4667073154427580 and payStatus='V' and payEnabled=1 05/11/2024 13:29:42.6096 3919 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 13:29:37',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 13:29:37',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'; 05/11/2024 13:29:47.7841 1504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:30:24.5156 634 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 13:31:03.4185 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:31:34.0720 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:31:34.0720 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:37:16.2074 678 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-05 13:37:15',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'; 05/11/2024 13:39:34.5628 561 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 13:39:33' where traUID = 5197460401866220 and traStatus='V' and traEnabled=1 05/11/2024 13:39:37.8800 715 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:39:38.8316 839 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/11/2024 13:41:11.3484 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:41:58.6179 513 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 13:42:00.9345 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:42:18.3481 1494 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:42:20.8578 1111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:43:06.3351 1891 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 13:43:35.4156 900 ms. EXEC: update payReceipt set recCreation = '2024-11-05 13:43:34',recModify = '2024-11-05 13:43:34',recUseId=0,recStatus='V' where recId = 319441 05/11/2024 13:43:55.3058 589 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 13:43:54' where payTraUID = 5619067051361920 and payStatus='V' and payEnabled=1 05/11/2024 13:43:55.9643 657 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 13:43:54' where traUID = 5619067051361920 and traStatus='V' and traEnabled=1 05/11/2024 13:44:44.6988 1053 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:44:50.1444 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:44:53.5637 911 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 13:44:52' where payTraUID = 4870170573331290 and payStatus='V' and payEnabled=1 (WAIT TIME 14 ms.) 05/11/2024 13:44:54.5244 795 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 13:44:52' where traUID = 4870170573331290 and traStatus='V' and traEnabled=1 05/11/2024 13:45:00.9056 515 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:45:12.1081 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:45:46.6642 794 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 13:46:15.0901 2198 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 13:46:40.9884 561 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/11/2024 13:49:12.4455 956 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:51:11.6171 624 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/11/2024 13:52:18.5178 503 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-05 13:52:15',0,'V',5121137698852230,5306290583053470,2024,'2024-11-05 13:52:15',3,1,0,4,'2024-11-05 14:07:15','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 05/11/2024 13:52:19.5434 701 ms. EXEC: update paycash set casCreation = '2024-11-05 13:52:18',casModify = '2024-11-05 13:52:18',casUseId=0,casStatus='V' where casId = 193358 05/11/2024 13:53:45.8961 1208 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-05 13:53:44',0,0,'V',4732597998184050,5446502003351480,2024,'2024-11-05 13:53:44',3,'KES',1,100,100,'N',''); 05/11/2024 13:53:59.8404 614 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 13:54:07.5766 666 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-05 13:54:06',0,'V',5628685932714500,5356284620385830,2024,'2024-11-05 13:54:06',2,1,0,-1,'2024-11-05 14:54:06','S','KES',0,0,0,'','','',3,0,0) 05/11/2024 13:54:45.2297 1120 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCode = '455994854600327001012999' 05/11/2024 13:54:45.8311 601 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 13:54:44' where payTraUID = 5306290583053470 and payStatus='V' and payEnabled=1 05/11/2024 13:54:46.6356 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:54:46.6496 817 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 13:54:44' where traUID = 5306290583053470 and traStatus='V' and traEnabled=1 05/11/2024 13:54:51.3398 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:56:05.6384 1445 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4648451570110460,5308516103042770,2024,'2024-11-05 13:56:04',' Date: 11/5/2024 1:56:03 PM Code: 455994538300327005012999 Entry Date: 11/5/2024 12:36:23 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 # 2400748377 ',0) 05/11/2024 13:56:36.5290 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 68 ms.) 05/11/2024 13:56:52.1484 1725 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 13:56:52.1524 4118 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 13:57:49.3426 1445 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '455994219000327005012999' 05/11/2024 13:57:53.4844 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 13:58:40.7699 1057 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 13:58:41.5104 555 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 13:58:40' where payTraUID = 5590533625671750 and payStatus='V' and payEnabled=1 05/11/2024 14:01:38.4505 523 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-05 14:01:37','V',4996035288655350,2024,'2024-11-05 14:01:36','455995049600327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 14:03:10.9063 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:05:24.1212 1623 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48378, trcLastPrinted = '2400748378', trcLastDate = '2024-11-05 14:05:22' where trcStatus='V' and trcTerId = 18 05/11/2024 14:07:50.4148 542 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-05 14:07:49',0,0,'V',5179806823271860,5003124490912850,2024,'2024-11-05 14:07:49',3,'KES',1,100,100,'N',''); 05/11/2024 14:07:52.0900 967 ms. EXEC: update payInventory set invCreation = '2024-11-05 14:07:51',invModify = '2024-11-05 14:07:51',invUseId=0,invStatus='V' where invId = 217467 05/11/2024 14:08:27.9419 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 782 ms.) 05/11/2024 14:09:32.1948 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:10:21.1375 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:11:57.1315 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:12:05.9504 1958 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 14:12:13.8157 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:13:01.9048 1803 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-05 14:13:00','V',5238243099833570,2024,'2024-11-05 14:12:59','455995117900327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 14:13:27.1767 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:13:36.6250 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:14:39.9242 1936 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-05 14:12:09',6,'V',4696587650710930,5433464203867720,2024,'2024-11-05 14:12:09',4,1,0,4,'2024-11-05 14:27:09','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 14:14:53.0260 573 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 14:15:32.9526 1866 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 14:16:11.9967 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:16:53.5364 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:17:16.8630 537 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 14:17:59.5265 804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:20:54.4512 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 14:20:55.7461 1971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:21:14.4346 759 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 14:21:13' where payTraUID = 5378491213502000 and payStatus='V' and payEnabled=1 05/11/2024 14:21:15.0890 654 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 14:21:13' where traUID = 5378491213502000 and traStatus='V' and traEnabled=1 05/11/2024 14:21:20.0413 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 14:22:29.9000 804 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-05 14:22:29' where subId = 179 05/11/2024 14:22:30.7145 753 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-05 14:22:29',0,'V',4743592049589190,4657998037771400,2024,'2024-11-05 14:22:29',2,1,0,-1,'2024-11-05 15:22:29','S','KES',0,0,0,'','','',3,0,0) 05/11/2024 14:22:31.5981 704 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 14:22:39.4173 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 14:23:11.0995 1474 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 14:23:09' where traUID = 4896005733292560 and traStatus='V' and traEnabled=1 05/11/2024 14:27:50.0757 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:31:29.8424 755 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 05/11/2024 14:32:44.6133 537 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 14:35:09.1918 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:37:30.7623 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:42:50.5888 696 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-05 14:42:49' where subId = 16 05/11/2024 14:42:52.2860 532 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 14:42:51' where traUID = 4652806219127260 and traStatus='V' and traEnabled=1 05/11/2024 14:43:57.5465 854 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:44:13.8694 569 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) 05/11/2024 14:44:23.2437 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:45:43.5963 1211 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 14:45:45.6907 1232 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/11/2024 14:45:45.7077 1000 ms. EXEC: update payReceipt set recCreation = '2024-11-05 14:45:44',recModify = '2024-11-05 14:45:44',recUseId=0,recStatus='V' where recId = 319466 05/11/2024 14:47:08.5160 891 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-05 14:47:07',0,'V',4733652192163480,5707850647941120,2024,'2024-11-05 14:47:07',18,1,0,4,'2024-11-05 15:02:07','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 05/11/2024 14:48:30.1415 635 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5238243099833570,5584608033786620,2024,'2024-11-05 14:48:29',' Data: 11/5/2024 2:46:28 PM Codice: 455995117900327005012999 Ingresso: 11/5/2024 2:12:59 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400606869 ',0) 05/11/2024 14:48:44.3270 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 14:50:25.4315 802 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 14:50:35.0909 983 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-05 14:48:33',12,'V',5320108997241920,5236245566096280,2024,'2024-11-05 14:48:33',17,1,0,4,'2024-11-05 15:03:33','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/11/2024 14:50:52.6186 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 14:51:01.9228 525 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-05 14:51:01','V',5117148291274430,2024,'2024-11-05 14:51:00','455994801400327005012999',2,2,2,'O','',0,'2024-11-05 14:51:01',1,'','',0) (WAIT TIME 2 ms.) 05/11/2024 14:51:03.3518 1028 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 14:51:02' where payTraUID = 5184267171886770 and payStatus='V' and payEnabled=1 05/11/2024 14:51:20.8775 735 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-05 14:51:20','0230004101179',0,0,4913049408508390,8,'0000-00-00 00:00:00','0000-00-00 00:00:00') 05/11/2024 14:51:26.9165 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 14:52:05.3682 2170 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 14:52:05.9366 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 14:52:15.7471 544 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 14:52:16.4906 698 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 14:52:17.8945 911 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 14:52:16' where traUID = 5236245566096280 and traStatus='V' and traEnabled=1 05/11/2024 14:52:53.4093 1646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:53:07.3646 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:53:38.0621 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:53:46.4677 2638 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 14:53:46.4787 3005 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:53:52.1605 1222 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/11/2024 14:54:16.0714 1023 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-05 14:54:15','V',4776713941619290,2024,'2024-11-05 14:54:13','455994929400327005012999',2,2,2,'O','',0,'2024-11-05 14:54:15',1,'','',0) 05/11/2024 14:54:19.4107 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 14:56:56.9298 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:58:48.1541 866 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 14:59:49.2539 688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 14:59:56.1445 837 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/11/2024 15:01:50.9871 1331 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 15:02:26.5549 739 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 05/11/2024 15:03:18.1353 977 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-05 15:03:16',0,'V',5225862528790800,4664448366555350,2024,'2024-11-05 15:03:16',18,1,0,4,'2024-11-05 15:18:16','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/11/2024 15:04:01.8245 3430 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:05:23.7361 1774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:05:30.7598 1354 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 367527 else acvFstPayId end),acvLstPayId = 367527 where acvSftId = 816 and acvCodeId = 3 (WAIT TIME 4 ms.) 05/11/2024 15:05:32.3899 1612 ms. EXEC: update tabTerminalReceipt set trcProgressive = 6875, trcLastPrinted = '2400606875', trcLastDate = '2024-11-05 15:05:30' where trcStatus='V' and trcTerId = 17 05/11/2024 15:07:17.0708 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:07:23.9224 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 15:07:24.5578 565 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/11/2024 15:08:58.0262 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 15:09:14.2160 1982 ms. OPEN: select useParkAccess from tabUser where (useBadId = '455995014200327005012999' or useBadId = '455995014200327005012999') 05/11/2024 15:09:14.7333 516 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 15:09:30.2037 1387 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 15:11:26.3722 2082 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 05/11/2024 15:11:49.9520 2638 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-05 15:09:47',12,'V',5274322101957530,4640496999475380,2024,'2024-11-05 15:09:47',17,1,0,4,'2024-11-05 15:24:47','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 15:11:52.9179 2788 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 367531 else acvFstPayId end),acvLstPayId = 367531 where acvSftId = 816 and acvCodeId = 3 05/11/2024 15:12:50.6575 2498 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:12:54.2919 1451 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:13:06.1648 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:13:17.2612 581 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-05 15:13:16','0230003944064',0,0,5227999993627650,14,'0000-00-00 00:00:00','0000-00-00 00:00:00') 05/11/2024 15:14:01.9461 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 15:14:22.4528 1303 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:15:13.1226 611 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-05 15:15:12',17,12,'2024-11-05 15:15:12','455995355400327005012999','Pagato (Contanti ) Biglietto ') 05/11/2024 15:16:18.8385 2033 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-05 15:16:16',0,'V',5319917939498680,4628977618531810,2024,'2024-11-05 15:16:16',2,1,0,-1,'2024-11-05 16:16:16','S','KES',0,0,0,'','','',3,0,0) 05/11/2024 15:17:18.1551 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:18:50.3996 1202 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 15:21:58.5222 1063 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 15:21:57' where payTraUID = 4835851898184460 and payStatus='V' and payEnabled=1 05/11/2024 15:22:02.9342 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 15:22:06.8007 1875 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:25:40.8286 520 ms. OPEN: select traCode from movTransit where traCode ='455995553800327005012999' 05/11/2024 15:25:41.7452 687 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-05 15:25:41','V',5043048356598850,2024,'2024-11-05 15:25:38','455995553800327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 15:26:06.9511 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:26:17.8233 1806 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 15:26:20.3720 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:27:20.0178 530 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48396, trcLastPrinted = '2400748396', trcLastDate = '2024-11-05 15:27:19' where trcStatus='V' and trcTerId = 18 05/11/2024 15:28:03.8651 809 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 15:28:03' where traUID = 5337365371534930 and traStatus='V' and traEnabled=1 05/11/2024 15:28:10.5025 530 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/11/2024 15:29:17.4332 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:29:22.1324 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:29:22.1434 1374 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 15:29:33.4419 1167 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:29:53.9516 663 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 05/11/2024 15:30:09.8132 2067 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4774399382308810,4781899117560490,2024,'2024-11-05 15:30:07',' Date: 11/5/2024 3:30:07 PM Code: 455995462500327005012999 Entry Date: 11/5/2024 3:10:25 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400748397 ',0) 05/11/2024 15:31:37.2486 2094 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:31:42.4100 574 ms. EXEC: update abbCards set carLastDate = '2024-11-05 15:31:41',carLastDirection='I' where carStatus='V' and carId = 12 05/11/2024 15:32:03.8263 1072 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 15:32:02' where traUID = 4774399382308810 and traStatus='V' and traEnabled=1 05/11/2024 15:34:06.5062 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 15:34:11.5566 944 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 15:34:24.2741 668 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 15:34:23' where payTraUID = 4755450686221800 and payStatus='V' and payEnabled=1 05/11/2024 15:34:25.1556 798 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 15:34:23' where traUID = 4755450686221800 and traStatus='V' and traEnabled=1 05/11/2024 15:36:34.7992 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:37:47.4177 636 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-05 15:37:46','V',4871362368389100,2024,'2024-11-05 15:37:44','455995460900327005012999',2,2,2,'O','',0,'2024-11-05 15:37:46',1,'','',0) 05/11/2024 15:37:48.0941 581 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 15:38:56.6729 552 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48402, trcLastPrinted = '2400748402', trcLastDate = '2024-11-05 15:38:56' where trcStatus='V' and trcTerId = 18 05/11/2024 15:39:52.5472 634 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 15:39:52.6833 643 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48403, trcLastPrinted = '2400748403', trcLastDate = '2024-11-05 15:39:52' where trcStatus='V' and trcTerId = 18 05/11/2024 15:40:10.6923 878 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 15:40:39.1573 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 15:40:39.7337 669 ms. OPEN: show columns from tabArea where Field = 'areBookingReserved' 05/11/2024 15:40:57.7958 725 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48404, trcLastPrinted = '2400748404', trcLastDate = '2024-11-05 15:40:57' where trcStatus='V' and trcTerId = 18 05/11/2024 15:41:08.9412 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 15:42:02.1927 981 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 15:42:05.3999 911 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:42:05.3999 1005 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 15:42:39.6277 780 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-05 15:40:38',12,'V',5292723927462920,5594167151824910,2024,'2024-11-05 15:40:38',17,1,0,4,'2024-11-05 15:55:38','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 15:42:59.0347 532 ms. EXEC: update abbCards set carLastDate = '2024-11-05 15:42:58',carLastDirection='I' where carStatus='V' and carId = 15 05/11/2024 15:43:28.0521 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 15:43:42.3896 1151 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-05 15:43:41','V',5429507943907230,2024,'2024-11-05 15:43:38','455995363700327005012999',2,2,2,'O','',0,'2024-11-05 15:43:41',1,'','',0) 05/11/2024 15:43:50.3289 1379 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 15:44:05.3890 602 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/11/2024 15:44:12.3716 1160 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 15:44:52.5535 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:46:44.3631 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 15:50:03.6712 1223 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48411, trcLastPrinted = '2400748411', trcLastDate = '2024-11-05 15:50:02' where trcStatus='V' and trcTerId = 18 05/11/2024 15:54:30.0320 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:57:00.4774 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 15:59:08.0686 637 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 16:00:25.0309 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:00:45.4116 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:04:17.7823 1622 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 16:07:27.6040 1339 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48416, trcLastPrinted = '2400748416', trcLastDate = '2024-11-05 16:07:26' where trcStatus='V' and trcTerId = 18 05/11/2024 16:07:35.6244 1272 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:07:52.4806 796 ms. EXEC: update payReceipt set recCreation = '2024-11-05 16:07:51',recModify = '2024-11-05 16:07:51',recUseId=0,recStatus='V' where recId = 319519 05/11/2024 16:07:52.4857 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:07:57.6751 708 ms. EXEC: update payReceipt set recCreation = '2024-11-05 16:07:56',recModify = '2024-11-05 16:07:56',recUseId=0,recStatus='V' where recId = 319520 05/11/2024 16:08:00.3129 631 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-05 16:07:59','V',5101953381315500,2024,'2024-11-05 16:07:58','455995171900327005012999',2,2,2,'O','',0,'2024-11-05 16:07:59',1,'','',0) 05/11/2024 16:08:06.8012 938 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 05/11/2024 16:08:06.9263 1678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 16:08:13.5787 1384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:08:15.4780 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:08:18.7032 1681 ms. EXEC: update payReceipt set recCreation = '2024-11-05 16:08:17',recModify = '2024-11-05 16:08:17',recUseId=0,recStatus='V' where recId = 319521 05/11/2024 16:08:52.1155 1148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:10:44.5605 3115 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-05 16:10:41',0,'V',4805530040664060,5075481979933590,2024,'2024-11-05 16:10:41',18,1,0,4,'2024-11-05 16:25:41','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 16:11:32.3774 1873 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 16:11:54.1370 2775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:11:58.3238 3165 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15597, trcLastPrinted = '2400415597', trcLastDate = '2024-11-05 16:11:55' where trcStatus='V' and trcTerId = 4 05/11/2024 16:13:21.5333 1399 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:13:32.7248 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 16:14:06.2662 894 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 05/11/2024 16:14:24.0260 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 16:14:32.5207 737 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 16:14:32.5287 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:20:45.8359 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:24:24.1086 1055 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:25:26.5433 1635 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-05 16:25:24','V',5010901832154800,2024,'2024-11-05 16:25:23','455995422000327005012999',2,2,2,'O','',0,'2024-11-05 16:25:24',1,'','',0) 05/11/2024 16:25:30.5220 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 16:25:44.1060 3909 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 16:25:45.6671 1562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:28:18.3680 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:29:32.5365 835 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 16:33:37.1778 501 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 16:34:26.9220 637 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-05 16:34:26',0,'V',4739966485509660,5033316794199630,2024,'2024-11-05 16:34:26',18,1,0,4,'2024-11-05 16:49:26','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 05/11/2024 16:35:17.5558 652 ms. EXEC: update abbCards set carLastDate = '2024-11-05 16:35:16',carLastDirection='O' where carStatus='V' and carId = 102 05/11/2024 16:35:18.9548 1371 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCarId = 102 05/11/2024 16:35:29.6909 2038 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:35:41.9391 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 16:35:42.0182 704 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 16:36:04.8814 517 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-05 16:36:04','V',5734587874546580,2024,'2024-11-05 16:36:02','455995779600327005012999',2,2,2,'O','',0,'2024-11-05 16:36:04',1,'','',0) 05/11/2024 16:36:47.0626 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:36:47.1767 1756 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 16:40:31.9647 631 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-05 16:40:31','V',5630690173413640,2024,'2024-11-05 16:40:29','455996002900327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 16:41:59.1719 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 16:42:25.7217 713 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 16:43:56.3962 1194 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:45:27.8562 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 16:45:49.1575 1182 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 16:45:50.3022 1050 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 16:46:18.5441 1045 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:50:27.8975 1131 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 16:50:58.5730 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:51:02.5307 521 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 16:52:06.2232 1753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:53:24.0862 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:54:01.0658 1099 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 16:54:31.4801 1327 ms. EXEC: update payReceipt set recCreation = '2024-11-05 16:54:30',recModify = '2024-11-05 16:54:30',recUseId=0,recStatus='V' where recId = 319539 05/11/2024 16:54:44.6529 1300 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 16:55:21.9328 752 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-05 16:55:21' where subId = 32 05/11/2024 16:55:23.9442 1861 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-05 16:55:22',0,'V',4779926710117610,5106619060257730,2024,'2024-11-05 16:55:22',2,1,0,-1,'2024-11-05 17:55:22','S','KES',0,0,0,'','','',3,0,0) 05/11/2024 16:55:34.9675 883 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 16:55:48.0312 1835 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 16:56:15.8148 2550 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 16:56:31.9536 1227 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-05 16:56:30' where subId = 11 05/11/2024 16:56:50.7371 818 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-05 16:56:49','V',5256195379166630,2024,'2024-11-05 16:56:48','455995652100327005012999',2,2,2,'O','',0,'2024-11-05 16:56:49',1,'','',0) 05/11/2024 16:57:01.6194 2030 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/11/2024 16:57:01.6214 2038 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 16:57:54.4366 1758 ms. EXEC: update payReceipt set recCreation = '2024-11-05 16:57:52',recModify = '2024-11-05 16:57:52',recUseId=0,recStatus='V' where recId = 319540 05/11/2024 16:57:54.5647 1203 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 17:00:02.5692 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:00:02.5972 555 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/11/2024 17:00:05.1849 2101 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 17:00:58.6976 1842 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 17:00:56' where traUID = 5382623280446830 and traStatus='V' and traEnabled=1 05/11/2024 17:07:07.7530 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 17:08:44.7277 917 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:09:12.2721 1535 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-05 17:09:10','V',5034832243846340,2024,'2024-11-05 17:09:08','455993571800327005012999',2,2,2,'O','',0,'2024-11-05 17:09:10',1,'','0810007113876',103,0) 05/11/2024 17:11:31.0157 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 17:12:25.5251 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:13:36.9248 1376 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-05 17:13:35' where subId = 208 05/11/2024 17:14:14.1496 1142 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-05 17:14:13','V',4795584985043890,2024,'2024-11-05 17:14:08','455996204800327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 17:14:26.0996 1891 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 17:14:57.1954 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 17:15:04.1720 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:16:21.9810 956 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 17:16:42.4376 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:17:51.9170 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 17:19:02.6272 1020 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/11/2024 17:20:57.3658 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:21:28.1864 1873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:21:57.5310 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:22:00.9463 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:22:48.6491 960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:24:03.5311 1650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:27:02.3485 1261 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 17:28:10.0657 958 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 17:28:09' where payTraUID = 5742314233210750 and payStatus='V' and payEnabled=1 05/11/2024 17:28:23.9730 941 ms. EXEC: update abbCards set carLastDate = '2024-11-05 17:28:23',carLastDirection='O' where carStatus='V' and carId = 26 05/11/2024 17:29:05.4677 581 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 17:35:41.2258 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:53:13.0320 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:54:10.5814 709 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-05 17:54:09','V',4808269934377480,2024,'2024-11-05 17:54:08','455996444800327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 17:55:44.3380 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:56:13.3544 736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:58:51.6670 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 17:59:42.9333 1093 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-05 17:59:41',0,'V',4661188823671360,5140302261072870,2024,'2024-11-05 17:59:41',2,1,0,-1,'2024-11-05 18:59:41','S','KES',0,0,0,'','','',3,0,0) 05/11/2024 18:00:43.4907 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:01:06.9023 1591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:02:42.0098 610 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-05 18:02:41' where subId = 20 05/11/2024 18:02:43.7910 818 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 18:02:42' where traUID = 5214734472269220 and traStatus='V' and traEnabled=1 05/11/2024 18:03:00.9184 610 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-05 18:03:00',0,'V',4675571609029690,4928232757486560,2024,'2024-11-05 18:03:00',18,1,0,4,'2024-11-05 18:18:00','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/11/2024 18:04:16.4839 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:04:34.6610 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:04:42.0590 654 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 18:07:45.0911 975 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-05 18:07:44','V',4675186229348030,2024,'2024-11-05 18:07:42','455996526200327005012999',1,2,16,'I','',1,0,1,'','0560008304916',190,0) 05/11/2024 18:10:36.3174 678 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 18:10:52.5323 845 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 18:12:31.4513 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:12:52.6394 2844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:14:44.9884 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:17:25.6947 1308 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 18:17:48.7781 1409 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:19:21.0677 1865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:19:43.4407 1510 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 18:20:09.5521 1173 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:20:27.2329 1094 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:21:15.2410 545 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-05 18:21:14' where subId = 26 05/11/2024 18:21:17.1282 1672 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-05 18:21:15','0230003957463',0,0,5609178776323130,25,'0000-00-00 00:00:00','0000-00-00 00:00:00') 05/11/2024 18:21:25.2286 792 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 18:21:25.6619 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:22:44.1293 1170 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5063720308255100,4650739209667370,2024,'2024-11-05 18:22:42',' Date: 11/5/2024 6:22:42 PM Code: 455995696600327005012999 Entry Date: 11/5/2024 3:49:26 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 # 2400748446 ',0) 05/11/2024 18:22:44.9839 1457 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/11/2024 18:24:20.0814 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:27:50.4418 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:30:25.9786 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:30:32.7241 1028 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:31:30.4717 782 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-05 18:31:29','V',4835057381557930,2024,'2024-11-05 18:31:28','455995618000327005012999',2,2,2,'O','',0,'2024-11-05 18:31:29',1,'','',0) 05/11/2024 18:31:40.6565 574 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/11/2024 18:32:17.3470 719 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 18:32:17.8163 3089 ms. EXEC: update abbCards set carLastDate = '2024-11-05 18:32:14',carLastDirection='I' where carStatus='V' and carId = 183 05/11/2024 18:33:07.1002 1264 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:33:20.4431 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:34:22.6416 1701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:35:34.3605 1211 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 18:35:35.0890 848 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 18:39:01.1645 1371 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:41:07.1847 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:41:10.0856 1134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:42:04.3748 1662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:43:28.0077 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:43:28.0087 501 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 05/11/2024 18:43:28.5340 1084 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 18:46:43.8464 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:48:37.6253 765 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 18:49:55.0720 1083 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:54:05.8164 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:55:23.2331 1696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:55:34.0063 1360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:57:28.9040 1241 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 18:57:39.6842 965 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:00:34.9242 1035 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 19:03:31.1248 883 ms. OPEN: show columns from tabUser where Field = 'useAllowZReport' 05/11/2024 19:03:39.0481 2277 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:04:21.3754 2200 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:05:16.0368 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:06:05.3818 868 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 367642 else acvFstPayId end),acvLstPayId = 367642 where acvSftId = 818 and acvCodeId = 3 05/11/2024 19:06:10.8174 1134 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 19:06:11.5319 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 19:06:46.2261 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:08:24.8069 1071 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-05 19:05:53',6,'V',5167038700164400,5752641859172450,2024,'2024-11-05 19:05:53',4,1,0,4,'2024-11-05 19:20:53','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/11/2024 19:09:28.5944 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:09:41.5991 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,'2024-11-05 19:09:40','V',4894821050737450,2024,'2024-11-05 19:09:38','455996465800327005012999',2,2,2,'O','',0,'2024-11-05 19:09:40',1,'','',0) 05/11/2024 19:09:43.9187 1693 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 19:09:42' where traUID = 5304504781565120 and traStatus='V' and traEnabled=1 05/11/2024 19:09:46.0321 1505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:10:58.8067 1024 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 19:11:48.9451 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:12:14.4632 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:14:58.7418 515 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 19:14:58' where payTraUID = 4795584985043890 and payStatus='V' and payEnabled=1 05/11/2024 19:16:22.5318 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 19:16:41.4184 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:17:39.9194 905 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-05 19:17:39','V',5606094273333050,2024,'2024-11-05 19:17:36','455996717000327005012999',2,2,2,'O','',0,'2024-11-05 19:17:39',1,'','',0) 05/11/2024 19:22:57.5845 1977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:24:36.4135 586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:26:07.4032 683 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48461, trcLastPrinted = '2400748461', trcLastDate = '2024-11-05 19:26:06' where trcStatus='V' and trcTerId = 18 05/11/2024 19:30:16.5635 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:35:56.4094 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 19:35:59.2693 919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:40:57.5955 1119 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:42:21.7987 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:43:37.2560 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 19:43:48.9438 1055 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 19:43:48.9509 964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:46:05.4019 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:47:03.0274 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:48:04.6275 631 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 19:49:41.3861 1002 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:49:56.4802 1677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:53:31.9761 849 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48464, trcLastPrinted = '2400748464', trcLastDate = '2024-11-05 19:53:31' where trcStatus='V' and trcTerId = 18 05/11/2024 19:54:21.7553 1532 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-05 19:54:20',0,'V',5585479325548740,5012681232548220,2024,'2024-11-05 19:54:20',2,1,0,-1,'2024-11-05 20:54:20','S','KES',0,0,0,'','','',3,0,0) 05/11/2024 19:54:28.1656 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 19:54:29.9818 1149 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:55:36.5802 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 19:55:55.2757 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 19:57:03.1440 2890 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 19:59:25.2149 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:04:02.7401 2153 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:04:34.8085 2771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:05:26.9894 1557 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 20:06:59.1019 1183 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 20:08:52.0022 2973 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/11/2024 20:10:38.5854 586 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/11/2024 20:11:20.1351 1615 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-05 20:11:18','V',5483326651757080,2024,'2024-11-05 20:11:17','455997240500327005012999',2,2,2,'O','',0,'2024-11-05 20:11:18',1,'','',0) 05/11/2024 20:11:58.9430 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:14:40.4398 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 20:14:40.5759 1257 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 05/11/2024 20:16:27.2892 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:17:38.1575 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:17:54.2432 744 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/11/2024 20:18:01.1768 1834 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 20:18:11.0935 844 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 20:20:16.1479 1218 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 20:20:16.1689 2821 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-05 20:20:13','V',5290238784534700,2024,'2024-11-05 20:20:11','455996889000327005012999',2,2,2,'O','',0,'2024-11-05 20:20:13',1,'','0230003944064',14,0) 05/11/2024 20:21:54.6047 687 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 20:21:55.2821 521 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 20:22:46.0240 1201 ms. EXEC: update payReceipt set recCreation = '2024-11-05 20:22:44',recModify = '2024-11-05 20:22:44',recUseId=0,recStatus='V' where recId = 319587 05/11/2024 20:24:43.9277 1228 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 20:25:38.4951 802 ms. EXEC: update payReceipt set recCreation = '2024-11-05 20:25:37',recModify = '2024-11-05 20:25:37',recUseId=0,recStatus='V' where recId = 319588 05/11/2024 20:26:03.2136 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:29:08.6584 2383 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:29:19.1784 550 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 05/11/2024 20:29:49.2485 2365 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/11/2024 20:29:57.8503 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:31:50.8307 958 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/11/2024 20:33:19.2917 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:33:56.1683 987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:34:16.1277 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:36:13.8152 632 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-05 20:36:13','V',5129342580468710,2024,'2024-11-05 20:36:12','455997043700327005012999',2,2,2,'O','',0,'2024-11-05 20:36:13',1,'','',0) 05/11/2024 20:36:29.6428 826 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 20:36:53.4227 1079 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:38:12.8847 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:38:44.7940 2204 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/11/2024 20:38:44.8681 1488 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:38:46.3821 1007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:39:17.3548 1223 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/11/2024 20:41:09.8168 1096 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:41:22.9826 1539 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 20:41:27.0964 1285 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:42:50.3900 1256 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:43:12.7509 572 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-05 20:43:12','V',4664856571468150,2024,'2024-11-05 20:43:11','455997459100327005012999',1,2,16,'I','',1,0,1,'','',4) 05/11/2024 20:43:14.2389 1257 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/11/2024 20:43:22.0081 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:44:17.5451 3726 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 20:44:32.5542 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:45:04.7166 1799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:46:46.0983 988 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 05/11/2024 20:48:17.1021 956 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:48:27.8002 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 20:48:59.8496 1206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:49:54.3280 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 20:53:45.3212 627 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/11/2024 21:02:25.0731 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:04:00.7320 527 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 21:12:16.9372 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:15:30.3794 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 21:15:42.2853 863 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 21:17:51.6197 1185 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5416493269039060,5284802803538930,2024,'2024-11-05 21:17:50',' Date: 11/5/2024 9:17:50 PM Code: 455997472900327005012999 Entry Date: 11/5/2024 8:45:29 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 # 2400748478 ',0) 05/11/2024 21:24:13.4466 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:28:01.6309 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:28:04.7760 865 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 21:28:03' where payTraUID = 5650194822488170 and payStatus='V' and payEnabled=1 05/11/2024 21:30:49.0937 623 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/11/2024 21:31:26.7838 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:31:26.8419 509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 21:33:44.4908 519 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/11/2024 21:33:54.0151 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:40:18.7379 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:40:23.5411 891 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-05 21:40:22','V',4761105370753990,2024,'2024-11-05 21:40:21','455996013100327005012999',2,2,2,'O','',0,'2024-11-05 21:40:22',1,'','',0) 05/11/2024 21:41:44.0589 1994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:44:16.5247 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:45:21.9003 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 21:45:27.6702 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:45:29.5504 903 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/11/2024 21:50:07.0897 604 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/11/2024 21:51:26.7549 805 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 21:51:52.6542 860 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-05 21:51:51',0,'V',5520595230470710,5285573821372470,2024,'2024-11-05 21:51:51',18,1,0,4,'2024-11-05 22:06:51','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 05/11/2024 21:53:05.3517 833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 21:53:27.8887 643 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 21:54:04.1129 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 21:58:18.3727 1496 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 05/11/2024 22:00:01.5165 801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:00:07.2754 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:01:13.1003 848 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-05 22:01:12','V',5041865041910970,2024,'2024-11-05 22:01:11','455997760000327005012999',2,2,2,'O','',0,'2024-11-05 22:01:12',1,'','',0) 05/11/2024 22:01:19.1704 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 22:01:27.9832 1127 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 22:04:11.7125 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:08:36.0550 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:10:49.1879 1236 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:12:04.8984 1590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:13:01.1770 1003 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:13:19.9545 1488 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-05 22:13:18','V',4669753850084030,2024,'2024-11-05 22:13:17','455997378500327005012999',2,2,2,'O','',0,'2024-11-05 22:13:18',1,'','',0) 05/11/2024 22:13:28.1910 1683 ms. OPEN: select * from tabParameters order by parId desc limit 1 05/11/2024 22:13:28.3141 1688 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/11/2024 22:13:30.5046 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 22:13:34.5873 1505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:17:55.7326 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:18:47.6283 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:19:04.8578 5877 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 05/11/2024 22:19:05.6353 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:23:59.6015 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:28:23.7128 929 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-05 22:28:22' where payTraUID = 4833857415149960 and payStatus='V' and payEnabled=1 05/11/2024 22:28:24.5444 828 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-05 22:28:22' where traUID = 4833857415149960 and traStatus='V' and traEnabled=1 05/11/2024 22:28:35.7789 2259 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 22:28:35.8519 2181 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-05 22:28:33','V',5090856464108850,2024,'2024-11-05 22:28:30','455998091000327005012999',1,2,16,'I','',1,0,1,'','0230003943530',44,0) 05/11/2024 22:31:29.3287 2486 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:33:06.5466 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:34:11.3259 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:35:13.0291 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:36:18.6209 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:39:34.2114 1305 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:40:42.4790 1384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:41:28.2185 1452 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 22:48:11.3557 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 23:03:07.9282 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:03:22.3698 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:03:30.9936 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:07:18.7266 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:09:09.5015 1086 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/11/2024 23:19:34.8290 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:21:21.0649 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:22:14.1553 575 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/11/2024 23:24:07.4370 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/11/2024 23:24:11.5147 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:27:09.4365 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:27:41.5069 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:28:54.5126 789 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/11/2024 23:28:54.5136 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:29:35.4820 858 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 05/11/2024 23:32:19.5155 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:32:32.9985 2177 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:37:35.1352 1665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:37:56.1942 1988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:38:06.0408 1883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/11/2024 23:53:00.8731 790 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/11/2024 23:54:43.4646 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1