SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    86818, 86816, 86673, 86546, 86298, 86564, 
    87403, 87401, 86580, 88424, 86807, 
    86875, 86874, 86872, 86869, 86867, 
    86866, 86771, 86770, 86769
  )

Query time 0.00043

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
86298 PTR117 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592521200 0 Y N N B N R Y N N Y 10 1592521200 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 5054285118641 GBKQU2054989 N Power Tracks Records Power Tracks Records 1591811275 Y 2021-12-17 17:37:27 0
86546 FE298 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592521200 0 Y N N B N R Y N N Y 10 1592521200 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 5054285077306 GBKQU2047710 N Fatal Energy Records Anthony Michael Whitton 1591811275 Y 2021-12-17 17:37:27 0
86564 DNZ406 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592434800 0 Y N N B N R Y N N Y 10 1592434800 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 5054285155042 GBKQU2062050 N DNZ Records Dj Oskar 1591811275 Y 2021-12-17 17:37:27 0
86580 FE297 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592348400 0 Y N N B N R Y N N Y 10 1592348400 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 5054285077283 GBKQU2047708 N Fatal Energy Records Evgeniy Levchenko 1591811275 Y 2021-12-17 17:37:27 0
86673 Cheek477A P A 1 1.69 1 0.000 0 0 0 0.00 0 1592521200 0 Y N N B N R Y N N Y 10 1592521200 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 5054284958323 GBLV61923284 N All Boys Music Mark Topham, Karl Twigg 1591817694 Y 2021-12-17 17:37:27 0
86769 DNZHD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591916400 0 Y N N B N R Y N N Y 10 1591916400 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 5054285142066 GBKQU2059454 N 86772 DNZ Records Various Artists 1591818782 Y 2021-12-17 17:37:27 0
86770 DNZHD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591916400 0 Y N N B N R Y N N Y 10 1591916400 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 5054285142066 GBKQU2059455 N 86772 DNZ Records Various Artists 1591818782 Y 2021-12-17 17:37:27 0
86771 DNZHD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591916400 0 Y N N B N R Y N N Y 10 1591916400 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 5054285142066 GBKQU2059456 N 86772 DNZ Records Various Artists 1591818782 Y 2021-12-17 17:37:27 0
86807 FE296 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592175600 0 Y N N B N R Y N N Y 10 1592175600 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 5054285077276 GBKQU2047707 N Fatal Energy Records Fabrizio Fronzoni 1591823124 Y 2021-12-17 17:37:27 0
86816 PTR122 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592607600 0 Y N N B N R Y N N Y 10 1592607600 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 5054285151549 GBKQU2061302 N 86826 Power Tracks Records Power Tracks Records 1591823143 Y 2021-12-17 17:37:27 0
86818 PTR122 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592607600 0 Y N N B N R Y N N Y 10 1592607600 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 5054285151549 GBKQU2061304 N 86826 Power Tracks Records Power Tracks Records 1591823146 Y 2021-12-17 17:37:27 0
86866 PTR121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592002800 0 Y N N B N R Y N N Y 10 1592002800 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 5054285151532 GBKQU2061292 N 86876 Power Tracks Records Power Tracks Records 1591824602 Y 2021-12-17 17:37:27 0
86867 PTR121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592002800 0 Y N N B N R Y N N Y 10 1592002800 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 5054285151532 GBKQU2061293 N 86876 Power Tracks Records Power Tracks Records 1591824602 Y 2021-12-17 17:37:27 0
86869 PTR121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592002800 0 Y N N B N R Y N N Y 10 1592002800 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 5054285151532 GBKQU2061295 N 86876 Power Tracks Records Power Tracks Records 1591824602 Y 2021-12-17 17:37:27 0
86872 PTR121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592002800 0 Y N N B N R Y N N Y 10 1592002800 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 5054285151532 GBKQU2061298 N 86876 Power Tracks Records Power Tracks Records 1591824603 Y 2021-12-17 17:37:27 0
86874 PTR121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592002800 0 Y N N B N R Y N N Y 10 1592002800 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 5054285151532 GBKQU2061300 N 86876 Power Tracks Records Power Tracks Records 1591824603 Y 2021-12-17 17:37:27 0
86875 PTR121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592002800 0 Y N N B N R Y N N Y 10 1592002800 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 5054285151532 GBKQU2061301 N 86876 Power Tracks Records Power Tracks Records 1591824603 Y 2021-12-17 17:37:27 0
87401 DNZ405 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592348400 0 Y N N B N R Y N N Y 10 1592348400 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 5054285155097 GBKQU2062067 N DNZ Records Call of Duty, Lou 1594060262 Y 2021-12-17 17:37:27 0
87403 DNZ405 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592348400 0 Y N N B N R Y N N Y 10 1592348400 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 5054285155097 GBKQU2062069 N DNZ Records Call of Duty, Lou 1594060295 Y 2021-12-17 17:37:27 0
88424 bG62 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592175600 0 Y N N B N R Y N N Y 10 1592175600 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 5054285313008 GBKQU2090528 N bg bg 1598894248 Y 2021-12-17 17:37:27 0