Sandbox

SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  cscart_images.image_id AS images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id 
  LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id 
  AND cscart_common_descriptions.object_holder = 'images' 
  AND cscart_common_descriptions.lang_code = 'en' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    '5033', 
    '5034', 
    '5035', 
    '5036', 
    '5037', 
    '5038', 
    '5039', 
    '5040', 
    '5041', 
    '5042', 
    '5043', 
    '5044', 
    '5045', 
    '5046', 
    '5047', 
    '5048', 
    '5049', 
    '5050', 
    '5051', 
    '5052', 
    '5093', 
    '5094', 
    '5095', 
    '5096', 
    '5097', 
    '5098', 
    '5099', 
    '5100', 
    '5101', 
    '5102', 
    '5103', 
    '5104', 
    '5105', 
    '5106', 
    '5107', 
    '5108', 
    '5109', 
    '5110', 
    '5111', 
    '5112', 
    '5133', 
    '5134', 
    '5135', 
    '5136', 
    '5137', 
    '5138', 
    '5139', 
    '5140', 
    '5141', 
    '5142', 
    '5143', 
    '5144', 
    '5145', 
    '5146', 
    '5147', 
    '5148', 
    '5149', 
    '5150', 
    '5151', 
    '5152', 
    '5230', 
    '5231', 
    '5232', 
    '5233', 
    '5234', 
    '5235', 
    '5236', 
    '5237', 
    '5238', 
    '5239', 
    '5240', 
    '5241', 
    '5242', 
    '5243', 
    '5244', 
    '5245', 
    '5246', 
    '5281', 
    '5282', 
    '5283', 
    '5284', 
    '5285', 
    '5286', 
    '5287', 
    '5288', 
    '5289', 
    '5290', 
    '5291', 
    '5292', 
    '5293', 
    '5294', 
    '5295', 
    '5296', 
    '5297', 
    '5315', 
    '5316', 
    '5317', 
    '5318', 
    '5319', 
    '5320', 
    '5321', 
    '5322', 
    '5323', 
    '5324', 
    '5325', 
    '5326', 
    '5327', 
    '5328', 
    '5329', 
    '5330', 
    '5331', 
    '5392', 
    '5393', 
    '5394', 
    '5395', 
    '5396', 
    '5397', 
    '5398', 
    '5399', 
    '5400', 
    '5419', 
    '5420', 
    '5421', 
    '5422', 
    '5423', 
    '5424', 
    '5425', 
    '5426', 
    '5427', 
    '5437', 
    '5438', 
    '5439', 
    '5440', 
    '5441', 
    '5442', 
    '5443', 
    '5444', 
    '5445', 
    '5477', 
    '5478', 
    '5479', 
    '5480', 
    '5489', 
    '5490', 
    '5491', 
    '5492', 
    '5497', 
    '5498', 
    '5499', 
    '5500', 
    '5521', 
    '5522', 
    '5523', 
    '5524', 
    '5525', 
    '5526', 
    '5527', 
    '5528', 
    '5545', 
    '5546', 
    '5547', 
    '5548', 
    '5549', 
    '5550', 
    '5551', 
    '5552', 
    '5561', 
    '5562', 
    '5563', 
    '5564', 
    '5565', 
    '5566', 
    '5567', 
    '5568', 
    '5597', 
    '5598', 
    '5599', 
    '5600', 
    '5609', 
    '5610', 
    '5611', 
    '5612', 
    '5617', 
    '5618', 
    '5619', 
    '5620', 
    '5652', 
    '5653', 
    '5654', 
    '5655', 
    '5656', 
    '5657', 
    '5658', 
    '5659', 
    '5660', 
    '5661', 
    '5662', 
    '5663', 
    '5664', 
    '5665', 
    '5666', 
    '5667', 
    '5668', 
    '5669', 
    '5670', 
    '5709', 
    '5710', 
    '5711', 
    '5712', 
    '5713', 
    '5714', 
    '5715', 
    '5716', 
    '5717', 
    '5718', 
    '5719', 
    '5720', 
    '5721', 
    '5722', 
    '5723', 
    '5724', 
    '5725', 
    '5726', 
    '5727', 
    '5747', 
    '5748', 
    '5749', 
    '5750', 
    '5751', 
    '5752', 
    '5753', 
    '5754', 
    '5755', 
    '5756', 
    '5757', 
    '5758', 
    '5759', 
    '5760', 
    '5761', 
    '5762', 
    '5763', 
    '5764', 
    '5765'
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00140

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
        "table": {
          "table_name": "cscart_images_links",
          "access_type": "range",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "rows": 243,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in ('5033','5034','5035','5036','5037','5038','5039','5040','5041','5042','5043','5044','5045','5046','5047','5048','5049','5050','5051','5052','5093','5094','5095','5096','5097','5098','5099','5100','5101','5102','5103','5104','5105','5106','5107','5108','5109','5110','5111','5112','5133','5134','5135','5136','5137','5138','5139','5140','5141','5142','5143','5144','5145','5146','5147','5148','5149','5150','5151','5152','5230','5231','5232','5233','5234','5235','5236','5237','5238','5239','5240','5241','5242','5243','5244','5245','5246','5281','5282','5283','5284','5285','5286','5287','5288','5289','5290','5291','5292','5293','5294','5295','5296','5297','5315','5316','5317','5318','5319','5320','5321','5322','5323','5324','5325','5326','5327','5328','5329','5330','5331','5392','5393','5394','5395','5396','5397','5398','5399','5400','5419','5420','5421','5422','5423','5424','5425','5426','5427','5437','5438','5439','5440','5441','5442','5443','5444','5445','5477','5478','5479','5480','5489','5490','5491','5492','5497','5498','5499','5500','5521','5522','5523','5524','5525','5526','5527','5528','5545','5546','5547','5548','5549','5550','5551','5552','5561','5562','5563','5564','5565','5566','5567','5568','5597','5598','5599','5600','5609','5610','5611','5612','5617','5618','5619','5620','5652','5653','5654','5655','5656','5657','5658','5659','5660','5661','5662','5663','5664','5665','5666','5667','5668','5669','5670','5709','5710','5711','5712','5713','5714','5715','5716','5717','5718','5719','5720','5721','5722','5723','5724','5725','5726','5727','5747','5748','5749','5750','5751','5752','5753','5754','5755','5756','5757','5758','5759','5760','5761','5762','5763','5764','5765')"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["image_id"],
      "ref": ["rfswire_cart.cscart_images_links.image_id"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_common_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "107",
      "used_key_parts": ["object_id", "lang_code", "object_holder"],
      "ref": ["rfswire_cart.cscart_images.image_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_common_descriptions.object_id = cscart_images.image_id and cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'en' and trigcond(cscart_images.image_id is not null))"
    }
  }
}