Sandbox

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 (65696, 64821, 65686, 65690) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00046

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 (65696,64821,65686,65690) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
64821	Hand-crafted, customizable, and American made! This deep bowl modern pendant light adds a contemporary style to homes and businesses!	loma, locke, BLE-C-DBL-PC, The Loma Pendant, The Loma Pendants, The Loma Pendant light, The Loma Pendant Lights, The Loma Pendant Lighting, The Loma Ceiling Pendant, The Loma Ceiling Pendants, The Loma Ceiling Light, The Loma Ceiling Lights, The Loma Ceiling Lighting, Loma Pendant, Loma Pendants, Loma Pendant light, Loma Pendant Lights, Loma Pendant Lighting, Loma Ceiling Pendant, Loma Ceiling Pendants, Loma Ceiling Light, Loma Ceiling Lights, Loma Ceiling Lighting, Loma, The Loma, The Loma Cord Hung Pendant, The Loma Cord Hung Pendants, The Loma Cord Hung Pendant light, The Loma Cord Hung Pendant Lights, The Loma Cord Hung Pendant Lighting, The Loma Cord Hung Ceiling Pendant, The Loma Cord Hung Ceiling Pendants, The Loma Cord Hung Ceiling Light, The Loma Cord Hung Ceiling Lights, The Loma Cord Hung Ceiling Lighting, Loma Cord Hung Pendant, Loma Cord Hung Pendants, Loma Cord Hung Pendant light, Loma Cord Hung Pendant Lights, Loma Cord Hung Pendant Lighting, Loma Cord Hung Ceiling Pendant, Loma Cord Hung Ceiling Pendants, Loma Cord Hung Ceiling Light, Loma Cord Hung Ceiling Lights, Loma Cord Hung Ceiling Lighting, The Loma Cord Pendant, The Loma Cord Pendants, The Loma Cord Pendant light, The Loma Cord Pendant Lights, The Loma Cord Pendant Lighting, The Loma Cord Ceiling Pendant, The Loma Cord Ceiling Pendants, The Loma Cord Ceiling Light, The Loma Cord Ceiling Lights, The Loma Cord Ceiling Lighting, Loma Cord Pendant, Loma Cord Pendants, Loma Cord Pendant light, Loma Cord Pendant Lights, Loma Cord Pendant Lighting, Loma Cord Ceiling Pendant, Loma Cord Ceiling Pendants, Loma Cord Ceiling Light, Loma Cord Ceiling Lights, Loma Cord Ceiling Lighting, hemisphere lighting, hemisphere light, hemisphere pendant, hemisphere, hemisphere fixture, hemisphere cord light, hemisphere cord pendant, hemisphere cord, loma deep bowl, new listing, new rlm, new loma, locke, loma, The Lock Pendant, The Lock Pendants, The Lock Pendant light, The Lock Pendant Lights, The Lock Pendant Lighting, Lock Pendant, Lock Pendants, Lock Pendant light, Lock Pendant Lights, Lock Pendant Lighting, The Lock Cord Hung Pendant, The Lock Cord Hung Pendants, The Lock Cord Hung Pendant light, The Lock Cord Hung Pendant Lights, The Lock Cord Hung Pendant Lighting, Lock Cord Hung Pendant, Lock Cord Hung Pendants, Lock Cord Hung Pendant light, Lock Cord Hung Pendant Lights, Lock Cord Hung Pendant Lighting, The Lock Cord Hung Pendant light, The Lock Cord Hung Lights, The Lock Cord Hung Lighting, Lock Cord Hung Pendant light, Lock Cord Hung Lights, Lock Cord Hung Lighting, The Lock Cord Pendant light, The Lock Cord Lights, The Lock Cord Lighting, Lock Cord Pendant light, Lock Cord Lights, Lock Cord Lighting, The Lock Ceiling Pendant, The Lock Ceiling Pendants, Lock Ceiling Pendant, Lock Ceiling Pendants, The Lock Ceiling Light, The Lock Ceiling Lights, The Lock Ceiling Lighting, Lock Ceiling Light, Lock Ceiling Lights, Lock Ceiling Lighting, Lock, The Lock, The Locke Pendant, The Locke Pendants, The Locke Pendant light, The Locke Pendant Lights, The Locke Pendant Lighting, Locke Pendant, Locke Pendants, Locke Pendant light, Locke Pendant Lights, Locke Pendant Lighting, The Locke Cord Hung Pendant, The Locke Cord Hung Pendants, The Locke Cord Hung Pendant light, The Locke Cord Hung Pendant Lights, The Locke Cord Hung Pendant Lighting, Locke Cord Hung Pendant, Locke Cord Hung Pendants, Locke Cord Hung Pendant light, Locke Cord Hung Pendant Lights, Locke Cord Hung Pendant Lighting, The Locke Cord Hung Pendant light, The Locke Cord Hung Lights, The Locke Cord Hung Lighting, Locke Cord Hung Pendant light, Locke Cord Hung Lights, Locke Cord Hung Lighting, The Locke Cord Pendant light, The Locke Cord Lights, The Locke Cord Lighting, Locke Cord Pendant light, Locke Cord Lights, Locke Cord Lighting, The Locke Ceiling Pendant, The Locke Ceiling Pendants, Locke Ceiling Pendant, Locke Ceiling Pendants, The Locke Ceiling Light, The Locke Ceiling Lights, The Locke Ceiling Lighting, Locke Ceiling Light, Locke Ceiling Lights, Locke Ceiling Lighting, Locke, The Locke, BLE-C-DBL, BLE-C-DBL12, BLE-C-DBL16, BLE-C-DBL20, Dome, dome light, dome lights, dome lighting, Dome shade, dome shades, loma dome shade, loma dome shades, loma dome light shade, loma dome light shades, dome light fixture, dome light fixtures, dome lighting fixture, dome lighting fixtures, dome shade lighting, dome shade lights, dome shade light, dome shade light fixture, dome shade light fixtures, Loma dome light fixture, Loma dome light fixtures, Loma dome lighting fixture, Loma dome lighting fixtures, Loma dome shade lighting, Loma dome shade lights, Loma dome shade light, Loma dome shade light fixture, Loma dome shade light fixtures, BLE-C-DBL, Lima, loma+pendant, loma deep bowl, locke loma deep bowl, locke & loma, lima pendant, lima pendants, loma deep bowl pendant, loma deep bowl pendants, ble-dbl, ble--dbl, dbl, dome pendant light 12", Loma Collection, Loma Series, The Loma Collection, The Loma Series, SPS-0013, SPS 0013, SPS0013, teal, 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, cord loma, jadeite, jadite, jadeite light, jadite light, lomas, H-26112, H-26116, hemisphere, hemisphere collection,
65686	The farmhouse charm you love has never been more affordable! Quality and style merge beautifully with our Barn Light Basics The Original™ Warehouse Pendant!	basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, modern light, modern light fixture, original basic, the original basic, original basics, original light, the original light, warehouse pendant, original warehouse pendant, the original warehouse pendant, original cord, the original cord, original pendant, the original pendant, original cord light, the original cord light, original cord pendant, the original cord pendant, discount barn lights, discount warehouse lights, basic barn light, simple barn light, minimal barn light, back to basics, H-15112, H-15116, classic warehouse shade cord-hung pendant rlm, classic warehouse shade,
65690	Our new Barn Light Basics Seaside Pendant Light is the undeniably stylish yet budget-friendly light you've been looking for! Quality isn't sacrificed even at this great price!	basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, seaside basic, basic seaside, seaside basics, radial wave light, wave shaped pendant, seaside cord, seaside light, seaside pendant, radial wave cord light, seaside cord pendant, discount lights, basic lights, back to basics,
65696	The deep bowl style you love at a price you'll love even more! Our Barn Light Basics Wilcox Pendant Light is the perfect statement for above a dining room table!	basic light, discount light, discount lighting, better than steel lighting, budget lighting, budget friendly light, budget friendly lighting, budget friendly light fixture, barn light budget lighting, barn light discount lights, cheap lighting, barn lighting, steel lighting, modern light, modern light fixture, wilcox basic, basic wilcox, wilcox basics, bowl light, bowl shaped pendant, wilcox cord, deep bowl light, deep bowl pendant, modern cord light, modern cord pendant, discount modern lights, basic modern light, wilcox light, back to basics, H-16112, H-16116, H-16118, classic deep bowl shade, classic deep bowl shade cord-hung pendant,