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 (62979, 62981, 62983, 62984) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00041

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 (62979,62981,62983,62984) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
62979 Cord Hung Lighting, Pendant Light, Bare Bulb Pendant, Minimalist Lighting Fixtures Befitting both contemporary and traditional designs, the Kao showcases a bare bulb look. Add an Edison Bulb to raise the vintage vibe! Perfect for homes and businesses! The Kao Downtown Minimalist Pendant, Kao Downtown Minimalist Pendant, Downtown Minimalist Pendant, kao, Minimalist Pendant, minimalist, cord hung, cord hung lighting, ceiling lighting, ceiling light, ceiling pendant, pendant light, pendant lighting, kao lighting, kao pendant, kao cord hung, kao ceiling light, kao pendant lighting, kao minimal, kao downtown, kao down town, BLE-C-PINDY-CUP/KAO, BLE-C-PINDY-CUP, KAO, Alabax, Alabax pendant, pass and Seymour, pass & seymour, downtown, down town, down town minimalist, downtown minimalist, downtown pendant, down town pendant, minimalist pendant, downtown, down, town, downtown minimalist pendant, 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 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, pindy cup, pendy cup, 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-0039, SPS 0039, SPS0039, kao collection, kao series, kao collection, kao series, the kao collection, the kao series, koa, kao lighting, kao light, kao lights, pindy socket, pindy sockets, pindy cup, pindy cups, pendy socket, pendy sockets, pendy cup, pendy cups, kao ceramic ceiling canopy, edison bulb pendant, bulb pendant,
62981 Warehouse Lighting, Alabax lighting, Ceiling Pendant, Cord Hung Lighting Merging our classic warehouse lighting with the ceramic originally produced by Alabax. This meeting of quality is perfect for commercial spaces and homes. The Kao Eclipse Pendant, kao eclipse pendant, eclipse pendant, kao, kao pendant, cord hung lighting, koa, pendant, pendant lights, pendant lighting, ceiling light, ceiling pendants, cord hung, warehouse lighting, warehouse lights, warehouse, warehouse shade, ceramic lighting, BLE-C-WHE-PC/KAO, eclipse, pass and seymour, pass & seymour, Alabax, Alabax lighting, kao esso, esso, kao esso cord hung pendant, kao esso cord pendant, kao esso cord hung pendants, kao esso cord pendants, BLE-C-WHE8/KAO, BLE-C-WHE10/KAO, SPS-0564, SPS 0564, SPS0564, Kao collection, Kao series, kao collection, kao series, the kao collection, the kao series, koa, kao lighting, kao light, kao lights, kao ceramic ceiling canopy,
62983 Pendant lighting, Ceiling Lighting, Fluted Warehouse Shade, Ceramic Lighting With a fluted warehouse shade and a ceramic canopy, the Kao brings a unique style to any space. The Koa becomes a focal point in homes and businesses! The Kao Fluted Shade Pendant, Kao Fluted Shade Pendant, Kao Shade Pendant, Kao Fluted Pendant, kao pendant, kao, pendant, ceiling light, ceiling pendant, ceiling lighting, warehouse shade, fluted, fluted pendant, fluted ceiling pendant, ceramic, ceramic lighting, Alabax, pass & Seymour, pass and Seymour, warehouse lighting, BLE-CC-FLT-PC/KAO, BLE-CC-FLT-PC, fluted ceiling pendant, flute, flute pendant, BLE-CC-FLT10/KAO, BLE-CC-FLT12/KAO, FLK, SPS-0561, SPS 0561, SPS0561, Fluted Collection, Fluted Series, Kao collection, kao series, kao collection, kao series, the kao collection, the kao series, koa, kao lighting, kao light, kao lights, 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, fluted light, kao ceramic ceiling canopy, fluted lights,
62984 Cord Hung Lighting, Ceramic Lighting, Industrial Lighting, Pendant Lights Now industrial lighting features a glossy ceramic canopy! This ensures this ceiling light will illuminate your space for many years. Consider for both homes and businesses! The Kao Gladstone Pendant, Kao Gladstone Pendant, Kao Gladstone, Kao Pendant, kao, Gladstone pendant, Gladstone, pendant light, pendant lighting, ceiling lighting, ceiling pendant, Alabax, pass & Seymour, pass and Seymour, ceramic, ceramic lighting, ceramic pendant, porcelian, BLE-CU-DBG/KAO, BLE-CU-DBG, BLE-CU-DBG10, BLE-CU-DBG8, BLE-CU-DBG10-KAO, BLE-CU-DBG8-KAO, BLE-CU-DBG6-KAO, BLE-CU-DBG8-KAO, BLE-CU-DBG10-KAO, SPS-0374, SPS 0374, SPS0374, Gladstone Collection, Glad Stone Collection, Gladstone Series, Glad Stone Series, Kao Collection, Kao Series, kao collection, kao series, the kao collection, the kao series, koa, kao lighting, kao light, kao lights, kao ceramic ceiling canopy, jadeite, jadite, jadeite light, jadite light,