SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    90052, 89929, 89312, 89311, 89310, 89309, 
    89985, 89944, 89943, 89402, 89191, 
    89173, 89172, 89551, 89037, 89483, 
    89445, 89443, 88978, 88914
  )

Query time 0.00052

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
88914 ST015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285326923 GBKQU2093443 N Shed trax Kirk P 1616758071 Y 2021-12-17 17:37:27 0
88978 RRR005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1602025200 0 Y N N B N R Y N N Y 10 1602025200 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;} 4 N Toolbox Publishing Owen Swinerd / Dom Sweeten / Rob Stephens 1602430050 Y 2021-12-17 17:37:27 0
89037 HSU009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1602457200 0 Y N N B N R Y N N Y 10 1602457200 0 B 0 0 0 0 6 N 0 P F 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 5054285157282 GBKQU2029605 N 89047 mcps copyright control various artists 1599887403 Y 2021-12-17 17:37:27 0
89172 ST016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1602802800 0 Y N N B N R Y N N Y 10 1602802800 0 B 0 0 0 0 6 N 0 P F 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 5054285353615 GBKQU2099177 N Shed Trax Rick James 1600232713 Y 2021-12-17 17:37:27 0
89173 ST016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1602802800 0 Y N N B N R Y N N Y 10 1602802800 0 B 0 0 0 0 6 N 0 P F 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 5054285353615 GBKQU2099178 N Shed Trax Rick James 1600232713 Y 2021-12-17 17:37:27 0
89191 LTB05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1602802800 0 Y N N B N R Y N N Y 10 1602802800 0 B 0 0 0 0 6 N 0 P F 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 5054285353004 GBKQU2099053 N Copyright Control Alan James, Wain Johnstone & Rocksteady 1600233308 Y 2021-12-17 17:37:27 0
89309 Cheek494 P A 1 1.69 1 0.000 0 0 0 0.00 0 1603407600 0 Y N N B N R Y N N Y 10 1603407600 0 B 0 0 0 0 6 N 0 P F 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 5054285035801 GBKQU2030885 N Copyright Control Charlie Goddard 1600837505 Y 2021-12-17 17:37:27 0
89310 Cheek494 P A 1 1.69 1 0.000 0 0 0 0.00 0 1603407600 0 Y N N B N R Y N N Y 10 1603407600 0 B 0 0 0 0 6 N 0 P F 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 5054285035801 GBKQU2040217 N Copyright Control Charlie Goddard 1600837505 Y 2021-12-17 17:37:27 0
89311 Cheek494 P A 1 1.69 1 0.000 0 0 0 0.00 0 1603407600 0 Y N N B N R Y N N Y 10 1603407600 0 B 0 0 0 0 6 N 0 P F 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 5054285035801 GBKQU2040218 N Copyright Control Charlie Goddard 1600837505 Y 2021-12-17 17:37:27 0
89312 Cheek494 P A 1 1.69 1 0.000 0 0 0 0.00 0 1603407600 0 Y N N B N R Y N N Y 10 1603407600 0 B 0 0 0 0 6 N 0 P F 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 5054285035801 GBKQU2040219 N Copyright Control Charlie Goddard 1600837506 Y 2021-12-17 17:37:27 0
89402 PMD030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1602802800 0 Y N N B N R Y N N Y 10 1602802800 1604016000 B 0 0 0 0 6 N 0 P F 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;} 4 labelworx 5054285378717 GBLV62004020 N Pumped Marc Daniels 1601053502 Y 2021-12-17 17:37:27 0
89443 DNZF878 P A 1 1.69 1 0.000 0 0 0 0.00 0 1602025200 0 Y N N B N R Y N N Y 10 1602025200 0 B 0 0 0 0 6 N 0 P F 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 5054285388105 GBLV62005858 N DNZ Records T-Jay, Adelle 1601399106 Y 2021-12-17 17:37:27 0
89445 DNZF879 P A 1 1.69 1 0.000 0 0 0 0.00 0 1602111600 0 Y N N B N R Y N N Y 10 1602111600 0 B 0 0 0 0 6 N 0 P F 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 5054285388075 GBLV62005856 N DNZ Records Bounce Enforcerz 1601400001 Y 2021-12-17 17:37:27 0
89483 DNZF880 P A 1 1.69 1 0.000 0 0 0 0.00 0 1602284400 0 Y N N B N R Y N N Y 10 1602284400 0 B 0 0 0 0 6 N 0 P F 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 5054285388273 GBLV62005881 N DNZ Records Jumpin Jack 1601485502 Y 2021-12-17 17:37:27 0
89551 DNZF882 P A 1 1.69 1 0.000 0 0 0 0.00 0 1602543600 0 Y N N B N R Y N N Y 10 1602543600 0 B 0 0 0 0 6 N 0 P F 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 5054285398234 GBLV62007438 N DNZ Records Jamie B 1601918102 Y 2021-12-17 17:37:27 0
89929 DNZF889 P A 1 1.69 1 0.000 0 0 0 0.00 0 1603407600 0 Y N N B N R Y N N Y 10 1603407600 0 B 0 0 0 0 6 N 0 P F 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 5054285425756 GBLV62012188 N DNZ Records Jamie B 1602782102 Y 2021-12-17 17:37:27 0
89943 DNZF887 P A 1 1.69 1 0.000 0 0 0 0.00 0 1603234800 0 Y N N B N R Y N N Y 10 1603234800 0 B 0 0 0 0 6 N 0 P F 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 5054285425312 GBLV62012137 N DNZ Records Jumpin Jack 1602782108 Y 2021-12-17 17:37:27 0
89944 DNZ418 P A 1 1.69 1 0.000 0 0 0 0.00 0 1603321200 0 Y N N B N R Y N N Y 10 1603321200 0 B 0 0 0 0 6 N 0 P F 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 5054285425558 GBLV62012161 N DNZ Records DJ Pulse 1602782109 Y 2021-12-17 17:37:27 0
89985 RTR010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1603321200 0 Y N N B N R Y N N Y 10 1603321200 0 N 0 0 0 0 6 N 0 P F 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;} UKXN21984539 N Rec Tec Music Scott Rage 1602952182 Y 2021-12-17 17:37:27 0
90052 DNZA002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1603670400 0 Y N N B N R Y N N Y 10 1603670400 0 B 0 0 0 0 6 N 0 P F 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 5054285432266 GBLV62013409 N 90058 DNZ Records Dj Oskar 1603128306 Y 2021-12-17 17:37:27 0