patients and medicals, MySQL

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

CREATE TABLE medicals_mg1
(`id` varchar (50), `control` tinyint(3), `date` datetime, `timestamp` varchar(50));

INSERT INTO medicals_mg1 (`id`, `control`, `date`, `timestamp`)
VALUES ('64f5fac0-96e8-11e6-938b-25cb5cd69242', 0, '2017-02-20 13:24:44', 1487615084580),
('64f5fac0-96e8-11e6-938b-25cb5cd69242', 1, '2017-02-21 18:16:13', 1487718961328),
('64f5fac0-96e8-11e6-938b-25cb5cd69242', 2, '2017-02-21 18:17:22', 1487719042879);

CREATE TABLE patients_mg1
(`_id` varchar(50), `id` varchar(50), `nombres` varchar(70), `numeroDocumento` varchar(50));

INSERT INTO patients_mg1 (`_id`, `id`, `nombres`, `numeroDocumento`)
VALUES ('5808fb0331a4dd0917e0abf1', '64f5fac0-96e8-11e6-938b-25cb5cd69242', 'jose geronimo', '17322147');

SELECT P.id, P.numeroDocumento, P.nombres, M.control
FROM patients_mg1 AS P
INNER JOIN medicals_mg1 AS M
  ON M.id = M.id
WHERE P.numeroDocumento = '17322147'
ORDER BY M.date DESC
LIMIT 1;

DROP TABLE medicals_mg1, patients_mg1;


absolute service time: 0,4 sec