SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    95595, 95594, 95593, 95592, 95591, 95590, 
    95589, 95588, 95587, 95586, 95585, 
    95584, 95583, 95582, 95581, 95580, 
    95579, 95578, 95577, 95576, 95575, 
    95574, 95573, 95572, 95571, 94905, 
    95440, 95439, 94679, 94678, 94677, 
    94676, 94675, 94674, 94673, 94672, 
    94659, 94629, 94628, 94626
  )

Query time 0.00058

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
94626 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 GBTWT2101651 N 94627 Nu Energy Music Various Artists 1617167721 Y 2021-12-17 17:37:27 0
94628 HDUK009 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 default 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 5054285742600 GBKQU2126667 N Defensive Music Ltd Ian Hollyman, Jamie Jackson 1629451843 Y 2021-12-17 17:37:27 0
94629 HDUK009 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 5054285742600 GBKQU2126668 N Defensive Music Ltd Ian Hollyman, Jamie Jackson 1617167723 Y 2021-12-17 17:37:27 0
94659 HPU005 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 5054285720004 GBKQU2122478 N Copyright Control Tom Sampson & Lesley Anne Johnston 1617168302 Y 2021-12-17 17:37:27 0
94672 Silver004 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 5054285803844 GBKQU2137785 N 94680 Hell's recordings p. de rooij 1617210607 Y 2021-12-17 17:37:27 0
94673 Silver004 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 5054285803844 GBKQU2137786 N 94680 Hell's recordings p. de rooij 1617210607 Y 2021-12-17 17:37:27 0
94674 Silver004 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 5054285803844 GBKQU2137787 N 94680 Hell's recordings p. de rooij 1617210608 Y 2021-12-17 17:37:27 0
94675 Silver004 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 5054285803844 GBKQU2137788 N 94680 Hell's recordings p. de rooij 1617210609 Y 2021-12-17 17:37:27 0
94676 Silver004 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 5054285803844 GBKQU2137789 N 94680 Hell's recordings p. de rooij 1617210609 Y 2021-12-17 17:37:27 0
94677 Silver004 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 5054285803844 GBKQU2137790 N 94680 Hell's recordings p. de rooij 1617210609 Y 2021-12-17 17:37:27 0
94678 Silver004 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 5054285803844 GBKQU2137791 N 94680 Hell's recordings p. de rooij 1617210609 Y 2021-12-17 17:37:27 0
94679 Silver004 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 5054285803844 GBKQU2137792 N 94680 Hell's recordings p. de rooij 1617210610 Y 2021-12-17 17:37:27 0
94905 XTR010 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 5054285830352 GBKQU2141827 N Eric Marhuenda, Sami Haapajoki, Emanuele Agostinetto, Andriy Ursaki, Erica Mingardi, Mattia Pasini Eric Marhuenda, Sami Haapajoki 1618161002 Y 2021-12-17 17:37:27 0
95439 MRV241 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 5054285875438 NLS161802636 N 2 Dex Publishing F. Marazzi 1619629815 Y 2021-12-17 17:37:27 0
95440 MRV241 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 5054285875438 NLS161801482 N 2 Dex Publishing F. Marazzi 1619629856 Y 2021-12-17 17:37:27 0
95571 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 NLS160900210 N 95620 2 Dex Publishing Various Artists 1620148555 Y 2021-12-17 17:37:27 0
95572 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 NLS161100018 N 95620 2 Dex Publishing Various Artists 1620148569 Y 2021-12-17 17:37:27 0
95573 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 NLS160900179 N 95620 2 Dex Publishing Various Artists 1620148585 Y 2021-12-17 17:37:27 0
95574 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 NLS160900023 N 95620 2 Dex Publishing Various Artists 1620148599 Y 2021-12-17 17:37:27 0
95575 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 NLS161000089 N 95620 2 Dex Publishing Various Artists 1620148613 Y 2021-12-17 17:37:27 0
95576 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 NLS161000050 N 95620 2 Dex Publishing Various Artists 1620148628 Y 2021-12-17 17:37:27 0
95577 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 NLS161100033 N 95620 2 Dex Publishing Various Artists 1620148643 Y 2021-12-17 17:37:27 0
95578 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 NLS161000064 N 95620 2 Dex Publishing Various Artists 1620148657 Y 2021-12-17 17:37:27 0
95579 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 NLS161000083 N 95620 2 Dex Publishing Various Artists 1620148674 Y 2021-12-17 17:37:27 0
95580 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 NLS161100020 N 95620 2 Dex Publishing Various Artists 1620148689 Y 2021-12-17 17:37:27 0
95581 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 NLS160900240 N 95620 2 Dex Publishing Various Artists 1620148705 Y 2021-12-17 17:37:27 0
95582 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 NLS160900178 N 95620 2 Dex Publishing Various Artists 1620148721 Y 2021-12-17 17:37:27 0
95583 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 NLS161100122 N 95620 2 Dex Publishing Various Artists 1620148737 Y 2021-12-17 17:37:27 0
95584 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 NLS161100005 N 95620 2 Dex Publishing Various Artists 1620148752 Y 2021-12-17 17:37:27 0
95585 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 NLS160900182 N 95620 2 Dex Publishing Various Artists 1620148765 Y 2021-12-17 17:37:27 0
95586 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 NLS161100165 N 95620 2 Dex Publishing Various Artists 1620148780 Y 2021-12-17 17:37:27 0
95587 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 NLS161100085 N 95620 2 Dex Publishing Various Artists 1620148794 Y 2021-12-17 17:37:27 0
95588 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 NLS161100074 N 95620 2 Dex Publishing Various Artists 1620148810 Y 2021-12-17 17:37:27 0
95589 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 NLS161100096 N 95620 2 Dex Publishing Various Artists 1620148823 Y 2021-12-17 17:37:27 0
95590 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 NLS161100319 N 95620 2 Dex Publishing Various Artists 1620148841 Y 2021-12-17 17:37:27 0
95591 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 NLS161100362 N 95620 2 Dex Publishing Various Artists 1620148856 Y 2021-12-17 17:37:27 0
95592 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 NLS161801108 N 95620 2 Dex Publishing Various Artists 1620148870 Y 2021-12-17 17:37:27 0
95593 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 NLS161100180 N 95620 2 Dex Publishing Various Artists 1620148886 Y 2021-12-17 17:37:27 0
95594 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 NLS161100203 N 95620 2 Dex Publishing Various Artists 1620148900 Y 2021-12-17 17:37:27 0
95595 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 NLS161100089 N 95620 2 Dex Publishing Various Artists 1620148918 Y 2021-12-17 17:37:27 0