03/03/2025 10:02:41.1290 1208 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 03/03/2025 10:03:50.8538 1474 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/03/2025 10:10:02.8713 525 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-03-03 10:10:02',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'; 03/03/2025 11:05:42.4000 532 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/03/2025 13:39:16.5849 544 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-03-03 13:39:16','V',4613103884252600,2025,'2025-03-03 13:39:15','457174915500327001012999',1,2,1,'I','',1,0,1,'','',4) 03/03/2025 15:34:45.3876 575 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 03/03/2025 15:40:31.7918 1229 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 03/03/2025 15:40:31.8348 1248 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 64 ms.) 03/03/2025 15:40:32.9886 511 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 03/03/2025 15:40:33.6641 1064 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 03/03/2025 15:40:33.6641 1066 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 03/03/2025 15:40:33.6651 1068 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/03/2025 15:40:33.6671 1052 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/03/2025 15:40:33.6721 1062 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/03/2025 15:40:33.6721 1059 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 03/03/2025 15:40:33.6721 1058 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 03/03/2025 15:40:33.6751 1058 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/03/2025 15:40:33.6781 1066 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 03/03/2025 15:40:33.6791 1076 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 03/03/2025 15:40:33.6801 1069 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 03/03/2025 15:40:33.6811 1076 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 03/03/2025 15:40:33.6821 1079 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/03/2025 15:40:33.6821 1084 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/03/2025 15:40:33.6831 1077 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 03/03/2025 15:40:33.6841 1080 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/03/2025 15:40:33.6841 1084 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/03/2025 15:40:33.6851 1070 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/03/2025 15:40:33.6861 1078 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 03/03/2025 15:40:33.6871 1071 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 03/03/2025 15:40:33.6881 1086 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 03/03/2025 15:40:33.6891 1091 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 03/03/2025 15:40:33.6891 1074 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 03/03/2025 15:40:34.8208 551 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 03/03/2025 15:40:34.8228 553 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 03/03/2025 15:40:34.8268 558 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 03/03/2025 15:40:47.8285 13909 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457175413600327001012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 03/03/2025 15:40:47.8525 14019 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '874867' and traDirection='I' order by traId DESC LIMIT 1 03/03/2025 15:40:48.2988 11237 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId 03/03/2025 15:40:55.2757 1558 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 03/03/2025 15:40:56.2453 502 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabCardConversionRules' nr: 1 (WAIT TIME 8 ms.) 03/03/2025 15:40:57.4542 2178 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 03/03/2025 15:40:58.1856 984 ms. OPEN: select * from tabClass where claPosition = 2 03/03/2025 15:40:58.1886 818 ms. OPEN: select * from tabClass where claPosition = 2 03/03/2025 15:40:58.3888 539 ms. OPEN: select * from tabuser where useStatus='V' order by useId 03/03/2025 15:40:59.8568 26581 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 03/03/2025 15:41:00.6323 775 ms. EXEC: update payCurInventory set curType='C' where curType<>'C' and curValue = 5 and curDevCode in (41003,41002,41001,41101,41102,41103); 03/03/2025 15:41:01.6890 13669 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 17 and payDateTime = '2025-03-03 15:37:18' nr: 0 03/03/2025 15:41:01.9401 4568 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '1992' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 03/03/2025 15:41:02.1923 3986 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '457174817700327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 03/03/2025 15:41:02.1923 3986 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '457175415000327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 03/03/2025 15:41:02.4425 751 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 = '457175413600327001012999' nr: 0 03/03/2025 15:41:03.4281 1452 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 03/03/2025 15:41:03.4291 551 ms. OPEN: select * from movtransit where traUID = 4952381820731190 and traStatus='V' (WAIT TIME 2 ms.) 03/03/2025 15:41:07.8781 3964 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-03-03 15:41:03',17,1,'2025-03-03 15:41:03','457175413600327001012999','Pagato (Contanti ) Biglietto ') 03/03/2025 15:41:08.4515 3975 ms. OPEN: select * from payreceipt where recPayUID = 5157937032408650 and recStatus='V' 03/03/2025 15:41:09.5212 8886 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/03/2025 15:41:13.4508 3928 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); 03/03/2025 15:41:14.1403 627 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/03/2025 15:43:45.2908 2308 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 03/03/2025 15:46:07.5212 3155 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 03/03/2025 15:51:43.9496 640 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 412001 else acvFstPayId end),acvLstPayId = 412001 where acvSftId = 913 and acvCodeId = 3 03/03/2025 16:21:46.8860 1918 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 03/03/2025 16:23:41.2692 571 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 103 order by traDateTime desc,traId desc 03/03/2025 16:44:15.0749 849 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 03/03/2025 16:57:33.1443 1318 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 03/03/2025 17:03:31.5457 528 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-03-03 17:03:31','V',4886274188896410,2025,'2025-03-03 17:03:30','457173051200327005012999',2,2,2,'O','',0,'2025-03-03 17:03:31',1,'','0230003950863',158,0) 03/03/2025 17:17:05.4297 13133 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 03/03/2025 17:19:30.5828 1074 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 03/03/2025 18:45:43.8710 629 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 03/03/2025 19:32:01.0964 1515 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 = 9 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 03/03/2025 21:37:06.7564 572 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-03-03 21:37:05',0,'V',5133726026601600,4837826335395880,2025,'2025-03-03 21:37:05',3,1,0,4,'2025-03-03 21:52:05','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0)