SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  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 (954, 956, 955, 953, 6186) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00022

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": "3",
      "used_key_parts": ["product_id"],
      "rows": 5,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (954,956,955,953,6186)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
953 <p> BUD 70&quot; H open rack with larger support base and upright angles. Black textured finish. Ships broken down in 2 cartons with all necessary hardware.</p> <p> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Exceptionally strong structure made up of chassis-type base and supporting angles.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Uprights: .11&quot; steel channels, 3.00&quot; deep.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Top Plate, 1.12&quot; x 3.12&quot;.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Rails tapped #10-32 on EIA universal spacing. (Use #7346 screws - order separately)&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Base is 19.96&quot; x 22.00&quot; and drilled for RC-7758 casters.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Racks have been tested to 650# equipment load capacity.&nbsp;</span><br style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);" /> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Racks are shipped knocked down in two (2) cartons, with all necessary assembly hardware included.</span></p>
954 <p> BUD: Table top rack w/ 21" of panel space. 24" overall height. Black textured finish </p><p> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Chassis-type base holds heavy components for table mounting applications. Supporting angles provide strength and rigidity. Panel mounting rails tapped #10-32 on E.I.A. universal spacing. (Use #7346 screws - order separately) Standard 19" panel fits flush with front. Base, 20.37" x 12.00". Shipped knocked down.</span> </p><p> <span style="color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);">Finish: Black Texture</span> </p> table top rack, tabletop rack, 2' rack, 2' open rack, 2 foot rack, 2 foot open rack, tabletop equipment rack, table top equipment rack
955 <p>These swingframe racks offer all the conveniences of a wall mounted rack, plus the added advantage of a swing out frame for easy access to the rear of your equipment.</p><p style="margin-top: 0px; font-size: 12px; line-height: 18px; margin-bottom: 20px; color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; background-color: rgb(255, 255, 255);"><strong>Features</strong></p><ul><li>Left or right hand hinge.</li><li>#12-24 panel mounting hardware (Use #9260 screws - order separately)</li><li>Velcro cable straps included</li><li>16" on center wall mounting (wall mounting hardware not included).</li><li>75# equipment load capacity</li><li>Two Styles: Style A - Knockdown Assembly, Style B - Welded Assembly<br><br><strong>Finish:</strong> Black Texture (BT)</li></ul>
956 <p> BUD: Wall mount cabinet (Emperor Series). 21&quot; panel space (12U). 23.62&quot; W X 15.75&quot; D X 25&quot; H. 85 lbs</p> <p> &nbsp;</p> <ul style="margin-top: -8px; margin-left: 10px; color: rgb(102, 102, 102); font-family: Tahoma, Geneva, sans-serif; font-size: 12px; line-height: 18px; background-color: rgb(255, 255, 255);"> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> Sturdy and durable steel construction. Mounting rails &ndash; 18 ga., other parts 20 ga.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> Furnished completely assembled with tempered glass front door and removable sides.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> EIA 310 compliant for 19&frac12; mount equipment.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> Two pairs of fully adjustable panel mounting rails are included in the center section. One fixed pair of mounting rails is included in the rear section.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> One ventilated shelf provided.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> Includes two fans installed in the top of the center section.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> Slots with readily removable covers are provided in the top and bottom of the rear section for easy cable installation.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> Sides are readily removable but come with key lock and with ventilation at top and bottom of cabinet.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> 4 mounting slots provided in rear unit for rapid wall mounting.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> Cabinet can be mounted to rear section hinged left or right.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> Front door can be hinged left or right.</p> </li> <li style="margin-bottom: 0px; padding-bottom: 8px; margin-top: 0px;"> <p> Other sizes and modifications are available upon request.</p> </li> </ul>
6186 <p>Bud Industries 19" ventilated shelf for open rack. Black textured finish</p>