id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY w ALL NULL NULL NULL NULL 10 Using temporary; Using filesort
1 PRIMARY <derived2> ALL NULL NULL NULL NULL 10
1 PRIMARY <derived4> ALL NULL NULL NULL NULL 10
1 PRIMARY <derived6> ALL NULL NULL NULL NULL 4
6 DERIVED sw range dashboard_status_index2 dashboard_status_index2 8 NULL 5623 Using where; Using temporary; Using filesort
4 DERIVED <derived5> ALL NULL NULL NULL NULL 10 Using temporary; Using filesort
4 DERIVED sw ref dashboard_status_index,dashboard_status_index2 dashboard_status_index 13 sw2.worker_id,sw2.latest 1
4 DERIVED p eq_ref PRIMARY PRIMARY 4 proxyminer.sw.pool_id 1
5 DERIVED submitted_work range NULL dashboard_status_index 5 NULL 11 Using where; Using index for group-by
2 DERIVED <derived3> ALL NULL NULL NULL NULL 10 Using temporary; Using filesort
2 DERIVED wd ref PRIMARY,worker_time worker_time 12 wd2.worker_id,wd2.latest 1
2 DERIVED p eq_ref PRIMARY PRIMARY 4 proxyminer.wd.pool_id 1
3 DERIVED work_data range NULL worker_time 4 NULL 11 Using index for group-by