SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    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, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    287, 288, 289, 290, 286, 285, 278, 280, 
    282, 247, 248, 241, 244, 245, 246, 240, 
    6, 66, 166, 214, 219, 221, 223, 192
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00076

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_descriptions",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["product_id", "lang_code"],
          "rows": 24,
          "filtered": 100,
          "index_condition": "cscart_product_descriptions.product_id in (287,288,289,290,286,285,278,280,282,247,248,241,244,245,246,240,6,66,166,214,219,221,223,192) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
6 <p>Think you need to break your budget to enjoy blockbuster HD entertainment? Not with Toshiba's 32" class C110U LCD HDTV. Featuring all-new design, this value-packed television looks great and works well in a living room, kitchen or bedroom. Increase detail and depth of the images on your screen with our impressive Dynalight technology.</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>
66 <p>The XRS 9970G provides total protection and peace of mind with Super-Xtreme Range Superheterodyne Technology, detecting all 15 radar/laser bands with its super-fast lock-on detection circuitry. The unit provides extra detection range and the best possible advance warning to even the fastest of POP mode radar guns. . It comes with a GPS Locator and Lifetime updates to the AURA&trade; Database to alert you to verified Speed and Red Light Camera locations, dangerous intersections, and reported Speed Trap locations for entire United States and Canada. Other features include Cobra exclusive Touchscreen, full-color ExtremeBright DataGrafix Display, an 8-point electronic compass, Voice Alert, car battery voltage display/low car battery warning and much more.</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>
166 <p>For your very mobile lifestyle comes a completely new imaging system with freedom to create and express as never before. Highly compact and portable, the Nikon 1 J1 goes everywhere you go. Moments from your amazing world are captured using a highly responsive autofocus and super fast shooting speed. In one touch you can work in Full HD (1080p) movie record mode. A camera so versatile you can even snap photos while recording movies. Unleash your creativity with Nikon 1&mdash;offering a balance of high performance, advanced features, portability and a newly designed interchangeable lens system. Infuse your world with photos from every moment and connect as never before.</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>
192 <p><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">Tracklisting:</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">1. Black And White America</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">2. Come On Get It</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">3. In The Black</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">4. Liquid Jesus</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">5. Rock Star City Life</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">6. Boongie Drop</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">7. Stand</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">8. Superlove</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">9. Everything</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">10. I Can't Be Without You</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">11. Looking Back On Love</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">12. Life Ain't Ever Been Better Than It Is Now</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">13. The Faith Of A Child</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">14. Sunflower</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">15. Dream</span><br style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #cac5c5; padding: 0px; margin: 0px;" /><span style="color: #000000; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; text-align: left; background-color: #ffffff;">16. Push</span></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>
214 <p>A glossy surface givess the CP6130 an air of elegance, while and an eye-catching power button inspired from the halo of a lunar eclipse seamlessly blends in to the front of the case.</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>
219 <p>Don't be weighed down by wasted time, let your PC come alive when you need it. Your life happens on the go, you don't have time to wait for PC to shut down and power up. With Samsung's exclusive Fast Start technology, simply close the lid to enter a hybrid sleep mode. When you open the lid, you are up and running in less than 3 sec.</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>
221 <p>You no longer have to shut down your Samsung computer, just close its lid and it goes into a special powerless sleep mode. When you open the lid your computer comes back to life in 3 seconds and you are exactly at the same place as when you shut the lid. Fast Start saves your data and system configurations to your hard drive and PC memory. So, when you power it back on it is just like you left 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>
223 <p>If you buy the wrong tablet, you&rsquo;re at the mercy of the manufacturer regarding how much you can customize or personalize your screens. But the beauty of Android is that you have much greater flexibility to arrange things however you want. You&rsquo;ll have multiple home screens to compose and design, plus live wallpapers to express your mood and personality. The Tab also offers you the freedom of TouchWiz&reg;, the intuitive user interface that allows you to quickly drag and drop your icons, widgets and Live Panels with only the touch of a finger. Now, reorganizing your tablet&rsquo;s menus and navigational options will be simple and straightforward.</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>
240 <p> iPad features a stunning Retina display, iSight® and FaceTime cameras, the all new A6X chip and ultrafast wireless. And with access to over 275,000 apps1 on the App Store, you can do more than ever. </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>
241 <p> iPad features a stunning Retina display, iSight® and FaceTime cameras, the all new A6X chip and ultrafast wireless. And with access to over 275,000 apps1 on the App Store, you can do more than ever. </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>
244 <p> Great Packard Bell all in one PC with 23" HD LCD Multi Touchscreen and Windows 7. The PC is in perfect working order. The LCD screen is very crisp and bright and the touchscreen is responsive and easy to use The casing is in good but used condition, there is hardly a mark on it and only noticeable very close up. Comes with an Intel i3 CPU and a dedicated nVidia Geforce 315 video card for superb performance. Also has a Freeview TV card so you can watch and record TV.It has an HDMI out port making it simple to connect to a larger TV if required. It has had a fresh install of Windows 7 including the full Packard Bell software suite. Windows has been fully updated and you are ready to go straight out of the box. Has an active recovery partition enabling you to perform a full reset to factory defaults straight from the hard drive and also create a spare set of recovery discs. </p>
245 <p> A6 chip. 8MP iSight camera. 4-inch Retina display. Ultrafast LTE wireless. iPhone 5c has the things that made iPhone 5 an amazing phone — and more, including iOS 7. All in a completely new design that feels great in your hand. </p>
246 <p> Take smooth video with up to 4K resolution with this GoPro Hero3+ Black Edition CHDHX-302 camera that features a waterproof housing and a wearable, mountable design that lets you easily film yourself engaging in your favorite activities. </p>
247 <p>Nokia N1 smartphone with 7.90-inch 2048x1536 display powered by 2.3GHz processor alongside 2GB RAM and 8-megapixel rear camera.</p>
248 <p>Xbox One's exterior casing consists of a two-tone "liquid black" finish; with half finished in a matte grey, and the other in a glossier black. The design was intended to evoke a more entertainment-oriented and simplified look than previous iterations of the console; among other changes.</p><div>It is powered by an AMD "Jaguar" Accelerated Processing Unit (APU) with two quad-core modules totaling eight x86-64 cores clocked at 1.75 GHz, and 8 GB of DDR3 RAM with a memory bandwidth of 68.3 GB/s. The memory subsystem also features an additional 32 MB of "embedded static" RAM, or ESRAM, with a memory bandwidth of 109 GB/s.</div> <p class="product-promo-text"><span class="product-promo-header">Just before the end of the week!</span><span class="product-promo-body">Select the drive with the game as a gift!</span></p>
278
280
282
285 <p></p> <p>Compatible Part Number:0X3X6, CGFJT <sup class="superscript"></sup><br>Model:DPS-200PB-184<sup class="superscript"></sup></p> <p></p> DPS-200PB-184, 0X3X6, CGFJT, S3048-ON, DELL 200W, Reverse Airflow PSU
286 <p>Optiplex 7010 9010 780 790 990 Usff</p> 1VCY4, NMPRY, DPS-200PB-191, OptiPlex 7010, OptiPlex 9010, OptiPlex 780, OptiPlex 790, OptiPlex 990, USFF 200W PSU
287 <p>Juiciness-e bhorpur ebong akare boro Giant Kew pineapple&mdash;fresh juice o smoothie-er jonno shera.</p> Giant Kew, Giant Pineapple, Juice Anaras, Big Pineapple, Fresh Anaras
288 <p>Deshi jat-er sobcheye misti o shugondhi Honey Queen pineapple.</p> Honey Queen, Misti Anaras, Sweet Pineapple, Deshi Anaras, Premium Pineapple
289 <p>Natural golden colour ebong Vitamin C rich MD2 Gold pineapple.</p> <p>MD2 Pineapple, Gold Pineapple, Golden Anaras, Vitamin C Fruit, Export Quality Pineapple</p>
290 <p>Kantahin pata o cylindrical shape-er smooth texture pineapple.</p> Smooth Cayenne, Juice Pineapple, Sliced Anaras, Canning Pineapple, Fresh Fruits