Sandbox

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 (266, 529, 586) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00026

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id", "company_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 3,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.product_id in (266,529,586)",
      "attached_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
266		<p><span style="font-size: 16px;font-weight: bold;padding-bottom:20px;">Fine Art Quality, Professional "Ball Head" </span></p> <p>Professionals demand a device that can trust.</p> <p>It must perform when situation gets difficult, even in extreme cold or hot weathers.</p> <p>Our Q-Balls are very durable and corrosion resistant because they are made out of the highest quality Material(A6061-T6) used in the aviation industry with CNC precision machining and hard-anodized process.</p> <p>You can trust our Q-Ball and dedicated yourself in taking pictures.</p> <p><br> →　<a href="./about-markins#movie"><strong>Demo Movie (9kg TEST BAR on Markins Q10i)</strong></a></p> <div style="height:1px; border-bottom: 1px #aaaaaa dotted; margin: 20px 0px 20px 0px;"></div> <br> <ul> <li>All-in-one design with quickshoe</li> <li>110lb (50kg) of load capacity, the best in its class</li> <li>Compatible with the new BV-Head attachment</li> <li>Improved anti-vibration and new replaceable quickshoe connection</li> <li>The Quick Lever opens or closes by single action (Patented)</li> </ul> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Quick Release Lever</div> The lever arm is convertible to eigher left or right hand position for one's own convenience.<br> <br> <p><img src="./html/images/qs-i-type-q-en.gif" ></p> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Posision Marks</div> Laser engraved position marks make it convenient to align the nodal point in panorama photography.<br> <br> <p><img src="./html/images/qs-i-type-index-en.gif" ></p> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Specification</div> <table width="100%" cellpadding="5" cellspacing="1"> <tbody> <tr><td><div align="center"><strong>Code</strong></div></td> <td><strong>Q20iQ-BK</strong></td> </tr> <tr><td><div align="center">Color</div></td> <td>Wine Red </td> </tr> <tr><td><div align="center">Maximum Load</div></td> <td>110lb (50 kg)</td> </tr> <tr><td><div align="center">Weight</div></td> <td>1.22lb (552 g)</td> </tr> <tr><td><div align="center">Ball Diameter</div></td> <td>1.89in (48mm)</td> </tr> <tr><td><div align="center">Base Diameter</div></td> <td>2.68in (68mm)</td> </tr> <tr><td><div align="center">Height</div></td> <td>4.02in (102mm)</td> </tr> <tr><td><div align="center">Tripod Mount Hole</div></td> <td>UNC 3/8"-16</td> </tr> <tr bgcolor="#424242"> <td nowrap="nowrap" bgcolor="#ffffff"><div align="center">Friction Control</div></td> <td bgcolor="#ffffff"><div align="left">Bi-Axial Progressive</div></td> </tr> <tr bgcolor="#424242"> <td bgcolor="#ffffff"><div align="center">Maximum Torque</div></td> <td bgcolor="#ffffff"><div align="left">220 lbf・in (250 kgf・cm)</div></td> </tr> <tr><td><div align="center">Panning</div></td> <td>Yes</td> </tr> <tr><td><div align="center">Panorama Index </div></td> <td>Yes</td> </tr> <tr bgcolor="#424242"> <td bgcolor="#ffffff"><div align="center">Camera Connection</div></td> <td bgcolor="#ffffff"><div align="left">Lever Release Style Quickshoe (QL-60i)</div></td> </tr> </tbody> </table> <p> </p> <p> </p> <p> </p>	Camera,head, ballhead, tripod, gitzo, Arca Swiss, RRS, KIRK, Wimberley, foba	Fine Art Quality, Professional Ball Head Markins Q20iQ-RD Lever Shoe
529		<h4 style="line-height:25px;">Simple & Easy Solution<br>for Bird Photography & Videography</h4> <div style="height:20px;"></div> <p style="line-height:21px;">Markins BV-Head is a ball head module designed for bird photography or videography.<br /> It makes the ball rotate in one direction only. It also helps reduce vibration because the mass centers of the ball head, BV-Head and your equipment can easily be aligned on top of each other.<br /> With this compact, easy-to-install and light weight BV-Head, we hope your photographic life more enjoyable. </p> <div style="margin: 20px 0px 20px 0; border-bottom: 1px dotted #666666;"></div> <ul style="margin: 20px 0 0 0;line-height:21px;"> <li>compact and portable head module for bird photography and videography</li> <li>easy installation and provide swift change between the two functions</li> <li>two types of heads in one package</li> <li>The new Quick-Turn knob opens or closed by one turn (Patent Pending)</li> </ul> <div style="margin: 20px 0px; height: 1px; border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1px; border-bottom-style: dotted;"></div> <p align="center"><img src="./html/items/bv-head/bv-head_use_icon.jpg" unselectable="on"></p> <div style="margin: 20px 0px 20px; height: 1px; border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1px; border-bottom-style: dotted;"></div> <div style="width:420px; float:left; margin:0 10px 10px 0;"><img src="./html/images/report_20150516_11.jpg" border="0" unselectable="on"></div> <div style="width:420px; float:left; margin:0 10px 10px 0;"><img src="./html/images/report_20150516_12.jpg" border="0" unselectable="on"></div> <div style="clear:left;"></div> <p>→　<a href="./report/150515">Users Report of Koji Nakano</a></p> <p>→　<a href="./report/150618">Users Report of Yoshiteru Takahashi</a></p> <br> <div style="margin: 20px 0px 20px; height: 1px; border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1px; border-bottom-style: dotted;"></div> <p align="center"><a href="http://player.vimeo.com/video/74501616?color=ff9933&autoplay=1" target="_blank"><img src="./html/images/bvhead_set_install.jpg" border="0" unselectable="on"></a></p> <div align="center"><br> <a href="http://player.vimeo.com/video/74501616?color=ff9933&autoplay=1" target="_blank"><img src="./html/images/bvhead_install_movie.jpg" width="400" border="0"></a> </div> <div style="margin: 20px 0px 20px; height: 1px; border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1px; border-bottom-style: dotted;"></div> <p></p> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Specification</div> <table width="90%" style="color: rgb(66, 66, 66); font-size: 10pt;" bgcolor="#424242" cellspacing="1" cellpadding="5"> <tbody> <TR> <TH bgcolor="#ffffff"><strong>Product</strong></TH> <TD bgcolor="#ffffff"><strong>Markins BV-24 (with BS-22)</strong></TD> </TR> <TR> <td bgcolor="#ffffff"><div align="center">Code</div></td> <TD bgcolor="#ffffff">BV24</TD> </TR> <TR> <td bgcolor="#ffffff"><div align="center">Weight</div></td> <TD bgcolor="#ffffff">0.52lb (238 g) with BS-22 </TD> </TR> <TR> <td bgcolor="#ffffff"><div align="center">Size</div></td> <TD bgcolor="#ffffff">4.33 x 3.07 x 2.36in (110 x 78 x 60 mm)</TD> </TR> <TR> <td nowrap="" bgcolor="#ffffff"><div align="center">BS-22</div></td> <TD bgcolor="#ffffff">BS-22（Stopper） * 1EA<br /> Weight (16ｇ)<br /> Size 1.69 * 0.55 * 0.75in (43 * 14 * 19 mm）</TD> </TR> <TR> <td nowrap="" bgcolor="#ffffff"><div align="center">Fit</div></td> <TD bgcolor="#ffffff">Markins Q-Ball Q20i Series</TD> </TR> </tbody> </table> <div align="center"></div> <div style="margin: 20px 0px; height: 1px; border-bottom-color: rgb(170, 170, 170); border-bottom-width: 1px; border-bottom-style: dotted;"></div>	Camera, Video, Bird, Video, Photo, Tripod, Wimberley, Gimbal, Arca-swiss, Wimberley	Markins BV-24 is Simple & Easy Solution Head for Bird Photography & Videography