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, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    1335, 1338, 1233, 1324, 1323, 1081, 1326, 
    1325, 1333, 1082, 1321, 1330, 1331, 
    1329, 1334, 1337, 1339, 1340, 1343, 
    399, 1299, 1810, 1811, 2918, 1341, 1342, 
    1856, 2913, 1815, 1819, 2914, 1859, 
    1858, 1850, 1294, 1298, 1297, 1293, 
    1295, 1814, 1816, 1817, 1818, 1820, 
    1821, 1822, 1823, 1824, 1825, 1826, 
    1827, 1828, 1829, 1830, 1831, 1300, 
    1301, 1302, 1304, 1303, 1812, 1808, 
    1807, 1813, 1836, 1860, 1861, 1837, 
    1851, 1853, 1838, 1839, 1840, 1841, 
    1842, 1843, 1844, 1845, 1846, 1847, 
    1848, 1849, 1855, 2915, 1857, 1862, 
    1835, 1834, 1863, 1809, 1864, 1150, 
    1152, 1149, 1151, 1148
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00058

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.16771496,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_descriptions",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["product_id", "lang_code"],
          "loops": 1,
          "rows": 96,
          "cost": 0.16771496,
          "filtered": 100,
          "attached_condition": "cscart_product_descriptions.product_id in (1335,1338,1233,1324,1323,1081,1326,1325,1333,1082,1321,1330,1331,1329,1334,1337,1339,1340,1343,399,1299,1810,1811,2918,1341,1342,1856,2913,1815,1819,2914,1859,1858,1850,1294,1298,1297,1293,1295,1814,1816,1817,1818,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1300,1301,1302,1304,1303,1812,1808,1807,1813,1836,1860,1861,1837,1851,1853,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1855,2915,1857,1862,1835,1834,1863,1809,1864,1150,1152,1149,1151,1148) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description unit_name
