SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    74539, 74537, 74536, 74535, 74534, 74533, 
    74532, 74531, 74530, 74529, 74528, 
    74527, 74526, 74525, 74524, 74523, 
    74522, 74521, 74520, 74519, 74518, 
    74497, 74462, 74461, 74423, 73854, 
    73847, 73826, 73625, 73600, 73910, 
    73823, 74413, 74412, 74411, 74410, 
    74409, 74408, 74407, 74406
  )

Query time 0.00059

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 40 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
73600 VCR277 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550188800 0 Y N N B N R Y N N Y 10 1550188800 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 Copy Dean Rooker / Lee Mills 1546462797 Y 2021-12-17 17:37:27 0
73625 FBR309 P A 1 1.39 1 0.000 0 0 0 0.00 0 1550188800 0 Y N N B N R Y N N Y 10 1550188800 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;} 4 N Copyright Control Rob Moulder / Matt Clarkson 1546620364 Y 2021-12-17 17:37:27 0
73823 IOD071 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550102400 0 Y N N B N R Y N N Y 10 1550102400 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 Inside Out Digital Steve Clack 1547849815 Y 2021-12-17 17:37:27 0
73826 UTHHD027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550188800 0 Y N N B N R Y N N Y 10 1550188800 1551398400 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 labelworx 5054284178691 GBKQU1904332 N Ultratech Jay Middleton & Danny Haynes 1547874004 Y 2021-12-17 17:37:27 0
73847 TT027a P A 1 1.69 1 0.000 0 0 0 0.00 0 1550188800 0 Y N N B N R Y N N Y 10 1550188800 1551398400 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 labelworx 5054284174129 GBKQU1903431 N Tuff Trax Mark Raine and Sean Taylor 1547874019 Y 2021-12-17 17:37:27 0
73854 AAA179 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550188800 0 Y N N B N R Y N N Y 10 1550188800 1551398400 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;} 3 labelworx 5054284173726 GBKQU1903304 N Ahura Mazda Recordings NITRO Burak Harsitlioglu 1547960404 Y 2021-12-17 17:37:27 0
73910 XTRA136 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550102400 0 Y N N B N R Y N N Y 10 1550102400 1551312000 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 labelworx 5054284192178 GBKQU1907032 N Xtrahard Records Francisco Gaitan 1548306005 Y 2021-12-17 17:37:27 0
74406 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Leon Allen 1549829865 Y 2021-12-17 17:37:27 0
74407 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Dave Owens 1549829890 Y 2021-12-17 17:37:27 0
74408 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 / Wayne Smart 1549829922 Y 2021-12-17 17:37:27 0
74409 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Karim Laamouri 1549829957 Y 2021-12-17 17:37:27 0
74410 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 / Paul Batten 1549829999 Y 2021-12-17 17:37:27 0
74411 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 1549830035 Y 2021-12-17 17:37:27 0
74412 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Batten / Richard Whybrow 1549830077 Y 2021-12-17 17:37:27 0
74413 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Tim Wellings 1549830109 Y 2021-12-17 17:37:27 0
74423 PDHH115 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550188800 0 Y N N B N R Y N N Y 10 1550188800 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 Premonition Digital Pearce/Pearce 1549997184 Y 2021-12-17 17:37:27 0
74461 NITROX102 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550188800 0 Y N N B N R Y N N Y 10 1550188800 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;} 4 N Toolbox Publishing, Hatfish Music James Jackson / Dave Owens 1642451501 Y 15/02/2019 17/03/2019 2021-12-17 17:37:27 0
74462 FR071 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550188800 0 Y N N B N R Y N N Y 10 1550188800 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 Dennis De Grande 1550099083 Y 2021-12-17 17:37:27 0
74497 JAM031 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550272568 0 Y N N B N R Y N N Y 10 1550188800 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 UKG3L1900001 N Copyright Controli Kevin Byrne / Darragh Mulligan 1550273423 Y 2021-12-17 17:37:27 0
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
74539 SC064 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550519845 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 1550520023 Y 2021-12-17 17:37:27 0