13/01/2023 10:24:06.3318 627 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 13/01/2023 10:45:33.3431 529 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-01-13 10:45:32',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'; 13/01/2023 12:02:10.0229 708 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-01-13 12:02:09' where traUID = 5246787248261290 and traStatus='V' and traEnabled=1 13/01/2023 13:16:11.3362 560 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/01/2023 13:40:25.5825 591 ms. EXEC: update payInventory set invCreation = '2023-01-13 13:40:24',invModify = '2023-01-13 13:40:24',invUseId=0,invStatus='V' where invId = 46487 13/01/2023 14:04:24.5787 504 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-13 14:04:24','V',5628473193832780,2023,'2023-01-13 14:04:23','449374828900327005012999',2,2,2,'O','',0,'2023-01-13 14:04:24',1,'','',0) 13/01/2023 17:07:13.3731 508 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-01-13 17:07:12' where traUID = 4786778635379390 and traStatus='V' and traEnabled=1 13/01/2023 17:31:30.4564 5893 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traCode = '449376307900327005012999' and traDirection='I' order by traId DESC LIMIT 1 nr: 152139 13/01/2023 17:31:39.9565 4542 ms. EXEC: create temporary table temp_tariff (tarId integer not null default 0,tarDay integer not null default 0,tarHourFrom datetime not null default 0,tarHourTo datetime not null default 0,tarNumber integer not null default 0,tarAmount double not null default 0,tarPeriod integer not null default 0,tarPeriodLength integer not null default 0,tarPeriodCount integer not null default 0,rulAmountPeriod double not null default 0,rulAmountPeriodDay double not null default 0,tarDisabled integer not null default 0) ENGINE = MEMORY 13/01/2023 17:31:44.6895 4606 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 13/01/2023 17:31:54.2096 9254 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '449375964900327005012999' 13/01/2023 17:32:16.1267 531 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentCustomers' 13/01/2023 17:32:24.1208 2937 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 13/01/2023 17:32:31.1573 3723 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/01/2023 17:32:31.1824 7032 ms. OPEN: show columns from tabArea where Field = 'areType' 13/01/2023 17:32:39.1435 8040 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 13/01/2023 17:32:39.1465 11712 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/01/2023 17:32:39.1485 14999 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 13/01/2023 17:33:28.2170 514 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2023-01-13 17:33:27',1,2,'2023-01-13 17:33:27','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 13/01/2023 17:33:52.6216 5292 ms. OPEN: select * from tabDevice where devId = 50001 and devStatus = 'V' 13/01/2023 17:34:02.1337 4689 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2023-01-13 17:33:57' where subId = 20 13/01/2023 17:34:31.8658 4260 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' (WAIT TIME 32 ms.) 13/01/2023 17:35:36.2301 5753 ms. OPEN: select * from abbCards where carStatus='V' and carCode='449376153400327005012999' (WAIT TIME 91 ms.) 13/01/2023 17:35:46.7078 4459 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 69 ms.) 13/01/2023 17:35:51.4979 4164 ms. OPEN: select * from tabTariff left join tabtlkTariff on tlkTarId = tarId where (tarValidFrom <= '2023-01-13' and tarValidTo >= '2023-01-13' and tarStatus='V' and tlkAreId = 1 and tlkStatus='V') and (((tarIdClass = 6 or tarIdClass <=0) and tarEnabled <> 0) or tarDefault<>0) order by tarModify desc,tarId desc (WAIT TIME 104 ms.) 13/01/2023 17:36:20.2143 6684 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 74 ms.) 13/01/2023 17:36:20.2193 6690 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 70 ms.) 13/01/2023 17:36:26.1972 4877 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 60 ms.) 13/01/2023 17:36:37.7816 5263 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 76 ms.) 13/01/2023 17:37:54.9751 3717 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 83 ms.) 13/01/2023 17:39:34.6711 4516 ms. OPEN: select * from tabtariff where tarId=4 (WAIT TIME 35 ms.) 13/01/2023 17:39:44.1592 4347 ms. OPEN: select * from tabTerminalReceipt where trcStatus='V' and trcTerId = 4 order by trcId desc limit 1 13/01/2023 17:39:48.8872 4681 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4884990143643330,5365693217953950,2023,'2023-01-13 17:39:44',' Date: 1/13/2023 5:35:27 PM Code: 449375926200327005012999 Entry Date: 1/13/2023 4:27:42 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 0.00 KES ______________________________ Paid: 0.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: Manual Cashier 1 ',1) 13/01/2023 17:39:58.3973 4582 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/01/2023 17:40:17.3975 4226 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/01/2023 17:41:00.1520 4535 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/01/2023 17:41:38.1383 4218 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 13/01/2023 17:41:42.8784 4272 ms. EXEC: update payReceipt set recCreation = '2023-01-13 17:41:38',recModify = '2023-01-13 17:41:38',recUseId=0,recStatus='V' where recId = 56939 13/01/2023 18:21:36.9387 544 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1