SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    13878, 13877, 13876, 13875, 13874, 13873, 
    13872, 13870, 13869, 13829, 13862, 
    13858, 13850, 13849, 13848, 13847, 
    13846, 13845, 13844, 13843, 13842, 
    13841, 13840, 13839, 13838, 13837, 
    13836, 13835, 13834, 13833, 13832, 
    13831, 13830, 13827, 13826, 13825, 
    13824, 13823, 13822, 13821
  )

Query time 0.00055

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
13821 IHDSB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145608 0 Y N N B N R Y N N Y 10 1361145600 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 5052653536837 GBX7Q1100083 N 13828 Various Various 0 Y 2021-12-17 17:37:27 0
13822 IHDSB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145609 0 Y N N B N R Y N N Y 10 1361145600 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 5052653536837 GBX7Q1200109 N 13828 Various Various 0 Y 2021-12-17 17:37:27 0
13823 IHDSB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145610 0 Y N N B N R Y N N Y 10 1361145600 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 5052653536837 GBX7Q1100095 N 13828 Various Various 0 Y 2021-12-17 17:37:27 0
13824 IHDSB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145611 0 Y N N B N R Y N N Y 10 1361145600 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 5052653536837 GBX7Q1100081 N 13828 Various Various 0 Y 2021-12-17 17:37:27 0
13825 IHDSB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145612 0 Y N N B N R Y N N Y 10 1361145600 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 5052653536837 GBCMJ1024503 N 13828 Various Various 0 Y 2021-12-17 17:37:27 0
13826 IHDSB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145613 0 Y N N B N R Y N N Y 10 1361145600 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 5052653536837 GBX7Q1100068 N 13828 Various Various 0 Y 2021-12-17 17:37:27 0
13827 IHDSB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145614 0 Y N N B N R Y N N Y 10 1361145600 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 5052653536837 GBX7Q1100023 N 13828 Various Various 0 Y 2021-12-17 17:37:27 0
13829 RIOT111 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145656 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507349 GBKQU1339997 N Copyright Control Scott Attrill 0 Y 2021-12-17 17:37:27 0
13830 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145617 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339390 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13831 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145618 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339406 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13832 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145619 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339417 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13833 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145620 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339424 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13834 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145621 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339432 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13835 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145622 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1338853 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13836 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145623 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1338837 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13837 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145624 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1338844 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13838 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145625 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1338847 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13839 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145626 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1340003 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13840 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145627 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1340010 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13841 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145628 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1340013 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13842 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145629 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1338869 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13843 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145630 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1338858 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13844 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145631 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339953 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13845 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145632 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339962 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13846 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145633 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339976 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13847 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145634 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339984 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13848 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145635 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339989 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13849 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145636 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339994 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13850 T100P3 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145637 0 Y N N B N R Y N N Y 10 1361145600 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 5052653507493 GBKQU1339958 N 13851 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13858 ACTD008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145645 0 Y N N B N R Y N N Y 10 1361145600 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 5052653529587 GBKQU1344493 N Kernnel Kernnel 0 Y 2021-12-17 17:37:27 0
13862 FLMBD029 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361145654 0 Y N N B N R Y N N Y 10 1361145600 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 5052653508742 GBKQU1340276 N Flammable Records Matt E.B 0 Y 2021-12-17 17:37:27 0
13869 ES105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361232000 0 Y N N B N R Y N N Y 10 1361232000 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 5052653517645 GBKQU1277656 N 13879 Defensive Audio Various Artists 0 Y 2021-12-17 17:37:27 0
13870 ES105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361232001 0 Y N N B N R Y N N Y 10 1361232000 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 5052653517645 GBKQU1029967 N 13879 Defensive Audio Various Artists 0 Y 2021-12-17 17:37:27 0
13872 ES105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361232003 0 Y N N B N R Y N N Y 10 1361232000 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 5052653517645 GBKQU1027440 N 13879 Defensive Audio Various Artists 0 Y 2021-12-17 17:37:27 0
13873 ES105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361232004 0 Y N N B N R Y N N Y 10 1361232000 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 5052653517645 GBKQU1156814 N 13879 Defensive Audio Various Artists 0 Y 2021-12-17 17:37:27 0
13874 ES105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361232005 0 Y N N B N R Y N N Y 10 1361232000 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 5052653517645 GBKQU1144000 N 13879 Defensive Audio Various Artists 0 Y 2021-12-17 17:37:27 0
13875 ES105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361232006 0 Y N N B N R Y N N Y 10 1361232000 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 5052653517645 GBKQU1138834 N 13879 Defensive Audio Various Artists 0 Y 2021-12-17 17:37:27 0
13876 ES105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361232007 0 Y N N B N R Y N N Y 10 1361232000 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 5052653517645 GBKQU1135778 N 13879 Defensive Audio Various Artists 0 Y 2021-12-17 17:37:27 0
13877 ES105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361232008 0 Y N N B N R Y N N Y 10 1361232000 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 5052653517645 GBKQU1148571 N 13879 Defensive Audio Various Artists 0 Y 2021-12-17 17:37:27 0
13878 ES105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361232009 0 Y N N B N R Y N N Y 10 1361232000 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 5052653517645 GBKQU1027734 N 13879 Defensive Audio Various Artists 0 Y 2021-12-17 17:37:27 0