SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (226, 161, 54) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00029

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_ult_product_descriptions range PRIMARY,product_id,company_id PRIMARY 13 3 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
54 <p>The TS-W3002D2/4 subwoofers are designed to produce enormously powerful music. Just take a look at its super-heavy-duty construction, all designed to handle up to 3,500 watts max. Double-stacked magnets for higher power, and a step-up radial surround for superior control and long excursions. We used a constructed cast-aluminum basket for this sub. Add in our patented IMPP cone and you've got a monster sub that can handle whatever you want to throw at it.</p> <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>
161 <p>The 3.0" Flip-Out Display lets you take and view great pictures from multiple angles. Easily adjust the LCD from 0 to 180 degrees and make any shot possible. Snap a picture over a crowd or get waist-level candids of kids and pets, or spin the display for perfectly framed self-portraits. Choose from 3 shutter options to comfortably snap pics from any position.</p> <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>
226 <div class="prod-details-processor-information" style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, Tahoma, Helvetica, sans-serif; padding: 0px; margin: 0px; border: 0px initial initial;"><div class="prod-details-processor-image" style="outline-style: none; outline-width: initial; outline-color: initial; margin-top: 0px; margin-right: 20px; margin-bottom: 20px; border-image: initial; font: inherit; vertical-align: baseline; color: #666666; float: left; font-size: 14px; width: 90px; padding: 0px; border: 0px initial initial;"><img style="outline-style: none; outline-width: initial; outline-color: initial; border-style: initial; border-color: initial; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px;" src="http://www.intel.com/sites/sitewide/pix/badges/core/ci7_78x59.gif" alt="" /></div><div class="prod-details-processor-details component" style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; color: #666666; padding: 0px; margin: 0px; border: 0px initial initial;"><div class="proc-spec-intelinside" style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"><div class="proc-spec-title" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 0px; padding-right: 0px; padding-bottom: 8px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-size: 14px; color: #666666; background-color: #ffffff; margin: 0px; border: 0px initial initial;">Intel&reg; Core&trade; i7 Processor i7-950 Desktop Processor Specification</div></div></div></div><table style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; border-collapse: collapse; color: #666666; line-height: 16px; background-color: #ffffff; padding: 0px; margin: 0px; border: 0px initial initial; width: 100%"><tbody style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">Processor Model #</td><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">i7-950</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">Platform Technology</td><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">Desktop</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">Cores/Threads</td><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">4/8</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">Clock Speed</td><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">3.06 GHz</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">Socket</td><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">FCLGA1366</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">Max Turbo Frequency</td><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">3.33GHz</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">L2 Cache</td><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">8M</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">Front Side Bus</td><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">4.8 GT/s</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">Max TDP</td><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">130</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">Silicon</td><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">45nm</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">Intel Turbo Boost Technology</td><td class="proc-spec-table-row-odd" style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: #f2f2f2; margin: 0px; border: 0px initial initial;">Y</td></tr><tr style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; height: 21px; padding: 0px; margin: 0px; border: 0px initial initial;"><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">Intel Hyper Threading Technology</td><td style="outline-style: none; outline-width: initial; outline-color: initial; padding-top: 4px; padding-right: 0px; padding-bottom: 4px; padding-left: 0px; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, tahoma, helvetica, sans-serif; font-size: 12px; margin: 0px; border: 0px initial initial;">Y</td></tr></tbody></table><div class="prod-details-processor-information" style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; font-family: intel-neo-sans-1, intel-neo-sans-2, Tahoma, Helvetica, sans-serif; padding: 0px; margin: 0px; border: 0px initial initial;"><div class="prod-details-processor-details component" style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; color: #666666; padding: 0px; margin: 0px; border: 0px initial initial;"><div class="proc-spec-intelinside" style="outline-style: none; outline-width: initial; outline-color: initial; border-image: initial; font: inherit; vertical-align: baseline; padding: 0px; margin: 0px; border: 0px initial initial;"></div></div></div> <p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p>