06/11/2024 00:03:10.7453 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 00:06:29.4599 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 00:08:12.3056 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 506 ms.) 06/11/2024 00:19:33.2692 680 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 00:22:46.7383 501 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/11/2024 00:24:17.1587 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 00:26:47.2048 1309 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/11/2024 00:27:49.8877 823 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 06/11/2024 00:29:40.1963 923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 00:39:02.3806 1278 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 00:41:34.1439 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 00:43:32.3949 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 00:56:33.4262 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 00:59:27.1412 1265 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:10:13.8599 1619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:10:47.7706 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:17:05.3586 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:17:15.2482 1403 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:18:34.2510 1185 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:24:03.5968 742 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 06/11/2024 01:31:09.9955 659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:31:59.7277 1615 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:36:17.9721 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:38:38.2007 791 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/11/2024 01:44:12.8561 1285 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:44:52.3344 761 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/11/2024 01:47:51.3259 1250 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:49:00.6912 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:52:04.7531 858 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/11/2024 01:52:33.9576 632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 01:58:19.8935 579 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/11/2024 02:11:16.4619 872 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 02:11:19.2008 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 02:22:06.9231 768 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 02:26:55.2416 694 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 02:39:23.6492 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 02:39:28.2423 839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 02:39:42.0435 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 02:50:00.6645 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 02:53:49.2160 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:00:21.2587 749 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 03:00:21.8041 1676 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 06/11/2024 03:03:16.7419 2352 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:08:18.6735 2279 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/11/2024 03:08:29.5497 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:10:48.4624 1013 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:12:20.1797 959 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:13:51.7378 1179 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:17:00.3857 856 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5003279442535600,4960852596488220,2024,'2024-11-06 03:16:59',' Date: 11/6/2024 3:14:30 AM Code: 456001034200327005012999 Entry Date: 11/6/2024 2:52:22 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 # 2400415616 ',0) (WAIT TIME 1 ms.) 06/11/2024 03:17:03.3037 1926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:19:08.3111 583 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 03:29:01.8523 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:29:19.5842 676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:38:10.8168 1359 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:46:20.9280 779 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:54:29.6352 1257 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 03:57:10.5587 1186 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 04:00:06.0898 887 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 04:00:36.0408 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 04:06:29.9601 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 04:09:15.8188 1624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 04:16:12.5080 2183 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 04:32:12.0070 1463 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 04:38:48.6117 3975 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 06/11/2024 04:59:35.4021 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 04:59:37.6305 891 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/11/2024 05:01:06.6260 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 05:03:19.4686 971 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/11/2024 05:15:38.0046 1255 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 05:16:05.3309 787 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 05:20:48.9306 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 05:20:48.9316 531 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/11/2024 05:21:20.0073 1729 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 05:25:50.9582 711 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 05:42:53.6309 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 05:54:20.5725 1133 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 05:59:07.6972 842 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 06:07:12.2457 907 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 06:15:07.7371 1290 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 06:16:25.5370 662 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-11-06 06:13:49',1,'V',5160871514013950,4930263804947250,2024,'2024-11-06 06:13:49',4,1,0,4,'2024-11-06 06:28:49','P','KES',150,150,0,'','','',1,150,0,0,'',0,0) 06/11/2024 06:22:17.5540 611 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/11/2024 06:22:17.5840 810 ms. EXEC: update abbCards set carLastDate = '2024-11-06 06:22:16',carLastDirection='I' where carStatus='V' and carId = 163 (WAIT TIME 12 ms.) 06/11/2024 06:25:27.4838 629 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 07:01:20.7362 546 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 07:02:42.7099 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 07:03:01.0792 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 07:04:40.7858 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 07:05:38.4212 1084 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-06 07:05:37','V',4821404914063120,2024,'2024-11-06 07:05:35','456002474700327001012999',2,2,2,'O','',0,'2024-11-06 07:05:37',1,'','',0) 06/11/2024 07:06:36.2809 779 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 06/11/2024 07:07:42.2559 977 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 06/11/2024 07:09:47.0422 687 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 07:11:08.9049 803 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/11/2024 07:22:23.0239 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 07:28:35.0432 913 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 07:33:12.2162 552 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 06/11/2024 07:35:43.0890 651 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48497, trcLastPrinted = '2400748497', trcLastDate = '2024-11-06 07:35:42' where trcStatus='V' and trcTerId = 18 06/11/2024 07:37:44.0207 1299 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/11/2024 07:39:09.0575 937 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 07:41:13.6336 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 07:42:52.6747 673 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 07:43:26.3002 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 07:45:52.7780 1278 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/11/2024 07:52:41.2881 546 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 367715 else acvFstPayId end),acvLstPayId = 367715 where acvSftId = 819 and acvCodeId = 3 06/11/2024 07:52:57.9262 742 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 07:53:17.3892 724 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/11/2024 07:59:50.0554 801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:02:22.0638 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-11-06 08:02:21','V',5129504176442380,2024,'2024-11-06 08:02:20','456002785500327001012999',2,2,2,'O','',0,'2024-11-06 08:02:21',1,'','',0) 06/11/2024 08:02:22.6222 550 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/11/2024 08:02:23.9361 1151 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-06 08:02:22' where traUID = 5474428943218710 and traStatus='V' and traEnabled=1 06/11/2024 08:02:27.5755 619 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 08:04:26.8371 663 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/11/2024 08:07:34.8636 1748 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:08:30.4588 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:09:15.8140 652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:15:02.0071 1866 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/11/2024 08:15:17.3144 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 70 ms.) 06/11/2024 08:15:25.5899 681 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:16:02.1043 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 08:17:52.3358 1290 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/11/2024 08:25:00.5887 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 08:25:00.8799 756 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/11/2024 08:25:14.9343 2728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:25:15.2405 1425 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-06 08:25:13','V',5655399246123040,2024,'2024-11-06 08:25:09','456003030900327005012999',1,2,16,'I','',1,0,1,'','0230003944406',17,0) 06/11/2024 08:25:17.5060 1680 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/11/2024 08:33:12.6182 1367 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-06 08:33:11','V',4618642664336090,2024,'2024-11-06 08:33:08','456003078800327005012999',1,2,16,'I','',1,0,1,'','0230003942254',18,0) 06/11/2024 08:34:02.9448 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 08:36:56.8779 1393 ms. EXEC: update payReceipt set recCreation = '2024-11-06 08:36:55',recModify = '2024-11-06 08:36:55',recUseId=0,recStatus='V' where recId = 319637 06/11/2024 08:37:18.4953 1135 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/11/2024 08:37:38.7148 2806 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/11/2024 08:37:44.3816 2311 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:39:27.3493 506 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 06/11/2024 08:39:28.2199 784 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-06 08:39:27' where payTraUID = 4770670459026340 and payStatus='V' and payEnabled=1 06/11/2024 08:39:36.2283 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 08:41:04.7664 1206 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 06/11/2024 08:41:27.6977 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 08:41:32.7420 2107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:45:14.3520 620 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:46:32.6352 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:47:51.2137 1148 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:47:56.6663 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:49:13.6838 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:49:17.1721 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:49:35.6694 2259 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-06 08:49:33' where payTraUID = 4692911731397240 and payStatus='V' and payEnabled=1 06/11/2024 08:49:36.3379 667 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-06 08:49:33' where traUID = 4692911731397240 and traStatus='V' and traEnabled=1 06/11/2024 08:49:42.6541 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 08:51:19.3476 523 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-06 08:51:18','V',5147290761611010,2024,'2024-11-06 08:51:17','456003187700327005012999',1,2,16,'I','',1,0,1,'','',4) 06/11/2024 08:56:18.9456 720 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:59:15.9608 771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 08:59:20.0185 2037 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/11/2024 09:02:37.2622 2749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:06:22.3825 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:08:19.7418 1327 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-06 09:08:18' where traUID = 4644021995528050 and traStatus='V' and traEnabled=1 06/11/2024 09:08:26.4003 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 09:08:59.8346 1245 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:09:04.5487 2747 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:09:04.7929 1516 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 110 ms.) 06/11/2024 09:09:14.2292 2304 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 456 ms.) 06/11/2024 09:11:07.6709 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 09:11:40.5679 1583 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-11-06 09:09:04',1,'V',5351804817775170,5162774758754280,2024,'2024-11-06 09:09:04',4,1,0,4,'2024-11-06 09:24:04','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/11/2024 09:11:51.6313 1992 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-06 09:11:49','V',5611738853165190,2024,'2024-11-06 09:11:48','456003310800327005012999',1,2,16,'I','',1,0,1,'','',4) 06/11/2024 09:12:12.4331 943 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15631, trcLastPrinted = '2400415631', trcLastDate = '2024-11-06 09:12:11' where trcStatus='V' and trcTerId = 4 06/11/2024 09:12:37.3238 650 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 06/11/2024 09:13:14.5406 662 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 09:13:46.8832 3588 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:18:27.2974 1330 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:19:29.8331 983 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/11/2024 09:19:34.8255 731 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:19:50.5830 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:20:13.7414 516 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/11/2024 09:23:46.6186 1063 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:30:46.5399 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:33:46.7402 1032 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-06 09:33:45','V',4804053947470670,2024,'2024-11-06 09:33:45','456003178700327005031999',2,2,2,'O','',0,'2024-11-06 09:33:45',1,'','',0) 06/11/2024 09:33:47.9260 769 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-06 09:33:47' where traUID = 4807697362492790 and traStatus='V' and traEnabled=1 06/11/2024 09:35:01.9064 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 09:36:19.1069 1436 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:39:04.4703 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:41:20.9034 867 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 09:46:53.9167 1807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:50:18.5973 613 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/11/2024 09:50:53.3625 1761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:51:46.3229 561 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 06/11/2024 09:55:00.3394 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:55:55.7754 1771 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 09:58:53.3759 938 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 06/11/2024 10:00:15.1505 2130 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:01:08.1619 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:01:20.8464 1795 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/11/2024 10:01:42.6820 732 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/11/2024 10:01:48.0195 900 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:03:38.9916 588 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/11/2024 10:04:24.3319 1103 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' (WAIT TIME 128 ms.) 06/11/2024 10:07:11.3724 512 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/11/2024 10:07:11.5935 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:07:13.7410 1194 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:08:11.2003 503 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-06 10:08:10','V',5182059002925180,2024,'2024-11-06 10:08:08','456003310800327005012999',2,2,2,'O','',0,'2024-11-06 10:08:10',1,'','',0) 06/11/2024 10:08:12.0689 607 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-06 10:08:11' where traUID = 5611738853165190 and traStatus='V' and traEnabled=1 06/11/2024 10:08:21.0699 822 ms. EXEC: update abbCards set carLastDate = '2024-11-06 10:08:20',carLastDirection='I' where carStatus='V' and carId = 25 06/11/2024 10:08:21.1430 723 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/11/2024 10:08:25.5709 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:10:52.9673 985 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/11/2024 10:13:58.6453 794 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:14:07.9445 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:14:21.8187 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:14:29.4818 1080 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:17:45.2846 1150 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-06 10:17:44','V',5198505801278160,2024,'2024-11-06 10:17:42','456002284200327005012999',2,2,2,'O','',0,'2024-11-06 10:17:44',1,'','',0) 06/11/2024 10:17:51.7549 651 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:25:14.4664 1555 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/11/2024 10:26:59.4195 1518 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:28:58.2948 536 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/11/2024 10:29:13.4920 2041 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 06/11/2024 10:29:57.2102 2932 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 06/11/2024 10:30:07.3429 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:30:13.0988 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:30:41.1375 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:31:10.8723 693 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:32:47.0786 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:33:24.4405 1763 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:34:21.3545 537 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/11/2024 10:34:21.3555 538 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 06/11/2024 10:35:07.6954 2066 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/11/2024 10:35:13.8866 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:35:32.3469 2241 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 33 ms.) 06/11/2024 10:35:33.3155 968 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-06 10:35:32',0,16,'2024-11-06 10:35:32','','Unauthorized Transit Entry 2') 06/11/2024 10:35:57.1174 595 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/11/2024 10:36:37.7175 1443 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-11-06 10:36:36',0,'V',5160941317572930,5368448722674360,2024,'2024-11-06 10:36:36',18,1,0,4,'2024-11-06 10:51:36','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/11/2024 10:36:38.7132 601 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5368448722674360,5160941317572930,2024,'2024-11-06 10:36:38',' Date: 11/6/2024 10:36:36 AM Code: 456003463800327005012999 Entry Date: 11/6/2024 9:37:18 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 # 2400748520 ',0) 06/11/2024 10:37:24.5168 3215 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 06/11/2024 10:38:13.0291 611 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:38:13.5755 3638 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/11/2024 10:38:22.4885 1096 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:38:42.3697 754 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-06 10:38:41','V',4979904858249430,2024,'2024-11-06 10:38:39','456003831900327005012999',1,2,16,'I','',1,0,1,'','',4) 06/11/2024 10:40:03.6890 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:41:33.2528 1104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:42:06.6801 1800 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:42:25.8069 1378 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:47:22.9332 1776 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:47:58.6841 649 ms. EXEC: update payCurInventory set curQuantity=0,curAmount=0 where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 06/11/2024 10:48:00.8636 2179 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:45',5,3,42101,0,50,-8,-400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:45',5,3,42101,0,50,8,400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:45',5,3,42101,0,100,-20,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:45',5,3,42101,0,100,20,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:45',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-11-06 10:47:45',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-11-06 10:47:45',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:45',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:45',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-11-06 10:47:45',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-11-06 10:47:45',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 06/11/2024 10:48:03.0150 1863 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:55',5,3,42101,0,50,-9,-450,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:55',5,3,42101,0,100,-20,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:55',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-11-06 10:47:55',5,3,42101,0,500,-1,-500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:47:55',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-11-06 10:47:55',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 06/11/2024 10:48:31.1488 1276 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:48:56.4096 1519 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 06/11/2024 10:51:26.0565 1994 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 06/11/2024 10:52:22.7644 1492 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:52:16',5,3,42101,0,50,14,700,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+14,5),curAmount=round(curAmount+700,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-06 10:52:16',5,3,42101,0,100,3,300,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+3,5),curAmount=round(curAmount+300,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 06/11/2024 10:54:25.1171 831 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-06 10:54:24','V',5352934939628210,2024,'2024-11-06 10:54:22','455978205700327005012999',2,2,2,'O','',0,'2024-11-06 10:54:24',1,'','0230003944059',13,0) 06/11/2024 10:55:14.9153 603 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/11/2024 10:55:15.4927 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:55:24.6118 1247 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 10:56:01.0631 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:56:23.4951 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:57:12.0515 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 10:57:12.2907 737 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 06/11/2024 11:00:16.3545 784 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5601591666076400,5276392097783730,2024,'2024-11-06 11:00:15','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/6/2024 10:05:05 AM Date : 11/6/2024 11:00:13 AM Code : 456003630500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 200.00 KES Coin changed : 0.00 KES Note changed : 150.00 KES',0) 06/11/2024 11:00:20.0610 3519 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-06 11:00:16',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 06/11/2024 11:00:20.5113 841 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-11-06 11:00:19',0,'V',5352663970260810,5451300674312820,2024,'2024-11-06 11:00:19',18,1,0,4,'2024-11-06 11:15:19','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/11/2024 11:00:20.6254 537 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-06 11:00:20',0,0,'V',5381489995808200,5601591666076400,2024,'2024-11-06 11:00:20',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-06 11:00:20',0,0,'V',5381489995808200,5601591666076400,2024,'2024-11-06 11:00:20',3,'KES',-1,100,-100,'N',''); 06/11/2024 11:00:21.1117 585 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48522, trcLastPrinted = '2400748522', trcLastDate = '2024-11-06 11:00:20' where trcStatus='V' and trcTerId = 18 06/11/2024 11:00:22.4686 1425 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-06 11:00:20',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-11-06 11:00:20',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'; 06/11/2024 11:01:26.4003 1293 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 11:02:05.3593 1292 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 11:02:11.6005 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 06/11/2024 11:05:37.5520 1697 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-06 11:05:35','V',5665722387313010,2024,'2024-11-06 11:05:34','456003993400327005012999',1,2,16,'I','',1,0,1,'','',4) 06/11/2024 11:06:50.9470 568 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 06/11/2024 11:08:56.1005 927 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-11-06 11:08:54',0,'V',5665133851487210,5511709901896860,2024,'2024-11-06 11:08:54',3,1,0,4,'2024-11-06 11:23:54','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 06/11/2024 11:11:07.2931 916 ms. EXEC: update tabTerminalReceipt set trcProgressive = 48525, trcLastPrinted = '2400748525', trcLastDate = '2024-11-06 11:11:06' where trcStatus='V' and trcTerId = 18 06/11/2024 11:12:19.7555 1254 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 06/11/2024 11:12:24.5086 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 11:18:21.8665 7967 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 06/11/2024 11:18:21.9406 8057 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 54 ms.) 06/11/2024 11:18:24.4492 601 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 06/11/2024 11:18:24.4532 652 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' (WAIT TIME 2 ms.) 06/11/2024 11:18:24.4773 502 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/11/2024 11:18:24.4793 517 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 06/11/2024 11:18:24.4793 517 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 06/11/2024 11:18:24.4803 509 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 06/11/2024 11:18:24.4803 505 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 06/11/2024 11:18:24.8135 889 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 06/11/2024 11:18:24.8345 820 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 06/11/2024 11:18:24.8405 854 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 06/11/2024 11:18:24.8415 824 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 06/11/2024 11:18:24.8425 824 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 06/11/2024 11:18:24.8445 828 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 06/11/2024 11:18:24.8455 828 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0 06/11/2024 11:18:24.8455 829 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 06/11/2024 11:18:24.9476 1143 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 06/11/2024 11:18:25.5980 673 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2024-11-06 11:18:24',extLoop1 = 1, extTerId = 2, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '' (WAIT TIME 84 ms.) 06/11/2024 11:18:25.6220 672 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 106 ms.) 06/11/2024 11:18:25.6340 673 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2024-11-06 11:18:24',extLoop1 = 1, extTerId = 1, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '' (WAIT TIME 115 ms.) 06/11/2024 11:18:25.6410 1042 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 121 ms.) 06/11/2024 11:18:25.6420 678 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 122 ms.) 06/11/2024 11:18:25.6430 676 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 122 ms.) 06/11/2024 11:18:25.6430 676 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 120 ms.) 06/11/2024 11:18:25.6440 708 ms. EXEC: INSERT INTO tabTerminalExtraMem SET extCreation = '2024-11-06 11:18:24',extLoop1 = 0, extTerId = 16, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '', extCode = '' (WAIT TIME 101 ms.) 06/11/2024 11:18:25.6510 579 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 128 ms.) 06/11/2024 11:18:25.6550 600 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' (WAIT TIME 112 ms.) 06/11/2024 11:18:25.6560 1066 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 111 ms.) 06/11/2024 11:18:25.6590 595 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 120 ms.) 06/11/2024 11:18:25.6670 581 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 148 ms.) 06/11/2024 11:18:25.6680 592 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' (WAIT TIME 138 ms.) 06/11/2024 11:18:25.6700 595 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' (WAIT TIME 137 ms.) 06/11/2024 11:18:25.6700 595 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' (WAIT TIME 136 ms.) 06/11/2024 11:18:27.4262 690 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:24' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:24' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.4292 650 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:25' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.4332 659 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:25' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.4522 677 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:25' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.4582 705 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:25' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.4652 723 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:24' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:24' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.4692 734 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:24' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:24' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.4722 740 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:24' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:24' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.4733 744 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:24' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:24' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.4943 778 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:24' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:24' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.4963 768 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:25' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:27.5003 760 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-06 10:18:26') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-06 11:18:25' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-06 11:18:25' and (resAreId = 1 or resAreId <= 0) nr: 0 06/11/2024 11:18:34.2292 2261 ms. OPEN: select * from tabClass where claPosition = 2 and claStatus='V' 06/11/2024 11:18:40.0162 11042 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456004053800327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 06/11/2024 11:18:40.0172 10788 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456004069600327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 06/11/2024 11:18:40.0522 14267 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '770415' and traDirection='I' order by traId DESC LIMIT 1 06/11/2024 11:18:40.1733 5430 ms. OPEN: select traCode from movTransit where traCode ='456004071400327005012999' 06/11/2024 11:18:42.1686 17350 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 06/11/2024 11:18:43.4345 1950 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-06 11:18:41','V',5126855105089480,2024,'2024-11-06 11:15:38','456004053800327005031999',1,2,16,'I','',1,0,1,'','',4) 06/11/2024 11:18:43.4345 2100 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-06 11:18:41','V',5033176701396780,2024,'2024-11-06 11:18:34','456004071400327005012999',1,2,16,'I','',1,0,1,'','',4) 06/11/2024 11:18:43.4355 1944 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-06 11:18:41','V',5656206952345790,2024,'2024-11-06 11:15:38','456004053800327005031999',1,2,16,'I','',1,0,1,'','',4) 06/11/2024 11:18:43.4355 2002 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-06 11:18:41','V',5413475525977530,2024,'2024-11-06 11:18:16','456004069600327001031999',1,2,1,'I','',1,0,1,'','',4) 06/11/2024 11:18:43.8798 854 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 06/11/2024 11:18:43.8948 688 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 06/11/2024 11:18:44.6083 684 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '456003930100327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 06/11/2024 11:18:44.7474 823 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '456003901900327001012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 06/11/2024 11:18:45.3928 1768 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/11/2024 11:18:45.4678 1844 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/11/2024 11:18:45.4688 1570 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/11/2024 11:18:45.4688 1848 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 06/11/2024 11:18:48.6161 6143 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 06/11/2024 11:18:49.3736 4625 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 = '456003901900327001012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 06/11/2024 11:18:49.3876 3855 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 = '456004071400327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 06/11/2024 11:18:49.4047 4795 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 = '456003930100327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 06/11/2024 11:18:51.4300 574 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 06/11/2024 11:18:51.4360 575 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 06/11/2024 11:18:52.6288 4012 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); 06/11/2024 11:32:27.9121 13875 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 06/11/2024 11:35:21.4472 1529 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 06/11/2024 11:58:25.8855 573 ms. EXEC: update payInventory set invCreation = '2024-11-06 11:58:25',invModify = '2024-11-06 11:58:25',invUseId=0,invStatus='V' where invId = 217517 06/11/2024 12:00:10.5284 2094 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 06/11/2024 12:26:36.0204 1056 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 06/11/2024 12:28:28.8569 791 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 06/11/2024 13:24:46.9805 1090 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 06/11/2024 13:48:41.8170 2303 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 06/11/2024 14:03:35.9984 1021 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-11-06 14:03:34',0,'V',5130076434672290,4933143216731740,2024,'2024-11-06 14:03:34',18,1,0,4,'2024-11-06 14:18:34','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 06/11/2024 14:03:36.8944 822 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4933143216731740,5130076434672290,2024,'2024-11-06 14:03:36',' Date: 11/6/2024 2:03:34 PM Code: 456004667600327001012999 Entry Date: 11/6/2024 12:57:56 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400748559 ',0) 06/11/2024 14:03:36.8954 824 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-06 14:03:36','V',5434415109698550,2024,'2024-11-06 14:03:35','456004951200327005012999',2,2,2,'O','',0,'2024-11-06 14:03:36',1,'','',0) 06/11/2024 14:03:37.7850 805 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-06 14:03:36' where traUID = 5746117722522400 and traStatus='V' and traEnabled=1 06/11/2024 14:14:36.4779 517 ms. EXEC: update payReceipt set recCreation = '2024-11-06 14:14:35',recModify = '2024-11-06 14:14:35',recUseId=0,recStatus='V' where recId = 319792 06/11/2024 14:45:51.6923 578 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 06/11/2024 14:52:10.4280 542 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 06/11/2024 16:08:33.8859 530 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-11-06 16:06:03',12,'V',5360418508261100,5697042287274180,2024,'2024-11-06 16:06:03',4,1,0,4,'2024-11-06 16:21:03','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 06/11/2024 16:09:45.0038 766 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 06/11/2024 17:39:04.2782 566 ms. EXEC: update abbCards set carLastDate = '2024-11-06 17:39:03',carLastDirection='O' where carStatus='V' and carId = 30 06/11/2024 19:08:07.2714 2663 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 06/11/2024 19:08:40.5253 1117 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType