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 (61444, 63136, 61448, 62395) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00046

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 (61444,63136,61448,62395) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
61444 industrial farmhouse chandelier light, down light chandelier, cast guard and glass three light chandelier, cluster pendant light, contemporary lighting chandeliers, nautical chandelier, The Alliance 3-light chandelier is full of nautical flair with its industrial pendant style mount and cast guard and glass fixtures that reflect ample lighting. The Alliance, three light chandelier, 3-light chandelier, BLE-S-CGG3, rustic chandelier, down light, cast guard and glass chandelier, CGG, CGU, TGG, industrial chandelier, industrial chandelier lighting, industrial ceiling light, cast guard and glass, cast guard and glass lighting, cast guard and glass ceiling light, The Alliance 3 Light Chandelier, The Alliance 3-Light Chandelier, The Alliance cast guard and glass, The Alliance cast guard lighting, the alliance ceiling lights, the alliance ceiling chandelier, industrial chandelier, industrial ceiling light, The Alliance 3-Light Chandelier, The Chappel 3-Light Chandelier, The Coalition 3-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, nautical chandelier, nautical chandeliers, SPS-0236, SPS0236, SPS 0236, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, alliance chandelier, alliance chandeliers, alliance 3-light chandelier, alliance 3-light chandeliers, alliance 3 light chandelier, alliance three light chandelier, ble-c-gg
61448 industrial three light chandelier, fixed track light, 3 light cluster pendant, 3 light mini chandelier, island light fixture Looking for a simple yet eye-catching chandelier? The Enterprise’s straightforward design brings a bold style to homes and businesses! Customize with finish colors and other unique options! The Enterprise, enterprise, rustic chandelier, chandelier, track light, BLE-C-CGGFS3/VAN36 3-light pendant chandelier, three light chandelier, enterprise, Enterprise 3-Light Chandelier, Enterprise 3-Light Chandeliers, Enterprise 3 Light Chandelier, Enterprise 3 Light Chandeliers, Enterprise Three Light Chandelier, Enterprise Three Light Chandeliers, industrial chandelier, industrial chandeliers, 3-light industrial chandelier, 3 light industrial chandelier, three light industrial chandelier, 3-light industrial chandeliers, 3 light industrial chandeliers, three light industrial chandeliers, industrial 3-light chandelier, industrial 3 light chandelier, industrial three light chandelier, industrial 3-light chandeliers, industrial 3 light chandeliers, industrial three light chandeliers, 3-light rustic chandelier, 3 light rustic chandelier, three light rustic chandelier, 3-light rustic chandeliers, 3 light rustic chandeliers, three light rustic chandeliers, rustic 3-light chandelier, rustic 3 light chandelier, rustic three light chandelier, rustic 3-light chandeliers, rustic 3 light chandeliers, rustic three light chandeliers, chandelier for dining room, dining room chandelier, dining room chandeliers, chandeliers for dining rooms, kitchen island pendant, kitchen island pendants, pendants for kitchen island, pendant for kitchen island, pendants for kitchen islands, 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-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, 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
63136 Influenced by the trendy look of SoHo, New York this rustic chandelier brings both the style and craftsmanship of industrial lighting fixtures to any space! The Canal Street SoHo 2 Light Chandelier, BLE-S-CH021, Canal, Canal Street, Soho, Soho lighting, Soho pendant, soho chandelier, rustic lighting, rustic chandelier, canal street, canal street chandelier, canal st., soho 2 light, soho 2 light chandelier, soho industrial, industrial chandelier, two light, 2 light, 2-light, 2 light chandelier, 2-light chandelier, two light chandelier, industrial pendant chandelier, galvanized, galvanized piping, galvanized soho, chandelier, Canal Street SoHo 2 Light Chandelier, Canal Street SoHo 2-Light Chandelier, canal street 2-light, canal street chandelier, canal chandelier, soho chandelier, soho, canal, soho two light, canal two light, SPS-0065, SPS 0065, SPS0065, soho collection, soho series, pendants, double, pendants, double