SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    84384, 84362, 84686, 84650, 84666, 84450, 
    84224, 84570, 84398, 84462, 84460, 
    84459, 84486, 84427, 84426, 84425, 
    84424, 84423, 84422, 84421
  )

Query time 0.00046

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
84224 FE278 P A 1 1.69 1 0.000 0 0 0 0.00 0 1585267200 0 Y N N B N R Y N N Y 10 1585267200 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 5054284901145 GBKQU2016530 N Fatal Energy Records Evgeniy Levchenko 1582779605 Y 2021-12-17 17:37:27 0
84362 CheekUDC5 P A 1 1.69 1 0.000 0 0 0 0.00 0 1585868400 0 Y N N B N R Y N N Y 10 1585868400 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 5054284585635 GBKQU1360874 N 84373 Copyright Control Various Artists 1583384406 Y 2021-12-17 17:37:27 0
84384 FE281 P A 1 1.69 1 0.000 0 0 0 0.00 0 1585868400 0 Y N N B N R Y N N Y 10 1585868400 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 5054284901183 GBKQU2016534 N Fatal Energy Records Yura Honcharov 1583384412 Y 2021-12-17 17:37:27 0
84398 WAOD051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584921600 0 Y N N B N R Y N N Y 10 1584921600 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 5054284914602 GBKQU2018887 N Copyright Control R.Scott 1583384416 Y 2021-12-17 17:37:27 0
84421 LWHDB10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584316800 0 Y N N B N R Y N N Y 10 1584316800 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 5054284933016 GBKQU1346776 N 84428 Copyright Control Various Artists 1583470807 Y 2021-12-17 17:37:27 0
84422 LWHDB10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584316800 0 Y N N B N R Y N N Y 10 1584316800 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 5054284933016 GBKQU1020977 N 84428 Copyright Control Various Artists 1583470807 Y 2021-12-17 17:37:27 0
84423 LWHDB10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584316800 0 Y N N B N R Y N N Y 10 1584316800 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 5054284933016 GBKQU1343489 N 84428 Copyright Control Various Artists 1583470808 Y 2021-12-17 17:37:27 0
84424 LWHDB10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584316800 0 Y N N B N R Y N N Y 10 1584316800 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 5054284933016 GBKQU1148557 N 84428 Copyright Control Various Artists 1583470808 Y 2021-12-17 17:37:27 0
84425 LWHDB10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584316800 0 Y N N B N R Y N N Y 10 1584316800 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 5054284933016 GBKQU1200624 N 84428 Copyright Control Various Artists 1583470808 Y 2021-12-17 17:37:27 0
84426 LWHDB10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584316800 0 Y N N B N R Y N N Y 10 1584316800 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 5054284933016 GBKQU1020399 N 84428 Copyright Control Various Artists 1583470808 Y 2021-12-17 17:37:27 0
84427 LWHDB10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584316800 0 Y N N B N R Y N N Y 10 1584316800 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 5054284933016 GBD5G0800001 N 84428 Copyright Control Various Artists 1583470808 Y 2021-12-17 17:37:27 0
84450 PTR108 P A 1 1.69 1 0.000 0 0 0 0.00 0 1585267200 0 Y N N B N R Y N N Y 10 1585267200 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 5054284929248 GBKQU2021836 N Power Tracks Records Power Tracks Records 1583557254 Y 2021-12-17 17:37:27 0
84459 DNZF749 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584576000 0 Y N N B N R Y N N Y 10 1584576000 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 5054284940861 GBKQU2023745 N DNZ Records Nova Scotia, DJ Pulse 1583816402 Y 2021-12-17 17:37:27 0
84460 DNZF749 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584576000 0 Y N N B N R Y N N Y 10 1584576000 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 5054284940861 GBKQU2023746 N DNZ Records Nova Scotia, DJ Pulse 1583816402 Y 2021-12-17 17:37:27 0
84462 DNZF749 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584576000 0 Y N N B N R Y N N Y 10 1584576000 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 5054284940861 GBKQU2023748 N DNZ Records Nova Scotia, DJ Pulse 1583816402 Y 2021-12-17 17:37:27 0
84486 DNZ396 P A 1 1.69 1 0.000 0 0 0 0.00 0 1584489600 0 Y N N B N R Y N N Y 10 1584489600 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 5054284940793 GBKQU2023721 N DNZ Records DJ Delirious, Caz 1583816410 Y 2021-12-17 17:37:27 0
84570 DNZF751 P A 1 1.69 1 0.000 0 0 0 0.00 0 1585180800 0 Y N N B N R Y N N Y 10 1585180800 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 5054284960531 GBKQU2026711 N DNZ Records Clarky 1584507602 Y 2021-12-17 17:37:27 0
84650 DNZ398 P A 1 1.69 1 0.000 0 0 0 0.00 0 1585695600 0 Y N N B N R Y N N Y 10 1585695600 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 5054284968797 GBKQU2028297 N DNZ Records Paul Norval 1585026002 Y 2021-12-17 17:37:27 0
84666 DNZ399 P A 1 1.69 1 0.000 0 0 0 0.00 0 1585609200 0 Y N N B N R Y N N Y 10 1585609200 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 5054284974590 GBKQU2029359 N DNZ Records Dj Oskar, Jamie B 1585026007 Y 2021-12-17 17:37:27 0
84686 DNZF752 P A 1 1.69 1 0.000 0 0 0 0.00 0 1585782000 0 Y N N B N R Y N N Y 10 1585782000 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 5054284968896 GBKQU2028314 N DNZ Records DJ Chris Davies 1585026014 Y 2021-12-17 17:37:27 0