SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    65926, 65925, 65924, 65923, 65922, 65921, 
    65920, 65919, 65918, 65917, 65916, 
    65915, 65914, 65913, 65912, 65911, 
    65910, 65909, 65908, 65907, 65906, 
    65905, 65904, 65903, 65902, 65901, 
    65900, 65899, 65898, 65897
  )

Query time 0.00041

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 30 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
65897 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374813 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806741 N 65927 Copyright Control Various Artists 1549016190 Y 2021-12-17 17:37:27 0
65898 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374813 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806742 N 65927 Copyright Control Various Artists 1517375901 Y 2021-12-17 17:37:27 0
65899 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374813 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806743 N 65927 Copyright Control Various Artists 1517375920 Y 2021-12-17 17:37:27 0
65900 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374813 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806744 N 65927 Copyright Control Various Artists 1517375940 Y 2021-12-17 17:37:27 0
65901 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374813 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806745 N 65927 Copyright Control Various Artists 1517375959 Y 2021-12-17 17:37:27 0
65902 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374813 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806746 N 65927 Copyright Control Various Artists 1517375978 Y 2021-12-17 17:37:27 0
65903 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374813 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806747 N 65927 Copyright Control Various Artists 1517375998 Y 2021-12-17 17:37:27 0
65904 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374813 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806748 N 65927 Copyright Control Various Artists 1517376015 Y 2021-12-17 17:37:27 0
65905 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374813 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806749 N 65927 Copyright Control Various Artists 1517376037 Y 2021-12-17 17:37:27 0
65906 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374814 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806750 N 65927 Copyright Control Various Artists 1517376056 Y 2021-12-17 17:37:27 0
65907 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374814 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806751 N 65927 Copyright Control Various Artists 1517376075 Y 2021-12-17 17:37:27 0
65908 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374814 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806752 N 65927 Copyright Control Various Artists 1517376094 Y 2021-12-17 17:37:27 0
65909 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374814 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806753 N 65927 Copyright Control Various Artists 1517376114 Y 2021-12-17 17:37:27 0
65910 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374814 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806754 N 65927 Copyright Control Various Artists 1517376134 Y 2021-12-17 17:37:27 0
65911 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374814 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806755 N 65927 Copyright Control Various Artists 1549016193 Y 2021-12-17 17:37:27 0
65912 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374814 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806757 N 65927 Copyright Control Various Artists 1517376169 Y 2021-12-17 17:37:27 0
65913 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374814 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806758 N 65927 Copyright Control Various Artists 1517376189 Y 2021-12-17 17:37:27 0
65914 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374815 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806759 N 65927 Copyright Control Various Artists 1517376206 Y 2021-12-17 17:37:27 0
65915 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374815 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806760 N 65927 Copyright Control Various Artists 1517376226 Y 2021-12-17 17:37:27 0
65916 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374815 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806761 N 65927 Copyright Control Various Artists 1517376244 Y 2021-12-17 17:37:27 0
65917 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374815 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806762 N 65927 Copyright Control Various Artists 1517376264 Y 2021-12-17 17:37:27 0
65918 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374815 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806763 N 65927 Copyright Control Various Artists 1517376282 Y 2021-12-17 17:37:27 0
65919 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374816 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806764 N 65927 Copyright Control Various Artists 1517376301 Y 2021-12-17 17:37:27 0
65920 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374816 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806765 N 65927 Copyright Control Various Artists 1517376319 Y 2021-12-17 17:37:27 0
65921 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374816 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806766 N 65927 Copyright Control Various Artists 1517376339 Y 2021-12-17 17:37:27 0
65922 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374816 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806767 N 65927 Copyright Control Various Artists 1517376359 Y 2021-12-17 17:37:27 0
65923 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374816 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806768 N 65927 Copyright Control Various Artists 1517376380 Y 2021-12-17 17:37:27 0
65924 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374816 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806769 N 65927 Copyright Control Various Artists 1549016196 Y 2021-12-17 17:37:27 0
65925 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374816 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806770 N 65927 Copyright Control Various Artists 1517376418 Y 2021-12-17 17:37:27 0
65926 DCHVA004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1517374816 0 Y N N B N R Y N N Y 10 1517356800 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 5054283463200 GBKQU1806771 N 65927 Copyright Control Various Artists 1517376439 Y 2021-12-17 17:37:27 0