DROP DATABASE IF EXISTS `my_test`;
CREATE DATABASE `my_test`;
USE `my_test`;

CREATE TABLE `test` (
	`id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
	`size` INT UNSIGNED NOT NULL,
	PRIMARY KEY (`id`)
)ENGINE=Innodb;
insert into my_test.test values(0,100);

SET profiling = 1;
#this update has short query end 
update my_test.test set size=100 where id=1;
#this update has long query end 
update my_test.test set size=size+100 where id=1;
SHOW PROFILE for query 1;
SHOW PROFILE for query 2;
