SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    64531, 63919, 63727, 64535, 64525, 64524, 
    64509, 64424, 64100, 64099, 63197, 
    64508, 64507, 64506, 64505, 64429, 
    64428, 64427, 64426, 64425, 64393, 
    64208, 63573, 63572, 61775, 61755, 
    64145, 64122, 64121, 64120, 61891, 
    64080, 64079, 63775, 63898, 63897, 
    63871, 63718, 63301, 63300
  )

Query time 0.00107

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
61755 FBR282 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512086400 0 Y N N B N R Y N N Y 10 1512086400 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 Kris O'Rourke 1504555908 Y 2021-12-17 17:37:27 0
61775 VCR254 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512086400 0 Y N N B N R Y N N Y 10 1512086400 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 Fabio Seramota 1504610228 Y 2021-12-17 17:37:27 0
61891 PDHH083 P A 1 1.69 1 0.000 0 0 0 0.00 0 1511481600 0 Y N N B N R Y N N Y 10 1511481600 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/Thornton Steve Thornton 1504813986 Y 2021-12-17 17:37:27 0
63197 TB185 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512345600 0 Y N N B N R Y N N Y 10 1512345600 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 Dave Neale / Dale Parry 1508961894 Y 2021-12-17 17:37:27 0
63300 Cheek338 P A 1 1.69 1 0.000 0 0 0 0.00 0 1510876800 0 Y N N B N R Y N N Y 10 1510876800 1512086400 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 5054283313611 GBLV61709192 N Copyright Control Mark Doggett, Carlton McCarthy, Rob Smith, Ray Mighty 1508994020 Y 2021-12-17 17:37:27 0
63301 Cheek338 P A 1 1.69 1 0.000 0 0 0 0.00 0 1510876800 0 Y N N B N R Y N N Y 10 1510876800 1512086400 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 5054283313611 GBLV61709193 N Copyright Control Mark Doggett, Carlton McCarthy, Rob Smith, Ray Mighty 1508994021 Y 2021-12-17 17:37:27 0
63572 Cheek350B P A 1 1.69 1 0.000 0 0 0 0.00 0 1512086400 0 Y N N B N R Y N N Y 10 1512086400 1513296000 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 5054283313987 GBLV61709271 N Copyright Control Mohamed Moretta 1509598802 Y 2021-12-17 17:37:27 0
63573 Cheek350B P A 1 1.69 1 0.000 0 0 0 0.00 0 1512086400 0 Y N N B N R Y N N Y 10 1512086400 1513296000 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 5054283313987 GBLV61709272 N Copyright Control Mohamed Moretta 1509598802 Y 2021-12-17 17:37:27 0
63718 TDOG114 P A 1 1.69 1 0.000 0 0 0 0.00 0 1510876800 0 Y N N B N R Y N N Y 10 1510876800 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 Hatfish Dave Owens 1510114041 Y 2021-12-17 17:37:27 0
63727 UTHHD020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512691200 0 Y N N B N R Y N N Y 10 1512691200 1513900800 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 5054283316155 GBLV61709611 N Ultratech Sam Alame & Jay Middleton 1510203602 Y 2021-12-17 17:37:27 0
63775 ST019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1510963200 0 Y N N B N R Y N N Y 10 1510963200 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 Spectrum Trax Mitch Doig 1510368877 Y 2021-12-17 17:37:27 0
63871 BZK069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1510876800 0 Y N N B N R Y N N Y 10 1510876800 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 James Jackson / Dave Owens 1593722137 Y 2021-12-17 17:37:27 0
63897 JAM018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1510876800 0 Y N N B N R Y N N Y 10 1510876800 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 UKG3L1700010 N Copyright Control Adrian Buss 1510862109 Y 2021-12-17 17:37:27 0
63898 IOD044 P A 1 1.69 1 0.000 0 0 0 0.00 0 1510879617 0 Y N N B N R Y N N Y 10 1510876800 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 Joe Duffy 1510880423 Y 2021-12-17 17:37:27 0
63919 UBT004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512691200 0 Y N N B N R Y N N Y 10 1512691200 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 Mischief Duo 1512592785 Y 2021-12-17 17:37:27 0
64079 D10R P A 1 1.69 1 0.000 0 0 0 0.00 0 1511136000 0 Y N N B N R Y N N Y 10 1511136000 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 delusion delusion 1511175203 Y 2021-12-17 17:37:27 0
64080 SC062 P A 1 1.69 1 0.000 0 0 0 0.00 0 1511210357 0 Y N N B N R Y N N Y 10 1511136000 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 Hatfish James Hill / Paul Norris 1511210722 Y 2021-12-17 17:37:27 0
64099 WLHH006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512345600 0 Y N N B N R Y N N Y 10 1512345600 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/Tim Clowes 1511303556 Y 2021-12-17 17:37:27 0
64100 WLHH006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512345600 0 Y N N B N R Y N N Y 10 1512345600 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 1511304349 Y 2021-12-17 17:37:27 0
64120 TND005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1511481600 0 Y N N B N R Y N N Y 10 1511481600 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, Gaz Fullard 1511441948 Y 2021-12-17 17:37:27 0
64121 SSD027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1511481600 0 Y N N B N R Y N N Y 10 1511481600 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 James/Gaz F 1511478550 Y 2021-12-17 17:37:27 0
64122 NEVER025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1511481600 0 Y N N B N R Y N N Y 10 1511481600 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 UKCCW1700010 N Copyright Control Simon Mowling/Ben MacDonald 1511480282 Y 2021-12-17 17:37:27 0
64145 JTH006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1511557500 0 Y N N B N R Y N N Y 10 1511481600 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 Martin Cook/Marc Andrew Lowley 1511558930 Y 2021-12-17 17:37:27 0
64208 FR048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512086400 0 Y N N B N R Y N N Y 10 1512086400 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 1641471910 Y 01/12/2017 31/12/2017 2021-12-17 17:37:27 0
64393 HLXR044 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512086842 0 Y N N B N R Y N N Y 10 1512086400 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 GB9W51700011 N Toolbox Publishing Dawn Lee 1641936640 Y 01/12/2017 31/12/2017 2021-12-17 17:37:27 0
64424 D007R P A 1 1.69 1 0.000 0 0 0 0.00 0 1512345600 0 Y N N B N R Y N N Y 10 1512345600 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 delusion delusion 1512390560 Y 2021-12-17 17:37:27 0
64425 Bosc001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512257627 0 Y N N B N R Y N N Y 10 1512172800 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 Boscaland Recordings John Vaughan 1512311838 Y 2021-12-17 17:37:27 0
64426 Bosc002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512257945 0 Y N N B N R Y N N Y 10 1512172800 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;} 3 N Boscaland Recordings John Vaughan 1512311696 Y 2021-12-17 17:37:27 0
64427 Bosc003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512258117 0 Y N N B N R Y N N Y 10 1512172800 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 Boscaland Recordings John Vaughan 1512311826 Y 2021-12-17 17:37:27 0
64428 Bosc004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512258558 0 Y N N B N R Y N N Y 10 1512172800 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;} 34 N Boscaland Recordings John Vaughan 1512311723 Y 2021-12-17 17:37:27 0
64429 Bosc005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512258775 0 Y N N B N R Y N N Y 10 1512172800 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;} 3 N Sony Spacey/Vaughan/Pound/Harris 1513035938 Y 2021-12-17 17:37:27 0
64505 TMP096 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512313265 0 Y N N B N R Y N N Y 10 1512259200 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 Alan Sharkey 1512314123 Y 2021-12-17 17:37:27 0
64506 Bosc006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512322751 0 Y N N B N R Y N N Y 10 1512259200 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;} 3 N Boscaland Recordings John Vaughan 1512323122 Y 2021-12-17 17:37:27 0
64507 Bosc007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512323907 0 Y N N B N R Y N N Y 10 1512259200 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;} 3 N Boscaland Recordings John Vaughan 1512324015 Y 2021-12-17 17:37:27 0
64508 Bosc008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512330523 0 Y N N B N R Y N N Y 10 1512259200 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;} 34 N Boscaland Recordings John Vaughan 1512331914 Y 2021-12-17 17:37:27 0
64509 AR011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512392282 0 Y N N B N R Y N N Y 10 1512345600 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 Whitewood / Ben Stevens 1512392421 Y 2021-12-17 17:37:27 0
64524 Bosc009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512511490 0 Y N N B N R Y N N Y 10 1512432000 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 Boscaland Recordings John Vaughan 1512512120 Y 2021-12-17 17:37:27 0
64525 Bosc010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512515495 0 Y N N B N R Y N N Y 10 1512432000 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;} 3 N Boscaland Recordings John Vaughan 1512515719 Y 2021-12-17 17:37:27 0
64531 DB018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512691200 0 Y N N B N R Y N N Y 10 1512691200 1513900800 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 5054283320268 GBLV61710260 N Drop Bear Digital Leigh Jones, Mish Bennetts 1512724427 Y 2021-12-17 17:37:27 0
64535 DD125 P A 1 1.69 1 0.000 0 0 0 0.00 0 1512597317 0 Y N N B N R Y N N Y 10 1512518400 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 GBLV61704921 N Copyright Control Damaged Gudz 1512597620 Y 2021-12-17 17:37:27 0