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 (65157, 65169, 65175, 65179) 
  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 (65157,65169,65175,65179) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_description	search_words
65157	Versatile and stylish, the Aero shows off a look perfect for both contemporary designs and more traditional looks. Equipped with LED drivers! Customize the shade with the numerous finish options we offer!	BLE-PMS-SBA, BLE-PMSD-SBA, BLE-PMS-SBA-BRS, BLE-PMSD-SBA-COP, BLE-PMS-SBA-COP, BLE-PMSD-SBA-BRS, Prospector Single Post Mount Exterior Light, Post mount, Prospector, Exterior light, Outdoor light, light pole, driveway light, walkway light, dock light, parking lot light, Warehouse, warehouse shade, barn light, Post Mount, Post Mount Warehouse Shade, P-3, pole mount, post mount, pole light, BLE-PMS-SBA14, BLE-PMS-SBA16, The Aero Single Post Mount Light, Aero Single Post Mount Light, The Aero Single Post Mount Lights, Aero Single Post Mount Lights, The Aero Single Post Mount Lighting, Aero Single Post Mount Lighting, The Aero Post Mount Light, Aero Post Mount Light, The Aero Post Mount Lights, Aero Post Mount Lights, The Aero Post Mount Lighting, Aero Post Mount Lighting, Copper post mount, copper post mounts, copper post mount light, copper post mount lights, copper post mount lighting, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, aero post, aero post mount, aero single post, single aero post, aero post mount light, single post mount aero, aero post light, new led post, Aero Nautical LED Single Post Mount Light, Aero Nautical LED Single Post Mount, Aero Nautical LED Post Mount Light, Aero Nautical LED Post Mount, Aero Nautical Single Post Mount Light, Aero Nautical Single Post Mount, Aero Nautical Post Mount Light, Aero Nautical Post Mount, Aero LED, Aero LED post Mount, LED aero, LED aero post mount, LED Nautical, Nautical LED, LED nautical post mount, nautical led post mount, aero nautical, nautical aero, BLE-PMS-SBA14, BLE-PMS-SBA16, BLE-PMSD-SBA14, BLE-PMSD-SBA16, aero led series, aero LED collection, SPS-0458, SPS0458, SPS 0458, aero series, aero collection, arrow, SPS-0222, SPS0222, SPS 0222, SPS-0526, SPS0526, SPS 0526, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, post top fixture, post top fixtures, post top light fixture, LED post top, LED Post top light, LED Post Top Lights, LED Post top lighting, LED Post top fixture, LED post top fixtures, led post top light fixture, led post top light fixtures, rustic LED Post mount, rustic LED Post mounts, BLE PMS, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting,
65169	Stunning deep bowl shades are fitted to a pole mounting, creating a dynamic focal point for residential and commercial settings. Fitted with efficient LED modules!	BLE-PMS-DBW, BLE-PMSD-DBW, Wilcox Single Post Mount Decorative Exterior Light, BLE-PMSD-DBW, Wilcox post mount, wilcox light pole, wilcox, single post, post mount, decorative, exterior light, decorative light pole, light pole, deep bowl, bowl shade, sidewalk light, commercial lighting, pole light, post light, Wilcox Single Post Mount Exterior Light, BLE-PMS-DBW, wilcox, single post, post mount, exterior light, lampost, post mount, deep bowl, bowl light, porch light, driveway lighting, street lamp post, lamp post, direct lighting, BLE-PMS-DBW14, BLE-PMS-DBW16, The Wilcox Single Post Mount Light, The Wilcox Single Post Mount Lights, The Wilcox Single Post Mount Lighting, The Wilcox Post Mount Light, The Wilcox Post Mount Lights, The Wilcox Post Mount Lighting, Wilcox Single Post Mount Light, Wilcox Single Post Mount Lights, Wilcox Single Post Mount Lighting, Wilcox Post Mount Light, Wilcox Post Mount Lights, Wilcox Post Mount Lighting, Copper post mount, copper post mounts, copper post mount light, copper post mount lights, copper post mount lighting, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, wilcox post, wilcox post mount light, single wilcox post mount, wilcox single post, deep bowl post mount, deep bowl post, wilcox, wilcox post light, new led post, wilcox post mount, wilcox led post mount, led post mount, wilcox led post, led wilcox post mount, wilcox post mount, Wilcox Nautical LED Single Post Mount Light, Wilcox Nautical LED Post Mount Light, Wilcox Nautical LED Single Post Mount, Wilcox Nautical LED Post Mount, Wilcox LED Single Post Mount Light, Wilcox LED Single Post Mount, Wilcox Nautical LED Post Mount Light, Wilcox Nautical LED Post Mount, Wilcox Nautical Post Mount Light, Wilcox Nautical Post Mount, nautical led, led nautical, nautical post mount, BLE-DBW14, BLE-DBW16, BLE-PMS-DBW14, BLE-PMS-DBW16, BLE-PMSD-DBW14, BLE-PMSD-DBW16, rustic LED Post mount, rustic LED Post mount light, rustic+LED+Post+mount, PMS Wilcox, SPS-0272, SPS 0272, SPS0272, SPS-0158, SPS 0158, SPS0158, Wilcox Series, Wilcox Collection, The Wilcox Series, The Wilcox Collection, Wilcox deep bowl series, wilcox deep bowl collection, the wilcox deep bowl series, the wilcox deep bowl collection, deep bowl series, deep bowl collection, Wilcox LED Series, Wilcox LED Collection, The Wilcox LED Series, The Wilcox LED Collection, Wilcox LED deep bowl series, wilcox LED deep bowl collection, the wilcox LED deep bowl series, the wilcox LED deep bowl collection, LED deep bowl series, LED deep bowl collection, SPS-0453, SPS0453, SPS 0453, SPS-0272, SPS 0272, SPS0272, The Wilcox Post Mount Collection, The Wilcox Post Mount Series, Wilcox Post Mount Collection, Wilcox Post Mount Series, rustic LED Post mount, rustic LED Post mounts, BLE PMS, wilcox bowl, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting, H-16114, H-16116, classic deep bowl shade, classic deep bowl shade post light, H-16114, H-16116, classic deep bowl shade, classic deep bowl post light,
65175	The Sterling’s dramatic, streamline shade and nautical guard establishes the perfect look for commercial settings and residential properties. Outfitted with LED modules! Customize this post mount light to match your space!	BLE-PMS-DCS, BLE-PMSD-DCS, Sterling Deep Cone Reflector Single Post Mount Decorative Exterior Light, BLE-PMSD-DCS, deep cone light pole, deep cone post mount, sterling post mount, sterling light pole, sterling, deep cone, cone reflector, single post, post mount, exterior light, decorative light pole, light pole, post mount light, reflector shade, sidewalk light, landscape lighting, commercial lighting, pole light, post light, pole mount, BLE-PMSD-DCS14, BLE-PMSD-DCS16, Sterling Deep Cone Reflector Single Post Mount Exterior Light, Sterling, Deep Cone, Reflector, Single, pole light, Post Mount, Exterior Light, BLE-PMS-DCS, reflector shade, cone reflector shade, post mount, garden lights, patio post lights, post lights, restaurant post, outdoor lighting, lamppost, pole mount, BLE-PMS-DCS14, BLE-PMS-DCS16, The Sterling Post Mount Light, The Sterling Post Mount Lights, The Sterling Post Mount Lighting, Sterling post mount light, sterling post mount lights, sterling post mount lighting, Copper post mount light, copper post mount lights, copper post mount lighting, copper post mount, copper post mounts, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, sterling post, sterling post mount, deep cone post, deep cone post mount, sterling single post mount, sterling post light, sterling deep cone post , reflector post mount light, new led post, Sterling LED Single Post Mount Light, Sterling LED Post Mount Light, Sterling LED Single Post Mount, Sterling Single Post Mount, Sterling LED, led sterling, led post mount, post mount led, Sterling Nautical LED Single Post Mount Light, Sterling Nautical LED Single Post Mount, Sterling Nautical Single Post Mount Light, Sterling Nautical Single Post Mount, Sterling LED Single Post Mount Light, Sterling LED Single Post Mount, Sterling Nautical Post Mount Light, Sterling Nautical Post Mount, Sterling LED Post Mount Light, Sterling LED Post Mount, Nautical led, LED nautical, nautical post mount, post mount nautical, led post mount, post mount led, BLE-PMS-DCS14, BLE-PMS-DCS16, BLE-PMSD-DCS14, BLE-PMSD-DCS16, SPS-0270, SPS 0270, SPS0270, The Sterling Post Mount Collection, The Sterling Post Mount Series, Sterling Post Mount Collection, Sterling Post Mount Series, rustic LED Post mount, rustic LED Post mounts, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting,
65179	With a wavy fluted shade, rugged nautical guard, and cutting-edge LED tech, the Seaside is a functional and decorative addition to outdoor settings! Customize its look to match your building’s décor!	BLE-PMS-RWS, BLE-PMSD-RWS, BLE-PMS-RWS-BRS, BLE-PMS-RWS-COP, BLE-PMSD-RWS-BRS, BLE-PMSD-RWS-COP, Seaside Radial Wave Reflector Single Post Mount Exterior Light, Seaside post mount, BLE-PMS-RWS, seaside, radial wave, single post, post mount, exterior light, pole light, pole light fixtures light pole, radial wave, radial wave light, decorative outdoor lighting, driveway lighting, commercial outdoor lighting, outdoor lighting, garden lighting, pole mount, post light, BLE-PMS-RWS14, BLE-PMS-RWS16, Seaside Radial Wave Post/Pole Mount Light, The Seaside Radial Wave Single Post Mount Light, The Seaside Radial Wave Single Post Mount Lights, The Seaside Radial Wave Single Post Mount Lighting, The Seaside Radial Wave Post Mount Light, The Seaside Radial Wave Post Mount Lights, The Seaside Radial Wave Post Mount Lighting, Seaside Radial Wave Post Mount Light, Seaside Radial Wave Post Mount Lights, Seaside Radial Wave Post Mount Lighting, Seaside Post Mount Light, Seaside Post Mount Lights, Seaside Post Mount Lighting, Copper post mount, copper post mounts, copper post mount light, copper post mount lights, copper post mount lighting, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, seaside post, seaside post mount, seaside radial wave post, radial wave post mount, seaside single post, radial post, new led post, Seaside Nautical LED Single Post Mount Light, Seaside Nautical LED Single Post Mount, Seaside Nautical LED Post Mount Light, Seaside Nautical LED Post Mount, Seaside Nautical Single Post Mount Light, Seaside Nautical Single Post Mount, Seaside LED Single Post Mount Light, Seaside LED Single Post Mount, Seaside Nautical Post Mount Light, Seaside Nautical Post Mount, Seaside LED Post Mount Light, Seaside LED Post Mount, nautical led, LED nautical, nautical post mount, BLE-PMS-RWS12, BLE-PMS-RWS14, BLE-PMSD-RWS12, BLE-PMSD-RWS14, seaside series, seaside collection, sea side series, sea side collection, the seaside series, the seaside collection, the sea side series, the sea side collection, SPS-0156, SPS0156, SPS 0156, SPS-0456, SPS 0456, SPS0456, seaside led series, seaside led collection, sea side led series, sea side led collection, the seaside led series, the seaside led collection, the sea side led series, the sea side led collection, SPS-0528, SPS 0528, SPS0528, SPS-0268, SPS0268, SPS 0268, The Seaside Post Mount Collection, The Seaside Post Mount Series, The Sea side Post Mount Collection, The Sea side Post Mount Series, Seaside Post Mount Collection, Seaside Post Mount Series, Sea side Post Mount Collection, Sea side Post Mount Series, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, post top fixture, post top fixtures, post top light fixture, LED post top, LED Post top light, LED Post Top Lights, LED Post top lighting, LED Post top fixture, LED post top fixtures, led post top light fixture, led post top light fixtures, rustic LED Post mount, rustic LED Post mounts, lamp post lights, barn lights on pole, outdoor pole lights, light post lighting,