SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    85887, 85886, 85885, 85884, 85883, 85882, 
    85881, 85880, 85879, 85878, 85877, 
    85876, 85875, 85874, 85873, 85872, 
    85871, 85870, 85869, 85868
  )

Query time 0.00032

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
85868 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 DEYI62000005 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85869 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBKQU2005552 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85870 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBKQU2011342 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85871 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBKQU2011249 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85872 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBKQU2012155 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85873 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBKQU2002534 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85874 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBKQU2011498 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85875 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBKQU2001780 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85876 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBKQU2003147 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85877 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBKQU2006010 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85878 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 SEXRM1900147 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85879 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 UK2X22000004 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85880 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 NLH4S2000003 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85881 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 QZ4WR1600309 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85882 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBLV61908739 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85883 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBKQU2002331 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85884 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 GBLV61908608 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85885 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 UK4L91900004 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85886 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 QZ4WR1600300 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0
85887 LWIBIZA202004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1590534000 0 Y N N B N R Y N N Y 10 1590534000 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 5054285078648 BEL951900025 N 85892 Copyright Control Various Artists 1590589829 Y 2021-12-17 17:37:27 0