# Time: 121123 19:56:05.0000999572 # User@Host: root[root] @ [127.0.0.1] # Thread_id: 558036 Schema: test_db Last_errno: 0 Killed: 0 # Query_time: 0.000137 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 # Bytes_sent: 11 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1353700565; use test_db; # Time: 121123 19:56:05.0000999530 # User@Host: root[root] @ [127.0.0.1] # Thread_id: 558033 Schema: test_db Last_errno: 0 Killed: 0 # Query_time: 0.000147 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 # Bytes_sent: 11 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1353700565; use test_db; # Time: 121123 19:56:05.0000999736 # User@Host: root[root] @ [127.0.0.1] # Thread_id: 558031 Schema: test_db Last_errno: 0 Killed: 0 # Query_time: 0.000101 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 # Bytes_sent: 11 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1353700565; use test_db; # Time: 121123 19:56:06.0000001967 # User@Host: root[root] @ [127.0.0.1] # Thread_id: 558038 Schema: test_db Last_errno: 0 Killed: 0 # Query_time: 0.000102 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 # Bytes_sent: 11 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SET timestamp=1353700566; use test_db; # Time: 121123 19:56:06.0000002134 # User@Host: root[root] @ [127.0.0.1] # Thread_id: 558032 Schema: test_db Last_errno: 0 Killed: 0 # Query_time: 0.002515 Lock_time: 0.000197 Rows_sent: 0 Rows_examined: 1 Rows_affected: 1 Rows_read: 0 # Bytes_sent: 52 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: 1E95C1 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages_distinct: 7 SET timestamp=1353700566; update total_balance set bal = bal + -30, points = points + 10 where user_id=102123312;