07/05/2025 03:39:50.1990 26193 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 07/05/2025 03:39:56.8909 5230 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 07/05/2025 03:40:00.8103 3718 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/05/2025 03:40:02.2979 1487 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); 07/05/2025 05:09:17.1007 1403 ms. OPEN: select max(traCode) as vCode from movTransit where traCode >='45782 ' and traCode < '45783 ' and traType = 22 07/05/2025 05:09:18.8763 694 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 = '457820000100327003229999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 07/05/2025 07:34:28.4161 1948 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-05-07 07:34:25',0,'V',5231076040875330,5084329074107430,2025,'2025-05-07 07:34:25',3,1,0,0,'2025-05-07 07:34:25','C','KES',1,50,0,'',' ',' ',2,1,0,0,'',0,0) 07/05/2025 07:34:29.4075 982 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5084329074107430,5231076040875330,2025,'2025-05-07 07:34:28','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 5/7/2025 7:14:54 AM Date : 5/7/2025 7:34:25 AM Code : 457822609400327005031999 Total : 1.00 KES VAT 16% : 0.14 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES Not changed Note : 0.00 KES Coin : 0.00 KES Unavailable : 49.00 KES',0) 07/05/2025 07:55:52.5811 28760 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 07/05/2025 07:55:52.5911 2049 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 11 ms.) 07/05/2025 07:55:52.5931 18070 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 14 ms.) 07/05/2025 07:55:53.1672 573 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/05/2025 07:55:53.1742 580 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/05/2025 07:55:58.5408 4940 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 07/05/2025 07:56:01.4782 2773 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/05/2025 07:56:03.1280 1649 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); 07/05/2025 07:56:20.7614 1261 ms. OPEN: select max(traCode) as vCode from movTransit where traCode >='45782 ' and traCode < '45783 ' and traType = 22 07/05/2025 07:56:22.4667 607 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 = '457820000200327003229999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 07/05/2025 09:07:45.6563 15993 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 = 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 07/05/2025 09:11:53.5358 2069 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 07/05/2025 12:10:02.1177 575 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-05-07 12:10:01','V',5173486868260300,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:10:37.3453 664 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 183 order by traDateTime desc,traId desc 07/05/2025 12:10:40.2346 977 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-05-07 12:10:39','V',5470733075745230,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:10:40.8336 580 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-05-07 12:10:40','V',5628018842924580,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:10:42.8015 1502 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-05-07 12:10:41','V',4800808956569640,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:10:44.6011 751 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-05-07 12:10:43','V',4930075486033700,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:10:46.4511 648 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-05-07 12:10:45','V',5265114961725970,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:11:42.2620 533 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-05-07 12:11:41','V',4924653868440270,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:12:26.0805 1067 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-05-07 12:12:25','V',5058352751526420,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:12:29.3683 3267 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-05-07 12:12:26','V',5587691711554580,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:13:49.6336 565 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-05-07 12:13:49','V',5344537969110740,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:14:15.0080 1169 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-05-07 12:14:13','V',5123849461853470,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:16:06.0233 3053 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-05-07 12:16:02','V',4710977814921240,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:17:48.6205 1229 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-05-07 12:17:47','V',5319459497053210,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:19:38.4350 2762 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-05-07 12:19:35','V',4652252511128880,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:19:39.8017 1340 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-05-07 12:19:38','V',5474903633959050,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:20:24.2638 504 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-05-07 12:20:23','V',5666528243235200,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:20:59.3257 515 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-05-07 12:20:58','V',5469949039283580,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:23:34.6566 557 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-05-07 12:23:34','V',4745665168525660,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:24:59.7380 621 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-05-07 12:24:59','V',4796411369242190,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:28:21.9437 510 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-05-07 12:28:21','V',5119783806783990,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:30:12.0003 539 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-05-07 12:30:11','V',5145613541826280,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:32:08.2795 2371 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 07/05/2025 12:33:17.6071 588 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-05-07 12:33:17','V',5431297663547750,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:38:28.0188 502 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-05-07 12:38:27','V',5488723318891680,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:42:54.0192 509 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-05-07 12:42:53','V',5341121541429030,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:43:05.3026 516 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-05-07 12:43:04','V',5623630354040890,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:43:49.6399 704 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-05-07 12:43:48','V',5292130620510030,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:44:34.4662 567 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-05-07 12:44:33','V',5559899185916630,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:49:12.0103 510 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-05-07 12:49:11','V',5655882049170420,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:50:53.0515 597 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-05-07 12:50:52','V',5428868769092370,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:56:53.1717 641 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-05-07 12:56:52','V',5224330305532600,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 12:57:04.6961 525 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-05-07 12:57:04','V',4790205802819270,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:57:15.9106 529 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-05-07 12:57:15','V',5721853282222040,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 12:57:58.6788 517 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-05-07 12:57:58','V',5592840605412570,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 13:01:35.1215 510 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-05-07 13:01:34','V',4932736138393840,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 13:04:27.9128 2098 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-05-07 13:04:25','V',5480633057283530,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 13:08:06.0850 3953 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-05-07 13:08:02','V',5422923996370600,2025,'2025-05-07 10:47:32','457820076400327005029999',2,1,2,'O','',1,0,1,'','0532370678705',206,0) 07/05/2025 13:08:08.6443 1432 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-05-07 13:08:07','V',5093254784547020,2025,'2025-05-07 11:33:59','457820076100327005029999',2,1,2,'O','',1,0,1,'','0532370677718',17,0) 07/05/2025 13:28:20.2995 30628 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 07/05/2025 13:28:20.4324 30795 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/05/2025 13:28:20.4344 27804 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 07/05/2025 13:28:20.4374 10064 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 07/05/2025 13:28:20.4394 30802 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/05/2025 13:28:21.4932 844 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/05/2025 13:28:21.4932 848 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/05/2025 13:28:21.4942 849 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/05/2025 13:28:21.4962 852 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/05/2025 13:28:21.4992 849 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/05/2025 13:28:21.5022 858 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/05/2025 13:28:21.5032 861 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/05/2025 13:28:21.5032 852 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/05/2025 13:28:21.5042 839 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/05/2025 13:28:21.5042 854 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/05/2025 13:28:21.5052 863 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/05/2025 13:28:21.5052 853 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/05/2025 13:28:21.5062 860 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/05/2025 13:28:21.5092 867 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/05/2025 13:28:21.5092 864 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/05/2025 13:28:21.5102 868 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/05/2025 13:28:21.5102 869 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 07/05/2025 13:28:21.5112 867 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/05/2025 13:28:21.5172 873 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) 07/05/2025 13:28:22.1850 570 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitId' nr: 1 07/05/2025 13:28:22.2110 667 ms. EXEC: CREATE TABLE IF NOT EXISTS tabTimeZones(timId int(11) not null auto_increment,timCreation DATETIME not null default '0000-00-00',timModify TIMESTAMP not null,timUseId int(11) not null default 0,timStatus varchar(1) not null default 'V',timRegion varchar(5) not null default '',timIdWindows varchar(100) not null default '',timIdLinux varchar(100) not null default '', PRIMARY KEY (timId)) ENGINE=InnoDB DEFAULT CHARSET=utf8; 07/05/2025 13:28:22.7677 530 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 07/05/2025 13:28:22.7677 529 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 07/05/2025 13:28:23.5191 536 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-05-07 12:28:22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-05-07 13:28:22' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-05-07 13:28:22' and (resAreId = 1 or resAreId <= 0) nr: 0 07/05/2025 13:28:23.5201 535 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-05-07 12:28:22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-05-07 13:28:22' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-05-07 13:28:22' and (resAreId = 1 or resAreId <= 0) nr: 0 07/05/2025 13:28:23.5201 547 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-05-07 12:28:22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-05-07 13:28:22' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-05-07 13:28:22' and (resAreId = 1 or resAreId <= 0) nr: 0 07/05/2025 13:28:23.5221 549 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-05-07 12:28:22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-05-07 13:28:22' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-05-07 13:28:22' and (resAreId = 1 or resAreId <= 0) nr: 0 07/05/2025 13:28:23.5862 609 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-05-07 12:28:22') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-05-07 13:28:22' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-05-07 13:28:22' and (resAreId = 1 or resAreId <= 0) nr: 0 07/05/2025 13:28:23.6062 616 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 2))) order by tagName 07/05/2025 13:28:23.8028 813 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 2))) order by tagName 07/05/2025 13:28:28.5935 3715 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457824845500327001031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 07/05/2025 13:28:28.5945 3715 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 07/05/2025 13:28:28.7216 6535 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '928360' and traDirection='I' order by traId DESC LIMIT 1 07/05/2025 13:28:28.7226 4741 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '926563' and traDirection='I' order by traId DESC LIMIT 1 07/05/2025 13:28:30.3783 1007 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0098788191894' and traDirection='I' order by traId desc limit 1 07/05/2025 13:28:30.7107 7931 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 07/05/2025 13:28:32.6787 2290 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-05-07 13:28:30','V',5721080380455800,2025,'2025-05-07 12:09:10','0098788191894',2,1,2,'O','',1,0,1,'','',0) 07/05/2025 13:28:32.6797 2141 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-05-07 13:28:30','V',5750701929886690,2025,'2025-05-07 13:27:35','457824845500327001031999',1,1,1,'I','',1,0,1,'','',4) 07/05/2025 13:28:32.9519 1048 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 = '457824704100327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 07/05/2025 13:28:33.0477 1144 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 = '457824603600327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 07/05/2025 13:28:34.4467 1756 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/05/2025 13:28:36.2389 5525 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/05/2025 13:28:36.2929 3340 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 = '457824704100327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 07/05/2025 13:28:36.3279 3279 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 = '457824603600327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 07/05/2025 13:28:37.8067 1567 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); 07/05/2025 13:29:20.0314 2129 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 07/05/2025 13:33:52.5418 560 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 202 order by traDateTime desc,traId desc