SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    74051, 74050, 74049, 74048, 74047, 74046, 
    74045, 74044, 74043, 73817, 73816, 
    74713, 74712, 74711, 74710, 74709, 
    74708, 74707, 74706, 74705, 74704, 
    74703, 74702, 74701, 74700, 74699, 
    74698, 74697, 74696, 74695, 74694, 
    74466, 74601, 74540, 74092, 73927, 
    73907, 73906, 73824, 73952
  )

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
73816 DS025A P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 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 Digital Snail Gary O'Connor 1547831761 Y 2021-12-17 17:37:27 0
73817 DS025B P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 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 Digital Snail Gary O'Connor 1547831762 Y 2021-12-17 17:37:27 0
73824 IOD072 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550707200 0 Y N N B N R Y N N Y 10 1550707200 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 Inside Out Digital Marc Lewis 1548927056 Y 2021-12-17 17:37:27 0
73906 Cheek408 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550793600 0 Y N N B N R Y N N Y 10 1550793600 1552003200 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 5054284129211 GBKQU1896006 N Copyright Control Kenneth Edwards, Daryl Simmons, Dave Owens 1548306004 Y 2021-12-17 17:37:27 0
73907 Cheek408 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550793600 0 Y N N B N R Y N N Y 10 1550793600 1552003200 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 5054284129211 GBLV61811581 N Copyright Control Kenneth Edwards, Daryl Simmons, Dave Owens 1548306004 Y 2021-12-17 17:37:27 0
73927 UTHHD028 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550793600 0 Y N N B N R Y N N Y 10 1550793600 1552003200 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 5054284178738 GBKQU1904334 N Ultratech Jay Middleton & Helen Rutter 1548478804 Y 2021-12-17 17:37:27 0
73952 KD007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550620800 0 Y N N B N R Y N N Y 10 1550620800 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 Chaney/Mark Hayes Scott Chaney/Mark Hayes 1549012593 Y 2021-12-17 17:37:27 0
74043 ALBUTH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 1552608000 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 5054283960600 GBLV61804083 N 74055 Ultratech Jay Middleton, Helen Rutter, Ray Jones, Harley Willis, Ben Stevens, Dave Owens. 1548910834 Y 2021-12-17 17:37:27 0
74044 ALBUTH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 1552608000 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 5054283960600 GBLV61804084 N 74055 Ultratech Jay Middleton, Helen Rutter, Ray Jones, Harley Willis, Ben Stevens, Dave Owens. 1548910834 Y 2021-12-17 17:37:27 0
74045 ALBUTH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 1552608000 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 5054283960600 GBLV61804085 N 74055 Ultratech Jay Middleton, Helen Rutter, Ray Jones, Harley Willis, Ben Stevens, Dave Owens. 1548910834 Y 2021-12-17 17:37:27 0
74046 ALBUTH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 1552608000 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 5054283960600 GBLV61804086 N 74055 Ultratech Jay Middleton, Helen Rutter, Ray Jones, Harley Willis, Ben Stevens, Dave Owens. 1548910834 Y 2021-12-17 17:37:27 0
74047 ALBUTH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 1552608000 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 5054283960600 GBLV61804087 N 74055 Ultratech Jay Middleton, Helen Rutter, Ray Jones, Harley Willis, Ben Stevens, Dave Owens. 1548910835 Y 2021-12-17 17:37:27 0
74048 ALBUTH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 1552608000 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 5054283960600 GBLV61804088 N 74055 Ultratech Jay Middleton, Helen Rutter, Ray Jones, Harley Willis, Ben Stevens, Dave Owens. 1548910835 Y 2021-12-17 17:37:27 0
74049 ALBUTH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 1552608000 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 5054283960600 GBLV61804089 N 74055 Ultratech Jay Middleton, Helen Rutter, Ray Jones, Harley Willis, Ben Stevens, Dave Owens. 1548910835 Y 2021-12-17 17:37:27 0
74050 ALBUTH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 1552608000 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 5054283960600 GBLV61804090 N 74055 Ultratech Jay Middleton, Helen Rutter, Ray Jones, Harley Willis, Ben Stevens, Dave Owens. 1548910835 Y 2021-12-17 17:37:27 0
74051 ALBUTH004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551398400 0 Y N N B N R Y N N Y 10 1551398400 1552608000 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 5054283960600 GBLV61804091 N 74055 Ultratech Jay Middleton, Helen Rutter, Ray Jones, Harley Willis, Ben Stevens, Dave Owens. 1548910836 Y 2021-12-17 17:37:27 0
74092 DER018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550793600 0 Y N N B N R Y N N Y 10 1550793600 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 Kirk Povey 1549029262 Y 2021-12-17 17:37:27 0
74466 FILTH007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551052800 0 Y N N B N R Y N N Y 10 1551052800 1552262400 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 5054284230467 GBKQU1914159 N The Filth Foundry Daisy & Miric 1550120403 Y 2021-12-17 17:37:27 0
74540 NEVER026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550793600 0 Y N N B N R Y N N Y 10 1550793600 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 UKCCW1900001 N Copyright Control Wayne German 1550793633 Y 2021-12-17 17:37:27 0
74601 FR072 P A 1 1.69 1 0.000 0 0 0 0.00 0 1550794094 0 Y N N B N R Y N N Y 10 1550793600 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, Copyright Control Rob Yellowley / Rob Healy 1641475602 Y 22/02/2019 24/03/2019 2021-12-17 17:37:27 0
74694 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112531 0 Y N N B N R Y N N Y 10 1551052800 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 Sniper 1551113122 Y 2021-12-17 17:37:27 0
74695 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112570 0 Y N N B N R Y N N Y 10 1551052800 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 1551113143 Y 2021-12-17 17:37:27 0
74696 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112604 0 Y N N B N R Y N N Y 10 1551052800 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 Cp[u Matt Capitani 1551113161 Y 2021-12-17 17:37:27 0
74697 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112637 0 Y N N B N R Y N N Y 10 1551052800 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 Richard C / James Nardi 1551113181 Y 2021-12-17 17:37:27 0
74698 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112669 0 Y N N B N R Y N N Y 10 1551052800 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 1551113202 Y 2021-12-17 17:37:27 0
74699 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112705 0 Y N N B N R Y N N Y 10 1551052800 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 Mikko Moyyky 1551113219 Y 2021-12-17 17:37:27 0
74700 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112729 0 Y N N B N R Y N N Y 10 1551052800 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 Gibson 1551113239 Y 2021-12-17 17:37:27 0
74701 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112766 0 Y N N B N R Y N N Y 10 1551052800 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 David Pym / Lucy Goldberg 1551113259 Y 2021-12-17 17:37:27 0
74702 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112796 0 Y N N B N R Y N N Y 10 1551052800 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 1551113278 Y 2021-12-17 17:37:27 0
74703 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112837 0 Y N N B N R Y N N Y 10 1551052800 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 Brendan Neild 1551113297 Y 2021-12-17 17:37:27 0
74704 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112862 0 Y N N B N R Y N N Y 10 1551052800 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 Harris 1551113316 Y 2021-12-17 17:37:27 0
74705 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112894 0 Y N N B N R Y N N Y 10 1551052800 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 Vicki Bartlett 1551113334 Y 2021-12-17 17:37:27 0
74706 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112945 0 Y N N B N R Y N N Y 10 1551052800 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 1551113356 Y 2021-12-17 17:37:27 0
74707 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551112978 0 Y N N B N R Y N N Y 10 1551052800 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 1551113376 Y 2021-12-17 17:37:27 0
74708 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551113005 0 Y N N B N R Y N N Y 10 1551052800 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 1551113395 Y 2021-12-17 17:37:27 0
74709 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551113027 0 Y N N B N R Y N N Y 10 1551052800 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 1551113414 Y 2021-12-17 17:37:27 0
74710 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551113051 0 Y N N B N R Y N N Y 10 1551052800 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 1551113434 Y 2021-12-17 17:37:27 0
74711 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551113082 0 Y N N B N R Y N N Y 10 1551052800 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 Vicki Bartlett 1551113453 Y 2021-12-17 17:37:27 0
74712 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551113106 0 Y N N B N R Y N N Y 10 1551052800 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 Smart 1551114021 Y 2021-12-17 17:37:27 0
74713 TB04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1551113132 0 Y N N B N R Y N N Y 10 1551052800 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 1551114041 Y 2021-12-17 17:37:27 0