Sandbox

SELECT 
  cscart_aprilproduct_descriptions.product_id, 
  cscart_aprilproduct_descriptions.short_description, 
  IF(
    cscart_aprilproduct_descriptions.short_description = '' 
    OR cscart_aprilproduct_descriptions.short_description IS NULL, 
    cscart_aprilproduct_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_aprilproduct_descriptions.unit_name 
FROM 
  cscart_aprilproduct_descriptions 
WHERE 
  cscart_aprilproduct_descriptions.product_id IN (45, 8, 10, 50, 44, 150) 
  AND cscart_aprilproduct_descriptions.lang_code = 'ar'

Query time 0.00070

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "14.41"
    },
    "table": {
      "table_name": "cscart_aprilproduct_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 6,
      "rows_produced_per_join": 6,
      "filtered": "100.00",
      "index_condition": "((`vishalecarter_april_setup`.`cscart_aprilproduct_descriptions`.`product_id` in (45,8,10,50,44,150)) and (`vishalecarter_april_setup`.`cscart_aprilproduct_descriptions`.`lang_code` = 'ar'))",
      "cost_info": {
        "read_cost": "13.21",
        "eval_cost": "1.20",
        "prefix_cost": "14.41",
        "data_read_per_join": "27K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "unit_name"
      ]
    }
  }
}

Result

product_id	short_description	full_description	unit_name
8		<p> Although its attractive features, design, and passive 3D have merit, the picture quality issues of the Toshiba TL515U LED-based LCD TV lessen its appeal in the face of the stiff competition. </p>
10		<p>Although its attractive features, design, and passive 3D have merit, the picture quality issues of the Toshiba TL515U LED-based LCD TV lessen its appeal in the face of the stiff competition.</p>
44		<p> <p style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 17px;"><span style="color: #996633; font-family: Georgia, 'Times New Roman', Times, serif; font-size: x-small;"><strong>Purpose:</strong></span></p> <p style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 17px;"><span style="color: #996633; font-family: Georgia, 'Times New Roman', Times, serif; font-size: x-small;">To provide students taking the 11th-grade New York State course in U.S. history and government and the Regents examination, as well as others taking a similar course, with a concise and comprehensive text. <br /></span></p> <ul style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 17px;" type="square"> <span style="color: #996633; font-family: Georgia, 'Times New Roman', Times, serif; font-size: x-small;"><strong>Text features include:</strong> <li>introduction to U.S. geography with an emphasis on how geography has shaped the American experience</li> <li>summary of the founding, principles, and operations of the U.S. government . lucid historical narrative</li> <li>emphasis on the modern period</li> <li>primary source readings in every chapter</li> <li>emphasis on the experiences and contributions of women and minorities</li> <li>mid-chapter “in Review” features</li> <li>end-of-chapter exercises: multiple-choice, thematic-essay, and document-based questions</li> <li>more maps, charts, and tables</li> <li>expanded coverage of U.S. Supreme Court landmark cases</li> <li>“The American People: Changes at the Millennium” - a demographic feature in the last chapter</li> <li>appendix: annotated Declaration of Independence and U.S. Constitution.</li> <li>Teacher’s Manual With Answers has guidelines for class presentation of each chapter, answer key, Student’s Study Guide.</li> <li>Hardbound</li> </span> </ul> </p>
45		<p><strong style="color: #000000; font-family: Arial, Verdana, 'Sans Serif'; line-height: 15px; text-align: justify;">A student friendly, thoughtfully organized introduction to research in psychology </strong><br style="color: #000000; font-family: Arial, Verdana, 'Sans Serif'; line-height: 15px; text-align: justify;" /><br style="color: #000000; font-family: Arial, Verdana, 'Sans Serif'; line-height: 15px; text-align: justify;" /><span style="color: #000000; font-family: Arial, Verdana, 'Sans Serif'; line-height: 15px; text-align: justify;">Employing numerous examples and the pedagogical approach of spaced repetition, this introductory text provides a step-by-step explanation of how to design, conduct, and present a research study in psychology. Chronologically organized and chock-full of pedagogy, this book creates logical scaffolding upon which students can build their knowledge.</span><br style="color: #000000; font-family: Arial, Verdana, 'Sans Serif'; line-height: 15px; text-align: justify;" /></p>
50		<p>Absolute fidelity to musical sources takes form from speakers that reproduce the ambience in which sounds originate. Stage size, musicians’ movement, aural reflection and other distinctive details all bring these sounds to life. Pioneer D-Series speakers are available in 2-way component packages or 2-way coaxial designs in multiple sizes that fit most vehicles.</p>
150		<div id="overview-bullets"> <ul class="bullet-points"> <li>Hi-Ten Remington Steel Wildwood Citi Comfort Frame</li> <li>45mm Travel Comfort Suspension Fork</li> <li>Compact Crankset w/ Integrated Chainguard</li> <li>SSW26 Double Tunnel Alloy Rims<span> </span></li> <li>Avenir Comfort Saddle w/ Supersoft Foam, Coil Springs</li> </ul> </div>