SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    95939, 95938, 95937, 95936, 95935, 95934, 
    95933, 95932, 95931, 95930
  )

Query time 0.00022

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 10 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
95930 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 4 labelworx 5054285822531 GBLV61709611 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796821 Y 2021-12-17 17:37:27 0
95931 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 4 labelworx 5054285822531 GBKQU1904334 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796822 Y 2021-12-17 17:37:27 0
95932 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 4 labelworx 5054285822531 GBLV61616199 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796822 Y 2021-12-17 17:37:27 0
95933 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 4 labelworx 5054285822531 GBKQU2027913 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796822 Y 2021-12-17 17:37:27 0
95934 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 4 labelworx 5054285822531 GBKQU1941681 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796822 Y 2021-12-17 17:37:27 0
95935 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 4 labelworx 5054285822531 GBKQU1941682 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796822 Y 2021-12-17 17:37:27 0
95936 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 4 labelworx 5054285822531 GBLV62015918 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796823 Y 2021-12-17 17:37:27 0
95937 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 4 labelworx 5054285822531 GBKQU1904332 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796823 Y 2021-12-17 17:37:27 0
95938 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 4 labelworx 5054285822531 GBKQU2104073 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796823 Y 2021-12-17 17:37:27 0
95939 UTHCMP001HD P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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;} 4 labelworx 5054285822531 GBKQU2056029 N 95940 Ultratech Dance Music UK Jay Middleton, Drake Liddell, Ray Jones, Ben Stevens, Dave Owens, Danny Haynes, Sam Didden. 1620796824 Y 2021-12-17 17:37:27 0