Yacht sales

Choose Brand
  • Choose Brand
  • Azimut
  • Dominator
  • Ferretti
  • Fiart Mare
  • Fiat
  • FIPA AB
  • Pershing
  • Pirelli
  • Riva
Choose
  • Choose
  • 1
  • 1 or 2
  • 1+salon
  • 14
  • 2
  • 2 or 3
  • 3
  • 3 + 1 convertible
  • 3 or 4
  • 4
  • 5
  • 5/10+2 kids
  • 6
Zobrazení vašich nabídek č. 1-619
load more

vytvořeno Vergiliem

  ZFDebug log Log variables Variables database 35 in 250.87 ms 7246K in 886ms

Event log for productsController->preowned-yachtsAction() (products module)

438ms2601KStartup - ZFDebug construct()
1ms14KRoute
383ms3319KproductsController::preowned-yachtsAction
443ms4190KDispatch
886ms7017KShutdown

View variables

action => 'preowned-yachts'
controller => 'products'
countAll => 19
folder => ProductFolder Object()
form => YachtFilter Object()
limit => 'overall-length'
maxLength => 25.34
maxPrice => 29000000.00
maxYear => 2017
minYear => 2003
module => 'products'
offset => 'overall-length'
order => 'overall-length'
parent => ProductFolder Object()
title => 'Yacht sales'
yachts => Tajfun_Db_Table_Rowset Object()

Request parameters

action => 'preowned-yachts'
controller => 'products'
lang => 'cs'
module => 'products'

Zend Registry

Zend_Controller_Plugin_ActionStack =>
Zend_Locale => Zend_Locale Object()
Zend_Translate => Zend_Translate Object()
Zend_View_Helper_Doctype => ArrayObject Object()
Zend_View_Helper_Placeholder_Registry => Zend_View_Helper_Placeholder_Registry Object()
appType => 'frontend'
config => Zend_Config_Ini Object()
configSection => 'live'
db => Tajfun_Db_Adapter_Pdo_Mysql Object()
lang => 'cs'
locale => Zend_Locale Object()
localeString => 'cs_CZ'
moduleConfig => Zend_Config_Ini Object()
routesConfig => Zend_Config_Ini Object()

Cookies

 

Database queries – Metadata cache ENABLED

