20/12/2024 00:01:48.5718 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 00:04:16.9009 1040 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 20/12/2024 00:56:17.8434 751 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 20/12/2024 01:35:10.6460 1263 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 02:16:38.2937 1170 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 03:11:22.1175 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 03:11:42.6665 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 03:12:26.7221 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 03:56:14.8700 1247 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-20 03:56:13' where traUID = 5755464915961510 and traStatus='V' and traEnabled=1 20/12/2024 04:20:57.5597 970 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 04:54:44.7023 1670 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 04:57:34.5358 1178 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 04:59:32.4651 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 05:30:48.2648 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 05:34:40.2631 724 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 06:03:35.7461 1230 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 06:19:01.3694 980 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 20/12/2024 06:37:06.5560 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 06:46:57.1233 620 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 20/12/2024 06:58:05.1138 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 06:58:58.7557 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 07:11:41.7507 804 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 07:23:28.0143 503 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 20/12/2024 08:03:16.8193 580 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 08:05:42.9439 637 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 20/12/2024 08:05:43.1560 764 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 08:06:00.9899 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 08:10:16.0524 770 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 08:10:17.0511 1013 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 20/12/2024 08:14:19.9706 581 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/12/2024 08:36:13.9149 518 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-12-20 08:36:13','V',5177477297904960,2024,'2024-12-20 08:36:12','456443097200327005012999',1,2,16,'I','',1,0,1,'','0560008304916',190,0) 20/12/2024 08:41:19.3842 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 08:43:58.1375 607 ms. EXEC: update payReceipt set recCreation = '2024-12-20 08:43:57',recModify = '2024-12-20 08:43:57',recUseId=0,recStatus='V' where recId = 334178 20/12/2024 08:57:29.2111 547 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 20/12/2024 08:57:33.8308 697 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-20 08:57:33','V',5636429310062840,2024,'2024-12-20 08:57:32','456443225200327005012999',1,2,16,'I','',1,0,1,'','',4) 20/12/2024 08:58:33.6688 825 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 09:01:23.9856 915 ms. EXEC: update payReceipt set recCreation = '2024-12-20 09:01:23',recModify = '2024-12-20 09:01:23',recUseId=0,recStatus='V' where recId = 334182 20/12/2024 09:02:01.0928 874 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 20/12/2024 09:04:57.8629 570 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 09:17:50.1071 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 09:18:04.3346 895 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 09:29:33.7472 1405 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 09:32:36.6189 2400 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 09:33:20.5103 1366 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-20 09:33:19','V',5353050306641630,2024,'2024-12-20 09:33:16','456443384000327005012999',2,2,2,'O','',0,'2024-12-20 09:33:19',1,'','',0) 20/12/2024 09:34:51.5411 1214 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/12/2024 09:35:11.3423 1270 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 09:38:39.1843 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 09:42:38.6772 653 ms. EXEC: update abbCards set carLastDate = '2024-12-20 09:42:38',carLastDirection='I' where carStatus='V' and carId = 8 20/12/2024 09:46:44.4034 966 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 20/12/2024 09:46:48.3020 527 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 20/12/2024 09:46:55.4788 1257 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 09:51:03.6391 534 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-20 09:51:03','V',4698597396368710,2024,'2024-12-20 09:51:01','456443546100327005012999',1,2,16,'I','',1,0,1,'','',4) 20/12/2024 09:56:44.8259 844 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-20 09:56:43','V',5136129671380520,2024,'2024-12-20 09:56:42','456443580200327005012999',1,2,16,'I','',1,0,1,'','',4) 20/12/2024 09:58:33.3615 1137 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 09:58:42.0563 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 09:58:48.5796 748 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/12/2024 10:00:22.1282 719 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 20/12/2024 10:01:05.1515 543 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 20/12/2024 10:03:07.2229 823 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 20/12/2024 10:03:24.3133 1034 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-20 10:03: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-12-20 10:03:23',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'; 20/12/2024 10:04:02.0675 879 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-20 10:04:01','V',4846632343913840,2024,'2024-12-20 10:03:59','456443124200327005012999',2,2,2,'O','',0,'2024-12-20 10:04:01',1,'','',0) 20/12/2024 10:20:58.9895 739 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-20 10:20:58',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-20 10:20:58',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 20/12/2024 10:34:23.8861 549 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 10:36:48.6871 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 10:45:38.5536 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 10:48:56.0686 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 10:54:56.4290 629 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-20 10:54:55' where payTraUID = 5262147904040320 and payStatus='V' and payEnabled=1 20/12/2024 10:57:46.0965 960 ms. EXEC: update payInventory set invCreation = '2024-12-20 10:57:45',invModify = '2024-12-20 10:57:45',invUseId=0,invStatus='V' where invId = 226421 20/12/2024 10:59:25.1187 642 ms. OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 20/12/2024 10:59:27.0080 1328 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-20 10:59:25',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-20 10:59:25',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 20/12/2024 11:01:03.7026 579 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-20 10:57:35',1,'V',4639289295785130,5276196545221910,2024,'2024-12-20 10:57:35',4,1,0,4,'2024-12-20 11:12:35','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 20/12/2024 11:01:04.5231 576 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5276196545221910,4639289295785130,2024,'2024-12-20 11:01:03',' Date: 12/20/2024 10:57:35 AM Code: 456443861800327005012999 Entry Date: 12/20/2024 10:43:38 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400418173 ',0) 20/12/2024 11:03:46.9063 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:11:05.7099 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:12:08.9281 781 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 = 6 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 20/12/2024 11:14:09.3643 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:15:09.6457 864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:17:27.5144 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:17:46.0084 738 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-12-20 11:17:45','V',5134548982629950,2024,'2024-12-20 11:17:44','456444066400327005012999',1,2,16,'I','',1,0,1,'','0230003957444',26,0) 20/12/2024 11:31:40.5382 602 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-20 11:31:39',0,'V',5555057669481510,5221605044570150,2024,'2024-12-20 11:31:39',18,1,0,4,'2024-12-20 11:46:39','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 20/12/2024 11:32:49.9961 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 11:37:11.6712 567 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-20 11:37:11' where payTraUID = 5221605044570150 and payStatus='V' and payEnabled=1 20/12/2024 11:41:26.2801 913 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:41:38.7855 881 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 11:43:53.7873 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:53:04.2654 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:53:13.8419 1144 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:54:32.7574 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:54:50.1789 1224 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 11:54:59.4654 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 12:03:57.7004 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 12:13:21.3010 572 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 20/12/2024 12:25:47.8991 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 12:28:50.4191 786 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 12:30:23.2501 1401 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-20 12:30:21','V',5664569907396270,2024,'2024-12-20 12:30:20','456444206100327005012999',2,2,2,'O','',0,'2024-12-20 12:30:21',1,'','',0) 20/12/2024 12:31:18.4710 695 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 20/12/2024 12:33:45.3912 629 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 20/12/2024 12:33:45.3932 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 12:34:15.0581 660 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 20/12/2024 12:53:11.5787 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 13:12:47.4777 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-12-20 13:12:46','V',5504898098516090,2024,'2024-12-20 13:12:46','456444592100327005012999',2,2,2,'O','',0,'2024-12-20 13:12:46',1,'','',0) 20/12/2024 13:16:34.6123 988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 13:17:44.1236 726 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 13:18:23.5483 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 13:19:56.7730 1098 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5319688806499420,5528818808910250,2024,'2024-12-20 13:19:55','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/20/2024 12:20:14 PM Date : 12/20/2024 1:19:53 PM Code : 456444441400327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 20/12/2024 13:19:58.1209 1345 ms. EXEC: update payReceipt set recCreation = '2024-12-20 13:19:56',recModify = '2024-12-20 13:19:56',recUseId=0,recStatus='V' where recId = 334301 20/12/2024 13:29:10.2818 1111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 13:30:52.5914 1362 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 20/12/2024 13:34:58.3676 588 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 20/12/2024 13:49:29.5681 709 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 20/12/2024 13:54:30.5728 698 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/12/2024 13:58:01.2365 637 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/12/2024 14:04:22.4240 1165 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 14:08:37.4065 1548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 14:09:34.5284 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 14:10:42.4119 588 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 20/12/2024 14:18:20.4895 619 ms. EXEC: update payReceipt set recCreation = '2024-12-20 14:18:19',recModify = '2024-12-20 14:18:19',recUseId=0,recStatus='V' where recId = 334335 20/12/2024 14:21:20.8512 1526 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 20/12/2024 14:21:21.0163 1127 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 20/12/2024 14:30:52.6784 1240 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 14:34:11.2615 626 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 20/12/2024 14:34:11.9840 646 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 14:37:07.4673 847 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 = 6 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 20/12/2024 14:39:53.6326 533 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-20 14:39:52' where traUID = 4709626172513890 and traStatus='V' and traEnabled=1 20/12/2024 14:41:04.7255 679 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 20/12/2024 14:44:16.5532 919 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-20 14:44:15',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-20 14:44:15',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'; 20/12/2024 14:50:25.7839 977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 14:51:19.6463 835 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 20/12/2024 14:56:49.6369 606 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 20/12/2024 15:00:30.5044 682 ms. EXEC: update payReceipt set recCreation = '2024-12-20 15:00:29',recModify = '2024-12-20 15:00:29',recUseId=0,recStatus='V' where recId = 334356 20/12/2024 15:03:10.1250 551 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 15:05:51.2294 757 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 20/12/2024 15:11:30.2800 706 ms. EXEC: update tabTerminalReceipt set trcProgressive = 8187, trcLastPrinted = '2400608187', trcLastDate = '2024-12-20 15:11:29' where trcStatus='V' and trcTerId = 17 20/12/2024 15:12:53.1526 983 ms. EXEC: update payReceipt set recCreation = '2024-12-20 15:12:52',recModify = '2024-12-20 15:12:52',recUseId=0,recStatus='V' where recId = 334367 20/12/2024 15:12:54.3675 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 15:13:20.8312 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 15:13:20.8342 565 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 20/12/2024 15:37:46.7670 524 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-20 15:37:46',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 20/12/2024 15:44:59.3387 1254 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 15:50:29.4711 719 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 20/12/2024 15:51:37.8728 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 15:55:50.6015 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 16:09:10.6967 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 16:11:39.2567 572 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 20/12/2024 16:22:38.1771 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 16:23:24.5395 529 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-20 16:23:23',3,42101,0,50,2,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 20/12/2024 16:26:32.8040 1523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 16:35:38.7635 746 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 16:35:40.9700 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 16:47:24.9329 524 ms. EXEC: update tabTerminalReceipt set trcProgressive = 54295, trcLastPrinted = '2400754295', trcLastDate = '2024-12-20 16:47:24' where trcStatus='V' and trcTerId = 18 20/12/2024 16:57:39.6566 555 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 20/12/2024 17:07:21.7434 829 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-20 17:07:20','V',4735789879006570,2024,'2024-12-20 17:07:19','456445843000327005012999',2,2,2,'O','',0,'2024-12-20 17:07:20',1,'','',0) 20/12/2024 17:09:12.4808 504 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 20/12/2024 17:09:44.8021 691 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4860008188316240,5118756063362370,2024,'2024-12-20 17:09:44',' Date: 12/20/2024 5:09:43 PM Code: 456445604900327005012999 Entry Date: 12/20/2024 3:34:09 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 # 2400754302 ',0) 20/12/2024 17:10:49.8592 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 17:12:01.5531 831 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 20/12/2024 17:18:26.6392 650 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 17:19:45.3678 1469 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-20 17:19:43' where payTraUID = 4753484934045280 and payStatus='V' and payEnabled=1 20/12/2024 17:21:03.0271 599 ms. EXEC: update abbCards set carLastDate = '2024-12-20 17:21:02',carLastDirection='O' where carStatus='V' and carId = 8 20/12/2024 17:23:22.1321 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 17:33:47.1163 526 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-20 17:33:46','V',5189928609317500,2024,'2024-12-20 17:33:45','456445680800327001012999',2,2,2,'O','',0,'2024-12-20 17:33:46',1,'','',0) 20/12/2024 17:36:20.7602 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 17:36:53.9253 825 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 20/12/2024 17:41:37.7137 565 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 20/12/2024 17:48:23.0672 707 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 20/12/2024 17:50:29.9923 672 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-12-20 16:50:29') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-20 17:50:29' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-20 17:50:29' and (resAreId = 1 or resAreId <= 0) nr: 0 20/12/2024 17:51:19.7616 1383 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-20 17:51:18' where payTraUID = 5130282941279600 and payStatus='V' and payEnabled=1 20/12/2024 17:51:21.2136 1450 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-20 17:51:18' where traUID = 5130282941279600 and traStatus='V' and traEnabled=1 20/12/2024 18:08:55.9955 677 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-20 18:08:55',0,0,'V',5145492967687550,4737853140436210,2024,'2024-12-20 18:08:55',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-12-20 18:08:55',0,0,'V',5145492967687550,4737853140436210,2024,'2024-12-20 18:08:55',3,'KES',-1,100,-100,'N',''); 20/12/2024 18:15:05.2933 622 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-20 18:15:04' where traUID = 5071538811515450 and traStatus='V' and traEnabled=1 20/12/2024 18:20:31.5262 787 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 20/12/2024 18:21:26.7165 1233 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5521449583951810,5430022591669360,2024,'2024-12-20 18:21:25',' Date: 12/20/2024 6:21:25 PM Code: 456446395300327005012999 Entry Date: 12/20/2024 5:45:53 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 # 2400754313 ',0) 20/12/2024 18:24:18.1437 578 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 20/12/2024 18:27:51.7875 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 18:28:31.0328 791 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-20 18:28:30',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'; 20/12/2024 18:33:12.2248 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 18:42:26.5354 542 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/12/2024 18:44:16.3546 690 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-20 18:44:15' where traUID = 5517392879792920 and traStatus='V' and traEnabled=1 20/12/2024 18:52:47.2663 851 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-20 18:52:46',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'; 20/12/2024 19:02:15.7042 2786 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 20/12/2024 19:11:28.5027 684 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-20 19:11:27',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 20/12/2024 19:31:19.3882 551 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 19:34:41.1748 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 19:37:12.4139 2930 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 = 10 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 20/12/2024 19:49:23.9199 1189 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-20 19:49:22',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'; 20/12/2024 20:02:20.3184 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 20:06:41.7111 522 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-20 20:06:41',0,16,'2024-12-20 20:06:41','','Unauthorized Transit Entry 2') 20/12/2024 20:13:54.0977 581 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/12/2024 20:14:47.1942 1122 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 20/12/2024 20:15:00.1909 517 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-20 20:14:59',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'; 20/12/2024 20:16:16.1787 908 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 20/12/2024 20:16:41.3004 640 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-20 20:13:51',1,'V',5461233773109170,5595683409494150,2024,'2024-12-20 20:13:51',17,1,0,4,'2024-12-20 20:28:51','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 20/12/2024 20:17:25.9073 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 20:17:28.1578 1770 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-20 20:17:26','V',4999034584743510,2024,'2024-12-20 20:17:23','456447260300327005012999',2,2,2,'O','',0,'2024-12-20 20:17:26',1,'','',0) 20/12/2024 20:17:57.2732 930 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 20:18:01.6482 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 20:18:10.6592 1413 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-12-20 20:18:08',0,'V',5382305184346100,5747243710341330,2024,'2024-12-20 20:18:08',2,1,0,-1,'2024-12-20 21:18:08','S','KES',0,0,0,'','','',3,0,0) 20/12/2024 20:19:30.1223 1707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 20:22:31.8538 909 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 20:52:25.5429 624 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 20:53:22.6163 540 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-20 20:53:22' where payTraUID = 5293879559935940 and payStatus='V' and payEnabled=1 20/12/2024 20:53:25.3791 755 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 20:54:50.6042 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 20:59:15.4162 542 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-20 20:59:14','V',5515534178633140,2024,'2024-12-20 20:59:13','456447555300327005012999',1,2,16,'I','',1,0,1,'','',4) 20/12/2024 21:34:11.0905 746 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 20/12/2024 21:40:35.4435 818 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 21:47:45.1014 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 22:03:09.3553 578 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/12/2024 22:03:31.6225 1402 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 20/12/2024 22:13:44.9351 1156 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 22:13:44.9521 1156 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 20/12/2024 22:13:51.8581 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 22:14:36.4598 1997 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 22:15:41.6820 755 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 22:16:27.7902 977 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-20 22:16:26' where payTraUID = 5302970450088670 and payStatus='V' and payEnabled=1 20/12/2024 22:25:34.3026 612 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 22:25:36.7932 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 22:25:42.2088 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 22:25:54.6221 732 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-20 22:25:53' where subId = 16 20/12/2024 22:45:52.4864 501 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-20 22:45:51' where payTraUID = 4793387422226940 and payStatus='V' and payEnabled=1 20/12/2024 22:47:03.7530 1470 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 20/12/2024 22:48:57.0878 1226 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 22:51:27.3482 1252 ms. EXEC: update tabTerminalReceipt set trcProgressive = 18218, trcLastPrinted = '2400418218', trcLastDate = '2024-12-20 22:51:26' where trcStatus='V' and trcTerId = 4 20/12/2024 22:52:13.3345 712 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/12/2024 22:52:14.6003 970 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-20 22:52:13' where traUID = 5346908721714890 and traStatus='V' and traEnabled=1 20/12/2024 22:52:22.5236 2522 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 20/12/2024 22:52:22.5426 2150 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 20/12/2024 22:53:25.3309 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 23:29:14.6718 1529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/12/2024 23:30:42.3686 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 20/12/2024 23:30:51.5962 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1