23/02/2024 09:29:22.0297 3295 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 23/02/2024 09:29:24.8124 1371 ms. OPEN: show columns from movoperator where Field = 'opeQuery' 23/02/2024 09:29:26.3633 3563 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 23/02/2024 09:29:27.4801 4096 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '453433385100327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/02/2024 09:29:29.2861 505 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 23/02/2024 09:29:29.8616 3495 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/02/2024 09:29:30.5996 1917 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,'2024-02-23 09:29:28','V',5235221980246630,2024,'2024-02-23 09:24:11','453433385100327005031999',1,2,16,'I','',1,0,1,'','',4) 23/02/2024 09:29:32.1907 1580 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/02/2024 09:29:34.2241 4862 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 = '453433276900327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 23/02/2024 09:29:38.7123 4424 ms. OPEN: select * from payreceipt where recPayUID = 5299231149846760 and recStatus='V' 23/02/2024 09:29:39.5288 9667 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); 23/02/2024 09:29:40.4132 602 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/02/2024 09:29:41.4326 1007 ms. EXECSCALAR: select count(*) from tabTables where tabId = 30 and tabTxtValue='22' and tabTable = 'devAction' nr: 0 23/02/2024 09:29:41.5186 680 ms. OPEN: select * from tabRoutes inner join tabAbbGroups on rouAbgId = abgId where rouStatus='V' and rouAbgId = 99999 23/02/2024 09:29:43.0597 873 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 = '453433276900327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 23/02/2024 09:29:43.9082 569 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,'2024-02-23 09:29:43','V',5251261973736150,2024,'2024-02-23 09:29:07','453433414700327005031999',1,2,16,'I','',1,0,1,'','',4) 23/02/2024 09:29:44.4736 559 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/02/2024 09:29:44.4936 1432 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 23/02/2024 09:30:52.8048 7163 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 = 6 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 23/02/2024 09:32:24.1018 1469 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 23/02/2024 10:05:37.3157 625 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-02-23 10:05:36' where traUID = 4965814662172450 and traStatus='V' and traEnabled=1 23/02/2024 10:15:45.3588 584 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 23/02/2024 10:18:03.2232 579 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 23/02/2024 10:30:03.8597 825 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 23/02/2024 11:00:31.7856 508 ms. EXEC: update payInventory set invCreation = '2024-02-23 11:00:31',invModify = '2024-02-23 11:00:31',invUseId=0,invStatus='V' where invId = 166270