0.56ms connect
0.76ms DESCRIBE `entities`
1.54ms SELECT `products_folders`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_folders` INNER JOIN `entities` ON `entities`.entity_id = `products_folders`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
10.20ms SELECT `products`.*, `entities`.*, `pb`.`name` AS `brandname`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON entities.entity_id = products.entity_id LEFT JOIN `products_brands` AS `pb` ON pb.brand_id = products.brand_id LEFT JOIN `products_folders_associated` ON products_folders_associated.product_id = products.product_id LEFT JOIN `products_folders` ON products_folders.folder_id = products_folders_associated.folder_id LEFT JOIN `products_folders` AS `products_folders_parent` ON products_folders_parent.folder_id = products_folders.parent_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (entities.publish = '1') AND (products_folders_parent.rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') GROUP BY `pb`.`brand_id` ORDER BY `pb`.`name` asc
5.03ms SELECT `products`.*, `entities`.*, `ppv`.`value_varchar` AS `yearvalue`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON entities.entity_id = products.entity_id INNER JOIN `products_properties_values` AS `ppv` ON ppv.product_id = products.product_id INNER JOIN `products_properties` AS `pp` ON ppv.property_id = pp.property_id LEFT JOIN `products_folders_associated` ON products_folders_associated.product_id = products.product_id LEFT JOIN `products_folders` ON products_folders.folder_id = products_folders_associated.folder_id LEFT JOIN `products_folders` AS `products_folders_parent` ON products_folders_parent.folder_id = products_folders.parent_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (pp.code = 'year') AND (entities.publish = '1') AND (products_folders_parent.rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') GROUP BY `yearvalue` ORDER BY `yearvalue` desc
8.41ms SELECT `products`.*, `entities`.*, `ppv`.`value_varchar` AS `value`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON entities.entity_id = products.entity_id INNER JOIN `products_properties_values` AS `ppv` ON ppv.product_id = products.product_id INNER JOIN `products_properties` AS `pp` ON ppv.property_id = pp.property_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (pp.code = 'cabins') AND (entities.publish = '1') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') GROUP BY `value` ORDER BY `value` asc
49.26ms SELECT `products`.*, `entities`.*, `parent`.`rewrite_url` AS `folder_rewrite_url`, `ppv_length`.`value_varchar` AS `length`, `ppv_overall_length`.`value_float` AS `overall-length`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON `entities`.entity_id = `products`.entity_id LEFT JOIN `products_properties_values` ON products_properties_values.product_id = products.product_id LEFT JOIN `products_properties` ON products_properties.property_id = products_properties_values.property_id LEFT JOIN `products_folders_associated` ON products_folders_associated.product_id = products.product_id LEFT JOIN `products_folders` ON products_folders.folder_id = products_folders_associated.folder_id LEFT JOIN `products_folders` AS `products_folders_parent` ON products_folders_parent.folder_id = products_folders.parent_id LEFT JOIN `products_folders` AS `parent` ON products_folders.parent_id = parent.folder_id LEFT JOIN `products_properties_values` AS `ppv_length` ON ppv_length.product_id = products.product_id LEFT JOIN `products_properties` AS `pp_length` ON pp_length.property_id = ppv_length.property_id LEFT JOIN `products_properties_values` AS `ppv_overall_length` ON ppv_overall_length.product_id = products.product_id LEFT JOIN `products_properties` AS `pp_overall_length` ON pp_overall_length.property_id = ppv_overall_length.property_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND ((pp_overall_length.code = "overall-length") OR (pp_length.code = "length")) AND (products_folders_parent.rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') GROUP BY `products`.`product_id` ORDER BY cast(ifnull(`overall-length`, `length`) as decimal(10,2)) desc LIMIT 6
57.30ms SELECT `products`.*, `entities`.*, `parent`.`rewrite_url` AS `folder_rewrite_url`, `ppv_length`.`value_varchar` AS `length`, `ppv_overall_length`.`value_float` AS `overall-length`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON `entities`.entity_id = `products`.entity_id LEFT JOIN `products_properties_values` ON products_properties_values.product_id = products.product_id LEFT JOIN `products_properties` ON products_properties.property_id = products_properties_values.property_id LEFT JOIN `products_folders_associated` ON products_folders_associated.product_id = products.product_id LEFT JOIN `products_folders` ON products_folders.folder_id = products_folders_associated.folder_id LEFT JOIN `products_folders` AS `products_folders_parent` ON products_folders_parent.folder_id = products_folders.parent_id LEFT JOIN `products_folders` AS `parent` ON products_folders.parent_id = parent.folder_id LEFT JOIN `products_properties_values` AS `ppv_length` ON ppv_length.product_id = products.product_id LEFT JOIN `products_properties` AS `pp_length` ON pp_length.property_id = ppv_length.property_id LEFT JOIN `products_properties_values` AS `ppv_overall_length` ON ppv_overall_length.product_id = products.product_id LEFT JOIN `products_properties` AS `pp_overall_length` ON pp_overall_length.property_id = ppv_overall_length.property_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND ((pp_overall_length.code = "overall-length") OR (pp_length.code = "length")) AND (products_folders_parent.rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') GROUP BY `products`.`product_id` ORDER BY cast(ifnull(`overall-length`, `length`) as decimal(10,2)) desc
12.65ms SELECT `products`.*, `entities`.*, `ppv`.`value_varchar` AS `value`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON entities.entity_id = products.entity_id INNER JOIN `products_properties_values` AS `ppv` ON ppv.product_id = products.product_id INNER JOIN `products_properties` AS `pp` ON ppv.property_id = pp.property_id LEFT JOIN `products_folders_associated` ON products_folders_associated.product_id = products.product_id LEFT JOIN `products_folders` ON products_folders.folder_id = products_folders_associated.folder_id LEFT JOIN `products_folders` AS `products_folders_parent` ON products_folders_parent.folder_id = products_folders.parent_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (pp.code = 'length') AND (entities.publish = '1') AND (products_folders_parent.rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') ORDER BY cast(value as unsigned) desc LIMIT 1
5.66ms SELECT `products`.*, `entities`.*, `ppv`.`value_float` AS `value`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON entities.entity_id = products.entity_id INNER JOIN `products_properties_values` AS `ppv` ON ppv.product_id = products.product_id INNER JOIN `products_properties` AS `pp` ON ppv.property_id = pp.property_id LEFT JOIN `products_folders_associated` ON products_folders_associated.product_id = products.product_id LEFT JOIN `products_folders` ON products_folders.folder_id = products_folders_associated.folder_id LEFT JOIN `products_folders` AS `products_folders_parent` ON products_folders_parent.folder_id = products_folders.parent_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (pp.code = 'overall-length') AND (entities.publish = '1') AND (products_folders_parent.rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') ORDER BY cast(value as unsigned) desc LIMIT 1
5.14ms SELECT `products`.*, `entities`.*, `ppv`.`value_varchar` AS `value`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON entities.entity_id = products.entity_id INNER JOIN `products_properties_values` AS `ppv` ON ppv.product_id = products.product_id INNER JOIN `products_properties` AS `pp` ON ppv.property_id = pp.property_id LEFT JOIN `products_folders_associated` ON products_folders_associated.product_id = products.product_id LEFT JOIN `products_folders` ON products_folders.folder_id = products_folders_associated.folder_id LEFT JOIN `products_folders` AS `products_folders_parent` ON products_folders_parent.folder_id = products_folders.parent_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (pp.code = 'year') AND (entities.publish = '1') AND (products_folders_parent.rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') ORDER BY cast(value as unsigned) asc LIMIT 1
9.20ms SELECT `products`.*, `entities`.*, `ppv`.`value_varchar` AS `value`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON entities.entity_id = products.entity_id INNER JOIN `products_properties_values` AS `ppv` ON ppv.product_id = products.product_id INNER JOIN `products_properties` AS `pp` ON ppv.property_id = pp.property_id LEFT JOIN `products_folders_associated` ON products_folders_associated.product_id = products.product_id LEFT JOIN `products_folders` ON products_folders.folder_id = products_folders_associated.folder_id LEFT JOIN `products_folders` AS `products_folders_parent` ON products_folders_parent.folder_id = products_folders.parent_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (pp.code = 'year') AND (entities.publish = '1') AND (products_folders_parent.rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') ORDER BY cast(value as unsigned) desc LIMIT 1
17.63ms SELECT `products`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON entities.entity_id = products.entity_id LEFT JOIN `products_folders_associated` ON products_folders_associated.product_id = products.product_id LEFT JOIN `products_folders` ON products_folders.folder_id = products_folders_associated.folder_id LEFT JOIN `products_folders` AS `products_folders_parent` ON products_folders_parent.folder_id = products_folders.parent_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "cs" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (products_folders_parent.rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') ORDER BY cast(price as unsigned) desc LIMIT 1
13.22ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '122054') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '122054') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
3.55ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '446') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
2.75ms SELECT `products_brands`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_brands` INNER JOIN `entities` ON `entities`.entity_id = `products_brands`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 12) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
9.66ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '121263') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '121263') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
0.37ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '445') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.80ms SELECT `products_brands`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_brands` INNER JOIN `entities` ON `entities`.entity_id = `products_brands`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 41) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
6.07ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '129020') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '129020') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
0.32ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '452') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.88ms SELECT `products_brands`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_brands` INNER JOIN `entities` ON `entities`.entity_id = `products_brands`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 57) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
2.59ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '129058') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '129058') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
0.29ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '453') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
2.94ms SELECT `products_brands`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_brands` INNER JOIN `entities` ON `entities`.entity_id = `products_brands`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 2) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
4.94ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '40020') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '40020') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
0.50ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '398') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
1.73ms SELECT `products_brands`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_brands` INNER JOIN `entities` ON `entities`.entity_id = `products_brands`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 1) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
3.02ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '110638') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "cs" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '110638') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
3.31ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '437') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.13ms SELECT `products_brands`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_brands` INNER JOIN `entities` ON `entities`.entity_id = `products_brands`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 1) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
1.84ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
5.02ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id INNER JOIN `pages_folders` ON `pages_folders`.folder_id = `pages`.folder_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (parent_id is null) AND (code = 'mainmenu') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:55:18')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:55:18')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') ORDER BY `priority` ASC
3.44ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'service') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.15ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "cs" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'charter') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1