[20/Jul/2023:14:22:04] (login) Get Groups For :gvk-up-102  admin
[20/Jul/2023:14:22:04] (login) select * from AccountUserSettings where accountID='gvk-up-102' and userID='admin'
[20/Jul/2023:14:22:04] (login) Get Account Settings For :gvk-up-102
[20/Jul/2023:14:22:04] (login) select * from  AccountSetup where accountID='gvk-up-102'
[20/Jul/2023:14:22:04] (login) Get Account String For :gvk-up-102
[20/Jul/2023:14:22:04] (login) select * from  AccountString where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:04] (login) Return Group List 
[20/Jul/2023:14:22:04] (index) SELECT * from Geozone where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:04] (index) select groupID,description from DeviceGroup where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:04] (index) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:04] (index) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:22:06] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:06] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:22:07] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('gvk-up-102','admin','mapmyindia','map','1689843127','49.204.26.56')
[20/Jul/2023:14:22:07] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:07] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:22:08] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:08] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:22:09] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:09] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:22:10] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:10] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:22:35] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:35] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:22:36] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:37] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:22:37] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:37] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:22:38] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:38] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:22:39] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:22:39] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:23:10] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:23:10] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:23:10] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:23:10] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:23:11] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:23:11] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:23:26] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:23:26] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:23:27] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:23:27] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:23:43] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:23:43] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:23:43] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:23:43] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:23:44] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:23:44] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:23:46] (index) select * from email where accountID='gvk-up-102'
[20/Jul/2023:14:23:46] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:23:46] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:14:24:03] (MailOparetions) select * from email where accountID='gvk-up-102' and groupID='selectall' and reportSchedule='daily' and emailaddress='rizwan@glovision.co' and reporttype='summary' and description='currentstatus'
[20/Jul/2023:14:24:03] (MailOparetions) insert into email (accountID,emailaddress,groupID,time,reportSchedule,reporttype,description,userID) values('gvk-up-102','rizwan@glovision.co','selectall','1689843243','daily','summary','currentstatus','admin')
[20/Jul/2023:14:24:04] (index) select * from email where accountID='gvk-up-102'
[20/Jul/2023:14:24:04] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:14:24:04] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:16:26:28] (login) Get Groups For :gvk-up-102  admin
[20/Jul/2023:16:26:28] (login) select * from AccountUserSettings where accountID='gvk-up-102' and userID='admin'
[20/Jul/2023:16:26:28] (login) Get Account Settings For :gvk-up-102
[20/Jul/2023:16:26:28] (login) select * from  AccountSetup where accountID='gvk-up-102'
[20/Jul/2023:16:26:28] (login) Get Account String For :gvk-up-102
[20/Jul/2023:16:26:28] (login) select * from  AccountString where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:26:28] (login) Return Group List 
[20/Jul/2023:16:26:28] (index) SELECT * from Geozone where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:26:28] (index) select groupID,description from DeviceGroup where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:26:28] (index) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:26:28] (index) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:16:26:33] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:26:33] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:26:33] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:16:26:33] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:16:26:33] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('gvk-up-102','admin','mapmyindia','map','1689850593','157.48.161.221')
[20/Jul/2023:16:26:33] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:26:33] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:16:26:35] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:26:35] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:16:26:35] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:26:35] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:16:26:38] (index) select * from email where accountID='gvk-up-102'
[20/Jul/2023:16:26:40] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:26:40] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:16:27:11] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:27:11] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[20/Jul/2023:16:27:41] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[20/Jul/2023:16:27:41] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'