SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    125139, 125138, 125136, 125123, 125652, 
    125492, 125025, 125024, 125020, 125568, 
    125566, 124982, 125496, 124870, 124859, 
    124858, 125412, 125411, 124963, 124733, 
    124731, 124573, 124546, 124358, 124737, 
    124650, 124299, 124231, 124217, 124215
  )

Query time 0.00082

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 30 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
124215 Cheek688 P A 1 1.69 1 0.000 0 0 0 0.00 0 1717110000 0 Y N N B N R Y N N Y 10 1717110000 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 5054288041144 GBKQU2419268 N Copyright Control David Amo Filva, Julio Navas Arranz 1717150481 Y 2024-05-01 06:05:10 0
124217 DNRGK3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1717110000 0 Y N N B N R Y N N Y 10 1717110000 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 5054288089504 GBKQU2426234 N Copyright control Katie Weston 1717150499 Y 2024-05-01 06:05:11 0
124231 GREP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1717110000 0 Y N N B N R Y N N Y 10 1717110000 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 5054288145552 GBKQU2434905 N Copyright Control Daniel Gibson 1717150514 Y 2024-05-01 06:20:02 0
124299 UNTIDY085 P A 1 1.69 1 0.000 0 0 0 0.00 0 1717110000 0 Y N N B N R Y N N Y 10 1717110000 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 5054288209971 GBKQU2445154 N Toolbox Publishing Paul Norris, Mark Tench 1717150573 Y 2024-05-05 01:00:02 0
124358 FLA081 P A 1 1.69 1 0.000 0 0 0 0.00 0 1717714800 0 Y N N B N R Y N N Y 10 1717714800 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 5054288203153 GBKQU2444154 N FLAUNT Shaun Williams 1717933393 Y 2024-05-08 06:15:02 0
124546 Cheek690 P A 1 1.69 1 0.000 0 0 0 0.00 0 1718319600 0 Y N N B N R Y N N Y 10 1718319600 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 5054288173395 GBKQU2439127 N Copyright Control Nick Hughes 1718349763 Y 2024-05-15 06:05:13 0
124573 TIDYCT004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1718319600 0 Y N N B N R Y N N Y 10 1718319600 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 5054288225612 GBKQU2447525 N Tidy Publishing Anne Savage, Andrew Pickles, Amadeus Celery Mozart 1718349800 Y 2024-05-15 06:05:19 0
124650 CARN0004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1717110000 0 Y N N B N R Y N N Y 10 1717110000 0 N 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;} 4 N Copyright Control Gav Adam 1717150527 Y 2024-05-20 09:51:37 0
124731 Cheek693 P A 1 1.69 1 0.000 0 0 0 0.00 0 1718924400 0 Y N N B N R Y N N Y 10 1718924400 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 5054288144036 GBKQU2434710 N Copyright Control Darren Sampson, John Matthews 1719559626 Y 2024-05-22 06:05:09 0
124733 DNRGK4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1718924400 0 Y N N B N R Y N N Y 10 1718924400 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 5054288089474 GBKQU2426228 N Copyright control Katie Weston 1719559647 Y 2024-05-22 06:05:09 0
124737 FEER0042 P A 1 1.69 1 0.000 0 0 0 0.00 0 1717110000 0 Y N N B N R Y N N Y 10 1717110000 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;} 4 N Copyright Control Dan Madams 1717150541 Y 31/05/2024 30/06/2024 2024-05-22 09:15:34 0
124858 PAF2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719529200 0 Y N N B N R Y N N Y 10 1719529200 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 5054288203450 GBKQU2444191 N MCPS Don Grant & Andy Allder 1719559824 Y 2024-05-29 06:05:02 0
124859 PAF2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719529200 0 Y N N B N R Y N N Y 10 1719529200 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 5054288203450 GBKQU2444192 N MCPS Don Grant & Andy Allder 1719559840 Y 2024-05-29 06:05:14 0
124870 TIBUK054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719529200 0 Y N N B N R Y N N Y 10 1719529200 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 5054288249687 GBKQU2450780 N Copyright Control Zara Larsson, James Abrahart, Alexander Izquierdo, Marcus Lomax, Stefan Johnson, Jordan Johnson, Karen Chin, Oliver Peterhof, Anthony Kelly 1719559418 Y 2024-05-29 06:10:03 0
124963 RMS011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719442800 0 Y N N B N R Y N N Y 10 1719442800 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 5054288277628 GBKQU2430653 N ReVibe Music Various Artists 1719559611 Y 2024-06-04 01:10:02 0
124982 RMS012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720047600 0 Y N N B N R Y N N Y 10 1720047600 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 5054288277642 GBKQU2412183 N ReVibe Music Various Artists 1720167692 Y 2024-06-04 06:05:11 0
125020 BB24 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720134000 0 Y N N B N R Y N N Y 10 1720134000 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 5054288257781 GBKQU2452013 N Bouncing Bomb Digital Danny Gibson 1720167730 Y 2024-06-05 06:15:01 0
125024 TIBUK055 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720134000 0 Y N N B N R Y N N Y 10 1720134000 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 5054288249649 GBKQU2450776 N Copyright Control Kymberley Myles 1720167741 Y 2024-06-05 06:25:02 0
125025 GR016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720134000 0 Y N N B N R Y N N Y 10 1720134000 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 5054288223458 GBKQU2447164 N Copyright Control Daniel Gibson 1720167752 Y 2024-06-05 06:25:02 0
125123 RMS013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720652400 0 Y N N B N R Y N N Y 10 1720652400 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 5054288294557 GBKQU2430658 N ReVibe Music Various Artists 1720766811 Y 2024-06-11 06:10:03 0
125136 Cheek695 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720738800 0 Y N N B N R Y N N Y 10 1720738800 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 5054288194765 GBKQU2442836 N Copyright Control Kieron Hughes, Kenny Hayes 1720766821 Y 2024-06-12 06:05:02 0
125138 DNRGK5 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720738800 0 Y N N B N R Y N N Y 10 1720738800 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 5054288089511 GBKQU2426236 N Copyright control Katie Weston 1720766833 Y 2024-06-12 06:05:03 0
125139 FLA084 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720738800 0 Y N N B N R Y N N Y 10 1720738800 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 5054288294755 GBKQU2457449 N FLAUNT Gav Adam & Ali Wilson 1720766847 Y 2024-06-12 06:05:03 0
125411 SVR004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719442800 0 Y N N B N R Y N N Y 10 1719442800 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 5054288321215 GBKQU2461538 N 125422 Copyright Control Various Artists 1719559445 Y 2024-06-25 01:35:06 0
125412 SVR004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719442800 0 Y N N B N R Y N N Y 10 1719442800 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 5054288321215 GBKQU2461539 N 125422 Copyright Control Various Artists 1719559437 Y 2024-06-25 01:35:06 0
125492 TIDYCT006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720134000 0 Y N N B N R Y N N Y 10 1720134000 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 5054288334390 GBKQU2463737 N Copyright Control Alan Prosser, Alan Wragg 1720162305 Y 2024-06-28 01:00:02 0
125496 MM012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719532803 0 Y N N B N R Y N N Y 10 1719529200 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 5054288333829 GBKQU2463685 N Manic Music Rob Cain 1719559405 Y 2024-06-28 01:00:03 0
125566 TIDYHF001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1720047600 0 Y N N B N R Y N N Y 10 1720047600 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 5054288332051 GBKQU2463409 N 125591 Copyright Control Various Artists 1720167711 Y 2024-07-02 06:10:09 0
125568 TIDYHF001D P A 1 1.69 1 0.000 0 0 0 0.00 0 1720047600 0 Y N N B N R Y N N Y 10 1720047600 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 5054288332051 GBKQU2463411 N 125591 Copyright Control Various Artists 1720167716 Y 2024-07-02 06:10:10 0
125652 SUB012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720134000 0 Y N N B N R Y N N Y 10 1720134000 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 5054288350765 GBKQU2466036 N Tidy Trax Stephen Ansell, Sarah Ansell 1720766797 Y 2024-07-06 06:40:02 0