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 (329, 330, 702, 704, 585, 535, 333) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00028

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": 7,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.product_id in (329,330,702,704,585,535,333) and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	meta_keywords	meta_description
329	<div style="font-size:14px;font-weight:bold;"></div> <p>Markins 'Ring Plate' is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.</p> <p>It replaces the original lens foot and provides a double support and a lowered mass center of the lens, which gives an enhanced stability of your system. </p> <p>The 'Ring Plate' will provide the photographers with a widened capability of creating photos using a long teleport lens which has never been possible before.</p> <div id="separate_dot_bar"></div> <br> <ul style="margin-left:0px;line-height:18px;"> <li>Custom fit plates for Super teleport lenses</li> <li>Modular design: Ring + Replacement lens foot</li> <li>Much enhanced vibration reduction performance</li> <li>Safer and comfortable hand holding </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 bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">RC40SET</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">9.74 oz (276 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">6.2 x 5.9 x 8.7 in (158 x 150 x 220 mm)</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Canon EF 400mm F2.8L IS II USM </td> </tr> </table> <br> <br> <div id="separate_dot_bar"></div> <br> <br> <center> <img src="./html/items/rc40set_body01.jpg" alt="Ring Plate Outline" /> </center> <br> <br> <br>	Canon, EF, 400mm, F2.8L, IS, II, USM, Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba	Markins Ring Plate is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.
330	<div style="font-size:14px;font-weight:bold;"></div> <p>Markins 'Ring Plate' is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.</p> <p>It replaces the original lens foot and provides a double support and a lowered mass center of the lens, which gives an enhanced stability of your system. </p> <p>The 'Ring Plate' will provide the photographers with a widened capability of creating photos using a long teleport lens which has never been possible before.</p> <div id="separate_dot_bar"></div> <br> <ul style="margin-left:0px;line-height:18px;"> <li>Custom fit plates for Super teleport lenses</li> <li>Modular design: Ring + Replacement lens foot</li> <li>Much enhanced vibration reduction performance</li> <li>Safer and comfortable hand holding </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 bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">RC60SET</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">10.16 oz (288 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">6.2 x 5.9 x 9.4 in (158 x 150 x 240 mm)</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Canon EF 600mm F4L IS II USM</td> </tr> </table> <br> <br> <div id="separate_dot_bar"></div> <br> <br> <center> <img src="./html/items/rc60set_body02.jpg" alt="Ring Plate Outline" /> </center> <br> <br> <br>	Canon, EF, 600mm, F4L, IS, II, USM, Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba	Markins Ring Plate is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.
333	<div style="font-size:14px;font-weight:bold;"></div> <p>Markins 'Ring Plate' is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.</p> <p>It replaces the original lens foot and provides a double support and a lowered mass center of the lens, which gives an enhanced stability of your system. </p> <p>The 'Ring Plate' will provide the photographers with a widened capability of creating photos using a long teleport lens which has never been possible before.</p> <div id="separate_dot_bar"></div> <br> <ul style="margin-left:0px;line-height:18px;"> <li>Custom fit plates for Super teleport lenses</li> <li>Modular design: Ring + Replacement lens foot</li> <li>Much enhanced vibration reduction performance</li> <li>Safer and comfortable hand holding </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 bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">RN80SET</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">8.92 oz (253 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">6.0 x 4.9 x 6.0 in (152 x 125 x 153 mm)</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">AF-S NIKKOR 800mm F5.6E FL ED VR </td> </tr> </table> <br> <br> <div id="separate_dot_bar"></div> <br> <br> <center> <img src="./html/images/ringplate_outline_en.jpg" alt="Ring Plate Outline" /> </center> <br> <br> <br>	Nikon, AF-S, NIKKOR, 800mm, F5.6E, FL ED, VR, Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba	Markins Ring Plate is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.
535	<div style="font-size:14px;font-weight:bold;"></div> <p>Markins 'Ring Plate' is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.</p> <p>It replaces the original lens foot and provides a double support and a lowered mass center of the lens, which gives an enhanced stability of your system. </p> <p>The 'Ring Plate' will provide the photographers with a widened capability of creating photos using a long teleport lens which has never been possible before.</p> <div id="separate_dot_bar"></div> <br> <ul style="margin-left:0px;line-height:18px;"> <li>Custom fit plates for Super teleport lenses</li> <li>Modular design: Ring + Replacement lens foot</li> <li>Much enhanced vibration reduction performance</li> <li>Safer and comfortable hand holding </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 bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">RN62SET</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">9.10 oz (258 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">7.4 x 5.1 x 6.0 in (189x130x152 mm)</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Nikon AF-S NIKKOR 600mm F4E FL ED VR</td> </tr> </table> <br> <br> <div id="separate_dot_bar"></div> <br> <br> <center> <img src="./html/images/ringplate_outline_en.jpg" alt="Ring Plate Outline" /> </center> <br> <br> <div id="separate_dot_bar"></div> <br> <center> <img src="./html/items/rn62set/rn62set-10.jpg" alt="Nikon AF-S NIKKOR 600mm F4E FL ED VR" /> </center> <br> <br> <center> <img src="./html/items/rn62set/rn62set-11.jpg" alt="Nikon Ring Plate Foot" /> </center> <br> <br> <center> <img src="./html/items/rn62set/rn62set-12.jpg" alt="Nikon AF-S NIKKOR 600mm F4E FL ED VR" /> </center> <br> <br> <br>	Nikon, NIKKOR, 600, FL, Tripod, Head, Quick, Shoe, Clamp, Plate, Foot, Arca-Swiss, rrs, kirk, foba	Markins Ring Plate is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.
585	<div style="font-size:14px;font-weight:bold;"></div> <p>Markins 'Ring Plate' is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.</p> <p>It replaces the original lens foot and provides a double support and a lowered mass center of the lens, which gives an enhanced stability of your system. </p> <p>The 'Ring Plate' will provide the photographers with a widened capability of creating photos using a long teleport lens which has never been possible before.</p> <div id="separate_dot_bar"></div> <br> <ul style="margin-left:0px;line-height:18px;"> <li>Custom fit plates for Super teleport lenses</li> <li>Modular design: Ring + Replacement lens foot</li> <li>Much enhanced vibration reduction performance</li> <li>Safer and comfortable hand holding </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 bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">RN42SET</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">8.89 oz (252 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">7.3 x 5.1 x 6.0 in (185x130x152 mm)</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Nikon AF-S NIKKOR 400mm f2.8E FL ED VR</td> </tr> </table> <br> <br> <br> <center> <img src="/html/items/rn42set/rn42set-10.jpg" alt="Markins Arca-Swiss Nikon 400mm Ring Plate" /> </center> <br> <br> <center> <img src="/html/items/rn42set/rn42set-11.jpg" alt="Nikon NIKKOR 400mm f/2.8E FL ED VR Ring Plate" /> </center> <br> <br> <br>
702	<div style="font-size:14px;font-weight:bold;"></div> <p>Markins 'Ring Plate' is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.</p> <p>It replaces the original lens foot and provides a double support and a lowered mass center of the lens, which gives an enhanced stability of your system. </p> <p>The 'Ring Plate' will provide the photographers with a widened capability of creating photos using a long teleport lens which has never been possible before.</p> <div id="separate_dot_bar"></div> <br> <ul style="margin-left:0px;line-height:18px;"> <li>Custom fit plates for Super teleport lenses</li> <li>Modular design: Ring + Replacement lens foot</li> <li>Much enhanced vibration reduction performance</li> <li>Safer and comfortable hand holding </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 bgcolor="#FFFFFF">Code</th> <td bgcolor="#FFFFFF">RC62SET</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">10.23 oz (290 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">6.2 x 5.9 x 10.2 in (158 x 150 x 260 mm)</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Canon EF 600mm F4L IS III USM</td> </tr> </table> <div style="height:60px;"></div> <center> <img src="/html/items/ringplate/rc40-62set_body10.gif" alt="Canon EF 600mm F4L IS III USM" /> </center> <br> <div id="separate_dot_bar"></div> <br> <br> <center> <img src="/html/items/ringplate/rc62set-10.jpg" alt="" /> </center> <br> <br> <br>
704	<div style="font-size:14px;font-weight:bold;"></div> <p>Markins 'Ring Plate' is product to minimize the effect of vibration while shooting and to provide better results with a long teleport lens.</p> <p>It replaces the original lens foot and provides a double support and a lowered mass center of the lens, which gives an enhanced stability of your system. </p> <p>The 'Ring Plate' will provide the photographers with a widened capability of creating photos using a long teleport lens which has never been possible before.</p> <div id="separate_dot_bar"></div> <br> <ul style="margin-left:0px;line-height:18px;"> <li>Custom fit plates for Super teleport lenses</li> <li>Modular design: Ring + Replacement lens foot</li> <li>Much enhanced vibration reduction performance</li> <li>Safer and comfortable hand holding </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">RN40SET</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">9.14 oz (259 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">4.9 x 5.9 x 5.7 in (125 x 150 x 145 mm)</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Nikon AF-S NIKKOR 180-400mm f/4E TC1.4 FL ED VR</td> </tr> </table> <div style="height:60px;"></div> <center> <img src="/html/items/ringplate/rn40set-10.jpg" alt="" /> </center> <br> <br> <br>