30/11/2024 00:04:32.7175 2383 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 03:32:56.9920 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/11/2024 04:21:26.2894 570 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 06:37:50.4092 781 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/11/2024 07:37:32.8099 743 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/11/2024 08:37:43.0754 1763 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 30/11/2024 08:46:51.4936 1974 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 18 order by traDateTime desc,traId desc 30/11/2024 09:25:56.1371 1200 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-30 09:25:54',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 30/11/2024 09:26:21.7613 1000 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/11/2024 09:34:07.0529 576 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/11/2024 09:38:44.2256 716 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-30 09:38:43' where traUID = 5194060544296770 and traStatus='V' and traEnabled=1 30/11/2024 09:39:18.7938 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/11/2024 09:39:40.2372 974 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-30 09:39:39','V',5161645083519330,2024,'2024-11-30 09:39:38','456243477800327005012999',1,2,16,'I','',1,0,1,'','0560008421774',187,0) 30/11/2024 09:39:44.6881 958 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 09:51:43.6564 1672 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 30/11/2024 10:16:32.5806 808 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-30 10:16:31',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'; 30/11/2024 10:27:23.2766 2785 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 30/11/2024 10:29:36.2950 8496 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 30/11/2024 10:34:31.5685 651 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-30 10:34:30' where traUID = 4735970300098290 and traStatus='V' and traEnabled=1 30/11/2024 10:37:48.9208 1373 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 106 order by traDateTime desc,traId desc 30/11/2024 10:40:01.6147 1652 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 30/11/2024 10:40:02.9336 662 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-30 10:40:02' where subId = 16 30/11/2024 10:40:08.7415 1269 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/11/2024 11:06:58.3802 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 11:09:46.2383 633 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-30 11:09:45','V',4682871457326110,2024,'2024-11-30 11:09:45','456243731000327001012999',2,2,2,'O','',0,'2024-11-30 11:09:45',1,'','',0) 30/11/2024 11:29:56.3073 658 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 30/11/2024 11:31:13.4326 5084 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 = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 30/11/2024 11:48:32.6369 523 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-30 11:48:32',0,16,'2024-11-30 11:48:32','','Manual Open Barrier Entry 2') 30/11/2024 11:52:44.4949 565 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-30 11:52:43','V',4646537951315930,2024,'2024-11-30 11:52:43','456244191400327005012999',2,2,2,'O','',0,'2024-11-30 11:52:43',1,'','',0) 30/11/2024 11:52:45.6077 857 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-30 11:52:44' where traUID = 5654593789334140 and traStatus='V' and traEnabled=1 30/11/2024 11:52:48.2374 782 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 12:42:35.8475 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/11/2024 12:43:00.4640 1070 ms. EXEC: update payInventory set invCreation = '2024-11-30 12:42:59',invModify = '2024-11-30 12:42:59',invUseId=0,invStatus='V' where invId = 222352 30/11/2024 12:43:50.2724 1155 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-30 12:43:49' where traUID = 5455520459423750 and traStatus='V' and traEnabled=1 30/11/2024 12:47:17.1877 565 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/11/2024 12:52:05.1487 520 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-30 12:52:04','V',5056048729703550,2024,'2024-11-30 12:52:04','456244312000327005012999',2,2,2,'O','',0,'2024-11-30 12:52:04',1,'','',0) 30/11/2024 12:53:37.8098 703 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/11/2024 12:55:44.3966 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/11/2024 13:02:49.6126 508 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-30 13:02:49',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'; 30/11/2024 13:03:11.2601 673 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 13:09:21.4412 615 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 30/11/2024 13:09:36.5933 748 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 13:56:18.4142 820 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 13:57:01.7212 835 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 13:59:18.1155 605 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-30 13:59:17','V',5473318712524910,2024,'2024-11-30 13:59:16','456244981100327005012999',2,2,2,'O','',0,'2024-11-30 13:59:17',1,'','',0) 30/11/2024 13:59:18.7629 637 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/11/2024 14:39:40.0992 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/11/2024 14:41:31.5488 781 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 30/11/2024 15:00:16.5901 849 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/11/2024 15:21:21.0511 708 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 15:45:35.0595 579 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 30/11/2024 15:49:40.7681 833 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/11/2024 15:54:52.4229 557 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 30/11/2024 16:15:47.4345 574 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-30 16:15:46' where traUID = 5739789192536320 and traStatus='V' and traEnabled=1 30/11/2024 17:03:30.4168 691 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/11/2024 17:24:38.3547 607 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 30/11/2024 17:51:28.5371 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/11/2024 19:09:17.2416 559 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 30/11/2024 19:56:58.8010 920 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-30 19:56:57' where traUID = 5054268291287330 and traStatus='V' and traEnabled=1 30/11/2024 20:00:41.5082 505 ms. EXEC: update payReceipt set recCreation = '2024-11-30 20:00:41',recModify = '2024-11-30 20:00:41',recUseId=0,recStatus='V' where recId = 327681 30/11/2024 20:05:18.7029 1288 ms. EXEC: update tabTerminalReceipt set trcProgressive = 51619, trcLastPrinted = '2400751619', trcLastDate = '2024-11-30 20:05:17' where trcStatus='V' and trcTerId = 18 30/11/2024 20:05:19.1001 647 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 30/11/2024 20:05:19.1071 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 30/11/2024 20:26:43.8488 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 21:17:07.9239 548 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-30 21:17:07' where payTraUID = 5363790401571530 and payStatus='V' and payEnabled=1 30/11/2024 22:10:11.0098 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 30/11/2024 22:10:11.5972 571 ms. EXEC: UPDATE payCash SET casType='N' WHERE casType<>'N' AND ABS(casSingleAmount) IN (100,200,500); 30/11/2024 22:10:11.8454 864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1