{"code":"AP000","record":[{"at":"2026-10-29T04:25:19.061Z","durationMs":43.455111,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 AND g.CarPlateID IS NOT NULL AND h.CarplateNo IS NOT NULL ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobi","values":[100,0]},{"at":"2026-10-29T03:10:56.435Z","durationMs":270.610452,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[55]},{"at":"2026-10-29T03:10:56.435Z","durationMs":273.59208,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[8]},{"at":"2026-10-29T03:10:56.435Z","durationMs":274.862857,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[3]},{"at":"2026-10-29T03:10:56.434Z","durationMs":275.719589,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-29T03:10:56.245Z","durationMs":87.919278,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[1]},{"at":"2026-10-29T03:10:56.154Z","durationMs":418.994468,"source":"common.database.execQuery","sql":"SELECT GateID, RefGateID, IsEntryGate FROM Gate a LEFT JOIN GateController b ON b.GateControllerID = a.GateControllerID;","values":[]},{"at":"2026-10-28T14:15:44.663Z","durationMs":269.892237,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[55]},{"at":"2026-10-28T14:15:44.662Z","durationMs":268.807062,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[8]},{"at":"2026-10-28T14:15:44.661Z","durationMs":282.62751,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[3]},{"at":"2026-10-28T14:15:44.661Z","durationMs":283.846976,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-28T14:15:44.526Z","durationMs":151.265776,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[1]},{"at":"2026-10-28T14:15:44.373Z","durationMs":356.94413,"source":"common.database.execQuery","sql":"SELECT GateID, RefGateID, IsEntryGate FROM Gate a LEFT JOIN GateController b ON b.GateControllerID = a.GateControllerID;","values":[]},{"at":"2026-10-28T06:37:06.233Z","durationMs":34.19406,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS","values":[100,0]},{"at":"2026-10-28T06:35:53.873Z","durationMs":33.54776,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS","values":[100,0]},{"at":"2026-10-28T06:35:53.208Z","durationMs":34.87541,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS","values":[100,0]},{"at":"2026-10-28T05:41:51.493Z","durationMs":34.240734,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS","values":[100,0]},{"at":"2026-10-28T04:58:56.409Z","durationMs":49.767901,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 AND g.CarPlateID IS NOT NULL AND h.CarplateNo IS NOT NULL ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobi","values":[100,0]},{"at":"2026-10-27T06:10:13.208Z","durationMs":63.44302,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS","values":[100,0]},{"at":"2026-10-27T03:58:59.168Z","durationMs":50.910558,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 AND b.OperatorID REGEXP ? ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarP","values":["^(3)$",100,0,"^(3)$"]},{"at":"2026-10-27T03:23:18.347Z","durationMs":40.05007,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS","values":[100,0]},{"at":"2026-10-26T08:47:15.184Z","durationMs":35.32802,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS","values":[100,0]},{"at":"2026-10-23T08:33:02.239Z","durationMs":128.639376,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[1]},{"at":"2026-10-23T08:33:02.238Z","durationMs":127.820316,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[10]},{"at":"2026-10-23T08:33:02.238Z","durationMs":127.450955,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[11]},{"at":"2026-10-23T08:33:02.237Z","durationMs":126.900314,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[12]},{"at":"2026-10-23T08:33:02.236Z","durationMs":125.54564,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[13]},{"at":"2026-10-23T08:33:02.234Z","durationMs":123.018061,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-23T08:33:02.233Z","durationMs":122.231639,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[3]},{"at":"2026-10-23T08:33:02.231Z","durationMs":120.839506,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[6]},{"at":"2026-10-23T08:33:02.231Z","durationMs":120.173934,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[7]},{"at":"2026-10-23T08:33:02.230Z","durationMs":119.186283,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[8]},{"at":"2026-10-23T08:33:02.227Z","durationMs":116.579868,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[9]},{"at":"2026-10-23T08:33:02.223Z","durationMs":113.260977,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[14]},{"at":"2026-10-23T08:33:02.222Z","durationMs":111.947151,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[15]},{"at":"2026-10-23T08:33:02.220Z","durationMs":109.908278,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[16]},{"at":"2026-10-23T08:33:02.218Z","durationMs":107.760623,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[17]},{"at":"2026-10-23T08:33:02.216Z","durationMs":105.562543,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[18]},{"at":"2026-10-23T08:33:02.214Z","durationMs":103.820746,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[19]},{"at":"2026-10-23T08:33:02.210Z","durationMs":99.966605,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[29]},{"at":"2026-10-23T08:33:02.209Z","durationMs":99.638318,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[28]},{"at":"2026-10-23T08:33:02.208Z","durationMs":98.762203,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[27]},{"at":"2026-10-23T08:33:02.208Z","durationMs":97.835085,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[20]},{"at":"2026-10-23T08:33:02.206Z","durationMs":95.728316,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[21]},{"at":"2026-10-23T08:33:02.204Z","durationMs":94.181692,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[22]},{"at":"2026-10-23T08:33:02.203Z","durationMs":93.286799,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[23]},{"at":"2026-10-23T08:33:02.200Z","durationMs":90.660738,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[24]},{"at":"2026-10-23T08:33:02.199Z","durationMs":89.505999,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[25]},{"at":"2026-10-23T08:33:02.194Z","durationMs":84.131525,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[26]},{"at":"2026-10-23T08:33:02.181Z","durationMs":71.388764,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[30]},{"at":"2026-10-23T08:33:02.180Z","durationMs":70.218854,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[31]},{"at":"2026-10-23T08:33:02.178Z","durationMs":70.28524,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[39]},{"at":"2026-10-23T08:33:02.175Z","durationMs":65.185518,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[32]},{"at":"2026-10-23T08:33:02.174Z","durationMs":64.34409,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[33]},{"at":"2026-10-23T08:33:02.173Z","durationMs":63.325853,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[34]},{"at":"2026-10-23T08:33:02.170Z","durationMs":60.447059,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[35]},{"at":"2026-10-23T08:33:02.164Z","durationMs":54.906457,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[37]},{"at":"2026-10-23T08:33:02.164Z","durationMs":54.548297,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[36]},{"at":"2026-10-23T08:33:02.160Z","durationMs":62.881373,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[50]},{"at":"2026-10-23T08:33:02.158Z","durationMs":53.592947,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[41]},{"at":"2026-10-23T08:33:02.157Z","durationMs":59.288035,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[45]},{"at":"2026-10-23T08:33:02.157Z","durationMs":51.452296,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[40]},{"at":"2026-10-23T08:33:02.157Z","durationMs":57.651249,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[42]},{"at":"2026-10-23T08:33:02.156Z","durationMs":60.673591,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[61]},{"at":"2026-10-23T08:33:02.156Z","durationMs":59.871719,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[55]},{"at":"2026-10-23T08:33:02.151Z","durationMs":56.618829,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[62]},{"at":"2026-10-23T08:33:02.148Z","durationMs":39.154087,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[38]},{"at":"2026-10-23T08:33:02.133Z","durationMs":39.299409,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[63]},{"at":"2026-10-23T08:15:41.010Z","durationMs":58.751298,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 AND b.CarParkID REGEXP ? ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPl","values":["^(4|5|61)$",100,0,"^(4|5|61)$"]},{"at":"2026-10-23T07:39:22.295Z","durationMs":34.861774,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS","values":[100,0]},{"at":"2026-10-23T07:39:16.676Z","durationMs":35.139054,"source":"db.reader.query","sql":"SELECT a.ParkingEntryID, a.TicketID, a.loginMobileID, c.mobile, e.name, e.email,\n            f.loginEmailID, f.email AS linkedemail, a.CarParkID, b.SystemID, b.SystemName,\n            b.OperatorID, b.OperatorName, b.CarParkName, b.CarParkMappingID, b.CarParkUserInputCode,\n            a.GateID, a.GateType, a.Duration, a.Amount_CurrentFees, a.Amount_Paid, a.Amount_Due,\n            a.ParkingEntryDateTime, a.ExitMethod, g.CarPlateID, h.CarPlateNo,\n            (\n                SELECT a1.CreatedDateTime\n                FROM Transaction_ParkingPayment a1\n                WHERE a1.TicketID = a.TicketID\n                    AND a1.ParkingPaymentTrxStatus = 1\n                ORDER BY a1.CreatedDateTime DESC\n                LIMIT 1\n            ) AS LastPaidTimeDate FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS NOT NULL AND a.ActiveStatus = 1 ORDER BY a.ParkingEntryDateTime DESC LIMIT ? OFFSET ?; SELECT COUNT(a.ParkingEntryID) AS resultcount FROM ParkingTicket_Entry a LEFT JOIN TempTable_Get_CarParkDetails b ON b.CarParkID = a.CarParkID LEFT JOIN LoginMobile c ON c.loginMobileID = a.loginMobileID LEFT JOIN LoginLink d ON d.loginMobileID = c.loginMobileID AND d.DeletedDateTime IS NULL LEFT JOIN LoginMobile_Profile e ON e.loginMobileID = c.loginMobileID LEFT JOIN LoginEmail f ON f.loginEmailID = d.loginEmailID LEFT JOIN ParkingTicket_Parker g ON g.TicketID = a.TicketID AND g.ParkingEntryID = a.ParkingEntryID LEFT JOIN LoginMobile_CarPlateNo h ON h.ID = g.CarPlateID WHERE a.TicketID IS","values":[100,0]},{"at":"2026-10-23T07:08:59.413Z","durationMs":36.432288,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-23T07:08:59.412Z","durationMs":30.423889,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[8]},{"at":"2026-10-23T07:08:57.632Z","durationMs":49.331389,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-23T07:08:57.629Z","durationMs":39.023524,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[55]},{"at":"2026-10-23T07:08:57.628Z","durationMs":42.785561,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[8]},{"at":"2026-10-23T07:08:57.628Z","durationMs":43.803033,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[3]},{"at":"2026-10-23T07:08:31.052Z","durationMs":40.831854,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-23T07:08:31.046Z","durationMs":31.452379,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[7]},{"at":"2026-10-23T07:08:31.044Z","durationMs":31.578737,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[3]},{"at":"2026-10-23T07:08:31.041Z","durationMs":32.249552,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[1]},{"at":"2026-10-23T07:08:29.138Z","durationMs":31.607033,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-23T07:08:03.734Z","durationMs":30.36453,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[11]},{"at":"2026-10-23T07:08:03.733Z","durationMs":30.369995,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[9]},{"at":"2026-10-23T07:08:03.733Z","durationMs":37.15731,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-23T07:08:03.732Z","durationMs":33.061477,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[7]},{"at":"2026-10-23T07:08:03.731Z","durationMs":33.144098,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[3]},{"at":"2026-10-23T06:37:47.845Z","durationMs":35.090287,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-23T06:37:47.844Z","durationMs":31.48854,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[3]},{"at":"2026-10-23T06:37:47.841Z","durationMs":31.554135,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[1]},{"at":"2026-10-23T06:37:09.421Z","durationMs":32.367222,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[9]},{"at":"2026-10-23T06:37:09.420Z","durationMs":38.056075,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-23T06:37:09.419Z","durationMs":33.98627,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[7]},{"at":"2026-10-23T06:37:09.419Z","durationMs":35.4314,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[3]},{"at":"2026-10-23T06:37:09.418Z","durationMs":30.929795,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[8]},{"at":"2026-10-23T06:36:49.503Z","durationMs":72.984863,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[41]},{"at":"2026-10-23T06:36:49.503Z","durationMs":74.515612,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[20]},{"at":"2026-10-23T06:36:49.502Z","durationMs":108.778945,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[2]},{"at":"2026-10-23T06:36:49.501Z","durationMs":100.132673,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[8]},{"at":"2026-10-23T06:36:49.501Z","durationMs":97.263441,"source":"common.database.execQuery","sql":"SELECT COUNT(ParkingEntryID) AS TotalInParking FROM ParkingTicket_Entry WHERE CarParkID = ? AND ActiveStatus = 1;","values":[9]}],"count":100}