02/11/2024 00:55:17.4723 2106 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 02/11/2024 03:55:53.5387 642 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/11/2024 08:41:24.8579 517 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 02/11/2024 09:50:08.2712 1382 ms. OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 02/11/2024 09:50:08.2933 1373 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 21 ms.) 02/11/2024 09:50:10.7179 542 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-02 08:50:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-02 09:50:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-02 09:50:09' and (resAreId = 1 or resAreId <= 0) nr: 0 02/11/2024 09:50:10.7209 544 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-02 08:50:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-02 09:50:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-02 09:50:09' and (resAreId = 1 or resAreId <= 0) nr: 0 02/11/2024 09:50:10.7269 521 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-02 08:50:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-02 09:50:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-02 09:50:09' and (resAreId = 1 or resAreId <= 0) nr: 0 02/11/2024 09:50:10.7319 547 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-02 08:50:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-02 09:50:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-02 09:50:09' and (resAreId = 1 or resAreId <= 0) nr: 0 02/11/2024 09:50:10.7359 531 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-02 08:50:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-02 09:50:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-02 09:50:09' and (resAreId = 1 or resAreId <= 0) nr: 0 02/11/2024 09:50:10.7439 546 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-02 08:50:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-02 09:50:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-02 09:50:09' and (resAreId = 1 or resAreId <= 0) nr: 0 02/11/2024 09:50:10.7459 552 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-02 08:50:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-02 09:50:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-02 09:50:09' and (resAreId = 1 or resAreId <= 0) nr: 0 02/11/2024 09:50:10.7509 576 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-02 08:50:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-11-02 09:50:09' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-11-02 09:50:09' and (resAreId = 1 or resAreId <= 0) nr: 0 02/11/2024 09:50:15.2340 3686 ms. OPEN: show columns from movoperator where Field = 'opeQuery' 02/11/2024 09:50:15.9705 728 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'movTransitId' nr: 1 02/11/2024 09:50:15.9735 738 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-11-02 09:50:15',0,16,'2024-11-02 09:50:15','','Unauthorized Transit Entry 2') 02/11/2024 09:50:26.1933 10955 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '455963520700327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 02/11/2024 09:50:26.2654 15412 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 02/11/2024 09:50:26.3805 10408 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '767246' and traDirection='I' order by traId DESC LIMIT 1 02/11/2024 09:50:30.2881 576 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 02/11/2024 09:50:30.8484 2115 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-02 09:50:28','V',5204842509486500,2024,'2024-11-02 09:46:47','455963520700327005031999',1,2,16,'I','',1,0,1,'','',4) 02/11/2024 09:50:32.0893 1069 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 02/11/2024 09:50:32.8548 1970 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 02/11/2024 09:50:32.8558 852 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 1 ms.) 02/11/2024 09:50:33.0459 6555 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/11/2024 09:50:37.2867 5081 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 = '455963032300327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 02/11/2024 09:50:38.0702 5023 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); 02/11/2024 09:50:38.7377 570 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 02/11/2024 09:59:34.9861 1041 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 103 order by traDateTime desc,traId desc 02/11/2024 10:15:28.1254 3023 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 02/11/2024 10:16:05.0448 1490 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 02/11/2024 10:28:24.1549 1525 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 02/11/2024 11:02:39.3280 1249 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 20 order by traDateTime desc,traId desc 02/11/2024 11:13:06.9271 670 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 02/11/2024 11:38:41.4961 10267 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 02/11/2024 11:48:17.2081 776 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 02/11/2024 12:20:06.2705 1112 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 02/11/2024 12:38:24.1474 2999 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 = 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 02/11/2024 12:45:35.9753 941 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 02/11/2024 13:01:23.6930 520 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 02/11/2024 13:16:32.5067 604 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-02 13:14:35',12,'V',5726459969912290,5761403236232380,2024,'2024-11-02 13:14:35',17,1,0,4,'2024-11-02 13:29:35','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 02/11/2024 14:01:33.8080 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-02 14:01:33','V',5312732941535290,2024,'2024-11-02 14:01:32','455964688600327005012999',2,2,2,'O','',0,'2024-11-02 14:01:33',1,'','',0) 02/11/2024 14:15:12.1825 508 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-02 14:15:11','V',4844121081855560,2024,'2024-11-02 14:15:11','455965061900327005012999',2,2,2,'O','',0,'2024-11-02 14:15:11',1,'','',0) 02/11/2024 14:30:06.5478 1252 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 02/11/2024 14:38:21.6849 552 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-02 14:38:21','V',5396302437957940,2024,'2024-11-02 14:38:20','455965270000327005012999',1,2,16,'I','',1,0,1,'','',4) 02/11/2024 16:28:12.3691 612 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 366515 else acvFstPayId end),acvLstPayId = 366515 where acvSftId = 814 and acvCodeId = 3 02/11/2024 18:32:17.4676 660 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 02/11/2024 19:01:40.3830 900 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 02/11/2024 23:12:52.3704 562 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-02 23:12:51' where payTraUID = 5409195313478420 and payStatus='V' and payEnabled=1