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.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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    220144, 
    215513, 
    215516, 
    220173, 
    215556, 
    215557, 
    215558, 
    215559, 
    215560, 
    215561, 
    215562, 
    215563, 
    215564, 
    215565, 
    215566, 
    215567, 
    215568, 
    215569, 
    243103, 
    243104, 
    243105, 
    243106, 
    220229, 
    217138, 
    217139, 
    217140, 
    217141, 
    220258, 
    218968, 
    218969, 
    218970, 
    220259, 
    218978, 
    218979, 
    218980, 
    220260, 
    218988, 
    218989, 
    218990, 
    220318, 
    215376, 
    215377, 
    228407, 
    228408, 
    228409, 
    228410, 
    228411, 
    228412, 
    228413, 
    230564, 
    230565, 
    230566, 
    230567, 
    230568, 
    230569, 
    233387, 
    233355, 
    233356, 
    233357, 
    233358, 
    233359, 
    233360, 
    238319, 
    238320, 
    233361, 
    241909, 
    233362, 
    233363, 
    233364, 
    233365, 
    233366, 
    241910, 
    233367, 
    233368, 
    233369, 
    233370, 
    233371, 
    233372, 
    233373, 
    233374, 
    241911, 
    233375, 
    241912, 
    233376, 
    233377, 
    233378, 
    233379, 
    233380, 
    241913, 
    233385, 
    233386, 
    242171, 
    242172, 
    242173, 
    242174, 
    233417, 
    233388, 
    233389, 
    233390, 
    233391, 
    233392, 
    233393, 
    233394, 
    238321, 
    238322, 
    233395, 
    241924, 
    233396, 
    233397, 
    233398, 
    233399, 
    233400, 
    241925, 
    233401, 
    233402, 
    233403, 
    233404, 
    233405, 
    233406, 
    233407, 
    233408, 
    241926, 
    233409, 
    241927, 
    233410, 
    233411, 
    233412, 
    233413, 
    233414, 
    241928, 
    233415, 
    233416, 
    242183, 
    242184, 
    242185, 
    242186, 
    233451, 
    233422, 
    233423, 
    233424, 
    233425, 
    233426, 
    233427, 
    233428, 
    238323, 
    238324, 
    233429, 
    241929, 
    233430, 
    233431, 
    233432, 
    233433, 
    233434, 
    241930, 
    233435, 
    233436, 
    233437, 
    233438, 
    233439, 
    233440, 
    233441, 
    233442, 
    241931, 
    233443, 
    241932, 
    233444, 
    233445, 
    233446, 
    233447, 
    233448, 
    241933, 
    233449, 
    233450, 
    242187, 
    242188, 
    242189, 
    242190, 
    233486, 
    233457, 
    233458, 
    233459, 
    233460, 
    233461, 
    233462, 
    233463, 
    238325, 
    238326, 
    233464, 
    241914, 
    233465, 
    233466, 
    233467, 
    233468, 
    233469, 
    241915, 
    233470, 
    233471, 
    233472, 
    233473, 
    233474, 
    233475, 
    233476, 
    233477, 
    241916, 
    233478, 
    241917, 
    233479, 
    233480, 
    233481, 
    233482, 
    233483, 
    241918, 
    233484, 
    233485, 
    242175, 
    242176, 
    242177, 
    242178, 
    233546, 
    233547, 
    233548, 
    233549, 
    240413, 
    240444, 
    240414, 
    240415, 
    240416, 
    240417, 
    240418, 
    240419, 
    240420, 
    241919, 
    240421, 
    240422, 
    240423, 
    240424, 
    240425, 
    241920, 
    240426, 
    240427, 
    240428, 
    240429, 
    240430, 
    240431, 
    240432, 
    240433, 
    241921, 
    240434, 
    241922, 
    240435, 
    240436, 
    240437, 
    240438, 
    240439, 
    241923, 
    240445, 
    240446, 
    242179, 
    242180, 
    242181, 
    242182, 
    240447
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00403

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": 262,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220144,215513,215516,220173,215556,215557,215558,215559,215560,215561,215562,215563,215564,215565,215566,215567,215568,215569,243103,243104,243105,243106,220229,217138,217139,217140,217141,220258,218968,218969,218970,220259,218978,218979,218980,220260,218988,218989,218990,220318,215376,215377,228407,228408,228409,228410,228411,228412,228413,230564,230565,230566,230567,230568,230569,233387,233355,233356,233357,233358,233359,233360,238319,238320,233361,241909,233362,233363,233364,233365,233366,241910,233367,233368,233369,233370,233371,233372,233373,233374,241911,233375,241912,233376,233377,233378,233379,233380,241913,233385,233386,242171,242172,242173,242174,233417,233388,233389,233390,233391,233392,233393,233394,238321,238322,233395,241924,233396,233397,233398,233399,233400,241925,233401,233402,233403,233404,233405,233406,233407,233408,241926,233409,241927,233410,233411,233412,233413,233414,241928,233415,233416,242183,242184,242185,242186,233451,233422,233423,233424,233425,233426,233427,233428,238323,238324,233429,241929,233430,233431,233432,233433,233434,241930,233435,233436,233437,233438,233439,233440,233441,233442,241931,233443,241932,233444,233445,233446,233447,233448,241933,233449,233450,242187,242188,242189,242190,233486,233457,233458,233459,233460,233461,233462,233463,238325,238326,233464,241914,233465,233466,233467,233468,233469,241915,233470,233471,233472,233473,233474,233475,233476,233477,241916,233478,241917,233479,233480,233481,233482,233483,241918,233484,233485,242175,242176,242177,242178,233546,233547,233548,233549,240413,240444,240414,240415,240416,240417,240418,240419,240420,241919,240421,240422,240423,240424,240425,241920,240426,240427,240428,240429,240430,240431,240432,240433,241921,240434,241922,240435,240436,240437,240438,240439,241923,240445,240446,242179,242180,242181,242182,240447)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["image_id"],
      "ref": ["cscart_migrate.cscart_images_links.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_id = cscart_images.image_id)"
    },
    "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": ["cscart_migrate.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))"
    }
  }
}

