24/10/2024 09:24:14.8131 1097 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 ('2024-10-24 09:24:12',0,'V',5481579871165730,4931991790460380,2024,'2024-10-24 09:24:12',3,1,0,4,'2024-10-24 09:39:12','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 24/10/2024 09:24:15.9159 720 ms. EXEC: update payInventory set invCreation = '2024-10-24 09:24:15',invModify = '2024-10-24 09:24:15',invUseId=0,invStatus='V' where invId = 214909 24/10/2024 15:12:11.7591 566 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/10/2024 16:37:29.1689 547 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-24 16:37:28' where payTraUID = 4616977207132420 and payStatus='V' and payEnabled=1 24/10/2024 17:18:51.2411 584 ms. EXEC: update payReceipt set recCreation = '2024-10-24 17:18:50',recModify = '2024-10-24 17:18:50',recUseId=0,recStatus='V' where recId = 315733 24/10/2024 17:18:52.3259 1079 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-10-24 17:18:51',0,0,'V',5626219776692440,5392071014702940,2024,'2024-10-24 17:18:51',3,'KES',1,100,100,'N',''); 24/10/2024 17:59:37.7301 22342 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 24/10/2024 17:59:41.0683 1161 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 24/10/2024 17:59:41.4726 883 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:39' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:39' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:41.4736 880 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:39' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:39' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:41.4746 878 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:39' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:39' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:41.4746 881 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:39' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:39' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:41.4766 878 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:38' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:38' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:41.4766 878 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:39' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:39' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:41.4786 887 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:39' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:39' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:41.4796 886 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:39' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:39' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:41.4806 889 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:39' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:39' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:41.4816 892 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:38' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:38' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:41.4826 887 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:38' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:38' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 1 ms.) 24/10/2024 17:59:41.4836 889 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-24 16:59:40') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-24 17:59:39' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-24 17:59:39' and (resAreId = 1 or resAreId <= 0) nr: 0 24/10/2024 17:59:57.0730 14759 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '455876463000327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 24/10/2024 17:59:57.0740 16954 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0240526473873' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 24/10/2024 17:59:58.9412 907 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 24/10/2024 17:59:58.9412 1014 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 24/10/2024 17:59:59.5607 560 ms. OPEN: select max(traCode) as vCode from movTransit where traCode >='45587 ' and traCode < '45588 ' and traType = 2 24/10/2024 18:00:00.0570 21232 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 24/10/2024 18:00:01.6931 1551 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,'2024-10-24 18:00:00','V',5597764678623280,2024,'2024-10-24 17:57:10','455876463000327005031999',1,2,16,'I','',1,0,1,'','',4) 24/10/2024 18:00:01.8002 1849 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-10-24 17:59:59','V',5748296356328280,2024,'2024-10-24 17:57:00','455876366100327002029999',2,1,2,'O','',1,0,1,'','1301662556817',169,0) 24/10/2024 18:00:01.8052 2052 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-10-24 17:59:59','V',5342845011088340,2024,'2024-10-24 17:57:00','455876366100327002029999',2,1,2,'O','',1,0,1,'','1301662556817',169,0) 24/10/2024 18:00:03.1751 1471 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/10/2024 18:00:03.1771 1370 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 2 ms.) 24/10/2024 18:00:05.5276 5268 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/10/2024 18:00:10.3128 4785 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); 24/10/2024 18:00:28.9064 15476 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 24/10/2024 18:19:24.8055 1397 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 24/10/2024 18:27:23.8281 1576 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 24/10/2024 18:41:11.9258 681 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 106 order by traDateTime desc,traId desc 24/10/2024 18:42:32.7112 1366 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 24/10/2024 18:52:27.7775 1053 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 24/10/2024 19:54:44.4627 1640 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 24/10/2024 22:16:55.3681 781 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