SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    111756, 111755, 111754, 111753, 111752, 
    111751, 111750, 111749, 111748, 111747, 
    111746, 111745, 111744, 111743, 111742, 
    111741, 111740, 111739, 111738, 111737, 
    111736, 111735, 111734, 111733, 111732
  )

Query time 0.00040

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 25 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
111732 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2262609 N 111757 Copyright Control Various Artists 1668402920 Y 2022-11-14 06:15:20 0
111733 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2266074 N 111757 Copyright Control Various Artists 1668402920 Y 2022-11-14 06:15:20 0
111734 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2265909 N 111757 Copyright Control Various Artists 1668402921 Y 2022-11-14 06:15:21 0
111735 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2265954 N 111757 Copyright Control Various Artists 1668402921 Y 2022-11-14 06:15:21 0
111736 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2265963 N 111757 Copyright Control Various Artists 1668402921 Y 2022-11-14 06:15:21 0
111737 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2264435 N 111757 Copyright Control Various Artists 1668402921 Y 2022-11-14 06:15:21 0
111738 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2246076 N 111757 Copyright Control Various Artists 1668402921 Y 2022-11-14 06:15:21 0
111739 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2247358 N 111757 Copyright Control Various Artists 1668402922 Y 2022-11-14 06:15:22 0
111740 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2260709 N 111757 Copyright Control Various Artists 1668402922 Y 2022-11-14 06:15:22 0
111741 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2261517 N 111757 Copyright Control Various Artists 1668402922 Y 2022-11-14 06:15:22 0
111742 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2256793 N 111757 Copyright Control Various Artists 1668402922 Y 2022-11-14 06:15:22 0
111743 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2259487 N 111757 Copyright Control Various Artists 1668402923 Y 2022-11-14 06:15:23 0
111744 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2268681 N 111757 Copyright Control Various Artists 1668402923 Y 2022-11-14 06:15:23 0
111745 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2256439 N 111757 Copyright Control Various Artists 1668402923 Y 2022-11-14 06:15:23 0
111746 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2255350 N 111757 Copyright Control Various Artists 1668402923 Y 2022-11-14 06:15:23 0
111747 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2252145 N 111757 Copyright Control Various Artists 1668402923 Y 2022-11-14 06:15:23 0
111748 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 TFT202200003 N 111757 Copyright Control Various Artists 1668402924 Y 2022-11-14 06:15:24 0
111749 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2250771 N 111757 Copyright Control Various Artists 1668402924 Y 2022-11-14 06:15:24 0
111750 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2255805 N 111757 Copyright Control Various Artists 1668402924 Y 2022-11-14 06:15:24 0
111751 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 UK9E92200303 N 111757 Copyright Control Various Artists 1668402924 Y 2022-11-14 06:15:24 0
111752 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2252926 N 111757 Copyright Control Various Artists 1668402925 Y 2022-11-14 06:15:25 0
111753 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2037631 N 111757 Copyright Control Various Artists 1668402925 Y 2022-11-14 06:15:25 0
111754 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2241823 N 111757 Copyright Control Various Artists 1668402925 Y 2022-11-14 06:15:25 0
111755 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2238908 N 111757 Copyright Control Various Artists 1668402925 Y 2022-11-14 06:15:25 0
111756 LWHTS07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670976000 0 Y N N B N R Y N N Y 10 1670976000 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 5054286999362 GBKQU2241638 N 111757 Copyright Control Various Artists 1668402925 Y 2022-11-14 06:15:25 0