SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    74537, 74536, 74535, 74534, 74533, 74532, 
    74531, 74530, 74529, 74528, 74527, 
    74526, 74525, 74524, 74523, 74522, 
    74521, 74520, 74519, 74518
  )

Query time 0.00037

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
74518 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477333 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Claire Browne 1550477721 Y 2021-12-17 17:37:27 0
74519 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477362 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control James Nardi / Ross Homson 1550477742 Y 2021-12-17 17:37:27 0
74520 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477391 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Podge Mccabe 1550477763 Y 2021-12-17 17:37:27 0
74521 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477423 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Steve Maynard 1550477781 Y 2021-12-17 17:37:27 0
74522 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477464 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Rich Piper 1550477801 Y 2021-12-17 17:37:27 0
74523 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477503 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Paul Norris / Matt Mara 1550477823 Y 2021-12-17 17:37:27 0
74524 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477536 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Mike Taylor 1550477843 Y 2021-12-17 17:37:27 0
74525 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477563 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Ian Fitzpatrick 1550477864 Y 2021-12-17 17:37:27 0
74526 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477603 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Darrell White / Nick Hayward 1550477883 Y 2021-12-17 17:37:27 0
74527 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477627 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control James Nardi 1550477904 Y 2021-12-17 17:37:27 0
74528 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477652 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Olly Lennox 1550477924 Y 2021-12-17 17:37:27 0
74529 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477676 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Frank Farrell 1550477942 Y 2021-12-17 17:37:27 0
74530 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477705 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Dan Andres / James Nardi 1550478621 Y 2021-12-17 17:37:27 0
74531 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477744 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Ian Fitzpatrick / James Nardi 1550478641 Y 2021-12-17 17:37:27 0
74532 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477774 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Ian Fitzpatrick 1550478662 Y 2021-12-17 17:37:27 0
74533 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477819 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control James Hill 1550478683 Y 2021-12-17 17:37:27 0
74534 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477852 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Ian Fitzpatrick 1550478706 Y 2021-12-17 17:37:27 0
74535 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477882 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Jason Pepper / Kevin Byrne 1550478728 Y 2021-12-17 17:37:27 0
74536 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477909 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Mitch Doig 1550478749 Y 2021-12-17 17:37:27 0
74537 TTB03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550477959 0 Y N N B N R Y N N Y 10 1550448000 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;} 4 N Copyright Control Jason Pepper / Claire Browne / James Nardi 1550478769 Y 2021-12-17 17:37:27 0