ZFDebug log Log variables Variables database 36 in 42.05 ms 9072K in 865ms

Event log for indexController->indexAction() (frontend module)

656ms3806KStartup - ZFDebug construct()
1ms15KRoute
169ms4084KindexController::indexAction
201ms4727KDispatch
865ms8835KShutdown

View variables

action => 'index'
articles => Tajfun_Db_Table_Rowset Object()
code => 'preowned-yachts'
controller => 'index'
events => Tajfun_Db_Table_Rowset Object()
module => 'frontend'
newsPage => Page Object()
productFolder => ProductFolder Object()
products => Tajfun_Db_Table_Rowset Object()
title => 'New and preowned yachts'

Request parameters

action => 'index'
controller => 'index'
module => 'frontend'

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 => 'en'
locale => Zend_Locale Object()
localeString => 'en_US'
moduleConfig => NULL
routesConfig => Zend_Config_Ini Object()

Cookies

 

Database queries – Metadata cache ENABLED

0.42ms connect
0.28ms 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 = "en" 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'news') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
12.52ms SELECT DISTINCT `articles`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `title_translation`.`value_varchar` AS `Xtranslated_title`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `subtitle_translation`.`value_varchar` AS `Xtranslated_subtitle` FROM `articles` INNER JOIN `entities` ON `entities`.entity_id = `articles`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_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 = "en" 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 = "en" 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_translations` AS `subtitle_translation` ON subtitle_translation.entity_id = entities.entity_id and subtitle_translation.column_key = "subtitle" and subtitle_translation.lang = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (entities_related.master_id = '21882') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') ORDER BY `priority` ASC, `created` desc LIMIT 6
1.41ms SELECT `events`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `annotation_translation`.`value_text` AS `Xtranslated_annotation`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `events` INNER JOIN `entities` ON `entities`.entity_id = `events`.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 = "en" LEFT JOIN `entities_translations` AS `annotation_translation` ON annotation_translation.entity_id = entities.entity_id and annotation_translation.column_key = "annotation" and annotation_translation.lang = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (start <= now()) AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') ORDER BY `start` desc LIMIT 8 OFFSET 4
0.75ms SELECT `events`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `annotation_translation`.`value_text` AS `Xtranslated_annotation`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `events` INNER JOIN `entities` ON `entities`.entity_id = `events`.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 = "en" LEFT JOIN `entities_translations` AS `annotation_translation` ON annotation_translation.entity_id = entities.entity_id and annotation_translation.column_key = "annotation" and annotation_translation.lang = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (start >= '2017-09-27') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') ORDER BY `start` asc LIMIT 8
0.11ms 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 = "en" 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 = "en" 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.13ms SELECT `products_folders`.`folder_id`, `products_folders`.`parent_id` FROM `products_folders`
3.97ms SELECT `products`.*, `entities`.*, `products_folders_associated`.*, `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 `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = "en" 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (folder_id in (25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 83, 84, 85, 86)) AND (products.product_id in (select product_id from products_attributes_associated where attribute_id in (select attribute_id from products_attributes where code = 'special'))) AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') ORDER BY `entities`.`priority` ASC
0.11ms 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 = "en" 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 = "en" 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
2.58ms 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 = "en" 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 = "en" 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 = "en" 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-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" 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-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
0.10ms 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
0.28ms 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 = "en" 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 = "en" 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
1.79ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '41006') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '41006') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
0.12ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '404') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.17ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 63) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
2.58ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
0.07ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '451') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.12ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 68) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
1.52ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '129157') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '129157') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
1.53ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '128292') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '128292') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
1.50ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '128196') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '128196') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
1.69ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '122928') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '122928') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
1.77ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '122999') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '122999') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
1.85ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '119551') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '119551') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
0.21ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '67529') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '67529') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` ASC
0.19ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '122949') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '122949') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` ASC
0.17ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '118726') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '118726') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` ASC
0.15ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '123047') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '123047') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` ASC
0.14ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '123048') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '123048') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` ASC
0.13ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '122935') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '122935') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` ASC
0.14ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '122938') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '122938') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` ASC
0.13ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '122940') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '122940') AND (relation_type = 'images') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` ASC
0.14ms 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 = "en" 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = '') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
3.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 = "en" 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 = "en" 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 = "en" 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 = "en" 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-04-24 19:46:52')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-04-24 19:46:52')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') ORDER BY `priority` ASC
0.14ms 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 = "en" 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 = "en" 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 = "en" 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.12ms 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 = "en" 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 = "en" 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 = "en" 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1