SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    21831, 18743, 12099, 12259, 12174, 12166, 
    12241, 11885, 11739, 11625, 11646, 
    11460, 11463, 10820, 10693, 10690, 
    10646, 10639, 10573, 10568
  )

Query time 0.00054

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 20 Using where

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since exclusive_end_date out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params final_category aggregator aggregator_id ean isrc tbid is_album from_album publisher writers updated_timestamp available_worldwide stream_release_date download_release_date added_timestamp parent_product_id
10568 YEAH049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1350255600 0 Y N N B N R Y N N Y 10 1350255600 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653391740 GB2P41200053 N Yeah Boi Recordings Lee4Real, Fl4sh, Trix, Bowie666 1393934318 Y 2021-12-17 17:37:27 0
10573 FLMBD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1350255600 0 Y N N B N R Y N N Y 10 1350255600 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653391375 GBKQU1212968 N Flammable Records Elivate & Matt E.B 1393934270 Y 2021-12-17 17:37:27 0
10639 DLI012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1350860400 0 Y N N B N R Y N N Y 10 1350860400 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653386579 GBKQU1211794 N N / A Antony Reynolds, 1393933869 Y 2021-12-17 17:37:27 0
10646 DNZ044 P A 1 1.69 1 0.000 0 0 0 0.00 0 1351033200 0 Y N N B N R Y N N Y 10 1351033200 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653408486 GBKQU1216879 N DNZ Records Dj Oskar 1393591326 Y 2021-12-17 17:37:27 0
10690 DLI011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1351468800 0 Y N N B N R Y N N Y 10 1351468800 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653386562 GB9P51200023 N Copyright Dan Bentick, Marvin Jarvis 1393933462 Y 2021-12-17 17:37:27 0
10693 DLI011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1351468800 0 Y N N B N R Y N N Y 10 1351468800 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653386562 GBKQU1214196 N Copyright Dan Bentick, Marvin Jarvis 1393933484 Y 2021-12-17 17:37:27 0
10820 AA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1351555200 0 Y N N B N R Y N N Y 10 1351555200 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653404266 GBKQU1215865 N Unknown Dean Cliff 1393933417 Y 2021-12-17 17:37:27 0
11460 ACTD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1351900800 0 Y N N B N R Y N N Y 10 1351900800 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653419390 GBKQU1219403 N Active Sound Records Deejay Laura 1393933137 Y 2021-12-17 17:37:27 0
11463 RC005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1351728000 0 Y N N B N R Y N N Y 10 1351728000 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} N 1393933312 Y 2021-12-17 17:37:27 0
11625 DNZ051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1353110400 0 Y N N B N R Y N N Y 10 1353110400 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653436861 GBKQU1223272 N Dj Oskar Dj Oskar 1393932513 Y 2021-12-17 17:37:27 0
11646 MOJO018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1352851200 0 Y N N B N R Y N N Y 10 1352851200 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} N Copyright Control Nik Geordasis 1393932617 Y 2021-12-17 17:37:27 0
11739 DNZ054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1354320000 0 Y N N B N R Y N N Y 10 1354320000 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653449618 GBKQU1226484 N Dj Oskar Dj Oskar 1393592209 Y 2021-12-17 17:37:27 0
11885 FLMBD018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1355097600 0 Y N N B N R Y N N Y 10 1355097600 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653407069 GBKQU1216606 N Flammable Records Sharp-E 1393930725 Y 2021-12-17 17:37:27 0
12099 FLMBD023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1356912000 0 Y N N B N R Y N N Y 10 1356912000 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653407113 GBKQU1216611 N Flammable Records Kye Shand & Ozy 1393929769 Y 2021-12-17 17:37:27 0
12166 FLMBD021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1356480000 0 Y N N B N R Y N N Y 10 1356480000 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653407144 GBKQU1216615 N Flammable Records Brickenden DJ's 1393930142 Y 2021-12-17 17:37:27 0
12174 HNRS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1356566400 0 Y N N B N R Y N N Y 10 1356566400 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653470797 GBKQU1231065 N Hardnoise Records Nando Cp 1393930105 Y 2021-12-17 17:37:27 0
12241 AA008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1356393600 0 Y N N B N R Y N N Y 10 1356393600 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653452830 GBKQU1227291 N Audio Abuse Recordings Micky Williams 1393930165 Y 2021-12-17 17:37:27 0
12259 Cheek101 P A 1 1.69 1 0.000 0 0 0 0.00 0 1356652800 0 Y N N B N R Y N N Y 10 1356652800 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653461818 GBKQU1228998 N Copyright Control Steven Brett, Chris Waddleton 1393588937 Y 2021-12-17 17:37:27 0
18743 TPS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1356998400 0 Y N N B N R Y N N Y 10 1356998400 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653899093 GBKQU1327769 N Tps Records DJ Crazybass 1393929660 Y 2021-12-17 17:37:27 0
21831 Digital14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1356998400 0 Y N N B N R Y N N Y 10 1356998400 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5052653920629 GBKQU1332236 N 21839 Cenobite Music Axel Doorman 1393929713 Y 2021-12-17 17:37:27 0