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

Query time 0.00025

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": 5,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.product_id in (527,528,529,530,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
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
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.