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 (
    1233012, 1067180, 696234, 591722, 589214, 
    1067678, 1033163, 992088, 1730410, 
    614833, 600286, 588439, 588446, 589740, 
    697903, 1067318, 1025367, 695078, 
    1233020, 599887, 1067521, 588910, 
    612038, 991897, 590755, 1025365, 622101, 
    1120163, 697332, 697155, 1073044, 
    591218, 1070391, 593887, 697609, 991976
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.01090

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "183.75"
    },
    "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 (1233012,1067180,696234,591722,589214,1067678,1033163,992088,1730410,614833,600286,588439,588446,589740,697903,1067318,1025367,695078,1233020,599887,1067521,588910,612038,991897,590755,1025365,622101,1120163,697332,697155,1073044,591218,1070391,593887,697609,991976)))",
            "cost_info": {
              "read_cost": "69.32",
              "eval_cost": "3.60",
              "prefix_cost": "72.92",
              "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": "34.65",
              "eval_cost": "3.60",
              "prefix_cost": "111.17",
              "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": "32.99",
              "eval_cost": "3.60",
              "prefix_cost": "147.75",
              "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
928998 588439 product 0 929235 M 0 bec-auto-cu-halogen-pentru-proiector-vecta-h3-24v-70w-pk22s--1-buc-kft-auto.jpg 570 800 929235
929005 588446 product 0 929242 M 0 bec-auto-led-carguard-12v-b85d-025w-cu-dulie-de-plastic-pentru-bord--2-buc-kft-auto.jpg 800 800 929242
929506 588910 product 0 929743 M 0 buson-rezervor-combustibil-citroen-c2-c3-c4-jumpy-peugeot-207-307-4007-807-modele-cu-inchidere-centralizata--motorizare-diesel-kft-auto.jpg 709 496 929743
929851 589214 product 0 930088 M 0 capac-spalator-faruri-subaru-forester-sh-012008-032013-partea-dreapta-86636-sc020-kft-auto.jpg 700 525 930088
930415 589740 product 0 930652 M 0 comutator-mecanism-ridicare-geam-skoda-fabia-1-6y-2000-2007-fata-dreapta-usi-spate-comutator-geam-6y0959855-kft-auto.jpg 800 736 930652
931487 590755 product 0 931724 M 0 furtun-umflat-roti-camioane-12-metri-culoare-albastru-kft-auto.jpg 800 777 931724
931965 591218 product 0 932202 M 0 husa-auto-scaun-cu-incalzire-automax-12v-1-buc-kft-auto.jpg 800 600 932202
932489 591722 product 0 932726 M 0 kit-reparatie-mecanism-ridicare-geam-fata-ford-focus-1-1998-2004-electrica-fata-stanga-cablu-role-si-suport-geam-kft-auto.jpg 1000 1000 932726
934728 593887 product 0 934965 M 0 racleta-auto-automax-pentru-curatat-geamurile-cu-lamela-de-235-cm--1-buc-kft-auto.jpg 800 600 934965
944398 599887 product 0 944635 M 0 carcasa-cheie-auto-briceag-cu-3-butoane-au-119-compatibil-audi-allcars.jpg 1000 1000 944635
945292 600286 product 0 945529 M 0 carcasa-cheie-auto-cu-2-butoane-si-lamela-hu43-pentru-transformat-compatibil-opel-op-150-allcars.jpg 1000 1000 945529
957411 612038 product 0 957648 M 0 intrerupator-j07---driving-light-maniacars.jpg 800 533 957648
961867 614833 product 0 962104 M 0 cupla-remorca-patrata-1300j-maniacars.jpg 800 600 962104
977158 622101 product 0 977395 M 0 dispozitiv-telescopic-de-prindere-cu-varf-magnetic-lungime-maxima-79cm-pentru-atelier-auto-.jpg 666 500 977395
1092504 695078 product 0 1092741 M 0 abtibild--dragon--alb-reflectorizant-an16-maniacars.jpg 800 349 1092741
1093476 696234 product 0 1093713 M 0 rola-ornament-neagra-cu-adeziv-8mm-x-15m-maniacars.jpg 675 450 1093713
1094906 697155 product 0 1095143 M 0 husa-auto-compatibile-duster-2008--din-9-piese-calitate-premium-maniacars.jpg 800 600 1095143
1095180 697332 product 0 1095417 M 0 set-t47-1-led-5050-smd-12v-culoare-albastru-produs-lux-maniacars.jpg 400 250 1095417
1095635 697609 product 0 1095872 M 0 oglinda-camion-universala-manuala-012-maniacars.jpg 600 450 1095872
1096105 697903 product 0 1096342 M 0 lampa-gabarit-14-x-15-de-24v-maniacars.jpg 800 600 1096342
1540592 991897 product 0 1540829 M 0 husa-volan-lux-fst01-cu-ac-si-ata-piele-cu-gaurele-marime-l-culoare-negru-mall.jpg 800 533 1540829
1540715 991976 product 0 1540952 M 0 becuri-led-sofit-canbus-6smd-36mm-3030-premium-mall.jpg 800 800 1540952
1540893 992088 product 0 1541130 M 0 set-capacele-pentru-jante-50mm-mall.jpg 800 533 1541130
1580386 1025365 product 0 1580623 M 0 cablu-frana-2m15mm---mto-bsp0758-.jpg 568 282 1580623
1580388 1025367 product 0 1580625 M 0 cablu-frana-2m15mm---mto-bsp0763-.jpg 566 216 1580625
1590406 1033163 product 0 1590643 M 0 segmenti-honda-gx-390-88mm---2mm---mto-gx0145-.jpg 320 168 1590643
1650167 1067180 product 0 1650405 M 0 kit-reparatie-mecanism-ridicare-geam-fata-mercedes-vito--viano--w639-2003-2010-electrica-dreapta-cablu-role-si-suport-geam-kft-auto.jpg 1600 807 1650405
1650431 1067318 product 0 1650669 M 0 pompa-servodirectie-vw-lt-28-35-1999-072006-pompa-hidraulica-directie-asistata--062145165c-srline-polonia-kft-auto.jpg 259 173 1650669
1650831 1067521 product 0 1651069 M 0 capac-spalator-faruri-bmw-seria-1-e81e82e87e88-092004-102013-pachet-m-partea-dreapta-61677837432-kft-auto.jpg 799 577 1651069
1651083 1067678 product 0 1651321 M 0 stop-spate-lampa-audi-a4-b6-combi--estate--avant-112000-112004-bestautovest-partea-stanga-depo-kft-auto.jpg 1000 1000 1651321
1654978 1070391 product 0 1655216 M 0 cupla-aer-m4--mufa-rapida-cot-90-grade-plastic-kft-auto.jpg 1306 726 1655216
1658093 1073044 product 0 1658331 M 0 pamatuf-lana-pentru-aplicare-parbrize-prin-lipire-cu-adeziv-womi-kft-auto.jpg 600 600 1658331
1770565 1120163 product 0 1770804 M 0 fir-cu-neon-pentru-lumina-ambientala-auto-lungime-5m-culoare-roz-.jpg 750 750 1770804
1994233 1233012 product 0 1994485 M 0 sticker-performance---suzuki-maniastiker-.jpg 640 480 1994485
1994242 1233020 product 0 1994494 M 0 sticker-sports-mind-skoda-motorsport-maniastiker-.jpg 709 709 1994494
3941946 1730410 product 0 3942199 M 0 Set-350-clipsuri-auto-Tagred-de-fixare--12-modele--cu-cutie-organizator--compatibil-Volvo-TGD13-TA1144.jpg Set 350 clipsuri auto Tagred de fixare, 12 modele, cu cutie organizator, compatibil Volvo TGD13-TA1144 1000 968 3942199