18/12/2024 00:02:11.6408 1286 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 00:02:30.2348 772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 00:09:56.2183 892 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 18/12/2024 00:10:49.7997 666 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 00:16:21.5242 744 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/12/2024 00:20:18.1220 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 00:23:35.1713 673 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-12-18 00:23:34','V',4629320797492540,2024,'2024-12-18 00:23:34','456420141400327005012999',1,2,16,'I','',1,0,1,'','',4) 18/12/2024 00:24:20.1129 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 00:24:22.1593 1340 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 00:29:27.8798 828 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/12/2024 00:30:50.9804 1321 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 00:34:34.4597 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 00:34:43.5970 696 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 01:06:59.1837 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 01:08:11.7565 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 01:09:12.3507 605 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 01:12:26.4845 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 01:14:07.5774 1243 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 01:14:20.2948 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 01:30:56.3199 858 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 01:35:18.8842 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 01:40:20.4159 1116 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 18/12/2024 01:40:31.5434 795 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 01:58:34.5190 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:10:45.5917 1086 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/12/2024 02:11:56.4269 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:12:04.3859 1023 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:25:23.2055 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:32:03.0702 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:32:10.7949 599 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:33:53.2894 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:38:09.6393 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:39:59.3309 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/12/2024 02:45:05.0269 761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:46:48.7550 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:48:21.0637 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 02:53:25.0673 1105 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 03:00:50.9249 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 03:49:53.9437 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 03:52:13.1933 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 04:11:10.9664 1466 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 04:18:48.9467 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 04:19:04.2937 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 04:55:20.9480 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 05:05:48.1099 882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 05:09:28.3462 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 05:22:55.0386 851 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 05:31:30.2314 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 05:32:18.9310 1397 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 05:36:21.8259 1064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 05:36:52.1437 1468 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 06:28:19.0652 1309 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 07:15:20.8263 891 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-18 07:15:19' where payTraUID = 5129919669409010 and payStatus='V' and payEnabled=1 18/12/2024 07:18:13.0304 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 07:19:40.3149 686 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-12-18 07:19:39','V',5476770893026260,2024,'2024-12-18 07:19:38','456422637800327005012999',1,2,16,'I','',1,0,1,'','0230003957466',21,0) 18/12/2024 07:23:47.1887 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 07:25:11.2084 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 07:25:54.7390 1137 ms. EXEC: update tabTerminalReceipt set trcProgressive = 18010, trcLastPrinted = '2400418010', trcLastDate = '2024-12-18 07:25:53' where trcStatus='V' and trcTerId = 4 18/12/2024 07:27:37.4041 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 07:33:54.2952 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 07:37:39.5872 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 07:45:56.1817 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 07:47:42.4734 514 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/12/2024 07:55:00.6659 852 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-12-18 07:54:59',0,'V',5483279189208090,5682687519415060,2024,'2024-12-18 07:54:59',3,1,0,4,'2024-12-18 08:09:59','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 18/12/2024 08:00:45.2149 1332 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/12/2024 08:04:41.4646 638 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/12/2024 08:06:36.2164 925 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 08:08:21.0676 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 08:11:25.6450 1360 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 08:15:04.6345 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 08:15:18.0721 1229 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 08:17:23.8332 848 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 08:23:28.9981 502 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 18/12/2024 08:53:34.8503 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 09:02:49.8018 513 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/12/2024 09:08:24.2164 1374 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/12/2024 09:14:47.9499 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 09:26:06.6867 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 09:27:03.0255 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 09:27:06.3100 1137 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/12/2024 09:35:35.4301 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 09:44:58.6477 1140 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5736326839011840,4909022776309970,2024,'2024-12-18 09:44:57',' Date: 12/18/2024 9:41:30 AM Code: 456423423700327005012999 Entry Date: 12/18/2024 9:30:37 AM 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 # 2400418012 ',0) 18/12/2024 09:47:19.9332 1140 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/12/2024 09:50:57.1592 1116 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-12-18 09:50:56','V',5292349523242160,2024,'2024-12-18 09:50:55','456423545500327005012999',1,2,16,'I','',1,0,1,'','',4) 18/12/2024 09:53:24.3609 520 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/12/2024 09:54:55.9773 515 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:44',5,3,42101,0,50,-6,-300,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:44',5,3,42101,0,50,6,300,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:44',5,3,42101,0,100,-30,-3000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:44',5,3,42101,0,100,30,3000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:44',5,3,42101,0,200,-10,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:44',5,3,42101,0,200,10,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:44',5,3,42101,0,500,-3,-1500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:44',5,3,42101,0,500,3,1500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:44',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 18/12/2024 09:54:58.3109 1819 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:49',5,3,42101,0,50,-12,-600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:49',5,3,42101,0,100,-34,-3400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:49',5,3,42101,0,200,-11,-2200,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:49',5,3,42101,0,500,-3,-1500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 09:54:49',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 18/12/2024 09:55:38.1368 621 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/12/2024 09:58:14.3164 875 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/12/2024 10:02:51.0255 520 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-18 10:02:50',0,16,'2024-12-18 10:02:50','','Unauthorized Transit Entry 2') 18/12/2024 10:08:49.6709 1095 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/12/2024 10:14:59.8188 781 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-12-18 10:14:59','V',5017831726354330,2024,'2024-12-18 10:14:58','456423539100327005012999',2,2,2,'O','',0,'2024-12-18 10:14:59',1,'','',0) 18/12/2024 10:15:57.5183 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 336 ms.) 18/12/2024 10:16:16.9114 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 10:16:50.8365 574 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/12/2024 10:17:35.6940 1157 ms. EXEC: update tabTerminalReceipt set trcProgressive = 53926, trcLastPrinted = '2400753926', trcLastDate = '2024-12-18 10:17:34' where trcStatus='V' and trcTerId = 18 18/12/2024 10:24:49.3767 508 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/12/2024 10:31:38.4435 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 10:31:59.4082 754 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 10:32:22.9176 1633 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-12-18 10:32:21','V',5113077265302240,2024,'2024-12-18 10:32:20','456423689100327005012999',2,2,2,'O','',0,'2024-12-18 10:32:21',1,'','',0) 18/12/2024 10:32:23.6664 599 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 18/12/2024 10:33:41.3046 684 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/12/2024 10:35:36.2998 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/12/2024 10:43:13.5530 998 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-12-18 10:43:12','V',5095207978268060,2024,'2024-12-18 10:43:12','456423859200327005012999',1,2,16,'I','',1,0,1,'','',4) 18/12/2024 10:47:22.7228 584 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/12/2024 10:47:38.7891 786 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-12-18 10:47:38','V',5039951280119340,2024,'2024-12-18 10:47:37','456423885700327005012999',1,2,16,'I','',1,0,1,'','',4) 18/12/2024 10:51:22.6513 3670 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); (WAIT TIME 88 ms.) 18/12/2024 10:53:20.4820 818 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-12-18 10:53:19','V',4797954444025500,2024,'2024-12-18 10:53:14','456423919400327005012999',1,2,16,'I','',1,0,1,'','',4) 18/12/2024 10:55:07.1097 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 10:55:12.9360 553 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/12/2024 10:57:20.8923 850 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 10:59:03.5765 1924 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 18/12/2024 11:00:09.0350 671 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-18 11:00:08',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 18/12/2024 11:02:12.1309 649 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-12-18 11:02:11',0,'V',4842478131915190,5095207978268060,2024,'2024-12-18 11:02:11',18,1,0,4,'2024-12-18 11:17:11','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 18/12/2024 11:02:16.4774 870 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/12/2024 11:02:21.4967 702 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/12/2024 11:20:33.2136 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 11:37:13.7572 1255 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 11:37:26.5056 4607 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/12/2024 11:37:38.4121 3425 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/12/2024 11:38:42.1534 742 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 14 ms.) 18/12/2024 11:39:13.0394 4488 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 36 ms.) 18/12/2024 11:39:17.9090 4127 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc (WAIT TIME 130 ms.) 18/12/2024 11:40:22.1859 9693 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 265 ms.) 18/12/2024 11:40:47.2933 9616 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 133 ms.) 18/12/2024 11:41:32.3514 6603 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 384 ms.) 18/12/2024 11:42:39.0250 7787 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' (WAIT TIME 6044 ms.) 18/12/2024 13:01:21.2046 4006 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 18/12/2024 13:01:21.4337 650 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 18/12/2024 13:02:26.1087 27319 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 18/12/2024 13:03:21.2892 2210 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 18/12/2024 13:03:26.0364 2818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 13:03:30.8237 3749 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 18/12/2024 13:08:21.5063 3390 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 18/12/2024 13:08:21.5443 2278 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 (WAIT TIME 79 ms.) 18/12/2024 13:08:21.5443 21697 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 (WAIT TIME 78 ms.) 18/12/2024 13:08:21.5453 3392 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 74 ms.) 18/12/2024 13:08:24.6733 682 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-12-18 12:08:23') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-18 13:08:22' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-18 13:08:22' and (resAreId = 1 or resAreId <= 0) nr: 0 18/12/2024 13:08:24.6843 682 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-12-18 12:08:23') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-18 13:08:22' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-18 13:08:22' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 11 ms.) 18/12/2024 13:08:24.6903 886 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 18/12/2024 13:08:37.6078 13715 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191889' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/12/2024 13:08:37.6088 10491 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456424703500327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 18/12/2024 13:08:37.6128 15203 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '803856' and traDirection='I' order by traId DESC LIMIT 1 18/12/2024 13:08:38.9138 675 ms. OPEN: show columns from movRoutes where Field = 'rtsCarId' 18/12/2024 13:08:39.2971 734 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370677393' and traDirection='I' order by traId desc limit 1 18/12/2024 13:08:39.7363 1171 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 18/12/2024 13:08:43.4799 3258 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-12-18 13:08:40','V',4809109481728250,2024,'2024-12-18 13:04:36','456424523100327002029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 18/12/2024 13:08:43.4809 2378 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-12-18 13:08:41','V',5339307941480730,2024,'2024-12-18 13:03:55','456424703500327005031999',1,1,16,'I','',1,0,1,'','',4) 18/12/2024 13:08:44.8527 2221 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '456424282800327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 18/12/2024 13:08:45.0058 3193 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '456424158700327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 18/12/2024 13:08:45.7603 2266 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/12/2024 13:08:45.8614 2366 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/12/2024 13:08:46.5128 23515 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 18/12/2024 13:08:50.6545 5800 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 = '456424282800327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/12/2024 13:08:50.7515 5744 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 = '456424158700327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 18/12/2024 13:08:51.1098 4287 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/12/2024 13:08:52.4816 811 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 18/12/2024 13:08:52.4826 812 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 18/12/2024 13:08:55.4075 13621 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 164 order by traDateTime desc,traId desc 18/12/2024 13:08:55.9039 4794 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/12/2024 13:08:56.7037 746 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 18/12/2024 13:08:57.9986 2175 ms. OPEN: select * from payreceipt where recPayUID = 4623692524741760 and recStatus='V' 18/12/2024 13:09:15.1553 11812 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 18/12/2024 13:09:36.2052 35964 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 18/12/2024 13:27:07.4509 1437 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 18/12/2024 13:36:41.5652 2239 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 18/12/2024 13:50:26.7919 2297 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 18/12/2024 14:00:29.6281 4682 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 167 order by traDateTime desc,traId desc 18/12/2024 14:00:53.5320 9530 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 18/12/2024 14:01:02.9723 4526 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-12-18 14:00:58','V',5679434367635200,2024,'2024-12-18 14:00:19','456424615000327005012999',2,2,2,'O','',0,'2024-12-18 14:00:58',1,'','0810007115885',167,0) (WAIT TIME 54 ms.) 18/12/2024 14:01:14.7902 11257 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 29 ms.) 18/12/2024 14:01:14.8092 11267 ms. EXEC: delete from movInside where insTraUID = 4935778915456790 (WAIT TIME 41 ms.) 18/12/2024 14:01:14.8313 11315 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-12-18 14:01:03','V',5423148700559650,2024,'2024-12-18 14:00:39','456424969200327002029999',2,1,2,'O','',1,0,1,'','1882553264237',167,0) (WAIT TIME 58 ms.) 18/12/2024 14:01:46.8947 20712 ms. OPEN: SELECT * FROM tabuser WHERE useBadId<>'' AND (useBadId = '456423540800327005012999' OR useBadId = '456423540800327005012999') 18/12/2024 14:49:46.0767 1744 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 18/12/2024 14:52:14.1142 1745 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 18/12/2024 15:00:25.9345 5056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 15:00:44.9330 1078 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 15:00:58.8621 1643 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 15:01:22.6057 1894 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/12/2024 15:05:40.4438 7216 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 18/12/2024 15:05:50.1452 8970 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 15:05:50.1462 2731 ms. EXEC: update tabTerminalExtraMem SET extLoop2 = 0 where extStatus='V' and extTerId = 16 AND extPlateWaitOperator=0 18/12/2024 15:05:50.1472 2733 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 18/12/2024 15:06:19.1502 22228 ms. OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 18/12/2024 15:06:24.2245 5024 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 18/12/2024 15:06:25.6905 1465 ms. OPEN: select paypayment.payClosePeriod from movtransit inner join paypayment on movtransit.traUID=paypayment.payTraUID where paypayment.payStatus='V' and movtransit.traCode=@TRACODE and paypayment.payClosePeriod is not null order by paypayment.payClosePeriod desc 18/12/2024 15:06:33.6917 2339 ms. OPEN: select parVatRate,parVatName,parVatMethod,parVatRound,parVatDiscount from tabParameters where parStatus='V' order by parId desc limit 1 18/12/2024 15:07:22.1275 929 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 18/12/2024 15:07:22.1485 947 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 18/12/2024 15:07:22.2696 91821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 15:08:40.8021 78472 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 18/12/2024 15:09:07.8078 105481 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/12/2024 15:09:34.8015 132537 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-18 15:07:22',17,1,'2024-12-18 15:07:22','456425355400327005012999','Pagato (Contanti ) Biglietto ') 18/12/2024 15:09:34.8046 53322 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 18/12/2024 15:09:43.8215 8857 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 384196 else acvFstPayId end),acvLstPayId = 384196 where acvSftId = 855 and acvCodeId = 3 18/12/2024 15:20:20.7639 1199 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 18/12/2024 15:48:24.0630 611 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-12-18 15:48:23','V',5726961533674050,2024,'2024-12-18 15:48:22','456425690200327005012999',1,2,16,'I','',1,0,1,'','',4) 18/12/2024 16:10:27.4427 601 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 18/12/2024 16:17:48.8570 580 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 17 order by traDateTime desc,traId desc 18/12/2024 16:44:45.7925 630 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 384251 else acvFstPayId end),acvLstPayId = 384251 where acvSftId = 858 and acvCodeId = 3 18/12/2024 21:20:38.3551 21239 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 18/12/2024 21:22:20.5397 2509 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 18/12/2024 21:35:10.2756 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 21:35:47.5895 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 21:54:10.2994 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 21:57:35.6160 608 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 18/12/2024 22:00:02.2839 681 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-18 22:00:01',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/12/2024 22:02:30.1008 605 ms. EXEC: update tabTerminalReceipt set trcProgressive = 54023, trcLastPrinted = '2400754023', trcLastDate = '2024-12-18 22:02:29' where trcStatus='V' and trcTerId = 18 18/12/2024 22:02:59.4304 759 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-18 22:02:58',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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-18 22:02:58',3,42101,0,100,-1,-100,1,'O','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/12/2024 22:03:33.8224 721 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 384377 else acvFstPayId end),acvLstPayId = 384377 where acvSftId = 855 and acvCodeId = 3 18/12/2024 22:04:20.7068 661 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 18/12/2024 22:04:24.7655 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 18/12/2024 22:05:37.8713 1155 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-18 22:05:36' where traUID = 5459126780215970 and traStatus='V' and traEnabled=1 18/12/2024 22:05:55.4251 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 22:13:09.4645 526 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5709692030778670,4806189808046320,2024,'2024-12-18 22:13:08',' Data: 12/18/2024 10:10:20 PM Codice: 456427007300327005012999 Ingresso: 12/18/2024 7:27:53 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400608156 ',0) 18/12/2024 22:59:24.8241 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 23:11:33.9238 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 18/12/2024 23:30:38.3664 597 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-18 23:30:37' where traUID = 5703899623583000 and traStatus='V' and traEnabled=1 18/12/2024 23:33:40.9646 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1