SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    78020, 78019, 78018, 78017, 78016, 78015, 
    78014, 78013, 78012, 78011, 78010, 
    78009, 78008, 78007, 78006, 78005, 
    78004, 78003, 78002, 78001
  )

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
78001 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748970 N 78021 Copyright Control Various Artists 1560411361 Y 2021-12-17 17:37:27 0
78002 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748971 N 78021 Copyright Control Various Artists 1560411383 Y 2021-12-17 17:37:27 0
78003 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748973 N 78021 Copyright Control Various Artists 1560411401 Y 2021-12-17 17:37:27 0
78004 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748974 N 78021 Copyright Control Various Artists 1560411420 Y 2021-12-17 17:37:27 0
78005 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748975 N 78021 Copyright Control Various Artists 1560411441 Y 2021-12-17 17:37:27 0
78006 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748976 N 78021 Copyright Control Various Artists 1560411458 Y 2021-12-17 17:37:27 0
78007 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748978 N 78021 Copyright Control Various Artists 1560411477 Y 2021-12-17 17:37:27 0
78008 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748979 N 78021 Copyright Control Various Artists 1560411496 Y 2021-12-17 17:37:27 0
78009 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748980 N 78021 Copyright Control Various Artists 1560411514 Y 2021-12-17 17:37:27 0
78010 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748983 N 78021 Copyright Control Various Artists 1560411535 Y 2021-12-17 17:37:27 0
78011 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748985 N 78021 Copyright Control Various Artists 1560411553 Y 2021-12-17 17:37:27 0
78012 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748986 N 78021 Copyright Control Various Artists 1560411572 Y 2021-12-17 17:37:27 0
78013 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748988 N 78021 Copyright Control Various Artists 1560411588 Y 2021-12-17 17:37:27 0
78014 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748989 N 78021 Copyright Control Various Artists 1560411604 Y 2021-12-17 17:37:27 0
78015 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748990 N 78021 Copyright Control Various Artists 1560411622 Y 2021-12-17 17:37:27 0
78016 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748992 N 78021 Copyright Control Various Artists 1560411641 Y 2021-12-17 17:37:27 0
78017 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748993 N 78021 Copyright Control Various Artists 1560411660 Y 2021-12-17 17:37:27 0
78018 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748994 N 78021 Copyright Control Various Artists 1560411677 Y 2021-12-17 17:37:27 0
78019 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748995 N 78021 Copyright Control Various Artists 1560411696 Y 2021-12-17 17:37:27 0
78020 HBCBT0203RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 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 5054284423746 GBKQU1748996 N 78021 Copyright Control Various Artists 1560411714 Y 2021-12-17 17:37:27 0