SELECT 
  q_images.*, 
  q_images_links.*, 
  q_common_descriptions.description AS alt, 
  q_images.image_id AS images_image_id 
FROM 
  q_images_links 
  LEFT JOIN q_images ON q_images_links.detailed_id = q_images.image_id 
  LEFT JOIN q_common_descriptions ON q_common_descriptions.object_id = q_images.image_id 
  AND q_common_descriptions.object_holder = 'images' 
  AND q_common_descriptions.lang_code = 'en' 
WHERE 
  q_images_links.object_type = 'product' 
  AND q_images_links.type = 'A' 
  AND q_images_links.object_id IN (
    '47678', 
    '47679', 
    '47680', 
    '47681', 
    '47682', 
    '47683', 
    '47684', 
    '47685', 
    '47686', 
    '47688', 
    '47690', 
    '47691', 
    '47692', 
    '47693', 
    '47694', 
    '47695', 
    '47696', 
    '47697', 
    '47698', 
    '47699', 
    '47700', 
    '47701', 
    '47702', 
    '47703', 
    '47705', 
    '47706', 
    '47707', 
    '47708', 
    '47709', 
    '47710', 
    '47711', 
    '47712', 
    '47714', 
    '47719', 
    '47720', 
    '47721', 
    '47722', 
    '47725', 
    '47730', 
    '47731', 
    '47732', 
    '47733', 
    '47734', 
    '47735', 
    '47736', 
    '47737', 
    '47738', 
    '47739', 
    '47740', 
    '47741', 
    '47742', 
    '47743', 
    '47744', 
    '47745', 
    '47746', 
    '47747', 
    '47748', 
    '47749', 
    '47750', 
    '47751', 
    '47752', 
    '47753', 
    '47754', 
    '47755', 
    '47756', 
    '47757', 
    '47758', 
    '47760', 
    '47761', 
    '47762', 
    '47763', 
    '47764', 
    '47765', 
    '47766', 
    '47767', 
    '47768', 
    '47769', 
    '47770', 
    '47771', 
    '47772', 
    '47773', 
    '47774', 
    '45784', 
    '45785', 
    '45786', 
    '45787', 
    '45788', 
    '45789', 
    '45790', 
    '45791', 
    '45792', 
    '45793', 
    '45794', 
    '45795', 
    '45796', 
    '45797', 
    '45798', 
    '45799', 
    '45800', 
    '45801', 
    '45802', 
    '45803', 
    '45804', 
    '45805', 
    '45806', 
    '45807', 
    '45808', 
    '45809', 
    '45810', 
    '45811', 
    '45812', 
    '45813', 
    '45814', 
    '45815', 
    '45816', 
    '45817', 
    '45818', 
    '45819', 
    '45820', 
    '45821', 
    '45822', 
    '45823', 
    '45824', 
    '45825', 
    '45826', 
    '45827', 
    '45828', 
    '45829'
  ) 
ORDER BY 
  q_images_links.position, 
  q_images_links.pair_id

Query time 0.00953

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "929.61"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "167.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "q_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": 167,
            "rows_produced_per_join": 167,
            "filtered": "100.00",
            "index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'A') and (`portal`.`q_images_links`.`object_id` in ('47678','47679','47680','47681','47682','47683','47684','47685','47686','47688','47690','47691','47692','47693','47694','47695','47696','47697','47698','47699','47700','47701','47702','47703','47705','47706','47707','47708','47709','47710','47711','47712','47714','47719','47720','47721','47722','47725','47730','47731','47732','47733','47734','47735','47736','47737','47738','47739','47740','47741','47742','47743','47744','47745','47746','47747','47748','47749','47750','47751','47752','47753','47754','47755','47756','47757','47758','47760','47761','47762','47763','47764','47765','47766','47767','47768','47769','47770','47771','47772','47773','47774','45784','45785','45786','45787','45788','45789','45790','45791','45792','45793','45794','45795','45796','45797','45798','45799','45800','45801','45802','45803','45804','45805','45806','45807','45808','45809','45810','45811','45812','45813','45814','45815','45816','45817','45818','45819','45820','45821','45822','45823','45824','45825','45826','45827','45828','45829')))",
            "cost_info": {
              "read_cost": "328.41",
              "eval_cost": "33.40",
              "prefix_cost": "361.81",
              "data_read_per_join": "15K"
            },
            "used_columns": [
              "pair_id",
              "object_id",
              "object_type",
              "image_id",
              "detailed_id",
              "type",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "q_images",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "image_id"
            ],
            "key_length": "4",
            "ref": [
              "portal.q_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 167,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "167.00",
              "eval_cost": "33.40",
              "prefix_cost": "562.21",
              "data_read_per_join": "127K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res"
            ],
            "attached_condition": "<if>(is_not_null_compl(q_images), (`portal`.`q_images_links`.`detailed_id` = `portal`.`q_images`.`image_id`), true)"
          }
        },
        {
          "table": {
            "table_name": "q_common_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "lang_code",
              "object_holder"
            ],
            "key_length": "107",
            "ref": [
              "portal.q_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 167,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "167.00",
              "eval_cost": "33.40",
              "prefix_cost": "762.61",
              "data_read_per_join": "99K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ],
            "attached_condition": "<if>(is_not_null_compl(q_common_descriptions), (`portal`.`q_common_descriptions`.`object_id` = `portal`.`q_images`.`image_id`), true)"
          }
        }
      ]
    }
  }
}