SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    66199, 66198, 66197, 66196, 66195, 66194, 
    66193, 66192, 66191, 66190, 66189, 
    66188, 66187, 66186, 66185, 66184, 
    66183, 66182, 66019, 66018
  )

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
66018 LWHTA09 P A 1 1.69 1 0.000 0 0 0 0.00 0 1519603200 0 Y N N B N R Y N N Y 10 1519603200 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 5054283485264 GBKQU1791112 N 66019 Copyright Control Various Artists 1517634040 Y 2021-12-17 17:37:27 0
66019 LWHTA09 P A 1 8.99 1 0.000 0 0 0 0.00 0 1519603200 0 Y N N B N R Y N N Y 10 1519603200 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 5054283485264 Y 1517634041 Y 2021-12-17 17:37:27 0
66182 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1770106 N 66207 Copyright Control Various Artists 1518325215 Y 2021-12-17 17:37:27 0
66183 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBLV61635923 N 66207 Copyright Control Various Artists 1518325215 Y 2021-12-17 17:37:27 0
66184 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1775872 N 66207 Copyright Control Various Artists 1518325216 Y 2021-12-17 17:37:27 0
66185 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1772583 N 66207 Copyright Control Various Artists 1518325216 Y 2021-12-17 17:37:27 0
66186 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1772884 N 66207 Copyright Control Various Artists 1518325216 Y 2021-12-17 17:37:27 0
66187 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1768604 N 66207 Copyright Control Various Artists 1518325216 Y 2021-12-17 17:37:27 0
66188 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1757289 N 66207 Copyright Control Various Artists 1518325216 Y 2021-12-17 17:37:27 0
66189 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1748303 N 66207 Copyright Control Various Artists 1518325216 Y 2021-12-17 17:37:27 0
66190 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GB2P41700005 N 66207 Copyright Control Various Artists 1518325217 Y 2021-12-17 17:37:27 0
66191 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1761465 N 66207 Copyright Control Various Artists 1518325217 Y 2021-12-17 17:37:27 0
66192 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1757049 N 66207 Copyright Control Various Artists 1518325217 Y 2021-12-17 17:37:27 0
66193 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1748828 N 66207 Copyright Control Various Artists 1518325217 Y 2021-12-17 17:37:27 0
66194 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1724356 N 66207 Copyright Control Various Artists 1518325218 Y 2021-12-17 17:37:27 0
66195 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1744505 N 66207 Copyright Control Various Artists 1518325218 Y 2021-12-17 17:37:27 0
66196 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1740884 N 66207 Copyright Control Various Artists 1518325218 Y 2021-12-17 17:37:27 0
66197 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1733494 N 66207 Copyright Control Various Artists 1518325218 Y 2021-12-17 17:37:27 0
66198 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1706752 N 66207 Copyright Control Various Artists 1518325218 Y 2021-12-17 17:37:27 0
66199 LWEGHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 5054283391176 GBKQU1735144 N 66207 Copyright Control Various Artists 1518325218 Y 2021-12-17 17:37:27 0