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 (
    219927, 
    219928, 
    219929, 
    220114, 
    219894, 
    219895, 
    219896, 
    219897, 
    220135, 
    244918, 
    244919, 
    244920, 
    244921, 
    244922, 
    244923, 
    244924, 
    244925, 
    217391, 
    217392, 
    217393, 
    217394, 
    217395, 
    217396, 
    236870, 
    236871, 
    217397, 
    245301, 
    241058, 
    219829, 
    217398, 
    217399, 
    217400, 
    217401, 
    241059, 
    217402, 
    217403, 
    217404, 
    217405, 
    217406, 
    217407, 
    217408, 
    217409, 
    241060, 
    217410, 
    241061, 
    217411, 
    217412, 
    245302, 
    245303, 
    225914, 
    217413, 
    217414, 
    245304, 
    241062, 
    217415, 
    217416, 
    217417, 
    217418, 
    217419, 
    220215, 
    219660, 
    219661, 
    220216, 
    218424, 
    218425, 
    220221, 
    219662, 
    244926, 
    244927, 
    244928, 
    244929, 
    244930, 
    244931, 
    244932, 
    244933, 
    220222, 
    219675, 
    219676, 
    219677, 
    219678, 
    219679, 
    219680, 
    219681, 
    236932, 
    236933, 
    219682, 
    245305, 
    241063, 
    219683, 
    219684, 
    219685, 
    219686, 
    219687, 
    241064, 
    219688, 
    219689, 
    219690, 
    219691, 
    219692, 
    219693, 
    219694, 
    219695, 
    241065, 
    219696, 
    241066, 
    219697, 
    219698, 
    245306, 
    245307, 
    219699, 
    219700, 
    219701, 
    245308, 
    241067, 
    219702, 
    219703, 
    219704, 
    219705, 
    219706, 
    220318, 
    215376, 
    215377, 
    220319, 
    219225, 
    219227, 
    242997, 
    219229, 
    240507, 
    240506, 
    240508, 
    240509, 
    240536, 
    240514, 
    240515, 
    240516, 
    240517, 
    240518, 
    240526, 
    240535, 
    240519, 
    240520, 
    240521, 
    240522, 
    240523, 
    240524, 
    240525, 
    240527, 
    240528, 
    240529, 
    240530, 
    240559, 
    240537, 
    240538, 
    240539, 
    240540, 
    240541, 
    240549, 
    240558, 
    240542, 
    240543, 
    240544, 
    240545, 
    240546, 
    240547, 
    240548, 
    240550, 
    240551, 
    240552, 
    240553, 
    240582, 
    240560, 
    240561, 
    240562, 
    240563, 
    240564, 
    240572, 
    240581, 
    240565, 
    240566, 
    240567, 
    240568, 
    240569, 
    240570, 
    240571, 
    240573, 
    240574, 
    240575, 
    240576
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00360

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": 188,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (219927,219928,219929,220114,219894,219895,219896,219897,220135,244918,244919,244920,244921,244922,244923,244924,244925,217391,217392,217393,217394,217395,217396,236870,236871,217397,245301,241058,219829,217398,217399,217400,217401,241059,217402,217403,217404,217405,217406,217407,217408,217409,241060,217410,241061,217411,217412,245302,245303,225914,217413,217414,245304,241062,217415,217416,217417,217418,217419,220215,219660,219661,220216,218424,218425,220221,219662,244926,244927,244928,244929,244930,244931,244932,244933,220222,219675,219676,219677,219678,219679,219680,219681,236932,236933,219682,245305,241063,219683,219684,219685,219686,219687,241064,219688,219689,219690,219691,219692,219693,219694,219695,241065,219696,241066,219697,219698,245306,245307,219699,219700,219701,245308,241067,219702,219703,219704,219705,219706,220318,215376,215377,220319,219225,219227,242997,219229,240507,240506,240508,240509,240536,240514,240515,240516,240517,240518,240526,240535,240519,240520,240521,240522,240523,240524,240525,240527,240528,240529,240530,240559,240537,240538,240539,240540,240541,240549,240558,240542,240543,240544,240545,240546,240547,240548,240550,240551,240552,240553,240582,240560,240561,240562,240563,240564,240572,240581,240565,240566,240567,240568,240569,240570,240571,240573,240574,240575,240576)"
        }
      }
    },
    "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
