Как оптимизировать хранимую процедуру?

CREATE TABLE `sh_prod_im` (
  `prod` int(10) unsigned NOT NULL,
  `type` int(10) unsigned NOT NULL,
  `pict` int(10) unsigned NOT NULL,
  `updated` int(1) unsigned default '1',
  PRIMARY KEY (`prod`,`type`,`pict`)
) ENGINE=InnoDB;

DELIMITER $$
CREATE DEFINER=`root`@`%` PROCEDURE `sync_fl`()
BEGIN
  UPDATE `sh_prod_im` SET `updated` = 0;

  INSERT INTO `sh_prod_im` (`prod`,`type`,`pict`) 
    SELECT `prod`,`type`, `pict`
    FROM `sh_prod_im_`
    ON DUPLICATE KEY UPDATE `updated` = 1;

  DELETE FROM `sh_prod_im` WHERE `updated` = 0;
END$$
DELIMITER;

SELECT * FROM `sh_prod_im` WHERE `prod` IN ('.implode(',',$prod_k).') ORDER BY `type`

DELIMITER $$
CREATE DEFINER=`root`@`%` PROCEDURE `sync_fl2`()

BEGIN

DECLARE exit handler for sqlexception
  BEGIN
    -- ERROR
  ROLLBACK;
END;

DECLARE exit handler for sqlwarning
 BEGIN
    -- WARNING
 ROLLBACK;
END;

START TRANSACTION;

  UPDATE `sh_prod_im` SET `updated` = 0;

  INSERT INTO `sh_prod_im` (`prod`,`type`,`pict`) 
    SELECT `prod`,`type`,`pict`
    FROM `sh_prod_im_`
    FOR UPDATE
    ON DUPLICATE KEY UPDATE `updated` = 1;

  DELETE FROM `sh_prod_im` WHERE `updated` = 0;

COMMIT;
END$$
DELIMITER ;

DELIMITER $$
CREATE DEFINER=`root`@`%` PROCEDURE `sync_fl`()
BEGIN

DECLARE exit handler for sqlexception
  BEGIN
    -- ERROR
  ROLLBACK;
END;

DECLARE exit handler for sqlwarning
 BEGIN
    -- WARNING
 ROLLBACK;
END;

START TRANSACTION;
CREATE DEFINER=`root`@`%` PROCEDURE `sync_fl`()
BEGIN
  DROP TABLE IF EXISTS `sh_prod_im__`;
  ALTER TABLE `sh_prod_im` RENAME TO `sh_prod_im__`;
  ALTER TABLE `sh_prod_im_` RENAME TO `sh_prod_im`;
COMMIT;
END$$
DELIMITER ;