Skip to content

Instantly share code, notes, and snippets.

@santiagobasulto
Created May 18, 2012 14:49
Show Gist options
  • Select an option

  • Save santiagobasulto/2725653 to your computer and use it in GitHub Desktop.

Select an option

Save santiagobasulto/2725653 to your computer and use it in GitHub Desktop.
+----+-------------+-------+--------+------------------------+------------------------+---------+-------------------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+--------+------------------------+------------------------+---------+-------------------+------+----------------------------------------------+
| 1 | SIMPLE | w | index | stats_workout_fbfc09f1 | stats_workout_fbfc09f1 | 4 | NULL | 32 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | pr | eq_ref | user_id | user_id | 4 | athlete.w.user_id | 1 | Using index |
| 1 | SIMPLE | p | ref | workout_id | workout_id | 5 | athlete.w.id | 1 | Using index |
| 1 | SIMPLE | c | ALL | NULL | NULL | NULL | NULL | 20 | |
+----+-------------+-------+--------+------------------------+------------------------+---------+-------------------+------+----------------------------------------------+
4 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment