10/01/2025 09:57:11.0493 525 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-10 09:57:10','V',5597743153883760,2025,'2025-01-10 09:57:09','456653465400327005012999',2,2,2,'O','',0,'2025-01-10 09:57:10',1,'','',0) 10/01/2025 10:26:56.8552 1861 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 10/01/2025 12:38:31.2197 542 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 13:34:28.1145 626 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-10 13:34:27',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 ('2025-01-10 13:34:27',3,42101,0,100,-1,-100,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 10/01/2025 14:02:51.3478 907 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 15:03:31.7136 600 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5607604344643450,5006468889837950,2025,'2025-01-10 15:03:31',' Date: 1/10/2025 3:03:30 PM Code: 456654911200327005012999 Entry Date: 1/10/2025 1:38:32 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 # 2500701426 ',0) 10/01/2025 15:41:01.7161 643 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-10 15:41:01','V',5197707375550020,2025,'2025-01-10 15:40:59','456655249900327005012999',2,2,2,'O','',0,'2025-01-10 15:41:01',1,'','',0) 10/01/2025 19:20:49.0680 639 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 19:33:09.2900 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 19:33:57.9145 1057 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-01-10 19:33:56' where subId = 178 10/01/2025 19:42:36.9898 565 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 19:48:32.2797 594 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 19:49:44.7424 1192 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5529419926378770,4877096320586240,2025,'2025-01-10 19:49:43',' Date: 1/10/2025 7:49:43 PM Code: 456656673400327005012999 Entry Date: 1/10/2025 6:32:14 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 # 2500701484 ',0) 10/01/2025 19:53:17.4187 1333 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 19:55:13.6152 502 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 20:01:37.4326 979 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-10 20:01:36',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 10/01/2025 20:03:07.8465 1099 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/01/2025 20:03:08.5310 560 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 20:05:47.1101 937 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 20:08:54.8298 1422 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/01/2025 20:13:40.2566 805 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 20:18:54.8549 581 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/01/2025 20:22:06.3669 1193 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-10 20:22:03',0,'V',5146618658190110,5145592886629890,2025,'2025-01-10 20:22:03',3,1,0,4,'2025-01-10 20:37:03','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 10/01/2025 20:22:08.2162 604 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-01-10 20:22:07',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 10/01/2025 20:24:56.4967 523 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 20:25:00.9566 765 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/01/2025 20:27:22.1210 870 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/01/2025 20:28:10.3502 1458 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 20:31:27.3910 578 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 20:31:27.9944 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 20:39:09.8805 655 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 20:40:08.0080 506 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-10 20:40:07',0,'V',5595723895731310,5526791358890550,2025,'2025-01-10 20:40:07',18,1,0,4,'2025-01-10 20:55:07','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 10/01/2025 20:43:59.8983 623 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 21:08:49.7129 541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 21:18:22.6419 1108 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 21:18:33.6854 1339 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/01/2025 21:19:03.8596 660 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-10 21:19:03','V',5434845329682280,2025,'2025-01-10 21:19:02','456657674200327005012999',1,2,16,'I','',1,0,1,'','',4) 10/01/2025 21:19:04.7141 632 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/01/2025 21:19:40.6314 662 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-10 21:19:39','V',5441753195354980,2025,'2025-01-10 21:19:38','456657068100327005012999',2,2,2,'O','',0,'2025-01-10 21:19:39',1,'','',0) 10/01/2025 21:19:47.6331 2782 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/01/2025 21:22:31.1154 958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 21:25:14.8843 1301 ms. EXEC: update tabTerminalReceipt set trcProgressive = 214, trcLastPrinted = '2500600214', trcLastDate = '2025-01-10 21:25:13' where trcStatus='V' and trcTerId = 17 10/01/2025 21:25:16.1191 967 ms. EXEC: update payReceipt set recCreation = '2025-01-10 21:25:15',recModify = '2025-01-10 21:25:15',recUseId=0,recStatus='V' where recId = 341147 10/01/2025 21:25:55.7149 574 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 21:26:40.1277 612 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 21:28:29.6815 535 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 21:37:32.1833 1091 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); 10/01/2025 21:40:39.3934 517 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 21:49:54.4266 513 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 10/01/2025 21:49:54.4276 571 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 10/01/2025 21:49:55.4022 674 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 21:49:56.6130 1162 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 10/01/2025 21:58:57.9397 688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 21:59:52.0108 534 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 22:02:06.6725 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 22:04:01.5612 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 22:24:06.2687 2276 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/01/2025 22:24:43.7828 926 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 22:24:48.9803 1054 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/01/2025 22:29:32.9622 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 22:39:28.4685 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 22:45:46.4499 1567 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/01/2025 22:53:52.5903 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 10/01/2025 23:03:57.1649 1184 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.1769 1247 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 44 ms.) 10/01/2025 23:03:57.1869 1264 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 49 ms.) 10/01/2025 23:03:57.1929 1191 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 59 ms.) 10/01/2025 23:03:57.1949 1205 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 60 ms.) 10/01/2025 23:03:57.1959 1287 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 58 ms.) 10/01/2025 23:03:57.1969 1217 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 55 ms.) 10/01/2025 23:03:57.1979 1203 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 55 ms.) 10/01/2025 23:03:57.2219 1254 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.3720 1506 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.3740 1502 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.3750 1522 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.3760 1527 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.3770 1489 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.3790 1524 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.3800 1493 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.3840 1441 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.3850 1501 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 10/01/2025 23:03:57.3970 513 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/01/2025 23:03:58.4947 1537 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 1108 ms.) 10/01/2025 23:03:58.5057 554 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 1100 ms.) 10/01/2025 23:03:58.5158 568 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 1110 ms.) 10/01/2025 23:03:58.5178 534 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 1111 ms.) 10/01/2025 23:04:00.2239 875 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/01/2025 23:04:00.2389 821 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/01/2025 23:04:00.2389 911 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/01/2025 23:04:00.2399 911 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/01/2025 23:04:00.2409 902 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/01/2025 23:04:00.2409 911 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/01/2025 23:04:00.2409 893 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/01/2025 23:04:00.2419 883 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/01/2025 23:04:00.2419 884 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/01/2025 23:04:00.2429 834 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/01/2025 23:04:00.2439 827 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/01/2025 23:04:00.2479 901 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/01/2025 23:04:00.2489 900 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/01/2025 23:04:00.2489 903 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/01/2025 23:04:00.2499 900 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/01/2025 23:04:00.2539 903 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/01/2025 23:04:00.2549 925 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 10/01/2025 23:04:00.2569 908 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/01/2025 23:04:00.2649 915 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/01/2025 23:04:00.2689 911 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/01/2025 23:04:00.2719 915 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/01/2025 23:04:00.3970 1032 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/01/2025 23:04:01.1635 727 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 16 AND extPlateWaitOperator=0 10/01/2025 23:04:01.1875 748 ms. EXEC: update tabTerminalExtraMem SET extLoop2 = 0 where extStatus='V' and extTerId = 16 AND extPlateWaitOperator=0 10/01/2025 23:04:01.1885 718 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 1 AND extPlateWaitOperator=0 (WAIT TIME 24 ms.) 10/01/2025 23:04:01.2586 817 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 2 AND extPlateWaitOperator=0 10/01/2025 23:04:11.4359 16625 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '821597' and traDirection='I' order by traId DESC LIMIT 1 10/01/2025 23:04:16.1467 15740 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 10/01/2025 23:04:18.2447 1976 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '456658034600327001012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 10/01/2025 23:04:22.4234 6035 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/01/2025 23:04:22.4894 4242 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 = '456658034600327001012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 10/01/2025 23:04:25.5134 3088 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); 10/01/2025 23:04:48.5796 2417 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 10/01/2025 23:04:59.5618 1882 ms. OPEN: show columns from movoperator where Field = 'opeQuery'