SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    88127, 88126, 88125, 88124, 87662, 87418, 
    87417, 87416, 87415, 87414, 87413, 
    87412, 87411, 87410, 87409, 87363, 
    87362, 87158, 87157, 87659, 88123, 
    88122, 87708, 87707, 87676, 87675, 
    87475, 87169, 87083, 87082, 87081, 
    87067, 87024, 87854, 87853, 87852, 
    87713, 87712, 87711, 87710
  )

Query time 0.00065

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
87024 STI0159 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285182154 GBKQU2066771 N Copyright Control N. Smith, A. Taylor 1594052864 Y 2021-12-17 17:37:27 0
87067 CF057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285182987 GBKQU2066975 N Peers Music Chris Fear 1594052904 Y 2021-12-17 17:37:27 0
87081 RAVEMUZIK036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285151600 GBKQU2061320 N Copyright Control C.Rau 1594052918 Y 2021-12-17 17:37:27 0
87082 RAVEMUZIK036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285151600 GBKQU2061321 N Copyright Control C.Rau 1594052919 Y 2021-12-17 17:37:27 0
87083 RAVEMUZIK036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285151600 GBKQU2061322 N Copyright Control C.Rau 1594052919 Y 2021-12-17 17:37:27 0
87157 STM055 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285187814 GBY3G2000336 N Copyright Control D. Henry 1594053000 Y 2021-12-17 17:37:27 0
87158 STM055 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285187814 GBY3G2000337 N Copyright Control D. Henry 1594053000 Y 2021-12-17 17:37:27 0
87169 VDH044 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285184707 GBKQU2067205 N Various Digital Hardcore Overdrive 1594053011 Y 2021-12-17 17:37:27 0
87362 CR0182 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285143391 GBKQU2059736 N Label Worx Neil Lowndes 1594054452 Y 2021-12-17 17:37:27 0
87363 CR0182 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285143391 GBKQU2059737 N Label Worx Neil Lowndes 1594054452 Y 2021-12-17 17:37:27 0
87409 HUAACD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285214961 GBKQU2073069 N 87419 Copyright Control C. Stone 1594054871 Y 2021-12-17 17:37:27 0
87410 HUAACD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285214961 GBKQU2073070 N 87419 Copyright Control C. Stone 1594054872 Y 2021-12-17 17:37:27 0
87411 HUAACD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285214961 GBKQU2073071 N 87419 Copyright Control C. Stone 1594054872 Y 2021-12-17 17:37:27 0
87412 HUAACD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285214961 GBKQU2073072 N 87419 Copyright Control C. Stone 1594054872 Y 2021-12-17 17:37:27 0
87413 HUAACD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285214961 GBKQU2073073 N 87419 Copyright Control C. Stone 1594054872 Y 2021-12-17 17:37:27 0
87414 HUAACD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285214961 GBKQU2073074 N 87419 Copyright Control C. Stone 1594054873 Y 2021-12-17 17:37:27 0
87415 HUAACD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285214961 GBKQU2073075 N 87419 Copyright Control C. Stone 1594054873 Y 2021-12-17 17:37:27 0
87416 HUAACD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285214961 GBKQU2073076 N 87419 Copyright Control C. Stone 1594054873 Y 2021-12-17 17:37:27 0
87417 HUAACD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285214961 GBKQU2073077 N 87419 Copyright Control C. Stone 1594054873 Y 2021-12-17 17:37:27 0
87418 HUAACD010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285214961 GBKQU2073078 N 87419 Copyright Control C. Stone 1594054873 Y 2021-12-17 17:37:27 0
87475 STI0146 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285109397 GBKQU2053366 N Copyright Control BenAddikt & Elektrik 1594055336 Y 2021-12-17 17:37:27 0
87659 STI0145 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596236400 0 Y N N B N R Y N N Y 10 1596236400 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 5054285109373 GBKQU2053365 N Copyright Control BenAddikt & Blade 1596642411 Y 2021-12-17 17:37:27 0
87662 JH284 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285259054 GBKQU2080974 N Copyright Control EzKiLL 1596642453 Y 2021-12-17 17:37:27 0
87675 DSB032 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285259153 NLS161802346 N 2 Dex Publishing P. Di Vincenzo / J. Medina / G. Bignasca / E.Gomes 1596642669 Y 2021-12-17 17:37:27 0
87676 DSB032 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285259153 NLS161802348 N 2 Dex Publishing P. Di Vincenzo / J. Medina / G. Bignasca / E.Gomes 1596642679 Y 2021-12-17 17:37:27 0
87707 RELIGION007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285238097 GBKQU2077158 N Toff Music, Viceroy Music J. Mchugh, J. Kalkan 1596643601 Y 2021-12-17 17:37:27 0
87708 RELIGION007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285238097 GBKQU2077159 N Toff Music, Viceroy Music J. Mchugh, J. Kalkan 1596643613 Y 2021-12-17 17:37:27 0
87710 MOUTH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285241547 GBKQU2077710 N Copyright Control M.Moran, S.Eyre, A.Innes, A.Robertson, G.Smith 1596643645 Y 2021-12-17 17:37:27 0
87711 MOUTH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285241547 GBKQU2077711 N Copyright Control M.Moran, S.Eyre, A.Innes, A.Robertson, G.Smith 1596643661 Y 2021-12-17 17:37:27 0
87712 MOUTH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285241547 GBKQU2077712 N Copyright Control M.Moran, S.Eyre, A.Innes, A.Robertson, G.Smith 1596643676 Y 2021-12-17 17:37:27 0
87713 MOUTH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285241547 GBKQU2077713 N Copyright Control M.Moran, S.Eyre, A.Innes, A.Robertson, G.Smith 1596643694 Y 2021-12-17 17:37:27 0
87852 DARKUL017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285241172 GBKQU2077646 N Copyright Control A.Robertson 1596646783 Y 2021-12-17 17:37:27 0
87853 DARKUL017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285241172 GBKQU2077647 N Copyright Control A.Robertson 1596646799 Y 2021-12-17 17:37:27 0
87854 DARKUL017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596063600 0 Y N N B N R Y N N Y 10 1596063600 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 5054285241172 GBKQU2077648 N Copyright Control A.Robertson 1596646814 Y 2021-12-17 17:37:27 0
88122 MOUTHDATA087 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285234846 GBKQU2076511 N Copyright Control Denis Fedorchuk 1596653306 Y 2021-12-17 17:37:27 0
88123 MOUTHDATA087 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596150000 0 Y N N B N R Y N N Y 10 1596150000 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 5054285234846 GBKQU2076512 N Copyright Control Denis Fedorchuk 1596653322 Y 2021-12-17 17:37:27 0
88124 DARKUL018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285241189 GBKQU2077649 N Copyright Control Giuseppe Di Mauro & Tommaso Benini 1596653336 Y 2021-12-17 17:37:27 0
88125 DARKUL018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285241189 GBKQU2077650 N Copyright Control Giuseppe Di Mauro & Tommaso Benini 1596653351 Y 2021-12-17 17:37:27 0
88126 DARKUL018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285241189 GBKQU2077651 N Copyright Control Giuseppe Di Mauro & Tommaso Benini 1596653366 Y 2021-12-17 17:37:27 0
88127 DARKUL018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596409200 0 Y N N B N R Y N N Y 10 1596409200 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 5054285241189 GBKQU2077652 N Copyright Control Giuseppe Di Mauro & Tommaso Benini 1596653379 Y 2021-12-17 17:37:27 0