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 (
    218148, 
    218149, 
    218150, 
    220119, 
    218037, 
    218038, 
    218039, 
    220120, 
    218040, 
    218041, 
    218042, 
    220143, 
    244558, 
    244559, 
    244560, 
    244561, 
    244562, 
    244563, 
    244564, 
    244565, 
    216947, 
    216948, 
    216949, 
    216950, 
    216951, 
    216952, 
    236882, 
    236883, 
    216953, 
    245122, 
    241590, 
    216954, 
    216955, 
    216956, 
    216957, 
    216958, 
    241591, 
    216959, 
    216960, 
    216961, 
    216962, 
    216963, 
    216964, 
    216965, 
    216966, 
    241592, 
    216967, 
    241593, 
    216968, 
    216969, 
    245123, 
    245124, 
    225920, 
    216970, 
    216971, 
    245125, 
    241594, 
    220173, 
    215556, 
    215557, 
    215558, 
    215559, 
    215560, 
    215561, 
    215562, 
    215563, 
    215564, 
    215565, 
    215566, 
    215567, 
    215568, 
    215569, 
    243103, 
    243104, 
    243105, 
    243106, 
    220232, 
    218151, 
    218152, 
    218153, 
    218154, 
    220240, 
    216999, 
    217000, 
    217001, 
    220241, 
    217009, 
    217010, 
    217011, 
    220264, 
    216983, 
    216984, 
    216985, 
    220267, 
    244574, 
    244575, 
    244576, 
    244577, 
    244578, 
    244579, 
    244580, 
    244581, 
    220268, 
    217069, 
    217070, 
    217071, 
    217072, 
    217073, 
    217074, 
    236884, 
    236885, 
    217075, 
    245130, 
    241600, 
    217076, 
    217077, 
    217078, 
    217079, 
    217080, 
    241601, 
    217081, 
    217082, 
    217083, 
    217084, 
    217085, 
    217086, 
    217087, 
    217088, 
    241602, 
    217089, 
    241603, 
    217090, 
    217091, 
    245131, 
    245132, 
    217092, 
    217093, 
    217094, 
    245133, 
    241604, 
    220300, 
    215616, 
    215617, 
    220307, 
    215660, 
    215661, 
    215662, 
    215663, 
    215664, 
    215665, 
    215666, 
    215667, 
    215668, 
    215669, 
    215670, 
    215671, 
    215672, 
    215673, 
    243095, 
    243096, 
    243097, 
    243098, 
    220308, 
    215618, 
    215619, 
    220317, 
    217132, 
    217133, 
    220319, 
    219225, 
    219227, 
    242997, 
    219229, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    223760, 
    223761, 
    223762, 
    224224, 
    224225, 
    224226, 
    228555, 
    228556, 
    228557, 
    228558, 
    228559, 
    228560, 
    228561, 
    228593, 
    228562, 
    228563, 
    228564, 
    228565, 
    228566, 
    228567, 
    228569, 
    237078, 
    237079, 
    228570, 
    242785, 
    241675, 
    228571, 
    228572, 
    228573, 
    228574, 
    228575, 
    241676, 
    228576, 
    228577, 
    228578, 
    228579, 
    228580, 
    228581, 
    228582, 
    228583, 
    241677, 
    228584, 
    241678, 
    228585, 
    228586, 
    242786, 
    242787, 
    228587, 
    228588, 
    242788, 
    241679, 
    228624, 
    228594, 
    228595, 
    228596, 
    228597, 
    228619, 
    228612, 
    237074, 
    237075, 
    228598, 
    242509, 
    241555, 
    228599, 
    228600, 
    228601, 
    228602, 
    228603, 
    241556, 
    228604, 
    228605, 
    228606, 
    228607, 
    228608, 
    228609, 
    228610, 
    228611, 
    241557, 
    228613, 
    241558, 
    228614, 
    228615, 
    242510, 
    242511, 
    228616, 
    228617, 
    228618, 
    242512, 
    241559, 
    228649, 
    228646, 
    228647, 
    228648, 
    238250, 
    238248, 
    238249
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00260

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": 274,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (218148,218149,218150,220119,218037,218038,218039,220120,218040,218041,218042,220143,244558,244559,244560,244561,244562,244563,244564,244565,216947,216948,216949,216950,216951,216952,236882,236883,216953,245122,241590,216954,216955,216956,216957,216958,241591,216959,216960,216961,216962,216963,216964,216965,216966,241592,216967,241593,216968,216969,245123,245124,225920,216970,216971,245125,241594,220173,215556,215557,215558,215559,215560,215561,215562,215563,215564,215565,215566,215567,215568,215569,243103,243104,243105,243106,220232,218151,218152,218153,218154,220240,216999,217000,217001,220241,217009,217010,217011,220264,216983,216984,216985,220267,244574,244575,244576,244577,244578,244579,244580,244581,220268,217069,217070,217071,217072,217073,217074,236884,236885,217075,245130,241600,217076,217077,217078,217079,217080,241601,217081,217082,217083,217084,217085,217086,217087,217088,241602,217089,241603,217090,217091,245131,245132,217092,217093,217094,245133,241604,220300,215616,215617,220307,215660,215661,215662,215663,215664,215665,215666,215667,215668,215669,215670,215671,215672,215673,243095,243096,243097,243098,220308,215618,215619,220317,217132,217133,220319,219225,219227,242997,219229,223755,223756,223757,223758,223759,223760,223761,223762,224224,224225,224226,228555,228556,228557,228558,228559,228560,228561,228593,228562,228563,228564,228565,228566,228567,228569,237078,237079,228570,242785,241675,228571,228572,228573,228574,228575,241676,228576,228577,228578,228579,228580,228581,228582,228583,241677,228584,241678,228585,228586,242786,242787,228587,228588,242788,241679,228624,228594,228595,228596,228597,228619,228612,237074,237075,228598,242509,241555,228599,228600,228601,228602,228603,241556,228604,228605,228606,228607,228608,228609,228610,228611,241557,228613,241558,228614,228615,242510,242511,228616,228617,228618,242512,241559,228649,228646,228647,228648,238250,238248,238249)"
        }
      }
    },
    "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
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
33769 215619 variant_image 46002 0 V 0 D 0 0
33807 215660 variant_image 46040 0 V 0 D 0 0
33808 215661 variant_image 46041 0 V 0 D 0 0
33809 215662 variant_image 46042 0 V 0 D 0 0
33810 215663 variant_image 46043 0 V 0 D 0 0
33811 215664 variant_image 46044 0 V 0 D 0 0
33812 215665 variant_image 46045 0 V 0 D 0 0
33813 215666 variant_image 46046 0 V 0 D 0 0
33814 215667 variant_image 46047 0 V 0 D 0 0
33815 215668 variant_image 46048 0 V 0 D 0 0
33816 215669 variant_image 46049 0 V 0 D 0 0
33817 215670 variant_image 46050 0 V 0 D 0 0
33818 215671 variant_image 46051 0 V 0 D 0 0
33819 215672 variant_image 46052 0 V 0 D 0 0
33820 215673 variant_image 46053 0 V 0 D 0 0
33840 215618 variant_image 46073 0 V 0 D 0 0
34161 215616 variant_image 46394 0 V 0 D 0 0
34162 215617 variant_image 46395 0 V 0 D 0 0
35143 216947 variant_image 47376 0 V 0 D 0 0
35144 216948 variant_image 47377 0 V 0 D 0 0
35145 216949 variant_image 47378 0 V 0 D 0 0
35146 216950 variant_image 47379 0 V 0 D 0 0
35147 216951 variant_image 47380 0 V 0 D 0 0
35148 216952 variant_image 47381 0 V 0 D 0 0
35149 216953 variant_image 47382 0 V 0 D 0 0
35150 216954 variant_image 47383 0 V 0 D 0 0
35151 216955 variant_image 47384 0 V 0 D 0 0
35152 216956 variant_image 47385 0 V 0 D 0 0
35153 216957 variant_image 47386 0 V 0 D 0 0
35154 216958 variant_image 47387 0 V 0 D 0 0
35155 216959 variant_image 47388 0 V 0 D 0 0
35156 216960 variant_image 47389 0 V 0 D 0 0
35157 216961 variant_image 47390 0 V 0 D 0 0
35158 216962 variant_image 47391 0 V 0 D 0 0
35159 216963 variant_image 47392 0 V 0 D 0 0
35160 216964 variant_image 47393 0 V 0 D 0 0
35161 216965 variant_image 47394 0 V 0 D 0 0
35162 216966 variant_image 47395 0 V 0 D 0 0
35163 216967 variant_image 47396 0 V 0 D 0 0
35164 216968 variant_image 47397 0 V 0 D 0 0
35165 216969 variant_image 47398 0 V 0 D 0 0
35166 216970 variant_image 47399 0 V 0 D 0 0
35167 216971 variant_image 47400 0 V 0 D 0 0
35178 216983 variant_image 47411 0 V 0 D 0 0
35179 216984 variant_image 47412 0 V 0 D 0 0
35180 216985 variant_image 47413 0 V 0 D 0 0
35195 216999 variant_image 47428 0 V 0 D 0 0
35196 217000 variant_image 47429 0 V 0 D 0 0
35197 217001 variant_image 47430 0 V 0 D 0 0
35205 217009 variant_image 47438 0 V 0 D 0 0
35206 217010 variant_image 47439 0 V 0 D 0 0
35207 217011 variant_image 47440 0 V 0 D 0 0
35264 217069 variant_image 47497 0 V 0 D 0 0
35265 217070 variant_image 47498 0 V 0 D 0 0
35266 217071 variant_image 47499 0 V 0 D 0 0
35267 217072 variant_image 47500 0 V 0 D 0 0
35268 217073 variant_image 47501 0 V 0 D 0 0
35269 217074 variant_image 47502 0 V 0 D 0 0
35270 217075 variant_image 47503 0 V 0 D 0 0
35271 217076 variant_image 47504 0 V 0 D 0 0
35272 217077 variant_image 47505 0 V 0 D 0 0
35273 217078 variant_image 47506 0 V 0 D 0 0
35274 217079 variant_image 47507 0 V 0 D 0 0
35275 217080 variant_image 47508 0 V 0 D 0 0
35276 217081 variant_image 47509 0 V 0 D 0 0
35277 217082 variant_image 47510 0 V 0 D 0 0
35278 217083 variant_image 47511 0 V 0 D 0 0
35279 217084 variant_image 47512 0 V 0 D 0 0
35280 217085 variant_image 47513 0 V 0 D 0 0
35281 217086 variant_image 47514 0 V 0 D 0 0
35282 217087 variant_image 47515 0 V 0 D 0 0
35283 217088 variant_image 47516 0 V 0 D 0 0
35284 217091 variant_image 47517 0 V 0 D 0 0
35285 217092 variant_image 47518 0 V 0 D 0 0
35286 217093 variant_image 47519 0 V 0 D 0 0
35287 217094 variant_image 47520 0 V 0 D 0 0
35325 217132 variant_image 47558 0 V 0 D 0 0
35326 217133 variant_image 47559 0 V 0 D 0 0
35328 217089 variant_image 47561 0 V 0 D 0 0
35329 217090 variant_image 47562 0 V 0 D 0 0
36462 218037 variant_image 48695 0 V 0 D 0 0
36463 218038 variant_image 48696 0 V 0 D 0 0
36464 218039 variant_image 48697 0 V 0 D 0 0
36465 218040 variant_image 48698 0 V 0 D 0 0
36466 218041 variant_image 48699 0 V 0 D 0 0
36467 218042 variant_image 48700 0 V 0 D 0 0
36646 218151 variant_image 48879 0 V 0 D 0 0
36647 218152 variant_image 48880 0 V 0 D 0 0
36648 218153 variant_image 48881 0 V 0 D 0 0
36649 218154 variant_image 48882 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
42039 223756 variant_image 54272 0 V 0 D 0 0
42040 223757 variant_image 54273 0 V 0 D 0 0
42041 223758 variant_image 54274 0 V 0 D 0 0
42042 223759 variant_image 54275 0 V 0 D 0 0
42043 223761 variant_image 54276 0 V 0 D 0 0
42044 223762 variant_image 54277 0 V 0 D 0 0
44137 225920 variant_image 56370 0 V 0 D 0 0
46719 228556 variant_image 58952 0 V 0 D 0 0
46720 228557 variant_image 58953 0 V 0 D 0 0
46721 228558 variant_image 58954 0 V 0 D 0 0
46722 228559 variant_image 58955 0 V 0 D 0 0
46723 228560 variant_image 58956 0 V 0 D 0 0
46724 228561 variant_image 58957 0 V 0 D 0 0
46725 228563 variant_image 58958 0 V 0 D 0 0
46726 228564 variant_image 58959 0 V 0 D 0 0
46727 228565 variant_image 58960 0 V 0 D 0 0
46728 228566 variant_image 58961 0 V 0 D 0 0
46729 228567 variant_image 58962 0 V 0 D 0 0
46731 228569 variant_image 58964 0 V 0 D 0 0
46732 228570 variant_image 58965 0 V 0 D 0 0
46733 228571 variant_image 58966 0 V 0 D 0 0
46734 228572 variant_image 58967 0 V 0 D 0 0
46735 228573 variant_image 58968 0 V 0 D 0 0
46736 228574 variant_image 58969 0 V 0 D 0 0
46737 228575 variant_image 58970 0 V 0 D 0 0
46738 228576 variant_image 58971 0 V 0 D 0 0
46739 228577 variant_image 58972 0 V 0 D 0 0
46740 228578 variant_image 58973 0 V 0 D 0 0
46741 228579 variant_image 58974 0 V 0 D 0 0
46742 228580 variant_image 58975 0 V 0 D 0 0
46743 228581 variant_image 58976 0 V 0 D 0 0
46744 228582 variant_image 58977 0 V 0 D 0 0
46745 228583 variant_image 58978 0 V 0 D 0 0
46746 228584 variant_image 58979 0 V 0 D 0 0
46747 228585 variant_image 58980 0 V 0 D 0 0
46748 228586 variant_image 58981 0 V 0 D 0 0
46749 228587 variant_image 58982 0 V 0 D 0 0
46750 228588 variant_image 58983 0 V 0 D 0 0
46755 228594 variant_image 58988 0 V 0 D 0 0
46756 228595 variant_image 58989 0 V 0 D 0 0
46757 228596 variant_image 58990 0 V 0 D 0 0
46758 228597 variant_image 58991 0 V 0 D 0 0
46759 228598 variant_image 58992 0 V 0 D 0 0
46760 228599 variant_image 58993 0 V 0 D 0 0
46761 228600 variant_image 58994 0 V 0 D 0 0
46762 228601 variant_image 58995 0 V 0 D 0 0
46763 228602 variant_image 58996 0 V 0 D 0 0
46764 228603 variant_image 58997 0 V 0 D 0 0
46765 228604 variant_image 58998 0 V 0 D 0 0
46766 228605 variant_image 58999 0 V 0 D 0 0
46767 228606 variant_image 59000 0 V 0 D 0 0
46768 228607 variant_image 59001 0 V 0 D 0 0
46769 228608 variant_image 59002 0 V 0 D 0 0
46770 228609 variant_image 59003 0 V 0 D 0 0
46771 228610 variant_image 59004 0 V 0 D 0 0
46772 228611 variant_image 59005 0 V 0 D 0 0
46773 228612 variant_image 59006 0 V 0 D 0 0
46774 228613 variant_image 59007 0 V 0 D 0 0
46775 228614 variant_image 59008 0 V 0 D 0 0
46776 228615 variant_image 59009 0 V 0 D 0 0
46777 228616 variant_image 59010 0 V 0 D 0 0
46778 228617 variant_image 59011 0 V 0 D 0 0
46779 228618 variant_image 59012 0 V 0 D 0 0
46780 228619 variant_image 59013 0 V 0 D 0 0
46806 228646 variant_image 59039 0 V 0 D 0 0
46807 228647 variant_image 59040 0 V 0 D 0 0
46808 228648 variant_image 59041 0 V 0 D 0 0
59624 236882 variant_image 71857 0 V 0 D 0 0
59625 236883 variant_image 71858 0 V 0 D 0 0
59626 236884 variant_image 71859 0 V 0 D 0 0
59627 236885 variant_image 71860 0 V 0 D 0 0
59821 237074 variant_image 72054 0 V 0 D 0 0
59822 237075 variant_image 72055 0 V 0 D 0 0
59825 237078 variant_image 72058 0 V 0 D 0 0
59826 237079 variant_image 72059 0 V 0 D 0 0
62038 238248 variant_image 74271 0 V 0 D 0 0
62039 238249 variant_image 74272 0 V 0 D 0 0
71105 241555 variant_image 83338 0 V 0 D 0 0
71106 241556 variant_image 83339 0 V 0 D 0 0
71107 241557 variant_image 83340 0 V 0 D 0 0
71108 241558 variant_image 83341 0 V 0 D 0 0
71109 241559 variant_image 83342 0 V 0 D 0 0
71144 241590 variant_image 83377 0 V 0 D 0 0
71145 241591 variant_image 83378 0 V 0 D 0 0
71146 241592 variant_image 83379 0 V 0 D 0 0
71147 241593 variant_image 83380 0 V 0 D 0 0
71148 241594 variant_image 83381 0 V 0 D 0 0
71154 241600 variant_image 83387 0 V 0 D 0 0
71155 241601 variant_image 83388 0 V 0 D 0 0
71156 241602 variant_image 83389 0 V 0 D 0 0
71157 241603 variant_image 83390 0 V 0 D 0 0
71158 241604 variant_image 83391 0 V 0 D 0 0
71229 241675 variant_image 83462 0 V 0 D 0 0
71230 241676 variant_image 83463 0 V 0 D 0 0
71231 241677 variant_image 83464 0 V 0 D 0 0
71232 241678 variant_image 83465 0 V 0 D 0 0
71233 241679 variant_image 83466 0 V 0 D 0 0
72104 242509 variant_image 84337 0 V 0 D 0 0
72105 242510 variant_image 84338 0 V 0 D 0 0
72106 242511 variant_image 84339 0 V 0 D 0 0
72107 242512 variant_image 84340 0 V 0 D 0 0
72394 242785 variant_image 84627 0 V 0 D 0 0
72395 242786 variant_image 84628 0 V 0 D 0 0
72396 242787 variant_image 84629 0 V 0 D 0 0
72397 242788 variant_image 84630 0 V 0 D 0 0
72641 242997 variant_image 84874 0 V 0 D 0 0
72811 243095 variant_image 85044 0 V 0 D 0 0
72812 243096 variant_image 85045 0 V 0 D 0 0
72813 243097 variant_image 85046 0 V 0 D 0 0
72814 243098 variant_image 85047 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
74350 244558 variant_image 86583 0 V 0 D 0 0
74351 244559 variant_image 86584 0 V 0 D 0 0
74352 244560 variant_image 86585 0 V 0 D 0 0
74353 244561 variant_image 86586 0 V 0 D 0 0
74354 244562 variant_image 86587 0 V 0 D 0 0
74355 244563 variant_image 86588 0 V 0 D 0 0
74356 244564 variant_image 86589 0 V 0 D 0 0
74357 244565 variant_image 86590 0 V 0 D 0 0
74366 244574 variant_image 86599 0 V 0 D 0 0
74367 244575 variant_image 86600 0 V 0 D 0 0
74368 244576 variant_image 86601 0 V 0 D 0 0
74369 244577 variant_image 86602 0 V 0 D 0 0
74370 244578 variant_image 86603 0 V 0 D 0 0
74371 244579 variant_image 86604 0 V 0 D 0 0
74372 244580 variant_image 86605 0 V 0 D 0 0
74373 244581 variant_image 86606 0 V 0 D 0 0
74917 245122 variant_image 87150 0 V 0 D 0 0
74918 245123 variant_image 87151 0 V 0 D 0 0
74919 245124 variant_image 87152 0 V 0 D 0 0
74920 245125 variant_image 87153 0 V 0 D 0 0
74925 245130 variant_image 87158 0 V 0 D 0 0
74926 245131 variant_image 87159 0 V 0 D 0 0
74927 245132 variant_image 87160 0 V 0 D 0 0
74928 245133 variant_image 87161 0 V 0 D 0 0