SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (
    12259, 12260, 12261, 12262, 12263, 12264, 
    12265, 12266, 12267, 12268, 12269, 
    12270, 12271, 12272, 12273, 12274, 
    12275, 12276, 12277, 12278, 12279, 
    12280, 12281, 12282, 12283, 12284, 
    12285, 12286, 12287, 12288, 12289, 
    12290, 12291, 12292, 12293, 12294, 
    12295, 12296, 12297, 12298, 12299, 
    12300, 12301, 12302, 12303, 12304, 
    12305, 12306, 12307, 12308, 12309, 
    12310, 12311, 12312, 12313, 12314, 
    12315, 12316, 12317, 12318, 12319, 
    12320, 12321, 12322, 12323, 12324, 
    12325, 12326, 12327, 12328, 12329, 
    12330, 12331, 12332, 12333, 12334, 
    12335, 12336, 12337, 12338, 12339, 
    12340, 12341, 12342, 12343, 12344, 
    12345, 12346, 12347, 12348
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00106

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "63.01"
    },
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id",
        "company_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code",
        "company_id"
      ],
      "key_length": "13",
      "rows_examined_per_scan": 90,
      "rows_produced_per_join": 90,
      "filtered": "100.00",
      "index_condition": "((`test2_gaseus`.`cscart_ult_product_descriptions`.`company_id` = 1) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`product_id` in (12259,12260,12261,12262,12263,12264,12265,12266,12267,12268,12269,12270,12271,12272,12273,12274,12275,12276,12277,12278,12279,12280,12281,12282,12283,12284,12285,12286,12287,12288,12289,12290,12291,12292,12293,12294,12295,12296,12297,12298,12299,12300,12301,12302,12303,12304,12305,12306,12307,12308,12309,12310,12311,12312,12313,12314,12315,12316,12317,12318,12319,12320,12321,12322,12323,12324,12325,12326,12327,12328,12329,12330,12331,12332,12333,12334,12335,12336,12337,12338,12339,12340,12341,12342,12343,12344,12345,12346,12347,12348)) and (`test2_gaseus`.`cscart_ult_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "54.01",
        "eval_cost": "9.00",
        "prefix_cost": "63.01",
        "data_read_per_join": "343K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "company_id",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "promo_text"
      ]
    }
  }
}