Row locking based on index, no index, use table lock

For example, select * from tab_with_index where id = 1 for update; Id is the primary key, and row locks will be used