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, 396, 526, 287, 325) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00040

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 (316,396,526,287,325)",
      "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
287 <br> <div style="font-size:14px;font-weight:bold;">Markins P53U is an anti-twist flange style camera plate for Canon 5D markIII without battery grip.</div> <p></p> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Compatible with any Arca-Swiss type</li> <li>Anti-Twist Flange</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 bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">P53U</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">1.59 oz (45 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.4 x 2.0 x 0.5 in (62 x 50 x 12 mm)</td> </tr> <tr> <th nowrap bgcolor="#FFFFFF">Bidirectional</th> <td bgcolor="#FFFFFF">Yes</td> </tr> <tr> <th 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">Monopod Hole</th> <td bgcolor="#FFFFFF">1/4&quot;-20 UNC</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Canon EOS 5D Mark Ⅲ / 5Ds / 5DsR / 5D Mark IV</td> </tr> </table> <br> <br> <!-- <div id="separate_dot_bar"></div> <div style="width:96%;text-align: left;">サイトリンク：　<a href="http://ganref.jp/accessories/2487">GANREF</a></div> --> <br> <br> <br> Canon, 5D, 5Ds, 5Ds R, markIII, mark3, mkIII, mk3, Camera, Tripod, Head, Quick, Shoe, Clamp, Plate, Arca-Swiss, rrs, kirk, foba Markins P53U is an anti-twist flange style camera plate for Canon 5D markIII without battery grip.
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）
325 <br> <div style="font-size:14px;font-weight:bold;">Markins PL-55 is a 2.4in (60mm) long anti-twist flange style lens plate. </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="90%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th width="20%" bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">PL55</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">1.48 oz (42 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">1.5x2.4x0.3 in (38×60×8 mm)</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Mounting Bolt</th> <td bgcolor="#FFFFFF">1/4&quot;-20 UNC Bolt <a href="/accessory/hb1/">HB1</a> <br /> * Requires 4mm (5/32&quot;) hex <a href="/accessory/tllw1/">L-wrench</a></td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Monopod Hole</th> <td bgcolor="#FFFFFF">1/4&quot;-20 UNC</td> </tr> </table> <br> <div id="separate_dot_bar"></div> <br> <img src="./html/items/pl55_detail.jpg" > <br> <br> Camera, Lens, Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba Markins PL-55 is a 2.4in (60mm) long anti-twist flange style lens plate.
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 /> &quot;Lowest profile in its class, 24mm&quot;<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.
526 <p style="font-size: 16px;font-weight: bold;padding-bottom:20px;">Fine Art Quality, Professional &quot;Ball Head&quot; </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>65lb (30kg) of load capacity, the best in its class</li> <li>Improved anti-vibration and new replaceable quickshoe connection</li> <li>The new Quick-Turn knob opens or closes by one turn (Patented)</li> </ul> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Quick Turn Knob</div> It only takes a single turn to open or close the quickshoe jaw. You will appreciate this fast open and close performance when you need to change the setup quickly, especially in cold weather or under urgent situation. <br> <br> <p><img src="./html/images/qs-i-type-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>Q3i-RD</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>65lb (30 kg)</td> </tr> <tr><td><div align="center">Weight</div></td> <td> 0.83lb (380g)</td> </tr> <tr><td><div align="center">Ball Diameter</div></td> <td>1.50in (38mm)</td> </tr> <tr><td><div align="center">Base Diameter</div></td> <td>2.20in (56mm)</td> </tr> <tr><td><div align="center">Height</div></td> <td>3.50in (89mm)</td> </tr> <tr><td><div align="center">Tripod Mount Hole</div></td> <td>UNC 3/8&quot;-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">130 lbf・in (150 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">Screw Knob Style Quickshoe (<a href="/quickshoe/qr48i/">QR-48i</a>)</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 Q3i-BL Knob Shoe