2019-08-21 10:18:43 777 335566800 335653140 SQL 2 SELECT SPN245 FROM fas_analytical_server_core.mobiledevice_candt WHERE vehicleID = 217999001 AND eventDate <= 335653140 AND eventDate > 335566800 AND SPN245 IS NOT NULL ORDER BY eventDate DESC LIMIT 1
2019-08-21 10:18:43 777 0 335566800 SQL 2 SELECT SPN245 FROM fas_analytical_server_core.mobiledevice_candt WHERE vehicleID = 217999001 AND eventDate <= 335566800 AND eventDate > 0 AND SPN245 IS NOT NULL ORDER BY eventDate DESC LIMIT 1
2019-08-21 10:18:43 777 335566800 335653140 SQL 1 SELECT SPN247 FROM fas_analytical_server_core.mobiledevice_candt WHERE vehicleID = 217999001 AND eventDate <= 335653140 AND eventDate > 335566800 AND SPN247 IS NOT NULL ORDER BY eventDate DESC LIMIT 1
2019-08-21 10:18:43 777 335566800 335653140 SQL 0 SELECT SPN250 FROM fas_analytical_server_core.mobiledevice_candt WHERE vehicleID = 217999001 AND eventDate <= 335653140 AND eventDate > 335566800 AND SPN250 IS NOT NULL ORDER BY eventDate DESC LIMIT 1
2019-08-21 10:18:43 777 335566800 335653140 SQL 0 SELECT SPN914 FROM fas_analytical_server_core.mobiledevice_candt WHERE vehicleID = 217999001 AND eventDate <= 335653140 AND eventDate > 335566800 AND SPN914 IS NOT NULL ORDER BY eventDate DESC LIMIT 1
2019-08-21 10:18:43 777 335566800 335653140 SQL 0 SELECT SPN916 FROM fas_analytical_server_core.mobiledevice_candt WHERE vehicleID = 217999001 AND eventDate <= 335653140 AND eventDate > 335566800 AND SPN916 IS NOT NULL ORDER BY eventDate DESC LIMIT 1
2019-08-21 10:18:43 777 335566800 335653140 SQL 58 CALL fas_procedures.get_closest_extreme_eventdates(217999001,335566800,335653140,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **)
2019-08-21 10:18:43 777 335485210 0 SQL 0 SELECT r.mileageDrift, m.isGPSDataValid, m.satellitesNmb, m.latitude, m.longitude FROM fas_analytical_server_core.report_params r JOIN fas_analytical_server_core.mobiledevicedata m USING (vehicleID, eventDate) LEFT JOIN fas_map_processing.track_point_exclusions e USING (vehicleID, eventDate) WHERE r.vehicleID = 217999001 AND r.eventDate = 335485210 AND e.eventDate IS NULL
2019-08-21 10:18:43 777 335566800 335653140 SQL 4 CALL fas_procedures.get_extreme_fuellevels(217999001,335566800,335653140,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **)
2019-08-21 10:18:43 777 335566800 335653140 SQL 2 CALL fas_procedures.get_report_range(217999001, 335566800, 335653140, 'eventDate,step,speed,mileage,mileageSpeeding,movementTime,withoutMovementTime,downTime,workedTime,rpmIdleTime,rpmNormTime,rpmCritTime')
2019-08-21 10:18:43 777 0 335566800 SQL 1 SELECT eventDate FROM fas_analytical_server_core.events WHERE vehicleID = 217999001 and eventDate < 335566800 and  eventTypeID = 1 ORDER BY eventDate desc LIMIT 1
2019-08-21 10:18:43 777 0 335566800 SQL 0 SELECT eventDate FROM fas_analytical_server_core.events WHERE vehicleID = 217999001 and eventDate < 335566800 and  eventTypeID = 2 ORDER BY eventDate desc LIMIT 1
2019-08-21 10:18:43 777 0 335566800 SQL 1 SELECT eventDate FROM fas_analytical_server_core.events WHERE vehicleID = 217999001 and eventDate < 335566800 and  eventTypeID = 3 ORDER BY eventDate desc LIMIT 1
2019-08-21 10:18:43 777 0 335566800 SQL 0 SELECT eventDate FROM fas_analytical_server_core.events WHERE vehicleID = 217999001 and eventDate < 335566800 and  eventTypeID = 4 ORDER BY eventDate desc LIMIT 1
2019-08-21 10:18:43 777 335566800 335653140 SQL 1  SELECT r.eventDate, IFNULL(f.approximatedVolume, f.rawVolume) as fuelLevel, IFNULL(e.eventTypeID, 0) as eventType, r.movementTime, r.workedTime, r.rpmIdleTime, r.rpmNormTime, r.rpmCritTime FROM fas_analytical_server_core.report_params r LEFT JOIN fas_analytical_server_core.fuellevels f ON (f.vehicleID = r.vehicleID AND f.eventDate = r.eventDate) LEFT JOIN fas_analytical_server_core.events e ON (e.vehicleID = r.vehicleID AND e.eventDate = r.eventDate AND e.eventtypeID IN (1, 2, 3, 4)) WHERE r.vehicleID = 217999001 AND NOT f.vehicleID is null AND r.eventDate BETWEEN 335566800 AND 335653140 ORDER BY eventDate
2019-08-21 10:18:43 777 335566800 335653140 SQL 1 SELECT e.eventTypeID, SUM(IFNULL(e.volume, 0)) sumVolume, SUM(IFNULL(e.deliveryVolume, 0)) sumDelivery FROM fas_analytical_server_core.events e WHERE e.vehicleID = 217999001 AND e.eventTypeID in (1,3,15,17,19) AND (e.eventDate BETWEEN  335566800 AND  335653140 ) GROUP BY e.eventTypeID
2019-08-21 10:18:44 777 0 0 SQL 0 select * from periodic_service_counters where vehicleId = 217999001