16/09/2024 11:51:22.4041   874 ms.           OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2024-09-07 11:56:37' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal
16/09/2024 13:06:04.5081   582 ms.           EXEC: update payInventory set invCreation = '2024-09-16 13:06:03',invModify = '2024-09-16 13:06:03',invUseId=0,invStatus='V' where invId = 207663
16/09/2024 13:06:04.6732   625 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-16 13:06:04','V',5116225118180820,2024,'2024-09-16 13:06:03','455494716300327005012999',1,2,16,'I','',1,0,1,'','',4)
16/09/2024 13:08:47.7707   711 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-09-16 13:08:47' where payTraUID = 5269231263289540 and payStatus='V' and payEnabled=1
16/09/2024 15:13:37.0373   549 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-09-16 15:13:36',0,'V',4725628766992970,4768705560737410,2024,'2024-09-16 15:13:36',18,1,0,4,'2024-09-16 15:28:36','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
16/09/2024 15:16:46.0944  1508 ms.           EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 348594 else acvFstPayId end),acvLstPayId = 348594 where acvSftId = 781 and acvCodeId = 3
16/09/2024 15:50:44.2346   528 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-09-16 15:50:43',0,'V',5137930273556680,5192551981332960,2024,'2024-09-16 15:50:43',18,1,0,4,'2024-09-16 16:05:43','C','KES',50,50,0,'','','',1,50,0,0,'',0,0)
16/09/2024 22:50:12.1982 14855 ms.     EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1
16/09/2024 22:50:12.2233 14831 ms.           OPEN: show columns from tabParameters where Field = 'parUseCulture' (WAIT TIME 24 ms.)
16/09/2024 22:50:14.1545   569 ms.     EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 1 nr: 0
16/09/2024 22:50:14.1555   566 ms.     EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0
16/09/2024 22:50:14.1555   565 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V'
16/09/2024 22:50:14.1656   575 ms.     EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0
16/09/2024 22:50:14.1676   575 ms.     EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 0
16/09/2024 22:50:14.1686   576 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V'
16/09/2024 22:50:14.1716   579 ms.     EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 0
16/09/2024 22:50:14.1746   580 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V'
16/09/2024 22:50:14.1756   581 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V'
16/09/2024 22:50:14.1816   585 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V'
16/09/2024 22:50:14.1866   580 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' (WAIT TIME 11 ms.)
16/09/2024 22:50:14.1876   581 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' (WAIT TIME 10 ms.)
16/09/2024 22:50:14.1916   546 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' (WAIT TIME 2 ms.)
16/09/2024 22:50:14.1976   582 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 20 ms.)
16/09/2024 22:50:14.3046   752 ms.           OPEN: select * from tabCurrency where curStatus='V' and curCode = 'KES'
16/09/2024 22:50:14.8560   654 ms.           OPEN: show columns from tabTerminalExtraMem where Field = 'extcode'
16/09/2024 22:50:16.3890   697 ms.           OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal
16/09/2024 22:50:16.4131   813 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4151   817 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4191   816 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4191   813 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4201   816 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4211   821 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4221   820 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4231   819 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4231   822 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4241   819 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4261   826 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0
16/09/2024 22:50:16.4371   833 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-16 21:50:15') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-09-16 22:50:14' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-09-16 22:50:14' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 6 ms.)
16/09/2024 22:50:30.7232 14859 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788346374' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
16/09/2024 22:50:32.6645   986 ms.           OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketnotfound' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en')
16/09/2024 22:50:33.3670   684 ms.           OPEN: select max(traCode) as vCode from movTransit where traCode >='45549                   ' and traCode < '45550                   ' and traType = 2
16/09/2024 22:50:34.4737 20164 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0
16/09/2024 22:50:35.9677  2588 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-16 22:50:33','V',5452543472116460,2024,'2024-09-16 22:47:51','455498111900327002029999',2,1,2,'O','',1,0,1,'','0532370831878',157,0)
16/09/2024 22:50:36.0628   876 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-16 22:50:35','V',5402177155898390,2024,'2024-09-16 22:47:51','455498111900327002029999',2,1,2,'O','',1,0,1,'','0532370831878',157,0)
16/09/2024 22:50:37.9300  1951 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
16/09/2024 22:50:40.9460  6040 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
16/09/2024 22:50:46.8090  5861 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);
16/09/2024 22:50:47.4094   933 ms.           OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0
16/09/2024 22:50:47.5605  1162 ms.           OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 44
16/09/2024 22:50:47.6775   789 ms.           EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001);
16/09/2024 22:50:49.1165  1655 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 = '455498072900327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P'))
16/09/2024 22:50:54.6814  7115 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
16/09/2024 22:50:55.9834  1029 ms.           OPEN: select * from payreceipt where recPayUID = 5747646771883380 and recStatus='V'