drop procedure if exists ttest;
delimiter //
create procedure ttest()
BEGIN
  DECLARE stime int;
  DECLARE etime int;
  
  /*
    Mark start time.
  */
  select unix_timestamp() into stime;

  /*
    Your query goes here.
  */
  show tables;

  /*
    Mark end time.
  */
  select unix_timestamp() into etime;

  /*
    Calculate time elapsed
    (integer seconds only.)
  */
  select etime-stime as elapsed_time;
END
//
delimiter ;