SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    61885, 61787, 61767, 61766, 61519, 61518, 
    61116, 60266, 59324, 61789, 61788, 
    61217, 59956, 61633, 61112, 61007, 
    61006, 60975, 60963, 60854, 60265, 
    61632, 61613, 61523, 61583, 61565, 
    58785, 61509, 61418, 61407, 61406, 
    61391, 61016, 60853, 60264, 59808, 
    61508, 60867, 61409, 61157
  )

Query time 0.00101

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
58785 FBR274 P A 1 1.69 1 0.000 0 0 0 0.00 0 1503702000 0 Y N N B N R Y N N Y 10 1503615600 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 Neil Bee 1503648984 Y 2021-12-17 17:37:27 0
59324 FBR275 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504825200 0 Y N N B N R Y N N Y 10 1504825200 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 / Marc Lewis 1496305538 Y 2021-12-17 17:37:27 0
59808 ENC084 P A 1 1.69 1 0.000 0 0 0 0.00 0 1503615600 0 Y N N B N R Y N N Y 10 1503615600 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 Encoded Wayne Smart / Lee Sylvester 1498238079 Y 2021-12-17 17:37:27 0
59956 TB182 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504479600 0 Y N N B N R Y N N Y 10 1504479600 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 Phil Cogan 1498761367 Y 2021-12-17 17:37:27 0
60264 HIOKT094 P A 1 1.69 1 0.000 0 0 0 0.00 0 1503615600 0 Y N N B N R Y N N Y 10 1503615600 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 1499290090 Y 2021-12-17 17:37:27 0
60265 HIOKT095 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504220400 0 Y N N B N R Y N N Y 10 1504220400 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 / Frank Farrell 1499290221 Y 2021-12-17 17:37:27 0
60266 HIOKT096 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504825200 0 Y N N B N R Y N N Y 10 1504825200 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 1499290334 Y 2021-12-17 17:37:27 0
60853 PDHH076 P A 1 1.69 1 0.000 0 0 0 0.00 0 1503615600 0 Y N N B N R Y N N Y 10 1503615600 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/Mac Phillips/Mac 1501190947 Y 2021-12-17 17:37:27 0
60854 PDHH077 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504220400 0 Y N N B N R Y N N Y 10 1504220400 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/Sheppard/Yellowey/Farrell Richard Sheppard/Robert Yellowey/Frank Farrell 1501191267 Y 2021-12-17 17:37:27 0
60867 DS023A P A 1 1.69 1 0.000 0 0 0 0.00 0 1503529200 0 Y N N B N R Y N N Y 10 1503529200 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 GaryO'Connor 1501485501 Y 2021-12-17 17:37:27 0
60963 FD025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504220400 0 Y N N B N R Y N N Y 10 1504220400 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 Frantic Digital Dawn Lee 1501686892 Y 2021-12-17 17:37:27 0
60975 DB014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504220400 0 Y N N B N R Y N N Y 10 1504220400 1505430000 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 5054283064353 GBKQU1758248 N Drop Bear Digital Sean Taylor, Dale West 1501736443 Y 2021-12-17 17:37:27 0
61006 WLHH3.1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504220400 0 Y N N B N R Y N N Y 10 1504220400 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 Tim Clowes/Jamie Haig 1503493344 Y 2021-12-17 17:37:27 0
61007 WLHH3.2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504220400 0 Y N N B N R Y N N Y 10 1504220400 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 Tim Clowes/Jamie Haig 1503493352 Y 2021-12-17 17:37:27 0
61016 TT010a P A 1 1.69 1 0.000 0 0 0 0.00 0 1503615600 0 Y N N B N R Y N N Y 10 1503615600 1504825200 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 5054283169294 GBKQU1777188 N Tuff Trax Jade Paley, Sam Alame, Scott Chaney and Dave Pearson. 1501995627 Y 2021-12-17 17:37:27 0
61112 TT011a P A 1 1.69 1 0.000 0 0 0 0.00 0 1504220400 0 Y N N B N R Y N N Y 10 1504220400 1505430000 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 5054283169331 GBKQU1777189 N Tuff Trax Marc Lewis 1502254864 Y 2021-12-17 17:37:27 0
61116 TT012a P A 1 1.69 1 0.000 0 0 0 0.00 0 1504825200 0 Y N N B N R Y N N Y 10 1504825200 1506034800 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 5054283172966 GBKQU1777888 N Tuff Trax Adrian Buss 1502341213 Y 2021-12-17 17:37:27 0
61157 DC031 P A 1 1.69 1 0.000 0 0 0 0.00 0 1503270000 0 Y N N B N R Y N N Y 10 1503270000 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 Jay 1502503311 Y 2021-12-17 17:37:27 0
61217 FE093 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504479600 0 Y N N B N R Y N N Y 10 1504479600 1505689200 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 5054283182590 GBKQU1779946 N Fatal Energy Records Danny Hough, James Musgrave 1502773203 Y 2021-12-17 17:37:27 0
61391 MEP002B P A 1 1.69 1 0.000 0 0 0 0.00 0 1503615600 0 Y N N B N R Y N N Y 10 1503615600 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 Mangled Wreck Chords Alan Brown/Nik Georgandis 1503609180 Y 2021-12-17 17:37:27 0
61406 NEVER022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1503615600 0 Y N N B N R Y N N Y 10 1503615600 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 UKCCW1700007 N Copyright Control Wayne Smart/Matt Adam 1503435395 Y 2021-12-17 17:37:27 0
61407 MEP002A P A 1 1.69 1 0.000 0 0 0 0.00 0 1503615600 0 Y N N B N R Y N N Y 10 1503615600 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 Mangled Wreck Chords Alan Brown/Nik Georgandis 1503609189 Y 2021-12-17 17:37:27 0
61409 WC003RED P A 1 1.69 1 0.000 0 0 0 0.00 0 1503356400 0 Y N N B N R Y N N Y 10 1503356400 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 WiggleCat Records Sean inside out 1503406056 Y 2021-12-17 17:37:27 0
61418 BZK067 P A 1 1.69 1 0.000 0 0 0 0.00 0 1503615600 0 Y N N B N R Y N N Y 10 1503615600 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 Copyright Control Matt Clarkson 1593722105 Y 2021-12-17 17:37:27 0
61508 IOD037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1503529200 0 Y N N B N R Y N N Y 10 1503529200 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 Ben Macdonald 1503566462 Y 2021-12-17 17:37:27 0
61509 SSD024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1503615600 0 Y N N B N R Y N N Y 10 1503615600 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/Ben Stevens 1503609372 Y 2021-12-17 17:37:27 0
61518 Cheek339 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504825200 0 Y N N B N R Y N N Y 10 1504825200 1506034800 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 5054283200522 GBKQU1783336 N Copyright Control Kieran Jopson 1503637228 Y 2021-12-17 17:37:27 0
61519 Cheek339 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504825200 0 Y N N B N R Y N N Y 10 1504825200 1506034800 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 5054283200522 GBKQU1783337 N Copyright Control Kieran Jopson 1503637231 Y 2021-12-17 17:37:27 0
61523 TMP090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504047600 0 Y N N B N R Y N N Y 10 1504047600 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 Matt Wade 1503658169 Y 2021-12-17 17:37:27 0
61565 ON048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1503702000 0 Y N N B N R Y N N Y 10 1503702000 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 Orrible Noize Rob Yellowley 1503735503 Y 2021-12-17 17:37:27 0
61583 MEP002 P A 1 2.49 1 0.000 0 0 0 0.00 0 1503788400 0 Y N N B N R Y N N Y 10 0 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;} Y 1743769334 Y 2021-12-17 17:37:27 0
61613 DD120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504047600 0 Y N N B N R Y N N Y 10 1504047600 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 GBKQU1785773 N Copyright Control Nikkdbubble & Rick James 1504112790 Y 2021-12-17 17:37:27 0
61632 SPEAK003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504134000 0 Y N N B N R Y N N Y 10 1504134000 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 Lee Silvester / Jo Martin 1641997372 Y 31/08/2017 30/09/2017 2021-12-17 17:37:27 0
61633 HLXR041 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504220400 0 Y N N B N R Y N N Y 10 1504220400 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 GB9W51700008 N Copyright Control Ben MacDonald 1620671947 Y 2021-12-17 17:37:27 0
61766 VCR247 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504825200 0 Y N N B N R Y N N Y 10 1504825200 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 Defensive Music Rob Tissera / Ben Stevens / Adam Martin 1504605689 Y 2021-12-17 17:37:27 0
61767 VCR247 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504825200 0 Y N N B N R Y N N Y 10 1504825200 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 Rob Tissera / Ben Stevens / Adam Martin 1504604576 Y 2021-12-17 17:37:27 0
61787 UBT002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504825200 0 Y N N B N R Y N N Y 10 1504825200 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 Damien Blanes 1504630706 Y 2021-12-17 17:37:27 0
61788 ESP010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504566000 0 Y N N B N R Y N N Y 10 1504566000 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 Energy Source Productions DJ Serenity 1504630774 Y 2021-12-17 17:37:27 0
61789 ESP011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504566000 0 Y N N B N R Y N N Y 10 1504566000 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 Energy Source Productions DJ Serenity 1504635733 Y 2021-12-17 17:37:27 0
61885 TMP091 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504825200 0 Y N N B N R Y N N Y 10 1504825200 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 Matt Clarkson 1504807709 Y 2021-12-17 17:37:27 0