SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    96513, 96512, 96511, 96510, 96503, 96384, 
    96086, 95838, 94773, 95878, 96342, 
    96341, 96340, 96343, 96337, 96336, 
    96335, 96322, 96313, 96182
  )

Query time 0.00045

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
94773 FD049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622156400 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 Mick Doyle / Hayley Duggan 1617618218 Y 2021-12-17 17:37:27 0
95838 SSD043 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622156400 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 AUTO N Sugar Skull Digital Jud Roper 1620429645 Y 2021-12-17 17:37:27 0
95878 RRB003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621983600 0 Y N N B N R Y N N Y 10 1621983600 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;} 3 N Copyright Control Dean Richardson/Stuart Angus 1642009206 Y 26/05/2021 25/06/2021 2021-12-17 17:37:27 0
96086 HOT086 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622156400 0 Y N N B N R Y N N Y 10 1622156400 1623366000 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 5054285913918 GBKQU2157430 N Hot Box Digital Dean Richardson 1621272302 Y 2021-12-17 17:37:27 0
96182 TBHH033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621551600 0 Y N N B N R Y N N Y 10 1621551600 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 Matt Lewis / Joseph Hooper 1621409843 Y 2021-12-17 17:37:27 0
96313 FR132 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621551600 0 Y N N B N R Y N N Y 10 1621551600 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 Tara Nicholson 1621748712 Y 2021-12-17 17:37:27 0
96322 BB023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621575011 0 Y N N B N R Y N N Y 10 1621551600 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 Ben Miles 1621786515 Y 2021-12-17 17:37:27 0
96335 VRF009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621646394 0 Y N N B N R Y N N Y 10 1621638000 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 Slenderman/Random but Raw 1622128562 Y 2021-12-17 17:37:27 0
96336 TMP176 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621677554 0 Y N N B N R Y N N Y 10 1621638000 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 Tempo Trax Gary orton & Matt Clarkson 1622128575 Y 2021-12-17 17:37:27 0
96337 TMP177 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621677652 0 Y N N B N R Y N N Y 10 1621638000 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 Tempo Trax Trevor Wilson/Robert Yellowley 1622128588 Y 2021-12-17 17:37:27 0
96340 HFEP005A P A 1 1.69 1 0.000 0 0 0 0.00 0 1621810800 0 Y N N B N R Y N N Y 10 1621810800 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 Toolbox Publishing Nick Hayward/Rick Eastham 1622190166 Y 2021-12-17 17:37:27 0
96341 HFEP005B P A 1 1.69 1 0.000 0 0 0 0.00 0 1621810800 0 Y N N B N R Y N N Y 10 1621810800 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 Toolbox Publishing Nick Hayward/Rick Eastham 1622190185 Y 2021-12-17 17:37:27 0
96342 HFEP005C P A 1 1.69 1 0.000 0 0 0 0.00 0 1621810800 0 Y N N B N R Y N N Y 10 1621810800 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 Toolbox Publishing Nick Hayward/Rick Eastham 1622190208 Y 2021-12-17 17:37:27 0
96343 FBR338 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621801144 0 Y N N B N R Y N N Y 10 1621724400 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 Ben Stevens / Mark Tench 1622128670 Y 2021-12-17 17:37:27 0
96384 TTLFD007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622156400 0 Y N N B N R Y N N Y 10 1622156400 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;} 3 N Copyright Control Jonni Bryant/Paul Clark 1641760529 Y 28/05/2021 27/06/2021 2021-12-17 17:37:27 0
96503 FR133 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622156400 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 Damien Dobson / Paul Luffman / Rob Yellowley 1641484002 Y 28/05/2021 27/06/2021 2021-12-17 17:37:27 0
96510 BDR007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622188026 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 Dave Grabowski 1643556680 Y 28/05/2021 27/06/2021 2021-12-17 17:37:27 0
96511 IA014A P A 1 1.69 1 0.000 0 0 0 0.00 0 1622198056 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 Tara Nicholson 1622198763 Y 2021-12-17 17:37:27 0
96512 IA014B P A 1 1.69 1 0.000 0 0 0 0.00 0 1622198114 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 Ben Miles 1622198782 Y 2021-12-17 17:37:27 0
96513 KK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622198233 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 Matthew Wade 1622198805 Y 2021-12-17 17:37:27 0