SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    43816, 43815, 43814, 43813, 43812, 43811, 
    43810, 43809, 43808, 43807, 43806, 
    43805, 43804, 43803, 43802, 43598, 
    43597, 43596, 43595, 43594
  )

Query time 0.00038

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
43594 LWEGHD13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1436223600 0 Y N N B N R Y N N Y 10 1436223600 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 5054281769212 GBKQU1501866 N 43598 Copyright Control Various Artists 1434603744 Y 2021-12-17 17:37:27 0
43595 LWEGHD13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1436223600 0 Y N N B N R Y N N Y 10 1436223600 0 B 0 0 0 0 6 N 0 P F default 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 5054281769212 GBKQU1502488 N 43598 Copyright Control Various Artists 1436258823 Y 2021-12-17 17:37:27 0
43596 LWEGHD13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1436223600 0 Y N N B N R Y N N Y 10 1436223600 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 5054281769212 GBLV61400797 N 43598 Copyright Control Various Artists 1434603753 Y 2021-12-17 17:37:27 0
43597 LWEGHD13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1436223600 0 Y N N B N R Y N N Y 10 1436223600 0 B 0 0 0 0 6 N 0 P F default 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 5054281769212 GBKQU1503328 N 43598 Copyright Control Various Artists 1436258843 Y 2021-12-17 17:37:27 0
43598 LWEGHD13 P A 1 8.99 1 0.000 0 0 0 0.00 0 1436223600 0 Y N N B N R Y N N Y 10 1436223600 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 5054281769212 Y 1434603760 Y 2021-12-17 17:37:27 0
43802 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 0 B 0 0 0 0 6 N 0 P F default 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 5054281780927 GBKQU1520194 N 43826 Copyright Control Various Artists 1438003218 Y 2021-12-17 17:37:27 0
43803 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 0 B 0 0 0 0 6 N 0 P F default 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 5054281780927 GBKQU1502493 N 43826 Copyright Control Various Artists 1438003249 Y 2021-12-17 17:37:27 0
43804 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 0 B 0 0 0 0 6 N 0 P F default 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 5054281780927 GBLV61417989 N 43826 Copyright Control Various Artists 1438003267 Y 2021-12-17 17:37:27 0
43805 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 0 B 0 0 0 0 6 N 0 P F default 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 5054281780927 GB9E90000147 N 43826 Copyright Control Various Artists 1438003299 Y 2021-12-17 17:37:27 0
43806 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 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 5054281780927 GBKQU1527313 N 43826 Copyright Control Various Artists 1435467681 Y 2021-12-17 17:37:27 0
43807 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 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 5054281780927 GBKQU1521669 N 43826 Copyright Control Various Artists 1435467683 Y 2021-12-17 17:37:27 0
43808 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 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 5054281780927 GBKQU1518788 N 43826 Copyright Control Various Artists 1435467686 Y 2021-12-17 17:37:27 0
43809 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 0 B 0 0 0 0 6 N 0 P F default 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 5054281780927 GBKQU1533105 N 43826 Copyright Control Various Artists 1438003325 Y 2021-12-17 17:37:27 0
43810 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 0 B 0 0 0 0 6 N 0 P F default 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 5054281780927 GBKQU1520542 N 43826 Copyright Control Various Artists 1438003346 Y 2021-12-17 17:37:27 0
43811 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 0 B 0 0 0 0 6 N 0 P F default 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 5054281780927 GBKQU1503352 N 43826 Copyright Control Various Artists 1438003370 Y 2021-12-17 17:37:27 0
43812 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 0 B 0 0 0 0 6 N 0 P F default 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 5054281780927 GBLV61416538 N 43826 Copyright Control Various Artists 1438003388 Y 2021-12-17 17:37:27 0
43813 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 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 5054281780927 GBKQU1512805 N 43826 Copyright Control Various Artists 1435467698 Y 2021-12-17 17:37:27 0
43814 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 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 5054281780927 GBKQU1502750 N 43826 Copyright Control Various Artists 1435467700 Y 2021-12-17 17:37:27 0
43815 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 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 5054281780927 GBKQU1507315 N 43826 Copyright Control Various Artists 1435467703 Y 2021-12-17 17:37:27 0
43816 LWHDS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437951600 0 Y N N B N R Y N N Y 10 1437951600 0 B 0 0 0 0 6 N 0 P F default 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 5054281780927 GBKQU1507104 N 43826 Copyright Control Various Artists 1438003426 Y 2021-12-17 17:37:27 0