15/11/2024 07:46:54.2985  3319 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'
15/11/2024 07:46:54.9299   677 ms.     EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1
15/11/2024 07:46:54.9309   623 ms.           OPEN: select * from tabarea where areStatus='V' and areId = 1
15/11/2024 07:46:58.9446   550 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
15/11/2024 07:49:34.6156  1438 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
15/11/2024 07:49:56.2541   533 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
15/11/2024 07:50:06.8201   779 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-11-15 07:50:06','V',4845532995271990,2024,'2024-11-15 07:50:04','456092820400327005012999',1,2,16,'I','',1,0,1,'','0230003950907',19,0)
15/11/2024 11:46:57.2686  4404 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'
15/11/2024 11:46:57.3327  1504 ms.     EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1
15/11/2024 11:46:58.3663   549 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 320 ms.)
15/11/2024 11:46:59.3200   628 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
15/11/2024 16:55:53.6924  3148 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'
15/11/2024 16:55:54.3649   648 ms.     EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0
15/11/2024 16:55:55.4486  1802 ms.     EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1
15/11/2024 16:55:55.9419   562 ms.           OPEN: show columns from tabParameters where Field = 'parUseCulture'
15/11/2024 16:56:55.7008  1706 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 16:56:53' where traUID = 4731771222615910 and traStatus='V' and traEnabled=1
15/11/2024 16:57:38.9097  1427 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
15/11/2024 17:48:26.7211  3038 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'
15/11/2024 17:48:27.4415   581 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
15/11/2024 17:49:26.4119  1110 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
15/11/2024 17:49:44.0087  1183 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-15 17:49:42' where traUID = 4720544442685830 and traStatus='V' and traEnabled=1
15/11/2024 17:53:41.8156   622 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 ('2024-11-15 17:53:41',0,'V',4919888270923360,5640737721770440,2024,'2024-11-15 17:53:41',2,1,0,-1,'2024-11-15 18:53:41','S','KES',0,0,0,'','','',3,0,0)
15/11/2024 17:53:45.2699  1747 ms.           OPEN: select * from tabTerminal where terId = 2
15/11/2024 17:54:49.2356   550 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
15/11/2024 17:55:47.7697   864 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
15/11/2024 18:03:33.6400   984 ms.           OPEN: select sum(crc32(mesDescription)) as vCheck from tabMessage
15/11/2024 18:08:29.3996  1410 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
15/11/2024 18:08:29.3996  1410 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3)
15/11/2024 18:09:51.8107   602 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 ('2024-11-15 18:07:12',6,'V',5546639119846230,5406132711708880,2024,'2024-11-15 18:07:12',4,1,0,4,'2024-11-15 18:22:12','P','KES',50,50,0,'','','',1,50,0,0,'',0,0)
15/11/2024 18:11:02.5309   683 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
15/11/2024 18:11:05.6630   859 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-11-15 18:11:04','V',5048505673228780,2024,'2024-11-15 18:11:04','456096266000327005012999',2,2,2,'O','',0,'2024-11-15 18:11:04',1,'','',0)