SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    74996, 75157, 74620, 74619, 74618, 74617, 
    74616, 74615, 74614, 74613, 74612, 
    74611, 74870, 74993, 74918, 74515, 
    74513, 74512, 74898, 74465
  )

Query time 0.00048

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
74465 Cheek411 P A 1 1.69 1 0.000 0 0 0 0.00 0 1552608000 0 Y N N B N R Y N N Y 10 1552608000 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 5054284129297 GBLV61811584 N Copyright Control Patrick Donelan, Glen Walker 1646418456 Y 2021-12-17 17:37:27 0
74512 FE185 P A 1 1.69 1 0.000 0 0 0 0.00 0 1552867200 0 Y N N B N R Y N N Y 10 1552867200 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 5054284223681 GBKQU1912987 N Fatal Energy Records Yura Honcharov 1550379602 Y 2021-12-17 17:37:27 0
74513 TiOS034 P A 1 1.69 1 0.000 0 0 0 0.00 0 1552867200 0 Y N N B N R Y N N Y 10 1552867200 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 5054284234786 GBKQU1914915 N This Is Our Sound Digital (TiOS) Moses "M3-O" Olivier 1550379602 Y 2021-12-17 17:37:27 0
74515 TR1780 P A 1 1.69 1 0.000 0 0 0 0.00 0 1552867200 0 Y N N B N R Y N N Y 10 1552867200 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 5054284214603 GBKQU1911335 N mcps copyright control Scott Attrill 1646418459 Y 2021-12-17 17:37:27 0
74611 TFCD013D P A 1 1.69 1 0.000 0 0 0 0.00 0 1553299200 0 Y N N B N R Y N N Y 10 1553299200 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 5054284200262 JPN841900001 N 74621 TERRAFORM MUSIC M-Project 1550811605 Y 2021-12-17 17:37:27 0
74612 TFCD013D P A 1 1.69 1 0.000 0 0 0 0.00 0 1553299200 0 Y N N B N R Y N N Y 10 1553299200 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 5054284200262 JPN841900002 N 74621 TERRAFORM MUSIC M-Project 1550811605 Y 2021-12-17 17:37:27 0
74613 TFCD013D P A 1 1.69 1 0.000 0 0 0 0.00 0 1553299200 0 Y N N B N R Y N N Y 10 1553299200 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 5054284200262 JPN841900003 N 74621 TERRAFORM MUSIC M-Project 1550811605 Y 2021-12-17 17:37:27 0
74614 TFCD013D P A 1 1.69 1 0.000 0 0 0 0.00 0 1553299200 0 Y N N B N R Y N N Y 10 1553299200 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 5054284200262 JPN841900004 N 74621 TERRAFORM MUSIC M-Project 1550811605 Y 2021-12-17 17:37:27 0
74615 TFCD013D P A 1 1.69 1 0.000 0 0 0 0.00 0 1553299200 0 Y N N B N R Y N N Y 10 1553299200 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 5054284200262 JPN841900005 N 74621 TERRAFORM MUSIC M-Project 1550811605 Y 2021-12-17 17:37:27 0
74616 TFCD013D P A 1 1.69 1 0.000 0 0 0 0.00 0 1553299200 0 Y N N B N R Y N N Y 10 1553299200 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 5054284200262 JPN841900006 N 74621 TERRAFORM MUSIC M-Project 1550811606 Y 2021-12-17 17:37:27 0
74617 TFCD013D P A 1 1.69 1 0.000 0 0 0 0.00 0 1553299200 0 Y N N B N R Y N N Y 10 1553299200 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 5054284200262 JPN841900007 N 74621 TERRAFORM MUSIC M-Project 1550811606 Y 2021-12-17 17:37:27 0
74618 TFCD013D P A 1 1.69 1 0.000 0 0 0 0.00 0 1553299200 0 Y N N B N R Y N N Y 10 1553299200 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 5054284200262 JPN841900008 N 74621 TERRAFORM MUSIC M-Project 1550811606 Y 2021-12-17 17:37:27 0
74619 TFCD013D P A 1 1.69 1 0.000 0 0 0 0.00 0 1553299200 0 Y N N B N R Y N N Y 10 1553299200 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 5054284200262 JPN841900009 N 74621 TERRAFORM MUSIC M-Project 1550811606 Y 2021-12-17 17:37:27 0
74620 TFCD013D P A 1 1.69 1 0.000 0 0 0 0.00 0 1553299200 0 Y N N B N R Y N N Y 10 1553299200 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 5054284200262 JPN841900010 N 74621 TERRAFORM MUSIC M-Project 1550811606 Y 2021-12-17 17:37:27 0
74870 PTR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1553126400 0 Y N N B N R Y N N Y 10 1553126400 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 5054284265919 GBKQU1921557 N Power Tracks Records Power Tracks Records 1551848402 Y 2021-12-17 17:37:27 0
74898 DNZF468 P A 1 1.69 1 0.000 0 0 0 0.00 0 1552694400 0 Y N N B N R Y N N Y 10 1552694400 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 5054284260839 GBKQU1920600 N DNZ Records Paul Norval 1551848411 Y 2021-12-17 17:37:27 0
74918 DNZF470 P A 1 1.69 1 0.000 0 0 0 0.00 0 1552953600 0 Y N N B N R Y N N Y 10 1552953600 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 5054284267555 GBKQU1921977 N DNZ Records T-Jay 1551848450 Y 2021-12-17 17:37:27 0
74993 DNZF472 P A 1 1.69 1 0.000 0 0 0 0.00 0 1553040000 0 Y N N B N R Y N N Y 10 1553040000 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 5054284280400 GBKQU1924199 N DNZ Records Que & Rkay 1552366802 Y 2021-12-17 17:37:27 0
74996 PTR091 P A 1 1.69 1 0.000 0 0 0 0.00 0 1553731200 0 Y N N B N R Y N N Y 10 1553731200 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 5054284265933 GBKQU1921559 N Power Tracks Records Power Tracks Records 1552453201 Y 2021-12-17 17:37:27 0
75157 DNZF474 P A 1 1.69 1 0.000 0 0 0 0.00 0 1553472000 0 Y N N B N R Y N N Y 10 1553472000 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 5054284283920 GBKQU1924991 N DNZ Records Que & Rkay 1552626034 Y 2021-12-17 17:37:27 0