SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    125358, 125461, 125089, 125066, 125487, 
    124934, 125127, 124797, 124795, 124990, 
    124970, 124816, 125134, 125133, 125030, 
    124778, 124470, 124653, 124477, 124475, 
    124857, 124312, 124309, 124180, 124483, 
    124302, 124301, 124033, 124449, 124269
  )

Query time 0.00072

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
124033 ONESEVENTY196 P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288178598 GBKQU2439843 N Bucks Music Group Alfie Bamford 1716367524 N 2024-04-25 01:05:02 0
124180 BONKERS011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1716937200 0 Y N N B N R Y N N Y 10 1716937200 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 5054288175344 GBKQU2439389 N Copyright Control Michael O'Brien, Matthew Davis 1717152145 Y 2024-04-29 06:05:04 0
124269 BONKERS010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1715295600 0 Y N N B N R Y N N Y 10 1715295600 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 5054288208622 GBKQU2444987 N Copyright Control Johnathan Kneath, Joseph McHugh 1715323570 Y 2024-05-04 01:25:01 0
124301 TWORMX007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288209902 GBKQU2445148 N Tidy Publishing / Copyright Control Scott Attrill, Chris Grayston 1716367535 Y 2024-05-05 01:05:01 0
124302 TWORMX007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288209902 GBKQU2445149 N Tidy Publishing / Copyright Control Scott Attrill, Chris Grayston 1716367543 Y 2024-05-05 01:05:02 0
124309 ONESEVENTY197 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 5054288213251 GBKQU2445677 N Copyright Control Jennifer Melsopp 1717152097 N 2024-05-08 01:00:16 0
124312 KU103 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 5054288215552 GBKQU2446080 N Copyright Control Nick Ingman, Rob Dougan 1717933480 Y 2024-05-08 01:00:16 0
124449 LTR075 P A 1 1.69 1 0.000 0 0 0 0.00 0 1715641200 0 Y N N B N R Y N N Y 10 1715641200 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 5054288221195 GBKQU2446927 N Toffmusic Ying-Cheng Peng, Wei-Jyun Wang 1716367510 Y 2024-05-10 01:00:07 0
124470 SD233 P A 1 1.69 1 0.000 0 0 0 0.00 0 1718146800 0 Y N N B N R Y N N Y 10 1718146800 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 5054288205690 GBKQU2444535 N Peer Music Paul Austen 1718349997 Y 2024-05-13 06:05:01 0
124475 ONESEVENTY198 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 5054288228439 GBKQU2447974 N Bucks Music Group, Copyright Control Alfie Bamford, Jason Lau 1717933585 N 2024-05-14 01:00:14 0
124477 RR001 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 5054288229924 GBKQU2448140 N Copyright Control Michael Parker-Goulding, Dominik Petranovic, Bert Brueggemann, Norman Williams, Dennis Rusch, Laurens Van Steenbergen 1717933603 Y 2024-05-14 01:00:14 0
124483 TWORMXB001 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 5054288225803 GBKQU2340308 N 124499 Tidy Publishing, Copyright Control Various Artists 1716533939 Y 2024-05-14 01:00:16 0
124653 CR261 P A 1 1.69 1 0.000 0 0 0 0.00 0 1717974000 0 Y N N B N R Y N N Y 10 1717974000 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 5054288243371 GBKQU2449990 N Contagious Records Riko Norton-Wilkes & James Waller 1718349968 Y 2024-05-21 01:00:01 0
124778 BONKLEG004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1718146800 0 Y N N B N R Y N N Y 10 1718146800 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 5054288250409 GBKQU2450904 N Copyright Control Jonathan Kneath 1718350011 Y 2024-05-24 01:00:02 0
124795 CR262 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719183600 0 Y N N B N R Y N N Y 10 1719183600 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 5054288243418 GBKQU2450017 N Contagious Records Riko Norton-Wilkes & Kirsti Flannery 1719560157 Y 2024-05-25 06:05:06 0
124797 NINJAHC015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719183600 0 Y N N B N R Y N N Y 10 1719183600 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 5054288229283 GBKQU2448074 N Copyright Control Leigh Garner 1719560144 Y 2024-05-25 06:10:02 0
124816 JH379 P A 1 1.69 1 0.000 0 0 0 0.00 0 1718751600 0 Y N N B N R Y N N Y 10 1718751600 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 5054288263218 GBKQU2452761 N Copyright Control Stuart Wrenn 1718982414 Y 2024-05-29 01:00:26 0
124857 NTWO063 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 5054288264130 GBKQU2452925 N Copyright Control J.Roberts, A.Bennett 1717152082 Y 2024-05-29 01:40:04 0
124934 STI381 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719788400 0 Y N N B N R Y N N Y 10 1719788400 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 5054288242695 GBKQU2449875 N Copyright Control Gavin Covington 1720167837 Y 2024-06-01 06:05:02 0
124970 SD234 P A 1 1.69 1 0.000 0 0 0 0.00 0 1718751600 0 Y N N B N R Y N N Y 10 1718751600 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 5054288274870 GBKQU2454537 N Peer Music Mike Elliot 1718982424 Y 2024-06-04 01:10:04 0
124990 ONESEVENTY200 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 5054288281052 GBKQU2455486 N 120 Publishing Pty Ltd, Bucks Music Group James Stanhope, Alfie Bamford 1718982437 Y 2024-06-05 01:00:01 0
125030 ONESEVENTY199 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 5054288281038 GBKQU2455481 N Copyright Control Michael O'Brien, Matthew Davis 1718350023 N 2024-06-06 01:05:01 0
125066 CR263 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720393200 0 Y N N B N R Y N N Y 10 1720393200 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 5054288243487 GBKQU2450020 N Contagious Records Riko Norton-Wilkes & James Waller 1720767033 Y 2024-06-08 06:05:10 0
125089 JH381 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720566000 0 Y N N B N R Y N N Y 10 1720566000 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 5054288275877 GBKQU2454713 N Copyright Control Ryan Sanders 1720767050 Y 2024-06-10 06:05:02 0
125127 NTWO066 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 5054288298753 GBKQU2458036 N Copyright Control Mark Gee, Craig Serenity 1719560170 Y 2024-06-12 01:05:02 0
125133 NTWO064 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 5054288298739 GBKQU2458033 N Copyright Control Kel Haynes 1718350038 Y 2024-06-12 01:10:02 0
125134 NTWO064 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 5054288298739 GBKQU2458034 N Copyright Control Kel Haynes 1718350044 Y 2024-06-12 01:10:02 0
125358 NTWO065 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 5054288320836 GBKQU2461465 N Copyright Control Brett Cooper, William Kinniar 1720767064 Y 2024-06-21 01:00:02 0
125461 SD235 P A 1 1.69 1 0.000 0 0 0 0.00 0 1720566000 0 Y N N B N R Y N N Y 10 1720566000 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 5054288327330 GBKQU2462699 N Peer Music Kel Haynes, Shaun White 1720767078 Y 2024-06-26 01:20:02 0
125487 BONKERS013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1719874800 0 Y N N B N R Y N N Y 10 1719874800 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 5054288329990 GBKQU2463094 N Copyright Control Kyle Gawley, Richard Besgrove 1720167848 Y 2024-06-27 02:20:01 0