Debian Codegraph @

test/slow-logs/slow018.log

raw
1 # User@Host: [SQL_SLAVE] @ []
2 # Query_time: 0.000001 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 1
3 # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
4 # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
5 # No InnoDB statistics available for this query
6 use db1;
7 select * from t where id in (1,2,3);
8 # User@Host: [SQL_SLAVE] @ []
9 # Query_time: 0.000512 Lock_time: 0.000000 Rows_sent: 2 Rows_examined: 2
10 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
11 # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
12 # No InnoDB statistics available for this query
13 select * from t where id in (100,200,300);
14 # User@Host: [SQL_SLAVE] @ []
15 # Query_time: 0.000530 Lock_time: 0.000000 Rows_sent: 3 Rows_examined: 3
16 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
17 # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
18 # No InnoDB statistics available for this query
19 select * from t where id in (1000,2000,3000);
20 # User@Host: [SQL_SLAVE] @ []
21 # Query_time: 0.900001 Lock_time: 0.000000 Rows_sent: 4 Rows_examined: 4
22 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
23 # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
24 select * from t where id in (10000,20000,30000);