Result

pair_id object_id object_type image_id detailed_id type position image_type show_gallery gallery_category_id image_path alt image_x image_y images_image_id
33339 215376 variant_image 45572 0 V 0 D 0 0
33340 215377 variant_image 45573 0 V 0 D 0 0
33513 215556 variant_image 45746 0 V 0 D 0 0
33514 215557 variant_image 45747 0 V 0 D 0 0
33515 215558 variant_image 45748 0 V 0 D 0 0
33516 215559 variant_image 45749 0 V 0 D 0 0
33517 215560 variant_image 45750 0 V 0 D 0 0
33518 215561 variant_image 45751 0 V 0 D 0 0
33519 215562 variant_image 45752 0 V 0 D 0 0
33520 215563 variant_image 45753 0 V 0 D 0 0
33521 215564 variant_image 45754 0 V 0 D 0 0
33522 215565 variant_image 45755 0 V 0 D 0 0
33523 215566 variant_image 45756 0 V 0 D 0 0
33524 215567 variant_image 45757 0 V 0 D 0 0
33525 215568 variant_image 45758 0 V 0 D 0 0
33526 215569 variant_image 45759 0 V 0 D 0 0
35343 217138 variant_image 47576 0 V 0 D 0 0
35344 217139 variant_image 47577 0 V 0 D 0 0
35345 217140 variant_image 47578 0 V 0 D 0 0
35346 217141 variant_image 47579 0 V 0 D 0 0
37481 218968 variant_image 49714 0 V 0 D 0 0
37482 218969 variant_image 49715 0 V 0 D 0 0
37483 218970 variant_image 49716 0 V 0 D 0 0
37491 218978 variant_image 49724 0 V 0 D 0 0
37492 218979 variant_image 49725 0 V 0 D 0 0
37493 218980 variant_image 49726 0 V 0 D 0 0
37501 218988 variant_image 49734 0 V 0 D 0 0
37502 218989 variant_image 49735 0 V 0 D 0 0
37503 218990 variant_image 49736 0 V 0 D 0 0
53880 233355 variant_image 66113 0 V 0 D 0 0
53881 233356 variant_image 66114 0 V 0 D 0 0
53882 233357 variant_image 66115 0 V 0 D 0 0
53883 233358 variant_image 66116 0 V 0 D 0 0
53884 233359 variant_image 66117 0 V 0 D 0 0
53885 233360 variant_image 66118 0 V 0 D 0 0
53886 233361 variant_image 66119 0 V 0 D 0 0
53887 233362 variant_image 66120 0 V 0 D 0 0
53888 233363 variant_image 66121 0 V 0 D 0 0
53889 233364 variant_image 66122 0 V 0 D 0 0
53890 233365 variant_image 66123 0 V 0 D 0 0
53891 233366 variant_image 66124 0 V 0 D 0 0
53892 233367 variant_image 66125 0 V 0 D 0 0
53893 233368 variant_image 66126 0 V 0 D 0 0
53894 233369 variant_image 66127 0 V 0 D 0 0
53895 233370 variant_image 66128 0 V 0 D 0 0
53896 233371 variant_image 66129 0 V 0 D 0 0
53897 233372 variant_image 66130 0 V 0 D 0 0
53898 233373 variant_image 66131 0 V 0 D 0 0
53899 233374 variant_image 66132 0 V 0 D 0 0
53900 233375 variant_image 66133 0 V 0 D 0 0
53901 233376 variant_image 66134 0 V 0 D 0 0
53902 233377 variant_image 66135 0 V 0 D 0 0
53903 233378 variant_image 66136 0 V 0 D 0 0
53904 233379 variant_image 66137 0 V 0 D 0 0
53905 233380 variant_image 66138 0 V 0 D 0 0
53910 233385 variant_image 66143 0 V 0 D 0 0
53911 233386 variant_image 66144 0 V 0 D 0 0
53912 233389 variant_image 66145 0 V 0 D 0 0
53913 233390 variant_image 66146 0 V 0 D 0 0
53914 233391 variant_image 66147 0 V 0 D 0 0
53915 233392 variant_image 66148 0 V 0 D 0 0
53916 233393 variant_image 66149 0 V 0 D 0 0
53917 233394 variant_image 66150 0 V 0 D 0 0
53918 233395 variant_image 66151 0 V 0 D 0 0
53919 233396 variant_image 66152 0 V 0 D 0 0
53920 233397 variant_image 66153 0 V 0 D 0 0
53921 233398 variant_image 66154 0 V 0 D 0 0
53922 233399 variant_image 66155 0 V 0 D 0 0
53923 233400 variant_image 66156 0 V 0 D 0 0
53924 233401 variant_image 66157 0 V 0 D 0 0
53925 233402 variant_image 66158 0 V 0 D 0 0
53926 233403 variant_image 66159 0 V 0 D 0 0
53927 233404 variant_image 66160 0 V 0 D 0 0
53928 233405 variant_image 66161 0 V 0 D 0 0
53929 233406 variant_image 66162 0 V 0 D 0 0
53930 233407 variant_image 66163 0 V 0 D 0 0
53931 233408 variant_image 66164 0 V 0 D 0 0
53932 233409 variant_image 66165 0 V 0 D 0 0
53933 233410 variant_image 66166 0 V 0 D 0 0
53934 233411 variant_image 66167 0 V 0 D 0 0
53935 233412 variant_image 66168 0 V 0 D 0 0
53936 233413 variant_image 66169 0 V 0 D 0 0
53937 233414 variant_image 66170 0 V 0 D 0 0
53938 233415 variant_image 66171 0 V 0 D 0 0
53939 233416 variant_image 66172 0 V 0 D 0 0
53955 233423 variant_image 66188 0 V 0 D 0 0
53956 233424 variant_image 66189 0 V 0 D 0 0
53957 233425 variant_image 66190 0 V 0 D 0 0
53958 233426 variant_image 66191 0 V 0 D 0 0
53959 233427 variant_image 66192 0 V 0 D 0 0
53960 233428 variant_image 66193 0 V 0 D 0 0
53961 233429 variant_image 66194 0 V 0 D 0 0
53962 233430 variant_image 66195 0 V 0 D 0 0
53963 233431 variant_image 66196 0 V 0 D 0 0
53964 233432 variant_image 66197 0 V 0 D 0 0
53965 233433 variant_image 66198 0 V 0 D 0 0
53966 233434 variant_image 66199 0 V 0 D 0 0
53967 233435 variant_image 66200 0 V 0 D 0 0
53968 233436 variant_image 66201 0 V 0 D 0 0
53969 233437 variant_image 66202 0 V 0 D 0 0
53970 233438 variant_image 66203 0 V 0 D 0 0
53971 233439 variant_image 66204 0 V 0 D 0 0
53972 233440 variant_image 66205 0 V 0 D 0 0
53973 233441 variant_image 66206 0 V 0 D 0 0
53974 233442 variant_image 66207 0 V 0 D 0 0
53975 233443 variant_image 66208 0 V 0 D 0 0
53976 233444 variant_image 66209 0 V 0 D 0 0
53977 233445 variant_image 66210 0 V 0 D 0 0
53978 233446 variant_image 66211 0 V 0 D 0 0
53979 233447 variant_image 66212 0 V 0 D 0 0
53980 233448 variant_image 66213 0 V 0 D 0 0
53981 233449 variant_image 66214 0 V 0 D 0 0
53982 233450 variant_image 66215 0 V 0 D 0 0
53999 233458 variant_image 66232 0 V 0 D 0 0
54000 233459 variant_image 66233 0 V 0 D 0 0
54001 233460 variant_image 66234 0 V 0 D 0 0
54002 233461 variant_image 66235 0 V 0 D 0 0
54003 233462 variant_image 66236 0 V 0 D 0 0
54004 233463 variant_image 66237 0 V 0 D 0 0
54005 233464 variant_image 66238 0 V 0 D 0 0
54006 233465 variant_image 66239 0 V 0 D 0 0
54007 233466 variant_image 66240 0 V 0 D 0 0
54008 233467 variant_image 66241 0 V 0 D 0 0
54009 233468 variant_image 66242 0 V 0 D 0 0
54010 233469 variant_image 66243 0 V 0 D 0 0
54011 233470 variant_image 66244 0 V 0 D 0 0
54012 233471 variant_image 66245 0 V 0 D 0 0
54013 233472 variant_image 66246 0 V 0 D 0 0
54014 233473 variant_image 66247 0 V 0 D 0 0
54015 233474 variant_image 66248 0 V 0 D 0 0
54016 233475 variant_image 66249 0 V 0 D 0 0
54017 233476 variant_image 66250 0 V 0 D 0 0
54018 233477 variant_image 66251 0 V 0 D 0 0
54019 233478 variant_image 66252 0 V 0 D 0 0
54020 233479 variant_image 66253 0 V 0 D 0 0
54021 233480 variant_image 66254 0 V 0 D 0 0
54022 233481 variant_image 66255 0 V 0 D 0 0
54023 233482 variant_image 66256 0 V 0 D 0 0
54024 233483 variant_image 66257 0 V 0 D 0 0
54025 233484 variant_image 66258 0 V 0 D 0 0
54026 233485 variant_image 66259 0 V 0 D 0 0
54104 233547 variant_image 66337 0 V 0 D 0 0
54105 233548 variant_image 66338 0 V 0 D 0 0
54106 233549 variant_image 66339 0 V 0 D 0 0
62278 238319 variant_image 74511 0 V 0 D 0 0
62279 238320 variant_image 74512 0 V 0 D 0 0
62280 238321 variant_image 74513 0 V 0 D 0 0
62281 238322 variant_image 74514 0 V 0 D 0 0
62282 238323 variant_image 74515 0 V 0 D 0 0
62283 238324 variant_image 74516 0 V 0 D 0 0
62284 238325 variant_image 74517 0 V 0 D 0 0
62285 238326 variant_image 74518 0 V 0 D 0 0
69198 240414 variant_image 81431 0 V 0 D 0 0
69199 240415 variant_image 81432 0 V 0 D 0 0
69200 240416 variant_image 81433 0 V 0 D 0 0
69201 240417 variant_image 81434 0 V 0 D 0 0
69202 240418 variant_image 81435 0 V 0 D 0 0
69203 240419 variant_image 81436 0 V 0 D 0 0
69204 240420 variant_image 81437 0 V 0 D 0 0
69205 240421 variant_image 81438 0 V 0 D 0 0
69206 240422 variant_image 81439 0 V 0 D 0 0
69207 240423 variant_image 81440 0 V 0 D 0 0
69208 240424 variant_image 81441 0 V 0 D 0 0
69209 240425 variant_image 81442 0 V 0 D 0 0
69210 240426 variant_image 81443 0 V 0 D 0 0
69211 240427 variant_image 81444 0 V 0 D 0 0
69212 240428 variant_image 81445 0 V 0 D 0 0
69213 240429 variant_image 81446 0 V 0 D 0 0
69214 240430 variant_image 81447 0 V 0 D 0 0
69215 240431 variant_image 81448 0 V 0 D 0 0
69216 240432 variant_image 81449 0 V 0 D 0 0
69217 240433 variant_image 81450 0 V 0 D 0 0
69218 240434 variant_image 81451 0 V 0 D 0 0
69219 240435 variant_image 81452 0 V 0 D 0 0
69220 240436 variant_image 81453 0 V 0 D 0 0
69221 240437 variant_image 81454 0 V 0 D 0 0
69222 240438 variant_image 81455 0 V 0 D 0 0
69223 240439 variant_image 81456 0 V 0 D 0 0
69228 240446 variant_image 81461 0 V 0 D 0 0
69229 240445 variant_image 81462 0 V 0 D 0 0
71462 241909 variant_image 83695 0 V 0 D 0 0
71463 241910 variant_image 83696 0 V 0 D 0 0
71464 241911 variant_image 83697 0 V 0 D 0 0
71465 241912 variant_image 83698 0 V 0 D 0 0
71466 241913 variant_image 83699 0 V 0 D 0 0
71467 241914 variant_image 83700 0 V 0 D 0 0
71468 241915 variant_image 83701 0 V 0 D 0 0
71469 241916 variant_image 83702 0 V 0 D 0 0
71470 241917 variant_image 83703 0 V 0 D 0 0
71471 241918 variant_image 83704 0 V 0 D 0 0
71472 241919 variant_image 83705 0 V 0 D 0 0
71473 241920 variant_image 83706 0 V 0 D 0 0
71474 241921 variant_image 83707 0 V 0 D 0 0
71475 241922 variant_image 83708 0 V 0 D 0 0
71476 241923 variant_image 83709 0 V 0 D 0 0
71477 241924 variant_image 83710 0 V 0 D 0 0
71478 241925 variant_image 83711 0 V 0 D 0 0
71479 241926 variant_image 83712 0 V 0 D 0 0
71480 241927 variant_image 83713 0 V 0 D 0 0
71481 241928 variant_image 83714 0 V 0 D 0 0
71482 241929 variant_image 83715 0 V 0 D 0 0
71483 241930 variant_image 83716 0 V 0 D 0 0
71484 241931 variant_image 83717 0 V 0 D 0 0
71485 241932 variant_image 83718 0 V 0 D 0 0
71486 241933 variant_image 83719 0 V 0 D 0 0
71734 242171 variant_image 83967 0 V 0 D 0 0
71735 242172 variant_image 83968 0 V 0 D 0 0
71736 242173 variant_image 83969 0 V 0 D 0 0
71737 242174 variant_image 83970 0 V 0 D 0 0
71738 242175 variant_image 83971 0 V 0 D 0 0
71739 242176 variant_image 83972 0 V 0 D 0 0
71740 242179 variant_image 83973 0 V 0 D 0 0
71741 242180 variant_image 83974 0 V 0 D 0 0
71742 242181 variant_image 83975 0 V 0 D 0 0
71743 242182 variant_image 83976 0 V 0 D 0 0
71744 242177 variant_image 83977 0 V 0 D 0 0
71745 242178 variant_image 83978 0 V 0 D 0 0
71746 242183 variant_image 83979 0 V 0 D 0 0
71747 242184 variant_image 83980 0 V 0 D 0 0
71748 242185 variant_image 83981 0 V 0 D 0 0
71749 242186 variant_image 83982 0 V 0 D 0 0
71750 242187 variant_image 83983 0 V 0 D 0 0
71751 242188 variant_image 83984 0 V 0 D 0 0
71752 242189 variant_image 83985 0 V 0 D 0 0
71753 242190 variant_image 83986 0 V 0 D 0 0
72819 243103 variant_image 85052 0 V 0 D 0 0
72820 243104 variant_image 85053 0 V 0 D 0 0
72821 243105 variant_image 85054 0 V 0 D 0 0
72822 243106 variant_image 85055 0 V 0 D 0 0