有一个循环的查询或使用MySQL（IN）？

Question

Which one of these two methods is faster.

Method A:

for( $i = 0; $i < 10; $i++ )
    // SELECT * FROM table WHERE id = $i ( run and fetch )

Method B:

for( $i = 0; $i < 10; $i++ )
    $ids .= $i . ",";

// SELECT * FROM table WHERE id IN ( $ids ) 

Answer 1

if starting is 0 and ending is 10, then why not use between query

select * from tbl where  id between 0 and 10

i think this will be the fastest