SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    73780, 73779, 73756, 73689, 73597, 73339, 
    73242, 73628, 73776, 73775, 73774, 
    73773, 73772, 73771, 73770, 73769, 
    73768, 73767, 73766, 73765, 73764, 
    73763, 73762, 73761, 73760, 73759, 
    73288, 73311, 73283, 73282, 73281, 
    73280, 73279, 73278, 73624, 73596, 
    73595, 73338, 73216, 73215
  )

Query time 0.00058

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
73215 CheekA38 P A 1 1.69 1 0.000 0 0 0 0.00 0 1546560000 0 Y N N B N R Y N N Y 10 1546560000 1547769600 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 5054283770667 GBKQU1860022 N 73216 Copyright Control Various Artists 1543986020 Y 2021-12-17 17:37:27 0
73216 CheekA38 P A 1 8.99 1 0.000 0 0 0 0.00 0 1546560000 0 Y N N B N R Y N N Y 10 1546560000 1547769600 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;} 13 labelworx 5054283770667 Y 1743769338 Y 2021-12-17 17:37:27 0
73242 HWR015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547769600 0 Y N N B N R Y N N Y 10 1547769600 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 UK/LD7/19/00 N Copyright Control Ross Baldwin 1544302862 Y 2021-12-17 17:37:27 0
73278 Cheek407 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547164800 0 Y N N B N R Y N N Y 10 1547164800 1548374400 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 5054283988956 GBKQU1881855 N Copyright Control Joe Longbottom, Micheal Galvin, Daniel Clark 1544677203 Y 2021-12-17 17:37:27 0
73279 Cheek407 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547164800 0 Y N N B N R Y N N Y 10 1547164800 1548374400 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 5054283988956 GBKQU1881857 N Copyright Control Joe Longbottom, Micheal Galvin, Daniel Clark 1544677204 Y 2021-12-17 17:37:27 0
73280 Cheek407 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547164800 0 Y N N B N R Y N N Y 10 1547164800 1548374400 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 5054283988956 GBKQU1868428 N Copyright Control Joe Longbottom, Micheal Galvin, Daniel Clark 1544677204 Y 2021-12-17 17:37:27 0
73281 Cheek407 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547164800 0 Y N N B N R Y N N Y 10 1547164800 1548374400 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 5054283988956 GBLV61809046 N Copyright Control Joe Longbottom, Micheal Galvin, Daniel Clark 1544677204 Y 2021-12-17 17:37:27 0
73282 Cheek407 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547164800 0 Y N N B N R Y N N Y 10 1547164800 1548374400 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 5054283988956 GBLV61809047 N Copyright Control Joe Longbottom, Micheal Galvin, Daniel Clark 1544677204 Y 2021-12-17 17:37:27 0
73283 Cheek407 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547164800 0 Y N N B N R Y N N Y 10 1547164800 1548374400 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 5054283988956 GBLV61809048 N Copyright Control Joe Longbottom, Micheal Galvin, Daniel Clark 1544677204 Y 2021-12-17 17:37:27 0
73288 TT026a P A 1 1.69 1 0.000 0 0 0 0.00 0 1547251200 0 Y N N B N R Y N N Y 10 1547251200 1548460800 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 5054284125367 GBLV61815934 N Tuff Trax Craig Stoneham 1544763602 Y 2021-12-17 17:37:27 0
73311 DER15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547164800 0 Y N N B N R Y N N Y 10 1547164800 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 Leigh Jones 1544788786 Y 2021-12-17 17:37:27 0
73338 FBR306 P A 1 1.69 1 0.000 0 0 0 0.00 0 1546560000 0 Y N N B N R Y N N Y 10 1546560000 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 Smith 1544994452 Y 2021-12-17 17:37:27 0
73339 FBR307 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547769600 0 Y N N B N R Y N N Y 10 1547769600 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 Mark Tench 1544994499 Y 2021-12-17 17:37:27 0
73595 PDHH112 P A 1 1.69 1 0.000 0 0 0 0.00 0 1546560000 0 Y N N B N R Y N N Y 10 1546560000 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/Moore Moore 1546451147 Y 2021-12-17 17:37:27 0
73596 VCR274 P A 1 1.69 1 0.000 0 0 0 0.00 0 1546560000 0 Y N N B N R Y N N Y 10 1546560000 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 1546462464 Y 2021-12-17 17:37:27 0
73597 VCR275 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547769600 0 Y N N B N R Y N N Y 10 1547769600 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 Wayne German 1546462520 Y 2021-12-17 17:37:27 0
73624 TBR190 P A 1 1.39 1 0.000 0 0 0 0.00 0 1546560000 0 Y N N B N R Y N N Y 10 1546560000 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 Nikk Geordasis / Chloe McManoman 1546614571 Y 2021-12-17 17:37:27 0
73628 HOT022 P A 1 1.39 1 0.000 0 0 0 0.00 0 1547596800 0 Y N N B N R Y N N Y 10 1547596800 1548806400 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 5054284155524 GBKQU1900009 N Hot Box Digital D-Fi 1546620358 Y 2021-12-17 17:37:27 0
73689 DB031 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547769600 0 Y N N B N R Y N N Y 10 1547769600 1548979200 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 5054284163581 GBKQU1901411 N Drop Bear Digital Rob Yellowley 1547010006 Y 2021-12-17 17:37:27 0
73756 DOR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547769600 0 Y N N B N R Y N N Y 10 1547769600 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 Nick Edwards 1547420254 Y 2021-12-17 17:37:27 0
73759 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547583810 0 Y N N B N R Y N N Y 10 1547510400 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 Leighton Smith 1547584222 Y 2021-12-17 17:37:27 0
73760 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547583850 0 Y N N B N R Y N N Y 10 1547510400 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 / Aaron Langstaff 1547584246 Y 2021-12-17 17:37:27 0
73761 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547583949 0 Y N N B N R Y N N Y 10 1547510400 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 Glazby 1547584267 Y 2021-12-17 17:37:27 0
73762 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547583990 0 Y N N B N R Y N N Y 10 1547510400 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 Mitchell James 1547584287 Y 2021-12-17 17:37:27 0
73763 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584035 0 Y N N B N R Y N N Y 10 1547510400 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 Chris Waddleton 1547584308 Y 2021-12-17 17:37:27 0
73764 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584165 0 Y N N B N R Y N N Y 10 1547510400 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 / Kirsty Gannon 1547584329 Y 2021-12-17 17:37:27 0
73765 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584213 0 Y N N B N R Y N N Y 10 1547510400 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 Glazby / Paul Maddox 1547585119 Y 2021-12-17 17:37:27 0
73766 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584254 0 Y N N B N R Y N N Y 10 1547510400 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 / Paul Norris 1547585141 Y 2021-12-17 17:37:27 0
73767 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584358 0 Y N N B N R Y N N Y 10 1547510400 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 / Dave Neale 1547585160 Y 2021-12-17 17:37:27 0
73768 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584408 0 Y N N B N R Y N N Y 10 1547510400 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 Truelove Music Paul King / Bianca Eglington 1547585182 Y 2021-12-17 17:37:27 0
73769 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584452 0 Y N N B N R Y N N Y 10 1547510400 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 Jeff Payne / Mike Taylor 1547585202 Y 2021-12-17 17:37:27 0
73770 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584492 0 Y N N B N R Y N N Y 10 1547510400 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 Justin Charge 1547585221 Y 2021-12-17 17:37:27 0
73771 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584554 0 Y N N B N R Y N N Y 10 1547510400 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 Adrian Buss 1547585244 Y 2021-12-17 17:37:27 0
73772 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584592 0 Y N N B N R Y N N Y 10 1547510400 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 Kirsty Walker / Ryan Handley 1547585263 Y 2021-12-17 17:37:27 0
73773 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584643 0 Y N N B N R Y N N Y 10 1547510400 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 Jeremy Winters / Charlie Lyons 1547585283 Y 2021-12-17 17:37:27 0
73774 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584679 0 Y N N B N R Y N N Y 10 1547510400 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 Pickup / Myles Davies 1547585302 Y 2021-12-17 17:37:27 0
73775 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584716 0 Y N N B N R Y N N Y 10 1547510400 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 1547585321 Y 2021-12-17 17:37:27 0
73776 VCRB2018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547584780 0 Y N N B N R Y N N Y 10 1547510400 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 Danny Clark / Matt Clarkson 1547585343 Y 2021-12-17 17:37:27 0
73779 F4A008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547769600 0 Y N N B N R Y N N Y 10 1547769600 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 Alistair McMeechan 1547653886 Y 2021-12-17 17:37:27 0
73780 PDHH113 P A 1 1.69 1 0.000 0 0 0 0.00 0 1547769600 0 Y N N B N R Y N N Y 10 1547769600 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/Milburn Milburn 1547658307 Y 2021-12-17 17:37:27 0