SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    42268, 42267, 42266, 42265, 42264, 42263, 
    42262, 42261, 42260, 42259, 42258, 
    42257, 42256, 42255, 42254, 42253, 
    42252, 42251, 42250, 42249
  )

Query time 0.00034

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
42249 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 GBLV61405288 N 42271 Copyright Control Various Artists 1428728467 Y 2021-12-17 17:37:27 0
42250 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 ES60B1400371 N 42271 Copyright Control Various Artists 1428728470 Y 2021-12-17 17:37:27 0
42251 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 GBLV61402139 N 42271 Copyright Control Various Artists 1428728472 Y 2021-12-17 17:37:27 0
42252 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 GBKQU1493775 N 42271 Copyright Control Various Artists 1428728474 Y 2021-12-17 17:37:27 0
42253 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 GBLV61409283 N 42271 Copyright Control Various Artists 1428728477 Y 2021-12-17 17:37:27 0
42254 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 GBLV61400731 N 42271 Copyright Control Various Artists 1428728479 Y 2021-12-17 17:37:27 0
42255 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 GBLV61402212 N 42271 Copyright Control Various Artists 1428728481 Y 2021-12-17 17:37:27 0
42256 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 GBLV61405511 N 42271 Copyright Control Various Artists 1428728484 Y 2021-12-17 17:37:27 0
42257 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 GBLV61413467 N 42271 Copyright Control Various Artists 1428728486 Y 2021-12-17 17:37:27 0
42258 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 GBLV61407493 N 42271 Copyright Control Various Artists 1428728488 Y 2021-12-17 17:37:27 0
42259 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 GBLV61407422 N 42271 Copyright Control Various Artists 1428728491 Y 2021-12-17 17:37:27 0
42260 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 ES60B1400369 N 42271 Copyright Control Various Artists 1428728493 Y 2021-12-17 17:37:27 0
42261 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 GBLV61409457 N 42271 Copyright Control Various Artists 1428728495 Y 2021-12-17 17:37:27 0
42262 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 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 5054281663015 GBLV61402137 N 42271 Copyright Control Various Artists 1430984198 Y 2021-12-17 17:37:27 0
42263 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 GBLV61403137 N 42271 Copyright Control Various Artists 1428728500 Y 2021-12-17 17:37:27 0
42264 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 GBLV61405177 N 42271 Copyright Control Various Artists 1428728503 Y 2021-12-17 17:37:27 0
42265 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 GBLV61402334 N 42271 Copyright Control Various Artists 1428728505 Y 2021-12-17 17:37:27 0
42266 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 GBKQU1488187 N 42271 Copyright Control Various Artists 1428728508 Y 2021-12-17 17:37:27 0
42267 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 GBLV61401706 N 42271 Copyright Control Various Artists 1428728510 Y 2021-12-17 17:37:27 0
42268 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 GBLV61400077 N 42271 Copyright Control Various Artists 1428728512 Y 2021-12-17 17:37:27 0