SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    43255, 43254, 43253, 43252, 43251, 43250, 
    43249, 42769, 42768, 42767, 42766, 
    42765, 42764, 42763, 42762, 42761, 
    42759, 42758, 42757, 42756
  )

Query time 0.00044

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
42756 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 ES60B1500001 N 42769 Copyright Control Various Artists 1430888469 Y 2021-12-17 17:37:27 0
42757 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 GBLV61405791 N 42769 Copyright Control Various Artists 1431351745 Y 2021-12-17 17:37:27 0
42758 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 GBLV61410758 N 42769 Copyright Control Various Artists 1430888474 Y 2021-12-17 17:37:27 0
42759 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 GBLV61405119 N 42769 Copyright Control Various Artists 1431351711 Y 2021-12-17 17:37:27 0
42761 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 GBKQU1498867 N 42769 Copyright Control Various Artists 1431351658 Y 2021-12-17 17:37:27 0
42762 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 GBLV61401429 N 42769 Copyright Control Various Artists 1433844057 Y 2021-12-17 17:37:27 0
42763 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 GBKQU1494550 N 42769 Copyright Control Various Artists 1430888487 Y 2021-12-17 17:37:27 0
42764 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 GBKQU1500356 N 42769 Copyright Control Various Artists 1430888489 Y 2021-12-17 17:37:27 0
42765 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 GBKQU1500188 N 42769 Copyright Control Various Artists 1430888492 Y 2021-12-17 17:37:27 0
42766 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 GBLV61415130 N 42769 Copyright Control Various Artists 1430888499 Y 2021-12-17 17:37:27 0
42767 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 ES60B1500034 N 42769 Copyright Control Various Artists 1430888502 Y 2021-12-17 17:37:27 0
42768 LWHDS06 P A 1 1.69 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 GBLV61402182 N 42769 Copyright Control Various Artists 1433844390 Y 2021-12-17 17:37:27 0
42769 LWHDS06 P A 1 8.99 1 0.000 0 0 0 0.00 0 1433372400 0 Y N N B N R Y N N Y 10 1433372400 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 5054281696532 Y 1430888507 Y 2021-12-17 17:37:27 0
43249 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1512242 N 43274 Copyright Control Various Artists 1433307676 Y 2021-12-17 17:37:27 0
43250 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1517849 N 43274 Copyright Control Various Artists 1433307679 Y 2021-12-17 17:37:27 0
43251 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1512760 N 43274 Copyright Control Various Artists 1433307681 Y 2021-12-17 17:37:27 0
43252 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 AU5T41205009 N 43274 Copyright Control Various Artists 1433307684 Y 2021-12-17 17:37:27 0
43253 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBPSX1400320 N 43274 Copyright Control Various Artists 1433307686 Y 2021-12-17 17:37:27 0
43254 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1517786 N 43274 Copyright Control Various Artists 1433307689 Y 2021-12-17 17:37:27 0
43255 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1517139 N 43274 Copyright Control Various Artists 1433307691 Y 2021-12-17 17:37:27 0