SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    101801, 101800, 101799, 101798, 101797, 
    101796, 101795, 101794, 101793, 101792, 
    101791, 101790, 101789, 101788, 101787, 
    101786, 101785, 101784, 101783, 101782
  )

Query time 0.00035

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
101782 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204791 N 101809 Copyright Control Various Artists 1642526614 Y 2022-01-18 18:05:29 0
101783 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204792 N 101809 Copyright Control Various Artists 1642526632 Y 2022-01-18 18:05:29 0
101784 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204793 N 101809 Copyright Control Various Artists 1642526653 Y 2022-01-18 18:05:29 0
101785 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204794 N 101809 Copyright Control Various Artists 1642526673 Y 2022-01-18 18:05:30 0
101786 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204795 N 101809 Copyright Control Various Artists 1642526690 Y 2022-01-18 18:05:30 0
101787 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204796 N 101809 Copyright Control Various Artists 1642526709 Y 2022-01-18 18:05:30 0
101788 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204797 N 101809 Copyright Control Various Artists 1642526726 Y 2022-01-18 18:05:30 0
101789 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204798 N 101809 Copyright Control Various Artists 1642526746 Y 2022-01-18 18:05:30 0
101790 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204799 N 101809 Copyright Control Various Artists 1642526764 Y 2022-01-18 18:05:31 0
101791 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204800 N 101809 Copyright Control Various Artists 1642526783 Y 2022-01-18 18:05:31 0
101792 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204801 N 101809 Copyright Control Various Artists 1642526803 Y 2022-01-18 18:05:31 0
101793 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204802 N 101809 Copyright Control Various Artists 1642526822 Y 2022-01-18 18:05:31 0
101794 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204804 N 101809 Copyright Control Various Artists 1642526839 Y 2022-01-18 18:05:31 0
101795 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204805 N 101809 Copyright Control Various Artists 1642526858 Y 2022-01-18 18:05:32 0
101796 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204806 N 101809 Copyright Control Various Artists 1642526878 Y 2022-01-18 18:05:32 0
101797 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204807 N 101809 Copyright Control Various Artists 1642526897 Y 2022-01-18 18:05:32 0
101798 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204808 N 101809 Copyright Control Various Artists 1642526918 Y 2022-01-18 18:05:32 0
101799 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204809 N 101809 Copyright Control Various Artists 1642526937 Y 2022-01-18 18:05:32 0
101800 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204810 N 101809 Copyright Control Various Artists 1642526956 Y 2022-01-18 18:05:33 0
101801 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204811 N 101809 Copyright Control Various Artists 1642526972 Y 2022-01-18 18:05:33 0