SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    96572, 96559, 96114, 95928, 92920, 96615, 
    96498, 95750, 95749, 96567, 96499, 
    95897, 95896, 94823, 96556, 96522, 
    96521, 96520, 96519, 96518
  )

Query time 0.00041

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
92920 VCR319 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622761200 0 Y N N B N R Y N N Y 10 1622761200 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;} 4 N Toolbox Publishing Paul Norris / Darrell White / Nick Hayward 1612123301 Y 2021-12-17 17:37:27 0
94823 KD019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622415600 0 Y N N B N R Y N N Y 10 1622415600 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;} 4 N Aleks/Paul Reeves aleks/Paul Reeves/Nomadic 1618508141 Y 2021-12-17 17:37:27 0
95749 PRN007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622502000 0 Y N N B N R Y N N Y 10 1622502000 1623711600 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 5054285882795 GBKQU2151536 N Perennial Recording Network K. Daw & S. Hill 1620321302 Y 2021-12-17 17:37:27 0
95750 PRN007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622502000 0 Y N N B N R Y N N Y 10 1622502000 1623711600 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;} 3 labelworx 5054285882795 GBKQU2151537 N Perennial Recording Network K. Daw & S. Hill 1620321302 Y 2021-12-17 17:37:27 0
95896 BTN011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622415600 0 Y N N B N R Y N N Y 10 1622415600 1623625200 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 5054285903810 GBKQU2155163 N Bring the noise recordings Dave 'Ludo' Parker 1620752701 Y 2021-12-17 17:37:27 0
95897 BTN011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622415600 0 Y N N B N R Y N N Y 10 1622415600 1623625200 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 5054285903810 GBKQU2155164 N Bring the noise recordings Dave 'Ludo' Parker 1620752702 Y 2021-12-17 17:37:27 0
95928 INR071 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622761200 0 Y N N B N R Y N N Y 10 1622761200 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 5054285895191 GBKQU2153651 N Copyright Control Spyndl 1623232116 Y 2021-12-17 17:37:27 0
96114 TBR213 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622761200 0 Y N N B N R Y N N Y 10 1622761200 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;} 4 N Copyright Control Martyn Harrison / Gareth Roberts 1621346745 Y 2021-12-17 17:37:27 0
96498 HHF013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622502000 0 Y N N B N R Y N N Y 10 1622502000 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;} 4 N Copyright Control Artem Svirchevskiy 1622058271 Y 2021-12-17 17:37:27 0
96499 KT009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622415600 0 Y N N B N R Y N N Y 10 1622415600 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;} 4 N Kaki Trax Paul Norris 1623225591 Y 2021-12-17 17:37:27 0
96518 PDR040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622206961 0 Y N N B N R Y N N Y 10 1622156400 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;} 4 N copyright control brian keith 1622207766 Y 2021-12-17 17:37:27 0
96519 PDR041 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622207084 0 Y N N B N R Y N N Y 10 1622156400 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;} 4 N Toolbox Publishing, Copyright Control Pat Glenny, Gary Sly, Tanya Sly 1642265309 Y 28/05/2021 27/06/2021 2021-12-17 17:37:27 0
96520 PDR042 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622207387 0 Y N N B N R Y N N Y 10 1622156400 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;} 4 N copyright control Dean Richardson 1622207808 Y 2021-12-17 17:37:27 0
96521 BZK081 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622213284 0 Y N N B N R Y N N Y 10 1622156400 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;} 4 N Copyright Control Karl Davies / Chloe Mcmanoman 1622214031 Y 2021-12-17 17:37:27 0
96522 TGR079 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622213647 0 Y N N B N R Y N N Y 10 1622156400 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;} 4 N Copyright control Paul Batten/Richard Whybrow 1622214109 Y 2021-12-17 17:37:27 0
96556 VR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622302448 0 Y N N B N R Y N N Y 10 1622242800 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;} 4 N Copyright Control G.W.R./Alexei Reynolds 1622303129 Y 2021-12-17 17:37:27 0
96559 FLY014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622761200 0 Y N N B N R Y N N Y 10 1622761200 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;} 4 N Copyright Control Vandalize/Pete Maxwell 1624431205 Y 2021-12-17 17:37:27 0
96567 HF041 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622443553 0 Y N N B N R Y N N Y 10 1622415600 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;} 4 N Toolbox Digital Darren Lewis/David Jackson 1622445069 Y 2021-12-17 17:37:27 0
96572 EM003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622761200 0 Y N N B N R Y N N Y 10 1622761200 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;} 4 N Copyright Control Casey Fournere 1680545739 Y 04/06/2021 04/07/2021 2021-12-17 17:37:27 0
96615 RRR021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622646299 0 Y N N B N R Y N N Y 10 1622588400 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;} 4 N Toolbox Publishing, Copyright Control Stuart Angus/Pat Glenny 1642009295 Y 02/06/2021 02/07/2021 2021-12-17 17:37:27 0