SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    84954, 84953, 84952, 84950, 84948, 84906, 
    84905, 84904, 84903, 84902, 84901, 
    84900, 84899, 84898, 84897, 84896, 
    84895, 84628, 84627, 84600, 84599, 
    84597, 84943, 84942, 84919, 84918, 
    84917, 84916, 84915, 84639, 84549, 
    84977, 84811, 84810, 84809, 84808, 
    84807, 84806, 84805, 84804
  )

Query time 0.00052

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
84549 STI0121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586818800 0 Y N N B N R Y N N Y 10 1586818800 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 5054284941325 GBKQU2023818 N Label Worx DJ Hooch 1584334802 Y 2021-12-17 17:37:27 0
84597 BFR2002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284912424 GBKQU2018479 N Bassface Recordings Brain-Dee 1584594010 Y 2021-12-17 17:37:27 0
84599 247HC196 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284941554 UKT6B2000040 N Copyright Control D.Somma, J.Hartshorn 1584594011 Y 2021-12-17 17:37:27 0
84600 247HC196 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284941554 UKT6B2000041 N Copyright Control D.Somma, J.Hartshorn 1584594011 Y 2021-12-17 17:37:27 0
84627 247HC193 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284949000 UKT6B2000042 N Peer Music / Copyright Control D.Heavey, A.Taylor 1584594020 Y 2021-12-17 17:37:27 0
84628 247HC193 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284949000 UKT6B2000044 N Peer Music / Copyright Control D.Heavey, A.Taylor 1584594020 Y 2021-12-17 17:37:27 0
84639 STI0125 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586991600 0 Y N N B N R Y N N Y 10 1586991600 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 5054284966281 GBKQU2027946 N Copyright Control Diskoh & Area51 1584680408 Y 2021-12-17 17:37:27 0
84804 LWHTE10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586732400 0 Y N N B N R Y N N Y 10 1586732400 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 5054284978321 GB5FL1200256 N 84812 Copyright Control Various Artists 1585199005 Y 2021-12-17 17:37:27 0
84805 LWHTE10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586732400 0 Y N N B N R Y N N Y 10 1586732400 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 5054284978321 GBLV61920877 N 84812 Copyright Control Various Artists 1585199005 Y 2021-12-17 17:37:27 0
84806 LWHTE10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586732400 0 Y N N B N R Y N N Y 10 1586732400 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 5054284978321 GBLV61902696 N 84812 Copyright Control Various Artists 1585199006 Y 2021-12-17 17:37:27 0
84807 LWHTE10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586732400 0 Y N N B N R Y N N Y 10 1586732400 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 5054284978321 GBLV61902888 N 84812 Copyright Control Various Artists 1585199006 Y 2021-12-17 17:37:27 0
84808 LWHTE10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586732400 0 Y N N B N R Y N N Y 10 1586732400 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 5054284978321 QMHT71900010 N 84812 Copyright Control Various Artists 1585199006 Y 2021-12-17 17:37:27 0
84809 LWHTE10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586732400 0 Y N N B N R Y N N Y 10 1586732400 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 5054284978321 GBLV61902041 N 84812 Copyright Control Various Artists 1585199006 Y 2021-12-17 17:37:27 0
84810 LWHTE10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586732400 0 Y N N B N R Y N N Y 10 1586732400 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 5054284978321 NLVS51900178 N 84812 Copyright Control Various Artists 1585199006 Y 2021-12-17 17:37:27 0
84811 LWHTE10 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586732400 0 Y N N B N R Y N N Y 10 1586732400 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 5054284978321 GBLV61908248 N 84812 Copyright Control Various Artists 1585199006 Y 2021-12-17 17:37:27 0
84895 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2027720 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285203 Y 2021-12-17 17:37:27 0
84896 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2027721 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285203 Y 2021-12-17 17:37:27 0
84897 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2017054 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285203 Y 2021-12-17 17:37:27 0
84898 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2027722 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285203 Y 2021-12-17 17:37:27 0
84899 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2027723 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285203 Y 2021-12-17 17:37:27 0
84900 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2017057 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285204 Y 2021-12-17 17:37:27 0
84901 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2027724 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285204 Y 2021-12-17 17:37:27 0
84902 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2017059 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285204 Y 2021-12-17 17:37:27 0
84903 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2017060 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285204 Y 2021-12-17 17:37:27 0
84904 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2027725 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285204 Y 2021-12-17 17:37:27 0
84905 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2017062 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285205 Y 2021-12-17 17:37:27 0
84906 CRU001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284964911 GBKQU2017063 N 84907 Label Worx Riki Norton-Wilkes, Robert Cox, Ben Jones 1585285205 Y 2021-12-17 17:37:27 0
84915 Hells037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586991600 0 Y N N B N R Y N N Y 10 1586991600 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 5054284982236 GBKQU2030591 N Hell's Recordings D. Meulenberg 1585285209 Y 2021-12-17 17:37:27 0
84916 Hells037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586991600 0 Y N N B N R Y N N Y 10 1586991600 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 5054284982236 GBKQU2030592 N Hell's Recordings D. Meulenberg 1585285209 Y 2021-12-17 17:37:27 0
84917 Hells037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586991600 0 Y N N B N R Y N N Y 10 1586991600 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 5054284982236 GBKQU2030593 N Hell's Recordings D. Meulenberg 1585285210 Y 2021-12-17 17:37:27 0
84918 Hells037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586991600 0 Y N N B N R Y N N Y 10 1586991600 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 5054284982236 GBKQU2030594 N Hell's Recordings D. Meulenberg 1585285210 Y 2021-12-17 17:37:27 0
84919 Hells037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586991600 0 Y N N B N R Y N N Y 10 1586991600 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 5054284982236 GBKQU2030595 N Hell's Recordings D. Meulenberg 1585285210 Y 2021-12-17 17:37:27 0
84942 RAVEMUZIK033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586991600 0 Y N N B N R Y N N Y 10 1586991600 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 5054284987996 GBKQU2031707 N Copyright Control Michael Wells 1585630801 Y 2021-12-17 17:37:27 0
84943 RAVEMUZIK033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586991600 0 Y N N B N R Y N N Y 10 1586991600 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 5054284987996 GBKQU2031708 N Copyright Control Michael Wells 1585630802 Y 2021-12-17 17:37:27 0
84948 EvMix017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284985527 GBLV61408673 N 84966 23rd Precinct Music Ltd Scott Brown 1585630806 Y 2021-12-17 17:37:27 0
84950 EvMix017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284985527 GBKQU1625469 N 84966 23rd Precinct Music Ltd Scott Brown 1585630806 Y 2021-12-17 17:37:27 0
84952 EvMix017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284985527 GBLV61408648 N 84966 23rd Precinct Music Ltd Scott Brown 1585630806 Y 2021-12-17 17:37:27 0
84953 EvMix017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284985527 GBKQU1509533 N 84966 23rd Precinct Music Ltd Scott Brown 1585630807 Y 2021-12-17 17:37:27 0
84954 EvMix017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1587078000 0 Y N N B N R Y N N Y 10 1587078000 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 5054284985527 GBKQU1625484 N 84966 23rd Precinct Music Ltd Scott Brown 1585630807 Y 2021-12-17 17:37:27 0
84977 JH267 P A 1 1.69 1 0.000 0 0 0 0.00 0 1586732400 0 Y N N B N R Y N N Y 10 1586732400 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 5054284991498 GBKQU2032249 N Copyright Control 4* 1585717205 Y 2021-12-17 17:37:27 0