SELECT 
  q_images.*, 
  q_images_links.*, 
  q_common_descriptions.description AS alt, 
  q_images.image_id AS images_image_id 
FROM 
  q_images_links 
  LEFT JOIN q_images ON q_images_links.image_id = q_images.image_id 
  LEFT JOIN q_common_descriptions ON q_common_descriptions.object_id = q_images.image_id 
  AND q_common_descriptions.object_holder = 'images' 
  AND q_common_descriptions.lang_code = 'en' 
WHERE 
  q_images_links.object_type = 'product' 
  AND q_images_links.type = 'A' 
  AND q_images_links.object_id IN (
    '47678', 
    '47679', 
    '47680', 
    '47681', 
    '47682', 
    '47683', 
    '47684', 
    '47685', 
    '47686', 
    '47688', 
    '47690', 
    '47691', 
    '47692', 
    '47693', 
    '47694', 
    '47695', 
    '47696', 
    '47697', 
    '47698', 
    '47699', 
    '47700', 
    '47701', 
    '47702', 
    '47703', 
    '47705', 
    '47706', 
    '47707', 
    '47708', 
    '47709', 
    '47710', 
    '47711', 
    '47712', 
    '47714', 
    '47719', 
    '47720', 
    '47721', 
    '47722', 
    '47725', 
    '47730', 
    '47731', 
    '47732', 
    '47733', 
    '47734', 
    '47735', 
    '47736', 
    '47737', 
    '47738', 
    '47739', 
    '47740', 
    '47741', 
    '47742', 
    '47743', 
    '47744', 
    '47745', 
    '47746', 
    '47747', 
    '47748', 
    '47749', 
    '47750', 
    '47751', 
    '47752', 
    '47753', 
    '47754', 
    '47755', 
    '47756', 
    '47757', 
    '47758', 
    '47760', 
    '47761', 
    '47762', 
    '47763', 
    '47764', 
    '47765', 
    '47766', 
    '47767', 
    '47768', 
    '47769', 
    '47770', 
    '47771', 
    '47772', 
    '47773', 
    '47774', 
    '45784', 
    '45785', 
    '45786', 
    '45787', 
    '45788', 
    '45789', 
    '45790', 
    '45791', 
    '45792', 
    '45793', 
    '45794', 
    '45795', 
    '45796', 
    '45797', 
    '45798', 
    '45799', 
    '45800', 
    '45801', 
    '45802', 
    '45803', 
    '45804', 
    '45805', 
    '45806', 
    '45807', 
    '45808', 
    '45809', 
    '45810', 
    '45811', 
    '45812', 
    '45813', 
    '45814', 
    '45815', 
    '45816', 
    '45817', 
    '45818', 
    '45819', 
    '45820', 
    '45821', 
    '45822', 
    '45823', 
    '45824', 
    '45825', 
    '45826', 
    '45827', 
    '45828', 
    '45829'
  ) 
ORDER BY 
  q_images_links.position, 
  q_images_links.pair_id

Query time 0.00472

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "929.61"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "167.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "q_images_links",
            "access_type": "range",
            "possible_keys": [
              "object_id"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type",
              "type"
            ],
            "key_length": "81",
            "rows_examined_per_scan": 167,
            "rows_produced_per_join": 167,
            "filtered": "100.00",
            "index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'A') and (`portal`.`q_images_links`.`object_id` in ('47678','47679','47680','47681','47682','47683','47684','47685','47686','47688','47690','47691','47692','47693','47694','47695','47696','47697','47698','47699','47700','47701','47702','47703','47705','47706','47707','47708','47709','47710','47711','47712','47714','47719','47720','47721','47722','47725','47730','47731','47732','47733','47734','47735','47736','47737','47738','47739','47740','47741','47742','47743','47744','47745','47746','47747','47748','47749','47750','47751','47752','47753','47754','47755','47756','47757','47758','47760','47761','47762','47763','47764','47765','47766','47767','47768','47769','47770','47771','47772','47773','47774','45784','45785','45786','45787','45788','45789','45790','45791','45792','45793','45794','45795','45796','45797','45798','45799','45800','45801','45802','45803','45804','45805','45806','45807','45808','45809','45810','45811','45812','45813','45814','45815','45816','45817','45818','45819','45820','45821','45822','45823','45824','45825','45826','45827','45828','45829')))",
            "cost_info": {
              "read_cost": "328.41",
              "eval_cost": "33.40",
              "prefix_cost": "361.81",
              "data_read_per_join": "15K"
            },
            "used_columns": [
              "pair_id",
              "object_id",
              "object_type",
              "image_id",
              "detailed_id",
              "type",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "q_images",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "image_id"
            ],
            "key_length": "4",
            "ref": [
              "portal.q_images_links.image_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 167,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "167.00",
              "eval_cost": "33.40",
              "prefix_cost": "562.21",
              "data_read_per_join": "127K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res"
            ]
          }
        },
        {
          "table": {
            "table_name": "q_common_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "lang_code",
              "object_holder"
            ],
            "key_length": "107",
            "ref": [
              "portal.q_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 167,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "167.00",
              "eval_cost": "33.40",
              "prefix_cost": "762.61",
              "data_read_per_join": "99K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ],
            "attached_condition": "<if>(is_not_null_compl(q_common_descriptions), (`portal`.`q_common_descriptions`.`object_id` = `portal`.`q_images`.`image_id`), true)"
          }
        }
      ]
    }
  }
}

