SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    39037, 39033, 39028, 16065, 16030, 15873, 
    14556, 15818, 15707, 15625, 15692, 
    15689, 15688, 15340, 15531, 15288, 
    14901, 14869, 39048, 14806
  )

Query time 0.00061

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
14556 BR005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1366585200 0 Y N N B N R Y N N Y 10 1366585200 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;} N 1393599150 Y 2021-12-17 17:37:27 0
14806 UDT76 P A 1 1.69 1 0.000 0 0 0 0.00 0 1363910400 0 Y N N B N R Y N N Y 10 1363910400 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 5052653517195 GBKQU1342034 N Underdog Trax Dan Diamond 1393600576 Y 2021-12-17 17:37:27 0
14869 ACTD016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1364515200 0 Y N N B N R Y N N Y 10 1364515200 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 5052653565684 GBKQU1352313 N Active Sound Records Kernnel 1393600285 Y 2021-12-17 17:37:27 0
14901 RC025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1364688000 0 Y N N B N R Y N N Y 10 1364688000 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 5052653558730 GBKQU1350716 N Copyright Control Ramiro P Sanz 1393600259 Y 2021-12-17 17:37:27 0
15288 AA015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1364857200 0 Y N N B N R Y N N Y 10 1364857200 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 5052653546560 GBKQU1347879 N Audio Abuse Recordings Daniel Diamond 1393600206 Y 2021-12-17 17:37:27 0
15340 DNZF015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1364943600 0 Y N N B N R Y N N Y 10 1364943600 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 5052653579902 GBKQU1355526 N DNZ Records Gemeliyo & Borja 1393592242 Y 2021-12-17 17:37:27 0
15531 TDOG062 P A 1 1.69 1 0.000 0 0 0 0.00 0 1364857200 0 Y N N B N R Y N N Y 10 1364857200 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;} N Hatfish Dave Owens / Frank Farrell 1393600144 Y 2021-12-17 17:37:27 0
15625 DNZF016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1365634800 0 Y N N B N R Y N N Y 10 1365634800 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 5052653582889 GBKQU1356218 N DNZ Records Gemeliyo & Borja 1393599611 Y 2021-12-17 17:37:27 0
15688 THM009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1365289200 0 Y N N B N R Y N N Y 10 1365289200 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;} N Copyright Control Alan Prosser / Adrian Wragg 1393599728 Y 2021-12-17 17:37:27 0
15689 THM007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1365289200 0 Y N N B N R Y N N Y 10 1365289200 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;} N Copyright Control Alan Prosser / Adrian Wragg 1393599746 Y 2021-12-17 17:37:27 0
15692 THM023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1365289200 0 Y N N B N R Y N N Y 10 1365289200 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;} N Copyright Control Alan Prosser / Adrian Wragg 1393599779 Y 2021-12-17 17:37:27 0
15707 RC012RMX P A 1 1.69 1 0.000 0 0 0 0.00 0 1365894000 0 Y N N B N R Y N N Y 10 1365894000 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 5052653570763 GBKQU1353421 N Copyright Control Ramiro P Sanz 1393599479 Y 2021-12-17 17:37:27 0
15818 ACTD012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1366326000 0 Y N N B N R Y N N Y 10 1366326000 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 5052653605663 GBKQU1361559 N Active Sound Records Deejay Laura 1393599275 Y 2021-12-17 17:37:27 0
15873 DNZ059 P A 1 1.69 1 0.000 0 0 0 0.00 0 1366758000 0 Y N N B N R Y N N Y 10 1366758000 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 5052653604161 GBKQU1361223 N DNZ Records Buzzed 1393599041 Y 2021-12-17 17:37:27 0
16030 IBHHA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1367794800 0 Y N N B N R Y N N Y 10 1367794800 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 5052653634809 GBKQU1367750 N 16031 Copyright Control Various Artists 1393333882 Y 2021-12-17 17:37:27 0
16065 ACTD019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1368054000 0 Y N N B N R Y N N Y 10 1368054000 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 5052653614573 GBKQU1363456 N Active Sound Records Kernnel 1393598551 Y 2021-12-17 17:37:27 0
39028 EDD017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1368140400 0 Y N N B N R Y N N Y 10 1368140400 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 5054281388376 GBKQU1494844 N Emotive Dance Digital Sito & Cheka 1416718809 Y 2021-12-17 17:37:27 0
39033 EDD016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1368140400 0 Y N N B N R Y N N Y 10 1368140400 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 5054281388468 GBKQU1494871 N Emotive Dance Digital Sito & Cheka, Sanz, One & Brivi. 1416718824 Y 2021-12-17 17:37:27 0
39037 EDD018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1368140400 0 Y N N B N R Y N N Y 10 1368140400 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 5054281388314 GBKQU1494831 N Emotive Dance Digital Sito & Cheka, PokyTwins. 1416718834 Y 2021-12-17 17:37:27 0
39048 EDD012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1364169600 0 Y N N B N R Y N N Y 10 1364169600 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 5054281388420 GBKQU1494850 N Emotive Dance Digital Sito & Cheka 1416718867 Y 2021-12-17 17:37:27 0