SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    118790, 118789, 118788, 118787, 118786, 
    118785, 118784, 118783, 118782, 118781, 
    118780, 118779, 118778, 118777, 118776, 
    118775, 118774, 118773, 118772, 118771, 
    118770, 118769, 118768
  )

Query time 0.00051

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 23 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
118768 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 1 labelworx 5054287684007 GBKQU1801491 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916754 Y 2023-10-10 06:45:54 0
118769 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 1 labelworx 5054287684007 GBKQU1808952 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916756 Y 2023-10-10 06:45:56 0
118770 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 1 labelworx 5054287684007 GBKQU1801489 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916759 Y 2023-10-10 06:45:59 0
118771 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1777189 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916762 Y 2023-10-10 06:46:02 0
118772 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 1 labelworx 5054287684007 GBKQU1801483 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916765 Y 2023-10-10 06:46:05 0
118773 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1777188 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916770 Y 2023-10-10 06:46:10 0
118774 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 1 labelworx 5054287684007 GBKQU1801488 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916773 Y 2023-10-10 06:46:13 0
118775 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 1 labelworx 5054287684007 GBKQU1801487 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916775 Y 2023-10-10 06:46:15 0
118776 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1808950 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916778 Y 2023-10-10 06:46:18 0
118777 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1777888 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916781 Y 2023-10-10 06:46:21 0
118778 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1729675 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916784 Y 2023-10-10 06:46:24 0
118779 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1729674 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916789 Y 2023-10-10 06:46:29 0
118780 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1801618 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916792 Y 2023-10-10 06:46:32 0
118781 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1755482 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916795 Y 2023-10-10 06:46:35 0
118782 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1873685 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916798 Y 2023-10-10 06:46:38 0
118783 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1755503 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916800 Y 2023-10-10 06:46:40 0
118784 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 1 labelworx 5054287684007 GBKQU1801490 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916803 Y 2023-10-10 06:46:43 0
118785 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1755484 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916806 Y 2023-10-10 06:46:46 0
118786 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 1 labelworx 5054287684007 GBKQU1801492 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916809 Y 2023-10-10 06:46:49 0
118787 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1960351 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916812 Y 2023-10-10 06:46:52 0
118788 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1842037 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916817 Y 2023-10-10 06:46:57 0
118789 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1729676 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916820 Y 2023-10-10 06:47:00 0
118790 TTLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1699488000 0 Y N N B N R Y N N Y 10 1699488000 1700697600 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;} 4 labelworx 5054287684007 GBKQU1777142 N 118791 Tuff Trax Garett Reimond, Sean Taylor, Matt Wade, Paul Ryder, Dan Hall, Adrian John Buss, Marc Lewis, Hadyn Jay, Joe Clifford, Edward Horsfall, Si Mowling 1696916825 Y 2023-10-10 06:47:05 0