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 (
    89394, 89396, 89390, 89392, 89388, 89395, 
    89397, 89410, 89411, 89412, 82420, 
    89360, 89363, 89365, 82354, 89359, 
    89297, 89362, 89364, 89296, 89391, 
    89393, 89406, 89408, 89407, 90843, 
    82421, 89302, 89389, 89300, 82381, 
    89301, 89299, 89349, 89334, 89350, 
    89263, 89336, 82355, 89353, 82380, 
    89333, 89354, 86823, 89355, 89356, 
    89335, 89293, 89291, 89370, 89262, 
    89372, 89273, 89276, 89369, 89371, 
    89374, 89292, 89287, 86819, 86821, 
    89272, 89275, 89357, 89271, 89274, 
    89358, 86822, 89327, 89373, 89266, 
    89328, 89329, 89269, 89402, 89404, 
    89403, 89331, 89265, 89330, 89264, 
    86817, 89368, 89268, 89367, 89308, 
    89267, 86818, 86820, 89295, 89332, 
    89294, 89405, 89309, 89321, 89257
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00150

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.24"
    },
    "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": 96,
      "rows_produced_per_join": 96,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "33.64",
        "eval_cost": "9.60",
        "prefix_cost": "43.24",
        "data_read_per_join": "366K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_product_descriptions`.`product_id` in (89394,89396,89390,89392,89388,89395,89397,89410,89411,89412,82420,89360,89363,89365,82354,89359,89297,89362,89364,89296,89391,89393,89406,89408,89407,90843,82421,89302,89389,89300,82381,89301,89299,89349,89334,89350,89263,89336,82355,89353,82380,89333,89354,86823,89355,89356,89335,89293,89291,89370,89262,89372,89273,89276,89369,89371,89374,89292,89287,86819,86821,89272,89275,89357,89271,89274,89358,86822,89327,89373,89266,89328,89329,89269,89402,89404,89403,89331,89265,89330,89264,86817,89368,89268,89367,89308,89267,86818,86820,89295,89332,89294,89405,89309,89321,89257)) and (`nuie_scalesta_net`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
