| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a0_ | ALL | PRIMARY | 1 | 100 | Using where; Using temporary; Using filesort | ||||
| 1 | SIMPLE | a1_ | eq_ref | app_tag_translation_uniq_trans, IDX_F27A1A062C2AC5D3 | app_tag_translation_uniq_trans | 771 | open_marketplace.a0_.id, const | 1 | 100 |