SELECT 
  product_id, 
  short_description, 
  full_description 
FROM 
  q_product_descriptions 
WHERE 
  product_id IN (
    3741, 3742, 3743, 3744, 3745, 3746, 3747, 
    3748, 3749, 3750, 3751, 3752, 3753, 
    3755, 3756, 3757, 3758, 3759, 3760, 
    3761, 3762, 3764, 3765, 3768, 3769, 
    3772, 1470
  ) 
  AND lang_code = 'en'

Query time 0.00065

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "64.81"
    },
    "table": {
      "table_name": "q_product_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": 27,
      "rows_produced_per_join": 27,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3755,3756,3757,3758,3759,3760,3761,3762,3764,3765,3768,3769,3772,1470)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "59.41",
        "eval_cost": "5.40",
        "prefix_cost": "64.81",
        "data_read_per_join": "102K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
1470 <p>Heavy dusty scrub sponge removes stain easily without a scratch / It is perfect for stainless steel appliances at home / It cleans in and around the sink effectively / It is highly absorbent and non-scratch / It dries quickly, rinses and wrings easily</p>
3741 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Equipped with a zippered closure that allows you to keep your things securely</li><li class="jsx-1889249662">Contains a strap that allows you to comfortably carry it around</li><li class="jsx-1889249662">Sturdy construction enhances prolonged usage</li></ul>
3742 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Equipped with a zippered closure that allows you to keep your things securely</li><li class="jsx-1889249662">Contains a strap that allows you to comfortably carry it around</li><li class="jsx-1889249662">Sturdy construction enhances prolonged usage</li></ul>
3743 <p>Excellent insulation and insulation effect using high-grade insulation material / You can extend cool and warm time much more if you put the ice pack into the bag / Stylish toddler style / Stain-resistant silver lining material</p>
3744 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Equipped with a zippered closure that allows you to keep your things securely</li><li class="jsx-1889249662">Contains a strap that allows you to comfortably carry it around</li><li class="jsx-1889249662">Sturdy construction enhances prolonged usage</li></ul>
3745 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Equipped with a zippered closure that allows you to keep your things securely</li><li class="jsx-1889249662">Contains a strap that allows you to comfortably carry it around</li><li class="jsx-1889249662">Sturdy construction enhances prolonged usage</li></ul>
3746 <ul><li>suitable for various outdoor activities</li><li>Lock and Lock. Mini lunch bag. Sprout pattern.</li></ul>
3747 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li></ul>
3748 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3749 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3750 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3751 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3752 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3753 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3755 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3756 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3757 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3758 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3759 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3760 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3761 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3762 <ul><li>Soft and good absorption</li><li>No residues left over</li><li>No damage on surface</li><li>Economical, save detergent</li><li>Easy remove dirt and dust</li></ul>
3764 <p>Ideal for all kitchen surfaces and bathroom steel, granite, tiles, kitchen and bathroom furniture, mirrors and crystals / Super absorbent and deep clean all kinds of dirt, oil and even grease without chemicals / Environmentally friendly / Leave no fingerprints</p>
3765 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">External Dimensions: 600 x 400 x 306mm</span></li><li><span class="a-list-item">Stacks when lids are closed, nests when box is empty and lids are open</span></li><li><span class="a-list-item">Brand new, heavy duty and stronger than most storage boxes you will find on the high street</span></li><li><span class="a-list-item">Easy to carry and lightweight at only 3.08 Kg per box</span></li><li><span class="a-list-item">Easy to clean and made from food safe PP plastic</span></li></ul>
3768 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Moulded from high-grade material to avoid chipping even through prolonged usage</li><li class="jsx-1889249662">Exudes an exquisite craftsmanship that manifests an accentuating show</li><li class="jsx-1889249662">Fade-proof construction resists catching stains, facilitating easy cleaning</li></ul>
3769 <h5><span style="font-size:10pt;">DESCRIPTION</span></h5><div class="value"><span style="font-size:10pt;">LOCK&LOCK Chopper is the ideal kitchen tool for food processing.</span><br /><p><br /></p> <h3><span style="font-size:10pt;">FEATURES & FUNCTIONS</span></h3> <ul><li><span style="font-size:10pt;">Powerful slicing with rotation work and triple stainless-steel blades</span></li> <li><span style="font-size:10pt;">Glass-like clear mixing bowl</span></li> <li><span style="font-size:10pt;">Detachable blades and easy cleaning</span></li> </ul><strong>Number Of Blades</strong><br /><br />S : 3 Blades<br />M : 3 Blades<span style="font-size:10pt;"></span></div><div class="value">L : 5 Blades</div><div class="value"> </div>
3772 <ul><li>Lock & Lock food waste bin is specially developed and designed for home kitchen waste disposal. </li><li>smooth internal walls prevent the formation of food and liquids and make the cleaning easier.</li></ul>