SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    43273, 43272, 43271, 43270, 43269, 43268, 
    43267, 43266, 43265, 43264, 43263, 
    43262, 43261, 43260, 43259, 43258, 
    43257, 43256, 43255, 43254, 43253, 
    43252, 43251, 43250, 43249
  )

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 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
43249 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1512242 N 43274 Copyright Control Various Artists 1433307676 Y 2021-12-17 17:37:27 0
43250 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1517849 N 43274 Copyright Control Various Artists 1433307679 Y 2021-12-17 17:37:27 0
43251 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1512760 N 43274 Copyright Control Various Artists 1433307681 Y 2021-12-17 17:37:27 0
43252 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 AU5T41205009 N 43274 Copyright Control Various Artists 1433307684 Y 2021-12-17 17:37:27 0
43253 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBPSX1400320 N 43274 Copyright Control Various Artists 1433307686 Y 2021-12-17 17:37:27 0
43254 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1517786 N 43274 Copyright Control Various Artists 1433307689 Y 2021-12-17 17:37:27 0
43255 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1517139 N 43274 Copyright Control Various Artists 1433307691 Y 2021-12-17 17:37:27 0
43256 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1543995 N 43274 Copyright Control Various Artists 1433307694 Y 2021-12-17 17:37:27 0
43257 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1493039 N 43274 Copyright Control Various Artists 1433307697 Y 2021-12-17 17:37:27 0
43258 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1507414 N 43274 Copyright Control Various Artists 1433307699 Y 2021-12-17 17:37:27 0
43259 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1506743 N 43274 Copyright Control Various Artists 1433307702 Y 2021-12-17 17:37:27 0
43260 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1505291 N 43274 Copyright Control Various Artists 1433307704 Y 2021-12-17 17:37:27 0
43261 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1504175 N 43274 Copyright Control Various Artists 1433307707 Y 2021-12-17 17:37:27 0
43262 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1504346 N 43274 Copyright Control Various Artists 1433307709 Y 2021-12-17 17:37:27 0
43263 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1511981 N 43274 Copyright Control Various Artists 1433307712 Y 2021-12-17 17:37:27 0
43264 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1500452 N 43274 Copyright Control Various Artists 1435562716 Y 2021-12-17 17:37:27 0
43265 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 BEB681400647 N 43274 Copyright Control Various Artists 1433307717 Y 2021-12-17 17:37:27 0
43266 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBLV61406063 N 43274 Copyright Control Various Artists 1433307719 Y 2021-12-17 17:37:27 0
43267 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1493133 N 43274 Copyright Control Various Artists 1433307724 Y 2021-12-17 17:37:27 0
43268 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBLV61401850 N 43274 Copyright Control Various Artists 1433307727 Y 2021-12-17 17:37:27 0
43269 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBLV61401122 N 43274 Copyright Control Various Artists 1433307729 Y 2021-12-17 17:37:27 0
43270 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBPSX1400319 N 43274 Copyright Control Various Artists 1433307732 Y 2021-12-17 17:37:27 0
43271 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1491517 N 43274 Copyright Control Various Artists 1433307734 Y 2021-12-17 17:37:27 0
43272 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1499709 N 43274 Copyright Control Various Artists 1433307737 Y 2021-12-17 17:37:27 0
43273 LWWHAHC07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435532400 0 Y N N B N R Y N N Y 10 1435532400 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 5054281745278 GBKQU1499146 N 43274 Copyright Control Various Artists 1433307739 Y 2021-12-17 17:37:27 0