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 (
    334, 338, 583, 340, 335, 336, 419, 337
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00010

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": 8,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.product_id in (334,338,583,340,335,336,419,337)",
      "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
334 <br> <p>Markins Titanium Spikes are compatible with all tripods with 3/8"-16 female screw hole at the end of legs. All the latest Gitzo tripods that are Series 2 or bigger are compatible.</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 bgcolor="#FFFFFF">SKU</th> <td bgcolor="#FFFFFF">RS23SET</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">1.3 x 0.9 in (32 x 22 mm) Length x Diameter</td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">Titanium </td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Gitzo GT2530, GT2530EX, GT2530LVL, GT2531, GT2542T, GT2931, GT2931EX, GT3330, GT3530, GT3530LSV, GT3530S, GT3533LS, GT3540, GT3540L, GT3540LS, GT3540XLS, GT5540LS</td> </tr> </table> <p><br></p> <p><br></p> Gitzo, GT2530, GT2530EX, GT2530LVL, GT2531, GT2542T, GT2931, GT2931EX, GT3330, GT3530, GT3530LSV, GT3530S, GT3540, GT3540L, GT3540LS, GT3540XLS, GT5540LS Markins Titanium Spikes are compatible with all tripods with 3/8"-16 female screw hole at the end of legs. All the latest Gitzo tripods that are Series 2 or bigger are compatible.
335 <p>Custom-designed for selected Gitzo tripods, Markins tripod hub is a tuning kit to improve the performance of Gitzo tripods. <br /> It improves stability and transportability.</p> <!-- 2017/09/05 削除 <div style="color:#FF0000;">* It does not fit in the Mountaineer after 2014</div> --> <div style="clear:both;"></div> <br> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Custom-designed for for selected Gitzo tripods</li> <li>Precision machined from a single block of airplane grade material (A6061-T6) </li> <li>Enhances stability and reduces vibration</li> <li>Great for macro photography by lowering tripod to the ground level without raising the center column</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">SKU</th> <td bgcolor="#FFFFFF">TB20</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">2.5W x 1.2H in (63W x 30H mm)</td> </tr> <tr> <th bgcolor="#FFFFFF">Color</th> <td bgcolor="#FFFFFF">Black</td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Gitzo G1220, G1224, G1226, G1227, G1228, G1257, G1258, G1297, G1298, GT2530, GT2540</td> </tr> </table> <br> <div id="separate_dot_bar"></div> <br> <center><img src="./html/items/tb_feature.jpg"></center> <br> <br> Gitzo, G1220, G1224, G1226, G1227, G1228, G1257, G1258, G1297, G1298, GT2530, GT2540 Custom-designed for selected Gitzo tripods, Markins tripod base TB-20 is a tuning kit to improve the performance of Gitzo tripods. It improves stability and transportability.
337 <p>Custom-designed for selected Gitzo tripods, Markins tripod hub is a tuning kit to improve the performance of Gitzo tripods. <br /> It improves stability and transportability.</p> <!-- 2017/09/05 削除 <div style="color:#FF0000;">* It does not fit in the Mountaineer after 2014</div> --> <div style="clear:both;"></div> <br> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Custom-designed for for selected Gitzo tripods</li> <li>Precision machined from a single block of airplane grade material (A6061-T6) </li> <li>Enhances stability and reduces vibration</li> <li>Great for macro photography by lowering tripod to the ground level without raising the center column</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">SKU</th> <td bgcolor="#FFFFFF">TB30</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">2.6W x 1.2H in (67W x 31H mm)</td> </tr> <tr> <th bgcolor="#FFFFFF">Color</th> <td bgcolor="#FFFFFF">Black</td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Gitzo G1320, G1326, G1327, GT3330, GT3530, GT3540, GT3540L, GT3531, GT3541, GT3541L<br /> <span style="color:#FF0000;">*TB-30 doesn't fit with GT3531, GT3541 & GT3541L purchased after Apr. 2012</span></td> </tr> </table> <br> <div id="separate_dot_bar"></div> <br> <center><img src="./html/items/tb_feature.jpg"></center> <br> <br> Gitzo, G1320, G1326, G1327, GT3330, GT3530, GT3540, GT3540L, GT3531, GT3541, GT3541L Custom-designed for selected Gitzo tripods, Markins tripod base TB-30 is a tuning kit to improve the performance of Gitzo tripods. It improves stability and transportability.
338 <p>Custom-designed for selected Gitzo tripods, Markins tripod hub is a tuning kit to improve the performance of Gitzo tripods. <br /> It improves stability and transportability.</p> <!-- 2017/09/05 削除 <div style="color:#FF0000;">* It does not fit in the Mountaineer after 2014</div> --> <br> <div id="separate_dot_bar"></div> <br> <ul style="line-height:18px;"> <li>Custom-designed for for selected Gitzo tripods</li> <li>Designed to replace the factory installed hub </li> <li>Precision machined from a single block of airplane grade material (A6061-T6) </li> <li>Enhances stability and reduces vibration</li> <li>Reduces the weight and size for better portability<br /> (Example: The weight reduction for the GT2530 Carbon 6X tripod is 0.54 lbs. Exact amount can vary from model to model.)</li> <li>Great for macro photography by lowering tripod to the ground level without raising the center column</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">SKU</th> <td bgcolor="#FFFFFF">TH200</td> </tr> <tr> <th bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">6.14 oz (174 g)</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">Ф3.8 x 2.0 in (Ф96 x 50 mm)</td> </tr> <tr> <th bgcolor="#FFFFFF">Color</th> <td bgcolor="#FFFFFF">Natural Green </td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Gitzo GT2530, GT2531, GT2540, GT2541, GT2541L, GT2542L, GT2931, GT2932, GT2940C, GT2940L, GT2941, GT2941L, GT2942, G1228</td> </tr> </table> <br><br><br> <div align="center"> <img src="./html/items/th200_01.jpg"><br /> <br> <br> <img src="./html/items/th300b04.jpg"> <br><br><br> <div style="height:1px; border-bottom: 1px #aaaaaa dotted; margin: 20px 0px 20px 0px;"></div> <br><br> <img src="./html/images/hook-05.jpg"><br> <br> * You can also hang the luggage if fitted with the <a href="./gitzo/thhook/">TH-HOOK for Tripod Hub</a> sold separately.<br> <br><br> </div> <br> <br> Gitzo, GT2530, GT2531, GT2540, GT2541, GT2541L, GT2542, GT2542L, GT2931, GT2932, GT2940C, GT2940L, GT2941, GT2941L, GT2942, G1228 Custom-designed for for selected Gitzo tripods, Markins tripod hub TH-200 is a tuning kit to improve the performance of Gitzo tripods. It improves stability and transportability.
340 <br> <p>Markins TH-HOOK for TH-HUB Series.</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 bgcolor="#FFFFFF">SKU</th> <td bgcolor="#FFFFFF">TH-HOOK</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Weight</th> <td bgcolor="#FFFFFF">0.42 oz (12 g)</td> </tr> <tr> <th bgcolor="#FFFFFF">Screw</th> <td bgcolor="#FFFFFF">3/8&quot;-16</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF"><a href="./gitzo/th200/">TH-200</a>, TH-30, <a href="./gitzo/th300/">TH-300</a>, TH-500</td> </tr> </table> <p><br></p> <div style="height:1px; border-bottom: 1px #aaaaaa dotted; margin: 20px 0px 20px 0px;"></div> <p><br></p> <div align="center"><img src="http://www.markinsjapan.com/html/images/hook-05.jpg"><br> <br> Use is attached to the Tripod Hub like this</p> <p align="center"><br> <br> </div> Gitzo, Tripod, Kit, Bag, Hook Markins TH-HOOK for TH-HUB Series.
419 <p>Custom-designed for for selected Gitzo tripods, Markins tripod hub is a tuning kit to improve the performance of Gitzo tripods. <br /> It improves stability and transportability.</p> <br> <div id="separate_dot_bar"></div> <ul style="line-height:18px;"> <li>Custom-designed for for selected Gitzo tripods</li> <li>Precision machined from a single block of airplane grade material (A6061-T6) </li> <li>Enhances stability and reduces vibration</li> <li>Great for macro photography by lowering tripod to the ground level without raising the center column</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">SKU</th> <td bgcolor="#FFFFFF">TB22</td> </tr> <tr> <th nowrap="nowrap" bgcolor="#FFFFFF">Size</th> <td bgcolor="#FFFFFF">2.7 x 1.1 in (69W×28H mm)</td> </tr> <tr> <th bgcolor="#FFFFFF">Color</th> <td bgcolor="#FFFFFF">Black</td> </tr> <tr> <th bgcolor="#FFFFFF">Material</th> <td bgcolor="#FFFFFF">A6061-T6</td> </tr> <tr> <th width="20%" nowrap bgcolor="#FFFFFF">Fit</th> <td bgcolor="#FFFFFF">Gitzo GT2532, GT2542, GT2543L, GT3532, GT3542, GT3542L</td> </tr> </table> <br> <div id="separate_dot_bar"></div> <br> <center> </center> <br> <br>