35604 217391 variant_image 47837 0 V 0 D 0 0
35605 217392 variant_image 47838 0 V 0 D 0 0
35606 217393 variant_image 47839 0 V 0 D 0 0
35607 217394 variant_image 47840 0 V 0 D 0 0
35608 217395 variant_image 47841 0 V 0 D 0 0
35609 217396 variant_image 47842 0 V 0 D 0 0
35610 217397 variant_image 47843 0 V 0 D 0 0
35611 217398 variant_image 47844 0 V 0 D 0 0
35612 217399 variant_image 47845 0 V 0 D 0 0
35613 217401 variant_image 47846 0 V 0 D 0 0
35614 217402 variant_image 47847 0 V 0 D 0 0
35615 217403 variant_image 47848 0 V 0 D 0 0
35616 217404 variant_image 47849 0 V 0 D 0 0
35617 217405 variant_image 47850 0 V 0 D 0 0
35618 217406 variant_image 47851 0 V 0 D 0 0
35619 217407 variant_image 47852 0 V 0 D 0 0
35620 217408 variant_image 47853 0 V 0 D 0 0
35621 217409 variant_image 47854 0 V 0 D 0 0
35622 217410 variant_image 47855 0 V 0 D 0 0
35623 217411 variant_image 47856 0 V 0 D 0 0
35624 217412 variant_image 47857 0 V 0 D 0 0
35625 217413 variant_image 47858 0 V 0 D 0 0
35626 217414 variant_image 47859 0 V 0 D 0 0
35627 217415 variant_image 47860 0 V 0 D 0 0
35628 217416 variant_image 47861 0 V 0 D 0 0
35629 217417 variant_image 47862 0 V 0 D 0 0
35630 217418 variant_image 47863 0 V 0 D 0 0
35631 217419 variant_image 47864 0 V 0 D 0 0
36884 218424 variant_image 49117 0 V 0 D 0 0
36885 218425 variant_image 49118 0 V 0 D 0 0
37889 219227 variant_image 50122 0 V 0 D 0 0
37891 219229 variant_image 50124 0 V 0 D 0 0
38008 219225 variant_image 50241 0 V 0 D 0 0
38307 219660 variant_image 50540 0 V 0 D 0 0
38308 219661 variant_image 50541 0 V 0 D 0 0
38321 219676 variant_image 50554 0 V 0 D 0 0
38322 219677 variant_image 50555 0 V 0 D 0 0
38323 219678 variant_image 50556 0 V 0 D 0 0
38324 219679 variant_image 50557 0 V 0 D 0 0
38325 219680 variant_image 50558 0 V 0 D 0 0
38326 219681 variant_image 50559 0 V 0 D 0 0
38327 219682 variant_image 50560 0 V 0 D 0 0
38328 219683 variant_image 50561 0 V 0 D 0 0
38329 219684 variant_image 50562 0 V 0 D 0 0
38330 219685 variant_image 50563 0 V 0 D 0 0
38331 219686 variant_image 50564 0 V 0 D 0 0
38332 219687 variant_image 50565 0 V 0 D 0 0
38333 219688 variant_image 50566 0 V 0 D 0 0
38334 219689 variant_image 50567 0 V 0 D 0 0
38335 219690 variant_image 50568 0 V 0 D 0 0
38336 219691 variant_image 50569 0 V 0 D 0 0
38337 219692 variant_image 50570 0 V 0 D 0 0
38338 219693 variant_image 50571 0 V 0 D 0 0
38339 219694 variant_image 50572 0 V 0 D 0 0
38340 219695 variant_image 50573 0 V 0 D 0 0
38341 219696 variant_image 50574 0 V 0 D 0 0
38342 219697 variant_image 50575 0 V 0 D 0 0
38343 219698 variant_image 50576 0 V 0 D 0 0
38344 219699 variant_image 50577 0 V 0 D 0 0
38345 219700 variant_image 50578 0 V 0 D 0 0
38346 219701 variant_image 50579 0 V 0 D 0 0
38347 219702 variant_image 50580 0 V 0 D 0 0
38348 219703 variant_image 50581 0 V 0 D 0 0
38349 219704 variant_image 50582 0 V 0 D 0 0
38350 219705 variant_image 50583 0 V 0 D 0 0
38351 219706 variant_image 50584 0 V 0 D 0 0
38476 217400 variant_image 50709 0 V 0 D 0 0
38489 219829 variant_image 50722 0 V 0 D 0 0
38606 219894 variant_image 50839 0 V 0 D 0 0
38607 219895 variant_image 50840 0 V 0 D 0 0
38608 219896 variant_image 50841 0 V 0 D 0 0
38609 219897 variant_image 50842 0 V 0 D 0 0
44124 225914 variant_image 56357 0 V 0 D 0 0
59612 236870 variant_image 71845 0 V 0 D 0 0
59613 236871 variant_image 71846 0 V 0 D 0 0
59674 236932 variant_image 71907 0 V 0 D 0 0
59675 236933 variant_image 71908 0 V 0 D 0 0
69896 240514 variant_image 82129 0 V 0 D 0 0
69897 240515 variant_image 82130 0 V 0 D 0 0
69898 240516 variant_image 82131 0 V 0 D 0 0
69899 240517 variant_image 82132 0 V 0 D 0 0
69900 240518 variant_image 82133 0 V 0 D 0 0
69901 240519 variant_image 82134 0 V 0 D 0 0
69902 240520 variant_image 82135 0 V 0 D 0 0
69903 240521 variant_image 82136 0 V 0 D 0 0
69904 240522 variant_image 82137 0 V 0 D 0 0
69905 240523 variant_image 82138 0 V 0 D 0 0
69906 240524 variant_image 82139 0 V 0 D 0 0
69907 240525 variant_image 82140 0 V 0 D 0 0
69908 240526 variant_image 82141 0 V 0 D 0 0
69909 240527 variant_image 82142 0 V 0 D 0 0
69910 240528 variant_image 82143 0 V 0 D 0 0
69911 240529 variant_image 82144 0 V 0 D 0 0
69912 240530 variant_image 82145 0 V 0 D 0 0
69917 240535 variant_image 82150 0 V 0 D 0 0
69918 240537 variant_image 82151 0 V 0 D 0 0
69919 240538 variant_image 82152 0 V 0 D 0 0
69920 240539 variant_image 82153 0 V 0 D 0 0
69921 240540 variant_image 82154 0 V 0 D 0 0
69922 240541 variant_image 82155 0 V 0 D 0 0
69923 240542 variant_image 82156 0 V 0 D 0 0
69924 240543 variant_image 82157 0 V 0 D 0 0
69925 240544 variant_image 82158 0 V 0 D 0 0
69926 240545 variant_image 82159 0 V 0 D 0 0
69927 240546 variant_image 82160 0 V 0 D 0 0
69928 240547 variant_image 82161 0 V 0 D 0 0
69929 240548 variant_image 82162 0 V 0 D 0 0
69930 240549 variant_image 82163 0 V 0 D 0 0
69931 240550 variant_image 82164 0 V 0 D 0 0
69932 240551 variant_image 82165 0 V 0 D 0 0
69933 240552 variant_image 82166 0 V 0 D 0 0
69934 240553 variant_image 82167 0 V 0 D 0 0
69939 240558 variant_image 82172 0 V 0 D 0 0
69940 240560 variant_image 82173 0 V 0 D 0 0
69941 240561 variant_image 82174 0 V 0 D 0 0
69942 240562 variant_image 82175 0 V 0 D 0 0
69943 240563 variant_image 82176 0 V 0 D 0 0
69944 240564 variant_image 82177 0 V 0 D 0 0
69945 240565 variant_image 82178 0 V 0 D 0 0
69946 240566 variant_image 82179 0 V 0 D 0 0
69947 240567 variant_image 82180 0 V 0 D 0 0
69948 240568 variant_image 82181 0 V 0 D 0 0
69949 240569 variant_image 82182 0 V 0 D 0 0
69950 240570 variant_image 82183 0 V 0 D 0 0
69951 240571 variant_image 82184 0 V 0 D 0 0
69952 240572 variant_image 82185 0 V 0 D 0 0
69953 240573 variant_image 82186 0 V 0 D 0 0
69954 240574 variant_image 82187 0 V 0 D 0 0
69955 240575 variant_image 82188 0 V 0 D 0 0
69956 240576 variant_image 82189 0 V 0 D 0 0
69961 240581 variant_image 82194 0 V 0 D 0 0
70593 241058 variant_image 82826 0 V 0 D 0 0
70594 241059 variant_image 82827 0 V 0 D 0 0
70595 241060 variant_image 82828 0 V 0 D 0 0
70596 241061 variant_image 82829 0 V 0 D 0 0
70597 241062 variant_image 82830 0 V 0 D 0 0
70598 241063 variant_image 82831 0 V 0 D 0 0
70599 241064 variant_image 82832 0 V 0 D 0 0
70600 241065 variant_image 82833 0 V 0 D 0 0
70601 241066 variant_image 82834 0 V 0 D 0 0
70602 241067 variant_image 82835 0 V 0 D 0 0
72641 242997 variant_image 84874 0 V 0 D 0 0
74710 244918 variant_image 86943 0 V 0 D 0 0
74711 244919 variant_image 86944 0 V 0 D 0 0
74712 244920 variant_image 86945 0 V 0 D 0 0
74713 244921 variant_image 86946 0 V 0 D 0 0
74714 244922 variant_image 86947 0 V 0 D 0 0
74715 244923 variant_image 86948 0 V 0 D 0 0
74716 244924 variant_image 86949 0 V 0 D 0 0
74717 244925 variant_image 86950 0 V 0 D 0 0
74718 244926 variant_image 86951 0 V 0 D 0 0
74719 244927 variant_image 86952 0 V 0 D 0 0
74720 244928 variant_image 86953 0 V 0 D 0 0
74721 244929 variant_image 86954 0 V 0 D 0 0
74722 244930 variant_image 86955 0 V 0 D 0 0
74723 244931 variant_image 86956 0 V 0 D 0 0
74724 244932 variant_image 86957 0 V 0 D 0 0
74725 244933 variant_image 86958 0 V 0 D 0 0
75103 245301 variant_image 87336 0 V 0 D 0 0
75104 245302 variant_image 87337 0 V 0 D 0 0
75105 245303 variant_image 87338 0 V 0 D 0 0
75106 245304 variant_image 87339 0 V 0 D 0 0
75108 245305 variant_image 87341 0 V 0 D 0 0
75109 245306 variant_image 87342 0 V 0 D 0 0
75110 245307 variant_image 87343 0 V 0 D 0 0
75111 245308 variant_image 87344 0 V 0 D 0 0