MySQL performance issue comparing 2 DateTime fields on the same table -
my feed_listingjob has 2 datetime fields: +------------+-------------+------+-----+---------+----------------+ | field | type | null | key | default | | +------------+-------------+------+-----+---------+----------------+ | id | int(11) | no | pri | null | auto_increment | | data | longtext | no | | null | | | meta_data | longtext | no | | null | | | state | varchar(25) | no | | null | | | error | longtext | no | | null | | | job_id | int(11) | no | mul | null | | | created_at | datetime(6) | no | mul | null | | | updated_at | datetime(6) | no | mul | null | | | es_sync_at | datetime(6) | yes | mul | null | | +------------+-------------+------+-----+---------+----------------+ updated_at , es_sync_at both indexed individually below:...