29/01/2023 11:34:32.9527 516 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-01-29 11:34:32',3,41101,0,20,1,20,1,'I','C'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+20,5) where curTerId = 3 and curDevCode = 41101 and curChannelId = 1 and curValue = 20 and curType = 'C'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-01-29 11:34:32',3,41003,0,40,1,40,2,'I','C'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+40,5) where curTerId = 3 and curDevCode = 41003 and curChannelId = 2 and curValue = 40 and curType = 'C'; 29/01/2023 12:02:15.6730 541 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 29/01/2023 16:33:00.6990 595 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2023 18:25:41.0063 725 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-01-29 18:25:40',3,41101,0,10,1,10,1,'I','C'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+10,5) where curTerId = 3 and curDevCode = 41101 and curChannelId = 1 and curValue = 10 and curType = 'C'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-01-29 18:25:40',3,41101,0,20,2,40,1,'I','C'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+40,5) where curTerId = 3 and curDevCode = 41101 and curChannelId = 1 and curValue = 20 and curType = 'C'; 29/01/2023 18:53:46.9428 612 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 29/01/2023 18:53:47.0199 727 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 29/01/2023 18:53:49.2787 1366 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 29/01/2023 18:53:49.4450 1591 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '449536793600327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 29/01/2023 18:53:49.5301 592 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788195269' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 (WAIT TIME 85 ms.) 29/01/2023 18:53:49.5301 1901 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '168858' and traDirection='I' order by traId DESC LIMIT 1 (WAIT TIME 64 ms.) 29/01/2023 18:53:50.6641 1277 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/01/2023 18:53:51.1764 512 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); 29/01/2023 18:53:51.2476 852 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,'2023-01-29 18:53:50','V',5664389705065940,2023,'2023-01-29 18:52:29','0098788195269',2,1,2,'O','',1,0,1,'','',0) (WAIT TIME 33 ms.) 29/01/2023 18:53:51.7901 532 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2023 18:53:51.7901 536 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/01/2023 18:53:51.9648 876 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 = '449536130500327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 29/01/2023 18:54:15.3978 761 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5163618090058490,5224833777432760,2023,'2023-01-29 18:54:14',' Date: 1/29/2023 6:54:12 PM Code: 449536130500327005012999 Entry Date: 1/29/2023 5:01:45 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2300704739 ',0) 29/01/2023 18:56:30.3891 603 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,'2023-01-29 18:56:29','V',5694785603018890,2023,'2023-01-29 18:56:39','449536130500327005012999',2,2,2,'O','',0,'2023-01-29 18:56:29',1,'','',0) 29/01/2023 19:06:57.8476 1561 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 29/01/2023 19:09:02.4884 711 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 29/01/2023 19:55:04.4817 671 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