| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | p0_ | ref | PRIMARY, IDX_AF3C677912469DE2, IDX_AF3C6779C5253849, IDX_AF3C6779A9CED711, IDX_AF3C677961220EA6 | IDX_AF3C677912469DE2 | 5 | const | 10 | 100.00 | Using temporary; Using filesort | |
| 1 | SIMPLE | p1_ | ref | publication_translation_unique_translation, IDX_630AE0C42C2AC5D3 | IDX_630AE0C42C2AC5D3 | 5 | viewpoint_dev.p0_.id | 1 | 100.00 | Using index | |
| 1 | SIMPLE | p2_ | eq_ref | PRIMARY | PRIMARY | 4 | viewpoint_dev.p0_.publication_category_id | 1 | 100.00 |