SELECT `cruise`.`id` AS `id`, any_value(`cruise`.`featured_id`) AS `featuredId`, any_value(`cruise`.`featured_date`) AS `featuredDate`, any_value(`cruise18`.`title`) AS `title`, any_value(`cruise18`.`label`) AS `label`, any_value(`cruise18`.`slug`) AS `slug`, any_value(`upload`.`id`) AS `uploadId`, any_value(`upload`.`filename`) AS `uploadFilename`, any_value(`upload`.`ver`) AS `uploadVersion`, any_value(`upload18`.`additional`) AS `uploadAdditional`, any_value(`port`.`title`) AS `startPort`, any_value(`ship`.`id`) AS `shipId`, any_value(`ship`.`rating`) AS `shipRating`, any_value(`ship18`.`title`) AS `shipTitle`, any_value(`prices`.`price_lv`) AS `price`, any_value(`prices`.`date`) AS `date` FROM `cruises` AS `cruise` LEFT JOIN `cruises_i18n` AS `cruise18` ON `cruise18`.`foreign_key` = `cruise`.`id` LEFT JOIN `uploads` AS `upload` ON `upload`.`foreign_key` = `cruise`.`id` AND `upload`.`section` = 'cruiseFeaturedImage' AND `upload`.`is_active` = 1 AND `upload`.`is_default` = 1 LEFT JOIN `uploads_i18n` AS `upload18` ON `upload18`.`foreign_key` = `upload`.`id` AND `upload18`.`lang` = 'bg' LEFT JOIN `cruise_route_points` AS `route` ON `cruise`.`id` = `route`.`cruise_id` AND `route`.`ord` = 0 LEFT JOIN `ports_i18n` AS `port` ON `port`.`foreign_key` = `route`.`port_id` AND `port`.`lang` = 'bg' LEFT JOIN `ships` AS `ship` ON `cruise`.`ship_id` = `ship`.`id` LEFT JOIN `ships_i18n` AS `ship18` ON `ship18`.`foreign_key` = `ship`.`id` AND `ship18`.`lang` = 'bg' LEFT JOIN `cruise_prices_cache` AS `prices` ON `prices`.`cruise_id` = `cruise`.`id` AND IF(`cruise`.`featured_date`, (`prices`.`date` = `cruise`.`featured_date`), (`prices`.`is_lowest` = 1)) WHERE ((`cruise18`.`is_active` = 1) AND (`cruise`.`featured_id` IN (:ids0, :ids1, :ids2, :ids3, :ids4, :ids5))) AND (`cruise18`.`lang` = :lang) GROUP BY `cruise`.`id` ORDER BY `prices`.`price` ASC
1
366.75 ms
366.75 ms
366.75 ms
366.75 ms