21/04/2025 07:46:17.0740 3002 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/04/2025 07:46:17.0740 3010 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/04/2025 07:46:17.0750 3007 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/04/2025 07:46:17.0760 3011 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/04/2025 07:46:17.0770 3010 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/04/2025 07:46:17.0780 11583 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 21/04/2025 07:46:17.0780 3011 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/04/2025 07:46:17.0780 3013 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/04/2025 07:46:17.0790 3011 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/04/2025 07:46:17.0790 3014 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/04/2025 07:46:17.0800 3011 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/04/2025 07:46:17.0800 3014 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/04/2025 07:46:17.0800 3016 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/04/2025 07:46:17.0800 3015 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/04/2025 07:46:17.0810 3014 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/04/2025 07:46:17.0810 26609 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 21/04/2025 07:46:17.0820 10577 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 21/04/2025 07:46:17.0820 3016 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/04/2025 07:46:17.0820 3013 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/04/2025 07:46:17.1641 3094 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 21/04/2025 07:46:18.0466 510 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentCustomers' 21/04/2025 07:46:19.0293 853 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 21/04/2025 07:46:19.0323 854 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 21/04/2025 07:46:19.0333 855 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/04/2025 07:46:19.0393 861 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 21/04/2025 07:46:19.0393 862 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/04/2025 07:46:19.0403 862 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 21/04/2025 07:46:19.0423 863 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/04/2025 07:46:19.0473 868 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/04/2025 07:46:19.0953 915 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 4 ms.) 21/04/2025 07:46:19.7748 502 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId (WAIT TIME 6 ms.) 21/04/2025 07:46:19.7988 505 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId (WAIT TIME 29 ms.) 21/04/2025 07:46:20.3602 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-04-21 06:46:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-21 07:46:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-21 07:46:17' and (resAreId = 1 or resAreId <= 0) nr: 0 21/04/2025 07:46:20.3612 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-04-21 06:46:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-21 07:46:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-21 07:46:18' and (resAreId = 1 or resAreId <= 0) nr: 0 21/04/2025 07:46:20.3652 1022 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-21 06:46:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-21 07:46:19' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-21 07:46:19' and (resAreId = 1 or resAreId <= 0) nr: 0 21/04/2025 07:46:20.3662 1027 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-21 06:46:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-21 07:46:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-21 07:46:18' and (resAreId = 1 or resAreId <= 0) nr: 0 21/04/2025 07:46:20.3702 1028 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-21 06:46:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-21 07:46:19' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-21 07:46:19' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 2 ms.) 21/04/2025 07:46:20.3732 1027 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-21 06:46:19') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-21 07:46:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-21 07:46:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 6 ms.) 21/04/2025 07:46:20.3752 569 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' (WAIT TIME 7 ms.) 21/04/2025 07:46:36.2708 14745 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788189620' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 21/04/2025 07:46:38.5313 18154 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 21/04/2025 07:46:38.7284 776 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 181 21/04/2025 07:46:40.0733 1337 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,'2025-04-21 07:46:38','V',5335685249115020,2025,'2025-04-21 07:44:04','457662404900327005029999',2,2,16,'I','',1,0,1,'','0532370675124',181,0) 21/04/2025 07:46:41.3322 1246 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/04/2025 07:46:43.6787 4822 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/04/2025 07:46:48.1938 4514 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); 21/04/2025 07:46:48.8832 561 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/04/2025 07:46:49.5210 3106 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '457655896800327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 21/04/2025 07:46:50.1354 582 ms. OPEN: select * from payreceipt where recPayUID = 4910876820655860 and recStatus='V' 21/04/2025 08:33:00.9718 576 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 164 order by traDateTime desc,traId desc 21/04/2025 09:15:46.6585 2429 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 21/04/2025 10:07:05.0290 15224 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 21/04/2025 10:09:28.9887 1966 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 21/04/2025 10:27:23.4708 1307 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 21/04/2025 11:29:44.9296 515 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4648753823076430,5748500381566870,2025,'2025-04-21 11:29:44',' Data: 4/21/2025 11:28:01 AM Codice: 457663786200327005012999 Ingresso: 4/21/2025 10:31:02 AM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500602840 ',0) 21/04/2025 12:21:29.0095 1230 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-21 12:21:27',0,'V',5579184421196440,4872467030379760,2025,'2025-04-21 12:21:27',18,1,0,4,'2025-04-21 12:36:27','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 21/04/2025 13:14:02.2438 1928 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/04/2025 14:18:56.2404 1520 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 21/04/2025 15:12:05.4645 2272 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-21 15:12:03' where payTraUID = 4852844612533050 and payStatus='V' and payEnabled=1 21/04/2025 15:12:07.0359 1571 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-21 15:12:03' where traUID = 4852844612533050 and traStatus='V' and traEnabled=1 21/04/2025 19:06:23.4906 1167 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 = 10 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 21/04/2025 20:13:07.6200 601 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-21 20:13:07',17,10,'2025-04-21 20:13:07','457666854100327005012999','Pagato (Contanti ) Biglietto ') 21/04/2025 20:53:32.7776 1130 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