SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    74072, 74071, 74056, 73996, 73977, 73815, 
    73673, 73599, 73598, 73821, 73994, 
    73976, 73740, 73734, 73880, 73819, 
    73484, 73483, 73820, 73874, 73626, 
    73873, 73872, 73871, 73870, 73869, 
    73868, 73867, 73866, 73865, 73864, 
    73863, 73862, 73861, 73860, 73859, 
    73858, 73857, 73856, 73855
  )

Query time 0.00067

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
73483 Cheek404 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548374400 0 Y N N B N R Y N N Y 10 1548374400 1549584000 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 5054283990379 GBKQU1881830 N Polygram Music Publishing Simon Thorne, Tom Jones 1545886801 Y 2021-12-17 17:37:27 0
73484 Cheek404 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548374400 0 Y N N B N R Y N N Y 10 1548374400 1549584000 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 5054283990379 GBKQU1881836 N Polygram Music Publishing Simon Thorne, Tom Jones 1545886801 Y 2021-12-17 17:37:27 0
73598 VCR276 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548979200 0 Y N N B N R Y N N Y 10 1548979200 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 Burgess 1546462663 Y 2021-12-17 17:37:27 0
73599 VCR276 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548979200 0 Y N N B N R Y N N Y 10 1548979200 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 Burgess 1546462730 Y 2021-12-17 17:37:27 0
73626 HOT023 P A 1 1.39 1 0.000 0 0 0 0.00 0 1548028800 0 Y N N B N R Y N N Y 10 1548028800 1549238400 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 labelworx 5054284155531 GBKQU1900010 N Hot Box Digital Rat-E 1546620362 Y 2021-12-17 17:37:27 0
73673 DB032 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548979200 0 Y N N B N R Y N N Y 10 1548979200 1550188800 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 5054284163611 GBKQU1901413 N Drop Bear Digital Ben Ford, Banga Matt, Leigh Jones, Mish Bennetts 1547010002 Y 2021-12-17 17:37:27 0
73734 TGR065 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548460800 0 Y N N B N R Y N N Y 10 1548460800 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 Ant Hornsby 1547149205 Y 2021-12-17 17:37:27 0
73740 FILTH006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548633600 0 Y N N B N R Y N N Y 10 1548633600 1549843200 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 5054284169842 GBKQU1902640 N The Filth Foundry Fredrik Redegard 1547182803 Y 2021-12-17 17:37:27 0
73815 DS024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548979200 0 Y N N B N R Y N N Y 10 1548979200 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 Digital Snail Ben Stevens/Gary O'Connor 1548080425 Y 2021-12-17 17:37:27 0
73819 CAD003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548374400 0 Y N N B N R Y N N Y 10 1548374400 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 Martyn Curran 1547832453 Y 2021-12-17 17:37:27 0
73820 IOD068 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548288000 0 Y N N B N R Y N N Y 10 1548288000 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 1547849521 Y 2021-12-17 17:37:27 0
73821 IOD069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548892800 0 Y N N B N R Y N N Y 10 1548892800 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 Sean Taylor 1547849634 Y 2021-12-17 17:37:27 0
73855 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024207 0 Y N N B N R Y N N Y 10 1547942400 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 Defensive Music Ben Stevens / Mark Tench 1548024322 Y 2021-12-17 17:37:27 0
73856 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024245 0 Y N N B N R Y N N Y 10 1547942400 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 Dean Rooker / Lee Mills 1548024343 Y 2021-12-17 17:37:27 0
73857 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024282 0 Y N N B N R Y N N Y 10 1547942400 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 Defensive Music James Valentine / Ben Stevens 1548024363 Y 2021-12-17 17:37:27 0
73858 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024337 0 Y N N B N R Y N N Y 10 1547942400 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 / Simon Mowling 1548025224 Y 2021-12-17 17:37:27 0
73859 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024374 0 Y N N B N R Y N N Y 10 1547942400 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 Andrew Cullen / Emma Hand 1548025244 Y 2021-12-17 17:37:27 0
73860 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024401 0 Y N N B N R Y N N Y 10 1547942400 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 Marc Lewis 1548025263 Y 2021-12-17 17:37:27 0
73861 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024439 0 Y N N B N R Y N N Y 10 1547942400 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 Andrew Shenton / Matt Smith 1548025283 Y 2021-12-17 17:37:27 0
73862 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024492 0 Y N N B N R Y N N Y 10 1547942400 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 Dina Watson / Simon Stevens 1548025302 Y 2021-12-17 17:37:27 0
73863 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024542 0 Y N N B N R Y N N Y 10 1547942400 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 Dina Watson / Simon Stevens 1548025319 Y 2021-12-17 17:37:27 0
73864 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024588 0 Y N N B N R Y N N Y 10 1547942400 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 Darren Meredith / Elliot Fletcher 1548025340 Y 2021-12-17 17:37:27 0
73865 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024615 0 Y N N B N R Y N N Y 10 1547942400 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 Joseph 1548025359 Y 2021-12-17 17:37:27 0
73866 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024648 0 Y N N B N R Y N N Y 10 1547942400 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 Craig Jones 1548025379 Y 2021-12-17 17:37:27 0
73867 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024683 0 Y N N B N R Y N N Y 10 1547942400 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 1548025400 Y 2021-12-17 17:37:27 0
73868 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024711 0 Y N N B N R Y N N Y 10 1547942400 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 Dark Matter 1548025421 Y 2021-12-17 17:37:27 0
73869 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024742 0 Y N N B N R Y N N Y 10 1547942400 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 1548025442 Y 2021-12-17 17:37:27 0
73870 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024778 0 Y N N B N R Y N N Y 10 1547942400 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 Defensive Music Ben Stevens / Anthony Ratcliffe 1548025463 Y 2021-12-17 17:37:27 0
73871 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024822 0 Y N N B N R Y N N Y 10 1547942400 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 Rick Eastham /Jon Hemming 1548025483 Y 2021-12-17 17:37:27 0
73872 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024929 0 Y N N B N R Y N N Y 10 1547942400 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 Micheal Hagan 1548025501 Y 2021-12-17 17:37:27 0
73873 FBRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548024962 0 Y N N B N R Y N N Y 10 1547942400 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 Patrick Kelly 1548025522 Y 2021-12-17 17:37:27 0
73874 DD144 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548108782 0 Y N N B N R Y N N Y 10 1548028800 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 GBKQU1906600 N Copyright Control Nippy Baines 1548108920 Y 2021-12-17 17:37:27 0
73880 DER016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548374400 0 Y N N B N R Y N N Y 10 1548374400 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 One Foot In The Rave 1548339029 Y 2021-12-17 17:37:27 0
73976 NITROX101 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548761539 0 Y N N B N R Y N N Y 10 1548720000 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 1642451494 Y 29/01/2019 28/02/2019 2021-12-17 17:37:27 0
73977 FR069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548979200 0 Y N N B N R Y N N Y 10 1548979200 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 Andrew Cullen 1548807335 Y 2021-12-17 17:37:27 0
73994 TMP119 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548868864 0 Y N N B N R Y N N Y 10 1548806400 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 Nico Ahlqvist & Matt Clarkson 1548869425 Y 2021-12-17 17:37:27 0
73996 PDHH114 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548979200 0 Y N N B N R Y N N Y 10 1548979200 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/Povey Povey 1549113193 Y 2021-12-17 17:37:27 0
74056 FBR308 P A 1 1.69 1 0.000 0 0 0 0.00 0 1548979200 0 Y N N B N R Y N N Y 10 1548979200 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 / Craig Dunbar 1548959700 Y 2021-12-17 17:37:27 0
74071 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 1549018689 Y 2021-12-17 17:37:27 0
74072 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 1549018725 Y 2021-12-17 17:37:27 0