07/01/2025 00:41:00.0136 604 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/01/2025 00:44:31.4240 522 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/01/2025 00:55:48.8196 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 01:23:00.9204 688 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 01:23:59.7908 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 01:44:01.7227 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 01:44:52.0584 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 01:48:10.2426 1034 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 02:11:12.3514 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 02:23:11.8482 1350 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 02:32:56.7133 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 02:51:54.1866 934 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 03:05:21.5563 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 03:14:36.9128 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 03:36:05.5109 614 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 03:36:04' where traUID = 5174627083480230 and traStatus='V' and traEnabled=1 07/01/2025 03:43:24.5192 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 03:51:18.9075 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 04:22:59.7834 505 ms. EXEC: update abbCards set carLastDate = '2025-01-07 04:22:59',carLastDirection='O' where carStatus='V' and carId = 165 07/01/2025 04:28:33.2161 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 05:02:47.8102 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 05:23:04.8181 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 05:27:42.4327 527 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/01/2025 05:44:13.3620 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 05:53:31.3428 1011 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 05:53:30' where payTraUID = 4711416185997650 and payStatus='V' and payEnabled=1 07/01/2025 05:53:41.0323 666 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 05:56:50.3410 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 05:59:23.5184 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 06:01:25.4138 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 06:03:02.4323 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 06:06:58.7655 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 06:20:41.1769 1143 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 07/01/2025 06:23:04.4647 773 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 06:23:03','V',4825095234403080,2025,'2025-01-07 06:23:03','456622298300327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 06:23:05.7966 1327 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 06:35:16.6176 736 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 06:37:42.4378 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 06:40:53.7597 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 06:51:44.3305 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 06:55:45.0036 539 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/01/2025 06:57:29.7862 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 06:57:57.5945 945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 06:58:03.2463 1674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 1 ms.) 07/01/2025 07:03:41.6731 528 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/01/2025 07:03:48.2535 1401 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 07:03:48.3046 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 07:04:20.9524 874 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 07:14:15.8779 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 07:27:43.6057 1177 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 07/01/2025 07:37:15.8721 752 ms. EXEC: update abbCards set carLastDate = '2025-01-07 07:37:15',carLastDirection='I' where carStatus='V' and carId = 19 07/01/2025 07:44:50.6720 1004 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 07:44:49','V',5064472777539630,2025,'2025-01-07 07:44:47','456622657000327005012999',2,2,2,'O','',0,'2025-01-07 07:44:49',1,'','',0) 07/01/2025 07:51:43.2783 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 07:52:16.3454 986 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-07 07:52:13',0,'V',5532249514560990,4733654240945540,2025,'2025-01-07 07:52:13',3,1,0,4,'2025-01-07 08:07:13','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 07/01/2025 07:55:27.3731 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 07:58:28.1813 895 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 07:58:26',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 07/01/2025 08:01:22.7988 607 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 08:01:51.9773 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 08:09:49.3425 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 08:12:53.5446 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 08:15:59.9992 507 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 07/01/2025 08:18:53.2600 2049 ms. EXEC: update payReceipt set recCreation = '2025-01-07 08:18:51',recModify = '2025-01-07 08:18:51',recUseId=0,recStatus='V' where recId = 339797 07/01/2025 08:18:54.9071 1304 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 08:18:53',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 07/01/2025 08:20:31.5117 1378 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 08:21:41.6453 707 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 08:23:05.9258 534 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 08:25:40.0021 723 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 08:25:39' where traUID = 5263087082736110 and traStatus='V' and traEnabled=1 07/01/2025 08:25:48.9331 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 08:26:23.9445 1053 ms. EXEC: update paycash set casCreation = '2025-01-07 08:26:22',casModify = '2025-01-07 08:26:22',casUseId=0,casStatus='V' where casId = 203638 07/01/2025 08:26:26.2320 1703 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 08:26:24',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity-1,5),curAmount=round(curAmount-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 08:26:24',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 08:26:24',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'; 07/01/2025 08:30:32.4149 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 08:34:53.6746 1963 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/01/2025 08:47:57.0221 929 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 08:47:57.1962 533 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 08:52:21.3418 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 09:09:21.6082 881 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 09:09:37.0045 610 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/01/2025 09:16:24.3628 891 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,0,50,-9,-450,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,0,50,9,450,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,0,100,-37,-3700,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,0,100,37,3700,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,0,200,-1,-200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,0,200,1,200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,0,500,-2,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,0,500,2,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,0,1000,-2,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,0,1000,2,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:12',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 07/01/2025 09:16:25.4105 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 09:16:25.9079 884 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:20',5,3,42101,0,50,-18,-900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:20',5,3,42101,0,100,-45,-4500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:20',5,3,42101,0,200,-3,-600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:20',5,3,42101,0,500,-3,-1500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:20',5,3,42101,0,1000,-2,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 09:16:20',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; (WAIT TIME 366 ms.) 07/01/2025 09:21:55.2821 1494 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 09:22:57.7179 810 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 09:22:56','V',4867378129406240,2025,'2025-01-07 09:22:55','456623377500327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 09:22:58.2913 556 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 09:23:16.0441 688 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 09:23:15','V',5505558443716920,2025,'2025-01-07 09:23:14','456620000800327003229999',22,22,3,'I','',1,0,1,'','',0) 07/01/2025 09:26:32.9147 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 09:27:45.8370 570 ms. EXEC: update payReceipt set recCreation = '2025-01-07 09:27:45',recModify = '2025-01-07 09:27:45',recUseId=0,recStatus='V' where recId = 339809 07/01/2025 09:27:46.4814 642 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 07/01/2025 09:27:47.0948 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 09:29:05.7595 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 09:29:08.6375 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 09:36:04.6407 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 09:38:15.8363 773 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 09:50:09.8115 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 09:52:55.5383 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 09:55:03.0225 1186 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 09:59:18.4413 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 10:02:59.1818 1307 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:05:18.1017 1012 ms. EXEC: update payInventory set invCreation = '2025-01-07 10:05:17',invModify = '2025-01-07 10:05:17',invUseId=0,invStatus='V' where invId = 229746 07/01/2025 10:05:18.1187 946 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:07:22.5169 1913 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:09:12.4153 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 10:09:59.4488 1301 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 10:10:16.9645 1100 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 07/01/2025 10:11:32.8872 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:14:19.7037 1480 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-07 10:14:18',0,0,'V',5255435982222390,4722522652672420,2025,'2025-01-07 10:14:18',3,'KES',1,100,100,'N',''); 07/01/2025 10:14:19.7217 790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:14:20.3692 654 ms. EXEC: update paycash set casCreation = '2025-01-07 10:14:19',casModify = '2025-01-07 10:14:19',casUseId=0,casStatus='V' where casId = 203649 07/01/2025 10:15:32.5574 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:15:59.7146 765 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 10:15:58' where traUID = 4722522652672420 and traStatus='V' and traEnabled=1 07/01/2025 10:19:21.6486 529 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 10:20:25.5643 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 10:25:26.9728 1436 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-07 10:25:25',0,16,'2025-01-07 10:25:25','','Manual Open Barrier Entry 2') 07/01/2025 10:31:27.1781 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 10:32:08.0294 728 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-07 10:32:07','V',5677057522937990,2025,'2025-01-07 10:32:01','456623792100327005012999',1,2,16,'I','',1,0,1,'','0810007145851',106,0) 07/01/2025 10:32:08.8820 721 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 10:32:10.0738 1189 ms. EXEC: update abbCards set carLastDate = '2025-01-07 10:32:08',carLastDirection='I' where carStatus='V' and carId = 106 07/01/2025 10:32:21.2322 832 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 10:32:24.5524 1265 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 10:32:23','V',4778918442442030,2025,'2025-01-07 10:32:09','456623792900327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 10:32:26.6278 1311 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-07 10:32:25','V',4831972922168790,2025,'2025-01-07 10:32:23','456623794300327005012999',1,2,16,'I','',1,0,1,'','0560008421760',192,0) 07/01/2025 10:32:26.6288 2040 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 10:32:28.8393 1854 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 10:32:43.4721 601 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 10:32:42','V',4979992729564120,2025,'2025-01-07 10:32:42','456623796200327001012999',1,2,1,'I','',1,0,1,'','',4) 07/01/2025 10:36:54.7424 735 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 07/01/2025 10:41:23.5816 840 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 10:41:22' where payTraUID = 4798312875113480 and payStatus='V' and payEnabled=1 07/01/2025 10:42:05.6113 660 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 10:43:00.4029 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:43:29.2072 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:44:02.9177 953 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 391345 else acvFstPayId end),acvLstPayId = 391345 where acvSftId = 881 and acvCodeId = 3 07/01/2025 10:44:24.1099 1351 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:45:30.5252 643 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5597218500811220,5231620550748720,2025,'2025-01-07 10:45:29','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 1/7/2025 10:33:59 AM Date : 1/7/2025 10:45:29 AM Code : 456623803900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 07/01/2025 10:45:39.1720 1062 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 10:45:54.4777 963 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-01-07 10:45:53',0,'V',5173985037515660,4667677860017360,2025,'2025-01-07 10:45:53',2,1,0,-1,'2025-01-07 11:45:53','S','KES',0,0,0,'','','',3,0,0) (WAIT TIME 5 ms.) 07/01/2025 10:46:24.3077 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:46:31.8167 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 10:47:19.1460 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 10:48:45.6158 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:48:54.4677 548 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/01/2025 10:49:03.2116 1400 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 10:51:16.0234 754 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 10:54:49.9584 610 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 10:57:42.5321 576 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); (WAIT TIME 113 ms.) 07/01/2025 11:01:03.6875 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:05:13.2544 1699 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/01/2025 11:05:16.0683 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:05:34.9480 1028 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 11:05:33','V',5596107070689050,2025,'2025-01-07 11:05:32','456623993200327001012999',1,2,1,'I','',1,0,1,'','',4) 07/01/2025 11:06:04.7122 713 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 11:06: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'; 07/01/2025 11:06:19.7723 1185 ms. EXEC: update payReceipt set recCreation = '2025-01-07 11:06:18',recModify = '2025-01-07 11:06:18',recUseId=0,recStatus='V' where recId = 339846 07/01/2025 11:10:48.1855 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 11:10:48.3296 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:11:48.0711 1009 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 11:11:46' where traUID = 5460579528330060 and traStatus='V' and traEnabled=1 07/01/2025 11:11:51.7286 724 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 11:16:46.8590 808 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 07/01/2025 11:16:53.0101 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 11:18:16.3000 1623 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 11:18:14',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 07/01/2025 11:19:11.6650 813 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-07 11:19:08',0,'V',4947461029254970,5520175885001230,2025,'2025-01-07 11:19:08',3,1,0,4,'2025-01-07 11:34:08','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 07/01/2025 11:21:13.1192 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 11:22:41.7515 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:23:17.2782 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:34:26.1537 943 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:41:02.2465 504 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 11:41:01' where traUID = 4837446616837970 and traStatus='V' and traEnabled=1 07/01/2025 11:41:11.9519 1458 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/01/2025 11:41:11.9610 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:41:55.3980 1242 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 11:41:54','V',4696883554649860,2025,'2025-01-07 11:41:53','456624211300327001012999',1,2,1,'I','',1,0,1,'','',4) 07/01/2025 11:42:16.4040 1223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:42:56.3257 1478 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:43:02.7820 775 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 11:43:41.7621 744 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-07 11:40:37',1,'V',4656540060323380,5666777403067050,2025,'2025-01-07 11:40:37',17,1,0,4,'2025-01-07 11:55:37','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/01/2025 11:46:37.1223 614 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 11:46:36' where payTraUID = 5081353822910840 and payStatus='V' and payEnabled=1 07/01/2025 11:49:10.7220 1569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:49:36.5092 575 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-07 10:49:35') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-07 11:49:35' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-07 11:49:35' and (resAreId = 1 or resAreId <= 0) nr: 0 07/01/2025 11:50:06.9786 1120 ms. EXEC: update payReceipt set recCreation = '2025-01-07 11:50:05',recModify = '2025-01-07 11:50:05',recUseId=0,recStatus='V' where recId = 339867 07/01/2025 11:50:07.5370 501 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-07 11:50:07',0,0,'V',5640922270289960,4893450546529030,2025,'2025-01-07 11:50:07',3,'KES',1,100,100,'N',''); 07/01/2025 11:51:09.2172 651 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-07 11:51:08',0,0,'V',5020446315000040,5378074750331250,2025,'2025-01-07 11:51:08',3,'KES',1,100,100,'N',''); 07/01/2025 11:51:09.8156 596 ms. EXEC: update paycash set casCreation = '2025-01-07 11:51:09',casModify = '2025-01-07 11:51:09',casUseId=0,casStatus='V' where casId = 203671 07/01/2025 11:51:43.6562 548 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 11:54:06.2065 2000 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5383567824022560,5378811947217230,2025,'2025-01-07 11:54:04',' Date: 1/7/2025 11:54:04 AM Code: 456624159000327005012999 Entry Date: 1/7/2025 11:33:10 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 # 2500700910 ',0) 07/01/2025 11:55:12.6839 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:57:35.8927 920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 11:58:12.3550 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 11:59:11.3335 765 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 11:59:21.6964 1729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 12:02:36.2735 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 12:02:37.0220 713 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/01/2025 12:02:57.6117 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 12:05:52.1004 608 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 12:05:53.0730 876 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/01/2025 12:05:54.1347 910 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 12:05:53' where traUID = 5756225884578390 and traStatus='V' and traEnabled=1 07/01/2025 12:05:58.9329 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 12:06:20.3652 621 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 12:06:19',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 07/01/2025 12:07:11.7606 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 12:07:20.8747 1003 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 12:09:07.5490 1018 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 12:09:52.7472 688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 12:10:34.1249 604 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 12:10:33',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 07/01/2025 12:10:51.6516 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 12:12:49.2542 537 ms. EXEC: update payInventory set invCreation = '2025-01-07 12:12:48',invModify = '2025-01-07 12:12:48',invUseId=0,invStatus='V' where invId = 229778 07/01/2025 12:16:41.2027 530 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-07 12:16:40','V',5276556501561580,2025,'2025-01-07 12:16:38','456624419800327005012999',1,2,16,'I','',1,0,1,'','0230004098589',197,0) 07/01/2025 12:19:17.3521 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 12:26:09.9479 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 12:29:43.7348 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 12:35:16.3502 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 12:38:30.4914 768 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 07/01/2025 12:41:37.3093 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 12:42:37.2649 644 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 12:42:36' where traUID = 5132949098719950 and traStatus='V' and traEnabled=1 07/01/2025 12:43:40.0208 649 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 12:43:39','V',5679324138467370,2025,'2025-01-07 12:43:37','456624581700327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 12:45:25.2242 674 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 12:45:24' where payTraUID = 4956572231668710 and payStatus='V' and payEnabled=1 07/01/2025 12:50:06.4612 928 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 12:52:46.4354 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 12:53:54.0266 746 ms. EXEC: update paycash set casCreation = '2025-01-07 12:53:53',casModify = '2025-01-07 12:53:53',casUseId=0,casStatus='V' where casId = 203686 07/01/2025 12:56:50.1333 605 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 12:56:49','V',5339999823414580,2025,'2025-01-07 12:56:47','456624360600327005012999',2,2,2,'O','',0,'2025-01-07 12:56:49',1,'','',0) 07/01/2025 12:56:53.6106 516 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 12:57:20.0013 503 ms. EXEC: update payInventory set invCreation = '2025-01-07 12:57:19',invModify = '2025-01-07 12:57:19',invUseId=0,invStatus='V' where invId = 229794 07/01/2025 12:57:25.3639 537 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/01/2025 12:58:53.0885 649 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 12:58:53.9851 802 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 12:59:07.1559 1027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 26 ms.) 07/01/2025 12:59:32.7270 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 12:59:33.4535 694 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/01/2025 13:01:13.2122 1693 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 07/01/2025 13:03:04.2397 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:03:07.1937 2048 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 13:03:05','V',5188272210906800,2025,'2025-01-07 13:03:03','456624698300327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 13:03:27.3311 1702 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 13:03:28.5920 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 237 ms.) 07/01/2025 13:08:42.1983 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 13:13:19.2236 570 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 13:13:18' where traUID = 5469051775991710 and traStatus='V' and traEnabled=1 07/01/2025 13:13:39.9055 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:17:00.0812 640 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5211331588083710,5208128967425490,2025,'2025-01-07 13:16:59',' Date: 1/7/2025 1:16:58 PM Code: 456624580200327005012999 Entry Date: 1/7/2025 12:43:22 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500700926 ',0) 07/01/2025 13:17:48.1504 1400 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 13:18:40.1631 2177 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 13:18:37',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 07/01/2025 13:19:45.4718 703 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 13:19:44','V',4628117667952540,2025,'2025-01-07 13:19:42','456624798200327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 13:20:32.3471 1179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:20:38.8195 1420 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:21:06.2798 2312 ms. EXEC: update tabTerminalReceipt set trcProgressive = 927, trcLastPrinted = '2500700927', trcLastDate = '2025-01-07 13:21:03' where trcStatus='V' and trcTerId = 18 07/01/2025 13:21:29.1721 1936 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 07/01/2025 13:22:03.1428 691 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 13:22:02' where traUID = 4920205445124110 and traStatus='V' and traEnabled=1 07/01/2025 13:22:38.4995 658 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 13:28:00.6198 618 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 13:28:01.3743 718 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 13:28:09.3846 1384 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 13:29:56.8155 999 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/01/2025 13:29:58.1193 1232 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 13:29:56' where traUID = 4943614992777440 and traStatus='V' and traEnabled=1 07/01/2025 13:31:06.7652 633 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/01/2025 13:35:08.4758 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:37:05.5881 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 13:40:11.7000 952 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 13:40:10' where payTraUID = 4904695141385270 and payStatus='V' and payEnabled=1 07/01/2025 13:40:15.6236 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 13:43:30.6150 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:46:09.5353 681 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 13:46:13.7832 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 13:46:15.9896 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:46:19.5450 541 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/01/2025 13:46:42.6044 543 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 07/01/2025 13:46:57.7956 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:49:42.2249 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 13:49:51.5102 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 13:49:59.4975 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:53:04.0730 1148 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 13:53:02','V',4636413124616150,2025,'2025-01-07 13:53:02','456624785200327001012999',2,2,2,'O','',0,'2025-01-07 13:53:02',1,'','',0) 07/01/2025 13:53:05.1318 736 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 13:53:04' where payTraUID = 5508110469693720 and payStatus='V' and payEnabled=1 07/01/2025 13:53:12.0094 593 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 13:53:14.9723 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:54:02.5501 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:56:59.3971 733 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 13:57:01.8247 970 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 13:57:00' where payTraUID = 5698645711433120 and payStatus='V' and payEnabled=1 07/01/2025 13:59:19.4624 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:00:32.3916 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:00:43.1537 568 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 14:00:42' where traUID = 5376579725375240 and traStatus='V' and traEnabled=1 07/01/2025 14:02:33.5810 1080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:03:09.3990 639 ms. EXEC: update abbCards set carLastDate = '2025-01-07 14:03:08',carLastDirection='I' where carStatus='V' and carId = 187 07/01/2025 14:03:10.0024 552 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 14:03:15.7172 509 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/01/2025 14:05:07.0957 569 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 14:05:06','V',5354448126795440,2025,'2025-01-07 14:05:03','456625070300327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 71 ms.) 07/01/2025 14:05:09.9466 2039 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-01-07 14:05:07','0230003944059',0,0,5043244746565060,13,'0000-00-00 00:00:00','0000-00-00 00:00:00') 07/01/2025 14:05:17.0523 950 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 14:05:25.8912 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:06:45.1962 3002 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 14:06:41',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 07/01/2025 14:10:49.6283 1187 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/01/2025 14:10:50.7530 813 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 14:10:49' where traUID = 5403477228869680 and traStatus='V' and traEnabled=1 07/01/2025 14:18:44.8041 751 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/01/2025 14:20:28.2842 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:21:14.8293 1865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:23:05.9456 894 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 818674 07/01/2025 14:23:32.7205 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 14:26:10.3799 667 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/01/2025 14:28:26.8241 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 14:34:33.7609 762 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 07/01/2025 14:34:35.0277 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 14:40:38.5458 2280 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/01/2025 14:40:59.7249 587 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 07/01/2025 14:41:01.4911 1757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:41:46.8104 1992 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 14:41:47.8891 902 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 14:41:57.0082 985 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/01/2025 14:42:04.2040 1026 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 14:42:03',3,42101,0,1000,1,1000,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+1000,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 1000 and curType = 'N'; 07/01/2025 14:42:05.2788 507 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 14:42:04',3,42101,0,200,-1,-200,1,'O','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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 14:42:04',3,42101,0,500,-1,-500,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 07/01/2025 14:42:06.8998 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:42:44.7929 793 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 14:44:05.7494 693 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 14:44:05' where payTraUID = 4979992729564120 and payStatus='V' and payEnabled=1 07/01/2025 14:44:15.4799 901 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/01/2025 14:45:34.1795 869 ms. EXEC: update payInventory set invCreation = '2025-01-07 14:45:33',invModify = '2025-01-07 14:45:33',invUseId=0,invStatus='V' where invId = 229831 07/01/2025 14:45:34.5698 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:45:34.8169 624 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-01-07 14:45:34',0,0,'V',5053622556766960,4996469722487660,2025,'2025-01-07 14:45:34',3,'KES',-1,50,-50,'N',''); 07/01/2025 14:45:36.6802 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:45:46.0274 1051 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 14:46:58.0347 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 14:47:13.6121 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:52:32.8766 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 14:54:13.4188 577 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-07 14:54:12' where subId = 43 07/01/2025 14:55:20.1254 689 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5072392684301210,5641337328465790,2025,'2025-01-07 14:55:19',' Data: 1/7/2025 2:52:15 PM Codice: 456625296400327005012999 Ingresso: 1/7/2025 2:42:44 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 # 2500600133 ',0) 07/01/2025 14:55:20.6877 560 ms. EXEC: update payReceipt set recCreation = '2025-01-07 14:55:20',recModify = '2025-01-07 14:55:20',recUseId=0,recStatus='V' where recId = 339974 07/01/2025 14:56:06.2432 1560 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-07 14:56:04',17,1,'2025-01-07 14:56:04','456625321400327005012999','Pagato (Contanti ) Biglietto ') 07/01/2025 14:57:59.0256 504 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/01/2025 14:59:06.1054 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 14:59:54.5128 751 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 15:02:05.9736 702 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 15:02:26.1051 941 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 15:02:24' where traUID = 4677867782589700 and traStatus='V' and traEnabled=1 07/01/2025 15:02:33.3409 588 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-07 15:02:32',0,'V',4945184110593500,4636003122051930,2025,'2025-01-07 15:02:32',18,1,0,4,'2025-01-07 15:17:32','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/01/2025 15:02:34.3546 684 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4636003122051930,4945184110593500,2025,'2025-01-07 15:02:33',' Date: 1/7/2025 3:02:32 PM Code: 456625062700327001012999 Entry Date: 1/7/2025 2:03:47 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500700947 ',0) 07/01/2025 15:04:26.7678 1410 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 15:04:33.0339 778 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5327857543099160,5330734426813800,2025,'2025-01-07 15:04:32',' Data: 1/7/2025 3:01:29 PM Codice: 456625138100327005012999 Ingresso: 1/7/2025 2:16:21 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 # 2500600135 ',0) 07/01/2025 15:04:46.4809 677 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentToConfirm' 07/01/2025 15:04:46.6520 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 15:04:47.1094 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 15:04:49.7491 1016 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-07 15:04:48',0,16,'2025-01-07 15:04:48','','Unauthorized Transit Entry 2') 07/01/2025 15:04:55.6901 764 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/01/2025 15:05:01.6321 726 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 15:05:15.3402 593 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 15:05:14','V',5523002432175820,2025,'2025-01-07 15:05:11','456625431100327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 15:08:56.1490 1504 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 15:08:54',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 15:08:54',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'; 07/01/2025 15:09:39.0027 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 15:13:57.8016 815 ms. EXEC: update abbCards set carLastDate = '2025-01-07 15:13:56',carLastDirection='O' where carStatus='V' and carId = 17 07/01/2025 15:16:10.4723 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 15:22:41.0394 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 15:28:35.6006 654 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 15:29:35.7839 1325 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 15:32:02.5249 625 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/01/2025 15:32:19.7555 502 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 15:32:18',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N'; 07/01/2025 15:32:32.4049 547 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 15:32:33.9379 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 15:33:15.0704 637 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 15:33:14' where traUID = 5086008808109980 and traStatus='V' and traEnabled=1 07/01/2025 15:34:09.1206 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 15:34:22.5656 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 15:34:38.4582 1001 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 15:34:40.2194 1405 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 15:34:38' where payTraUID = 4625503589900640 and payStatus='V' and payEnabled=1 07/01/2025 15:35:52.3035 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 15:36:53.5275 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 15:39:13.1298 1411 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-07 15:39:11',0,'V',5266760764800230,4703130068609920,2025,'2025-01-07 15:39:11',18,1,0,4,'2025-01-07 15:54:11','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/01/2025 15:42:38.7512 1368 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/01/2025 15:46:34.3429 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 15:51:09.3979 556 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 15:51:08' where payTraUID = 5543401577861810 and payStatus='V' and payEnabled=1 07/01/2025 15:51:15.2529 779 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 15:51:52.0024 1185 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 07/01/2025 15:53:26.1604 757 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/01/2025 15:53:26.2294 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 15:57:07.9066 1229 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 15:57:06','V',5241746353615330,2025,'2025-01-07 15:57:05','456625742500327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 15:57:29.1418 605 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 391550 else acvFstPayId end),acvLstPayId = 391550 where acvSftId = 881 and acvCodeId = 3 07/01/2025 15:57:30.6758 1507 ms. EXEC: update tabTerminalReceipt set trcProgressive = 242, trcLastPrinted = '2500400242', trcLastDate = '2025-01-07 15:57:29' where trcStatus='V' and trcTerId = 4 07/01/2025 15:58:29.9244 894 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-07 15:58:29',4,6,'2025-01-07 15:58:29','456625575200327005012999','Payed (Credit Card ) Ticket ') 07/01/2025 16:21:02.7823 674 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5322422339964130,5105188758002550,2025,'2025-01-07 16:21:02',' Date: 1/7/2025 4:21:01 PM Code: 456625414600327005012999 Entry Date: 1/7/2025 3:02: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 # 2500700966 ',0) 07/01/2025 16:21:03.8100 552 ms. EXEC: update payReceipt set recCreation = '2025-01-07 16:21:03',recModify = '2025-01-07 16:21:03',recUseId=0,recStatus='V' where recId = 340019 07/01/2025 16:23:07.6237 668 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 16:23:14.1141 1129 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 16:23:58.8830 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 16:24:32.0341 501 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 16:24:31' where traUID = 5034881466756190 and traStatus='V' and traEnabled=1 07/01/2025 16:31:15.7777 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 16:41:03.6266 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 16:41:09.5786 574 ms. EXEC: update tabTerminalReceipt set trcProgressive = 970, trcLastPrinted = '2500700970', trcLastDate = '2025-01-07 16:41:09' where trcStatus='V' and trcTerId = 18 07/01/2025 16:43:41.6785 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 16:44:17.9737 507 ms. EXEC: update paycash set casCreation = '2025-01-07 16:44:17',casModify = '2025-01-07 16:44:17',casUseId=0,casStatus='V' where casId = 203749 07/01/2025 16:45:18.9957 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 16:48:17.0298 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 16:53:06.6043 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 16:56:14.4649 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 16:58:16.2793 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 16:58:35.9215 684 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='456625335100327005012999' 07/01/2025 17:01:15.0898 683 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-07 17:01:14',0,'V',5690225374222440,5034136158475790,2025,'2025-01-07 17:01:14',18,1,0,4,'2025-01-07 17:16:14','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/01/2025 17:01:50.6706 653 ms. EXEC: update paycash set casCreation = '2025-01-07 17:01:50',casModify = '2025-01-07 17:01:50',casUseId=0,casStatus='V' where casId = 203756 07/01/2025 17:01:51.8314 934 ms. EXEC: update payInventory set invCreation = '2025-01-07 17:01:50',invModify = '2025-01-07 17:01:50',invUseId=0,invStatus='V' where invId = 229866 07/01/2025 17:02:03.3971 1105 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 17:02:40.6801 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:02:54.3092 1120 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-01-07 17:02:53',0,'V',4631945836580910,5427674077110020,2025,'2025-01-07 17:02:53',2,1,0,-1,'2025-01-07 18:02:53','S','KES',0,0,0,'','','',3,0,0) 07/01/2025 17:04:25.0748 665 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 17:04:38.8921 502 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 17:04:38' where payTraUID = 5034136158475790 and payStatus='V' and payEnabled=1 07/01/2025 17:06:18.2265 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:06:48.1045 2255 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 17:06:48.1095 2139 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 07/01/2025 17:06:49.9557 1345 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 17:07:33.9591 1831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:09:14.4383 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:09:29.8676 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:09:31.3005 560 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 17:09: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'; 07/01/2025 17:10:49.6789 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:12:14.8299 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 17:13:42.8647 1345 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/01/2025 17:16:17.2409 508 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 17:18:54.7322 1154 ms. EXEC: update payReceipt set recCreation = '2025-01-07 17:18:53',recModify = '2025-01-07 17:18:53',recUseId=0,recStatus='V' where recId = 340043 07/01/2025 17:19:16.6938 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:20:48.9825 654 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 17:22:54.9856 1252 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-07 17:22:53','V',5266056932630340,2025,'2025-01-07 17:22:50','456626105700327001012999',2,2,2,'O','',0,'2025-01-07 17:22:53',1,'','0230003943530',44,0) 07/01/2025 17:23:05.4085 969 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-07 17:23:04',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 07/01/2025 17:23:25.0430 1164 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 17:23:34.0950 826 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 17:28:15.3968 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:29:02.1801 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:30:12.2770 649 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-07 17:30:11',0,'V',5525191103606990,5081150793395550,2025,'2025-01-07 17:30:11',18,1,0,4,'2025-01-07 17:45:11','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 07/01/2025 17:31:33.9331 586 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 17:31:34.7076 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 17:32:25.1466 669 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/01/2025 17:32:27.2500 2002 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 17:32:25' where payTraUID = 5295807473171820 and payStatus='V' and payEnabled=1 07/01/2025 17:33:57.8751 1007 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:37:21.2891 879 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 17:44:01.6752 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 17:44:02.0444 564 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 07/01/2025 17:50:02.5076 620 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 17:50:01' where traUID = 5467563863045720 and traStatus='V' and traEnabled=1 07/01/2025 17:51:06.7405 1415 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:51:31.7472 585 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-07 17:51:31',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 ('2025-01-07 17:51:31',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'; 07/01/2025 17:51:31.9734 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:52:31.4992 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 17:52:35.6169 501 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/01/2025 17:54:49.6615 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 17:55:13.6946 998 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 17:55:12','V',4990013995197540,2025,'2025-01-07 17:55:11','456620001400327003229999',22,22,3,'I','',1,0,1,'','',0) 07/01/2025 17:55:49.8838 1372 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:57:54.3625 1257 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 17:59:44.8073 774 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 17:59:43' where traUID = 5595579414267300 and traStatus='V' and traEnabled=1 07/01/2025 18:00:46.1853 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:00:51.4739 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 18:01:09.1847 539 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId 07/01/2025 18:01:25.0883 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:02:43.4907 562 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/01/2025 18:09:05.9789 1513 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-07 18:09:04','V',5093877550469250,2025,'2025-01-07 18:09:03','456624748500327005012999',2,2,2,'O','',0,'2025-01-07 18:09:04',1,'','0230004098567',165,0) 07/01/2025 18:09:07.3889 618 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 18:09:06' where traUID = 5495441750708860 and traStatus='V' and traEnabled=1 07/01/2025 18:09:16.0717 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:09:34.2809 617 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 18:09:33','V',5144963958156900,2025,'2025-01-07 18:09:31','456626013200327005012999',2,2,2,'O','',0,'2025-01-07 18:09:33',1,'','',0) 07/01/2025 18:09:39.4373 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 18:10:23.3827 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:11:23.8041 732 ms. EXEC: update payReceipt set recCreation = '2025-01-07 18:11:23',recModify = '2025-01-07 18:11:23',recUseId=0,recStatus='V' where recId = 340063 07/01/2025 18:12:24.8760 521 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 18:12:26.0978 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:12:26.5301 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 18:12:36.0085 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 18:14:21.7858 769 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 18:16:37.4917 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:16:52.8960 588 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 18:16:52','V',5100811753040000,2025,'2025-01-07 18:16:50','456626581000327001012999',1,2,1,'I','',1,0,1,'','',4) 07/01/2025 18:17:44.7657 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:18:36.7765 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:19:24.8766 709 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 18:20:30.4414 705 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 07/01/2025 18:20:31.4230 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 18:20:38.4547 637 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-07 18:20:37',4,6,'2025-01-07 18:20:37','456626312000327005012999','Payed (Credit Card ) Ticket ') 07/01/2025 18:23:50.2219 948 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-07 18:23:49',0,'V',4623361046361700,4934569478943710,2025,'2025-01-07 18:23:49',18,1,0,4,'2025-01-07 18:38:49','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/01/2025 18:23:52.7846 1344 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:28:35.8462 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:34:34.9562 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:40:47.2604 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 18:41:47.3739 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 18:43:14.9381 701 ms. EXEC: update paycash set casCreation = '2025-01-07 18:43:14',casModify = '2025-01-07 18:43:14',casUseId=0,casStatus='V' where casId = 203785 07/01/2025 18:44:03.9466 1132 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 18:51:10.7679 622 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/01/2025 18:51:11.4394 669 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/01/2025 18:51:11.4504 1258 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1 07/01/2025 18:51:11.6185 861 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/01/2025 18:55:15.0417 765 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 18:55:14','V',5129016001795430,2025,'2025-01-07 18:55:12','456626811200327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 18:55:16.6567 1513 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 18:55:15','V',5055154583014640,2025,'2025-01-07 18:55:13','456626429000327005012999',2,2,2,'O','',0,'2025-01-07 18:55:15',1,'','',0) 07/01/2025 18:55:16.7728 1370 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 18:55:31.7258 1045 ms. OPEN: select * from movtransit where traCode = '456626331500327005012999' and traStatus='V' ORDER BY traId DESC 07/01/2025 18:58:05.5907 940 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 18:58:04','V',4664538724342280,2025,'2025-01-07 18:58:03','456626237500327005012999',2,2,2,'O','',0,'2025-01-07 18:58:04',1,'','',0) 07/01/2025 18:58:06.6103 673 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-07 18:58:05' where payTraUID = 5082661960895750 and payStatus='V' and payEnabled=1 07/01/2025 18:59:13.2709 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 19:02:35.9224 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 19:06:37.0496 937 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 19:08:35.4077 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 19:09:35.6392 541 ms. EXEC: update payReceipt set recCreation = '2025-01-07 19:09:35',recModify = '2025-01-07 19:09:35',recUseId=0,recStatus='V' where recId = 340081 07/01/2025 19:10:47.3191 659 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 19:10:46' where traUID = 5100811753040000 and traStatus='V' and traEnabled=1 07/01/2025 19:10:56.5382 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 19:11:32.4713 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 19:12:00.4520 504 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 19:12:01.4306 826 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 19:12:05.1791 679 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 19:12:04','V',5729882211350660,2025,'2025-01-07 19:12:00','456626912000327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 19:12:06.0617 595 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 19:14:27.9662 897 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 19:14:28.6647 532 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/01/2025 19:14:30.3118 660 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/01/2025 19:15:26.7275 595 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 19:15:26','V',4665959597867130,2025,'2025-01-07 19:15:24','456626843800327005012999',2,2,2,'O','',0,'2025-01-07 19:15:26',1,'','',0) 07/01/2025 19:15:27.6871 595 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 19:15:27' where traUID = 4776352586911990 and traStatus='V' and traEnabled=1 07/01/2025 19:16:10.0604 516 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/01/2025 19:16:10.3496 823 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 19:17:26.4555 832 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 19:17:29.1603 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 19:53:38.6534 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 19:54:35.2823 16978 ms. OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal 07/01/2025 20:07:32.5755 938 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5491117184274860,5035860786387530,2025,'2025-01-07 20:07:31',' Date: 1/7/2025 8:07:31 PM Code: 456624014400327005012999 Entry Date: 1/7/2025 11:09:04 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 700.00 KES ______________________________ Paid: 700.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500701009 ',0) 07/01/2025 20:18:33.7809 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 20:19:38.3261 798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 20:22:20.1653 729 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 20:29:12.5039 524 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 20:29:13.6046 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 20:31:28.1105 533 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/01/2025 20:34:19.1769 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 20:46:04.5270 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 20:47:46.7183 1381 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 20:47:45','V',5363061880039820,2025,'2025-01-07 20:47:44','456627486400327005012999',1,2,16,'I','',1,0,1,'','',4) 07/01/2025 20:49:34.9084 721 ms. EXEC: update tabTerminalReceipt set trcProgressive = 1017, trcLastPrinted = '2500701017', trcLastDate = '2025-01-07 20:49:34' where trcStatus='V' and trcTerId = 18 07/01/2025 20:50:46.0718 720 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 20:53:06.7536 969 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 20:56:44.8845 1064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 21:00:12.5723 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 21:00:40.3138 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 21:00:49.0126 1276 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 21:06:42.4865 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 21:15:41.8003 508 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/01/2025 21:17:30.9937 585 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 21:19:20.6500 682 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 21:19:19' where traUID = 4695106693470660 and traStatus='V' and traEnabled=1 07/01/2025 21:19:46.3432 1212 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 21:19:45' where traUID = 5508776410951500 and traStatus='V' and traEnabled=1 07/01/2025 21:20:37.7726 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 21:25:56.2648 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 21:28:31.1603 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 21:36:12.8280 509 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-01-07 21:36:12','V',5446337120744270,2025,'2025-01-07 21:36:10','456626156500327005012999',2,2,2,'O','',0,'2025-01-07 21:36:12',1,'','0230003939927',164,0) 07/01/2025 21:37:54.1227 1039 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-07 21:37:53','V',5171910905330930,2025,'2025-01-07 21:37:51','456627388600327005012999',2,2,2,'O','',0,'2025-01-07 21:37:53',1,'','',0) 07/01/2025 21:41:16.9739 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 21:47:12.7590 655 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 21:47:12.7600 528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/01/2025 21:47:13.1703 1079 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 21:50:48.1332 552 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 21:50:47' where traUID = 5194770159256180 and traStatus='V' and traEnabled=1 07/01/2025 21:50:49.5291 1391 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 819103 07/01/2025 21:59:27.3374 1070 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 22:05:07.7974 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 22:10:45.3129 733 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 22:18:48.9502 720 ms. EXEC: update payReceipt set recCreation = '2025-01-07 22:18:48',recModify = '2025-01-07 22:18:48',recUseId=0,recStatus='V' where recId = 340126 07/01/2025 22:20:41.9427 892 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-07 22:20:40' where traUID = 5360422013332160 and traStatus='V' and traEnabled=1 07/01/2025 22:22:39.0960 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 22:27:34.1714 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 22:35:42.2143 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 22:38:12.9992 1751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 22:38:19.5886 2152 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/01/2025 22:38:20.1870 1219 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 07/01/2025 22:39:37.1696 1340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 22:55:48.1343 1999 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/01/2025 23:05:38.0722 561 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 07/01/2025 23:15:45.4756 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/01/2025 23:22:17.5800 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/01/2025 23:50:56.0045 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1