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 (62839, 62843, 62844, 62847) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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 (62839,62843,62844,62847) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
62839	multi-light chandelier, industrial pendant light, industrial lighting, bare bulb light, bare bulb lighting fixture, bare bulb chandelier, industrial multi-light, industrial chandelier	Inspired by vintage industrial pendant lighting the bare-bulb look of this multi-light chandelier offers modern style for both residential and commercial lighting.	BLE-C-SCP01, The Indy Industrial Multi-Light Chandelier, multi-light chandelier, multi-light pendant, cluster pendant, cluster light, indy industrial, indy light, chandelier, industrial chandelier, cord hung chandelier, minimalist lighting, bare bulb, bare bulb lighting, bare bulb pendant, bare bulb chandelier, indy chandelier, indy light fixture, indy lighting fixtures, BLE multi light chandelier, ble chandelier, 3 and 5 light chandelier, 3 5 light chandelier, 3 5 chandelier, 3-light chandelier, 3-light chandeliers, Triple Pendant lights, Triple Pendant lights, Triple Pendant lighting, Triple Pendant light,
62843	industrial lighting fixtures, industrial pendant, industrial chandelier, minimalist lighting, minimalist chandelier, bare bulb chandelier, multi-light chandelier, bare bulb multi light, exposed bulb multi light	Minimalism meets modern lighting fixtures. This multi-light chandelier merges industrial pendant lighting into a stylish ceiling light. Perfect for commercial uses!	BLE-C-SCP04, The Downtown Minimalist Multi-Light Chandelier, multi-light chandelier, multi light chandelier, minimalist light, bare bulb light, bare bulb pendant, bare bulb chandelier, downtown, the downtown, Down town minimalist, downtown minimalist, downtown multi-light chandelier, downtown multi light, downtown multi-light, downtown pendant lighting, downtown lighting, chandelier, minimalist lighting, minimalist, minimalist chandelier, minimalist bare bulb, minimalist exposed bulb, BLE multi light chandelier, ble chandelier, 3 and 5 light chandelier, 3 5 light chandelier, 3 5 chandelier, 3-light chandelier, 3-light chandeliers, downtown, down town, down town minimalist, downtown minimalist, downtown pendant, down town pendant, minimalist pendant, downtown, down, town, downtown minimalist pendant, LCP04, PINDY, Bare bulb light, bare bulb lights, bare bulb lighting, bare bulb light fixture, bare bulb light fixtures, bare bulb lighting fixture, bare bulb lighting fixtures, Bare bulb pendant, bare bulb pendants, bare bulb ceiling pendant, bare bulb ceiling pendants, bare bulb pendant light, bare bulb pendant lights, bare bulb pendant lighting, bare bulb ceiling light, bare bulb ceiling lights, bare bulb ceiling lighting, Bare bulb chandelier, bare bulb chandeliers, bare bulb chandelier fixture, bare bulb chandelier fixtures, bare bulb multi light, bare bulb multilight, bare bulb multilights, bare bulb multilighting, bare bulb multi light, bare bulb multi lights, bare bulb multi lighting, bare bulb multi-light, bare bulb multi-lights, bare bulb multi-lighting, bare bulb multiple light, bare bulb multiple lights, bare bulb multiple lighting, multiple lighting fixtures, multiple light fixture, multiple light fixtures, multiple lighting fixture, chandelier with multiple fixtures, chandelier with multiple fixture, chandeliers with multiple fixtures, chandeliers with multiple light fixture, chandelier with multiple light fixtures, chandelier with multiple lighting fixture, chandelier with multiple lighting fixtures, chandeliers with multiple light fixtures, chandeliers with multiple lighting fixtures, Bare bulb cord, cord bare bulb, bare bulb cord hung, cord hung bare bulb, bare bulb cord hung pendant, bare bulb cord hung pendants, cord hung bare bulb pendant, cord hung bare bulb pendants, cord hung bare bulb ceiling pendant, bare bulb cord hung ceiling pendant, cord hung bare bulb ceiling pendants, bare bulb cord hung ceiling pendants, bare bulb cord hung pendant light, cord hung bare bulb pendant light, cord hung bare bulb pendant lights, bare bulb cord hung pendant lights, cord hung bare bulb pendant lighting, bare bulb cord hung pendant lighting, cord hung bare bulb ceiling light, bare bulb cord hung ceiling light, cord hung bare bulb ceiling lights, bare bulb cord hung ceiling lights, bare bulb cord hung ceiling lighting, cord hung bare bulb ceiling lighting, bare bulb cord mount, cord mount bare bulb, bare bulb cord mount pendant, bare bulb cord mount pendants, cord mount bare bulb pendant, cord mount bare bulb pendants, cord mount bare bulb ceiling pendant, bare bulb cord mount ceiling pendant, cord mount bare bulb ceiling pendants, bare bulb cord mount ceiling pendants, bare bulb cord mount pendant light, cord mount bare bulb pendant light, cord mount bare bulb pendant lights, bare bulb cord mount pendant lights, cord mount bare bulb pendant lighting, bare bulb cord mount pendant lighting, cord mount bare bulb ceiling light, bare bulb cord mount ceiling light, cord mount bare bulb ceiling lights, bare bulb cord mount ceiling lights, bare bulb cord mount ceiling lighting, cord mount bare bulb ceiling lighting, Downtown Collection, Downtown Series, The Downtown Collection, The Downtown Series, Down town Collection, Down town Series, The Down town Collection, The Down town Series, Minimalist collection, Minimalist series, The Minimalist collection, The Minimalist series, Downtown Minimalist Collection, Downtown Minimalist Series, The Downtown Minimalist Collection, The Downtown Minimalist Series, Down town Minimalist Collection, Down town Minimalist Series, The Down town Minimalist Collection, The Down town Minimalist Series, SPS-0213, SPS 0213, SPS0213, downtown multi-light collection, downtown multi light collection, downtown multi light collection, downtown multi-light series, downtown multi light series, downtown multi light series, down town multi-light collection, down town multi light collection, down town multi light collection, down town multi-light series, down town multi light series, down town multi light series, downtown multi-light chandelier collection, downtown multi light chandelier collection, downtown multi light chandelier collection, downtown multi-light chandelier series, downtown multi light chandelier series, downtown multi light chandelier series, down town multi-light chandelier collection, down town multi light chandelier collection, down town multi light chandelier collection, down town multi-light chandelier series, down town multi light chandelier series, down town multi light chandelier series, Triple Pendant lights, Triple Pendant light, Triple Pendant lighting, pindy socket, pindy sockets, pindy cup, pindy cups, pendy socket, pendy sockets, pendy cup, pendy cups, edison bulb pendant, bulb pendant,
62844	raw brass multi light, multi light chandelier, multi-light chandelier, multi light, bare bulb lighting, industrial chandelier	With a brass socket, this multi-light chandelier matches ceiling lighting with industrial pendants. This lighting fixture brings its style to commercial lighting.	BLE-C-SCP05, The Raw Brass Multi-Light Chandelier, multi light chandelier, raw brass multi light, multi-light, multi-light chandelier, bare bulb light, bare bulb multi light, raw brass chandelier, raw brass lighting, brass socket, brass socket pendant light, brass socket multi light, brass socket multi-light, barebulb multi-light, bare bulb multi-light, exposed bulb lighting, exposed bulb chandelier, multi light pendant, multi light pendant lighting, multi pendant light, multi pendant lighting, multiple light chandelier, multiple light pendant, multiple pendant chandelier, cluster pendant, cluster lighting, BLE multi light chandelier, ble chandelier, 3 and 5 light chandelier, 3 5 light chandelier, 3 5 chandelier, 3-light chandelier, 3-light chandeliers, Triple Pendant lights, Triple Pendant lighting, Triple Pendant light,
62847	BLE-C-SCP07, The Lafayette Multi-Light Chandelier, Lafayette multi light, Lafayette multi-light, Lafayette chandelier, Lafayette lighting fixture, Lafayette, Lafayette cord hung chandelier, mine shade, mini shade chandelier, minishade chandelier, cord hun	Modern style industrial pendants are gathered into a single ceiling light, resulting in a lighting fixture perfect for residential or commercial lighting.	BLE-C-SCP07, The Lafayette Multi-Light Chandelier, Lafayette multi light, Lafayette multi-light, Lafayette chandelier, Lafayette lighting fixture, Lafayette, Lafayette cord hung chandelier, mine shade, mini shade chandelier, minishade chandelier, cord hung mini shade chandelier, BLE multi light chandelier, ble chandelier, 3 and 5 light chandelier, 3 5 light chandelier, 3 5 chandelier, 3-light chandelier, 3-light chandeliers, lafayette 3-light, soho collection, soho series, The soho collection, the soho series, Lafayette collection, Lafayette series, The Lafayette collection, The Lafayette series, Lafayette soho collection, soho series, The soho collection, the soho series, SPS-0308, SPS 0308, SPS0308, Triple Pendant lights, Triple Pendant light, Triple Pendant lighting, magenta,