SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    59575, 59574, 59573, 59572, 59571, 59570, 
    59569, 59568, 59567, 59566, 59565, 
    59564, 59563, 59562, 59561, 59560, 
    59559, 59558, 59557, 59556
  )

Query time 0.00038

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
59556 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759103 N 59581 Copyright Control Various Artists 1496984430 Y 2021-12-17 17:37:27 0
59557 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759104 N 59581 Copyright Control Various Artists 1496984433 Y 2021-12-17 17:37:27 0
59558 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759105 N 59581 Copyright Control Various Artists 1496984436 Y 2021-12-17 17:37:27 0
59559 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759106 N 59581 Copyright Control Various Artists 1496984439 Y 2021-12-17 17:37:27 0
59560 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759107 N 59581 Copyright Control Various Artists 1500881651 Y 2021-12-17 17:37:27 0
59561 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759108 N 59581 Copyright Control Various Artists 1496984445 Y 2021-12-17 17:37:27 0
59562 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759109 N 59581 Copyright Control Various Artists 1496984448 Y 2021-12-17 17:37:27 0
59563 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759110 N 59581 Copyright Control Various Artists 1496984451 Y 2021-12-17 17:37:27 0
59564 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759111 N 59581 Copyright Control Various Artists 1496984454 Y 2021-12-17 17:37:27 0
59565 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759112 N 59581 Copyright Control Various Artists 1496984457 Y 2021-12-17 17:37:27 0
59566 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759113 N 59581 Copyright Control Various Artists 1496984460 Y 2021-12-17 17:37:27 0
59567 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759115 N 59581 Copyright Control Various Artists 1496984464 Y 2021-12-17 17:37:27 0
59568 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759116 N 59581 Copyright Control Various Artists 1496984467 Y 2021-12-17 17:37:27 0
59569 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759117 N 59581 Copyright Control Various Artists 1496984470 Y 2021-12-17 17:37:27 0
59570 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759118 N 59581 Copyright Control Various Artists 1496984473 Y 2021-12-17 17:37:27 0
59571 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759119 N 59581 Copyright Control Various Artists 1496984476 Y 2021-12-17 17:37:27 0
59572 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759120 N 59581 Copyright Control Various Artists 1500881654 Y 2021-12-17 17:37:27 0
59573 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759121 N 59581 Copyright Control Various Artists 1496984483 Y 2021-12-17 17:37:27 0
59574 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759122 N 59581 Copyright Control Various Artists 1496984486 Y 2021-12-17 17:37:27 0
59575 HDCSU003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1497222000 0 Y N N B N R Y N N Y 10 1497222000 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 5054283068641 GBKQU1759123 N 59581 Copyright Control Various Artists 1496984489 Y 2021-12-17 17:37:27 0