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 (65698, 65691, 65700, 64706) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00051

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 (65698,65691,65700,64706) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
64706 large outdoor lights, dark sky barn lighting, vintage gooseneck lighting Attentively handcrafted, fully customizable gooseneck lighting! Bring a timeless yet modern look to indoor and outdoor décors with the USA-made Bomber Gooseneck! Goodrich® Bomber Gooseneck Light, BLE-G-WHB, gooseneck, gooseneck, bomber gooseneck, gooseneck bomber, BLE-G-WHB11, BLE-G-WHB13, BLE-G-WHB15, BLE-G-WHB17, new listing, new rlm, new bomber, Warehouse, warehouse shade, barn light, gooseneck light, Old dixie, Gooseneck, Old dixie gooseneck, BLE-G-WHB11-PC, BLE-G-WHB13-PC, BLE-G-WHB15-PC, BLE-G-WHB17-PC, The Old Dixie Gooseneck Light, old Dixie gooseneck, old Dixie wall light, old Dixie gooseneck lighting, old Dixie warehouse shade, old Dixie warehouse lighting, old Dixie warehouse barn light, old Dixie warehouse gooseneck, Dixie warehouse, Dixie gooseneck, Dixie gooseneck barn light, Dixie wall light, Old Dixie, Goodrich Gooseneck Light, Goodrich Gooseneck Lights, Goodrich Gooseneck Lighting, Goodrich Gooseneck Wall Light, Goodrich Gooseneck Wall Lights, Gooseneck Light, gooseneck lighting, BLE-WHB17-P/G19, goodrich husky, g19, large gooseneck light, big gooseneck light, 17", BLE-G-WHB11, BLE-G-WHB13, BLE-G-WHB15, BLE-G-WHB17, goodyear, whb, whn, bomber lighting outdoor, outdoor bomber lighting, bomber light outdoor, bomber lights outdoor, bomber series, bomber collection, SPS-0149, SPS0149, SPS 0149, outdoor gooseneck barn lights, outdoor gooseneck barn light, outdoor gooseneck barn lighting, Outdoor garage lights, Outdoor garage light, Outdoor garage lighting, Out door garage lights, Out door garage light, Out door garage lighting, dark sky, dark-sky, Warehouse Gooseneck Lights, Warehouse Gooseneck Light, Warehouse Gooseneck Lighting, Ware house Gooseneck Lights, Ware house Gooseneck Light, Ware house Gooseneck Lighting, Warehouse Goose neck Lights, Warehouse Goose neck Light, Warehouse Goose neck Lighting, Ware house Goose neck Lights, Ware house Goose neck Light, Ware house Goose neck Lighting, Warehouse Gooseneck, Warehouse Goosenecks, Ware house Gooseneck, Ware house Goosenecks, Ware house Goose neck, Ware house Goose necks, Gooseneck Warehouse Lights, Gooseneck Warehouse Light, Gooseneck Warehouse Lighting, Gooseneck Ware house Lights, Gooseneck Ware house Light, Gooseneck Ware house Lighting, Goose neck Warehouse Lights, Goose neck Warehouse Light, Goose neck Warehouse Lighting, Goose neck Ware house Lights, Goose neck Ware house Light, Goose neck Ware house Lighting, Gooseneck Warehouse, Gooseneck Ware house, Goose neck Warehouse, Goose neck Ware house, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside lighting, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, bleg, jadeite, jadite, jadeite light, jadite light,
65691 Sticking to a budget but don't want to sacrifice on quality or style? Our Barn Light Basics Aero Gooseneck Light is the light you've been looking for! 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, discount modern lights, basic modern light, aero gooseneck, aero light, aero basic, aero gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, aero gooseneck, aero discount light, back to basics,
65698 Now more budget friendly than ever, our weather resistant aluminum Barn Light Basics Fire Chief Sign Light is the sleek and inviting fixture your business needs! 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, fire chief gooseneck, fire chief light, fire chief basic, fire chief gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, fire chief discount light, discount sign light, basic sign light, budget sign light, budget friendly sign light, firechief discount, firechief discount light, firechief basic, firechief basic light, discounted sign light, firechief basics, back to basics,
65700 Our sturdy, all-weather Avalon shade is now at a cost your budget will love! Our Barn Light Basics Avalon Gooseneck Light is the perfect balance of efficiency and style! All Weather, Gooseneck, Warehouse Shade, Warehouse Gooseneck, BLE-G-LCS-PC, wall light, exterior, Discount gooseneck, All Weather Gooseneck 12," 14" and 16" Warehouse Shade, All weather goose neck, all weather warehouse shade, all weather ware house shade, All weather warehouse light, All weather warehouse lights, All weather warehouse lighting, All weather light, All weather lights, All weather lighting, All weather ware house light, All weather ware house lights, All weather ware house lighting, All weather farmhouse, All weather farm house, All weather outdoor lighting, All weather outdoor light, All weather outdoor lights, all weather gooseneck farm light wall mount, all weather gooseneck farm light wall mounts, all weather gooseneck wall mount, all weather gooseneck wall mounts, all weather gooseneck wall mount light, all weather gooseneck wall mount lights, all weather gooseneck wall mount lighting, all weather wall mount, all weather wall mounts, all weather gooseneck wall mount light, all weather gooseneck wall mount lights, all weather gooseneck wall mount lighting, all weather wall mount light, all weather wall mount lights, all weather wall mount lighting, All weather Gooseneck Farm light, All weather Gooseneck Farm lights, All weather Gooseneck Farm lighting, All weather Goose neck Farm light, All weather Goose neck Farm lights, All weather Goose neck Farm lighting, All weather gooseneck light, All weather gooseneck lights, All weather gooseneck lighting, All weather gooseneck, All weather wall mount, All weather wall mounts, All weather wall mount light, All weather wall mount lights, All weather wall mount lighting, 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, discount modern lights, basic modern light, avalon gooseneck, avalon light, avalon basic, avalon gooseneck light, discount gooseneck light, discount goosenecks, basic goosenecks, budget gooseneck lights, budget friendly gooseneck lights, avalon gooseneck, avalon discount light, budget lights, farm & barn, farm and barn, all weather, all-weather, all weather gooseneck warehouse light, back to basics,