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 (62383, 62664, 61467, 61623) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00052

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 (62383,62664,61467,61623) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61467	industrial barn lighting, gooseneck light chandelier, rlm shade chandelier, barn light original chandelier, farm style chandelier, down light chandelier, warehouse shade multi rlm pendant fixture, 4-light barn shade fixture	The Von Braun 4-light reflector chandelier is the ideal fixture for industrial commercial lighting, or modern rustic spaces with its atomic barn styling.	BLE-S-WHS12-CH007, BLE-S-WHS14-CH007, BLE-S-WHS16-CH007, BLE-S-WHS18-CH007, von, braun, von braun, 4 light, 4 light chandelier, S-CH007, von, braun, van braun chandelier, von braun chandeliers, rlm chandelier, rlm chandelier, warehouse shade chandelier, warehouse chandelier, SPS-0060, SPS 0060, SPS0060, H-4MNBL, four classic warehouse shade, four classic warehouse shade melon ball fixture,
61623	straight arm schoolhouse light chandelier, decorative glass chandelier, school house light fixture, schoolhouse light chandeliers, colorful light fixtures, classic schoolhouse lighting, american made schoolhouse light, period schoolhouse lighting	American made lighting, this 4-light schoolhouse ceiling light fixture showcases industrial arms and decorative glass globes and custom color bands. Free Shipping!	University Schoolhouse Chandelier, BLE-S-SCH-CH011, the university, schoolhouse chandelier, glass chandelier, The University 4-Light Schoolhouse Chandelier, the university chandelier, 4-light chandelier, chandelier lighting, schoolhouse chandelier lighting, ceiling lighting, schoolhouse ceiling lighting, schoolhouse shade, ceiling lighting, chandelier ceiling light, chandelier ceiling lighting, university ceiling lighting, university lighting, university ceiling lighting, indoor chandelier, Junior, Junior Schoolhouse Chandelier, Junior Schoolhouse, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary 4-Light Straight Arm Schoolhouse Chandelier, Primary 4-Light Schoolhouse Chandelier, Primary 4-Light Chandelier, Primary four Light Straight Arm Schoolhouse Chandelier, Primary four Light Schoolhouse Chandelier, Primary Straight Arm 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-CH011-SCH10, BLE-S-CH011-SCH14, BLE-S-CH011-SCHCL10, BLE-S-CH011-SCHCL14, 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-0067, SPS 0067, SPS0067, striped schoolhouse, striped schoolhouse light,
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,
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,