15/05/2025 13:00:17.4148 15270 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 15/05/2025 13:00:17.4178 12569 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 (WAIT TIME 40 ms.) 15/05/2025 13:00:17.4188 890 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 34 ms.) 15/05/2025 13:00:17.4259 14929 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 15/05/2025 13:00:17.5219 1027 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 15/05/2025 13:00:17.5359 14554 ms. OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 15/05/2025 13:00:18.5509 575 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitId' nr: 1 15/05/2025 13:00:18.7311 984 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentCustomers' 15/05/2025 13:00:19.2634 525 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 15/05/2025 13:00:21.2727 2008 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 15/05/2025 13:00:21.4709 781 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 15/05/2025 13:00:22.4665 894 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-05-15 12:00:21') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-05-15 13:00:20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-05-15 13:00:20' and (resAreId = 1 or resAreId <= 0) nr: 0 15/05/2025 13:00:22.4705 895 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-05-15 12:00:21') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-05-15 13:00:20' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-05-15 13:00:20' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 2 ms.) 15/05/2025 13:00:30.9226 13140 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457904643900327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 15/05/2025 13:00:30.9666 12415 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '934422' and traDirection='I' order by traId DESC LIMIT 1 15/05/2025 13:00:33.9466 12161 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 15/05/2025 13:00:35.0043 763 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '457903337900327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 15/05/2025 13:00:35.0043 763 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '457903337900327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 15/05/2025 13:00:35.0294 3744 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 17 and payDateTime = '2025-05-15 12:57:10' nr: 0 15/05/2025 13:00:37.3219 3234 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/05/2025 13:00:37.4910 1235 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-05-15 13:00:36',17,9,'2025-05-15 13:00:36','457904643900327005031999','Pagato (Contanti ) Biglietto ') 15/05/2025 13:00:38.7178 1395 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); 15/05/2025 13:00:40.3989 1369 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4716584098509530,5307083204805290,2025,'2025-05-15 13:00:39',' Data: 5/15/2025 12:57:10 PM Codice: 457904643900327005031999 Ingresso: 5/15/2025 12:53:59 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 0.00 KES ______________________________ Pagato: 0.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 ',1) 15/05/2025 13:00:41.5910 1214 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-05-15 13:00:40','V',5206455330331930,2025,'2025-05-15 12:56:23','457904510600327005029999',2,2,16,'I','',1,0,1,'','0532370673239',164,0) 15/05/2025 13:10:04.2859 530 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 183 order by traDateTime desc,traId desc 15/05/2025 13:36:53.0926 2448 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 15/05/2025 13:41:31.4126 525 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 165 order by traDateTime desc,traId desc 15/05/2025 14:02:20.6457 1198 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 15/05/2025 14:15:31.2013 1142 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 15/05/2025 17:21:44.5344 8077 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 15/05/2025 17:21:44.5484 8062 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 8 ms.) 15/05/2025 17:21:44.5634 8064 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 23 ms.) 15/05/2025 17:21:44.5684 8082 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 11 ms.) 15/05/2025 17:21:44.5684 8065 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 27 ms.) 15/05/2025 17:21:44.5724 8076 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 18 ms.) 15/05/2025 17:21:44.5724 8077 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 17 ms.) 15/05/2025 17:21:44.5774 8075 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 24 ms.) 15/05/2025 17:21:44.5804 8067 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 38 ms.) 15/05/2025 17:21:44.5814 8077 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 27 ms.) 15/05/2025 17:21:44.5974 8079 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 42 ms.) 15/05/2025 17:21:44.6054 8075 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 55 ms.) 15/05/2025 17:21:44.6054 8077 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 52 ms.) 15/05/2025 17:21:44.6064 8079 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 50 ms.) 15/05/2025 17:21:44.6094 8079 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 52 ms.) 15/05/2025 17:21:44.6104 8075 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 59 ms.) 15/05/2025 17:21:44.6104 8074 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 58 ms.) 15/05/2025 17:21:44.6114 8064 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 71 ms.) 15/05/2025 17:21:44.6124 8063 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 71 ms.) 15/05/2025 17:21:44.6124 8076 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 60 ms.) 15/05/2025 17:21:44.6134 8067 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 70 ms.) 15/05/2025 17:21:44.6144 8061 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 75 ms.) 15/05/2025 17:21:44.6144 8074 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 63 ms.) 15/05/2025 17:21:44.6154 8080 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 57 ms.) 15/05/2025 17:21:45.6151 599 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 15/05/2025 17:21:45.6161 610 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 15/05/2025 17:21:45.7072 621 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' (WAIT TIME 79 ms.) 15/05/2025 17:21:53.6084 6718 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788348987' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 15/05/2025 17:21:53.6084 4653 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457906249700327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 15/05/2025 17:21:53.6104 6401 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457906226600327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 15/05/2025 17:21:54.4250 8245 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 15/05/2025 17:21:55.0814 656 ms. EXEC: update payCurInventory set curType='C' where curType<>'C' and curValue = 5 and curDevCode in (41003,41002,41001,41101,41102,41103); 15/05/2025 17:21:55.9480 1225 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370834491' and traDirection='I' order by traId desc limit 1 15/05/2025 17:21:57.5351 1849 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-05-15 17:21:55','V',5143366382755610,2025,'2025-05-15 17:21:37','457906249700327005031999',1,2,16,'I','',1,0,1,'','',4) 15/05/2025 17:21:57.5351 1447 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-05-15 17:21:56','V',4654009980893940,2025,'2025-05-15 17:20:43','457906016800327002029999',2,1,2,'O','',1,0,1,'','0532370834491',8,0) 15/05/2025 17:21:57.7272 2041 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-05-15 17:21:55','V',5603856760051280,2025,'2025-05-15 17:17:46','457906226600327001031999',1,2,1,'I','',1,0,1,'','',4) 15/05/2025 17:21:58.3596 624 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 15/05/2025 17:22:20.3463 25262 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 15/05/2025 17:22:39.8713 1414 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 = '457906255600327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 15/05/2025 17:22:51.0660 990 ms. OPEN: show columns from movoperator where Field = 'opeQuery' 15/05/2025 17:23:53.1351 6770 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 15/05/2025 17:23:53.1441 10624 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 15/05/2025 17:23:54.5660 1323 ms. OPEN: select * from payreceipt where recPayUID = 4987346934896590 and recStatus='V' 15/05/2025 17:23:56.1131 1077 ms. OPEN: show columns from abbPayment where Field = 'payCarId' 15/05/2025 17:27:32.7860 581 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 18 and payDateTime = '2025-05-15 17:27:32' nr: 0 15/05/2025 17:28:18.2250 539 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 156 order by traDateTime desc,traId desc 15/05/2025 17:40:51.5353 2239 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 15/05/2025 17:42:19.1934 1136 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 15/05/2025 17:46:09.3832 540 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5109948695918790,5044033132635500,2025,'2025-05-15 17:46:08',' Date: 5/15/2025 5:45:58 PM Code: 457905972400327005012999 Entry Date: 5/15/2025 4:35:24 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2500406255 ',0) 15/05/2025 17:46:32.2456 15491 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 15/05/2025 17:55:15.6521 678 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 15/05/2025 18:02:20.1768 1985 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 15/05/2025 18:38:20.4735 1279 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 15/05/2025 18:46:10.1573 697 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