16/08/2025 12:48:50.6012 501 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-08-16 12:48:50',0,0,'V',5445591790616560,5175005485058420,2025,'2025-08-16 12:48:50',3,'KES',1,10,10,'C',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-08-16 12:48:50',0,0,'V',5445591790616560,5175005485058420,2025,'2025-08-16 12:48:50',3,'KES',2,20,40,'C',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-08-16 12:48:50',0,0,'V',5445591790616560,5175005485058420,2025,'2025-08-16 12:48:50',3,'KES',1,5,5,'C',''); 16/08/2025 13:48:17.2773 513 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-16 13:48:16','V',4783094810434610,2025,'2025-08-16 13:48:16','458834770800327005012999',2,2,2,'O','',0,'2025-08-16 13:48:16',1,'','',0) 16/08/2025 19:49:37.1184 598 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-08-16 19:49:36',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 16/08/2025 19:56:43.8007 890 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 16/08/2025 20:46:50.7876 1383 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 16/08/2025 22:37:52.0521 10441 ms. OPEN: show columns from tabParameters where Field = 'parVatMethod' 16/08/2025 22:37:52.2502 10666 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 16/08/2025 22:37:52.2512 10669 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/08/2025 22:37:52.2522 10668 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 16/08/2025 22:37:52.2542 10671 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/08/2025 22:37:52.3743 10789 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/08/2025 22:37:52.4073 10823 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/08/2025 22:37:52.4173 10832 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 16/08/2025 22:37:52.4183 10839 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 16/08/2025 22:37:52.4373 10852 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/08/2025 22:37:52.4383 10858 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 16/08/2025 22:37:52.4403 10864 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/08/2025 22:37:52.4413 10860 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 16/08/2025 22:37:52.4433 10862 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/08/2025 22:37:52.4453 10866 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 16/08/2025 22:37:52.4523 10866 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/08/2025 22:37:52.4573 10879 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/08/2025 22:37:52.4663 10884 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 16/08/2025 22:37:53.4540 619 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 16/08/2025 22:37:53.4540 619 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 16/08/2025 22:37:53.4550 618 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/08/2025 22:37:53.4560 619 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/08/2025 22:37:53.4560 618 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 16/08/2025 22:37:53.4570 622 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 16/08/2025 22:37:53.4580 625 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/08/2025 22:37:53.4640 630 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/08/2025 22:37:53.4650 628 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 16/08/2025 22:37:53.4690 632 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/08/2025 22:37:53.4700 635 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/08/2025 22:37:53.4800 644 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 16/08/2025 22:37:53.4840 651 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 16/08/2025 22:37:53.4870 652 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 16/08/2025 22:37:53.4880 653 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/08/2025 22:37:53.4890 651 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 16/08/2025 22:37:53.4900 652 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 16/08/2025 22:37:53.4910 658 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 16/08/2025 22:37:53.4930 656 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/08/2025 22:37:53.4940 658 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 16/08/2025 22:37:53.4950 659 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/08/2025 22:37:53.4960 662 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/08/2025 22:37:54.7088 557 ms. OPEN: show columns from tabUser where Field = 'useAllowZReport' 16/08/2025 22:37:54.7479 616 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 16/08/2025 22:37:55.5184 1414 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 16/08/2025 22:37:55.5194 797 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 16/08/2025 22:37:55.5204 1842 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 16/08/2025 22:37:55.5204 799 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 16/08/2025 22:37:55.5214 797 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 16/08/2025 22:37:55.5214 807 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 16/08/2025 22:37:55.5234 801 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 16/08/2025 22:37:55.5244 804 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 16/08/2025 22:37:55.5254 786 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 16/08/2025 22:37:55.5264 786 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 16/08/2025 22:37:55.5264 786 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 16/08/2025 22:37:55.5284 764 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 16/08/2025 22:37:55.5394 775 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 16/08/2025 22:37:55.5444 779 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 16/08/2025 22:37:55.5454 780 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 16/08/2025 22:37:55.5564 1875 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName (WAIT TIME 2 ms.) 16/08/2025 22:37:55.5604 790 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 6 ms.) 16/08/2025 22:37:55.5734 786 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' (WAIT TIME 23 ms.) 16/08/2025 22:37:56.1358 579 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 16/08/2025 22:37:56.1458 571 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 16/08/2025 22:37:56.2759 2597 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 16/08/2025 22:37:56.2769 2598 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 16/08/2025 22:37:56.2779 757 ms. OPEN: show columns from tabTerminalExtraMem where Field = 'extcode' 16/08/2025 22:37:56.3179 785 ms. EXEC: update tabTerminal set terVersion = 'Parking_project V.1.6.2 (BETA 44) Jul 25 2017 12:08:13.31061.20170725082637' where terId = 3 16/08/2025 22:37:56.6011 1859 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 16/08/2025 22:37:56.6021 1041 ms. EXEC: update tabTerminal set terVersion = 'Parking_project V.1.6.2 (BETA 44) Jul 25 2017 12:08:13.31061.20170725082637' where terId = 3 16/08/2025 22:37:56.6111 2932 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 16/08/2025 22:37:58.1852 747 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 16/08/2025 22:37:58.2412 812 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 16/08/2025 22:37:58.2422 630 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 16/08/2025 22:37:58.2422 627 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 16/08/2025 22:37:58.2422 813 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 16/08/2025 22:37:58.2432 814 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 16/08/2025 22:37:58.2432 815 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 16/08/2025 22:37:59.1418 873 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) 16/08/2025 22:37:59.1428 874 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) (WAIT TIME 13 ms.) 16/08/2025 22:37:59.1638 873 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) (WAIT TIME 20 ms.) 16/08/2025 22:37:59.1848 877 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) (WAIT TIME 52 ms.) 16/08/2025 22:37:59.1848 872 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) (WAIT TIME 57 ms.) 16/08/2025 22:37:59.1858 880 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',100 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 100 and curType = 'N' LIMIT 1) (WAIT TIME 50 ms.) 16/08/2025 22:37:59.9193 776 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.56' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.56' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:37:59.9223 783 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.56' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.56' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:37:59.9223 1418 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.58') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.56' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.56' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:37:59.9243 783 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.55' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:37:59.9253 793 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.56' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.56' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:37:59.9263 789 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.55' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:37:59.9293 1425 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.58') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.57' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:37:59.9293 797 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.55' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.55' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:37:59.9303 786 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.56' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.56' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:37:59.9333 785 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.59') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.57' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.57' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:37:59.9343 1430 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 21.37.58') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 22.37.56' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 22.37.56' and (resAreId = 1 or resAreId <= 0) nr: 0 16/08/2025 22:38:09.0614 13543 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 16/08/2025 22:38:09.0614 14311 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 16/08/2025 22:38:10.3863 8402 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '458837951500327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 16/08/2025 22:38:10.3863 11863 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 16/08/2025 22:38:15.2195 3431 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-16 22.38.11','V',5604253560080070,2025,'2025-08-16 22.05.16','458837951500327005031999',1,2,16,'I','',1,0,1,'','',4) 16/08/2025 22:38:15.5277 4694 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 16/08/2025 22:38:16.3263 7259 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/08/2025 22:38:16.7195 7511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 16/08/2025 22:38:17.3219 2087 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/08/2025 22:38:17.3219 1512 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/08/2025 22:38:20.3429 4015 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); 16/08/2025 22:38:20.3710 3650 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); 16/08/2025 22:38:21.2325 771 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/08/2025 22:38:21.2966 844 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 16/08/2025 22:39:02.2223 22813 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 16/08/2025 22:39:07.6179 565 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 16/08/2025 22:39:22.3579 503 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 16/08/2025 22:39:22.9763 578 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '458837796000327005012999' 16/08/2025 22:41:56.5500 2442 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 16/08/2025 23:09:03.4223 567 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-08-16 23.09.02' where payTraUID = 5705121017299070 and payStatus='V' and payEnabled=1 16/08/2025 23:09:23.5153 1804 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 16/08/2025 23:11:11.1855 1446 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 16/08/2025 23:21:20.1732 18604 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 16/08/2025 23:21:20.2303 18644 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 73 ms.) 16/08/2025 23:21:20.2363 18615 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 75 ms.) 16/08/2025 23:21:21.0188 509 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 16/08/2025 23:21:21.1439 605 ms. EXEC: CREATE TABLE IF NOT EXISTS tabTimeZones(timId int(11) not null auto_increment,timCreation DATETIME not null default '0000-00-00',timModify TIMESTAMP not null,timUseId int(11) not null default 0,timStatus varchar(1) not null default 'V',timRegion varchar(5) not null default '',timIdWindows varchar(100) not null default '',timIdLinux varchar(100) not null default '', PRIMARY KEY (timId)) ENGINE=InnoDB DEFAULT CHARSET=utf8; 16/08/2025 23:21:22.1656 734 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 2 AND extPlateWaitOperator=0 16/08/2025 23:21:22.4608 950 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'EUR' 16/08/2025 23:21:22.6079 1138 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 16/08/2025 23:21:22.6139 1180 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 16/08/2025 23:21:23.4095 1470 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'EUR' (WAIT TIME 109 ms.) 16/08/2025 23:21:23.4115 511 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 0))) order by tagName (WAIT TIME 101 ms.) 16/08/2025 23:21:23.4135 851 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 0 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' (WAIT TIME 101 ms.) 16/08/2025 23:21:23.4145 1819 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 112 ms.) 16/08/2025 23:21:23.4165 1819 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 116 ms.) 16/08/2025 23:21:23.4175 1812 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 116 ms.) 16/08/2025 23:21:23.4195 1946 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 0))) order by tagName (WAIT TIME 114 ms.) 16/08/2025 23:21:23.4215 1838 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 117 ms.) 16/08/2025 23:21:23.4355 635 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 1 ms.) 16/08/2025 23:21:23.6777 869 ms. OPEN: select * from tabParameters order by parId desc limit 1 16/08/2025 23:21:24.2361 562 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 16/08/2025 23:21:24.2391 825 ms. OPEN: select * from tabUser where useStatus='V' and useBadId<>'' and useParkAccess<>0 order by useSuperUser desc,useId 16/08/2025 23:21:24.2401 825 ms. OPEN: select * from payCurInventory where curTerId = 0 order by curDevCode,curChannelId,curValue,curType,curAmount desc 16/08/2025 23:21:24.2431 750 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',5 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 5 and curType = 'N' LIMIT 1) 16/08/2025 23:21:24.4352 742 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 16/08/2025 23:21:24.4372 743 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 16/08/2025 23:21:24.8535 516 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-16 22.21.24') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-16 23.21.21' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-16 23.21.21' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 93 ms.) 16/08/2025 23:21:25.5977 578 ms. EXEC: insert into payCurInventory (curTerId,curDevCode,curDevDescription,curChannelId,curChannelDescr,curValue,curType) SELECT * FROM (SELECT 3,42101,'Notes Escrow',1 as c1,'Payout',10 as v1,'N') as tmp WHERE NOT EXISTS ( SELECT curDevCode,curTerId,curChannelId,curValue FROM payCurInventory WHERE curDevCode = 42101 and curChannelId = 1 and curTerId = 3 and curValue = 10 and curType = 'N' LIMIT 1) (WAIT TIME 40 ms.) 16/08/2025 23:21:36.5343 12804 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 16/08/2025 23:21:36.5353 11567 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 (WAIT TIME 1 ms.) 16/08/2025 23:21:38.8969 670 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 16/08/2025 23:21:40.0767 3291 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 16/08/2025 23:21:40.3829 1239 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 = '0230003944086' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 16/08/2025 23:21:41.5747 1474 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-16 23.21.40','V',5162022322971820,2025,'2025-08-16 23.20.54','0098788191894',2,1,2,'O','',1,0,1,'','',0) 16/08/2025 23:21:43.4119 1956 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 16/08/2025 23:21:44.2885 3904 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 = '0230003944086' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 16/08/2025 23:21:46.7637 1764 ms. OPEN: show columns from movoperator where Field = 'opeQuery' 16/08/2025 23:21:47.5532 551 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 subStatus='V' and cusStatus='V' and (carCode = '0230003944086') (WAIT TIME 1 ms.) 16/08/2025 23:22:23.8129 29958 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 16/08/2025 23:22:27.9056 538 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 16/08/2025 23:25:10.3984 2296 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 16/08/2025 23:34:50.1873 504 ms. OPEN: select * from payreceipt where recPayUID = 5386611211549510 and recStatus='V' 16/08/2025 23:34:52.1731 537 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-08-16 23.34.51',4,1,'2025-08-16 23.34.51','458837961200327005031999','Payed (Credit Card ) Ticket ')