26/12/2024 00:31:56.7093 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 00:41:04.2412 1176 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 00:51:31.1883 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 00:51:42.6720 1181 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 01:00:44.9255 1495 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 01:03:59.3314 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 01:11:14.6260 815 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 01:12:03.4377 1106 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 01:21:45.9839 1160 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 02:11:57.9381 738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 02:33:10.5645 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 02:44:58.7224 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 02:52:40.3955 637 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/12/2024 02:53:02.3431 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 02:53:49.7478 1995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 03:01:06.9471 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 03:14:48.6846 835 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 03:38:55.4968 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 03:46:36.5492 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 04:06:44.8811 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 04:23:09.9233 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 04:24:37.2084 1548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 04:28:34.3386 967 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 04:30:37.9908 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 04:42:12.5046 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 04:44:21.6722 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 04:45:13.0142 606 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/12/2024 04:56:21.7390 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 05:02:28.6656 677 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/12/2024 05:11:15.7269 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 05:15:48.1179 945 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 05:28:06.1544 542 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 05:33:15.7194 669 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-26 05:33:15','V',5728642284483330,2024,'2024-12-26 05:33:13','456501999300327005012999',1,2,16,'I','',1,0,1,'','',4) 26/12/2024 05:37:27.1175 589 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 26/12/2024 05:44:36.3824 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 06:07:53.4883 1313 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/12/2024 06:07:53.6504 1055 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 06:17:26.1271 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 06:21:16.6812 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 06:23:10.5874 588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 06:38:15.4081 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 06:38:21.1459 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 06:56:25.0203 1239 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/12/2024 07:03:05.8661 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 07:07:04.7451 2201 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 07:11:13.9159 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 07:17:49.7894 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 07:30:05.4449 791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 07:30:17.0357 695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 07:46:26.4262 2398 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/12/2024 07:52:07.4256 675 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/12/2024 07:53:47.6815 1116 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 26/12/2024 08:08:36.7410 896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 08:10:31.9155 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 08:14:28.6779 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 08:19:15.0134 1031 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-26 08:19:13',5,3,0,3,0,0,0,0,'3','') 26/12/2024 08:34:22.7968 505 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/12/2024 08:52:04.0067 662 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 08:58:15.2407 572 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/12/2024 08:58:37.5896 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 09:01:53.3204 849 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/12/2024 09:02:04.3038 738 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 09:05:47.8482 977 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 09:07:41.2132 843 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 09:08:47.4655 886 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 09:19:14.7273 637 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 09:20:06.3448 1485 ms. EXEC: update paycash set casCreation = '2024-12-26 09:20:04',casModify = '2024-12-26 09:20:04',casUseId=0,casStatus='V' where casId = 202051 26/12/2024 09:21:44.2732 560 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/12/2024 09:24:06.0950 563 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/12/2024 09:24:52.0637 862 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 09:27:23.8292 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-12-26 09:27:23','V',4750987391797930,2024,'2024-12-26 09:27:22','456503404200327005012999',1,2,16,'I','',1,0,1,'','',4) 26/12/2024 09:28:48.2560 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 09:32:14.4898 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 09:34:34.4013 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 09:37:15.0567 1177 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 09:40:30.7946 868 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/12/2024 09:42:20.9472 1061 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 09:44:55.4074 885 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/12/2024 09:59:47.6286 1053 ms. EXEC: update payInventory set invCreation = '2024-12-26 09:59:46',invModify = '2024-12-26 09:59:46',invUseId=0,invStatus='V' where invId = 227733 26/12/2024 09:59:47.8897 1162 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 10:04:59.3411 603 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-26 10:04:58','V',5566079758486010,2024,'2024-12-26 10:04:57','456503402700327005012999',2,2,2,'O','',0,'2024-12-26 10:04:58',1,'','',0) 26/12/2024 10:28:51.2077 1150 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 10:37:46.6401 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 10:37:47.4197 723 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/12/2024 10:49:59.8271 655 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 10:52:14.9314 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 10:53:44.5623 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 10:55:12.9704 705 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 10:58:40.2390 739 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 10:58:50.8220 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 10:58:55.4151 887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 10:59:37.8145 1417 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 11:14:02.8174 593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 11:16:42.5432 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 11:22:40.2840 686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 11:28:06.3510 634 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 26/12/2024 11:39:10.7000 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 11:39:30.7844 540 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-26 11:39:30','V',5140014510957530,2024,'2024-12-26 11:39:29','456504196900327005012999',1,2,16,'I','',1,0,1,'','',4) 26/12/2024 11:41:48.8251 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 11:41:55.3178 10503 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 26/12/2024 11:42:00.1020 544 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 = 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/12/2024 11:43:40.4269 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 11:49:14.0539 686 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/12/2024 11:53:36.3415 868 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 11:55:47.0569 1271 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/12/2024 12:06:18.0653 660 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/12/2024 12:06:18.6467 591 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/12/2024 12:07:04.7182 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 12:12:07.2568 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 12:12:56.9023 1084 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/12/2024 12:22:50.9078 705 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5283981590067030,5596136773079000,2024,'2024-12-26 12:22:50','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/26/2024 11:40:17 AM Date : 12/26/2024 12:22:49 PM Code : 456504201700327001012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 26/12/2024 12:25:12.0815 508 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5609358014015980,5444593963554780,2024,'2024-12-26 12:25:11','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/26/2024 11:27:41 AM Date : 12/26/2024 12:25:10 PM Code : 456504126100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 26/12/2024 12:25:42.1606 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 12:26:18.8151 1376 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/12/2024 12:26:21.1997 788 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-26 12:26:20',0,16,'2024-12-26 12:26:20','','Unauthorized Transit Entry 2') 26/12/2024 12:31:32.1650 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 12:32:41.1520 523 ms. OPEN: show columns from tabParameters where Field = 'parUseFloorCounter' 26/12/2024 12:32:45.0666 602 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 12:41:32.5529 997 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 12:45:50.1573 1745 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/12/2024 12:50:16.2340 635 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 12:50:23.5619 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 12:50:58.7796 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 12:53:21.1438 666 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 12:53:22.0874 895 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/12/2024 12:54:11.1592 1802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 12:56:39.1923 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 12:56:39.4174 602 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/12/2024 12:56:40.2510 1027 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/12/2024 12:58:45.1105 625 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-26 12:58:44','V',4684607355053390,2024,'2024-12-26 12:58:42','456504375300327005012999',2,2,2,'O','',0,'2024-12-26 12:58:44',1,'','',0) 26/12/2024 12:58:45.6898 562 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/12/2024 12:59:09.3917 969 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-26 12:59:08','V',5247172114096340,2024,'2024-12-26 12:59:06','456504451000327001012999',2,2,2,'O','',0,'2024-12-26 12:59:08',1,'','',0) 26/12/2024 12:59:16.0441 626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 13:03:26.1718 1212 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 26/12/2024 13:04:20.1619 1252 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 26/12/2024 13:18:57.1800 532 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 13:19:10.2387 559 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-26 13:19:07',0,'V',5179624868849270,5051915276965660,2024,'2024-12-26 13:19:07',3,1,0,4,'2024-12-26 13:34:07','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 26/12/2024 13:19:28.8682 819 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 13:38:59.0193 775 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 13:54:30.9414 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 13:56:06.5715 1094 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/12/2024 13:58:19.5288 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:13:35.6966 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:13:37.4628 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:13:47.2133 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:15:52.5861 1277 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:21:59.4624 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 14:22:00.4050 905 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/12/2024 14:24:10.1868 1270 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:27:37.9366 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:33:08.4873 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:33:35.9111 607 ms. EXEC: update abbCards set carLastDate = '2024-12-26 14:33:35',carLastDirection='I' where carStatus='V' and carId = 183 26/12/2024 14:37:13.0170 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:41:18.1695 2448 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:51:13.7105 632 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-26 14:51:13' where traUID = 5628288064083020 and traStatus='V' and traEnabled=1 26/12/2024 14:52:37.3324 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 14:53:57.6385 562 ms. EXEC: update paycash set casCreation = '2024-12-26 14:53:57',casModify = '2024-12-26 14:53:57',casUseId=0,casStatus='V' where casId = 202092 26/12/2024 14:54:23.5919 1718 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-26 14:54:21',0,16,'2024-12-26 14:54:21','','Unauthorized Transit Entry 2') 26/12/2024 15:06:01.6095 2124 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-26 15:05:59' where payTraUID = 5360188923147590 and payStatus='V' and payEnabled=1 26/12/2024 15:06:07.5915 551 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 15:06:19.7457 1298 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 15:12:37.7834 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 15:21:07.2928 742 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 15:22:38.5889 677 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/12/2024 15:23:11.8498 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 15:30:02.6664 782 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 26/12/2024 15:30:57.8276 848 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/12/2024 15:30:59.0374 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 15:37:11.7580 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 15:37:12.0172 857 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/12/2024 15:39:35.2619 926 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 15:41:53.9416 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 15:44:16.9002 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 15:44:22.9052 1161 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55204, trcLastPrinted = '2400755204', trcLastDate = '2024-12-26 15:44:21' where trcStatus='V' and trcTerId = 18 26/12/2024 15:46:07.6943 916 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-26 15:46:06','V',5613009288487130,2024,'2024-12-26 15:46:06','456505089700327005012999',2,2,2,'O','',0,'2024-12-26 15:46:06',1,'','',0) 26/12/2024 15:47:12.6147 1299 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/12/2024 15:47:20.6180 524 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 15:49:30.8313 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 15:57:06.1575 1896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 15:59:26.5493 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 16:00:50.7516 1033 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-26 16:00:49' where traUID = 4988520322330070 and traStatus='V' and traEnabled=1 26/12/2024 16:08:50.8015 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 16:16:23.9174 853 ms. EXEC: update abbCards set carLastDate = '2024-12-26 16:16:23',carLastDirection='O' where carStatus='V' and carId = 190 26/12/2024 16:18:24.9823 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 16:18:59.3053 3080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 16:23:01.1509 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 16:24:38.3019 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 17:02:55.1644 700 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/12/2024 17:02:55.1965 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 17:04:44.0062 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 17:07:19.5476 711 ms. EXEC: update payInventory set invCreation = '2024-12-26 17:07:18',invModify = '2024-12-26 17:07:18',invUseId=0,invStatus='V' where invId = 227778 26/12/2024 17:09:58.4483 1405 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 17:17:53.5555 755 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/12/2024 17:20:45.2996 586 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 26/12/2024 17:38:31.8168 527 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/12/2024 17:38:41.9946 1212 ms. EXEC: update payInventory set invCreation = '2024-12-26 17:38:40',invModify = '2024-12-26 17:38:40',invUseId=0,invStatus='V' where invId = 227780 26/12/2024 17:40:16.4997 527 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/12/2024 17:40:27.8753 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 17:41:02.4935 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 17:41:46.6510 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 17:41:47.2074 517 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/12/2024 17:48:16.9519 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 17:59:30.5224 654 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 17:59:32.9060 721 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55214, trcLastPrinted = '2400755214', trcLastDate = '2024-12-26 17:59:32' where trcStatus='V' and trcTerId = 18 26/12/2024 18:04:50.2174 517 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/12/2024 18:10:41.5025 755 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 18:20:46.0394 969 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 18:26:03.3609 1055 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-26 18:26:02','V',4756259225111470,2024,'2024-12-26 18:26:00','456506537400327005012999',2,2,2,'O','',0,'2024-12-26 18:26:02',1,'','',0) 26/12/2024 18:26:09.2399 1355 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 18:28:21.5053 756 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/12/2024 18:30:14.6699 1404 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 18:36:07.1946 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 18:36:12.7493 523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 18:42:51.6608 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 18:43:12.2916 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 18:46:27.6142 877 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5694682719227560,4978874266067110,2024,'2024-12-26 18:46:26','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/26/2024 4:58:27 PM Date : 12/26/2024 6:46:24 PM Code : 456506110700327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 1000.00 KES Coin changed : 0.00 KES Note changed : 900.00 KES',0) 26/12/2024 18:46:28.8350 669 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-26 18:46:28',3,42101,0,100,-2,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-26 18:46:28',3,42101,0,200,-1,-200,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-26 18:46:28',3,42101,0,500,-1,-500,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 26/12/2024 18:53:37.9615 2491 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 18:54:56.3589 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 18:59:44.4516 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 19:03:11.4349 622 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/12/2024 19:19:26.1782 1361 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 19:22:46.4511 1084 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/12/2024 19:27:09.6299 2558 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/12/2024 19:29:40.6248 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 19:30:13.4287 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 19:40:36.8240 1723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 19:41:04.9969 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 19:41:36.5379 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 19:42:21.0287 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 19:43:03.3650 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 19:43:04.6749 539 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 19:47:10.5694 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 19:47:13.9077 1066 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-12-26 19:47:12',0,'V',4772396935724690,5484992257988810,2024,'2024-12-26 19:47:12',2,1,0,-1,'2024-12-26 20:47:12','S','KES',0,0,0,'','','',3,0,0) 26/12/2024 19:47:14.6712 616 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-26 19:47:13','V',4861018268660370,2024,'2024-12-26 19:47:10','456507118900327001012999',2,2,2,'O','',0,'2024-12-26 19:47:14',1,'','0230004098588',183,0) 26/12/2024 19:47:16.2042 631 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 20:31:51.2263 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 20:34:29.0978 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 20:35:01.8047 1405 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/12/2024 20:35:27.9542 948 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 20:45:46.2940 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 20:53:20.1702 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 20:54:58.3669 1665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 20:55:28.9013 746 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 21:05:01.4071 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 21:07:38.9914 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 21:09:30.1791 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 21:14:29.0016 2154 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-26 21:14:26',0,'V',5275417566917720,5049583841626750,2024,'2024-12-26 21:14:26',18,1,0,4,'2024-12-26 21:29:26','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 26/12/2024 21:14:30.5596 1444 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55231, trcLastPrinted = '2400755231', trcLastDate = '2024-12-26 21:14:29' where trcStatus='V' and trcTerId = 18 26/12/2024 21:14:31.2821 717 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5049583841626750,5275417566917720,2024,'2024-12-26 21:14:30',' Date: 12/26/2024 9:14:26 PM Code: 456506938800327005012999 Entry Date: 12/26/2024 7:16:28 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400755231 ',0) 26/12/2024 21:22:42.3876 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 21:29:05.7928 735 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 21:32:58.3321 1342 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 21:34:27.2139 1078 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/12/2024 21:34:29.2583 2019 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-26 21:34:27' where payTraUID = 5123018210471080 and payStatus='V' and payEnabled=1 26/12/2024 21:34:29.9157 656 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-26 21:34:27' where traUID = 5123018210471080 and traStatus='V' and traEnabled=1 26/12/2024 21:44:45.7163 611 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-26 21:44:48',6,'V',5699595209977070,4650761849455140,2024,'2024-12-26 21:44:48',4,1,0,4,'2024-12-26 21:59:48','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 26/12/2024 21:44:46.3787 597 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-26 21:44:45',4,6,'2024-12-26 21:44:45','456507134300327005012999','Payed (Credit Card ) Ticket ') 26/12/2024 21:50:44.7863 1611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 21:57:25.0299 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 21:57:39.3754 1130 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:00:46.2957 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:04:54.9448 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:09:59.9499 549 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 810793 26/12/2024 22:10:07.0756 858 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/12/2024 22:11:48.4944 756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:23:21.7922 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:26:56.9330 665 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-12-26 22:26:56',0,'V',5608800680110380,4821336411584520,2024,'2024-12-26 22:26:56',2,1,0,-1,'2024-12-26 23:26:56','S','KES',0,0,0,'','','',3,0,0) 26/12/2024 22:26:57.6585 716 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-26 22:26:56','V',5467717033224190,2024,'2024-12-26 22:26:54','456507954300327005012999',2,2,2,'O','',0,'2024-12-26 22:26:56',1,'','0560008304916',190,0) 26/12/2024 22:28:23.7430 651 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-26 22:28:23','V',5149154965832120,2024,'2024-12-26 22:28:22','456507607900327005012999',2,2,2,'O','',0,'2024-12-26 22:28:23',1,'','',0) 26/12/2024 22:32:29.7300 935 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:37:40.7683 1333 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:38:56.4429 519 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 26/12/2024 22:42:40.8589 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:49:26.5402 1036 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:54:28.5511 2152 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:55:21.8637 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:57:02.7331 1932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:57:05.9022 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 22:59:05.6823 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 23:03:22.1730 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 23:05:06.3507 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 23:26:26.4907 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/12/2024 23:55:49.0434 712 ms. EXEC: update tabTerminalReceipt set trcProgressive = 55237, trcLastPrinted = '2400755237', trcLastDate = '2024-12-26 23:55:48' where trcStatus='V' and trcTerId = 18 26/12/2024 23:56:32.0422 798 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-26 23:56:31','V',5344103463435650,2024,'2024-12-26 23:56:30','456508501200327005012999',2,2,2,'O','',0,'2024-12-26 23:56:31',1,'','',0) 26/12/2024 23:56:33.0489 701 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-26 23:56:32' where traUID = 4675253084836920 and traStatus='V' and traEnabled=1 26/12/2024 23:56:41.3244 796 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);