ZFDebug log Log variables Variables database 38 in 74.03 ms 8120K in 3067ms

Event log for productsController->indexAction() (products module)

799ms2599KStartup - ZFDebug construct()
23ms1603KRoute
90ms2493KproductsController::indexAction
171ms3318KDispatch
3067ms7839KShutdown

View variables

action => 'index'
controller => 'products'
folder => ProductFolder Object()
module => 'products'
parent => ProductFolder Object()

Request parameters

action => 'index'
controller => 'products'
module => 'products'
rewrite_url => 'williams'

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 => Zend_Config_Ini Object()
routesConfig => Zend_Config_Ini Object()

Cookies

 

Database queries – Metadata cache ENABLED

0.41ms connect
0.37ms SELECT `products_folders`.*, `entities`.* FROM `products_folders` INNER JOIN `entities` ON `entities`.entity_id = `products_folders`.entity_id
0.15ms SELECT `products_folders`.`folder_id`, `products_folders`.`parent_id` FROM `products_folders`
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 = "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 = 'williams') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.10ms 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 (`folder_id` = 18) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
6.87ms 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 ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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
2.22ms 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 (products_folders_associated.folder_id = '19') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 `products_folders_associated`.`priority` ASC
0.15ms 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 (products_folders_associated.folder_id = '19') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 `products_folders_associated`.`priority` ASC
0.79ms 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 (products_folders_associated.folder_id = '82') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 `products_folders_associated`.`priority` ASC
0.73ms 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 (products_folders_associated.folder_id = '87') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 `products_folders_associated`.`priority` ASC
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 = "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 = '1511') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 = '1511') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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.49ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '71') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.68ms 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` = 14) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
1.71ms 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 = '1513') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 = '1513') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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.40ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '72') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.10ms 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` = 14) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
1.70ms 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 = '1514') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 = '1514') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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.34ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '73') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.09ms 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` = 14) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
1.57ms 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 = '1515') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 = '1515') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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.25ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '74') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.10ms 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` = 14) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
2.70ms 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 = '5410') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 = '5410') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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.31ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '204') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.09ms 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` = 14) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
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 = '5440') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 = '5440') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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.32ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '206') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.09ms 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` = 14) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
1.54ms 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 = '5450') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 = '5450') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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.21ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '207') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.09ms 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` = 14) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
1.62ms 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 = '5455') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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 = '5455') AND (doctype = 'photo') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:39:34')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:34')) 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.26ms SELECT `products_attributes_associated`.* FROM `products_attributes_associated` WHERE (product_id = '208') AND (attribute_id in (select attribute_id from products_attributes where code = 'offer-badge')) LIMIT 1
0.09ms 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` = 14) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
23.53ms 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 = 'water-toys') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
9.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 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-05-24 13:39:35')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:39:35')) 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
5.78ms 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
2.36ms 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