Query | Affected | Num. rows | Took (ms) | Actions |
---|
SET SQL_BIG_SELECTS = 1 | 0 | 0 | 0 | |
SELECT `Setting`.`key`, `Setting`.`value` FROM `sorenc5_db`.`cms_settings` AS `Setting` WHERE `active` = '1' AND `visible` = '1' ORDER BY `key` ASC | 52 | 52 | 0 | |
SELECT `Module`.`path`, `Module`.`id` FROM `sorenc5_db`.`cms_modules` AS `Module` WHERE 1 = 1 ORDER BY `path` ASC | 20 | 20 | 0 | |
SELECT `ModuleMenu`.`id`, `ModuleMenu`.`module_id`, `ModuleMenu`.`name`, `ModuleMenu`.`path`, `ModuleMenu`.`order`, `ModuleMenu`.`visible`, `ModuleMenu`.`created`, `ModuleMenu`.`modified`, `ModuleMenu`.`create_user`, `ModuleMenu`.`mod_user` FROM `sorenc5_db`.`cms_module_menus` AS `ModuleMenu` WHERE `ModuleMenu`.`module_id` IN (11, 1, 15, 3, 17, 10, 13, 7, 5, 8, 14, 20, 21, 22, 9, 12, 19, 2, 16, 18) ORDER BY `module_id` ASC, `order` ASC | 40 | 40 | 1 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`type`, `Language`.`code`, `Language`.`order`, `Language`.`default`, `Language`.`visible`, `Language`.`active`, `Language`.`created`, `Language`.`modified`, `Language`.`create_user`, `Language`.`mod_user` FROM `sorenc5_db`.`cms_languages` AS `Language` WHERE `active` = '1' | 8 | 8 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`type`, `Language`.`code`, `Language`.`order`, `Language`.`default`, `Language`.`visible`, `Language`.`active`, `Language`.`created`, `Language`.`modified`, `Language`.`create_user`, `Language`.`mod_user` FROM `sorenc5_db`.`cms_languages` AS `Language` WHERE `type` = '0' AND `visible` = '1' AND `active` = '1' ORDER BY `order` ASC, `name` ASC | 1 | 1 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`type`, `Language`.`code`, `Language`.`order`, `Language`.`default`, `Language`.`visible`, `Language`.`active`, `Language`.`created`, `Language`.`modified`, `Language`.`create_user`, `Language`.`mod_user` FROM `sorenc5_db`.`cms_languages` AS `Language` WHERE `type` = '0' AND `default` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Module`.`id`, `Module`.`name`, `Module`.`description`, `Module`.`path`, `Module`.`sysmodule`, `Module`.`order`, `Module`.`cms`, `Module`.`visible`, `Module`.`created`, `Module`.`modified`, `Module`.`create_user`, `Module`.`mod_user` FROM `sorenc5_db`.`cms_modules` AS `Module` WHERE `Module`.`path` = 'contents' AND `Module`.`visible` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ModuleMenu`.`id`, `ModuleMenu`.`module_id`, `ModuleMenu`.`name`, `ModuleMenu`.`path`, `ModuleMenu`.`order`, `ModuleMenu`.`visible`, `ModuleMenu`.`created`, `ModuleMenu`.`modified`, `ModuleMenu`.`create_user`, `ModuleMenu`.`mod_user` FROM `sorenc5_db`.`cms_module_menus` AS `ModuleMenu` WHERE `ModuleMenu`.`module_id` = (1) ORDER BY `module_id` ASC, `order` ASC | 2 | 2 | 0 | |
SELECT `Content`.`id`, `Content`.`category_id`, `Content`.`slug`, `Content`.`title`, `Content`.`content`, `Content`.`order`, `Content`.`meta_title`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`visible_title`, `Content`.`active`, `Content`.`visible`, `Content`.`editable`, `Content`.`deleteable`, `Content`.`created`, `Content`.`modified`, `Content`.`create_user`, `Content`.`mod_user`, (`I18n__slugTranslation`.`content`) AS `Content__i18n_slugTranslation`, (`I18n__titleTranslation`.`content`) AS `Content__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Content__i18n_contentTranslation`, (`I18n__metaTitleTranslation`.`content`) AS `Content__i18n_metaTitleTranslation`, (`I18n__metaDescriptionTranslation`.`content`) AS `Content__i18n_metaDescriptionTranslation`, (`I18n__metaKeywordsTranslation`.`content`) AS `Content__i18n_metaKeywordsTranslation` FROM `sorenc5_db`.`cms_contents` AS `Content` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slugTranslation` ON (`Content`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Content' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Content`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Content' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Content`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Content' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaTitleTranslation` ON (`Content`.`id` = `I18n__metaTitleTranslation`.`foreign_key` AND `I18n__metaTitleTranslation`.`model` = 'Content' AND `I18n__metaTitleTranslation`.`field` = 'meta_title' AND `I18n__metaTitleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaDescriptionTranslation` ON (`Content`.`id` = `I18n__metaDescriptionTranslation`.`foreign_key` AND `I18n__metaDescriptionTranslation`.`model` = 'Content' AND `I18n__metaDescriptionTranslation`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaKeywordsTranslation` ON (`Content`.`id` = `I18n__metaKeywordsTranslation`.`foreign_key` AND `I18n__metaKeywordsTranslation`.`model` = 'Content' AND `I18n__metaKeywordsTranslation`.`field` = 'meta_keywords' AND `I18n__metaKeywordsTranslation`.`locale` = 'eng') WHERE `Content`.`active` = '1' AND `Content`.`visible` = '1' AND `slug` = 'contents' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`product_category_id`, `Product`.`slug`, `Product`.`title`, `Product`.`intro`, `Product`.`content`, `Product`.`thumb`, `Product`.`thumb_text1`, `Product`.`thumb_text2`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`active`, `Product`.`visible`, `Product`.`order`, `Product`.`created`, `Product`.`modified`, `Product`.`create_user`, `Product`.`mod_user`, `Product`.`param1`, `Product`.`param2`, `Product`.`param3`, `Product`.`param4`, `Product`.`param5`, `Product`.`param6`, `Product`.`param7`, `Product`.`param8`, `Product`.`param9`, `Product`.`param10`, `Product`.`param11`, `Product`.`param12`, `Product`.`param13`, `Product`.`param14`, `Product`.`param15`, `Product`.`param16`, `Product`.`param17`, `Product`.`param18`, `Product`.`param19`, `Product`.`param20`, (`I18n__slugTranslation`.`content`) AS `Product__i18n_slugTranslation`, (`I18n__titleTranslation`.`content`) AS `Product__i18n_titleTranslation`, (`I18n__introTranslation`.`content`) AS `Product__i18n_introTranslation`, (`I18n__contentTranslation`.`content`) AS `Product__i18n_contentTranslation`, (`I18n__metaTitleTranslation`.`content`) AS `Product__i18n_metaTitleTranslation`, (`I18n__metaDescriptionTranslation`.`content`) AS `Product__i18n_metaDescriptionTranslation`, (`I18n__metaKeywordsTranslation`.`content`) AS `Product__i18n_metaKeywordsTranslation`, `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`slug`, `ProductCategory`.`title`, `ProductCategory`.`content`, `ProductCategory`.`pagelimit`, `ProductCategory`.`order`, `ProductCategory`.`meta_title`, `ProductCategory`.`meta_keywords`, `ProductCategory`.`meta_description`, `ProductCategory`.`active`, `ProductCategory`.`visible`, `ProductCategory`.`editable`, `ProductCategory`.`deleteable`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`create_user`, `ProductCategory`.`mod_user`, `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `sorenc5_db`.`cms_products` AS `Product` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slugTranslation` ON (`Product`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Product' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Product`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Product' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__introTranslation` ON (`Product`.`id` = `I18n__introTranslation`.`foreign_key` AND `I18n__introTranslation`.`model` = 'Product' AND `I18n__introTranslation`.`field` = 'intro' AND `I18n__introTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Product`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Product' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaTitleTranslation` ON (`Product`.`id` = `I18n__metaTitleTranslation`.`foreign_key` AND `I18n__metaTitleTranslation`.`model` = 'Product' AND `I18n__metaTitleTranslation`.`field` = 'meta_title' AND `I18n__metaTitleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaDescriptionTranslation` ON (`Product`.`id` = `I18n__metaDescriptionTranslation`.`foreign_key` AND `I18n__metaDescriptionTranslation`.`model` = 'Product' AND `I18n__metaDescriptionTranslation`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaKeywordsTranslation` ON (`Product`.`id` = `I18n__metaKeywordsTranslation`.`foreign_key` AND `I18n__metaKeywordsTranslation`.`model` = 'Product' AND `I18n__metaKeywordsTranslation`.`field` = 'meta_keywords' AND `I18n__metaKeywordsTranslation`.`locale` = 'eng') LEFT JOIN `sorenc5_db`.`cms_product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`visible` = '1' AND `Product`.`slug` = 'contents' LIMIT 1 | 0 | 0 | 60 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`slug`, `ProductCategory`.`title`, `ProductCategory`.`content`, `ProductCategory`.`pagelimit`, `ProductCategory`.`order`, `ProductCategory`.`meta_title`, `ProductCategory`.`meta_keywords`, `ProductCategory`.`meta_description`, `ProductCategory`.`active`, `ProductCategory`.`visible`, `ProductCategory`.`editable`, `ProductCategory`.`deleteable`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`create_user`, `ProductCategory`.`mod_user`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, (`I18n__slugTranslation`.`content`) AS `ProductCategory__i18n_slugTranslation`, (`I18n__titleTranslation`.`content`) AS `ProductCategory__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `ProductCategory__i18n_contentTranslation`, (`I18n__metaTitleTranslation`.`content`) AS `ProductCategory__i18n_metaTitleTranslation`, (`I18n__metaDescriptionTranslation`.`content`) AS `ProductCategory__i18n_metaDescriptionTranslation`, (`I18n__metaKeywordsTranslation`.`content`) AS `ProductCategory__i18n_metaKeywordsTranslation` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slugTranslation` ON (`ProductCategory`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'ProductCategory' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`ProductCategory`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'ProductCategory' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`ProductCategory`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'ProductCategory' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaTitleTranslation` ON (`ProductCategory`.`id` = `I18n__metaTitleTranslation`.`foreign_key` AND `I18n__metaTitleTranslation`.`model` = 'ProductCategory' AND `I18n__metaTitleTranslation`.`field` = 'meta_title' AND `I18n__metaTitleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaDescriptionTranslation` ON (`ProductCategory`.`id` = `I18n__metaDescriptionTranslation`.`foreign_key` AND `I18n__metaDescriptionTranslation`.`model` = 'ProductCategory' AND `I18n__metaDescriptionTranslation`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaKeywordsTranslation` ON (`ProductCategory`.`id` = `I18n__metaKeywordsTranslation`.`foreign_key` AND `I18n__metaKeywordsTranslation`.`model` = 'ProductCategory' AND `I18n__metaKeywordsTranslation`.`field` = 'meta_keywords' AND `I18n__metaKeywordsTranslation`.`locale` = 'eng') WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`visible` = '1' AND `ProductCategory`.`slug` = 'contents' LIMIT 1 | 0 | 0 | 8 | maybe slow |
SELECT `Content`.`id`, `Content`.`category_id`, `Content`.`slug`, `Content`.`title`, `Content`.`content`, `Content`.`order`, `Content`.`meta_title`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`visible_title`, `Content`.`active`, `Content`.`visible`, `Content`.`editable`, `Content`.`deleteable`, `Content`.`created`, `Content`.`modified`, `Content`.`create_user`, `Content`.`mod_user`, (`I18n__slugTranslation`.`content`) AS `Content__i18n_slugTranslation`, (`I18n__titleTranslation`.`content`) AS `Content__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Content__i18n_contentTranslation`, (`I18n__metaTitleTranslation`.`content`) AS `Content__i18n_metaTitleTranslation`, (`I18n__metaDescriptionTranslation`.`content`) AS `Content__i18n_metaDescriptionTranslation`, (`I18n__metaKeywordsTranslation`.`content`) AS `Content__i18n_metaKeywordsTranslation` FROM `sorenc5_db`.`cms_contents` AS `Content` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slugTranslation` ON (`Content`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Content' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Content`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Content' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Content`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Content' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaTitleTranslation` ON (`Content`.`id` = `I18n__metaTitleTranslation`.`foreign_key` AND `I18n__metaTitleTranslation`.`model` = 'Content' AND `I18n__metaTitleTranslation`.`field` = 'meta_title' AND `I18n__metaTitleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaDescriptionTranslation` ON (`Content`.`id` = `I18n__metaDescriptionTranslation`.`foreign_key` AND `I18n__metaDescriptionTranslation`.`model` = 'Content' AND `I18n__metaDescriptionTranslation`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaKeywordsTranslation` ON (`Content`.`id` = `I18n__metaKeywordsTranslation`.`foreign_key` AND `I18n__metaKeywordsTranslation`.`model` = 'Content' AND `I18n__metaKeywordsTranslation`.`field` = 'meta_keywords' AND `I18n__metaKeywordsTranslation`.`locale` = 'eng') WHERE `Content`.`active` = '1' AND `Content`.`visible` = '1' AND `slug` = 'contents' LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`slug`, `ProductCategory`.`title`, `ProductCategory`.`content`, `ProductCategory`.`pagelimit`, `ProductCategory`.`order`, `ProductCategory`.`meta_title`, `ProductCategory`.`meta_keywords`, `ProductCategory`.`meta_description`, `ProductCategory`.`active`, `ProductCategory`.`visible`, `ProductCategory`.`editable`, `ProductCategory`.`deleteable`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`create_user`, `ProductCategory`.`mod_user`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, (`I18n__slugTranslation`.`content`) AS `ProductCategory__i18n_slugTranslation`, (`I18n__titleTranslation`.`content`) AS `ProductCategory__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `ProductCategory__i18n_contentTranslation`, (`I18n__metaTitleTranslation`.`content`) AS `ProductCategory__i18n_metaTitleTranslation`, (`I18n__metaDescriptionTranslation`.`content`) AS `ProductCategory__i18n_metaDescriptionTranslation`, (`I18n__metaKeywordsTranslation`.`content`) AS `ProductCategory__i18n_metaKeywordsTranslation` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slugTranslation` ON (`ProductCategory`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'ProductCategory' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`ProductCategory`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'ProductCategory' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`ProductCategory`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'ProductCategory' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaTitleTranslation` ON (`ProductCategory`.`id` = `I18n__metaTitleTranslation`.`foreign_key` AND `I18n__metaTitleTranslation`.`model` = 'ProductCategory' AND `I18n__metaTitleTranslation`.`field` = 'meta_title' AND `I18n__metaTitleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaDescriptionTranslation` ON (`ProductCategory`.`id` = `I18n__metaDescriptionTranslation`.`foreign_key` AND `I18n__metaDescriptionTranslation`.`model` = 'ProductCategory' AND `I18n__metaDescriptionTranslation`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaKeywordsTranslation` ON (`ProductCategory`.`id` = `I18n__metaKeywordsTranslation`.`foreign_key` AND `I18n__metaKeywordsTranslation`.`model` = 'ProductCategory' AND `I18n__metaKeywordsTranslation`.`field` = 'meta_keywords' AND `I18n__metaKeywordsTranslation`.`locale` = 'eng') WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`visible` = '1' AND `ProductCategory`.`slug` = 'contents' LIMIT 1 | 0 | 0 | 8 | maybe slow |
SELECT `Product`.`id`, `Product`.`product_category_id`, `Product`.`slug`, `Product`.`title`, `Product`.`intro`, `Product`.`content`, `Product`.`thumb`, `Product`.`thumb_text1`, `Product`.`thumb_text2`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`active`, `Product`.`visible`, `Product`.`order`, `Product`.`created`, `Product`.`modified`, `Product`.`create_user`, `Product`.`mod_user`, `Product`.`param1`, `Product`.`param2`, `Product`.`param3`, `Product`.`param4`, `Product`.`param5`, `Product`.`param6`, `Product`.`param7`, `Product`.`param8`, `Product`.`param9`, `Product`.`param10`, `Product`.`param11`, `Product`.`param12`, `Product`.`param13`, `Product`.`param14`, `Product`.`param15`, `Product`.`param16`, `Product`.`param17`, `Product`.`param18`, `Product`.`param19`, `Product`.`param20`, (`I18n__slugTranslation`.`content`) AS `Product__i18n_slugTranslation`, (`I18n__titleTranslation`.`content`) AS `Product__i18n_titleTranslation`, (`I18n__introTranslation`.`content`) AS `Product__i18n_introTranslation`, (`I18n__contentTranslation`.`content`) AS `Product__i18n_contentTranslation`, (`I18n__metaTitleTranslation`.`content`) AS `Product__i18n_metaTitleTranslation`, (`I18n__metaDescriptionTranslation`.`content`) AS `Product__i18n_metaDescriptionTranslation`, (`I18n__metaKeywordsTranslation`.`content`) AS `Product__i18n_metaKeywordsTranslation`, `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`slug`, `ProductCategory`.`title`, `ProductCategory`.`content`, `ProductCategory`.`pagelimit`, `ProductCategory`.`order`, `ProductCategory`.`meta_title`, `ProductCategory`.`meta_keywords`, `ProductCategory`.`meta_description`, `ProductCategory`.`active`, `ProductCategory`.`visible`, `ProductCategory`.`editable`, `ProductCategory`.`deleteable`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`create_user`, `ProductCategory`.`mod_user`, `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `sorenc5_db`.`cms_products` AS `Product` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slugTranslation` ON (`Product`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Product' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Product`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Product' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__introTranslation` ON (`Product`.`id` = `I18n__introTranslation`.`foreign_key` AND `I18n__introTranslation`.`model` = 'Product' AND `I18n__introTranslation`.`field` = 'intro' AND `I18n__introTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Product`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Product' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaTitleTranslation` ON (`Product`.`id` = `I18n__metaTitleTranslation`.`foreign_key` AND `I18n__metaTitleTranslation`.`model` = 'Product' AND `I18n__metaTitleTranslation`.`field` = 'meta_title' AND `I18n__metaTitleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaDescriptionTranslation` ON (`Product`.`id` = `I18n__metaDescriptionTranslation`.`foreign_key` AND `I18n__metaDescriptionTranslation`.`model` = 'Product' AND `I18n__metaDescriptionTranslation`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaKeywordsTranslation` ON (`Product`.`id` = `I18n__metaKeywordsTranslation`.`foreign_key` AND `I18n__metaKeywordsTranslation`.`model` = 'Product' AND `I18n__metaKeywordsTranslation`.`field` = 'meta_keywords' AND `I18n__metaKeywordsTranslation`.`locale` = 'eng') LEFT JOIN `sorenc5_db`.`cms_product_categories` AS `ProductCategory` ON (`Product`.`product_category_id` = `ProductCategory`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`visible` = '1' AND `Product`.`slug` = 'contents' | 0 | 0 | 57 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`slug`, `ProductCategory`.`title`, `ProductCategory`.`content`, `ProductCategory`.`pagelimit`, `ProductCategory`.`order`, `ProductCategory`.`meta_title`, `ProductCategory`.`meta_keywords`, `ProductCategory`.`meta_description`, `ProductCategory`.`active`, `ProductCategory`.`visible`, `ProductCategory`.`editable`, `ProductCategory`.`deleteable`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`create_user`, `ProductCategory`.`mod_user`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, (`I18n__slugTranslation`.`content`) AS `ProductCategory__i18n_slugTranslation`, (`I18n__titleTranslation`.`content`) AS `ProductCategory__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `ProductCategory__i18n_contentTranslation`, (`I18n__metaTitleTranslation`.`content`) AS `ProductCategory__i18n_metaTitleTranslation`, (`I18n__metaDescriptionTranslation`.`content`) AS `ProductCategory__i18n_metaDescriptionTranslation`, (`I18n__metaKeywordsTranslation`.`content`) AS `ProductCategory__i18n_metaKeywordsTranslation` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slugTranslation` ON (`ProductCategory`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'ProductCategory' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`ProductCategory`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'ProductCategory' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`ProductCategory`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'ProductCategory' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaTitleTranslation` ON (`ProductCategory`.`id` = `I18n__metaTitleTranslation`.`foreign_key` AND `I18n__metaTitleTranslation`.`model` = 'ProductCategory' AND `I18n__metaTitleTranslation`.`field` = 'meta_title' AND `I18n__metaTitleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaDescriptionTranslation` ON (`ProductCategory`.`id` = `I18n__metaDescriptionTranslation`.`foreign_key` AND `I18n__metaDescriptionTranslation`.`model` = 'ProductCategory' AND `I18n__metaDescriptionTranslation`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaKeywordsTranslation` ON (`ProductCategory`.`id` = `I18n__metaKeywordsTranslation`.`foreign_key` AND `I18n__metaKeywordsTranslation`.`model` = 'ProductCategory' AND `I18n__metaKeywordsTranslation`.`field` = 'meta_keywords' AND `I18n__metaKeywordsTranslation`.`locale` = 'eng') WHERE `ProductCategory`.`active` = '1' AND `ProductCategory`.`visible` = '1' AND `ProductCategory`.`slug` = 'contents' | 0 | 0 | 12 | maybe slow |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`title`, `Menu`.`link`, `Menu`.`css_class`, `Menu`.`order`, `Menu`.`active`, `Menu`.`visible`, `Menu`.`editable`, `Menu`.`deleteable`, `Menu`.`insite`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`create_user`, `Menu`.`mod_user`, `Menu`.`lft`, `Menu`.`rght`, (`I18n__titleTranslation`.`content`) AS `Menu__i18n_titleTranslation`, (`I18n__linkTranslation`.`content`) AS `Menu__i18n_linkTranslation`, (`I18n__css_classTranslation`.`content`) AS `Menu__i18n_css_classTranslation` FROM `sorenc5_db`.`cms_menus` AS `Menu` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Menu`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Menu' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__linkTranslation` ON (`Menu`.`id` = `I18n__linkTranslation`.`foreign_key` AND `I18n__linkTranslation`.`model` = 'Menu' AND `I18n__linkTranslation`.`field` = 'link' AND `I18n__linkTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__css_classTranslation` ON (`Menu`.`id` = `I18n__css_classTranslation`.`foreign_key` AND `I18n__css_classTranslation`.`model` = 'Menu' AND `I18n__css_classTranslation`.`field` = 'css_class' AND `I18n__css_classTranslation`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `Menu`.`lft` asc | 60 | 60 | 10 | maybe slow |
SELECT `Banner`.`id`, `Banner`.`name`, `Banner`.`image`, `Banner`.`place`, `Banner`.`order`, `Banner`.`visible`, `Banner`.`active`, `Banner`.`start_date`, `Banner`.`end_date`, `Banner`.`width`, `Banner`.`height`, `Banner`.`url`, `Banner`.`terms_url`, `Banner`.`insite`, `Banner`.`popup`, `Banner`.`create_user`, `Banner`.`mod_user`, `Banner`.`created`, `Banner`.`modified`, (`I18n__nameTranslation`.`content`) AS `Banner__i18n_nameTranslation`, (`I18n__imageTranslation`.`content`) AS `Banner__i18n_imageTranslation`, (`I18n__urlTranslation`.`content`) AS `Banner__i18n_urlTranslation`, (`I18n__termsUrlTranslation`.`content`) AS `Banner__i18n_termsUrlTranslation` FROM `sorenc5_db`.`cms_banners` AS `Banner` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__nameTranslation` ON (`Banner`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Banner' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__imageTranslation` ON (`Banner`.`id` = `I18n__imageTranslation`.`foreign_key` AND `I18n__imageTranslation`.`model` = 'Banner' AND `I18n__imageTranslation`.`field` = 'image' AND `I18n__imageTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__urlTranslation` ON (`Banner`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'Banner' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__termsUrlTranslation` ON (`Banner`.`id` = `I18n__termsUrlTranslation`.`foreign_key` AND `I18n__termsUrlTranslation`.`model` = 'Banner' AND `I18n__termsUrlTranslation`.`field` = 'terms_url' AND `I18n__termsUrlTranslation`.`locale` = 'eng') WHERE `visible` = '1' AND `active` = '1' AND ((`start_date` <= '2022-08-11 13:01:45') OR (`start_date` IS NULL)) AND ((`end_date` > '2022-08-11 13:01:45') OR (`end_date` IS NULL)) ORDER BY `place` ASC, `order` ASC | 0 | 0 | 1 | maybe slow |
SELECT `Content`.`id`, `Content`.`category_id`, `Content`.`slug`, `Content`.`title`, `Content`.`content`, `Content`.`order`, `Content`.`meta_title`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`visible_title`, `Content`.`active`, `Content`.`visible`, `Content`.`editable`, `Content`.`deleteable`, `Content`.`created`, `Content`.`modified`, `Content`.`create_user`, `Content`.`mod_user`, (`I18n__slugTranslation`.`content`) AS `Content__i18n_slugTranslation`, (`I18n__titleTranslation`.`content`) AS `Content__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Content__i18n_contentTranslation`, (`I18n__metaTitleTranslation`.`content`) AS `Content__i18n_metaTitleTranslation`, (`I18n__metaDescriptionTranslation`.`content`) AS `Content__i18n_metaDescriptionTranslation`, (`I18n__metaKeywordsTranslation`.`content`) AS `Content__i18n_metaKeywordsTranslation` FROM `sorenc5_db`.`cms_contents` AS `Content` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slugTranslation` ON (`Content`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Content' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Content`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Content' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Content`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Content' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaTitleTranslation` ON (`Content`.`id` = `I18n__metaTitleTranslation`.`foreign_key` AND `I18n__metaTitleTranslation`.`model` = 'Content' AND `I18n__metaTitleTranslation`.`field` = 'meta_title' AND `I18n__metaTitleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaDescriptionTranslation` ON (`Content`.`id` = `I18n__metaDescriptionTranslation`.`foreign_key` AND `I18n__metaDescriptionTranslation`.`model` = 'Content' AND `I18n__metaDescriptionTranslation`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaKeywordsTranslation` ON (`Content`.`id` = `I18n__metaKeywordsTranslation`.`foreign_key` AND `I18n__metaKeywordsTranslation`.`model` = 'Content' AND `I18n__metaKeywordsTranslation`.`field` = 'meta_keywords' AND `I18n__metaKeywordsTranslation`.`locale` = 'eng') WHERE `Content`.`category_id` = 2 AND `Content`.`active` = '1' AND `Content`.`visible` = '1' ORDER BY `Content`.`order` ASC, `Content`.`created` DESC | 0 | 0 | 3 | maybe slow |
SELECT `SlideshowContent`.`id`, `SlideshowContent`.`slideshow_id`, `SlideshowContent`.`media_url`, `SlideshowContent`.`title`, `SlideshowContent`.`content`, `SlideshowContent`.`link`, `SlideshowContent`.`insite`, `SlideshowContent`.`active`, `SlideshowContent`.`visible`, `SlideshowContent`.`order`, `SlideshowContent`.`created`, `SlideshowContent`.`modified`, `SlideshowContent`.`create_user`, `SlideshowContent`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `SlideshowContent__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `SlideshowContent__i18n_contentTranslation`, (`I18n__linkTranslation`.`content`) AS `SlideshowContent__i18n_linkTranslation`, `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user` FROM `sorenc5_db`.`cms_slideshow_contents` AS `SlideshowContent` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`SlideshowContent`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'SlideshowContent' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`SlideshowContent`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'SlideshowContent' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__linkTranslation` ON (`SlideshowContent`.`id` = `I18n__linkTranslation`.`foreign_key` AND `I18n__linkTranslation`.`model` = 'SlideshowContent' AND `I18n__linkTranslation`.`field` = 'link' AND `I18n__linkTranslation`.`locale` = 'eng') LEFT JOIN `sorenc5_db`.`cms_slideshows` AS `Slideshow` ON (`SlideshowContent`.`slideshow_id` = `Slideshow`.`id`) WHERE `Slideshow`.`active` = '1' AND `Slideshow`.`visible` = '1' AND `SlideshowContent`.`active` = '1' AND `SlideshowContent`.`visible` = '1' ORDER BY RAND() ASC | 28 | 28 | 5 | maybe slow |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `titleTranslation` WHERE `model` = 'SlideshowContent' AND `field` = 'title' AND `titleTranslation`.`foreign_key` IN (28, 32, 30, 36, 17, 14, 35, 9, 19, 25, 26, 22, 24, 31, 15, 12, 34, 29, 10, 21, 11, 20, 13, 27, 16, 23, 18, 33) | 28 | 28 | 1 | |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `contentTranslation` WHERE `model` = 'SlideshowContent' AND `field` = 'content' AND `contentTranslation`.`foreign_key` IN (28, 32, 30, 36, 17, 14, 35, 9, 19, 25, 26, 22, 24, 31, 15, 12, 34, 29, 10, 21, 11, 20, 13, 27, 16, 23, 18, 33) | 28 | 28 | 1 | |
SELECT `linkTranslation`.`id`, `linkTranslation`.`locale`, `linkTranslation`.`model`, `linkTranslation`.`foreign_key`, `linkTranslation`.`field`, `linkTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `linkTranslation` WHERE `model` = 'SlideshowContent' AND `field` = 'link' AND `linkTranslation`.`foreign_key` IN (28, 32, 30, 36, 17, 14, 35, 9, 19, 25, 26, 22, 24, 31, 15, 12, 34, 29, 10, 21, 11, 20, 13, 27, 16, 23, 18, 33) | 28 | 28 | 1 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`slug`, `Slideshow`.`title`, `Slideshow`.`content`, `Slideshow`.`visible`, `Slideshow`.`active`, `Slideshow`.`editable`, `Slideshow`.`deleteable`, `Slideshow`.`created`, `Slideshow`.`modified`, `Slideshow`.`create_user`, `Slideshow`.`mod_user`, (`I18n__titleTranslation`.`content`) AS `Slideshow__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Slideshow__i18n_contentTranslation` FROM `sorenc5_db`.`cms_slideshows` AS `Slideshow` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Slideshow`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slideshow' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Slideshow`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Slideshow' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') WHERE `Slideshow`.`visible` = '1' AND `Slideshow`.`active` = '1' AND `Slideshow`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Content`.`id`, `Content`.`category_id`, `Content`.`slug`, `Content`.`title`, `Content`.`content`, `Content`.`order`, `Content`.`meta_title`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`visible_title`, `Content`.`active`, `Content`.`visible`, `Content`.`editable`, `Content`.`deleteable`, `Content`.`created`, `Content`.`modified`, `Content`.`create_user`, `Content`.`mod_user`, (`I18n__slugTranslation`.`content`) AS `Content__i18n_slugTranslation`, (`I18n__titleTranslation`.`content`) AS `Content__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Content__i18n_contentTranslation`, (`I18n__metaTitleTranslation`.`content`) AS `Content__i18n_metaTitleTranslation`, (`I18n__metaDescriptionTranslation`.`content`) AS `Content__i18n_metaDescriptionTranslation`, (`I18n__metaKeywordsTranslation`.`content`) AS `Content__i18n_metaKeywordsTranslation` FROM `sorenc5_db`.`cms_contents` AS `Content` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slugTranslation` ON (`Content`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Content' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__titleTranslation` ON (`Content`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Content' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__contentTranslation` ON (`Content`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Content' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaTitleTranslation` ON (`Content`.`id` = `I18n__metaTitleTranslation`.`foreign_key` AND `I18n__metaTitleTranslation`.`model` = 'Content' AND `I18n__metaTitleTranslation`.`field` = 'meta_title' AND `I18n__metaTitleTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaDescriptionTranslation` ON (`Content`.`id` = `I18n__metaDescriptionTranslation`.`foreign_key` AND `I18n__metaDescriptionTranslation`.`model` = 'Content' AND `I18n__metaDescriptionTranslation`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslation`.`locale` = 'eng') INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__metaKeywordsTranslation` ON (`Content`.`id` = `I18n__metaKeywordsTranslation`.`foreign_key` AND `I18n__metaKeywordsTranslation`.`model` = 'Content' AND `I18n__metaKeywordsTranslation`.`field` = 'meta_keywords' AND `I18n__metaKeywordsTranslation`.`locale` = 'eng') WHERE `Content`.`id` = 3 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `slugTranslation` WHERE `model` = 'Content' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (3) | 3 | 3 | 0 | |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `titleTranslation` WHERE `model` = 'Content' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (3) | 3 | 3 | 0 | |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `contentTranslation` WHERE `model` = 'Content' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (3) | 3 | 3 | 0 | |
SELECT `metaTitleTranslation`.`id`, `metaTitleTranslation`.`locale`, `metaTitleTranslation`.`model`, `metaTitleTranslation`.`foreign_key`, `metaTitleTranslation`.`field`, `metaTitleTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaTitleTranslation` WHERE `model` = 'Content' AND `field` = 'meta_title' AND `metaTitleTranslation`.`foreign_key` = (3) | 3 | 3 | 0 | |
SELECT `metaDescriptionTranslation`.`id`, `metaDescriptionTranslation`.`locale`, `metaDescriptionTranslation`.`model`, `metaDescriptionTranslation`.`foreign_key`, `metaDescriptionTranslation`.`field`, `metaDescriptionTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaDescriptionTranslation` WHERE `model` = 'Content' AND `field` = 'meta_description' AND `metaDescriptionTranslation`.`foreign_key` = (3) | 3 | 3 | 0 | |
SELECT `metaKeywordsTranslation`.`id`, `metaKeywordsTranslation`.`locale`, `metaKeywordsTranslation`.`model`, `metaKeywordsTranslation`.`foreign_key`, `metaKeywordsTranslation`.`field`, `metaKeywordsTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaKeywordsTranslation` WHERE `model` = 'Content' AND `field` = 'meta_keywords' AND `metaKeywordsTranslation`.`foreign_key` = (3) | 3 | 3 | 0 | |