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.image_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 = 'category' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    10914, 
    10851, 
    21172, 
    1165, 
    20976, 
    19350, 
    21168, 
    37453, 
    19731, 
    37445, 
    12995, 
    2876, 
    23729, 
    37544, 
    12994, 
    10981, 
    37510, 
    37436, 
    10874, 
    10893, 
    37558, 
    7127, 
    37500, 
    16864, 
    37463, 
    19506, 
    11085, 
    19386, 
    10988, 
    3275, 
    37457, 
    7128, 
    10857, 
    19544, 
    37464, 
    10956, 
    7126, 
    37593, 
    37465, 
    10955, 
    37532, 
    10967, 
    37553, 
    23197, 
    37535, 
    37539, 
    37534, 
    37537, 
    10934, 
    37528, 
    37540, 
    37536, 
    37573, 
    37458, 
    10964, 
    5865, 
    37497, 
    5869, 
    16582, 
    23787, 
    5074, 
    3129, 
    19555, 
    37522, 
    37585, 
    37466, 
    37482, 
    37467, 
    37538, 
    3341, 
    5795, 
    37557, 
    23295, 
    5862, 
    11014, 
    19474, 
    37491, 
    37446, 
    37428, 
    7131, 
    10855, 
    37555, 
    3251, 
    30008, 
    37576, 
    37559, 
    23246, 
    37549, 
    37501, 
    10976, 
    5789, 
    37449, 
    3154, 
    13461, 
    13446, 
    10886, 
    17028, 
    37579, 
    37511, 
    37468, 
    37527, 
    37543, 
    23191, 
    37469, 
    21065, 
    37562, 
    37430, 
    37581, 
    37455, 
    37515, 
    37524, 
    37529, 
    37591, 
    37612, 
    37577, 
    10895, 
    37452, 
    10940, 
    37509, 
    37561, 
    37470, 
    11122, 
    5853, 
    37614, 
    10930, 
    15302, 
    37531, 
    37589, 
    13435, 
    37438, 
    1720, 
    23739, 
    23440, 
    3398, 
    37610, 
    37456, 
    23784, 
    37447, 
    17042, 
    23301, 
    23786, 
    37461, 
    37462, 
    37609, 
    7345, 
    37471, 
    37541, 
    37506, 
    37568, 
    37514, 
    8083, 
    37490, 
    5971, 
    37483, 
    21178, 
    3274, 
    23312, 
    8900, 
    37472, 
    37484, 
    37575, 
    37604, 
    37485, 
    5870, 
    23512, 
    37613, 
    37473, 
    37547, 
    2726, 
    23298, 
    37565, 
    37586, 
    37574, 
    37546, 
    5884, 
    10887, 
    6381, 
    23102, 
    37502, 
    37572, 
    37489, 
    37488, 
    37434, 
    37495, 
    37588, 
    37587, 
    37520, 
    37592, 
    37582, 
    10960, 
    16836, 
    5842, 
    37492, 
    37494, 
    3184, 
    5837, 
    37542, 
    3126, 
    37560, 
    17053, 
    1452, 
    8094, 
    37523, 
    37605, 
    20993, 
    10983, 
    23767, 
    37440, 
    37442, 
    37444, 
    37443, 
    37441, 
    3172, 
    10933, 
    37550, 
    37475, 
    1412, 
    37477, 
    11112, 
    16887, 
    3358, 
    37611, 
    37476, 
    8124, 
    37459, 
    37607, 
    10894, 
    7221, 
    37460, 
    37554, 
    11102, 
    7890, 
    3177, 
    37503, 
    37606, 
    37526, 
    37486, 
    1465, 
    37564, 
    37584, 
    37545, 
    37533, 
    37530, 
    1152, 
    11013, 
    37551, 
    37427, 
    37451, 
    37505, 
    16568, 
    8132, 
    11116, 
    37487, 
    37571, 
    3256, 
    37519, 
    6038, 
    13450, 
    37474, 
    7888, 
    10892, 
    3174, 
    37521, 
    37580, 
    37478, 
    10913, 
    37563, 
    37608, 
    37566, 
    1571
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.10078

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1413.12"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "270.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": 270,
            "rows_produced_per_join": 270,
            "filtered": "100.00",
            "index_condition": "((`maniamall_cscart`.`cscart_images_links`.`object_type` = 'category') and (`maniamall_cscart`.`cscart_images_links`.`type` = 'M') and (`maniamall_cscart`.`cscart_images_links`.`object_id` in (10914,10851,21172,1165,20976,19350,21168,37453,19731,37445,12995,2876,23729,37544,12994,10981,37510,37436,10874,10893,37558,7127,37500,16864,37463,19506,11085,19386,10988,3275,37457,7128,10857,19544,37464,10956,7126,37593,37465,10955,37532,10967,37553,23197,37535,37539,37534,37537,10934,37528,37540,37536,37573,37458,10964,5865,37497,5869,16582,23787,5074,3129,19555,37522,37585,37466,37482,37467,37538,3341,5795,37557,23295,5862,11014,19474,37491,37446,37428,7131,10855,37555,3251,30008,37576,37559,23246,37549,37501,10976,5789,37449,3154,13461,13446,10886,17028,37579,37511,37468,37527,37543,23191,37469,21065,37562,37430,37581,37455,37515,37524,37529,37591,37612,37577,10895,37452,10940,37509,37561,37470,11122,5853,37614,10930,15302,37531,37589,13435,37438,1720,23739,23440,3398,37610,37456,23784,37447,17042,23301,23786,37461,37462,37609,7345,37471,37541,37506,37568,37514,8083,37490,5971,37483,21178,3274,23312,8900,37472,37484,37575,37604,37485,5870,23512,37613,37473,37547,2726,23298,37565,37586,37574,37546,5884,10887,6381,23102,37502,37572,37489,37488,37434,37495,37588,37587,37520,37592,37582,10960,16836,5842,37492,37494,3184,5837,37542,3126,37560,17053,1452,8094,37523,37605,20993,10983,23767,37440,37442,37444,37443,37441,3172,10933,37550,37475,1412,37477,11112,16887,3358,37611,37476,8124,37459,37607,10894,7221,37460,37554,11102,7890,3177,37503,37606,37526,37486,1465,37564,37584,37545,37533,37530,1152,11013,37551,37427,37451,37505,16568,8132,11116,37487,37571,3256,37519,6038,13450,37474,7888,10892,3174,37521,37580,37478,10913,37563,37608,37566,1571)))",
            "cost_info": {
              "read_cost": "524.97",
              "eval_cost": "27.00",
              "prefix_cost": "551.97",
              "data_read_per_join": "25K"
            },
            "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.image_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 270,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "269.29",
              "eval_cost": "27.00",
              "prefix_cost": "848.25",
              "data_read_per_join": "206K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_images), (`maniamall_cscart`.`cscart_images_links`.`image_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": 270,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "267.87",
              "eval_cost": "27.00",
              "prefix_cost": "1143.12",
              "data_read_per_join": "160K"
            },
            "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
