Since 1988, Profile Design has been setting the standard in innovation, creating cycling components designed for speed. For nearly three decades, Profile Design has been pushing the limits and making the bold moves to increase cycling performance on the sport’s most captivating stages. Cyclists turn to Profile Design for compelling, detail-oriented products engineered for superior handling, aerodynamics, adjustability and fit.
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE ((e.entity_id IN (478156, 478159, 478150, 478153, 478144, 420815, 468784, 460311, 478523, 504781, 464688, 436449, 450317, 478183, 464685, 478195, 431112, 420807, 477057, 436413, 436437, 478192, 420716, 478189, 429106, 455067, 500386, 500039, 455397, 428241))) AND (e.created_in '1627772401') ORDER BY FIELD(e.entity_id,478156,478159,478150,478153,478144,420815,468784,460311,478523,504781,464688,436449,450317,478183,464685,478195,431112,420807,477057,436413,436437,478192,420716,478189,429106,455067,500386,500039,455397,428241)
