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 (62975, 62977, 62976, 65533) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00054

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 (62975,62977,62976,65533) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text
62975 Wall Lighting, Wall Sconce, Ceramic lighting This wall lighting integrates quality ceramic into its design. This material gives the Kao its sleek appearance, capable of standing out in any décor. Browse sconce lighting today! The Kao Wall Sconce, Kao, Kao Wall Sconce, Kao Sconce, Kao light, kao lighting, kao wall, koa, koa wall sconce, kao wall light, kao wall lighting, kao light, kao wall lights, kao sconce light, wall sconce, wall sconce light, sconce, Alabax, Alabax wall light, Alabax sconce, pass & Seymour, BLE-W-KAO, kao collection, kao series, the kao collection, the kao series, koa, kao lighting, kao light, kao lights, Interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor lighting, ceramic wall sconce, ceramic sconce,
62976 Flush Mount Lighting, Ceiling Lighting, Ceramic Fixture Ceiling lighting with a sleek new style, the Kao Flush Mount is undersized, resulting in easy installation in smaller spaces. Add to homes and businesses! The Kao Flush Mount, kao flush mount, kao flush mount pendant, kao flush, koa flush mount, koa, kao ceiling lighting, kao ceiling light, kao pendant, kao ceiling pendant, kao light, kao, kao pendant light, kao pendant lighting, kao pendants, BLE-F-KAO, Alabax, pass & Seymour, pass and seymour, Flush mount light, kao collection, kao series, the kao collection, the kao series, koa, kao lighting, kao light, kao lights, Small mount lighting, Small mount light, Small mount lights, foyer light, foyer lights, foyer lighting,
62977 Schoolhouse Lighting, Flush Mount Pendants, Ceiling lighting Incorporating a ceramic mounting, the Kao Primary Schoolhouse Flush Mount is designed to stand out! Add stripes to complete the vintage look! The Kao Schoolhouse Flush Mount, kao schoolhouse, kao flush mount, kao flush mount schoolhouse, kao, kao school house, school house, schoolhouse lighting, schoolhouse flushmount, schoolhouse flush mount, flush mount pendant, flush mount pendant lighting, BLE-F-SCH-PC/KAO, Alabax, pass & Seymour, pass and seymour, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary Schoolhouse Flush Mount Light, Primary Schoolhouse Flush Mount, Primary Schoolhouse Flush Mount Pendant, Primary Flush Mount Light, Primary Flush Mount, Primary School house Flush Mount Light, Primary School house Flush Mount, Primary School house Flush Mount Pendant, Kao Primary Schoolhouse Flush Mount Light, Kao Primary Schoolhouse Flush Mount, Kao Primary Flush Mount Light, Kao Primary Flush Mount, glass lighting, glass lighting fixture, glass lighting fixtures, glass shade, glass shades, glass shade light, glass shade lights, glass shade lighting, glass globe, glass globes, glass globe shade, glass globe shades, glass globe light, glass globe lighting, glass globe shade light, glass globe shade lights, glass globe shade lighting, glass light fixture, glass light fixtures, glass pendant light, glass pendant lights, glass pendant lighting, glass pendant light fixture, glass pendant light fixtures, glass pendant lighting fixture, glass pendant lighting fixtures, glass shade pendant light, glass shade pendant lights, glass shade pendant lighting, glass globe pendant light, glass globe pendant lighting, glass globe pendant lighting, glass globe pendant lights, glass globe shade pendant light, glass globe shade pendant lights, glass globe shade pendant lighting, glass ceiling light, glass ceiling lights, glass ceiling lighting, glass ceiling lighting fixture, glass ceiling lighting fixtures, glass shade ceiling light, glass shade ceiling lights, glass shade ceiling lighting, glass globe ceiling light, glass globe ceiling lighting, glass globe shade ceiling light, glass globe shade ceiling lights, glass globe shade ceiling lighting, glass ceiling light fixture, glass ceiling light fixtures, glass ceiling pendant, glass ceiling pendants, glass shade ceiling pendant, glass shade ceiling pendants, glass globe ceiling pendant, glass globe ceiling pendants, glass globe shade ceiling pendant, glass globe shade ceiling pendants, BLE-F-SCH10-KAO, BLE-F-SCH14-KAO, BLE-F-SCHCL10-KAO, BLE-F-SCHCL14-KAO, Flush mount light, Schoolhouse collection, schoolhouse series, the schoolhouse collection, the schoolhouse series, School house collection, school house series, the school house collection, the school house series, primary Schoolhouse collection, primary schoolhouse series, the primary schoolhouse collection, the primary schoolhouse series, primary School house collection, primary school house series, the primary school house collection, the primary school house series, primary collection, primary series, the primary collection, the primary series, SPS-0040, SPS 0040, SPS0040, kao collection, kao series, teal, Flush mount school house, Flush mount schoolhouse, kao collection, kao series, the kao collection, the kao series, koa, kao lighting, kao light, kao lights, Small mount lighting, Small mount light, Small mount lights, foyer light, foyer lights, foyer lighting, ceiling flush mount, striped schoolhouse, striped schoolhouse light,
65533 From playful to upscale, this flush mount schoolhouse light embraces a ceramic mounting and round glass shade. Fully customizable! BLE-F-RND-KAO, RND, Round, Round Schoolhouse, Kao Collection, Kao Series, Round Collection, Round Series, Kao schoolhouse, Kao school house, kao flush mount schoolhouse pendant, kao flush mount school house pendant, kao flush mount, kao flush mounts, kao flush mount pendant, kao flush mount pendants, kao flush mount ceiling pendant, kao flush mount ceiling pendants, kao flush ceiling light, kao flush mount ceiling lights, kao flush mount ceiling lighting, kao flush, flush mount kao, flush mount kao ceiling light, flush mount kao ceiling lights, flush mount kao ceiling lighting, Round schoolhouse kao, kao round schoolhouse, kao round schoolhouse pendant, kao round schoolhouse pendants, Round school house kao, kao round school house, kao round school house pendant, kao round school house pendants, Kao round schoolhouse flush mount, Round Kao schoolhouse flush mount, kao round schoolhouse flush mounts, round kao schoolhouse flush mounts, Kao round schoolhouse flush mount pendant, kao round schoolhouse flush mount pendants, kao round schoolhouse flush mount ceiling pendant, kao round schoolhouse flush mount ceiling pendants, Kao round school house flush mount, Round Kao school house flush mount, kao round school house flush mounts, round kao school house flush mounts, Kao round school house flush mount pendant, kao round school house flush mount pendants, kao round school house flush mount ceiling pendant, kao round school house flush mount ceiling pendants, Kao round flush mount, Kao round flush mounts, Kao round flush mount pendant, Kao round flush mount pendants, Kao round flush mount pendant light, Kao round flush mount pendant lights, Kao round flush mount pendant lighting, Kao round flush mount ceiling pendant, Kao round flush mount ceiling pendants, Kao schoolhouse light, Kao schoolhouse lights, Kao schoolhouse lighting, Kao schoolhouse pendant, Kao schoolhouse pendants, Kao schoolhouse flush mount, Kao schoolhouse flush mounts, Kao school house light, Kao school house lights, Kao school house lighting, Kao school house pendant, Kao school house pendants, Kao school house flush mount, Kao school house flush mounts, Kao light, Kao light fixture, Kao light fixtures, Kao Lighting fixture, Kao Lighting Fixtures, Round light, round lights, round lighting, round light fixture, round light fixtures, round lighting fixture, round lighting fixtures, round pendant, round pendants, round pendant light, round pendant lights, round pendant lights, round pendant lighting, round ceiling pendant, round ceiling pendants, round ceiling light, round ceiling lighting, Kao globe, Kao Schoolhouse Globe, Kao school house globe, Kao schoolhouse globes, Kao globe schoolhouse, Kao globe school house, Kao glass globe, kao schoolhouse glass globe, Kao globe flush mount, kao globe flush mounts, Kao globe flush mount light, Flush mount light, flush mount, flush mounts, flush mount pendant, flush mount pendants, flush mount pendant light, flush mount pendant lights, flush mount pendant lighting, flush mount fixture, flush mount fixtures, striped schoolhouse, striped schoolhouse light,