12792 1152 category 0 13029 M 0
12941 1165 category 0 13178 M 0
16894 1412 category 0 17131 M 0
19768 1452 category 0 20005 M 0
21512 1465 category 0 21749 M 0
25123 1571 category 0 25360 M 0
58886 1720 category 0 59123 M 0
90536 2726 category 0 90773 M 0
102447 2876 category 0 102684 M 0
107599 3126 category 0 107836 M 0
107604 3129 category 0 107841 M 0
107793 3154 category 0 108030 M 0
107871 3172 category 0 108108 M 0
107875 3174 category 0 108112 M 0
107893 3177 category 0 108130 M 0
107946 3184 category 0 108183 M 0
108566 3251 category 0 108803 M 0
108594 3256 category 0 108831 M 0
110047 3274 category 0 110284 M 0
110053 3275 category 0 110290 M 0
110739 3341 category 0 110976 M 0
111115 3358 category 0 111352 M 0
233250 5074 category 0 233487 M 0
409333 5789 category 0 409570 M 0
409368 5795 category 0 409605 M 0
409651 5837 category 0 409888 M 0
409710 5842 category 0 409947 M 0
409825 5853 category 0 410062 M 0
409901 5862 category 0 410138 M 0
409922 5865 category 0 410159 M 0
409959 5869 category 0 410196 M 0
409966 5870 category 0 410203 M 0
410108 5884 category 0 410345 M 0
412214 5971 category 0 412451 M 0
413529 6038 category 0 413766 M 0
460128 6381 category 0 460365 M 0
678080 7126 category 0 678317 M 0
678120 7127 category 0 678357 M 0
678286 7128 category 0 678523 M 0
691549 7131 category 0 691786 M 0
745120 7221 category 0 745357 M 0
817856 7345 category 0 818093 M 0
921217 7888 category 0 921454 M 0
921219 7890 category 0 921456 M 0
922875 8083 category 0 923112 M 0
923766 8094 category 0 924003 M 0
924462 8124 category 0 924699 M 0
925720 8132 category 0 925957 M 0
1056234 8900 category 0 1056471 M 0
1111902 10851 category 0 1112139 M 0
1111941 10855 category 0 1112178 M 0
1111958 10857 category 0 1112195 M 0
1112068 10874 category 0 1112305 M 0
1112148 10886 category 0 1112385 M 0
1112150 10887 category 0 1112387 M 0
1112167 10892 category 0 1112404 M 0
1112169 10893 category 0 1112406 M 0
1112172 10894 category 0 1112409 M 0
1112176 10895 category 0 1112413 M 0
1112251 10913 category 0 1112488 M 0
1112264 10914 category 0 1112501 M 0
1112449 10930 category 0 1112686 M 0
1112459 10933 category 0 1112696 M 0
1112473 10934 category 0 1112710 M 0
1112615 10940 category 0 1112852 M 0
1112978 10955 category 0 1113215 M 0
1112996 10956 category 0 1113233 M 0
1113071 10960 category 0 1113308 M 0
1113078 10964 category 0 1113315 M 0
1113107 10967 category 0 1113344 M 0
1113166 10976 category 0 1113403 M 0
1113242 10981 category 0 1113479 M 0
1113264 10983 category 0 1113501 M 0
1113302 10988 category 0 1113539 M 0
1113498 11013 category 0 1113735 M 0
1113500 11014 category 0 1113737 M 0
1114146 11085 category 0 1114383 M 0
1114624 11102 category 0 1114861 M 0
1114721 11112 category 0 1114958 M 0
1114764 11116 category 0 1115001 M 0
1114925 11122 category 0 1115162 M 0
1286849 12994 category 0 1287086 M 0
1286856 12995 category 0 1287093 M 0
1298547 13435 category 0 1298784 M 0
1298614 13446 category 0 1298851 M 0
1298662 13450 category 0 1298899 M 0
1299192 13461 category 0 1299429 M 0
1393234 15302 category 0 1393471 M 0
1583573 16568 category 0 1583810 M 0
1583692 16582 category 0 1583929 M 0
1599502 16836 category 0 1599739 M 0
1600180 16864 category 0 1600417 M 0
1601759 16887 category 0 1601996 M 0
1616412 17028 category 0 1616649 M 0
1616472 17042 category 0 1616709 M 0
1616633 17053 category 0 1616870 M 0
1649480 19350 category 0 1649718 M 0
1649538 19386 category 0 1649776 M 0
1650223 19474 category 0 1650461 M 0
1650280 19506 category 0 1650518 M 0
1650361 19544 category 0 1650599 M 0
1650377 19555 category 0 1650615 M 0
1650752 19731 category 0 1650990 M 0
1653812 20976 category 0 1654050 M 0
1653870 20993 category 0 1654108 M 0
1654333 21065 category 0 1654571 M 0
1655457 21168 category 0 1655695 M 0
1655518 21172 category 0 1655756 M 0
1655562 21178 category 0 1655800 M 0
1670175 23102 category 0 1670413 M 0
1671749 23191 category 0 1671987 M 0
1671779 23197 category 0 1672017 M 0
1672833 23246 category 0 1673071 M 0
1674030 23295 category 0 1674268 M 0
1674134 23298 category 0 1674372 M 0
1674369 23301 category 0 1674607 M 0
1674811 23312 category 0 1675049 M 0
1687669 23440 category 0 1687907 M 0
1697570 23512 category 0 1697808 M 0
1697584 23729 category 0 1697822 M 0
1697848 23784 category 0 1698086 M 0
1697850 23786 category 0 1698088 M 0
2068891 30008 category 0 2069143 M 0
3642766 37427 category 0 3643019 M 0
3642776 37428 category 0 3643029 M 0
3642786 37430 category 0 3643039 M 0
3642813 37434 category 0 3643066 M 0
3642823 37436 category 0 3643076 M 0
3642829 37438 category 0 3643082 M 0
3642841 37440 category 0 3643094 M 0
3642854 37441 category 0 3643107 M 0
3642863 37442 category 0 3643116 M 0
3642867 37443 category 0 3643120 M 0
3642870 37444 category 0 3643123 M 0
3642878 37445 category 0 3643131 M 0
3642900 37446 category 0 3643153 M 0
3642910 37447 category 0 3643163 M 0
3642931 37449 category 0 3643184 M 0
3642941 37451 category 0 3643194 M 0
3642960 37452 category 0 3643213 M 0
3642982 37453 category 0 3643235 M 0
3642986 37455 category 0 3643239 M 0
3643001 37456 category 0 3643254 M 0
3643003 37457 category 0 3643256 M 0
3643005 37458 category 0 3643258 M 0
3643009 37459 category 0 3643262 M 0
3643011 37460 category 0 3643264 M 0
3643037 37461 category 0 3643290 M 0
3643041 37462 category 0 3643294 M 0
3643048 37463 category 0 3643301 M 0
3643050 37464 category 0 3643303 M 0
3643058 37465 category 0 3643311 M 0
3643060 37466 category 0 3643313 M 0
3643064 37467 category 0 3643317 M 0
3643072 37468 category 0 3643325 M 0
3643081 37469 category 0 3643334 M 0
3643083 37470 category 0 3643336 M 0
3643087 37471 category 0 3643340 M 0
3643089 37472 category 0 3643342 M 0
3643091 37473 category 0 3643344 M 0
3643266 37474 category 0 3643519 M 0
3643280 37475 category 0 3643533 M 0
3643330 37476 category 0 3643583 M 0
3643336 37477 category 0 3643589 M 0
3643393 37478 category 0 3643646 M 0
3643476 37482 category 0 3643729 M 0
3643484 37483 category 0 3643737 M 0
3643487 37484 category 0 3643740 M 0
3643489 37485 category 0 3643742 M 0
3643493 37486 category 0 3643746 M 0
3643495 37487 category 0 3643748 M 0
3643504 37488 category 0 3643757 M 0
3643515 37489 category 0 3643768 M 0
3643528 37490 category 0 3643781 M 0
3643530 37491 category 0 3643783 M 0
3643545 37492 category 0 3643798 M 0
3643606 37494 category 0 3643859 M 0
3643646 37495 category 0 3643899 M 0
3643668 37497 category 0 3643921 M 0
3643717 37500 category 0 3643970 M 0
3643734 37501 category 0 3643987 M 0
3643743 37502 category 0 3643996 M 0
3643835 37503 category 0 3644088 M 0
3643843 37505 category 0 3644096 M 0
3643850 37506 category 0 3644103 M 0
3643961 37509 category 0 3644214 M 0
3643997 37510 category 0 3644250 M 0
3644024 37511 category 0 3644277 M 0
3644046 37514 category 0 3644299 M 0
3644054 37515 category 0 3644307 M 0
3644112 37519 category 0 3644365 M 0
3644127 37520 category 0 3644380 M 0
3644161 37521 category 0 3644414 M 0
3644215 37522 category 0 3644468 M 0
3644222 37523 category 0 3644475 M 0
3644241 37524 category 0 3644494 M 0
3644305 37526 category 0 3644558 M 0
3644333 37527 category 0 3644586 M 0
3644343 37528 category 0 3644596 M 0
3644361 37529 category 0 3644614 M 0
3644367 37530 category 0 3644620 M 0
3644377 37531 category 0 3644630 M 0
3644405 37532 category 0 3644658 M 0
3644439 37533 category 0 3644692 M 0
3644464 37534 category 0 3644717 M 0
3644471 37535 category 0 3644724 M 0
3644474 37536 category 0 3644727 M 0
3644479 37537 category 0 3644732 M 0
3644509 37538 category 0 3644762 M 0
3644533 37539 category 0 3644786 M 0
3644569 37540 category 0 3644822 M 0
3644586 37541 category 0 3644839 M 0
3644639 37542 category 0 3644892 M 0
3644661 37543 category 0 3644914 M 0
3644666 37544 category 0 3644919 M 0
3644672 37545 category 0 3644925 M 0
3644699 37546 category 0 3644952 M 0
3644703 37547 category 0 3644956 M 0
3644726 37549 category 0 3644979 M 0
3644776 37550 category 0 3645029 M 0
3644784 37551 category 0 3645037 M 0
3644853 37553 category 0 3645106 M 0
3644886 37554 category 0 3645139 M 0
3644901 37555 category 0 3645154 M 0
3645078 37557 category 0 3645331 M 0
3645125 37558 category 0 3645378 M 0
3645151 37559 category 0 3645404 M 0
3645240 37560 category 0 3645493 M 0
3645258 37561 category 0 3645511 M 0
3645267 37562 category 0 3645520 M 0
3645340 37563 category 0 3645593 M 0
3645381 37564 category 0 3645634 M 0
3645425 37565 category 0 3645678 M 0
3645429 37566 category 0 3645682 M 0
3645444 37568 category 0 3645697 M 0
3645500 37571 category 0 3645753 M 0
3645511 37572 category 0 3645764 M 0
3645515 37573 category 0 3645768 M 0
3645533 37574 category 0 3645786 M 0
3645978 37575 category 0 3646231 M 0
3645993 37576 category 0 3646246 M 0
3646015 37577 category 0 3646268 M 0
3646098 37579 category 0 3646351 M 0
3646102 37580 category 0 3646355 M 0
3646125 37581 category 0 3646378 M 0
3646131 37582 category 0 3646384 M 0
3646162 37584 category 0 3646415 M 0
3646189 37585 category 0 3646442 M 0
3646204 37586 category 0 3646457 M 0
3646221 37587 category 0 3646474 M 0
3646232 37588 category 0 3646485 M 0
3646256 37589 category 0 3646509 M 0
3646315 37591 category 0 3646568 M 0
3646426 37592 category 0 3646679 M 0
3646560 37593 category 0 3646813 M 0
3648957 37604 category 0 3649210 M 0
3648995 37605 category 0 3649248 M 0
3649019 37606 category 0 3649272 M 0
3649023 37607 category 0 3649276 M 0
3649033 37608 category 0 3649286 M 0
3649070 37609 category 0 3649323 M 0
3649089 37610 category 0 3649342 M 0
3649096 37611 category 0 3649349 M 0
3649511 37612 category 0 3649764 M 0
3649556 37613 category 0 3649809 M 0
3649561 37614 category 0 3649814 M 0