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 (64693, 62258, 62260, 62259) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (64693,62258,62260,62259) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
62258 Ideal for vapor proof fixtures, industrial guard lights and refrigerator lights, this replacement lamp guard has an extra thick frame. Free Shipping on light parts. Ideal for vapor proof fixtures, industrial guard lights and refrigerator lights, this replacement lamp guard has an extra thick frame. Free Shipping on light parts. BLE-TGG, industrial cast guard parts, vapor proof cast guard, vapor proof guard replacement, replacement lamp guard, Heavy Duty Cast Guard, light parts, cast guard, replacement cast guard, replacement heavy duty cast guard, cast hard,
62259 replacement part for refrigerator light, wire guard replacement, vapor proof wire guard, wire guard light accessory The wire guard replacement is ideal for vapor proof fixtures, industrial guard and glass fixtures, and refrigerator lights. This wire guard light accessory comes with Free Shipping. BLE-WGG, Wire Guard, Protective Wire Guard, wire guard replacement, replacement wire guard, light accessories, light parts, wire guard part, individual wire guard, cast hard,
62260 vapor proof guard parts, die cast vapor proof guard, light bulb cast guard, vapor tight cast guard This replacement die cast guard fits standard vapor proof and threaded fixtures and comes with a custom finish. Free Shipping with replacement light parts. BLE-CGG, Standard Cast Guard, Industrial Light Parts, light parts, cast guard, cast guard replacement, guard replacement, lighting accessories, vapor proof guard, standard vapor proof, cast hard,
64693 barn light pendant, original barn lighting flush, flush mount warehouse shade, industrial flush mount lighting, farm pendant, barn light flush mount Get stylish flush mount pendant lighting with The Original™. Customize yours with a variety of bright finishes for a modern or industrial farmhouse look. Barn Light Warehouse Pendant, flush mount, BLE-F-WHS12-PC, BLE-F-WHS14-PC, BLE-F-WHS16-PC, BLE-F-WHS18-PC, BLE-F-WHS20-PC, flush mount pendant light, flush mount lighting, flush mount pendant, flush mount pendant lighting, flush mount ceiling lighting, ceiling lighting, ceiling light, The Original™ Warehouse Flush Mount Pendant, The Original™, The Original, Original™, The Original™ ceiling mount, The Original™ flush mount, The Original™ flush mount ceiling light, The Original™ flush mount ceiling lighting, The Original™ ceiling light, The Original flush mount, The Original flush mount ceiling light, The Original flush mount ceiling lighting, The Original ceiling light, Original, Original™, wet location, outdoor light, farmhouse, modern farmhouse, farm house, modern farm house, modern farmhouse light, modern farmhouse lights, modern farmhouse lighting, modern farm house light, modern farm house lights, modern farm house lighting, farmhouse light, farmhouse lights, farmhouse lighting, farm house light, farm house lights, farm house lighting, new listing, new rlm, BLE-F-WHS16, BLE-F-WHS18, BLE-F-WHS20, BLE-F-WHS24, BLE-F-WHS28, BLE-F-WHS12, BLE-F-WHS14, cage, wire cage, wire, wire guard, Flush mount light, the original warehouse flush mount pendant, original warehouse, original warehouse shade, original warehouse shades, original ware house, original ware house shade, original ware house shades, the original barn light, warehouse flushmount, whs, SPS-0111, SPS 0111, SPS0111, original series, original collection, original™ series, original™ collection, originaltm collection, originaltm series, the original series, the original collection, the original™ series, the original™ collection, originaltm collection, originaltm series, original warehouse flushmount, original flushmount, Small mount lighting, Small mount light, Small mount lights, flush mount outdoor, Flush mount barn lights for ceilings, foyer light, foyer lights, foyer lighting, The Originaltm Warehouse Flush Mount Pendant Light, Originaltm Warehouse Flush Mount Pendant Light, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside flush mount, Outside flush mounts, Outside flush mount light, Outside flush mount lights, Outside flush mount lighting, Outside flush mount light fixture, Outside flush mount light fixtures, Outside flush mount lighting fixture, Outside flush mount lighting fixtures, Outside flush mount pendant, Outside flush mount pendants, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, Semi flush farmhouse light, Semi-flush farmhouse light, ceiling flush mount, 24" shade, 28" shade, jadeite, jadite, jadeite light, jadite light,