No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Section`.`id`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `disfruta_online`.`sections` AS `Section` LEFT JOIN `disfruta_online`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE LOWER(`I18n__slug`.`content`) LIKE 'users%' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Section`.`id`, (`I18n__name`.`content`) AS `Section__i18n_name` FROM `disfruta_online`.`sections` AS `Section` LEFT JOIN `disfruta_online`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE LOWER(CONVERT(`I18n__name`.`content` USING latin1)) LIKE 'users%' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`code2`, `Language`.`code3` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' | 8 | 8 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' AND NOT (`Language`.`code2` IS NULL) | 8 | 8 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`code2` = 'en' LIMIT 1 | 1 | 1 | 0 | |
SELECT `EstadoInstalacion`.`instalacion`, `EstadoInstalacion`.`estado`, `EstadoInstalacion`.`actualizado` FROM `disfruta_online`.`estadoinstalaciones` AS `EstadoInstalacion` WHERE 1 = 1 | 6 | 6 | 0 | |
SELECT `Experience`.`id`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug` FROM `disfruta_online`.`experiences` AS `Experience` LEFT JOIN `disfruta_online`.`i18n` AS `I18n__name` ON (`Experience`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Experience' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__slug` ON (`Experience`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Experience' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `Experience`.`id` = 48 AND `Experience`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `disfruta_online`.`subcategories` AS `Subcategory` JOIN `disfruta_online`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`experience_id` = 48 AND `ExperiencesSubcategory`.`subcategory_id` = `Subcategory`.`id`) WHERE `category_id` IN (16, 19) ORDER BY `ExperiencesSubcategory`.`id` ASC | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Subcategory__i18n_name`, (`I18n__slug`.`content`) AS `Subcategory__i18n_slug` FROM `disfruta_online`.`subcategories` AS `Subcategory` inner JOIN `disfruta_online`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Subcategory' AND `I18n_name_spa`.`foreign_key` = `Subcategory`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__name` ON (`Subcategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Subcategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__slug` ON (`Subcategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Subcategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `Subcategory`.`id` = 73 AND `Subcategory`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Category__i18n_name`, (`I18n__slug`.`content`) AS `Category__i18n_slug` FROM `disfruta_online`.`categories` AS `Category` inner JOIN `disfruta_online`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Category' AND `I18n_name_spa`.`foreign_key` = `Category`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__slug` ON (`Category`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Category' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Category`.`id` = 16 AND `Category`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, (`I18n__name`.`content`) AS `Article__i18n_name`, (`I18n__slug`.`content`) AS `Article__i18n_slug` FROM `disfruta_online`.`articles` AS `Article` LEFT JOIN `disfruta_online`.`article_i18ns` AS `I18n__name` ON (`Article`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Article' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`article_i18ns` AS `I18n__slug` ON (`Article`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Article' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `Article`.`id` = 89 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `disfruta_online`.`sections` AS `Section` JOIN `disfruta_online`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 89 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`main_menu_order`, `Section`.`cancelled`, `Section`.`site_id`, `Section`.`created`, `Section`.`modified`, `Section`.`main_article_id`, `Section`.`category_id`, `Section`.`deleted`, `Section`.`deleted_date`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `disfruta_online`.`sections` AS `Section` LEFT JOIN `disfruta_online`.`section_i18ns` AS `I18n__name` ON (`Section`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Section' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`section_i18ns` AS `I18n__use_url` ON (`Section`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Section' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`section_i18ns` AS `I18n__slug` ON (`Section`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Section' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `Section`.`id` = 6 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Experience`.`id`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug` FROM `disfruta_online`.`experiences` AS `Experience` LEFT JOIN `disfruta_online`.`i18n` AS `I18n__name` ON (`Experience`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Experience' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__slug` ON (`Experience`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Experience' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `Experience`.`id` = 480 AND `Experience`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `disfruta_online`.`subcategories` AS `Subcategory` JOIN `disfruta_online`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`experience_id` = 480 AND `ExperiencesSubcategory`.`subcategory_id` = `Subcategory`.`id`) WHERE `category_id` IN (16, 19) ORDER BY `ExperiencesSubcategory`.`id` ASC | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Subcategory__i18n_name`, (`I18n__slug`.`content`) AS `Subcategory__i18n_slug` FROM `disfruta_online`.`subcategories` AS `Subcategory` inner JOIN `disfruta_online`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Subcategory' AND `I18n_name_spa`.`foreign_key` = `Subcategory`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__name` ON (`Subcategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Subcategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__slug` ON (`Subcategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Subcategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `Subcategory`.`id` = 69 AND `Subcategory`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Category__i18n_name`, (`I18n__slug`.`content`) AS `Category__i18n_slug` FROM `disfruta_online`.`categories` AS `Category` inner JOIN `disfruta_online`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Category' AND `I18n_name_spa`.`foreign_key` = `Category`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__slug` ON (`Category`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Category' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Category`.`id` = 16 AND `Category`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Experience`.`id`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug` FROM `disfruta_online`.`experiences` AS `Experience` LEFT JOIN `disfruta_online`.`i18n` AS `I18n__name` ON (`Experience`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Experience' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__slug` ON (`Experience`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Experience' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `Experience`.`id` = 449 AND `Experience`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `disfruta_online`.`subcategories` AS `Subcategory` JOIN `disfruta_online`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`experience_id` = 449 AND `ExperiencesSubcategory`.`subcategory_id` = `Subcategory`.`id`) WHERE `category_id` IN (16, 19) ORDER BY `ExperiencesSubcategory`.`id` ASC | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Subcategory__i18n_name`, (`I18n__slug`.`content`) AS `Subcategory__i18n_slug` FROM `disfruta_online`.`subcategories` AS `Subcategory` inner JOIN `disfruta_online`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Subcategory' AND `I18n_name_spa`.`foreign_key` = `Subcategory`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__name` ON (`Subcategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Subcategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__slug` ON (`Subcategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Subcategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `Subcategory`.`id` = 73 AND `Subcategory`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Category__i18n_name`, (`I18n__slug`.`content`) AS `Category__i18n_slug` FROM `disfruta_online`.`categories` AS `Category` inner JOIN `disfruta_online`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Category' AND `I18n_name_spa`.`foreign_key` = `Category`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'spa') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__slug` ON (`Category`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Category' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'spa') WHERE `Category`.`id` = 16 AND `Category`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date`, (`I18n__name`.`content`) AS `Subcategory__i18n_name`, (`I18n__titulo_seo`.`content`) AS `Subcategory__i18n_titulo_seo`, (`I18n__descripcion_seo`.`content`) AS `Subcategory__i18n_descripcion_seo`, (`I18n__descripcion`.`content`) AS `Subcategory__i18n_descripcion`, (`I18n__h1`.`content`) AS `Subcategory__i18n_h1`, (`I18n__h2`.`content`) AS `Subcategory__i18n_h2`, (`I18n__slug`.`content`) AS `Subcategory__i18n_slug`, (`I18n__lang_hide`.`content`) AS `Subcategory__i18n_lang_hide`, (`I18n__image`.`content`) AS `Subcategory__i18n_image` FROM `disfruta_online`.`subcategories` AS `Subcategory` LEFT JOIN `disfruta_online`.`i18n` AS `I18n__name` ON (`Subcategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Subcategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__titulo_seo` ON (`Subcategory`.`id` = `I18n__titulo_seo`.`foreign_key` AND `I18n__titulo_seo`.`model` = 'Subcategory' AND `I18n__titulo_seo`.`field` = 'titulo_seo' AND `I18n__titulo_seo`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__descripcion_seo` ON (`Subcategory`.`id` = `I18n__descripcion_seo`.`foreign_key` AND `I18n__descripcion_seo`.`model` = 'Subcategory' AND `I18n__descripcion_seo`.`field` = 'descripcion_seo' AND `I18n__descripcion_seo`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__descripcion` ON (`Subcategory`.`id` = `I18n__descripcion`.`foreign_key` AND `I18n__descripcion`.`model` = 'Subcategory' AND `I18n__descripcion`.`field` = 'descripcion' AND `I18n__descripcion`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__h1` ON (`Subcategory`.`id` = `I18n__h1`.`foreign_key` AND `I18n__h1`.`model` = 'Subcategory' AND `I18n__h1`.`field` = 'h1' AND `I18n__h1`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__h2` ON (`Subcategory`.`id` = `I18n__h2`.`foreign_key` AND `I18n__h2`.`model` = 'Subcategory' AND `I18n__h2`.`field` = 'h2' AND `I18n__h2`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__slug` ON (`Subcategory`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Subcategory' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__lang_hide` ON (`Subcategory`.`id` = `I18n__lang_hide`.`foreign_key` AND `I18n__lang_hide`.`model` = 'Subcategory' AND `I18n__lang_hide`.`field` = 'lang_hide' AND `I18n__lang_hide`.`locale` = 'eng') LEFT JOIN `disfruta_online`.`i18n` AS `I18n__image` ON (`Subcategory`.`id` = `I18n__image`.`foreign_key` AND `I18n__image`.`model` = 'Subcategory' AND `I18n__image`.`field` = 'image' AND `I18n__image`.`locale` = 'eng') WHERE `Subcategory`.`category_id` = 16 AND `Subcategory`.`cancelled` = '0' AND `I18n__name`.`content` <> '' AND `I18n__lang_hide`.`content` <> '1' AND NOT (`Subcategory`.`id` = 94) AND `Subcategory`.`deleted` = '0' ORDER BY (case when `Subcategory`.`id` = 72 then 'a' when `Subcategory`.`id` = 103 then 'aa' when `Subcategory`.`id` = 96 then 'aaa' when `Subcategory`.`id` = 99 then 'aaaa' when `Subcategory`.`id` = 69 then 'aaaaa' when `Subcategory`.`id` = 73 then 'aaaaaa' when `Subcategory`.`id` = 98 then 'aaaaaaa' when `Subcategory`.`id` = 107 then 'aaaaaaaa' when `Subcategory`.`id` = 95 then 'aaaaaaaaa' when `Subcategory`.`id` = 102 then 'aaaaaaaaaa' when `Subcategory`.`id` = 94 then 'aaaaaaaaaaa' when `Subcategory`.`id` = 105 then 'aaaaaaaaaaaa' when `Subcategory`.`id` = 108 then 'aaaaaaaaaaaaa' when `Subcategory`.`id` = 106 then 'aaaaaaaaaaaaaa' else `I18n__name`.`content` end) asc | 11 | 11 | 0 | |
SELECT `Experience`.`id`, `Experience`.`gps_lat`, `Experience`.`gps_long`, `Experience`.`promoted`, `Experience`.`cancelled`, `Experience`.`location_id`, `Experience`.`duration`, `Experience`.`duration_days`, `Experience`.`min_pax`, `Experience`.`max_pax`, `Experience`.`fixed_date`, `Experience`.`experience_description_title_id`, `Experience`.`difficulty_id`, `Experience`.`sort_order`, `Experience`.`transport_id`, `Experience`.`activity_id`, `Experience`.`duration_flexible`, `Experience`.`hotel_id`, `Experience`.`supplier_id`, `Experience`.`baby_max_age`, `Experience`.`child_max_age`, `Experience`.`visible_only_on_view`, `Experience`.`island_id`, `Experience`.`in_offer`, `Experience`.`promotur_result`, `Experience`.`canonical`, `Experience`.`canonical_experience_id`, `Experience`.`modified`, `Experience`.`promotur_exported`, `Experience`.`promotur_headers`, `Experience`.`promotur_response_code`, `Experience`.`discounts_only`, `Experience`.`alternatives_exp`, `Experience`.`date_change_limit`, `Experience`.`date_change_number_limit`, `Experience`.`deleted`, `Experience`.`deleted_date`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `disfruta_online`.`experiences` AS `Experience` JOIN `disfruta_online`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`subcategory_id` IN (72, 96, 99, 69, 73, 98, 95, 102, 105, 101, 111) AND `ExperiencesSubcategory`.`experience_id` = `Experience`.`id`) WHERE `Experience`.`cancelled` = '0' ORDER BY case when `ExperiencesSubcategory`.`sort_order` is null then 1000 else `ExperiencesSubcategory`.`sort_order` end ASC | 90 | 90 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO` FROM `disfruta_online`.`languages` AS `Language` WHERE `id` IN (1, 2, 4) | 3 | 3 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO` FROM `disfruta_online`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' AND NOT (`Language`.`code2` IS NULL) | 8 | 8 | 0 |
Peak Memory Use 52.81 MB
Message | Memory use |
---|---|
Component initialization | 4.11 MB |
Controller action start | 9.95 MB |
Controller render start | 11.11 MB |
View render complete | 11.91 MB |
Total Request Time: 495 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 29.07 | |
Event: Controller.initialize | 41.65 | |
Event: Controller.startup | 5.79 | |
Controller action | 6.24 | |
Event: Controller.beforeRender | 196.41 | |
» Processing toolbar data | 195.62 | |
Rendering View | 12.25 | |
» Event: View.beforeRender | 0.05 | |
» Rendering APP/View/Users/login.ctp | 3.92 | |
» Event: View.afterRender | 0.03 | |
» Event: View.beforeLayout | 0.03 | |
» Rendering APP/View/Layouts/default.ctp | 0.12 | |
» Rendering APP/View/Layouts/main.ctp | 7.01 | |
» » Rendering APP/View/Themed/Volcano/Elements/header/header.ctp | 1.33 | |
» » » Rendering APP/View/Themed/Volcano/Elements/header/main_menu.ctp | 0.43 | |
» » » Rendering APP/View/Themed/Volcano/Elements/header/language_selector.ctp | 0.56 | |
» » Rendering APP/View/Elements/../Themed/Volcano/Elements/header/cookie-popup.ctp | 0.22 | |
» » Rendering APP/View/Themed/Volcano/Elements/footer/footer.ctp | 2.57 | |
» » » Rendering APP/View/Themed/Volcano/Elements/footer/4columns.ctp | 0.52 | |
» » » Rendering APP/View/Themed/Volcano/Elements/footer/badges.ctp | 0.15 | |
» » » Rendering APP/View/Themed/Volcano/Elements/footer/legal-menus.ctp | 0.79 | |
» » » Rendering APP/View/Themed/Volcano/Elements/common/hubspot.ctp | 0.08 | |
Event: View.afterLayout | 0.00 |