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 (500, 396, 598) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00291

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": "PRIMARY",
      "key_length": "13",
      "used_key_parts": ["product_id", "lang_code", "company_id"],
      "rows": 3,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.product_id in (500,396,598) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description
396	<p>Markins QR-70P is Compatible with any Arca-Swiss type quick shoe(clamp). It is designed for precision panorama photography. Panning action is silky smooth. Employing our new Quick-Turn knob, it is extremely fast and efficient to open and close the clamp while offering excellent compatibility with most Arca Swiss type plate in the market. The Quick-Turn knob is 3 times faster than the traditional style. <br /> <br /> It can be mounted directly on our new i-Type Q-Balls replacing the existing clamp with M6 screw. Or, it can be mounted on top of the existing Arca Swiss type clamp using the PE-1 Adapter that comes together as kit.<br> </p> <div id="separate_dot_bar"></div> <ul style="margin-left:0px; padding-left:30px;"> <li>Innovative design greatly reduces size and weight. (Patent Pending)</li> <li>Compatible with any Arca-Swiss type camera plates</li> <li>The Quick-Turn knob opens or closed by one turn. (Patented)</li> <li>DDL Mechanism-Enhanced locking by double wedge lock (Patented)</li> </ul> <div id="separate_dot_bar"></div> <br> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_01.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar"> Innovative design </div> QR-70P is a totally new panorama quick shoe in the market. Main body is cut to shape beautiful body lines. It keeps larger jaw clamping area, greatly reduces size and weight. <br> <br> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_02.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar">Mininum size, Maximum performance </div> QR-70P reduces size and weight. but increases locking power and usefulness.<br /> "Lowest profile in its class, 24mm"<br /> Height is minimized to keep it free from vibration. <br> <br> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_03.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar">Quick turn knob </div> It also equipped with patented quick turn knob. It only takes a single turn to open or close the quickshoe jaw. You will love this fast open and close performance when your need to change the setup quickly, especially in cold weather or in need of quick response. <br> <br> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_04.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar"> Powerful panning lock - Double Disk Lock </div> <p>Small and light weight design is possible due to this powerful locking mechanism. QR-70P is equipped with a newly optimized DDL (double disc lock) mechanism. It is a device with dual wedge locking ring and disk of round shapes. It needs less torque to lock the panning. Overall, it is improved by 50%. Axis of rotation also stays the same regardless of locking. Position of locking knob is changed for easier control under a long nodal slide. It is more comfortable to operate and will provide you with sharper images. <br> <br> </p> <div align="center"><img src="./html/items/qr70p/qr70p_body_05.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar">Names of the Components </div> <ol> <li>Panorama locking knob </li> <li>Plate locking knob </li> <li>Panorama base （5' index）</li> <li>Plate stoper </li> <li>Bubble level </li> <li>Quick shoe index</li> </ol> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_06.gif" border="0"></div> <br> <br> <div id="separate_dot_bar"></div> <br> <br> <table width="90%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <td width="30%" bgcolor="#FFFFFF"><div align="center"><strong>Code</strong></div></td> <td width="70%" bgcolor="#FFFFFF"><strong>QR70P</strong></td> </tr> <tr> <td nowrap bgcolor="#FFFFFF"><div align="center">Release Style</div></td> <td nowrap bgcolor="#FFFFFF">Quick Turn Knob Style</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Base Diameter</div></td> <td bgcolor="#FFFFFF">2.44 in (62mm)</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Jaw Width </div></td> <td bgcolor="#FFFFFF">2.20 in (56mm)</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Width (Close / Open) </div></td> <td bgcolor="#FFFFFF">3.31 in (84mm) / 3.50 in (89mm) </td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Height</div></td> <td bgcolor="#FFFFFF">0.94 in (24mm)<br> 1.14 in (29mm) w/ Adaptor Plate</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Weight</div></td> <td bgcolor="#FFFFFF">6.56 oz (186g)<br> 7.23 oz (205g) w/ Adaptor Plate </td> </tr> </table> <br> <br><br> <br> <br> <br>	Tripod, Head, Quick, Shoe, Clamp, Panorama, Arca-Swiss, rrs, kirk, foba	Markins QR-70P is QuickShoe that rotates 360 degrees which is developed for panoramic photography.
500	<p><br> <b>マーキンス QR-70P-38 パノラマクイックシュー</b> は、<b>UNC 3/8-16（太ネジ）用</b>の360度回転するパノラマクイックシューです。</p> <p>UNC 3/8-16（太ネジ）で装着するタイプですので、３WAY雲台やi-Type以前のマーキンス自由雲台に取り付けてご使用いただけます。</p> <p> 自由雲台でもパノラマ撮影が可能なのに、なぜ別途にパノラマクイックシューが必要なのだろうかと疑問に思われる方も多いと思いますが、自由雲台のパノラマはベース部分が三脚に固定されていますので、平地以外の場所では、三脚が傾くためパノラマ撮影も傾いたものになります。<br> <br> 勿論、通常の撮影ではボールを傾けて水平を合わせれば問題ありませんが、パノラマ撮影となると、構図を少し横にずらしただけで再度水平合わせが必要となります。<br> <br> では、三脚を水平にすれば問題ないと思われるでしょうが、三脚の脚を伸ばしたり縮めたりして水平を合わせるのは簡単ではなく、結構な時間がかかるのです。<br> <br> そこでこのパノラマクイックシューですが、三脚の傾きを自由雲台で補正した状態でクイックシューが回転するわけですから、そのままパノラマ撮影が可能になるというわけです。<br> <br> <br> </p> <div align="center"><img src="./html/items/qr70p/qr70p38-b20.jpg" border="0"></div> <div id="separate_dot_bar"></div> <div align="center"><img src="./html/items/qr70p/qr70p-38-b11.jpg" border="0"></div> <div align="center">※３WAY雲台やi-Type以前のマーキンス自由雲台に装着</div> <div style="margin:20px 0 30px 0;"> <div align="center"><img src="./html/images/report/yn-takahashi/yn-takahashi_22.jpg" border="0"></div> <div style="margin-top:10px;"></div> <div align="center">※ハスキーの３WAY雲台に装着</div> </div> <div id="separate_dot_bar"></div> <ul style="margin-left:0px; padding-left:30px; line-height:25px;"> <li>アルカスイスと互換性のあるダブテールスタイル</li> <li>クイックターン・ノブによる機材の素早い着脱</li> <li>パンニングに Double Disc Lock 採用</li> <li>航空機素材としても使われるアルミ合金採用による軽量化と十分な剛性</li> <li>硬質アルマイト（ハードアノダイジン）加工による高い耐磨耗性</li> <li>滑らかで安全なラウンディング加工とバレル研磨仕上げ</li> <li>機材の落下を予防する安全ピン付</li> <li>水準器内臓</li> </ul> <div id="separate_dot_bar"></div> <br> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_01.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar"> 斬新なデザイン </div> 一般的な円形デザインから最適な曲線を探し、不必要な部分を削りました。クランピング面積は損なわず、サイズと重量を絞った画期的なデザインに仕上がりました。<br> <br> <br> <div align="center"><img src="/html/items/qr70p/qr70p_body_02.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar"> コンパクトサイズながら最高のパフォーマンス </div> 既存のデザインを見直すことでコンパクトサイズを実現。しかも、高さはわずか24mm。重心が低くおさえられる分、振動も抑えられます。<br> <br> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_03.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar"> クイックターン・ノブ </div> 約１回転で着脱可能なクイックターン・ノブを採用しましたので、機材の素早い着脱が可能です。<br> <br> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_04.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar"> Double Disk Lock による強力なパンニング</div> パンニングにはダブルディスク方式を採用。くさび型によりわずかな力でも50% が向上した強力なトルクを誇ります。ロック時の回転軸のブレもありませんので鮮明度の高いパノラマ撮影が可能です。 <br> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_05.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar"> 主要部分の説明</div> <ol> <li>パノラマ固定ノブ</li> <li>プレート固定ノブ</li> <li>パノラマベース（5°インデックス）</li> <li>安全ピン</li> <li>水準器</li> <li>クイックシュー目盛：8mm間隔</li> </ol> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_06.gif" border="0"></div> <br> <br> <table width="90%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <td width="30%" bgcolor="#FFFFFF"><div align="center"><strong>型番</strong></div></td> <td width="70%" bgcolor="#FFFFFF"><strong>QR70P-38</strong></td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">JANコード</div></td> <td bgcolor="#FFFFFF">4580404982219</td> </tr> <tr> <td nowrap bgcolor="#FFFFFF"><div align="center">タイプ</div></td> <td nowrap bgcolor="#FFFFFF">クイックターンノブ</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">ベース直径</div></td> <td bgcolor="#FFFFFF">62mm</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">JAW 幅 </div></td> <td bgcolor="#FFFFFF">56mm</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">幅（Close / Open）</div></td> <td bgcolor="#FFFFFF">84mm / 89mm</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">高さ</div></td> <td bgcolor="#FFFFFF">24mm</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">重量</div></td> <td bgcolor="#FFFFFF">186g</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">装着方法</div></td> <td bgcolor="#FFFFFF"><strong>UNC 3/8-16（太ネジ）</strong> ※付属しません<br /> ※取り付け機材が細ネジの場合は別途 <a href="/accessory/bu1/">ブッシュアダプタ</a> 要</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">適応雲台</div></td> <td bgcolor="#FFFFFF">Markins i-Type 以前の自由雲台、<a href="/ballhead/q10inqs/">Q10i-NQS</a>、<a href="/ballhead/q20inqs/">Q20i-NQS</a>、3WAY 雲台、他</td> </tr> </table> <br> <br>
598	<p>Markins QR-65P is Compatible with any Arca-Swiss type quick shoe(clamp). It is designed for precision panorama photography. Panning action is silky smooth. Employing our new Quick-Turn knob, it is extremely fast and efficient to open and close the clamp while offering excellent compatibility with most Arca Swiss type plate in the market. The Quick-Turn knob is 3 times faster than the traditional style. <br /> <br /> It can be mounted directly on our new i-Type Q-Balls replacing the existing clamp with M6 screw. Or, it can be mounted on top of the existing Arca Swiss type clamp using the PE-1 Adapter that comes together as kit.<br> </p> <div id="separate_dot_bar"></div> <ul style="margin-left:0px; padding-left:30px;"> <li>Innovative design greatly reduces size and weight. (Patent Pending)</li> <li>Compatible with any Arca-Swiss type camera plates</li> <li>The Quick-Turn knob opens or closed by one turn. (Patented)</li> <li>DDL Mechanism-Enhanced locking by double wedge lock (Patented)</li> </ul> <br> <br> <div style="height:20px;"></div> <div id="subtitle_bar">Quick turn knob </div> It also equipped with patented quick turn knob. It only takes a single turn to open or close the quickshoe jaw. You will love this fast open and close performance when your need to change the setup quickly, especially in cold weather or in need of quick response. <br> <br> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_04.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar"> Powerful panning lock - Double Disk Lock </div> <p>Small and light weight design is possible due to this powerful locking mechanism. QR-65P is equipped with a newly optimized DDL (double disc lock) mechanism. It is a device with dual wedge locking ring and disk of round shapes. It needs less torque to lock the panning. Axis of rotation also stays the same regardless of locking. Position of locking knob is changed for easier control under a long nodal slide. It is more comfortable to operate and will provide you with sharper images. <br> <br> </p> <div><img src="/html/items/qr65p/qr65p_double_disk.gif" border="0"></div> <div style="height:20px;"></div> <div id="subtitle_bar">Names of the Components </div> <ol> <li>Panorama locking knob </li> <li>Plate locking knob </li> <li>Panorama base （5' index）</li> <li>Plate stoper </li> <li>Bubble level </li> <li>Quick shoe index</li> </ol> <br> <div align="center"><img src="./html/items/qr70p/qr70p_body_06.gif" border="0"></div> <br> <br> <table width="90%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <td width="30%" bgcolor="#FFFFFF"><div align="center"><strong>Code</strong></div></td> <td width="70%" bgcolor="#FFFFFF"><strong>QR65P</strong></td> </tr> <tr> <td nowrap bgcolor="#FFFFFF"><div align="center">Release Style</div></td> <td nowrap bgcolor="#FFFFFF">Quick Turn Knob Style</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Base Diameter</div></td> <td bgcolor="#FFFFFF">2.44 in (62mm)</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Jaw Width </div></td> <td bgcolor="#FFFFFF">2.20 in (56mm)</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Width (Close / Open) </div></td> <td bgcolor="#FFFFFF">3.31 in (84mm) / 3.50 in (89mm) </td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Height</div></td> <td bgcolor="#FFFFFF">0.94 in (24mm)<br> 1.14 in (29mm) w/ Adaptor Plate</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center">Weight</div></td> <td bgcolor="#FFFFFF">6.56 oz (186g)<br> 7.23 oz (205g) w/ Adaptor Plate </td> </tr> </table> <br> <br><br> <br> <br> <br>	Tripod, Head, Quick, Shoe, Clamp, Panorama, Arca-Swiss, rrs, kirk, foba	Markins QR-65P is QuickShoe that rotates 360 degrees which is developed for panoramic photography.