20/10/2024 12:21:39.6702 16631 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 20/10/2024 12:21:39.7963 19592 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 20/10/2024 12:21:41.5609 797 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 16 AND extPlateWaitOperator=0 20/10/2024 12:21:41.5609 789 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 1, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '' where extStatus='V' and extTerId = 16 20/10/2024 12:21:43.1209 522 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-20 11:21:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-20 12:21:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-20 12:21:40' and (resAreId = 1 or resAreId <= 0) nr: 0 20/10/2024 12:21:43.1209 503 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-20 11:21:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-20 12:21:41' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-20 12:21:41' and (resAreId = 1 or resAreId <= 0) nr: 0 20/10/2024 12:21:43.1229 504 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-20 11:21:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-20 12:21:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-20 12:21:40' and (resAreId = 1 or resAreId <= 0) nr: 0 20/10/2024 12:21:43.1229 523 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-20 11:21:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-20 12:21:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-20 12:21:40' and (resAreId = 1 or resAreId <= 0) nr: 0 20/10/2024 12:21:43.1239 505 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-20 11:21:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-20 12:21:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-20 12:21:40' and (resAreId = 1 or resAreId <= 0) nr: 0 20/10/2024 12:21:43.1239 524 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-20 11:21:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-20 12:21:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-20 12:21:40' and (resAreId = 1 or resAreId <= 0) nr: 0 20/10/2024 12:21:43.1259 527 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-20 11:21:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-20 12:21:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-20 12:21:40' and (resAreId = 1 or resAreId <= 0) nr: 0 20/10/2024 12:21:43.1289 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-10-20 11:21:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-20 12:21:40' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-20 12:21:40' and (resAreId = 1 or resAreId <= 0) nr: 0 20/10/2024 12:21:43.1359 536 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-20 11:21:42') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-20 12:21:41' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-20 12:21:41' and (resAreId = 1 or resAreId <= 0) nr: 0 20/10/2024 12:21:43.5462 508 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 20/10/2024 12:21:44.2629 1012 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_unauthorized' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 20/10/2024 12:21:51.6511 7386 ms. OPEN: show columns from movoperator where Field = 'opeQuery' 20/10/2024 12:22:00.5611 20357 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '757782' and traDirection='I' order by traId DESC LIMIT 1 20/10/2024 12:22:00.5611 14756 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '757773' and traDirection='I' order by traId DESC LIMIT 1 20/10/2024 12:22:00.5631 8908 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '455834435100327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 20/10/2024 12:22:01.3876 991 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 20/10/2024 12:22:02.2842 565 ms. OPEN: show columns from movRoutes where Field = 'rtsCarId' 20/10/2024 12:22:03.1148 630 ms. EXECSCALAR: select count(rulId) from tabTicketRules where rulStatus='V' and rulTerId = 18 and rulDevId = 17 and rulTicId = 1 nr: 0 20/10/2024 12:22:03.6081 899 ms. OPEN: show columns from tabTariff where Field = 'tarTimeControlTimeBegin' 20/10/2024 12:22:04.7449 1119 ms. OPEN: select * from tabTariff left join tabtlkTariff on tlkTarId = tarId where (tarValidFrom <= '2024-10-20' and tarValidTo >= '2024-10-20' and tarStatus='V' AND tarEnabled <> 0) AND (tarIdClass = 2 OR tarIdClass <=0) AND ((tlkAreId = 1 AND tlkStatus='V') OR (tarDefault<>0) OR (tlkAreId IS NULL AND tarIdType IN (SELECT ticId FROM tabTicketType WHERE ticStatus='V' AND ticType = 2))) ORDER BY tarModify DESC,tarId DESC 20/10/2024 12:22:10.2476 5167 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-10-20 12:22:05','V',5464939962362290,2024,'2024-10-20 12:19:11','455834435100327005031999',1,2,16,'I','',1,0,1,'','',4) 20/10/2024 12:22:10.2506 5166 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-10-20 12:22:05','V',5407237115951530,2024,'2024-10-20 12:19:11','455834435100327005031999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 2 ms.) 20/10/2024 12:22:13.1728 2911 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/10/2024 12:22:13.1738 2912 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 20/10/2024 12:22:14.0214 12756 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 4 and payDateTime = '2024-10-20 12:18:38' nr: 0 20/10/2024 12:22:14.7068 3874 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 = '455834344000327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 20/10/2024 12:22:14.8419 4010 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 = '455834288600327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 20/10/2024 12:22:15.1271 1104 ms. EXECSCALAR: SELECT COUNT(*) FROM payPayment INNER JOIN movTransit ON traUID = payTrauid WHERE payStatus='V' AND payPayed=0 AND payAmount=0 AND payDiscount = 100 AND payDiscountType = 1 AND traStatus='V' AND traEnabled = 1 AND traCode = '455834328200327005012999' nr: 0 20/10/2024 12:22:16.4823 33699 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 (WAIT TIME 88 ms.) 20/10/2024 12:22:16.6384 562 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-10-20 12:22:16',4,6,'2024-10-20 12:22:16','455834328200327005012999','Payed (Cash ) Ticket ') 20/10/2024 12:22:17.7311 1241 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 = '455834344000327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 20/10/2024 12:22:17.7311 1242 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 = '455834288600327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 20/10/2024 12:22:20.5814 3712 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 20/10/2024 12:22:23.7976 2688 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5020252733806320,4632027693322250,2024,'2024-10-20 12:22:21',' Date: 10/20/2024 12:18:38 PM Code: 455834328200327005012999 Entry Date: 10/20/2024 12:01:22 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 0.00 KES ______________________________ Paid: 0.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: Manual Cashier 1 ',1) 20/10/2024 12:22:26.6335 6051 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); 20/10/2024 12:23:45.4964 538 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-10-20 12:23:44','V',4875904283182730,2024,'2024-10-20 12:23:42','455834344000327005012999',2,2,2,'O','',0,'2024-10-20 12:23:44',1,'','',0) 20/10/2024 12:49:13.8320 668 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 135 order by traDateTime desc,traId desc 20/10/2024 12:52:45.7788 2455 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 20/10/2024 13:14:48.5585 11310 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 20/10/2024 16:01:05.2433 1128 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 20/10/2024 16:08:50.6544 1096 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