SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    110550, 110388, 110332, 110331, 110329, 
    110328, 110419, 110389, 110424, 110423, 
    110391, 110390, 110349, 110696, 110386, 
    110358, 110357, 110354, 110351, 110350
  )

Query time 0.00060

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 20 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
110328 MQDREP009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668556800 0 Y N N B N R Y N N Y 10 1668556800 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 5054286949800 GBKQU2258181 N +QDance Records David Almarcha, Miguel Bort, Guillermo Tormo 1665984602 Y 2022-10-17 06:30:02 0
110329 MQDREP009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668556800 0 Y N N B N R Y N N Y 10 1668556800 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 5054286949800 GBKQU2259687 N +QDance Records David Almarcha, Miguel Bort, Guillermo Tormo 1665984604 Y 2022-10-17 06:30:04 0
110331 MQDREP009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668556800 0 Y N N B N R Y N N Y 10 1668556800 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 5054286949800 GBKQU2209601 N +QDance Records David Almarcha, Miguel Bort, Guillermo Tormo 1665984605 Y 2022-10-17 06:30:05 0
110332 MQDREP009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668556800 0 Y N N B N R Y N N Y 10 1668556800 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 5054286949800 GBKQU2280541 N +QDance Records David Almarcha, Miguel Bort, Guillermo Tormo 1665984606 Y 2022-10-17 06:30:06 0
110349 KKE025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668384000 0 Y N N B N R Y N N Y 10 1668384000 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 5054286986621 GBKQU2296690 N Copyright Control Medvedev Artem Alexandrovich 1666113327 Y 2022-10-18 18:15:27 0
110350 KKR159 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054286986157 GBKQU2296649 N Copyright Control Giuseppe Elia, Andrea DAmore 1666113327 Y 2022-10-18 18:15:27 0
110351 KKR159 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054286986157 GBKQU2296650 N Copyright Control Giuseppe Elia, Andrea DAmore 1666113328 Y 2022-10-18 18:15:28 0
110354 KKE024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054286984757 GBKQU2296480 N Copyright Control Fabian Kaschub 1666113328 Y 2022-10-18 18:15:28 0
110357 KKR160 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054286986645 GBKQU2296694 N Copyright Control Alan Zenobius 1666113330 Y 2022-10-18 18:15:30 0
110358 KKR160 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054286986645 GBKQU2296695 N Copyright Control Alan Zenobius 1666113330 Y 2022-10-18 18:15:30 0
110386 UPR213 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054286987758 NL3TA2209001 N Copyright Control Luca Mueller 1666199703 Y 2022-10-19 18:15:03 0
110388 INFEXORI011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668643200 0 Y N N B N R Y N N Y 10 1668643200 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 5054286988809 GBKQU2297056 N Copyright Control Daniele Mondello 1666242902 Y 2022-10-20 06:15:02 0
110389 UPR214 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987796 NL3TA2209101 N Copyright Control Artem Uzefchuck 1666242905 Y 2022-10-20 06:15:05 0
110390 KKR162 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668384000 0 Y N N B N R Y N N Y 10 1668384000 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 5054286987062 GBKQU2296739 N Copyright Control Robin Pault 1666242907 Y 2022-10-20 06:15:07 0
110391 KKR162 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668384000 0 Y N N B N R Y N N Y 10 1668384000 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 5054286987062 GBKQU2296740 N Copyright Control Robin Pault 1666242907 Y 2022-10-20 06:15:07 0
110419 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801270 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286111 Y 2022-10-20 18:15:11 0
110423 KKR161 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668384000 0 Y N N B N R Y N N Y 10 1668384000 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 5054286988069 GBKQU2296903 N Copyright Control Ryan Benjamins 1666286112 Y 2022-10-20 18:15:12 0
110424 KKR161 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668384000 0 Y N N B N R Y N N Y 10 1668384000 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 5054286988069 GBKQU2296904 N Copyright Control Ryan Benjamins 1666286113 Y 2022-10-20 18:15:13 0
110550 HBR129 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668643200 0 Y N N B N R Y N N Y 10 1668643200 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 5054287004973 GBKQU2299540 N Copyright Control Flavio Mazzucchelli, Francesco Chiaro 1666934102 Y 2022-10-28 06:15:02 0
110696 HB17 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054287018857 GBLV62201558 N Copyright Control M. Comis 1667583901 Y 2022-11-04 18:45:01 0