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 (64941, 64942, 64943, 61954) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00062

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 (64941,64942,64943,61954) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61954 clear glass schoolhouse globe, schoolhouse globe with clear glass, flush mounted schoolhouse light, flush schoolhouse ceiling light, flush mount ceiling light with glass globe, american made schoolhouse globe, This vintage-inspired schoolhouse flush mount’s rounded glass globe elevates the smaller areas of homes and businesses! Fully customizable! BLE-F-SCH-PC, Letterman Schoolhouse Flush Mount Light, clear glass schoolhouse, glass flush mount, flush mount light, clear schoolhouse lighting, flush mount schoolhouse lighting, flush mount ceiling light, ceiling lighting, schoolhouse ceiling lighting, schoolhouse ceiling pendant, clear schoolhouse pendant, ceiling mount lighting, clear schoolhouse ceiling mount, ceiling mount, ceiling mount lighting, clear glass lighting, clear glass shade, clear glass lighting, clear shade, glass shade, Rudimentary, Rudimentary schoolhouse, Rudimentary schoolhouse light, The Rudimentary Schoolhouse Light, The Rudimentary Schoolhouse, schoolhouse, school house, schoolhouse glass, glass schoolhouse, school, school house glass, glass school house, school glass, glass school, schoolhouse flush, school house flush, flush schoolhouse, flush school house, flush mount schoolhouse, schoolhouse flush mount, schoolhouse flush mounts, school house flush mounts, schoolhouse flush mount light, school house flush mount light, schoolhouse ceiling mount, school house ceiling mount, schoolhouse ceiling, school house ceiling, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary Schoolhouse Flush Mount Light, Primary Schoolhouse Flush Mount, Primary Schoolhouse Flush Mount Pendant, Primary Flush Mount Light, Primary Flush Mount, Primary School house Flush Mount Light, Primary School house Flush Mount, Primary School house Flush Mount Pendant, glass lighting, glass lighting fixture, glass lighting fixtures, glass shade, glass shades, glass shade light, glass shade lights, glass shade lighting, glass globe, glass globes, glass globe shade, glass globe shades, glass globe light, glass globe lighting, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass light fixture, glass light fixtures, glass pendant light, glass pendant lights, glass pendant lighting, glass pendant light fixture, glass pendant light fixtures, glass pendant lighting fixture, glass pendant lighting fixtures, glass shade pendant light, glass shade pendant lights, glass shade pendant lighting, glass globe pendant light, glass globe pendant lighting, glass globe pendant lighting, glass globe pendant lights, glass globe shade pendant light, glass globe shade pendant lights, glass globe shade pendant lighting, glass ceiling light, glass ceiling lights, glass ceiling lighting, glass ceiling lighting fixture, glass ceiling lighting fixtures, glass shade ceiling light, glass shade ceiling lights, glass shade ceiling lighting, glass globe ceiling light, glass globe ceiling lighting, glass globe shade ceiling light, glass globe shade ceiling lights, glass globe shade ceiling lighting, glass ceiling light fixture, glass ceiling light fixtures, glass ceiling pendant, glass ceiling pendants, glass shade ceiling pendant, glass shade ceiling pendants, glass globe ceiling pendant, glass globe ceiling pendants, glass globe shade ceiling pendant, glass globe shade ceiling pendants, BLE-F-SCH10, BLE-F-SCH14, BLE-F-SCHCL10, BLE-F-SCHCL14, sch, Schoolhouse collection, schoolhouse series, the schoolhouse collection, the schoolhouse series, School house collection, school house series, the school house collection, the school house series, primary Schoolhouse collection, primary schoolhouse series, the primary schoolhouse collection, the primary schoolhouse series, primary School house collection, primary school house series, the primary school house collection, the primary school house series, primary collection, primary series, the primary collection, the primary series, SPS-0069, SPS0069, SPS 0069, Flush mount school house, Flush mount schoolhouse, Small mount lighting, Small mount light, Small mount lights, Flushmount schoolhouse lights, foyer light, foyer lights, foyer lighting, school light, school lights, school lighting, school, ceiling flush mount, striped schoolhouse, striped schoolhouse light,
64941 A replacement acorn schoolhouse glass shade for your favorite Barn Light Electric fixtures! Customize the glass with hand-painted bands for a unique look! Acorn Schoolhouse Glass, Replacement Acorn Schoolhouse Glass, Acorn Glass, Replacement Acorn Glass, Schoolhouse Acorn Glass, Replacement schoolhouse, replacement schoolhouse glass, Acorn School house Glass, Replacement Acorn School house Glass, School house Acorn Glass, replacement school house glass, Acorn Schoolhouse Globe, Replacement Acorn Schoolhouse Globe, Acorn Globe, Replacement Acorn Globe, Schoolhouse Acorn Globe, replacement schoolhouse globe, Acorn School house Globe, Replacement Acorn School house Globe, School house Acorn Globe, replacement school house globe, Acorn Schoolhouse Shade, Replacement Acorn Schoolhouse Shade, Acorn Shade, Replacement Acorn Shade, Schoolhouse Acorn Shade, replacement schoolhouse shade, Acorn School house Shade, Replacement Acorn School house Shade, School house Acorn Shade, replacement school house shade, acorn, BLE-ACN-GLASS, replacement globes, striped schoolhouse, striped schoolhouse light,
64942 This replacement round schoolhouse glass is available in multiple sizes and with hand-painted bands in various colors! BLE-RND-GLASS, Round Schoolhouse Glass, Replacement Round Schoolhouse Glass, Round Glass, Replacement Round Glass, Schoolhouse Round Glass, Replacement schoolhouse, replacement schoolhouse glass, Round School house Glass, Replacement Round School house Glass, School house Round Glass, replacement school house glass, Round Schoolhouse Globe, Replacement Round Schoolhouse Globe, Round Globe, Replacement Round Globe, Schoolhouse Round Globe, replacement schoolhouse globe, Round School house Globe, Replacement Round School house Globe, School house Round Globe, replacement school house globe, Round Schoolhouse Shade, Replacement Round Schoolhouse Shade, Round Shade, Replacement Round Shade, Schoolhouse Round Shade, replacement schoolhouse shade, Round School house Shade, Replacement Round School house Shade, School house Round Shade, replacement school house shade, round, replacement globes, striped schoolhouse, striped schoolhouse light,
64943 Fully customizable with hand-painted bands in several colors and two glass options, replace broken shade with this drum schoolhouse glass! BLE-DRM-GLASS, Drum Schoolhouse Glass, Replacement Drum Schoolhouse Glass, Drum Glass, Replacement Drum Glass, Schoolhouse Drum Glass, Replacement schoolhouse, replacement schoolhouse glass, Drum School house Glass, Replacement Drum School house Glass, School house Drum Glass, replacement school house glass, Drum Schoolhouse Globe, Replacement Drum Schoolhouse Globe, Drum Globe, Replacement Drum Globe, Schoolhouse Drum Globe, replacement schoolhouse globe, Drum School house Globe, Replacement Drum School house Globe, School house Drum Globe, replacement school house globe, Drum Schoolhouse Shade, Replacement Drum Schoolhouse Shade, Drum Shade, Replacement Drum Shade, Schoolhouse Drum Shade, replacement schoolhouse shade, Drum School house Shade, Replacement Drum School house Shade, School house Drum Shade, replacement school house shade, drum, replacement globes, striped schoolhouse,