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 (62448, 63226, 64846, 61622) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00055

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 (62448,63226,64846,61622) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61622 gooseneck arm chandelier, decorative globe chandelier, schoolhouse chandelier with colorful bands, schoolhouse chandelier, school house chandelier fixture, american made schoolhouse lighting, period arts chandelier Schoolhouse lights at its best! Handcrafted by local artisans, our Primary Schoolhouse Chandelier casts a nostalgic glow in your home’s interior. BLE-S-SCH-CH007, The Alma Mater Schoolhouse Chandelier, Alma Mater, schoolhouse chandelier, schoolhouse lighting, schoolhouse chandelier lighting, chandelier lighting, chandelier light, schoolhouse ceiling light, ceiling light, chandelier ceiling light, chandeliers, schoolhouse chandeliers, alma mater schoolhouse, alma mater schoolhouse lighting, 4-light chandelier, four light chandelier, 4-light chandelier lighting, four light chandelier lighting, schoolhouse 4-light, schoolhouse four light, Senior, Senior Schoolhouse, Senior schoolhouse light, senior schoolhouse chandelier, S-CH007, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary 4-Light Schoolhouse Chandelier, Primary 4 Light Schoolhouse Chandelier Primary four Light Schoolhouse Chandelier, Primary Schoolhouse chandelier, schoolhouse chandelier, Primary 4-Light School house Chandelier, Primary 4 Light School house Chandelier Primary four Light School house Chandelier, Primary School house chandelier, school house chandelier, 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, glass chandelier, glass chandeliers, glass shade chandelier, glass shade chandeliers, glass globe chandelier, glass globe chandeliers, BLE-S-CH007-SCH10, BLE-S-CH007-SCH14, BLE-S-CH007-SCHCL10, BLE-S-CH007-SCHCL14, Schoolhouse pendant chandelier, Schoolhouse pendant chandeliers, 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, School house chandelier collection, school house chandelier series, Schoolhouse chandelier collection, schoolhouse chandelier series, Primary schoolhouse chandelier collection, primary schoolhouse chandelier series, SPS-0172, SPS 0172, SPS0172, striped schoolhouse, striped schoolhouse light,
62448 stem pendant light, barn light chandelier, billiard lighting Three classic RLM shades are fitted to a single stem pendant to reflect a wide span of light. Customize this fixture to match your space! BLE-S-WHD12-P/ST-HANCOCK, 3-light pendant, stem pendant, stem mount pendant, benjamin, hancock, hancock stem, 3 light pendant, 3 light, hancock stem, triple chandelier, triple, drake chandelier, dino chandelier, hancock chandelier, BLE-S-ST3-WHD12, 3-light chandelier, 3-light chandeliers, Dino 3-Light Stem Mount Pendant, Dino 3 Light Stem Mount Pendant, Dino Three Light Stem Mount Pendant, Dino 3-Light chandelier, Dino 3 Light chandelier, Dino three Light chandelier, dino chandelier, Dino 3-Light Stem Mount, Dino 3 Light Stem Mount, Dino three Light Stem Mount, Dino 3-Light Pendant, Dino 3 Light Pendant, Dino three Light Pendant, dino, SPS-0258, SPS 0258, SPS0258, pool table lights, pool table light, pool table lighting, kitchen table light, kitchen table lights, kitchen table lighting, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside chandelier, Outside chandeliers, Outdoor chandelier, jadeite, jadite, jadeite light, jadite light,
63226 An industrial chandelier incorporating 3 or 5 warehouse shades! This American made lighting is handcrafted and customizable to your needs. Add to your space today! BLE-C-CH020, BLE-C-CH023, CH020, CH023, The Calico Chandelier, calico chandelier, calico, chandelier, industrial chandelier, warehouse chandelier, industrial chandelier, rustic chandelier, rustic ceiling light, rustic ceiling lights, rustic ceiling lighting, industrial ceiling light, industrial ceiling lights, industrial ceiling lighting, chain hung chandelier, chain hung ceiling light, chain hung ceiling lights, chain hung ceiling lighting, warehouse shade chandelier, shade chandelier, three light chandelier, 3 light chandelier, three fixture chandelier, 3 fixture chandelier, five light chandelier, 5 light chandelier, 5 fixture chandelier, five fixture chandelier, five, 5, three, 3, farmhouse, farm house, modern farmhouse, modern farm house, modern farmhouse light, modern farmhouse lights, modern farmhouse lighting, modern farm house light, modern farm house lights, modern farm house lighting, farmhouse light, farmhouse lights, farmhouse lighting, farm house light, farm house lights, farm house lighting, SPS-0068, Calico collection, Calico series, the calico collection, the calico series, calico 3 light,
64846 medieval round chandelier, wagon wheel chandelier, industrial wheel ceiling light, 8-light chandelier, statement light fixture, ring chandelier A customizable industrial chandelier — The Maven embodies classic styles, establishing a versatile look! Make a statement in homes and businesses with this chandelier! The Maven Chandelier, maven, outerbanks, outer banks chandelier, round chandelier, medieval chandelier, BLE-C-CH012, mavin, mavan, vintage chandelier, maven chandileir, ring chandelier, rope, rope hung, rope mount, rope mount lighting, stem mount chandelier, chandelier, industrial chandelier, rustic chandelier, farmhouse, modern farmhouse, farm house, modern farm house, modern farmhouse light, modern farmhouse lights, modern farmhouse lighting, modern farm house light, modern farm house lights, modern farm house lighting, farmhouse light, farmhouse lights, farmhouse lighting, farm house light, farm house lights, farm house lighting, maven stem, new maven, stem chandelier, stem chandeliers, Maven stem chandelier, maven stem chandeliers, mavin stem chandelier, mavin stem chandeliers, outer bank, outer banks, The Outer Banks Chandelier, wagon wheel chandelier, wagon wheel light, wagon wheel pendant,