SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    47805, 47804, 47803, 47802, 47801, 47800, 
    47799, 47798, 47797, 47796, 47795, 
    47794, 47793, 47792, 47791, 47790, 
    47789, 47788, 47787, 47786, 47785, 
    47784, 47783, 47782, 47781
  )

Query time 0.00044

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
47781 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1587170 N 47806 Copyright Control Various Artists 1452857780 Y 2021-12-17 17:37:27 0
47782 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1578912 N 47806 Copyright Control Various Artists 1452857788 Y 2021-12-17 17:37:27 0
47783 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1589203 N 47806 Copyright Control Various Artists 1452857791 Y 2021-12-17 17:37:27 0
47784 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1574764 N 47806 Copyright Control Various Artists 1452857795 Y 2021-12-17 17:37:27 0
47785 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1572020 N 47806 Copyright Control Various Artists 1452857798 Y 2021-12-17 17:37:27 0
47786 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 UK4FJ1500020 N 47806 Copyright Control Various Artists 1452857801 Y 2021-12-17 17:37:27 0
47787 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1574711 N 47806 Copyright Control Various Artists 1452857804 Y 2021-12-17 17:37:27 0
47788 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1567997 N 47806 Copyright Control Various Artists 1452857806 Y 2021-12-17 17:37:27 0
47789 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1576797 N 47806 Copyright Control Various Artists 1453967653 Y 2021-12-17 17:37:27 0
47790 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1572101 N 47806 Copyright Control Various Artists 1452857812 Y 2021-12-17 17:37:27 0
47791 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1572017 N 47806 Copyright Control Various Artists 1452857815 Y 2021-12-17 17:37:27 0
47792 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1575501 N 47806 Copyright Control Various Artists 1452857822 Y 2021-12-17 17:37:27 0
47793 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1574710 N 47806 Copyright Control Various Artists 1452857829 Y 2021-12-17 17:37:27 0
47794 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1571669 N 47806 Copyright Control Various Artists 1452857831 Y 2021-12-17 17:37:27 0
47795 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1550935 N 47806 Copyright Control Various Artists 1452857834 Y 2021-12-17 17:37:27 0
47796 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1579069 N 47806 Copyright Control Various Artists 1452857838 Y 2021-12-17 17:37:27 0
47797 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1552008 N 47806 Copyright Control Various Artists 1452857844 Y 2021-12-17 17:37:27 0
47798 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 UK4FJ1500018 N 47806 Copyright Control Various Artists 1452857847 Y 2021-12-17 17:37:27 0
47799 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1570966 N 47806 Copyright Control Various Artists 1452857850 Y 2021-12-17 17:37:27 0
47800 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 UK4FJ1500016 N 47806 Copyright Control Various Artists 1452857853 Y 2021-12-17 17:37:27 0
47801 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1548465 N 47806 Copyright Control Various Artists 1452857856 Y 2021-12-17 17:37:27 0
47802 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1555423 N 47806 Copyright Control Various Artists 1452857859 Y 2021-12-17 17:37:27 0
47803 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1549410 N 47806 Copyright Control Various Artists 1452857862 Y 2021-12-17 17:37:27 0
47804 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 GBKQU1576740 N 47806 Copyright Control Various Artists 1452857864 Y 2021-12-17 17:37:27 0
47805 LWWHAHC11 P A 1 1.69 1 0.000 0 0 0 0.00 0 1453939200 0 Y N N B N R Y N N Y 10 1453939200 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 5054282103961 UK4FJ1500014 N 47806 Copyright Control Various Artists 1452857867 Y 2021-12-17 17:37:27 0