JOBS TABLE

jobs	CREATE TABLE `jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `driver_id` int(11) NOT NULL,
  `truck_id` int(11) NOT NULL,
  `job_id` int(11) NOT NULL,
  `mileage_start` int(11) NOT NULL,
  `mileage_end` int(11) NOT NULL,
  `mileage_total` int(11) NOT NULL,
  `time` datetime NOT NULL,
  `customer` int(11) NOT NULL,
  `address` text NOT NULL,
  `city` text NOT NULL,
  `state` varchar(255) NOT NULL,
  `zip` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `cc_name` varchar(255) NOT NULL,
  `cc_type` varchar(255) NOT NULL,
  `cc_number` varchar(255) NOT NULL,
  `cc_exp` varchar(255) NOT NULL,
  `cc_ccv` int(11) NOT NULL,
  `cc_zip` int(11) NOT NULL,
  `source` int(11) NOT NULL,
  `item` int(11) NOT NULL,
  `loadsize` varchar(255) NOT NULL,
  `unclosed` enum('Y','N') NOT NULL DEFAULT 'N',
  `notes` text NOT NULL,
  `djid` int(11) DEFAULT NULL,
  `end_time` text NOT NULL,
  `oil_notes` text NOT NULL,
  `view_check` varchar(255) NOT NULL,
  `dumpType` int(11) NOT NULL,
  `fieldTicket` varchar(255) NOT NULL,
  `stamped` enum('NOT STAMPED','RE-STAMPED','STAMPED') NOT NULL DEFAULT 'NOT STAMPED',
  `ticket_received` enum('Y','N') NOT NULL DEFAULT 'N',
  `well_name` varchar(255) NOT NULL,
  `fileLink` text NOT NULL,
  `metric` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `mob_charge` double(10,2) NOT NULL,
  `comp` double(10,2) NOT NULL,
  `mob_hours` double(10,2) NOT NULL,
  `ar` varchar(255) NOT NULL,
  `ap` varchar(255) NOT NULL,
  `report_notes` text NOT NULL,
  `salesman` int(11) NOT NULL,
  `history` text NOT NULL,
  `ticketed` enum('Y','N') NOT NULL DEFAULT 'N',
  `sub_id` int(11) NOT NULL,
  `submetric` varchar(255) NOT NULL,
  `subprice` text NOT NULL,
  `approve_stamp` text NOT NULL,
  `sub_ap` varchar(255) NOT NULL,
  `theDstatus` enum('Picked Up','Dumped') NOT NULL DEFAULT 'Picked Up',
  `theApp` varchar(255) NOT NULL,
  `ponum` varchar(255) NOT NULL,
  `theManifest` varchar(255) NOT NULL,
  `taxregion` int(11) NOT NULL,
  `hauloffID` int(11) NOT NULL DEFAULT '0',
  `rComp` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `driverAppID` int(11) NOT NULL,
  `gpsloc` varchar(255) NOT NULL,
  `projectEnter` bigint(20) NOT NULL,
  `projectExit` bigint(20) NOT NULL,
  `geofence` varchar(10) NOT NULL,
  `projectgps` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `customer` (`customer`),
  KEY `job_id` (`job_id`),
  KEY `ar` (`ar`),
  KEY `ap` (`ap`),
  KEY `ponum` (`ponum`),
  KEY `sub_id` (`sub_id`),
  KEY `salesman` (`salesman`),
  KEY `item` (`item`),
  KEY `source` (`source`),
  KEY `dumpType` (`dumpType`),
  KEY `truck_id` (`truck_id`),
  KEY `driver_id` (`driver_id`)
) ENGINE=InnoDB AUTO_INCREMENT=198515 DEFAULT CHARSET=latin1

DRIVER EVENTS TABLE:

driver_events	CREATE TABLE `driver_events` (
  `driverId` int(11) NOT NULL,
  `eventId` tinyint(1) NOT NULL,
  `time` bigint(20) NOT NULL,
  `location` varchar(45) NOT NULL,
  KEY `driverId` (`driverId`),
  KEY `time` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

EXPLAIN SELECTS:

EXPLAIN SELECT * from jobs WHERE time between '2019-12-11 00:00:00' and '2019-12-17 23:59:59' order by time DESC

1	SIMPLE	jobs	ALL
    NULL

    NULL

    NULL

    NULL
	148787	Using where; Using filesort


EXPLAIN select * from driver_events where driverId = '923' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5

1	SIMPLE	driver_events	index	driverId	time	8
    NULL
	263	Using where