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 | 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 `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 `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` = 1 AND `Content`.`active` = '1' AND `Content`.`visible` = '1' LIMIT 1 | 1 | 1 | 3 | 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` = (1) | 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` = (1) | 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` = (1) | 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` = (1) | 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` = (1) | 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` = (1) | 3 | 3 | 0 | |
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 | 6 | maybe slow |
SELECT `Menu`.`lft`, `Menu`.`rght` FROM `sorenc5_db`.`cms_menus` AS `Menu` WHERE `Menu`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Menu`.`id`, (`I18n__link`.`content`) AS `Menu__i18n_link` FROM `sorenc5_db`.`cms_menus` AS `Menu` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__link` ON (`Menu`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'Menu' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') WHERE 1 = 1 AND `Menu`.`lft` <= 1 AND `Menu`.`rght` >= 2 ORDER BY `Menu`.`lft` asc | 1 | 1 | 2 | maybe slow |
SELECT `Menu`.`lft`, `Menu`.`rght` FROM `sorenc5_db`.`cms_menus` AS `Menu` WHERE `Menu`.`id` = 28 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Menu`.`id`, (`I18n__link`.`content`) AS `Menu__i18n_link` FROM `sorenc5_db`.`cms_menus` AS `Menu` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__link` ON (`Menu`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'Menu' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') WHERE 1 = 1 AND `Menu`.`lft` <= 10 AND `Menu`.`rght` >= 11 ORDER BY `Menu`.`lft` asc | 2 | 2 | 1 | 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:20:27') OR (`start_date` IS NULL)) AND ((`end_date` > '2022-08-11 13:20:27') 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 | 2 | 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 | 4 | 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 (19, 17, 35, 14, 21, 10, 29, 24, 25, 16, 31, 27, 36, 34, 28, 20, 22, 32, 11, 15, 9, 12, 18, 23, 30, 13, 33, 26) | 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 (19, 17, 35, 14, 21, 10, 29, 24, 25, 16, 31, 27, 36, 34, 28, 20, 22, 32, 11, 15, 9, 12, 18, 23, 30, 13, 33, 26) | 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 (19, 17, 35, 14, 21, 10, 29, 24, 25, 16, 31, 27, 36, 34, 28, 20, 22, 32, 11, 15, 9, 12, 18, 23, 30, 13, 33, 26) | 28 | 28 | 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 | 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 | 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 | 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 `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 | |