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 (61444, 62670, 63431, 61622) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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 (61444,62670,63431,61622) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61444 industrial farmhouse chandelier light, down light chandelier, cast guard and glass three light chandelier, cluster pendant light, contemporary lighting chandeliers, nautical chandelier, The Alliance 3-light chandelier is full of nautical flair with its industrial pendant style mount and cast guard and glass fixtures that reflect ample lighting. The Alliance, three light chandelier, 3-light chandelier, BLE-S-CGG3, rustic chandelier, down light, cast guard and glass chandelier, CGG, CGU, TGG, industrial chandelier, industrial chandelier lighting, industrial ceiling light, cast guard and glass, cast guard and glass lighting, cast guard and glass ceiling light, The Alliance 3 Light Chandelier, The Alliance 3-Light Chandelier, The Alliance cast guard and glass, The Alliance cast guard lighting, the alliance ceiling lights, the alliance ceiling chandelier, industrial chandelier, industrial ceiling light, The Alliance 3-Light Chandelier, The Chappel 3-Light Chandelier, The Coalition 3-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, nautical chandelier, nautical chandeliers, SPS-0236, SPS0236, SPS 0236, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, alliance chandelier, alliance chandeliers, alliance 3-light chandelier, alliance 3-light chandeliers, alliance 3 light chandelier, alliance three light chandelier, 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,
62670 3-light chandelier, industrial light fixture, industrial chandelier, modern chandelier, steampunk lighting, durable lighting, heavy duty light fixtures Our Marathon SoHo 3-Light Chandelier features three hand-spun warehouse shades in a customizable finish color. Illuminate your kitchen island, pool table or game room now! the houston street soho 3 light chandelier, houston 3-light chandelier, houston three light chandelier, houston chandelier, chandelier lighting, kitchen island light, pool table light, billiard light, game room lighting, man cave lighting, chandelier, multi light fixture, three light fixture, ble-s-ch019, soho chandelier, houston 3-light, houston 3 light, houston street 3-light, houston street 3-light chandelier, houston 3-light chandelier, Marathon SoHo 3-Light Chandelier, Marathon Soho, Marathon 3-light, Marathon 3 light, marathon three light, soho 3-light, soho 3 light, soho three light, soho, marathon, houston, soho chandelier, soho chandeliers, marathon chandelier, marathon chandeliers, SPS-0304, SPS 0304, SPS0304, SPS-0133, SPS0133, SPS 0133, marathon soho series, marathon soho collection, Houston series, houston collection, houston street soho series, houston street series, houston street collection, soho series, soho collection,
63431 Designed around timeless styles, this schoolhouse chandelier brings a new life into any location. Customizable with hand-painted stripes for additional charms! BLE-S-SCH-CH023-PC, The Schoolhouse 2-Light Chandelier, The Schoolhouse 2 Light Chandelier, The Schoolhouse Two Light Chandelier, The Schoolhouse 2-Light Chandeliers, The Schoolhouse 2 Light Chandeliers, The Schoolhouse Two Light Chandeliers, Schoolhouse 2-Light Chandelier, Schoolhouse 2 Light Chandelier, Schoolhouse Two Light Chandelier, Schoolhouse 2-Light Chandeliers, Schoolhouse 2 Light Chandeliers, Schoolhouse Two Light Chandeliers, Schoolhouse chandelier, schoolhouse chandeliers, 2-light chandelier, 2 light chandelier, two light chandelier, 2-light chandeliers, 2 light chandeliers, two light chandeliers, two light pendant, two light pendants, two light ceiling pendant, two light ceiling pendants, 2 light pendant, 2 light pendants, 2 light pendant light, 2 light pendant lights, 2 light pendant lighting, two light pendant light, two light pendant lights, two light pendant lighting, schoolhouse two light, schoolhouse two lights, schoolhouse pendant, schoolhouse pendants, schoolhouse pendant light, schoolhouse pendant lights, schoolhouse pendant lighting, school house chandelier, school house chandelier, school house chandeliers, school house two light, school house two light 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, glass chandelier, glass chandeliers, glass shade chandelier, glass shade chandeliers, glass globe chandelier, glass globe chandeliers, BLE-S-ST2-SCH10, BLE-S-ST2-SCH14, BLE-S-ST2-SCHCL10, BLE-S-ST2-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, SPS-0174, SPS 0174, SPS0174, pendants, double, 2 light school house, 2 light schoolhouse, primary schoolhouse 2 light, striped schoolhouse, striped schoolhouse light, primary 2-light, primary 2 light, primary two light, primary schoolhouse chandelier