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 (62664, 61452, 61465, 62370) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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 (62664,61452,61465,62370) 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
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,
62370	industrial style chandelier, cast guard and glass led chandelier, bulbless chandelier, led chandelier	This industrial style 4-light LED chandelier, The Polaris, features our rustic cast guard and glass jars fitted with the latest in bulbess LED technology.	Polaris LED 4 Light Chandelier, BLE-S-CGGWH-CH007-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, nautical chandelier, nautical led chandelier, nautical led, polaris, polaris led, nautical, polaris chandelier, rustic chandelier, 4 light chandelier, S-CH007, 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 LED light, rugged guard LED lights, rugged guard LED lighting, rugged guard LED light fixture, rugged guard LED lighting fixture, rugged guard LED light fixtures, rugged guard LED lighting fixtures, 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-0203, SPS 0203, SPS0203, ble-c-gg
62664	SoHo Chandelier, Industrial Chandelier, 4 Light Chandelier, Galvanized pipe light fixtures, Flared Neck Chandelier, Flared Neck Lighting Fixture, RLM chandelier	This multi-light chandelier combines flared RLM shades with chic industrial-styled mounting! Perfect for studios, apartments, galleries, bars and basements!	the canal street soho 4 light chandelier, canal street industrial chandelier, industrial chandeliers, chandeliers, canal street lighting, flared shade lighting, apartment loft lighting, art gallery lighting, basement chandeliers, BLE-S-CH014, soho chandelier, soho 4-light, soho 4 light, canal 4-light, canal street 4-light, canal 4-light chandelier, canal street 4-light chandelier, canal 4-light, canal soho, canal chandelier, canal, soho, SPS-0306, SPS 0306, SPS0306, soho collection, soho series,