id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | b0_ | ref | PRIMARY, content_type_idx, status_idx | content_type_idx | 766 | const | 4 | 100.00 | Using where; Using filesort | |
1 | SIMPLE | b1_ | ref | PRIMARY, IDX_4A2EBBE584A0A3ED, IDX_4A2EBBE5727ACA70 | IDX_4A2EBBE584A0A3ED | 4 | web4_sustain.b0_.id | 9 | 3.18 | Using where | |
1 | SIMPLE | b2_ | ref | field_translation_unique_translation, IDX_5C60C0542C2AC5D3 | field_translation_unique_translation | 5 | web4_sustain.b1_.id | 2 | 100.00 | Using where |