10/03/2025 14:15:31.3987 5259 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 10/03/2025 14:15:31.5588 5418 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/03/2025 14:15:31.5598 5418 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/03/2025 14:15:31.5598 5419 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/03/2025 14:15:31.5608 5419 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/03/2025 14:15:31.5608 5420 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/03/2025 14:15:31.5618 5421 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/03/2025 14:15:31.5618 5421 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/03/2025 14:15:31.5628 5422 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/03/2025 14:15:31.5648 5424 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/03/2025 14:15:31.5648 5424 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/03/2025 14:15:31.5658 5425 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/03/2025 14:15:31.5658 5425 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/03/2025 14:15:31.5668 5426 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/03/2025 14:15:31.5668 5426 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/03/2025 14:15:31.5678 5427 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/03/2025 14:15:31.5678 5427 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/03/2025 14:15:31.5688 5428 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/03/2025 14:15:31.5688 5428 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/03/2025 14:15:31.5698 5429 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/03/2025 14:15:31.5718 5431 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/03/2025 14:15:31.5728 5432 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/03/2025 14:15:31.6399 5499 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/03/2025 14:15:31.6409 5500 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/03/2025 14:15:32.2773 501 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' 10/03/2025 14:15:33.5461 1119 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 2 (WAIT TIME 7 ms.) 10/03/2025 14:15:33.5471 1098 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 2 (WAIT TIME 3 ms.) 10/03/2025 14:15:33.5471 1100 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 2 (WAIT TIME 4 ms.) 10/03/2025 14:15:33.5481 978 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 16 AND extPlateWaitOperator=0 (WAIT TIME 8 ms.) 10/03/2025 14:15:33.5481 1123 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 1 (WAIT TIME 6 ms.) 10/03/2025 14:15:33.5851 561 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 10/03/2025 14:15:40.4758 1714 ms. OPEN: select * from tabClass where claPosition = 2 and claStatus='V' 10/03/2025 14:15:46.2357 11556 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 10/03/2025 14:15:46.3567 10962 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457245124500327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 10/03/2025 14:15:46.4128 7956 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '880170' and traDirection='I' order by traId DESC LIMIT 1 10/03/2025 14:15:46.4958 5656 ms. OPEN: select traCode from movTransit where traCode ='457245133900327005012999' 10/03/2025 14:15:50.2513 2479 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-03-10 14:15:47','V',4890611590724070,2025,'2025-03-10 14:14:05','457245124500327005031999',1,2,16,'I','',1,0,1,'','',4) 10/03/2025 14:15:50.2513 2483 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-03-10 14:15:47','V',5252825020714630,2025,'2025-03-10 14:14:05','457245124500327005031999',1,2,16,'I','',1,0,1,'','',4) 10/03/2025 14:15:50.2523 620 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-03-10 14:15:49','V',4885213051692590,2025,'2025-03-10 14:14:05','457245124500327005031999',1,2,16,'I','',1,0,1,'','',4) 10/03/2025 14:15:50.2523 2485 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-03-10 14:15:47','V',5053780235990100,2025,'2025-03-10 14:15:39','457245133900327005012999',1,2,16,'I','',1,0,1,'','',4) 10/03/2025 14:15:51.6683 919 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 10/03/2025 14:15:52.0746 1809 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/03/2025 14:15:52.0756 1809 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/03/2025 14:15:55.5549 8779 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/03/2025 14:15:56.7987 4568 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 = '457245133900327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 10/03/2025 14:15:56.8047 5076 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 = '457244813500327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 10/03/2025 14:16:00.5312 4974 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); 10/03/2025 14:16:01.4748 819 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/03/2025 14:16:14.6577 1111 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4852794052512590,5422417652815280,2025,'2025-03-10 14:16:13',' Data: 3/10/2025 2:13:22 PM Codice: 457244451400327005012999 Ingresso: 3/10/2025 12:21:54 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 0.00 KES ______________________________ Pagato: 0.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 ',1) 10/03/2025 14:21:54.0777 1450 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 28 order by traDateTime desc,traId desc 10/03/2025 14:27:34.9684 1431 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 10/03/2025 14:56:02.4814 537 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-03-10 14:56:01','V',5216293525970190,2025,'2025-03-10 14:56:01','457245294400327001012999',2,2,2,'O','',0,'2025-03-10 14:56:01',1,'','',0) 10/03/2025 14:59:18.8266 571 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 10/03/2025 15:19:02.6822 502 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 151 order by traDateTime desc,traId desc 10/03/2025 15:23:23.2277 2965 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 10/03/2025 15:52:50.0940 1514 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 10/03/2025 15:59:34.9300 812 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 10/03/2025 16:18:04.9306 801 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 10/03/2025 17:31:16.1001 653 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 10/03/2025 17:32:27.6832 1571 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 10/03/2025 17:57:03.5847 12748 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 10/03/2025 18:26:01.1018 973 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 10/03/2025 19:13:13.8560 1333 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