SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    86725, 86724, 86723, 86561, 86560, 86558, 
    86557, 86556, 86555, 86554, 86553, 
    86552, 86551, 86825, 86824, 86823, 
    86822, 86821, 86820, 86819
  )

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
86551 HUS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285098936 GBKQU1339956 N 86562 copyright control MCPS various artists 1591811275 Y 2021-12-17 17:37:27 0
86552 HUS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285098936 GBKQU1273045 N 86562 copyright control MCPS various artists 1591811275 Y 2021-12-17 17:37:27 0
86553 HUS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285098936 GBKQU1338853 N 86562 copyright control MCPS various artists 1591811275 Y 2021-12-17 17:37:27 0
86554 HUS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285098936 GBKQU1389184 N 86562 copyright control MCPS various artists 1591811275 Y 2021-12-17 17:37:27 0
86555 HUS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285098936 GBKQU1211177 N 86562 copyright control MCPS various artists 1591811275 Y 2021-12-17 17:37:27 0
86556 HUS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285098936 GBKQU1381416 N 86562 copyright control MCPS various artists 1591811275 Y 2021-12-17 17:37:27 0
86557 HUS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285098936 GBKQU1140137 N 86562 copyright control MCPS various artists 1591811275 Y 2021-12-17 17:37:27 0
86558 HUS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285098936 GBKQU1149883 N 86562 copyright control MCPS various artists 1591811275 Y 2021-12-17 17:37:27 0
86560 HUS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285098936 GBKQU1148645 N 86562 copyright control MCPS various artists 1591811275 Y 2021-12-17 17:37:27 0
86561 HUS001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285098936 GBKQU1148557 N 86562 copyright control MCPS various artists 1591811275 Y 2021-12-17 17:37:27 0
86723 HDB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285057636 GBKQU1339956 N 86735 copyright control MCPS various artists 1591818162 Y 2021-12-17 17:37:27 0
86724 HDB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285057636 GBKQU1149881 N 86735 copyright control MCPS various artists 1591818162 Y 2021-12-17 17:37:27 0
86725 HDB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1592780400 0 Y N N B N R Y N N Y 10 1592780400 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 5054285057636 GBKQU1160933 N 86735 copyright control MCPS various artists 1591818162 Y 2021-12-17 17:37:27 0
86819 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 GBKQU2061305 N 86826 Power Tracks Records Power Tracks Records 1591823146 Y 2021-12-17 17:37:27 0
86820 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 GBKQU2061306 N 86826 Power Tracks Records Power Tracks Records 1591823147 Y 2021-12-17 17:37:27 0
86821 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 GBKQU2061307 N 86826 Power Tracks Records Power Tracks Records 1591823147 Y 2021-12-17 17:37:27 0
86822 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 GBKQU2061308 N 86826 Power Tracks Records Power Tracks Records 1591823147 Y 2021-12-17 17:37:27 0
86823 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 GBKQU2061309 N 86826 Power Tracks Records Power Tracks Records 1591823147 Y 2021-12-17 17:37:27 0
86824 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 GBKQU2061310 N 86826 Power Tracks Records Power Tracks Records 1591823147 Y 2021-12-17 17:37:27 0
86825 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 GBKQU2061311 N 86826 Power Tracks Records Power Tracks Records 1591823147 Y 2021-12-17 17:37:27 0