SELECT 
  ushop_images.*, 
  ushop_images_links.*, 
  ushop_common_descriptions.description AS alt, 
  ushop_images.image_id AS images_image_id 
FROM 
  ushop_images_links 
  LEFT JOIN ushop_images ON ushop_images_links.image_id = ushop_images.image_id 
  LEFT JOIN ushop_common_descriptions ON ushop_common_descriptions.object_id = ushop_images.image_id 
  AND ushop_common_descriptions.object_holder = 'images' 
  AND ushop_common_descriptions.lang_code = 'es' 
WHERE 
  ushop_images_links.object_type = 'ab__lc_catalog_icon' 
  AND ushop_images_links.type = 'M' 
  AND ushop_images_links.object_id IN (
    318, 328, 329, 330, 331, 332, 333, 334, 
    335, 325, 320, 326, 319, 336, 323, 337, 
    315, 338, 339, 324, 340, 341, 321, 342, 
    317, 322, 792, 316, 791, 343, 344, 775, 
    345, 327, 346, 375, 767, 768, 769, 770, 
    771, 772, 773, 774
  ) 
ORDER BY 
  ushop_images_links.position, 
  ushop_images_links.pair_id

Query time 0.00148

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "107.76"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "45.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "ushop_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": 45,
            "rows_produced_per_join": 45,
            "filtered": "100.00",
            "index_condition": "((`marketplace`.`ushop_images_links`.`object_type` = 'ab__lc_catalog_icon') and (`marketplace`.`ushop_images_links`.`type` = 'M') and (`marketplace`.`ushop_images_links`.`object_id` in (318,328,329,330,331,332,333,334,335,325,320,326,319,336,323,337,315,338,339,324,340,341,321,342,317,322,792,316,791,343,344,775,345,327,346,375,767,768,769,770,771,772,773,774)))",
            "cost_info": {
              "read_cost": "26.76",
              "eval_cost": "4.50",
              "prefix_cost": "31.26",
              "data_read_per_join": "4K"
            },
            "used_columns": [
              "pair_id",
              "object_id",
              "object_type",
              "image_id",
              "detailed_id",
              "type",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "ushop_images",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "image_id"
            ],
            "key_length": "4",
            "ref": [
              "marketplace.ushop_images_links.image_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 45,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "11.25",
              "eval_cost": "4.50",
              "prefix_cost": "47.01",
              "data_read_per_join": "34K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res",
              "transparent"
            ]
          }
        },
        {
          "table": {
            "table_name": "ushop_common_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "lang_code",
              "object_holder"
            ],
            "key_length": "108",
            "ref": [
              "marketplace.ushop_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 45,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "11.25",
              "eval_cost": "4.50",
              "prefix_cost": "62.76",
              "data_read_per_join": "26K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}

Result

image_id image_path image_x image_y is_high_res transparent pair_id object_id object_type detailed_id type position alt images_image_id
9167 icono-control-gamer-categoria.png 64 64 N N 7151 319 ab__lc_catalog_icon 0 M 0 9167
9173 icono-camaras-y-accesorios.png 100 100 N N 7157 325 ab__lc_catalog_icon 0 M 0 9173
9177 icono-bateria-de-coche-categoria.png 64 64 N N 7161 318 ab__lc_catalog_icon 0 M 0 9177
9178 icono-smartphone-cateogoria.png 67 67 N N 7162 320 ab__lc_catalog_icon 0 M 0 9178
9179 icono-de-laptop.png 64 64 N N 7163 326 ab__lc_catalog_icon 0 M 0 9179
9180 icono-pesa-fitness.png 100 100 N N 7164 323 ab__lc_catalog_icon 0 M 0 9180
9181 icono-cronometro-temporalizador.png 64 64 N N 7165 321 ab__lc_catalog_icon 0 M 0 9181
9182 icono-libros-y-revistas.png 100 100 N N 7166 317 ab__lc_catalog_icon 0 M 0 9182
9183 icono-musica-y-peliculas.png 64 64 N N 7167 322 ab__lc_catalog_icon 0 M 0 9183
9184 icono-boligrafo-y-publicacion-categoria.png 64 64 N N 7168 324 ab__lc_catalog_icon 0 M 0 9184
9185 icono-otras-categorias-cuadrados.png 96 96 N N 7169 327 ab__lc_catalog_icon 0 M 0 9185
9186 icono-tractor.png 100 100 N N 7170 328 ab__lc_catalog_icon 0 M 0 9186
9187 icono-taco-de-mujer.png 100 100 N N 7171 316 ab__lc_catalog_icon 0 M 0 9187
9189 icono-huella-de-mascota.png 100 100 N N 7173 330 ab__lc_catalog_icon 0 M 0 9189
9190 icono-coleccion-de-cd.png 100 100 N N 7174 331 ab__lc_catalog_icon 0 M 0 9190
9191 icono-paleta-de-colores.png 64 64 N N 7175 332 ab__lc_catalog_icon 0 M 0 9191
9192 icono-vaso-bebida.png 91 91 N N 7176 329 ab__lc_catalog_icon 0 M 0 9192
9193 icono-coche.png 96 96 N N 7177 333 ab__lc_catalog_icon 0 M 0 9193
9194 icono-bebe.png 80 80 N N 7178 334 ab__lc_catalog_icon 0 M 0 9194
9195 icono-de-perfume.png 100 100 N N 7179 335 ab__lc_catalog_icon 0 M 0 9195
9196 icono-persona-obrero.png 64 64 N N 7180 336 ab__lc_catalog_icon 0 M 0 9196
9197 icono-electrodomestico-lavarropas.png 100 100 N N 7181 337 ab__lc_catalog_icon 0 M 0 9197
9198 icono-llave-herramienta.png 80 80 N N 7182 338 ab__lc_catalog_icon 0 M 0 9198
9199 icono-pala-y-planta-jardin.png 64 64 N N 7183 339 ab__lc_catalog_icon 0 M 0 9199
9200 icono-inmuebles-propiedades.png 100 100 N N 7184 340 ab__lc_catalog_icon 0 M 0 9200
9201 icono-jazz-instrumento-musical.png 64 64 N N 7185 341 ab__lc_catalog_icon 0 M 0 9201
9202 icono-oso-peluche.png 80 80 N N 7186 342 ab__lc_catalog_icon 0 M 0 9202
9203 icono-estetoscopio.png 100 100 N N 7187 343 ab__lc_catalog_icon 0 M 0 9203
9204 icono-estrechon-de-manos.png 100 100 N N 7188 344 ab__lc_catalog_icon 0 M 0 9204
9205 icono-mascara-antifaz.png 96 96 N N 7189 345 ab__lc_catalog_icon 0 M 0 9205
9206 icono-eco-sustentable.png 64 64 N N 7190 346 ab__lc_catalog_icon 0 M 0 9206
9207 icono-avion-categoria.png 100 100 N N 7191 375 ab__lc_catalog_icon 0 M 0 9207
9208 icono-television.png 50 50 N N 7192 315 ab__lc_catalog_icon 0 M 0 9208