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.detailed_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 (
    '10499', '10500', '10501', '10502', 
    '10503', '10504', '10505', '10506', 
    '10507', '10508', '10509', '10510', 
    '10511', '10512', '10513', '10514'
  ) 
ORDER BY 
  q_images_links.position, 
  q_images_links.pair_id

Query time 0.00157

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "131.21"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "24.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": 24,
            "rows_produced_per_join": 24,
            "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 ('10499','10500','10501','10502','10503','10504','10505','10506','10507','10508','10509','10510','10511','10512','10513','10514')))",
            "cost_info": {
              "read_cost": "44.81",
              "eval_cost": "4.80",
              "prefix_cost": "49.61",
              "data_read_per_join": "2K"
            },
            "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.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 24,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "24.00",
              "eval_cost": "4.80",
              "prefix_cost": "78.41",
              "data_read_per_join": "18K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res"
            ],
            "attached_condition": "<if>(is_not_null_compl(q_images), (`portal`.`q_images_links`.`detailed_id` = `portal`.`q_images`.`image_id`), true)"
          }
        },
        {
          "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": 24,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "24.00",
              "eval_cost": "4.80",
              "prefix_cost": "107.21",
              "data_read_per_join": "14K"
            },
            "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 41ug0xSrYOL._SX342_.jpg 342 342 N 21518 10510 product 23480 A 1 23480
0 xiaomi-mitu-building-blocks-mining-truck-l.jpg 840 463 N 26761 10505 product 28723 A 2 28723
0 71y78Mdkv7L._SL1500_.jpg 1500 844 N 21807 10500 product 23769 A 10 23769
0 31yJPfaOT8L.jpg 500 407 N 21810 10501 product 23772 A 10 23772
0 51fXv6lxhqL._SL1440_.jpg 1280 1440 N 21813 10502 product 23775 A 10 23775
0 41CoF_3_GRL.jpg 500 500 N 21816 10503 product 23778 A 10 23778
0 31_n1hOrvCL.jpg 500 292 N 21819 10504 product 23781 A 10 23781
0 41tF_Jdz3oL._SL1000_.jpg 1000 1000 N 21822 10506 product 23784 A 10 23784
0 4132bqdGMiL._SX342_.jpg 342 429 N 21825 10508 product 23787 A 10 23787
0 41K-tKJe2pL._SX342_.jpg 342 342 N 21827 10509 product 23789 A 10 23789
0 31b4W2iGRZL._SX342_.jpg 342 346 N 21830 10511 product 23792 A 10 23792
0 51Otg6DShQL._SX342_.jpg 342 342 N 21831 10512 product 23793 A 10 23793
0 41G7vZkBHSL._SY445_.jpg 319 445 N 21832 10513 product 23794 A 10 23794
0 4142_teh5rL._SX342_.jpg 342 342 N 21833 10514 product 23795 A 10 23795
0 417N-ixxA_L.jpg 500 500 N 21808 10500 product 23770 A 20 23770
0 51E6SZ8iUHL._SL1200_.jpg 1200 1200 N 21811 10501 product 23773 A 20 23773
0 51Y03dnnKKL._SL1440_.jpg 1280 1440 N 21814 10502 product 23776 A 20 23776
0 41urGZS3-7L.jpg 500 500 N 21817 10503 product 23779 A 20 23779
0 7165e67Yc_L._SL1500_.jpg 1500 763 N 21820 10504 product 23782 A 20 23782
0 51whV5bk5EL._SL1000_.jpg 1000 1000 N 21823 10506 product 23785 A 20 23785
0 41mvpR_r6WL._SX342_.jpg 342 429 N 21826 10508 product 23788 A 20 23788
0 41NlSyrQvcL._SX342_.jpg 342 342 N 21828 10509 product 23790 A 20 23790
0 41mnlsMfCUL._SX342_.jpg 342 342 N 21834 10514 product 23796 A 20 23796
0 41fV_4tIsSL.jpg 500 500 N 21809 10500 product 23771 A 30 23771
0 61PgtOxbnGL._SL1500__zn07-5j.jpg 1500 595 N 21812 10501 product 23774 A 30 23774
0 711PZD-TjoL._SL1500_.jpg 1500 554 N 21815 10502 product 23777 A 30 23777
0 51-xk3ObmCL.jpg 500 500 N 21818 10503 product 23780 A 30 23780
0 816obpjphDL._SL1500_.jpg 1500 890 N 21821 10504 product 23783 A 30 23783
0 31X_8QIe7EL.jpg 500 500 N 21824 10506 product 23786 A 30 23786
0 41m0MYFlvRL._SX342_.jpg 342 342 N 21829 10509 product 23791 A 30 23791
0 41MOkuZG2PL._SX342_.jpg 342 342 N 21835 10514 product 23797 A 30 23797