Sandbox

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 (59877, 63434, 63136, 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 (59877,63434,63136,61622) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
59877	2-light warehouse shade pendant, warehouse shade chandelier, double light stem mount pendant, rlm shade 2-light pendant, billiard room lighting, kitchen island light fixture, kitchen island industrial light, commercial chandel	Light up your kitchen island or billiard table with this barn style double-light pendant. Customize its two classic shades with one of our eye-catching finishes!	The Gilmore 2-Light Stem Mount Pendant, BLE-S-ST2-WHS16, sky chief, double chandelier, 2-light chandelier, gilmore, the gilmore 2-light stem mount pendant, 2 light pendant, 2 light, gilmore stem, double chandelier, double, sky chief chandelier, original chandelier, skychief chandelier, 2 light chandelier, chandelier, the original chandelier, the original 2-light chandelier, original 2-light chandelier, original chandelier, two light original, 2-light original, The Original™ 2-Light Stem Mount Pendant, original two light pendant, original 2-light pendant, original pendant, SPS-0056, SPS0056, SPS 0056, pool table lights, pool table light, pool table lighting, kitchen table light, kitchen table lights, kitchen table lighting, dining room table light, dining room table lighting, dining room table lights, 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, 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, pendants, double, outdoor chandelier, original 2 light, original 2 light stem mount, jadeite, jadite, jadeite light, jadite light,
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,
63136		Influenced by the trendy look of SoHo, New York this rustic chandelier brings both the style and craftsmanship of industrial lighting fixtures to any space!	The Canal Street SoHo 2 Light Chandelier, BLE-S-CH021, Canal, Canal Street, Soho, Soho lighting, Soho pendant, soho chandelier, rustic lighting, rustic chandelier, canal street, canal street chandelier, canal st., soho 2 light, soho 2 light chandelier, soho industrial, industrial chandelier, two light, 2 light, 2-light, 2 light chandelier, 2-light chandelier, two light chandelier, industrial pendant chandelier, galvanized, galvanized piping, galvanized soho, chandelier, Canal Street SoHo 2 Light Chandelier, Canal Street SoHo 2-Light Chandelier, canal street 2-light, canal street chandelier, canal chandelier, soho chandelier, soho, canal, soho two light, canal two light, SPS-0065, SPS 0065, SPS0065, soho collection, soho series, pendants, double, pendants, double
63434		Three fashionable schoolhouse shades are united into a single chandelier. This gives any residential or commercial a striking centerpiece, elevating your overall décor!	BLE-S-SCH-CH024-PC, The Schoolhouse 3-Light Chandelier, The Schoolhouse 3 Light Chandelier, The Schoolhouse Three Light Chandelier, Schoolhouse 3-Light Chandelier, Schoolhouse 3 Light Chandelier, Schoolhouse Three Light Chandelier, The Schoolhouse 3-Light Chandeliers, The Schoolhouse 3 Light Chandeliers, The Schoolhouse three Light Chandeliers, Schoolhouse 3-Light Chandeliers, Schoolhouse 3 Light Chandeliers, Schoolhouse three Light Chandeliers, Schoolhouse chandelier, schoolhouse chandeliers, school house chandelier, school house chandeliers, 3-light chandelier, 3 light chandelier, three light chandelier, 3-light chandeliers, 3 light chandeliers, three light chandeliers, three light pendant, three light pendants, 3 light pendant, 3 light pendants, 3-light pendant, 3-light pendants, 3-light pendant light, 3-light pendant lights, 3-light pendant lighting, 3 light pendant light, 3 light pendant lights, 3 light pendant lighting, three light pendant light, three light pendant lighting, school house light, school house lights, school house lighting, school house pendant, school house pendants, school house pendant light, school house pendant lights, school house pendant lighting, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary 3-Light Schoolhouse Chandelier, Primary 3-Light Chandelier, Primary four Light Schoolhouse Chandelier, Primary Schoolhouse Chandelier, Primary 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-ST3-SCH10, BLE-S-ST3-SCH14, BLE-S-ST3-SCHCL10, BLE-S-ST3-SCHCL14, Schoolhouse pendant chandelier, Schoolhouse pendant chandeliers, 3 light schoolhouse chandelier, 3 light schoolhouse 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-0173, SPS0173, SPS 0173, primary schoolhouse 3 light chandelier, striped schoolhouse, striped schoolhouse light,