12/04/2025 05:40:19.9430 16962 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 12/04/2025 05:40:19.9901 17016 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 12/04/2025 05:40:19.9901 12910 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 12/04/2025 05:40:19.9911 17012 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 12/04/2025 05:40:19.9921 29020 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 12/04/2025 05:40:19.9931 17014 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 12/04/2025 05:40:19.9941 17013 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 12/04/2025 05:40:20.0271 17023 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 26 ms.) 12/04/2025 05:40:20.0311 17029 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 28 ms.) 12/04/2025 05:40:20.0331 17058 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 12/04/2025 05:40:20.0551 17025 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 51 ms.) 12/04/2025 05:40:20.0571 30180 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 26 ms.) 12/04/2025 05:40:20.0911 17059 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 44 ms.) 12/04/2025 05:40:20.1462 17026 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 145 ms.) 12/04/2025 05:40:20.1512 17029 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 149 ms.) 12/04/2025 05:40:20.1532 17029 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 150 ms.) 12/04/2025 05:40:20.1752 17030 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 169 ms.) 12/04/2025 05:40:20.2012 17019 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 202 ms.) 12/04/2025 05:40:20.2212 17025 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 216 ms.) 12/04/2025 05:40:20.2212 17028 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 216 ms.) 12/04/2025 05:40:20.2583 13981 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 204 ms.) 12/04/2025 05:40:20.5084 502 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 12/04/2025 05:40:21.1368 579 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' (WAIT TIME 55 ms.) 12/04/2025 05:40:21.9274 582 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' (WAIT TIME 15 ms.) 12/04/2025 05:40:23.2703 1707 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 12/04/2025 05:40:23.2733 1941 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 12/04/2025 05:40:23.2803 850 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 12/04/2025 05:40:23.3033 850 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 12/04/2025 05:40:23.3153 1731 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 18 ms.) 12/04/2025 05:40:23.3203 961 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 20 ms.) 12/04/2025 05:40:24.8293 2224 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04.40.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05.40.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05.40.20' and (resAreId = 1 or resAreId <= 0) nr: 0 12/04/2025 05:40:24.8343 2193 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04.40.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05.40.21' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05.40.21' and (resAreId = 1 or resAreId <= 0) nr: 0 12/04/2025 05:40:24.8403 2109 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04.40.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05.40.21' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05.40.21' and (resAreId = 1 or resAreId <= 0) nr: 0 12/04/2025 05:40:24.8543 2122 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04.40.22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05.40.20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05.40.20' and (resAreId = 1 or resAreId <= 0) nr: 0 12/04/2025 05:40:42.4166 19110 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 12/04/2025 05:40:46.8537 4203 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 12/04/2025 05:40:49.1892 2335 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); 12/04/2025 05:52:45.0682 6102 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 12/04/2025 05:52:45.1383 6133 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 112 ms.) 12/04/2025 05:52:45.1383 6136 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 111 ms.) 12/04/2025 05:52:45.1403 6132 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 112 ms.) 12/04/2025 05:52:45.1413 6130 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 112 ms.) 12/04/2025 05:52:45.1443 6136 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 107 ms.) 12/04/2025 05:52:45.1443 6144 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 106 ms.) 12/04/2025 05:52:45.1463 6143 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 108 ms.) 12/04/2025 05:52:45.1473 6139 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 108 ms.) 12/04/2025 05:52:45.1483 6145 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 105 ms.) 12/04/2025 05:52:45.1503 6131 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 121 ms.) 12/04/2025 05:52:45.1513 6142 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 109 ms.) 12/04/2025 05:52:45.1523 6131 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 125 ms.) 12/04/2025 05:52:45.1533 6151 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 109 ms.) 12/04/2025 05:52:45.1543 6145 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 114 ms.) 12/04/2025 05:52:45.1543 30151 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 117 ms.) 12/04/2025 05:52:45.1553 6129 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 129 ms.) 12/04/2025 05:52:45.1563 6137 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 120 ms.) 12/04/2025 05:52:45.1573 6131 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 129 ms.) 12/04/2025 05:52:45.1583 30153 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 119 ms.) 12/04/2025 05:52:45.1593 6139 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 120 ms.) 12/04/2025 05:52:45.1593 6148 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 114 ms.) 12/04/2025 05:52:45.9268 501 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 12/04/2025 05:52:45.9278 501 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 12/04/2025 05:52:45.9348 507 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 12/04/2025 05:52:45.9648 539 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 12/04/2025 05:52:46.0939 540 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 12/04/2025 05:52:46.3041 657 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 221 ms.) 12/04/2025 05:52:46.3051 659 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 219 ms.) 12/04/2025 05:52:46.3101 672 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 211 ms.) 12/04/2025 05:52:46.3111 514 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 214 ms.) 12/04/2025 05:52:46.3121 671 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 214 ms.) 12/04/2025 05:52:47.1557 707 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 12/04/2025 05:52:47.1587 744 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 12/04/2025 05:52:47.6811 726 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04:52:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05:52:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05:52:46' and (resAreId = 1 or resAreId <= 0) nr: 0 12/04/2025 05:52:47.6831 726 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04:52:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05:52:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05:52:46' and (resAreId = 1 or resAreId <= 0) nr: 0 12/04/2025 05:52:47.6861 730 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04:52:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05:52:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05:52:46' and (resAreId = 1 or resAreId <= 0) nr: 0 12/04/2025 05:52:47.6871 729 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04:52:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05:52:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05:52:46' and (resAreId = 1 or resAreId <= 0) nr: 0 12/04/2025 05:52:47.6891 728 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04:52:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05:52:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05:52:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 5 ms.) 12/04/2025 05:52:47.6901 727 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04:52:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05:52:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05:52:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 7 ms.) 12/04/2025 05:52:47.6911 728 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04:52:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05:52:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05:52:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 7 ms.) 12/04/2025 05:52:47.6921 727 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-04-12 04:52:46') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-12 05:52:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-12 05:52:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 7 ms.) 12/04/2025 05:52:59.5114 13057 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 12/04/2025 05:53:05.2307 5520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 12/04/2025 05:53:08.4500 3219 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); 12/04/2025 05:56:46.0780 18230 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 12/04/2025 06:01:02.3381 1062 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-04-12 06:01:01','V',5371353166752650,2025,'2025-04-12 06:01:00','457572166000327005012999',1,2,16,'I','',1,0,1,'','',4) 12/04/2025 08:01:21.1714 549 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 163 order by traDateTime desc,traId desc 12/04/2025 08:08:30.1764 2578 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 12/04/2025 08:33:43.7637 763 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 12/04/2025 08:36:21.4249 743 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 12/04/2025 08:50:47.5794 513 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 12/04/2025 09:35:49.5237 859 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 12/04/2025 09:56:51.3432 1070 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 12/04/2025 10:20:20.0088 2618 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 = 12 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 12/04/2025 10:37:07.7242 573 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-12 10:37:07' where traUID = 5200354882457780 and traStatus='V' and traEnabled=1 12/04/2025 11:20:29.1888 768 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 12/04/2025 14:56:36.6682 527 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 12/04/2025 15:11:11.5125 593 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-12 15:11:10' where traUID = 5074874008618530 and traStatus='V' and traEnabled=1 12/04/2025 15:40:04.5796 648 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-12 15:40:03' where payTraUID = 5754129486933420 and payStatus='V' and payEnabled=1 12/04/2025 16:06:55.3987 630 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-04-12 16:06:54',0,'V',4886799523947980,4647645985203140,2025,'2025-04-12 16:06:54',3,1,0,4,'2025-04-12 16:21:54','C','KES',50,0,0,'',' ',' ',98,50,0,0,'',0,0) 12/04/2025 18:42:54.5301 957 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