SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    87011, 86980, 86979, 86977, 86976, 86975, 
    86974, 86973, 86972, 86971, 86970, 
    86969, 87436, 87396, 87395, 87394, 
    87393, 87392, 87391, 87390
  )

Query time 0.00038

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
86969 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBKQU1149881 N 86981 Copyright Control Mcps Various Artists 1594052814 Y 2021-12-17 17:37:27 0
86970 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBKQU1149878 N 86981 Copyright Control Mcps Various Artists 1594052815 Y 2021-12-17 17:37:27 0
86971 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBKQU1339988 N 86981 Copyright Control Mcps Various Artists 1594052815 Y 2021-12-17 17:37:27 0
86972 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBKQU1160921 N 86981 Copyright Control Mcps Various Artists 1594052815 Y 2021-12-17 17:37:27 0
86973 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBKQU1338839 N 86981 Copyright Control Mcps Various Artists 1594052815 Y 2021-12-17 17:37:27 0
86974 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBLV61605477 N 86981 Copyright Control Mcps Various Artists 1594052815 Y 2021-12-17 17:37:27 0
86975 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBKQU1298482 N 86981 Copyright Control Mcps Various Artists 1594052816 Y 2021-12-17 17:37:27 0
86976 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBKQU1211173 N 86981 Copyright Control Mcps Various Artists 1594052816 Y 2021-12-17 17:37:27 0
86977 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBKQU1212925 N 86981 Copyright Control Mcps Various Artists 1594052816 Y 2021-12-17 17:37:27 0
86979 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBKQU1202973 N 86981 Copyright Control Mcps Various Artists 1594052816 Y 2021-12-17 17:37:27 0
86980 HDB010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285088586 GBKQU1166811 N 86981 Copyright Control Mcps Various Artists 1594052817 Y 2021-12-17 17:37:27 0
87011 PTR123 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594940400 0 Y N N B N R Y N N Y 10 1594940400 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 5054285166451 GBKQU2064123 N Power Tracks Records Power Tracks Records 1594052849 Y 2021-12-17 17:37:27 0
87390 HDB009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285084892 GBKQU1549756 N 87397 Copyright Control Mcps Various Artists 1594054671 Y 2021-12-17 17:37:27 0
87391 HDB009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285084892 GBKQU1338852 N 87397 Copyright Control Mcps Various Artists 1594054672 Y 2021-12-17 17:37:27 0
87392 HDB009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285084892 GBKQU1287153 N 87397 Copyright Control Mcps Various Artists 1594054672 Y 2021-12-17 17:37:27 0
87393 HDB009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285084892 GBKQU1299340 N 87397 Copyright Control Mcps Various Artists 1594054672 Y 2021-12-17 17:37:27 0
87394 HDB009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285084892 GBKQU1377112 N 87397 Copyright Control Mcps Various Artists 1594054672 Y 2021-12-17 17:37:27 0
87395 HDB009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285084892 GBKQU1299338 N 87397 Copyright Control Mcps Various Artists 1594054672 Y 2021-12-17 17:37:27 0
87396 HDB009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285084892 GBJLH0513526 N 87397 Copyright Control Mcps Various Artists 1594054672 Y 2021-12-17 17:37:27 0
87436 DNZF812 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594681200 0 Y N N B N R Y N N Y 10 1594681200 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 5054285215685 GBKQU2073191 N DNZ Records Zero Range 1594055010 Y 2021-12-17 17:37:27 0