21/08/2025 01:27:21.4829 13309 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 21/08/2025 01:27:21.4979 13309 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 21/08/2025 01:27:22.1644 505 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.1684 514 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.1704 509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.1714 517 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2054 549 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2124 555 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2134 556 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2144 557 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2144 559 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2154 553 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2164 557 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2164 555 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2174 560 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2184 562 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2194 564 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2214 561 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:22.2214 565 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 21/08/2025 01:27:23.0550 776 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/08/2025 01:27:23.0560 744 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/08/2025 01:27:23.0580 762 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/08/2025 01:27:23.0580 773 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 01:27:23.0600 766 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/08/2025 01:27:23.0710 793 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 01:27:23.0720 760 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 01:27:23.0740 777 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 2 ms.) 21/08/2025 01:27:23.0750 790 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/08/2025 01:27:23.1751 898 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 01:27:23.1761 882 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 01:27:24.1258 502 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'EUR' 21/08/2025 01:27:24.1278 502 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'EUR' 21/08/2025 07:04:20.6257 27276 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 21/08/2025 07:04:20.6347 27260 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 8 ms.) 21/08/2025 07:04:21.6764 590 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 07:04:21.7805 694 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/08/2025 07:04:21.7805 690 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 07:04:21.7815 695 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/08/2025 07:04:21.7825 696 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 07:04:21.7845 698 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/08/2025 07:04:21.7855 699 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/08/2025 07:04:21.7885 698 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/08/2025 07:04:21.7895 702 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/08/2025 07:04:21.7905 703 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/08/2025 07:04:21.7915 704 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/08/2025 07:04:21.7925 706 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/08/2025 07:04:21.7945 707 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/08/2025 07:04:21.7965 708 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/08/2025 07:04:21.7965 710 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/08/2025 07:04:21.7975 708 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/08/2025 07:04:21.8045 718 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 21/08/2025 07:04:21.8055 720 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/08/2025 07:04:22.5851 533 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 07:04:22.5861 540 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/08/2025 07:04:22.5871 543 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 07:04:22.5871 546 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 07:04:22.5881 542 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 07:04:22.5891 541 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 07:04:22.5891 549 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 07:04:22.5901 549 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/08/2025 07:04:22.5911 551 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/08/2025 07:04:22.5911 549 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/08/2025 07:04:22.5931 540 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 07:04:22.5951 541 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 07:04:22.5951 540 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/08/2025 07:04:22.5951 541 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/08/2025 07:04:22.5961 540 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/08/2025 07:04:22.5971 544 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 07:04:22.5971 541 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 07:04:22.5981 555 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 07:04:22.5991 548 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 07:04:22.6001 546 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/08/2025 07:04:22.6001 545 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/08/2025 07:04:22.6011 546 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/08/2025 07:04:22.7572 674 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 35 ms.) 21/08/2025 07:04:23.7059 917 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/08/2025 07:04:23.7069 919 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 07:04:23.7089 903 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 07:04:23.7099 901 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/08/2025 07:04:23.7109 897 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 07:04:23.7119 895 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/08/2025 07:04:23.7209 938 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 07:04:23.7219 929 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 07:04:23.7229 929 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/08/2025 07:04:23.7250 936 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/08/2025 07:04:23.7280 953 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1 21/08/2025 07:04:23.8681 1047 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 21/08/2025 07:04:23.8751 1051 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/08/2025 07:04:23.8761 1057 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/08/2025 07:04:24.6386 542 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2025-08-21 07.04.23',extLoop1 = 0, extTerId = 1, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '', extCode = '' 21/08/2025 07:04:24.6386 541 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2025-08-21 07.04.23',extLoop2 = 0, extTerId = 2 21/08/2025 07:04:24.6406 538 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2025-08-21 07.04.23',extLoop2 = 0, extTerId = 16 21/08/2025 07:04:24.6416 537 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2025-08-21 07.04.23',extBarrier = 0, extTerId = 2 21/08/2025 07:04:24.6456 549 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2025-08-21 07.04.23',extLoop2 = 0, extTerId = 1 21/08/2025 07:04:24.6456 549 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2025-08-21 07.04.23',extLoop1 = 0, extTerId = 16, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '', extCode = '' 21/08/2025 07:04:34.6703 11908 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 21/08/2025 07:04:35.0276 8023 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458882528400327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 21/08/2025 07:04:36.6158 594 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 21/08/2025 07:04:39.2068 1951 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-08-21 07.04.37','V',5586838210651590,2025,'2025-08-21 07.01.24','458882528400327005031999',1,2,16,'I','',1,0,1,'','',4) 21/08/2025 07:04:39.3389 4487 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/08/2025 07:04:40.2225 1003 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/08/2025 07:04:40.9711 1631 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/08/2025 07:05:05.5128 1992 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 21/08/2025 07:05:09.4097 755 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 = '458882484400327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 21/08/2025 07:18:21.9728 1962 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 21/08/2025 07:19:04.8860 18388 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/08/2025 07:19:09.4015 533 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 21/08/2025 07:21:44.9923 2159 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-08-21 07.21.42','V',5243006013352690,2025,'2025-08-21 07.21.42','458882533500327005031999',2,2,2,'O','',0,'2025-08-21 07.21.42',1,'','',0) (WAIT TIME 5 ms.) 21/08/2025 07:21:45.3747 2058 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 185 order by traDateTime desc,traId desc 21/08/2025 07:48:41.3015 1287 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 21/08/2025 08:41:51.6880 1080 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 17 order by traDateTime desc,traId desc 21/08/2025 08:43:11.3598 1642 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/08/2025 08:51:35.4084 761 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 21/08/2025 08:55:21.8533 1273 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 21/08/2025 08:58:07.8742 617 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/08/2025 10:00:34.2749 1442 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 21/08/2025 10:04:30.9600 3194 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 = 12 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/08/2025 10:28:15.9706 877 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/08/2025 13:30:53.1207 1237 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/08/2025 13:59:54.8360 691 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-08-21 13.59.54' where traUID = 5652723597035450 and traStatus='V' and traEnabled=1 21/08/2025 14:16:37.4718 679 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-08-21 14.16.36' where payTraUID = 5008512176382670 and payStatus='V' and payEnabled=1 21/08/2025 14:39:45.5671 2559 ms. OPEN: show columns from tabParameters where Field = 'parForce24Hours' 21/08/2025 14:39:45.7452 2570 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 230 ms.) 21/08/2025 14:39:45.7452 2577 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 225 ms.) 21/08/2025 14:39:45.7482 2572 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 232 ms.) 21/08/2025 14:39:45.7492 2574 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 231 ms.) 21/08/2025 14:39:45.7502 2571 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 233 ms.) 21/08/2025 14:39:45.7522 2576 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 231 ms.) 21/08/2025 14:39:45.7542 2577 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 233 ms.) 21/08/2025 14:39:45.7542 2584 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 225 ms.) 21/08/2025 14:39:45.7562 2582 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 228 ms.) 21/08/2025 14:39:45.7582 2584 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 230 ms.) 21/08/2025 14:39:45.7592 2582 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 233 ms.) 21/08/2025 14:39:45.7612 2602 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 214 ms.) 21/08/2025 14:39:45.7632 2604 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 215 ms.) 21/08/2025 14:39:45.7632 2606 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 214 ms.) 21/08/2025 14:39:45.7652 2604 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 215 ms.) 21/08/2025 14:39:45.7672 2607 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 215 ms.) 21/08/2025 14:39:45.7672 2576 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 247 ms.) 21/08/2025 14:39:45.7682 2584 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 239 ms.) 21/08/2025 14:39:45.7682 2583 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 240 ms.) 21/08/2025 14:39:45.7692 2581 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 243 ms.) 21/08/2025 14:39:45.7702 2601 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 224 ms.) 21/08/2025 14:39:45.7702 2581 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 243 ms.) 21/08/2025 14:39:45.7712 2580 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 246 ms.) 21/08/2025 14:39:48.4150 1376 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 21/08/2025 14:39:55.9540 2823 ms. OPEN: select * from tabClass where claPosition = 2 and claStatus='V' 21/08/2025 14:39:58.2423 11416 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 21/08/2025 14:39:58.9588 9562 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191889' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 21/08/2025 14:39:58.9588 8615 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458885262300327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 21/08/2025 14:39:59.0669 2763 ms. OPEN: select traCode from movTransit where traCode ='458885279200327005012999' 21/08/2025 14:40:01.7358 1866 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-08-21 14.39.59','V',5631423999304560,2025,'2025-08-21 14.39.52','458885279200327005012999',1,2,16,'I','',1,0,1,'','',4) 21/08/2025 14:40:01.7358 1792 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-08-21 14.39.59','V',4787373772765470,2025,'2025-08-21 14.37.03','458885262300327005031999',1,2,16,'I','',1,0,1,'','',4) 21/08/2025 14:40:02.1170 2005 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-08-21 14.40.00','V',4959023918418060,2025,'2025-08-21 14.39.10','458885155000327002029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 21/08/2025 14:40:03.4693 1304 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/08/2025 14:40:03.4693 1349 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/08/2025 14:40:03.4723 1725 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/08/2025 14:40:03.4723 1726 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/08/2025 14:40:03.7665 5275 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/08/2025 14:40:07.0703 3500 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 = '458885279200327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 21/08/2025 14:40:07.7244 3957 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/08/2025 14:40:08.4129 590 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 21/08/2025 14:40:26.5690 716 ms. EXEC: update payReceipt set recCreation = '2025-08-21 14.40.25',recModify = '2025-08-21 14.40.25',recUseId=0,recStatus='V' where recId = 408390 21/08/2025 14:40:31.4409 525 ms. OPEN: show columns from movAnomaly where Field = 'anmMandatory' 21/08/2025 14:43:53.4348 841 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/08/2025 14:43:59.6291 776 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 21/08/2025 14:52:35.8299 2832 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/08/2025 14:56:34.6543 587 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-08-21 14:56:34','V',5263901536207520,2025,'2025-08-21 14:56:33','458885223100327005012999',2,2,2,'O','',0,'2025-08-21 14:56:34',1,'','',0) 21/08/2025 15:10:55.4206 3622 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/08/2025 15:40:18.6532 16140 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/08/2025 15:40:43.5172 534 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 21/08/2025 16:01:08.4636 517 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-08-21 16:01:07',0,'V',4845542817085290,5630520504014280,2025,'2025-08-21 16:01:07',18,1,0,4,'2025-08-21 16:16:07','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 21/08/2025 16:05:26.3262 626 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/08/2025 16:11:04.3615 1220 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 21/08/2025 16:42:35.4857 535 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 21/08/2025 17:21:09.4838 700 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-08-21 17:21:08','V',5006605647106080,2025,'2025-08-21 17:21:08','458883130000327005012999',2,2,2,'O','',0,'2025-08-21 17:21:08',1,'','0230003900848',211,0) 21/08/2025 19:54:24.2831 576 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