31/01/2024 10:33:22.4495 2407 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2024 10:33:22.4636 2405 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 31/01/2024 10:33:22.4666 5141 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 31/01/2024 10:33:22.9889 522 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2024 10:33:22.9909 501 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2024 10:33:22.9929 505 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2024 10:33:22.9949 507 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 31/01/2024 10:33:23.0509 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 37 ms.) 31/01/2024 10:33:24.4759 1358 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2024 10:33:24.4769 1326 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 31/01/2024 10:33:24.4779 850 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/01/2024 10:33:24.4789 849 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/01/2024 10:33:24.4799 850 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/01/2024 10:33:25.1754 1454 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitId' nr: 1 31/01/2024 10:33:25.1754 2053 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 31/01/2024 10:33:25.1764 2039 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 31/01/2024 10:33:25.1774 1017 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/01/2024 10:33:25.5416 1377 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/01/2024 10:33:25.5416 1374 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/01/2024 10:33:25.5426 1320 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/01/2024 10:33:25.5456 1256 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/01/2024 10:33:25.5486 887 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 31/01/2024 10:33:25.5696 1407 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 31/01/2024 10:33:26.1790 998 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1 31/01/2024 10:33:26.8685 682 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 31/01/2024 10:33:26.8695 682 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 31/01/2024 10:33:26.8695 683 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 31/01/2024 10:33:26.8705 680 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 31/01/2024 10:33:26.8705 684 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 31/01/2024 10:33:26.8715 685 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 31/01/2024 10:33:26.8725 684 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 31/01/2024 10:33:26.8805 690 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 31/01/2024 10:33:26.8805 691 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 31/01/2024 10:33:26.8815 691 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 31/01/2024 10:33:26.8895 709 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 31/01/2024 10:33:27.0106 1375 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 31/01/2024 10:33:28.3535 520 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-01-31 09:33:27') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-01-31 10:33:26' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-01-31 10:33:26' and (resAreId = 1 or resAreId <= 0) nr: 0 31/01/2024 10:33:28.3545 519 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-01-31 09:33:27') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-01-31 10:33:26' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-01-31 10:33:26' and (resAreId = 1 or resAreId <= 0) nr: 0 31/01/2024 10:33:28.3545 519 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-01-31 09:33:27') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-01-31 10:33:26' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-01-31 10:33:26' and (resAreId = 1 or resAreId <= 0) nr: 0 31/01/2024 10:33:28.3605 522 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-01-31 09:33:27') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-01-31 10:33:26' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-01-31 10:33:26' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 5 ms.) 31/01/2024 10:33:28.3625 523 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-01-31 09:33:27') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-01-31 10:33:26' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-01-31 10:33:26' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 6 ms.) 31/01/2024 10:33:28.3635 522 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-01-31 09:33:27') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-01-31 10:33:26' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-01-31 10:33:26' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 7 ms.) 31/01/2024 10:33:36.3418 8642 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788198704' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 31/01/2024 10:33:36.3448 7400 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '453203783600327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 31/01/2024 10:33:36.4058 11230 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '534904' and traDirection='I' order by traId DESC LIMIT 1 31/01/2024 10:33:37.9470 643 ms. OPEN: show columns from movRoutes where Field = 'rtsCarId' 31/01/2024 10:33:38.6216 667 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370684208' and traDirection='I' order by traId desc limit 1 31/01/2024 10:33:38.7807 824 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 31/01/2024 10:33:41.2016 576 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 31/01/2024 10:33:41.2026 780 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 1 ms.) 31/01/2024 10:33:41.2026 579 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 31/01/2024 10:33:41.2036 782 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 31/01/2024 10:33:41.2046 13973 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 31/01/2024 10:33:41.5158 2263 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-01-31 10:33:39','V',4821273393610370,2024,'2024-01-30 15:54:10','453198628700327002029999',2,1,2,'O','',1,0,1,'','0532370684208',20,0) 31/01/2024 10:33:41.7599 2174 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-01-31 10:33:39','V',4630758678611150,2024,'2024-01-31 10:30:36','453203783600327005031999',1,2,16,'I','',1,0,1,'','',4) 31/01/2024 10:33:42.6225 1006 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 31/01/2024 10:33:43.5601 2034 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2024 10:33:43.5611 1971 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2024 10:33:43.5621 1674 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2024 10:33:43.8373 1192 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '453203742700327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 31/01/2024 10:33:47.3767 5946 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2024 10:33:49.2089 5370 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 = '453203742700327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 31/01/2024 10:33:51.9217 4545 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); 31/01/2024 10:33:52.8143 1782 ms. OPEN: select * from payreceipt where recPayUID = 5235984415267340 and recStatus='V' 31/01/2024 10:34:16.3790 545 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 106 order by traDateTime desc,traId desc 31/01/2024 10:34:36.5155 7900 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 = 12 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 31/01/2024 10:38:33.4108 1619 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 31/01/2024 10:48:25.8477 532 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 31/01/2024 11:09:42.6144 509 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 3 and payDateTime = '2024-01-31 11:09:54' nr: 0 31/01/2024 11:17:50.2847 997 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 31/01/2024 11:18:38.6248 3450 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 31/01/2024 12:06:23.4190 602 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-01-31 12:06:22' where payTraUID = 4902987316153140 and payStatus='V' and payEnabled=1 31/01/2024 12:45:59.2744 637 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-01-31 12:45:58' where payTraUID = 5585429094890790 and payStatus='V' and payEnabled=1 31/01/2024 14:43:17.1480 528 ms. EXEC: update paycash set casCreation = '2024-01-31 14:43:16',casModify = '2024-01-31 14:43:16',casUseId=0,casStatus='V' where casId = 144265 31/01/2024 15:13:03.3619 647 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4967093369771780,5281419488191970,2024,'2024-01-31 15:13:02',' Data: 1/31/2024 3:12:15 PM Codice: 453205352000327005012999 Ingresso: 1/31/2024 2:52:00 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400600736 ',0)