08/05/2025 12:52:29.8063 22076 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 08/05/2025 12:52:29.8123 14640 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 08/05/2025 12:52:29.8123 22062 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 08/05/2025 12:52:31.2330 937 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) 08/05/2025 12:52:31.2330 937 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 08/05/2025 12:52:32.2562 564 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 08/05/2025 12:52:39.2741 3854 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457834167400327005012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 08/05/2025 12:52:39.2851 2387 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '929677' and traDirection='I' order by traId DESC LIMIT 1 08/05/2025 12:52:39.2851 8009 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '929677' and traDirection='I' order by traId DESC LIMIT 1 08/05/2025 12:52:40.6292 9213 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 08/05/2025 12:52:42.8678 3316 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 4 and payDateTime = '2025-05-08 12:12:04' nr: 0 08/05/2025 12:52:43.3860 517 ms. EXECSCALAR: SELECT COUNT(*) FROM payPayment INNER JOIN movTransit ON traUID = payTrauid WHERE payStatus='V' AND payPayed=0 AND payAmount=0 AND payDiscount = 100 AND payDiscountType = 1 AND traStatus='V' AND traEnabled = 1 AND traCode = '457834167400327005012999' nr: 0 08/05/2025 12:52:44.1029 577 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '457833876900327001012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 08/05/2025 12:52:44.1039 577 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '457833876900327001012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 08/05/2025 12:52:44.7069 3794 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/05/2025 12:52:45.5315 1384 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-05-08 12:52:44',4,1,'2025-05-08 12:52:44','457834167400327005012999','Payed (Cash ) Ticket ') 08/05/2025 12:52:46.6919 1985 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); 08/05/2025 12:52:47.8682 928 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4750549734217670,5711279298567080,2025,'2025-05-08 12:52:46',' Date: 5/8/2025 12:12:04 PM Code: 457834167400327005012999 Entry Date: 5/8/2025 11:34:34 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 0.00 KES ______________________________ Paid: 0.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: Manual Cashier 1 ',1) 08/05/2025 12:52:50.7834 657 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/05/2025 14:06:40.5718 6206 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 08/05/2025 14:06:40.5768 8857 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 11 ms.) 08/05/2025 14:06:40.5798 6190 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 08/05/2025 14:06:42.7991 624 ms. EXEC: update tabTerminalExtraMem SET extLoop2 = 1 where extStatus='V' and extTerId = 2 AND extPlateWaitOperator=0 08/05/2025 14:06:42.8001 1139 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 2 AND extPlateWaitOperator=0 08/05/2025 14:06:42.8011 1133 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 1, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '' where extStatus='V' and extTerId = 2 08/05/2025 14:06:42.8021 624 ms. EXEC: update tabTerminalExtraMem SET extLoop2 = 0 where extStatus='V' and extTerId = 2 AND extPlateWaitOperator=0 08/05/2025 14:06:42.8131 590 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 08/05/2025 14:06:42.8691 1718 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 08/05/2025 14:06:43.3891 542 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 08/05/2025 14:06:52.8397 9937 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 08/05/2025 14:06:53.6313 10237 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 08/05/2025 14:06:53.7871 582 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 08/05/2025 14:06:55.5847 1773 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-08 14:06:53','V',4695949557054430,2025,'2025-05-08 13:57:43','0098788191894',2,1,2,'O','',1,0,1,'','',0) 08/05/2025 14:06:56.6103 1014 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 08/05/2025 14:06:57.2687 3410 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 08/05/2025 14:06:57.8161 547 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); 08/05/2025 14:07:15.3686 651 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 = '457834936300327005031999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P'))