| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | g | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | ||
| 1 | SIMPLE | c | const | PRIMARY, UNIQ_6D773021E48FD905 | UNIQ_6D773021E48FD905 | 4 | const | 1 | 100.00 | Using index | |
| 1 | SIMPLE | cp | const | PRIMARY, IDX_8E24BB624EE93BE6, IDX_8E24BB6299E6F5DF | PRIMARY | 8 | const, const | 1 | 100.00 | ||
| 1 | SIMPLE | gps | index_merge | FK_E0962C163BD0B512, FK_E0962C16E48FD913 | FK_E0962C163BD0B512, FK_E0962C16E48FD913 | 4, 4 | 1 | 100.00 | Using intersect(FK_E0962C163BD0B512, FK_E0962C16E48FD913); Using where | ||
| 1 | SIMPLE | ga | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |