SELECT 
  q_product_descriptions.product_id, 
  q_product_descriptions.short_description, 
  IF(
    q_product_descriptions.short_description = '', 
    q_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  q_product_descriptions 
WHERE 
  q_product_descriptions.product_id IN (
    47678, 
    47679, 
    47680, 
    47681, 
    47682, 
    47683, 
    47684, 
    47685, 
    47686, 
    47688, 
    47690, 
    47691, 
    47692, 
    47693, 
    47694, 
    47695, 
    47696, 
    47697, 
    47698, 
    47699, 
    47700, 
    47701, 
    47702, 
    47703, 
    47705, 
    47706, 
    47707, 
    47708, 
    47709, 
    47710, 
    47711, 
    47712, 
    47714, 
    47719, 
    47720, 
    47721, 
    47722, 
    47725, 
    47730, 
    47731, 
    47732, 
    47733, 
    47734, 
    47735, 
    47736, 
    47737, 
    47738, 
    47739, 
    47740, 
    47741, 
    47742, 
    47743, 
    47744, 
    47745, 
    47746, 
    47747, 
    47748, 
    47749, 
    47750, 
    47751, 
    47752, 
    47753, 
    47754, 
    47755, 
    47756, 
    47757, 
    47758, 
    47760, 
    47761, 
    47762, 
    47763, 
    47764, 
    47765, 
    47766, 
    47767, 
    47768, 
    47769, 
    47770, 
    47771, 
    47772, 
    47773, 
    47774, 
    45784, 
    45785, 
    45786, 
    45787, 
    45788, 
    45789, 
    45790, 
    45791, 
    45792, 
    45793, 
    45794, 
    45795, 
    45796, 
    45797, 
    45798, 
    45799, 
    45800, 
    45801, 
    45802, 
    45803, 
    45804, 
    45805, 
    45806, 
    45807, 
    45808, 
    45809, 
    45810, 
    45811, 
    45812, 
    45813, 
    45814, 
    45815, 
    45816, 
    45817, 
    45818, 
    45819, 
    45820, 
    45821, 
    45822, 
    45823, 
    45824, 
    45825, 
    45826, 
    45827, 
    45828, 
    45829
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00181

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "307.21"
    },
    "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": 128,
      "rows_produced_per_join": 128,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (47678,47679,47680,47681,47682,47683,47684,47685,47686,47688,47690,47691,47692,47693,47694,47695,47696,47697,47698,47699,47700,47701,47702,47703,47705,47706,47707,47708,47709,47710,47711,47712,47714,47719,47720,47721,47722,47725,47730,47731,47732,47733,47734,47735,47736,47737,47738,47739,47740,47741,47742,47743,47744,47745,47746,47747,47748,47749,47750,47751,47752,47753,47754,47755,47756,47757,47758,47760,47761,47762,47763,47764,47765,47766,47767,47768,47769,47770,47771,47772,47773,47774,45784,45785,45786,45787,45788,45789,45790,45791,45792,45793,45794,45795,45796,45797,45798,45799,45800,45801,45802,45803,45804,45805,45806,45807,45808,45809,45810,45811,45812,45813,45814,45815,45816,45817,45818,45819,45820,45821,45822,45823,45824,45825,45826,45827,45828,45829)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "281.61",
        "eval_cost": "25.60",
        "prefix_cost": "307.21",
        "data_read_per_join": "488K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
45784 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand: Bestway</span></li> <li><span class="a-list-item">Model Number: 58216</span></li> <li><span class="a-list-item">Type: Camping Portable Shower</span></li> <li><span class="a-list-item">Color: Black</span></li> <li><span class="a-list-item">Size: 20 Liter</span></li> <li><span class="a-list-item">Construction Type: Gravity Fed System</span></li> <li><span class="a-list-item">Heat Source: Solar</span></li> </ul><div class="a-row a-expander-container a-expander-inline-container" style="width:600.484px;color:rgb(17,17,17);font-family:'Amazon Ember', Arial, sans-serif;font-size:13px;background-color:rgb(255,255,255);"> <div class="a-expander-content a-expander-extend-content a-expander-content-expanded"> <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Material: PVC</span></li> <li><span class="a-list-item">Temperature Indicator: Yes</span></li> <li><span class="a-list-item">Hanging Type: Hanging cord</span></li> </ul></div> </div>
45785 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">El set incluye un colchón hinchable para camping y un saco de dormir</span></li><li><span class="a-list-item">Cuenta con una estructura resistente con superficie flocada para una mayor comodidad</span></li><li><span class="a-list-item">Está fabricado con 190T poliéster y con un relleno de fibra de 200 g/m²</span></li><li><span class="a-list-item">Incluye bolsa de transporte para poder plegarlo y guardarlo en ella y llevarlo donde necesites</span></li><li><span class="a-list-item">Válvula de rápido inflado y desinflado para tenerlo listo cuando lo necesites</span></li></ul>
45786
45787 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Innovative nozzles facilitate effortless inflation and deflation</li><li class="jsx-1889249662">Attuned in a manner that exudes comfort and relaxation</li><li class="jsx-1889249662">Profound lining efficiently withstands shredding or tearing</li></ul>
45788
45789 <ul><li>4.8m x 2.1m x 165cm (15.7' x 83" x 65") Fits 4 adults, 2 layer Streamlined structure provides stability in windy conditions High density, anti-insect mesh door and windows Fabric: 190T polyester PU2000mm coated Ground protection: 120G/M2 PE Product unit weight: 7.0 kg (15.4 Lb) Waterproof seams and fire retardant fabric, ideal for camping Inside pocket to store personal effects Detachable roof is suitable for both hot and rainy seasons Convenient side doors Carry bag with header card Content: one tent, one carry bag</li></ul>
45790
45791
45792
45793
45794 <p>(1.35m + 1.35m + 2.2m) x 2.8m x 2.0m ( (53" + 53" + 87") x 110" x 79" ) Fits 4 adults, 2 layer High density, anti-insect mesh door and windows Fabric: 190T polyester PU3000mm coated Ground protection: 120G/M2 PE Product unit weight: 11.6kg (25.6Lb) Long tunnel structure provides superior space for family camping Back door can be connected to car Inside pocket to store personal effects Carry bag with header card Content: one tent, one carry bag</p>
45795
45796
45797
45798
45799
45800 <p><br /></p><ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Bestway</span></li><li><span class="a-list-item">Inflatables</span></li><li><span class="a-list-item">Bestway - Quari 45L Backpack, 68025<br /></span></li></ul>
45801
45802
45803
45804
45805
45806
45807 <p>Pavillo Montana is a tent for 4 people with a terrace and spends all the time to make the room pleasant. <br /> The curtains of this line are ideal for mountain lovers. <br /> The tent has internal pockets and mosquiteros, made of polyester and resistant to water to keep the body dry in rain, water-proof, characterized by a single inlet, a section of ventilation with PE low and assembled PE, made of water-repellent 170T polyester. <br /> Includes a carrying bag. <br /> * tent: Mountain model Bestway <br /> * Easy to install and comfortable to wear <br /> * 190T of a single layer of polyester fabric <br /> * Protection of the earth 115 g / m2 Pe <br /> * Side windows <br /> * Pockets inside <br /> * Good ventilation <br /> * dimensions: 1.00 m + 2.10 mxm 01: 00 02: 40 mx 1.30 m <br /> * Exterior Material: 170T polyester <br /> * Interior material : 170T breathable polyester <br /> * Reference material: PE <br /> * Weight: 3.8 kg <br /> * Transport case <br /> * Ideal for 4 people <br /> * Ideal for camping , beach, holidays and as a hunting shop <br />holidays and as a hunting shop <br />holidays and as a hunting shop <br /></p>
45808
45809
45810
45811 <p>CULTIVA X3 TENT</p>- Fits 3 adults, 2 layer<br style="color:rgb(71,75,86);font-family:'Roboto Condensed', 'Helvetica Neue', Arial, sans-serif;font-size:16px;background-color:rgb(230,231,232);" />- Streamlined structure provides stability in windy conditions<br style="color:rgb(71,75,86);font-family:'Roboto Condensed', 'Helvetica Neue', Arial, sans-serif;font-size:16px;background-color:rgb(230,231,232);" />- High density, anti-insect mesh door and windows<br style="color:rgb(71,75,86);font-family:'Roboto Condensed', 'Helvetica Neue', Arial, sans-serif;font-size:16px;background-color:rgb(230,231,232);" />- Fabric: 190T Polyester PU2000mm coated<br style="color:rgb(71,75,86);font-family:'Roboto Condensed', 'Helvetica Neue', Arial, sans-serif;font-size:16px;background-color:rgb(230,231,232);" />- Waterproof seams and fire retardant fabric, ideal for camping<br style="color:rgb(71,75,86);font-family:'Roboto Condensed', 'Helvetica Neue', Arial, sans-serif;font-size:16px;background-color:rgb(230,231,232);" />- Ground protection: 120G/M2 PE<br style="color:rgb(71,75,86);font-family:'Roboto Condensed', 'Helvetica Neue', Arial, sans-serif;font-size:16px;background-color:rgb(230,231,232);" />- Product unit weight: 4.38 kg (9.66 Lb)<br style="color:rgb(71,75,86);font-family:'Roboto Condensed', 'Helvetica Neue', Arial, sans-serif;font-size:16px;background-color:rgb(230,231,232);" /><p>- Inside pocket to store personal effects Contents: One tent, one carry bag</p>
45812 <p>Ideal temperature range: 0-5°C 32-41°F)<br />- Shell fabric: 190T polyester<br />- Lining: Pongee<br />- Padding: 300g/m2 hollow fiber<br />- One-way zipper</p>
45813 <ul><li>(1.85m + 35cm)x75cm ((73 + 14 ) x 30 ) Ideal temperature range: 5-9 C (41-48F) Shell fabric: 190T polyester Lining: Pongee Padding: 220g/m2 hollow fiber One way zipper Product unit weight: 1.1 kg (2.4 Lb) Semi-circular hood S shape quilting Carry bag with header card Content: one sleeping bag, one carry bag</li></ul>
45814 <div class="jsx-1003258361 jsx-3349621030" style="margin-bottom:0px;padding:0px;border-width:0px;font-size:12px;line-height:inherit;font-family:'Proxima Nova', 'Helvetica Neue', Arial, sans-serif;vertical-align:baseline;color:rgb(64,69,83);background-color:rgb(255,255,255);"><div class="jsx-1889249662 overviewSection" style="margin-bottom:0px;padding:0px;border-width:0px;font:inherit;vertical-align:baseline;"><ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Inner fabric offers to be warm and comforting against the body</li><li class="jsx-1889249662">Well padded bag is designed to be lightweight for carrying</li><li class="jsx-1889249662">Allows smooth zipper operation around corners</li></ul></div></div><ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item"></span></li></ul>
45815
45816
45817
45818
45819
45820 <ul><li>1.75m x 1.35m (69" x 53") </li><li>Top fabric: 120G/M2 Arcylic Bottom material: PEVA Convenient for camping and picnic</li><li> Water resistant bottom material Polybag with header card Content: one mat</li></ul>
45821
45822
45823
45824
45825
45826 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Height 31 cm x Width 31 cm x Depth 38 cm; Steel Frame//Capacity: 105 kg</span></li><li><span class="a-list-item">Weight: 0.8 kg – Folds Flat for Storage Lightweight</span></li><li><span class="a-list-item">Particularly suitable for outdoor use, carry bag</span></li></ul>
45827
45828
45829
47678
47679
47680
47681
47682
47683
47684
47685
47686
47688
47690 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Let your little one play away to their heart's content with the Inflatable Friendly Animal Mat - great for travel or just to set up at home</span></li><li><span class="a-list-item">Happy animal face design on the bottom is a guaranteed hit with young ones</span></li><li><span class="a-list-item">Colourful inflatable sides keep your youngster from getting out - means less worry for you</span></li><li><span class="a-list-item">Made from durable and strong pre-tested vinyl - with repair patch</span></li><li><span class="a-list-item">Quick and easy to inflate/deflate - your baby will be able to play to their hearts content in no time</span></li></ul>
47691
47692
47693
47694
47695
47696
47697
47698
47699
47700
47701
47702
47703
47705
47706
47707
47708
47709
47710
47711
47712
47714
47719
47720
47721
47722
47725
47730
47731
47732
47733
47734
47735
47736
47737
47738
47739
47740
47741
47742
47743
47744
47745
47746
47747
47748
47749
47750
47751
47752
47753
47754
47755
47756
47757
47758
47760
47761
47762
47763
47764
47765
47766 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Stick-on adhesive repair patches</span></li><li><span class="a-list-item">Works in wet conditions, even underwater</span></li><li><span class="a-list-item">Fixes damaged boats, inflatable pools, tubes, and more</span></li><li><span class="a-list-item">10 patches included</span></li><li><span class="a-list-item">Dimensions: 2.5 x 2.5 inches</span></li></ul><p><a><br /></a></p>
47767
47768
47769
47770
47771
47772
47773
47774