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 (62382, 62388, 62395, 61478) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00066

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 (62382,62388,62395,61478) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
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
62382 rustic led chandelier, guard and glass led lights, led billiard lighting This rustic LED chandelier features four guard & glass LED lights suspended on industrial down-rods. Ideal for billiard room lighting or kitchen island lights. Foundry LED 4 Light Chandelier, BLE-S-CGG-CH001-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, foundry, foundry led, foundry chandelier, nautical, nautical led, nautical led chandelier, nautical chandelier, rustic led, rustic led chandelier, rustic chandelier, 4 light, 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 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-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
62388 industrial vapor proof fixture, led cast guard and glass, industrial led lighting Styled after vapor proof fixtures, the Alliance 3-Light Chandelier features LED cast guard & glass fixtures affixed to a rugged stem. Enjoy with Free Shipping! Alliance LED 3-Light Chandelier, Industrial Billiard Light, BLE-S-CGG3-PC-LED, 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, 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, Alliance, Alliance Chandelier, Alliance Chandeliers, rugged guard chandelier, rugged guard chandeliers, LED rugged guard chandelier, LED rugged guard chandeliers, Rugged guard led chandelier, rugged guard LED chandeliers, SPS-0236, SPS 0236, SPS0236, 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
62395 led chandelier, guard and glass pendants Energy efficient and endlessly customizable, the Insider can elevate and transform homes and businesses! Save money and help the environment with LED chandeliers! Insider LED 2 Light Chandelier, 2-light led pendant, BLE-C-CGG2/VAN24-PC-LED, 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, led chandelier, led ceiling light, industrial led chandelier, led industrial chandelier, industrial led chandeliers, led industrial chandeliers, rugged chandelier, rugged led chandelier, rugged chandeliers, rugged led chandeliers, 2-light led chandelier, two light led chandelier, two light led chandeliers, 2-light led chandeliers, 2-light pendant, 2-light led pendant, led two light chandelier, led 2-light chandelier, chandelier with leds, 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, ble-c-gg, pendants, double