SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    10965, 
    10975, 
    10966, 
    10967, 
    10968, 
    10969, 
    10970, 
    10971, 
    10972, 
    10973, 
    10974, 
    10985, 
    10995, 
    10986, 
    10987, 
    10988, 
    10989, 
    10990, 
    10991, 
    10992, 
    10993, 
    10994, 
    11005, 
    11016, 
    11006, 
    11007, 
    11008, 
    11009, 
    11010, 
    11011, 
    11012, 
    11013, 
    11014, 
    11015, 
    11027, 
    11037, 
    11028, 
    11029, 
    11030, 
    11031, 
    11032, 
    11033, 
    11034, 
    11035, 
    11036, 
    11047, 
    11057, 
    11048, 
    11049, 
    11050, 
    11051, 
    11052, 
    11053, 
    11054, 
    11055, 
    11056, 
    11067, 
    11078, 
    11068, 
    11069, 
    11070, 
    11071, 
    11072, 
    11073, 
    11074, 
    11075, 
    11076, 
    11077, 
    11089, 
    11100, 
    11090, 
    11091, 
    11092, 
    11093, 
    11094, 
    11095, 
    11096, 
    11097, 
    11098, 
    11099, 
    11111, 
    11122, 
    11112, 
    11113, 
    11114, 
    11115, 
    11116, 
    11117, 
    11118, 
    11119, 
    11120, 
    11121, 
    11133, 
    11143, 
    11134, 
    11135, 
    11136, 
    11137, 
    11138, 
    11139, 
    11140, 
    11141, 
    11142, 
    11153, 
    11163, 
    11154, 
    11155, 
    11156, 
    11157, 
    11158, 
    11159, 
    11160, 
    11161, 
    11162, 
    11173, 
    11184, 
    11174, 
    11175, 
    11176, 
    11177, 
    11178, 
    11179, 
    11180, 
    11181, 
    11182, 
    11183, 
    11195, 
    11205, 
    11196, 
    11197, 
    11198, 
    11199, 
    11200, 
    11201, 
    11202, 
    11203, 
    11204
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00366

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "350.31"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "147.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": 147,
            "rows_produced_per_join": 147,
            "filtered": "100.00",
            "index_condition": "((`gaseus`.`cscart_images_links`.`object_type` = 'product') and (`gaseus`.`cscart_images_links`.`type` = 'M') and (`gaseus`.`cscart_images_links`.`object_id` in (10965,10975,10966,10967,10968,10969,10970,10971,10972,10973,10974,10985,10995,10986,10987,10988,10989,10990,10991,10992,10993,10994,11005,11016,11006,11007,11008,11009,11010,11011,11012,11013,11014,11015,11027,11037,11028,11029,11030,11031,11032,11033,11034,11035,11036,11047,11057,11048,11049,11050,11051,11052,11053,11054,11055,11056,11067,11078,11068,11069,11070,11071,11072,11073,11074,11075,11076,11077,11089,11100,11090,11091,11092,11093,11094,11095,11096,11097,11098,11099,11111,11122,11112,11113,11114,11115,11116,11117,11118,11119,11120,11121,11133,11143,11134,11135,11136,11137,11138,11139,11140,11141,11142,11153,11163,11154,11155,11156,11157,11158,11159,11160,11161,11162,11173,11184,11174,11175,11176,11177,11178,11179,11180,11181,11182,11183,11195,11205,11196,11197,11198,11199,11200,11201,11202,11203,11204)))",
            "cost_info": {
              "read_cost": "85.71",
              "eval_cost": "14.70",
              "prefix_cost": "100.41",
              "data_read_per_join": "13K"
            },
            "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": "4",
            "ref": [
              "gaseus.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 147,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "36.75",
              "eval_cost": "14.70",
              "prefix_cost": "151.86",
              "data_read_per_join": "112K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res"
            ]
          }
        },
        {
          "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": "108",
            "ref": [
              "gaseus.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 147,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "36.75",
              "eval_cost": "14.70",
              "prefix_cost": "203.31",
              "data_read_per_join": "87K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}