SELECT `id`, `asin`, `marketplace_id`
FROM `repricing_product`
WHERE
  (`marketplace_id` = 10 AND `asin` IN ('value',.....)) OR 
  (`marketplace_id` =  2 AND `asin` IN ('value',.....)) OR   
  (`marketplace_id` =  3 AND `asin` IN ('value',.....)) OR 
  (`marketplace_id` =  1 AND `asin` IN ('value',.....)) OR 
  (`marketplace_id` =  7 AND `asin` IN ('value',.....)) OR 
  (`marketplace_id` =  8 AND `asin` IN ('value',.....)) OR 
  (`marketplace_id` =  5 AND `asin` IN ('value',.....)) OR 
  (`marketplace_id` =  4 AND `asin` IN ('value',.....))

SELECT `id`, `asin`, `marketplace_id`
FROM `repricing_product`
WHERE
  (`asin`, `marketplace_id`) IN
  (
    ('value',10),....,
    ('value',2),....,
    ('value',3),....,
    ('value',1),....,
    ('value',7),....,
    ('value',8),....,
    ('value',5),....,
    ('value',4),....
  )

CREATE TABLE `repricing_product` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `asin` char(10) NOT NULL,
  `marketplace_id` tinyint(3) unsigned NOT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_asin_marketplace_id` (`asin`,`marketplace_id`),
  KEY `idx_marketplace_id` (`marketplace_id`),
  CONSTRAINT `repricing_product_ibfk_1` FOREIGN KEY (`marketplace_id`) REFERENCES `repricing_marketplace` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9141910 DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=55

CREATE TEMPORARY TABLE `product` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `asin` char(10) NOT NULL,
  `marketplace_id` tinyint(3) unsigned NOT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_asin_marketplace_id` (`asin`,`marketplace_id`),
  KEY `idx_marketplace_id` (`marketplace_id`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `product` (id, asin, marketplace_id)
VALUES
  (7799199, '0001374354', 10),
  (8943063, '0001712713', 10),
  (6030237, '0001839225', 2),
  (8421613, '0002110385', 2),
  (4599181, '000330230X', 3),
  (4395135, '0006176666', 1),
  (3383439, '0006371949', 5),
  (4395273, '0006514391', 1),
  (3383519, '0007103077', 5),
  (6861881, '0007103077', 7),
  (6248157, '0007106777', 8),
  (4599443, '0007115164', 3),
  (3261315, '0007185928', 8),
  (6862551, '000719031X', 7),
  (8478771, 'B003G53VSO', 4),
  (8478379, 'B004DK434C', 4);



SELECT `id`, `asin`, `marketplace_id`
FROM `product`
WHERE
  (`marketplace_id` = 10 AND `asin` IN ('0001374354','0001712713')) OR 
  (`marketplace_id` =  2 AND `asin` IN ('0001839225','0002110385')) OR   
  (`marketplace_id` =  3 AND `asin` IN ('000330230X','0007115164')) OR 
  (`marketplace_id` =  1 AND `asin` IN ('0006176666','0006514391')) OR 
  (`marketplace_id` =  7 AND `asin` IN ('0007103077','000719031X')) OR 
  (`marketplace_id` =  8 AND `asin` IN ('0007106777','0007185928')) OR 
  (`marketplace_id` =  5 AND `asin` IN ('0006371949','0007103077')) OR 
  (`marketplace_id` =  4 AND `asin` IN ('B003G53VSO','B004DK434C'));
  
  
SELECT `id`, `asin`, `marketplace_id`
FROM `product`
WHERE
  (`asin`,`marketplace_id`) IN
  (
    ('0001374354',10),('0001712713',10),
    ('0001839225',2),('0002110385',2),
    ('000330230X',3),('0007115164',3),
    ('0006176666',1),('0006514391',1),
    ('0007103077',7),('000719031X',7),
    ('0007106777',8),('0007185928',8),
    ('0006371949',5),('0007103077',5),
    ('B003G53VSO',4),('B004DK434C',4)
  );