SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_id AS images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.detailed_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 = 'ar' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    5750, 
    5752, 
    5755, 
    5758, 
    5761, 
    5762, 
    7013, 
    7005, 
    7009, 
    7004, 
    7014, 
    7015, 
    5739, 
    5741, 
    5742, 
    5743, 
    5744, 
    5747, 
    5727, 
    5730, 
    5733, 
    5735, 
    5736, 
    952, 
    446, 
    948, 
    944, 
    947, 
    946, 
    945, 
    981, 
    978, 
    478, 
    975, 
    970, 
    973, 
    974, 
    996, 
    993, 
    493, 
    985, 
    990, 
    987, 
    986, 
    918, 
    924, 
    921, 
    525, 
    916, 
    917, 
    2478, 
    2486, 
    2489, 
    2483, 
    2482, 
    10284, 
    10286, 
    10288, 
    10290, 
    10292, 
    10285, 
    2524, 
    2527, 
    2525, 
    2526, 
    2528, 
    2490, 
    2492, 
    2494, 
    2496, 
    2497, 
    1406, 
    1265, 
    1408, 
    1411, 
    1407, 
    1001, 
    508, 
    1000, 
    999, 
    1266, 
    1439, 
    1442, 
    1447, 
    1445, 
    1446, 
    1428, 
    1261, 
    1426, 
    1430, 
    1429, 
    1263, 
    1454, 
    1456, 
    1458, 
    1453, 
    2468, 
    2469, 
    2471, 
    2472, 
    2576, 
    2577, 
    2578, 
    2615, 
    2620, 
    2621, 
    1256, 
    1397, 
    1395, 
    1396, 
    1323, 
    1319, 
    1318, 
    1262, 
    1317, 
    1273, 
    1421, 
    1423, 
    1420, 
    4526, 
    4528, 
    4530, 
    4532, 
    4527, 
    2502, 
    3639, 
    2473, 
    2475, 
    2476, 
    2477, 
    2534, 
    2564, 
    2565, 
    2579, 
    2580, 
    2550, 
    2544, 
    2552, 
    2549, 
    2596, 
    2599, 
    2601, 
    2598, 
    2503, 
    2504, 
    2505, 
    2602, 
    2604, 
    2607, 
    2608, 
    3049, 
    3050, 
    3051, 
    2538, 
    2540, 
    2541, 
    3048, 
    3047, 
    3046, 
    3053, 
    3054, 
    4775, 
    4767, 
    4771, 
    4773, 
    4770, 
    2685, 
    2686, 
    2687, 
    2623, 
    2624, 
    2626, 
    5041, 
    5037, 
    8417, 
    8419, 
    8421, 
    8398, 
    8415, 
    4744, 
    4746, 
    4748, 
    4750, 
    4745, 
    2499, 
    2500, 
    3055, 
    3058, 
    3059, 
    2581, 
    2585, 
    2586, 
    2631, 
    2632, 
    2633, 
    2517, 
    2518, 
    2519, 
    8399, 
    8476, 
    8477, 
    4788, 
    4789, 
    4790, 
    5031, 
    5027, 
    10140, 
    10142, 
    10144, 
    10141, 
    10224, 
    10223, 
    10222, 
    10228, 
    10229, 
    10230, 
    10435, 
    10861, 
    10395, 
    10396, 
    10233, 
    10234
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00708

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1010.11"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "444.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_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": 444,
            "rows_produced_per_join": 444,
            "filtered": "100.00",
            "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_images_links`.`object_type` = 'product') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_images_links`.`type` = 'M') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_images_links`.`object_id` in (5750,5752,5755,5758,5761,5762,7013,7005,7009,7004,7014,7015,5739,5741,5742,5743,5744,5747,5727,5730,5733,5735,5736,952,446,948,944,947,946,945,981,978,478,975,970,973,974,996,993,493,985,990,987,986,918,924,921,525,916,917,2478,2486,2489,2483,2482,10284,10286,10288,10290,10292,10285,2524,2527,2525,2526,2528,2490,2492,2494,2496,2497,1406,1265,1408,1411,1407,1001,508,1000,999,1266,1439,1442,1447,1445,1446,1428,1261,1426,1430,1429,1263,1454,1456,1458,1453,2468,2469,2471,2472,2576,2577,2578,2615,2620,2621,1256,1397,1395,1396,1323,1319,1318,1262,1317,1273,1421,1423,1420,4526,4528,4530,4532,4527,2502,3639,2473,2475,2476,2477,2534,2564,2565,2579,2580,2550,2544,2552,2549,2596,2599,2601,2598,2503,2504,2505,2602,2604,2607,2608,3049,3050,3051,2538,2540,2541,3048,3047,3046,3053,3054,4775,4767,4771,4773,4770,2685,2686,2687,2623,2624,2626,5041,5037,8417,8419,8421,8398,8415,4744,4746,4748,4750,4745,2499,2500,3055,3058,3059,2581,2585,2586,2631,2632,2633,2517,2518,2519,8399,8476,8477,4788,4789,4790,5031,5027,10140,10142,10144,10141,10224,10223,10222,10228,10229,10230,10435,10861,10395,10396,10233,10234)))",
            "cost_info": {
              "read_cost": "210.91",
              "eval_cost": "44.40",
              "prefix_cost": "255.31",
              "data_read_per_join": "41K"
            },
            "used_columns": [
              "pair_id",
              "object_id",
              "object_type",
              "image_id",
              "detailed_id",
              "type",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_images",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "image_id"
            ],
            "key_length": "4",
            "ref": [
              "softwarepirmam_hewadelivard_cscart_4.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 444,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "111.00",
              "eval_cost": "44.40",
              "prefix_cost": "410.71",
              "data_read_per_join": "343K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res",
              "transparent",
              "cp_in_opt_list"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_common_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "lang_code",
              "object_holder"
            ],
            "key_length": "108",
            "ref": [
              "softwarepirmam_hewadelivard_cscart_4.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 444,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "111.00",
              "eval_cost": "44.40",
              "prefix_cost": "566.11",
              "data_read_per_join": "263K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}