SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    42450, 42449, 42448, 42447, 42446, 42445, 
    42444, 42443, 42442, 42441, 42440, 
    42439, 42438, 42437, 42436, 42435, 
    42433, 42271, 42270, 42269
  )

Query time 0.00049

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
42269 LWWAHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1430953200 0 Y N N B N R Y N N Y 10 1430953200 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 5054281663015 GBKQU1490850 N 42271 Copyright Control Various Artists 1428728515 Y 2021-12-17 17:37:27 0
42270 LWWAHH15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1430953200 0 Y N N B N R Y N N Y 10 1430953200 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 5054281663015 GBKQU1476762 N 42271 Copyright Control Various Artists 1428728517 Y 2021-12-17 17:37:27 0
42271 LWWAHH15 P A 1 8.99 1 0.000 0 0 0 0.00 0 1430953200 0 Y N N B N R Y N N Y 10 1430953200 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 5054281663015 Y 1428728520 Y 2021-12-17 17:37:27 0
42433 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBKQU1506606 N 42458 Copyright Control Various Artists 1429419614 Y 2021-12-17 17:37:27 0
42435 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61405792 N 42458 Copyright Control Various Artists 1431352438 Y 2021-12-17 17:37:27 0
42436 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61416252 N 42458 Copyright Control Various Artists 1429419624 Y 2021-12-17 17:37:27 0
42437 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61414523 N 42458 Copyright Control Various Artists 1429419626 Y 2021-12-17 17:37:27 0
42438 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61400794 N 42458 Copyright Control Various Artists 1431352421 Y 2021-12-17 17:37:27 0
42439 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBKQU1515506 N 42458 Copyright Control Various Artists 1429419632 Y 2021-12-17 17:37:27 0
42440 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61411903 N 42458 Copyright Control Various Artists 1429419634 Y 2021-12-17 17:37:27 0
42441 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61412548 N 42458 Copyright Control Various Artists 1429419637 Y 2021-12-17 17:37:27 0
42442 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 AU5U41200116 N 42458 Copyright Control Various Artists 1429419642 Y 2021-12-17 17:37:27 0
42443 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GRAG11400036 N 42458 Copyright Control Various Artists 1429419644 Y 2021-12-17 17:37:27 0
42444 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61405519 N 42458 Copyright Control Various Artists 1431352384 Y 2021-12-17 17:37:27 0
42445 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61410781 N 42458 Copyright Control Various Artists 1429419652 Y 2021-12-17 17:37:27 0
42446 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61407365 N 42458 Copyright Control Various Artists 1429419654 Y 2021-12-17 17:37:27 0
42447 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBKQU1488324 N 42458 Copyright Control Various Artists 1431936806 Y 2021-12-17 17:37:27 0
42448 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61405118 N 42458 Copyright Control Various Artists 1429419661 Y 2021-12-17 17:37:27 0
42449 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61401447 N 42458 Copyright Control Various Artists 1431352351 Y 2021-12-17 17:37:27 0
42450 LWEGHD12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1431903600 0 Y N N B N R Y N N Y 10 1431903600 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 5054281672468 GBLV61401444 N 42458 Copyright Control Various Artists 1431352330 Y 2021-12-17 17:37:27 0