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 (306, 526, 499, 258, 270) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00054

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 (306,526,499,258,270)",
      "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
258		<p style="font-size: 16px;font-weight: bold;padding-bottom:20px;">Fine Art Quality, Professional "Ball Head" </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 Quick Lever opens or closes by single action (Patented)</li> </ul> <div style="font-size:16px; border-bottom:dotted 1px #666666;margin:60px 0 20px 0;padding-bottom:8px;">Quick Release Lever</div> The lever arm is convertible to eigher left or right hand position for one's own convenience.<br> <br> <p><img src="./html/images/qs-i-type-q-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>Q3iQ-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 (379g)</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"-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/ql48i/">QL-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 Q3iQ-RD Lever Shoe
270	A		Tripod, Head, Quick, Shoe, Clamp, Arca-Swiss, rrs, kirk, foba	Markis QL-48 is Dovetail type lever release clamp with a spring loaded detent pin to prevent from accidental slippage. Compatible with any Arca-Swiss type camera plates from Arca, Foba, Kirk and R.R.S.
306		<br> <div style="font-size:14px;font-weight:bold;">Markins PS-A72 is an anti-twist style camera plate for Sony A7II camera. It can be converted to an L-Plate(L-bracket) with optional sub plate LS-A72. </div> <p>(sub plate is <a href="./l-plate/lsa72"><strong>LS-A72</strong></a> ) </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">PSA72</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">3.2 X 1.4 X 0.4 in (82 X 36 X 10 mm)</td> </tr> <tr> <th nowrap bgcolor="#FFFFFF">Bidirectional</th> <td bgcolor="#FFFFFF">No</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"-20 UNC</td> </tr> <tr> <th width="20%" 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/2487">GANREF</a></div> --> <br> <br> <br>	sony, a7II, a7RII, ILCE-7M2, Camera, Tripod, Head, Quick, Shoe, Clamp, Plate, Arca-Swiss, rrs, kirk, foba	For Sony a7II a7RII. Markins PS-A72 is an anti-twist style camera plate for Sony A7II camera. It can be converted to an L-Plate(L-bracket) with optional sub plate LS-A72.
499		<br> <div style="font-size:14px;font-weight:bold;">Optional LP-K1 for PP-K1 to convert it to L-Plate（L-Bracket）</div> <p>*Requires <a href="/plate/camera/ppk1/">PP-K1</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="100%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;margin-top:40px;"> <tr> <th width="20%" bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">LPK1</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">0.85 oz (24 g)</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF"><p>0.5 X 1.5 X 2.8 in (13 X 38 X 72 mm)</p> </td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <!-- <tr> <td bgcolor="#FFFFFF"><div align="center"><strong>サイズ</strong></div></td> <td bgcolor="#FFFFFF"></td> </tr> --> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Pentax K-1, K-1 Mark II</td> </tr> </table> <div style="height:30px;"></div> <center> <img src="/html/items/lpk1/en_lpk1-03.jpg"> </center> <div id="separate_dot_bar"></div> <center> <img src="/html/items/lpk1/lpk1-05.jpg"> </center> <div id="separate_dot_bar"></div> <p> </p> <br> <br> <br>
526		<p style="font-size: 16px;font-weight: bold;padding-bottom:20px;">Fine Art Quality, Professional "Ball Head" </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"-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