No avialable product.
Developed by Webpole
2011-2022 • Copyright • UVC Spectrum LTD
No avialable product.
No post data.
No querystring data.
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 | 1 | |
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` = 'ozone_producing_uv_lamps' 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` = 'ozone_producing_uv_lamps' LIMIT 1 | 0 | 0 | 52 | 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` = 'ozone_producing_uv_lamps' LIMIT 1 | 1 | 1 | 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` FROM `sorenc5_db`.`cms_products` AS `Product` WHERE `Product`.`product_category_id` = (10) | 0 | 0 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `slugTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (10) | 1 | 1 | 1 | |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `titleTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (10) | 1 | 1 | 1 | |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `contentTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (10) | 1 | 1 | 0 | |
SELECT `metaTitleTranslation`.`id`, `metaTitleTranslation`.`locale`, `metaTitleTranslation`.`model`, `metaTitleTranslation`.`foreign_key`, `metaTitleTranslation`.`field`, `metaTitleTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaTitleTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'meta_title' AND `metaTitleTranslation`.`foreign_key` = (10) | 1 | 1 | 1 | |
SELECT `metaDescriptionTranslation`.`id`, `metaDescriptionTranslation`.`locale`, `metaDescriptionTranslation`.`model`, `metaDescriptionTranslation`.`foreign_key`, `metaDescriptionTranslation`.`field`, `metaDescriptionTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaDescriptionTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'meta_description' AND `metaDescriptionTranslation`.`foreign_key` = (10) | 1 | 1 | 0 | |
SELECT `metaKeywordsTranslation`.`id`, `metaKeywordsTranslation`.`locale`, `metaKeywordsTranslation`.`model`, `metaKeywordsTranslation`.`foreign_key`, `metaKeywordsTranslation`.`field`, `metaKeywordsTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaKeywordsTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'meta_keywords' AND `metaKeywordsTranslation`.`foreign_key` = (10) | 1 | 1 | 0 | |
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 10 LIMIT 1 | 1 | 1 | 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__slug`.`content`) AS `ProductCategory__i18n_slug` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slug` ON (`ProductCategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'ProductCategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE 1 = 1 AND `ProductCategory`.`lft` <= 6 AND `ProductCategory`.`rght` >= 7 ORDER BY `ProductCategory`.`lft` asc | 2 | 2 | 2 | |
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` = 'uvc_spectrum_lamps' LIMIT 1 | 0 | 0 | 1 | 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` = 'uvc_spectrum_lamps' LIMIT 1 | 1 | 1 | 12 | 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` FROM `sorenc5_db`.`cms_products` AS `Product` WHERE `Product`.`product_category_id` = (2) | 0 | 0 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `slugTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (2) | 1 | 1 | 0 | |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `titleTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (2) | 1 | 1 | 0 | |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `contentTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (2) | 1 | 1 | 0 | |
SELECT `metaTitleTranslation`.`id`, `metaTitleTranslation`.`locale`, `metaTitleTranslation`.`model`, `metaTitleTranslation`.`foreign_key`, `metaTitleTranslation`.`field`, `metaTitleTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaTitleTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'meta_title' AND `metaTitleTranslation`.`foreign_key` = (2) | 1 | 1 | 0 | |
SELECT `metaDescriptionTranslation`.`id`, `metaDescriptionTranslation`.`locale`, `metaDescriptionTranslation`.`model`, `metaDescriptionTranslation`.`foreign_key`, `metaDescriptionTranslation`.`field`, `metaDescriptionTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaDescriptionTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'meta_description' AND `metaDescriptionTranslation`.`foreign_key` = (2) | 1 | 1 | 0 | |
SELECT `metaKeywordsTranslation`.`id`, `metaKeywordsTranslation`.`locale`, `metaKeywordsTranslation`.`model`, `metaKeywordsTranslation`.`foreign_key`, `metaKeywordsTranslation`.`field`, `metaKeywordsTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaKeywordsTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'meta_keywords' AND `metaKeywordsTranslation`.`foreign_key` = (2) | 1 | 1 | 0 | |
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 2 LIMIT 1 | 1 | 1 | 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__slug`.`content`) AS `ProductCategory__i18n_slug` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slug` ON (`ProductCategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'ProductCategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE 1 = 1 AND `ProductCategory`.`lft` <= 1 AND `ProductCategory`.`rght` >= 10 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 3 | 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` = 'ozone_producing_uv_lamps' | 0 | 0 | 49 | 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` = 'ozone_producing_uv_lamps' | 1 | 1 | 9 | 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` FROM `sorenc5_db`.`cms_products` AS `Product` WHERE `Product`.`product_category_id` = (10) | 0 | 0 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `slugTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (10) | 1 | 1 | 0 | |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `titleTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (10) | 1 | 1 | 0 | |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `contentTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (10) | 1 | 1 | 0 | |
SELECT `metaTitleTranslation`.`id`, `metaTitleTranslation`.`locale`, `metaTitleTranslation`.`model`, `metaTitleTranslation`.`foreign_key`, `metaTitleTranslation`.`field`, `metaTitleTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaTitleTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'meta_title' AND `metaTitleTranslation`.`foreign_key` = (10) | 1 | 1 | 0 | |
SELECT `metaDescriptionTranslation`.`id`, `metaDescriptionTranslation`.`locale`, `metaDescriptionTranslation`.`model`, `metaDescriptionTranslation`.`foreign_key`, `metaDescriptionTranslation`.`field`, `metaDescriptionTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaDescriptionTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'meta_description' AND `metaDescriptionTranslation`.`foreign_key` = (10) | 1 | 1 | 0 | |
SELECT `metaKeywordsTranslation`.`id`, `metaKeywordsTranslation`.`locale`, `metaKeywordsTranslation`.`model`, `metaKeywordsTranslation`.`foreign_key`, `metaKeywordsTranslation`.`field`, `metaKeywordsTranslation`.`content` FROM `sorenc5_db`.`cms_i18n` AS `metaKeywordsTranslation` WHERE `model` = 'ProductCategory' AND `field` = 'meta_keywords' AND `metaKeywordsTranslation`.`foreign_key` = (10) | 1 | 1 | 0 | |
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 10 LIMIT 1 | 1 | 1 | 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__slug`.`content`) AS `ProductCategory__i18n_slug` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slug` ON (`ProductCategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'ProductCategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE 1 = 1 AND `ProductCategory`.`lft` <= 6 AND `ProductCategory`.`rght` >= 7 ORDER BY `ProductCategory`.`lft` asc | 2 | 2 | 3 | maybe slow |
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 10 LIMIT 1 | 1 | 1 | 1 | |
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__slug`.`content`) AS `ProductCategory__i18n_slug` FROM `sorenc5_db`.`cms_product_categories` AS `ProductCategory` INNER JOIN `sorenc5_db`.`cms_i18n` AS `I18n__slug` ON (`ProductCategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'ProductCategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE 1 = 1 AND `ProductCategory`.`lft` <= 6 AND `ProductCategory`.`rght` >= 7 ORDER BY `ProductCategory`.`lft` asc | 2 | 2 | 3 | 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`.`product_category_id` = 10 ORDER BY `Product`.`title` ASC | 0 | 0 | 12 | 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`.`parent_id` = 10 ORDER BY `ProductCategory`.`title` ASC | 0 | 0 | 2 | 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 | 7 | maybe slow |
SELECT `Menu`.`lft`, `Menu`.`rght` FROM `sorenc5_db`.`cms_menus` AS `Menu` WHERE `Menu`.`id` = 29 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` <= 12 AND `Menu`.`rght` >= 21 ORDER BY `Menu`.`lft` asc | 2 | 2 | 2 | |
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:22:45') OR (`start_date` IS NULL)) AND ((`end_date` > '2022-08-11 13:22: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 | 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 | 7 | 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 (23, 26, 36, 10, 24, 35, 34, 12, 21, 28, 14, 32, 31, 9, 22, 16, 19, 25, 11, 13, 17, 33, 20, 30, 18, 15, 27, 29) | 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 (23, 26, 36, 10, 24, 35, 34, 12, 21, 28, 14, 32, 31, 9, 22, 16, 19, 25, 11, 13, 17, 33, 20, 30, 18, 15, 27, 29) | 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 (23, 26, 36, 10, 24, 35, 34, 12, 21, 28, 14, 32, 31, 9, 22, 16, 19, 25, 11, 13, 17, 33, 20, 30, 18, 15, 27, 29) | 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 | 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 `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 | 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` = (3) | 3 | 3 | 1 | 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` = '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 |
Peak Memory Use 17.22 MB
Message | Memory use |
---|---|
Component initialization | 3.68 MB |
Controller action start | 7.91 MB |
Controller render start | 8.05 MB |
View render complete | 11.28 MB |
Total Request Time: 680 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 74.66 | |
Event: Controller.initialize | 209.90 | |
Event: Controller.startup | 5.62 | |
Controller action | 108.57 | |
Event: Controller.beforeRender | 134.72 | |
» Processing toolbar data | 24.66 | |
Rendering View | 14.00 | |
» Event: View.beforeRender | 0.06 | |
» Rendering APP/ViewResponsive/Contents/productlist.ctp | 1.03 | |
» » Rendering APP/ViewResponsive/Elements/menu/products_menu.ctp | 0.41 | |
» Event: View.afterRender | 0.04 | |
» Event: View.beforeLayout | 0.03 | |
» Rendering APP/ViewResponsive/Layouts/frontend.ctp | 11.48 | |
» » Rendering APP/ViewResponsive/Elements/script/google_siteverification.ctp | 0.22 | |
» » Rendering APP/ViewResponsive/Elements/script/google_analytics.ctp | 0.28 | |
» » Rendering APP/ViewResponsive/Elements/script/google_sitesearch.ctp | 0.20 | |
» » Rendering APP/ViewResponsive/Elements/menu/main_menu.ctp | 2.93 | |
» » » Rendering APP/ViewResponsive/Elements/menu/sub_menu.ctp | 0.47 | |
» » » Rendering APP/ViewResponsive/Elements/menu/sub_menu.ctp #2 | 1.00 | |
» » » Rendering APP/ViewResponsive/Elements/menu/sub_menu.ctp #3 | 0.41 | |
» » Rendering APP/ViewResponsive/Elements/uvc_breadcrumbs.ctp | 0.28 | |
» » Rendering APP/ViewResponsive/Elements/../Email/contact_product_ajax.ctp | 5.89 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
ENVIRONMENT | production |
URL | https://uvc-spectrum.com |
URL_SHORT | / |
Constant | Value |
---|---|
APP | /home/sorenc5/uvc-spectrum.com/app/ |
APP_DIR | app |
APPLIBS | /home/sorenc5/uvc-spectrum.com/app/Lib/ |
CACHE | /home/sorenc5/uvc-spectrum.com/app/tmp/cache/ |
CAKE | /home/sorenc5/uvc-spectrum.com/lib/Cake/ |
CAKE_CORE_INCLUDE_PATH | /home/sorenc5/uvc-spectrum.com/lib |
CORE_PATH | /home/sorenc5/uvc-spectrum.com/lib/ |
CAKE_VERSION | 2.4.6 |
CSS | /home/sorenc5/uvc-spectrum.com/app/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | https://uvc-spectrum.com |
IMAGES | /home/sorenc5/uvc-spectrum.com/app/webroot/img/ |
IMAGES_URL | img/ |
JS | /home/sorenc5/uvc-spectrum.com/app/webroot/js/ |
JS_URL | js/ |
LOGS | /home/sorenc5/uvc-spectrum.com/app/tmp/logs/ |
ROOT | /home/sorenc5/uvc-spectrum.com |
TESTS | /home/sorenc5/uvc-spectrum.com/app/Test/ |
TMP | /home/sorenc5/uvc-spectrum.com/app/tmp/ |
VENDORS | /home/sorenc5/uvc-spectrum.com/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /home/sorenc5/uvc-spectrum.com/app/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 5.6.40 |
Context Document Root | /home/sorenc5/uvc-spectrum.com |
Context Prefix | |
Document Root | /home/sorenc5/uvc-spectrum.com |
Gateway Interface | CGI/1.1 |
Https | on |
Http Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
Http Accept Encoding | br,gzip |
Http Accept Language | en-US,en;q=0.5 |
Http Connection | Keep-Alive |
Http Host | uvc-spectrum.com |
Http If Modified Since | Thu, 21 Oct 2021 08:15:47 GMT |
Http User Agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
Http X Https | 1 |
Path | /bin:/usr/bin |
Query String | |
Redirect Https | on |
Redirect Redirect Https | on |
Redirect Redirect Script Uri | https://uvc-spectrum.com/uvc_spectrum_lamps/ozone_producing_uv_lamps |
Redirect Redirect Script Url | /uvc_spectrum_lamps/ozone_producing_uv_lamps |
Redirect Redirect Ssl Tls Sni | uvc-spectrum.com |
Redirect Redirect Status | 200 |
Redirect Redirect Unique Id | YvTmhD_c7qNuELsXjTIeLgAABAQ |
Redirect Script Uri | https://uvc-spectrum.com/uvc_spectrum_lamps/ozone_producing_uv_lamps |
Redirect Script Url | /uvc_spectrum_lamps/ozone_producing_uv_lamps |
Redirect Ssl Tls Sni | uvc-spectrum.com |
Redirect Status | 200 |
Redirect Unique Id | YvTmhD_c7qNuELsXjTIeLgAABAQ |
Redirect Url | /app/webroot/uvc_spectrum_lamps/ozone_producing_uv_lamps |
Remote Addr | 44.200.175.255 |
Remote Port | 57400 |
Request Method | GET |
Request Scheme | https |
Request Uri | /uvc_spectrum_lamps/ozone_producing_uv_lamps |
Script Filename | /home/sorenc5/uvc-spectrum.com/app/webroot/index.php |
Script Name | /app/webroot/index.php |
Script Uri | https://uvc-spectrum.com/uvc_spectrum_lamps/ozone_producing_uv_lamps |
Script Url | /uvc_spectrum_lamps/ozone_producing_uv_lamps |
Server Addr | 198.46.81.153 |
Server Admin | webmaster@uvc-spectrum.sostarob.com |
Server Name | uvc-spectrum.com |
Server Port | 443 |
Server Protocol | HTTP/1.1 |
Server Signature | |
Server Software | Apache |
Ssl Tls Sni | uvc-spectrum.com |
Tz | America/New_York |
Unique Id | YvTmhD_c7qNuELsXjTIeLgAABAQ |
Php Self | /app/webroot/index.php |
Request Time Float | 1660216964.8526 |
Request Time | 1660216964 |
Argc | 0 |