82354 nuie Shower Kits Traditional Thermostatic Shower Valve & Kit - Chrome / White
82355 nuie Shower Kits Traditional Thermostatic Shower Valve & Kit - Chrome / White
82380 Hudson Reed Multi Option Shower Kits Round Brass Thermostatic Bar Valve & Shower Kit - Chrome
82381 Hudson Reed Multi Option Shower Kits Square Brass Thermostatic Bar Valve & Shower Kit - Chrome
82420 Hudson Reed Shower Kits Traditional Thermostatic Shower Valve & Kit - Brushed Brass
82421 Hudson Reed Shower Kits Traditional Thermostatic Shower Valve & Kit - Brushed Brass
86817 nuie Shower Kits Thermostatic Bar Shower With Kit - Chrome
86818 nuie Shower Kits Round Thermostatic Bar Valve & Shower Kit - Matt Black
86819 nuie Shower Kits Square Thermostatic Bar Valve & Shower Kit - Matt Black
86820 nuie Shower Kits Round Thermostatic Bar Valve & Shower Kit - Gunmetal
86821 nuie Shower Kits Square Thermostatic Bar Valve & Shower Kit - Gunmetal
86822 nuie Shower Kits Round Thermostatic Bar Valve & Shower Kit - Brushed Brass
86823 nuie Shower Kits Square Thermostatic Bar Valve & Shower Kit - Brushed Brass
89257 nuie Concealed Manual Round Valve, Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89262 nuie Thermostatic Concealed Twin Round Valve & Slide Rail Kit with Multi Function Handset & Outlet Elbow Shower Kit - Chrome
89263 nuie Thermostatic Concealed Twin Round Valve, Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89264 nuie Thermostatic Round Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89265 nuie Thermostatic Round Bar Valve & Multi Function Slide Rail Shower Kit - Chrome
89266 nuie Thermostatic Round Bar Valve & Multi Function Slide Rail Shower Kit - Chrome
89267 nuie Thermostatic Round Bar Valve & Multi Function Slide Rail Shower Kit - Chrome
89268 nuie Thermostatic Round Bar Valve & Multi Function Slide Rail Shower Kit - Chrome
89269 nuie Thermostatic Round Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89271 nuie Binsey Thermostatic Round Bath Shower Mixer & Single Function Slide Rail Shower Kit - Chrome
89272 nuie Binsey Thermostatic Round Bath Shower Mixer & Multi Function Slide Rail Shower Kit - Chrome
89273 nuie Binsey Thermostatic Round Bath Shower Mixer & Multi Function Slide Rail Shower Kit - Chrome
89274 nuie Arvan Thermostatic Round Bath Shower Mixer & Single Function Slide Rail Shower Kit - Chrome
89275 nuie Arvan Thermostatic Round Bath Shower Mixer & Multi Function Slide Rail Shower Kit - Chrome
89276 nuie Arvan Thermostatic Round Bath Shower Mixer & Single Function Slide Rail Shower Kit - Chrome
89287 nuie Binsey Thermostatic Concealed Twin Round Valve & Slide Rail Kit with Multi Function Handset & Outlet Elbow Shower Kit - Chrome
89291 nuie Binsey Thermostatic Concealed Twin Round Valve, Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89292 nuie Arvan Thermostatic Concealed Twin Round Valve & Slide Rail Kit with Multi Function Handset & Outlet Elbow Shower Kit - Chrome
89293 nuie Arvan Thermostatic Concealed Twin Round Valve, Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89294 nuie Arvan Manual Concealed Twin Round Valve with Diverter, Slide Rail Kit with Multi Function Handset & Outlet Elbow Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89295 nuie Binsey Manual Concealed Twin Round Valve with Diverter, Slide Rail Kit with Multi Function Handset & Outlet Elbow Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89296 nuie Thermostatic Concealed Twin Round Valve with Diverter, Slide Rail Kit with Multi Function Handset & Outlet Elbow Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89297 nuie Thermostatic Concealed Triple Round Valve, Slide Rail Kit with Multi Function Handset & Outlet Elbow Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89299 nuie Binsey Thermostatic Concealed Twin Round Valve with Diverter, Slide Rail Kit with Multi Function Handset & Outlet Elbow Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89300 nuie Binsey Thermostatic Concealed Triple Round Valve, Slide Rail Kit with Multi Function Handset & Outlet Elbow Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89301 nuie Arvan Thermostatic Concealed Twin Round Valve with Diverter, Slide Rail Kit with Multi Function Handset & Outlet Elbow Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89302 nuie Arvan Thermostatic Concealed Triple Round Valve, Slide Rail Kit with Multi Function Handset & Outlet Elbow Wall Mount Shower Arm & Round Fixed Head Shower Kit - Chrome
89308 nuie Thermostatic Round Bar Valve & Multi Function Slide Rail Shower Kit - Chrome
89309 nuie Thermostatic Round Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89321 nuie Thermostatic Round Bar Valve & Multi Function Slide Rail Shower Kit - Chrome
89327 nuie Reef Thermostatic Bath Shower Mixer & Multi Function Slide Rail Shower Kit - Chrome
89328 nuie Reef Thermostatic Bath Shower Mixer & Single Function Slide Rail Shower Kit - Chrome
89329 nuie Reef Thermostatic Bath Shower Mixer & Luxury Curved Multi Function Slide Rail Shower Kit - Chrome
89330 nuie Reef Thermostatic Bath Shower Mixer & Single Function Slide Rail Shower Kit - Chrome
89331 nuie Reef Thermostatic Bath Shower Mixer & Multi Function Slide Rail Shower Kit - Chrome
89332 nuie Reef Thermostatic Bath Shower Mixer & Multi Function Slide Rail Shower Kit - Chrome
89333 nuie Windon Thermostatic Square Bath Shower Mixer & Single Function Slide Rail Shower Kit - Chrome
89334 nuie Windon Thermostatic Square Bath Shower Mixer & Single Function Slide Rail Shower Kit - Chrome
89335 nuie Sanford Thermostatic Square Bath Shower Mixer & Single Function Slide Rail Shower Kit - Chrome
89336 nuie Sanford Thermostatic Square Bath Shower Mixer & Single Function Slide Rail Shower Kit - Chrome
89349 nuie Thermostatic Concealed Twin Square Valve & Slide Rail Kit with Single Function Handset & Outlet Elbow Shower Kit - Chrome
89350 nuie Thermostatic Concealed Twin Square Valve, Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89353 nuie Windon Thermostatic Concealed Twin Square Valve & Slide Rail Kit with Single Function Handset & Outlet Elbow Shower Kit - Chrome
89354 nuie Windon Thermostatic Concealed Twin Square Valve, Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89355 nuie Sanford Thermostatic Concealed Twin Square Valve & Slide Rail Kit with Single Function Handset & Outlet Elbow Shower Kit - Chrome
89356 nuie Sanford Thermostatic Concealed Twin Square Valve, Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89357 nuie Windon Manual Concealed Square Valve, Slide Rail Kit with Single Function Handset & Outlet Elbow Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89358 nuie Sanford Manual Concealed Square Valve, Slide Rail Kit with Single Function Handset & Outlet Elbow Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89359 nuie Thermostatic Concealed Twin Square Valve with Single Function Handset & Outlet Elbow Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89360 nuie Sanford Thermostatic Concealed Triple Square Valve with Single Function Handset & Outlet Elbow Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89362 nuie Windon Thermostatic Concealed Twin Square Valve with Diverter with Single Function Handset & Outlet Elbow Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89363 nuie Windon Thermostatic Concealed Triple Square Valve with Single Function Handset & Outlet Elbow Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89364 nuie Sanford Thermostatic Concealed Twin Square Valve with Diverter with Single Function Handset & Outlet Elbow Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89365 nuie Sanford Thermostatic Concealed Triple Square Valve with Single Function Handset & Outlet Elbow Wall Mount Shower Arm & Square Fixed Head Shower Kit - Chrome
89367 nuie Thermostatic Square Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89368 nuie Thermostatic Square Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89369 nuie Thermostatic Square Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89370 nuie Thermostatic Square Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89371 nuie Thermostatic Square Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89372 nuie Thermostatic Square Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89373 nuie Thermostatic Square Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89374 nuie Thermostatic Square Bar Valve & Single Function Slide Rail Shower Kit - Chrome
89388 nuie Victorian Traditional Dual Exposed Valve & Rigid Riser Shower Kit - Chrome/White
89389 nuie Victorian Traditional Dual Exposed Valve & Single Function Slide Rail Shower Kit - Chrome/White
89390 nuie Victorian Traditional Twin Exposed Valve & Rigid Riser Shower Kit - Chrome/White
89391 nuie Victorian Traditional Twin Exposed Valve & Single Function Slide Rail Shower Kit - Chrome/White
89392 nuie Edwardian Traditional Twin Exposed Valve & Rigid Riser Shower Kit - Chrome/White
89393 nuie Edwardian Traditional Twin Exposed Valve & Single Function Slide Rail Shower Kit - Chrome/White
89394 nuie Victorian Traditional Triple Exposed Valve, Rigid Riser Kit & Bath Spout Shower Kit - Chrome/White
89395 nuie Victorian Traditional Triple Exposed Valve & Rigid Riser Kit Shower Kit - Chrome/White
89396 nuie Edwardian Traditional Triple Exposed Valve, Rigid Riser Kit & Bath Spout Shower Kit - Chrome/White
89397 nuie Edwardian Traditional Triple Exposed Valve & Rigid Riser Kit Shower Kit - Chrome/White
89402 nuie Traditional Manual Concealed Valve & Single Function Slider Rail Kit & Outlet Elbow - Chrome/White
89403 nuie Traditional Manual Concealed Valve, Wall Mount Shower Arm and Round Fixed Head Shower Kit - Chrome/White
89404 nuie Traditional Manual Exposed Valve & Single Function Slider Rail Kit & Outlet Elbow - Chrome/White
89405 nuie Traditional Manual Exposed Valve & Rigid Riser Kit with Swivel Spout - Chrome/White
89406 nuie Victorian Traditional Thermostatic Concealed Twin Valve & Single Function Slider Rail Kit & Outlet Elbow - Chrome/White
89407 nuie Victorian Traditional Thermostatic Concealed Twin Valve, Wall Mount Shower Arm and Round Fixed Head Shower Kit - Chrome/White
89408 nuie Edwardian Traditional Thermostatic Concealed Twin Valve & Single Function Slider Rail Kit & Outlet Elbow - Chrome/White
89410 nuie Victorian Traditional Thermostatic Concealed Triple Valve, Single Function Slider Rail Kit & Outlet Elbow & Wall Mount Shower Arm and Round Fixed Head Shower Kit - Chrome/White
89411 nuie Victorian Traditional Thermostatic Concealed Triple Valve, Single Function Slider Rail Kit & Outlet Elbow & Wall Mount Shower Arm and Round Fixed Head Shower Kit - Chrome/White
89412 nuie Edwardian Traditional Thermostatic Concealed Triple Valve, Single Function Slider Rail Kit & Outlet Elbow & Wall Mount Shower Arm and Round Fixed Head Shower Kit - Chrome/White
90843 nuie Edwardian Traditional Thermostatic Concealed Twin Valve, Wall Mount Shower Arm and Round Fixed Head Shower Kit - Chrome/White