18/10/2022 14:13:08.9645 520 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/10/2022 14:18:57.5771 547 ms. EXEC: update payInventory set invCreation = '2022-10-18 14:18:57',invModify = '2022-10-18 14:18:57',invUseId=0,invStatus='V' where invId = 12490 18/10/2022 15:02:08.3996 635 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/10/2022 15:02:08.4216 666 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 18/10/2022 15:02:09.8962 563 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 (WAIT TIME 23 ms.) 18/10/2022 15:02:10.6357 1380 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '46739' and traDirection='I' order by traId DESC LIMIT 1 (WAIT TIME 98 ms.) 18/10/2022 15:02:11.1080 1119 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/10/2022 15:02:11.2781 579 ms. OPEN: select * from tabClass where claPosition = 1 and claStatus='V' 18/10/2022 15:02:11.2951 577 ms. OPEN: show columns from movoperator where Field = 'opeQuery' 18/10/2022 15:02:13.3101 788 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '448505277900327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/10/2022 15:03:15.9769 671 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5051940087489810,4835965567605670,2022,'2022-10-18 15:03:15','---------------------------------- PSONE PARK End of payment ---------------------------------- POF Entry : 10/18/2022 2:39:39 PM Date : 10/18/2022 3:03:11 PM Code : 448505277900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 18/10/2022 15:03:32.0552 1277 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 = 7 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 18/10/2022 15:18:57.5746 707 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 18/10/2022 15:20:49.6062 615 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-10-18 15:20:48',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 18/10/2022 16:15:12.1427 689 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 12 ms.) 18/10/2022 16:15:12.1587 615 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 37 ms.) 18/10/2022 16:15:12.1837 781 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 18/10/2022 16:15:13.9590 1158 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/10/2022 16:15:14.2934 1404 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788195269' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/10/2022 16:15:14.2944 1402 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788205274' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/10/2022 16:15:22.5272 628 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '448504301600327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/10/2022 16:15:32.8774 562 ms. OPEN: show columns from abbPayment where Field = 'payCarId' 18/10/2022 16:18:41.1269 629 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 = 7 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 18/10/2022 19:12:54.6379 559 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,'2022-10-18 19:12:54','V',5428785331387950,2022,'2022-10-18 19:12:53','448506917300327005012999',1,2,16,'I','',1,0,1,'','',4)