SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    88722, 88721, 88720, 88719, 88718, 88717, 
    88716, 88715, 88714, 88713, 88712, 
    88711, 88710, 88709, 88708, 88707, 
    88706, 89080, 89079, 89078, 88676, 
    88675, 88674, 88920, 88919, 88493, 
    89075, 88916, 88491, 89082, 89030, 
    89029, 89028, 88996, 88995, 88994, 
    88993, 88981, 88520, 88495
  )

Query time 0.00072

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
88491 TiOS096 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601247600 0 Y N N B N R Y N N Y 10 1601247600 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 5054285315354 GBKQU2091036 N This Is Our Sound Digital (TiOS) Victor "GERCORE" Wiedemann 1598892752 Y 2021-12-17 17:37:27 0
88493 TiOS097 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601420400 0 Y N N B N R Y N N Y 10 1601420400 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 5054285317976 GBKQU2091593 N This Is Our Sound Digital (TiOS) Ian "Pez" Perrett. 1598892754 Y 2021-12-17 17:37:27 0
88495 CRR036 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 5054285248140 GBKQU2078929 N Copyright Control Zeom & AmnesiA 1598892755 Y 2021-12-17 17:37:27 0
88520 Rave20201 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 5054285310724 UK7J92000001 N Rave Essentials Bridson and Rikston 1598892900 Y 2021-12-17 17:37:27 0
88674 ONESEVENTY75 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601506800 0 Y N N B N R Y N N Y 10 1601506800 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 5054285266885 GBKQU2082115 N Copyright Control Michael O'Brien 1598936701 Y 2021-12-17 17:37:27 0
88675 ONESEVENTY75 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601506800 0 Y N N B N R Y N N Y 10 1601506800 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 5054285266885 GBKQU2082114 N Copyright Control Michael O'Brien 1598936701 Y 2021-12-17 17:37:27 0
88676 HBA0018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601506800 0 Y N N B N R Y N N Y 10 1601506800 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 5054285284643 GBKQU2085114 N Defensive Music Justin Kashi 1598936702 Y 2021-12-17 17:37:27 0
88706 CRR037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285248645 GBKQU2078996 N Copyright Control Preacker 1599023417 Y 2021-12-17 17:37:27 0
88707 CRR037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285248645 GBKQU2078997 N Copyright Control Preacker 1599023417 Y 2021-12-17 17:37:27 0
88708 CRR037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285248645 GBKQU2078998 N Copyright Control Preacker 1599023417 Y 2021-12-17 17:37:27 0
88709 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091761 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023420 Y 2021-12-17 17:37:27 0
88710 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091762 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023420 Y 2021-12-17 17:37:27 0
88711 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091763 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023420 Y 2021-12-17 17:37:27 0
88712 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091764 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023420 Y 2021-12-17 17:37:27 0
88713 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091765 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023420 Y 2021-12-17 17:37:27 0
88714 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091766 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023421 Y 2021-12-17 17:37:27 0
88715 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091767 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023421 Y 2021-12-17 17:37:27 0
88716 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091768 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023421 Y 2021-12-17 17:37:27 0
88717 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091769 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023421 Y 2021-12-17 17:37:27 0
88718 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091770 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023421 Y 2021-12-17 17:37:27 0
88719 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091771 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023422 Y 2021-12-17 17:37:27 0
88720 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091772 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023422 Y 2021-12-17 17:37:27 0
88721 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091773 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023422 Y 2021-12-17 17:37:27 0
88722 TiOSALBUM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601593200 0 Y N N B N R Y N N Y 10 1601593200 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 5054285318812 GBKQU2091774 N 88727 This Is Our Sound Digital (TiOS) Various Artists 1599023422 Y 2021-12-17 17:37:27 0
88916 BAB005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601247600 0 Y N N B N R Y N N Y 10 1601247600 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 5054285333129 NLS161802369 N 2 Dex Publishing R. van der Vaart / M. Bakker / C. Harvey 1599239413 Y 2021-12-17 17:37:27 0
88919 RRS002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601420400 0 Y N N B N R Y N N Y 10 1601420400 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 5054285335437 GBKQU2095356 N Copyright Control Alexander Kern 1599239414 Y 2021-12-17 17:37:27 0
88920 RRS002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601420400 0 Y N N B N R Y N N Y 10 1601420400 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 5054285335437 GBKQU2095357 N Copyright Control Alexander Kern 1599239414 Y 2021-12-17 17:37:27 0
88981 247HC204 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 5054285347867 UKT6B2000103 N Peer Music / Copyright Control S.Attrill, A.Taylor 1599671101 Y 2021-12-17 17:37:27 0
88993 247HC205 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 5054285347874 UKT6B2000088 N copyright Control VA 1599671402 Y 2021-12-17 17:37:27 0
88994 247HC205 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 5054285347874 UKT6B2000089 N copyright Control VA 1599671403 Y 2021-12-17 17:37:27 0
88995 247HC205 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 5054285347874 UKT6B2000090 N copyright Control VA 1599671403 Y 2021-12-17 17:37:27 0
88996 247HC205 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 5054285347874 UKT6B2000091 N copyright Control VA 1599671403 Y 2021-12-17 17:37:27 0
89028 DARKUL023 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 5054285349397 GBKQU2098318 N Copyright Control S.Hinshelwood, M.Collins 1599758112 Y 2021-12-17 17:37:27 0
89029 DARKUL023 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 5054285349397 GBKQU2098319 N Copyright Control S.Hinshelwood, M.Collins 1599758112 Y 2021-12-17 17:37:27 0
89030 DARKUL023 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 5054285349397 GBKQU2098320 N Copyright Control S.Hinshelwood, M.Collins 1599758113 Y 2021-12-17 17:37:27 0
89075 XZONE041 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601247600 0 Y N N B N R Y N N Y 10 1601247600 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 5054285354025 GBKQU2099252 N X-Zone Ragga Wolvz 1600103104 Y 2021-12-17 17:37:27 0
89078 RID023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601506800 0 Y N N B N R Y N N Y 10 1601506800 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 5054285356036 GBKQU2099650 N Copyright Control Lammert Brouwer 1600103401 Y 2021-12-17 17:37:27 0
89079 RID023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601506800 0 Y N N B N R Y N N Y 10 1601506800 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 5054285356036 GBKQU2099651 N Copyright Control Lammert Brouwer 1600103402 Y 2021-12-17 17:37:27 0
89080 RID023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1601506800 0 Y N N B N R Y N N Y 10 1601506800 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 5054285356036 GBKQU2099652 N Copyright Control Lammert Brouwer 1600103402 Y 2021-12-17 17:37:27 0
89082 UKDD0042 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 5054285353387 GBKQU2099113 N Paul Rodriguez Music Publishing J.Broomfield 1600103403 Y 2021-12-17 17:37:27 0