SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    4643, 4641, 4371, 6277, 6210, 6313, 6283, 
    6284, 6205, 6204, 6203, 4973, 6206, 
    4956, 34983, 5183, 5511, 5657, 5368, 
    5364
  )

Query time 0.00049

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
4371 AWSMB009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1332716400 0 Y N N B N R Y N N Y 10 1332716400 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 195596 5052653227902 GBKQU1275119 N 4374 Various Various 1393506091 Y 2021-12-17 17:37:27 0
4641 DEFCA04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1332716400 0 Y N N B N R Y N N Y 10 1332716400 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 152367 5052653204804 GBKQU0909324 N 4650 23rd Precinct & Copyright Control Copyright Control 1393946056 Y 2021-12-17 17:37:27 0
4643 DEFCA04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1332716400 0 Y N N B N R Y N N Y 10 1332716400 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 152369 5052653204804 GBKQU0910910 N 4650 23rd Precinct & Copyright Control Copyright Control 1393948546 Y 2021-12-17 17:37:27 0
4956 UDT31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1328918400 0 Y N N B N R Y N N Y 10 1328918400 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 175591 5052653200547 GBKQU1269267 N Underdog Trax Elivate & Musikal Madness 1393507621 Y 2021-12-17 17:37:27 0
4973 DEFCA09 P A 1 1.69 1 0.000 0 0 0 0.00 0 1330300800 0 Y N N B N R Y N N Y 10 1330300800 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 152477 5052653204798 GBKQU1149039 N 4974 23rd Precinct & Copyright Control Copyright Control 1393510300 Y 2021-12-17 17:37:27 0
5183 AWSM043 P A 1 1.69 1 0.000 0 0 0 0.00 0 1326067200 0 Y N N B N R Y N N Y 10 1326067200 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 166441 5052653173919 GBW7F1100188 N Copyright Control Tom Berry & Zac F 1393508375 Y 2021-12-17 17:37:27 0
5364 DEFCA05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1323043200 0 Y N N B N R Y N N Y 10 1323043200 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 152403 5052653150385 GBKQU1142371 N 5380 23rd Precinct & Copyright Control Various 1393510431 Y 2021-12-17 17:37:27 0
5368 DEFCA05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1323043200 0 Y N N B N R Y N N Y 10 1323043200 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 152407 5052653150385 GBKQU1149039 N 5380 23rd Precinct & Copyright Control Various 1393510309 Y 2021-12-17 17:37:27 0
5511 TT2011002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1323648000 0 Y N N B N R Y N N Y 10 1323648000 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 162185 5052653171625 GBW7F1100164 N 5519 Various Various 1393504149 Y 2021-12-17 17:37:27 0
5657 DEFCA08 P A 1 1.69 1 0.000 0 0 0 0.00 0 1323043200 0 Y N N B N R Y N N Y 10 1323043200 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 152449 5052653173278 GBKQU1149039 N 23rd Precinct & Copyright Control Various 1393509653 Y 2021-12-17 17:37:27 0
6203 YEAH039 P A 1 1.69 1 0.000 0 0 0 0.00 0 1330300800 0 Y N N B N R Y N N Y 10 1330300800 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 176160 5052653209168 GB2P41200109 N Yeah Boi Recordings Dark13, Jamie R, Justin Daniels 1393950933 Y 2021-12-17 17:37:27 0
6204 YEAH039 P A 1 1.69 1 0.000 0 0 0 0.00 0 1330300800 0 Y N N B N R Y N N Y 10 1330300800 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 176161 5052653209168 GB2P41200110 N Yeah Boi Recordings Dark13, Jamie R, Justin Daniels 1393950918 Y 2021-12-17 17:37:27 0
6205 YEAH039 P A 1 1.69 1 0.000 0 0 0 0.00 0 1330300800 0 Y N N B N R Y N N Y 10 1330300800 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 176163 5052653209168 GB2P41200111 N Yeah Boi Recordings Dark13, Jamie R, Justin Daniels 1393950899 Y 2021-12-17 17:37:27 0
6206 UDT32 P A 1 1.69 1 0.000 0 0 0 0.00 0 1330128000 0 Y N N B N R Y N N Y 10 1330128000 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 179175 5052653200516 GBKQU1269264 N Underdog Trax Audox & Cooki 1393950966 Y 2021-12-17 17:37:27 0
6210 UDT39 P A 1 1.69 1 0.000 0 0 0 0.00 0 1331942400 0 Y N N B N R Y N N Y 10 1331942400 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 186696 5052653216227 GBKQU1272411 N Underdog Trax Elivate 1393949130 Y 2021-12-17 17:37:27 0
6277 BAD003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1332201600 0 Y N N B N R Y N N Y 10 1332201600 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 184223 5052653218924 GBKQU1273059 N Copyright Control Charlie Bosh - Charlie Goddard 1393948795 Y 2021-12-17 17:37:27 0
6283 UDT38 P A 1 1.69 1 0.000 0 0 0 0.00 0 1331337600 0 Y N N B N R Y N N Y 10 1331337600 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 186684 5052653216210 GBKQU1272410 N Underdog Trax DJ Ransome 1393949614 Y 2021-12-17 17:37:27 0
6284 BAD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1330560000 0 Y N N B N R Y N N Y 10 1330560000 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 182757 5052653207904 GBKQU1270736 N Copyright Control Fierce DJ's 1393950431 Y 2021-12-17 17:37:27 0
6313 B2T036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1331769600 0 Y N N B N R Y N N Y 10 1331769600 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 173391 5052653218993 GBKQU1273066 N Copyright Control Paul-F & Your DJ's 1393949353 Y 2021-12-17 17:37:27 0
34983 TPS033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1326758400 0 Y N N B N R Y N N Y 10 1326758400 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 5054281092334 GBKQU1429940 N TPS RECORDS Dj Murto & Dejotalberto 1404018006 Y 2021-12-17 17:37:27 0