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 (
    1732000, 1661266, 1731933, 1658668, 
    1658805, 2539827, 1661450, 1658400, 
    1661340, 2072334, 1659066, 1163013, 
    1663387, 2253671, 1659620, 1658630, 
    1659207, 1658657, 1657931, 1661143, 
    1732317, 1664148, 1732319, 1657915, 
    1659840, 1658338, 1658635, 1658606, 
    1658866, 1658169, 1660818, 1659802, 
    1659293, 1660499, 1658645, 1661096
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.47187

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "189.86"
    },
    "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 (1732000,1661266,1731933,1658668,1658805,2539827,1661450,1658400,1661340,2072334,1659066,1163013,1663387,2253671,1659620,1658630,1659207,1658657,1657931,1661143,1732317,1664148,1732319,1657915,1659840,1658338,1658635,1658606,1658866,1658169,1660818,1659802,1659293,1660499,1658645,1661096)))",
            "cost_info": {
              "read_cost": "73.09",
              "eval_cost": "3.60",
              "prefix_cost": "76.69",
              "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.34",
              "eval_cost": "3.60",
              "prefix_cost": "115.63",
              "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.64",
              "eval_cost": "3.60",
              "prefix_cost": "153.87",
              "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
1870579 1163013 product 0 1870831 M 0 total---lama-taiere---carbid-tungsten---compatibil---mto-tht576004b-.jpg 222 228 1870831
3643033 1657915 product 0 3643286 M 0 priza-auto-incorporabila-12v-20a---carpoint-maniamall-cars.jpg 177 177 3643286
3643053 1657931 product 0 3643306 M 0 aparatori-noroi-camion-45x35cm-2buc-maniamall-cars.jpg 177 177 3643306
3643400 1658169 product 0 3643653 M 0 plasa-protectie-universala-120x50cm-maniamall-cars.jpg 177 177 3643653
3643583 1658338 product 0 3643836 M 0 bec-tip-led-12v-iluminat-bord-soclu-pl-t5-w2x46d-5buc---albast-maniamall-cars.jpg 177 177 3643836
3643647 1658400 product 0 3643900 M 0 autocolant-3d-crom-type-3-28mm-litera---b-maniamall-cars.jpg 177 177 3643900
3643864 1658606 product 0 3644117 M 0 set-sigurante-cilindrice-10buc---lampa-maniamall-cars.jpg 177 177 3644117
3643889 1658630 product 0 3644142 M 0 bec-tip-led-24v-poz-semn-bord-soclu-metal-t4w-ba9s-2buc---rosu-maniamall-cars.jpg 177 177 3644142
3643894 1658635 product 0 3644147 M 0 bec-tip-led-12v-sofit-cu-8-leduri-13x35mm-sv85-8-1buc---verde-maniamall-cars.jpg 177 177 3644147
3643904 1658645 product 0 3644157 M 0 bec-halogen-blu-xe-h7-55w-px26d-12v-2buc-maniamall-cars.jpg 177 177 3644157
3643916 1658657 product 0 3644169 M 0 bec-halogen-blu-xe--h7-100w-px26d-12v-2buc-maniamall-cars.jpg 177 177 3644169
3643927 1658668 product 0 3644180 M 0 priza-auto-incorporabila-din---1224v-16a---lampa-maniamall-cars.jpg 177 177 3644180
3644074 1658805 product 0 3644327 M 0 burduf-schimbator-viteza-cu-snur---galben-maniamall-cars.jpg 177 177 3644327
3644138 1658866 product 0 3644391 M 0 prezoane-antifurt-jante-sferice-m14x15mm-4buc---tip-d-maniamall-cars.jpg 177 177 3644391
3644346 1659066 product 0 3644599 M 0 maner-schimbator-viteza-imitatie-lemn-si-masaj-4cars-maniamall-cars.jpg 177 177 3644599
3644496 1659207 product 0 3644749 M 0 bec-halogen-12v---h10---42w---py20d-1buc-lampa--maniamall-cars.jpg 177 177 3644749
3644585 1659293 product 0 3644838 M 0 bec-xenon-12v---h7---35w-px26d-1buc---6000k-maniamall-cars.jpg 177 177 3644838
3644927 1659620 product 0 3645180 M 0 bec-tip-led-12v-soclu-plastic-t5-w2x46d-2buc---curcubeu-maniamall-cars.jpg 177 177 3645180
3645111 1659802 product 0 3645364 M 0 bec-led---2smd-12v-sofit-t11x36mm-soclu-sv85-8-2buc---alb-maniamall-cars.jpg 177 177 3645364
3645150 1659840 product 0 3645403 M 0 oglinda-interioara-cu-ventuza-148x60mm-carpoint-maniamall-cars.jpg 177 177 3645403
3645825 1660499 product 0 3646078 M 0 placute-frana-spate-trw---mercedes-c-class-w202w203-maniamall-cars.jpg 177 177 3646078
3646153 1660818 product 0 3646406 M 0 priza-tripla-bricheta-cu-usb-si-telecomanda-duo-4-ir-24v-maniamall-cars.jpg 177 177 3646406
3646440 1661096 product 0 3646693 M 0 huse-scaun-de-luxe-sport-edition-jacquard-high-quality-9buc---negru-maniamall-cars.jpg 177 177 3646693
3646487 1661143 product 0 3646740 M 0 breloc-chei-cu-cablu-10cm---usb-la-micro-usb-maniamall-cars.jpg 177 177 3646740
3646613 1661266 product 0 3646866 M 0 ornamente-bara-protectie-reflectorizante-cata-reflex-4buc-maniamall-cars.jpg 177 177 3646866
3646687 1661340 product 0 3646940 M 0 releu-electronic-pentru-semnalizatoare-led-61224v-maniamall-cars.jpg 177 177 3646940
3646797 1661450 product 0 3647050 M 0 coliere-fixare-proiectoare-fixer-2buc-maniamall-cars.jpg 177 177 3647050
3648729 1663387 product 0 3648982 M 0 rui-pentru-fixarea-gazonului-artificial---pachet-de-10-maniamall-cars.jpg 177 177 3648982
3649498 1664148 product 0 3649751 M 0 fierbator-apa-1l-carpoint---12v---150w-maniamall-cars.jpg 177 177 3649751
3947016 1731933 product 0 3947269 M 0 Ornamente-crom-pt--oglinda-compatibil-Land-Range-Rover-Freelander-2-Discovery-Sport-CROM-0230-MRA36-240521-3.jpg Ornamente crom pt. oglinda compatibil Land Range Rover Freelander 2 Discovery Sport CROM 0230 MRA36-240521-3 800 533 3947269
3947108 1732000 product 0 3947361 M 0 Ornamente-crom-pt--oglinda-compatibil-Dacia-Duster-2010---TR-MRA36-150421-5.jpg Ornamente crom pt. oglinda compatibil Dacia Duster 2010-> TR MRA36-150421-5 1024 561 3947361
3947593 1732317 product 0 3947846 M 0 Aparatori-noroi-dedicate-Mercedes-Clasa-E-W212-berlina-Facelift-W212---W212-T-modell-Facelift-S212--2013-2016---MUD1104-CH-2---MRA36-091220-22.jpg Aparatori noroi dedicate Mercedes Clasa E W212 berlina Facelift W212 / W212 T-modell Facelift S212 2013-2016 ( MUD1104 CH-2 ) MRA36-091220-22 720 600 3947846
3947597 1732319 product 0 3947850 M 0 Aparatori-noroi-dedicate-Land-Rover-Range-Rover-Evoque-Prestige-2011-----MUD1102-CH-2---MRA36-091220-20.jpg Aparatori noroi dedicate Land Rover Range Rover Evoque Prestige 2011-> ( MUD1102 CH-2 ) MRA36-091220-20 600 600 3947850
4986207 2072334 product 0 4986460 M 0 Suport-magnetic-auto-pentru-telefon-cu-prindere-in-grila-de-ventilatie--culoare-Negru.jpg Suport magnetic auto pentru telefon cu prindere in grila de ventilatie, culoare Negru 543 543 4986460
5641343 2253671 product 0 5641596 M 0 Set-Accesorii-Intex-pentru-Curatarea-Piscinelor--culoare-Alb-Albastru.jpg Set Accesorii Intex pentru Curatarea Piscinelor, culoare Alb/Albastru 1000 695 5641596
6559887 2539827 product 0 6560140 M 0 Termometru-alimentar-analogic-de-insertie-pentru-carne--inox--0--C---120--C--negru-argintiu.jpg Termometru alimentar analogic de insertie pentru carne, inox, 0°C - 120°C, negru/argintiu 500 500 6560140