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 (61453, 61461, 61456, 61465) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

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 (61453,61461,61456,61465) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61453	the assembly line chandelier, circular gooseneck chandelier, streamline moderne chandelier, guard and glass chandelier, mid century modern industrial chandelier, galvanized chandelier lightning, industrial chandelier, industrial-style chandelier	A striking, timeless chandelier, the Orbiter is fully customizable to bring a bold style to every home and business. Durable, long-lasting, and stylish: Elevate your decor with the Orbiter!	The Orbiter, the Assembly Line, rustic chandelier, gooseneck arm chandelier, space age chandelier, industrial chandelier, guard and glass, BLE-S-CH004, orbiter, orbiter ceiling light, orbiter ceiling lighting, The Orbiter 4 Light Chandelier, orbiter 4 light chandelier, orbiter chandelier, 4 light, four light, industrial lighting, space age design, cgg, rustic lighting, rustic ceiling lights, rustic ceiling lighting, rustic chandelier, gooseneck chandelier, orbiter gooseneck chandelier, gooseneck arm lighting, industrial chandelier, industrial ceiling light, orbiter industrial ceiling light, orbiter industrial chandelier, Orbiter 4-Light Chandelier, 4-light chandelier, 4-light chandeliers, 4 light chandelier, 4 light chandeliers, four light chandelier, four light chandeliers, 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 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, LED rugged guard chandelier, LED rugged guard chandeliers, Rugged guard led chandelier, rugged guard LED chandeliers, orbitor, orbitor chandelier, SPS-0195, SPS 0195, SPS0195, 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
61456	heavy duty industrial chandelier, large sputnik chandelier, atomic age chandelier, mid century hanging chandelier, eight light chandelier, huge chandelier, contemporary lighting fixture, commercial chandelier lighting	Inspired by Mid-Century style lighting, the Mercury outshines the rest with eight guard and glass fixtures mounted to an industrial stem mount chandelier.	The Mercury, BLE-S-CH006, 8-light chandelier, eight light chandelier, rustic chandelier, cgg, cgu, cast guard and glass chandelier, industrial chandelier , kitchen island lighting, kitchen lighting, entryway lights, entryway lighting, commercial lighting, commercial lights, rustic lighting, ceiling light, ceiling lights, ceiling lighting, industrial ceiling light, industrial chandelier, rustic ceiling light, rustic lighting, large chandeliers, oversized lighting, oversized 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, jelly jar light, jelly jar lights, jelly jar light fixture, jelly jar light fixtures, SPS-0206, SPS 0206, SPS0206, 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
61465	industrial guard chandelier, modern industrial pendant chandelier, 4 light chandelier, four light rustic chandelier, cast guard and glass vintage industrial light, atomic age inspired lighting, vintage modern chandelier, urban chandelier,	Inspired by atomic industrial lighting, The Sputnik shows off space age style with four extended arms and guard and glass fixtures with retro modern flair!	BLE-S-CH014, The Sputnik, industrial chandelier, rustic chandelier, cgg, tgg, cgu, modern chandler, Sputnik 4-Light Chandelier, Sputnik 4 Light Chandelier, Sputnik 4-Light Chandeliers, Sputnik 4 Light Chandeliers, Sputnik Four Light Chandelier, Sputnik Four Light Chandeliers, sputnik, sputnik chandelier, sputnik chandeliers, 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, jelly jar light, jelly jar lights, jelly jar light fixture, jelly jar light fixtures, nautical chandelier, nautical chandeliers, SPS-0202, SPS 0202, SPS0202, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, foyer light, foyer lights, foyer lighting, ble-c-gg, small chandeliers, spud nick,