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 (471, 472, 469, 470, 345, 346) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00344

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": 6,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.product_id in (471,472,469,470,345,346)",
      "attached_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description
345	<br> <div style="font-size:14px;">Markins YK-15S is short type york for VR-Holder 15 series.</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="100%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th width="20%" bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">YK15S</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">24L×75W×50H mm</td> </tr> <tr> <th bgcolor="#FFFFFF"><strong>Weight</strong></th> <td bgcolor="#FFFFFF">84 g</td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <tr> <th bgcolor="#FFFFFF"><strong>Fit</strong></th> <td bgcolor="#FFFFFF">VR-Holder 15 series </td> </tr> </table> <div style="height:40px;"></div> <p><center><img src="./html/items/york-15s_size.jpg"></center></p> <div style="height:40px;"></div>	Tripod, Head, Quick, Shoe, Clamp, Arca-Swiss, rrs, kirk, foba	Markins YK-15S is short type york for VR-Holder 15 series.
346	<br> <div style="font-size:14px;">Markins YK-15L is long type york for VR-Holder 15 series.</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="100%" cellpadding="5" cellspacing="1" bgcolor="#424242" style="font-size: 10pt; color:#424242;"> <tr> <th width="20%" bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">YK15L</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">24L×75W×75H mm</td> </tr> <tr> <th bgcolor="#FFFFFF"><strong>Weight</strong></th> <td bgcolor="#FFFFFF">92 g</td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <tr> <th bgcolor="#FFFFFF"><strong>Fit</strong></th> <td bgcolor="#FFFFFF">VR-Holder 15 series </td> </tr> </table> <div style="height:40px;"></div> <p><center><img src="./html/items/york-15l_size.jpg"></center></p> <br> <p></p>	Tripod, Head, Quick, Shoe, Clamp, Arca-Swiss, rrs, kirk, foba	Markins YK-15L is long type york for VR-Holder 15 series.
470	<br> <p>Markins VR-Holder is designed to reduce vibration dramatically by providing an extra support at the front end of a lens. The long dovetail rail allows balancing the whole weight effectively to lessen the load to support system.</p> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Universal design to work with most lenses</li> <li>Enhances stability and reduces vibration </li> <li>It won't work well with the most L-brackets in the market since they have left-right dovetal direction.</li> <li>It can move the mini quick shoe to forward, backward for balance with your instruments.</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 width="20%" bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">VR15J-LL</td> </tr> <tr> <td align="middle" nowrap="nowrap" bgcolor="#ffffff"><div align="center"><strong>Quick Shoe </strong></div></td> <td align="middle" bgcolor="#ffffff"><div align="left">Lever Release Style</div></td> </tr> <tr> <td align="middle" bgcolor="#ffffff"><div align="center"><strong>York</strong></div></td> <td align="middle" nowrap="nowrap" bgcolor="#ffffff"><div align="left">YK15L (Long Type) for battery grip <br /> </div></td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">242L×85W×88H mm</td> </tr> <tr> <th bgcolor="#FFFFFF"><strong>Weight</strong></th> <td bgcolor="#FFFFFF">331 g</td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> </table> <div style="height:40px;"></div> <div style="margin: 20px 0 20px 0;"><img src="./html/items/vr15j-ll_10.jpg" style="max-width:600px;" alt="Enhances stability and reduces vibration"></div> <div style="width:10px; margin: 0 4px 4px 0;float:left;"></div> <div style="width:95%; margin: 0 4px 4px 0;float:left;">You can change the angle by attachment and detachment of the VR-Quickshoe (It is required separately <a href="/accessory/texh4/">Hex Key T-Wrench</a>)</div> <div style="clear:both;"></div> <div style="margin: 30px 0 15px 0;"><img src="./html/items/vr15j-l_20.jpg" alt="Enhances stability and reduces vibration"></div> <div style="clear:both;"></div> <br> <div style="height:1px; border-bottom: 1px #aaaaaa dotted; margin: 20px 0px 20px 0px;"></div> <br> <p><span style="font-size:18px;font-weight:bold;">VR-Holder Example</span> <br /> <br> <strong> from <a href="/report/120530">Photographer Akio Torikoshi User Report</a></strong></p> <br> <div style="font-weight:bold; border-bottom:dotted 1px #666666;margin:20px 0 10px 0;padding-bottom:8px;">Example 1</div> <p>- DATA - <br /> Nikon D700 + Tamron SP180mm F2.5 LD<br /> ISO200, F16, 1/15sec, 180mm</p> <div style="margin-bottom:10px;"><img src="./html/images/20120530a1.jpg" /></div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530a2.jpg" /><br> Not Used </div> </div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530a3.jpg" /><br> VR-Holder Used</div> </div> <div style="clear:both;"></div> <div style="font-weight:bold; border-bottom:dotted 1px #666666;margin:20px 0 10px 0;padding-bottom:8px;">Example 2</div> <p>- DATA - <br /> Nikon D700 + SIGMA 50-500mm F4-6.3 EXDG HSM + ×２Telecon <br /> ISO200, F13, 1/15sec, 1000mm</p> <div style="margin-bottom:10px;"><img src="./html/images/20120530b1.jpg" /></div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530b2.jpg" /><br> Not Used </div> </div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530b3.jpg" /><br> VR-Holder Used</div> </div> <div style="clear:both;"></div> <div style="font-weight:bold; border-bottom:dotted 1px #666666;margin:20px 0 10px 0;padding-bottom:8px;">Example 3</div> <p>- DATA - <br /> Nikon D700 + SIGMA 50-500mm F4-6.3 EXDG HSM<br /> ISO1600, F6.3, 1sec, 500mm</p> <div style="margin-bottom:10px;"><img src="./html/images/20120530c1.jpg" /></div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530c2.jpg" /><br> Not Used </div> </div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530c3.jpg" /><br> VR-Holder Used</div> </div> <div style="clear:both;"></div> <p> </p>	Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba
471	<br> <p>Markins VR-Holder is designed to reduce vibration dramatically by providing an extra support at the front end of a lens. The long dovetail rail allows balancing the whole weight effectively to lessen the load to support system.</p> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Universal design to work with most lenses</li> <li>Enhances stability and reduces vibration </li> <li>It won't work well with the most L-brackets in the market since they have left-right dovetal direction.</li> <li>It can move the mini quick shoe to forward, backward for balance with your instruments.</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 width="20%" bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">VR15J-SS</td> </tr> <tr> <td align="middle" nowrap="nowrap" bgcolor="#ffffff"><div align="center"><strong>Quick Shoe </strong></div></td> <td align="middle" bgcolor="#ffffff"><div align="left">Screw Knob Style </div></td> </tr> <tr> <td align="middle" bgcolor="#ffffff"><div align="center"><strong>York</strong></div></td> <td align="middle" nowrap="nowrap" bgcolor="#ffffff"><div align="left">YK15S (Short Type) for without battery grip <br /> </div></td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">242L×75W×63H mm</td> </tr> <tr> <th bgcolor="#FFFFFF"><strong>Weight</strong></th> <td bgcolor="#FFFFFF">321 g</td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> </table> <div style="height:40px;"></div> <div style="margin: 20px 0 20px 0;"><img src="./html/items/vr15j-ss_10.jpg" style="max-width:600px;" alt="Enhances stability and reduces vibration"></div> <div style="width:10px; margin: 0 4px 4px 0;float:left;"></div> <div style="width:95%; margin: 0 4px 4px 0;float:left;">You can change the angle by attachment and detachment of the VR-Quickshoe (It is required separately <a href="/accessory/texh4/">Hex Key T-Wrench</a>)</div> <div style="clear:both;"></div> <div style="margin: 30px 0 15px 0;"><img src="./html/items/vr15j-l_20.jpg" alt="Enhances stability and reduces vibration"></div> <div style="clear:both;"></div> <br> <div style="height:1px; border-bottom: 1px #aaaaaa dotted; margin: 20px 0px 20px 0px;"></div> <br> <p><span style="font-size:18px;font-weight:bold;">VR-Holder Example</span> <br /> <br> <strong> from <a href="/report/120530">Photographer Akio Torikoshi User Report</a></strong></p> <br> <div style="font-weight:bold; border-bottom:dotted 1px #666666;margin:20px 0 10px 0;padding-bottom:8px;">Example 1</div> <p>- DATA - <br /> Nikon D700 + Tamron SP180mm F2.5 LD<br /> ISO200, F16, 1/15sec, 180mm</p> <div style="margin-bottom:10px;"><img src="./html/images/20120530a1.jpg" /></div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530a2.jpg" /><br> Not Used </div> </div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530a3.jpg" /><br> VR-Holder Used</div> </div> <div style="clear:both;"></div> <div style="font-weight:bold; border-bottom:dotted 1px #666666;margin:20px 0 10px 0;padding-bottom:8px;">Example 2</div> <p>- DATA - <br /> Nikon D700 + SIGMA 50-500mm F4-6.3 EXDG HSM + ×２Telecon <br /> ISO200, F13, 1/15sec, 1000mm</p> <div style="margin-bottom:10px;"><img src="./html/images/20120530b1.jpg" /></div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530b2.jpg" /><br> Not Used </div> </div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530b3.jpg" /><br> VR-Holder Used</div> </div> <div style="clear:both;"></div> <div style="font-weight:bold; border-bottom:dotted 1px #666666;margin:20px 0 10px 0;padding-bottom:8px;">Example 3</div> <p>- DATA - <br /> Nikon D700 + SIGMA 50-500mm F4-6.3 EXDG HSM<br /> ISO1600, F6.3, 1sec, 500mm</p> <div style="margin-bottom:10px;"><img src="./html/images/20120530c1.jpg" /></div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530c2.jpg" /><br> Not Used </div> </div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530c3.jpg" /><br> VR-Holder Used</div> </div> <div style="clear:both;"></div> <p> </p>	Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba
472	<br> <p>Markins VR-Holder is designed to reduce vibration dramatically by providing an extra support at the front end of a lens. The long dovetail rail allows balancing the whole weight effectively to lessen the load to support system.</p> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Universal design to work with most lenses</li> <li>Enhances stability and reduces vibration </li> <li>It won't work well with the most L-brackets in the market since they have left-right dovetal direction.</li> <li>It can move the mini quick shoe to forward, backward for balance with your instruments.</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 width="20%" bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">VR15J-SL</td> </tr> <tr> <td align="middle" nowrap="nowrap" bgcolor="#ffffff"><div align="center"><strong>Quick Shoe </strong></div></td> <td align="middle" bgcolor="#ffffff"><div align="left">Screw Knob Style </div></td> </tr> <tr> <td align="middle" bgcolor="#ffffff"><div align="center"><strong>York</strong></div></td> <td align="middle" nowrap="nowrap" bgcolor="#ffffff"><div align="left">YK15L (Long Type) for battery grip <br /> </div></td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">242L×75W×88H mm</td> </tr> <tr> <th bgcolor="#FFFFFF"><strong>Weight</strong></th> <td bgcolor="#FFFFFF">331 g</td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> </table> <div style="height:40px;"></div> <div style="margin: 20px 0 20px 0;"><img src="./html/items/vr15j-sl_10.jpg" style="max-width:600px;" alt="Enhances stability and reduces vibration"></div> <div style="width:10px; margin: 0 4px 4px 0;float:left;"></div> <div style="width:95%; margin: 0 4px 4px 0;float:left;">You can change the angle by attachment and detachment of the VR-Quickshoe (It is required separately <a href="/accessory/texh4/">Hex Key T-Wrench</a>)</div> <div style="clear:both;"></div> <div style="margin: 30px 0 15px 0;"><img src="./html/items/vr15j-l_20.jpg" alt="Enhances stability and reduces vibration"></div> <div style="clear:both;"></div> <br> <div style="height:1px; border-bottom: 1px #aaaaaa dotted; margin: 20px 0px 20px 0px;"></div> <br> <p><span style="font-size:18px;font-weight:bold;">VR-Holder Example</span> <br /> <br> <strong> from <a href="/report/120530">Photographer Akio Torikoshi User Report</a></strong></p> <br> <div style="font-weight:bold; border-bottom:dotted 1px #666666;margin:20px 0 10px 0;padding-bottom:8px;">Example 1</div> <p>- DATA - <br /> Nikon D700 + Tamron SP180mm F2.5 LD<br /> ISO200, F16, 1/15sec, 180mm</p> <div style="margin-bottom:10px;"><img src="./html/images/20120530a1.jpg" /></div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530a2.jpg" /><br> Not Used </div> </div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530a3.jpg" /><br> VR-Holder Used</div> </div> <div style="clear:both;"></div> <div style="font-weight:bold; border-bottom:dotted 1px #666666;margin:20px 0 10px 0;padding-bottom:8px;">Example 2</div> <p>- DATA - <br /> Nikon D700 + SIGMA 50-500mm F4-6.3 EXDG HSM + ×２Telecon <br /> ISO200, F13, 1/15sec, 1000mm</p> <div style="margin-bottom:10px;"><img src="./html/images/20120530b1.jpg" /></div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530b2.jpg" /><br> Not Used </div> </div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530b3.jpg" /><br> VR-Holder Used</div> </div> <div style="clear:both;"></div> <div style="font-weight:bold; border-bottom:dotted 1px #666666;margin:20px 0 10px 0;padding-bottom:8px;">Example 3</div> <p>- DATA - <br /> Nikon D700 + SIGMA 50-500mm F4-6.3 EXDG HSM<br /> ISO1600, F6.3, 1sec, 500mm</p> <div style="margin-bottom:10px;"><img src="./html/images/20120530c1.jpg" /></div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530c2.jpg" /><br> Not Used </div> </div> <div style="width:300;margin:0 10px 10px 0;float:left;"> <div align="center"><img src="./html/images/20120530c3.jpg" /><br> VR-Holder Used</div> </div> <div style="clear:both;"></div> <p> </p>	Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba