id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | <derived2> | ALL | 9 | Using temporary; Using filesort | ||||
2 | DERIVED | t | ref | PRIMARY, IDX_FEC530A96CB1415A | IDX_FEC530A96CB1415A | 9 | const | 1 | 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 | ref | IDX_FEC530A96CB1415A, published_at_index, IDX_get_content | IDX_FEC530A96CB1415A | 9 | const | 1 | Using where |
UNION RESULT | <union2, 3> | ALL |