26/11/2024 00:22:52.1052 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 00:41:25.6714 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 01:18:05.2311 618 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 01:21:15.3355 857 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 01:21:37.5004 840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 01:31:04.4494 657 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 01:40:02.4071 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 02:05:01.9006 629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 02:10:45.3778 537 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 02:43:35.2256 780 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 02:56:32.2846 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 03:02:07.6204 1026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 03:24:05.2076 1507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 03:31:35.7957 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 04:00:14.7082 742 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-26 04:00:13',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'; 26/11/2024 04:03:26.8800 847 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 2 ms.) 26/11/2024 04:15:03.8881 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 04:40:06.6812 625 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/11/2024 04:52:58.5261 920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 05:01:49.9079 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 05:09:13.9962 518 ms. EXEC: update payReceipt set recCreation = '2024-11-26 05:09:13',recModify = '2024-11-26 05:09:13',recUseId=0,recStatus='V' where recId = 326041 26/11/2024 05:42:40.1500 573 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 393 ms.) 26/11/2024 05:58:50.6057 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 06:05:09.0761 898 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 06:16:39.3733 1035 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 06:41:20.8892 663 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 06:48:57.0446 766 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-26 06:48:56','V',4659740785313120,2024,'2024-11-26 06:48:55','456202453500327005012999',1,2,16,'I','',1,0,1,'','',4) 26/11/2024 07:19:48.9846 550 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 26/11/2024 07:51:35.3492 703 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 07:56:50.8374 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 07:59:09.7264 784 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-26 07:56:14',6,'V',5114121426054510,5698156607325400,2024,'2024-11-26 07:56:14',4,1,0,4,'2024-11-26 08:11:14','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/11/2024 08:00:38.0385 820 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 08:08:28.0212 884 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-26 08:08:26',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'; 26/11/2024 08:10:50.7257 727 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 08:23:03.7956 770 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 08:33:31.1636 571 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 08:34:00.1110 705 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 08:34:09.7474 704 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 08:37:05.2319 589 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 08:40:21.2632 538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 08:52:31.8033 1641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 08:53:55.1281 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 08:53:59.9864 1682 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-26 08:53:58','V',5527727870756520,2024,'2024-11-26 08:53:57','456203203700327005012999',1,2,16,'I','',1,0,1,'','0810007103066',82,0) 26/11/2024 08:54:07.9787 632 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 08:56:16.3186 938 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 09:02:37.1846 791 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-26 09:02:36','V',4684021765232970,2024,'2024-11-26 09:02:36','456203107200327005012999',2,2,2,'O','',0,'2024-11-26 09:02:36',1,'','',0) 26/11/2024 09:02:47.5816 664 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 09:06:18.0285 1324 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-26 09:06:16' where payTraUID = 4922423039723270 and payStatus='V' and payEnabled=1 26/11/2024 09:11:00.6227 1084 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 09:28:28.5503 564 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-26 09:28:24',5,3,42101,0,50,-27,-1350,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-26 09:28:24',5,3,42101,0,100,-31,-3100,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-26 09:28:24',5,3,42101,0,200,-10,-2000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-26 09:28:24',5,3,42101,0,500,-3,-1500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-26 09:28:24',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 26/11/2024 09:30:36.4470 841 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 09:38:00.8255 820 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-26 09:37:59',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'; 26/11/2024 09:38:02.0013 737 ms. EXEC: update payInventory set invCreation = '2024-11-26 09:38:01',invModify = '2024-11-26 09:38:01',invUseId=0,invStatus='V' where invId = 221437 26/11/2024 09:40:12.9920 783 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/11/2024 09:42:30.8183 717 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-26 09:42:29' where traUID = 4650624582541880 and traStatus='V' and traEnabled=1 26/11/2024 09:42:32.3153 1319 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 09:42:32.3193 582 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) (WAIT TIME 4 ms.) 26/11/2024 09:44:31.3620 657 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/11/2024 09:45:43.2762 810 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-26 09:45:42','V',5754654058543600,2024,'2024-11-26 09:45:41','456203514100327005012999',1,2,16,'I','',1,0,1,'','',4) 26/11/2024 09:47:45.9164 651 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 09:47:53.7876 682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 09:56:09.3214 561 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 26/11/2024 09:57:11.5811 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 09:59:20.8707 504 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-26 09:59:20' where payTraUID = 4631363064195830 and payStatus='V' and payEnabled=1 26/11/2024 09:59:21.6212 749 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-26 09:59:20' where traUID = 4631363064195830 and traStatus='V' and traEnabled=1 26/11/2024 10:06:03.5473 1621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 10:06:03.7854 1852 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-26 10:06:01' where payTraUID = 5045662180038070 and payStatus='V' and payEnabled=1 26/11/2024 10:10:29.1301 944 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/11/2024 10:11:38.2083 2283 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-26 10:11:35' where payTraUID = 5453848703484110 and payStatus='V' and payEnabled=1 26/11/2024 10:17:09.4071 769 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 10:20:25.2092 549 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-26 10:20:24',0,'V',5219098709544390,4910592863400230,2024,'2024-11-26 10:20:24',18,1,0,4,'2024-11-26 10:35:24','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/11/2024 10:23:55.7301 739 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-26 10:23:54','V',5597846261134930,2024,'2024-11-26 10:23:54','456203743400327005012999',1,2,16,'I','',1,0,1,'','',4) 26/11/2024 10:25:11.3908 834 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 10:31:41.4299 856 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-26 10:31:40',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'; 26/11/2024 10:35:35.0704 637 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 10:36:02.9130 823 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 10:36:02.9360 873 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16664, trcLastPrinted = '2400416664', trcLastDate = '2024-11-26 10:36:02' where trcStatus='V' and trcTerId = 4 26/11/2024 10:41:25.9543 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 10:42:33.4855 864 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 10:45:20.8716 549 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 26/11/2024 10:46:31.0766 1046 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-26 10:46:30',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-26 10:46:30',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 26/11/2024 10:47:43.7182 635 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 10:47:46.4491 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 10:50:57.3829 533 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-26 10:50:56',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'; 26/11/2024 10:54:33.6197 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 10:54:55.1911 568 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 10:56:00.4228 785 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 11:04:33.9106 1012 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/11/2024 11:04:49.6381 682 ms. EXEC: update abbCards set carLastDate = '2024-11-26 11:04:48',carLastDirection='O' where carStatus='V' and carId = 185 26/11/2024 11:11:58.2272 665 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 26/11/2024 11:11:58.2342 580 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 26/11/2024 11:14:24.7523 876 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/11/2024 11:17:26.0797 511 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 11:17:30.4486 789 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 11:22:31.7474 513 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 11:28:35.4609 1070 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 11:29:55.8717 578 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 26/11/2024 11:29:57.1806 630 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-26 11:29:56' where payTraUID = 5048492805485390 and payStatus='V' and payEnabled=1 26/11/2024 11:31:17.4604 2530 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 26/11/2024 11:32:09.7043 608 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/11/2024 11:38:10.6470 962 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-26 11:38:09','V',4922997915189010,2024,'2024-11-26 11:38:08','456203920700327001012999',2,2,2,'O','',0,'2024-11-26 11:38:09',1,'','',0) 26/11/2024 11:38:50.7118 548 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-26 11:38:50' where payTraUID = 5092609238454590 and payStatus='V' and payEnabled=1 26/11/2024 11:38:51.6925 980 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-26 11:38:50' where traUID = 5092609238454590 and traStatus='V' and traEnabled=1 26/11/2024 11:38:59.3176 563 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/11/2024 11:52:20.5771 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 12:07:01.1166 1056 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 12:07:18.3542 1011 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-26 12:07:15',0,'V',5389125913778860,4777212268921590,2024,'2024-11-26 12:07:15',3,1,0,4,'2024-11-26 12:22:15','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 26/11/2024 12:21:15.7821 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-26 12:21:13',0,'V',4804352272023750,5161600017952560,2024,'2024-11-26 12:21:13',3,1,0,4,'2024-11-26 12:36:13','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 26/11/2024 12:26:30.5179 557 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-11-26 12:26:29','0230004100967',0,0,4917376403179270,12,'0000-00-00 00:00:00','0000-00-00 00:00:00') 26/11/2024 12:26:32.4261 986 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-26 12:26:31' where payTraUID = 5079018434758100 and payStatus='V' and payEnabled=1 26/11/2024 12:33:22.1325 567 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/11/2024 12:34:29.6617 923 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/11/2024 12:36:19.8845 631 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 12:38:03.1436 988 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 12:38:59.2642 727 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 12:50:58.0695 1128 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 12:51:05.4324 1170 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-26 12:51:04',0,'V',4855263460713380,5672174192679470,2024,'2024-11-26 12:51:04',18,1,0,4,'2024-11-26 13:06:04','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/11/2024 12:51:30.7493 708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 12:53:58.7134 547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 12:57:14.0752 578 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-26 12:54:19',6,'V',4872802842048000,4806343563179820,2024,'2024-11-26 12:54:19',4,1,0,4,'2024-11-26 13:09:19','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/11/2024 12:59:00.8637 633 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 13:00:42.6899 1490 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 13:01:35.0199 647 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/11/2024 13:07:41.8115 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 13:09:03.5702 543 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-26 13:09:02' where traUID = 4836415433986150 and traStatus='V' and traEnabled=1 26/11/2024 13:09:22.2928 778 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-26 13:09:21' where traUID = 5633481716397890 and traStatus='V' and traEnabled=1 26/11/2024 13:10:00.2602 678 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/11/2024 13:11:20.6230 656 ms. EXEC: update paycash set casCreation = '2024-11-26 13:11:19',casModify = '2024-11-26 13:11:19',casUseId=0,casStatus='V' where casId = 196888 26/11/2024 13:16:21.3824 1072 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4851946954118180,5290515200905390,2024,'2024-11-26 13:16:20',' Data: 11/26/2024 1:13:57 PM Codice: 456204685800327005012999 Ingresso: 11/26/2024 1:00:58 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400607489 ',0) 26/11/2024 13:16:26.4748 554 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-26 13:14:03',1,'V',5340360224971660,5074892814434140,2024,'2024-11-26 13:14:03',17,1,0,4,'2024-11-26 13:29:03','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 26/11/2024 13:18:48.6140 1303 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-26 13:18:47','V',4671918751736330,2024,'2024-11-26 13:18:45','456204685800327005012999',2,2,2,'O','',0,'2024-11-26 13:18:47',1,'','',0) 26/11/2024 13:19:29.4873 816 ms. EXEC: update paycash set casCreation = '2024-11-26 13:19:28',casModify = '2024-11-26 13:19:28',casUseId=0,casStatus='V' where casId = 196889 26/11/2024 13:20:15.7993 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 13:25:07.7328 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 13:27:39.1722 707 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 13:30:13.7347 1099 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-26 13:30:12','V',4802519195150370,2024,'2024-11-26 13:30:12','456204861200327001012999',1,2,1,'I','',1,0,1,'','',4) 26/11/2024 13:30:36.0526 1300 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-26 13:30:34',0,'V',4661917506365340,4703351227953020,2024,'2024-11-26 13:30:34',3,1,0,4,'2024-11-26 13:45:34','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 26/11/2024 13:30:38.1040 823 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 26/11/2024 13:33:35.2366 1231 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 13:33:46.0298 1126 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-26 13:33:44' where payTraUID = 5705609294366770 and payStatus='V' and payEnabled=1 26/11/2024 13:34:45.9479 698 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 13:35:44.3680 577 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 26/11/2024 13:36:44.3412 1531 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 13:36:48.6141 540 ms. EXEC: update payInventory set invCreation = '2024-11-26 13:36:48',invModify = '2024-11-26 13:36:48',invUseId=0,invStatus='V' where invId = 221513 26/11/2024 13:36:53.6895 909 ms. EXEC: update tabTerminalReceipt set trcProgressive = 51064, trcLastPrinted = '2400751064', trcLastDate = '2024-11-26 13:36:52' where trcStatus='V' and trcTerId = 18 26/11/2024 13:37:43.5278 1712 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 4 ms.) 26/11/2024 13:38:23.0913 560 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-26 13:38:22' where traUID = 4655817077412370 and traStatus='V' and traEnabled=1 26/11/2024 13:38:42.6344 1195 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-26 13:38:41' where payTraUID = 5324896674387530 and payStatus='V' and payEnabled=1 26/11/2024 13:39:00.8536 799 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 26/11/2024 13:45:43.2110 775 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 13:45:46.8985 918 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 375479 else acvFstPayId end),acvLstPayId = 375479 where acvSftId = 818 and acvCodeId = 3 26/11/2024 13:45:48.0492 1124 ms. EXEC: update tabTerminalReceipt set trcProgressive = 16679, trcLastPrinted = '2400416679', trcLastDate = '2024-11-26 13:45:46' where trcStatus='V' and trcTerId = 4 26/11/2024 13:47:15.0605 971 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 14:12:24.3325 610 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-26 14:12:23','V',4685064960367670,2024,'2024-11-26 14:12:23','456205114300327005012999',1,2,16,'I','',1,0,1,'','',4) 26/11/2024 14:26:43.4447 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 14:29:44.6090 1336 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-26 14:29:43',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'; 26/11/2024 14:38:08.2532 1340 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-26 14:38:06' where subId = 174 26/11/2024 14:40:56.8791 701 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-26 14:40:56','V',5524467673442530,2024,'2024-11-26 14:40:55','456205285500327005012999',1,2,16,'I','',1,0,1,'','',4) 26/11/2024 14:42:37.8327 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 14:44:30.3481 587 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-26 14:41:35',6,'V',5447974770265330,5087679937825750,2024,'2024-11-26 14:41:35',4,1,0,4,'2024-11-26 14:56:35','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 26/11/2024 14:52:35.1897 1178 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 14:52:59.0126 777 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 14:53:14.9583 775 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 26/11/2024 14:53:31.4283 953 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/11/2024 14:53:36.1055 1218 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 14:53:56.2159 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 26/11/2024 14:54:42.5420 959 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-26 14:54:40',0,'V',5231224984620950,5746123836598780,2024,'2024-11-26 14:54:40',3,1,0,4,'2024-11-26 15:09:40','C','KES',100,1000,900,'',' ',' ',1,100,0,0,'',0,0) 26/11/2024 14:55:16.0874 1190 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 26/11/2024 14:57:21.4023 638 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-11-26 14:57:20',0,'V',5328145814787880,5460558874918170,2024,'2024-11-26 14:57:20',2,1,0,-1,'2024-11-26 15:57:20','S','KES',0,0,0,'','','',3,0,0) 26/11/2024 14:57:44.7189 3747 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 14:58:43.2091 1431 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/11/2024 14:59:27.0104 667 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-26 14:59:26','V',5167943755065120,2024,'2024-11-26 14:59:00','456204900200327005012999',2,2,2,'O','',0,'2024-11-26 14:59:26',1,'','',0) 26/11/2024 14:59:28.0331 820 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-26 14:59:27' where traUID = 4958440161970450 and traStatus='V' and traEnabled=1 26/11/2024 14:59:56.4791 3378 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/11/2024 15:01:59.8297 4517 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 26/11/2024 15:02:30.4913 3559 ms. OPEN: select * from tabArea where areId = 1 26/11/2024 15:07:56.8332 5577 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitId' nr: 1 26/11/2024 15:07:56.9003 5612 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 40 ms.) 26/11/2024 15:07:56.9033 2434 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 (WAIT TIME 17 ms.) 26/11/2024 15:07:56.9083 16095 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 21 ms.) 26/11/2024 15:07:56.9103 16133 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 22 ms.) 26/11/2024 15:07:58.4715 858 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 26/11/2024 15:08:00.5138 660 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitPlates' nr: 1 (WAIT TIME 952 ms.) 26/11/2024 15:08:01.0492 2577 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 26/11/2024 15:08:15.0325 18126 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '786240' and traDirection='I' order by traId DESC LIMIT 1 26/11/2024 15:08:15.0325 18127 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '786246' and traDirection='I' order by traId DESC LIMIT 1 26/11/2024 15:08:15.0335 18130 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '786210' and traDirection='I' order by traId DESC LIMIT 1 26/11/2024 15:08:15.0905 10627 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId 26/11/2024 15:08:16.4234 15380 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 26/11/2024 15:08:20.9985 4142 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 15:08:21.6919 3025 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456205139700327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 26/11/2024 15:08:21.7450 2914 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456205304300327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 26/11/2024 15:08:21.8120 2982 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456205333000327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 26/11/2024 15:08:21.8130 2982 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456205333000327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) (WAIT TIME 1 ms.) 26/11/2024 15:08:23.2350 535 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '456205333000327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 26/11/2024 15:08:23.2360 514 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '456205333000327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 26/11/2024 15:08:23.2390 536 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '456205304300327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 26/11/2024 15:08:23.2410 541 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '456205139700327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 26/11/2024 15:08:24.7620 3762 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 26/11/2024 15:08:25.4434 584 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 26/11/2024 15:28:50.4986 725 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-26 15:28:49' where traUID = 4768113489065840 and traStatus='V' and traEnabled=1 26/11/2024 15:29:35.9395 1569 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 102 order by traDateTime desc,traId desc 26/11/2024 15:33:35.6500 2113 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 26/11/2024 15:34:53.4834 1680 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 26/11/2024 15:36:19.4424 2275 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 26/11/2024 15:42:37.8990 710 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 26/11/2024 15:54:35.1486 1894 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 26/11/2024 16:07:05.6407 10341 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/11/2024 16:10:37.8666 538 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 26/11/2024 18:19:38.0735 4383 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 26/11/2024 18:19:38.0845 4339 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 151 ms.) 26/11/2024 18:19:38.8961 573 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.8961 577 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.8981 572 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.8981 571 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.8991 575 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9011 590 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9021 584 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9041 585 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9041 584 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9051 580 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9051 591 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9061 585 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9071 589 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9081 590 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9091 583 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9091 587 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9101 592 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9111 587 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9121 600 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9131 600 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9131 591 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9141 598 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:38.9151 598 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 26/11/2024 18:19:39.6426 562 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/11/2024 18:19:39.6426 559 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/11/2024 18:19:39.6526 569 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/11/2024 18:19:39.6526 567 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/11/2024 18:19:39.6536 567 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/11/2024 18:19:39.6536 572 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/11/2024 18:19:39.6546 572 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/11/2024 18:19:39.6546 574 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/11/2024 18:19:39.6556 571 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/11/2024 18:19:39.6556 570 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/11/2024 18:19:39.6566 573 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/11/2024 18:19:39.6576 573 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/11/2024 18:19:39.6586 577 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 26/11/2024 18:19:39.6586 573 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/11/2024 18:19:39.6596 578 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/11/2024 18:19:39.6606 578 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/11/2024 18:19:39.6626 582 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/11/2024 18:19:39.6626 577 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/11/2024 18:19:39.6636 577 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/11/2024 18:19:39.6646 581 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/11/2024 18:19:39.6656 579 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 26/11/2024 18:19:39.6666 581 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 26/11/2024 18:19:39.6666 586 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 26/11/2024 18:19:40.3001 564 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId (WAIT TIME 577 ms.) 26/11/2024 18:19:41.4220 561 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 26/11/2024 18:19:41.4230 770 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 26/11/2024 18:19:42.3866 621 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 26/11/2024 18:19:44.0001 1530 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:40' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:44.0011 1529 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:40' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:44.0041 1244 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:41' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:41' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:44.0071 1537 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:40' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:44.0091 1538 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:40' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:44.0091 1622 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 26/11/2024 18:19:44.0121 1527 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:40' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 12 ms.) 26/11/2024 18:19:44.0151 1544 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:40' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:44.2573 1789 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:40' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:44.3103 1842 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:40' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:44.3113 1351 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:42' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:42' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:44.3143 1845 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:40' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:44.3483 1873 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-26 17:19:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-26 18:19:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-26 18:19:40' and (resAreId = 1 or resAreId <= 0) nr: 0 26/11/2024 18:19:57.8589 16432 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 26/11/2024 18:19:58.5924 13126 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456206591100327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 26/11/2024 18:19:58.5924 14715 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191889' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 26/11/2024 18:19:59.9093 516 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370677393' and traDirection='I' order by traId desc limit 1 26/11/2024 18:20:00.0674 510 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 26/11/2024 18:20:02.8286 2892 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-26 18:19:59','V',4725681955551160,2024,'2024-11-26 18:16:43','456206363300327001029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 26/11/2024 18:20:02.8306 1893 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-26 18:20:00','V',4919087659302580,2024,'2024-11-26 18:18:31','456206591100327005031999',1,1,16,'I','',1,0,1,'','',4) 26/11/2024 18:20:04.1695 1326 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 18:20:04.1695 1326 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 18:20:04.1715 772 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 18:20:04.1715 1328 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 26/11/2024 18:20:04.5698 6262 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 26/11/2024 18:20:07.3607 3061 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456200000700327003229999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 26/11/2024 18:20:08.1983 3628 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 26/11/2024 18:20:38.3636 15755 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/11/2024 18:21:17.0434 958 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 3 and payDateTime = '2024-11-26 18:21:15' nr: 0 26/11/2024 18:21:18.4434 533 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-26 18:21:17',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'; 26/11/2024 18:25:24.0650 1537 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 26/11/2024 18:44:27.2715 597 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 142 order by traDateTime desc,traId desc 26/11/2024 18:51:45.1063 1949 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 26/11/2024 18:57:40.4207 2083 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 26/11/2024 19:01:38.6972 1134 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 26/11/2024 19:16:30.0995 1163 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 26/11/2024 20:04:40.4500 576 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 26/11/2024 20:33:28.8791 679 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5404561638622460,4696932555367530,2024,'2024-11-26 20:33:28',' Date: 11/26/2024 8:33:28 PM Code: 456206708100327005012999 Entry Date: 11/26/2024 6:38:01 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 # 2400751102 ',0) 26/11/2024 20:33:36.8671 825 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 26/11/2024 20:42:00.4408 632 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-26 20:41: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-26 20:41:59',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-26 20:41:59',3,42101,0,500,-1,-500,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N'; 26/11/2024 21:29:41.2563 576 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-26 21:29:40',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';