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 | z | range | PRIMARY,i_zip_from_dist_to | i_zip_from_dist_to | 9 | 11 | 100.00 | Using where; Using index | ||
1 | SIMPLE | v | ref | PRIMARY,i_venue_zip | i_venue_zip | 5 | hshaware_sandbox.z.zipcode_to | 1 | 100.00 | Using index | |
1 | SIMPLE | e | ref | i_event_venue | i_event_venue | 4 | hshaware_sandbox.v.id | 1 | 100.00 | Using index |
(3 rows returned)