09/02/2024 09:00:01.4137 2982 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 09/02/2024 09:00:02.3373 642 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3383 641 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3403 638 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3433 644 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3443 643 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3463 652 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3473 644 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3503 545 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3513 654 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3513 658 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3533 649 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3543 661 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3563 657 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3573 656 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3613 662 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3633 663 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3633 559 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3633 666 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3643 666 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3663 669 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3673 672 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3693 672 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:02.3703 669 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/02/2024 09:00:13.7209 8769 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '453293213300327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 09/02/2024 09:00:14.1362 11388 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 09/02/2024 09:00:14.8857 749 ms. EXEC: update payCurInventory set curType='C' where curType<>'C' and curValue = 5 and curDevCode in (41003,41002,41001,41101,41102,41103); 09/02/2024 09:00:14.8887 705 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabCardConversionRules' nr: 1 09/02/2024 09:00:16.8910 1304 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 09/02/2024 09:00:21.4080 3360 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-09 09:00:18','V',5060968155025560,2024,'2024-02-09 08:55:34','453293213300327005031999',1,2,16,'I','',1,0,1,'','',4) 09/02/2024 09:00:25.2487 10361 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/02/2024 09:00:25.4399 4020 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/02/2024 09:00:30.2571 536 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 09/02/2024 09:00:33.4752 8226 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); 09/02/2024 09:00:34.5379 4219 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 = '453292714600327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 09/02/2024 09:01:45.0614 1888 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 09/02/2024 09:47:51.0617 763 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 09/02/2024 10:01:16.8471 923 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 09/02/2024 10:12:51.9702 508 ms. EXEC: update payInventory set invCreation = '2024-02-09 10:12:51',invModify = '2024-02-09 10:12:51',invUseId=0,invStatus='V' where invId = 162928 09/02/2024 10:20:15.1944 900 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 09/02/2024 10:34:47.7328 747 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 09/02/2024 10:40:39.3273 609 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc