27/10/2024 13:22:21.8386 10058 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 27/10/2024 13:22:21.9156 9427 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 27/10/2024 13:22:21.9166 9431 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/10/2024 13:22:21.9296 9432 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/10/2024 13:22:21.9516 9436 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 30 ms.) 27/10/2024 13:22:21.9707 9485 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 27/10/2024 13:22:22.0677 9462 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 119 ms.) 27/10/2024 13:22:22.0938 9462 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 145 ms.) 27/10/2024 13:22:22.1298 9464 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 180 ms.) 27/10/2024 13:22:22.4580 593 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 27/10/2024 13:22:22.4960 521 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.4970 580 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.4980 548 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.5000 547 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.5100 634 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 27/10/2024 13:22:22.5160 519 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.5270 520 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.5290 600 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.5300 614 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.6631 733 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.7572 684 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.7602 612 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:22.7612 672 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 27/10/2024 13:22:23.4506 646 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 27/10/2024 13:22:23.4907 661 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 27/10/2024 13:22:23.4917 661 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/10/2024 13:22:23.5037 612 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 27/10/2024 13:22:23.5047 600 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 27/10/2024 13:22:23.7819 521 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 27/10/2024 13:22:23.7909 531 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 (WAIT TIME 13 ms.) 27/10/2024 13:22:24.1791 1155 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 27/10/2024 13:22:25.3349 660 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2024-10-27 13:22:24',extBarrier = 0, extTerId = 16 (WAIT TIME 163 ms.) 27/10/2024 13:22:37.1688 12819 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 27/10/2024 13:22:37.9543 756 ms. EXEC: update payCurInventory set curType='C' where curType<>'C' and curValue = 5 and curDevCode in (41003,41002,41001,41101,41102,41103); 27/10/2024 13:22:39.5954 10782 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '455904794300327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 27/10/2024 13:22:41.5317 961 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 27/10/2024 13:22:42.6274 628 ms. OPEN: show columns from tabTariff where Field = 'tarTimeControlTimeBegin' 27/10/2024 13:22:45.5404 1999 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 27/10/2024 13:22:46.0807 3123 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-10-27 13:22:42','V',5133888074684630,2024,'2024-10-27 13:19:03','455904794300327005031999',1,2,16,'I','',1,0,1,'','',4) 27/10/2024 13:22:46.5430 8580 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 27/10/2024 13:22:48.2374 2145 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 27/10/2024 13:22:52.1610 5981 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 4 and payDateTime = '2024-10-27 13:17:02' nr: 0 27/10/2024 13:22:52.8255 663 ms. EXECSCALAR: SELECT COUNT(*) FROM payPayment INNER JOIN movTransit ON traUID = payTrauid WHERE payStatus='V' AND payPayed=0 AND payAmount=0 AND payDiscount = 100 AND payDiscountType = 1 AND traStatus='V' AND traEnabled = 1 AND traCode = '455904640500327005012999' nr: 0 27/10/2024 13:22:53.4769 6932 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); 27/10/2024 13:22:54.2214 678 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 27/10/2024 13:22:56.1057 2728 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-27 13:22:53',4,1,'2024-10-27 13:22:53','455904640500327005012999','Payed (Cash ) Ticket ') 27/10/2024 13:23:01.2451 1735 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4616131882729970,5396954435625720,2024,'2024-10-27 13:22:59',' Date: 10/27/2024 1:17:02 PM Code: 455904640500327005012999 Entry Date: 10/27/2024 12:53:25 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 0.00 KES ______________________________ Paid: 0.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: Manual Cashier 1 ',1) 27/10/2024 13:35:52.3273 560 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5572076126439150,4769548693055870,2024,'2024-10-27 13:35:51',' Data: 10/27/2024 1:34:03 PM Codice: 455904475300327005012999 Ingresso: 10/27/2024 12:25:53 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400606601 ',0) (WAIT TIME 52 ms.) 27/10/2024 13:38:22.8212 2517 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