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 = 'ro' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    1660621, 1663150, 1664049, 1658333, 
    1658334, 1664157, 1658506, 1657840, 
    1657777, 1658557, 1661197, 1662527, 
    1658427, 1658811, 1658265, 1663182, 
    1658593, 1660401, 1658270, 1663613, 
    1659564, 1658864, 1657833, 1662451, 
    1661407, 1659246, 1663612, 2099795, 
    1660547, 1660154, 1659920, 1659832, 
    1658398, 1658504, 1661697, 1661022
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.14993

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "190.29"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "36.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": 36,
            "rows_produced_per_join": 36,
            "filtered": "100.00",
            "index_condition": "((`maniamall_cscart`.`cscart_images_links`.`object_type` = 'product') and (`maniamall_cscart`.`cscart_images_links`.`type` = 'M') and (`maniamall_cscart`.`cscart_images_links`.`object_id` in (1660621,1663150,1664049,1658333,1658334,1664157,1658506,1657840,1657777,1658557,1661197,1662527,1658427,1658811,1658265,1663182,1658593,1660401,1658270,1663613,1659564,1658864,1657833,1662451,1661407,1659246,1663612,2099795,1660547,1660154,1659920,1659832,1658398,1658504,1661697,1661022)))",
            "cost_info": {
              "read_cost": "73.21",
              "eval_cost": "3.60",
              "prefix_cost": "76.81",
              "data_read_per_join": "3K"
            },
            "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": "3",
            "ref": [
              "maniamall_cscart.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 36,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "35.36",
              "eval_cost": "3.60",
              "prefix_cost": "115.77",
              "data_read_per_join": "27K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_images), (`maniamall_cscart`.`cscart_images_links`.`detailed_id` = `maniamall_cscart`.`cscart_images`.`image_id`), true)"
          }
        },
        {
          "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": "107",
            "ref": [
              "maniamall_cscart.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 36,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "34.92",
              "eval_cost": "3.60",
              "prefix_cost": "154.29",
              "data_read_per_join": "21K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_common_descriptions), (`maniamall_cscart`.`cscart_common_descriptions`.`object_id` = `maniamall_cscart`.`cscart_images`.`image_id`), true)"
          }
        }
      ]
    }
  }
}

Result

