26/10/2024 03:04:33.8964 1377 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 03:06:36.4867 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 03:13:18.8010 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 03:14:12.2818 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 03:16:58.2099 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 03:19:46.9610 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 03:25:26.1518 785 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 26/10/2024 03:25:27.5647 950 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 03:42:14.3619 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 03:51:24.9919 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 03:57:03.0944 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 04:01:24.8460 987 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 04:08:33.5191 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 04:21:00.5400 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 04:45:34.3843 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 04:46:39.0756 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 04:48:35.3634 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 04:50:40.5782 1328 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 04:52:33.8411 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 04:57:37.7217 525 ms. EXEC: update payInventory set invCreation = '2024-10-26 04:57:37',invModify = '2024-10-26 04:57:37',invUseId=0,invStatus='V' where invId = 215326 26/10/2024 05:06:05.4545 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 05:12:43.4440 1223 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 05:13:32.4038 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 05:18:21.6547 1028 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 05:18:22.2721 618 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 05:18:21' where traUID = 4686874297579100 and traStatus='V' and traEnabled=1 26/10/2024 05:19:07.2432 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 05:20:07.5416 512 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/10/2024 05:20:25.6598 732 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 05:28:23.4799 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 05:54:42.2114 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 05:56:54.8490 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 06:13:33.4555 625 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 07:18:20.9281 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 07:19:20.7803 634 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 07:19:37.3945 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 07:22:07.3269 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 07:24:54.3189 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 07:37:34.9115 989 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 07:53:34.9366 944 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/10/2024 07:53:35.2078 1186 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 08:01:21.0421 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 08:07:00.8030 601 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 08:14:37.8594 693 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 08:17:02.3709 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 08:24:21.2781 1672 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-26 08:24:09',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 ('2024-10-26 08:24:09',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 ('2024-10-26 08:24:09',5,3,42101,0,100,-31,-3100,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-26 08:24:09',5,3,42101,0,100,31,3100,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-26 08:24:09',5,3,42101,0,200,-10,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-26 08:24:09',5,3,42101,0,200,10,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-26 08:24:09',5,3,42101,0,500,-3,-1500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-26 08:24:09',5,3,42101,0,500,3,1500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-26 08:24:09',5,3,42101,0,1000,-3,-3000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-26 08:24:09',5,3,42101,0,1000,3,3000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-10-26 08:24:09',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 26/10/2024 08:25:34.3399 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 08:27:32.4420 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 08:33:31.7387 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 08:34:12.2747 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 08:35:14.8183 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 08:35:38.1029 587 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 08:35:37','V',5721435730960730,2024,'2024-10-26 08:35:35','455892912000327005012999',2,2,2,'O','',0,'2024-10-26 08:35:37',1,'','',0) 26/10/2024 08:41:26.6972 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 09:05:41.2735 553 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5514197989290150,5629391201671810,2024,'2024-10-26 09:05:40','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/26/2024 8:41:44 AM Date : 10/26/2024 9:05:40 AM Code : 455893130400327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 26/10/2024 09:06:38.0946 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 09:07:12.5958 537 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-26 09:07:12' where payTraUID = 5514197989290150 and payStatus='V' and payEnabled=1 26/10/2024 09:07:22.8136 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 09:07:45.4048 1056 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 09:07:44' where traUID = 5140080410183820 and traStatus='V' and traEnabled=1 26/10/2024 09:09:24.2882 1271 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-26 09:09:23' where payTraUID = 4714393310016250 and payStatus='V' and payEnabled=1 26/10/2024 09:09:25.0618 772 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 09:09:23' where traUID = 4714393310016250 and traStatus='V' and traEnabled=1 26/10/2024 09:15:20.6236 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 09:16:38.3879 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 09:17:34.9679 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 09:21:22.0215 641 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 09:31:01.8437 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 09:44:59.0496 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 09:45:00.1234 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 09:48:33.0984 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 09:58:12.0636 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 09:58:48.1038 534 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5585238685269750,5427595036728010,2024,'2024-10-26 09:58:47',' Date: 10/26/2024 9:58:47 AM Code: 455893445600327005012999 Entry Date: 10/26/2024 9:34:16 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 # 2400747177 ',0) 26/10/2024 09:59:48.4094 781 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-26 09:59:47' where payTraUID = 5585238685269750 and payStatus='V' and payEnabled=1 26/10/2024 10:03:24.3325 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 10:04:11.2230 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:05:08.0371 1725 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 10:05:06' where traUID = 5262898720688460 and traStatus='V' and traEnabled=1 26/10/2024 10:08:46.2201 713 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 10:19:16.2750 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:19:51.3817 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 10:21:55.7876 590 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/10/2024 10:21:56.5832 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 10:24:34.4336 2349 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 26/10/2024 10:25:20.0624 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:27:28.0587 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 10:27:46.8124 1259 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:29:26.6287 1623 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/10/2024 10:32:36.2346 552 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 10:32:35',0,'V',5744123410671970,4817397439065240,2024,'2024-10-26 10:32:35',18,1,0,4,'2024-10-26 10:47:35','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/10/2024 10:34:51.0135 644 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/10/2024 10:34:51.0715 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:35:40.2737 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:36:00.6194 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 10:36:09.1232 638 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 10:36:34.8625 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 10:42:58.0870 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:43:41.3242 533 ms. OPEN: select devId from tabDevice where devStatus='V' and devCode = 20001 26/10/2024 10:44:58.6653 2981 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/10/2024 10:45:26.5131 1225 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:47:24.6668 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 10:47:24.9610 744 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/10/2024 10:49:08.2567 658 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:52:51.3452 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:56:39.3209 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 10:56:39.3389 696 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 26/10/2024 10:57:31.3750 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 10:58:50.9807 1130 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:11:49.3637 686 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 11:12:01.4429 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 11:12:37.0069 649 ms. EXEC: update payInventory set invCreation = '2024-10-26 11:12:36',invModify = '2024-10-26 11:12:36',invUseId=0,invStatus='V' where invId = 215392 26/10/2024 11:13:44.6665 1831 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-26 11:13:42',0,16,'2024-10-26 11:13:42','','Unauthorized Transit Entry 2') 26/10/2024 11:18:24.3311 1121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:26:23.0150 1103 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 11:26:46.7560 955 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/10/2024 11:27:10.4820 670 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/10/2024 11:29:58.4043 862 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 11:30:07.4263 934 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/10/2024 11:30:14.2289 2484 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15075, trcLastPrinted = '2400415075', trcLastDate = '2024-10-26 11:30:11' where trcStatus='V' and trcTerId = 4 26/10/2024 11:30:28.6747 513 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/10/2024 11:33:19.1777 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:33:25.7141 1505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:33:43.1418 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:33:51.3454 1512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:34:56.1831 567 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 11:34:56.8085 618 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 11:34:57.7572 760 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 11:34:56' where traUID = 4924276403792060 and traStatus='V' and traEnabled=1 26/10/2024 11:35:37.6311 792 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 11:35:36','V',5682703519006820,2024,'2024-10-26 11:35:35','455894173500327001012999',1,2,1,'I','',1,0,1,'','',4) 26/10/2024 11:35:57.2563 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:37:37.2777 1186 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:38:19.5012 1840 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 11:38:14',0,'V',5762635103292130,5038264009839660,2024,'2024-10-26 11:38:14',3,1,0,4,'2024-10-26 11:53:14','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 26/10/2024 11:38:21.1183 888 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='455893623800327005012999' 26/10/2024 11:39:12.8322 967 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/10/2024 11:39:31.2276 3336 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 11:39:27','V',4725614621501330,2024,'2024-10-26 11:39:27','455894196700327005012999',1,2,16,'I','',1,0,1,'','',4) 26/10/2024 11:39:59.0594 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:40:17.3337 726 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 11:41:20.1501 1007 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/10/2024 11:43:31.6428 900 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 11:47:13.1011 540 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/10/2024 11:47:22.7186 1087 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:48:15.9405 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:50:08.0371 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:50:31.2818 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:50:43.7042 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:53:08.6159 638 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-26 11:53:07',0,16,'2024-10-26 11:53:07','','Unauthorized Transit Entry 2') 26/10/2024 11:57:48.1765 980 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:58:15.8491 898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 11:58:38.8126 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:00:27.0887 2342 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/10/2024 12:01:58.8566 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 12:02:11.0958 779 ms. EXEC: update payInventory set invCreation = '2024-10-26 12:02:10',invModify = '2024-10-26 12:02:10',invUseId=0,invStatus='V' where invId = 215412 26/10/2024 12:02:33.8572 1153 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 12:03:10.4678 2055 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 12:03:25.2028 1649 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/10/2024 12:07:19.6989 1110 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:07:21.6102 1190 ms. EXEC: update payInventory set invCreation = '2024-10-26 12:07:20',invModify = '2024-10-26 12:07:20',invUseId=0,invStatus='V' where invId = 215413 26/10/2024 12:09:03.8642 731 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/10/2024 12:09:04.4936 542 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 12:09:01',0,'V',5317038029433750,5156486078539810,2024,'2024-10-26 12:09:01',3,1,0,4,'2024-10-26 12:24:01','C','KES',100,500,400,'',' ',' ',1,100,0,0,'',0,0) 26/10/2024 12:11:04.3995 860 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 12:11:03' where traUID = 5245904688275740 and traStatus='V' and traEnabled=1 26/10/2024 12:11:42.5933 1476 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 12:11:41',0,'V',5379028619602670,4655487388244210,2024,'2024-10-26 12:11:41',18,1,0,4,'2024-10-26 12:26:41','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 26/10/2024 12:12:52.0941 975 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:14:51.4426 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:15:24.9863 991 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-26 12:15:23',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 26/10/2024 12:18:19.6351 797 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 12:18:18' where traUID = 5075924581346890 and traStatus='V' and traEnabled=1 26/10/2024 12:21:47.8775 604 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 12:21:55.4957 753 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 12:22:21.2380 585 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 12:22:14',0,'V',5224129441269100,5160915765217560,2024,'2024-10-26 12:22:14',3,1,0,4,'2024-10-26 12:37:14','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 26/10/2024 12:22:59.1036 882 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 12:22:58','V',5205698514914930,2024,'2024-10-26 12:22:57','455894457700327005012999',1,2,16,'I','',1,0,1,'','',4) 26/10/2024 12:26:21.3440 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:27:00.9357 1199 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/10/2024 12:27:43.7846 1561 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/10/2024 12:28:36.0748 2833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:31:03.6314 534 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/10/2024 12:31:12.6164 2322 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-26 12:31:10',0,16,'2024-10-26 12:31:10','','Unauthorized Transit Entry 2') 26/10/2024 12:31:12.6174 1155 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 12:31:11','V',5193434135288340,2024,'2024-10-26 12:31:10','455894416200327005012999',2,2,2,'O','',0,'2024-10-26 12:31:11',1,'','',0) 26/10/2024 12:31:46.0770 1039 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 12:31:58.4263 626 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 12:31:57' where traUID = 4794040237096990 and traStatus='V' and traEnabled=1 26/10/2024 12:32:04.7526 760 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 26/10/2024 12:32:17.4592 1067 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 12:32:16','V',5627159678908130,2024,'2024-10-26 12:32:15','455894335100327005012999',2,2,2,'O','',0,'2024-10-26 12:32:16',1,'','',0) 26/10/2024 12:32:19.4955 1597 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 12:32:20.3521 508 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 12:32:19' where traUID = 5193967279062680 and traStatus='V' and traEnabled=1 26/10/2024 12:32:23.5683 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 12:33:11.1103 570 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-10-26 12:33:10','0750009518612',0,0,5129204247822290,99,'0000-00-00 00:00:00','0000-00-00 00:00:00') 26/10/2024 12:33:39.5745 704 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/10/2024 12:33:49.9926 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:34:01.3832 879 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:34:16.5495 1531 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 12:32:27',12,'V',5197703264144610,5068428451209250,2024,'2024-10-26 12:32:27',17,1,0,4,'2024-10-26 12:47:27','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) (WAIT TIME 13 ms.) 26/10/2024 12:35:43.8634 2392 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/10/2024 12:35:49.2840 1472 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/10/2024 12:36:34.2303 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:36:57.2188 1165 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 12:40:29.1508 948 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 12:42:15.5145 2376 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:44:23.3157 789 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 12:44:24.4005 520 ms. EXEC: update payReceipt set recCreation = '2024-10-26 12:44:23',recModify = '2024-10-26 12:44:23',recUseId=0,recStatus='V' where recId = 316326 26/10/2024 12:47:23.4712 635 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 12:47:44.8416 1094 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/10/2024 12:48:49.1540 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 12:48:49.3081 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:50:26.1254 789 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 12:53:06.1904 1162 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 12:53:03',0,'V',5121607003279150,4848887952390550,2024,'2024-10-26 12:53:03',3,1,0,4,'2024-10-26 13:08:03','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 26/10/2024 12:53:21.1665 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 12:54:27.7224 545 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4981979520694460,5534335307027030,2024,'2024-10-26 12:54:27','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/26/2024 12:46:07 PM Date : 10/26/2024 12:54:25 PM Code : 455894596700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 26/10/2024 12:55:30.8790 569 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 12:55:35.9844 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:01:22.9414 956 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-26 13:01:21',0,0,'V',5011780333456840,4833791427804820,2024,'2024-10-26 13:01:21',3,'KES',1,100,100,'N',''); 26/10/2024 13:01:35.0766 1314 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-26 13:01:33',0,16,'2024-10-26 13:01:33','','Unauthorized Transit Entry 2') 26/10/2024 13:01:42.5286 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:04:14.4971 3236 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/10/2024 13:06:12.4167 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:06:12.6328 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:06:26.4782 2586 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 13:06:23','V',5638137005133270,2024,'2024-10-26 13:06:22','455894542900327005012999',2,2,2,'O','',0,'2024-10-26 13:06:23',1,'','',0) 26/10/2024 13:06:26.6012 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 120 ms.) 26/10/2024 13:06:42.4770 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:08:30.2366 2254 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/10/2024 13:08:30.3207 1178 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:08:33.6309 930 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 26/10/2024 13:08:55.8749 1972 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 26/10/2024 13:08:56.0190 927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:09:43.0898 742 ms. OPEN: select * from tabClass where claPosition = 2 and claStatus='V' 26/10/2024 13:09:51.1232 1037 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-10-26 13:09:50',0,'V',5031392893162760,4713646955246800,2024,'2024-10-26 13:09:50',2,1,0,-1,'2024-10-26 14:09:50','S','KES',0,0,0,'','','',3,0,0) 26/10/2024 13:10:23.0547 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:10:23.1968 749 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1 26/10/2024 13:10:40.1062 1276 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/10/2024 13:10:40.4895 1233 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 146 ms.) 26/10/2024 13:10:43.5846 2842 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 13:10:45.2337 1504 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 13:10:49.9168 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:12:13.4422 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:13:32.6016 3586 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:15:02.7514 737 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/10/2024 13:15:03.5339 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:15:26.1432 692 ms. OPEN: show columns from tabTerminalExtraMem where Field = 'extCode' 26/10/2024 13:15:35.0161 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:16:07.0427 1827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:16:16.1469 964 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-26 13:16:15' where payTraUID = 5470435041670730 and payStatus='V' and payEnabled=1 26/10/2024 13:16:25.6363 1038 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/10/2024 13:16:32.3628 824 ms. EXEC: update payReceipt set recCreation = '2024-10-26 13:16:31',recModify = '2024-10-26 13:16:31',recUseId=0,recStatus='V' where recId = 316344 26/10/2024 13:16:35.5600 3405 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 13:16:53.3480 916 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-26 13:16:52' where payTraUID = 4916619148047440 and payStatus='V' and payEnabled=1 26/10/2024 13:16:57.1355 3374 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 762383 26/10/2024 13:17:27.8512 1064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:18:17.4487 973 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:19:02.6512 1607 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/10/2024 13:19:38.9236 1385 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:20:24.8406 1817 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 13:20:47.2978 3720 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 13:20:42' where traUID = 5281638395381660 and traStatus='V' and traEnabled=1 (WAIT TIME 138 ms.) 26/10/2024 13:21:10.0861 4152 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:23:32.7624 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:23:45.4369 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:25:41.8875 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:26:13.9891 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:26:51.0971 2417 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5159743847895250,5310756854474990,2024,'2024-10-26 13:26:48','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/26/2024 11:59:41 AM Date : 10/26/2024 1:26:46 PM Code : 455894318100327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 26/10/2024 13:26:51.7005 601 ms. EXEC: update payReceipt set recCreation = '2024-10-26 13:26:51',recModify = '2024-10-26 13:26:51',recUseId=0,recStatus='V' where recId = 316348 26/10/2024 13:31:05.9343 1325 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 13:31:12.3586 594 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/10/2024 13:31:56.0991 1443 ms. EXEC: update abbCards set carLastDate = '2024-10-26 13:31:54',carLastDirection='I' where carStatus='V' and carId = 12 26/10/2024 13:32:10.5719 1327 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:32:31.8052 699 ms. OPEN: select terDefaultClass from tabTerminal where terStatus='V' and terId = 16 26/10/2024 13:33:01.6824 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:35:20.9583 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:35:24.9790 1920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:35:52.5276 1005 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 13:35:49',0,'V',5158932617807230,5691283976074520,2024,'2024-10-26 13:35:49',3,1,0,4,'2024-10-26 13:50:49','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 26/10/2024 13:35:53.6103 630 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-26 13:35:52',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 26/10/2024 13:36:25.9592 585 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/10/2024 13:38:31.9451 2020 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:38:52.6971 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:40:33.2169 530 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 13:41:10.2779 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:41:16.6552 1259 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 13:42:46.9071 757 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:44:34.5057 882 ms. EXEC: update tabTerminalExtraMem SET extCode = @extCode, extUseId = 0 WHERE extStatus='V' and extTerId = @extTerId 26/10/2024 13:44:35.3462 579 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 13:45:00.8444 1210 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:46:13.9077 1138 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-10-26 13:46:12','V',5277138870220730,2024,'2024-10-26 13:46:11','455894625200327001029999',2,2,2,'O','',0,'2024-10-26 13:46:12',1,'','0230003939927',164,0) 26/10/2024 13:46:49.3786 1822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:47:30.5144 4411 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:48:19.3913 1104 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/10/2024 13:48:55.2715 1488 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 13:48:58.7719 2685 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/10/2024 13:49:02.7336 2229 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:49:02.7766 2541 ms. EXEC: update paycash set casCreation = '2024-10-26 13:49:00',casModify = '2024-10-26 13:49:00',casUseId=0,casStatus='V' where casId = 191630 26/10/2024 13:49:14.9798 763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:49:55.6673 3123 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:51:01.1465 1057 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 13:51:00','V',4723557642096710,2024,'2024-10-26 13:50:58','455894784600327005012999',2,2,2,'O','',0,'2024-10-26 13:51:00',1,'','',0) 26/10/2024 13:51:10.8410 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:51:19.8270 906 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/10/2024 13:51:22.5159 1620 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-26 13:51:20',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-26 13:51:20',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-26 13:51:20',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'; 26/10/2024 13:53:26.0212 1475 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 13:53:24',0,'V',5524582336698140,5159901158369210,2024,'2024-10-26 13:53:24',18,1,0,4,'2024-10-26 14:08:24','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 26/10/2024 13:53:31.5879 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:53:51.0540 733 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 13:53:50','V',5751757947858510,2024,'2024-10-26 13:53:50','455895003000327005012999',1,2,16,'I','',1,0,1,'','',4) 26/10/2024 13:53:51.0580 761 ms. EXEC: update tabTerminalReceipt set trcProgressive = 47215, trcLastPrinted = '2400747215', trcLastDate = '2024-10-26 13:53:50' where trcStatus='V' and trcTerId = 18 26/10/2024 13:54:08.4128 1626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:54:08.4138 1280 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/10/2024 13:54:58.8248 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:55:23.8006 1798 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 13:55:21','V',5006212279637450,2024,'2024-10-26 13:55:21','455895012100327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 724 ms.) 26/10/2024 13:55:37.1556 1009 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 13:57:15.3438 1304 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 13:59:37.6848 846 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/10/2024 13:59:37.7239 885 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 13:59:40.9691 1642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:01:05.6552 633 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 14:01:05','V',5366199812500680,2024,'2024-10-26 14:01:04','455895046400327005012999',1,2,16,'I','',1,0,1,'','',4) 26/10/2024 14:02:04.1026 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:04:00.5151 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:05:30.8520 1704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:05:58.5127 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:08:03.1688 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:08:19.5018 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:08:28.0776 666 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:08:36.4612 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:15:52.6264 1451 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:16:20.6693 799 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:16:27.9492 1222 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:17:29.1315 1254 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:18:59.9858 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:23:27.8224 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:24:00.4174 1399 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:24:26.7242 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:25:58.3680 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:26:41.8293 1052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:28:16.9745 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:28:18.1853 831 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 14:28:17','V',5730323529760570,2024,'2024-10-26 14:28:17','455895209700327005012999',1,2,16,'I','',1,0,1,'','',4) 26/10/2024 14:30:10.5991 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:30:46.7385 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:31:11.8464 556 ms. EXEC: update tabTerminalReceipt set trcProgressive = 47223, trcLastPrinted = '2400747223', trcLastDate = '2024-10-26 14:31:11' where trcStatus='V' and trcTerId = 18 26/10/2024 14:31:33.0267 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:31:50.4214 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:31:55.7840 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:32:35.4028 1986 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 26/10/2024 14:32:36.7457 620 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:33:51.7403 2225 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/10/2024 14:35:32.8625 981 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/10/2024 14:35:32.8655 955 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 26/10/2024 14:35:33.7521 792 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:38:19.6840 1121 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/10/2024 14:39:12.4816 2563 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 14:39:09' where traUID = 4621431061994940 and traStatus='V' and traEnabled=1 (WAIT TIME 370 ms.) 26/10/2024 14:40:56.0895 726 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:43:26.1617 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:43:44.4330 927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:43:46.0221 730 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 14:43:45','V',4758929516067900,2024,'2024-10-26 14:43:45','455895302500327005012999',1,2,16,'I','',1,0,1,'','',4) 26/10/2024 14:43:47.7923 1767 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 14:43:52.1392 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:44:17.4112 824 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-10-26 14:44:16','V',5205153139912910,2024,'2024-10-26 14:44:15','455895305500327005012999',1,2,16,'I','',1,0,1,'','0810007145851',106,0) 26/10/2024 14:44:22.7188 968 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:44:35.9918 681 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/10/2024 14:45:59.9354 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:46:12.5139 1524 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/10/2024 14:46:16.8728 872 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 14:44:01',6,'V',5034981917165440,5107082023464580,2024,'2024-10-26 14:44:01',4,1,0,4,'2024-10-26 14:59:01','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/10/2024 14:46:18.5379 587 ms. EXEC: update payReceipt set recCreation = '2024-10-26 14:46:17',recModify = '2024-10-26 14:46:17',recUseId=0,recStatus='V' where recId = 316385 26/10/2024 14:46:19.9489 1409 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '455895181800327005012999' 26/10/2024 14:46:38.0901 1621 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/10/2024 14:48:02.1578 1998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:48:22.2684 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:49:29.4517 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:50:37.7128 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 14:50:57.9364 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:54:51.2658 634 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 14:55:48.2782 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:55:48.9427 615 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/10/2024 14:57:22.1881 682 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-10-26 14:57:21','0230003944064',0,0,5530962654888270,14,'0000-00-00 00:00:00','0000-00-00 00:00:00') 26/10/2024 14:57:47.0876 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 14:59:05.2436 781 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 14:59:01',0,'V',5275029459383620,5687038825679580,2024,'2024-10-26 14:59:01',3,1,0,4,'2024-10-26 15:14:01','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 26/10/2024 14:59:30.2802 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:01:04.5008 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:01:21.3510 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:01:38.7286 2651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:02:03.0488 739 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:02:55.7588 509 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-26 15:02:55',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'; 26/10/2024 15:03:04.7938 1326 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 15:03:03','V',5068507630072590,2024,'2024-10-26 15:03:02','455895204700327005012999',2,2,2,'O','',0,'2024-10-26 15:03:03',1,'','',0) 26/10/2024 15:04:55.3793 765 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:06:48.3504 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:13:37.2503 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:14:06.0664 578 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-10-26 15:14:05' where subId = 206 26/10/2024 15:14:58.3152 826 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/10/2024 15:20:08.3504 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:21:07.9140 2560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:22:01.5727 1023 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:22:02.7605 716 ms. EXEC: update abbCards set carLastDate = '2024-10-26 15:22:02',carLastDirection='O' where carStatus='V' and carId = 18 26/10/2024 15:22:11.0029 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:24:07.7196 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:24:43.2352 742 ms. EXEC: update abbCards set carLastDate = '2024-10-26 15:24:42',carLastDirection='I' where carStatus='V' and carId = 190 26/10/2024 15:25:01.0901 1659 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 15:24:59','V',5519965831440710,2024,'2024-10-26 15:24:58','455895003000327005012999',2,2,2,'O','',0,'2024-10-26 15:24:59',1,'','',0) 26/10/2024 15:25:02.2498 813 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 15:25:01' where traUID = 5751757947858510 and traStatus='V' and traEnabled=1 26/10/2024 15:25:42.4836 819 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-10-26 15:25:41','V',4629641028498420,2024,'2024-10-26 15:25:40','455895554000327005012999',1,2,16,'I','',1,0,1,'','0750003728779',122,4) 26/10/2024 15:25:58.3412 522 ms. EXEC: update paycash set casCreation = '2024-10-26 15:25:57',casModify = '2024-10-26 15:25:57',casUseId=0,casStatus='V' where casId = 191651 26/10/2024 15:25:58.9776 636 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-26 15:25:57',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'; 26/10/2024 15:27:14.0315 1308 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 15:27:12','V',4637570767038020,2024,'2024-10-26 15:27:10','455895300300327005012999',2,2,2,'O','',0,'2024-10-26 15:27:12',1,'','',0) 26/10/2024 15:27:24.9928 791 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:28:06.9307 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:28:13.6682 891 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:28:14.1115 1322 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/10/2024 15:28:14.1205 908 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/10/2024 15:28:14.1915 808 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/10/2024 15:28:58.4249 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:29:04.8872 1031 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-26 15:29:03',4,6,'2024-10-26 15:29:03','455894505900327005012999','Payed (Credit Card ) Ticket ') 26/10/2024 15:29:05.6207 673 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 363939 else acvFstPayId end),acvLstPayId = 363939 where acvSftId = 804 and acvCodeId = 3 26/10/2024 15:29:07.5310 1680 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15084, trcLastPrinted = '2400415084', trcLastDate = '2024-10-26 15:29:05' where trcStatus='V' and trcTerId = 4 (WAIT TIME 153 ms.) 26/10/2024 15:29:20.9810 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:30:16.0216 1173 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 15:32:15.7051 2294 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/10/2024 15:32:52.9298 654 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:33:56.1779 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:35:01.5303 3084 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 15:34:57',0,'V',5568947714804790,4990033546120990,2024,'2024-10-26 15:34:57',3,1,0,4,'2024-10-26 15:49:57','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) (WAIT TIME 44 ms.) 26/10/2024 15:35:03.9539 2185 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-26 15:35:01',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'; 26/10/2024 15:37:09.8726 1742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:37:22.6080 2795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:38:00.0499 2731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:38:09.9105 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:38:40.3267 819 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-10-26 15:38:39','0560008304916',0,0,4946400562444780,190,'0000-00-00 00:00:00','0000-00-00 00:00:00') 26/10/2024 15:38:41.6516 1318 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 190 order by traDateTime desc,traId desc 26/10/2024 15:39:02.5354 1283 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:41:38.1108 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:42:38.6281 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:44:01.3770 3530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:44:31.6732 1470 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:45:33.6414 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:47:27.0107 646 ms. EXEC: update payInventory set invCreation = '2024-10-26 15:47:26',invModify = '2024-10-26 15:47:26',invUseId=0,invStatus='V' where invId = 215472 26/10/2024 15:47:59.3052 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:48:12.6250 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:51:53.3727 2252 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:51:59.7279 1801 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 15:51:57' where traUID = 4629641028498420 and traStatus='V' and traEnabled=1 26/10/2024 15:52:49.3989 526 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 15:52:48','V',5461478118969450,2024,'2024-10-26 15:52:48','455895588100327005012999',2,2,2,'O','',0,'2024-10-26 15:52:48',1,'','',0) 26/10/2024 15:53:00.1040 1449 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:53:45.5892 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:54:06.7783 1070 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/10/2024 15:57:50.7111 1509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 15:59:26.7779 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 15:59:39.1701 1886 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4989644929327720,5066929207225870,2024,'2024-10-26 15:59:37','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/26/2024 3:14:51 PM Date : 10/26/2024 3:59:35 PM Code : 455895489100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 26/10/2024 16:00:12.3222 1114 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:01:36.7593 2157 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:01:37.1595 2364 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 16:01:34','V',4884305332185540,2024,'2024-10-26 16:01:33','455895269600327005012999',2,2,2,'O','',0,'2024-10-26 16:01:34',1,'','',0) 26/10/2024 16:02:31.4846 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 16:03:30.6329 579 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 16:03:30',0,'V',4943977025180740,5685644236743120,2024,'2024-10-26 16:03:30',18,1,0,4,'2024-10-26 16:18:30','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/10/2024 16:03:52.7937 809 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:03:54.0735 1023 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:04:11.8313 1636 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/10/2024 16:06:04.3061 1136 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-26 16:06:03' where payTraUID = 5240390589212270 and payStatus='V' and payEnabled=1 26/10/2024 16:06:44.0325 748 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/10/2024 16:06:46.5401 1405 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/10/2024 16:11:15.1126 1700 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/10/2024 16:11:26.1480 893 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 2 ms.) 26/10/2024 16:11:33.7290 1534 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/10/2024 16:12:48.6718 1224 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:18:10.0054 2577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:18:47.8756 580 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/10/2024 16:18:51.7111 1944 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 26/10/2024 16:19:34.5997 599 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/10/2024 16:20:20.3321 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:20:58.1762 1316 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:21:41.5731 1675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:22:03.0544 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:22:12.0613 1235 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 26/10/2024 16:22:22.6914 1727 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/10/2024 16:22:31.0129 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:23:06.7707 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:24:27.3593 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 16:24:41.3406 505 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 16:25:33.2471 559 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 16:25:39.8185 611 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-10-26 16:25:39','V',4656401939996610,2024,'2024-10-26 16:25:38','455895913800327005012999',1,2,16,'I','',1,0,1,'','0750003253270',66,0) 26/10/2024 16:29:44.5913 855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:30:02.2801 1370 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:36:58.8611 799 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 310 ms.) 26/10/2024 16:36:58.9672 836 ms. OPEN: show columns from tabArea where Field = 'areBookingReserved' (WAIT TIME 403 ms.) 26/10/2024 16:37:05.3595 554 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5754910540981070,5752135585216830,2024,'2024-10-26 16:37:04','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/26/2024 1:36:46 PM Date : 10/26/2024 4:37:00 PM Code : 455894900600327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 100.00 KES',0) 26/10/2024 16:37:27.3561 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:37:28.0045 1049 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 16:38:34.0685 1385 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:39:46.0063 1854 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-26 16:39:43' where traUID = 4636338854694610 and traStatus='V' and traEnabled=1 26/10/2024 16:42:27.4427 539 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 16:42:26','V',5126704691713350,2024,'2024-10-26 16:42:25','455895286100327005012999',2,2,2,'O','',0,'2024-10-26 16:42:26',1,'','',0) 26/10/2024 16:43:05.3680 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:43:05.5241 608 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/10/2024 16:43:31.4923 3616 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/10/2024 16:43:31.9436 2306 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:47:13.0137 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:48:35.4396 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:50:52.3717 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:51:36.1118 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:52:03.0287 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:54:18.5839 536 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/10/2024 16:54:44.9024 501 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/10/2024 16:54:44.9034 502 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/10/2024 16:54:44.9044 502 ms. OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage 26/10/2024 16:54:45.1956 792 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 16:54:47.7763 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:55:02.3890 794 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 16:55:01','V',5635966080375760,2024,'2024-10-26 16:55:00','455895911900327005012999',2,2,2,'O','',0,'2024-10-26 16:55:01',1,'','',0) 26/10/2024 16:56:34.1541 651 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 16:56:33','V',5624024399163200,2024,'2024-10-26 16:56:33','455896099300327001012999',1,2,1,'I','',1,0,1,'','',4) 26/10/2024 16:57:38.5240 1511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:58:33.9759 2711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:59:03.2264 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:59:26.9982 1273 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 16:59:32.1926 2924 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/10/2024 16:59:32.3437 1677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:00:16.5802 1282 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 17:00:56.7089 2096 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:02:25.5410 1390 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/10/2024 17:03:01.6221 1532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:03:59.1544 880 ms. EXEC: update payReceipt set recCreation = '2024-10-26 17:03:58',recModify = '2024-10-26 17:03:58',recUseId=0,recStatus='V' where recId = 316433 26/10/2024 17:03:59.8729 584 ms. EXEC: update payInventory set invCreation = '2024-10-26 17:03:59',invModify = '2024-10-26 17:03:59',invUseId=0,invStatus='V' where invId = 215484 26/10/2024 17:05:01.9082 1193 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:05:27.9255 2023 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:06:34.5859 518 ms. EXEC: update tabTerminalReceipt set trcProgressive = 47254, trcLastPrinted = '2400747254', trcLastDate = '2024-10-26 17:06:34' where trcStatus='V' and trcTerId = 18 26/10/2024 17:06:54.8363 727 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 17:06:54','V',5727972352060960,2024,'2024-10-26 17:06:52','455894946600327005012999',2,2,2,'O','',0,'2024-10-26 17:06:54',1,'','',0) 26/10/2024 17:07:05.8967 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 17:07:21.0748 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:08:29.1181 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:14:06.3957 692 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-10-26 17:14:05' where subId = 26 26/10/2024 17:18:32.2117 671 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/10/2024 17:18:32.7311 519 ms. OPEN: select * from tabDevice where devId = 1 and devStatus = 'V' 26/10/2024 17:19:40.4452 702 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 17:22:42.6225 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:24:32.6138 3823 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 17:24:28','V',5417281018292440,2024,'2024-10-26 17:24:28','455896266800327005012999',1,2,16,'I','',1,0,1,'','',4) 26/10/2024 17:24:50.7539 2603 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/10/2024 17:29:37.9471 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 17:30:58.5328 2096 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 17:31:14.1723 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:31:32.6085 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 17:31:39.0108 540 ms. EXEC: update payReceipt set recCreation = '2024-10-26 17:31:38',recModify = '2024-10-26 17:31:38',recUseId=0,recStatus='V' where recId = 316442 26/10/2024 17:32:00.7603 1156 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:32:15.3360 3297 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:36:37.4206 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:37:30.6881 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:37:32.2271 1423 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:40:13.7337 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:40:36.3258 2185 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:40:41.2430 1168 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='455895957800327005012999' 26/10/2024 17:42:04.4805 1818 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 17:43:33.4898 595 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:47:37.6175 756 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 17:48:09.0814 699 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 17:48:08','V',5282185682199440,2024,'2024-10-26 17:48:07','455896266800327005012999',2,2,2,'O','',0,'2024-10-26 17:48:08',1,'','',0) 26/10/2024 17:48:09.8590 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:48:12.0494 2935 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 17:48:12.9540 896 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 17:48:13.9157 939 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-26 17:48:12' where payTraUID = 5417281018292440 and payStatus='V' and payEnabled=1 26/10/2024 17:48:15.4877 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 17:50:35.9333 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:51:35.1888 1341 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:51:37.8706 1448 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 17:51:49.3892 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:52:41.8762 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:53:34.2661 1668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:53:59.5940 1426 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:54:40.8515 903 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/10/2024 17:54:52.4522 1053 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 17:55:43.5073 1361 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5439775394114790,4690429452430480,2024,'2024-10-26 17:55:42','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 10/26/2024 5:09:50 PM Date : 10/26/2024 5:55:39 PM Code : 455896179000327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 26/10/2024 17:56:05.2518 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 17:59:37.0639 1269 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:00:01.5593 1190 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:02:21.1723 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:04:10.8034 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:04:26.0936 3168 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:12:08.7540 1437 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-26 18:12:07',0,'V',4852978051679200,4717379584854470,2024,'2024-10-26 18:12:07',18,1,0,4,'2024-10-26 18:27:07','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/10/2024 18:12:52.6242 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:13:19.9564 508 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/10/2024 18:13:24.2833 827 ms. EXEC: update tabTerminalReceipt set trcProgressive = 47265, trcLastPrinted = '2400747265', trcLastDate = '2024-10-26 18:13:23' where trcStatus='V' and trcTerId = 18 26/10/2024 18:13:25.2169 746 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4792627608736640,5550195514606870,2024,'2024-10-26 18:13:24',' Date: 10/26/2024 6:13:23 PM Code: 455896206300327005012999 Entry Date: 10/26/2024 5:14:23 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 # 2400747265 ',0) 26/10/2024 18:13:51.9838 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:14:01.9624 1033 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-26 18:14:00','V',5354619372271870,2024,'2024-10-26 18:14:00','455896335700327005012999',2,2,2,'O','',0,'2024-10-26 18:14:00',1,'','',0) 26/10/2024 18:14:13.4961 2614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 18:15:19.1729 652 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/10/2024 18:16:47.3487 702 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-10-26 18:16:46',0,'V',5215802152655960,5208638735358130,2024,'2024-10-26 18:16:46',2,1,0,-1,'2024-10-26 19:16:46','S','KES',0,0,0,'','','',3,0,0) 26/10/2024 18:16:48.3203 952 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-10-26 18:16:47','V',5728997636636560,2024,'2024-10-26 18:16:45','455893166900327005012999',2,2,2,'O','',0,'2024-10-26 18:16:47',1,'','0810007103066',82,0) 26/10/2024 18:17:13.0198 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:20:41.9481 635 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 26/10/2024 18:25:21.8215 981 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/10/2024 18:25:21.8755 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:25:38.6006 899 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/10/2024 18:27:12.3410 852 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/10/2024 18:27:15.4651 638 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/10/2024 18:28:04.8850 583 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:29:07.3125 582 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/10/2024 18:29:11.0710 1056 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 1140 ms.) 26/10/2024 18:30:58.1913 1189 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/10/2024 18:32:54.2866 1896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 18:33:34.0941 1252 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/10/2024 21:26:54.9161 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/10/2024 21:31:05.9861 4202 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/10/2024 22:25:37.0716 1803 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 26/10/2024 23:30:54.4528 575 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V'