42gJYebq

1CREATE TABLE IF NOT EXISTS `jobs` (
2    `job_id` varchar(36) NOT NULL,
3    `job_status` varchar(30) NOT NULL,
4    `created_at` datetime NOT NULL,
5    `lease_date` datetime,
6    `priority` int NOT NULL,
7    PRIMARY KEY(`job_id`),
8    INDEX `job_status_priority_lease_date` (`job_status`, `priority`, `lease_date`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; 
10     
11select * from jobs use index (job_status_priority_lease_date)
12where status="IN_PROGRESS"
13and priority=0
14limit 100