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 (
    316, 595, 533, 511, 534, 517, 515, 516
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00027

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": 8,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.product_id in (316,595,533,511,534,517,515,516) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
316 <br> <div style="font-size:14px;font-weight:bold;">Optional LS-A72 for PS-A72 to convert it to L-Plate（L-Bracket）</div> <p>*Requires <a href="/plate/camera/psa72/">PS-A72</a> camera plate</p> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Compatible with any Arca-Swiss type</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="90%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th width="20%" bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">LSA72</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">0.81 oz (23 g)</td> </tr> <tr> <th bgcolor="#FFFFFF" >Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Sony α7II, α7RII, α7SII</td> </tr> </table> <br> <br> <!-- <div id="separate_dot_bar"></div> <div style="width:96%;text-align: left;">サイトリンク：　<a href="http://ganref.jp/accessories/2495">GANREF</a></div> --> <br> <br> <br> Camera, Tripod, Head, Quick, Shoe, Clamp, Plate, Bracket, Arca-Swiss, rrs, kirk, foba For Sony α7II α7RII. Optional LS-A72 for PS-A72 to convert it to L-Plate（L-Bracket）
511 <p>Camera Plate (PV-100 ) &amp; Sub Plate ( LV-160 ) L-Plate Set.</p> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Compatible with any Arca-Swiss type</li> <li>Anti-Twist rubber bumpons </li> <li>Scratch resistant hard-anodized surface</li> <li>Safe and ergonomically rounded corners and edges</li> </ul> <div id="separate_dot_bar"></div> <br> <center><img src="./html/items/plv/pv100_lv160-170.png"></center> <br> <br> <table width="90%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">PLV100160</td> </tr> <tr> <th bgcolor="#FFFFFF">JAN</th> <td bgcolor="#FFFFFF">4580404982318</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">2.36 oz ( 67 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">3.7 X 1.5 X 2.8 in ( 94×38×70 mm )</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Mounting Bolt</th> <td bgcolor="#FFFFFF">1/4 UNC Bolt <a href="/accessory/hb1/">HB1</a> <br /> *<a href="/accessory/tllw1/">L-Wrench</a> is required separately</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Universal fit for medium sized SLRs</td> </tr> <!-- <tr> <th width="20%" nowrap bgcolor="#FFFFFF">主な適応カメラ</th> <td bgcolor="#FFFFFF">35mmカメラ及びデジタルカメラ</td> </tr> --> </table> <br> <br> <br><br> <!-- <div id="subtitle2_bar"><b>使用例</b></div> <br> <div style="margin:20px 0 0 0;"> <center> <img src="/html/items/lu100/leica_sl_lu100_11.jpg" alt="ライカ SL Typ 601" /> <div style="margin-top:10px;">ライカ SL Typ 601 + LU-100 + <a href="/accessory/p67ustb/">P67USTB</a></div> </center> </div> <br> <div id="separate_dot_bar"></div> <br> --> <br> <br>
515 <p>Markins sub plate LV-160 for PV-80 and PV-100.</p> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Compatible with any Arca-Swiss type</li> <li>Scratch resistant hard-anodized surface</li> <li>Safe and ergonomically rounded corners and edges</li> </ul> <div style="height: 30px;"></div> <table width="100%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">LV160</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">0.63 oz ( 18 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">0.6 X 1.5 X 2.8 in ( 14×38×70 mm )</td> </tr> </table> <div style="margin:40px 0 50px 0;"> <center><img src="/html/items/plv/lv160_size.jpg"></center> </div>
516 <p>Markins sub plate LV-160 for PV-80 and PV-100.</p> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Compatible with any Arca-Swiss type</li> <li>Scratch resistant hard-anodized surface</li> <li>Safe and ergonomically rounded corners and edges</li> </ul> <div style="height: 30px;"></div> <table width="100%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">LV160</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">0.74 oz ( 21 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">0.7 X 1.5 X 3.1 in ( 19×38×80 mm )</td> </tr> </table> <div style="margin:40px 0 50px 0;"> <center><img src="/html/items/plv/lv170_size.jpg"></center> </div>
517 <p>Camera Plate (PV-100 ) &amp; Sub Plate ( LV-170 ) L-Plate Set.</p> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Compatible with any Arca-Swiss type</li> <li>Anti-Twist rubber bumpons </li> <li>Scratch resistant hard-anodized surface</li> <li>Safe and ergonomically rounded corners and edges</li> </ul> <div id="separate_dot_bar"></div> <br> <center><img src="./html/items/plv/pv100_lv160-170.png"></center> <br> <br> <table width="90%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">PLV100170</td> </tr> <tr> <th bgcolor="#FFFFFF">JAN</th> <td bgcolor="#FFFFFF">4580404982325</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">2.47 oz ( 70 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">3.9 X 1.5 X 3.1 in ( 99×38×80 mm )</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Mounting Bolt</th> <td bgcolor="#FFFFFF">1/4 UNC Bolt <a href="/accessory/hb1/">HB1</a> <br /> *<a href="/accessory/tllw1/">L-Wrench</a> is required separately</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Universal fit for medium sized SLRs</td> </tr> </table> <br> <br> <div id="subtitle2_bar"><b>Example of use</b></div> <div style="margin:10px 0 0 0;"> <center> <img src="/html/items/plv/d750_lv170_01.jpg" alt="Nikon D750" /> <div style="margin-top:10px;">Nikon D750 + PLV100170</div> </center> </div> <br> <div id="separate_dot_bar"></div> <br> <br> <br>
534 <p>Camera Plate (PV-80 ) &amp; Sub Plate ( LV-170 ) L-Plate Set.</p> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Compatible with any Arca-Swiss type</li> <li>Anti-Twist rubber bumpons </li> <li>Scratch resistant hard-anodized surface</li> <li>Safe and ergonomically rounded corners and edges</li> </ul> <div id="separate_dot_bar"></div> <br> <center><img src="./html/items/plv/pv80_lv160-170.png"></center> <br> <br> <table width="90%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">PLV100170</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">2.43 oz ( 69 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">3.4 X 1.5 X 3.1 in ( 87×38×80 mm )</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Mounting Bolt</th> <td bgcolor="#FFFFFF">1/4 UNC Bolt <a href="/accessory/hb1/">HB1</a> <br /> *<a href="/accessory/tllw1/">L-Wrench</a> is required separately</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Universal fit for medium sized SLRs</td> </tr> </table> <br> <br> <br><br> <div id="subtitle2_bar"><b>Example of use</b></div> <br> <div style="margin:20px 0 0 0;"> <center><img src="/html/items/plv/plv80170-x-t2_12.jpg" alt="Fujifilm X-T2" /></center> <div style="margin-top:10px; text-align:center;">Fujifilm X-T2</div> </div> <br> <br>
595 <br> 別売のカメラプレート <a href="/plate/camera/psa9"><b>PS-A9</b></a> と組み合わせることにより、縦位置撮影に素早く変更できる L-プレートとしてご使用いただける <b>ソニー α9, α7RIII 専用</b> サブプレートです。<br> <br> 組み合わせ時も、十分な強度がありますので、カメラをしっかりとホールドし、ブレのない安定した撮影が可能です。<br> <br> <div id="separate_dot_bar"></div> <br> <p> L-プレートを使用することにより、雲台を動かさずに、すばやく横位置・縦位置の切り替えができ、光軸のズレも抑えられます。</p> <p> シンプルで洗練されたデザインには無駄がないため軽量なのがマーキンス（Markins） プレートの特徴です。</p> <p>また、カメラに装着したさいにバランスが最も良くなるように計算された設計には、振動の原因を徹底的になくしていくという独自のこだわりが詰まっています。</p> <p> 軽量ながらも充分な剛性があり、カメラをしっかりとホールドしますので、ブレのない安定した撮影が可能です。</p> <br> <div id="separate_dot_bar"></div> <br> <ul style="line-height:21px;"> <li style="color:#000099"><strong>アルカスイスと互換性のあるダブテールスタイル</strong></li> <li style="color:#000099"><strong>硬質アルマイト（ハードアノダイジン）加工による高い耐磨耗性</strong></li> <li>滑らかで安全なラウンド加工</li> <li>高級感のある艶消し仕上げ</li> </ul> <br> <div id="separate_dot_bar"></div> <br> <table width="100%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <td bgcolor="#FFFFFF"><div align="center"><strong>メーカー</strong></div></td> <td bgcolor="#FFFFFF">マーキンス（Markins）</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center"><strong>型番</strong></div></td> <td bgcolor="#FFFFFF">LSA9</td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center"><strong>重量</strong></div></td> <td bgcolor="#FFFFFF">21 g</td> </tr> <tr> <td bgcolor="#FFFFFF" ><div align="center"><strong>材質</strong></div></td> <td bgcolor="#FFFFFF">アルミ合金　A6061-T6</td> </tr> <tr> <td nowrap bgcolor="#FFFFFF"><div align="center"><STRONG>組み合わせ方法</STRONG></div></td> <td bgcolor="#FFFFFF">付属のレンチにて装着</td> </tr> <tr> <td width="20%" nowrap bgcolor="#FFFFFF"><div align="center"><strong>主な適応カメラ</strong></div></td> <td bgcolor="#FFFFFF">ソニー α9, α7RIII</td> </tr> </table> <p align="center"><img src="/html/items/plsa9/lsa9-10.jpg" /></p> <div id="separate_dot_bar"></div> <p align="center"><img src="/html/items/plsa9/lsa9-11.jpg" /></p> <div id="separate_dot_bar"></div> <p align="center"><img src="/html/items/plsa9/lsa9-12.jpg" /></p> <div id="separate_dot_bar"></div> <p align="center"><img src="/html/items/plsa9/lsa9-20.jpg" /></p> <div id="separate_dot_bar"></div> <p align="center"><img src="/html/items/plsa9/lsa9-21.jpg" /></p> <div id="separate_dot_bar"></div> <p align="center"><img src="/html/items/plsa9/lsa9-22.jpg" /></p> <div style="height:60px;"></div>