29/04/2025 19:05:03.1473 15162 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitId' nr: 1 29/04/2025 19:05:03.2153 15205 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/04/2025 19:05:03.2193 15203 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 2 ms.) 29/04/2025 19:05:03.2193 28686 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 2 ms.) 29/04/2025 19:05:03.2203 15203 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 3 ms.) 29/04/2025 19:05:03.2213 15216 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/04/2025 19:05:03.2224 15211 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/04/2025 19:05:03.2304 15205 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 14 ms.) 29/04/2025 19:05:03.3464 15334 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/04/2025 19:05:03.3474 15332 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/04/2025 19:05:03.3484 15334 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/04/2025 19:05:03.3484 13774 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 29/04/2025 19:05:03.3494 15333 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 3 ms.) 29/04/2025 19:05:03.3514 29614 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 29/04/2025 19:05:03.3524 15340 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/04/2025 19:05:03.3524 15344 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/04/2025 19:05:03.3524 15339 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/04/2025 19:05:03.3534 15345 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 29/04/2025 19:05:03.3534 12790 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 29/04/2025 19:05:03.3544 15344 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/04/2025 19:05:03.3554 15345 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 29/04/2025 19:05:03.3574 15350 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 29/04/2025 19:05:03.3584 15343 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 29/04/2025 19:05:04.8835 597 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 29/04/2025 19:05:04.8845 595 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 29/04/2025 19:05:04.8845 595 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 29/04/2025 19:05:04.8855 598 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 29/04/2025 19:05:04.8865 595 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 29/04/2025 19:05:04.8875 716 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 29/04/2025 19:05:04.8905 628 ms. OPEN: show columns from tabArea where Field = 'areBookingReserved' 29/04/2025 19:05:04.8905 575 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 29/04/2025 19:05:04.8935 578 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 29/04/2025 19:05:04.8945 578 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 29/04/2025 19:05:04.9055 590 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 29/04/2025 19:05:04.9085 594 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 29/04/2025 19:05:04.9115 595 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 29/04/2025 19:05:04.9145 598 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 29/04/2025 19:05:04.9155 743 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 29/04/2025 19:05:04.9165 599 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 29/04/2025 19:05:04.9175 599 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 29/04/2025 19:05:04.9235 605 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 29/04/2025 19:05:06.3514 1440 ms. OPEN: show columns from tabTerminalExtraMem where Field = 'extcode' 29/04/2025 19:05:06.3845 1403 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 29/04/2025 19:05:06.4945 2239 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 29/04/2025 19:05:06.5045 850 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 29/04/2025 19:05:07.4592 700 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 29/04/2025 19:05:07.6633 641 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-29 18:05:07') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-04-29 19:05:04' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-04-29 19:05:04' and (resAreId = 1 or resAreId <= 0) nr: 0 29/04/2025 19:05:07.6663 880 ms. OPEN: show columns from tabUser where Field = 'useAllowZReport' 29/04/2025 19:05:15.6863 12536 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '916879' and traDirection='I' order by traId DESC LIMIT 1 29/04/2025 19:05:15.6884 12537 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '916879' and traDirection='I' order by traId DESC LIMIT 1 29/04/2025 19:05:15.6914 7181 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457746863500327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 29/04/2025 19:05:17.1540 9692 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 29/04/2025 19:05:19.0305 1750 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-04-29 19:05:17','V',5398070269364480,2025,'2025-04-29 19:03:55','457746863500327005031999',1,2,16,'I','',1,0,1,'','',4) 29/04/2025 19:05:19.1976 696 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 = '457746712900327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 29/04/2025 19:05:19.1986 696 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 = '457746712900327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 29/04/2025 19:05:20.7472 1704 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 29/04/2025 19:05:23.1878 5754 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 29/04/2025 19:05:23.2899 4091 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 = '457746712900327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 29/04/2025 19:05:23.2909 4091 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 = '457746712900327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 29/04/2025 19:05:25.9707 2781 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/04/2025 19:05:51.5980 20620 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/04/2025 19:10:40.8416 2669 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 29/04/2025 19:15:57.0352 2275 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/04/2025 19:22:56.8817 730 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2025-04-29 19:22:56',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 29/04/2025 20:05:54.2398 1305 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/04/2025 22:13:53.9997 1754 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