| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | k | ALL | TABLE_SCHEMA, TABLE_NAME | Using where; Open_full_table; Scanned 0 databases; Using temporary | ||||||
| 1 | SIMPLE | c | ALL | CONSTRAINT_SCHEMA, TABLE_NAME | Using where; Open_full_table; Scanned 0 databases; Using join buffer (Block Nested Loop) |