SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    87227, 87226, 87225, 87224, 87223, 87222, 
    87221, 87220, 87219, 87218, 87217, 
    87216, 87000, 86999, 86998, 86997, 
    86996, 86995, 86994, 86993, 86506, 
    86447, 86446, 86445, 86444, 86384, 
    86383, 86382, 86381, 86380, 86379, 
    86378, 86377, 86376, 86375, 86374, 
    87116, 86470, 86469, 86468
  )

Query time 0.00056

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
86374 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000020 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86375 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000021 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86376 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000022 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86377 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000023 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86378 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000024 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86379 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000025 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86380 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000026 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86381 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000027 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86382 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000028 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86383 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000029 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86384 TFCD020D P A 1 1.69 1 0.000 0 0 0 0.00 0 1593471600 0 Y N N B N R Y N N Y 10 1593471600 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 5054285102664 JPX542000030 N 86385 TERRAFORM MUSIC M-Project 1591811273 Y 2021-12-17 17:37:27 0
86444 DARKUL010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593644400 0 Y N N B N R Y N N Y 10 1593644400 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 5054285138687 GBKQU2058825 N Copyright Control T.Corbett 1591811272 Y 2021-12-17 17:37:27 0
86445 DARKUL010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593644400 0 Y N N B N R Y N N Y 10 1593644400 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 5054285138687 GBKQU2058826 N Copyright Control T.Corbett 1591811272 Y 2021-12-17 17:37:27 0
86446 DARKUL010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593644400 0 Y N N B N R Y N N Y 10 1593644400 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 5054285138687 GBKQU2058827 N Copyright Control T.Corbett 1591811272 Y 2021-12-17 17:37:27 0
86447 DARKUL010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593644400 0 Y N N B N R Y N N Y 10 1593644400 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 5054285138687 GBKQU2058828 N Copyright Control T.Corbett 1591811272 Y 2021-12-17 17:37:27 0
86468 DARKUL009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593385200 0 Y N N B N R Y N N Y 10 1593385200 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 5054285138670 GBKQU2058822 N Copyright Control G.di Mauro 1591811273 Y 2021-12-17 17:37:27 0
86469 DARKUL009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593385200 0 Y N N B N R Y N N Y 10 1593385200 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 5054285138670 GBKQU2058823 N Copyright Control G.di Mauro 1591811273 Y 2021-12-17 17:37:27 0
86470 DARKUL009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593385200 0 Y N N B N R Y N N Y 10 1593385200 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 5054285138670 GBKQU2058824 N Copyright Control G.di Mauro 1591811273 Y 2021-12-17 17:37:27 0
86506 VDH041 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285082430 GBKQU2048584 N Various Digital Hardcore Overdrive & Monster 1591811272 Y 2021-12-17 17:37:27 0
86993 247HC197 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285171066 UKT6B2000058 N Copyright Control Rob IYF & Friends 1594053434 Y 2021-12-17 17:37:27 0
86994 247HC197 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285171066 UKT6B2000062 N Copyright Control Rob IYF & Friends 1594053443 Y 2021-12-17 17:37:27 0
86995 247HC197 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285171066 UKT6B2000063 N Copyright Control Rob IYF & Friends 1594053459 Y 2021-12-17 17:37:27 0
86996 247HC197 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285171066 UKT6B2000059 N Copyright Control Rob IYF & Friends 1594053471 Y 2021-12-17 17:37:27 0
86997 247HC197 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285171066 UKT6B2000061 N Copyright Control Rob IYF & Friends 1594053485 Y 2021-12-17 17:37:27 0
86998 247HC197 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285171066 UKT6B2000065 N Copyright Control Rob IYF & Friends 1594053496 Y 2021-12-17 17:37:27 0
86999 247HC197 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285171066 UKT6B2000060 N Copyright Control Rob IYF & Friends 1594053509 Y 2021-12-17 17:37:27 0
87000 247HC197 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285171066 UKT6B2000064 N Copyright Control Rob IYF & Friends 1594053517 Y 2021-12-17 17:37:27 0
87116 JH279 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593385200 0 Y N N B N R Y N N Y 10 1593385200 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 5054285170205 GBKQU2064687 N Copyright Control Riko & X-Fadid 1594055113 Y 2021-12-17 17:37:27 0
87216 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 FR9W12004277 N 87241 Copyright Control Various Artists 1594057499 Y 2021-12-17 17:37:27 0
87217 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 GBKQU2002554 N 87241 Copyright Control Various Artists 1594057516 Y 2021-12-17 17:37:27 0
87218 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 GBKQU2013007 N 87241 Copyright Control Various Artists 1594057534 Y 2021-12-17 17:37:27 0
87219 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 GBKQU2007581 N 87241 Copyright Control Various Artists 1594057553 Y 2021-12-17 17:37:27 0
87220 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 GBKQU2011944 N 87241 Copyright Control Various Artists 1594057571 Y 2021-12-17 17:37:27 0
87221 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 GBKQU2016073 N 87241 Copyright Control Various Artists 1594057590 Y 2021-12-17 17:37:27 0
87222 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 ITB842000101 N 87241 Copyright Control Various Artists 1594057607 Y 2021-12-17 17:37:27 0
87223 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 GBLV61929125 N 87241 Copyright Control Various Artists 1594057625 Y 2021-12-17 17:37:27 0
87224 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 GBKQU2008522 N 87241 Copyright Control Various Artists 1594057647 Y 2021-12-17 17:37:27 0
87225 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 GBLV61927662 N 87241 Copyright Control Various Artists 1594057664 Y 2021-12-17 17:37:27 0
87226 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 GBKQU2022172 N 87241 Copyright Control Various Artists 1594057681 Y 2021-12-17 17:37:27 0
87227 LWHTE12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1593730800 0 Y N N B N R Y N N Y 10 1593730800 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 5054285163511 GBKQU2026785 N 87241 Copyright Control Various Artists 1594057697 Y 2021-12-17 17:37:27 0