SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    92732, 92731, 92730, 92729, 92728, 92726, 
    92725, 92723, 92721, 92720, 92719, 
    92718, 92717, 92716, 92715, 92713, 
    92712, 92711, 92710, 92709
  )

Query time 0.00032

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
92709 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2095693 N Copyright Control Various Artists 1611378611 Y 2021-12-17 17:37:27 0
92710 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBLV62013371 N Copyright Control Various Artists 1611378612 Y 2021-12-17 17:37:27 0
92711 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBLV62001980 N Copyright Control Various Artists 1611378612 Y 2021-12-17 17:37:27 0
92712 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBLV62006549 N Copyright Control Various Artists 1611378612 Y 2021-12-17 17:37:27 0
92713 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBLV62003825 N Copyright Control Various Artists 1611378612 Y 2021-12-17 17:37:27 0
92715 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 ITHZ02000718 N Copyright Control Various Artists 1611378613 Y 2021-12-17 17:37:27 0
92716 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2096544 N Copyright Control Various Artists 1611378613 Y 2021-12-17 17:37:27 0
92717 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2028904 N Copyright Control Various Artists 1611378613 Y 2021-12-17 17:37:27 0
92718 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2089557 N Copyright Control Various Artists 1611378613 Y 2021-12-17 17:37:27 0
92719 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2099177 N Copyright Control Various Artists 1611378614 Y 2021-12-17 17:37:27 0
92720 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2095205 N Copyright Control Various Artists 1611378614 Y 2021-12-17 17:37:27 0
92721 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU1882860 N Copyright Control Various Artists 1611378614 Y 2021-12-17 17:37:27 0
92723 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2040211 N Copyright Control Various Artists 1611378614 Y 2021-12-17 17:37:27 0
92725 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2095730 N Copyright Control Various Artists 1611378615 Y 2021-12-17 17:37:27 0
92726 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBLV62003241 N Copyright Control Various Artists 1611378615 Y 2021-12-17 17:37:27 0
92728 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2092484 N Copyright Control Various Artists 1611378616 Y 2021-12-17 17:37:27 0
92729 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2077628 N Copyright Control Various Artists 1611378616 Y 2021-12-17 17:37:27 0
92730 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2069013 N Copyright Control Various Artists 1611378616 Y 2021-12-17 17:37:27 0
92731 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2087545 N Copyright Control Various Artists 1611378616 Y 2021-12-17 17:37:27 0
92732 LWSHD04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285636862 GBKQU2088609 N Copyright Control Various Artists 1611378616 Y 2021-12-17 17:37:27 0