SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    88461, 88412, 88396, 89357, 89198, 88514, 
    88484, 88483, 88482, 88463, 88462, 
    89197, 89196, 89013, 89012, 89011, 
    88992, 88991, 88990, 88989, 88988, 
    88987, 88986, 88985, 88984, 88983, 
    88982, 88952, 88951, 88950, 88949, 
    88948, 88947, 88946, 88841, 88840, 
    88831, 88830, 88829, 88828
  )

Query time 0.00061

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
88396 HARSH157 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600815600 0 Y N N B N R Y N N Y 10 1600815600 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;} labelworx 5054285228821 GBKQU2092295 N Harsh Records STARX 1598892463 Y 2021-12-17 17:37:27 0
88412 STI0166 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600988400 0 Y N N B N R Y N N Y 10 1600988400 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;} labelworx 5054285300770 GBKQU2088077 N Copyright Control Solo 1598892555 Y 2021-12-17 17:37:27 0
88461 KTRAR020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600988400 0 Y N N B N R Y N N Y 10 1600988400 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;} labelworx 5054285325742 GBKQU2093204 N Copyright Control Michael Kyle Nurse, Jyle Michael Saunders 1598892631 Y 2021-12-17 17:37:27 0
88462 NINJAHCSE004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600642800 0 Y N N B N R Y N N Y 10 1600642800 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;} labelworx 5054285296516 GBKQU2087364 N Copyright Control L. Garner 1598892633 Y 2021-12-17 17:37:27 0
88463 NINJAHCSE004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600642800 0 Y N N B N R Y N N Y 10 1600642800 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;} labelworx 5054285296516 GBKQU2087365 N Copyright Control L. Garner 1598892633 Y 2021-12-17 17:37:27 0
88482 STi0165 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600642800 0 Y N N B N R Y N N Y 10 1600642800 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;} labelworx 5054285272824 GBKQU2083147 N Copyright Control Solo 1598892735 Y 2021-12-17 17:37:27 0
88483 STi0165 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600642800 0 Y N N B N R Y N N Y 10 1600642800 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;} labelworx 5054285272824 GBKQU2083148 N Copyright Control Solo 1598892735 Y 2021-12-17 17:37:27 0
88484 STi0165 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600642800 0 Y N N B N R Y N N Y 10 1600642800 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;} labelworx 5054285272824 GBKQU2083149 N Copyright Control Solo 1598892736 Y 2021-12-17 17:37:27 0
88514 IYHR104 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600642800 0 Y N N B N R Y N N Y 10 1600642800 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;} labelworx 5054285289709 GBKQU2086076 N In Your Head Records Paul Gilbert, Mike Summers 1598892820 Y 2021-12-17 17:37:27 0
88828 EvMix018i P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285325810 GBKQU1141950 N 88843 23rd Precinct Music Ltd Scott Brown 1599071171 Y 2021-12-17 17:37:27 0
88829 EvMix018i P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285325810 GBKQU1535398 N 88843 23rd Precinct Music Ltd Scott Brown 1599071171 Y 2021-12-17 17:37:27 0
88830 EvMix018i P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285325810 GBKQU1590687 N 88843 23rd Precinct Music Ltd Scott Brown 1599071172 Y 2021-12-17 17:37:27 0
88831 EvMix018i P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285325810 GBKQU1143582 N 88843 23rd Precinct Music Ltd Scott Brown 1599071172 Y 2021-12-17 17:37:27 0
88840 EvMix018i P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285325810 GBKQU1351153 N 88843 23rd Precinct Music Ltd Scott Brown 1599071175 Y 2021-12-17 17:37:27 0
88841 EvMix018i P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285325810 GBKQU1141260 N 88843 23rd Precinct Music Ltd Scott Brown 1599071175 Y 2021-12-17 17:37:27 0
88946 MOUTHDATA088 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285344828 GBKQU2097243 N Copyright Control C.Alexandrow 1599585312 Y 2021-12-17 17:37:27 0
88947 MOUTHDATA088 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285344828 GBKQU2097244 N Copyright Control C.Alexandrow 1599585313 Y 2021-12-17 17:37:27 0
88948 MOUTHDATA088 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285344828 GBKQU2097245 N Copyright Control C.Alexandrow 1599585313 Y 2021-12-17 17:37:27 0
88949 MOUTHDATA088 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285344828 GBKQU2097246 N Copyright Control C.Alexandrow 1599585314 Y 2021-12-17 17:37:27 0
88950 UIR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285339220 GBKQU2096060 N Underground Industry Records Leonard Wieder, Joshua Rickman 1599585314 Y 2021-12-17 17:37:27 0
88951 UIR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285339220 GBKQU2096061 N Underground Industry Records Leonard Wieder, Joshua Rickman 1599585314 Y 2021-12-17 17:37:27 0
88952 UIR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285339220 GBKQU2096062 N Underground Industry Records Leonard Wieder, Joshua Rickman 1599585315 Y 2021-12-17 17:37:27 0
88982 247HC210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347201 UKT6B2000098 N Various Artists Various Artists 1599671103 Y 2021-12-17 17:37:27 0
88983 247HC210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347201 UKT6B2000094 N Various Artists Various Artists 1599671103 Y 2021-12-17 17:37:27 0
88984 247HC210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347201 UKT6B2000105 N Various Artists Various Artists 1599671103 Y 2021-12-17 17:37:27 0
88985 247HC210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347201 UKT6B2000095 N Various Artists Various Artists 1599671104 Y 2021-12-17 17:37:27 0
88986 247HC210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347201 UKT6B2000096 N Various Artists Various Artists 1599671104 Y 2021-12-17 17:37:27 0
88987 247HC210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347201 UKT6B2000097 N Various Artists Various Artists 1599671104 Y 2021-12-17 17:37:27 0
88988 247HC210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347201 UKT6B2000099 N Various Artists Various Artists 1599671104 Y 2021-12-17 17:37:27 0
88989 247HC210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347201 UKT6B2000100 N Various Artists Various Artists 1599671105 Y 2021-12-17 17:37:27 0
88990 247HC210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347201 UKT6B2000101 N Various Artists Various Artists 1599671105 Y 2021-12-17 17:37:27 0
88991 247HC208 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347218 UKT6B2000093 N Peer Music M.Greig 1599671402 Y 2021-12-17 17:37:27 0
88992 247HC208 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285347218 UKT6B2000102 N Peer Music M.Greig 1599671402 Y 2021-12-17 17:37:27 0
89011 DARKUL022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285349311 GBN4S1300014 N Copyright Control T.Corbett 1599758106 Y 2021-12-17 17:37:27 0
89012 DARKUL022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285349311 GBN4S1300015 N Copyright Control T.Corbett 1599758106 Y 2021-12-17 17:37:27 0
89013 DARKUL022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285349311 GBN4S1300016 N Copyright Control T.Corbett 1599758106 Y 2021-12-17 17:37:27 0
89196 TSR048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285359013 NLS161802404 N 2 Dex Publishing J.Aalders & J. Voogsgeerd 1600275902 Y 2021-12-17 17:37:27 0
89197 TSR048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600383600 0 Y N N B N R Y N N Y 10 1600383600 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;} labelworx 5054285359013 NLS161802403 N 2 Dex Publishing J.Aalders & J. Voogsgeerd 1600275902 Y 2021-12-17 17:37:27 0
89198 RS081 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600642800 0 Y N N B N R Y N N Y 10 1600642800 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;} labelworx 5054285360170 GBLV62000458 N Rebirth Society Double Drums 1600275902 Y 2021-12-17 17:37:27 0
89357 SD185 P A 1 1.69 1 0.000 0 0 0 0.00 0 1600642800 0 Y N N B N R Y N N Y 10 1600642800 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;} labelworx 5028386715931 GBACW1801240 N Peer Music K.Armstrong,M.Elliot, L.Marie 1600882251 Y 2021-12-17 17:37:27 0