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 (61455, 61456, 61458, 61466) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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 (61455,61456,61458,61466) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61455	6 light chandelier, factory light, cast guard chandelier, rugged ceiling light, industrial light dining room, six light chandelier, atomic age lighting, vintage inspired ceiling light, commercial showroom lighting, restaurant lighting chandelier, galvaniz	This distinctive ceiling light features 6 guard and glass jar fixtures jutting out for multi directional lighting. An industrial light for modern spaces.	The Factory Overhead, BLE-S-CH005, Industrial 6 Light Chandelier "The Factory Overhead", 10HL1CG, six light chandelier, guard and glass ceiling light, cast guard and glass ceiling light, rustic chandelier, The Factory Overhead 6 Light Chandelier, factory, factory light, factory chandelier, 6 light chandelier, ceiling light, chandelier, industrial chandelier, factory overhead chandelier, industrial ceiling light, industrial ceiling lighting, factory light, factory, 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-0205, SPS 0205, SPS0205, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, 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, ble-c-gg, the factory overhead 6-light chandelier
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
61458	industrial age style chandelier, multi way light chandelier, industrial commercial lighting fixture, 8-light chandelier, large industrial chandelier, oversize restaurant rustic light, contemporary design chandeliers	Make a dramatic statement with The Vanguard modern industrial chandelier. Featuring atomic cast guard and glass elements jutting out on heavy duty arms.	BLE-S-CH005, The Vanguard, rustic chandelier, industrial chandelier, space age fixture, atomic chandelier, cast guard and glass, guard and glass, chandelier, chandeliers, rugged 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, SPS-0207, SPS 0207, SPS 0207, 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, vangaurd, vanguard 8 light chandelier,
61466	atomic age industrial chandelier, industrial sputnik chandelier, atomic light fixture, mid century hanging chandelier, five light chandelier, contemporary light fixture	Add retro inspired kitchen lighting with the Apollo 5-light chandelier. This atomic light fixture shows off industrial cast guards and glass with sputnik flair!	The Apollo, BLE-S-CH015, rustic chandelier, cast guard and glass chandelier, atomic age chandelier, mid century style, 5-light chandelier, five light chandelier, Apollo, The Apollo 5 Light Chandelier, Apollo 5 Light Chandelier, Apollo light, Apollo chandelier, 5-light, five light, 5 light, 5 light chandelier, rustic lighting, rustic ceiling light, Apollo ceiling light, Apollo ceiling lighting, atomic lighting, cgg, cgg lighting, cgg ceiling light, industrial chandelier, industrial ceiling light, industrial ceiling lighting, industrial 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, SPS-0204, SPS 0204, SPS0204, 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