07/12/2024 00:12:37.1051 538 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-07 00:12:36' where traUID = 5283861659233180 and traStatus='V' and traEnabled=1 07/12/2024 00:25:55.2831 680 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52515, trcLastPrinted = '2400752515', trcLastDate = '2024-12-07 00:25:54' where trcStatus='V' and trcTerId = 18 07/12/2024 00:30:35.9811 1818 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 00:35:33.5744 519 ms. EXEC: update abbAreaGroup set argNrInside = 0 where argStatus='V' and argNrInside < 0 07/12/2024 00:51:52.5109 891 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 00:56:46.3647 625 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/12/2024 00:56:47.4724 781 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 00:58:40.1059 740 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 00:59:01.7324 981 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 00:59:51.9440 1012 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 01:01:27.4279 545 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 01:24:19.9952 685 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 01:31:21.7517 530 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 01:38:17.9851 591 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 01:42:00.2770 664 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 01:44:30.3345 1287 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/12/2024 01:51:44.3642 521 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 01:58:37.1045 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 01:58:37.1405 828 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 02:07:44.1920 701 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 02:09:10.6139 517 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 02:19:39.7136 597 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 02:36:47.5507 569 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 02:43:45.1413 501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 02:46:22.2055 552 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/12/2024 02:46:28.2599 749 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 02:59:50.6231 760 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 03:00:21.5048 604 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 03:00:47.7025 706 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 03:01:41.0533 661 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 03:17:52.4972 543 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 07/12/2024 03:17:52.9975 895 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/12/2024 03:17:53.9431 650 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 03:28:20.0798 598 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 03:37:06.1580 514 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 03:39:19.1317 547 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/12/2024 03:39:19.1847 592 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 03:46:28.0660 979 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 03:49:53.9040 554 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 04:32:44.2139 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 04:41:35.9110 935 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 05:28:02.6336 601 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 05:47:52.6383 767 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 05:54:26.5716 732 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 06:19:45.2356 574 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 06:20:45.3327 745 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 06:49:19.7045 709 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 06:51:33.8721 522 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 07:33:57.5176 821 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 07:35:31.1321 1126 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-12-07 06:35:30') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-07 07:35:29' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-07 07:35:29' and (resAreId = 1 or resAreId <= 0) nr: 0 07/12/2024 07:41:25.2198 1107 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 07:52:02.1845 609 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 07:55:20.5691 679 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 08:16:46.4254 1617 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-07 08:16:41',5,3,42101,0,50,-8,-400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-07 08:16:41',5,3,42101,0,100,-53,-5300,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-07 08:16:41',5,3,42101,0,200,-9,-1800,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-07 08:16:41',5,3,42101,0,500,-3,-1500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-07 08:16:41',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 07/12/2024 08:23:02.0004 562 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 08:23:39.5975 1059 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 08:23:39.5995 563 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/12/2024 08:39:08.7635 777 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/12/2024 08:40:11.9628 555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 08:45:43.3032 766 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 08:45:47.4079 566 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-12-07 08:45:46','V',5123196439606000,2024,'2024-12-07 08:45:46','456313154600327005012999',1,2,16,'I','',1,0,1,'','0230003941812',181,0) 07/12/2024 08:56:51.4417 656 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 09:06:11.7839 573 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 09:06:16.6962 695 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-07 09:06:15' where traUID = 5089562421199630 and traStatus='V' and traEnabled=1 07/12/2024 09:06:16.9264 565 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 09:06:16.9264 567 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 09:06:21.8666 1286 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 09:15:14.7298 873 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 09:18:37.9126 660 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 09:20:20.5782 759 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 09:23:58.2547 683 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 09:31:01.8618 737 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 09:42:58.7369 699 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/12/2024 09:43:05.0571 985 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/12/2024 09:44:44.7816 769 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 09:59:54.9912 684 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-12-07 09:59:54','V',5024819347021500,2024,'2024-12-07 09:59:53','456313306800327001012999',2,2,2,'O','',0,'2024-12-07 09:59:54',1,'','',0) 07/12/2024 10:15:36.9147 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:16:17.0395 678 ms. EXEC: update paycash set casCreation = '2024-12-07 10:16:16',casModify = '2024-12-07 10:16:16',casUseId=0,casStatus='V' where casId = 198673 07/12/2024 10:16:22.3851 582 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 07/12/2024 10:18:08.3679 784 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 10:21:36.1018 796 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:25:32.7249 653 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:34:07.7591 526 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payVatPercent,payVatAmount) VALUES ('2024-12-07 10:34:07',0,'V',5694866985896000,5405017769677920,2024,'2024-12-07 10:34:07',2,1,0,-1,'2024-12-07 11:34:07','S','KES',0,0,0,'','','',3,0,0) 07/12/2024 10:35:24.4714 1413 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/12/2024 10:35:48.4624 569 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:36:21.9778 733 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:38:01.8836 848 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:40:31.7107 944 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:41:28.6068 839 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:50:45.1267 597 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:51:47.9116 786 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:55:14.4257 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 10:58:51.2986 756 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-07 10:58:50',0,0,'V',5433115595216410,4979538343791610,2024,'2024-12-07 10:58:50',3,'KES',-1,50,-50,'N',''); 07/12/2024 10:58:52.3703 909 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-07 10:58:50',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'; 07/12/2024 10:58:56.7012 1541 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 11:01:52.1985 617 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 11:03:40.8982 546 ms. EXEC: update paycash set casCreation = '2024-12-07 11:03:40',casModify = '2024-12-07 11:03:40',casUseId=0,casStatus='V' where casId = 198699 07/12/2024 11:04:32.9750 549 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/12/2024 11:04:33.9046 625 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 11:13:42.2433 526 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 15 ms.) 07/12/2024 11:21:03.8803 745 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 11:24:19.3637 508 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 11:38:11.7470 712 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 11:57:50.1806 535 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 12:02:38.6844 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 12:03:52.8250 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 12:05:26.3435 825 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 12:12:27.7671 27784 ms. OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal 07/12/2024 12:12:37.2364 677 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 12:14:23.7226 767 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/12/2024 12:14:40.9041 758 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 12:15:37.3538 871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 12:15:41.1413 3442 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 12:23:23.4340 538 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 12:23:27.0254 634 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 12:24:12.2196 865 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 12:39:39.1465 824 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 07/12/2024 12:39:39.3306 1084 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/12/2024 12:39:40.8627 973 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 12:40:21.5749 566 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52559, trcLastPrinted = '2400752559', trcLastDate = '2024-12-07 12:40:21' where trcStatus='V' and trcTerId = 18 07/12/2024 12:43:44.6750 639 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5082218351740300,5472560068557300,2024,'2024-12-07 12:43:44',' Data: 12/7/2024 12:41:09 PM Codice: 456314078600327005012999 Ingresso: 12/7/2024 11:19:46 AM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400607855 ',0) 07/12/2024 12:44:26.1828 644 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/12/2024 12:44:26.2078 747 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 12:46:13.0882 540 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 12:46:25.1082 596 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 12:48:46.0805 662 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/12/2024 12:51:41.2645 1465 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 12:52:03.2012 503 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 12:56:29.7383 770 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 12:58:05.4418 541 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/12/2024 13:02:44.7255 635 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-07 13:02:44',0,16,'2024-12-07 13:02:44','','Unauthorized Transit Entry 2') 07/12/2024 13:03:59.0165 697 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 13:04:11.0585 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 13:06:14.6521 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 13:07:26.0138 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 13:09:56.0511 536 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 07/12/2024 13:09:57.5681 550 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 13:11:31.0225 582 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 13:16:32.8883 688 ms. EXEC: update tabTerminalReceipt set trcProgressive = 17344, trcLastPrinted = '2400417344', trcLastDate = '2024-12-07 13:16:32' where trcStatus='V' and trcTerId = 4 07/12/2024 13:20:16.2646 748 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 13:24:23.2566 544 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 13:27:22.4554 593 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 15 order by traDateTime desc,traId desc 07/12/2024 13:27:23.4581 747 ms. EXEC: update tabTerminalReceipt set trcProgressive = 52570, trcLastPrinted = '2400752570', trcLastDate = '2024-12-07 13:27:22' where trcStatus='V' and trcTerId = 18 07/12/2024 13:37:43.4404 734 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 13:39:13.8048 691 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 13:49:06.3919 1047 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 13:49:07.5726 671 ms. EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-12-07 13:49:06',0,'V',5627681913923540,5622507784771120,2024,'2024-12-07 13:49:06',3,1,0,4,'2024-12-07 14:04:06','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 07/12/2024 13:52:19.2648 546 ms. EXEC: update paycash set casCreation = '2024-12-07 13:52:18',casModify = '2024-12-07 13:52:18',casUseId=0,casStatus='V' where casId = 198741 07/12/2024 13:55:13.1039 579 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 13:57:36.6819 668 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-12-07 13:57:35',0,'V',4824373348979080,5354304116793960,2024,'2024-12-07 13:57:35',18,1,0,4,'2024-12-07 14:12:35','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/12/2024 13:58:12.0615 1155 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 13:58:13.4485 615 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-12-07 13:58:12',0,'V',5324884958446950,5666103494669660,2024,'2024-12-07 13:58:12',18,1,0,4,'2024-12-07 14:13:12','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/12/2024 14:02:41.8639 537 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-07 14:02:41' where payTraUID = 4756280424668640 and payStatus='V' and payEnabled=1 07/12/2024 14:05:55.2581 781 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/12/2024 14:18:13.0162 958 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 14:19:44.2742 1058 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 14:22:16.9512 520 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/12/2024 14:22:23.3234 630 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 14:22:38.9579 579 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-07 14:22:38' where payTraUID = 5495192917962950 and payStatus='V' and payEnabled=1 07/12/2024 14:28:48.8021 641 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/12/2024 14:30:07.5507 513 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-12-07 14:30:06',0,'V',5699670486293460,5477535485835550,2024,'2024-12-07 14:30:06',18,1,0,4,'2024-12-07 14:45:06','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 07/12/2024 14:31:53.2964 685 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 14:32:16.2207 777 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-07 14:32:15',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 07/12/2024 14:32:18.2460 1256 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 14:32:22.8561 1194 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 07/12/2024 14:41:14.2813 759 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-12-07 14:41:12',0,'V',5426863066848320,5098848242177670,2024,'2024-12-07 14:41:12',3,1,0,4,'2024-12-07 14:56:12','C','KES',50,100,0,'',' ',' ',2,50,0,0,'',0,0) 07/12/2024 14:41:22.3477 669 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 14:45:43.7190 757 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 14:45:53.5555 609 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-12-07 14:45:52','V',5506482625420130,2024,'2024-12-07 14:45:52','456314967300327005012999',2,2,2,'O','',0,'2024-12-07 14:45:52',1,'','',0) 07/12/2024 14:46:00.3941 1079 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 14:46:00.4922 623 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/12/2024 15:02:48.5290 513 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 15:05:07.6660 610 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 15:07:18.7566 802 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 15:12:22.1813 615 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 15:12:28.7017 855 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/12/2024 15:23:05.3262 628 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 07/12/2024 15:23:05.3922 703 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/12/2024 15:23:07.0063 988 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 15:26:21.0230 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 15:27:40.8643 674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 15:29:12.0523 721 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 15:34:35.6395 692 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 15:35:36.9245 584 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 15:36:03.1440 1166 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 15:39:29.3878 678 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-12-07 15:39:28','V',5094112587442040,2024,'2024-12-07 15:39:27','456315452500327001012999',2,2,2,'O','',0,'2024-12-07 15:39:28',1,'','',0) 07/12/2024 15:39:33.4836 659 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 15:40:23.2358 577 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 15:42:46.2094 1455 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-07 15:42:44' where traUID = 5251976424953650 and traStatus='V' and traEnabled=1 07/12/2024 15:42:49.8338 581 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 15:44:41.2162 619 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 15:52:58.2495 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 15:53:56.0061 614 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/12/2024 15:59:08.7631 696 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 16:01:18.3007 705 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-07 16:01:17' where payTraUID = 4739346652499030 and payStatus='V' and payEnabled=1 07/12/2024 16:06:48.0261 522 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 16:08:06.6426 519 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 07/12/2024 16:08:06.7547 655 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 07/12/2024 16:18:09.0912 785 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 16:18:13.0779 516 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 16:18:25.4832 535 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/12/2024 16:18:26.0085 1004 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 16:19:01.8095 974 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-07 16:19:00',3,42101,0,50,-1,-50,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-07 16:19:00',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'; 07/12/2024 16:19:59.6488 1185 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 16:20:20.0524 553 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 16:45:24.6881 573 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-07 16:45:24',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'; 07/12/2024 16:52:29.9073 788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 16:55:00.9585 1232 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-07 16:54:59',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 07/12/2024 16:55:01.6590 558 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-07 16:55:00',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'; 07/12/2024 16:56:31.8092 564 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 16:57:02.2656 14491 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 = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 07/12/2024 16:58:00.1282 534 ms. OPEN: show columns from tabArea where Field = 'areType' 07/12/2024 16:58:00.1322 596 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 07/12/2024 16:58:00.5065 904 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 17:01:12.4988 33501 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 17:01:18.2486 16030 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 07/12/2024 17:01:24.1365 5467 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/12/2024 17:02:03.0265 1807 ms. OPEN: select * from opeShifts where sftId = 836 and sftStatus = 'V' 07/12/2024 17:02:33.8041 4695 ms. EXEC: insert into tmppay (tmpDateTime,tmpCode,tmpTarId,tmpAmount,tmpTimeLimit,tmpPrePaid,tmpTerId,tmpVatType,tmpVatRate,tmpVatTaxable,tmpVatAmount,tmpVatTotal,tmpVatRound) VALUES ('2024-12-07 17:02:29','456316056000327005012999',4,0,15,0,2,0,0,0,0,0,0) 07/12/2024 17:05:48.9053 3698 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/12/2024 17:07:12.2339 4690 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-07 17:07:07',0,16,'2024-12-07 17:07:07','','Unauthorized Transit Entry 2') 07/12/2024 17:07:17.0041 1212 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 17:09:40.5769 4550 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 07/12/2024 17:09:50.1894 4666 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/12/2024 17:09:54.9305 4726 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/12/2024 17:10:18.5793 4592 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/12/2024 17:10:18.8375 4702 ms. OPEN: select * from tabCustomer inner join abbSubscriptions on subCusId = cusId left join tabAbbGroups on cusAbgId = abgId where subId = 26 and cusStatus='V' 07/12/2024 17:10:23.3335 4264 ms. OPEN: select parVatRate,parVatName,parVatMethod,parVatRound,parVatDiscount from tabParameters where parStatus='V' order by parId desc limit 1 07/12/2024 17:10:38.3715 2050 ms. EXEC: update abbCards set carLastDate = '2024-12-07 17:10:36',carLastDirection='O' where carStatus='V' and carId = 25 07/12/2024 17:11:46.4620 4254 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = @extTerId nr: 1 07/12/2024 17:11:55.9403 4283 ms. OPEN: select parVatRate,parVatName,parVatMethod,parVatRound,parVatDiscount from tabParameters where parStatus='V' order by parId desc limit 1 07/12/2024 17:12:05.4356 8366 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/12/2024 17:12:34.7492 4851 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/12/2024 17:13:00.3703 1504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 07/12/2024 17:14:51.8768 2130 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/12/2024 17:15:24.3434 1632 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 07/12/2024 17:17:31.3122 4644 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 07/12/2024 17:18:28.0921 4630 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-12-07 17:18:23','V',4787886058199410,2024,'2024-12-07 17:18:04','456316228400327005031999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 59 ms.) 07/12/2024 17:18:54.3526 10578 ms. EXEC: DELETE FROM tmppay WHERE tmpDatetime<@tmpDateTime 07/12/2024 17:19:22.8266 9426 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 07/12/2024 17:19:43.0141 10592 ms. OPEN: SELECT * FROM tabuser WHERE useBadId<>'' AND (useBadId = '456315833700327005012999' OR useBadId = '456315833700327005012999') 07/12/2024 17:19:49.0942 6075 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 07/12/2024 17:20:27.0115 19005 ms. OPEN: SELECT * FROM tabterminal LEFT JOIN movtransit ON movtransit.traIdTerminal = tabterminal.terId LEFT JOIN tabtariff ON tabtariff.tarId = movtransit.traTarId LEFT JOIN tabterminalinout ON tabterminalinout.tioin = tabterminal.terId WHERE tabterminal.terStatus ='V' AND tabterminalinout.tioOut = 2 AND movtransit.traStatus ='V' AND tabterminal.terDirection = 'I' AND movtransit.traCode = '456315833700327005012999' 07/12/2024 17:20:36.4718 9472 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-07 17:20:26',0,16,'2024-12-07 17:20:26','','Unauthorized Transit Entry 2') 07/12/2024 17:20:45.9631 9392 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 1 07/12/2024 17:21:23.9785 56907 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/12/2024 17:21:33.4508 9388 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/12/2024 17:21:53.6173 701 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 07/12/2024 17:21:53.6393 732 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/12/2024 17:21:53.6513 701 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 = '456315870800327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 (WAIT TIME 36 ms.) 07/12/2024 17:27:28.0471 5484 ms. OPEN: show columns from tabParameters where Field = 'parForce24Hours' 07/12/2024 17:27:28.0621 5532 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 23 ms.) 07/12/2024 17:27:28.0631 5556 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/12/2024 17:27:28.0651 5561 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/12/2024 17:27:28.0661 5563 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 07/12/2024 17:27:28.0671 5552 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/12/2024 17:27:28.0671 5546 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/12/2024 17:27:28.0681 5538 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 07/12/2024 17:27:28.0681 5562 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 07/12/2024 17:27:28.0691 5553 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/12/2024 17:27:28.0691 5522 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 07/12/2024 17:27:28.0691 5546 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 07/12/2024 17:27:28.0701 5545 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/12/2024 17:27:28.0751 5551 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/12/2024 17:27:28.0771 5545 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 07/12/2024 17:27:28.0771 5497 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 37 ms.) 07/12/2024 17:27:28.0781 5555 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 29 ms.) 07/12/2024 17:27:28.0781 5548 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 28 ms.) 07/12/2024 17:27:28.0781 5546 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 26 ms.) 07/12/2024 17:27:28.0791 5552 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 26 ms.) 07/12/2024 17:27:28.0791 5540 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 38 ms.) 07/12/2024 17:27:28.0821 5554 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 07/12/2024 17:27:28.2743 2269 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 07/12/2024 17:27:29.1679 529 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0 07/12/2024 17:27:29.1769 531 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0 (WAIT TIME 5 ms.) 07/12/2024 17:27:29.4220 778 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitPlates' nr: 1 07/12/2024 17:27:30.3376 523 ms. OPEN: show columns from abbCards where Field = 'carUHFCode' 07/12/2024 17:27:30.8710 578 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 07/12/2024 17:27:31.0531 714 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 07/12/2024 17:27:45.5564 5815 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '795358' and traDirection='I' order by traId DESC LIMIT 1 07/12/2024 17:27:45.5584 11887 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '456316260600327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 07/12/2024 17:27:47.0904 16216 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 07/12/2024 17:27:47.1604 915 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 07/12/2024 17:27:47.6517 560 ms. EXEC: update payCurInventory set curType='C' where curType<>'C' and curValue = 5 and curDevCode in (41003,41002,41001,41101,41102,41103); 07/12/2024 17:27:50.3756 2075 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-12-07 17.27.48','V',5259054514530330,2024,'2024-12-07 17.23.26','456316260600327005031999',1,2,16,'I','',1,0,1,'','',4) 07/12/2024 17:27:50.6718 1607 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 = '456316085000327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 07/12/2024 17:27:51.8525 1466 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 07/12/2024 17:27:55.2710 4598 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 = '456316085000327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 07/12/2024 17:27:55.2870 7633 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 07/12/2024 17:27:59.7629 4475 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/12/2024 17:28:00.4434 592 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 07/12/2024 17:28:40.1345 11179 ms. OPEN: select 1 as Tot,payUID,payPayed,payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 07/12/2024 17:28:40.1355 42937 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 = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 07/12/2024 18:09:13.4314 1303 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 07/12/2024 18:47:18.5722 2122 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 07/12/2024 19:10:31.9165 504 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-12-07 19.10.30',0,'V',5411874654820190,5422684913007970,2024,'2024-12-07 19.10.30',3,1,0,4,'2024-12-07 19.25.30','C','KES',100,200,100,'',' ',' ',1,100,0,0,'',0,0) 07/12/2024 19:12:35.2238 2519 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 07/12/2024 20:41:53.7369 709 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