26/01/2025 00:08:04.5811 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 00:11:10.9529 5116 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/01/2025 00:12:47.7877 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 00:12:49.1085 1365 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/01/2025 00:13:33.8539 510 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 ('2025-01-26 00:10:11',1,'V',5297613374463740,5003610360794650,2025,'2025-01-26 00:10:11',17,1,0,4,'2025-01-26 00:25:11','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 26/01/2025 00:15:09.6987 1034 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,'2025-01-26 00:15:08','V',4627034226039800,2025,'2025-01-26 00:15:08','456807924800327005012999',2,2,2,'O','',0,'2025-01-26 00:15:08',1,'','',0) 26/01/2025 00:15:57.8132 1123 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 26/01/2025 00:16:35.5311 714 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/01/2025 00:16:35.5741 596 ms. OPEN: select ticId from tabTicketType where ticStatus='V' and ticType = 1 26/01/2025 00:18:32.2241 587 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 00:19:13.6243 894 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456810115100327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 26/01/2025 00:20:32.9744 911 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-26 00:20:31' where traUID = 5123700472299420 and traStatus='V' and traEnabled=1 26/01/2025 00:20:37.7894 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 00:22:15.1682 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 00:25:39.3166 960 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 00:28:24.4143 586 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-26 00:28:23',0,'V',5182855000684880,5504185296770670,2025,'2025-01-26 00:28:23',18,1,0,4,'2025-01-26 00:43:23','C','KES',300,300,0,'','','',1,300,0,0,'',0,0) 26/01/2025 00:29:16.0441 669 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-26 00:29:15',0,2,'2025-01-26 00:29:15','','Unauthorized Transit Exit 1') 26/01/2025 00:30:05.3293 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 00:33:07.2797 931 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 00:33:45.0166 2706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 00:34:45.2108 916 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 26/01/2025 00:34:46.9629 518 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/01/2025 00:37:53.3691 586 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 26/01/2025 00:38:19.7458 1549 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-26 00:38:18',17,1,'2025-01-26 00:38:18','456806865400327005012999','Pagato (Contanti ) Biglietto ') 26/01/2025 00:39:07.9484 649 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-01-26 00:39:07',0,2,'2025-01-26 00:39:07','','Unauthorized Transit Exit 1') 26/01/2025 00:41:42.9947 1568 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/01/2025 00:42:58.5016 562 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-26 00:42:57' where payTraUID = 5709042069960310 and payStatus='V' and payEnabled=1 26/01/2025 00:43:05.4210 513 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 26/01/2025 00:46:22.0807 675 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 00:56:47.0230 850 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/01/2025 01:02:18.8354 609 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 01:02:24.2579 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:02:59.5623 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:03:36.7298 773 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 26/01/2025 01:04:00.4068 1919 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:04:05.4510 3551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:04:45.7496 667 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:04:49.4209 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:05:34.1413 941 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:07:00.6231 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:07:17.3727 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:10:25.9743 576 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 26/01/2025 01:15:32.9040 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:15:43.4236 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:16:44.6314 1128 ms. OPEN: show columns from movAnomaly where Field = 'anmMandatory' 26/01/2025 01:16:51.3487 1014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:19:17.0343 816 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-26 01:19:16' where traUID = 5367423395456900 and traStatus='V' and traEnabled=1 26/01/2025 01:21:09.0734 1042 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:22:26.9818 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:36:54.7852 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,'2025-01-26 01:36:54','V',4966097806536520,2025,'2025-01-26 01:36:52','456810552300327005012999',2,2,2,'O','',0,'2025-01-26 01:36:54',1,'','',0) 26/01/2025 01:39:32.9145 741 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 1 ms.) 26/01/2025 01:48:11.3562 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:48:25.7254 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 01:55:30.4677 914 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:01:03.6470 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:03:41.4902 607 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:05:16.3604 542 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/01/2025 02:15:07.1760 892 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:16:36.4216 626 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-26 02:16:35' where payTraUID = 5239687359276770 and payStatus='V' and payEnabled=1 26/01/2025 02:16:37.6904 1267 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-26 02:16:35' where traUID = 5239687359276770 and traStatus='V' and traEnabled=1 26/01/2025 02:17:36.3576 825 ms. EXEC: update payReceipt set recCreation = '2025-01-26 02:17:35',recModify = '2025-01-26 02:17:35',recUseId=0,recStatus='V' where recId = 345930 (WAIT TIME 13 ms.) 26/01/2025 02:19:08.0498 575 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,'2025-01-26 02:19:07','V',4931329178957240,2025,'2025-01-26 02:19:06','456810625600327005012999',2,2,2,'O','',0,'2025-01-26 02:19:07',1,'','',0) 26/01/2025 02:19:13.9425 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 02:19:14.4558 506 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 26/01/2025 02:19:34.4025 1111 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:22:54.9716 907 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 02:29:54.5357 506 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/01/2025 02:39:40.0662 519 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-26 02:39:39' where payTraUID = 5022672285009010 and payStatus='V' and payEnabled=1 26/01/2025 02:39:48.3845 1129 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/01/2025 02:42:30.2231 1067 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:42:46.3574 699 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:44:16.5526 557 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/01/2025 02:44:17.5852 709 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-26 02:44:16' where payTraUID = 5305789003885360 and payStatus='V' and payEnabled=1 26/01/2025 02:44:20.8603 774 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 02:45:09.7033 995 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:45:31.1659 1416 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:45:32.8459 799 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:50:46.8521 639 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:54:42.8627 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:54:59.5633 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 02:55:52.8331 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 03:10:32.6543 558 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 03:14:44.9993 878 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 03:20:14.9598 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 03:28:28.1270 508 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/01/2025 03:31:36.0581 896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 03:42:22.7882 737 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 03:49:25.0762 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 04:09:38.7658 985 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 04:12:23.6734 1103 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 04:16:02.5082 595 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 26/01/2025 04:19:48.2093 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 04:22:28.9472 501 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/01/2025 04:22:33.0698 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 04:42:48.4425 606 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/01/2025 04:45:25.8193 1134 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 04:48:03.9126 614 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 04:48:42.8883 1718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 04:52:37.4330 682 ms. EXEC: update tabTerminalReceipt set trcProgressive = 3669, trcLastPrinted = '2500703669', trcLastDate = '2025-01-26 04:52:36' where trcStatus='V' and trcTerId = 18 26/01/2025 04:54:37.9184 1015 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 05:07:24.2844 564 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2025-01-26 05:07:23',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 26/01/2025 05:10:50.2350 1315 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 05:11:57.3675 668 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 05:19:20.5002 1188 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 05:29:59.1451 966 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/01/2025 05:33:34.0264 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 05:42:56.7372 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 05:45:22.3105 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 05:45:22.9569 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 05:45:23.6284 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 05:45:24.4639 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 05:54:58.7412 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 06:02:31.3762 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 06:04:31.8917 796 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 06:04:54.7051 587 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 06:18:40.2531 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 06:20:41.7591 689 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/01/2025 06:21:26.7527 560 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/01/2025 06:21:27.2700 1073 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/01/2025 06:21:47.0866 778 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/01/2025 06:23:19.4702 1734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 06:25:10.4075 1638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 06:32:42.5052 1716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 06:49:40.5838 645 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 26/01/2025 06:51:40.6659 772 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 06:52:02.7139 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 06:57:50.6505 802 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 07:01:51.0029 730 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/01/2025 07:18:27.6559 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 07:21:07.4633 821 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 26/01/2025 07:21:52.3267 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 07:34:59.4558 531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 07:52:54.5796 1035 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:02:17.2774 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:09:22.5481 1025 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:10:17.7991 518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:12:06.7682 1261 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:12:12.8911 920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:15:18.9552 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 08:17:02.1276 764 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:22:53.8537 1064 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:24:17.4987 685 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 26/01/2025 08:24:17.4997 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:24:34.4725 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:25:54.6703 509 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/01/2025 08:32:48.8430 704 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/01/2025 08:33:58.3310 1521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:35:41.4594 787 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 26/01/2025 08:35:45.6791 933 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:37:56.9643 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:41:03.0182 816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:45:32.5562 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 08:48:06.5828 1230 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:50:30.3290 559 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/01/2025 08:57:11.9547 1112 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 08:58:48.3358 1070 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 09:02:29.8883 992 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 09:02:45.5732 1761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 09:05:27.1657 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 09:07:21.6113 1161 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/01/2025 09:07:22.2527 594 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 ('2025-01-26 09:07:21',0,'V',4822085772397850,4724626582377620,2025,'2025-01-26 09:07:21',2,1,0,-1,'2025-01-26 10:07:21','S','KES',0,0,0,'','','',3,0,0) 26/01/2025 09:07:25.8259 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 09:08:31.1984 1182 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/01/2025 09:17:43.3459 26291 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 26/01/2025 09:17:46.7675 859 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:46.7685 820 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:46.7695 823 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:46.7705 850 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:46.7725 847 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:46.7735 840 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:46.7765 817 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 8 ms.) 26/01/2025 09:17:46.7845 845 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:46.7885 851 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:46.7915 874 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:46.7945 878 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:46.7995 888 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-01-26 08:17:45') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-01-26 09:17:45' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-01-26 09:17:45' and (resAreId = 1 or resAreId <= 0) nr: 0 26/01/2025 09:17:55.4412 7724 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456813296700327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 26/01/2025 09:17:56.1897 10650 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 26/01/2025 09:17:56.9272 562 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 26/01/2025 09:17:59.2595 1750 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,'2025-01-26 09:17:57','V',5061553782349670,2025,'2025-01-26 09:09:27','456813296700327005031999',1,2,16,'I','',1,0,1,'','',4) 26/01/2025 09:18:00.4508 1179 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/01/2025 09:18:00.9609 4548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/01/2025 09:18:03.5255 2564 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 26/01/2025 09:33:15.5517 3132 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 26/01/2025 10:49:37.4075 12131 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/01/2025 11:10:11.4581 921 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 26/01/2025 11:46:32.9490 1227 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 26/01/2025 12:15:54.2821 543 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-26 12:15:53' where traUID = 5750695508012260 and traStatus='V' and traEnabled=1 26/01/2025 13:00:36.2651 576 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 26/01/2025 13:30:23.7876 507 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-26 13:30:23' where traUID = 4934724244511160 and traStatus='V' and traEnabled=1 26/01/2025 14:18:48.9515 631 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-26 14:18:48' where traUID = 5043581069770460 and traStatus='V' and traEnabled=1 26/01/2025 18:50:44.8834 690 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 26/01/2025 21:23:22.7414 800 ms. EXEC: update payReceipt set recCreation = '2025-01-26 21:23:21',recModify = '2025-01-26 21:23:21',recUseId=0,recStatus='V' where recId = 346168