SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    87668, 87667, 87689, 87688, 87651, 87790, 
    87789, 87681, 87758, 87757, 87756, 
    87755, 87684, 87677, 87585, 87885, 
    88049, 88048, 88047, 88046, 88045, 
    87873, 87766, 87765, 87646, 87590, 
    87589, 88131, 88130, 88129, 88128, 
    88071, 88070, 88069, 88057, 88056, 
    88055, 87482, 87481, 87487
  )

Query time 0.00049

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
87481 ONESEVENTY71 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285142608 GBKQU2059581 N Toffmusic, Peer Music Ben Jones, Tyler Newby 1594101605 Y 2021-12-17 17:37:27 0
87482 ONESEVENTY71 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285142608 GBKQU2059582 N Toffmusic, Peer Music Ben Jones, Tyler Newby 1594101605 Y 2021-12-17 17:37:27 0
87487 SD182 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596582000 0 Y N N B N R Y N N Y 10 1596582000 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 5028386715535 GBACW1801230 N Peer Music S.Moore, D.Petranovic 1594317602 Y 2021-12-17 17:37:27 0
87585 CF058 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597014000 0 Y N N B N R Y N N Y 10 1597014000 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 5054285217498 GBKQU2073431 N Peers Music Chris Fear 1596635887 Y 2021-12-17 17:37:27 0
87589 CR0183 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285159729 GBKQU2062849 N Contagious Records Adam Newton & Barrie Murphy 1596635893 Y 2021-12-17 17:37:27 0
87590 CR0183 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285159729 GBKQU2062850 N Contagious Records Adam Newton & Barrie Murphy 1596635893 Y 2021-12-17 17:37:27 0
87646 KTRAR017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285221808 GBKQU2074096 N Copyright Control Mike Steventon 1596636327 Y 2021-12-17 17:37:27 0
87651 EXE088 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597186800 0 Y N N B N R Y N N Y 10 1597186800 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 5054285239384 GBKQU2077333 N Copyright Control Paul Bevan 1596636640 Y 2021-12-17 17:37:27 0
87667 DARKUL021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597273200 0 Y N N B N R Y N N Y 10 1597273200 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 5054285241219 GBKQU2077657 N Copyright Control A.Calcagnile, G.di Mauro 1596642036 Y 2021-12-17 17:37:27 0
87668 DARKUL021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597273200 0 Y N N B N R Y N N Y 10 1597273200 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 5054285241219 GBKQU2077658 N Copyright Control A.Calcagnile, G.di Mauro 1596642038 Y 2021-12-17 17:37:27 0
87677 TiOS093 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597014000 0 Y N N B N R Y N N Y 10 1597014000 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 5054285208076 GBKQU2071534 N This Is Our Sound Digital (TiOS) Moses "M3-O" Olivier, Kevin "Instinct" Scott. 1596642107 Y 2021-12-17 17:37:27 0
87681 STI0149 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597100400 0 Y N N B N R Y N N Y 10 1597100400 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 5054285137345 GBKQU2058530 N Copyright Control Adam Frantic 1596642111 Y 2021-12-17 17:37:27 0
87684 JH285 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597014000 0 Y N N B N R Y N N Y 10 1597014000 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 5054285274767 GBKQU2083437 N Copyright Control Niki Jager 1596642664 Y 2021-12-17 17:37:27 0
87688 CR0184 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597186800 0 Y N N B N R Y N N Y 10 1597186800 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 5054285159828 GBKQU2062868 N Contagious Records Rik Norton-Wilkes 1596642669 Y 2021-12-17 17:37:27 0
87689 CR0184 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597186800 0 Y N N B N R Y N N Y 10 1597186800 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 5054285159828 GBKQU2062869 N Contagious Records Rik Norton-Wilkes 1596642669 Y 2021-12-17 17:37:27 0
87755 DARKUL020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597014000 0 Y N N B N R Y N N Y 10 1597014000 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 5054285241202 GBKQU2077656 N Copyright Control D.van de Bilt 1596643464 Y 2021-12-17 17:37:27 0
87756 DARKUL020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597014000 0 Y N N B N R Y N N Y 10 1597014000 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 5054285241202 GBN4S1200081 N Copyright Control D.van de Bilt 1596643466 Y 2021-12-17 17:37:27 0
87757 DARKUL020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597014000 0 Y N N B N R Y N N Y 10 1597014000 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 5054285241202 GBN4S1200082 N Copyright Control D.van de Bilt 1596643466 Y 2021-12-17 17:37:27 0
87758 DARKUL020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597014000 0 Y N N B N R Y N N Y 10 1597014000 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 5054285241202 GBN4S1200083 N Copyright Control D.van de Bilt 1596643467 Y 2021-12-17 17:37:27 0
87765 UIR008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285271551 GBKQU2082921 N Underground Industry Records Timothe Terrier 1596643678 Y 2021-12-17 17:37:27 0
87766 UIR008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285271551 GBKQU2082922 N Underground Industry Records Timothe Terrier 1596643678 Y 2021-12-17 17:37:27 0
87789 RID021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597100400 0 Y N N B N R Y N N Y 10 1597100400 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 5054285272541 GBKQU2083082 N Copyright Control Arvid Torstensson 1596645196 Y 2021-12-17 17:37:27 0
87790 RID021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1597100400 0 Y N N B N R Y N N Y 10 1597100400 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 5054285272541 GBKQU2083083 N Copyright Control Arvid Torstensson 1596645197 Y 2021-12-17 17:37:27 0
87873 STI0147 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285137215 GBKQU2058514 N Copyright Control Mikey P & Gee 1596646141 Y 2021-12-17 17:37:27 0
87885 STI0148 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596841200 0 Y N N B N R Y N N Y 10 1596841200 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 5054285137277 GBKQU2058523 N Copyright Control Slamma 1596646375 Y 2021-12-17 17:37:27 0
88045 CRR030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285120514 GBKQU2055365 N Copyright Control Angstfrai 1596647805 Y 2021-12-17 17:37:27 0
88046 CRR030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285120514 GBKQU2055366 N Copyright Control Angstfrai 1596647805 Y 2021-12-17 17:37:27 0
88047 CRR030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285120514 GBKQU2055367 N Copyright Control Angstfrai 1596647805 Y 2021-12-17 17:37:27 0
88048 CRR030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285120514 GBKQU2055368 N Copyright Control Angstfrai 1596647806 Y 2021-12-17 17:37:27 0
88049 CRR030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596754800 0 Y N N B N R Y N N Y 10 1596754800 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 5054285120514 GBKQU2055369 N Copyright Control Angstfrai 1596647806 Y 2021-12-17 17:37:27 0
88055 MOK216 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285226803 NLLB82000064 N Copyright Control Maurice Schipperheijn 1596647812 Y 2021-12-17 17:37:27 0
88056 MOK216 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285226803 NLLB82000065 N Copyright Control Maurice Schipperheijn 1596647812 Y 2021-12-17 17:37:27 0
88057 MOK216 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285226803 NLLB82000066 N Copyright Control Maurice Schipperheijn 1596647812 Y 2021-12-17 17:37:27 0
88069 DARKUL019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285241196 GBKQU2077653 N Copyright Control G.di Mauro 1596647832 Y 2021-12-17 17:37:27 0
88070 DARKUL019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285241196 GBKQU2077654 N Copyright Control G.di Mauro 1596647834 Y 2021-12-17 17:37:27 0
88071 DARKUL019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285241196 GBKQU2077655 N Copyright Control G.di Mauro 1596647834 Y 2021-12-17 17:37:27 0
88128 MOUTHDATA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285241578 GBKQU2077715 N Copyright Control Maurice Pinkster, Stephen Cairns, Greg Dolphin, Greig Smith 1596648122 Y 2021-12-17 17:37:27 0
88129 MOUTHDATA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285241578 GBKQU2077716 N Copyright Control Maurice Pinkster, Stephen Cairns, Greg Dolphin, Greig Smith 1596648122 Y 2021-12-17 17:37:27 0
88130 MOUTHDATA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285241578 GBKQU2077717 N Copyright Control Maurice Pinkster, Stephen Cairns, Greg Dolphin, Greig Smith 1596648122 Y 2021-12-17 17:37:27 0
88131 MOUTHDATA005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1596668400 0 Y N N B N R Y N N Y 10 1596668400 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 5054285241578 GBKQU2077718 N Copyright Control Maurice Pinkster, Stephen Cairns, Greg Dolphin, Greig Smith 1596648123 Y 2021-12-17 17:37:27 0