19/08/2025 20:36:52.9649 1329 ms. OPEN: show columns from tabParameters where Field = 'parVatShowMode' 19/08/2025 20:36:54.0776 711 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 (WAIT TIME 144 ms.) 19/08/2025 20:36:54.9482 568 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 19/08/2025 20:36:55.1844 1110 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 19/08/2025 20:36:55.1854 1111 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 19/08/2025 20:36:55.1864 1113 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 19/08/2025 20:36:55.1874 1114 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 19/08/2025 20:36:55.1984 1121 ms. OPEN: select distinct tagName from tabtag where tagstatus='V' and tagMandatory=1 and tagDevCode in (select devCode from tabDevice where devStatus='V' and devId in (select lnkSubId from tabLnkDevice where lnkStatus='V' and lnkDevId = (select devId from tabDevice inner join tabTerminal on terType = devCode where terId = 3))) order by tagName 19/08/2025 20:36:55.6818 666 ms. OPEN: SELECT * FROM tabCardConversionRules WHERE ccrStatus=@ccrStatus AND (ccrTerId = @ccrTerId OR ccrTerId=0) AND (ccrDevId = @ccrDevId OR ccrDevId=0) AND (ccrSubId = @ccrSubId OR ccrSubId=0) ORDER BY ccrTerId DESC, ccrDevId DESC, ccrSubId DESC, ccrId DESC LIMIT 1 19/08/2025 20:36:56.2692 950 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 19/08/2025 20:36:56.2712 954 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 19/08/2025 20:36:56.2722 955 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 19/08/2025 20:36:56.2722 950 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 19/08/2025 20:36:56.2772 956 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 19/08/2025 20:36:56.2802 548 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 19/08/2025 20:36:56.2802 547 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 19/08/2025 20:36:56.2812 961 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 19/08/2025 20:36:56.2812 547 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' 19/08/2025 20:36:56.2892 957 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 16 ms.) 19/08/2025 20:36:56.2912 951 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 20 ms.) 19/08/2025 20:36:56.2942 543 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' (WAIT TIME 19 ms.) 19/08/2025 20:36:56.2962 960 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 21 ms.) 19/08/2025 20:36:56.3002 959 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 25 ms.) 19/08/2025 20:36:56.3032 956 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2025-08-19 19.36.55') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2025-08-19 20.36.54' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2025-08-19 20.36.54' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 29 ms.) 19/08/2025 20:36:56.3142 546 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' (WAIT TIME 40 ms.) 19/08/2025 20:36:56.3152 544 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' (WAIT TIME 29 ms.) 19/08/2025 20:37:06.2067 11256 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 19/08/2025 20:37:11.1680 4959 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/08/2025 20:37:12.4310 7107 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '1004388' and traDirection='I' order by traId DESC LIMIT 1 19/08/2025 20:37:13.4199 2251 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 19/08/2025 20:37:14.2245 717 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 19/08/2025 20:37:16.6859 2448 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 = '458867283400327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 19/08/2025 20:37:18.5771 800 ms. OPEN: select * from payreceipt where recPayUID = 5439047736446270 and recStatus='V' 19/08/2025 20:37:19.5671 685 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,'2025-08-19 20.37.18','V',5209053486211980,2025,'2025-08-19 20.37.17','458867212400327001012999',2,2,2,'O','',0,'2025-08-19 20.37.18',1,'','',0) 19/08/2025 20:38:12.3255 25768 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 19/08/2025 20:38:13.1390 746 ms. OPEN: select * from payFiscalReport where fsrStatus='V' and fsrType = 2 and fsrUseId = 1 order by fsrDateTime desc 19/08/2025 20:46:21.6407 2699 ms. OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 19/08/2025 20:46:21.6497 28531 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 56 ms.) 19/08/2025 20:46:21.6547 28532 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 60 ms.) 19/08/2025 20:46:21.6557 2478 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 59 ms.) 19/08/2025 20:46:21.6587 2237 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 61 ms.) 19/08/2025 20:46:21.6607 1641 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 63 ms.) 19/08/2025 20:46:21.7087 28530 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 19/08/2025 20:46:21.7407 28544 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 134 ms.) 19/08/2025 20:46:21.7468 28530 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 19/08/2025 20:46:21.7548 2345 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 19/08/2025 20:46:33.8202 939 ms. OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode 19/08/2025 20:46:35.1771 13307 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 19/08/2025 20:46:36.6614 13137 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0317833183668' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 19/08/2025 20:46:39.3382 2017 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,'2025-08-19 20.46.37','V',4741858613398920,2025,'2025-08-19 20.42.08','458867256300327002029999',2,1,2,'O','',1,0,1,'','1721271228852',216,0) 19/08/2025 20:46:40.4960 5008 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 19/08/2025 20:46:42.8896 2391 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); 19/08/2025 20:48:25.3216 21625 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 19/08/2025 21:00:33.1692 4077 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 19/08/2025 21:48:41.2100 1797 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 19/08/2025 23:23:40.4074 777 ms. EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 4 and payDateTime = '2014-01-01 02.29.54' nr: 0