SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    96111, 89233, 96931, 96923, 96621, 92921, 
    96897, 96889, 96826, 95940, 95939, 
    95938, 95937, 95936, 95935, 95934, 
    95933, 95932, 95931, 95930
  )

Query time 0.00048

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
89233 RRR022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623798000 0 Y N N B N R Y N N Y 10 1623798000 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 Matt Pickup / Ben Stevens 1642008454 Y 16/06/2021 16/07/2021 2021-12-17 17:37:27 0
92921 VCR320 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623452400 0 Y N N B N R Y N N Y 10 1623366000 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 Hatfish Music Dave Owens 1623392614 Y 2021-12-17 17:37:27 0
95930 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285822531 GBLV61709611 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796821 Y 2021-12-17 17:37:27 0
95931 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285822531 GBKQU1904334 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796822 Y 2021-12-17 17:37:27 0
95932 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285822531 GBLV61616199 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796822 Y 2021-12-17 17:37:27 0
95933 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285822531 GBKQU2027913 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796822 Y 2021-12-17 17:37:27 0
95934 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285822531 GBKQU1941681 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796822 Y 2021-12-17 17:37:27 0
95935 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285822531 GBKQU1941682 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796822 Y 2021-12-17 17:37:27 0
95936 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285822531 GBLV62015918 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796823 Y 2021-12-17 17:37:27 0
95937 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285822531 GBKQU1904332 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796823 Y 2021-12-17 17:37:27 0
95938 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285822531 GBKQU2104073 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796823 Y 2021-12-17 17:37:27 0
95939 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285822531 GBKQU2056029 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796824 Y 2021-12-17 17:37:27 0
95940 UTHCMP001HD P A 1 8.99 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 13 labelworx 5054285822531 Y 1743769369 Y 2021-12-17 17:37:27 0
96111 BMR215 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623884400 0 Y N N B N R Y N N Y 10 1623884400 1626303600 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 5054285868508 GBKQU2148288 N Beast Mode Recordings Adam Bellew, Alexei Reynolds 1621314310 Y 2021-12-17 17:37:27 0
96621 BTN012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623625200 0 Y N N B N R Y N N Y 10 1623625200 1624834800 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;} 1 labelworx 5054285949153 GBKQU2164127 N Bring The Noise Recordings Phil "Mobi D" Wale 1622654102 Y 2021-12-17 17:37:27 0
96826 UBT051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 Unbounded Traxx Damien Blanes 1632295316 Y 2021-12-17 17:37:27 0
96889 TMP178 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 Matt Clarkson 1623351113 Y 2021-12-17 17:37:27 0
96897 BDR008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623397904 0 Y N N B N R Y N N Y 10 1623366000 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 1643556767 Y 11/06/2021 11/07/2021 2021-12-17 17:37:27 0
96923 HF043 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623653927 0 Y N N B N R Y N N Y 10 1623625200 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 Digital Stuart Moir 1623654806 Y 2021-12-17 17:37:27 0
96931 ESP073 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623693017 0 Y N N B N R Y N N Y 10 1623625200 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 Energy Source Productions DJ Serenity 1623693624 Y 2021-12-17 17:37:27 0