19/11/2024 06:38:13.9500 512 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/11/2024 06:38:17.6575 512 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 06:39:45.3596 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 06:42:00.4022 987 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/11/2024 06:42:00.7464 951 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 06:42:09.9275 1170 ms. EXECSCALAR: select traId from movtransit where traUID = 5747254106361800 and traStatus='V' nr: 780623 19/11/2024 06:42:25.4409 698 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 06:47:51.2360 3041 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 19/11/2024 06:48:33.9385 942 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 06:50:15.1010 1380 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 19/11/2024 06:50:15.2291 577 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 06:50:19.8141 557 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/11/2024 06:50:19.9312 603 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 19/11/2024 06:50:24.6223 4091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 06:50:25.8381 1114 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 06:50:26.3965 539 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 06:51:18.5484 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/11/2024 06:56:01.4087 941 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 19/11/2024 06:57:42.0817 508 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 06:58:13.1365 2537 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 19/11/2024 07:00:59.1388 941 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 29 order by traDateTime desc,traId desc 19/11/2024 07:05:18.0996 1090 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:05:39.8152 1396 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:05:41.0320 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:05:44.2501 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:05:46.1194 1032 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:07:19.8251 550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:07:46.2498 952 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 26 order by traDateTime desc,traId desc 19/11/2024 07:12:36.3070 908 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/11/2024 07:12:37.4398 791 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/11/2024 07:12:43.3097 1538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 19/11/2024 07:13:06.7594 3203 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/11/2024 07:13:06.8054 1653 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:13:08.1914 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:13:15.8194 4292 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 19/11/2024 07:13:56.9779 611 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/11/2024 07:13:57.3051 503 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/11/2024 07:13:57.4532 1063 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 19/11/2024 07:15:51.4245 1104 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 07:15:53.5589 1642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:15:57.5576 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:16:00.9519 2298 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:16:01.4002 3513 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 19/11/2024 07:16:10.3532 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:16:16.4573 1947 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:16:20.3329 973 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:16:25.4374 4354 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:17:19.7890 6073 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 19/11/2024 07:17:20.4104 590 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 07:19:19.1202 715 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 07:19:18','V',4921702299578000,2024,'2024-11-19 07:19:16','456132635600327005012999',1,2,16,'I','',1,0,1,'','',4) 19/11/2024 07:22:11.5594 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:22:21.2529 527 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 07:22:20','V',5643399710886860,2024,'2024-11-19 07:22:17','456132653700327005012999',1,2,16,'I','',1,0,1,'','',4) 19/11/2024 07:31:11.0053 610 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-19 07:31:10' where payTraUID = 5356210596895350 and payStatus='V' and payEnabled=1 19/11/2024 07:35:10.1637 3523 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 19/11/2024 07:35:12.0920 1049 ms. EXEC: update abbCards set carLastDate = '2024-11-19 07:35:11',carLastDirection='I' where carStatus='V' and carId = 19 19/11/2024 07:42:49.7685 4575 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/11/2024 07:42:50.0067 2387 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 118 ms.) 19/11/2024 07:45:32.7243 1647 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 19/11/2024 07:48:37.3985 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:49:39.7662 1196 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 19/11/2024 07:51:37.1238 507 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 07:57:28.8341 1550 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:01:04.8073 770 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 19/11/2024 08:02:56.0998 1228 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/11/2024 08:03:09.8200 4266 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:03:13.7167 860 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:03:19.6287 8407 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 19/11/2024 08:03:19.7537 5520 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:03:22.4315 1756 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:03:24.8842 2149 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:03:31.8859 6076 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:03:34.8959 1287 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:03:41.1792 5676 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:03:46.2106 2202 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:03:48.1839 720 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/11/2024 08:03:49.3086 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:08:08.2492 1912 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 19/11/2024 08:08:28.0144 2688 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:09:02.3804 4708 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:09:05.7176 2322 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:09:06.0938 3696 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 08:09:09.8974 3455 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:09:52.6499 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:12:03.7742 1019 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 08:15:00.6122 2614 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/11/2024 08:15:34.9825 2022 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:16:43.4495 897 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 08:18:20.9780 955 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-19 08:18:20','V',5351619751068160,2024,'2024-11-19 08:18:19','456132989900327005012999',1,2,16,'I','',1,0,1,'','0560008304973',188,0) 19/11/2024 08:18:32.5118 1974 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 08:18:59.5139 4746 ms. OPEN: select * from payCurInventory where curTerId = 4 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue 19/11/2024 08:19:04.9965 697 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4921702299578000,5566720768311060,2024,'2024-11-19 08:19:04',' Date: 11/19/2024 8:16:31 AM Code: 456132635600327005012999 Entry Date: 11/19/2024 7:19:16 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400416330 ',0) 19/11/2024 08:21:36.3002 658 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/11/2024 08:21:38.8319 1686 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:21:47.9620 579 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-19 08:21:47' where payTraUID = 5107654849319980 and payStatus='V' and payEnabled=1 19/11/2024 08:22:43.1301 2727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:22:46.8015 1280 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:23:19.8258 5692 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/11/2024 08:23:21.8161 1886 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-19 08:23:19' where payTraUID = 4921702299578000 and payStatus='V' and payEnabled=1 19/11/2024 08:25:53.3673 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:29:00.3291 912 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 19/11/2024 08:29:01.6630 1188 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/11/2024 08:29:29.0183 646 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:29:30.4413 852 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:29:39.7405 1697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:29:45.7666 5306 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:29:51.5905 5306 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:31:16.5295 2069 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 08:31:14','V',4734961494730480,2024,'2024-11-19 08:31:13','456132757200327005012999',2,2,2,'O','',0,'2024-11-19 08:31:14',1,'','',0) 19/11/2024 08:31:24.4378 1092 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-19 08:31:23','V',4841922732889390,2024,'2024-11-19 08:31:14','456133067400327005012999',1,2,16,'I','',1,0,1,'','0230003939767',156,0) 19/11/2024 08:31:25.0332 587 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/11/2024 08:32:40.8410 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:32:42.7773 1049 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:32:46.5148 1882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:32:50.7016 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:32:53.2694 1493 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:32:57.1880 1166 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/11/2024 08:33:08.8338 7290 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:33:39.8697 4764 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 19/11/2024 08:35:02.1770 1882 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-19 08:34:59',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'; 19/11/2024 08:35:02.1810 1275 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:36:28.7552 530 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-19 08:36:28',0,'V',5308643022109480,5207177856035020,2024,'2024-11-19 08:36:28',18,1,0,4,'2024-11-19 08:51:28','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/11/2024 08:36:32.6288 894 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:36:42.4404 1592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:36:44.9551 1065 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:36:48.3894 1807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:36:51.9558 714 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:36:57.6906 4742 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/11/2024 08:37:07.1900 4634 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 08:37:02','V',5466743756327340,2024,'2024-11-19 08:36:49','456132412700327005012999',2,2,2,'O','',0,'2024-11-19 08:37:02',1,'','',0) 19/11/2024 08:37:30.9370 23699 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/11/2024 08:37:35.7733 3658 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 19/11/2024 08:39:20.1503 1523 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:39:27.7334 6322 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:40:50.4035 569 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 19/11/2024 08:41:11.3685 582 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:41:41.5947 745 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 19/11/2024 08:41:46.3458 3096 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:43:05.4474 507 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-19 08:40:32',6,'V',4971901997782380,5672852286969700,2024,'2024-11-19 08:40:32',4,1,0,4,'2024-11-19 08:55:32','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 19/11/2024 08:44:08.8732 826 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/11/2024 08:44:59.5722 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:45:03.6559 3251 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:46:07.0972 718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:46:30.8981 911 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 08:46:29','V',5092711761741290,2024,'2024-11-19 08:46:27','456133158700327005012999',1,2,16,'I','',1,0,1,'','',4) 19/11/2024 08:46:31.7467 635 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/11/2024 08:47:19.1466 2384 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:47:26.7907 5260 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:47:35.1384 2313 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:47:36.9756 1005 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:47:41.6878 1288 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:48:42.2139 627 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-19 08:48:41','V',4994205228954320,2024,'2024-11-19 08:48:39','456133171900327005012999',1,2,16,'I','',1,0,1,'','0230003944081',15,0) 19/11/2024 08:49:26.6428 861 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 19/11/2024 08:49:31.3780 3276 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:50:17.1001 617 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 08:50:16','V',5372634819333520,2024,'2024-11-19 08:50:13','456133181300327005012999',1,2,16,'I','',1,0,1,'','',4) 19/11/2024 08:50:33.4040 2479 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 82 order by traDateTime desc,traId desc 19/11/2024 08:50:34.1875 562 ms. OPEN: select * from paypayment where payUID = 5720718047831950 and payStatus='V' 19/11/2024 08:51:04.2436 5095 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 19/11/2024 08:51:20.8616 2486 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/11/2024 08:51:30.3780 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:51:30.5961 9586 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/11/2024 08:51:31.6929 933 ms. OPEN: select * from tabTicketType where ticId = 2 19/11/2024 08:52:07.8795 910 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 08:52:06','V',5588148637852600,2024,'2024-11-19 08:52:06','456132972100327005012999',2,2,2,'O','',0,'2024-11-19 08:52:06',1,'','',0) 19/11/2024 08:52:57.8799 940 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 08:52:56','V',4688474490031970,2024,'2024-11-19 08:52:56','456133197600327005012999',1,2,16,'I','',1,0,1,'','',4) 19/11/2024 08:54:56.6563 1590 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:55:05.5262 2366 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:55:08.1770 1547 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:55:11.0689 1648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:55:12.2447 715 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:55:17.7433 706 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 08:55:19.5575 1337 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:55:25.3794 5531 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 19/11/2024 08:55:25.3794 5537 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/11/2024 08:55:30.0986 2935 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-19 07:55:27') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-19 08:55:27' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-19 08:55:27' and (resAreId = 1 or resAreId <= 0) nr: 0 19/11/2024 08:55:44.3951 4716 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 08:55:53.8474 1506 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:57:22.2269 5274 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 08:57:23.4837 826 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 08:57:29.3596 5806 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 19/11/2024 08:57:34.1038 15408 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 08:57:18','V',5281570700151450,2024,'2024-11-19 08:57:16','456133223600327005012999',1,2,16,'I','',1,0,1,'','',4) 19/11/2024 08:57:38.9971 9529 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-11-19 07:57:29') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-19 08:57:29' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-19 08:57:29' and (resAreId = 1 or resAreId <= 0) nr: 0 19/11/2024 08:57:43.8123 4816 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 = '456133223600327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 19/11/2024 08:57:43.9614 4941 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/11/2024 08:57:48.4103 689 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-19 08:57:47',0,16,'2024-11-19 08:57:47','','Unauthorized Transit Entry 2') 19/11/2024 08:58:30.3772 781 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 19/11/2024 08:58:31.9683 785 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/11/2024 09:00:36.3950 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:00:55.8812 838 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-19 09:00:54' where traUID = 5182710087434960 and traStatus='V' and traEnabled=1 19/11/2024 09:02:05.4079 1911 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 09:02:03','V',5148527461368000,2024,'2024-11-19 09:02:02','456133252200327005012999',1,2,16,'I','',1,0,1,'','',4) 19/11/2024 09:02:07.0620 883 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 19/11/2024 09:02:11.3609 638 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/11/2024 09:04:49.2043 641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:04:51.6029 1184 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:06:34.7331 1319 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 09:06:35.9399 614 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-19 09:06:35',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'; 19/11/2024 09:06:37.4950 1554 ms. EXEC: update payInventory set invCreation = '2024-11-19 09:06:35',invModify = '2024-11-19 09:06:35',invUseId=0,invStatus='V' where invId = 220069 19/11/2024 09:08:09.9617 508 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 19/11/2024 09:08:19.0658 1138 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-19 09:08:17',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'; 19/11/2024 09:09:02.2937 610 ms. EXEC: update abbCards set carLastDate = '2024-11-19 09:09:01',carLastDirection='I' where carStatus='V' and carId = 142 19/11/2024 09:09:07.7473 821 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 19/11/2024 09:10:43.6196 1769 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 19/11/2024 09:10:52.5305 633 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 372809 else acvFstPayId end),acvLstPayId = 372809 where acvSftId = 818 and acvCodeId = 3 19/11/2024 09:12:12.0536 2938 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/11/2024 09:13:05.6578 744 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:13:51.5956 7350 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:13:51.6907 7145 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 19/11/2024 09:14:49.3780 529 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:15:33.4606 1101 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 09:15:32','V',5138483838694210,2024,'2024-11-19 09:15:32','456132995300327005012999',2,2,2,'O','',0,'2024-11-19 09:15:32',1,'','',0) 19/11/2024 09:16:42.2058 742 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 88 order by traDateTime desc,traId desc 19/11/2024 09:16:57.4210 1438 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/11/2024 09:16:57.7652 1953 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-19 09:16:55',0,16,'2024-11-19 09:16:55','','Unauthorized Transit Entry 2') 19/11/2024 09:16:57.7652 1961 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 09:16:55','V',4953076113618680,2024,'2024-11-19 09:16:51','456133341100327001012999',1,2,1,'I','',1,0,1,'','',4) 19/11/2024 09:16:58.2085 775 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 09:16:58.5178 738 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/11/2024 09:17:44.0724 1285 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/11/2024 09:17:55.5791 741 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 19/11/2024 09:18:02.8180 5782 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 09:18:02.8190 4051 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 19/11/2024 09:18:12.5996 5654 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/11/2024 09:18:57.6660 2351 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:19:52.2528 897 ms. EXEC: update payCurInventory set curQuantity=round(curQuantity+8,8),curAmount=round(curAmount+1600,8) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 200 and curType = 'N' 19/11/2024 09:19:53.6767 1229 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-19 09:17:39',5,3,42101,0,50,-20,-1000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-19 09:17:39',5,3,42101,0,50,20,1000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-19 09:17:39',5,3,42101,0,100,-37,-3700,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-19 09:17:39',5,3,42101,0,100,37,3700,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-19 09:17:39',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 ('2024-11-19 09:17:39',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 ('2024-11-19 09:17:39',5,3,42101,0,500,-3,-1500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-19 09:17:39',5,3,42101,0,500,3,1500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-11-19 09:17:39',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 19/11/2024 09:22:34.1746 565 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4779872941697110,5132032179155940,2024,'2024-11-19 09:22:33','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 11/19/2024 8:40:29 AM Date : 11/19/2024 9:22:32 AM Code : 456133122900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 19/11/2024 09:22:36.7914 1787 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 19/11/2024 09:23:15.3311 759 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 19/11/2024 09:23:31.1867 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:23:37.9772 5273 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:23:40.5860 2060 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:23:43.6730 2350 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:23:56.1633 7164 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 4711 ms.) 19/11/2024 09:24:21.2341 1102 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 09:24:20','V',5064061458726390,2024,'2024-11-19 09:24:19','456133122900327005012999',2,2,2,'O','',0,'2024-11-19 09:24:20',1,'','',0) 19/11/2024 09:24:30.5913 813 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 19/11/2024 09:24:31.9272 2023 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/11/2024 09:25:48.5365 628 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:25:49.7543 639 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 19/11/2024 09:25:49.7553 584 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:26:59.0678 1093 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 19/11/2024 09:27:42.8349 566 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:27:45.2295 2191 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:28:58.5363 880 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:29:05.8852 930 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-19 09:29:03',0,'V',5330328202357300,4698194191994560,2024,'2024-11-19 09:29:03',3,1,0,4,'2024-11-19 09:44:03','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 19/11/2024 09:31:46.7366 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,'2024-11-19 09:31:46','V',5294362778062160,2024,'2024-11-19 09:31:44','456133430400327005012999',1,2,16,'I','',1,0,1,'','0230003939927',164,0) 19/11/2024 09:31:56.0208 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/11/2024 09:32:10.7016 996 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2024-11-19 09:32:09','V',4786633315873920,2024,'2024-11-19 09:32:08','456133432800327005012999',1,2,16,'I','',1,0,1,'','0560008419314',195,0) 19/11/2024 09:32:18.6069 1028 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:32:25.2853 4204 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:32:27.7720 990 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:34:16.1428 993 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/11/2024 09:34:39.3623 9549 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 205 ms.) 19/11/2024 09:34:45.1492 5297 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:35:03.1832 13338 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketgracetime' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 19/11/2024 09:35:23.5318 517 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 19/11/2024 09:35:50.4448 642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:35:57.0562 806 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:36:26.8761 645 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:36:29.7791 881 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:36:34.1170 3825 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:38:40.8047 1088 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 09:38:59.0889 1560 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 09:39:06.2317 10931 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 19/11/2024 09:39:06.6180 2154 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 09:39:13.2084 722 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 09:39:18.1597 4746 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 19/11/2024 09:40:58.1164 2190 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 19/11/2024 09:41:26.1912 1127 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-11-19 09:41:24',0,'V',5604633394870630,5283109723580520,2024,'2024-11-19 09:41:24',3,1,0,4,'2024-11-19 09:56:24','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 19/11/2024 09:41:47.6707 502 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 19/11/2024 09:41:56.2605 4758 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 19/11/2024 09:45:25.3653 7197 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:45:28.9837 3618 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 19/11/2024 09:45:28.9857 3417 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:46:38.5730 586 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 09:48:21.8581 5538 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-19 09:48:16' where traUID = 4688474490031970 and traStatus='V' and traEnabled=1 19/11/2024 09:48:57.6379 730 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 19/11/2024 09:48:59.5612 1471 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:49:00.3567 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/11/2024 09:50:30.3900 661 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/11/2024 09:51:14.7648 4774 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 09:55:51.2512 679 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 19/11/2024 09:58:38.6643 1943 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-19 09:58:36' where traUID = 5672560305488300 and traStatus='V' and traEnabled=1 19/11/2024 10:02:44.6297 1827 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 10:02:51.6173 6365 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 10:02:54.8094 622 ms. EXECSCALAR: select traId from movtransit where traUID = 5000512042536430 and traStatus='V' nr: 780756 19/11/2024 10:02:55.8922 665 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 10:02:57.0409 509 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 17 ms.) 19/11/2024 10:02:58.3618 986 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 10:02:58.3618 918 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 10:03:07.8772 5162 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 19/11/2024 10:03:08.1824 7729 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/11/2024 10:03:08.1874 7839 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 10:03:37.5820 27438 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/11/2024 10:03:37.6090 27655 ms. EXEC: update abbCards set carLastDate = '2024-11-19 10:03:09',carLastDirection='I' where carStatus='V' and carId = 25 19/11/2024 10:03:47.2404 5876 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 1249 ms.) 19/11/2024 10:03:50.6417 633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/11/2024 10:08:29.1304 842 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 19/11/2024 10:11:01.9510 1092 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 19/11/2024 10:13:05.7018 3526 ms. OPEN: show columns from tabParameters where Field = 'parVatMethod' 19/11/2024 10:18:36.9060 21715 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 19/11/2024 10:18:49.0455 10966 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 19/11/2024 10:18:52.0427 2858 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/11/2024 10:18:54.8176 520 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 19/11/2024 10:18:54.8606 2816 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); 19/11/2024 10:19:19.7294 17342 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 19/11/2024 10:27:16.4631 3450 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 19/11/2024 10:37:27.6928 569 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-11-19 10:37:27','V',5320255300297060,2024,'2024-11-19 10:37:26','456133464600327005012999',2,2,2,'O','',0,'2024-11-19 10:37:27',1,'','',0) 19/11/2024 10:43:57.8865 1010 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 19/11/2024 10:44:01.8569 528 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 19/11/2024 10:44:18.2271 558 ms. EXEC: update payInventory set invCreation = '2024-11-19 10:44:17',invModify = '2024-11-19 10:44:17',invUseId=0,invStatus='V' where invId = 220106 19/11/2024 10:46:43.7855 642 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 19/11/2024 10:58:00.4821 2773 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 19/11/2024 11:43:38.4855 1094 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 19/11/2024 12:09:15.0921 931 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 19/11/2024 20:38:37.7054 595 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-19 20:38:37' where payTraUID = 5500929194803200 and payStatus='V' and payEnabled=1