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 (61620, 61621) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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": 2,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (61620,61621) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	meta_keywords	meta_description	search_words	promo_text
61620	double wall sconce, vintage vanity light, schoolhouse lighting, american made schoolhouse light, glass globe wall sconce with colorful band, school house sconce, bath vanity light, bronze schoolhouse light	Inspired by vintage lights, add Primary Schoolhouse Wall Light to your home. Accent yours with colorful bands for an instantly classic bathroom vanity light!	Collegiate 2-Light Schoolhouse Vanity Light, BLE-W-SCH10-24VAN, 2-light schoolhouse sconce, schoolhouse sconce light, schoolhouse lighting, schoolhouse wall light, wall lights, vanity lights, vanity lighting, vanity wall sconce, bathroom lighting, bathroom wall lights, 2-light vanity light, 2-light wall sconce, 2-light wall light, Freshman, Freshman schoolhouse, freshman schoolhouse light, freshman schoolhouse vanity light, Primary, Primary Schoolhouse, Primary School house, Primary schoolhouse shade, primary school house shade, primary schoolhouse light, primary school house light, Primary Schoolhouse Sconce, Primary Schoolhouse Wall Sconce, Primary School house Sconce, Primary School house Wall Sconce, Primary Schoolhouse Sconce Light, Primary School house Sconce Light, Primary Sconce, Primary Sconces, Primary Sconce Light, Primary 2-Light Schoolhouse Vanity Light, Primary 2 Light Schoolhouse Vanity Light, Primary two Light Schoolhouse Vanity Light, Primary 2-Light Schoolhouse Vanity sconce, Primary 2-Light Schoolhouse Vanity Wall Sconce, Primary Schoolhouse Vanity Light, Primary Schoolhouse Vanity Sconce, Primary Schoolhouse Vanity Wall Sconce, Primary Vanity Light, Primary Vanity Sconce, Primary Vanity Wall Sconce, wall vanity, wall vanity light, schoolhouse, school house, schoolhouse sconce, schoolhouse wall sconce, school house sconce, school house wall sconce, schoolhouse vanity sconce, school house vanity sconce, schoolhouse vanity wall sconce, school house vanity wall sconce, primary schoolhouse, primary school house, primary, 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 wall lighting, glass wall lighting fixture, glass wall lighting fixtures, glass shade wall light, glass shade wall lights, glass shade wall lighting, glass globe wall light, glass globe wall lighting, glass globe wall lights, glass globe shade wall light, glass globe shade wall lights, glass globe shade wall lighting, glass wall light fixture, glass wall light fixtures, glass sconce, glass sconce fixture, glass sconce fixtures, glass wall sconce, glass wall sconce fixture, glass wall sconce fixtures, glass shade sconce, glass shade wall sconce, glass sconce light, glass shade sconce light, glass globe sconce, glass globe wall sconce, glass globe wall sconces, glass globe sconce light, glass shade sconce, glass shade sconces, glass shade wall sconce, glass shade wall sconces, glass shade sconce light, BLE-W-SCH10-24VAN, BLE-W-SCHCL10-24VAN, Vanity lightdouble sconce, Vanity light double sconce, vanity, Bathroom vanity light fixture, Bathroom vanity light fixtures, Bathroom vanity fixture, Bathroom vanity fixtures, Bathroom vanity light, Bathroom vanity lights, Bathroom vanity lighting, Bath vanity light, Bath vanity lights, Bath vanity lighting, Bath vanity fixture, Bath vanity fixtures, bathroom light fixtures, bathroom light fixture, bathroom lighting fixtures, bathroom lighting fixture, bath light fixtures, bath light fixture, bath lighting fixtures, bath lighting fixture, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, 2 light school house, 2 light schoolhouse, double light wall sconces, vanity plates, striped schoolhouse, striped schoolhouse light,
61621	three light vanity lighting, 3-light schoolhouse sconce, glass globe vanity light, american made lighting, light fixture for bathroom, mirror lighting, vintage inspired lighting, schoolhouse mirror light	The Primary lights up your bathroom and powder room with schoolhouse flair! Three glass globes with painted bands hang from curved arms!	Graduate 3-Light Schoolhouse Vanity Light, BLE-W-SCH10-36VAN, Graduate, schoolhouse sconce, schoolhouse vanity light, Sophomore, sophomore schoolhouse, sophomore vanity light, sophomore schoolhouse light, the sophomore schoolhouse, the sophomore vanity light, the sophomore schoolhouse light, Primary Schoolhouse Sconce, Primary Schoolhouse Wall Sconce, Primary School house Sconce, Primary School house Wall Sconce, Primary Schoolhouse Sconce Light, Primary School house Sconce Light, Primary Sconce, Primary Sconces, Primary Sconce Light, Primary 3-Light Schoolhouse Vanity Light, Primary 3 Light Schoolhouse Vanity Light, Primary three Light Schoolhouse Vanity Light, Primary 3-Light Schoolhouse Vanity sconce, Primary 3-Light Schoolhouse Vanity Wall Sconce, Primary Schoolhouse Vanity Light, Primary Schoolhouse Vanity Sconce, Primary Schoolhouse Vanity Wall Sconce, Primary Vanity Light, Primary Vanity Sconce, Primary Vanity Wall Sconce, wall vanity, wall vanity light, glass wall lighting, glass wall lighting fixture, glass wall lighting fixtures, glass shade wall light, glass shade wall lights, glass shade wall lighting, glass globe wall light, glass globe wall lighting, glass globe wall lights, glass globe shade wall light, glass globe shade wall lights, glass globe shade wall lighting, glass wall light fixture, glass wall light fixtures, glass sconce, glass sconce fixture, glass sconce fixtures, glass wall sconce, glass wall sconce fixture, glass wall sconce fixtures, glass shade sconce, glass shade wall sconce, glass sconce light, glass shade sconce light, glass globe sconce, glass globe wall sconce, glass globe wall sconces, glass globe sconce light, glass shade sconce, glass shade sconces, glass shade wall sconce, glass shade wall sconces, glass shade sconce light, 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, BLE-W-SCH10-36VAN, BLE-W-SCHCL10-36VAN, 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-0324, SPS 0324, SPS0324, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount sconce light, Wall mount sconce lights, Wall mount sconce lighting, Wall mount sconce, Wall mount sconces, Wall mounted sconce light, Wall mounted sconce lights, Wall mounted sconce lighting, Wall mounted sconce, Wall mounted sconces, vanity plates, striped schoolhouse, striped schoolhouse light,