18/11/2024 07:01:29.1543 1122 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 07:02:21.6053 584 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-18 07:02:21','V',5028144835512490,2024,'2024-11-18 07:02:19','456122533900327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 07:08:15.1976 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 07:21:43.1134 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 07:22:59.7666 688 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 07:23:24.4381 1966 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 07:36:43.4219 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 07:43:13.6166 539 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/11/2024 07:46:08.0091 1229 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 18/11/2024 07:51:34.2251 754 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-18 07:51:21',5,3,42101,0,50,-31,-1550,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-18 07:51:21',5,3,42101,0,50,31,1550,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-18 07:51:21',5,3,42101,0,100,-18,-1800,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-18 07:51:21',5,3,42101,0,100,18,1800,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-18 07:51:21',5,3,42101,0,200,-6,-1200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-18 07:51:21',5,3,42101,0,200,6,1200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-18 07:51:21',5,3,42101,0,500,-2,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-18 07:51:21',5,3,42101,0,500,2,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-18 07:51:21',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 18/11/2024 07:51:58.0640 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 49 ms.) 18/11/2024 07:53:20.0157 561 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-18 07:53:15',5,3,42101,0,50,5,250,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+5,5),curAmount=round(curAmount+250,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 18/11/2024 07:53:23.5841 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 07:55:26.6834 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 08:06:39.5059 2132 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 08:07:23.9546 867 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/11/2024 08:07:24.1007 720 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 08:07:32.7205 1203 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 08:10:56.0043 694 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 08:10:55',0,16,'2024-11-18 08:10:55','','Unauthorized Transit Entry 2') 18/11/2024 08:12:27.2893 763 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 08:12:26',0,16,'2024-11-18 08:12:26','','Unauthorized Transit Entry 2') 18/11/2024 08:17:34.7427 1273 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 08:19:42.6301 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 08:23:59.7519 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 08:26:45.7078 589 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-18 08:26:45','V',4801515080863580,2024,'2024-11-18 08:26:43','456123040300327005012999',1,2,16,'I','',1,0,1,'','0230003942254',18,0) 18/11/2024 08:28:17.7393 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 08:36:18.0792 503 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 18/11/2024 08:38:07.0550 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 08:39:37.6226 911 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-18 08:39:36','V',5058752013259540,2024,'2024-11-18 08:39:34','456122957300327005012999',2,2,2,'O','',0,'2024-11-18 08:39:36',1,'','',0) 18/11/2024 08:42:00.8292 1009 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 08:50:39.2636 519 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 18/11/2024 08:50:44.7213 873 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 08:50:43',0,16,'2024-11-18 08:50:43','','Unauthorized Transit Entry 2') 18/11/2024 08:54:31.7429 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 09:00:13.9906 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 09:06:45.2870 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 09:13:07.8196 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 09:13:21.5158 1471 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 18/11/2024 09:13:33.2186 899 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 09:14:00.3938 1540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 09:14:01.4114 898 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-18 09:14:00','V',5132130686580010,2024,'2024-11-18 09:13:59','456123323900327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 09:14:18.6249 510 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-18 09:14:18','V',5608719237529660,2024,'2024-11-18 09:14:16','456123325600327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 09:20:36.1782 736 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-18 09:20:35','V',5170983688060770,2024,'2024-11-18 09:20:33','456123363300327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 09:25:45.9452 1313 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-18 09:25:44','V',4734629361160080,2024,'2024-11-18 09:25:43','456123394300327005012999',1,2,16,'I','',1,0,1,'','0560008419314',195,0) 18/11/2024 09:25:49.8238 537 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/11/2024 09:27:12.3589 571 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-18 09:27:11',0,'V',5491834761269500,5592288762827090,2024,'2024-11-18 09:27:11',3,1,0,4,'2024-11-18 09:42:11','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 18/11/2024 09:29:06.9615 620 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-18 09:29:06','V',4890054883932890,2024,'2024-11-18 09:29:05','456123323900327005012999',2,2,2,'O','',0,'2024-11-18 09:29:06',1,'','',0) 18/11/2024 09:29:07.6049 640 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 09:29:48.5462 726 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 18/11/2024 09:31:47.1535 671 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 09:31:50.1585 1116 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 18/11/2024 09:32:34.7113 592 ms. OPEN: show columns from tabParameters where Field = 'parTicketCustomLine1' 18/11/2024 09:32:47.3097 1282 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 09:34:14.9362 501 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 18/11/2024 09:34:27.2034 917 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 09:35:24.2355 724 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-18 09:35:23',3,42101,0,50,2,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 18/11/2024 09:36:40.3874 1900 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5608719237529660,4937113612528400,2024,'2024-11-18 09:36:38','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/18/2024 9:14:16 AM Date : 11/18/2024 9:36:37 AM Code : 456123325600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 18/11/2024 09:36:41.1089 721 ms. EXEC: update payReceipt set recCreation = '2024-11-18 09:36:40',recModify = '2024-11-18 09:36:40',recUseId=0,recStatus='V' where recId = 323630 18/11/2024 09:38:04.6627 768 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 09:38:04.7308 1145 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 09:42:05.6577 651 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 09:42:25.8422 2215 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/11/2024 09:42:26.5597 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 09:43:55.3845 577 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 18/11/2024 09:44:09.5960 2562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 09:51:24.0223 1186 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 09:51:22',0,16,'2024-11-18 09:51:22','','Unauthorized Transit Entry 2') 18/11/2024 09:52:38.4740 1038 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 09:56:47.4035 958 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-18 09:56:46','V',5593872400451500,2024,'2024-11-18 09:56:44','456123457300327005012999',2,2,2,'O','',0,'2024-11-18 09:56:46',1,'','',0) 18/11/2024 09:56:53.7537 845 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/11/2024 09:57:44.7648 566 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-18 09:57:44','V',4914767627436140,2024,'2024-11-18 09:57:43','456123586300327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 09:58:38.2305 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 09:58:55.9093 940 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 09:59:39.2062 1459 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:00:50.6770 914 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 10:09:56.6318 986 ms. EXEC: update payInventory set invCreation = '2024-11-18 10:09:55',invModify = '2024-11-18 10:09:55',invUseId=0,invStatus='V' where invId = 219920 18/11/2024 10:11:29.8020 7942 ms. OPEN: select 1 as Tot,payUID,payPayed,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 = 6 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 18/11/2024 10:11:39.4355 588 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-18 10:11:38',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 18/11/2024 10:13:12.7488 711 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 2 ms.) 18/11/2024 10:14:08.7532 554 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-18 10:14:07',0,'V',4914073942217860,5196550903423870,2024,'2024-11-18 10:14:07',3,1,0,4,'2024-11-18 10:29:07','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 18/11/2024 10:17:27.5260 2366 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:17:31.5997 1023 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-18 10:17:30',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 18/11/2024 10:18:04.2996 791 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 10:21:01.8973 1539 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/11/2024 10:22:44.9721 2258 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:23:30.5806 2412 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 18/11/2024 10:23:30.5826 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:24:59.3429 534 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-18 10:24:58','V',5062606562411700,2024,'2024-11-18 10:24:58','456123749800327005012999',1,2,16,'I','',1,0,1,'','0230003943530',44,0) 18/11/2024 10:27:24.8811 3298 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-18 10:27:21',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 18/11/2024 10:27:26.3091 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:27:57.9442 1668 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/11/2024 10:28:59.1051 1191 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 10:36:36.9230 3209 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 18/11/2024 10:38:20.3020 708 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 10:38:42.1807 524 ms. OPEN: select * from tabParameters order by parId desc limit 1 18/11/2024 10:38:43.2804 680 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-18 10:38:42','V',4740499591721860,2024,'2024-11-18 10:38:40','456123653000327005012999',2,2,2,'O','',0,'2024-11-18 10:38:42',1,'','',0) 18/11/2024 10:39:10.4395 2894 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-18 10:39:06',0,'V',5460900249032320,5634342032769280,2024,'2024-11-18 10:39:06',3,1,0,4,'2024-11-18 10:54:06','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 18/11/2024 10:40:37.7058 986 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 10:41:23.4204 603 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 10:42:50.9839 909 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 10:43:31.3258 2540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:43:35.4326 2647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:43:35.4726 1409 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 39 ms.) 18/11/2024 10:44:01.5580 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:44:03.2622 975 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:44:12.7565 1897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:44:37.1268 5240 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:44:44.8760 1747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:44:47.6298 2418 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 18/11/2024 10:44:47.6849 1471 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:46:35.7361 519 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 18/11/2024 10:46:52.7224 531 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 10:47:07.3202 575 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 10:47:36.3486 711 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 18/11/2024 10:49:12.2827 2575 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 10:49:14.0638 590 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 10:50:16.5936 689 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:50:34.1784 532 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-18 10:50:33',0,0,'V',5390782712643150,5022907782098080,2024,'2024-11-18 10:50:33',3,'KES',-1,50,-50,'N',''); 18/11/2024 10:52:13.5057 3896 ms. EXEC: insert into payFiscalReport (fsrCreation,fsrModify,fsrUseId,fsrDateTime,fsrTerId,fsrType,fsrCode,fsrText) VALUES ('2024-11-18 10:52:09','2024-11-18 10:52:09',12,'2024-11-18 10:52:09',17,2,2024200287,' Z - REPORT The Mall Operatore: 12-Elizabeth Elizabeth Num. Operaz. : 2024200287 Data : 11/18/202410:52:09 AM Apertura Turno : 11/15/202410:05:24 AM Fine Turno : ______________________________ Totale Contanti : 2300.00 KES Totale Resti : 0.00 KES Totale Carte : 0.00 KES Importo Totale : 2300.00 KES ______________________________ IMPORTI 50.00 Qtà : 24 100.00 Qtà : 11 ______________________________ N.Op. : 35 Rinnovo Abbon. : 0 Biglietti Gratis : 0 Biglietti Smarriti : 0 Biglietti Giornalieri : 0 Bigl. Smarriti con Data : 0 ______________________________ ______________________________ Totale in Cassa 2300.00 KES ______________________________ ===== COPIA ===== ') 18/11/2024 10:54:27.4732 2600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:54:37.2638 1019 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:55:03.3242 1650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:55:03.3302 1655 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 18/11/2024 10:56:44.6109 1843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:57:03.9498 1536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:57:27.6326 675 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 10:58:12.1464 520 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 10:58:44.4730 654 ms. EXEC: update payReceipt set recCreation = '2024-11-18 10:58:43',recModify = '2024-11-18 10:58:43',recUseId=0,recStatus='V' where recId = 323669 18/11/2024 10:58:47.7611 3276 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-18 10:58:44',0,0,'V',5178630329041010,5075766865589380,2024,'2024-11-18 10:58:44',3,'KES',1,50,50,'N',''); 18/11/2024 10:58:47.9062 1788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 10:58:51.0804 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:11:11.6021 1203 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:16:48.3341 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:18:57.4104 1014 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-18 11:18:56','V',5549463969495500,2024,'2024-11-18 11:18:55','456123603200327005012999',2,2,2,'O','',0,'2024-11-18 11:18:56',1,'','',0) 18/11/2024 11:19:47.2066 1344 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/11/2024 11:19:57.4225 675 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 11:19:56',0,16,'2024-11-18 11:19:56','','Unauthorized Transit Entry 2') 18/11/2024 11:20:12.4905 566 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 372488 else acvFstPayId end),acvLstPayId = 372488 where acvSftId = 826 and acvCodeId = 3 18/11/2024 11:20:14.6820 761 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 11:20:14.8581 2157 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5235598795107570,4858168230841280,2024,'2024-11-18 11:20:12',' Data: 11/18/2024 11:17:57 AM Codice: 456123940200327005012999 Ingresso: 11/18/2024 10:56:42 AM 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 # 2400607236 ',0) 18/11/2024 11:24:12.2077 921 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:27:41.1953 1318 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 11:30:14.3406 652 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-18 11:30:13',9999,'open','Send command to entry/exit units: Command OPEN on Device Entry 2 ','') 18/11/2024 11:30:22.9134 1055 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 11:30:27.2523 605 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 18/11/2024 11:30:49.0348 1013 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5190071205509900,4846340492462460,2024,'2024-11-18 11:30:48','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/18/2024 10:54:51 AM Date : 11/18/2024 11:30:46 AM Code : 456123929100327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 500.00 KES Coin changed : 0.00 KES Note changed : 450.00 KES',0) 18/11/2024 11:30:57.8977 1346 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-18 11:30:56','V',5347297996484860,2024,'2024-11-18 11:30:55','456124145500327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 204 ms.) 18/11/2024 11:30:58.5602 530 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 11:30:59.1506 528 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 11:44:23.6531 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 11:46:29.3981 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:50:55.7871 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:51:53.9800 1916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:52:48.3903 1442 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/11/2024 11:53:57.1503 1248 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/11/2024 11:54:26.0546 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:55:00.8068 760 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 11:55:00',0,16,'2024-11-18 11:55:00','','Unauthorized Transit Entry 2') 18/11/2024 11:55:04.7965 730 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-18 11:55:04','V',5736717483359430,2024,'2024-11-18 11:55:03','456124290300327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 11:55:12.9799 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:55:16.9206 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:56:00.7178 1040 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 11:58:06.4919 1990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 11:58:27.8761 547 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-18 11:58:26',0,'V',4686577677086340,4830040290646900,2024,'2024-11-18 11:58:26',3,1,0,4,'2024-11-18 12:13:26','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 18/11/2024 11:58:28.4445 503 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4830040290646900,4686577677086340,2024,'2024-11-18 11:58:27','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/18/2024 11:19:41 AM Date : 11/18/2024 11:58:26 AM Code : 456124078100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 18/11/2024 11:58:29.5923 629 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-18 11:58:28',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 18/11/2024 12:00:24.9694 1520 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 12:00:23' where traUID = 5623001680199830 and traStatus='V' and traEnabled=1 18/11/2024 12:00:44.7816 755 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 12:01:01.9131 623 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-18 12:01:01','V',4728444309285920,2024,'2024-11-18 12:01:00','456124078100327005012999',2,2,2,'O','',0,'2024-11-18 12:01:01',1,'','',0) 18/11/2024 12:01:03.7543 1483 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-18 12:01:02' where payTraUID = 4830040290646900 and payStatus='V' and payEnabled=1 18/11/2024 12:01:04.6189 862 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 12:01:02' where traUID = 4830040290646900 and traStatus='V' and traEnabled=1 18/11/2024 12:01:23.4284 1781 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/11/2024 12:01:23.4575 817 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:01:52.0976 3478 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-18 12:01:48','V',5531606982986610,2024,'2024-11-18 12:01:47','456123989100327005012999',2,2,2,'O','',0,'2024-11-18 12:01:48',1,'','',0) 18/11/2024 12:02:06.1770 1899 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 12:05:39.1793 1384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:07:23.7592 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:07:39.1725 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:14:00.0930 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:14:35.6497 806 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 12:14:34' where traUID = 4907416574894010 and traStatus='V' and traEnabled=1 18/11/2024 12:14:37.3909 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 12:17:24.5066 579 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 12:20:08.2370 1406 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/11/2024 12:23:35.1672 671 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-18 12:23:34','V',5546538858753230,2024,'2024-11-18 12:23:34','456124461400327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 12:23:55.7880 1641 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 12:25:37.1447 1015 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 12:25:47.7268 1211 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:25:47.7268 1296 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 12:27:29.1686 1014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:30:32.6151 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:31:07.8657 650 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 18/11/2024 12:31:53.7503 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:41:21.8040 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:43:51.3741 869 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:46:47.6581 1121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:48:31.3471 513 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-18 12:48:30',0,'V',5676551101493230,5007605355118970,2024,'2024-11-18 12:48:30',18,1,0,4,'2024-11-18 13:03:30','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 18/11/2024 12:48:32.7451 1325 ms. EXEC: update tabTerminalReceipt set trcProgressive = 50118, trcLastPrinted = '2400750118', trcLastDate = '2024-11-18 12:48:31' where trcStatus='V' and trcTerId = 18 18/11/2024 12:48:51.4262 1718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:49:21.0702 893 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:52:07.9126 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 12:55:26.8270 631 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-18 12:55:26',9999,'open','Send command to entry/exit units: Command OPEN on Device Entry 2 ','') 18/11/2024 12:55:38.5331 3692 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 12:58:30.3281 659 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 12:58:29',17,12,'2024-11-18 12:58:29','456124461400327005012999','Pagato (Contanti ) Biglietto ') 18/11/2024 12:59:17.3563 742 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 12:59:17.4234 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:00:57.8703 644 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 13:01:48.7846 1014 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-18 13:01:47',0,0,'V',5079461906480380,5262758526128470,2024,'2024-11-18 13:01:47',3,'KES',1,50,50,'N',''); 18/11/2024 13:01:49.3480 563 ms. EXEC: update paycash set casCreation = '2024-11-18 13:01:48',casModify = '2024-11-18 13:01:48',casUseId=0,casStatus='V' where casId = 195538 18/11/2024 13:01:53.5078 2358 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 13:02:31.5679 2578 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 13:02:28' where traUID = 5622099161490520 and traStatus='V' and traEnabled=1 18/11/2024 13:02:45.6935 1044 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-18 13:02:44',0,'V',5398234926437300,5119750915919460,2024,'2024-11-18 13:02:44',18,1,0,4,'2024-11-18 13:17:44','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 18/11/2024 13:03:23.1241 1752 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 13:03:51.7786 1578 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 13:03:50',0,16,'2024-11-18 13:03:50','','Unauthorized Transit Entry 2') 18/11/2024 13:03:54.9087 1586 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 13:04:07.6414 2313 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:04:08.6451 514 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-18 13:04:08','V',5130798527327170,2024,'2024-11-18 13:04:05','456124641100327001012999',2,2,2,'O','',0,'2024-11-18 13:04:08',1,'','',0) 18/11/2024 13:04:29.9196 732 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 13:04:29.9306 762 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/11/2024 13:04:31.4586 1440 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:04:31.4986 1537 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-18 13:04:29' where payTraUID = 5119750915919460 and payStatus='V' and payEnabled=1 18/11/2024 13:04:46.4418 661 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 18/11/2024 13:09:45.0273 1725 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 13:09:49.5303 730 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/11/2024 13:13:07.8533 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:15:31.7894 547 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 372544 else acvFstPayId end),acvLstPayId = 372544 where acvSftId = 818 and acvCodeId = 3 18/11/2024 13:15:35.0766 2545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:15:40.8805 2035 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:17:02.8048 1233 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-18 13:17:01',0,'V',4770522058171360,4800399909268140,2024,'2024-11-18 13:17:01',18,1,0,4,'2024-11-18 13:32:01','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 18/11/2024 13:17:30.5955 1798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:17:53.7942 547 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-18 13:17:53','V',5043167457184530,2024,'2024-11-18 13:17:50','456124683500327005012999',2,2,2,'O','',0,'2024-11-18 13:17:53',1,'','',0) 18/11/2024 13:17:54.5207 709 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 13:18:40.5477 2149 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-18 13:18:36',0,'V',5736331635269900,4820352075453550,2024,'2024-11-18 13:18:36',3,1,0,4,'2024-11-18 13:33:36','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 18/11/2024 13:19:47.5487 856 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 13:22:34.3812 714 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 13:22:50.9143 1575 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 18/11/2024 13:22:57.7530 2123 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:23:09.0856 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:25:04.3272 537 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-18 13:25:03','V',5464947052944550,2024,'2024-11-18 13:25:02','456124830200327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 13:30:03.8296 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:31:02.5400 586 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-18 13:31:01',0,'V',5065396648741710,4962389422578030,2024,'2024-11-18 13:31:01',18,1,0,4,'2024-11-18 13:46:01','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 18/11/2024 13:44:50.9883 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:46:55.9230 1281 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-18 13:46:54','V',4777829720817400,2024,'2024-11-18 13:46:54','456124961400327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 13:50:17.0618 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 13:52:35.7658 1275 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 13:52:58.9263 685 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 13:53:03.8866 1545 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 18/11/2024 13:53:36.7046 2726 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/11/2024 13:57:04.2207 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 13:58:37.6723 1537 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 13:59:13.4863 962 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:00:37.4676 662 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 14:00:36' where traUID = 4724590609311370 and traStatus='V' and traEnabled=1 18/11/2024 14:01:53.8328 606 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:02:07.0967 695 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 14:02:07.9002 1517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:02:38.8579 2539 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 18/11/2024 14:02:57.3383 1466 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:04:39.1135 1066 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:05:02.2470 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:05:18.0466 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:05:19.2174 994 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-18 14:05:18',0,'V',4811205610193180,5062338235699310,2024,'2024-11-18 14:05:18',18,1,0,4,'2024-11-18 14:20:18','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 18/11/2024 14:05:47.7475 717 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 14:07:17.7627 977 ms. EXEC: update tabTerminalReceipt set trcProgressive = 50135, trcLastPrinted = '2400750135', trcLastDate = '2024-11-18 14:07:16' where trcStatus='V' and trcTerId = 18 18/11/2024 14:07:26.5636 2503 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/11/2024 14:07:26.7938 2679 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 18/11/2024 14:08:58.7724 937 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-18 14:08:57','V',5268428516536380,2024,'2024-11-18 14:08:56','456124959800327005012999',2,2,2,'O','',0,'2024-11-18 14:08:57',1,'','',0) 18/11/2024 14:10:07.6415 627 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 14:10:59.1900 560 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 14:14:40.8684 1040 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/11/2024 14:15:11.7811 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:15:31.0920 3541 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/11/2024 14:15:43.7275 739 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-18 14:15:42','V',4925346767206880,2024,'2024-11-18 14:15:42','456124830200327005012999',2,2,2,'O','',0,'2024-11-18 14:15:42',1,'','',0) 18/11/2024 14:18:40.4998 1183 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 18/11/2024 14:20:16.8633 2143 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:21:52.0711 779 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 14:21:51',4,6,'2024-11-18 14:21:51','456124828400327005012999','Payed (Credit Card ) Ticket ') 18/11/2024 14:28:15.5238 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:28:33.3047 829 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 14:29:11.6724 1747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:30:18.6452 2343 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc 18/11/2024 14:30:47.6006 517 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 14:30:46' where traUID = 5371660967944880 and traStatus='V' and traEnabled=1 18/11/2024 14:30:48.7003 906 ms. OPEN: select * from tabTerminal where terId = 2 18/11/2024 14:30:52.8001 736 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 14:32:21.3513 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:32:45.4735 2976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:33:08.7841 774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:34:20.4351 502 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-18 14:31:44',6,'V',5081892441700220,4777829720817400,2024,'2024-11-18 14:31:44',4,1,0,4,'2024-11-18 14:46:44','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 18/11/2024 14:34:21.1986 758 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 14:34:20',4,6,'2024-11-18 14:34:20','456124961400327005012999','Payed (Credit Card ) Ticket ') 18/11/2024 14:34:39.9121 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 14:35:48.3399 715 ms. EXEC: update tabTerminalReceipt set trcProgressive = 50144, trcLastPrinted = '2400750144', trcLastDate = '2024-11-18 14:35:47' where trcStatus='V' and trcTerId = 18 18/11/2024 14:35:56.0561 1234 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/11/2024 14:36:54.7384 712 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-18 14:36:54','V',4795438131054570,2024,'2024-11-18 14:36:52','456124493500327005012999',2,2,2,'O','',0,'2024-11-18 14:36:54',1,'','',0) 18/11/2024 14:36:55.9142 1019 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 14:36:54' where traUID = 5760737060323540 and traStatus='V' and traEnabled=1 18/11/2024 14:39:37.8216 565 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 14:39:37' where traUID = 4777829720817400 and traStatus='V' and traEnabled=1 18/11/2024 14:41:10.6162 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:43:23.9325 1354 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 14:47:02.4818 1656 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/11/2024 14:47:25.8235 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 14:52:31.6913 1199 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/11/2024 15:00:13.3984 1154 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 15:00:12' where traUID = 5075107050890970 and traStatus='V' and traEnabled=1 18/11/2024 15:05:00.7820 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:06:26.7055 1099 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:06:38.6846 604 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 15:06:38.7716 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:06:46.7380 612 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 15:06:45' where traUID = 4786149270530660 and traStatus='V' and traEnabled=1 18/11/2024 15:08:10.6442 836 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:15:10.1072 1342 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 15:15:10.1542 729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:17:28.6159 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:20:23.3389 597 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 15:20:22' where traUID = 5078907007941300 and traStatus='V' and traEnabled=1 18/11/2024 15:21:37.3384 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:25:20.9472 652 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 15:25:32.4719 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:27:51.7071 1025 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:34:04.2735 1039 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:36:26.7379 1444 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:37:44.9413 1364 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 15:40:38.2804 1447 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-18 15:40:36','V',4933743455819770,2024,'2024-11-18 15:40:34','456125643400327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 15:42:08.4868 538 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-18 15:42:07',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 18/11/2024 15:42:25.3060 707 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 15:42:24' where traUID = 5148058893797140 and traStatus='V' and traEnabled=1 18/11/2024 15:43:15.9870 552 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 15:44:39.7340 998 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:46:44.5857 635 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 15:46:59.5887 1207 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 15:47:13.1268 878 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-18 15:47:12',0,'V',5356279447112970,4779136798101040,2024,'2024-11-18 15:47:12',18,1,0,4,'2024-11-18 16:02:12','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 18/11/2024 15:48:36.3565 1351 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 18/11/2024 15:49:40.5925 762 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:50:29.2161 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 15:50:45.2048 537 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 15:51:46.2957 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 15:52:08.4916 604 ms. OPEN: select payClosePeriod from paypayment inner join movtransit on paypayment.payTraUID=movtransit.traUID where movtransit.traStatus='V' AND traCode=@traCode and paypayment.payStatus='V' and paypayment.payClosePeriod is not null order by paypayment.payClosePeriod desc limit 1 18/11/2024 15:52:08.5496 694 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-18 15:52:05',0,'V',4739316799424160,5206914861319510,2024,'2024-11-18 15:52:05',3,1,0,4,'2024-11-18 16:07:05','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 18/11/2024 15:53:39.4845 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:01:43.4396 996 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:15:20.6318 1022 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 16:15:20.6368 1026 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 18/11/2024 16:15:20.7819 1180 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:15:32.7449 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:15:45.3363 743 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 16:16:08.4898 723 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 16:16:07' where traUID = 5496988169610660 and traStatus='V' and traEnabled=1 18/11/2024 16:16:11.7630 914 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/11/2024 16:16:24.0202 579 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitSecondary' nr: 1 18/11/2024 16:16:38.0116 811 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 16:16:38.0126 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:16:54.7558 1024 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 16:21:06.8276 949 ms. EXEC: update payInventory set invCreation = '2024-11-18 16:21:05',invModify = '2024-11-18 16:21:05',invUseId=0,invStatus='V' where invId = 220014 18/11/2024 16:23:05.0467 2094 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-18 16:23:02',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 18/11/2024 16:23:17.8083 2300 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:23:20.1799 1002 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:24:36.3649 1118 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-18 16:24:35','V',5460122049394940,2024,'2024-11-18 16:24:34','456125907400327005012999',1,2,16,'I','',1,0,1,'','0230004101179',8,0) 18/11/2024 16:25:26.9237 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:25:40.6799 606 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 16:25:51.5832 524 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 16:25:51' where traUID = 5717377681721880 and traStatus='V' and traEnabled=1 18/11/2024 16:27:04.2229 1421 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:29:29.1989 1615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:33:06.1102 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:39:22.4361 1553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:41:20.1019 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:44:30.7355 816 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-18 16:44:29','V',5026789175000770,2024,'2024-11-18 16:44:28','456125726900327005012999',2,2,2,'O','',0,'2024-11-18 16:44:29',1,'','',0) 18/11/2024 16:44:50.0675 525 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5290673264969910,5298975531891760,2024,'2024-11-18 16:44:49',' Date: 11/18/2024 4:42:15 PM Code: 456125969100327005012999 Entry Date: 11/18/2024 4:34:51 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400416319 ',0) 18/11/2024 16:44:50.0765 510 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 16:45:10.6793 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:46:32.1178 1198 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:47:00.1196 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:47:42.0336 812 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 16:51:47.2158 1667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:52:27.8830 1538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:53:58.6218 2408 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 16:55:21.1801 1331 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 16:55:31.6471 2751 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 16:56:13.5712 655 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-18 16:56:12','V',5084209569554210,2024,'2024-11-18 16:56:12','456126097200327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 16:56:14.2486 551 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 16:59:36.8843 1092 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/11/2024 17:01:47.8720 802 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 18/11/2024 17:02:43.1500 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:05:28.1565 751 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:05:51.6613 1579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:05:55.4148 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:06:38.7578 769 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 17:07:42.8547 815 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-18 17:07:42' where subId = 12 18/11/2024 17:13:04.3190 2025 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-18 17:13:02','0810007113876',0,0,5461150669184030,103,'0000-00-00 00:00:00','0000-00-00 00:00:00') 18/11/2024 17:13:22.8434 824 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-18 17:13:21',0,'V',4783729869295820,4949772577707540,2024,'2024-11-18 17:13:21',18,1,0,4,'2024-11-18 17:28:21','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 18/11/2024 17:13:40.5082 600 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-18 17:13:39','0230004101179',0,0,4697655410966880,8,'0000-00-00 00:00:00','0000-00-00 00:00:00') 18/11/2024 17:13:41.4298 703 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-18 17:13:40','V',5586571892139470,2024,'2024-11-18 17:13:38','456125907400327005012999',2,2,2,'O','',0,'2024-11-18 17:13:40',1,'','0230004101179',8,0) 18/11/2024 17:13:46.5273 3327 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 18/11/2024 17:28:33.9396 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:31:35.0289 632 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/11/2024 17:31:44.3001 1242 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 18/11/2024 17:32:06.2328 1963 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 17:36:41.9054 1305 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-18 17:36:40' where payTraUID = 5093707036712810 and payStatus='V' and payEnabled=1 18/11/2024 17:36:42.4698 564 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 17:36:40' where traUID = 5093707036712810 and traStatus='V' and traEnabled=1 18/11/2024 17:37:05.1210 1293 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-18 17:37:03' where payTraUID = 5725394457863000 and payStatus='V' and payEnabled=1 18/11/2024 17:37:06.2197 1098 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 17:37:03' where traUID = 5725394457863000 and traStatus='V' and traEnabled=1 18/11/2024 17:39:30.6054 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:42:28.7787 904 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:53:23.5803 1645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:54:08.5605 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:55:16.3749 896 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-18 17:55:15' where payTraUID = 5490950505169910 and payStatus='V' and payEnabled=1 18/11/2024 17:56:13.3600 572 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-18 17:56:12' where payTraUID = 5424350205699090 and payStatus='V' and payEnabled=1 18/11/2024 17:56:17.3067 1871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:56:17.3687 4008 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 17:56:12' where traUID = 5424350205699090 and traStatus='V' and traEnabled=1 18/11/2024 17:57:56.2710 3688 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 372706 else acvFstPayId end),acvLstPayId = 372706 where acvSftId = 818 and acvCodeId = 3 18/11/2024 17:58:16.4615 1177 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 17:58:37.2814 918 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-18 17:58:36',0,'V',5628424223500420,5644387030759520,2024,'2024-11-18 17:58:36',18,1,0,4,'2024-11-18 18:13:36','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 18/11/2024 18:00:18.0079 604 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-18 18:00:17','V',4926618564557790,2024,'2024-11-18 18:00:15','456126481500327001012999',1,2,1,'I','',1,0,1,'','',4) 18/11/2024 18:00:19.4939 593 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 18:00:35.1774 537 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 18/11/2024 18:01:10.2459 597 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-18 18:01:09',0,'V',5658593852907980,5631519575642140,2024,'2024-11-18 18:01:09',18,1,0,4,'2024-11-18 18:16:09','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 18/11/2024 18:01:12.4003 1773 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5631519575642140,5658593852907980,2024,'2024-11-18 18:01:10',' Date: 11/18/2024 6:01:09 PM Code: 456126446100327005012999 Entry Date: 11/18/2024 5:54:21 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400750185 ',0) 18/11/2024 18:02:49.0270 1132 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 18/11/2024 18:02:55.9677 1365 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:06:06.5533 776 ms. EXEC: update payReceipt set recCreation = '2024-11-18 18:06:05',recModify = '2024-11-18 18:06:05',recUseId=0,recStatus='V' where recId = 323856 18/11/2024 18:06:27.5074 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 18:10:32.0161 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:13:52.3243 590 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 18:16:42.7545 1070 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:18:37.5994 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:26:48.0199 1108 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4961145455371310,5339434465495720,2024,'2024-11-18 18:26:46','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/18/2024 4:26:54 PM Date : 11/18/2024 6:26:45 PM Code : 456125921400327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 18/11/2024 18:29:14.7922 1423 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-18 18:29:12',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 18/11/2024 18:33:23.3897 1330 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:38:03.3623 1506 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-18 18:38:01','V',5761154139880980,2024,'2024-11-18 18:38:01','456126708100327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 18:38:04.3189 554 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/11/2024 18:38:16.4951 1662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:41:13.2965 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:43:07.1748 1022 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-18 18:43:06','V',5628811772167790,2024,'2024-11-18 18:43:05','456126543300327005012999',2,2,2,'O','',0,'2024-11-18 18:43:06',1,'','',0) 18/11/2024 18:45:21.4067 1078 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:46:59.9317 892 ms. EXEC: update tabTerminalReceipt set trcProgressive = 50191, trcLastPrinted = '2400750191', trcLastDate = '2024-11-18 18:46:59' where trcStatus='V' and trcTerId = 18 18/11/2024 18:49:54.5877 519 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-18 18:49:53',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 18/11/2024 18:52:32.1542 1379 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:52:57.0849 1815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:53:34.9903 1037 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:54:13.1209 2152 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 18/11/2024 18:55:09.1794 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 18:55:52.8427 721 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 18:58:00.3141 1496 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 18:57:58' where traUID = 5761154139880980 and traStatus='V' and traEnabled=1 18/11/2024 18:58:06.0189 1628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:01:28.1373 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:01:43.4375 2046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:02:09.1878 1049 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 19:03:07.8791 2642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:03:24.3561 1142 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:03:59.9250 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:04:13.6622 1766 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-18 19:04:11','V',5721760058587050,2024,'2024-11-18 19:04:11','456126430900327005012999',2,2,2,'O','',0,'2024-11-18 19:04:11',1,'','',0) 18/11/2024 19:04:20.3196 3300 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 (WAIT TIME 1 ms.) 18/11/2024 19:04:29.9261 754 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 18/11/2024 19:05:03.8678 1917 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:07:00.7441 955 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-18 19:06:59','V',5258207900755170,2024,'2024-11-18 19:06:59','456126860900327005012999',2,2,2,'O','',0,'2024-11-18 19:06:59',1,'','',0) 18/11/2024 19:07:01.4076 614 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/11/2024 19:07:36.4440 982 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:07:56.0141 676 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 18/11/2024 19:08:29.0002 1010 ms. EXEC: INSERT INTO opeShifts (sftCreation,sftUseId,sftUID) VALUES ('2024-11-18 19:08:27',@SFTUSEID,@SFTUID) 18/11/2024 19:12:17.2662 1376 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:16:30.0435 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:25:05.2146 1888 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:25:41.2267 772 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 19:26:20.7162 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:28:13.4867 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 19:29:07.8021 585 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-18 19:29:07',0,'V',4829054287253580,4753240371841320,2024,'2024-11-18 19:29:07',18,1,0,4,'2024-11-18 19:44:07','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 18/11/2024 19:30:46.2991 617 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 19:30:45' where traUID = 4753240371841320 and traStatus='V' and traEnabled=1 18/11/2024 19:31:56.4781 1337 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 18/11/2024 19:32:23.1460 810 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 19:35:50.4118 1015 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-18 19:35:49','V',4699072623744130,2024,'2024-11-18 19:35:48','456125898400327005012999',2,2,2,'O','',0,'2024-11-18 19:35:49',1,'','',0) 18/11/2024 19:35:50.9782 557 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 19:35:52.1400 1150 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/11/2024 19:35:54.0713 510 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/11/2024 19:36:26.4510 1055 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:38:10.2035 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:42:13.7056 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:43:31.3817 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 19:45:50.6269 1485 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-18 19:45:49','V',5561081187759940,2024,'2024-11-18 19:45:48','456126620200327005012999',2,2,2,'O','',0,'2024-11-18 19:45:49',1,'','',0) 18/11/2024 19:49:23.3264 569 ms. EXEC: update tabTerminalReceipt set trcProgressive = 50196, trcLastPrinted = '2400750196', trcLastDate = '2024-11-18 19:49:22' where trcStatus='V' and trcTerId = 18 18/11/2024 19:50:41.7390 2119 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 19:51:09.7487 2097 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 19:51:29.8762 981 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 19:51:28' where traUID = 4736585512773350 and traStatus='V' and traEnabled=1 18/11/2024 19:55:06.4153 5934 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/11/2024 19:55:08.5178 2101 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 18/11/2024 19:55:11.5248 680 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 19:55:46.7875 11776 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 19:55:48.7699 4351 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 18/11/2024 19:55:48.7889 1909 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 19:55:54.3476 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:55:56.9453 1775 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:56:05.3980 2125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:56:15.4287 1269 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 19:58:18.4981 1105 ms. OPEN: select * from tabCustomer inner join abbSubscriptions on subCusId = cusId left join tabAbbGroups on cusAbgId = abgId where subId = 11 and cusStatus='V' 18/11/2024 19:58:19.8000 1290 ms. EXECSCALAR: select count(parCheckPassbackExit) from tabParameters where parStatus='V' and parCheckPassbackExit=0 order by parId DESC limit 1 nr: 0 18/11/2024 19:58:34.7990 11106 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 19:58:42.0078 6134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:00:16.8733 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:02:41.5132 7891 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 18/11/2024 20:02:47.1110 5596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:02:47.1110 5551 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 20:03:10.8160 10608 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 20:05:25.3654 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:07:00.6844 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:07:52.6231 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:08:22.4872 3737 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 20:08:41.4859 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:10:11.5389 2892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:12:01.2688 2827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:12:05.9369 3695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:13:02.7772 1829 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '456126908800327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc 18/11/2024 20:14:32.9689 1716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:15:30.3395 9113 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 20:15:58.7777 4583 ms. OPEN: select * from paypayment where payUID = 5374299431195880 and payStatus='V' 18/11/2024 20:16:13.0283 4627 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-18 20:16:08','V',4613568859538170,2024,'2024-11-18 20:15:48','456126908800327005012999',2,2,2,'O','',0,'2024-11-18 20:16:08',1,'','',0) 18/11/2024 20:16:17.8265 4732 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/11/2024 20:16:22.5287 4552 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 20:16:17' where traUID = 5266780900838670 and traStatus='V' and traEnabled=1 18/11/2024 20:16:30.5771 83499 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 183 ms.) 18/11/2024 20:17:41.0906 4622 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 4909 ms.) 18/11/2024 20:18:23.8824 4598 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 105 ms.) 18/11/2024 20:18:38.1540 4419 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 236 ms.) 18/11/2024 20:18:47.4042 4485 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 20:18:42',1,16,'2024-11-18 20:18:42','','Send command to entry/exit units: Command OPEN on Device Entry 2 ') 18/11/2024 20:19:17.1403 5248 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 18/11/2024 20:19:31.3578 3957 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 20:19:59.9060 4143 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 18/11/2024 20:20:04.6002 4250 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 20:20:23.6700 4388 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 20:20:42.3746 3197 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:20:47.1228 647 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:22:12.0040 1945 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 20:25:10.0762 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:25:58.6682 1484 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:27:43.1739 4751 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 20:27:47.8360 3591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:29:10.1665 1972 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 20:31:20.0275 2563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:31:56.7520 2626 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 20:32:06.2493 2367 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:32:29.9901 1758 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/11/2024 20:32:51.7096 577 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 18/11/2024 20:34:32.8270 1045 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 20:36:50.3806 1154 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:48:41.5053 2092 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:48:46.2555 2047 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 18/11/2024 20:48:51.0116 1605 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 20:49:14.8325 3867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:49:59.7585 2400 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:51:22.5617 2206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:51:32.0560 3027 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:53:32.2121 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:53:36.9913 1302 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:53:56.0580 3117 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 20:54:00.7131 2657 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/11/2024 20:54:38.7094 4683 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 = '300018' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/11/2024 20:54:52.0173 22687 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 6 ms.) 18/11/2024 21:04:43.3854 753 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-18 21:04:42','V',4680625620645660,2024,'2024-11-18 21:04:41','456127588100327005012999',1,2,16,'I','',1,0,1,'','',4) 18/11/2024 21:04:52.9558 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:15:53.7856 599 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-18 21:15:53' where payTraUID = 5573884244599370 and payStatus='V' and payEnabled=1 18/11/2024 21:15:54.8874 1101 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-18 21:15:53' where traUID = 5573884244599370 and traStatus='V' and traEnabled=1 18/11/2024 21:15:59.5095 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 21:16:46.8291 551 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-18 21:16:46' where payTraUID = 5303040989508790 and payStatus='V' and payEnabled=1 18/11/2024 21:17:27.1710 1871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:17:36.5833 1887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:17:38.7527 1555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:17:50.0473 6427 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 18/11/2024 21:20:43.0487 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:20:49.3089 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:22:50.3308 2360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:28:16.5918 552 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 21:29:27.3077 706 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 21:29:27.4938 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:29:28.1102 764 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/11/2024 21:39:40.3298 2001 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-18 21:39:38','V',5132714564488470,2024,'2024-11-18 21:39:37','456127698800327005012999',2,2,2,'O','',0,'2024-11-18 21:39:38',1,'','',0) 18/11/2024 21:39:44.7227 758 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 18/11/2024 21:43:48.9945 812 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-18 21:43:48','V',4668661102691080,2024,'2024-11-18 21:43:46','456127662500327005012999',2,2,2,'O','',0,'2024-11-18 21:43:48',1,'','',0) 18/11/2024 21:43:54.2680 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/11/2024 21:44:22.0775 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:44:48.6162 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:44:50.7366 918 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:44:53.6165 1444 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:44:54.7982 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:44:55.9710 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:46:58.3436 2016 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:49:14.4998 1621 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 21:50:39.6835 4208 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:50:44.3996 4648 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-18 21:50:39','0230003944081',0,0,5388372898505430,15,'0000-00-00 00:00:00','0000-00-00 00:00:00') 18/11/2024 21:50:49.1498 4409 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-18 21:50:44','V',5573783764503690,2024,'2024-11-18 21:50:30','456127440600327005012999',2,2,2,'O','',0,'2024-11-18 21:50:44',1,'','0230003944081',15,0) 18/11/2024 21:50:58.6612 4621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 21:54:39.4360 1762 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 21:56:13.8998 4882 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 21:56:44.2410 933 ms. EXECSCALAR: select claId from tabClass where claPosition = 2 and claStatus='V' nr: 2 18/11/2024 21:56:47.1183 1152 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/11/2024 21:59:45.7616 4796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 22:01:14.0424 2670 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-18 21:01:11') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-18 22:01:11' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-18 22:01:11' and (resAreId = 1 or resAreId <= 0) nr: 0 18/11/2024 22:02:42.7759 3314 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 22:03:01.6996 1171 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 22:03:44.4014 4548 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/11/2024 22:03:49.1536 3664 ms. EXECSCALAR: select count(rulId) from tabTicketRules where rulStatus='V' and rulTerId = 3 and rulDevId = 1 and rulTicId = 1 nr: 0 18/11/2024 22:03:58.6520 4655 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_invalidbadge' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 18/11/2024 22:05:03.0674 4648 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5732581503047960,5451746767139580,2024,'2024-11-18 22:04:58','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/18/2024 9:36:20 PM Date : 11/18/2024 10:04:57 PM Code : 456127778000327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) (WAIT TIME 1 ms.) 18/11/2024 22:08:27.8412 4399 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/11/2024 22:08:57.6863 1119 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 22:09:02.4656 3612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 22:09:19.0447 4678 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-18 22:09:07',0,'V',5173632327428840,5474954879015280,2024,'2024-11-18 22:09:07',3,1,0,4,'2024-11-18 22:24:07','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 18/11/2024 22:09:28.5811 9457 ms. EXEC: update payReceipt set recCreation = '2024-11-18 22:09:19',recModify = '2024-11-18 22:09:19',recUseId=0,recStatus='V' where recId = 323899 18/11/2024 22:09:28.7943 4908 ms. EXECSCALAR: select count(terId) from tabTerminal where terPassback<>0 and terId = 2 nr: 0 18/11/2024 22:09:33.2943 4422 ms. EXEC: update paycash set casCreation = '2024-11-18 22:09:28',casModify = '2024-11-18 22:09:28',casUseId=0,casStatus='V' where casId = 195616 18/11/2024 22:09:38.0885 4663 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-18 22:09:33',0,0,'V',5493512128814570,5474954879015280,2024,'2024-11-18 22:09:33',3,'KES',-1,50,-50,'N',''); 18/11/2024 22:10:01.9006 9139 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 22:10:31.4835 9432 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 22:10:36.2337 4181 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-18 22:10:32',1,2,'2024-11-18 22:10:32','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 18/11/2024 22:10:41.0319 4525 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 18/11/2024 22:10:45.7331 4514 ms. OPEN: select * from movTransit inner join paypayment on paypayment.payTraUID = movTransit.traUID where traCode = '456127778000327005012999' and traStatus='V' and payStatus='V' order by payDateTime desc 18/11/2024 22:11:20.4665 4053 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 18/11/2024 22:11:38.0363 761 ms. OPEN: select * from tabRoutes inner join tabAbbGroups on rouAbgId = abgId where rouStatus='V' and rouAbgId = 99999 18/11/2024 22:11:43.4650 505 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 18/11/2024 22:12:08.0535 4460 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 365 ms.) 18/11/2024 22:12:28.0880 5260 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 4960 ms.) 18/11/2024 22:12:37.5033 4696 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 4659 ms.) 18/11/2024 22:13:10.6957 4461 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 50 ms.) 18/11/2024 22:14:08.7998 9312 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 22:14:09.0730 4776 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 18/11/2024 22:15:02.2408 3008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 22:15:35.4852 4692 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 2 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 18/11/2024 22:15:40.2334 4684 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 22:15:54.4850 4649 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/11/2024 22:16:12.6943 8611 ms. OPEN: select count(useId) as vTot from tabUser where useStatus='V' and useBadId<>'' 18/11/2024 22:16:20.6096 7912 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketDisabled' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 18/11/2024 22:16:37.2348 5863 ms. EXEC: insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); 18/11/2024 22:16:53.1905 1647 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/11/2024 22:16:54.7596 9209 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/11/2024 22:17:03.3584 10167 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16)