SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    87311, 87310, 87309, 87308, 87307, 87306, 
    87660, 87619, 88817, 88816, 88815, 
    87791, 87923, 87293, 87292, 88787, 
    87884, 87017, 87994, 87888
  )

Query time 0.00050

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
87017 IR113 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595631600 0 Y N N B N R Y N N Y 10 1595631600 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 5054285191040 GBKQU2068453 N Innergize Records BloodDropz! 1594052856 Y 2021-12-17 17:37:27 0
87292 CATID072 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595890800 0 Y N N B N R Y N N Y 10 1595890800 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 5054285207963 NLN6L2000083 N The Funky Cat Publishing C.S. Jensen 1594054355 Y 2021-12-17 17:37:27 0
87293 CATID072 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595890800 0 Y N N B N R Y N N Y 10 1595890800 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 5054285207963 NLN6L2000087 N The Funky Cat Publishing C.S. Jensen 1594054357 Y 2021-12-17 17:37:27 0
87306 HUS004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285157152 GBKQU1140109 N 87317 Mcps Copyright Control Various Artists 1594054394 Y 2021-12-17 17:37:27 0
87307 HUS004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285157152 GBKQU1150482 N 87317 Mcps Copyright Control Various Artists 1594054394 Y 2021-12-17 17:37:27 0
87308 HUS004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285157152 GBKQU1621705 N 87317 Mcps Copyright Control Various Artists 1594054394 Y 2021-12-17 17:37:27 0
87309 HUS004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285157152 GBKQU1298291 N 87317 Mcps Copyright Control Various Artists 1594054395 Y 2021-12-17 17:37:27 0
87310 HUS004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285157152 GBKQU1687337 N 87317 Mcps Copyright Control Various Artists 1594054395 Y 2021-12-17 17:37:27 0
87311 HUS004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285157152 GBKQU1222649 N 87317 Mcps Copyright Control Various Artists 1594054395 Y 2021-12-17 17:37:27 0
87619 DNZ410 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285249581 GBKQU2079173 N DNZ Records DJ Chiki 1596636958 Y 2021-12-17 17:37:27 0
87660 PTR126 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285250068 GBKQU2079269 N Zentral Brothers Zentral Brothers 1596642431 Y 2021-12-17 17:37:27 0
87791 DNZF824 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285249567 GBKQU2079170 N DNZ Records Garbie Project 1596645870 Y 2021-12-17 17:37:27 0
87884 PTR125 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595631600 0 Y N N B N R Y N N Y 10 1595631600 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 5054285250051 GBKQU2079268 N Power Tracks Records Power Tracks Records 1596648113 Y 2021-12-17 17:37:27 0
87888 DNZF820 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595545200 0 Y N N B N R Y N N Y 10 1595545200 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 5054285234167 GBKQU2076365 N DNZ Records Stillzy 1596648171 Y 2021-12-17 17:37:27 0
87923 DNZF822 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595890800 0 Y N N B N R Y N N Y 10 1595890800 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 5054285242889 GBKQU2078068 N DNZ Records Jamie B 1596649019 Y 2021-12-17 17:37:27 0
87994 PTR124 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595545200 0 Y N N B N R Y N N Y 10 1595545200 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 5054285250037 GBKQU2079265 N Ivan Diaz Ivan Diaz 1596650689 Y 2021-12-17 17:37:27 0
88787 RTR002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595804400 0 Y N N B N R Y N N Y 10 1595804400 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 5054285169667 GBKQU2064600 N Copyright Control WulfX & RvNovae 1599071932 Y 2021-12-17 17:37:27 0
88815 INFEXHD005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285241295 GBKQU2077683 N Copyright Control A. Skred, J. Brennan 1599072280 Y 2021-12-17 17:37:27 0
88816 INFEXHD005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285241295 GBKQU2077684 N Copyright Control A. Skred, J. Brennan 1599072298 Y 2021-12-17 17:37:27 0
88817 INFEXHD005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285241295 GBKQU2077685 N Copyright Control A. Skred, J. Brennan 1599072318 Y 2021-12-17 17:37:27 0