399 Commercial Max/Oval Steel Accessory Universal Tiedown Kit
1081 Commercial Max/Oval Steel Accessory 100mm Conduit PVC Pipe only 4.2M Long
1082 Commercial Max/Oval Steel Accessory 150mm Conduit PVC Pipe Only 4.2M Long
1148 Wedgetail Trade Accessory Awning Bracket Pair
1149 Wedgetail Trade Accessory 3 Brackets Two End Caps No Pipe (Side Mount)
1150 Wedgetail Trade Accessory 1450mm Crossbar
1151 Wedgetail Trade Accessory 3 Brackets Two End Caps No Pipe (Side Mount)
1152 Wedgetail Trade Accessory 1600mm Crossbar
1233 <p>Commercial Max/Oval Steel Accessory</p>
1293 Wedgetail Adventure Accessory Awning bracket suits 270 awning x 2
1294 Wedgetail Adventure Accessory Awning bracket adjustable x 2
1295 Wedgetail Adventure Accessory Awning brackets adjustable x 3
1297 Wedgetail Adventure Accessory Awning bracket fixed x 2
1298 Wedgetail Adventure Accessory Awning bracket fixed kit x 3
1299 Ford Platform lightbar extension to suit TRANSIT EXLWB
1300 Wedgetail Adventure Accessory Gas Bottle Holder
1301 Wedgetail Adventure Accessory Hexmesh panel
1302 Wedgetail Adventure Accessory HexMesh Panel for Van
1303 Wedgetail Adventure Accessory Jerry can holder
1304 Wedgetail Adventure Accessory Hi-lift bracket
1321 <p>Commercial Max/Oval Steel Accessory Beacon Plate</p>
1323 <p>Commercial Max/Oval Steel Accessory 100mm conduit carrier with caps and 3 brackets</p>
1324 <p>Commercial Max/Oval Steel Accessory 100mm conduit carrier caps and 3 brackets, NO PIPE</p>
1325 Commercial Max/Oval Steel Accessory 150mm conduit carrier with caps and 3 brackets
1326 Commercial Max/Oval Steel Accessory 150mm conduit carrier caps and 3 brackets, NO PIPE
1329 Commercial Max/Oval Steel Accessory Jerrycan holder
1330 <p>Commercial Max/Oval Steel Accessory Jack and shovel holder</p>
1331 Commercial Max/Oval Steel Accessory Jack and shovel holder to suit ARB rack
1333 Commercial Max/Oval Steel Accessory 150mm Conduit end cap
1334 Commercial Max/Oval Steel Accessory Removable boat roller pair
1335 <p>Commercial Max Double roller bracket and rollers</p>
1337 <p>Commercial Max/Oval Steel Accessory Safeclamp ladder clamp pair</p>
1338 Commercial Max Single roller bracket and roller
1339 Commercial Max/Oval Steel Accessory Shovel holder
1340 Commercial Max/Oval Steel Accessory Spare wheel carrier
1341 Trademax Accessory Double Roller kit to suit Trademax Bar
1342 Trademax Accessory Single Roller kit to suit Trademax Bar
1343 Commercial Max/Oval Steel Accessory Steel Wind Deflector
1807 Wedgetail Adventure Accessory Lightbar Support plate
1808 Wedgetail Adventure Accessory Lightbar Support Extension
1809 Wedgetail Adventure Accessory Van Light Bar support Plate
1810 Platform lightbar extension to suit Crafter LWB
1811 Platform lightbar extension to suit Crafter MWB
1812 Wedgetail Adventure Accessory Light Mount Grab Handle
1813 Wedgetail Adventure Accessory Milwaukee Packout Bracket
1814 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-1113U
1815 Wedgetail Adventure Accessory 1300 cross bar rubber x 1piece
1816 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-1412U
1817 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-1413U
1818 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-1414U
1819 Wedgetail Adventure Accessory 1500 cross bar rubber x 1piece
1820 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-1613U
1821 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-1614U
1822 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-1812U
1823 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-1813U
1824 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-2012U
1825 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-2013U
1826 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-2212U
1827 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-2213U
1828 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-2214U
1829 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-3015U
1830 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-3315U
1831 Wedgetail Adventure Accessory Cross bar rubber kit to suit WTP-4015U
1834 Wedgetail Adventure Accessory Tiedown Straps PACK of 2 3.0 M
1835 Wedgetail Adventure Accessory Tiedown Straps BOX of 12 X 2 3.0 M
1836 Wedgetail Adventure Accessory Ratchet Straps PACK of 2 3.5 M
1837 Wedgetail Adventure Accessory Roof Top Tent Mounting Hardware
1838 Wedgetail Adventure Accessory Sides for 1100mm Platforms
1839 Wedgetail Adventure Accessory Sides for 1400mm Platforms
1840 Wedgetail Adventure Accessory Sides for 1600mm Platforms
1841 Wedgetail Adventure Accessory Sides for 1800mm Platforms
1842 Wedgetail Adventure Accessory Sides for 2000mm Platforms
1843 Wedgetail Adventure Accessory Sides for 2200mm Platforms
1844 Wedgetail Adventure Accessory Sides for 2500mm Platforms
1845 Wedgetail Adventure Accessory Sides for 2800mm Platforms
1846 Wedgetail Adventure Accessory Sides for 3000mm Platforms
1847 Wedgetail Adventure Accessory Sides for 3300mm Platforms
1848 Wedgetail Adventure Accessory Sides for 4000mm Platforms
1849 Wedgetail Adventure Accessory Sides for 4200mm Platforms
1850 Wedgetail Adventure Accessory Aerial Mount Side Mount Style
1851 Wedgetail Adventure Accessory Shovel holder
1853 Wedgetail Adventure Accessory Side Light Mount x 2
1855 Wedgetail Adventure Accessory Solar panel bracket pair (Panels >1m long require two kits)
1856 Tradesman SPARE FASTENERS KIT
1857 Wedgetail Adventure Accessory Spare wheel carrier
1858 Wedgetail Adventure Accessory Adjustable Recovery Tracks bracket to sit on top of rack
1859 Wedgetail Adventure Accessory Adjustable Recovery tracks bracket for fitment on side of rack
1860 Wedgetail Adventure Accessory Recovery Wing Tracks Bracket to sit on side of rack(Suits Maxtrax and new TREDs only) - No Pins included
1861 Wedgetail Adventure Accessory Recovery Wing Tracks Bracket to sit on top of rack(Suits Maxtrax and new TREDs only) - No Pins included
1862 Wedgetail Adventure Accessory Tiedown Eyelets pack of 4
1863 Wedgetail Adventure Accessory Universal “T” Plate - kit of 4
1864 Wedgetail Adventure Accessory Vent Hole Kit
2913 Wedgetail Adventure Accessory 100mm conduit carrier caps and 3 brackets, NO PIPE
2914 Wedgetail Adventure Accessory 150mm conduit carrier caps and 3 brackets, NO PIPE
2915 <p>CS-Cart Multi vendor Mobile App Builder provides an affordable, end-to-end mobile app for e-commerce businesses that enables growth and expansion in the mobile world.</p> <ul><li>Option to customize the design of the CS Cart Marketplace Mobile App.</li><li><span class="ws-check"></span>Customers can view vendor information, shipping address, description, & products.</li><li><span class="ws-check"></span>Allows the store owner to create multiple customer profiles.</li><li><span class="ws-check"></span>Continuous browsing without internet access with preloaded pages.</li><li><span class="ws-check"></span>Store owners can send various push notifications to customers.</li></ul>
2918 <p>this is a test product</p>