SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    71200, 71013, 70292, 70814, 71176, 71156, 
    71155, 71154, 71153, 70919, 71125, 
    71078, 71113, 70994, 70541, 71108, 
    71015, 70830, 71012, 70827, 71064, 
    71062, 71061, 71011, 70545, 70544, 
    70122, 70813, 70817, 70952, 70947, 
    70540, 70359, 70882, 70881, 70829, 
    70828, 70538, 70230, 70229
  )

Query time 0.00076

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
70122 FBR300 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539298800 0 Y N N B N R Y N N Y 10 1539298800 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 / Anthony Ratcliffe 1535382343 Y 2021-12-17 17:37:27 0
70229 Cheek388 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538089200 0 Y N N B N R Y N N Y 10 1538089200 1539298800 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 5054283782387 GBKQU1834914 N Copyright Control Francis Van Mechelen, Lorenzo Schoovaers, Rob Yellowley, Chloe McManoman 1535605233 Y 2021-12-17 17:37:27 0
70230 Cheek388 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538089200 0 Y N N B N R Y N N Y 10 1538089200 1539298800 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 5054283782387 GBKQU1838820 N Copyright Control Francis Van Mechelen, Lorenzo Schoovaers, Rob Yellowley, Chloe McManoman 1535605233 Y 2021-12-17 17:37:27 0
70292 FBR301 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540508400 0 Y N N B N R Y N N Y 10 1540508400 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 Eastham / Seam Zodd 1536005196 Y 2021-12-17 17:37:27 0
70359 TBR187 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538348400 0 Y N N B N R Y N N Y 10 1538348400 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 / Lucy Goldberg 1536178647 Y 2021-12-17 17:37:27 0
70538 TND026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538089200 0 Y N N B N R Y N N Y 10 1538089200 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 Pearson, Scott Chaney 1536775562 Y 2021-12-17 17:37:27 0
70540 DER008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538694000 0 Y N N B N R Y N N Y 10 1538694000 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 1537253049 Y 2021-12-17 17:37:27 0
70541 DER009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539903600 0 Y N N B N R Y N N Y 10 1539903600 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 Mowling 1536776522 Y 2021-12-17 17:37:27 0
70544 Cheek392 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539298800 0 Y N N B N R Y N N Y 10 1539298800 1540508400 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 5054283837391 GBKQU1830801 N Copyright Control Drake Liddell 1536814803 Y 2021-12-17 17:37:27 0
70545 Cheek392 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539298800 0 Y N N B N R Y N N Y 10 1539298800 1540508400 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 5054283837391 GBKQU1869002 N Copyright Control Drake Liddell 1536814804 Y 2021-12-17 17:37:27 0
70813 IOD066 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539212400 0 Y N N B N R Y N N Y 10 1539212400 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 Mark Hard / Karl Davies 1537824339 Y 2021-12-17 17:37:27 0
70814 IOD067 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540422000 0 Y N N B N R Y N N Y 10 1540422000 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 Steve Clack 1537824427 Y 2021-12-17 17:37:27 0
70817 HOT017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539126000 0 Y N N B N R Y N N Y 10 1539126000 1540335600 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 5054283893960 GBKQU1891575 N Hot Box Digital D-Fi 1537851603 Y 2021-12-17 17:37:27 0
70827 FILTH003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539558000 0 Y N N B N R Y N N Y 10 1539558000 1540771200 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 5054283893984 GBKQU1891577 N The Filth Foundry Matt Wade & Karl Davis 1537938003 Y 2021-12-17 17:37:27 0
70828 HWR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538089200 0 Y N N B N R Y N N Y 10 1538089200 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 Marc Lewis 1711483556 Y 2021-12-17 17:37:27 0
70829 PDHH105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538089200 0 Y N N B N R Y N N Y 10 1538089200 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/Hogan Hogan 1537982700 Y 2021-12-17 17:37:27 0
70830 UTHHD024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539730800 0 Y N N B N R Y N N Y 10 1539730800 1540944000 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 5054283898194 GBKQU1892309 N Ultratech Jay Middleton 1538024402 Y 2021-12-17 17:37:27 0
70881 TDOG122_P P A 1 1.69 1 0.000 0 0 0 0.00 0 1538142002 0 Y N N B N R Y N N Y 10 1538089200 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 Hatfish Dave Owens 1538146025 Y 2021-12-17 17:37:27 0
70882 TDOG122 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538146107 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;} N 1538146449 Y 2021-12-17 17:37:27 0
70919 XTRA128 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540076400 0 Y N N B N R Y N N Y 10 1540076400 1541289600 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 5054283904451 GBKQU1893461 N Xtrahard Records Francisco Gaitan 1538542803 Y 2021-12-17 17:37:27 0
70947 UBT015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538694000 0 Y N N B N R Y N N Y 10 1538694000 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 1538694268 Y 2021-12-17 17:37:27 0
70952 420013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1538798990 0 Y N N B N R Y N N Y 10 1538780400 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 Tim Sloan Tim Sloan 1544639832 Y 2021-12-17 17:37:27 0
70994 PDHT044 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539903600 0 Y N N B N R Y N N Y 10 1539903600 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 Premonition Digital/Taylor/Goddard Taylor/Goddard 1539891525 Y 2021-12-17 17:37:27 0
71011 PDHH106 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539298800 0 Y N N B N R Y N N Y 10 1539298800 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/Parry/Stevens Parry/Stevens 1539106293 Y 2021-12-17 17:37:27 0
71012 SS079 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539558000 0 Y N N B N R Y N N Y 10 1539558000 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 1539135061 Y 2021-12-17 17:37:27 0
71013 HOT018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540508400 0 Y N N B N R Y N N Y 10 1540508400 1541721600 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 5054283919820 GBKQU1896282 N Hot Box Digital Matt Wade & Gaz.P 1539147601 Y 2021-12-17 17:37:27 0
71015 BMR058 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539817200 0 Y N N B N R Y N N Y 10 1539817200 1542240000 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 5054283919202 GBKQU1896113 N Alexei Reynolds (C) 2018 Alexei Reynolds (C) 2018 1539147602 Y 2021-12-17 17:37:27 0
71061 TND027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539298800 0 Y N N B N R Y N N Y 10 1539298800 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 Mowling, Ben Macdonald 1539278109 Y 2021-12-17 17:37:27 0
71062 FR063 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539298800 0 Y N N B N R Y N N Y 10 1539298800 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 Will Shepherd 1539298824 Y 2021-12-17 17:37:27 0
71064 TMP113 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539365041 0 Y N N B N R Y N N Y 10 1539298800 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 1539365422 Y 2021-12-17 17:37:27 0
71078 KD004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539990000 0 Y N N B N R Y N N Y 10 1539990000 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 mark hard / dan dyson mark hard / dan dyson 1539545334 Y 2021-12-17 17:37:27 0
71108 F4A007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539817200 0 Y N N B N R Y N N Y 10 1539817200 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 Copyright Control Craig Jones 1539778866 Y 2021-12-17 17:37:27 0
71113 JAM028 P A 1 1.69 1 0.000 0 0 0 0.00 0 1539903600 0 Y N N B N R Y N N Y 10 1539903600 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 UKG3L1800008 N copyright Control Tom Whyld 1539897918 Y 2021-12-17 17:37:27 0
71125 RPR184 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540033267 0 Y N N B N R Y N N Y 10 1539990000 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 GBXME0800184 N none Leigh Jones, Mich Bennetts 1540034120 Y 2021-12-17 17:37:27 0
71153 ESP017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540218377 0 Y N N B N R Y N N Y 10 1540162800 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 1540218619 Y 2021-12-17 17:37:27 0
71154 ESP018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540218521 0 Y N N B N R Y N N Y 10 1540162800 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 1540218637 Y 2021-12-17 17:37:27 0
71155 ESP019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540218699 0 Y N N B N R Y N N Y 10 1540162800 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 1540219520 Y 2021-12-17 17:37:27 0
71156 ESP0016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540218857 0 Y N N B N R Y N N Y 10 1540162800 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 1540222480 Y 2021-12-17 17:37:27 0
71176 TND028 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540295501 0 Y N N B N R Y N N Y 10 1540249200 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 Kev & Si 1540298191 Y 2021-12-17 17:37:27 0
71200 PDHH107 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540508400 0 Y N N B N R Y N N Y 10 1540508400 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 Paley/Alamé/Parr 1540401364 Y 2021-12-17 17:37:27 0