pair_id object_id object_type image_id detailed_id type position image_path alt image_x image_y images_image_id
3642880 1657777 product 0 3643133 M 0 nuca-rotire-volan-pallino-maniamall-cars.jpg 177 177 3643133
3642942 1657833 product 0 3643195 M 0 suport-doza-pahar-maxi-cooler-maniamall-cars.jpg 177 177 3643195
3642949 1657840 product 0 3643202 M 0 cleme-de-precizie-pentru-tester-acumulator-micro-clips-4buc-45cm-maniamall-cars.jpg 177 177 3643202
3643505 1658265 product 0 3643758 M 0 autocolant-3d-crom-sport-maniamall-cars.jpg 177 177 3643758
3643510 1658270 product 0 3643763 M 0 autocolant-3d-crom-bear-paw-maniamall-cars.jpg 177 177 3643763
3643578 1658333 product 0 3643831 M 0 bec-tip-led-12v-soclu-pl-t10-w21x95d-2buc-alb-dispersat-maniamall-cars.jpg 177 177 3643831
3643579 1658334 product 0 3643832 M 0 bec-tip-led-12v-soclu-pl-t10-w21x95d-2buc-albastru-focalizat-maniamall-cars.jpg 177 177 3643832
3643644 1658398 product 0 3643897 M 0 aparatori-usi-contour-5---2buc---crom-maniamall-cars.jpg 177 177 3643897
3643677 1658427 product 0 3643930 M 0 cheie-filtru-ulei-cu-colier-metalic-lampa-maniamall-cars.jpg 177 177 3643930
3643758 1658504 product 0 3644011 M 0 plasa-grila-spoiler-racing-argintiu---small-2x4mm-100x33cm-maniamall-cars.jpg 177 177 3644011
3643760 1658506 product 0 3644013 M 0 plasa-grila-spoiler-racing-argintiu---medium-6x12mm---100x33cm-maniamall-cars.jpg 177 177 3644013
3643811 1658557 product 0 3644064 M 0 plasa-grila-spoiler-racing-negru---small-2x4mm---120x20cm-maniamall-cars.jpg 177 177 3644064
3643851 1658593 product 0 3644104 M 0 kit-de-ajustare-pentru-bare-snap-4buc---f-0---14cm-maniamall-cars.jpg 177 177 3644104
3644080 1658811 product 0 3644333 M 0 filtru-aer-sport-din-burete-af-4---rosu-maniamall-cars.jpg 177 177 3644333
3644136 1658864 product 0 3644389 M 0 prezoane-antifurt-jante-conice-m12x15mm-4buc---tip-b-maniamall-cars.jpg 177 177 3644389
3644537 1659246 product 0 3644790 M 0 bec-12v---w12w---12w-bord-soclu-sticla-w2x46d-1buc-narva--maniamall-cars.jpg 177 177 3644790
3644869 1659564 product 0 3645122 M 0 buson-rezervor-camion-din-metal-cromat-cu-cheie-kamar----80mm-maniamall-cars.jpg 177 177 3645122
3645142 1659832 product 0 3645395 M 0 husa-scaun-fata-masaj-cu-magneti-1buc-carpoint-maniamall-cars.jpg 177 177 3645395
3645231 1659920 product 0 3645484 M 0 set-sigurante-plate-mici-10buc---4cars-maniamall-cars.jpg 177 177 3645484
3645476 1660154 product 0 3645729 M 0 lampa-de-lucru-cu-neon-230v-filson-maniamall-cars.jpg 177 177 3645729
3645727 1660401 product 0 3645980 M 0 filtru-motorina-oe-ford---ford-transit-maniamall-cars.jpg 177 177 3645980
3645873 1660547 product 0 3646126 M 0 lampa-stop-spate-stg-oe-ford---ford-transit-maniamall-cars.jpg 177 177 3646126
3645947 1660621 product 0 3646200 M 0 bec-xenon-12v---d2s---35w-original-line-1buc---6000k-maniamall-cars.jpg 177 177 3646200
3646365 1661022 product 0 3646618 M 0 filtru-ulei-mahle---mercedes-e-classsprinter-vw-lt-maniamall-cars.jpg 177 177 3646618
3646541 1661197 product 0 3646794 M 0 huse-scaun-hastings-12buc---negrualbastru-maniamall-cars.jpg 177 177 3646794
3646754 1661407 product 0 3647007 M 0 prelata-motocicleta-basic-garage---xl---box-maniamall-cars.jpg 177 177 3647007
3647044 1661697 product 0 3647297 M 0 cutii-si-carcase-pt-baterii3-buc-aa-baterie-creioncu-intrerupator-cu-capac-maniamall-cars.jpg 177 177 3647297
3647793 1662451 product 0 3648046 M 0 lupa-8-dioptrii-pt-lampa-de-lucru-led---cod-10797-maniamall-cars.jpg 177 177 3648046
3647869 1662527 product 0 3648122 M 0 antifon---4-buc-maniamall-cars.jpg 177 177 3648122
3648492 1663150 product 0 3648745 M 0 profil-izolator-autoadeziv-pt-ferestre-si-usi-profil-e---100-m-maro-9-mm-maniamall-cars.jpg 177 177 3648745
3648524 1663182 product 0 3648777 M 0 sir-de-lumini-de-craciun---alb-cald-fir-argintiu---2-m-2-x-aa-maniamall-cars.jpg 177 177 3648777
3648954 1663612 product 0 3649207 M 0 mercedes-benz---carcasa-tip-cheie-briceag-cu1-buton-lama-4-piste-maniamall-cars.jpg 177 177 3649207
3648955 1663613 product 0 3649208 M 0 mercedes-benz---carcasa-tip-cheie-briceag-cu-1-buton-lama-2-piste-maniamall-cars.jpg 177 177 3649208
3649399 1664049 product 0 3649652 M 0 cupla-remorca-60x60mm-750kg-pentru-ax-patrat-carpoint-maniamall-cars.jpg 177 177 3649652
3649507 1664157 product 0 3649760 M 0 huse-scaun-camion-dedicate-daf-xf-set-11-locuri---negrugri-maniamall-cars.jpg 177 177 3649760
5161675 2099795 product 0 5161928 M 0 carlig-de-fixare-usa-semiremorca-furgon-maniamall-cars.jpg 177 177 5161928