Result

image_id image_path image_x image_y is_high_res pair_id object_id object_type detailed_id type position alt images_image_id
0 73171 45784 product 75122 A 1
0 73177 45785 product 75128 A 1
0 75196 45788 product 77139 A 1
0 75198 45789 product 77141 A 1
0 75204 45790 product 77147 A 1
0 75208 45787 product 77151 A 1
0 75213 45791 product 77156 A 1
0 75217 45792 product 77160 A 1
0 75220 45793 product 77163 A 1
0 75225 45794 product 77168 A 1
0 75245 45802 product 77188 A 1
0 75249 45803 product 77192 A 1
0 75256 45804 product 77199 A 1
0 75261 45805 product 77204 A 1
0 75263 45806 product 77206 A 1
0 75272 45807 product 77215 A 1
0 75280 45809 product 77223 A 1
0 75282 45810 product 77225 A 1
0 75285 45810 product 77228 A 1
0 75299 45815 product 77242 A 1
0 75306 45818 product 77249 A 1
0 75312 45819 product 77255 A 1
0 75313 45820 product 77256 A 1
0 75319 45821 product 77262 A 1
0 75323 45822 product 77266 A 1
0 75329 45823 product 77272 A 1
0 75332 45825 product 77275 A 1
0 75336 45827 product 77279 A 1
0 75340 45828 product 77283 A 1
0 75345 45829 product 77288 A 1
0 75381 45800 product 77324 A 1
0 75484 45826 product 77427 A 1
0 75496 45812 product 77439 A 1
0 78183 45814 product 80126 A 1
0 78667 47690 product 80610 A 1
0 79094 47746 product 81037 A 1
0 79098 47750 product 81041 A 1
0 79100 47751 product 81043 A 1
0 79102 47752 product 81045 A 1
0 79104 47753 product 81047 A 1
0 79180 47768 product 81123 A 1
0 79182 47769 product 81125 A 1
0 73172 45784 product 75123 A 2
0 75199 45789 product 77142 A 2
0 75205 45790 product 77148 A 2
0 75209 45787 product 77152 A 2
0 75214 45791 product 77157 A 2
0 75221 45793 product 77164 A 2
0 75226 45794 product 77169 A 2
0 75242 45801 product 77185 A 2
0 75246 45802 product 77189 A 2
0 75250 45803 product 77193 A 2
0 75257 45804 product 77200 A 2
0 75264 45806 product 77207 A 2
0 75283 45810 product 77226 A 2
0 75286 45810 product 77229 A 2
0 75289 45813 product 77232 A 2
0 75303 45816 product 77246 A 2
0 75307 45818 product 77250 A 2
0 75315 45820 product 77258 A 2
0 75324 45822 product 77267 A 2
0 75333 45825 product 77276 A 2
0 75337 45827 product 77280 A 2
0 75382 45800 product 77325 A 2
0 75485 45826 product 77428 A 2
0 73173 45784 product 75124 A 3
0 75200 45789 product 77143 A 3
0 75210 45787 product 77153 A 3
0 75269 45807 product 77212 A 3
0 75290 45813 product 77233 A 3
0 75316 45820 product 77259 A 3
0 75334 45825 product 77277 A 3
0 75383 45800 product 77326 A 3
0 75486 45826 product 77429 A 3
0 73174 45784 product 75125 A 4
0 75211 45787 product 77154 A 4
0 75296 45813 product 77239 A 4
0 75384 45800 product 77327 A 4
0 75487 45826 product 77430 A 4
0 73175 45784 product 75126 A 5
0 75488 45826 product 77431 A 5
0 75274 45807 product 77217 A 6
0 75489 45826 product 77432 A 6
0 75271 45807 product 77214 A 7
0 75503 45811 product 77446 A 7
0 75504 45811 product 77447 A 8