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 (61478, 63333, 63137, 62387) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00034

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 (61478,63333,63137,62387) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61478	mini shade chandelier, double island light chandelier, double billiard light, cast guard and glass jar chandelier, 2-light barn light with cast guard and glass	This rustic barn pendant, the Merger, features two guard and glass fixtures topped with mini warehouse shades. Perfect for industrial kitchen lighting.	The Merger 2 Light Chandelier, BLE-S-CGGWH2, 2 light chandelier, kitchen light, cgg, tgg, merger, cast guard chandelier, merger, merger light, merger lighting, merger chandelier, merger ceiling light, 2 light, two light, 2-light, industrial chandelier, rustic chandelier, industrial chandelier lighting, rustic chandelier lighting, rustic ceiling lighting, rustic two light, rustic 2-light, rustic two light chandelier, rustic 2-light chandelier, rustic 2 light chandelier, entryway lighting, entryway light, living room lighting, rustic living room lighting, industrial living room lights, industrial chandelier lights, merger, The Merger, The Collaboration, The Partnership, 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, nautical chandelier, nautical chandeliers, SPS-0014, SPS 0014, SPS0014, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, merger two light, merger 2 light, merger 2-light, ble-c-gg, pendants, double
62387	modern industrial led pendant, industrial cast guard lighting, industrial led pendant	Powerful LED technology with an eye-catching style, the Enterprise’s bold industrial design complements farmhouse, industrial, and nautical looks! Save money with fashionable lights!	Enterprise LED 3 Light Chandelier, BLE-C-CGGFS3/VAN36-PC-LED, led vanity, industrial led vanity light, rustic led chandelier, cast guard and glass led, led chandelier, rustic led, industrial led chandelier, vapor jar led chandelier, rustic led chandelier, led chandelier, cast guard and glass chandelier, led cast guard and glass chandelier, vapor jar led chandelier, led cast guard chandelier, 3-light chandelier, led chandelier, three light chandelier, industrial 3-light chandelier, industrial 3-light chandeliers, industrial 3 light chandelier, industrial 3 light chandeliers, industrial three light chandelier, industrial three light chandeliers, nautical chandelier, nautical 3-light chandelier, nautical 3-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 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, SPS-0549, SPS 0549, SPS0549, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, enterprise chandelier, enterprise chandeliers,
63137		Looking to the Soho, New York for inspiration this rustic chandelier brings the chic—yet—rugged look to your home or business! Customize it to meet your needs!	The Canal Street SoHo 3 Light Chandelier, BLE-S-CH022, Canal Street SoHo 3 Light Chandelier, Canal, Canal Street, Soho, Soho lighting, Soho pendant, soho chandelier, rustic lighting, rustic chandelier, canal street, canal street chandelier, canal st., soho 3 light, soho 3 light chandelier, soho industrial, industrial chandelier, three light, 3 light, 3-light, 3 light chandelier, 3-light chandelier, three light chandelier, industrial pendant chandelier, galvanized, galvanized piping, galvanized soho, chandelier, Canal Street SoHo 3 Light Chandelier, Canal Street SoHo 3-Light Chandelier, canal street 3-light, canal 3-light, canal street 3-light chandelier, canal 3-light chandelier, canal, soho, soho three light, soho 3 light, canal soho 3-light chandelier, soho chandeliers, soho chandelier, canal chandelier, canal chandeliers, SPS-0264, SPS 0264, SPS0264, soho collection, soho series,
63333		Style and function collide in the Union—a three light chandelier. Built by hand, this American made lighting is fully customizable with marine grade, powder coat, and natural metal finishes!	Benjamin, Benjamin collection, Benjamin three light, Benjamin 3 light, Benjamin multi light, Benjamin multi pendant, Benjamin multi light pendant, McClure multi light pendant, McClure Multi Light, multi light stem mount, multi stem mount, multi light chandelier, industrial chandelier, industrial multi light chandelier, multi light ceiling light, mcclure, 3 light pendant, 3 light, mcclure stem, triple chandelier, triple, union chandelier, universal chandelier, mcclure chandelier, BLE-S-ST3-WHU16, 3-light chandelier, 3-light chandeliers, Union 3-Light Stem Mount Pendant, Union 3 Light Stem Mount Pendant, Union three Light Stem Mount Pendant, Union 3-Light chandelier, Union 3 Light chandelier, union three light chandelier, Union 3-Light Stem Mount, Union 3 Light Stem Mount, Union three Light Stem Mount, Union 3-Light Pendant, Union 3 Light Pendant, Union three Light Pendant, union, universal, union chandelier, union series, union collection, the union series, the union collection, SPS-0255, SPS0255, SPS 0255, pool table lights, pool table light, pool table lighting, kitchen table light, kitchen table lights, kitchen table lighting, dining room table light, dining room table lighting, dining room table lights, Outside chandelier, Outside chandeliers, Out side chandelier, Out side chandeliers, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outdoor chandelier, jadeite, jadite, jadeite light, jadite light,