id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | <derived2> | ALL | 692 | Using temporary; Using filesort | ||||
2 | DERIVED | t | ref | PRIMARY, IDX_FEC530A96CB1415A | IDX_FEC530A96CB1415A | 9 | const | 86 | Using index |
2 | DERIVED | r | ref | IDX_FEC530A96CB1415A, published_at_index, IDX_get_content | IDX_FEC530A96CB1415A | 9 | roofers_staging2.t.id | 8 | Using where |
3 | UNION | t | index_merge | IDX_FEC530A96CB1415A, published_at_index, IDX_get_content | IDX_FEC530A96CB1415A, IDX_get_content | 9, 8 | 5 | Using intersect(IDX_FEC530A96CB1415A, IDX_get_content); Using where | |
UNION RESULT | <union2, 3> | ALL |