SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    67356, 67355, 67354, 67353, 67352, 67351, 
    67350, 67349, 67348, 67347, 67346, 
    67345, 67344, 67314, 67313, 76804, 
    76803, 76802, 76801, 76800, 76799, 
    76798, 76797, 76796, 76795, 76794, 
    67193, 67179, 67178, 67177, 67176, 
    67175, 67174, 67173, 67172, 67171, 
    67170, 67169, 67168, 67167
  )

Query time 0.00068

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
67167 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBKQU1679698 N 67183 Copyright Control Various Artists 1522299605 Y 2021-12-17 17:37:27 0
67168 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBKQU1466917 N 67183 Copyright Control Various Artists 1522299605 Y 2021-12-17 17:37:27 0
67169 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBKQU1505253 N 67183 Copyright Control Various Artists 1522299605 Y 2021-12-17 17:37:27 0
67170 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBLV61412153 N 67183 Copyright Control Various Artists 1522299605 Y 2021-12-17 17:37:27 0
67171 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBLV61525514 N 67183 Copyright Control Various Artists 1522299605 Y 2021-12-17 17:37:27 0
67172 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBKQU1679466 N 67183 Copyright Control Various Artists 1522299605 Y 2021-12-17 17:37:27 0
67173 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBKQU1750567 N 67183 Copyright Control Various Artists 1522299606 Y 2021-12-17 17:37:27 0
67174 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBKQU1728597 N 67183 Copyright Control Various Artists 1522299606 Y 2021-12-17 17:37:27 0
67175 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBLV61608860 N 67183 Copyright Control Various Artists 1522299606 Y 2021-12-17 17:37:27 0
67176 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBKQU1545453 N 67183 Copyright Control Various Artists 1522299606 Y 2021-12-17 17:37:27 0
67177 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBKQU1568162 N 67183 Copyright Control Various Artists 1522299606 Y 2021-12-17 17:37:27 0
67178 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBKQU1493885 N 67183 Copyright Control Various Artists 1522299606 Y 2021-12-17 17:37:27 0
67179 CheekPS1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283413502 GBKQU1795011 N 67183 Copyright Control Various Artists 1522299606 Y 2021-12-17 17:37:27 0
67193 DD036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524783600 0 Y N N B N R Y N N Y 10 1524783600 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 5054283582154 GBKQU1830911 N Copyright Control Bradley Milburn, Digital Mafia 1549016297 Y 2021-12-17 17:37:27 0
67313 Cheek376 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283581874 GBKQU1818754 N Copyright Control David Jackson, James Revill 1522904404 Y 2021-12-17 17:37:27 0
67314 Cheek376 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283581874 GBKQU1828785 N Copyright Control David Jackson, James Revill 1549016300 Y 2021-12-17 17:37:27 0
67344 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBLV61712390 N 67358 Copyright Control Various Artists 1522904417 Y 2021-12-17 17:37:27 0
67345 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBLV61712391 N 67358 Copyright Control Various Artists 1522904418 Y 2021-12-17 17:37:27 0
67346 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBKQU1493887 N 67358 Copyright Control Various Artists 1522904418 Y 2021-12-17 17:37:27 0
67347 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBLV61712392 N 67358 Copyright Control Various Artists 1522904418 Y 2021-12-17 17:37:27 0
67348 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBKQU1736443 N 67358 Copyright Control Various Artists 1522904418 Y 2021-12-17 17:37:27 0
67349 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBKQU1625213 N 67358 Copyright Control Various Artists 1522904418 Y 2021-12-17 17:37:27 0
67350 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBKQU1223328 N 67358 Copyright Control Various Artists 1522904418 Y 2021-12-17 17:37:27 0
67351 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBLV61712393 N 67358 Copyright Control Various Artists 1522904419 Y 2021-12-17 17:37:27 0
67352 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBLV61708483 N 67358 Copyright Control Various Artists 1522904419 Y 2021-12-17 17:37:27 0
67353 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBKQU1656588 N 67358 Copyright Control Various Artists 1522904419 Y 2021-12-17 17:37:27 0
67354 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBKQU1496775 N 67358 Copyright Control Various Artists 1522904420 Y 2021-12-17 17:37:27 0
67355 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBKQU1783337 N 67358 Copyright Control Various Artists 1522904420 Y 2021-12-17 17:37:27 0
67356 CheekA31 P A 1 1.69 1 0.000 0 0 0 0.00 0 1525388400 0 Y N N B N R Y N N Y 10 1525388400 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 5054283331400 GBKQU1679460 N 67358 Copyright Control Various Artists 1522904420 Y 2021-12-17 17:37:27 0
76794 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844304 N 76805 Copyright Control Various Artists 1558075150 Y 2021-12-17 17:37:27 0
76795 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844305 N 76805 Copyright Control Various Artists 1558075170 Y 2021-12-17 17:37:27 0
76796 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844306 N 76805 Copyright Control Various Artists 1558075186 Y 2021-12-17 17:37:27 0
76797 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844307 N 76805 Copyright Control Various Artists 1558075206 Y 2021-12-17 17:37:27 0
76798 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844308 N 76805 Copyright Control Various Artists 1558075226 Y 2021-12-17 17:37:27 0
76799 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844309 N 76805 Copyright Control Various Artists 1558075253 Y 2021-12-17 17:37:27 0
76800 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844310 N 76805 Copyright Control Various Artists 1558075274 Y 2021-12-17 17:37:27 0
76801 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844313 N 76805 Copyright Control Various Artists 1558075292 Y 2021-12-17 17:37:27 0
76802 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844314 N 76805 Copyright Control Various Artists 1558075312 Y 2021-12-17 17:37:27 0
76803 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844315 N 76805 Copyright Control Various Artists 1558075331 Y 2021-12-17 17:37:27 0
76804 HDCEC003RRD P A 1 1.69 1 0.000 0 0 0 0.00 0 1525042800 0 Y N N B N R Y N N Y 10 1525042800 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 5054284405476 GBKQU1844316 N 76805 Copyright Control Various Artists 1558075350 Y 2021-12-17 17:37:27 0