SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    101808, 101807, 101806, 101805, 101804, 
    101803, 101802, 101801, 101800, 101799, 
    101798, 101797, 101796, 101795, 101794, 
    101793, 101792, 101791, 101790, 101789, 
    101788, 101787, 101786, 101785, 101784, 
    101783, 101782, 101781, 101780, 101779
  )

Query time 0.00046

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
101779 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204788 N 101809 Copyright Control Various Artists 1642526560 Y 2022-01-18 18:05:27 0
101780 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204789 N 101809 Copyright Control Various Artists 1642526579 Y 2022-01-18 18:05:28 0
101781 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204790 N 101809 Copyright Control Various Artists 1642526597 Y 2022-01-18 18:05:29 0
101782 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204791 N 101809 Copyright Control Various Artists 1642526614 Y 2022-01-18 18:05:29 0
101783 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204792 N 101809 Copyright Control Various Artists 1642526632 Y 2022-01-18 18:05:29 0
101784 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204793 N 101809 Copyright Control Various Artists 1642526653 Y 2022-01-18 18:05:29 0
101785 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204794 N 101809 Copyright Control Various Artists 1642526673 Y 2022-01-18 18:05:30 0
101786 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204795 N 101809 Copyright Control Various Artists 1642526690 Y 2022-01-18 18:05:30 0
101787 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204796 N 101809 Copyright Control Various Artists 1642526709 Y 2022-01-18 18:05:30 0
101788 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204797 N 101809 Copyright Control Various Artists 1642526726 Y 2022-01-18 18:05:30 0
101789 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204798 N 101809 Copyright Control Various Artists 1642526746 Y 2022-01-18 18:05:30 0
101790 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204799 N 101809 Copyright Control Various Artists 1642526764 Y 2022-01-18 18:05:31 0
101791 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204800 N 101809 Copyright Control Various Artists 1642526783 Y 2022-01-18 18:05:31 0
101792 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204801 N 101809 Copyright Control Various Artists 1642526803 Y 2022-01-18 18:05:31 0
101793 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204802 N 101809 Copyright Control Various Artists 1642526822 Y 2022-01-18 18:05:31 0
101794 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204804 N 101809 Copyright Control Various Artists 1642526839 Y 2022-01-18 18:05:31 0
101795 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204805 N 101809 Copyright Control Various Artists 1642526858 Y 2022-01-18 18:05:32 0
101796 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204806 N 101809 Copyright Control Various Artists 1642526878 Y 2022-01-18 18:05:32 0
101797 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204807 N 101809 Copyright Control Various Artists 1642526897 Y 2022-01-18 18:05:32 0
101798 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204808 N 101809 Copyright Control Various Artists 1642526918 Y 2022-01-18 18:05:32 0
101799 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204809 N 101809 Copyright Control Various Artists 1642526937 Y 2022-01-18 18:05:32 0
101800 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204810 N 101809 Copyright Control Various Artists 1642526956 Y 2022-01-18 18:05:33 0
101801 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204811 N 101809 Copyright Control Various Artists 1642526972 Y 2022-01-18 18:05:33 0
101802 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204812 N 101809 Copyright Control Various Artists 1642526991 Y 2022-01-18 18:05:33 0
101803 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204813 N 101809 Copyright Control Various Artists 1642527009 Y 2022-01-18 18:05:33 0
101804 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204814 N 101809 Copyright Control Various Artists 1642527028 Y 2022-01-18 18:05:33 0
101805 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204815 N 101809 Copyright Control Various Artists 1642527046 Y 2022-01-18 18:05:34 0
101806 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204816 N 101809 Copyright Control Various Artists 1642527063 Y 2022-01-18 18:05:34 0
101807 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204817 N 101809 Copyright Control Various Artists 1642527081 Y 2022-01-18 18:05:34 0
101808 HDCHA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1642377600 0 Y N N B N R Y N N Y 10 1642377600 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 5054286410348 GBKQU2204818 N 101809 Copyright Control Various Artists 1642527101 Y 2022-01-18 18:05:34 0