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 (62396, 62379, 62373, 62372) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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 (62396,62379,62373,62372) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
62372	led ceiling light, industrial led chandelier, rustic led chandelier	This LED ceiling light features six industrial guard and glass jar fixtures fitted with new "bulbless" LED technology. Incorporate this rustic LED chandelier for a modern look.	Factory Overhead LED 6 Light Chandelier, BLE-S-CGG-CH003-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, factory overhead, CH003, 6-light, 6 light chandelier, nautical chandelier, nautical led chandelier, nautical, nautical led, factory, industrial chandelier, rugged guard chandelier, rugged guard chandeliers, LED rugged guard chandelier, LED rugged guard chandeliers, Rugged guard led chandelier, rugged guard LED chandeliers, SPS-0205, SPS 0205, SPS0205, cast guard collection, cast guard series, rugged guard collection, rugged guard series, industrial guard collection, industrial guard series, cgg collection, cgg series, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside chandelier, Outside chandeliers, Out side chandelier, Out side chandeliers, ble-c-gg, the factory overhead 6-light chandelier
62373	led chandelier lighting, led chandelier, led light fixture	Add retro inspired LED chandelier lighting with this industrial 5-light chandelier. This atomic LED light fixture shows off industrial cast guards and glass with the latest in LED technology!	Apollo LED 5 Light Chandelier, BLE-S-CGG-CH009-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, apollo, apollo chandelier, nautical chandelier, 5 light chandelier, rustic chandelier, led 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-0204, SPS0204, SPS 0204, 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
62379	industrial led lighting, rustic chandelier, led guard and glass	A bold industrial chandelier with integrated LED tech! Choose from dozens of finish options to create a unique look for your home or business!	Orbiter LED 4 Light Chandelier, BLE-S-CGG-CH002-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, orbiter, orbiter chandelier, nautical, nautical led, nautical led chandelier, 4 light, 4 light chandelier, orbit, led chandelier, orbiter led, LED orbiter, 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, orbitor, orbitor chandelier, orbitor LED, orbitor LED chandelier, LED orbitor, LED orbitor chandelier, SPS-0195, SPS 0195, SPS0195, 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
62396	rustic led pendant, led guard and glass, energy efficient light	This rustic LED pendant, the Merger, features two LED guard and glass fixtures topped with mini warehouse shades. Guaranteed 5 years of energy efficient light!	Merger LED 2 Light Chandelier, 2- light led pendant, 2 light led, BLE-S-CGGWH2-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, merger, 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-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, ble-c-gg, pendants, double