29/03/2025 07:47:45.3629 11185 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 29/03/2025 07:47:45.3679 11185 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/03/2025 07:47:45.3689 11189 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/03/2025 07:47:45.3699 11189 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/03/2025 07:47:45.3709 11191 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/03/2025 07:47:45.3719 11190 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/03/2025 07:47:45.3719 11191 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/03/2025 07:47:45.3729 11193 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/03/2025 07:47:45.3729 11191 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/03/2025 07:47:45.3739 11193 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/03/2025 07:47:45.3739 11193 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/03/2025 07:47:45.3749 11194 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/03/2025 07:47:45.3769 11195 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/03/2025 07:47:45.4860 11306 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/03/2025 07:47:45.4860 11306 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/03/2025 07:47:45.4870 11307 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/03/2025 07:47:45.4870 11307 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/03/2025 07:47:45.4870 11307 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/03/2025 07:47:45.4880 11306 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/03/2025 07:47:45.4880 11308 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/03/2025 07:47:45.4880 11307 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 29/03/2025 07:47:45.4890 11308 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/03/2025 07:47:45.4920 11308 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 3 ms.) 29/03/2025 07:47:48.1678 1012 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 29/03/2025 07:47:48.1688 1014 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 29/03/2025 07:47:48.1718 1016 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 29/03/2025 07:47:48.1718 1012 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 29/03/2025 07:47:48.1788 1011 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 8 ms.) 29/03/2025 07:47:48.1878 1016 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 18 ms.) 29/03/2025 07:47:48.1898 1012 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 20 ms.) 29/03/2025 07:47:48.1998 1019 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 27 ms.) 29/03/2025 07:47:48.2018 1014 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 28 ms.) 29/03/2025 07:47:48.2108 1016 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 36 ms.) 29/03/2025 07:47:48.2138 1018 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 37 ms.) 29/03/2025 07:47:48.2158 1021 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-03-29 06:47:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-03-29 07:47:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-03-29 07:47:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 39 ms.) 29/03/2025 07:47:59.2452 10013 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457432789200327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 29/03/2025 07:47:59.8446 12707 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 29/03/2025 07:48:03.1281 1796 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-29 07:48:01','V',5633275366753620,2025,'2025-03-29 07:44:52','457432789200327005031999',1,2,16,'I','',1,0,1,'','',4) 29/03/2025 07:48:04.4290 1281 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/03/2025 07:48:04.8193 4683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/03/2025 07:48:06.5034 1684 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); 29/03/2025 07:57:44.2956 2251 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 29/03/2025 08:32:07.7359 1924 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 29/03/2025 08:37:45.9156 1137 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 29/03/2025 08:49:14.3181 549 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 142 order by traDateTime desc,traId desc 29/03/2025 09:25:07.7058 1052 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 29/03/2025 09:58:45.5883 521 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-29 09:58:45','V',5315652177478340,2025,'2025-03-29 09:58:45','457433592500327005012999',1,2,16,'I','',1,0,1,'','',4) 29/03/2025 10:02:57.0202 13841 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 29/03/2025 10:22:03.9027 1263 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 29/03/2025 10:31:54.6627 1085 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 29/03/2025 11:27:15.8982 1817 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 29/03/2025 11:56:51.3548 940 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 29/03/2025 12:36:19.9873 539 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-29 12:34:19',12,'V',4668492828601610,4903450236721330,2025,'2025-03-29 12:34:19',4,1,0,4,'2025-03-29 12:49:19','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/03/2025 12:45:47.6389 534 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-29 12:44:33',1,'V',4877750980786610,5684420435123190,2025,'2025-03-29 12:44:33',17,1,0,4,'2025-03-29 12:59:33','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 29/03/2025 12:58:07.5544 616 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-03-29 12:58:06','0230003941812',0,0,4756925223531460,181,'0000-00-00 00:00:00','0000-00-00 00:00:00') 29/03/2025 13:47:08.9324 640 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-29 13:47:08','V',5418527359076450,2025,'2025-03-29 13:47:07','457434449800327005012999',2,2,2,'O','',0,'2025-03-29 13:47:08',1,'','',0) 29/03/2025 13:57:34.8575 1419 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