SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    77716, 77715, 77714, 77713, 77712, 77711, 
    77710, 77709, 77708, 77707, 77706, 
    77705, 77704, 77703, 77702, 77701, 
    77700, 77699, 77698, 77697, 77696, 
    77695, 77694, 77693, 77692, 77691, 
    77690, 77689
  )

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 28 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
77689 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723761 N 77717 Copyright Control Various Artists 1560405624 Y 2021-12-17 17:37:27 0
77690 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723762 N 77717 Copyright Control Various Artists 1560405642 Y 2021-12-17 17:37:27 0
77691 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723763 N 77717 Copyright Control Various Artists 1560405664 Y 2021-12-17 17:37:27 0
77692 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723764 N 77717 Copyright Control Various Artists 1560405685 Y 2021-12-17 17:37:27 0
77693 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723765 N 77717 Copyright Control Various Artists 1560405704 Y 2021-12-17 17:37:27 0
77694 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723767 N 77717 Copyright Control Various Artists 1560405724 Y 2021-12-17 17:37:27 0
77695 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723768 N 77717 Copyright Control Various Artists 1560405743 Y 2021-12-17 17:37:27 0
77696 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723769 N 77717 Copyright Control Various Artists 1560405765 Y 2021-12-17 17:37:27 0
77697 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723770 N 77717 Copyright Control Various Artists 1560405786 Y 2021-12-17 17:37:27 0
77698 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723771 N 77717 Copyright Control Various Artists 1560405806 Y 2021-12-17 17:37:27 0
77699 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723772 N 77717 Copyright Control Various Artists 1560405825 Y 2021-12-17 17:37:27 0
77700 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723773 N 77717 Copyright Control Various Artists 1560405847 Y 2021-12-17 17:37:27 0
77701 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723774 N 77717 Copyright Control Various Artists 1560405867 Y 2021-12-17 17:37:27 0
77702 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723775 N 77717 Copyright Control Various Artists 1560405887 Y 2021-12-17 17:37:27 0
77703 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723777 N 77717 Copyright Control Various Artists 1560405906 Y 2021-12-17 17:37:27 0
77704 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723778 N 77717 Copyright Control Various Artists 1560405928 Y 2021-12-17 17:37:27 0
77705 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723779 N 77717 Copyright Control Various Artists 1560405948 Y 2021-12-17 17:37:27 0
77706 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723780 N 77717 Copyright Control Various Artists 1560405967 Y 2021-12-17 17:37:27 0
77707 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723781 N 77717 Copyright Control Various Artists 1560405988 Y 2021-12-17 17:37:27 0
77708 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723782 N 77717 Copyright Control Various Artists 1560406005 Y 2021-12-17 17:37:27 0
77709 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723783 N 77717 Copyright Control Various Artists 1560406026 Y 2021-12-17 17:37:27 0
77710 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723784 N 77717 Copyright Control Various Artists 1560406047 Y 2021-12-17 17:37:27 0
77711 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723786 N 77717 Copyright Control Various Artists 1560406068 Y 2021-12-17 17:37:27 0
77712 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723787 N 77717 Copyright Control Various Artists 1560406088 Y 2021-12-17 17:37:27 0
77713 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723788 N 77717 Copyright Control Various Artists 1560406109 Y 2021-12-17 17:37:27 0
77714 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723789 N 77717 Copyright Control Various Artists 1560406130 Y 2021-12-17 17:37:27 0
77715 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723790 N 77717 Copyright Control Various Artists 1560406151 Y 2021-12-17 17:37:27 0
77716 HDCHVA003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1488758400 0 Y N N B N R Y N N Y 10 1488758400 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 5054284423708 GBKQU1723791 N 77717 Copyright Control Various Artists 1560406174 Y 2021-12-17 17:37:27 0