# User@Host: [SQL_SLAVE] @ [] # Query_time: 0.000001 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 1 # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No # Filesort: Yes Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query use db1; select * from t where id in (1,2,3); # User@Host: [SQL_SLAVE] @ [] # Query_time: 0.000512 Lock_time: 0.000000 Rows_sent: 2 Rows_examined: 2 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Tmp_table_on_disk: No # Filesort: Yes Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query select * from t where id in (100,200,300); # User@Host: [SQL_SLAVE] @ [] # Query_time: 0.000530 Lock_time: 0.000000 Rows_sent: 3 Rows_examined: 3 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: Yes Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query select * from t where id in (1000,2000,3000); # User@Host: [SQL_SLAVE] @ [] # Query_time: 0.900001 Lock_time: 0.000000 Rows_sent: 4 Rows_examined: 4 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: Yes Filesort_on_disk: No Merge_passes: 0 select * from t where id in (10000,20000,30000);