11/09/2024 10:45:15.3973 13440 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 11/09/2024 10:45:15.4504 16386 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 11/09/2024 10:45:16.9114 536 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 11/09/2024 10:45:16.9124 533 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/09/2024 10:45:16.9224 542 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/09/2024 10:45:16.9294 543 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/09/2024 10:45:16.9304 551 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/09/2024 10:45:16.9314 548 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/09/2024 10:45:16.9314 551 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/09/2024 10:45:16.9314 548 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/09/2024 10:45:16.9324 553 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/09/2024 10:45:16.9324 553 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/09/2024 10:45:17.0314 653 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/09/2024 10:45:17.0334 649 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/09/2024 10:45:17.0334 655 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/09/2024 10:45:17.0344 646 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/09/2024 10:45:17.0344 651 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 11/09/2024 10:45:17.0354 652 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 11/09/2024 10:45:17.0364 657 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/09/2024 10:45:17.0374 656 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 1 ms.) 11/09/2024 10:45:17.0374 650 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 11/09/2024 10:45:17.1255 737 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 11/09/2024 10:45:17.1535 750 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 18 ms.) 11/09/2024 10:45:17.1595 743 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 29 ms.) 11/09/2024 10:45:17.1615 745 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 30 ms.) 11/09/2024 10:45:17.1625 748 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) (WAIT TIME 30 ms.) 11/09/2024 10:45:17.4837 554 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 11/09/2024 10:45:19.5721 631 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 11/09/2024 10:45:19.6652 861 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:17' and (resAreId = 1 or resAreId <= 0) nr: 0 11/09/2024 10:45:19.6662 873 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:17' and (resAreId = 1 or resAreId <= 0) nr: 0 11/09/2024 10:45:19.6672 865 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:17' and (resAreId = 1 or resAreId <= 0) nr: 0 11/09/2024 10:45:19.6672 877 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:17' and (resAreId = 1 or resAreId <= 0) nr: 0 11/09/2024 10:45:19.6792 878 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:18' and (resAreId = 1 or resAreId <= 0) nr: 0 11/09/2024 10:45:19.6802 875 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:17' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 11 ms.) 11/09/2024 10:45:19.6822 879 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 14 ms.) 11/09/2024 10:45:19.6862 868 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:17' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 19 ms.) 11/09/2024 10:45:19.6882 874 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:17' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 19 ms.) 11/09/2024 10:45:19.6892 874 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:17' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:17' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 19 ms.) 11/09/2024 10:45:19.6952 871 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-09-11 09:45:18') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-11 10:45:18' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-11 10:45:18' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 24 ms.) 11/09/2024 10:45:34.6194 2387 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '727310' and traDirection='I' order by traId DESC LIMIT 1 11/09/2024 10:45:34.6204 14080 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '455443842900327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 11/09/2024 10:45:34.7265 15843 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191889' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 11/09/2024 10:45:35.8733 655 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId 11/09/2024 10:45:36.6798 512 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370677393' and traDirection='I' order by traId desc limit 1 11/09/2024 10:45:36.9110 741 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 11/09/2024 10:45:38.4280 990 ms. OPEN: show columns from tabTariff where Field = 'tarTimeControlTimeBegin' 11/09/2024 10:45:40.0340 22547 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 11/09/2024 10:45:40.4914 1880 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-09-11 10:45:38','V',5416505267986180,2024,'2024-09-11 10:41:44','455443701100327002029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 11/09/2024 10:45:40.5324 1783 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-09-11 10:45:38','V',4989286589499870,2024,'2024-09-11 10:40:29','455443842900327005031999',1,2,16,'I','',1,0,1,'','',4) 11/09/2024 10:45:40.5334 3109 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-09-11 10:45:37','V',5418909764677450,2024,'2024-09-11 10:41:44','455443701100327002029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 11/09/2024 10:45:40.5344 731 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-09-11 10:45:39','V',4965647531724530,2024,'2024-09-11 10:40:29','455443842900327005031999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 1 ms.) 11/09/2024 10:45:41.3389 791 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0347899511510' and traDirection='I' order by traId desc limit 1 11/09/2024 10:45:41.3399 792 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '0347899511510' and traDirection='I' order by traId desc limit 1 11/09/2024 10:45:42.2996 1301 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 11/09/2024 10:45:43.3593 2855 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/09/2024 10:45:43.4994 1936 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/09/2024 10:45:43.5004 2957 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/09/2024 10:45:43.5044 2049 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/09/2024 10:45:43.7725 1449 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 = '455443622800327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 11/09/2024 10:45:48.1835 7872 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 11/09/2024 10:45:50.8953 7121 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 = '455443622800327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 11/09/2024 10:45:52.1752 526 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '455443622800327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 11/09/2024 10:45:56.0759 7891 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); 11/09/2024 10:48:06.8578 12370 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 11/09/2024 10:53:04.4051 1673 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 11 order by traDateTime desc,traId desc 11/09/2024 10:55:38.8115 1425 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 11/09/2024 11:02:36.6761 2633 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 11/09/2024 11:13:23.9597 664 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 3 and payDateTime = '2024-09-11 11:13:22' nr: 0 11/09/2024 11:30:09.1660 1426 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 11/09/2024 11:39:24.8099 889 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 11/09/2024 11:41:50.8409 675 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-09-11 11:41:50',0,0,'V',5683588576954620,4732952567008450,2024,'2024-09-11 11:41:50',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-09-11 11:41:50',0,0,'V',5683588576954620,4732952567008450,2024,'2024-09-11 11:41:50',3,'KES',-2,200,-400,'N',''); 11/09/2024 11:42:10.8418 1556 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 11/09/2024 13:06:55.1026 575 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-09-11 13:06:54' where traUID = 5292807709558420 and traStatus='V' and traEnabled=1 11/09/2024 14:41:31.7921 539 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4919449029857510,4983511327704980,2024,'2024-09-11 14:41:31',' Date: 9/11/2024 2:41:31 PM Code: 455445086100327005012999 Entry Date: 9/11/2024 2:07:41 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400740395 ',0) 11/09/2024 14:53:53.4658 568 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-09-11 14:53:52',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'; 11/09/2024 15:06:21.5932 659 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-09-11 15:06:20','V',4672983122718140,2024,'2024-09-11 15:06:19','455445192700327005012999',2,2,2,'O','',0,'2024-09-11 15:06:20',1,'','0230003941812',181,0) 11/09/2024 17:22:08.0011 603 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 11/09/2024 18:06:28.2152 620 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-11 18:06:27' where payTraUID = 4659714267587750 and payStatus='V' and payEnabled=1 11/09/2024 20:04:15.6732 551 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-09-11 20:04:15',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';