13/08/2024 10:25:43.6213 19915 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 13/08/2024 10:25:44.7261 502 ms. OPEN: show columns from movLinks where Field = 'mliReceiptMessage' 13/08/2024 10:25:45.7798 511 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'tabTerminalExtraMem' nr: 1 13/08/2024 10:25:46.1600 708 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 13/08/2024 10:25:46.1630 794 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId (WAIT TIME 22 ms.) 13/08/2024 10:25:46.2371 708 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' (WAIT TIME 79 ms.) 13/08/2024 10:25:46.8635 669 ms. OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES' 13/08/2024 10:25:47.9252 579 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-08-13 09:25:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-08-13 10:25:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-08-13 10:25:46' and (resAreId = 1 or resAreId <= 0) nr: 0 13/08/2024 10:25:47.9262 578 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-08-13 09:25:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-08-13 10:25:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-08-13 10:25:46' and (resAreId = 1 or resAreId <= 0) nr: 0 13/08/2024 10:25:47.9272 578 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-08-13 09:25:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-08-13 10:25:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-08-13 10:25:46' and (resAreId = 1 or resAreId <= 0) nr: 0 13/08/2024 10:25:47.9402 574 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-08-13 09:25:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-08-13 10:25:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-08-13 10:25:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 8 ms.) 13/08/2024 10:25:47.9442 580 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-08-13 09:25:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-08-13 10:25:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-08-13 10:25:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 16 ms.) 13/08/2024 10:25:47.9622 574 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-08-13 09:25:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-08-13 10:25:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-08-13 10:25:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 34 ms.) 13/08/2024 10:25:47.9672 570 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-08-13 09:25:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-08-13 10:25:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-08-13 10:25:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 38 ms.) 13/08/2024 10:25:47.9692 581 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-08-13 09:25:47') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-08-13 10:25:46' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-08-13 10:25:46' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 36 ms.) 13/08/2024 10:25:58.8519 11990 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0347899511510' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 13/08/2024 10:25:58.8769 9794 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '455153712700327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 13/08/2024 10:26:02.2982 2029 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-08-13 10:26:00','V',4695552012117880,2024,'2024-08-13 10:20:17','0347899511510',2,1,2,'O','',1,0,1,'','',0) 13/08/2024 10:26:02.3042 807 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-08-13 10:26:01','V',5148276821482020,2024,'2024-08-13 10:18:47','455153712700327005031999',1,2,16,'I','',1,0,1,'','',4) 13/08/2024 10:26:02.5034 15636 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 13/08/2024 10:26:04.1395 1827 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/08/2024 10:26:04.1405 1830 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/08/2024 10:26:05.9657 713 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 13/08/2024 10:26:09.3449 6477 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/08/2024 10:26:16.2265 6881 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); 13/08/2024 10:26:17.4964 674 ms. EXECSCALAR: select count(*) from tabTables where tabId = 30 and tabTxtValue='22' and tabTable = 'devAction' nr: 0 13/08/2024 10:27:00.2826 622 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 = '455153616500327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 13/08/2024 10:27:06.9831 3362 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 13/08/2024 10:27:08.3560 654 ms. OPEN: select * from payreceipt where recPayUID = 5662542291672990 and recStatus='V' 13/08/2024 10:32:25.6323 1355 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 13/08/2024 10:33:12.8076 973 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 13/08/2024 10:55:40.4742 1051 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 13/08/2024 11:24:13.5492 804 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 13/08/2024 11:26:09.9146 6401 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 13/08/2024 11:32:34.4202 615 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-13 11:32:33',0,0,'V',5594649551976600,5234906577909370,2024,'2024-08-13 11:32:33',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-08-13 11:32:33',0,0,'V',5594649551976600,5234906577909370,2024,'2024-08-13 11:32:33',3,'KES',-1,100,-100,'N',''); 13/08/2024 11:34:53.8782 2247 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 13/08/2024 16:59:37.3185 524 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-08-13 16:59:36','V',5687526868233970,2024,'2024-08-13 16:59:36','455156117600327005012999',1,2,16,'I','',1,0,1,'','',4)