SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    43849, 43758, 43767, 43766, 43737, 43620, 
    43567, 43566, 43648, 43512, 43400, 
    43399, 43398, 43397, 43430, 43429, 
    43428, 43427, 43426, 43237
  )

Query time 0.00047

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 20 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
43237 DNZF103 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435186800 0 Y N N B N R Y N N Y 10 1435186800 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 5054281745995 GBKQU1553695 N DNZ Records Donna Marie 1433307630 Y 2021-12-17 17:37:27 0
43397 DNZ158 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435705200 0 Y N N B N R Y N N Y 10 1435705200 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 5054281755949 GBKQU1555742 N DNZ Records Sarah Jane 1433912422 Y 2021-12-17 17:37:27 0
43398 DNZ158 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435705200 0 Y N N B N R Y N N Y 10 1435705200 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 5054281755949 GBKQU1555743 N DNZ Records Sarah Jane 1433912425 Y 2021-12-17 17:37:27 0
43399 DNZ158 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435705200 0 Y N N B N R Y N N Y 10 1435705200 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 5054281755949 GBKQU1555745 N DNZ Records Sarah Jane 1433912428 Y 2021-12-17 17:37:27 0
43400 DNZ158 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435705200 0 Y N N B N R Y N N Y 10 1435705200 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 5054281755949 GBKQU1555746 N DNZ Records Sarah Jane 1433912435 Y 2021-12-17 17:37:27 0
43426 DNZ157 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435618800 0 Y N N B N R Y N N Y 10 1435618800 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 5054281758124 GBKQU1556258 N DNZ Records Adele 1434085213 Y 2021-12-17 17:37:27 0
43427 DNZ157 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435618800 0 Y N N B N R Y N N Y 10 1435618800 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 5054281758124 GBKQU1556259 N DNZ Records Adele 1434085216 Y 2021-12-17 17:37:27 0
43428 DNZ157 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435618800 0 Y N N B N R Y N N Y 10 1435618800 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 5054281758124 GBKQU1556260 N DNZ Records Adele 1434085218 Y 2021-12-17 17:37:27 0
43429 DNZ157 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435618800 0 Y N N B N R Y N N Y 10 1435618800 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 5054281758124 GBKQU1556261 N DNZ Records Adele 1434085221 Y 2021-12-17 17:37:27 0
43430 DNZ157 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435618800 0 Y N N B N R Y N N Y 10 1435618800 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 5054281758124 GBKQU1556262 N DNZ Records Adele 1434085224 Y 2021-12-17 17:37:27 0
43512 NT002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435791600 0 Y N N B N R Y N N Y 10 1435791600 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 5054281760240 GBKQU1556774 N Copyright Control NeuroTek 1434171623 Y 2021-12-17 17:37:27 0
43566 DNZ161 P A 1 1.69 1 0.000 0 0 0 0.00 0 1436310000 0 Y N N B N R Y N N Y 10 1436310000 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 5054281768796 GBKQU1558430 N DNZ Records JJ 1434603638 Y 2021-12-17 17:37:27 0
43567 DNZ161 P A 1 1.69 1 0.000 0 0 0 0.00 0 1436310000 0 Y N N B N R Y N N Y 10 1436310000 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 5054281768796 GBKQU1558431 N DNZ Records JJ 1434603646 Y 2021-12-17 17:37:27 0
43620 DNZ162 P A 1 1.69 1 0.000 0 0 0 0.00 0 1436396400 0 Y N N B N R Y N N Y 10 1436396400 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 5054281771253 GBKQU1558881 N DNZ Records Miky One DJ, DJ Kino 1434776410 Y 2021-12-17 17:37:27 0
43648 ACTD068 P A 1 1.69 1 0.000 0 0 0 0.00 0 1435964400 0 Y N N B N R Y N N Y 10 1435964400 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 5054281774179 GBKQU1559500 N Active Sound Records Deejay Laura 1435035623 Y 2021-12-17 17:37:27 0
43737 RE026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1436482800 0 Y N N B N R Y N N Y 10 1436482800 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 5054281778849 GBKQU1560600 N Relay Records Ash, Mush & Dan Diamond 1435208454 Y 2021-12-17 17:37:27 0
43758 ACTD069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437001200 0 Y N N B N R Y N N Y 10 1437001200 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 5054281782167 GBKQU1561251 N Active Sound Records DJ Nillos 1435381203 Y 2021-12-17 17:37:27 0
43766 DR029 P A 1 1.69 1 0.000 0 0 0 0.00 0 1436482800 0 Y N N B N R Y N N Y 10 1436482800 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 5054281781146 GBKQU1561069 N Fitzer Fitzer 1435381228 Y 2021-12-17 17:37:27 0
43767 DNZF104 P A 1 1.69 1 0.000 0 0 0 0.00 0 1436828400 0 Y N N B N R Y N N Y 10 1436828400 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 5054281782242 GBKQU1561268 N DNZ Records Dj Nillos 1435381231 Y 2021-12-17 17:37:27 0
43849 DR030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1437087600 0 Y N N B N R Y N N Y 10 1437087600 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 5054281786356 GBKQU1562152 N Fitzer Fitzer 1435726833 Y 2021-12-17 17:37:27 0