1R9GKu5G

1CREATE TABLE IF NOT EXISTS `jobs` (
2    `job_id` varchar(36) NOT NULL,
3    `job_status` varchar(30) NOT NULL,
4    `lease_date` datetime,
5    `priority` int NOT NULL,
6    PRIMARY KEY(`job_id`),
7    INDEX `job_status_priority_lease_date` (`job_status`, `priority`, `lease_date`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 
9     
10select * from jobs 
11where job_status="IN_PROGRESS"
12and lease_date<"10minutesago"
13order by priority
14limit 100 
15     
16select * from jobs 
17where job_status="IN_PROGRESS"
18and lease_date<"10minutesago"
19order by priority DESC
20limit 100