04/11/2024 00:29:25.1264 872 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 04/11/2024 06:32:25.0982 989 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 06:32:47.2800 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 06:40:36.4352 656 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-04 06:40:35' where traUID = 4940329553621160 and traStatus='V' and traEnabled=1 04/11/2024 06:42:13.9353 632 ms. EXEC: update payInventory set invCreation = '2024-11-04 06:42:13',invModify = '2024-11-04 06:42:13',invUseId=0,invStatus='V' where invId = 217160 04/11/2024 06:54:05.4332 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 06:54:53.0130 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 06:56:57.7072 1019 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 07:10:15.2717 581 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/11/2024 07:10:15.3657 693 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-04 07:10:14' where payTraUID = 5578566804651150 and payStatus='V' and payEnabled=1 04/11/2024 07:15:55.7179 1277 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 07:16:57.2200 792 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 04/11/2024 07:28:39.1245 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 07:35:34.4768 648 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/11/2024 07:46:09.0564 680 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5183561047055760,5243058141933870,2024,'2024-11-04 07:46:08','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/4/2024 7:27:11 AM Date : 11/4/2024 7:46:08 AM Code : 455982683100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 04/11/2024 07:48:42.6220 1169 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 04/11/2024 07:48:56.9175 1855 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 07:50:05.6664 954 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 07:56:23.6617 519 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-04 07:56:23',0,0,'V',5452415167875250,5725263865957740,2024,'2024-11-04 07:56:23',3,'KES',1,50,50,'N',''); 04/11/2024 07:57:36.2452 554 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/11/2024 07:58:50.7399 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 08:00:16.0028 543 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 04/11/2024 08:02:41.0757 1012 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:29',5,3,42101,0,50,-27,-1350,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:29',5,3,42101,0,50,27,1350,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:29',5,3,42101,0,100,-18,-1800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:29',5,3,42101,0,100,18,1800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:29',5,3,42101,0,200,-5,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:29',5,3,42101,0,200,5,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:29',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:29',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:29',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 04/11/2024 08:02:42.0523 539 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:37',5,3,42101,0,50,-27,-1350,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:37',5,3,42101,0,100,-21,-2100,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:37',5,3,42101,0,200,-5,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:37',5,3,42101,0,500,-3,-1500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-04 08:02:37',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 04/11/2024 08:06:17.3661 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 08:27:24.3138 636 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 13 ms.) 04/11/2024 08:27:25.3085 505 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-04 08:27:24' where payTraUID = 5389944267726560 and payStatus='V' and payEnabled=1 04/11/2024 08:31:27.6643 683 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 08:38:15.0792 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 08:45:02.1270 720 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/11/2024 08:47:54.7962 611 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-04 08:47:54',4,6,'2024-11-04 08:47:54','455983080500327005031999','Payed (Credit Card ) Ticket ') 04/11/2024 08:49:52.1626 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 08:50:04.6539 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 08:50:43.6089 725 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 08:54:47.4437 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 08:55:27.5084 510 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-04 08:55:26','V',5150720689856950,2024,'2024-11-04 08:55:14','455983211400327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 123 ms.) 04/11/2024 08:55:28.1239 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 230 ms.) 04/11/2024 08:56:52.9915 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 08:57:06.0813 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 09:01:20.9334 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 09:04:01.9819 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 09:08:54.2830 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 09:10:34.0216 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 09:10:42.0349 592 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-04 09:10:41','V',5745703248327450,2024,'2024-11-04 09:10:40','455983304000327005012999',1,2,16,'I','',1,0,1,'','0560008304916',190,0) 04/11/2024 09:11:42.7365 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 09:14:57.5845 1568 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 04/11/2024 09:14:58.9174 1167 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 09:17:37.0710 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 09:22:08.1520 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 09:23:41.6604 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 09:23:42.0617 1831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 09:24:49.1334 607 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 09:25:45.5141 517 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/11/2024 09:28:18.1460 1397 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 09:29:02.9669 758 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-04 09:29:01',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-04 09:29:01',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 04/11/2024 09:30:26.0283 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 09:36:37.4663 521 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 04/11/2024 09:36:37.6724 570 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 04/11/2024 09:52:15.2243 567 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 04/11/2024 09:53:42.5666 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 09:56:44.7652 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 09:58:46.2283 559 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 04/11/2024 10:00:25.6497 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 1 ms.) 04/11/2024 10:07:59.8909 2325 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 04/11/2024 10:08:01.2378 1332 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 10:10:29.7069 1129 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 04/11/2024 10:14:48.5367 2232 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 10:14:53.5631 665 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5683411013149520,4796580307518480,2024,'2024-11-04 10:14:52','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/4/2024 9:59:07 AM Date : 11/4/2024 10:14:51 AM Code : 455983594700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 04/11/2024 10:17:17.4381 568 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 10:17:54.3568 597 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/11/2024 10:18:01.7577 602 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-04 10:18:01','V',5626303022777910,2024,'2024-11-04 10:17:59','455983426300327005012999',2,2,2,'O','',0,'2024-11-04 10:18:01',1,'','',0) 04/11/2024 10:25:54.5883 587 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 04/11/2024 10:25:59.5146 797 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 10:28:04.9203 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 10:28:06.7566 685 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/11/2024 10:28:25.7653 15386 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 04/11/2024 10:33:46.4894 682 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-04 10:33:44',0,'V',4989986469026290,5006113206594490,2024,'2024-11-04 10:33:44',3,1,0,4,'2024-11-04 10:48:44','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 04/11/2024 10:35:37.9468 575 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-04 10:35:37','V',4970107357740310,2024,'2024-11-04 10:35:36','455983555600327005012999',2,2,2,'O','',0,'2024-11-04 10:35:37',1,'','',0) 04/11/2024 10:35:38.5071 550 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/11/2024 10:39:24.1077 673 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 17 order by traDateTime desc,traId desc 04/11/2024 10:39:25.3826 665 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-04 10:39:24','V',5596932281769300,2024,'2024-11-04 10:39:22','455982864100327005012999',2,2,2,'O','',0,'2024-11-04 10:39:24',1,'','0230003944406',17,0) 04/11/2024 10:39:26.9316 806 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 17 04/11/2024 10:39:31.5897 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 10:41:32.5225 1163 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 04/11/2024 10:44:00.9496 547 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 04/11/2024 10:44:21.4763 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 10:46:39.7616 752 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 04/11/2024 10:47:49.5932 636 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 10:50:59.8462 2957 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 04/11/2024 10:52:01.3623 2369 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 04/11/2024 10:52:01.9567 575 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 44 order by traDateTime desc,traId desc 04/11/2024 10:52:41.3890 789 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/11/2024 10:54:10.8497 557 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 106 order by traDateTime desc,traId desc 04/11/2024 10:54:16.6406 856 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-04 10:54:15',0,'V',5730036452056210,5658040369460480,2024,'2024-11-04 10:54:15',3,1,0,4,'2024-11-04 11:09:15','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 04/11/2024 10:56:15.2227 536 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 04/11/2024 10:56:16.0193 1274 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 10:57:11.4783 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 10:57:11.5193 776 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 04/11/2024 10:57:31.0854 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 11:02:27.1690 606 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 04/11/2024 11:03:06.7054 654 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 04/11/2024 11:03:58.1548 881 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 04/11/2024 11:05:25.4460 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 11:06:21.4964 870 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/11/2024 11:12:44.3379 994 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/11/2024 11:13:41.2249 643 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/11/2024 11:15:02.9214 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 11:18:09.0277 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 11:19:03.6582 897 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 04/11/2024 11:21:07.9091 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 11:24:13.7341 916 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 11:27:15.3314 733 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 04/11/2024 11:29:04.9185 534 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 04/11/2024 11:31:24.3686 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 11:34:35.0209 786 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-04 11:34:34',0,'V',5229995912263940,5284173160053790,2024,'2024-11-04 11:34:34',18,1,0,4,'2024-11-04 11:49:34','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/11/2024 11:34:58.7691 523 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-04 11:34:58' where payTraUID = 4669997238816330 and payStatus='V' and payEnabled=1 04/11/2024 11:36:12.5374 772 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-04 11:36:11',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-04 11:36:11',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 04/11/2024 11:39:22.1522 720 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 04/11/2024 11:42:18.0807 1511 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-04 11:42:16','V',5110870380080960,2024,'2024-11-04 11:42:14','455983916700327005012999',2,2,2,'O','',0,'2024-11-04 11:42:16',1,'','',0) 04/11/2024 11:43:38.4163 1785 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-04 11:43:36',0,'V',5684808786293160,5690137480856560,2024,'2024-11-04 11:43:36',3,1,0,4,'2024-11-04 11:58:36','C','KES',200,200,0,'',' ',' ',1,200,0,0,'',0,0) (WAIT TIME 171 ms.) 04/11/2024 11:45:32.6415 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 11:50:41.5277 563 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 11:52:46.1920 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 12:00:10.5216 580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 12:04:04.3487 629 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 367032 else acvFstPayId end),acvLstPayId = 367032 where acvSftId = 816 and acvCodeId = 3 04/11/2024 12:05:38.3604 656 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 12:06:46.5620 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 12:13:45.6677 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 12:16:26.2279 603 ms. EXEC: update abbCards set carLastDate = '2024-11-04 12:16:25',carLastDirection='I' where carStatus='V' and carId = 44 04/11/2024 12:18:32.4542 647 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 12:22:54.7693 557 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 04/11/2024 12:26:37.4029 572 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = @extTerId nr: 1 04/11/2024 12:26:44.4286 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 12:45:38.0374 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 12:52:29.5851 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 12:55:18.9672 510 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48243, trcLastPrinted = '2400748243', trcLastDate = '2024-11-04 12:55:18' where trcStatus='V' and trcTerId = 18 04/11/2024 12:56:55.6337 560 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 04/11/2024 12:56:58.1984 2084 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 13:00:47.9948 570 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/11/2024 13:00:57.7503 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 13:01:45.1099 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 13:01:46.4418 896 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-04 13:01:45','V',4741578960074180,2024,'2024-11-04 13:01:43','455984126900327005012999',2,2,2,'O','',0,'2024-11-04 13:01:45',1,'','',0) 04/11/2024 13:04:29.3376 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 13:05:01.0768 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 13:05:02.5497 1471 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 04/11/2024 13:05:17.8459 522 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 04/11/2024 13:05:41.0404 1282 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 13:08:22.6253 635 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-04 13:08:20',0,'V',5503948044560440,5416322369545050,2024,'2024-11-04 13:08:20',3,1,0,4,'2024-11-04 13:23:20','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 04/11/2024 13:09:42.6287 716 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/11/2024 13:09:57.3355 625 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-04 13:09:56' where payTraUID = 5416322369545050 and payStatus='V' and payEnabled=1 04/11/2024 13:10:07.8505 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 13:13:18.8400 870 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 13:14:33.2747 744 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 13:18:18.1909 616 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-04 13:18:17','V',4809256777241470,2024,'2024-11-04 13:18:15','455984132700327005012999',2,2,2,'O','',0,'2024-11-04 13:18:17',1,'','',0) 04/11/2024 13:18:59.8177 560 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/11/2024 13:21:33.9445 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 13:22:09.9316 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 13:26:19.6673 594 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5235558070056400,5541687916945430,2024,'2024-11-04 13:26:19','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/4/2024 1:08:22 PM Date : 11/4/2024 1:26:18 PM Code : 455984730200327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 04/11/2024 13:26:21.0992 1137 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-04 13:26:19',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 04/11/2024 13:30:34.7906 630 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/11/2024 13:33:47.1360 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 13:36:07.3276 654 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-04 13:36:06' where traUID = 5597610316979520 and traStatus='V' and traEnabled=1 04/11/2024 13:36:15.8253 606 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/11/2024 13:40:55.1147 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 13:42:57.7356 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 13:46:43.3472 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 13:47:10.3622 525 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-04 13:47:09',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 04/11/2024 13:48:28.2072 581 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 1 ms.) 04/11/2024 13:54:16.5727 2187 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 13:57:25.8351 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 13:57:39.0169 778 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-04 13:57:38',0,1,'2024-11-04 13:57:38','','Unauthorized Transit Entry 1') 04/11/2024 14:02:40.2990 1892 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 14:04:48.1383 814 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 304 ms.) 04/11/2024 14:09:02.6002 703 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 14:09:24.8270 763 ms. OPEN: SELECT traId,traCode,traDateTime,traEnabled FROM movTransitId INNER JOIN movTransit ON traId = tidTraId AND tidTraKey=@tidTraKey WHERE traStatus='V' AND traDirection = 'I' AND traCarId = 0 AND traEnabled = 1 ORDER BY traId DESC LIMIT 100 04/11/2024 14:09:39.7490 664 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-04 14:09:39' where payTraUID = 4691519873093510 and payStatus='V' and payEnabled=1 04/11/2024 14:16:18.6113 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 14:28:22.9268 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 14:48:48.6700 732 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 14:56:49.9423 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 14:56:50.6338 508 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-04 14:56:50','V',4835765985919510,2024,'2024-11-04 14:56:45','455985380500327005012999',1,2,16,'I','',1,0,1,'','',4) 04/11/2024 14:59:44.5749 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 15:02:53.0767 551 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-04 15:02:52',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'; 04/11/2024 15:03:31.9597 1068 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 15:05:57.4138 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 15:06:17.6163 713 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 04/11/2024 15:06:18.6560 822 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 15:09:13.0274 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 15:12:51.8024 765 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-04 15:12:50',0,'V',5623812106718780,5674160107381300,2024,'2024-11-04 15:12:50',18,1,0,4,'2024-11-04 15:27:50','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 04/11/2024 15:13:07.1457 580 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/11/2024 15:24:47.5042 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 15:25:08.9215 2810 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 04/11/2024 15:26:42.8862 527 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-04 15:26:42',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 04/11/2024 15:31:45.2841 776 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 15:34:11.6318 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 15:40:41.6061 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 15:54:56.1005 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 15:54:56.6709 668 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 04/11/2024 15:56:54.6597 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:02:14.7504 769 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:02:28.8127 698 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:05:09.9483 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:05:10.6027 607 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/11/2024 16:07:44.0642 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 16:09:04.0996 702 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/11/2024 16:14:17.4828 1505 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 04/11/2024 16:21:16.7887 611 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 04/11/2024 16:22:36.9663 775 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 04/11/2024 16:24:31.1465 729 ms. EXECSCALAR: SELECT COUNT(*) FROM payPayment INNER JOIN movTransit ON traUID = payTrauid WHERE payStatus='V' AND payPayed=0 AND payAmount=0 AND payDiscount = 100 AND payDiscountType = 1 AND traStatus='V' AND traEnabled = 1 AND traCode = '455985678000327005012999' nr: 0 04/11/2024 16:28:53.2454 1242 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:30:04.2178 536 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:31:07.0598 532 ms. EXEC: update payInventory set invCreation = '2024-11-04 16:31:06',invModify = '2024-11-04 16:31:06',invUseId=0,invStatus='V' where invId = 217297 04/11/2024 16:32:03.2503 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:35:09.1877 529 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 11 ms.) 04/11/2024 16:35:32.2040 504 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/11/2024 16:35:37.9079 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:37:55.5748 801 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-04 16:37:54',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'; 04/11/2024 16:38:11.5164 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:41:41.2704 959 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:48:45.4566 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:55:13.3625 1761 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 16:55:13.5136 752 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 04/11/2024 16:58:29.9318 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 16:58:29.9318 531 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/11/2024 17:05:03.5225 535 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/11/2024 17:06:17.7330 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 17:07:33.2635 519 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 148 ms.) 04/11/2024 17:07:50.1557 686 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-04 17:07:49' where subId = 194 04/11/2024 17:07:50.7982 627 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-04 17:07:50','0560008336057',0,0,5529070256320150,179,'0000-00-00 00:00:00','0000-00-00 00:00:00') 04/11/2024 17:14:27.4029 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 17:16:46.7159 616 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-04 16:16:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-04 17:16:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-04 17:16:46' and (resAreId = 1 or resAreId <= 0) nr: 0 04/11/2024 17:24:01.8254 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 17:35:59.9017 867 ms. EXECSCALAR: select count(*) from tabTables where tabId = 30 and tabTxtValue='22' and tabTable = 'devAction' nr: 0 04/11/2024 17:42:08.1346 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 17:43:28.5062 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 17:43:46.0439 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 17:45:18.1464 1096 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-04 17:45:17' where traUID = 5078509308035130 and traStatus='V' and traEnabled=1 04/11/2024 17:45:28.6864 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 17:48:19.2673 934 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/11/2024 17:48:28.8207 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 17:50:19.3765 673 ms. EXEC: update payReceipt set recCreation = '2024-11-04 17:50:18',recModify = '2024-11-04 17:50:18',recUseId=0,recStatus='V' where recId = 319207 04/11/2024 17:51:35.3552 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 17:59:38.8740 547 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-04 17:59:38',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'; 04/11/2024 18:00:07.0728 1947 ms. OPEN: SELECT * FROM tabuser WHERE useBadId<>'' AND (useBadId = '455984375100327005012999' OR useBadId = '455984375100327005012999') 04/11/2024 18:04:33.1635 535 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/11/2024 18:07:36.3107 524 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 04/11/2024 18:13:37.1446 511 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-04 18:13:36' where payTraUID = 5383343799707100 and payStatus='V' and payEnabled=1 04/11/2024 18:13:45.8124 655 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 04/11/2024 18:18:15.7136 521 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 04/11/2024 18:23:37.6985 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 18:25:16.1812 652 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 18:28:29.3742 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 18:36:03.9567 584 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-04 18:36:03' where payTraUID = 5188306396319070 and payStatus='V' and payEnabled=1 04/11/2024 18:36:12.3423 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 18:36:51.9657 624 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 18:36:52.3510 1016 ms. OPEN: show columns from tabArea where Field = 'areBookingReserved' 04/11/2024 18:37:20.7559 524 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 18:39:40.9165 891 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-04 18:39:40','V',4669691093794190,2024,'2024-11-04 18:39:38','455983546600327005012999',2,2,2,'O','',0,'2024-11-04 18:39:40',1,'','0230003957463',25,0) 04/11/2024 18:42:02.4830 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 18:46:36.6700 531 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/11/2024 18:48:40.6518 605 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5530725804203420,5144442742800330,2024,'2024-11-04 18:48:40','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/4/2024 6:19:11 PM Date : 11/4/2024 6:48:39 PM Code : 455986595100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 04/11/2024 18:52:05.4245 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 18:58:46.3832 634 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 19:02:47.9384 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 19:18:09.9509 592 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-04 19:18:09' where traUID = 4851783478783150 and traStatus='V' and traEnabled=1 04/11/2024 19:29:34.3718 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 19:31:37.4660 515 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 04/11/2024 19:31:38.2915 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 19:35:53.2587 887 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 04/11/2024 19:35:54.3985 606 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 19:40:11.1019 543 ms. EXEC: update payReceipt set recCreation = '2024-11-04 19:40:10',recModify = '2024-11-04 19:40:10',recUseId=0,recStatus='V' where recId = 319239 04/11/2024 19:40:28.0141 593 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 19:41:56.8044 1307 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 04/11/2024 19:44:25.0304 2237 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 19:48:24.9806 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 19:51:55.2099 903 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-04 19:51:54','V',5606931851215880,2024,'2024-11-04 19:51:53','455986759600327005012999',2,2,2,'O','',0,'2024-11-04 19:51:54',1,'','',0) 04/11/2024 19:51:56.8570 1149 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-04 19:51:55' where traUID = 5266197223209040 and traStatus='V' and traEnabled=1 04/11/2024 19:52:04.3750 750 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 19:52:22.4261 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 19:52:26.3327 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 19:56:56.5691 920 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/11/2024 20:04:39.7263 576 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-04 20:04:39',0,'V',5546844553734940,4726354115885760,2024,'2024-11-04 20:04:39',18,1,0,4,'2024-11-04 20:19:39','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 04/11/2024 20:10:41.0875 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 20:17:20.5351 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 20:19:55.2444 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 20:20:09.9813 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 20:34:35.8373 1187 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 04/11/2024 20:38:43.1183 546 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 04/11/2024 20:44:02.0953 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 20:51:37.0410 598 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 04/11/2024 21:11:47.5621 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 21:28:29.2608 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 21:51:50.2620 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 22:09:06.1105 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 22:19:03.4963 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 22:29:02.7063 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 22:40:49.4991 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 22:46:42.5828 1186 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 23:01:23.1797 968 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 04/11/2024 23:04:48.4157 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 04/11/2024 23:04:48.7759 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 23:19:23.7660 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/11/2024 23:40:28.7205 604 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 04/11/2024 23:40:36.9299 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1