SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (61517, 64689) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00053

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 2,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (61517,64689) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61517 wire guard warehouse shade pendant light, industrial guard shade pendant, wire guard ceiling light, caged pendant light The Blue Collar pendant shows off industrial styling with its wire cage guard silhouette. This caged pendant light is ideal for kitchen lighting and bright task lighting! Blue Collar Pendant, BLE-C-WGGWS, wire guard warehouse shade, wire guard shade, wire guard pendant, cage light, BLE-C-WGGWS12, BLE-C-WGGWS14, BLE-C-WGGWS16, caged pendant, caged pendant light, caged light, blue collar wire guard, blue collar warehouse shade, blue collar pendant, blue collar caged pendant, blue collar cage pendant, blue collar wire cage pendant, blue collar wire cage guard pendant, blue collar cage light, blue collar wire cage light, blue collar, blue collar cord hung, blue collar cord hung pendant, blue collar ceiling light, wire cage ceiling light, blue collar wire cage ceiling light, cord hung cage light, cage light, cage guard light, wire guard cage, wire guard light, blue collar wire guard, new listing, BLE-C-WGGWS12, BLE-C-WGGWS14, BLE-C-WGGWS16, blue collar collection, blue collar series, the blue collar collection, the blue collar series, SPS-0054, SPS 0054, SPS0054, corded pendant, corded pendants, corded pendant light, corded pendant lights, corded pendant lighting, corded ceiling pendant, corded ceiling pendants, corded ceiling light, corded ceiling lights, corded ceiling lighting, corded pendant light fixture, corded pendant light fixtures, corded pendant lighting fixture, corded pendant lighting fixtures, corded light fixture, corded light fixtures, corded lighting fixture, corded lighting fixtures, corded,
64689 Our Chicken Wire Stem Mount Pendant Light offers a unique focal point to homes and businesses! Choose a vivid finish color and revamp your décor today! new listing, chicken stem, chicken pendant, chicken wire, BLE-S-EIO, Chicken Wire Stem Mount Pendant Light, Chicken Wire Stem Mount Pendant Lights, Chicken Wire Stem Mount Pendant Lighting, Chicken Wire Stem Pendant, Chicken Wire Stem Pendants, Chicken Wire Stem Pendant Light, Chicken Wire Stem Pendant Lights, Chicken Wire Stem Ceiling Pendant, Chicken Wire Stem Ceiling Pendants, Chicken Wire Stem, Chicken Wire, Chickenwire, Chicken Wire Pendant, Chicken Wire Pendants, Chicken Wire stem pendant, Chicken Wire stem Pendants, Chicken Wire stem Pendant Light, Chicken Wire stem, Chicken Wire stem Pendant Lights, Chicken Wire stem Pendant Lighting, BLE-C-EIO, Chicken Wire Ceiling Pendant, Chicken Wire Ceiling Pendants, Chicken Wire Ceiling Light, Chicken Wire Ceiling Lights, Chicken Wire Ceiling Lighting, Farmhouse, Farmhouse Lighting, chicken wire light, chicken wire lights, chicken wire lighting, chicken wire collection, chicken wire series, SPS-0451, SPS 0451, SPS0451, stems, Stem pendant lights, stem light mount, stem light mounts, stem, basket, chicken wire basket, basket light,