Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Exec Time min/max/avg (seconds): 0.6/1.1/0.7
- +----+--------------------+---------------------+----------------+-----------------+----------------------+---------+-----------------------------------+------+----------------------------------------------+
- | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
- +----+--------------------+---------------------+----------------+-----------------+----------------------+---------+-----------------------------------+------+----------------------------------------------+
- | 1 | PRIMARY | users | index | NULL | pager_first_last_idx | 318 | NULL | 2247 | Using index; Using temporary; Using filesort |
- | 1 | PRIMARY | shifts_users | ref | user_id_fk_idx | user_id_fk_idx | 4 | sentact_nmh.users.id | 9 | Distinct |
- | 1 | PRIMARY | shifts | eq_ref | PRIMARY | PRIMARY | 4 | sentact_nmh.shifts_users.shift_id | 1 | Distinct |
- | 1 | PRIMARY | company_permissions | ref | PRIMARY | PRIMARY | 4 | sentact_nmh.users.id | 7 | Using where; Distinct |
- | 2 | DEPENDENT SUBQUERY | shift_times | index_subquery | shift_id_fk_idx | shift_id_fk_idx | 4 | func | 3 | Using where |
- +----+--------------------+---------------------+----------------+-----------------+----------------------+---------+-----------------------------------+------+----------------------------------------------+
Add Comment
Please, Sign In to add comment