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 (61452, 61453, 61467, 61468) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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 (61452,61453,61467,61468) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words
61452	down lighting chandelier, 4-light industrial chandelier, billiard room ceiling fixture, utilitarian lighting, industrial ceiling lighting, nautical style pendant, modern rustic chandelier, factory style chandelier,	This rustic chandelier features four guard and glass down lights suspended on industrial downrods. Ideal for billiard room lighting or kitchen island lighting.	The Foundry, BLE-S-CH003, 4-light chandelier, four light chandelier, rustic chandelier, industrial chandelier, guard and glass chandelier, cast guard and glass ceiling fixture, The Foundry 4 Light Chandelier, foundry, chandelier, cgg, guard & glass, chandelier lighting, chandelier ceiling lighting, ceiling lights, rustic ceiling light, industrial lighting, warehouse lighting, workshop lighting, warehouse chandelier, workshop chandelier, exposed pipe lighting, foundry chandelier, rustic chandelier, rustic ceiling light, lighting fixture, The Foundry 4-Light Chandelier, The Inventor 4-Light Chandelier, The Bottom Line 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 chandelier, rugged guard 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
61453	the assembly line chandelier, circular gooseneck chandelier, streamline moderne chandelier, guard and glass chandelier, mid century modern industrial chandelier, galvanized chandelier lightning, industrial chandelier, industrial-style chandelier	A striking, timeless chandelier, the Orbiter is fully customizable to bring a bold style to every home and business. Durable, long-lasting, and stylish: Elevate your decor with the Orbiter!	The Orbiter, the Assembly Line, rustic chandelier, gooseneck arm chandelier, space age chandelier, industrial chandelier, guard and glass, BLE-S-CH004, orbiter, orbiter ceiling light, orbiter ceiling lighting, The Orbiter 4 Light Chandelier, orbiter 4 light chandelier, orbiter chandelier, 4 light, four light, industrial lighting, space age design, cgg, rustic lighting, rustic ceiling lights, rustic ceiling lighting, rustic chandelier, gooseneck chandelier, orbiter gooseneck chandelier, gooseneck arm lighting, industrial chandelier, industrial ceiling light, orbiter industrial ceiling light, orbiter industrial chandelier, Orbiter 4-Light Chandelier, 4-light chandelier, 4-light chandeliers, 4 light chandelier, 4 light chandeliers, four light chandelier, four 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 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, LED rugged guard chandelier, LED rugged guard chandeliers, Rugged guard led chandelier, rugged guard LED chandeliers, orbitor, 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
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,
61468	retro industrial chandelier, vintage inspired gooseneck chandelier, streamline moderne chandelier, stilnovo style chandelier lighting, retro diner pendant light, four light chandelier, large industrial chandelier, 4-light retro chandelier	Inspired by Mid Century light fixtures, the Saturn-Vega shines bright with streamline modern style gooseneck arms and four cast guard and glass fixtures.	The Saturn-Vega, saturn vega, rustic chandelier, cgu, cgg, gooseneck chandelier, industrial farmhouse chandelier, cast guard and glass, The Saturn-Vega 4 Light Chandelier, Saturn-Vega 4 Light Chandelier, Saturn-Vega, 4 Light Chandelier, 4-light chandelier, gooseneck arm chandelier, gooseneck arms chandelier, gooseneck arms, ceiling light, ceiling lighting, entryway light, entryway lighting, entryway chandelier, cgg chandelier, The Saturn Vega 4 Light Chandelier, Saturn Vega 4 Light Chandelier, porch lighting, porch ceiling light, porch pendant, saturn-vega 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, SPS-0203, SPS 0203, SPS0203, 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