10/11/2024 00:00:48.7013 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:10:13.7237 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:10:22.1603 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:11:08.9435 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:13:56.8193 624 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:13:57.9240 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:15:59.6992 719 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:16:31.1921 1127 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:20:14.9042 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:26:53.6348 564 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 12 ms.) 10/11/2024 00:27:58.9553 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:33:59.9808 766 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 00:41:58.3915 550 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-10 00:41:57','V',4966275173257350,2024,'2024-11-10 00:41:57','456037933500327005012999',2,2,2,'O','',0,'2024-11-10 00:41:57',1,'','',0) 10/11/2024 00:42:01.9268 3002 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 00:41:58' where traUID = 4856813893583940 and traStatus='V' and traEnabled=1 10/11/2024 00:42:56.3331 654 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/11/2024 00:49:32.0287 1142 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 00:49:51.7208 791 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:50:01.7515 1384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:50:13.7054 973 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:52:09.8958 753 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 00:53:05.2597 1415 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:53:12.4445 2572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 00:53:38.5179 657 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:00:26.9920 1056 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4788448691623100,5401519062535030,2024,'2024-11-10 01:00:25',' Date: 11/10/2024 1:00:25 AM Code: 456040330800327001012999 Entry Date: 11/10/2024 12:55:08 AM 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 # 2400749078 ',0) 10/11/2024 01:01:41.5436 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 01:02:35.4275 616 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/11/2024 01:07:40.5558 712 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:08:32.8987 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:10:02.6455 733 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/11/2024 01:10:42.6361 608 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:10:48.3869 716 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/11/2024 01:11:47.2561 1445 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:13:59.3832 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:22:30.4616 647 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 01:22:29',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 01:22:29',3,42101,0,200,2,400,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N'; 10/11/2024 01:24:53.6050 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:28:10.2900 666 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 01:43:38.0683 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 01:43:47.4676 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:45:12.9746 1139 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:46:26.6706 571 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 01:46:26' where payTraUID = 5027715807482750 and payStatus='V' and payEnabled=1 10/11/2024 01:46:48.1450 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 67 ms.) 10/11/2024 01:52:59.5314 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:58:12.4588 1867 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5255932407330320,5282150251171740,2024,'2024-11-10 01:58:10',' Date: 11/10/2024 1:58:10 AM Code: 456038084500327005012999 Entry Date: 11/9/2024 10:27:25 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400749081 ',0) 10/11/2024 01:58:54.5168 684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 01:58:58.1512 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 01:59:23.4921 897 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 02:00:06.6759 620 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/11/2024 02:00:43.4034 2473 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 02:02:02.9193 887 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 02:02:01' where traUID = 4693334179816990 and traStatus='V' and traEnabled=1 10/11/2024 02:07:11.0686 687 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 02:07:28.6333 577 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-10 02:07:27',0,'V',5541965042883240,4941217340170270,2024,'2024-11-10 02:07:27',18,1,0,4,'2024-11-10 02:22:27','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/11/2024 02:11:07.9954 964 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/11/2024 02:15:59.9969 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 02:20:14.9278 3817 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal (WAIT TIME 182 ms.) 10/11/2024 02:20:14.9568 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 82 ms.) 10/11/2024 02:20:38.9868 1275 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/11/2024 02:20:48.4041 985 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside - 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 10/11/2024 02:20:54.7723 535 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 02:20:57.8223 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 02:22:29.3993 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 02:22:37.1525 628 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/11/2024 02:25:21.6131 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 02:28:21.8812 1414 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 02:28:43.2494 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 02:32:02.4331 502 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 02:42:11.7470 792 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 02:56:07.9180 1011 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 10/11/2024 02:56:08.6004 658 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/11/2024 02:56:09.4080 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 03:00:32.6924 1533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:00:32.6954 1089 ms. EXEC: update payReceipt set recCreation = '2024-11-10 03:00:31',recModify = '2024-11-10 03:00:31',recUseId=0,recStatus='V' where recId = 321175 10/11/2024 03:00:34.6247 1044 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:01:47.2901 875 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 03:02:21.6740 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:04:21.6089 656 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:09:08.5100 808 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-10 03:09:07','V',4865992027219930,2024,'2024-11-10 03:09:06','456038023300327005012999',2,2,2,'O','',0,'2024-11-10 03:09:07',1,'','',0) 10/11/2024 03:09:11.9953 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 03:14:43.6112 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:16:32.8790 984 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:16:43.5301 753 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:24:25.1786 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:27:49.0744 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 03:34:06.8761 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:43:03.8368 678 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:47:48.7436 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:54:15.5603 1349 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:54:58.1126 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 03:57:56.8177 680 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/11/2024 03:58:55.9591 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 04:02:18.8012 822 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/11/2024 04:02:31.4226 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 04:06:27.1606 638 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 04:06:26' where traUID = 5044837138059490 and traStatus='V' and traEnabled=1 10/11/2024 04:06:33.7981 671 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 04:06:57.0816 509 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 10/11/2024 04:06:57.6569 564 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 04:06:58.5305 630 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 04:07:00.9511 2391 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/11/2024 04:07:09.1726 2767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 25 ms.) 10/11/2024 04:10:52.3093 1449 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 04:15:26.4429 562 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 04:17:43.5482 575 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/11/2024 04:17:43.5702 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 04:23:13.3299 1020 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-10 04:23:11',0,'V',5288256842564850,5418990503751950,2024,'2024-11-10 04:23:11',3,1,0,4,'2024-11-10 04:38:11','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 10/11/2024 04:28:20.7577 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 04:30:57.1839 1745 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/11/2024 04:31:01.0605 541 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 10/11/2024 04:31:02.1772 556 ms. EXECSCALAR: select count(*) from payInventory where invChannel=2 and invCode=2 and invDevice=41101 nr: 0 10/11/2024 04:32:31.6098 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 04:32:44.0401 508 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 04:32:50.8146 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 04:32:56.0231 1974 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 04:36:46.8478 571 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-10 04:36:46',0,'V',5575557297468060,4656068305733970,2024,'2024-11-10 04:36:46',18,1,0,4,'2024-11-10 04:51:46','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/11/2024 04:52:42.4274 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 04:54:05.2505 1046 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside + 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 10/11/2024 04:58:50.6577 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 05:04:57.5311 516 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 05:05:31.9320 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 05:06:45.8942 690 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 05:08:26.7815 941 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 05:17:30.3165 750 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 05:17:30.6968 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 05:17:57.9109 865 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 05:19:13.3592 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 05:23:37.2159 999 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 05:45:19.5255 1198 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 05:48:51.0784 1172 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/11/2024 05:49:49.3102 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 05:49:49.3132 1207 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-10 05:49:48','V',4949718770541910,2024,'2024-11-10 05:49:46','456037864400327005012999',2,2,2,'O','',0,'2024-11-10 05:49:48',1,'','',0) 10/11/2024 05:49:49.8906 567 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 05:49:50.5420 648 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/11/2024 05:49:57.1204 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 05:50:07.2191 588 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/11/2024 05:50:07.3672 649 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 05:51:27.4906 1157 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 06:10:01.8239 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 06:20:59.5511 1125 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 06:25:50.2947 949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 06:25:54.8027 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 06:36:18.4722 609 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 06:46:16.2644 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 06:47:34.2203 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 06:50:34.3113 968 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 06:55:28.2801 751 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 06:55:46.1911 1188 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 07:11:04.6291 505 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 07:11:09.1831 731 ms. EXEC: update payReceipt set recCreation = '2024-11-10 07:11:08',recModify = '2024-11-10 07:11:08',recUseId=0,recStatus='V' where recId = 321210 10/11/2024 07:13:15.6204 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 07:24:15.0496 803 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 07:27:31.2133 718 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 07:32:09.0264 1095 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 07:33:28.6784 895 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 07:39:43.5181 838 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 07:42:06.8616 553 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-10 07:42:06','V',5563102602839410,2024,'2024-11-10 07:42:06','456042772600327005012999',1,2,16,'I','',1,0,1,'','',4) 10/11/2024 07:44:24.2652 783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 07:45:40.5540 750 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 07:45:53.5396 910 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-10 07:45:51',0,'V',4893688666375230,4730041353374710,2024,'2024-11-10 07:45:51',3,1,0,4,'2024-11-10 08:00:51','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 10/11/2024 07:46:39.0469 513 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 08:21:59.3614 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 08:28:12.5630 507 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/11/2024 08:30:34.8087 1287 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 08:34:33.9330 926 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 08:34:51.2116 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 08:41:15.8848 885 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 10/11/2024 08:41:56.2457 1883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 08:43:13.0989 652 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 08:45:42.1031 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 08:52:32.3354 846 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 08:58:39.4430 1065 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 09:04:54.5418 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 09:17:06.7916 660 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 09:17:11.8710 983 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 09:18:35.5848 2546 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 09:29:37.3996 999 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-10 09:29:36','V',5301459415428360,2024,'2024-11-10 09:29:34','456038365100327001012999',2,2,2,'O','',0,'2024-11-10 09:29:36',1,'','0230003943530',44,0) 10/11/2024 09:29:38.5794 537 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 09:29:38' where payTraUID = 5669050055869280 and payStatus='V' and payEnabled=1 10/11/2024 09:35:42.0936 1386 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 85 ms.) 10/11/2024 09:39:43.2743 707 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-10 09:39:41',0,'V',5596699409014120,5675006360333740,2024,'2024-11-10 09:39:41',3,1,0,4,'2024-11-10 09:54:41','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 10/11/2024 09:49:13.1659 878 ms. OPEN: SELECT * FROM tabuser WHERE useId = 5 10/11/2024 09:54:26.9089 1684 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 09:56:35.5856 1159 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 09:57:20.0432 813 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 10:01:08.6635 1982 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 09:57:57',5,3,42101,0,50,-12,-600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 09:57:57',5,3,42101,0,50,12,600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 09:57:57',5,3,42101,0,100,-42,-4200,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 09:57:57',5,3,42101,0,100,42,4200,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 09:57:57',5,3,42101,0,500,-6,-3000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 09:57:57',5,3,42101,0,500,6,3000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 09:57:57',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-10 09:57:57',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-10 09:57:57',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 10/11/2024 10:01:09.8373 630 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 10:01:03',5,3,42101,0,50,-12,-600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 10:01:03',5,3,42101,0,100,-49,-4900,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 10:01:03',5,3,42101,0,200,-3,-600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 10:01:03',5,3,42101,0,500,-6,-3000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 10:01:03',5,3,42101,0,1000,-2,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-10 10:01:03',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 10/11/2024 10:06:44.8575 527 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 10:07:45.6530 1298 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/11/2024 10:07:59.0619 812 ms. OPEN: show columns from tabArea where Field = 'areType' 10/11/2024 10:14:30.1014 1707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 10:22:13.4881 2050 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/11/2024 10:24:42.1381 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 10:25:39.4563 1013 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/11/2024 10:31:09.2520 854 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 10:36:15.5750 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 10:36:22.0083 663 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/11/2024 10:46:40.8095 1550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 10:56:40.9113 748 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 10:58:52.9492 691 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 10:58:53.6797 730 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside + 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 10/11/2024 11:03:32.7696 1340 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/11/2024 11:05:32.4804 1153 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/11/2024 11:05:39.3119 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:06:35.1361 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:06:58.9650 2068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 11:08:30.4099 1225 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' 10/11/2024 11:08:31.2965 543 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:08:47.9726 579 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 10/11/2024 11:08:48.4439 574 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 11:09:14.4703 593 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 10/11/2024 11:09:27.6981 1152 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 11:10:35.4002 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 11:10:58.8808 726 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:11:43.8768 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 11:11:50.4482 576 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:12:04.2133 796 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 11:14:59.2710 514 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:15:31.3994 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:18:54.2585 941 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 11:20:33.5646 1763 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 11:24:02.4268 855 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:24:09.4304 714 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/11/2024 11:24:09.9828 504 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/11/2024 11:24:11.4328 839 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/11/2024 11:24:24.3774 563 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 11:26:56.5938 573 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-10 11:26:56','V',5644395456087890,2024,'2024-11-10 11:26:54','456043899700327005012999',2,2,2,'O','',0,'2024-11-10 11:26:56',1,'','',0) 10/11/2024 11:27:16.2499 699 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 11:27:54.4954 720 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 10/11/2024 11:28:07.4710 1666 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/11/2024 11:29:31.3549 1288 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-10 11:29:30','V',5681545645810630,2024,'2024-11-10 11:29:29','456043964600327005012999',2,2,2,'O','',0,'2024-11-10 11:29:30',1,'','',0) 10/11/2024 11:29:32.8119 842 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 11:29:31' where traUID = 4993688631395660 and traStatus='V' and traEnabled=1 10/11/2024 11:29:39.7315 614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:30:25.2328 710 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/11/2024 11:31:02.1374 1733 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 11:31:05.8549 1109 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/11/2024 11:34:15.6733 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 11:37:00.2569 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:44:25.6506 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:45:52.2293 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 11:47:28.1932 526 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:47:29.4371 627 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5368962175226060,5115080829827580,2024,'2024-11-10 11:47:28','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/10/2024 10:56:34 AM Date : 11/10/2024 11:47:15 AM Code : 456043939400327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 10/11/2024 11:47:37.3854 527 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/11/2024 11:47:37.3864 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 11:49:08.8813 1746 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/11/2024 11:49:57.4987 691 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49126, trcLastPrinted = '2400749126', trcLastDate = '2024-11-10 11:49:56' where trcStatus='V' and trcTerId = 18 10/11/2024 11:50:12.8819 526 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 11:50:17.2028 567 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:50:35.7432 584 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/11/2024 11:52:00.1364 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 11:52:43.1570 1288 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-10 11:52:41',0,'V',5604563663900350,4716973571292810,2024,'2024-11-10 11:52:41',2,1,0,-1,'2024-11-10 12:52:41','S','KES',50,50,0,'','','',3,50,0,0,'',0,0) 10/11/2024 11:53:19.0389 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 11:54:19.1330 667 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/11/2024 11:57:32.2656 1571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 12:00:33.0270 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:02:03.1271 810 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 12:02:05.2105 2766 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/11/2024 12:02:05.9920 2824 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/11/2024 12:02:50.8068 1083 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-10 12:02:49','V',4833184825421280,2024,'2024-11-10 12:02:49','456044205800327005012999',2,2,2,'O','',0,'2024-11-10 12:02:49',1,'','',0) 10/11/2024 12:02:55.0707 940 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/11/2024 12:03:12.4392 504 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 10/11/2024 12:05:11.8358 1830 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 12:05:56.9578 1407 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 12:05:55',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/11/2024 12:06:58.7970 857 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 12:06:57',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/11/2024 12:10:35.8937 588 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 12:10:35' where traUID = 4745841269037640 and traStatus='V' and traEnabled=1 10/11/2024 12:10:43.9730 797 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 12:16:26.3877 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:16:56.6418 669 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-10 12:16:55','V',4869202138545760,2024,'2024-11-10 12:16:54','456044262400327005012999',2,2,2,'O','',0,'2024-11-10 12:16:55',1,'','',0) 10/11/2024 12:16:59.6398 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 12:19:50.8769 532 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 12:22:46.6360 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:23:43.3878 2131 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:24:25.8321 584 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 10/11/2024 12:24:26.4555 622 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/11/2024 12:24:27.3671 833 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 12:24:26' where traUID = 5580776833495010 and traStatus='V' and traEnabled=1 10/11/2024 12:25:54.9685 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:26:22.4858 957 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:27:16.4747 1577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:34:06.4509 2951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:34:12.7571 1030 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5353244509339850,5438161389231870,2024,'2024-11-10 12:34:11',' Date: 11/10/2024 12:34:10 PM Code: 456043846000327005012999 Entry Date: 11/10/2024 10:41:00 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400749131 ',0) 10/11/2024 12:35:21.0255 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:36:48.8700 1042 ms. EXEC: update payReceipt set recCreation = '2024-11-10 12:36:47',recModify = '2024-11-10 12:36:47',recUseId=0,recStatus='V' where recId = 321268 10/11/2024 12:37:15.7790 788 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 12:37:28.7966 936 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 12:37:27' where payTraUID = 5353244509339850 and payStatus='V' and payEnabled=1 10/11/2024 12:38:03.3016 1255 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 12:38:02' where payTraUID = 4862595625841530 and payStatus='V' and payEnabled=1 10/11/2024 12:40:15.8119 689 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-10 12:40:15',4,9,'2024-11-10 12:40:15','456044210000327005012999','Payed (Credit Card ) Ticket ') 10/11/2024 12:42:26.6981 605 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-10 12:42:26','V',5119937519065340,2024,'2024-11-10 12:42:25','456044574500327001012999',1,2,1,'I','',1,0,1,'','',4) 10/11/2024 12:42:27.3625 540 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 12:42:57.1394 1386 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/11/2024 12:44:41.9952 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:48:53.6118 767 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 12:49:07.3260 566 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/11/2024 12:49:07.3310 528 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:50:54.2882 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 12:51:54.2802 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:53:38.9439 830 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:54:20.7978 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 12:56:38.0983 881 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 12:58:45.3810 804 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/11/2024 12:59:14.2092 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:00:37.3286 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 13:00:41.1902 974 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:04:01.3855 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:06:56.5042 750 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:08:44.3070 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:08:52.7927 1399 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 13:09:57.5058 1428 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-10 13:09:54',0,'V',5092332892973990,5589683295820320,2024,'2024-11-10 13:09:54',3,1,0,4,'2024-11-10 13:24:54','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 10/11/2024 13:11:14.9073 839 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-10 13:11:12',0,'V',5151604552840970,5097894310211700,2024,'2024-11-10 13:11:12',3,1,0,4,'2024-11-10 13:26:12','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 10/11/2024 13:11:15.9490 684 ms. EXEC: update paycash set casCreation = '2024-11-10 13:11:15',casModify = '2024-11-10 13:11:15',casUseId=0,casStatus='V' where casId = 194198 10/11/2024 13:12:08.2829 1075 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/11/2024 13:12:09.0334 643 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 13:12:10.8056 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:13:32.2778 1130 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/11/2024 13:14:22.5453 678 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 13:18:50.6990 670 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 13:19:39.7526 509 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 13:22:03.3533 3280 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 13:24:16.0627 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:25:00.0490 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:25:00.5603 1687 ms. OPEN: select terDefaultClass from tabTerminal where terStatus='V' and terId = 16 10/11/2024 13:29:42.8564 563 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:31:26.3023 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:31:54.7743 706 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-10 13:31:53',0,'V',4778749098402070,4868369221151410,2024,'2024-11-10 13:31:53',3,1,0,4,'2024-11-10 13:46:53','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 10/11/2024 13:34:07.5397 2816 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-10 13:34:04','V',5755356179424150,2024,'2024-11-10 13:34:04','456044702400327005012999',2,2,2,'O','',0,'2024-11-10 13:34:04',1,'','',0) 10/11/2024 13:35:04.3406 938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:35:08.6344 1259 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:35:25.7188 580 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:36:03.7802 1375 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 13:36:56.5603 724 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-10 13:36:55','V',5457025763303220,2024,'2024-11-10 13:36:55','456044503600327005012999',2,2,2,'O','',0,'2024-11-10 13:36:55',1,'','',0) 10/11/2024 13:38:01.9389 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 13:38:51.0966 658 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/11/2024 13:40:42.1906 711 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-10 13:40:41','V',4668442580268870,2024,'2024-11-10 13:40:40','456044256500327005012999',2,2,2,'O','',0,'2024-11-10 13:40:41',1,'','',0) 10/11/2024 13:42:24.0415 590 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 13:45:40.3282 548 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 13:46:02.0477 787 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 13:49:07.3731 555 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 10/11/2024 13:51:49.8174 599 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 13:52:10.3871 699 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/11/2024 13:52:25.1079 1573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:54:06.6045 818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 13:54:49.1398 2450 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 13:54:58.7972 974 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/11/2024 13:55:01.5000 543 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 10/11/2024 13:59:53.3014 579 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 13:59:52' where traUID = 5040846321451930 and traStatus='V' and traEnabled=1 10/11/2024 13:59:58.1557 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 14:00:22.8791 793 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:01:52.0495 2040 ms. EXEC: update payReceipt set recCreation = '2024-11-10 14:01:50',recModify = '2024-11-10 14:01:50',recUseId=0,recStatus='V' where recId = 321300 10/11/2024 14:01:53.5175 553 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 10/11/2024 14:12:07.7087 957 ms. OPEN: select parTicketCounter from tabParameters where parStatus='V' order by parId desc limit 1 10/11/2024 14:14:38.0848 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:16:17.6802 513 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 14:16:20.5691 1708 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 14:16:18',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/11/2024 14:16:21.3076 738 ms. EXEC: update payInventory set invCreation = '2024-11-10 14:16:20',invModify = '2024-11-10 14:16:20',invUseId=0,invStatus='V' where invId = 218438 10/11/2024 14:16:23.3710 1764 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 14:16:21',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'; 10/11/2024 14:16:30.8630 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:18:05.2338 708 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-10 14:18:04','V',5342816930233960,2024,'2024-11-10 14:18:03','456045148300327005012999',1,2,16,'I','',1,0,1,'','',4) 10/11/2024 14:18:45.3095 712 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 14:20:11.1127 571 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-10 14:20:10','V',5620877265603460,2024,'2024-11-10 14:20:10','456045004700327005012999',2,2,2,'O','',0,'2024-11-10 14:20:10',1,'','',0) 10/11/2024 14:20:16.4482 603 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 14:21:59.9342 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:23:14.5989 822 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:25:16.0548 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 14:28:16.7972 1034 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:31:11.3335 556 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 14:34:41.6376 839 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 14:36:21.1459 940 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5483876312094450,4807021408763210,2024,'2024-11-10 14:36:20','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/10/2024 1:50:43 PM Date : 11/10/2024 2:36:19 PM Code : 456044984300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 10/11/2024 14:37:02.6555 938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:37:46.9810 542 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-10 14:37:46','V',4741924342962080,2024,'2024-11-10 14:37:45','456044984300327005012999',2,2,2,'O','',0,'2024-11-10 14:37:46',1,'','',0) 10/11/2024 14:37:53.7345 2122 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 14:40:31.3095 650 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:45:10.9708 567 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 10/11/2024 14:45:11.7363 649 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 14:45:26.8044 722 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/11/2024 14:46:02.9284 1692 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 14:46:01' where payTraUID = 5764568667055140 and payStatus='V' and payEnabled=1 10/11/2024 14:46:07.5205 523 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 14:46:07.7266 506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:46:24.1846 895 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/11/2024 14:47:27.1996 1395 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:50:02.9923 640 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:50:14.4149 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:50:22.9927 1281 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 14:50:48.5357 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 14:51:21.2254 644 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:52:42.2064 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 14:52:53.3738 811 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 17 nr: 1 10/11/2024 14:53:11.7511 1114 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/11/2024 14:53:27.8768 716 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 10/11/2024 14:53:38.0356 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 14:54:09.5436 539 ms. OPEN: select * from tabParameters order by parId desc limit 1 10/11/2024 14:54:11.0836 1311 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabCardConversionRules' nr: 1 10/11/2024 14:54:13.4362 964 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 14:54:12' where payTraUID = 4954321755230720 and payStatus='V' and payEnabled=1 10/11/2024 14:54:46.4532 736 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-10 14:54:45',0,'V',4886050080509060,5332889567060290,2024,'2024-11-10 14:54:45',18,1,0,4,'2024-11-10 15:09:45','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/11/2024 14:54:47.1456 615 ms. OPEN: show columns from tabTerminalReceipt where Field = 'trcHeader' 10/11/2024 14:57:50.9911 555 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-10 14:57:50','V',5485650936259010,2024,'2024-11-10 14:57:49','456045386900327005012999',1,2,16,'I','',1,0,1,'','',4) 10/11/2024 14:59:17.2075 1412 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-10 14:59:15',0,16,'2024-11-10 14:59:15','','Unauthorized Transit Entry 2') 10/11/2024 14:59:38.6398 631 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 15:03:02.9459 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:03:51.1240 902 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:06:17.5485 524 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/11/2024 15:06:22.3427 626 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/11/2024 15:07:17.4684 1134 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 15:07:43.3917 589 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:07:45.5562 831 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:08:34.5308 826 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-10 15:08:31',0,'V',4999568834687980,4654797631935260,2024,'2024-11-10 15:08:31',3,1,0,4,'2024-11-10 15:23:31','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 10/11/2024 15:08:36.1949 1102 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 15:08:34',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/11/2024 15:09:36.4210 554 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 15:10:32.3353 795 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 15:11:12.4200 785 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/11/2024 15:12:26.4563 533 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-10 15:12:25','V',4651969916567060,2024,'2024-11-10 15:12:25','456045474500327005012999',1,2,16,'I','',1,0,1,'','',4) 10/11/2024 15:12:37.1874 658 ms. EXEC: update paycash set casCreation = '2024-11-10 15:12:36',casModify = '2024-11-10 15:12:36',casUseId=0,casStatus='V' where casId = 194227 10/11/2024 15:12:39.5600 1170 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 15:12:36',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; (WAIT TIME 1200 ms.) 10/11/2024 15:13:20.1571 648 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 10/11/2024 15:13:20.1581 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:14:43.9229 694 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 15:14:43' where payTraUID = 5086504580834460 and payStatus='V' and payEnabled=1 10/11/2024 15:14:45.0676 1144 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 15:14:43' where traUID = 5086504580834460 and traStatus='V' and traEnabled=1 10/11/2024 15:14:51.0886 1073 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:15:44.2480 930 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 15:16:13.2854 880 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/11/2024 15:16:41.0409 1384 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-10 15:16:39','V',4628749842094040,2024,'2024-11-10 15:16:37','456045248900327005012999',2,2,2,'O','',0,'2024-11-10 15:16:39',1,'','',0) 10/11/2024 15:16:49.8167 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:17:49.8427 1353 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/11/2024 15:20:07.8977 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:21:02.7832 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:24:06.2905 541 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:24:17.5460 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:24:27.0973 1075 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:25:22.3491 715 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-10 15:25:20',0,'V',5062387796237250,4771929332718480,2024,'2024-11-10 15:25:20',3,1,0,4,'2024-11-10 15:40:20','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 10/11/2024 15:26:50.3678 642 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/11/2024 15:26:55.4432 688 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:29:35.5988 788 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 15:29:34',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'; 10/11/2024 15:29:36.7886 904 ms. EXEC: update paycash set casCreation = '2024-11-10 15:29:35',casModify = '2024-11-10 15:29:35',casUseId=0,casStatus='V' where casId = 194239 10/11/2024 15:29:38.8710 2082 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 15:29:35',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-10 15:29:35',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'; 10/11/2024 15:30:52.8643 870 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:31:55.6231 582 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 15:36:39.3831 985 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-10 15:36:38' where subId = 22 10/11/2024 15:36:43.6980 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:38:31.3828 1550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:38:39.7643 622 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 15:38:39' where payTraUID = 5530098582139210 and payStatus='V' and payEnabled=1 10/11/2024 15:39:48.8694 571 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4751306844789980,5199593744897480,2024,'2024-11-10 15:39:48','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/10/2024 3:15:51 PM Date : 11/10/2024 3:39:46 PM Code : 456045495100327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 10/11/2024 15:40:08.8147 1012 ms. EXEC: update tabTerminalReceipt set trcProgressive = 7059, trcLastPrinted = '2400607059', trcLastDate = '2024-11-10 15:40:07' where trcStatus='V' and trcTerId = 17 10/11/2024 15:40:36.3560 2689 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/11/2024 15:40:36.8223 3651 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 15:40:32',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'; (WAIT TIME 168 ms.) 10/11/2024 15:40:51.4651 1027 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/11/2024 15:40:52.2416 695 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:40:52.4517 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:42:01.1965 2262 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:42:43.6748 1695 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:45:48.0076 630 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:46:25.6817 2028 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 195 ms.) 10/11/2024 15:46:29.7304 988 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-10 15:46:28','V',5740619175865160,2024,'2024-11-10 15:46:27','456045312500327005012999',2,2,2,'O','',0,'2024-11-10 15:46:28',1,'','',0) 10/11/2024 15:46:33.9752 687 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:47:03.4309 669 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-10 15:47:02',0,0,'V',5227773183017690,5719619846442620,2024,'2024-11-10 15:47:02',3,'KES',1,100,100,'N',''); 10/11/2024 15:47:04.1343 559 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 15:47:02',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/11/2024 15:47:50.4632 648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:48:08.9455 1534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:48:39.9532 1069 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:48:53.1249 564 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-10 15:46:45',1,'V',4917886789956200,4813935772518630,2024,'2024-11-10 15:46:45',17,1,0,4,'2024-11-10 16:01:45','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/11/2024 15:49:39.8561 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:49:44.4331 668 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-10 15:49:43',0,'V',4974633688828350,4997039840014660,2024,'2024-11-10 15:49:43',18,1,0,4,'2024-11-10 16:04:43','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/11/2024 15:49:45.3827 596 ms. EXEC: update payReceipt set recCreation = '2024-11-10 15:49:44',recModify = '2024-11-10 15:49:44',recUseId=0,recStatus='V' where recId = 321363 10/11/2024 15:50:04.4424 547 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-10 15:50:03','V',5326514539029910,2024,'2024-11-10 15:50:01','456045409500327005012999',2,2,2,'O','',0,'2024-11-10 15:50:03',1,'','',0) 10/11/2024 15:50:05.7823 804 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 15:50:04' where payTraUID = 5719619846442620 and payStatus='V' and payEnabled=1 10/11/2024 15:50:06.8430 1060 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 15:50:04' where traUID = 5719619846442620 and traStatus='V' and traEnabled=1 10/11/2024 15:50:10.2793 572 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:50:25.5675 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-10 15:50:25','V',5455561468987430,2024,'2024-11-10 15:50:23','456045702300327005012999',1,2,16,'I','',1,0,1,'','',4) 10/11/2024 15:51:21.7559 817 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-10 15:51:20','V',5230601834813580,2024,'2024-11-10 15:51:19','456045047000327005012999',2,2,2,'O','',0,'2024-11-10 15:51:20',1,'','',0) 10/11/2024 15:51:48.7579 593 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-10 15:51:48','V',4817523528250840,2024,'2024-11-10 15:51:46','456045107900327005012999',2,2,2,'O','',0,'2024-11-10 15:51:48',1,'','',0) 10/11/2024 15:53:41.2609 1855 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:53:59.7682 2439 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 15:54:29.0047 727 ms. OPEN: select * from payCurInventory where curTerId = 3 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 10/11/2024 15:55:11.0217 557 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:55:41.0417 1906 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:57:08.4560 939 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-10 15:57:07','V',4969027000076620,2024,'2024-11-10 15:57:06','456045742600327005012999',1,2,16,'I','',1,0,1,'','',4) 10/11/2024 15:57:44.0998 554 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 15:57:51.8149 530 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5085607731381020,5243985048006500,2024,'2024-11-10 15:57:51','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/10/2024 3:07:15 PM Date : 11/10/2024 3:57:50 PM Code : 456045443500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 10/11/2024 15:57:54.0734 1121 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 15:59:11.7591 916 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:00:20.1327 1389 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:01:34.6694 702 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/11/2024 16:01:57.9138 959 ms. EXEC: update payInventory set invCreation = '2024-11-10 16:01:56',invModify = '2024-11-10 16:01:56',invUseId=0,invStatus='V' where invId = 218481 10/11/2024 16:02:03.7978 544 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 16:02:59.3648 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:02:59.8681 1057 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 16:02:58',3,42101,0,50,2,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+2,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 10/11/2024 16:03:03.2213 3352 ms. EXEC: update payInventory set invCreation = '2024-11-10 16:02:59',invModify = '2024-11-10 16:02:59',invUseId=0,invStatus='V' where invId = 218482 10/11/2024 16:05:16.9945 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 16:07:30.2022 796 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 16:07:29' where traUID = 5248211027316880 and traStatus='V' and traEnabled=1 10/11/2024 16:08:30.5574 1101 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:10:15.3402 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:11:40.8191 1894 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 16:12:40.1487 1394 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-11-10 16:12:38',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 10/11/2024 16:12:41.2344 1033 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-10 16:12:40',1,2,'2024-11-10 16:12:40','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 10/11/2024 16:13:23.7997 912 ms. EXEC: update payInventory set invCreation = '2024-11-10 16:13:22',invModify = '2024-11-10 16:13:22',invUseId=0,invStatus='V' where invId = 218485 10/11/2024 16:14:27.6173 624 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 10/11/2024 16:15:49.2016 868 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/11/2024 16:15:51.4201 754 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/11/2024 16:24:34.8848 876 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/11/2024 16:26:48.0965 653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:41:03.1361 3136 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:41:53.2365 1074 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-10 16:41:52',0,0,'V',4757666991377160,5704082947971720,2024,'2024-11-10 16:41:52',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-10 16:41:52',0,0,'V',4757666991377160,5704082947971720,2024,'2024-11-10 16:41:52',3,'KES',-1,100,-100,'N',''); 10/11/2024 16:41:57.5914 794 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 16:43:13.6110 581 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 16:43:13' where payTraUID = 5130084251138020 and payStatus='V' and payEnabled=1 10/11/2024 16:46:48.0439 815 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 16:46:50.1973 1903 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 16:46:48' where payTraUID = 5704082947971720 and payStatus='V' and payEnabled=1 10/11/2024 16:46:54.6373 767 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 16:46:59.1242 2380 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:47:36.8294 844 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:49:34.8580 559 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:51:59.6775 581 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:54:00.3308 595 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-10 16:53:57',0,'V',5496719107030870,5005247192807250,2024,'2024-11-10 16:53:57',3,1,0,4,'2024-11-10 17:08:57','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 10/11/2024 16:58:45.2176 913 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 16:58:44' where payTraUID = 5083450072348870 and payStatus='V' and payEnabled=1 10/11/2024 16:58:47.5041 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 16:58:49.6426 1395 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 10/11/2024 16:58:53.3670 1332 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 16:59:28.2082 892 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-10 16:59:27','V',5170375216110250,2024,'2024-11-10 16:59:26','456046015500327005012999',2,2,2,'O','',0,'2024-11-10 16:59:27',1,'','',0) 10/11/2024 16:59:32.0688 665 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 20 ms.) 10/11/2024 17:00:07.8777 903 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:02:40.2021 540 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 17:02:47.2138 558 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 17:03:01.6424 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:03:06.5717 1307 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-10 17:03:05','V',5119836417840050,2024,'2024-11-10 17:03:04','456046138400327005012999',1,2,16,'I','',1,0,1,'','',4) 10/11/2024 17:03:26.0637 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:05:24.1273 681 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 17:05:27.6157 3362 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 17:05:31.1900 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:05:40.0499 1736 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:05:44.7171 1477 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 322 ms.) 10/11/2024 17:10:55.2919 1110 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 17:12:03.4313 2646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:13:34.5701 1525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:14:26.7558 1409 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:16:09.4282 579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:16:36.6684 589 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/11/2024 17:16:54.1220 1097 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:22:28.9420 716 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 17:24:33.5170 552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:25:00.1748 562 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 10/11/2024 17:25:00.1758 548 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:25:34.2415 546 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/11/2024 17:25:34.7468 1031 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 17:25:42.3549 561 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 17:25:58.5316 2568 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49182, trcLastPrinted = '2400749182', trcLastDate = '2024-11-10 17:25:55' where trcStatus='V' and trcTerId = 18 10/11/2024 17:30:04.3444 1055 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/11/2024 17:32:08.6852 595 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 17:35:40.6254 2059 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:36:49.4833 1665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 210 ms.) 10/11/2024 17:41:08.2239 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:45:29.7692 600 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:53:43.5031 936 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 17:55:11.2995 604 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 17:59:45.6423 2448 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-10 17:59:42',0,'V',5547348205094130,5119836417840050,2024,'2024-11-10 17:59:42',3,1,0,4,'2024-11-10 18:14:42','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 10/11/2024 18:00:52.4618 588 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 18:03:36.2879 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 18:10:37.5776 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 18:13:18.0195 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 18:14:01.3513 527 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 18:15:00.9911 716 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 18:15:36.4497 911 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 44 10/11/2024 18:18:28.5753 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 18:20:24.3224 646 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 10/11/2024 18:22:05.8651 561 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 18:22:04',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'; 10/11/2024 18:24:21.6425 1144 ms. EXEC: update payReceipt set recCreation = '2024-11-10 18:24:20',recModify = '2024-11-10 18:24:20',recUseId=0,recStatus='V' where recId = 321407 10/11/2024 18:26:06.0981 616 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 18:27:45.2502 521 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 18:32:24.5492 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 18:33:13.3257 828 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 18:40:59.3161 571 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 18:40:59.4462 602 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 18:42:50.4862 511 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 18:43:07.1713 536 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 18:43:06' where payTraUID = 5586809341041140 and payStatus='V' and payEnabled=1 10/11/2024 18:43:38.9995 1405 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 18:44:51.1546 1555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 18:50:58.5213 639 ms. EXEC: update payReceipt set recCreation = '2024-11-10 18:50:57',recModify = '2024-11-10 18:50:57',recUseId=0,recStatus='V' where recId = 321413 10/11/2024 18:50:59.2968 650 ms. EXEC: update paycash set casCreation = '2024-11-10 18:50:58',casModify = '2024-11-10 18:50:58',casUseId=0,casStatus='V' where casId = 194282 10/11/2024 18:51:01.0810 1142 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 18:50:59',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-10 18:50:59',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'; 10/11/2024 18:51:18.6457 544 ms. EXEC: update payReceipt set recCreation = '2024-11-10 18:51:18',recModify = '2024-11-10 18:51:18',recUseId=0,recStatus='V' where recId = 321414 10/11/2024 18:54:43.9595 1222 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 18:55:47.4998 531 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 18:58:27.8016 672 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:04:41.9888 545 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 19:04:41' where traUID = 5041857007864270 and traStatus='V' and traEnabled=1 10/11/2024 19:04:56.5696 838 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 19:05:52.5979 1498 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:07:32.6035 1291 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 85 ms.) 10/11/2024 19:09:08.6545 1095 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:09:14.6305 1039 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:09:27.6742 1593 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-10 19:09:26','V',5682719097968730,2024,'2024-11-10 19:09:24','456046896400327005012999',1,2,16,'I','',1,0,1,'','',4) 10/11/2024 19:09:28.6398 962 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 19:09:29.3032 603 ms. OPEN: select * from tabDevice where devId = 1 and devStatus = 'V' 10/11/2024 19:10:01.6818 1496 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:10:09.6581 930 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:11:14.2582 509 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 19:12:50.6244 741 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:12:55.7117 1177 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:13:02.7945 1191 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 19:13:39.2357 2017 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:20:09.5307 596 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:24:55.8264 616 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:26:12.2674 896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:28:08.0975 1257 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:30:51.1852 977 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 369779 else acvFstPayId end),acvLstPayId = 369779 where acvSftId = 824 and acvCodeId = 3 10/11/2024 19:31:27.5744 665 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/11/2024 19:31:27.5744 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:33:09.4072 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 19:33:54.9846 1259 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:34:57.5943 559 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 19:34:58.1747 681 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49192, trcLastPrinted = '2400749192', trcLastDate = '2024-11-10 19:34:57' where trcStatus='V' and trcTerId = 18 10/11/2024 19:35:25.9662 901 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 10/11/2024 19:35:57.6773 1172 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 19:35:56' where payTraUID = 4942842046463660 and payStatus='V' and payEnabled=1 10/11/2024 19:35:57.7964 851 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:35:58.3678 690 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 19:35:56' where traUID = 4942842046463660 and traStatus='V' and traEnabled=1 10/11/2024 19:36:02.0613 1438 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 19:38:19.5058 1068 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:39:22.1626 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 19:39:44.9667 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:41:53.3903 748 ms. OPEN: select * from tabTariff left join tabtlkTariff on tlkTarId = tarId where (tarValidFrom <= '2024-11-10' and tarValidTo >= '2024-11-10' and tarStatus='V' AND tarEnabled <> 0) AND (tarIdClass = 2 OR tarIdClass <=0) AND ((tlkAreId = 1 AND tlkStatus='V') OR (tarDefault<>0) OR (tlkAreId IS NULL AND tarIdType IN (SELECT ticId FROM tabTicketType WHERE ticStatus='V' AND ticType = 2))) ORDER BY tarModify DESC,tarId DESC 10/11/2024 19:42:19.9090 567 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/11/2024 19:44:00.2488 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:44:23.7835 525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 19:44:25.8649 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:44:39.5740 663 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 19:44:38' where payTraUID = 5752890792752210 and payStatus='V' and payEnabled=1 10/11/2024 19:44:46.0453 657 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/11/2024 19:56:19.4272 1102 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 19:56:36.7668 657 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 19:56:35',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/11/2024 19:58:55.0929 660 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 19:58:54' where traUID = 4655672987713520 and traStatus='V' and traEnabled=1 10/11/2024 20:00:01.2910 976 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:00:46.9834 1175 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:08:10.1026 2472 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:08:58.0986 1299 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 10/11/2024 20:15:42.9533 2081 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 20:16:30.3429 595 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 20:18:32.8305 712 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-10 20:18:32','V',5376129721817380,2024,'2024-11-10 20:18:31','456044524700327005012999',2,2,2,'O','',0,'2024-11-10 20:18:32',1,'','',0) 10/11/2024 20:18:36.2878 507 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 20:19:38.5672 789 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:20:15.2197 825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:24:40.2052 915 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-10 20:22:32',1,'V',5090069238208830,5245121708415820,2024,'2024-11-10 20:22:32',17,1,0,4,'2024-11-10 20:37:32','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/11/2024 20:24:55.3623 679 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/11/2024 20:25:23.2839 591 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 20:26:47.5490 1078 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:30:55.0489 716 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 20:31:11.6740 632 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/11/2024 20:33:15.5255 600 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 20:33:36.1262 992 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-10 20:33:35',0,'V',4912365664529010,5586323973858190,2024,'2024-11-10 20:33:35',18,1,0,4,'2024-11-10 20:48:35','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/11/2024 20:33:36.8847 619 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49199, trcLastPrinted = '2400749199', trcLastDate = '2024-11-10 20:33:36' where trcStatus='V' and trcTerId = 18 10/11/2024 20:35:03.1862 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:35:29.1695 566 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 20:36:24.2232 1598 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/11/2024 20:37:31.1688 830 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-10 20:37:30' where subId = 206 10/11/2024 20:37:32.6758 820 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 20:37:31' where traUID = 5735489975141860 and traStatus='V' and traEnabled=1 10/11/2024 20:37:36.3192 1626 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 20:37:54.4272 543 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:39:32.9139 2464 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:40:29.6527 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:40:44.9498 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:41:23.2193 788 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/11/2024 20:41:48.4081 1149 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:42:10.5238 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:42:36.6042 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 20:42:55.0695 1014 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-10 20:42:54','V',5530555731146150,2024,'2024-11-10 20:42:52','456047385300327005012999',2,2,2,'O','',0,'2024-11-10 20:42:54',1,'','',0) 10/11/2024 20:48:47.3282 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:53:08.5882 710 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 20:53:35.6342 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:53:48.4258 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:56:53.6521 760 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 20:57:05.1548 505 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 20:58:10.3122 733 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 20:58:20.5991 1160 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 21:00:15.4446 752 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:01:29.8541 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 21:01:38.4969 612 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 21:01:43.5022 539 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:07:57.2422 1614 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 21:07:58.0267 832 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-10 21:07:57',0,'V',4898261415460020,5555819716650510,2024,'2024-11-10 21:07:57',18,1,0,4,'2024-11-10 21:22:57','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/11/2024 21:14:01.0535 1674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:14:38.0642 1255 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:18:20.5264 2417 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-10 21:18:17',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 10/11/2024 21:19:31.3196 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:19:58.8219 1816 ms. EXEC: update payReceipt set recCreation = '2024-11-10 21:19:57',recModify = '2024-11-10 21:19:57',recUseId=0,recStatus='V' where recId = 321449 10/11/2024 21:20:47.3312 786 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 21:20:51.1567 2165 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/11/2024 21:21:26.7044 517 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/11/2024 21:21:32.7525 1657 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 21:22:44.2851 949 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:22:46.1293 601 ms. EXEC: update payReceipt set recCreation = '2024-11-10 21:22:45',recModify = '2024-11-10 21:22:45',recUseId=0,recStatus='V' where recId = 321450 10/11/2024 21:22:48.2387 1571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:24:59.3110 1495 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 21:24:57' where traUID = 5455561468987430 and traStatus='V' and traEnabled=1 10/11/2024 21:26:13.1893 668 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/11/2024 21:26:13.6696 626 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:27:18.0084 5480 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:29:03.3136 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:30:58.0710 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:33:57.7587 901 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:34:35.1256 513 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/11/2024 21:36:15.6596 1334 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:40:59.7328 1030 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:44:11.4736 679 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 10/11/2024 21:44:42.8024 964 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:44:59.4996 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:46:23.2373 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 21:46:47.7607 520 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 21:46:47.7607 515 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:46:55.2997 1571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 21:46:55.8270 1355 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/11/2024 22:00:55.1832 1055 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 10/11/2024 22:02:30.6268 590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 22:08:21.1323 702 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 22:08:46.0899 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 22:15:43.2398 1619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 22:16:39.6593 1242 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/11/2024 22:29:29.6403 883 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 22:37:08.0616 805 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 22:39:28.7834 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 22:44:04.5751 680 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 22:45:09.2182 1703 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-10 22:45:07' where traUID = 4948110989653780 and traStatus='V' and traEnabled=1 10/11/2024 22:45:15.2142 648 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 22:47:36.1571 540 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 22:47:49.7831 563 ms. EXEC: update tabTerminalReceipt set trcProgressive = 49207, trcLastPrinted = '2400749207', trcLastDate = '2024-11-10 22:47:49' where trcStatus='V' and trcTerId = 18 10/11/2024 22:49:41.2224 731 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-10 22:49:40' where payTraUID = 4934911220749210 and payStatus='V' and payEnabled=1 10/11/2024 22:57:07.5697 929 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-10 21:57:06') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-10 22:57:05' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-10 22:57:05' and (resAreId = 1 or resAreId <= 0) nr: 0 10/11/2024 22:57:07.6708 1024 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 23:00:33.9342 506 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/11/2024 23:10:43.0709 765 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 23:11:45.2314 692 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 23:12:57.1342 857 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-10 23:12:56',0,0,'V',4901114105577930,5157946914550040,2024,'2024-11-10 23:12:56',3,'KES',1,100,100,'N',''); 10/11/2024 23:21:34.3348 1109 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 23:21:37.1577 1552 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 23:21:44.8138 1585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 23:29:54.8312 903 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/11/2024 23:30:46.5346 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 23:33:18.8361 1262 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 23:48:12.2642 551 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/11/2024 23:54:29.0923 863 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1