Enter MySQL script (temp tables/CRUD allowed, 5 sec / 5MB / 20 rows max):
No results are displayed if 5 second timeout reached.
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | v | index | PRIMARY,i_venue_zip | i_venue_zip | 5 | 12 | 100.00 | Using index | ||
| 1 | SIMPLE | z | eq_ref | PRIMARY,i_zip_from_dist_to | PRIMARY | 10 | hshaware_sandbox.v.zipcode,const | 1 | 33.33 | Using where | |
| 1 | SIMPLE | e | ref | i_event_venue | i_event_venue | 4 | hshaware_sandbox.v.id | 1 | 100.00 | Using index |
(3 rows returned)