18/12/2024 11:47:56.2520 505 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 18/12/2024 11:47:56.2660 14040 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 18/12/2024 11:47:56.2670 14416 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 18/12/2024 11:47:56.2680 3782 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 18/12/2024 11:47:56.4271 2934 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 18/12/2024 11:47:56.8114 543 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/12/2024 11:47:56.8114 544 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/12/2024 11:47:56.8154 549 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/12/2024 11:47:58.3354 1519 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 18/12/2024 11:47:58.8347 545 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 18/12/2024 11:47:59.2130 501 ms. OPEN: select * from tabuser where useStatus='V' order by useId 18/12/2024 11:47:59.2140 916 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 18/12/2024 11:47:59.2180 506 ms. OPEN: select * from tabuser where useStatus='V' order by useId 18/12/2024 11:48:16.2814 16873 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/12/2024 11:48:21.3637 4695 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/12/2024 11:48:25.4845 4119 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); 18/12/2024 11:48:26.3361 702 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/12/2024 11:49:01.2538 1275 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 803861 18/12/2024 11:49:01.8962 624 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 = '456424169100327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/12/2024 11:53:10.7009 827 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,'2024-12-18 11:53:09','V',5032587547192310,2024,'2024-12-18 11:39:21','456424132500327005029999',2,2,16,'I','',1,0,1,'','0532370677173',31,0) 18/12/2024 11:54:08.3651 2384 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 18/12/2024 11:54:24.0774 1023 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 125 order by traDateTime desc,traId desc 18/12/2024 11:54:42.5050 1527 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 111 order by traDateTime desc,traId desc 18/12/2024 12:00:58.3101 1159 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 18/12/2024 12:01:09.6967 4633 ms. OPEN: select traBadge from movTransit where traDateTime >= '2024-12-18 11:59:05' and traDateTime < '2024-12-18 12:01:03' and traDirection = 'O' and traIdTerminal = 2 and traCarId = 99 18/12/2024 12:01:14.4509 4414 ms. OPEN: select * from movtransit where traUID = 4690001765102090 and traStatus='V' 18/12/2024 12:01:19.2020 4554 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/12/2024 12:01:23.9742 4612 ms. OPEN: select * from movTransit where traStatus = 'V' and traCode='456423313800327005012999' and traBadge = '0750009518612' order by traId desc limit 1 18/12/2024 12:01:23.9792 4350 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/12/2024 12:01:28.7044 4590 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/12/2024 12:01:28.9706 4748 ms. OPEN: select * from tabTariff left join tabtlkTariff on tlkTarId = tarId where (tarValidFrom <= '2024-12-18' and tarValidTo >= '2024-12-18' and tarStatus='V' and tlkAreId = 1 and tlkStatus='V') and (((tarIdClass = 2 or tarIdClass <=0) and tarEnabled <> 0) or tarDefault<>0) order by tarModify desc,tarId desc 18/12/2024 12:01:33.4836 4433 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 35 ms.) 18/12/2024 12:01:33.5006 4439 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 (WAIT TIME 33 ms.) 18/12/2024 12:08:45.3331 3948 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 18/12/2024 12:08:45.3931 23938 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 85 ms.) 18/12/2024 12:08:45.3951 3760 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 86 ms.) 18/12/2024 12:08:47.3175 1559 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/12/2024 12:08:47.3175 1563 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/12/2024 12:08:47.3355 1578 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/12/2024 12:08:47.3365 1579 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 18/12/2024 12:08:47.3385 1575 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/12/2024 12:08:47.3385 1581 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/12/2024 12:08:47.3405 1585 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 18/12/2024 12:08:47.7618 1075 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 18/12/2024 12:08:47.9560 1134 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId (WAIT TIME 135 ms.) 18/12/2024 12:08:49.6882 1481 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 (WAIT TIME 373 ms.) 18/12/2024 12:09:00.3452 10653 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0322132065812' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/12/2024 12:09:02.1675 14257 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/12/2024 12:09:03.3113 2210 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,'2024-12-18 12:09:01','V',4868489931129160,2024,'2024-12-18 12:01:13','456424132700327002029999',2,1,2,'O','',1,0,1,'','1742685209108',99,0) 18/12/2024 12:09:04.4531 1130 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/12/2024 12:09:07.6494 5226 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/12/2024 12:09:12.2753 4625 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); 18/12/2024 12:09:55.5822 5261 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 = '456423972100327001012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/12/2024 12:13:10.6389 2127 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 18/12/2024 12:14:11.0518 2723 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 18/12/2024 12:22:06.6605 1344 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 18/12/2024 12:59:16.9629 2440 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 18/12/2024 14:07:41.6334 20118 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 18/12/2024 14:07:54.6617 11877 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/12/2024 14:07:59.1716 4287 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/12/2024 14:08:01.7912 6233 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '803826' and traDirection='I' order by traId DESC LIMIT 1 18/12/2024 14:08:01.7922 6685 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456424502200327005012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/12/2024 14:08:01.8852 2713 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); 18/12/2024 14:08:05.0792 1023 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 = '456424001100327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/12/2024 14:08:05.3224 3386 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 17 and payDateTime = '2024-12-18 13:59:24' nr: 0 18/12/2024 14:08:06.8644 722 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-18 14:08:06',17,1,'2024-12-18 14:08:06','456424502200327005012999','Pagato (Contanti ) Biglietto ') 18/12/2024 14:08:08.2274 602 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5459606632686410,5425465038680230,2024,'2024-12-18 14:08:07',' Data: 12/18/2024 1:59:24 PM Codice: 456424502200327005012999 Ingresso: 12/18/2024 12:30:22 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) 18/12/2024 14:08:25.8580 1164 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/12/2024 14:16:01.7998 3814 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 18/12/2024 14:17:35.5204 565 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-18 14:17:34' where traUID = 4754263972644470 and traStatus='V' and traEnabled=1 18/12/2024 14:21:01.2327 578 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-12-18 14:21:00','V',5372909102002990,2024,'2024-12-18 14:20:59','456420001000327003229999',22,22,3,'I','',1,0,1,'','',2) 18/12/2024 14:25:44.8890 675 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-12-18 14:25:44',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 18/12/2024 23:14:32.8524 3008 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'