SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    67257, 67256, 66534, 67158, 67208, 67196, 
    67195, 66979, 66878, 66812, 66787, 
    66527, 65967, 66881, 67016, 67014, 
    66981, 66980, 66784, 66622, 66621, 
    66393, 61786, 66986, 66985, 66978, 
    66846, 66843, 66842, 66783, 66780, 
    66286, 66283, 66214, 66779, 65966, 
    66533, 66729, 66594, 66287
  )

Query time 0.00127

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
61786 VCR262 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521763200 0 Y N N B N R Y N N Y 10 1521763200 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 1516037421 Y 2021-12-17 17:37:27 0
65966 IOD052 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521072000 0 Y N N B N R Y N N Y 10 1521072000 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 G Mix 1517601612 Y 2021-12-17 17:37:27 0
65967 IOD053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522278000 0 Y N N B N R Y N N Y 10 1522278000 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 Kimberley Baker 1517601802 Y 2021-12-17 17:37:27 0
66214 PDHH091 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521158400 0 Y N N B N R Y N N Y 10 1521158400 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/Lee/Neale Ben Stevens/Craig Lee/Dave Neale 1518441126 Y 2021-12-17 17:37:27 0
66283 UTHHD022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521158400 0 Y N N B N R Y N N Y 10 1521158400 1523574000 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 5054283431933 GBKQU1801236 N Ultratech Jay Middleton 1518670822 Y 2021-12-17 17:37:27 0
66286 TT006b P A 1 1.69 1 0.000 0 0 0 0.00 0 1521158400 0 Y N N B N R Y N N Y 10 1521158400 1522364400 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 5054283474695 GBKQU1808951 N Tuff Trax Scott Chaney & Dave Pearson 1518670823 Y 2021-12-17 17:37:27 0
66287 AAA157 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520553600 0 Y N N B N R Y N N Y 10 1520553600 1521763200 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 5054283498639 GBKQU1813678 N Ahura Mazda Recordings NITRO Burak Harsitlioglu 1518670823 Y 2021-12-17 17:37:27 0
66393 TT015a P A 1 1.69 1 0.000 0 0 0 0.00 0 1521763200 0 Y N N B N R Y N N Y 10 1521763200 1522969200 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 5054283474688 GBKQU1808950 N Tuff Trax Matt Wade, Steve Taylor & Simon Lowe 1519275601 Y 2021-12-17 17:37:27 0
66527 TT016a P A 1 1.69 1 0.000 0 0 0 0.00 0 1522364400 0 Y N N B N R Y N N Y 10 1522364400 1523574000 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 5054283523430 GBKQU1818643 N Tuff Trax Craig Stoneham 1519880404 Y 2021-12-17 17:37:27 0
66533 SS075 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520812800 0 Y N N B N R Y N N Y 10 1520812800 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 Slingshot Recodings Paul Norris/Jeff Payne 1519912937 Y 2021-12-17 17:37:27 0
66534 SS076 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522623600 0 Y N N B N R Y N N Y 10 1522623600 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 Slingshot Recodings Paul Norris 1519912939 Y 2021-12-17 17:37:27 0
66594 FR053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520553600 0 Y N N B N R Y N N Y 10 1520553600 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 Wade 1641474068 Y 09/03/2018 08/04/2018 2021-12-17 17:37:27 0
66621 Cheek364 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521763200 0 Y N N B N R Y N N Y 10 1521763200 1522969200 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 5054283546057 GBKQU1822819 N Copyright Control Alan Cowen, Glen Walker 1520398806 Y 2021-12-17 17:37:27 0
66622 Cheek364 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521763200 0 Y N N B N R Y N N Y 10 1521763200 1522969200 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 5054283546057 GBKQU1822820 N Copyright Control Alan Cowen, Glen Walker 1520398806 Y 2021-12-17 17:37:27 0
66729 MHR063 P A 1 1.69 1 0.000 0 0 0 0.00 0 1520645720 0 Y N N B N R Y N N Y 10 1520640000 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 Infinite Loops/MCPS Michael Franklin 1520646321 Y 2021-12-17 17:37:27 0
66779 HELL006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521072000 0 Y N N B N R Y N N Y 10 1521072000 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 Dave Owens / James Jackson 1642352400 Y 15/03/2018 14/04/2018 2021-12-17 17:37:27 0
66780 HWR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521158400 0 Y N N B N R Y N N Y 10 1521158400 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 Les Spalding 1520938608 Y 2021-12-17 17:37:27 0
66783 FBR289 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521158400 0 Y N N B N R Y N N Y 10 1521158400 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 1520949528 Y 2021-12-17 17:37:27 0
66784 FBR290 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521763200 0 Y N N B N R Y N N Y 10 1521763200 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 1520949577 Y 2021-12-17 17:37:27 0
66787 FBR292 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522364400 0 Y N N B N R Y N N Y 10 1522364400 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 / James Valentine 1520949792 Y 2021-12-17 17:37:27 0
66812 TBF007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522364400 0 Y N N B N R Y N N Y 10 1522364400 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 The Bounce Factory Jamie Russell / Justin Daniels / Dave Owens / Phil Critchley 1521194331 Y 2021-12-17 17:37:27 0
66842 TND013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521158400 0 Y N N B N R Y N N Y 10 1521158400 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 Sean Taylor 1521156619 Y 2021-12-17 17:37:27 0
66843 TND013A P A 1 1.69 1 0.000 0 0 0 0.00 0 1521158400 0 Y N N B N R Y N N Y 10 1521158400 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 1524763756 Y 2021-12-17 17:37:27 0
66846 TBF006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521192370 0 Y N N B N R Y N N Y 10 1521158400 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 TBF 1521192621 Y 2021-12-17 17:37:27 0
66878 BMR057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522364400 0 Y N N B N R Y N N Y 10 1522364400 1523574000 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 5054283566000 GBKQU1826595 N Alexei Reynolds (c) 2018 Alexei Reynolds (c) 2018 1521262828 Y 2021-12-17 17:37:27 0
66881 HOT001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522018800 0 Y N N B N R Y N N Y 10 1522018800 1523228400 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 5054283561722 GBKQU1825670 N Hot Box Digital Matt Wade & Kenny Seear 1521349203 Y 2021-12-17 17:37:27 0
66978 TMP101 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521466295 0 Y N N B N R Y N N Y 10 1521417600 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 Robert Moulder & Matt Clarkson 1521467122 Y 2021-12-17 17:37:27 0
66979 TMP102 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522364400 0 Y N N B N R Y N N Y 10 1522364400 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 Aynsley Byrne, Jayson Joiner & Matt Clarkson 1521466409 Y 2021-12-17 17:37:27 0
66980 HWR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521763200 0 Y N N B N R Y N N Y 10 1521763200 0 N 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 Hooverweight Records Dan Dyson 1711483443 Y 2021-12-17 17:37:27 0
66981 HWR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521763200 0 Y N N B N R Y N N Y 10 1521763200 0 N 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 Hooverweight Records Dan Dyson 1711483448 Y 2021-12-17 17:37:27 0
66985 420001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521577051 0 Y N N B N R Y N N Y 10 1521504000 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 Copyright Control Kid Sample 1521577822 Y 2021-12-17 17:37:27 0
66986 420002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521577982 0 Y N N B N R Y N N Y 10 1521504000 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 Karim/Riggsy Karim/Riggsy 1521578718 Y 2021-12-17 17:37:27 0
67014 JAM021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521763200 0 Y N N B N R Y N N Y 10 1521763200 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 UKG3L1800002 N Copyright Control Tom Basquil 1521743710 Y 2021-12-17 17:37:27 0
67016 HWR010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1521763200 0 Y N N B N R Y N N Y 10 1521763200 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 Ross Baldwin 1522053020 Y 2021-12-17 17:37:27 0
67158 DT0086 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522450800 0 Y N N B N R Y N N Y 10 1522450800 1524870000 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 5054283541748 GBKQU1822034 N Devious Trax Marc Lewis 1522213217 Y 2021-12-17 17:37:27 0
67195 TND014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522364400 0 Y N N B N R Y N N Y 10 1522364400 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 Lowe 1522316457 Y 2021-12-17 17:37:27 0
67196 SSD030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522364400 0 Y N N B N R Y N N Y 10 1522364400 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 Gareth Robers/Matt Clarkson 1546877264 Y 2021-12-17 17:37:27 0
67208 EFT006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522413722 0 Y N N B N R Y N N Y 10 1522364400 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 Stephen Walker 1522413920 Y 2021-12-17 17:37:27 0
67256 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681377 0 Y N N B N R Y N N Y 10 1522623600 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 Adam Martin / Mark Tench 1522682121 Y 2021-12-17 17:37:27 0
67257 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681418 0 Y N N B N R Y N N Y 10 1522623600 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 Adam Martin / Mark Tench 1522682141 Y 2021-12-17 17:37:27 0