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 (61452, 61461, 62383, 62666) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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 (61452,61461,62383,62666) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
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
61461	gooseneck arm pendant light, industrial down light chandelier, industrial farmhouse chandelier, streamline moderne light fixture, industrial farmhouse lighting, cast guard and glass decorative fixture, four light chandelier pendant, melon ball fixture	A fine example of Space Age-inspired lighting, The Aldrin industrial chandelier, casts ample light with its four guard and glass fixtures on sloping arms.	The Aldrin, BLE-S-CH008, industrial chandelier, rustic chandelier, cast guard and glass, guard and glass pendant, space age, The Aldrin 4 Light Chandelier, Aldrin 4 Light Chandelier, Aldrin industrial chandelier, cgg, cgg lighting, 4 light chandelier, four light chandelier, chandelier, rustic chandelier, entryway light, entryway lighting, entryway chandelier, outdoor lighting, outdoor lights, exterior lighting, exterior lights, aldrin, aldren, 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-0196, SPS 0196, SPS0196, 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
62383	bulbless led, led guard and glass, led sputnik	The Sputnik shows off space-age style with four stem arms and LED guard and glass fixtures! Save energy with our new bulbess LED technology from Cree, Inc.	Sputnik LED 4 Light Chandelier, BLE-S-CGG-CH008-PC-LED, rustic led chandelier, led chandelier, cast guard and glass chandelier, led cast guard and glass chandelier, vapor jar led chandelier, led cast guard 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 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 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, LED rugged guard chandelier, LED rugged guard chandeliers, Rugged guard led chandelier, rugged guard LED chandeliers, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, SPS-0202, SPS 0202, SPS0202, sputnik chandelier, sputnik chandeliers, ble-c-gg, spud nick,
62666	Steel pipe lighting fixture, RLM shade chandelier, modern style lighting, 4 light modern chandelier, handmade lighting fixtures, artistic lighting fixtures, warehouse lighting	An industrial-chic design! Inspired by classic SoHo styles for a modern appeal. Customize this 4-light chandelier to match your space!	the houston street soho 4 light chandelier, houston industrial ceiling chandelier, houston industrial chandelier, chandeliers, industrial chandeliers, industrial chandeliers, rustic lighting, porch light, warehouse chandelier, BLE-S-CH016, soho chandelier, houston street 4-light, houston street 4 light, 4-light chandelier, 4 light chandelier, 4-light chandeliers, 4 light chandeliers, Marathon SoHo 4-Light Chandelier, Marathon SoHo Chandelier, Marathon Chandelier, marathon, marathon soho, soho 4-light chandelier, soho 4 light chandelier, soho four light chandelier, SPS-0305, SPS 0305, SPS0305, 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,