| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s1_ | const | PRIMARY | PRIMARY | 4 | const | 1 | 100 | Using index; Using temporary | |
| 1 | SIMPLE | c2_ | const | PRIMARY | PRIMARY | 4 | const | 1 | 100 | Using index | |
| 1 | SIMPLE | s0_ | index_merge | IDX_A3C664D39162176F, IDX_A3C664D3D2EECC3F | IDX_A3C664D39162176F, IDX_A3C664D3D2EECC3F | 4, 4 | 14 | 98.75 | Using intersect(IDX_A3C664D39162176F, IDX_A3C664D3D2EECC3F); Using where |