SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    94625, 94624, 94623, 94622, 94621, 94620, 
    94619, 94618, 94617, 94616, 94615, 
    94614, 94613, 94612, 94611, 94610, 
    94609, 94608, 94607, 94606, 94605, 
    94604, 94603, 94602, 94601, 94600, 
    94599, 94598, 94597, 94596, 94595, 
    94594, 94593, 95222, 95221, 95220, 
    95219, 94863, 94862, 94697
  )

Query time 0.00075

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
94593 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101614 N 94627 Nu Energy Music Various Artists 1617167714 Y 2021-12-17 17:37:27 0
94594 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101615 N 94627 Nu Energy Music Various Artists 1617167714 Y 2021-12-17 17:37:27 0
94595 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101616 N 94627 Nu Energy Music Various Artists 1617167714 Y 2021-12-17 17:37:27 0
94596 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101617 N 94627 Nu Energy Music Various Artists 1617167714 Y 2021-12-17 17:37:27 0
94597 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101618 N 94627 Nu Energy Music Various Artists 1617167715 Y 2021-12-17 17:37:27 0
94598 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101622 N 94627 Nu Energy Music Various Artists 1617167715 Y 2021-12-17 17:37:27 0
94599 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101623 N 94627 Nu Energy Music Various Artists 1617167715 Y 2021-12-17 17:37:27 0
94600 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101624 N 94627 Nu Energy Music Various Artists 1617167715 Y 2021-12-17 17:37:27 0
94601 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101625 N 94627 Nu Energy Music Various Artists 1617167715 Y 2021-12-17 17:37:27 0
94602 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101626 N 94627 Nu Energy Music Various Artists 1617167716 Y 2021-12-17 17:37:27 0
94603 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101628 N 94627 Nu Energy Music Various Artists 1617167716 Y 2021-12-17 17:37:27 0
94604 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101629 N 94627 Nu Energy Music Various Artists 1617167716 Y 2021-12-17 17:37:27 0
94605 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101630 N 94627 Nu Energy Music Various Artists 1617167716 Y 2021-12-17 17:37:27 0
94606 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101631 N 94627 Nu Energy Music Various Artists 1617167717 Y 2021-12-17 17:37:27 0
94607 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101632 N 94627 Nu Energy Music Various Artists 1617167717 Y 2021-12-17 17:37:27 0
94608 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101633 N 94627 Nu Energy Music Various Artists 1617167717 Y 2021-12-17 17:37:27 0
94609 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101634 N 94627 Nu Energy Music Various Artists 1617167717 Y 2021-12-17 17:37:27 0
94610 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101635 N 94627 Nu Energy Music Various Artists 1617167717 Y 2021-12-17 17:37:27 0
94611 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101636 N 94627 Nu Energy Music Various Artists 1617167717 Y 2021-12-17 17:37:27 0
94612 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101637 N 94627 Nu Energy Music Various Artists 1617167718 Y 2021-12-17 17:37:27 0
94613 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101638 N 94627 Nu Energy Music Various Artists 1617167718 Y 2021-12-17 17:37:27 0
94614 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101639 N 94627 Nu Energy Music Various Artists 1617167718 Y 2021-12-17 17:37:27 0
94615 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101640 N 94627 Nu Energy Music Various Artists 1617167718 Y 2021-12-17 17:37:27 0
94616 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101641 N 94627 Nu Energy Music Various Artists 1617167718 Y 2021-12-17 17:37:27 0
94617 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101642 N 94627 Nu Energy Music Various Artists 1617167718 Y 2021-12-17 17:37:27 0
94618 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101643 N 94627 Nu Energy Music Various Artists 1617167719 Y 2021-12-17 17:37:27 0
94619 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101644 N 94627 Nu Energy Music Various Artists 1617167719 Y 2021-12-17 17:37:27 0
94620 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101645 N 94627 Nu Energy Music Various Artists 1617167719 Y 2021-12-17 17:37:27 0
94621 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101646 N 94627 Nu Energy Music Various Artists 1617167720 Y 2021-12-17 17:37:27 0
94622 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101647 N 94627 Nu Energy Music Various Artists 1617167721 Y 2021-12-17 17:37:27 0
94623 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101648 N 94627 Nu Energy Music Various Artists 1617167721 Y 2021-12-17 17:37:27 0
94624 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101649 N 94627 Nu Energy Music Various Artists 1617167721 Y 2021-12-17 17:37:27 0
94625 NUNRG71to80RM P A 1 1.69 1 0.000 0 0 0 0.00 0 1619737200 0 Y N N B N R Y N N Y 10 1619737200 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 5054285694596 GBTWT2101650 N 94627 Nu Energy Music Various Artists 1617167721 Y 2021-12-17 17:37:27 0
94697 KARNAGEDIGITA20 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619650800 0 Y N N B N R Y N N Y 10 1619650800 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 5054285808054 GBKQU2138422 N 94698 Copyright Control Thais Morel 1617339912 Y 2021-12-17 17:37:27 0
94862 CATID090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619650800 0 Y N N B N R Y N N Y 10 1619650800 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 5054285820520 NLN6L2100023 N The Funky Cat Publishing Sjef van der Heijden, C.S. Jensen 1617902402 Y 2021-12-17 17:37:27 0
94863 CATID090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619650800 0 Y N N B N R Y N N Y 10 1619650800 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 5054285820520 NLN6L2100024 N The Funky Cat Publishing Sjef van der Heijden, C.S. Jensen 1617902403 Y 2021-12-17 17:37:27 0
95219 MOUTHDATA093 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619650800 0 Y N N B N R Y N N Y 10 1619650800 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 5054285856178 GBKQU2145564 N Copyright Control Carl Alexandrow, Peter Nitschke 1618938902 Y 2021-12-17 17:37:27 0
95220 MOUTHDATA093 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619650800 0 Y N N B N R Y N N Y 10 1619650800 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 5054285856178 GBKQU2145565 N Copyright Control Carl Alexandrow, Peter Nitschke 1618938902 Y 2021-12-17 17:37:27 0
95221 MOUTHDATA093 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619650800 0 Y N N B N R Y N N Y 10 1619650800 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 5054285856178 GBKQU2145566 N Copyright Control Carl Alexandrow, Peter Nitschke 1618938902 Y 2021-12-17 17:37:27 0
95222 MOUTHDATA093 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619650800 0 Y N N B N R Y N N Y 10 1619650800 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 5054285856178 GBKQU2145567 N Copyright Control Carl Alexandrow, Peter Nitschke 1618938903 Y 2021-12-17 17:37:27 0