# Time: 191218 18:17:43
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1661276
# Query_time: 3.904155  Lock_time: 0.000090 Rows_sent: 1  Rows_examined: 33323
SET timestamp=1576693063;
select * from driver_events where driverId = '923' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:17:46
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1661291
# Query_time: 2.246203  Lock_time: 0.000091 Rows_sent: 1  Rows_examined: 59738
SET timestamp=1576693066;
select * from driver_events where driverId = '2069' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:17:54
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1661312
# Query_time: 7.148960  Lock_time: 0.000111 Rows_sent: 1  Rows_examined: 31089
SET timestamp=1576693074;
select * from driver_events where driverId = '1893' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:17:55
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1661287
# Query_time: 11.535992  Lock_time: 0.000086 Rows_sent: 1  Rows_examined: 40875
SET timestamp=1576693075;
select * from driver_events where driverId = '1280' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:17:59
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1661349
# Query_time: 3.423897  Lock_time: 0.000099 Rows_sent: 3  Rows_examined: 69967
SET timestamp=1576693079;
select * from driver_events where driverId = '1972' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1661356
# Query_time: 3.460171  Lock_time: 0.000104 Rows_sent: 3  Rows_examined: 77791
SET timestamp=1576693079;
select * from driver_events where driverId = '1737' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:18:00
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1661371
# Query_time: 3.320515  Lock_time: 0.000079 Rows_sent: 1  Rows_examined: 71310
SET timestamp=1576693080;
select * from driver_events where driverId = '1695' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:18:02
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1661389
# Query_time: 2.049438  Lock_time: 0.000088 Rows_sent: 1  Rows_examined: 42548
SET timestamp=1576693082;
select * from driver_events where driverId = '1349' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1661382
# Query_time: 3.115383  Lock_time: 0.000120 Rows_sent: 5  Rows_examined: 153126
SET timestamp=1576693082;
select * from driver_events where driverId = '1035' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:21
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667026
# Query_time: 3.082379  Lock_time: 0.000119 Rows_sent: 1  Rows_examined: 28823
use driverinterface;
SET timestamp=1576693941;
select * from driver_events where driverId = '2241' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:23
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1666998
# Query_time: 12.204783  Lock_time: 0.000051 Rows_sent: 691  Rows_examined: 187509
SET timestamp=1576693943;
SELECT * from jobs WHERE time between '2019-12-11 00:00:00' and '2019-12-17 23:59:59' order by time DESC LIMIT 0, 1000000;
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667054
# Query_time: 3.137356  Lock_time: 0.000083 Rows_sent: 1  Rows_examined: 19040
SET timestamp=1576693943;
select * from driver_events where driverId = '2101' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:25
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667067
# Query_time: 2.476020  Lock_time: 0.000139 Rows_sent: 1  Rows_examined: 28893
SET timestamp=1576693945;
select * from driver_events where driverId = '2202' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:26
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667035
# Query_time: 7.551598  Lock_time: 0.000121 Rows_sent: 1  Rows_examined: 50054
SET timestamp=1576693946;
select * from driver_events where driverId = '2207' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667019
# Query_time: 10.173921  Lock_time: 0.000127 Rows_sent: 1  Rows_examined: 59738
SET timestamp=1576693946;
select * from driver_events where driverId = '2069' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:27
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667037
# Query_time: 8.113913  Lock_time: 0.000116 Rows_sent: 1  Rows_examined: 31089
SET timestamp=1576693947;
select * from driver_events where driverId = '1893' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667004
# Query_time: 14.157028  Lock_time: 0.000147 Rows_sent: 1  Rows_examined: 40875
SET timestamp=1576693947;
select * from driver_events where driverId = '1280' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:29
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667076
# Query_time: 5.355023  Lock_time: 0.000094 Rows_sent: 1  Rows_examined: 70352
SET timestamp=1576693949;
select * from driver_events where driverId = '1729' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:30
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667095
# Query_time: 3.356466  Lock_time: 0.000136 Rows_sent: 3  Rows_examined: 69967
SET timestamp=1576693950;
select * from driver_events where driverId = '1972' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:31
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667057
# Query_time: 10.537348  Lock_time: 0.000155 Rows_sent: 5  Rows_examined: 153126
SET timestamp=1576693951;
select * from driver_events where driverId = '1035' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:32
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667103
# Query_time: 3.989617  Lock_time: 0.000133 Rows_sent: 1  Rows_examined: 71310
SET timestamp=1576693952;
select * from driver_events where driverId = '1695' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:34
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667110
# Query_time: 4.996127  Lock_time: 0.000129 Rows_sent: 3  Rows_examined: 77791
SET timestamp=1576693954;
select * from driver_events where driverId = '1737' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1667126
# Query_time: 3.920723  Lock_time: 0.000158 Rows_sent: 1  Rows_examined: 42548
SET timestamp=1576693954;
select * from driver_events where driverId = '1349' and FROM_UNIXTIME(time, '%m-%d-%Y') = '12-18-2019' order by time desc limit 0,5;

# Time: 191218 18:32:36
# User@Host: admin[admin] @  [172.31.15.60]  Id: 1666998
# Query_time: 12.474589  Lock_time: 0.000054 Rows_sent: 691  Rows_examined: 187509
SET timestamp=1576693956;
SELECT * from jobs WHERE time between '2019-12-11 00:00:00' and '2019-12-17 23:59:59' order by time DESC;