SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    96060, 95699, 95231, 93055, 89231, 96061, 
    95337, 92918, 96004, 96003, 96002, 
    95999, 95972, 95837, 95802, 95740, 
    95700, 95697, 95062, 95040
  )

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
89231 RRR020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621378800 0 Y N N B N R Y N N Y 10 1621378800 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 Hatfish Music, Copyright Control Gary Cooke / Dave Owens 1642007743 Y 19/05/2021 18/06/2021 2021-12-17 17:37:27 0
92918 VCR316 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621033200 0 Y N N B N R Y N N Y 10 1620946800 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 Mark Tench / Jeff Payne 1620976374 Y 2021-12-17 17:37:27 0
93055 VCR317 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 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 Copyright Control Michael Franklin 1621510324 Y 2021-12-17 17:37:27 0
95040 PMD040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 1622156400 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 5054285794388 GBKQU2135603 N Pumped Joe Longbottom 1618377302 Y 2021-12-17 17:37:27 0
95062 UTHHD048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 1622156400 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 5054285820780 GBKQU2140186 N Ultratech Dance Music UK David Grabowski 1618377618 Y 2021-12-17 17:37:27 0
95231 PMD041 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 1622761200 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 5054285794395 GBKQU2135604 N Pumped Rick James 1618981804 Y 2021-12-17 17:37:27 0
95337 BTN010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621206000 0 Y N N B N R Y N N Y 10 1621206000 1622415600 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 5054285869901 GBKQU2148517 N Bring The Noise Recordings Rick James 1619457901 Y 2021-12-17 17:37:27 0
95697 UBT050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 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 Unbounded Traxx Leighton Smith/ Damien Blanes 1620210778 Y 2021-12-17 17:37:27 0
95699 DBD059 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 1622761200 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 5054285890653 GBKQU2152999 N Drop Bear Digital Leigh Jones 1620234903 Y 2021-12-17 17:37:27 0
95700 TTLFD006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 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 Jonni Bryant/Matt Smith 1673755500 Y 14/05/2021 13/06/2021 2021-12-17 17:37:27 0
95740 EM002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 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 Shane Ryan 1620319621 Y 2021-12-17 17:37:27 0
95802 GAR010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 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 Andrew Holmes 1641541353 Y 14/05/2021 13/06/2021 2021-12-17 17:37:27 0
95837 SSD042 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 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 Kez/Drake Liddell 1620429557 Y 2021-12-17 17:37:27 0
95972 NITROX121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 0 N 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 / Hatfish Music James Jackson / Dave Owens 1642451698 Y 2021-12-17 17:37:27 0
95999 XA019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620946800 0 Y N N B N R Y N N Y 10 1620946800 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 xxxx N Copy Control Dion Phillips 1620947031 Y 2021-12-17 17:37:27 0
96002 BDR005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620978840 0 Y N N B N R Y N N Y 10 1620946800 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 Dennis De Grande 1643556626 Y 14/05/2021 13/06/2021 2021-12-17 17:37:27 0
96003 FR130 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620984394 0 Y N N B N R Y N N Y 10 1620946800 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 Rob Yellowley / Rob Healy 1641481304 Y 14/05/2021 13/06/2021 2021-12-17 17:37:27 0
96004 FR131 P A 1 1.69 1 0.000 0 0 0 0.00 0 1620984440 0 Y N N B N R Y N N Y 10 1620946800 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 Rob Yellowley / Rob Healy 1641481426 Y 14/05/2021 13/06/2021 2021-12-17 17:37:27 0
96060 GAR011 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 Global Awakening Records Paul Hunter 1621177443 Y 2021-12-17 17:37:27 0
96061 HF040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1621206000 0 Y N N B N R Y N N Y 10 1621206000 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 Aron Hammond/Damien Blanes 1621235483 Y 2021-12-17 17:37:27 0