29/12/2022 07:19:09.4848   744 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 64 ms.)
29/12/2022 07:19:09.4858   586 ms.     EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1
29/12/2022 07:19:09.4888   774 ms.           OPEN: show columns from tabParameters where Field = 'parUseCulture' (WAIT TIME 3 ms.)
29/12/2022 07:19:11.7186  1266 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 (WAIT TIME 26 ms.)
29/12/2022 07:19:12.3678   646 ms.           EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL)
29/12/2022 07:19:12.4318  1409 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '449222635000327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
29/12/2022 07:19:12.8841   506 ms.           EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL)
29/12/2022 07:19:12.9442  1202 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 21 ms.)
29/12/2022 07:19:13.6921   562 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-12-29 07:19:13','V',5377395902581680,2022,'2022-12-29 07:19:10','449222635000327005031999',1,2,16,'I','',1,0,1,'','',4)
29/12/2022 07:46:53.6407  1289 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 = 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType
29/12/2022 12:04:16.5682   524 ms.           EXEC: update payInventory set invCreation = '2022-12-29 12:04:16',invModify = '2022-12-29 12:04:16',invUseId=0,invStatus='V' where invId = 41195
29/12/2022 13:49:55.0368   588 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-12-29 13:49:54','V',5582340919741830,2022,'2022-12-29 13:49:54','449224792600327005012999',2,2,2,'O','',0,'2022-12-29 13:49:54',1,'','',0)
29/12/2022 16:10:05.9380   560 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2022-12-29 16:10:05' where payTraUID = 5003170467278850 and payStatus='V' and payEnabled=1
29/12/2022 17:19:26.4231   639 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2022-12-29 17:19:25' where payTraUID = 4690191451257270 and payStatus='V' and payEnabled=1