05/12/2023 08:37:30.3225 2140 ms. OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal 05/12/2023 12:20:57.3840 1140 ms. EXECSCALAR: select count(traId) as Tot from movTransit where traStatus='V' and traEnabled=1 and traCarId=0 and traAreId = 1 and traUID not in (select payTraUID from paypayment where payStatus='V') nr: 13704 05/12/2023 12:20:57.8997 515 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled=1 and traCarId=0 and traAreId = 1 and traUID not in (select payTraUID from paypayment where payStatus='V') order by traId 05/12/2023 13:03:26.6950 609 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/12/2023 13:12:30.9315 562 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/12/2023 13:39:11.0057 578 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-12-05 13:39:10',0,0,'V',5633340977609970,4741672193036750,2023,'2023-12-05 13:39:10',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-12-05 13:39:10',0,0,'V',5633340977609970,4741672193036750,2023,'2023-12-05 13:39:10',3,'KES',-1,100,-100,'N',''); 05/12/2023 13:49:00.5354 531 ms. EXEC: update tabTerminalReceipt set trcProgressive = 56769, trcLastPrinted = '2300756769', trcLastDate = '2023-12-05 13:49:00' where trcStatus='V' and trcTerId = 18 05/12/2023 14:04:04.4131 515 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/12/2023 16:08:51.2572 656 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-12-05 16:08:50' where payTraUID = 5342708158902590 and payStatus='V' and payEnabled=1 05/12/2023 18:07:00.0473 594 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1