09/12/2024 00:42:57.0331 741 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/12/2024 01:05:07.0015 776 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 01:33:57.6036 1768 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/12/2024 01:34:51.0276 755 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/12/2024 01:34:51.1347 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 02:45:24.0054 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 02:51:06.6922 910 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 03:29:57.9847 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 04:35:12.9875 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 04:50:48.3662 2081 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17447, trcLastPrinted = '2400417447', trcLastDate = '2024-12-09 04:50:46' where trcStatus='V' and trcTerId = 4 09/12/2024 04:50:51.2712 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 04:53:20.4386 1425 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-09 04:53:19','V',4698474487719630,2024,'2024-12-09 04:53:17','456331260500327005012999',2,2,2,'O','',0,'2024-12-09 04:53:19',1,'','',0) 09/12/2024 05:17:22.7406 1127 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 05:22:03.4496 1504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 05:22:06.6328 1160 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 05:39:42.8259 908 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 05:53:27.7312 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 06:08:32.4213 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 06:09:21.5514 661 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-09 06:09:20','V',5721099192622020,2024,'2024-12-09 06:09:19','456332215900327005012999',1,2,16,'I','',1,0,1,'','',4) 09/12/2024 06:28:33.6400 886 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 06:50:25.3141 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 06:58:09.9229 791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 06:58:15.9990 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 06:59:58.3379 802 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 07:16:05.7052 1591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 07:18:12.5176 868 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 07:18:53.3460 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 07:41:05.7021 1641 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 09/12/2024 07:46:35.7413 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 07:46:52.3024 1055 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 07:55:40.4620 518 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,0,50,-7,-350,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,0,50,7,350,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,0,100,-33,-3300,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,0,100,33,3300,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,0,200,-2,-400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,0,200,2,400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,0,500,-7,-3500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,0,500,7,3500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,0,1000,-1,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,0,1000,1,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 07:55:25',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 09/12/2024 08:05:30.2281 501 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-09 08:05:29','V',5323133781142380,2024,'2024-12-09 08:05:28','456330000200327003229999',22,22,3,'I','',1,0,1,'','',2) 09/12/2024 08:06:14.3838 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 08:06:25.2151 1171 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 08:06:31.8575 1742 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 08:07:00.3107 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 08:09:41.1260 1416 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 08:24:02.0756 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 08:34:25.6965 732 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 09:04:20.2857 1062 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-09 09:04:19','V',4858559348104420,2024,'2024-12-09 09:04:16','456333265600327001012999',1,2,1,'I','',1,0,1,'','',4) 09/12/2024 09:04:21.2693 971 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 09:04:30.3875 947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 09:05:02.1509 629 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-09 09:05:01','V',5529357020262040,2024,'2024-12-09 09:05:00','456333270000327005012999',1,2,16,'I','',1,0,1,'','',4) 09/12/2024 09:06:52.1659 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 09:21:14.8147 542 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 09:22:24.5837 517 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/12/2024 09:22:40.7976 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 09:26:04.2496 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 09:28:26.1591 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 09:47:36.9179 900 ms. EXEC: update payReceipt set recCreation = '2024-12-09 09:47:36',recModify = '2024-12-09 09:47:36',recUseId=0,recStatus='V' where recId = 330452 09/12/2024 09:52:07.9623 604 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/12/2024 09:53:20.3821 1064 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 09/12/2024 09:53:57.1779 951 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-09 09:53:56','V',4799501933657910,2024,'2024-12-09 09:53:55','456332873800327005012999',2,2,2,'O','',0,'2024-12-09 09:53:56',1,'','',0) 09/12/2024 10:15:25.8655 694 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 10:20:29.7771 1107 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-09 10:20:28' where payTraUID = 5075672492699190 and payStatus='V' and payEnabled=1 09/12/2024 10:28:41.4481 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 10:31:41.7265 698 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 09/12/2024 10:36:08.8283 576 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-09 10:36:08',4,1,'2024-12-09 10:36:08','456333441700327005012999','Payed (Credit Card ) Ticket ') 09/12/2024 10:36:36.6700 788 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 10:36:42.7461 1206 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-09 10:36:41',4,1,'2024-12-09 10:36:41','456333577700327005012999','Payed (Credit Card ) Ticket ') 09/12/2024 10:39:17.0660 663 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-09 10:39:16','V',5741784003017400,2024,'2024-12-09 10:39:15','456333801900327005012999',2,2,2,'O','',0,'2024-12-09 10:39:16',1,'','',0) 09/12/2024 10:39:35.2032 6494 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 09/12/2024 10:39:56.7858 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 10:40:03.7835 2277 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-09 10:40:01',17,12,'2024-12-09 10:40:01','456333753500327005012999','Pagato (Contanti ) Biglietto ') 09/12/2024 10:41:08.3169 915 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 10:46:41.1230 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 10:53:05.1575 1026 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/12/2024 10:56:00.4606 3562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 11:03:06.6235 526 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-09 11:03:06','V',5441879721164630,2024,'2024-12-09 11:03:04','456333978400327005012999',1,2,16,'I','',1,0,1,'','',4) 09/12/2024 11:06:55.8348 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 11:08:21.6976 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 11:10:23.9049 1115 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 09/12/2024 11:12:34.5198 828 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 11:12:41.8347 1584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 11:15:44.6378 673 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 11:17:49.7510 1164 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-09 11:17:48','V',5020040260105250,2024,'2024-12-09 11:17:47','456334066700327005012999',1,2,16,'I','',1,0,1,'','',4) 09/12/2024 11:20:29.5606 889 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 11:22:42.8814 1221 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 11:26:23.6680 757 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-09 11:26:22',0,'V',4901245568840390,4946594316236420,2024,'2024-12-09 11:26:22',2,1,0,-1,'2024-12-09 12:26:22','S','KES',0,0,0,'','','',3,0,0) 09/12/2024 11:26:25.0910 680 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/12/2024 11:26:29.7631 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 11:32:27.7362 763 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 11:34:49.3725 948 ms. EXEC: update payReceipt set recCreation = '2024-12-09 11:34:48',recModify = '2024-12-09 11:34:48',recUseId=0,recStatus='V' where recId = 330492 09/12/2024 11:39:41.7894 530 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/12/2024 11:39:41.8094 549 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/12/2024 11:39:55.7578 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 11:40:17.5885 1413 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 11:46:26.3107 800 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 11:50:36.2420 848 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5020040260105250,4887883110189950,2024,'2024-12-09 11:50:35',' Date: 12/9/2024 11:50:35 AM Code: 456334066700327005012999 Entry Date: 12/9/2024 11:17:47 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400752767 ',0) 09/12/2024 11:51:24.2813 1860 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-09 11:51:22','V',5184378245758010,2024,'2024-12-09 11:51:20','456334268000327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 09/12/2024 11:56:14.5167 522 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-09 11:56:13','V',5732079566624440,2024,'2024-12-09 11:56:12','456334199600327005012999',2,2,2,'O','',0,'2024-12-09 11:56:13',1,'','',0) 09/12/2024 11:58:10.5008 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 12:00:00.3608 677 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-09 11:56:45',1,'V',5410501397661560,5603087291949350,2024,'2024-12-09 11:56:45',4,1,0,4,'2024-12-09 12:11:45','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 09/12/2024 12:00:01.5616 777 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5603087291949350,5410501397661560,2024,'2024-12-09 12:00:00',' Date: 12/9/2024 11:56:45 AM Code: 456333694300327005012999 Entry Date: 12/9/2024 10:15:43 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400417482 ',0) 09/12/2024 12:02:07.2522 616 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5271514727377050,5181376932270860,2024,'2024-12-09 12:02:06',' Date: 12/9/2024 11:58:53 AM Code: 456334183200327005012999 Entry Date: 12/9/2024 11:37:12 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 # 2400417483 ',0) 09/12/2024 12:03:32.5236 600 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-09 12:00:17',1,'V',4616204272311490,5197214450974340,2024,'2024-12-09 12:00:17',4,1,0,4,'2024-12-09 12:15:17','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/12/2024 12:06:40.1519 555 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 12:06:41.6309 1470 ms. OPEN: select useParkAccess from tabUser where (useBadId = '456333782700327005012999' or useBadId = '456333782700327005012999') 09/12/2024 12:06:44.5899 2958 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/12/2024 12:06:50.3748 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 12:09:27.7048 971 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52771, trcLastPrinted = '2400752771', trcLastDate = '2024-12-09 12:09:26' where trcStatus='V' and trcTerId = 18 09/12/2024 12:11:15.1501 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 12:13:23.5735 527 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-09 12:13:22' where traUID = 4795293265250270 and traStatus='V' and traEnabled=1 09/12/2024 12:13:27.5973 592 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 12:22:36.0945 2256 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 12:25:08.6652 526 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:25:01',5,3,42101,0,50,2,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:25:01',5,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'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 09/12/2024 12:28:31.3467 608 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-09 12:28:30','V',4646044549901780,2024,'2024-12-09 12:28:29','456334490900327005012999',1,2,16,'I','',1,0,1,'','',4) 09/12/2024 12:28:52.6560 907 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 12:37:13.1059 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 12:38:03.4598 553 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 12:38:08.8675 593 ms. OPEN: SELECT traId,traCode,traDateTime,traEnabled FROM movTransitId INNER JOIN movTransit ON traId = tidTraId AND tidTraKey=@tidTraKey WHERE traStatus='V' AND traDirection = 'I' AND traCarId = 0 AND traEnabled = 1 ORDER BY traId DESC LIMIT 100 09/12/2024 12:39:46.8594 1453 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:39:45',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'; 09/12/2024 12:39:47.7961 872 ms. EXEC: update payInventory set invCreation = '2024-12-09 12:39:46',invModify = '2024-12-09 12:39:46',invUseId=0,invStatus='V' where invId = 224048 09/12/2024 12:41:09.4420 571 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/12/2024 12:41:16.6179 502 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-09 12:41:15','V',4675554195257970,2024,'2024-12-09 12:41:14','456334567400327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 180 ms.) 09/12/2024 12:43:43.6749 1061 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:43:42',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 09/12/2024 12:44:32.3547 887 ms. EXEC: update payReceipt set recCreation = '2024-12-09 12:44:31',recModify = '2024-12-09 12:44:31',recUseId=0,recStatus='V' where recId = 330527 09/12/2024 12:45:19.6305 839 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-09 12:45:18' where payTraUID = 5066690620966840 and payStatus='V' and payEnabled=1 09/12/2024 12:45:20.0167 934 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 12:45:24.7940 901 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 12:45:44.1630 847 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4953313678184400,4735361655603910,2024,'2024-12-09 12:45:43','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/9/2024 12:26:09 PM Date : 12/9/2024 12:45:42 PM Code : 456334476900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 09/12/2024 12:45:45.4158 698 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:45:44',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 09/12/2024 12:46:00.1438 607 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 12:46:16.1405 601 ms. EXEC: update payReceipt set recCreation = '2024-12-09 12:46:15',recModify = '2024-12-09 12:46:15',recUseId=0,recStatus='V' where recId = 330531 09/12/2024 12:47:55.6615 632 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 12:50:41.0979 1246 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:50:35',5,3,42101,0,50,-23,-1150,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:50:35',5,3,42101,0,100,-39,-3900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:50:35',5,3,42101,0,200,-2,-400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:50:35',5,3,42101,0,500,-7,-3500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:50:35',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 12:50:35',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 09/12/2024 12:51:05.2822 680 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-09 12:51:04' where traUID = 5260005306329920 and traStatus='V' and traEnabled=1 09/12/2024 12:53:22.8678 552 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/12/2024 12:55:01.5252 506 ms. OPEN: select * from movtransit where traCode = '456333957700327005012999' and traStatus='V' ORDER BY traId DESC 09/12/2024 12:55:54.5189 568 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-09 12:55:53' where payTraUID = 5023447467892260 and payStatus='V' and payEnabled=1 09/12/2024 12:57:23.0315 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 12:57:39.9869 502 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 12:57:54.3266 540 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-09 12:54:40',1,'V',5512838044074740,4660473081534300,2024,'2024-12-09 12:54:40',4,1,0,4,'2024-12-09 13:09:40','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/12/2024 13:02:54.7448 611 ms. EXEC: delete from movRoutes where rtsStatus = 'V' and rtsEnabled = 1 and rtsCode = '456334569800327005012999' 09/12/2024 13:03:19.5005 818 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/12/2024 13:07:18.4854 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 13:08:06.0324 678 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 13:12:31.7693 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 13:12:55.5013 547 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 380575 else acvFstPayId end),acvLstPayId = 380575 where acvSftId = 847 and acvCodeId = 3 09/12/2024 13:12:59.3419 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 13:17:13.6011 1137 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 13:22:35.5648 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 13:24:38.2084 1032 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 09/12/2024 13:24:38.2094 875 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 13:26:49.9431 1046 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 13:34:52.7541 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 13:34:54.9937 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 13:36:15.6970 1732 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-09 13:36:13' where traUID = 4762184292794760 and traStatus='V' and traEnabled=1 09/12/2024 13:36:20.7514 875 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/12/2024 13:36:22.9429 825 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 13:41:37.4696 595 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/12/2024 13:44:51.1530 786 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-09 13:44:50' where payTraUID = 5622916149493790 and payStatus='V' and payEnabled=1 09/12/2024 13:46:35.8535 607 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 13:46:36.4839 510 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-09 13:46:35' where payTraUID = 5343751290044300 and payStatus='V' and payEnabled=1 09/12/2024 13:50:16.4170 1848 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/12/2024 13:53:58.0892 830 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 13:57:12.6072 747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 13:58:07.4541 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 13:59:51.0539 865 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 14:00:21.7976 1705 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/12/2024 14:01:52.2114 1288 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 14:06:50.6514 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 14:12:39.3321 641 ms. EXEC: update payReceipt set recCreation = '2024-12-09 14:12:38',recModify = '2024-12-09 14:12:38',recUseId=0,recStatus='V' where recId = 330579 09/12/2024 14:12:54.6704 679 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 14:12:56.2155 682 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4675554195257970,5407332343361340,2024,'2024-12-09 14:12:55',' Date: 12/9/2024 2:12:54 PM Code: 456334567400327005012999 Entry Date: 12/9/2024 12:41:14 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 # 2400752792 ',0) 09/12/2024 14:16:44.2870 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 14:17:59.9400 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 14:18:42.1174 651 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-09 14:18:40',0,'V',5198690037586390,5533294281126370,2024,'2024-12-09 14:18:40',3,1,0,4,'2024-12-09 14:33:40','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 09/12/2024 14:32:01.5526 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 14:53:55.7884 788 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 14:55:57.4023 800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 14:55:58.1828 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 14:57:27.4699 610 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-09 14:57:26' where traUID = 5673040601091930 and traStatus='V' and traEnabled=1 09/12/2024 14:58:38.0754 1715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 15:00:47.6827 693 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 15:05:06.0617 752 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 15:07:43.1944 631 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 15:07:49.8960 547 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 15:07:49.9550 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 15:07:53.8856 1629 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-09 15:07:51',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 09/12/2024 15:10:56.3235 716 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-09 15:10:55',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 09/12/2024 15:12:49.4797 1267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 15:12:56.6395 517 ms. EXECSCALAR: select count(terId) from tabTerminal where terPassback<>0 and terId = 2 nr: 0 09/12/2024 15:13:23.5166 781 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-12-09 15:13:22','0230004101201',0,0,5596753934190850,9,'0000-00-00 00:00:00','0000-00-00 00:00:00') 09/12/2024 15:13:25.1537 1559 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-09 15:13:23',0,'V',5596753934190850,5645092653873840,2024,'2024-12-09 15:13:23',2,1,0,-1,'2024-12-09 16:13:23','S','KES',0,0,0,'','','',3,0,0) 09/12/2024 15:15:06.7110 688 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-09 15:12:28',12,'V',5370582824393950,5173151297150170,2024,'2024-12-09 15:12:28',17,1,0,4,'2024-12-09 15:27:28','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/12/2024 15:15:07.6447 755 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 380636 else acvFstPayId end),acvLstPayId = 380636 where acvSftId = 849 and acvCodeId = 3 09/12/2024 15:16:20.3806 1254 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 15:17:31.1753 811 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-09 15:17:30' where traUID = 5532431109493310 and traStatus='V' and traEnabled=1 09/12/2024 15:18:33.1110 567 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 09/12/2024 15:23:00.1548 1226 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/12/2024 15:23:06.0708 546 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 09/12/2024 15:23:06.0738 549 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/12/2024 15:23:06.7823 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 15:28:04.2215 1057 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 15:28:30.5773 643 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-09 15:28:29',4,1,'2024-12-09 15:28:29','456335275600327005012999','Payed (Credit Card ) Ticket ') 09/12/2024 15:31:10.2938 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 15:32:23.4210 541 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 380646 else acvFstPayId end),acvLstPayId = 380646 where acvSftId = 849 and acvCodeId = 3 09/12/2024 15:32:35.4521 682 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-09 15:32:34',4,1,'2024-12-09 15:32:34','456335023500327005012999','Payed (Credit Card ) Ticket ') 09/12/2024 15:35:12.8851 742 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-09 15:35:12','V',4673590799458740,2024,'2024-12-09 15:35:11','456335529500327005012999',2,2,2,'O','',0,'2024-12-09 15:35:12',1,'','',0) 09/12/2024 15:36:14.1564 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 15:36:15.0119 804 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/12/2024 15:43:28.8010 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 15:56:49.2189 833 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 16:00:31.2023 704 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 16:02:23.1097 1213 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 16:02:24.6847 680 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-09 15:59:11',1,'V',5205999167733040,5737018649515410,2024,'2024-12-09 15:59:11',4,1,0,4,'2024-12-09 16:14:11','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/12/2024 16:04:27.2813 524 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-09 16:04:26' where traUID = 5737018649515410 and traStatus='V' and traEnabled=1 09/12/2024 16:12:52.2672 887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 16:17:08.4637 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 16:17:08.4787 638 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 09/12/2024 16:20:52.1733 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 16:24:54.6926 542 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-09 16:24:53' where traUID = 5234982233834130 and traStatus='V' and traEnabled=1 09/12/2024 16:29:58.4101 634 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/12/2024 16:31:37.3391 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 16:35:05.4843 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 16:35:57.3752 808 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 16:37:57.8213 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 16:38:15.6643 677 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-09 16:38:14' where subId = 112 09/12/2024 16:38:47.5088 506 ms. EXEC: update payInventory set invCreation = '2024-12-09 16:38:47',invModify = '2024-12-09 16:38:47',invUseId=0,invStatus='V' where invId = 224149 09/12/2024 16:44:13.6746 1864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 16:45:47.1826 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 16:46:34.4474 1270 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 16:53:21.9978 734 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 16:55:34.5620 579 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 09/12/2024 16:58:06.6474 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 17:02:07.8408 640 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 17:03:21.2302 2159 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-09 17:03:19' where subId = 194 09/12/2024 17:05:40.0727 580 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-09 17:05:39','V',4766863713371870,2024,'2024-12-09 17:05:38','456335592200327005012999',2,2,2,'O','',0,'2024-12-09 17:05:39',1,'','',0) 09/12/2024 17:07:42.2900 867 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 17:10:10.5238 542 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/12/2024 17:11:54.8330 851 ms. EXEC: update abbCards set carLastDate = '2024-12-09 17:11:53',carLastDirection='O' where carStatus='V' and carId = 8 09/12/2024 17:11:58.6786 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 17:17:49.7389 1307 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 09/12/2024 17:23:23.4996 548 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17515, trcLastPrinted = '2400417515', trcLastDate = '2024-12-09 17:23:22' where trcStatus='V' and trcTerId = 4 09/12/2024 17:25:24.6212 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 17:27:24.3278 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 17:32:24.8321 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 17:34:13.7594 514 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 09/12/2024 17:34:31.7956 1227 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 17:34:56.6053 617 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 17:34:57.8581 1251 ms. EXEC: update abbCards set carLastDate = '2024-12-09 17:34:56',carLastDirection='O' where carStatus='V' and carId = 151 09/12/2024 17:37:25.5466 510 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-09 17:37:25','V',4815121978401810,2024,'2024-12-09 17:37:22','456336344200327001012999',1,2,1,'I','',1,0,1,'','0230003944081',15,0) 09/12/2024 17:41:20.5468 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 17:50:58.6860 798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 17:53:46.3829 833 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 17:58:43.3018 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 18:01:27.5844 924 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 18:01:58.5052 659 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-09 18:01:57',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-09 18:01:57',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'; 09/12/2024 18:19:53.0056 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 18:21:51.0221 951 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-09 18:21:50' where subId = 22 09/12/2024 18:21:54.2893 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 18:22:05.2116 1836 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 09/12/2024 18:29:29.6929 571 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 09/12/2024 18:33:03.6379 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 18:34:57.0733 885 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 18:37:06.8427 520 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 09/12/2024 18:37:45.4557 746 ms. EXEC: update payReceipt set recCreation = '2024-12-09 18:37:44',recModify = '2024-12-09 18:37:44',recUseId=0,recStatus='V' where recId = 330675 09/12/2024 18:38:39.9834 711 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 09/12/2024 18:38:41.7025 847 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52807, trcLastPrinted = '2400752807', trcLastDate = '2024-12-09 18:38:40' where trcStatus='V' and trcTerId = 18 09/12/2024 18:39:35.0194 570 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-09 18:39:34' where traUID = 5104102963679200 and traStatus='V' and traEnabled=1 09/12/2024 18:39:40.0708 1130 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/12/2024 18:44:11.2024 877 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 18:45:16.0090 532 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-09 18:45:15','V',5042660876816830,2024,'2024-12-09 18:45:13','456336714900327005012999',2,2,2,'O','',0,'2024-12-09 18:45:15',1,'','0230003944081',15,0) 09/12/2024 18:54:46.5371 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 18:56:46.9752 682 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 18:59:19.2617 641 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-09 18:59:18',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 09/12/2024 19:08:11.4010 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 19:09:20.5926 540 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-09 19:09:19',0,'V',5165052977024880,5685059557183500,2024,'2024-12-09 19:09:19',3,1,0,4,'2024-12-09 19:24:19','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 09/12/2024 19:12:23.5798 702 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-09 19:12:22',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-09 19:12:22',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'; 09/12/2024 19:12:39.1563 636 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-09 19:12:38' where traUID = 5667040049016750 and traStatus='V' and traEnabled=1 09/12/2024 19:12:42.0442 725 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 09/12/2024 19:12:42.4014 765 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 19:12:43.6793 973 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-09 19:12:42','V',4676423561059660,2024,'2024-12-09 19:12:37','456336915700327005012999',1,2,16,'I','',1,0,1,'','',4) 09/12/2024 19:13:20.9094 760 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 19:18:11.8803 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 19:19:12.5851 1610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 19:24:47.8348 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 19:29:02.1951 1309 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 09/12/2024 19:31:42.8663 609 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-09 19:31:42' where payTraUID = 4948995621517490 and payStatus='V' and payEnabled=1 09/12/2024 19:31:47.7636 726 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 19:33:06.4866 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 19:39:42.5602 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 19:41:20.9124 1468 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 19:49:43.8961 525 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-09 19:49:43',0,'V',5705925608930240,4881807340085640,2024,'2024-12-09 19:49:43',18,1,0,4,'2024-12-09 20:04:43','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/12/2024 19:51:11.5150 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 19:58:49.9267 904 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/12/2024 20:00:10.6890 702 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 20:06:36.6059 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 20:07:43.2938 1524 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 09/12/2024 20:07:46.6390 854 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 20:20:20.1903 743 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 20:24:15.7479 1578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 20:28:45.0132 761 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-09 20:28:44','V',5273530780259240,2024,'2024-12-09 20:28:42','456337059400327005012999',2,2,2,'O','',0,'2024-12-09 20:28:44',1,'','',0) 09/12/2024 20:31:42.5948 1260 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-09 20:28:26',1,'V',5138601091164760,5429968710238200,2024,'2024-12-09 20:28:26',4,1,0,4,'2024-12-09 20:43:26','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 09/12/2024 20:41:03.5825 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 21:04:12.8938 844 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 21:10:41.3323 556 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 21:12:48.7481 1492 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 21:19:23.6760 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 21:21:06.3111 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 21:21:25.7752 727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 21:29:13.2970 518 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 09/12/2024 21:29:16.8944 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 21:30:24.4429 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 21:30:47.9127 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 21:48:06.3678 505 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 21:55:57.5280 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 22:00:21.4257 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 22:03:06.1546 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 22:06:52.1317 621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 22:08:21.1617 575 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 22:09:32.6918 2262 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-09 22:09:30',3,42101,0,200,1,200,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N'; (WAIT TIME 73 ms.) 09/12/2024 22:10:56.4902 907 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 22:13:10.5815 1179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 22:21:21.0777 508 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 09/12/2024 22:21:21.0787 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 22:34:28.1256 572 ms. EXEC: update payInventory set invCreation = '2024-12-09 22:34:27',invModify = '2024-12-09 22:34:27',invUseId=0,invStatus='V' where invId = 224214 09/12/2024 22:42:00.1540 607 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 09/12/2024 22:44:43.7261 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 22:47:44.2246 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 22:49:47.7368 951 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 09/12/2024 22:52:18.3211 673 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 22:54:08.5473 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 23:03:02.9541 606 ms. EXEC: update paycash set casCreation = '2024-12-09 23:03:02',casModify = '2024-12-09 23:03:02',casUseId=0,casStatus='V' where casId = 199180 09/12/2024 23:03:04.0269 659 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-09 23:03:03',0,0,'V',5329435811471940,4794538507173300,2024,'2024-12-09 23:03:03',3,'KES',-1,50,-50,'N',''); 09/12/2024 23:16:13.5474 1231 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 23:36:26.1698 605 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 09/12/2024 23:36:29.6391 1082 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 09/12/2024 23:40:36.8065 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1