SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    96636, 96635, 96634, 96633, 96632, 96631, 
    96630, 96629, 96628, 96627, 96626, 
    95927, 95925, 95924, 95919, 95918, 
    95917, 95916, 95915, 95914, 95913, 
    95912, 95911, 95910, 95909, 95908, 
    95907, 95906, 95905, 95904, 95903, 
    95902, 95901, 95900, 95899, 96116, 
    96115, 95890, 95889, 95888
  )

Query time 0.00051

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
95888 ONESEVENTY103 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623279600 0 Y N N B N R Y N N Y 10 1623279600 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 5054285877524 GBKQU2150196 N Songtrust, Peermusic Andre McCann, Angel Lane, Jack Newman 1620709505 Y 2021-12-17 17:37:27 0
95889 ONESEVENTY103 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623279600 0 Y N N B N R Y N N Y 10 1623279600 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 5054285877524 GBKQU2150200 N Songtrust, Peermusic Andre McCann, Angel Lane, Jack Newman 1620709505 Y 2021-12-17 17:37:27 0
95890 ONESEVENTY103 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623279600 0 Y N N B N R Y N N Y 10 1623279600 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 5054285877524 GBKQU2150197 N Songtrust, Peermusic Andre McCann, Angel Lane, Jack Newman 1620709506 Y 2021-12-17 17:37:27 0
95899 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101726 N 95920 Various publishers Various artists 1620796204 Y 2021-12-17 17:37:27 0
95900 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101727 N 95920 Various publishers Various artists 1620796205 Y 2021-12-17 17:37:27 0
95901 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101728 N 95920 Various publishers Various artists 1620796205 Y 2021-12-17 17:37:27 0
95902 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101729 N 95920 Various publishers Various artists 1620796205 Y 2021-12-17 17:37:27 0
95903 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBKQU2149965 N 95920 Various publishers Various artists 1620796206 Y 2021-12-17 17:37:27 0
95904 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101731 N 95920 Various publishers Various artists 1620796206 Y 2021-12-17 17:37:27 0
95905 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101732 N 95920 Various publishers Various artists 1620796206 Y 2021-12-17 17:37:27 0
95906 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101733 N 95920 Various publishers Various artists 1620796206 Y 2021-12-17 17:37:27 0
95907 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101734 N 95920 Various publishers Various artists 1620796206 Y 2021-12-17 17:37:27 0
95908 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101735 N 95920 Various publishers Various artists 1620796207 Y 2021-12-17 17:37:27 0
95909 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101736 N 95920 Various publishers Various artists 1620796207 Y 2021-12-17 17:37:27 0
95910 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101737 N 95920 Various publishers Various artists 1620796207 Y 2021-12-17 17:37:27 0
95911 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101738 N 95920 Various publishers Various artists 1620796207 Y 2021-12-17 17:37:27 0
95912 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101739 N 95920 Various publishers Various artists 1620796207 Y 2021-12-17 17:37:27 0
95913 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101740 N 95920 Various publishers Various artists 1620796208 Y 2021-12-17 17:37:27 0
95914 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101741 N 95920 Various publishers Various artists 1620796208 Y 2021-12-17 17:37:27 0
95915 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101743 N 95920 Various publishers Various artists 1620796208 Y 2021-12-17 17:37:27 0
95916 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101744 N 95920 Various publishers Various artists 1620796208 Y 2021-12-17 17:37:27 0
95917 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101745 N 95920 Various publishers Various artists 1620796209 Y 2021-12-17 17:37:27 0
95918 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101746 N 95920 Various publishers Various artists 1620796209 Y 2021-12-17 17:37:27 0
95919 rlnt011to020rm P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285876558 GBTWT2101747 N 95920 Various publishers Various artists 1620796209 Y 2021-12-17 17:37:27 0
95924 Cheek521B P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285655177 GBKQU2111548 N Copyright Control Jenna Barr, Mickey Skeedale 1620796502 Y 2021-12-17 17:37:27 0
95925 Cheek521B P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285655177 GBKQU2111549 N Copyright Control Jenna Barr, Mickey Skeedale 1629451935 Y 2021-12-17 17:37:27 0
95927 STI0211 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285837665 GBKQU2142709 N Copyright Control B. Carberry 1620796801 Y 2021-12-17 17:37:27 0
96115 MOK234 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623279600 0 Y N N B N R Y N N Y 10 1623279600 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 5054285920015 NLLB82100042 N Copyright Control Sander de Vet 1621357502 Y 2021-12-17 17:37:27 0
96116 MOK234 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623279600 0 Y N N B N R Y N N Y 10 1623279600 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 5054285920015 NLLB82100043 N Copyright Control Sander de Vet 1621357502 Y 2021-12-17 17:37:27 0
96626 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100070 N 96641 Peer Music / Copyright Control R.Cox 1622654408 Y 2021-12-17 17:37:27 0
96627 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100071 N 96641 Peer Music / Copyright Control R.Cox 1622654408 Y 2021-12-17 17:37:27 0
96628 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100072 N 96641 Peer Music / Copyright Control R.Cox 1622654408 Y 2021-12-17 17:37:27 0
96629 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100073 N 96641 Peer Music / Copyright Control R.Cox 1622654408 Y 2021-12-17 17:37:27 0
96630 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100074 N 96641 Peer Music / Copyright Control R.Cox 1622654408 Y 2021-12-17 17:37:27 0
96631 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100075 N 96641 Peer Music / Copyright Control R.Cox 1622654409 Y 2021-12-17 17:37:27 0
96632 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100076 N 96641 Peer Music / Copyright Control R.Cox 1622654409 Y 2021-12-17 17:37:27 0
96633 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100077 N 96641 Peer Music / Copyright Control R.Cox 1622654409 Y 2021-12-17 17:37:27 0
96634 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100078 N 96641 Peer Music / Copyright Control R.Cox 1622654410 Y 2021-12-17 17:37:27 0
96635 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100079 N 96641 Peer Music / Copyright Control R.Cox 1622654410 Y 2021-12-17 17:37:27 0
96636 247HCLP020P2 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 5054285937259 UKT6B2100080 N 96641 Peer Music / Copyright Control R.Cox 1622654411 Y 2021-12-17 17:37:27 0