24/08/2024 08:01:01.7593 532 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-24 08:00:56',5,3,42101,0,50,10,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+10,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-24 08:00:56',5,3,42101,0,100,5,500,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+5,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 24/08/2024 08:15:42.6232 558 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-24 08:15:42','V',4894009635336320,2024,'2024-08-24 08:15:41','455262774500327005012999',2,2,2,'O','',0,'2024-08-24 08:15:42',1,'','',0) 24/08/2024 11:45:02.9419 3664 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>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal 24/08/2024 11:46:43.6105 1224 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 24/08/2024 12:26:44.6756 506 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 12:30:49.3476 541 ms. EXEC: update payInventory set invCreation = '2024-08-24 12:30:48',invModify = '2024-08-24 12:30:48',invUseId=0,invStatus='V' where invId = 203174 24/08/2024 12:47:33.9693 503 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-08-24 12:46:44',6,'V',5405955201028270,4770000199307390,2024,'2024-08-24 12:46:44',17,1,0,4,'2024-08-24 13:01:44','C','KES',50,50,0,'','','',1,50,0,0,'',0,0) 24/08/2024 12:49:43.5995 3097 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-24 12:49:40','V',5328764059097310,2024,'2024-08-24 12:49:00','455264378300327005012999',2,2,2,'O','',0,'2024-08-24 12:49:40',1,'','',0) (WAIT TIME 363 ms.) 24/08/2024 12:49:45.7800 555 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/08/2024 12:49:45.7810 613 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '455264300300327005012999') and traDirection='I' order by traId desc limit 1 (WAIT TIME 93 ms.) 24/08/2024 12:49:49.8203 5275 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 (WAIT TIME 939 ms.) 24/08/2024 12:52:05.6883 13562 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 12:51:02' where payTraUID = 4770000199307390 and payStatus='V' and payEnabled=1 (WAIT TIME 50105 ms.) 24/08/2024 12:53:36.2409 11070 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-24 12:51:02' where traUID = 4770000199307390 and traStatus='V' and traEnabled=1 (WAIT TIME 16 ms.) 24/08/2024 12:53:45.4672 7576 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-08-24 12:49:03',0,'V',4621652953217700,5048025375924210,2024,'2024-08-24 12:49:03',3,1,0,4,'2024-08-24 13:04:03','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) (WAIT TIME 9242 ms.) 24/08/2024 12:53:59.5238 9090 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5048025375924210,4621652953217700,2024,'2024-08-24 12:53:50','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/24/2024 11:56:43 AM Date : 8/24/2024 12:49:03 PM Code : 455264300300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 24/08/2024 12:54:15.9237 8085 ms. EXEC: update payReceipt set recCreation = '2024-08-24 12:54:07',recModify = '2024-08-24 12:54:07',recUseId=0,recStatus='V' where recId = 295538 24/08/2024 12:54:45.5313 20523 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-24 12:54:18',0,0,'V',5348501742171380,5048025375924210,2024,'2024-08-24 12:54:18',3,'KES',1,50,50,'N',''); (WAIT TIME 6030 ms.) 24/08/2024 12:54:57.3660 6562 ms. EXEC: update paycash set casCreation = '2024-08-24 12:54:49',casModify = '2024-08-24 12:54:49',casUseId=0,casStatus='V' where casId = 180935 24/08/2024 12:55:40.9153 28075 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-08-24 12:55:12','V',5146418922544280,2024,'2024-08-24 12:50:11','455264513000327005029999',2,2,16,'I','',1,0,1,'','0532370834528',10,0) 24/08/2024 12:55:59.5684 13621 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 1 ms.) 24/08/2024 12:56:06.5525 62995 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 12:54:18',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'; (WAIT TIME 3687 ms.) 24/08/2024 12:56:07.5658 8956 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-24 12:55:53','V',4994588727205330,2024,'2024-08-24 12:55:26','455264652600327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 4700 ms.) 24/08/2024 12:56:07.5668 4512 ms. EXEC: update abbCards set carLastDate = '2024-08-24 12:56:02',carLastDirection='I' where carStatus='V' and carId = 10 (WAIT TIME 1026 ms.) 24/08/2024 12:56:19.3241 11734 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 12:56:19.3291 11658 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-08-24 12:56:07','V',5085460179896210,2024,'2024-08-24 12:50:11','455264513100327005029999',2,2,16,'I','',1,0,1,'','0532370834528',10,0) (WAIT TIME 5 ms.) 24/08/2024 12:56:19.3361 11758 ms. EXEC: update payInventory set invCreation = '2024-08-24 12:56:07',invModify = '2024-08-24 12:56:07',invUseId=0,invStatus='V' where invId = 203182 (WAIT TIME 11 ms.) 24/08/2024 12:56:53.5399 34202 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 12:56:53.5409 34174 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 12:56:59.2518 8797 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-08-24 12:56:48','V',4740734664684420,2024,'2024-08-24 12:50:11','455264513200327005029999',2,2,16,'I','',1,0,1,'','0532370834528',10,0) (WAIT TIME 1596 ms.) 24/08/2024 12:57:35.2474 30888 ms. EXEC: update abbCards set carLastDate = '2024-08-24 12:56:53',carLastDirection='I' where carStatus='V' and carId = 10 (WAIT TIME 10819 ms.) 24/08/2024 12:57:35.3555 10974 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-08-24 12:57:24','V',5479154129964510,2024,'2024-08-24 12:50:11','455264513300327005029999',2,2,16,'I','',1,0,1,'','0532370834528',10,0) 24/08/2024 12:57:42.0922 42837 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 12:57:42.0932 6789 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-24 12:57:35','V',5679353282534890,2024,'2024-08-24 12:56:58','455264661800327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 12:57:46.7801 11418 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 12:57:49.0031 6902 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 12:57:49.0031 6909 ms. EXEC: update abbCards set carLastDate = '2024-08-24 12:57:42',carLastDirection='I' where carStatus='V' and carId = 10 24/08/2024 12:57:56.0515 9271 ms. EXEC: update abbCards set carLastDate = '2024-08-24 12:57:46',carLastDirection='I' where carStatus='V' and carId = 10 24/08/2024 12:58:17.0926 28055 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 12:58:24.5036 10138 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-08-24 12:55:10',6,'V',5061393943622560,4992611529738050,2024,'2024-08-24 12:55:10',17,1,0,4,'2024-08-24 13:10:10','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 24/08/2024 12:58:38.1715 13661 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 12:58:24',17,6,'2024-08-24 12:58:24','455263886800327005012999','Pagato (Contanti ) Biglietto ') 24/08/2024 12:58:44.2405 3728 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 339584 else acvFstPayId end),acvLstPayId = 339584 where acvSftId = 775 and acvCodeId = 3 24/08/2024 12:58:56.5978 12347 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5522, trcLastPrinted = '2400605522', trcLastDate = '2024-08-24 12:58:44' where trcStatus='V' and trcTerId = 17 24/08/2024 12:59:00.0286 3427 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4992611529738050,5061393943622560,2024,'2024-08-24 12:58:56',' Data: 8/24/2024 12:55:10 PM Codice: 455263886800327005012999 Ingresso: 8/24/2024 10:47:48 AM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400605522 ',0) 24/08/2024 12:59:05.9996 5969 ms. EXEC: update payReceipt set recCreation = '2024-08-24 12:59:00',recModify = '2024-08-24 12:59:00',recUseId=0,recStatus='V' where recId = 295539 24/08/2024 12:59:09.3239 5499 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-24 12:59:03','V',5684999239188720,2024,'2024-08-24 12:59:00','455263886800327005012999',2,2,2,'O','',0,'2024-08-24 12:59:03',1,'','',0) (WAIT TIME 4 ms.) 24/08/2024 12:59:09.3269 3352 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-08-24 12:59:05','V',5511350648956580,2024,'2024-08-24 12:50:11','455264513400327005029999',2,2,16,'I','',1,0,1,'','0532370834528',10,0) (WAIT TIME 8 ms.) 24/08/2024 12:59:12.4383 3106 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 12:59:14.6167 5283 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/08/2024 12:59:16.2115 3649 ms. EXEC: update abbCards set carLastDate = '2024-08-24 12:59:12',carLastDirection='I' where carStatus='V' and carId = 10 (WAIT TIME 124 ms.) 24/08/2024 12:59:17.0607 1798 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 12:59:14' where payTraUID = 4992611529738050 and payStatus='V' and payEnabled=1 24/08/2024 12:59:17.7295 595 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-08-24 12:59:17','V',4784415878634080,2024,'2024-08-24 12:50:11','455264513500327005029999',2,2,16,'I','',1,0,1,'','0532370834528',10,0) 24/08/2024 12:59:19.7348 2002 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 12:59:20.6544 918 ms. EXEC: update abbCards set carLastDate = '2024-08-24 12:59:19',carLastDirection='I' where carStatus='V' and carId = 10 24/08/2024 12:59:23.2414 2171 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-24 12:59:21','V',5551840297314400,2024,'2024-08-24 12:56:42','455264660200327005031999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 12:59:25.6116 2366 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 12:59:37.2861 2248 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-08-24 12:59:35' where subId = 179 24/08/2024 12:59:38.3147 1028 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-08-24 12:59:37','0230004098567',0,0,5195769398283390,165,'0000-00-00 00:00:00','0000-00-00 00:00:00') 24/08/2024 12:59:42.8891 4289 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,payVatPercent,payVatAmount) VALUES ('2024-08-24 12:59:38',0,'V',5195769398283390,5762580439880190,2024,'2024-08-24 12:59:38',2,1,0,-1,'2024-08-24 13:59:38','S','KES',0,0,0,'','','',3,0,0) (WAIT TIME 273 ms.) 24/08/2024 12:59:47.2450 4345 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-08-24 12:59:42','V',5658722567860360,2024,'2024-08-24 12:59:33','455262739400327005012999',2,2,2,'O','',0,'2024-08-24 12:59:42',1,'','0230004098567',165,0) 24/08/2024 12:59:47.9292 600 ms. EXEC: update abbCards set carLastDate = '2024-08-24 12:59:47',carLastDirection='O' where carStatus='V' and carId = 165 24/08/2024 12:59:48.8207 886 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/08/2024 12:59:49.7013 865 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 12:59:48' where payTraUID = 5762580439880190 and payStatus='V' and payEnabled=1 24/08/2024 12:59:52.6822 2979 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-24 12:59:48' where traUID = 5762580439880190 and traStatus='V' and traEnabled=1 24/08/2024 13:01:01.6840 13688 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 24/08/2024 13:01:13.3446 11638 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) 24/08/2024 13:01:50.2438 853 ms. OPEN: select * from payreceipt where recPayUID = 5308525067739760 and recStatus='V' 24/08/2024 13:01:52.1877 18935 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-24 13:01:33','V',4884041277938210,2024,'2024-08-24 13:01:30','455260000400327003229999',22,22,3,'I','',1,0,1,'','',2) 24/08/2024 13:01:57.0068 4813 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:02:14.8158 24497 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-08-24 13:01:50','V',5726339585431300,2024,'2024-08-24 13:01:45','455264690500327005012999',1,2,16,'I','',1,0,1,'','0230004100967',12,0) 24/08/2024 13:02:15.6917 25455 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-24 13:01:49','V',5106493722394470,2024,'2024-08-24 13:01:44','455260000500327003229999',22,22,3,'I','',1,0,1,'','',2) (WAIT TIME 874 ms.) 24/08/2024 13:02:21.8149 6120 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:02:21.8149 6121 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:02:24.0252 5086 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-08-24 13:02:18','V',4812563685749240,2024,'2024-08-24 13:01:58','455264513600327005029999',2,2,16,'I','',1,0,1,'','0532370834279',12,0) 24/08/2024 13:02:27.1765 5359 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:02:21',carLastDirection='I' where carStatus='V' and carId = 12 24/08/2024 13:02:31.0244 6994 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:02:34.3600 7168 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 10 ms.) 24/08/2024 13:02:35.7835 1416 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 12 24/08/2024 13:02:41.1828 10157 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:02:31',carLastDirection='I' where carStatus='V' and carId = 12 24/08/2024 13:02:41.1828 5377 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-08-24 13:02:18',0,'V',5240653991036580,4923425222206890,2024,'2024-08-24 13:02:18',3,1,0,4,'2024-08-24 13:17:18','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 24/08/2024 13:02:46.7021 5505 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4923425222206890,5240653991036580,2024,'2024-08-24 13:02:41','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/24/2024 12:26:43 PM Date : 8/24/2024 1:02:18 PM Code : 455264480300327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 24/08/2024 13:02:46.7021 3528 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-08-24 13:02:43','V',4917691284404360,2024,'2024-08-24 13:01:58','455264513700327005029999',2,2,16,'I','',1,0,1,'','0532370834279',12,0) 24/08/2024 13:02:50.3933 3691 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:02:46',recModify = '2024-08-24 13:02:46',recUseId=0,recStatus='V' where recId = 295540 24/08/2024 13:02:50.3963 3688 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 2 ms.) 24/08/2024 13:03:00.2552 9853 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-24 13:02:50',0,0,'V',5012291885479030,4923425222206890,2024,'2024-08-24 13:02:50',3,'KES',1,50,50,'N',''); 24/08/2024 13:03:00.2552 9857 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:02:50',carLastDirection='I' where carStatus='V' and carId = 12 24/08/2024 13:03:05.6355 2694 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-08-24 13:03:02','V',5211983517979890,2024,'2024-08-24 13:01:58','455264513800327005029999',2,2,16,'I','',1,0,1,'','0532370834279',12,0) 24/08/2024 13:03:05.6365 5380 ms. EXEC: update paycash set casCreation = '2024-08-24 13:03:00',casModify = '2024-08-24 13:03:00',casUseId=0,casStatus='V' where casId = 180936 24/08/2024 13:03:09.5793 3939 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:03:18.9023 7887 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-08-24 13:03:10',0,'V',5642976563112740,5366646897030500,2024,'2024-08-24 13:03:10',3,1,0,4,'2024-08-24 13:18:10','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 24/08/2024 13:03:18.9023 9323 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:03:09',carLastDirection='I' where carStatus='V' and carId = 12 24/08/2024 13:03:18.9033 13265 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 13:02:50',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'; 24/08/2024 13:03:26.7557 7842 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5366646897030500,5642976563112740,2024,'2024-08-24 13:03:18','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/24/2024 12:39:56 PM Date : 8/24/2024 1:03:10 PM Code : 455264559600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 24/08/2024 13:03:26.7557 6528 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-08-24 13:03:20','V',5706732087787940,2024,'2024-08-24 13:01:58','455264513900327005029999',2,2,16,'I','',1,0,1,'','0532370834279',12,0) 24/08/2024 13:03:26.7557 7850 ms. EXEC: update payInventory set invCreation = '2024-08-24 13:03:18',invModify = '2024-08-24 13:03:18',invUseId=0,invStatus='V' where invId = 203183 24/08/2024 13:03:27.4604 638 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/08/2024 13:03:27.4614 694 ms. OPEN: select * from payCurInventory where curTerId = 3 order by curDevCode,curChannelId,curValue,curType,curAmount desc 24/08/2024 13:03:28.7393 5623 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-24 13:03:23','V',5411243369025620,2024,'2024-08-24 13:03:22','455264700200327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:03:30.9869 1984 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:03:26',recModify = '2024-08-24 13:03:26',recUseId=0,recStatus='V' where recId = 295541 (WAIT TIME 2245 ms.) 24/08/2024 13:03:31.0830 4322 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:03:33.9222 2897 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-24 13:03:31',0,0,'V',4937226947386740,5366646897030500,2024,'2024-08-24 13:03:31',3,'KES',1,50,50,'N',''); (WAIT TIME 20 ms.) 24/08/2024 13:03:33.9231 2895 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 20 ms.) 24/08/2024 13:03:36.6272 5544 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:03:31',carLastDirection='I' where carStatus='V' and carId = 12 24/08/2024 13:03:36.6282 4577 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-08-24 13:03:32','V',4716162756701820,2024,'2024-08-24 13:01:58','455264514000327005029999',2,2,16,'I','',1,0,1,'','0532370834279',12,0) 24/08/2024 13:03:40.4636 6541 ms. EXEC: update paycash set casCreation = '2024-08-24 13:03:33',casModify = '2024-08-24 13:03:33',casUseId=0,casStatus='V' where casId = 180937 24/08/2024 13:03:40.4646 6517 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 13:03:40.4666 6360 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-08-24 13:03:34','V',4820083080799120,2024,'2024-08-24 13:01:58','455264514100327005029999',2,2,16,'I','',1,0,1,'','0532370834279',12,0) 24/08/2024 13:03:43.6685 7037 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:03:46.0939 5620 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:03:52.1477 8479 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:03:43',carLastDirection='I' where carStatus='V' and carId = 12 24/08/2024 13:03:54.8936 6996 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-08-24 13:03:47','V',5049286237933400,2024,'2024-08-24 13:01:58','455264514200327005029999',2,2,16,'I','',1,0,1,'','0532370834279',12,0) 24/08/2024 13:03:54.8936 2893 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-08-24 13:03:51',0,'V',4612829108957920,4854938211137280,2024,'2024-08-24 13:03:51',3,1,0,4,'2024-08-24 13:18:51','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 24/08/2024 13:03:54.8936 14429 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 13:03:31',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'; 24/08/2024 13:03:54.8946 7014 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:03:47',carLastDirection='I' where carStatus='V' and carId = 12 24/08/2024 13:03:59.0629 4165 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:04:00.1858 1717 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-08-24 13:03:58','V',4937939134595430,2024,'2024-08-24 13:01:58','455264514300327005029999',2,2,16,'I','',1,0,1,'','0532370834279',12,0) 24/08/2024 13:04:00.6890 5290 ms. EXEC: update payInventory set invCreation = '2024-08-24 13:03:54',invModify = '2024-08-24 13:03:54',invUseId=0,invStatus='V' where invId = 203184 (WAIT TIME 501 ms.) 24/08/2024 13:04:00.6890 5279 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4854938211137280,4612829108957920,2024,'2024-08-24 13:03:54','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/24/2024 10:11:44 AM Date : 8/24/2024 1:03:51 PM Code : 455263670400327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) (WAIT TIME 503 ms.) 24/08/2024 13:04:03.1049 4040 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:03:59',carLastDirection='I' where carStatus='V' and carId = 12 24/08/2024 13:04:04.9308 4235 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:04:04.9348 4240 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:04:00',recModify = '2024-08-24 13:04:00',recUseId=0,recStatus='V' where recId = 295542 (WAIT TIME 4 ms.) 24/08/2024 13:04:09.5003 4561 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-24 13:04:04',0,0,'V',5205872696305550,4854938211137280,2024,'2024-08-24 13:04:04',3,'KES',1,100,100,'N',''); 24/08/2024 13:04:12.5597 3058 ms. EXEC: update paycash set casCreation = '2024-08-24 13:04:09',casModify = '2024-08-24 13:04:09',casUseId=0,casStatus='V' where casId = 180938 24/08/2024 13:04:14.1353 9195 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:04:04',carLastDirection='I' where carStatus='V' and carId = 12 24/08/2024 13:04:14.3104 739 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:04:13',0,2,'2024-08-24 13:04:13','0810007160534','Exit 1 - User Transit Supervisor Supervisor') 24/08/2024 13:04:14.4335 1873 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 13:04:04',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 24/08/2024 13:04:16.4849 1896 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/08/2024 13:04:16.4859 1987 ms. OPEN: select traCode from movTransit where traCode ='455264514400327002029999' (WAIT TIME 6 ms.) 24/08/2024 13:04:17.7806 3069 ms. EXEC: update payInventory set invCreation = '2024-08-24 13:04:14',invModify = '2024-08-24 13:04:14',invUseId=0,invStatus='V' where invId = 203185 (WAIT TIME 273 ms.) 24/08/2024 13:04:22.9765 4074 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-08-24 13:04:18','V',5251787894585890,2024,'2024-08-24 13:01:58','455264514400327005029999',2,2,16,'I','',1,0,1,'','0532370834279',12,0) 24/08/2024 13:04:24.1416 1162 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:04:28.7603 4617 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:04:24',carLastDirection='I' where carStatus='V' and carId = 12 24/08/2024 13:04:34.1708 1941 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:04:32',0,2,'2024-08-24 13:04:32','0810007160534','Exit 1 - User Transit Supervisor Supervisor') 24/08/2024 13:04:38.8469 4618 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:04:34',0,2,'2024-08-24 13:04:34','0810007160534','Exit 1 - User Transit Supervisor Supervisor') 24/08/2024 13:05:12.8095 2386 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-24 13:05:10','V',5065295742531470,2024,'2024-08-24 13:05:09','455264710900327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:05:14.5254 1712 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:05:18.0066 2852 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 601 ms.) 24/08/2024 13:05:21.3915 2776 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-24 13:05:18','V',5209610560276700,2024,'2024-08-24 13:05:14','455264559600327005012999',2,2,2,'O','',0,'2024-08-24 13:05:18',1,'','',0) (WAIT TIME 449 ms.) 24/08/2024 13:05:24.5238 2653 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 13:05:21' where payTraUID = 5366646897030500 and payStatus='V' and payEnabled=1 24/08/2024 13:05:26.6962 2172 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-24 13:05:21' where traUID = 5366646897030500 and traStatus='V' and traEnabled=1 24/08/2024 13:06:33.1821 2266 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-08-24 13:06:30','V',4707855244197730,2024,'2024-08-24 13:06:27','455256039100327001012999',2,2,2,'O','',0,'2024-08-24 13:06:30',1,'','0230003944059',13,0) (WAIT TIME 4 ms.) 24/08/2024 13:06:38.2334 5047 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:06:39.7164 1482 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:06:38',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:06:40.4994 777 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/08/2024 13:06:49.8870 5792 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 13:06:40' where payTraUID = 4769438316696000 and payStatus='V' and payEnabled=1 (WAIT TIME 3578 ms.) 24/08/2024 13:06:50.1091 4313 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-24 13:06:45','V',5465418064059660,2024,'2024-08-24 13:06:44','455264720400327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 23 ms.) 24/08/2024 13:06:50.6245 514 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-24 13:06:40' where traUID = 4769438316696000 and traStatus='V' and traEnabled=1 24/08/2024 13:07:02.6153 2444 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370677371' and traDirection='I' order by traId desc limit 1 24/08/2024 13:07:07.7886 5111 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-08-24 13:07:02','V',4786492677332990,2024,'2024-08-24 13:06:43','455264559700327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) (WAIT TIME 46 ms.) 24/08/2024 13:07:09.3867 3819 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-08-24 13:07:05' where subId = 9 (WAIT TIME 8 ms.) 24/08/2024 13:07:09.5708 1746 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-24 13:07:07','V',5627106571081000,2024,'2024-08-24 13:07:06','455264722600327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:07:09.5708 1768 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:07:12.9330 1170 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 13:07:09' where payTraUID = 4754631936520340 and payStatus='V' and payEnabled=1 24/08/2024 13:07:14.5540 1611 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-24 13:07:09' where traUID = 4754631936520340 and traStatus='V' and traEnabled=1 (WAIT TIME 5 ms.) 24/08/2024 13:07:15.3787 824 ms. EXEC: delete from movInside where insTraUID = 4754631936520340 24/08/2024 13:07:18.6914 4019 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-08-24 13:07:13','V',5295940771985710,2024,'2024-08-24 13:06:43','455264559800327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) (WAIT TIME 1425 ms.) 24/08/2024 13:07:22.9277 4212 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 3 ms.) 24/08/2024 13:07:28.8662 5937 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:07:22',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:07:31.2017 2347 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-24 13:07:28','V',5705483001678090,2024,'2024-08-24 13:07:28','455264724800327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:07:36.5780 8229 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-08-24 13:07:22','V',4673213769499940,2024,'2024-08-24 13:06:43','455264559900327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) (WAIT TIME 5374 ms.) 24/08/2024 13:07:53.6745 8559 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-08-24 13:07:45','V',4875979842652660,2024,'2024-08-24 13:06:43','455264560000327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:07:53.6755 15130 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:07:53.6755 14837 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:07:58.7911 12908 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-08-24 13:07:45','V',4795944421979430,2024,'2024-08-24 13:06:43','455264560100327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:08:04.4340 10754 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:08:04.4340 10758 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:07:53',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:08:04.4350 10240 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 13:08:05.9731 1603 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-08-24 13:08:04','V',5428825876849820,2024,'2024-08-24 13:06:43','455264560200327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:08:05.9741 1609 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-24 13:08:04','V',4900775441557990,2024,'2024-08-24 13:07:41','455264726100327005031999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:08:05.9751 7177 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:08:07.8319 3396 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:08:04',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:08:11.5942 5613 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:08:11.7023 5617 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:08:05',carLastDirection='O' where carStatus='V' and carId = 13 (WAIT TIME 109 ms.) 24/08/2024 13:08:11.7033 5614 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 109 ms.) 24/08/2024 13:08:14.9983 3293 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:08:11',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:08:19.7571 4743 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-08-24 13:08:15','V',4743384850513660,2024,'2024-08-24 13:06:43','455264560300327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:08:23.6761 3913 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:08:29.9989 6284 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:08:23',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:08:30.5044 4066 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-24 13:08:25','V',5168079698643660,2024,'2024-08-24 13:08:23','455263670400327005012999',2,2,2,'O','',0,'2024-08-24 13:08:25',1,'','',0) (WAIT TIME 505 ms.) 24/08/2024 13:08:30.5054 5771 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-08-24 13:08:24','V',5409405503032210,2024,'2024-08-24 13:06:43','455264560400327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) (WAIT TIME 506 ms.) 24/08/2024 13:08:33.6244 3105 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/08/2024 13:08:33.6244 3107 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:08:41.1171 7487 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 13:08:33' where payTraUID = 4854938211137280 and payStatus='V' and payEnabled=1 24/08/2024 13:08:42.9823 9356 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:08:33',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:08:42.9833 2138 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-08-24 13:08:40','V',5190967591315700,2024,'2024-08-24 13:06:43','455264560500327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:08:44.9234 3805 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-24 13:08:33' where traUID = 4854938211137280 and traStatus='V' and traEnabled=1 24/08/2024 13:08:49.5632 6137 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 439 ms.) 24/08/2024 13:08:55.1435 4975 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-08-24 13:08:50','V',4733152814229260,2024,'2024-08-24 13:06:43','455264560600327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:08:55.1435 5580 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:08:49',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:08:58.9554 3807 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:09:03.2149 3850 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:08:58',carLastDirection='O' where carStatus='V' and carId = 13 (WAIT TIME 408 ms.) 24/08/2024 13:09:11.6186 8378 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-08-24 13:09:03','V',5004050608326170,2024,'2024-08-24 13:06:43','455264560700327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:09:11.6196 8364 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-24 13:09:03','V',5241178244008880,2024,'2024-08-24 13:09:01','455264734100327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:09:14.0351 2409 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 3 ms.) 24/08/2024 13:09:14.4115 2408 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 380 ms.) 24/08/2024 13:09:18.5191 4064 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-08-24 13:09:14','V',5191631980110330,2024,'2024-08-24 13:06:43','455264560800327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:09:18.5191 4089 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:09:14',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:09:18.5191 4075 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 13:09:21.0192 2496 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:09:27.6407 6613 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:09:21',carLastDirection='O' where carStatus='V' and carId = 13 (WAIT TIME 8 ms.) 24/08/2024 13:09:32.3146 3031 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-24 13:09:29','V',5681998635632140,2024,'2024-08-24 13:09:13','455264735300327005031999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:09:32.3146 3031 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-08-24 13:09:29','V',5603758217159670,2024,'2024-08-24 13:06:43','455264560900327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:09:35.2064 2625 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:09:35.2074 2625 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:09:39.9275 4720 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:09:35',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:09:42.6938 3026 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-08-24 13:09:39','V',5247231145667050,2024,'2024-08-24 13:06:43','455264561000327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:09:47.1579 4460 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:09:55.8873 3570 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-08-24 13:09:51','V',5448774669710340,2024,'2024-08-24 13:06:43','455264561100327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) (WAIT TIME 1192 ms.) 24/08/2024 13:10:06.6380 8472 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 2273 ms.) 24/08/2024 13:10:11.8140 2978 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-08-24 13:10:08','V',5569756894665640,2024,'2024-08-24 13:06:43','455264561200327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:10:15.8021 3984 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:10:16.9477 626 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-08-24 13:10:16','V',5266767931163430,2024,'2024-08-24 13:06:43','455264561300327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/08/2024 13:10:21.1123 5296 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:10:15',carLastDirection='O' where carStatus='V' and carId = 13 (WAIT TIME 13 ms.) 24/08/2024 13:10:21.1163 4145 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 19 ms.) 24/08/2024 13:10:21.1173 12276 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:10:08',carLastDirection='O' where carStatus='V' and carId = 13 (WAIT TIME 19 ms.) 24/08/2024 13:10:21.2707 34108 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:09:47',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:10:23.7672 1354 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:10:21',carLastDirection='O' where carStatus='V' and carId = 13 24/08/2024 13:10:50.8892 2150 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-08-24 13:10:45',0,'V',5763254640430700,5716144196428810,2024,'2024-08-24 13:10:45',3,1,0,4,'2024-08-24 13:25:45','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 24/08/2024 13:10:53.0392 2139 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5716144196428810,5763254640430700,2024,'2024-08-24 13:10:50','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/24/2024 10:17:27 AM Date : 8/24/2024 1:10:45 PM Code : 455263704700327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 24/08/2024 13:10:54.7633 1724 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:10:53',recModify = '2024-08-24 13:10:53',recUseId=0,recStatus='V' where recId = 295543 24/08/2024 13:10:58.3262 3559 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-24 13:10:54',0,0,'V',4871540031600310,5716144196428810,2024,'2024-08-24 13:10:54',3,'KES',1,100,100,'N',''); 24/08/2024 13:11:01.2981 2733 ms. EXEC: update paycash set casCreation = '2024-08-24 13:10:58',casModify = '2024-08-24 13:10:58',casUseId=0,casStatus='V' where casId = 180939 (WAIT TIME 238 ms.) 24/08/2024 13:11:10.2306 8932 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 13:10:54',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 24/08/2024 13:11:16.7134 6480 ms. EXEC: update payInventory set invCreation = '2024-08-24 13:11:10',invModify = '2024-08-24 13:11:10',invUseId=0,invStatus='V' where invId = 203186 24/08/2024 13:11:40.0555 5521 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-08-24 13:11:32',0,'V',4892310407079610,5588721138889120,2024,'2024-08-24 13:11:32',3,1,0,4,'2024-08-24 13:26:32','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 24/08/2024 13:11:46.0448 5978 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5588721138889120,4892310407079610,2024,'2024-08-24 13:11:40','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/24/2024 12:44:46 PM Date : 8/24/2024 1:11:32 PM Code : 455264588600327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 50.00 KES',0) 24/08/2024 13:11:52.5425 6097 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:11:46',recModify = '2024-08-24 13:11:46',recUseId=0,recStatus='V' where recId = 295544 24/08/2024 13:12:03.9756 11428 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-24 13:11:52',0,0,'V',4849224361010010,5588721138889120,2024,'2024-08-24 13:11:52',3,'KES',1,100,100,'N',''); 24/08/2024 13:12:09.5091 5532 ms. EXEC: update paycash set casCreation = '2024-08-24 13:12:03',casModify = '2024-08-24 13:12:03',casUseId=0,casStatus='V' where casId = 180940 24/08/2024 13:12:16.3136 6804 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 13:11:52',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; 24/08/2024 13:12:17.6465 1331 ms. EXEC: update payInventory set invCreation = '2024-08-24 13:12:16',invModify = '2024-08-24 13:12:16',invUseId=0,invStatus='V' where invId = 203187 24/08/2024 13:12:17.6465 1312 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-24 13:12:16','V',5205053036898830,2024,'2024-08-24 13:12:15','455264753500327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:12:17.7335 1257 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-08-24 13:12:16','0230004100082',0,0,5274377026710630,142,'0000-00-00 00:00:00','0000-00-00 00:00:00') 24/08/2024 13:12:18.6965 944 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,payVatPercent,payVatAmount) VALUES ('2024-08-24 13:12:17',0,'V',5274377026710630,4759566628184960,2024,'2024-08-24 13:12:17',2,1,0,-1,'2024-08-24 14:12:17','S','KES',0,0,0,'','','',3,0,0) 24/08/2024 13:12:20.2499 2461 ms. EXEC: update paycash set casCreation = '2024-08-24 13:12:17',casModify = '2024-08-24 13:12:17',casUseId=0,casStatus='V' where casId = 180941 24/08/2024 13:12:20.2499 2434 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 13:12:23.3225 4612 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-08-24 13:12:18','V',5229830988793330,2024,'2024-08-24 13:12:14','455263248100327005012999',2,2,2,'O','',0,'2024-08-24 13:12:18',1,'','0230004100082',142,0) 24/08/2024 13:12:26.0960 2771 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:12:23',carLastDirection='O' where carStatus='V' and carId = 142 24/08/2024 13:12:28.1937 7734 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 13:12:17',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'; (WAIT TIME 209 ms.) 24/08/2024 13:12:31.0147 4913 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/08/2024 13:12:32.5044 4176 ms. EXEC: update payInventory set invCreation = '2024-08-24 13:12:28',invModify = '2024-08-24 13:12:28',invUseId=0,invStatus='V' where invId = 203188 (WAIT TIME 134 ms.) 24/08/2024 13:12:32.7433 1712 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 13:12:31' where payTraUID = 4759566628184960 and payStatus='V' and payEnabled=1 24/08/2024 13:12:34.2586 1515 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-24 13:12:31' where traUID = 4759566628184960 and traStatus='V' and traEnabled=1 24/08/2024 13:12:37.4051 1651 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-24 13:12:35','V',4894789499128650,2024,'2024-08-24 13:12:35','455264755500327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:12:38.8710 1130 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 13:12:51.5791 3701 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-08-24 13:12:47','V',4890607119306450,2024,'2024-08-24 13:12:34','455264561400327002029999',2,1,2,'O','',1,0,1,'','0532370833394',142,0) 24/08/2024 13:12:52.2682 683 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:12:53.7636 1495 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:12:52',carLastDirection='O' where carStatus='V' and carId = 142 24/08/2024 13:13:20.5075 511 ms. OPEN: select ticId from tabTicketType where ticStatus='V' and ticType = 3 24/08/2024 13:13:23.4869 2729 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-24 13:13:20','V',5601553941623280,2024,'2024-08-24 12:55:55','455264655500327005031999',3,2,16,'I','',1,0,1,'','',0) 24/08/2024 13:13:26.1851 2316 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:13:43.4458 597 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-24 13:13:42','V',5154663466627220,2024,'2024-08-24 13:13:39','455264588600327005012999',2,2,2,'O','',0,'2024-08-24 13:13:42',1,'','',0) 24/08/2024 13:13:46.4026 2944 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 (WAIT TIME 8 ms.) 24/08/2024 13:13:49.8364 3225 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-24 13:13:46' where traUID = 5588721138889120 and traStatus='V' and traEnabled=1 24/08/2024 13:14:04.3460 2438 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-08-24 13:13:14',1,'V',5414438188082780,5681998635632140,2024,'2024-08-24 13:13:14',4,1,0,4,'2024-08-24 13:28:14','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 24/08/2024 13:14:07.7338 2072 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:14:04',4,1,'2024-08-24 13:14:04','455264735300327005031999','Payed (Credit Card ) Ticket ') (WAIT TIME 1309 ms.) 24/08/2024 13:14:11.6538 3891 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 339594 else acvFstPayId end),acvLstPayId = 339594 where acvSftId = 774 and acvCodeId = 3 24/08/2024 13:14:13.8222 2102 ms. EXEC: update tabTerminalReceipt set trcProgressive = 11917, trcLastPrinted = '2400411917', trcLastDate = '2024-08-24 13:14:11' where trcStatus='V' and trcTerId = 4 24/08/2024 13:14:18.3279 4041 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5681998635632140,5414438188082780,2024,'2024-08-24 13:14:13',' Date: 8/24/2024 1:13:14 PM Code: 455264735300327005031999 Entry Date: 8/24/2024 1:09:13 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400411917 ',0) (WAIT TIME 346 ms.) 24/08/2024 13:14:23.5224 5194 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:14:18',recModify = '2024-08-24 13:14:18',recUseId=0,recStatus='V' where recId = 295545 24/08/2024 13:14:23.5224 5147 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-24 13:14:18','V',4904436774578820,2024,'2024-08-24 12:53:12','455264639200327005031999',3,2,16,'I','',1,0,1,'','',0) 24/08/2024 13:14:24.5921 3813 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-08-24 13:13:31',1,'V',4939518951302110,5681998635632140,2024,'2024-08-24 13:13:31',4,1,0,-1,'2024-08-24 14:13:31','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 2 ms.) 24/08/2024 13:14:30.4584 5342 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 1589 ms.) 24/08/2024 13:14:31.8489 7251 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:14:24',4,1,'2024-08-24 13:14:24','455264735300327005031999','Payed (Credit Card ) Ticket ') 24/08/2024 13:14:33.8619 1981 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 339595 else acvFstPayId end),acvLstPayId = 339595 where acvSftId = 774 and acvCodeId = 3 24/08/2024 13:14:35.6943 1498 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5681998635632140,4939518951302110,2024,'2024-08-24 13:14:34',' Date: 8/24/2024 1:13:31 PM Code: 455264735300327005031999 Entry Date: 8/24/2024 1:09:13 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400411918 ',0) 24/08/2024 13:14:42.1893 3061 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-24 13:14:38','V',5399346952547200,2024,'2024-08-24 13:14:38','455264767800327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 727 ms.) 24/08/2024 13:14:42.1913 3221 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-08-24 13:13:50',1,'V',5004280377265950,5681998635632140,2024,'2024-08-24 13:13:50',4,1,0,-1,'2024-08-24 14:13:50','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 728 ms.) 24/08/2024 13:14:43.6356 678 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 24/08/2024 13:14:43.6356 718 ms. EXECSCALAR: SELECT COUNT(*) FROM movTransit WHERE traCode='455264639200327005031999' nr: 1 24/08/2024 13:14:43.6406 623 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 4 ms.) 24/08/2024 13:14:43.6426 689 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 6 ms.) 24/08/2024 13:14:45.6142 3411 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:14:42',4,1,'2024-08-24 13:14:42','455264735300327005031999','Payed (Credit Card ) Ticket ') 24/08/2024 13:14:45.6142 3407 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 6 ms.) 24/08/2024 13:14:46.8330 1169 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 13:14:46.8330 1184 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 339596 else acvFstPayId end),acvLstPayId = 339596 where acvSftId = 774 and acvCodeId = 3 24/08/2024 13:14:47.5285 684 ms. EXEC: update tabTerminalReceipt set trcProgressive = 11919, trcLastPrinted = '2400411919', trcLastDate = '2024-08-24 13:14:46' where trcStatus='V' and trcTerId = 4 24/08/2024 13:14:49.1291 1598 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5681998635632140,5004280377265950,2024,'2024-08-24 13:14:47',' Date: 8/24/2024 1:13:50 PM Code: 455264735300327005031999 Entry Date: 8/24/2024 1:09:13 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400411919 ',0) 24/08/2024 13:14:52.4651 3332 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:14:49',recModify = '2024-08-24 13:14:49',recUseId=0,recStatus='V' where recId = 295547 24/08/2024 13:15:17.9907 832 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/08/2024 13:16:05.7599 7301 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 44 order by traDateTime desc,traId desc 24/08/2024 13:16:07.5439 538 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2024-08-24 13:16:07','0230003943530',0,0,5404027393143570,44,'0000-00-00 00:00:00','0000-00-00 00:00:00') 24/08/2024 13:16:10.3796 2710 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,payVatPercent,payVatAmount) VALUES ('2024-08-24 13:16:07',0,'V',5404027393143570,5688347803249310,2024,'2024-08-24 13:16:07',2,1,0,-1,'2024-08-24 14:16:07','S','KES',0,0,0,'','','',3,0,0) (WAIT TIME 2 ms.) 24/08/2024 13:16:13.5157 3124 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-08-24 13:16:10','V',4945320982590520,2024,'2024-08-24 13:15:54','455264188200327005012999',2,2,2,'O','',0,'2024-08-24 13:16:10',1,'','0230003943530',44,0) 24/08/2024 13:16:17.9857 4459 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:16:13',carLastDirection='O' where carStatus='V' and carId = 44 (WAIT TIME 8 ms.) 24/08/2024 13:16:21.8356 3844 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/08/2024 13:16:22.3299 3846 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-24 13:16:17','V',4683028864726990,2024,'2024-08-24 13:16:13','455264777300327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 494 ms.) 24/08/2024 13:16:26.7139 3991 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:16:27.0431 4296 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 13:16:22' where payTraUID = 5688347803249310 and payStatus='V' and payEnabled=1 24/08/2024 13:16:29.3085 1800 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-24 13:16:22' where traUID = 5688347803249310 and traStatus='V' and traEnabled=1 (WAIT TIME 464 ms.) 24/08/2024 13:16:46.7065 4190 ms. OPEN: select * from movTransit where traStatus='V' and traBadge = '0532370676842' and traDirection='I' order by traId desc limit 1 (WAIT TIME 942 ms.) 24/08/2024 13:16:48.7519 1989 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-24 13:16:46','V',5001763109385690,2024,'2024-08-24 13:16:40','455264735300327005031999',2,2,2,'O','',0,'2024-08-24 13:16:46',1,'','',0) 24/08/2024 13:16:48.7519 2012 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-08-24 13:16:46','V',4777201571943840,2024,'2024-08-24 13:16:25','455264588700327002029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/08/2024 13:16:50.7572 1786 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-24 13:16:48','V',4880441922226380,2024,'2024-08-24 13:16:31','455264779100327005031999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:16:50.7572 2001 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:16:50.7572 1998 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/08/2024 13:16:53.3769 2612 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 13:16:50' where payTraUID = 5681998635632140 and payStatus='V' and payEnabled=1 24/08/2024 13:16:53.3779 2615 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:16:53.3809 2618 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:16:50',carLastDirection='O' where carStatus='V' and carId = 44 (WAIT TIME 4 ms.) 24/08/2024 13:16:53.3849 2083 ms. EXEC: update abbCards set carLastDate = '2024-08-24 13:16:51',carLastDirection='O' where carStatus='V' and carId = 44 24/08/2024 13:16:56.3881 1103 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-24 13:16:54','V',4932201769104710,2024,'2024-08-24 13:16:54','455264781400327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 453 ms.) 24/08/2024 13:17:37.2255 2933 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-08-24 13:17:31',0,'V',4689386565164830,5372768262550720,2024,'2024-08-24 13:17:31',3,1,0,4,'2024-08-24 13:32:31','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 24/08/2024 13:17:42.2179 4979 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5372768262550720,4689386565164830,2024,'2024-08-24 13:17:37','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/24/2024 12:42:47 PM Date : 8/24/2024 1:17:31 PM Code : 455264576700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 24/08/2024 13:17:43.7494 1530 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:17:42',recModify = '2024-08-24 13:17:42',recUseId=0,recStatus='V' where recId = 295548 24/08/2024 13:17:44.4707 716 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-24 13:17:43',0,0,'V',4786571948677460,5372768262550720,2024,'2024-08-24 13:17:43',3,'KES',1,50,50,'N',''); 24/08/2024 13:17:51.4476 6862 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-08-24 13:17:43',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 24/08/2024 13:18:04.8242 7347 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-08-24 13:17:09',1,'V',4903423086459780,5126614973140360,2024,'2024-08-24 13:17:09',4,1,0,4,'2024-08-24 13:32:09','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 24/08/2024 13:18:10.1535 5324 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:18:04',4,1,'2024-08-24 13:18:04','455264526100327005012999','Payed (Credit Card ) Ticket ') 24/08/2024 13:18:12.3828 2187 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 339599 else acvFstPayId end),acvLstPayId = 339599 where acvSftId = 774 and acvCodeId = 3 24/08/2024 13:18:23.0448 7900 ms. EXEC: update tabTerminalReceipt set trcProgressive = 11920, trcLastPrinted = '2400411920', trcLastDate = '2024-08-24 13:18:12' where trcStatus='V' and trcTerId = 4 (WAIT TIME 2752 ms.) 24/08/2024 13:18:23.0458 2769 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-24 13:18:19','V',5497562871649360,2024,'2024-08-24 13:18:18','455264789800327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 1036 ms.) 24/08/2024 13:18:29.6549 5623 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 972 ms.) 24/08/2024 13:18:29.6579 5628 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5126614973140360,4903423086459780,2024,'2024-08-24 13:18:23',' Date: 8/24/2024 1:17:09 PM Code: 455264526100327005012999 Entry Date: 8/24/2024 12:34:21 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400411920 ',0) (WAIT TIME 977 ms.) 24/08/2024 13:18:32.4214 2730 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 13:18:32.4214 2357 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-08-24 13:18:28',0,'V',4839776248631980,4892438675583220,2024,'2024-08-24 13:18:28',3,1,0,4,'2024-08-24 13:33:28','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 24/08/2024 13:18:32.4224 2763 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:18:29',recModify = '2024-08-24 13:18:29',recUseId=0,recStatus='V' where recId = 295549 24/08/2024 13:18:39.7940 5535 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-08-24 13:17:45',1,'V',4916749096521440,5126614973140360,2024,'2024-08-24 13:17:45',4,1,0,-1,'2024-08-24 14:17:45','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 1101 ms.) 24/08/2024 13:18:39.7950 6254 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4892438675583220,4839776248631980,2024,'2024-08-24 13:18:32','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/24/2024 11:57:28 AM Date : 8/24/2024 1:18:28 PM Code : 455264304800327005012999 Total : 100.00 KES VAT 16% : 13.79 KES ---------------------------------- Paid : 100.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) (WAIT TIME 1101 ms.) 24/08/2024 13:18:45.7580 4259 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:18:39',recModify = '2024-08-24 13:18:39',recUseId=0,recStatus='V' where recId = 295550 (WAIT TIME 1703 ms.) 24/08/2024 13:18:45.7640 4253 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:18:39',4,1,'2024-08-24 13:18:39','455264526100327005012999','Payed (Credit Card ) Ticket ') (WAIT TIME 1709 ms.) 24/08/2024 13:18:45.7921 1508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 35 ms.) 24/08/2024 13:18:49.9892 4182 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-24 13:18:45',0,0,'V',5581436584276190,4892438675583220,2024,'2024-08-24 13:18:45',3,'KES',1,100,100,'N',''); 24/08/2024 13:18:49.9902 4186 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 339601 else acvFstPayId end),acvLstPayId = 339601 where acvSftId = 774 and acvCodeId = 3 24/08/2024 13:18:50.7004 1507 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-08-24 13:18:01',1,'V',5232696460555410,5126614973140360,2024,'2024-08-24 13:18:01',4,1,0,-1,'2024-08-24 14:18:01','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 24/08/2024 13:18:53.5519 3561 ms. EXEC: update paycash set casCreation = '2024-08-24 13:18:49',casModify = '2024-08-24 13:18:49',casUseId=0,casStatus='V' where casId = 180943 24/08/2024 13:18:53.6189 3548 ms. EXEC: update tabTerminalReceipt set trcProgressive = 11921, trcLastPrinted = '2400411921', trcLastDate = '2024-08-24 13:18:50' where trcStatus='V' and trcTerId = 4 (WAIT TIME 67 ms.) 24/08/2024 13:18:56.2663 4909 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:18:50',4,1,'2024-08-24 13:18:50','455264526100327005012999','Payed (Credit Card ) Ticket ') (WAIT TIME 649 ms.) 24/08/2024 13:18:59.7610 5957 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 13:18:45',3,42101,0,100,1,100,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N'; (WAIT TIME 183 ms.) 24/08/2024 13:18:59.7620 3292 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5126614973140360,4916749096521440,2024,'2024-08-24 13:18:56',' Date: 8/24/2024 1:17:45 PM Code: 455264526100327005012999 Entry Date: 8/24/2024 12:34:21 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400411921 ',0) (WAIT TIME 184 ms.) 24/08/2024 13:18:59.7630 3263 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-24 13:18:56','V',5513561319247990,2024,'2024-08-24 13:18:36','455264791600327005031999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 182 ms.) 24/08/2024 13:18:59.7640 3274 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 339602 else acvFstPayId end),acvLstPayId = 339602 where acvSftId = 774 and acvCodeId = 3 (WAIT TIME 187 ms.) 24/08/2024 13:19:01.1093 1340 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:19:03.5873 3825 ms. EXEC: update payInventory set invCreation = '2024-08-24 13:18:59',invModify = '2024-08-24 13:18:59',invUseId=0,invStatus='V' where invId = 203190 24/08/2024 13:19:04.6107 4847 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:18:59',recModify = '2024-08-24 13:18:59',recUseId=0,recStatus='V' where recId = 295551 24/08/2024 13:19:04.6117 4831 ms. EXEC: update tabTerminalReceipt set trcProgressive = 11922, trcLastPrinted = '2400411922', trcLastDate = '2024-08-24 13:18:59' where trcStatus='V' and trcTerId = 4 (WAIT TIME 1 ms.) 24/08/2024 13:19:10.0047 5391 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5126614973140360,5232696460555410,2024,'2024-08-24 13:19:04',' Date: 8/24/2024 1:18:01 PM Code: 455264526100327005012999 Entry Date: 8/24/2024 12:34:21 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400411922 ',0) 24/08/2024 13:19:12.4147 7163 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-08-24 13:18:17',1,'V',4950297692759950,5126614973140360,2024,'2024-08-24 13:18:17',4,1,0,-1,'2024-08-24 14:18:17','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 433 ms.) 24/08/2024 13:19:12.4157 2408 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:19:10',recModify = '2024-08-24 13:19:10',recUseId=0,recStatus='V' where recId = 295552 24/08/2024 13:19:13.4176 996 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:19:12',4,1,'2024-08-24 13:19:12','455264526100327005012999','Payed (Credit Card ) Ticket ') 24/08/2024 13:19:17.7807 3944 ms. EXEC: update tabTerminalReceipt set trcProgressive = 11923, trcLastPrinted = '2400411923', trcLastDate = '2024-08-24 13:19:13' where trcStatus='V' and trcTerId = 4 24/08/2024 13:19:22.4995 4716 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5126614973140360,4950297692759950,2024,'2024-08-24 13:19:17',' Date: 8/24/2024 1:18:17 PM Code: 455264526100327005012999 Entry Date: 8/24/2024 12:34:21 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400411923 ',0) 24/08/2024 13:19:27.7062 1028 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-08-24 13:19:23',0,'V',5523679363514670,5601553941623280,2024,'2024-08-24 13:19:23',3,1,0,0,'2024-08-24 13:19:23','C','KES',1,100,50,'',' ',' ',2,1,0,0,'',0,0) 24/08/2024 13:19:37.1957 3803 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-24 13:19:29',0,0,'V',5551733704627870,5601553941623280,2024,'2024-08-24 13:19:29',3,'KES',-1,50,-50,'N',''); (WAIT TIME 3964 ms.) 24/08/2024 13:19:38.2803 1084 ms. EXEC: update paycash set casCreation = '2024-08-24 13:19:37',casModify = '2024-08-24 13:19:37',casUseId=0,casStatus='V' where casId = 180945 24/08/2024 13:19:47.7941 9292 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 13:19:29',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'; (WAIT TIME 219 ms.) 24/08/2024 13:19:48.9941 1186 ms. EXEC: update payInventory set invCreation = '2024-08-24 13:19:47',invModify = '2024-08-24 13:19:47',invUseId=0,invStatus='V' where invId = 203192 24/08/2024 13:20:11.2563 5402 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-08-24 13:20:03',0,'V',5145589196640490,5503942705364270,2024,'2024-08-24 13:20:03',3,1,0,4,'2024-08-24 13:35:03','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 24/08/2024 13:20:13.0249 1756 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5503942705364270,5145589196640490,2024,'2024-08-24 13:20:11','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/24/2024 12:31:09 PM Date : 8/24/2024 1:20:03 PM Code : 455264506900327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 24/08/2024 13:20:21.7947 8294 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 13:20:13',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'; 24/08/2024 13:20:24.5589 2763 ms. EXEC: update payInventory set invCreation = '2024-08-24 13:20:21',invModify = '2024-08-24 13:20:21',invUseId=0,invStatus='V' where invId = 203193 24/08/2024 13:20:25.4168 1985 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-24 13:20:23','V',5424539481932350,2024,'2024-08-24 12:54:54','455264649400327005031999',3,2,16,'I','',1,0,1,'','',0) 24/08/2024 13:20:29.3948 3160 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 808 ms.) 24/08/2024 13:20:53.1661 1036 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-08-24 13:20:02',1,'V',4624026130431910,5126614973140360,2024,'2024-08-24 13:20:02',4,1,0,-1,'2024-08-24 14:20:02','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) 24/08/2024 13:20:54.0412 862 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:20:53',4,1,'2024-08-24 13:20:53','455264526100327005012999','Payed (Credit Card ) Ticket ') 24/08/2024 13:20:56.0242 1953 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 339606 else acvFstPayId end),acvLstPayId = 339606 where acvSftId = 774 and acvCodeId = 3 24/08/2024 13:20:59.0743 2665 ms. EXEC: update tabTerminalReceipt set trcProgressive = 11924, trcLastPrinted = '2400411924', trcLastDate = '2024-08-24 13:20:56' where trcStatus='V' and trcTerId = 4 24/08/2024 13:21:03.9377 3957 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-08-24 13:20:58',0,'V',5172544978432250,5424539481932350,2024,'2024-08-24 13:20:58',3,1,0,0,'2024-08-24 13:20:58','C','KES',1,50,0,'',' ',' ',2,1,0,0,'',0,0) 24/08/2024 13:21:07.1596 2784 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:21:04',recModify = '2024-08-24 13:21:04',recUseId=0,recStatus='V' where recId = 295557 24/08/2024 13:21:11.3199 4097 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-08-24 13:21:07',0,0,'V',5737938013636830,5424539481932350,2024,'2024-08-24 13:21:07',3,'KES',1,50,50,'N',''); (WAIT TIME 5 ms.) 24/08/2024 13:21:13.4822 1866 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-08-24 13:21:07',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'; 24/08/2024 13:23:04.9405 526 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-24 13:23:04','V',4922488876295650,2024,'2024-08-24 13:23:03','455264818300327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:23:32.2189 3550 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-24 13:23:28','V',5559796317007230,2024,'2024-08-24 13:23:28','455264506900327005012999',2,2,2,'O','',0,'2024-08-24 13:23:28',1,'','',0) (WAIT TIME 4 ms.) 24/08/2024 13:23:34.4615 2237 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/08/2024 13:23:36.3283 1862 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-08-24 13:23:34' where payTraUID = 5503942705364270 and payStatus='V' and payEnabled=1 24/08/2024 13:23:39.5845 3255 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-08-24 13:23:34' where traUID = 5503942705364270 and traStatus='V' and traEnabled=1 24/08/2024 13:25:18.4451 921 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-24 13:25:17','V',5318586615739060,2024,'2024-08-24 13:25:17','455264831700327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:25:45.9457 589 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-24 13:25:44','V',5733232142552700,2024,'2024-08-24 13:25:44','455264834400327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 450 ms.) 24/08/2024 13:25:46.6943 745 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:25:47.6173 902 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 = '455264834400327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 24/08/2024 13:25:48.2719 608 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/08/2024 13:26:37.7186 3548 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-08-24 13:26:34',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 24/08/2024 13:26:38.5796 860 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-08-24 13:26:37',1,2,'2024-08-24 13:26:37','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 24/08/2024 13:26:57.5623 1593 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-08-24 13:26:55',0,'V',4746849077303620,5131497086074740,2024,'2024-08-24 13:26:55',18,1,0,4,'2024-08-24 13:41:55','C','KES',100,100,0,'','','',1,100,0,0,'',0,0) 24/08/2024 13:26:59.3959 1821 ms. EXEC: update tabTerminalReceipt set trcProgressive = 37554, trcLastPrinted = '2400737554', trcLastDate = '2024-08-24 13:26:57' where trcStatus='V' and trcTerId = 18 24/08/2024 13:27:02.5538 3154 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5131497086074740,4746849077303620,2024,'2024-08-24 13:26:59',' Date: 8/24/2024 1:26:55 PM Code: 455263918600327005012999 Entry Date: 8/24/2024 10:53:06 AM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400737554 ',0) 24/08/2024 13:27:03.3791 712 ms. EXEC: update payReceipt set recCreation = '2024-08-24 13:27:02',recModify = '2024-08-24 13:27:02',recUseId=0,recStatus='V' where recId = 295558 24/08/2024 13:27:06.3173 3191 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-24 13:27:03','V',4854472623334470,2024,'2024-08-24 13:27:03','455264842300327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 13:27:07.1038 776 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/08/2024 13:27:42.2282 597 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-08-24 13:27:41',0,'V',4790146394048210,5513561319247990,2024,'2024-08-24 13:27:41',3,1,0,4,'2024-08-24 13:42:41','C','KES',50,50,0,'',' ',' ',1,50,0,0,'',0,0) 24/08/2024 16:36:44.6060 508 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 339690 else acvFstPayId end),acvLstPayId = 339690 where acvSftId = 774 and acvCodeId = 3 24/08/2024 18:40:42.2257 708 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-24 18:40:41','V',5496500529384940,2024,'2024-08-24 18:40:41','455266724100327005012999',1,2,16,'I','',1,0,1,'','',4) 24/08/2024 20:03:00.0681 657 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 = 9 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