SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    94742, 94741, 94740, 94739, 94738, 94737, 
    94736, 94735, 94734, 94733, 94732, 
    94731, 94730, 94729, 94728, 94727, 
    95619, 95618, 95617, 95616, 95615, 
    95614, 95613, 95612, 95611, 95610, 
    95609, 95608, 95607, 95606, 95605, 
    95604, 95603, 95602, 95601, 95600, 
    95599, 95598, 95597, 95596
  )

Query time 0.00063

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
94727 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105864 N 94747 Contagious Records Various Artists 1617426304 Y 2021-12-17 17:37:27 0
94728 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105865 N 94747 Contagious Records Various Artists 1617426304 Y 2021-12-17 17:37:27 0
94729 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105866 N 94747 Contagious Records Various Artists 1617426304 Y 2021-12-17 17:37:27 0
94730 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105867 N 94747 Contagious Records Various Artists 1617426304 Y 2021-12-17 17:37:27 0
94731 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105868 N 94747 Contagious Records Various Artists 1617426305 Y 2021-12-17 17:37:27 0
94732 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105869 N 94747 Contagious Records Various Artists 1617426305 Y 2021-12-17 17:37:27 0
94733 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105870 N 94747 Contagious Records Various Artists 1617426305 Y 2021-12-17 17:37:27 0
94734 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105871 N 94747 Contagious Records Various Artists 1617426305 Y 2021-12-17 17:37:27 0
94735 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105872 N 94747 Contagious Records Various Artists 1617426306 Y 2021-12-17 17:37:27 0
94736 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105873 N 94747 Contagious Records Various Artists 1617426306 Y 2021-12-17 17:37:27 0
94737 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105874 N 94747 Contagious Records Various Artists 1617426306 Y 2021-12-17 17:37:27 0
94738 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105875 N 94747 Contagious Records Various Artists 1617426306 Y 2021-12-17 17:37:27 0
94739 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105876 N 94747 Contagious Records Various Artists 1617426307 Y 2021-12-17 17:37:27 0
94740 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105877 N 94747 Contagious Records Various Artists 1617426307 Y 2021-12-17 17:37:27 0
94741 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105878 N 94747 Contagious Records Various Artists 1617426307 Y 2021-12-17 17:37:27 0
94742 TBOCR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619996400 0 Y N N B N R Y N N Y 10 1619996400 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 5054285623213 GBKQU2105879 N 94747 Contagious Records Various Artists 1617426307 Y 2021-12-17 17:37:27 0
95596 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161100339 N 95620 2 Dex Publishing Various Artists 1620148932 Y 2021-12-17 17:37:27 0
95597 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161100585 N 95620 2 Dex Publishing Various Artists 1620148944 Y 2021-12-17 17:37:27 0
95598 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161600349 N 95620 2 Dex Publishing Various Artists 1620148958 Y 2021-12-17 17:37:27 0
95599 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161100499 N 95620 2 Dex Publishing Various Artists 1620148975 Y 2021-12-17 17:37:27 0
95600 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161801332 N 95620 2 Dex Publishing Various Artists 1620148991 Y 2021-12-17 17:37:27 0
95601 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161500214 N 95620 2 Dex Publishing Various Artists 1620149005 Y 2021-12-17 17:37:27 0
95602 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161802636 N 95620 2 Dex Publishing Various Artists 1620149020 Y 2021-12-17 17:37:27 0
95603 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161802385 N 95620 2 Dex Publishing Various Artists 1620149034 Y 2021-12-17 17:37:27 0
95604 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161802600 N 95620 2 Dex Publishing Various Artists 1620149045 Y 2021-12-17 17:37:27 0
95605 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161802680 N 95620 2 Dex Publishing Various Artists 1620149055 Y 2021-12-17 17:37:27 0
95606 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161802160 N 95620 2 Dex Publishing Various Artists 1620149069 Y 2021-12-17 17:37:27 0
95607 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161801145 N 95620 2 Dex Publishing Various Artists 1620149081 Y 2021-12-17 17:37:27 0
95608 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161801360 N 95620 2 Dex Publishing Various Artists 1620149095 Y 2021-12-17 17:37:27 0
95609 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161801481 N 95620 2 Dex Publishing Various Artists 1620149108 Y 2021-12-17 17:37:27 0
95610 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161802637 N 95620 2 Dex Publishing Various Artists 1620149122 Y 2021-12-17 17:37:27 0
95611 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161801482 N 95620 2 Dex Publishing Various Artists 1620149136 Y 2021-12-17 17:37:27 0
95612 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161801496 N 95620 2 Dex Publishing Various Artists 1620149151 Y 2021-12-17 17:37:27 0
95613 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161801560 N 95620 2 Dex Publishing Various Artists 1620149162 Y 2021-12-17 17:37:27 0
95614 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161801769 N 95620 2 Dex Publishing Various Artists 1620149177 Y 2021-12-17 17:37:27 0
95615 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161802672 N 95620 2 Dex Publishing Various Artists 1620149191 Y 2021-12-17 17:37:27 0
95616 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161801772 N 95620 2 Dex Publishing Various Artists 1620149206 Y 2021-12-17 17:37:27 0
95617 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161801897 N 95620 2 Dex Publishing Various Artists 1620149220 Y 2021-12-17 17:37:27 0
95618 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161600354 N 95620 2 Dex Publishing Various Artists 1620149234 Y 2021-12-17 17:37:27 0
95619 MR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619823600 0 Y N N B N R Y N N Y 10 1619823600 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 5054285880173 NLS161802491 N 95620 2 Dex Publishing Various Artists 1620149243 Y 2021-12-17 17:37:27 0