SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    70121, 70812, 70727, 70339, 70697, 70696, 
    70695, 70694, 70640, 70600, 70584, 
    70539, 70432, 70357, 70587, 70586, 
    70583, 70579, 70537, 70493, 70120, 
    69978, 69977, 70358, 70462, 70459, 
    70458, 70433, 69982, 70435, 70434, 
    70362, 70015, 70014, 70235, 70234, 
    70161, 70119, 69980, 69745
  )

Query time 0.00064

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
69745 Cheek386 P A 1 1.69 1 0.000 0 0 0 0.00 0 1535670000 0 Y N N B N R Y N N Y 10 1535670000 1536879600 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 5054283722703 GBKQU1838818 N Copyright Control Rick Eastham, Cat Culliford 1533186002 Y 2021-12-17 17:37:27 0
69977 Cheek385 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536879600 0 Y N N B N R Y N N Y 10 1536879600 1538089200 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 5054283724554 GBKQU1818275 N Copyright Control Dan Evans, Dave O'Connor, Michael Hagan 1534395617 Y 2021-12-17 17:37:27 0
69978 Cheek385 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536879600 0 Y N N B N R Y N N Y 10 1536879600 1538089200 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 5054283724554 GBKQU1838817 N Copyright Control Dan Evans, Dave O'Connor, Michael Hagan 1534395617 Y 2021-12-17 17:37:27 0
69980 TND024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1535670000 0 Y N N B N R Y N N Y 10 1535670000 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 Jon Doe, Miss Detonate 1535706232 Y 2021-12-17 17:37:27 0
69982 DER006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536274800 0 Y N N B N R Y N N Y 10 1536274800 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 Matt Wade, Andy Taylor 1534423635 Y 2021-12-17 17:37:27 0
70014 DB029 P A 1 1.69 1 0.000 0 0 0 0.00 0 1535756400 0 Y N N B N R Y N N Y 10 1535756400 1536966000 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 5054283836950 GBKQU1881662 N Drop Bear Digital Paul Byrd, Alex Calver 1534827601 Y 2021-12-17 17:37:27 0
70015 FILTH001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1535929200 0 Y N N B N R Y N N Y 10 1535929200 1537138800 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 5054283837704 GBKQU1881759 N The Filth Foundry Matt Wade & Gaz.F 1534827602 Y 2021-12-17 17:37:27 0
70119 FBR297 P A 1 1.69 1 0.000 0 0 0 0.00 0 1535670000 0 Y N N B N R Y N N Y 10 1535670000 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 Kevin Byrne 1535381246 Y 2021-12-17 17:37:27 0
70120 FBR298 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536879600 0 Y N N B N R Y N N Y 10 1536879600 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 Kevin Byrne 1535381372 Y 2021-12-17 17:37:27 0
70121 FBR299 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538089200 0 Y N N B N R Y N N Y 10 1538089200 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 Kevin Byrne 1535381428 Y 2021-12-17 17:37:27 0
70161 PDHH103 P A 1 1.69 1 0.000 0 0 0 0.00 0 1535670000 0 Y N N B N R Y N N Y 10 1535670000 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/Wade/Taylor Wade/Taylor 1535561140 Y 2021-12-17 17:37:27 0
70234 SSD035 P A 1 1.69 1 0.000 0 0 0 0.00 0 1535670000 0 Y N N B N R Y N N Y 10 1535670000 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 Diamond 1535660905 Y 2021-12-17 17:37:27 0
70235 FR060 P A 1 1.69 1 0.000 0 0 0 0.00 0 1535670000 0 Y N N B N R Y N N Y 10 1535670000 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 Toolbox Publishing Matt Clarkson 1641474765 Y 31/08/2018 30/09/2018 2021-12-17 17:37:27 0
70339 HOT016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537570800 0 Y N N B N R Y N N Y 10 1537570800 1538780400 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 5054283857535 GBKQU1885587 N Hot Box Digital Rat-E 1536123610 Y 2021-12-17 17:37:27 0
70357 FILTH002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537138800 0 Y N N B N R Y N N Y 10 1537138800 1538348400 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 5054283857511 GBKQU1885585 N The Filth Factory Damaged Gudz 1536123615 Y 2021-12-17 17:37:27 0
70358 TBR186 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536534000 0 Y N N B N R Y N N Y 10 1536534000 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 Yellowley / Nikk Geordasis 1536578313 Y 2021-12-17 17:37:27 0
70362 IOD062 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536188400 0 Y N N B N R Y N N Y 10 1536188400 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 Danny Gilligan 1536275681 Y 2021-12-17 17:37:27 0
70432 KD003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537398000 0 Y N N B N R Y N N Y 10 1537398000 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 danny clark danny clark 1536571425 Y 2021-12-17 17:37:27 0
70433 FR061 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536274800 0 Y N N B N R Y N N Y 10 1536274800 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 Toolbox Publishing Rob Yellowley 1641474803 Y 07/09/2018 07/10/2018 2021-12-17 17:37:27 0
70434 420008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536273626 0 Y N N B N R Y N N Y 10 1536188400 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 Copyright Co N Miss Adrenaline Miss Adrenaline 1536273922 Y 2021-12-17 17:37:27 0
70435 420007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536274150 0 Y N N B N R Y N N Y 10 1536188400 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 Copyright Co N AL G Alistair Murdoch 1536274820 Y 2021-12-17 17:37:27 0
70458 VCR270 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536307803 0 Y N N B N R Y N N Y 10 1536274800 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 Kevin Byrne 1536308120 Y 2021-12-17 17:37:27 0
70459 TDOG117 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536377406 0 Y N N B N R Y N N Y 10 1536361200 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 Hatfish Dave Owens 1536420680 Y 2021-12-17 17:37:27 0
70462 RPR178 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536447600 0 Y N N B N R Y N N Y 10 1536447600 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 GBXME0800178 N none Scott Chaney/Dave Pearson 1536447693 Y 2021-12-17 17:37:27 0
70493 PDHH104 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536879600 0 Y N N B N R Y N N Y 10 1536879600 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 / Liddell Liddell 1536684331 Y 2021-12-17 17:37:27 0
70537 TND025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536879600 0 Y N N B N R Y N N Y 10 1536879600 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 Simon Mowling, Emma Nate 1536775453 Y 2021-12-17 17:37:27 0
70539 DER007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537484400 0 Y N N B N R Y N N Y 10 1537484400 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 NeveRuMinD 1536776239 Y 2021-12-17 17:37:27 0
70579 TDOG118 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536887971 0 Y N N B N R Y N N Y 10 1536879600 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 Hatfish Dave Owens 1536888620 Y 2021-12-17 17:37:27 0
70583 TMP111 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536926545 0 Y N N B N R Y N N Y 10 1536879600 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 Tempo Trax Andrew Holmes 1536927323 Y 2021-12-17 17:37:27 0
70584 TMP112 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537484400 0 Y N N B N R Y N N Y 10 1537484400 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 Tempo Trax Danny Clark 1536926625 Y 2021-12-17 17:37:27 0
70586 RPR179 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536988334 0 Y N N B N R Y N N Y 10 1536966000 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 GBXME0800179 N none Mark Heyes 1536988542 Y 2021-12-17 17:37:27 0
70587 RPR180 P A 1 1.69 1 0.000 0 0 0 0.00 0 1536988441 0 Y N N B N R Y N N Y 10 1536966000 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 GBXME0800180 N none Mark Heyes 1536988538 Y 2021-12-17 17:37:27 0
70600 FR062 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537484400 0 Y N N B N R Y N N Y 10 1537484400 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 Toolbox Publishing Rob Yellowley 1641474852 Y 21/09/2018 21/10/2018 2021-12-17 17:37:27 0
70640 UBT014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537484400 0 Y N N B N R Y N N Y 10 1537484400 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 Unbounded Traxx Mischief Duo 1537389996 Y 2021-12-17 17:37:27 0
70694 JAM027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537484400 0 Y N N B N R Y N N Y 10 1537484400 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 UKG3L1800007 N Copyright Control Leighton Smith 1537517285 Y 2021-12-17 17:37:27 0
70695 TDOG119 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537496104 0 Y N N B N R Y N N Y 10 1537484400 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 Hatfish Dave Owens 1537497018 Y 2021-12-17 17:37:27 0
70696 TDOG120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537496150 0 Y N N B N R Y N N Y 10 1537484400 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 Hatfish Dave Owens 1537497036 Y 2021-12-17 17:37:27 0
70697 TDOG121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537496198 0 Y N N B N R Y N N Y 10 1537484400 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 Hatfish Dave Owens 1537497055 Y 2021-12-17 17:37:27 0
70727 RPR181 P A 1 1.69 1 0.000 0 0 0 0.00 0 1537605349 0 Y N N B N R Y N N Y 10 1537570800 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 GBXME0800181 N none Mark Heyes 1537605920 Y 2021-12-17 17:37:27 0
70812 IOD065 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538002800 0 Y N N B N R Y N N Y 10 1538002800 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 Jolene Chambers 1537856582 Y 2021-12-17 17:37:27 0