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 (530, 330, 322) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00028

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 (530,330,322)",
      "attached_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description
322	<br> <div style="font-size:14px;font-weight:bold;">Markins PC-14 is an Arca-Swiss compatible style dovetail plate for Canon EF 100-400mm f/4.5-5.6L IS II USM lens. </div> <p></p> <div id="separate_dot_bar"></div> <br> <ul style="margin-left:0px;line-height:18px;"> <li>Compatible with any Arca-Swiss type</li> <li>Anti-twist flange style</li> <li>Scratch resistant hard-anodized surface</li> <li>Safe and ergonomically rounded corners and edges</li> </ul> <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" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th width="20%" bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">PC14</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">1.16 oz (33 g)</td> </tr> <tr> <th bgcolor="#FFFFFF" >Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <tr> <th nowrap bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">2.4x1.5x0.4 in (60×38×10 mm)</td> </tr> <tr> <th nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Canon EF 100-400mm f/4.5-5.6L IS II USM</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Mounting Bolt</th> <td bgcolor="#FFFFFF">1/4"-20 UNC Bolt <a href="/accessory/hb1/">HB1</a> <br /> * Requires 4mm (5/32") hex <a href="/accessory/tllw1/">L-wrench</a></td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Monopod Hole</th> <td bgcolor="#FFFFFF">1/4"-20 UNC</td> </tr> </table> <div style="height:50px;"></div> <center><img src="/html/items/lensplate/pc14_20.jpg"></center> <br> <br> <br>	Camera, Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba	Markins PC-14 is an Arca-Swiss compatible style dovetail plate for Canon EF 100-400mm f/4.5-5.6L IS II USM lens.
330	<div style="font-size:14px;font-weight:bold;"></div> <p>Markins 'Ring Plate' is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.</p> <p>It replaces the original lens foot and provides a double support and a lowered mass center of the lens, which gives an enhanced stability of your system. </p> <p>The 'Ring Plate' will provide the photographers with a widened capability of creating photos using a long teleport lens which has never been possible before.</p> <div id="separate_dot_bar"></div> <br> <ul style="margin-left:0px;line-height:18px;"> <li>Custom fit plates for Super teleport lenses</li> <li>Modular design: Ring + Replacement lens foot</li> <li>Much enhanced vibration reduction performance</li> <li>Safer and comfortable hand holding </li> </ul> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Specification</div> <table width="90%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">RC60SET</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">10.16 oz (288 g)</td> </tr> <tr> <th bgcolor="#FFFFFF" >Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <tr> <th nowrap bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">6.2 x 5.9 x 9.4 in (158 x 150 x 240 mm)</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Canon EF 600mm F4L IS II USM</td> </tr> </table> <br> <br> <div id="separate_dot_bar"></div> <br> <br> <center> <img src="./html/items/rc60set_body02.jpg" alt="Ring Plate Outline" /> </center> <br> <br> <br>	Canon, EF, 600mm, F4L, IS, II, USM, Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba	Markins Ring Plate is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.
530	<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: 40px 0px 20px; 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_set_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="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Specification</div> <TABLE width="90%" bgcolor="#424242" cellspacing="1" cellpadding="5"> <TBODY> <TR> <TD width="30%" bgcolor="#ffffff"><DIV align="center"><strong>Product</strong></DIV></TD> <TD align="middle" bgcolor="#ffffff"><div align="left"><strong>Markins Q20iQ-BK + BV-24 (with BS-22) Set</strong></div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center">Code</DIV></TD> <TD align="middle" bgcolor="#ffffff"><div align="left">BV24SET</div></TD> </TR> </TBODY> </TABLE> <BR> <TABLE width="90%" bgcolor="#424242" cellspacing="1" cellpadding="5"> <TBODY> <TR> <TD width="30%" bgcolor="#ffffff"><DIV align="center"><strong>BV-HEAD</strong></DIV></TD> <TD align="middle" bgcolor="#ffffff"><div align="left"><A href="./bv-head/bv24/"><strong>BV24</strong></A></div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center">Weight</DIV></TD> <TD align="middle" bgcolor="#ffffff"><div align="left">0.49lb (222 g)</div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center">Size</DIV></TD> <TD align="middle" bgcolor="#ffffff"><div align="left">4.33 x 3.07 x 2.36in (110 x 78 x 60 mm)</div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center"><strong>BV-STOPPER</strong></DIV></TD> <TD align="middle" bgcolor="#ffffff"><div align="left"><strong>BS-22</strong></div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center">Weight</DIV></TD> <TD align="middle" bgcolor="#ffffff"><div align="left">0.04lb (16 g)</div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center">Size</DIV></TD> <TD align="middle" bgcolor="#ffffff"><div align="left">1.69 x 0.55 x 0.75 in (43 x 14 x 19 mm)</div></TD> </TR> </TBODY> </TABLE> <BR> <TABLE width="90%" bgcolor="#424242" cellspacing="1" cellpadding="5"> <TBODY> <TR> <TD width="30%" bgcolor="#ffffff"><DIV align="center"><strong>Ball Head</strong></DIV></TD> <TD align="middle" bgcolor="#ffffff"><div align="left"><A href="./bv-head/bv22set/"><strong>Q20iQ-BK</strong></A></div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center">Maximum Load</DIV></TD> <TD bgcolor="#ffffff"><div align="left">110lb (50 kg)</div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center">Weight</DIV></TD> <TD bgcolor="#ffffff"><div align="left">1.22lb (552 g)</div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center">Ball Diameter</DIV></TD> <TD nowrap="nowrap" bgcolor="#ffffff"><div align="left">1.89in (48mm)</div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center">Base Diameter</DIV></TD> <TD nowrap="nowrap" bgcolor="#ffffff"><div align="left">2.68in (68mm)</div></TD> </TR> <TR> <TD bgcolor="#ffffff"><DIV align="center">Height</DIV></TD> <TD nowrap="nowrap" bgcolor="#ffffff"><div align="left">4.02in (102mm)</div></TD> </TR> <TR> <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> <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 bgcolor="#ffffff"><DIV align="center">Camera Connection</DIV></TD> <TD bgcolor="#ffffff"><div align="left"><a href="/quickshoe/i-type/ql60i/">QL-60i</a></div></TD> </TR> </TBODY> </TABLE> <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 SET is Ball head Q20iQ-BK + BV-Head BV-24. Easy Solution Head for Bird Photography & Videography.