SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    125022, 124984, 124864, 125040, 124545, 
    124306, 124500, 124267, 123527, 123663, 
    122622, 121624, 120857, 120309, 120299, 
    119361, 118451, 118450, 118222, 117510, 
    117207, 117055, 116706, 116944, 116153, 
    115940, 114765, 114227, 113387, 112100
  )

Query time 0.00074

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
112100 BTN048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1672358400 0 Y N N B N R Y N N Y 10 1672358400 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 5054286984474 GBKQU2296434 N Tidy Publishing Paul Clark 1673036599 Y 2022-11-30 07:00:03 0
113387 KTRAR077 P A 1 1.69 1 0.000 0 0 0 0.00 0 1675987200 0 Y N N B N R Y N N Y 10 1675987200 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 5054287171927 GBKQU2308775 N Copyright Control Christopher Kirkpatrick, Klaus Kazamias 1679042979 Y 2023-01-23 18:30:03 0
114227 BTN053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1677258905 0 Y N N B N R Y N N Y 10 1677196800 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 5054287250196 GBKQU2320503 N Copyright Control Darren Simpson 1679041714 Y 2023-02-24 18:15:05 0
114765 TR201 P A 1 1.69 1 0.000 0 0 0 0.00 0 1680217200 0 Y N N B N R Y N N Y 10 1680217200 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 5054287313457 GBKQU2329949 N Copyright Control Jason Briley 1698139132 Y 2023-03-24 18:45:01 0
115940 ASR35 P A 1 1.69 1 0.000 0 0 0 0.00 0 1686870000 0 Y N N B N R Y N N Y 10 1686870000 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 5054287405886 GBKQU2345139 N Peer Music Matthew Harris, Scott Harris 1698139174 Y 2023-05-17 06:30:09 0
116153 ASR36 P A 1 1.69 1 0.000 0 0 0 0.00 0 1687993200 0 Y N N B N R Y N N Y 10 1687993200 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 5054287426133 GBKQU2348062 N Copyright Control Josh Pollak & Aaron Rennoldson 1698138929 Y 2023-05-30 06:15:01 0
116706 ASR37 P A 1 1.69 1 0.000 0 0 0 0.00 0 1690498800 0 Y N N B N R Y N N Y 10 1690498800 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 5054287506545 GBKQU2360074 N Peer Music Matthew Harris 1698138883 Y 2023-06-28 06:15:15 0
116944 STACK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1689894000 0 Y N N B N R Y N N Y 10 1689894000 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 5054287544523 GBKQU2365846 N Copyright Control Matty Ralph 1698139401 Y 2023-07-11 07:15:02 0
117055 STRAX036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1691708400 0 Y N N B N R Y N N Y 10 1691708400 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;} xelon 9358782645270 AUXN22340256 N Copyright Control Rizzlatto, Molella, Carmeni 1698139052 Y 2023-07-13 08:00:03 0
117207 ASR38 P A 1 1.69 1 0.000 0 0 0 0.00 0 1692313200 0 Y N N B N R Y N N Y 10 1692313200 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 5054287538966 GBKQU2365104 N Peer Music Matthew Harris & James Mcoldrick 1698139034 Y 2023-07-19 08:30:02 0
117510 ASR39 P A 1 1.69 1 0.000 0 0 0 0.00 0 1693522800 0 Y N N B N R Y N N Y 10 1693522800 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 5054287558155 GBKQU2367908 N Copyright Control Adam Brownlie 1698139014 Y 2023-08-02 08:45:02 0
118222 STACK009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1694732400 0 Y N N B N R Y N N Y 10 1694732400 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 5054287664733 GBKQU2384932 N Copyright Control Cody Aaron Wong 1698139387 Y 2023-09-07 07:00:02 0
118450 UFLP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1697410800 0 Y N N B N R Y N N Y 10 1697410800 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 5054287680825 GBKQU2387245 N 118456 Copyright Control Mallorca Lee & Ian Bland 1698138987 Y 2023-09-22 18:45:25 0
118451 UFLP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1697410800 0 Y N N B N R Y N N Y 10 1697410800 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 5054287680825 GBKQU2387246 N 118456 Copyright Control Mallorca Lee & Ian Bland 1698138993 Y 2023-09-22 18:45:27 0
119361 SDA014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287780723 GBLV62303345 N 119372 Peer Music Al Storm, Rob IYF, Kaylene Sc@r, UFO, Alaguan, Eazyvibe, Daniel Seven, DUNE, AOS, Ezkil, Kel X-Cyte, Rescue, Adam Mohican, Dionne, Ian K, Stompy, Intraspekt, Brett Cooper, Assailant, Emoticon, Zetamale, Candy Kid, Headsplitterz, Insane & Mind, Simon Apex, 1701158878 Y 2023-11-10 04:05:13 0
120299 WZ021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1700784000 0 Y N N B N R Y N N Y 10 1700784000 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 5054287756452 GBKQU2399277 N GRNVLD Music (CTM Publishing) Koen Groeneveld 1702027376 Y 2023-12-04 19:03:21 0
120309 BTN064 P A 1 1.69 1 0.000 0 0 0 0.00 0 1701475200 0 Y N N B N R Y N N Y 10 1701475200 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 5054287774487 GBLV62302420 N Copyright Control Jona D 1702027392 Y 2023-12-04 19:14:28 0
120857 NTWO054D P A 1 1.69 1 0.000 0 0 0 0.00 0 1702617038 0 Y N N B N R Y N N Y 10 1702598400 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 5054287880263 GBLV62316914 N Tidy Publishing, Copyright Control Rob Tissera, Scott Attrill, Jim Sullivan 1703263248 Y 2023-12-15 06:10:38 0
121624 ASR40D P A 1 1.69 1 0.000 0 0 0 0.00 0 1708560000 0 Y N N B N R Y N N Y 10 1708560000 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 5054287921461 GBKQU2376354 N Copyright Control Matthew Harris, Adam Brownlie 1708676717 Y 2024-01-23 06:07:09 0
122622 TIDYHHB004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1709251200 0 Y N N B N R Y N N Y 10 1709251200 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 5054288053376 GBKQU2420995 N 122627 Copyright Control Various Artists 1709281604 Y 2024-02-29 01:07:16 0
123527 PIA010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1714086000 0 Y N N B N R Y N N Y 10 1714086000 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 5054287995240 GBKQU2412922 N Sentric Music David Williams 1714719019 Y 2024-03-27 06:16:52 0
123663 TR204 P A 1 1.69 1 0.000 0 0 0 0.00 0 1712876400 0 Y N N B N R Y N N Y 10 1712876400 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 5054288137489 GBKQU2433763 N Copyright Control Rich Chubbs 1714116447 Y 2024-04-05 01:00:27 0
124267 K405R081 P A 1 1.69 1 0.000 0 0 0 0.00 0 1716505200 0 Y N N B N R Y N N Y 10 1716505200 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 5054288209087 GBYKK2400002 N K405 Records Kris Ryeland 1716533794 Y 2024-05-04 01:00:06 0
124306 K405R080 P A 1 1.69 1 0.000 0 0 0 0.00 0 1717628400 0 Y N N B N R Y N N Y 10 1717628400 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 5054288192044 GBYKK2400001 N K405 Records Kris Ryeland 1717933495 Y 2024-05-07 06:05:01 0
124500 TRHG001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1716505200 0 Y N N B N R Y N N Y 10 1716505200 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 5054288192778 GBKQU1339434 N 124516 Cop Various Artists 1716533777 Y 2024-05-14 01:00:20 0
124545 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 GBKQU2439126 N Copyright Control Nick Hughes 1719559789 Y 2024-05-15 06:05:13 0
124864 FE609 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 5054288204754 GBKQU2444371 N Fatal Energy Records Paul Murphy 1719559867 Y 2024-05-29 06:10:02 0
124984 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 GBKQU2430657 N ReVibe Music Various Artists 1720167780 Y 2024-06-04 06:05:11 0
125022 FE612 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 5054288204808 GBKQU2444376 N Fatal Energy Records Robert Curtis 1720766913 Y 2024-06-05 06:15:02 0
125040 K405R083 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 5054288288914 GBYKK2400004 N K405 Records Michael Steventon Thomas 1719559801 Y 2024-06-07 01:05:01 0