USE `test`;
CREATE TABLE `ololo` (
	`id` INT(11) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `trololo` (
	`id` INT(11) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
INSERT INTO `test`.`ololo` (`id`) VALUES (1);
INSERT INTO `test`.`trololo` (`id`) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
delimiter //
CREATE DEFINER=`root`@`%` PROCEDURE `sp_ololo`(IN `Param1` VARCHAR(255))
	LANGUAGE SQL
	NOT DETERMINISTIC
	READS SQL DATA
	SQL SECURITY DEFINER
	COMMENT ''
BEGIN
declare str varchar(255);
set @str = concat("select * from ololo where id=",Param1);
prepare stmt from @str;
execute stmt;
deallocate prepare stmt;
END//
delimiter ;
call sp_ololo('1'); -- моментально
call sp_ololo('(
select q1.id
from trololo q1
cross join trololo q2
cross join trololo q3
cross join trololo q4
cross join trololo q5
cross join trololo q6
order by rand()
limit 1
)') -- занимает несколько сеунд