Mysql slow query on large table
IDX_2 is the best index for that query when the test for work_id is included.  The ORDER BY is too complex for any index to help.
If you need to exclude work_id, then make an index without it.
The table is probably under 2GB; how big is innodb_buffer_pool_size?
Most of the BIGINTs are likely to be overkill.  Shrinking them from that 8-byte size would shrink the table.  But that probably would not help the 15 seconds much.