SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    89607, 89606, 89605, 89604, 89603, 89602, 
    89601, 89600, 90393, 90163, 90070, 
    90069, 90068, 89588, 89587, 89535, 
    89534, 90287, 89533, 90328, 90327, 
    89543, 89530, 89529, 89528, 89517, 
    89487, 89486, 90303, 90302, 90301, 
    90300, 90299, 90298, 90297, 90296, 
    90295, 90294, 90293, 90292
  )

Query time 0.00069

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
89486 STI0170 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604102400 0 Y N N B N R Y N N Y 10 1604102400 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 5054285369227 GBLV62002182 N Copyright Control Area51 1601529301 Y 2021-12-17 17:37:27 0
89487 CRR042 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604102400 0 Y N N B N R Y N N Y 10 1604102400 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 5054285275832 GBKQU2083664 N Copyright Control Corerrior 1601529302 Y 2021-12-17 17:37:27 0
89517 STI0171 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604188800 0 Y N N B N R Y N N Y 10 1604188800 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 5054285376881 GBLV62003692 N Copyright Control Mark Ridjel 1601615401 Y 2021-12-17 17:37:27 0
89528 EF020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604275200 0 Y N N B N R Y N N Y 10 1604275200 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 5054285151396 GBKQU2061267 N Copyright Control James Kitcher, Will Mayger, Matthew Harris 1601702102 Y 2021-12-17 17:37:27 0
89529 STM057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604275200 0 Y N N B N R Y N N Y 10 1604275200 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 5054285374313 GBY3G2000340 N Copyright Control C. Cutting. 1601702103 Y 2021-12-17 17:37:27 0
89530 STM057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604275200 0 Y N N B N R Y N N Y 10 1604275200 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 5054285374313 GBY3G2000341 N Copyright Control C. Cutting. 1601702103 Y 2021-12-17 17:37:27 0
89533 CRR043 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604361600 0 Y N N B N R Y N N Y 10 1604361600 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 5054285328514 GBKQU2093724 N Copyright Control Cooldampf 1601787901 Y 2021-12-17 17:37:27 0
89534 CR0189 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604448000 0 Y N N B N R Y N N Y 10 1604448000 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 5054285366325 GBLV62001615 N Contagious Records Riko Norton-Wilkes & Kevin Parry 1601874302 Y 2021-12-17 17:37:27 0
89535 CR0189 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604448000 0 Y N N B N R Y N N Y 10 1604448000 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 5054285366325 GBLV62001616 N Contagious Records Riko Norton-Wilkes & Kevin Parry 1601874303 Y 2021-12-17 17:37:27 0
89543 Sti0172 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604275200 0 Y N N B N R Y N N Y 10 1604275200 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 5054285398265 GBLV62007442 N Copyright Control Mindprinter 1601917801 Y 2021-12-17 17:37:27 0
89587 247HC203 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604534400 0 Y N N B N R Y N N Y 10 1604534400 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 5054285401798 UKT6B2000069 N Peermusic / copyright control A.Taylor, D.Heavey, R.Cox 1602003905 Y 2021-12-17 17:37:27 0
89588 247HC203 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604534400 0 Y N N B N R Y N N Y 10 1604534400 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 5054285401798 UKT6B2000066 N Peermusic / copyright control A.Taylor, D.Heavey, R.Cox 1602003905 Y 2021-12-17 17:37:27 0
89600 MR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285400616 NLS161802456 N 89613 2 Dex Publishing Organizer / Dorwart / Hazeleger / Peroti 1602047110 Y 2021-12-17 17:37:27 0
89601 MR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285400616 NLS161802457 N 89613 2 Dex Publishing Organizer / Dorwart / Hazeleger / Peroti 1602047111 Y 2021-12-17 17:37:27 0
89602 MR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285400616 NLS161802458 N 89613 2 Dex Publishing Organizer / Dorwart / Hazeleger / Peroti 1602047112 Y 2021-12-17 17:37:27 0
89603 MR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285400616 NLS161802459 N 89613 2 Dex Publishing Organizer / Dorwart / Hazeleger / Peroti 1602047113 Y 2021-12-17 17:37:27 0
89604 MR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285400616 NLS161802460 N 89613 2 Dex Publishing Organizer / Dorwart / Hazeleger / Peroti 1602047113 Y 2021-12-17 17:37:27 0
89605 MR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285400616 NLS161802461 N 89613 2 Dex Publishing Organizer / Dorwart / Hazeleger / Peroti 1602047113 Y 2021-12-17 17:37:27 0
89606 MR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285400616 NLS161802462 N 89613 2 Dex Publishing Organizer / Dorwart / Hazeleger / Peroti 1602047113 Y 2021-12-17 17:37:27 0
89607 MR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604620800 0 Y N N B N R Y N N Y 10 1604620800 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 5054285400616 NLS161802463 N 89613 2 Dex Publishing Organizer / Dorwart / Hazeleger / Peroti 1602047114 Y 2021-12-17 17:37:27 0
90068 MOUTHDATA011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604534400 0 Y N N B N R Y N N Y 10 1604534400 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 5054285432198 GBLV62013388 N Copyright Control Ingmar Wuestenhagen 1603129207 Y 2021-12-17 17:37:27 0
90069 MOUTHDATA011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604534400 0 Y N N B N R Y N N Y 10 1604534400 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 5054285432198 GBLV62013389 N Copyright Control Ingmar Wuestenhagen 1603129208 Y 2021-12-17 17:37:27 0
90070 MOUTHDATA011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604534400 0 Y N N B N R Y N N Y 10 1604534400 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 5054285432198 GBLV62013390 N Copyright Control Ingmar Wuestenhagen 1603129208 Y 2021-12-17 17:37:27 0
90163 SD186 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604534400 0 Y N N B N R Y N N Y 10 1604534400 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 5028386716037 GBACW1801241 N Peer Music S.Haley,A.Copeland 1603732502 Y 2021-12-17 17:37:27 0
90287 MR088 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604361600 0 Y N N B N R Y N N Y 10 1604361600 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 5054285450574 NLS161802385 N 2 Dex Publishing G.L. Ruseler, R. Martodikromo, S. Marazzi 1603905301 Y 2021-12-17 17:37:27 0
90292 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B1900238 N 90304 Peer Music V/A 1603905305 Y 2021-12-17 17:37:27 0
90293 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B1900226 N 90304 Peer Music V/A 1603905305 Y 2021-12-17 17:37:27 0
90294 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B1900227 N 90304 Peer Music V/A 1603905305 Y 2021-12-17 17:37:27 0
90295 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B1900223 N 90304 Peer Music V/A 1603905305 Y 2021-12-17 17:37:27 0
90296 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B1900228 N 90304 Peer Music V/A 1603905306 Y 2021-12-17 17:37:27 0
90297 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B1900230 N 90304 Peer Music V/A 1603905306 Y 2021-12-17 17:37:27 0
90298 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B1900229 N 90304 Peer Music V/A 1603905306 Y 2021-12-17 17:37:27 0
90299 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B1900231 N 90304 Peer Music V/A 1603905306 Y 2021-12-17 17:37:27 0
90300 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B2000133 N 90304 Peer Music V/A 1603905306 Y 2021-12-17 17:37:27 0
90301 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B2000135 N 90304 Peer Music V/A 1603905307 Y 2021-12-17 17:37:27 0
90302 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B1900240 N 90304 Peer Music V/A 1603905307 Y 2021-12-17 17:37:27 0
90303 247HCLP011BD P A 1 1.69 1 0.000 0 0 0 0.00 0 1604016000 0 Y N N B N R Y N N Y 10 1604016000 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 5054285441718 UKT6B2000136 N 90304 Peer Music V/A 1603905307 Y 2021-12-17 17:37:27 0
90327 BAB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604275200 0 Y N N B N R Y N N Y 10 1604275200 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 5054285442388 NLS161802411 N 2 Dex Publishing R. van der Vaart / M. Bakker 1603991102 Y 2021-12-17 17:37:27 0
90328 BAB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604275200 0 Y N N B N R Y N N Y 10 1604275200 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 5054285442388 NLS161802412 N 2 Dex Publishing R. van der Vaart / M. Bakker 1603991102 Y 2021-12-17 17:37:27 0
90393 DARKUL027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1604534400 0 Y N N B N R Y N N Y 10 1604534400 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 5054285460559 GBLV62018004 N Copyright Control M.Gordon 1604337014 Y 2021-12-17 17:37:27 0