SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    87742, 87741, 87656, 87644, 87643, 87642, 
    87641, 87640, 87639, 87638, 87637, 
    87636, 87635, 87634, 87633, 87632, 
    87631, 87630, 87629, 87628
  )

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
87628 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1982787 N 87645 Copyright Control Various Artists 1596636319 Y 2021-12-17 17:37:27 0
87629 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBLV61919550 N 87645 Copyright Control Various Artists 1596636319 Y 2021-12-17 17:37:27 0
87630 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1728084 N 87645 Copyright Control Various Artists 1596636320 Y 2021-12-17 17:37:27 0
87631 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1996212 N 87645 Copyright Control Various Artists 1596636320 Y 2021-12-17 17:37:27 0
87632 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1981470 N 87645 Copyright Control Various Artists 1596636321 Y 2021-12-17 17:37:27 0
87633 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1904025 N 87645 Copyright Control Various Artists 1596636321 Y 2021-12-17 17:37:27 0
87634 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 AU8N01100105 N 87645 Copyright Control Various Artists 1596636321 Y 2021-12-17 17:37:27 0
87635 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBY3G1800256 N 87645 Copyright Control Various Artists 1596636321 Y 2021-12-17 17:37:27 0
87636 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1813684 N 87645 Copyright Control Various Artists 1596636322 Y 2021-12-17 17:37:27 0
87637 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBLV61723341 N 87645 Copyright Control Various Artists 1596636322 Y 2021-12-17 17:37:27 0
87638 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1769068 N 87645 Copyright Control Various Artists 1596636322 Y 2021-12-17 17:37:27 0
87639 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBACW1700831 N 87645 Copyright Control Various Artists 1596636322 Y 2021-12-17 17:37:27 0
87640 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1765728 N 87645 Copyright Control Various Artists 1596636323 Y 2021-12-17 17:37:27 0
87641 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1760179 N 87645 Copyright Control Various Artists 1596636324 Y 2021-12-17 17:37:27 0
87642 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1725440 N 87645 Copyright Control Various Artists 1596636324 Y 2021-12-17 17:37:27 0
87643 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBLV61634669 N 87645 Copyright Control Various Artists 1596636324 Y 2021-12-17 17:37:27 0
87644 LWHDB14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285240991 GBKQU1573069 N 87645 Copyright Control Various Artists 1596636326 Y 2021-12-17 17:37:27 0
87656 WAOD057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285217047 GBKQU2073337 N Copyright Control R.Scott & K.Worby 1596641504 Y 2021-12-17 17:37:27 0
87741 HUS005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285157190 GBKQU1298662 N 87752 mcps copyright control various artists 1596643312 Y 2021-12-17 17:37:27 0
87742 HUS005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597618800 0 Y N N B N R Y N N Y 10 1597618800 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 5054285157190 GBKQU1148507 N 87752 mcps copyright control various artists 1596643313 Y 2021-12-17 17:37:27 0