SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    262454, 271489, 271497, 271493, 271504, 
    271500, 271506, 271496, 271492, 271498, 
    224456, 271510, 271503, 271494, 271490, 
    271502, 271505, 271509, 271508, 271499, 
    271507, 271501, 224454, 254325, 435505, 
    381725, 432250
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00172

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "37.86"
    },
    "table": {
      "table_name": "cscart_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",
      "cost_info": {
        "read_cost": "32.46",
        "eval_cost": "5.40",
        "prefix_cost": "37.86",
        "data_read_per_join": "184K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (262454,271489,271497,271493,271504,271500,271506,271496,271492,271498,224456,271510,271503,271494,271490,271502,271505,271509,271508,271499,271507,271501,224454,254325,435505,381725,432250)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
224454 <p><strong><em>Car Rent with Driver</em></strong><br /></p> <p>The car rental service with driver is the ideal solution for any kind of occasion. </p> <p>The chauffeured car hire drivers in Ragusa guarantee comfortable and punctual </p> <p>travel and can be booked up to a few hours before departure. </p> <p>All Nccassociati drivers in Comiso have attended regular refresher courses and </p> <p>speak several languages correctly: at your complete disposal to provide advice </p> <p>and information on places, they are also able to suggest excursions or local guides. </p> <p>The company operates on the national territory offering an absolute guarantee </p> <p>of safety with controlled vehicles for rental with driver, taxi, car rental, transfers</p> <p>and tours. </p> <p>The staff offers customers a diversified fleet of cars, strictly with quality brands, to </p> <p>offer first-class car rental with driver.</p>
224456 <p><strong><em>Car rental</em></strong></p> <p>The car rental service is the ideal solution for any kind of occasion. </p> <p>The staff offers customers a diversified fleet of cars, strictly with quality brands, to offer first-class</p> <p>car rental.</p> <p>By choosing the vehicle that best suits their needs, the customer will find the newest and most luxurious</p> <p> models of cars, vans, convertibles and minibuses at their disposal.</p> <p>Nccassociati has city cars, small cars, station wagons, cars for business trips, minibuses, Renault 15-seater </p> <p>transfers, S-Class, Cls Mercedes vintage cars and many other types of cars, suitable for any occasion. </p> <p>The best means are used to constantly guarantee comfort, punctuality and courtesy to all customers.</p>
254325 <h4> Rent a Car </h4> <p> Car rental service is the ideal solution for any type of case. <br> The staff offers customers a variety of machines, strictly with quality brands, <br> to offer first class rental cars. <// p> <p> Choose the vehicle that best suits your needs. </p> <p> <br> </p>
262454 <p> <b> Vehicle Sales </b> </p> <p> In the automotive sector since 1989, thirty years of experience at your disposal for any need. We try to find the right solution to your priority by enhancing and respecting the emotion that makes your heart beat. Every single guest is accompanied and guided by their tutor who will remain at their complete disposal both in the sales phase, but above all in the post-sales phase, always and in any case by their side </p> <p> <b> The DGA Car & Service offers: </b> </p> <ul> <li> <strong> Car rental </strong> </li> </ul> <p> </p>
271489
271490
271492
271493
271494
271496
271497
271498
271499
271500
271501
271502
271503
271504
271505
271506
271507
271508
271509
271510
381725 <p>Makina RV camping për dy persona 20 euro.</p> <p>Fëmijet nën 6 vjec falas.</p> <p>Ne ofrojmë një vend të mirë dhe të sigurt për të qëndruar gjatë natës. Ne gjithashtu shërbejmë mëngjes, drekë dhe darka. Këtu mund të gjeni energji elektrike, ujë të pijshëm, internet, shkarkime për tualete me ujë gri dhe kimike, gjithashtu mund të përdorni dushe, tualete dhe lavatriçe makinë.</p> <p>Shërbimet që vijnë të përfshira për makinat:</p> <ul><li>Internet </li><li>Ujë I pijshem </li><li>Elekticitet </li><li>Tualetet </li><li>Lavanteri </li><li>Dush </li><li>Ambient për zgarë</li><li>Shkarkimi I ujrave të zeza dhe të bardha </li></ul> <p><br /></p>
432250 <h3 class="text-center">Dacia Logan</h3><h3><em>Garantie 100 euro</em> </h3><h4> Classa family</h4><ol><li>3 zile                 <strong> 22  </strong>    Euro                        </li><li>4-8 zile               <strong>21</strong>      Euro                     </li><li>9-14 zile         <strong>   19.00</strong>  Euro     </li><li>15-21 zile          <strong>16.00</strong>  Euro     </li><li>22-30 zile         <strong> 15.00</strong>  Euro    </li></ol><h5><em>Cutie Viteza Manuala</em></h5><h5><em>Capacitate 5 pasageri </em></h5><h5><em>Carburant Diesel </em></h5><h5><em>Consum Carburant 5.5 L / 100 km </em></h5><h5><em>Ac, Abc, Airbags, Central locking, Cruise control, Electric windows, Esp</em></h5><p><br /></p><p><br /></p><p><br /></p>
435505 <p></p> <p><i class="fa-solid fa-gear"</i>Mercedes Benz C Class</p> <p>2.0 Diesel</p> <p>Manual</p> <p>30€ Day</p> <p>Minimum 3 Days</p> </i><p><i class="fa-solid fa-gear"></i></p>