21/02/2025 09:17:36.6850 4738 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 21/02/2025 09:17:46.1513 4673 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 21/02/2025 09:17:46.2014 4725 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/02/2025 09:22:06.5277 4742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/02/2025 09:22:57.9830 1537 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/02/2025 09:24:40.4483 1269 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/02/2025 09:24:59.8213 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/02/2025 09:25:40.2002 2461 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-02-21 08:25:37') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-02-21 09:25:37' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-02-21 09:25:37' and (resAreId = 1 or resAreId <= 0) nr: 0 21/02/2025 09:26:01.7095 6534 ms. EXECSCALAR: select claId from tabClass where claPosition = 2 and claStatus='V' nr: 2 21/02/2025 09:29:10.1672 4666 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/02/2025 09:29:14.9153 2522 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/02/2025 09:29:24.4606 1985 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/02/2025 09:29:29.2137 1647 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/02/2025 09:29:38.6639 4729 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/02/2025 09:54:10.9589 539 ms. EXEC: update payReceipt set recCreation = '2025-02-21 09:54:10',recModify = '2025-02-21 09:54:10',recUseId=0,recStatus='V' where recId = 353777 21/02/2025 10:19:02.6665 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/02/2025 10:20:06.8962 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/02/2025 10:27:28.3438 4744 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 16 21/02/2025 10:27:32.4806 4007 ms. OPEN: select * from tabTerminal where terStatus = 'V' and terAddress = 3 21/02/2025 10:28:19.0349 3201 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/02/2025 10:41:43.8013 3938 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 21/02/2025 10:41:53.3407 4642 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,'2025-02-21 10:41:48','V',5208479558866460,2025,'2025-02-21 10:41:48','457073850800327005012999',1,2,16,'I','',1,0,1,'','0230003939927',164,0) 21/02/2025 10:41:58.0289 4684 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/02/2025 10:42:12.3305 14270 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/02/2025 10:42:17.7152 649 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 21/02/2025 10:42:18.5377 562 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 (WAIT TIME 11 ms.) 21/02/2025 10:42:26.7262 3735 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 21/02/2025 10:42:39.3247 809 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-02-21 10:42:38',0,'V',5740928478792920,5195535527876450,2025,'2025-02-21 10:42:38',2,1,0,-1,'2025-02-21 11:42:38','S','KES',0,0,0,'','','',3,0,0) 21/02/2025 10:42:41.6363 2100 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 21/02/2025 10:42:42.1847 1073 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 21/02/2025 10:42:42.2107 1018 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 21/02/2025 10:42:45.5579 2598 ms. OPEN: show columns from payPayment where Field = 'payClosePeriod' 21/02/2025 10:42:45.5689 2299 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/02/2025 10:42:47.9165 929 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,'2025-02-21 10:42:46','V',5323512765939070,2025,'2025-02-21 10:42:13','457073810000327002029999',2,1,2,'O','',1,0,1,'','0532370834279',12,0) 21/02/2025 10:42:47.9736 943 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 21/02/2025 10:49:14.2957 4150 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/02/2025 10:49:28.4892 935 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/02/2025 10:50:12.0823 41251 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/02/2025 10:50:40.0870 27784 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-02-21 10:49:44',0,'V',5552787559330650,5533350402413490,2025,'2025-02-21 10:49:44',3,1,0,4,'2025-02-21 11:04:44','C','KES',200,600,400,'',' ',' ',1,200,0,0,'',0,0) 21/02/2025 10:51:30.7388 50422 ms. EXEC: update paycash set casCreation = '2025-02-21 10:50:40',casModify = '2025-02-21 10:50:40',casUseId=0,casStatus='V' where casId = 210110 21/02/2025 10:51:54.5106 8771 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 21/02/2025 10:54:05.0697 14236 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 21/02/2025 10:55:23.2239 4729 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-02-21 10:55:18','V',5021182791849650,2025,'2025-02-21 10:55:13','457070000400327003229999',22,22,3,'I','',1,0,1,'','',2) 21/02/2025 10:55:27.9730 4650 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 21/02/2025 10:55:28.0221 4700 ms. OPEN: SELECT * FROM tabuser WHERE useBadId<>'' AND (useBadId = '300211' OR useBadId = '300211') 21/02/2025 10:55:37.5774 9528 ms. OPEN: select * from movtransit t where traCode = '300211' and t.traStatus='V' and t.traDirection='I' and (t.traAreId = 1 OR t.traAreid = 0) order by t.traId desc limit 1 21/02/2025 10:55:56.5411 1050 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 21/02/2025 10:56:21.7699 4682 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-02-21 10:56:17','V',4949740048623860,2025,'2025-02-21 10:56:13','457073937300327005012999',1,2,16,'I','',1,0,1,'','',4) 21/02/2025 10:56:36.0254 4661 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-02-21 10:56:31',0,16,'2025-02-21 10:56:31','','Unauthorized Transit Entry 2') 21/02/2025 10:56:45.5608 4502 ms. EXECSCALAR: select claId from tabClass where claPosition = 2 and claStatus='V' nr: 2 21/02/2025 10:56:55.0191 4670 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 21/02/2025 11:04:34.5029 580 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/02/2025 11:29:34.2505 4700 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 21/02/2025 11:29:48.5220 14216 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/02/2025 11:29:52.9806 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 21/02/2025 11:32:46.2789 2723 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2025-02-21 11:32:43','0560008529778',0,0,4752726292990150,171,'0000-00-00 00:00:00','0000-00-00 00:00:00') 21/02/2025 11:33:06.4864 20165 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2025-02-21 11:32:46',0,'V',4752726292990150,4695123097274780,2025,'2025-02-21 11:32:46',2,1,0,-1,'2025-02-21 12:32:46','S','KES',0,0,0,'','','',3,0,0) 21/02/2025 11:33:11.2506 4744 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,'2025-02-21 11:33:06','V',5273309177604350,2025,'2025-02-21 11:32:43','457073359300327005012999',2,2,2,'O','',0,'2025-02-21 11:33:06',1,'','0560008529778',171,0) 21/02/2025 11:33:17.1475 4937 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-02-21 11:33:12' where traUID = 4695123097274780 and traStatus='V' and traEnabled=1 21/02/2025 11:33:24.2743 7068 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 21/02/2025 11:33:25.5021 8299 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 21/02/2025 11:33:26.1846 624 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 21/02/2025 11:33:26.1856 618 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 21/02/2025 11:45:54.9092 4673 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 21/02/2025 11:45:59.6605 4577 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,'2025-02-21 11:45:55','V',5270899876942440,2025,'2025-02-21 11:45:47','457074234700327001012999',1,2,1,'I','',1,0,1,'','0230004098588',183,0) 21/02/2025 11:46:04.4097 4594 ms. EXEC: update abbCards set carLastDate = '2025-02-21 11:45:59',carLastDirection='I' where carStatus='V' and carId = 183 21/02/2025 14:40:00.9454 587 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-02-21 14:40:00' where payTraUID = 5723690098945800 and payStatus='V' and payEnabled=1 21/02/2025 15:16:51.9991 1561 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-02-21 15:16:50','V',5646871192820100,2025,'2025-02-21 15:16:50','457075501000327001012999',1,2,1,'I','',1,0,1,'','',4) 21/02/2025 16:23:31.0116 508 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 21/02/2025 17:32:58.0018 512 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-02-21 17:32:57','V',5075448726794120,2025,'2025-02-21 17:32:57','457076317700327005012999',1,2,16,'I','',1,0,1,'','',4)