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 (61622, 61452, 60120, 61464) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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 (61622,61452,60120,61464) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
60120 industrial 3-light chandelier, three light chandelier, rlm style chandelier, vintage industrial lighting, barn style chandelier, industrial farmhouse lighting The Original™ 3-Light Stem Mount Pendant is fully customizable and handcrafted in the USA! sky chief, 3-light, stem mounted, BLE-WHS16-P/ST-FORTIFIED, 3 light, 3 light pendant, 3-light pendant, island pendant light, island light, 3 light chandelier, 3-light chandelier, fortified, 3 light pendant, 3 light, fortified stem, triple chandelier, triple, sky chief chandelier, original chandelier, fortified chandelier, The Original™ 3-Light Stem Mount Pendant, The Original 3-Light Stem Mount Pendant, Original™ 3-Light Stem Mount Pendant, Original 3-Light Stem Mount Pendant, The Original 3-Light chandelier, Original 3-Light chandelier, The Original 3-Light Stem Mount, Original 3-Light Stem Mount, The Original™ 3 Light Stem Mount Pendant, The Original 3 Light Stem Mount Pendant, Original™ 3 Light Stem Mount Pendant, Original 3 Light Stem Mount Pendant, The Original 3 Light chandelier, Original 3 Light chandelier, The Original 3 Light Stem Mount, Original 3 Light Stem Mount, Original three light chandelier, original three light stem mount, original three light pendant, original 3-light pendant, original 3 light pendant, original, the original, 3-light chandelier, 3 light chandelier, three light chandelier, 3-light pendant, 3 light pendant, three light pendant, sky chief, sky, chief, sky chief chandelier, SPS-0259, SPS0259, SPS0259, pool table lights, pool table light, pool table lighting, kitchen table light, kitchen table lights, kitchen table lighting, The Original™ series, The Original™ collection, Original™ series, Original™ collection, The Original Series, The Original Collection, The Originaltm Series, The Originaltm Collection, Original Series, Original Collection, Originaltm Series, Originaltm Collection, SPS-0259, SPS 0259, SPS0259, 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, Out side chandelier, Out side chandeliers, Outdoor chandelier, jadeite, jadite, jadeite light, jadite light,
61452 down lighting chandelier, 4-light industrial chandelier, billiard room ceiling fixture, utilitarian lighting, industrial ceiling lighting, nautical style pendant, modern rustic chandelier, factory style chandelier, This rustic chandelier features four guard and glass down lights suspended on industrial downrods. Ideal for billiard room lighting or kitchen island lighting. The Foundry, BLE-S-CH003, 4-light chandelier, four light chandelier, rustic chandelier, industrial chandelier, guard and glass chandelier, cast guard and glass ceiling fixture, The Foundry 4 Light Chandelier, foundry, chandelier, cgg, guard & glass, chandelier lighting, chandelier ceiling lighting, ceiling lights, rustic ceiling light, industrial lighting, warehouse lighting, workshop lighting, warehouse chandelier, workshop chandelier, exposed pipe lighting, foundry chandelier, rustic chandelier, rustic ceiling light, lighting fixture, The Foundry 4-Light Chandelier, The Inventor 4-Light Chandelier, The Bottom Line 4-Light Chandelier, Rugged guard light, rugged guard lights, rugged guard lighting, rugged guard light fixture, rugged guard lighting fixture, rugged guard light fixtures, rugged guard lighting fixtures, rugged guard pendant, rugged guard pendant lights, rugged guard ceiling pendant, rugged guard ceiling pendants, rugged guard ceiling light, rugged guard ceiling lights, rugged guard ceiling lighting, rugged guard chandelier, rugged guard chandeliers, SPS-0192, SPS 0192, SPS0192, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, ble-c-gg
61464 rlm warehouse chandelier, vintage industrial pendant chandelier, 4-light chandelier, four light hanging chandelier, down lighting fixture, factory light chandelier, streamline chandelier light, barn style chandelier This streamline-moderne style chandelier, The Polaris, features 4 glass and cast guards adorned with mini warehouse shades affixed to curved metal arms. The Polaris, BLE-S-CH012, 4 light chandelier, four light chandelier, CGU, CGG, TGG, rustic chandelier, nautical chandelier, The Armstrong 4-Light Chandelier, The Pioneer 4-Light Chandelier, The Polaris 4-Light Chandelier, S-CH007, polaris, polaris 4-light, polaris chandelier, Polaris 4-Light Chandelier, Polaris 4 Light Chandelier, Polaris four-Light Chandelier, Polaris four Light Chandelier, Rugged guard light, rugged guard lights, rugged guard lighting, rugged guard light fixture, rugged guard lighting fixture, rugged guard light fixtures, rugged guard lighting fixtures, Rugged guard LED light, rugged guard LED lights, rugged guard LED lighting, rugged guard LED light fixture, rugged guard LED lighting fixture, rugged guard LED light fixtures, rugged guard LED lighting fixtures, rugged guard LED pendant, rugged guard LED pendant lights, rugged guard LED ceiling pendant, rugged guard LED ceiling pendants, rugged guard LED ceiling light, rugged guard LED ceiling lights, rugged guard LED ceiling lighting, LED rugged guard pendant, LED rugged guard pendant lights, LED rugged guard ceiling pendant, LED rugged guard ceiling pendants, LED rugged guard ceiling light, LED rugged guard ceiling lights, LED rugged guard ceiling lighting, rugged guard chandelier, rugged guard chandeliers, SPS-0201, SPS 0201, SPS0201, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, ble-c-gg
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,