03/12/2024 00:38:20.2508 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 01:52:15.4661 565 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-12-03 01:52:14','V',5001496207058440,2024,'2024-12-03 01:52:13','456270673300327005012999',1,2,16,'I','',1,0,1,'','0560008304916',190,0) 03/12/2024 01:52:24.8524 964 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-03 01:52:23',0,16,'2024-12-03 01:52:23','','Unauthorized Transit Entry 2') 03/12/2024 02:40:54.2990 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 03:54:05.6403 617 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/12/2024 03:56:50.5007 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 04:55:33.4572 589 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-03 04:55:32' where payTraUID = 5158092808023140 and payStatus='V' and payEnabled=1 03/12/2024 04:55:36.1791 663 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 05:48:33.1874 510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 06:32:29.5853 912 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 06:43:53.6933 862 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/12/2024 06:48:46.0015 613 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 07:45:13.4206 910 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/12/2024 07:58:33.4139 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 07:59:30.1429 1164 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 03/12/2024 08:17:17.5641 572 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-03 08:17:16',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-03 08:17:16',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'; 03/12/2024 08:22:05.1488 530 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 08:48:15.9068 797 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 09:17:04.1585 606 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-03 09:17:03' where traUID = 5266328086544200 and traStatus='V' and traEnabled=1 03/12/2024 09:17:05.5054 504 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 09:45:28.3522 566 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-03 09:45:27' where traUID = 5409563816565450 and traStatus='V' and traEnabled=1 03/12/2024 09:54:39.1423 541 ms. EXEC: update abbCards set carLastDate = '2024-12-03 09:54:38',carLastDirection='O' where carStatus='V' and carId = 183 (WAIT TIME 1 ms.) 03/12/2024 10:27:20.0495 563 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/12/2024 10:29:16.7641 532 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-03 10:29:16','V',5653108703871170,2024,'2024-12-03 10:29:15','456273620300327005012999',2,2,2,'O','',0,'2024-12-03 10:29:16',1,'','',0) 03/12/2024 10:57:14.6753 699 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 11:08:10.5617 572 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-03 11:08:09','V',5436494947330940,2024,'2024-12-03 11:08:08','456274008800327005012999',1,2,16,'I','',1,0,1,'','',4) 03/12/2024 11:12:46.8979 521 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-12-03 11:12:46','V',4889789658766660,2024,'2024-12-03 11:12:45','456274036500327005012999',1,2,16,'I','',1,0,1,'','0230004101179',8,0) 03/12/2024 11:25:47.5720 580 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 03/12/2024 12:22:26.4654 822 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-03 12:22:25' where traUID = 5156719886913640 and traStatus='V' and traEnabled=1 03/12/2024 12:52:39.2592 815 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 12:54:41.6102 589 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 13:05:48.9408 602 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-12-03 13:05:48','V',5438789760369340,2024,'2024-12-03 13:05:47','456274714700327005012999',1,2,16,'I','',1,0,1,'','',4) 03/12/2024 13:10:14.2496 515 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-03 13:10:13' where subId = 31 (WAIT TIME 7 ms.) 03/12/2024 14:08:28.7030 1516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 14:33:15.1649 594 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 14:59:07.9824 816 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 15:07:28.5865 628 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 15:14:10.4818 571 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 15:36:25.4952 580 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-03 15:36:24' where payTraUID = 4747111684882920 and payStatus='V' and payEnabled=1 03/12/2024 16:15:12.1729 708 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5328982782999630,5023338523029100,2024,'2024-12-03 16:15:11',' Date: 12/3/2024 4:12:03 PM Code: 456275385200327005012999 Entry Date: 12/3/2024 2:57:32 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400417085 ',0) 03/12/2024 16:37:16.4153 508 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-03 16:37:15' where traUID = 5376895778742560 and traStatus='V' and traEnabled=1 03/12/2024 17:02:32.8669 735 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 17:17:07.9255 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 17:19:15.0587 1833 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 18:02:45.9368 642 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/12/2024 18:04:26.6932 577 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/12/2024 18:08:17.1812 736 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 03/12/2024 19:25:32.8270 508 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-03 19:25:32' where traUID = 5600075051067970 and traStatus='V' and traEnabled=1 03/12/2024 20:16:24.1029 713 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 03/12/2024 20:16:24.2480 1230 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 03/12/2024 20:16:29.5216 752 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 378413 else acvFstPayId end),acvLstPayId = 378413 where acvSftId = 840 and acvCodeId = 3 03/12/2024 20:23:13.6281 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 20:45:29.7526 520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 21:19:41.2010 710 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 21:31:49.5582 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 03/12/2024 23:28:48.1484 563 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 03/12/2024 23:32:06.2921 583 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-03 23:32:05' where traUID = 4876334388433830 and traStatus='V' and traEnabled=1