23/01/2025 06:53:47.9556 639 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-23 06:53:45',0,'V',5596608954129540,5340140956133840,2025,'2025-01-23 06:53:45',3,1,0,4,'2025-01-23 07:08:45','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 23/01/2025 06:55:39.2450 518 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 06:56:11.3234 1104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:01:46.2155 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:04:15.6689 994 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:14:51.0093 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:17:36.5539 549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:19:19.6378 571 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 23/01/2025 07:20:31.5418 597 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2025 07:23:22.3862 728 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:25:41.6605 724 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 23/01/2025 07:28:39.4861 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:29:12.5492 1056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:29:40.4258 569 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 07:30:03.9775 605 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 23/01/2025 07:33:08.3200 570 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:34:35.2891 613 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 07:36:22.3346 4660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:37:25.6559 939 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:37:56.5390 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:37:56.5490 645 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/01/2025 07:38:52.0871 1471 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 23/01/2025 07:42:13.1225 1248 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:42:14.2723 952 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:44:35.9939 522 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 23/01/2025 07:45:15.6534 969 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:46:36.5415 1659 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:48:49.0120 601 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 23/01/2025 07:49:03.9599 534 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 07:49:22.3102 829 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:49:38.9073 1054 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,'2025-01-23 07:49:37','V',4839906035466210,2025,'2025-01-23 07:49:35','456782817500327005012999',1,2,16,'I','',1,0,1,'','0230003939767',156,0) 23/01/2025 07:49:46.9747 626 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-23 07:49:46',0,'V',4684003355046400,5085138273517530,2025,'2025-01-23 07:49:46',18,1,0,4,'2025-01-23 08:04:46','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 23/01/2025 07:49:48.7318 865 ms. EXEC: update payReceipt set recCreation = '2025-01-23 07:49:47',recModify = '2025-01-23 07:49:47',recUseId=0,recStatus='V' where recId = 344941 23/01/2025 07:52:03.9592 574 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 07:52:03','V',5529926409250960,2025,'2025-01-23 07:52:02','456782570600327005012999',2,2,2,'O','',0,'2025-01-23 07:52:03',1,'','',0) 23/01/2025 07:52:09.1426 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 07:52:18.2047 536 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/01/2025 07:56:42.9305 671 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:58:14.6798 533 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 07:59:32.3717 683 ms. OPEN: show columns from tabParameters where Field = 'parTicketCustomLine1' 23/01/2025 07:59:55.9915 590 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 23/01/2025 08:01:32.0927 723 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:02:02.3229 707 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-23 08:02:01' where traUID = 5589293296284260 and traStatus='V' and traEnabled=1 23/01/2025 08:02:12.7729 1593 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:02:29.9744 3950 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 23/01/2025 08:02:40.1442 965 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 08:02:39','V',5619338940396200,2025,'2025-01-23 08:02:37','456782895700327005012999',1,2,16,'I','',1,0,1,'','',4) 23/01/2025 08:02:41.4330 821 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/01/2025 08:03:07.9467 1399 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:03:14.2439 1159 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:03:22.4884 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:03:25.9998 1629 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:04:07.6206 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:05:51.6961 2117 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/01/2025 08:09:40.7031 538 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 23/01/2025 08:09:48.4092 1537 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 31 order by traDateTime desc,traId desc 23/01/2025 08:09:51.4233 1295 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 23/01/2025 08:09:55.6201 681 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 08:10:09.2542 1187 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:10:29.4887 926 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 23/01/2025 08:10:30.9667 1060 ms. EXEC: update payCurInventory set curQuantity=0,curAmount=0 where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 23/01/2025 08:10:33.2072 2240 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:14',5,3,42101,0,50,-10,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:14',5,3,42101,0,50,10,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:14',5,3,42101,0,100,-46,-4600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:14',5,3,42101,0,100,46,4600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:14',5,3,42101,0,200,-8,-1600,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:14',5,3,42101,0,200,8,1600,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:14',5,3,42101,0,500,-1,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:14',5,3,42101,0,500,1,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:14',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 ('2025-01-23 08:10:14',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 ('2025-01-23 08:10:14',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 23/01/2025 08:10:34.5571 920 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:22',5,3,42101,0,50,-15,-750,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:22',5,3,42101,0,100,-54,-5400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:22',5,3,42101,0,200,-8,-1600,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:22',5,3,42101,0,500,-1,-500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:22',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:10:22',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 23/01/2025 08:11:55.7273 1813 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 164 order by traDateTime desc,traId desc 23/01/2025 08:15:05.9033 2182 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 23/01/2025 08:15:52.3974 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:16:00.1135 856 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:20:10.7460 1078 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:20:05',5,3,42101,0,50,18,900,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+18,5),curAmount=round(curAmount+900,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:20:05',5,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'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-01-23 08:20:05',5,3,42101,0,100,9,900,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+9,5),curAmount=round(curAmount+900,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 23/01/2025 08:22:36.2201 536 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:23:15.1211 1003 ms. OPEN: select * from tabDevice where devId = 3 and devStatus = 'V' 23/01/2025 08:23:16.4410 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 08:23:16.4410 622 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 23/01/2025 08:32:11.2784 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 08:37:19.0071 2970 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 23/01/2025 08:55:09.9529 506 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 23/01/2025 09:03:19.0102 1344 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 28 order by traDateTime desc,traId desc 23/01/2025 09:12:30.1192 550 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 144 order by traDateTime desc,traId desc 23/01/2025 09:21:36.3602 1250 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 23/01/2025 09:37:28.0744 1099 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 23/01/2025 10:03:18.0989 3251 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 106 order by traDateTime desc,traId desc 23/01/2025 10:03:28.7491 513 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 10:03:28','V',4924619806081060,2025,'2025-01-23 10:03:27','456783620700327005012999',1,2,16,'I','',1,0,1,'','',4) 23/01/2025 10:05:51.5999 2185 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/01/2025 10:06:03.6470 686 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 10:06:02','V',5618076882300060,2025,'2025-01-23 10:06:01','456783636100327001012999',1,2,1,'I','',1,0,1,'','',4) 23/01/2025 10:07:06.6053 2933 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 23/01/2025 10:07:08.6046 585 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2025 10:07:58.3020 622 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:08:21.5136 546 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:09:38.5503 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:09:55.1964 501 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 10:10:07.7399 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,'2025-01-23 10:10:07','V',5490682670557810,2025,'2025-01-23 10:10:06','456783553300327005012999',2,2,2,'O','',0,'2025-01-23 10:10:07',1,'','',0) 23/01/2025 10:10:13.0804 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 10:10:14.2732 1126 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-23 10:10:13',0,'V',5419482336084190,5596020019674370,2025,'2025-01-23 10:10:13',18,1,0,4,'2025-01-23 10:25:13','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 23/01/2025 10:11:49.3941 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 10:13:31.8246 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:15:22.1154 846 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 10:15:21','V',5015583564675730,2025,'2025-01-23 10:15:20','456783692000327001012999',1,2,1,'I','',1,0,1,'','',4) 23/01/2025 10:15:36.0587 915 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 10:15:35','V',5369374781462420,2025,'2025-01-23 10:15:32','456782877000327005012999',2,2,2,'O','',0,'2025-01-23 10:15:35',1,'','',0) 23/01/2025 10:15:37.5197 1130 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/01/2025 10:15:38.4133 811 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-01-23 10:15:37' where traUID = 5125954527569210 and traStatus='V' and traEnabled=1 23/01/2025 10:15:40.8269 549 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 10:16:52.2197 717 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:17:11.4305 541 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/01/2025 10:20:19.5513 648 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 10:20:18','V',4983599632131020,2025,'2025-01-23 10:20:17','456783471700327005012999',2,2,2,'O','',0,'2025-01-23 10:20:18',1,'','',0) 23/01/2025 10:23:48.5210 545 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 10:23:47','V',5577505887257190,2025,'2025-01-23 10:23:47','456783742700327005012999',1,2,16,'I','',1,0,1,'','',4) 23/01/2025 10:23:49.6128 724 ms. EXECSCALAR: select traId from movtransit where traUID = 5577505887257190 and traStatus='V' nr: 830778 23/01/2025 10:26:00.2712 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:26:17.7249 773 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 23/01/2025 10:27:08.2907 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:28:21.9680 1476 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 165 order by traDateTime desc,traId desc 23/01/2025 10:29:17.3260 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:29:24.8610 536 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 23/01/2025 10:29:39.4027 1885 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2025 10:29:40.0582 523 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/01/2025 10:29:55.8728 664 ms. EXECSCALAR: select traId from movtransit where traUID = 4673523404251330 and traStatus='V' nr: 830784 23/01/2025 10:30:20.1280 1316 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 23/01/2025 10:30:27.4789 510 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 10:31:36.7873 533 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 23/01/2025 10:33:30.0901 1100 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:33:35.1465 1323 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 11 order by traDateTime desc,traId desc 23/01/2025 10:34:40.5370 1320 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-23 10:34:39',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'; 23/01/2025 10:34:40.5540 851 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:38:36.0428 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 10:43:01.1506 538 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2025 10:43:28.6620 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:43:28.7200 868 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 23/01/2025 10:43:29.4305 708 ms. OPEN: SELECT * FROM tabTerminalExtraMem WHERE extStatus=@extStatus AND extTerId = @extTerId 23/01/2025 10:43:38.3034 67516 ms. OPEN: select 1 as Tot,payUID,payPayed,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 = 6 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 23/01/2025 10:47:04.6850 6342 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 23/01/2025 10:47:07.2998 1026 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:47:24.7144 1249 ms. OPEN: select 1 as Tot,payUID,payPayed,payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 23/01/2025 10:47:36.4092 824 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:47:54.3702 1760 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 23/01/2025 10:48:02.2424 665 ms. EXEC: update payInventory set invCreation = '2025-01-23 10:48:01',invModify = '2025-01-23 10:48:01',invUseId=0,invStatus='V' where invId = 232830 23/01/2025 10:48:05.7998 849 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:49:54.4804 701 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:50:32.4348 655 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 10:50:31','V',5046560577507490,2025,'2025-01-23 10:50:29','456783636100327001012999',2,2,2,'O','',0,'2025-01-23 10:50:31',1,'','',0) 23/01/2025 10:50:37.7133 537 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 10:50:45.6286 837 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 23/01/2025 10:50:45.6426 873 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:51:03.5996 671 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-23 10:51:02',0,'V',5549593479592670,4937429986242370,2025,'2025-01-23 10:51:02',18,1,0,4,'2025-01-23 11:06:02','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 23/01/2025 10:52:20.3850 748 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2025-01-23 10:52:18',0,'V',5058691556734280,5731964672672080,2025,'2025-01-23 10:52:18',3,1,0,4,'2025-01-23 11:07:18','C','KES',100,500,400,'',' ',' ',1,100,0,0,'',0,0) 23/01/2025 10:53:16.9168 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 10:53:20.0278 1376 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 23/01/2025 10:59:42.0626 23413 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 23/01/2025 10:59:43.3635 506 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3655 613 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3685 513 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3695 503 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3725 502 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3725 620 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3735 666 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3745 667 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3775 504 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3775 625 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 1 ms.) 23/01/2025 10:59:43.3775 674 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 3 ms.) 23/01/2025 10:59:43.3795 670 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3805 511 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3815 667 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3815 670 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3825 557 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3835 670 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 1 ms.) 23/01/2025 10:59:43.3845 528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3865 671 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3865 528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3875 676 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:43.3905 673 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 10:59:44.2864 525 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 261 ms.) 23/01/2025 10:59:44.3074 526 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 280 ms.) 23/01/2025 10:59:44.3154 512 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 286 ms.) 23/01/2025 10:59:44.3174 668 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 133 ms.) 23/01/2025 10:59:44.3264 668 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 139 ms.) 23/01/2025 10:59:44.3294 669 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) (WAIT TIME 142 ms.) 23/01/2025 10:59:44.3304 669 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 143 ms.) 23/01/2025 10:59:44.3464 684 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 160 ms.) 23/01/2025 10:59:44.4595 651 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 278 ms.) 23/01/2025 10:59:45.0404 712 ms. EXEC: update tabTerminalExtraMem SET extLoop1 = 0, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '', extCode = '' where extStatus='V' and extTerId = 16 23/01/2025 10:59:45.0434 716 ms. EXEC: update tabTerminalExtraMem SET extLoop2 = 0 where extStatus='V' and extTerId = 16 AND extPlateWaitOperator=0 23/01/2025 10:59:45.0434 720 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 1 AND extPlateWaitOperator=0 23/01/2025 10:59:45.0484 620 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 23/01/2025 10:59:45.0684 630 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' (WAIT TIME 14 ms.) 23/01/2025 10:59:45.1114 654 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 23/01/2025 10:59:45.1144 647 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 23/01/2025 10:59:45.1164 648 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 23/01/2025 10:59:45.1245 650 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 23/01/2025 10:59:45.1275 653 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 23/01/2025 10:59:45.1285 654 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 23/01/2025 10:59:45.1415 654 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' (WAIT TIME 12 ms.) 23/01/2025 10:59:45.2836 849 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 2 AND extPlateWaitOperator=0 23/01/2025 10:59:45.2906 811 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 23/01/2025 10:59:45.2996 937 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 23/01/2025 10:59:45.3066 588 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 23/01/2025 10:59:52.2110 7648 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '830806' and traDirection='I' order by traId DESC LIMIT 1 23/01/2025 10:59:52.2110 5296 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456783944300327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2025 10:59:52.2180 5516 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456783947700327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2025 10:59:54.2193 10360 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 23/01/2025 10:59:55.9085 670 ms. OPEN: select * from abbSubscriptions inner join abbCards on subId = carSubId inner join tabCustomer on cusId = subCusId where carStatus = 'V' and subStatus='V' and carCode = '456783779200327005012999' AND subAbbType <> 6 23/01/2025 10:59:56.7222 2156 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 10:59:54','V',4919916008829260,2025,'2025-01-23 10:57:23','456783944300327001031999',1,2,1,'I','',1,0,1,'','',4) 23/01/2025 10:59:56.7222 2159 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 10:59:54','V',5260205328935780,2025,'2025-01-23 10:57:57','456783947700327005031999',1,2,16,'I','',1,0,1,'','',4) 23/01/2025 10:59:58.5838 1840 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2025 11:00:00.3920 5936 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 11:00:00.6512 4420 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 = '456783897200327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 23/01/2025 11:00:00.6522 4114 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 = '456783779200327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 23/01/2025 11:00:01.9851 557 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 23/01/2025 11:00:02.6445 2252 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); 23/01/2025 11:00:36.8658 509 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 18 and payDateTime = '2025-01-23 11:00:36' nr: 0 23/01/2025 11:25:28.0158 17585 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 23/01/2025 11:25:28.0278 17346 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 (WAIT TIME 8 ms.) 23/01/2025 11:25:28.0298 16964 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 (WAIT TIME 9 ms.) 23/01/2025 11:25:28.5644 533 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 11:25:28.5684 537 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 23/01/2025 11:25:29.8067 1044 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 23/01/2025 11:25:29.8067 1050 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 23/01/2025 11:25:29.8137 1046 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 23/01/2025 11:25:29.8137 1053 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 23/01/2025 11:25:29.8717 1103 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/01/2025 11:25:29.8727 1116 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 23/01/2025 11:25:29.8737 1112 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 23/01/2025 11:25:29.8747 1107 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 23/01/2025 11:25:29.8757 1110 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/01/2025 11:25:29.8757 1108 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/01/2025 11:25:29.8767 1109 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/01/2025 11:25:29.8777 1108 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 1 ms.) 23/01/2025 11:25:29.8787 1116 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/01/2025 11:25:29.9576 1195 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 23/01/2025 11:25:29.9586 1189 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 23/01/2025 11:25:30.4391 637 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' (WAIT TIME 33 ms.) 23/01/2025 11:25:38.8975 6806 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456784083700327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2025 11:25:38.8985 6806 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0240526504678' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 23/01/2025 11:25:39.1308 8688 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 23/01/2025 11:25:40.1428 787 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 23/01/2025 11:25:41.4331 1961 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,'2025-01-23 11:25:39','V',5116021886254350,2025,'2025-01-23 11:21:56','456783763100327005029999',2,2,2,'O','',1,0,1,'','1301662587622',185,0) 23/01/2025 11:25:41.4331 649 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 11:25:40','V',4700513211857930,2025,'2025-01-23 11:20:37','456784083700327005031999',1,2,16,'I','',1,0,1,'','',4) 23/01/2025 11:25:42.5587 1114 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2025 11:25:43.6020 4332 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 23/01/2025 11:25:45.9196 2317 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); 23/01/2025 11:27:12.8848 677 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 = '456784123200327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 23/01/2025 11:31:42.2125 14406 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 23/01/2025 11:41:25.9365 1496 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 23/01/2025 12:34:27.1317 988 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 28 order by traDateTime desc,traId desc 23/01/2025 13:03:39.5635 713 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 23/01/2025 13:22:29.5443 2178 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 23/01/2025 13:27:31.6047 1191 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 23/01/2025 13:31:07.0045 934 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 23/01/2025 15:10:04.6425 502 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 15:10:04','V',4737608898483300,2025,'2025-01-23 15:10:03','456785339200327005012999',2,2,2,'O','',0,'2025-01-23 15:10:04',1,'','',0) 23/01/2025 17:02:14.9085 526 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 30 order by traDateTime desc,traId desc 23/01/2025 19:03:02.4228 2392 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 23/01/2025 20:04:57.6208 524 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2025-01-23 20:04:57','V',5318497120764570,2025,'2025-01-23 20:04:57','456787229700327005012999',1,2,16,'I','',1,0,1,'','',4)