SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    87164, 87137, 87134, 87133, 87131, 87721, 
    87821, 87203, 87202, 87201, 87200, 
    87199, 87198, 87197, 87196, 87195, 
    87194, 87193, 87192, 110657
  )

Query time 0.00033

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
87131 STMLP016 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 5054285177457 GBY3G1900320 N 87141 Copyright Control Various Artists 1594052979 Y 2021-12-17 17:37:27 0
87133 STMLP016 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 5054285177457 GBY3G1900326 N 87141 Copyright Control Various Artists 1594052980 Y 2021-12-17 17:37:27 0
87134 STMLP016 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 5054285177457 GBY3G1800287 N 87141 Copyright Control Various Artists 1594052980 Y 2021-12-17 17:37:27 0
87137 STMLP016 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 5054285177457 GBY3G1900316 N 87141 Copyright Control Various Artists 1594052981 Y 2021-12-17 17:37:27 0
87164 ST010 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 5054285171981 GBKQU2064978 N Shed Trax M Series 1594053006 Y 2021-12-17 17:37:27 0
87192 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1277754 N 87204 Mcps Copyright Control Various Artists 1594053922 Y 2021-12-17 17:37:27 0
87193 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1150482 N 87204 Mcps Copyright Control Various Artists 1594053922 Y 2021-12-17 17:37:27 0
87194 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1298649 N 87204 Mcps Copyright Control Various Artists 1594053922 Y 2021-12-17 17:37:27 0
87195 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1664252 N 87204 Mcps Copyright Control Various Artists 1594053922 Y 2021-12-17 17:37:27 0
87196 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1621705 N 87204 Mcps Copyright Control Various Artists 1594053922 Y 2021-12-17 17:37:27 0
87197 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1298292 N 87204 Mcps Copyright Control Various Artists 1594053923 Y 2021-12-17 17:37:27 0
87198 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1366829 N 87204 Mcps Copyright Control Various Artists 1594053923 Y 2021-12-17 17:37:27 0
87199 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1340009 N 87204 Mcps Copyright Control Various Artists 1594053923 Y 2021-12-17 17:37:27 0
87200 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1340010 N 87204 Mcps Copyright Control Various Artists 1594053923 Y 2021-12-17 17:37:27 0
87201 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1338850 N 87204 Mcps Copyright Control Various Artists 1594053923 Y 2021-12-17 17:37:27 0
87202 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1377113 N 87204 Mcps Copyright Control Various Artists 1594053924 Y 2021-12-17 17:37:27 0
87203 HUS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285157114 GBKQU1298486 N 87204 Mcps Copyright Control Various Artists 1594053924 Y 2021-12-17 17:37:27 0
87721 DNZ4091 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595458800 0 Y N N B N R Y N N Y 10 1595458800 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 5054285229408 GBKQU2075594 N DNZ Records Paul Norval, Clarkie, Jemma Stevenson 1596643819 Y 2021-12-17 17:37:27 0
87821 DNZF817 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285223789 GBKQU2074511 N DNZ Records Call Of Duty 1596646385 Y 2021-12-17 17:37:27 0
110657 CRKWLL20006DJ 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;} xelon 9355974204819 AUXN22062934 N Copyright Control Wav3motion 1667461534 Y 2022-11-03 08:30:05 0