By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | user_id |
---|---|
1 | 11 |
2 | 12 |
3 | 13 |
4 | 14 |
5 | 15 |
6 | 16 |
7 | 17 |
8 | 18 |
9 | 19 |
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | u | null | index | null | PRIMARY | 8 | null | 9 | 100.00 | Using where |
3 | DEPENDENT SUBQUERY | users_ids_mapping | null | eq_ref | current_user_id | current_user_id | 9 | fiddle_PZIAQDTCPDICWUPOUJCC.u.user_id | 1 | 100.00 | null |
2 | DEPENDENT SUBQUERY | users_ids_mapping | null | eq_ref | current_user_id | current_user_id | 9 | fiddle_PZIAQDTCPDICWUPOUJCC.u.user_id | 1 | 100.00 | null |
id | user_id |
---|---|
4 | 14 |
5 | 15 |
6 | 16 |
7 | 17 |
8 | 18 |
9 | 19 |
1 | 21 |
2 | 22 |
3 | 23 |
id | user_id |
---|---|
5 | 15 |
8 | 18 |
9 | 19 |
1 | 21 |
2 | 22 |
3 | 23 |
4 | 24 |
6 | 26 |
7 | 27 |
id | user_id |
---|---|
5 | 15 |
1 | 21 |
2 | 22 |
3 | 23 |
4 | 24 |
6 | 26 |
7 | 27 |
8 | 28 |
9 | 29 |