Query | Affected | Num. rows | Took (ms) | Actions |
---|
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__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `Section`.`id` = 14 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`articles` AS `Article` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`section_id` = 14 AND `ArticlesSection`.`article_id` = `Article`.`id`) WHERE `Article`.`cancelled` = '0' ORDER BY `Article`.`main_menu_order` ASC | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'deu') WHERE `Article`.`id` = 111 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (111) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (111) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (111) ORDER BY `id` ASC | 8 | 8 | 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 `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 111 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__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `Section`.`id` = 11 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`articles` AS `Article` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`section_id` = 11 AND `ArticlesSection`.`article_id` = `Article`.`id`) WHERE `Article`.`cancelled` = '0' ORDER BY `Article`.`main_menu_order` ASC | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'deu') WHERE `Article`.`id` = 105 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (105) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (105) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (105) ORDER BY `id` ASC | 8 | 8 | 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 `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 105 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__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `Section`.`id` = 13 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, `ArticlesSection`.`id`, `ArticlesSection`.`article_id`, `ArticlesSection`.`section_id`, `ArticlesSection`.`deleted`, `ArticlesSection`.`deleted_date` FROM `vte_core`.`articles` AS `Article` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`section_id` = 13 AND `ArticlesSection`.`article_id` = `Article`.`id`) WHERE `Article`.`cancelled` = '0' ORDER BY `Article`.`main_menu_order` ASC | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date`, (`I18n__subtitle`.`content`) AS `Article__i18n_subtitle`, (`I18n__intro_text`.`content`) AS `Article__i18n_intro_text`, (`I18n__full_text`.`content`) AS `Article__i18n_full_text`, (`I18n__seo_desc`.`content`) AS `Article__i18n_seo_desc`, (`I18n__seo_title`.`content`) AS `Article__i18n_seo_title`, (`I18n__use_url`.`content`) AS `Article__i18n_use_url`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Article__i18n_slugTranslation`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date` FROM `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`subcategories` AS `Subcategory` ON (`Article`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__subtitle` ON (`Article`.`id` = `I18n__subtitle`.`foreign_key` AND `I18n__subtitle`.`model` = 'Article' AND `I18n__subtitle`.`field` = 'subtitle' AND `I18n__subtitle`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__intro_text` ON (`Article`.`id` = `I18n__intro_text`.`foreign_key` AND `I18n__intro_text`.`model` = 'Article' AND `I18n__intro_text`.`field` = 'intro_text' AND `I18n__intro_text`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__full_text` ON (`Article`.`id` = `I18n__full_text`.`foreign_key` AND `I18n__full_text`.`model` = 'Article' AND `I18n__full_text`.`field` = 'full_text' AND `I18n__full_text`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_desc` ON (`Article`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Article' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__seo_title` ON (`Article`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Article' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__use_url` ON (`Article`.`id` = `I18n__use_url`.`foreign_key` AND `I18n__use_url`.`model` = 'Article' AND `I18n__use_url`.`field` = 'use_url' AND `I18n__use_url`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'deu') LEFT JOIN `vte_core`.`article_i18ns` AS `I18n__slugTranslation` ON (`Article`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Article' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'deu') WHERE `Article`.`id` = 110 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`article_id` = (110) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (110) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`article_i18ns` AS `slugTranslation` WHERE `model` = 'Article' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (110) ORDER BY `id` ASC | 8 | 8 | 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 `vte_core`.`sections` AS `Section` JOIN `vte_core`.`articles_sections` AS `ArticlesSection` ON (`ArticlesSection`.`article_id` = 110 AND `ArticlesSection`.`section_id` = `Section`.`id`) | 1 | 1 | 0 | |
SELECT `Experience`.`id`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug` FROM `vte_core`.`experiences` AS `Experience` LEFT JOIN `vte_core`.`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` = 'spa') LEFT JOIN `vte_core`.`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` = 'spa') WHERE `Experience`.`id` = 48 AND `Experience`.`deleted` = '0' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `vte_core`.`subcategories` AS `Subcategory` JOIN `vte_core`.`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 | 3 | 3 | 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 `vte_core`.`subcategories` AS `Subcategory` inner JOIN `vte_core`.`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 `vte_core`.`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` = 'spa') LEFT JOIN `vte_core`.`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` = 'spa') 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 `vte_core`.`categories` AS `Category` inner JOIN `vte_core`.`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 `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') 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 `vte_core`.`articles` AS `Article` LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') 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 `vte_core`.`sections` AS `Section` JOIN `vte_core`.`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__use_url`.`content`) AS `Section__i18n_use_url`, (`I18n__name`.`content`) AS `Section__i18n_name`, (`I18n__slug`.`content`) AS `Section__i18n_slug` FROM `vte_core`.`sections` AS `Section` LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') 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 `vte_core`.`experiences` AS `Experience` LEFT JOIN `vte_core`.`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` = 'spa') LEFT JOIN `vte_core`.`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` = 'spa') 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 `vte_core`.`subcategories` AS `Subcategory` JOIN `vte_core`.`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 `vte_core`.`subcategories` AS `Subcategory` inner JOIN `vte_core`.`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 `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') 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 `vte_core`.`categories` AS `Category` inner JOIN `vte_core`.`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 `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') 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 `vte_core`.`experiences` AS `Experience` LEFT JOIN `vte_core`.`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` = 'spa') LEFT JOIN `vte_core`.`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` = 'spa') 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 `vte_core`.`subcategories` AS `Subcategory` JOIN `vte_core`.`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 | 2 | 2 | 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 `vte_core`.`subcategories` AS `Subcategory` inner JOIN `vte_core`.`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 `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') 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 `vte_core`.`categories` AS `Category` inner JOIN `vte_core`.`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 `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') 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 `vte_core`.`subcategories` AS `Subcategory` LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `Subcategory`.`category_id` = 16 AND `Subcategory`.`cancelled` = '0' AND `I18n__name`.`content` <> '' AND `I18n__lang_hide`.`content` <> '1' AND NOT (`Subcategory`.`id` = 72) AND `Subcategory`.`deleted` = '0' ORDER BY (case
when `Subcategory`.`id` = 73 then 'a'
when `Subcategory`.`id` = 72 then 'aa'
when `Subcategory`.`id` = 96 then 'aaa'
when `Subcategory`.`id` = 99 then 'aaaa'
when `Subcategory`.`id` = 69 then 'aaaaa'
when `Subcategory`.`id` = 103 then 'aaaaaa'
when `Subcategory`.`id` = 94 then 'aaaaaaa'
when `Subcategory`.`id` = 107 then 'aaaaaaaa'
when `Subcategory`.`id` = 95 then 'aaaaaaaaa'
when `Subcategory`.`id` = 102 then 'aaaaaaaaaa'
when `Subcategory`.`id` = 98 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 | 9 | 9 | 2 | maybe slow |
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`.`lower_price_criteria`, `Experience`.`auto_refund`, `Experience`.`deleted`, `Experience`.`deleted_date`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `vte_core`.`experiences` AS `Experience` JOIN `vte_core`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`subcategory_id` IN (73, 96, 99, 69, 94, 98, 135, 134, 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 | 84 | 84 | 1 | |
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 `vte_core`.`subcategories` AS `Subcategory` inner JOIN `vte_core`.`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 `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `category_id` = 16 AND `I18n__slug`.`content` Like 'vip' AND `Subcategory`.`deleted` = '0' LIMIT 1 | 1 | 1 | 1 | |
SELECT `FindI18n`.`locale`, `lang_hide_i18n`.`id`, `lang_hide_i18n`.`content` FROM `vte_core`.`i18n` AS `FindI18n` INNER JOIN `vte_core`.`i18n` AS `lang_hide_i18n` ON (`lang_hide_i18n`.`foreign_key` = `FindI18n`.`foreign_key`
AND `lang_hide_i18n`.`model` = `FindI18n`.`model`
AND `lang_hide_i18n`.`locale` = `FindI18n`.`locale`
AND `lang_hide_i18n`.`field` = 'lang_hide') WHERE `FindI18n`.`model` = 'Subcategory' AND `FindI18n`.`foreign_key` = 94 AND `FindI18n`.`field` = 'name' AND `FindI18n`.`content` <> '' AND ((`lang_hide_i18n`.`id` IS NULL) OR (`lang_hide_i18n`.`content` = '0')) | 8 | 8 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO` FROM `vte_core`.`languages` AS `Language` WHERE `Language`.`code3` IN ('spa', 'eng', 'deu', 'fra', 'ita', 'rus', 'pol', 'nld') AND `Language`.`disabled` = '0' AND NOT (`Language`.`code2` IS NULL) | 8 | 8 | 0 | |
SELECT `Subcategory`.`id`, (`I18n__name`.`content`) AS `Subcategory__i18n_name`, (`I18n__slug`.`content`) AS `Subcategory__i18n_slug` FROM `vte_core`.`subcategories` AS `Subcategory` LEFT JOIN `vte_core`.`categories` AS `Category` ON (`Subcategory`.`category_id` = `Category`.`id`) LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `Subcategory`.`id` = 94 AND `Subcategory`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `IslandsSubcategory`.`id`, `IslandsSubcategory`.`island_id`, `IslandsSubcategory`.`subcategory_id`, `IslandsSubcategory`.`deleted`, `IslandsSubcategory`.`deleted_date` FROM `vte_core`.`islands_subcategories` AS `IslandsSubcategory` WHERE `IslandsSubcategory`.`subcategory_id` = (94) | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`main_menu_order`, `Article`.`created`, `Article`.`cancelled`, `Article`.`modified`, `Article`.`subcategory_id`, `Article`.`deleted`, `Article`.`deleted_date` FROM `vte_core`.`articles` AS `Article` WHERE `Article`.`subcategory_id` = (94) | 1 | 1 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`i18n` AS `nameTranslation` WHERE `model` = 'Subcategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (94) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`i18n` AS `slugTranslation` WHERE `model` = 'Subcategory' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (94) ORDER BY `id` ASC | 8 | 8 | 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`.`lower_price_criteria`, `Experience`.`auto_refund`, `Experience`.`deleted`, `Experience`.`deleted_date`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `vte_core`.`experiences` AS `Experience` JOIN `vte_core`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`subcategory_id` = 94 AND `ExperiencesSubcategory`.`experience_id` = `Experience`.`id`) ORDER BY case when `ExperiencesSubcategory`.`sort_order` is null then 1000 else `ExperiencesSubcategory`.`sort_order` end ASC | 13 | 13 | 0 | |
SELECT `News`.`id`, `News`.`created`, `News`.`modified`, `News`.`video`, `News`.`disabled`, `News`.`deleted`, `News`.`deleted_date`, `NewsSubcategory`.`id`, `NewsSubcategory`.`subcategory_id`, `NewsSubcategory`.`news_id`, `NewsSubcategory`.`deleted`, `NewsSubcategory`.`deleted_date` FROM `vte_core`.`news` AS `News` JOIN `vte_core`.`news_subcategories` AS `NewsSubcategory` ON (`NewsSubcategory`.`subcategory_id` = 94 AND `NewsSubcategory`.`news_id` = `News`.`id`) | 1 | 1 | 0 | |
SELECT `Experience`.`id`, `Experience`.`canonical_experience_id`, `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug`, (`I18n__lang_hide`.`content`) AS `Experience__i18n_lang_hide` FROM `vte_core`.`experiences` AS `Experience` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Experience' AND `I18n_name_spa`.`foreign_key` = `Experience`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__lang_hide` ON (`Experience`.`id` = `I18n__lang_hide`.`foreign_key` AND `I18n__lang_hide`.`model` = 'Experience' AND `I18n__lang_hide`.`field` = 'lang_hide' AND `I18n__lang_hide`.`locale` = 'deu') WHERE `I18n__slug`.`content` Like 'ausflug_teneriffa_astronomie_exklusiv' AND `Experience`.`deleted` = '0' LIMIT 1 | 1 | 1 | 6 | maybe slow |
SELECT `FindI18n`.`locale`, `lang_hide_i18n`.`id`, `lang_hide_i18n`.`content` FROM `vte_core`.`i18n` AS `FindI18n` INNER JOIN `vte_core`.`i18n` AS `lang_hide_i18n` ON (`lang_hide_i18n`.`foreign_key` = `FindI18n`.`foreign_key`
AND `lang_hide_i18n`.`model` = `FindI18n`.`model`
AND `lang_hide_i18n`.`locale` = `FindI18n`.`locale`
AND `lang_hide_i18n`.`field` = 'lang_hide') WHERE `FindI18n`.`model` = 'Experience' AND `FindI18n`.`foreign_key` = 618 AND `FindI18n`.`field` = 'name' AND `FindI18n`.`content` <> '' AND ((`lang_hide_i18n`.`id` IS NULL) OR (`lang_hide_i18n`.`content` = '0')) | 8 | 8 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO` FROM `vte_core`.`languages` AS `Language` WHERE `Language`.`code3` IN ('spa', 'eng', 'deu', 'fra', 'rus', 'ita', 'pol', 'nld') AND `Language`.`disabled` = '0' AND NOT (`Language`.`code2` IS NULL) | 8 | 8 | 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`.`lower_price_criteria`, `Experience`.`auto_refund`, `Experience`.`deleted`, `Experience`.`deleted_date`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__short_name`.`content`) AS `Experience__i18n_short_name`, (`I18n__description`.`content`) AS `Experience__i18n_description`, (`I18n__short_description`.`content`) AS `Experience__i18n_short_description`, (`I18n__aditional_information`.`content`) AS `Experience__i18n_aditional_information`, (`I18n__address`.`content`) AS `Experience__i18n_address`, (`I18n__menu`.`content`) AS `Experience__i18n_menu`, (`I18n__accommodation_text`.`content`) AS `Experience__i18n_accommodation_text`, (`I18n__titulo_seo`.`content`) AS `Experience__i18n_titulo_seo`, (`I18n__descripcion_seo`.`content`) AS `Experience__i18n_descripcion_seo`, (`I18n__h1`.`content`) AS `Experience__i18n_h1`, (`I18n__h2`.`content`) AS `Experience__i18n_h2`, (`I18n__slug`.`content`) AS `Experience__i18n_slug`, (`I18n__survey_url`.`content`) AS `Experience__i18n_survey_url`, (`I18n__lang_hide`.`content`) AS `Experience__i18n_lang_hide`, (`I18n__promoted_volcano`.`content`) AS `Experience__i18n_promoted_volcano`, (`I18n__home_featured`.`content`) AS `Experience__i18n_home_featured`, (`I18n__buy_widget_info`.`content`) AS `Experience__i18n_buy_widget_info`, (`I18n__description_summary`.`content`) AS `Experience__i18n_description_summary`, (`I18n__video_id`.`content`) AS `Experience__i18n_video_id`, (`I18n__section_description_name`.`content`) AS `Experience__i18n_section_description_name`, (`I18n__section_description_short_name`.`content`) AS `Experience__i18n_section_description_short_name`, (`I18n__section_book_name`.`content`) AS `Experience__i18n_section_book_name`, (`I18n__section_book_short_name`.`content`) AS `Experience__i18n_section_book_short_name`, (`I18n__section_information_name`.`content`) AS `Experience__i18n_section_information_name`, (`I18n__section_information_short_name`.`content`) AS `Experience__i18n_section_information_short_name`, (`I18n__section_faqs_name`.`content`) AS `Experience__i18n_section_faqs_name`, (`I18n__section_faqs_short_name`.`content`) AS `Experience__i18n_section_faqs_short_name`, (`I18n__section_reviews_name`.`content`) AS `Experience__i18n_section_reviews_name`, (`I18n__section_reviews_short_name`.`content`) AS `Experience__i18n_section_reviews_short_name`, `Location`.`id`, `Location`.`wide_location_id`, `Location`.`municipio_id`, `Location`.`deleted`, `Location`.`deleted_date`, `Island`.`id`, `Island`.`disabled`, `Island`.`image_id`, `Island`.`c7_id`, `Island`.`deleted`, `Island`.`deleted_date`, `Activity`.`id`, `Activity`.`cancelled`, `Activity`.`deleted`, `Activity`.`deleted_date`, `Difficulty`.`id`, `Difficulty`.`available`, `Difficulty`.`deleted`, `Difficulty`.`deleted_date`, `ExperienceDescriptionTitle`.`id`, `ExperienceDescriptionTitle`.`available`, `ExperienceDescriptionTitle`.`deleted`, `ExperienceDescriptionTitle`.`deleted_date`, `Supplier`.`id`, `Supplier`.`enterprise_id`, `Supplier`.`name`, `Supplier`.`cif`, `Supplier`.`web`, `Supplier`.`email`, `Supplier`.`is_payer`, `Supplier`.`street`, `Supplier`.`location`, `Supplier`.`province`, `Supplier`.`reservations_email`, `Supplier`.`reservations_phone`, `Supplier`.`admin_email`, `Supplier`.`admin_phone`, `Supplier`.`account`, `Supplier`.`payment_period_id`, `Supplier`.`image_id`, `Supplier`.`cancel_min_anticip`, `Supplier`.`deleted`, `Supplier`.`deleted_date`, `Hotel`.`id`, `Hotel`.`web`, `Hotel`.`email`, `Hotel`.`gps_lat`, `Hotel`.`gps_long`, `Hotel`.`location_id`, `Hotel`.`deleted`, `Hotel`.`deleted_date`, `Hotel`.`uuid` FROM `vte_core`.`experiences` AS `Experience` LEFT JOIN `vte_core`.`locations` AS `Location` ON (`Experience`.`location_id` = `Location`.`id`) LEFT JOIN `vte_core`.`islands` AS `Island` ON (`Experience`.`island_id` = `Island`.`id`) LEFT JOIN `vte_core`.`activities` AS `Activity` ON (`Experience`.`activity_id` = `Activity`.`id`) LEFT JOIN `vte_core`.`difficulties` AS `Difficulty` ON (`Experience`.`difficulty_id` = `Difficulty`.`id`) LEFT JOIN `vte_core`.`experience_description_titles` AS `ExperienceDescriptionTitle` ON (`Experience`.`experience_description_title_id` = `ExperienceDescriptionTitle`.`id`) LEFT JOIN `vte_core`.`suppliers` AS `Supplier` ON (`Experience`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `vte_core`.`hotels` AS `Hotel` ON (`Experience`.`hotel_id` = `Hotel`.`id`) LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__short_name` ON (`Experience`.`id` = `I18n__short_name`.`foreign_key` AND `I18n__short_name`.`model` = 'Experience' AND `I18n__short_name`.`field` = 'short_name' AND `I18n__short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__description` ON (`Experience`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Experience' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__short_description` ON (`Experience`.`id` = `I18n__short_description`.`foreign_key` AND `I18n__short_description`.`model` = 'Experience' AND `I18n__short_description`.`field` = 'short_description' AND `I18n__short_description`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__aditional_information` ON (`Experience`.`id` = `I18n__aditional_information`.`foreign_key` AND `I18n__aditional_information`.`model` = 'Experience' AND `I18n__aditional_information`.`field` = 'aditional_information' AND `I18n__aditional_information`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__address` ON (`Experience`.`id` = `I18n__address`.`foreign_key` AND `I18n__address`.`model` = 'Experience' AND `I18n__address`.`field` = 'address' AND `I18n__address`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__menu` ON (`Experience`.`id` = `I18n__menu`.`foreign_key` AND `I18n__menu`.`model` = 'Experience' AND `I18n__menu`.`field` = 'menu' AND `I18n__menu`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__accommodation_text` ON (`Experience`.`id` = `I18n__accommodation_text`.`foreign_key` AND `I18n__accommodation_text`.`model` = 'Experience' AND `I18n__accommodation_text`.`field` = 'accommodation_text' AND `I18n__accommodation_text`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__titulo_seo` ON (`Experience`.`id` = `I18n__titulo_seo`.`foreign_key` AND `I18n__titulo_seo`.`model` = 'Experience' AND `I18n__titulo_seo`.`field` = 'titulo_seo' AND `I18n__titulo_seo`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__descripcion_seo` ON (`Experience`.`id` = `I18n__descripcion_seo`.`foreign_key` AND `I18n__descripcion_seo`.`model` = 'Experience' AND `I18n__descripcion_seo`.`field` = 'descripcion_seo' AND `I18n__descripcion_seo`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__h1` ON (`Experience`.`id` = `I18n__h1`.`foreign_key` AND `I18n__h1`.`model` = 'Experience' AND `I18n__h1`.`field` = 'h1' AND `I18n__h1`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__h2` ON (`Experience`.`id` = `I18n__h2`.`foreign_key` AND `I18n__h2`.`model` = 'Experience' AND `I18n__h2`.`field` = 'h2' AND `I18n__h2`.`locale` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__survey_url` ON (`Experience`.`id` = `I18n__survey_url`.`foreign_key` AND `I18n__survey_url`.`model` = 'Experience' AND `I18n__survey_url`.`field` = 'survey_url' AND `I18n__survey_url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__lang_hide` ON (`Experience`.`id` = `I18n__lang_hide`.`foreign_key` AND `I18n__lang_hide`.`model` = 'Experience' AND `I18n__lang_hide`.`field` = 'lang_hide' AND `I18n__lang_hide`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__promoted_volcano` ON (`Experience`.`id` = `I18n__promoted_volcano`.`foreign_key` AND `I18n__promoted_volcano`.`model` = 'Experience' AND `I18n__promoted_volcano`.`field` = 'promoted_volcano' AND `I18n__promoted_volcano`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__home_featured` ON (`Experience`.`id` = `I18n__home_featured`.`foreign_key` AND `I18n__home_featured`.`model` = 'Experience' AND `I18n__home_featured`.`field` = 'home_featured' AND `I18n__home_featured`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__buy_widget_info` ON (`Experience`.`id` = `I18n__buy_widget_info`.`foreign_key` AND `I18n__buy_widget_info`.`model` = 'Experience' AND `I18n__buy_widget_info`.`field` = 'buy_widget_info' AND `I18n__buy_widget_info`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__description_summary` ON (`Experience`.`id` = `I18n__description_summary`.`foreign_key` AND `I18n__description_summary`.`model` = 'Experience' AND `I18n__description_summary`.`field` = 'description_summary' AND `I18n__description_summary`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__video_id` ON (`Experience`.`id` = `I18n__video_id`.`foreign_key` AND `I18n__video_id`.`model` = 'Experience' AND `I18n__video_id`.`field` = 'video_id' AND `I18n__video_id`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_description_name` ON (`Experience`.`id` = `I18n__section_description_name`.`foreign_key` AND `I18n__section_description_name`.`model` = 'Experience' AND `I18n__section_description_name`.`field` = 'section_description_name' AND `I18n__section_description_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_description_short_name` ON (`Experience`.`id` = `I18n__section_description_short_name`.`foreign_key` AND `I18n__section_description_short_name`.`model` = 'Experience' AND `I18n__section_description_short_name`.`field` = 'section_description_short_name' AND `I18n__section_description_short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_book_name` ON (`Experience`.`id` = `I18n__section_book_name`.`foreign_key` AND `I18n__section_book_name`.`model` = 'Experience' AND `I18n__section_book_name`.`field` = 'section_book_name' AND `I18n__section_book_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_book_short_name` ON (`Experience`.`id` = `I18n__section_book_short_name`.`foreign_key` AND `I18n__section_book_short_name`.`model` = 'Experience' AND `I18n__section_book_short_name`.`field` = 'section_book_short_name' AND `I18n__section_book_short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_information_name` ON (`Experience`.`id` = `I18n__section_information_name`.`foreign_key` AND `I18n__section_information_name`.`model` = 'Experience' AND `I18n__section_information_name`.`field` = 'section_information_name' AND `I18n__section_information_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_information_short_name` ON (`Experience`.`id` = `I18n__section_information_short_name`.`foreign_key` AND `I18n__section_information_short_name`.`model` = 'Experience' AND `I18n__section_information_short_name`.`field` = 'section_information_short_name' AND `I18n__section_information_short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_faqs_name` ON (`Experience`.`id` = `I18n__section_faqs_name`.`foreign_key` AND `I18n__section_faqs_name`.`model` = 'Experience' AND `I18n__section_faqs_name`.`field` = 'section_faqs_name' AND `I18n__section_faqs_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_faqs_short_name` ON (`Experience`.`id` = `I18n__section_faqs_short_name`.`foreign_key` AND `I18n__section_faqs_short_name`.`model` = 'Experience' AND `I18n__section_faqs_short_name`.`field` = 'section_faqs_short_name' AND `I18n__section_faqs_short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_reviews_name` ON (`Experience`.`id` = `I18n__section_reviews_name`.`foreign_key` AND `I18n__section_reviews_name`.`model` = 'Experience' AND `I18n__section_reviews_name`.`field` = 'section_reviews_name' AND `I18n__section_reviews_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_reviews_short_name` ON (`Experience`.`id` = `I18n__section_reviews_short_name`.`foreign_key` AND `I18n__section_reviews_short_name`.`model` = 'Experience' AND `I18n__section_reviews_short_name`.`field` = 'section_reviews_short_name' AND `I18n__section_reviews_short_name`.`locale` = 'deu') WHERE `Experience`.`id` = 618 AND `I18n__name`.`content` <> '' AND `Experience`.`deleted` = '0' LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`experience_id` = (618) | 7 | 7 | 0 | |
SELECT `Product`.`id`, `Product`.`remote_product_provider_id`, `Product`.`sku`, `Product`.`overall_capacity`, `Product`.`cancelled`, `Product`.`duration`, `Product`.`duration_days`, `Product`.`min_pax`, `Product`.`max_pax`, `Product`.`transport_id`, `Product`.`neto`, `Product`.`pvp`, `Product`.`percentage`, `Product`.`comission`, `Product`.`experience_id`, `Product`.`accommodation`, `Product`.`schedules_for_week_day`, `Product`.`location_id`, `Product`.`location_pickup_id`, `Product`.`supplier_id`, `Product`.`duration_flexible`, `Product`.`stop_sales`, `Product`.`availability_time_limit`, `Product`.`requires_confirmation`, `Product`.`min_per_purchase`, `Product`.`requires_mobile`, `Product`.`route_id`, `Product`.`requires_dni`, `Product`.`in_inbox`, `Product`.`no_day_required`, `Product`.`experience_order`, `Product`.`sms_notifications`, `Product`.`reservations_email`, `Product`.`enterprise_id`, `Product`.`validation_type`, `Product`.`no_notification_to_reservations`, `Product`.`meeting_point_lat`, `Product`.`meeting_point_lon`, `Product`.`lower_price_criteria`, `Product`.`auto_refund`, `Product`.`availability_type`, `Product`.`config`, `Product`.`deleted`, `Product`.`deleted_date` FROM `vte_core`.`products` AS `Product` WHERE `Product`.`deleted` = '0' AND `Product`.`experience_id` = (618) | 2 | 2 | 0 | |
SELECT `Rate`.`id`, `Rate`.`experience_id`, `Rate`.`name`, `Rate`.`scale`, `Rate`.`comment`, `Rate`.`created`, `Rate`.`modified`, `Rate`.`ip`, `Rate`.`deleted`, `Rate`.`deleted_date` FROM `vte_core`.`rates` AS `Rate` WHERE `Rate`.`experience_id` = (618) | 0 | 0 | 0 | |
SELECT `ExperienceOperations`.`id`, `ExperienceOperations`.`type`, `ExperienceOperations`.`experience_id`, `ExperienceOperations`.`time_limit`, `ExperienceOperations`.`time_limit_hour`, `ExperienceOperations`.`cost_type`, `ExperienceOperations`.`cost`, `ExperienceOperations`.`created`, `ExperienceOperations`.`modified` FROM `vte_core`.`experience_operations` AS `ExperienceOperations` WHERE `ExperienceOperations`.`experience_id` = (618) | 2 | 2 | 0 | |
SELECT `CustomerType`.`id`, `CustomerType`.`customer_type_clasification_id`, `CustomerType`.`cancelled`, `CustomerType`.`deleted`, `CustomerType`.`deleted_date`, `CustomerTypesExperience`.`id`, `CustomerTypesExperience`.`customer_type_id`, `CustomerTypesExperience`.`experience_id`, `CustomerTypesExperience`.`deleted`, `CustomerTypesExperience`.`deleted_date` FROM `vte_core`.`customer_types` AS `CustomerType` JOIN `vte_core`.`customer_types_experiences` AS `CustomerTypesExperience` ON (`CustomerTypesExperience`.`experience_id` = 618 AND `CustomerTypesExperience`.`customer_type_id` = `CustomerType`.`id`) | 4 | 4 | 0 | |
SELECT `Comida`.`id`, `Comida`.`available`, `Comida`.`deleted`, `Comida`.`deleted_date`, `ExperiencesComida`.`id`, `ExperiencesComida`.`experience_id`, `ExperiencesComida`.`comida_id`, `ExperiencesComida`.`deleted`, `ExperiencesComida`.`deleted_date` FROM `vte_core`.`comidas` AS `Comida` JOIN `vte_core`.`experiences_comidas` AS `ExperiencesComida` ON (`ExperiencesComida`.`experience_id` = 618 AND `ExperiencesComida`.`comida_id` = `Comida`.`id`) | 0 | 0 | 0 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date`, `ExperienceHintsExperience`.`id`, `ExperienceHintsExperience`.`experience_id`, `ExperienceHintsExperience`.`experience_hint_id`, `ExperienceHintsExperience`.`deleted`, `ExperienceHintsExperience`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` JOIN `vte_core`.`experience_hints_experiences` AS `ExperienceHintsExperience` ON (`ExperienceHintsExperience`.`experience_id` = 618 AND `ExperienceHintsExperience`.`experience_hint_id` = `ExperienceHint`.`id`) | 0 | 0 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `vte_core`.`subcategories` AS `Subcategory` JOIN `vte_core`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`experience_id` = 618 AND `ExperiencesSubcategory`.`subcategory_id` = `Subcategory`.`id`) ORDER BY `ExperiencesSubcategory`.`id` ASC | 4 | 4 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO`, `Language`.`disabled`, `Language`.`deleted`, `Language`.`deleted_date`, `ExperiencesLanguage`.`experience_id`, `ExperiencesLanguage`.`language_id`, `ExperiencesLanguage`.`id`, `ExperiencesLanguage`.`deleted`, `ExperiencesLanguage`.`deleted_date` FROM `vte_core`.`languages` AS `Language` JOIN `vte_core`.`experiences_languages` AS `ExperiencesLanguage` ON (`ExperiencesLanguage`.`experience_id` = 618 AND `ExperiencesLanguage`.`language_id` = `Language`.`id`) | 5 | 5 | 0 | |
SELECT `Associate`.`id`, `Associate`.`uuid`, `Associate`.`name`, `Associate`.`deleted`, `Associate`.`deleted_date`, `AssociatesExperience`.`id`, `AssociatesExperience`.`associate_id`, `AssociatesExperience`.`experience_id`, `AssociatesExperience`.`medium`, `AssociatesExperience`.`deleted`, `AssociatesExperience`.`deleted_date` FROM `vte_core`.`associates` AS `Associate` JOIN `vte_core`.`associates_experiences` AS `AssociatesExperience` ON (`AssociatesExperience`.`experience_id` = 618 AND `AssociatesExperience`.`associate_id` = `Associate`.`id`) | 0 | 0 | 0 | |
SELECT `Tag`.`id`, `Tag`.`site_id`, `Tag`.`slug`, `Tag`.`visible`, `Tag`.`deleted`, `Tag`.`deleted_date`, `Tag`.`created`, `Tag`.`order`, `Tag`.`protected`, `Tag`.`sort_order`, `Tag`.`group_id`, `ExperiencesTag`.`id`, `ExperiencesTag`.`experience_id`, `ExperiencesTag`.`tag_id`, `ExperiencesTag`.`deleted`, `ExperiencesTag`.`deleted_date` FROM `vte_core`.`tags` AS `Tag` JOIN `vte_core`.`experiences_tags` AS `ExperiencesTag` ON (`ExperiencesTag`.`experience_id` = 618 AND `ExperiencesTag`.`tag_id` = `Tag`.`id`) | 3 | 3 | 0 | |
SELECT `SharedProducts`.`id`, `SharedProducts`.`remote_product_provider_id`, `SharedProducts`.`sku`, `SharedProducts`.`overall_capacity`, `SharedProducts`.`cancelled`, `SharedProducts`.`duration`, `SharedProducts`.`duration_days`, `SharedProducts`.`min_pax`, `SharedProducts`.`max_pax`, `SharedProducts`.`transport_id`, `SharedProducts`.`neto`, `SharedProducts`.`pvp`, `SharedProducts`.`percentage`, `SharedProducts`.`comission`, `SharedProducts`.`experience_id`, `SharedProducts`.`accommodation`, `SharedProducts`.`schedules_for_week_day`, `SharedProducts`.`location_id`, `SharedProducts`.`location_pickup_id`, `SharedProducts`.`supplier_id`, `SharedProducts`.`duration_flexible`, `SharedProducts`.`stop_sales`, `SharedProducts`.`availability_time_limit`, `SharedProducts`.`requires_confirmation`, `SharedProducts`.`min_per_purchase`, `SharedProducts`.`requires_mobile`, `SharedProducts`.`route_id`, `SharedProducts`.`requires_dni`, `SharedProducts`.`in_inbox`, `SharedProducts`.`no_day_required`, `SharedProducts`.`experience_order`, `SharedProducts`.`sms_notifications`, `SharedProducts`.`reservations_email`, `SharedProducts`.`enterprise_id`, `SharedProducts`.`validation_type`, `SharedProducts`.`no_notification_to_reservations`, `SharedProducts`.`meeting_point_lat`, `SharedProducts`.`meeting_point_lon`, `SharedProducts`.`lower_price_criteria`, `SharedProducts`.`auto_refund`, `SharedProducts`.`availability_type`, `SharedProducts`.`config`, `SharedProducts`.`deleted`, `SharedProducts`.`deleted_date`, `ExperiencesProduct`.`id`, `ExperiencesProduct`.`experience_id`, `ExperiencesProduct`.`product_id`, `ExperiencesProduct`.`order`, `ExperiencesProduct`.`created`, `ExperiencesProduct`.`modified`, `ExperiencesProduct`.`modified_user_id`, `ExperiencesProduct`.`deleted`, `ExperiencesProduct`.`deleted_date` FROM `vte_core`.`products` AS `SharedProducts` JOIN `vte_core`.`experiences_products` AS `ExperiencesProduct` ON (`ExperiencesProduct`.`experience_id` = 618 AND `ExperiencesProduct`.`product_id` = `SharedProducts`.`id`) | 0 | 0 | 0 | |
SELECT `Experience`.`id`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug` FROM `vte_core`.`experiences` AS `Experience` LEFT JOIN `vte_core`.`locations` AS `Location` ON (`Experience`.`location_id` = `Location`.`id`) LEFT JOIN `vte_core`.`islands` AS `Island` ON (`Experience`.`island_id` = `Island`.`id`) LEFT JOIN `vte_core`.`activities` AS `Activity` ON (`Experience`.`activity_id` = `Activity`.`id`) LEFT JOIN `vte_core`.`difficulties` AS `Difficulty` ON (`Experience`.`difficulty_id` = `Difficulty`.`id`) LEFT JOIN `vte_core`.`experience_description_titles` AS `ExperienceDescriptionTitle` ON (`Experience`.`experience_description_title_id` = `ExperienceDescriptionTitle`.`id`) LEFT JOIN `vte_core`.`suppliers` AS `Supplier` ON (`Experience`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `vte_core`.`hotels` AS `Hotel` ON (`Experience`.`hotel_id` = `Hotel`.`id`) LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `Experience`.`id` = 618 AND `Experience`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`experience_id` = (618) | 7 | 7 | 0 | |
SELECT `Product`.`id`, `Product`.`remote_product_provider_id`, `Product`.`sku`, `Product`.`overall_capacity`, `Product`.`cancelled`, `Product`.`duration`, `Product`.`duration_days`, `Product`.`min_pax`, `Product`.`max_pax`, `Product`.`transport_id`, `Product`.`neto`, `Product`.`pvp`, `Product`.`percentage`, `Product`.`comission`, `Product`.`experience_id`, `Product`.`accommodation`, `Product`.`schedules_for_week_day`, `Product`.`location_id`, `Product`.`location_pickup_id`, `Product`.`supplier_id`, `Product`.`duration_flexible`, `Product`.`stop_sales`, `Product`.`availability_time_limit`, `Product`.`requires_confirmation`, `Product`.`min_per_purchase`, `Product`.`requires_mobile`, `Product`.`route_id`, `Product`.`requires_dni`, `Product`.`in_inbox`, `Product`.`no_day_required`, `Product`.`experience_order`, `Product`.`sms_notifications`, `Product`.`reservations_email`, `Product`.`enterprise_id`, `Product`.`validation_type`, `Product`.`no_notification_to_reservations`, `Product`.`meeting_point_lat`, `Product`.`meeting_point_lon`, `Product`.`lower_price_criteria`, `Product`.`auto_refund`, `Product`.`availability_type`, `Product`.`config`, `Product`.`deleted`, `Product`.`deleted_date` FROM `vte_core`.`products` AS `Product` WHERE `Product`.`deleted` = '0' AND `Product`.`experience_id` = (618) | 2 | 2 | 0 | |
SELECT `Rate`.`id`, `Rate`.`experience_id`, `Rate`.`name`, `Rate`.`scale`, `Rate`.`comment`, `Rate`.`created`, `Rate`.`modified`, `Rate`.`ip`, `Rate`.`deleted`, `Rate`.`deleted_date` FROM `vte_core`.`rates` AS `Rate` WHERE `Rate`.`experience_id` = (618) | 0 | 0 | 0 | |
SELECT `ExperienceOperations`.`id`, `ExperienceOperations`.`type`, `ExperienceOperations`.`experience_id`, `ExperienceOperations`.`time_limit`, `ExperienceOperations`.`time_limit_hour`, `ExperienceOperations`.`cost_type`, `ExperienceOperations`.`cost`, `ExperienceOperations`.`created`, `ExperienceOperations`.`modified` FROM `vte_core`.`experience_operations` AS `ExperienceOperations` WHERE `ExperienceOperations`.`experience_id` = (618) | 2 | 2 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content`, `nameTranslation`.`created`, `nameTranslation`.`modified`, `nameTranslation`.`deleted`, `nameTranslation`.`deleted_date` FROM `vte_core`.`i18n` AS `nameTranslation` WHERE `model` = 'Experience' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (618) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content`, `slugTranslation`.`created`, `slugTranslation`.`modified`, `slugTranslation`.`deleted`, `slugTranslation`.`deleted_date` FROM `vte_core`.`i18n` AS `slugTranslation` WHERE `model` = 'Experience' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (618) ORDER BY `id` ASC | 8 | 8 | 0 | |
SELECT `CustomerType`.`id`, `CustomerType`.`customer_type_clasification_id`, `CustomerType`.`cancelled`, `CustomerType`.`deleted`, `CustomerType`.`deleted_date`, `CustomerTypesExperience`.`id`, `CustomerTypesExperience`.`customer_type_id`, `CustomerTypesExperience`.`experience_id`, `CustomerTypesExperience`.`deleted`, `CustomerTypesExperience`.`deleted_date` FROM `vte_core`.`customer_types` AS `CustomerType` JOIN `vte_core`.`customer_types_experiences` AS `CustomerTypesExperience` ON (`CustomerTypesExperience`.`experience_id` = 618 AND `CustomerTypesExperience`.`customer_type_id` = `CustomerType`.`id`) | 4 | 4 | 0 | |
SELECT `Comida`.`id`, `Comida`.`available`, `Comida`.`deleted`, `Comida`.`deleted_date`, `ExperiencesComida`.`id`, `ExperiencesComida`.`experience_id`, `ExperiencesComida`.`comida_id`, `ExperiencesComida`.`deleted`, `ExperiencesComida`.`deleted_date` FROM `vte_core`.`comidas` AS `Comida` JOIN `vte_core`.`experiences_comidas` AS `ExperiencesComida` ON (`ExperiencesComida`.`experience_id` = 618 AND `ExperiencesComida`.`comida_id` = `Comida`.`id`) | 0 | 0 | 0 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date`, `ExperienceHintsExperience`.`id`, `ExperienceHintsExperience`.`experience_id`, `ExperienceHintsExperience`.`experience_hint_id`, `ExperienceHintsExperience`.`deleted`, `ExperienceHintsExperience`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` JOIN `vte_core`.`experience_hints_experiences` AS `ExperienceHintsExperience` ON (`ExperienceHintsExperience`.`experience_id` = 618 AND `ExperienceHintsExperience`.`experience_hint_id` = `ExperienceHint`.`id`) | 0 | 0 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`cancelled`, `Subcategory`.`sort_order`, `Subcategory`.`icon`, `Subcategory`.`video`, `Subcategory`.`background_image`, `Subcategory`.`deleted`, `Subcategory`.`deleted_date`, `ExperiencesSubcategory`.`id`, `ExperiencesSubcategory`.`experience_id`, `ExperiencesSubcategory`.`subcategory_id`, `ExperiencesSubcategory`.`sort_order`, `ExperiencesSubcategory`.`deleted`, `ExperiencesSubcategory`.`deleted_date` FROM `vte_core`.`subcategories` AS `Subcategory` JOIN `vte_core`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`experience_id` = 618 AND `ExperiencesSubcategory`.`subcategory_id` = `Subcategory`.`id`) ORDER BY `ExperiencesSubcategory`.`id` ASC | 4 | 4 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO`, `Language`.`disabled`, `Language`.`deleted`, `Language`.`deleted_date`, `ExperiencesLanguage`.`experience_id`, `ExperiencesLanguage`.`language_id`, `ExperiencesLanguage`.`id`, `ExperiencesLanguage`.`deleted`, `ExperiencesLanguage`.`deleted_date` FROM `vte_core`.`languages` AS `Language` JOIN `vte_core`.`experiences_languages` AS `ExperiencesLanguage` ON (`ExperiencesLanguage`.`experience_id` = 618 AND `ExperiencesLanguage`.`language_id` = `Language`.`id`) | 5 | 5 | 0 | |
SELECT `Associate`.`id`, `Associate`.`uuid`, `Associate`.`name`, `Associate`.`deleted`, `Associate`.`deleted_date`, `AssociatesExperience`.`id`, `AssociatesExperience`.`associate_id`, `AssociatesExperience`.`experience_id`, `AssociatesExperience`.`medium`, `AssociatesExperience`.`deleted`, `AssociatesExperience`.`deleted_date` FROM `vte_core`.`associates` AS `Associate` JOIN `vte_core`.`associates_experiences` AS `AssociatesExperience` ON (`AssociatesExperience`.`experience_id` = 618 AND `AssociatesExperience`.`associate_id` = `Associate`.`id`) | 0 | 0 | 0 | |
SELECT `Tag`.`id`, `Tag`.`site_id`, `Tag`.`slug`, `Tag`.`visible`, `Tag`.`deleted`, `Tag`.`deleted_date`, `Tag`.`created`, `Tag`.`order`, `Tag`.`protected`, `Tag`.`sort_order`, `Tag`.`group_id`, `ExperiencesTag`.`id`, `ExperiencesTag`.`experience_id`, `ExperiencesTag`.`tag_id`, `ExperiencesTag`.`deleted`, `ExperiencesTag`.`deleted_date` FROM `vte_core`.`tags` AS `Tag` JOIN `vte_core`.`experiences_tags` AS `ExperiencesTag` ON (`ExperiencesTag`.`experience_id` = 618 AND `ExperiencesTag`.`tag_id` = `Tag`.`id`) | 3 | 3 | 0 | |
SELECT `SharedProducts`.`id`, `SharedProducts`.`remote_product_provider_id`, `SharedProducts`.`sku`, `SharedProducts`.`overall_capacity`, `SharedProducts`.`cancelled`, `SharedProducts`.`duration`, `SharedProducts`.`duration_days`, `SharedProducts`.`min_pax`, `SharedProducts`.`max_pax`, `SharedProducts`.`transport_id`, `SharedProducts`.`neto`, `SharedProducts`.`pvp`, `SharedProducts`.`percentage`, `SharedProducts`.`comission`, `SharedProducts`.`experience_id`, `SharedProducts`.`accommodation`, `SharedProducts`.`schedules_for_week_day`, `SharedProducts`.`location_id`, `SharedProducts`.`location_pickup_id`, `SharedProducts`.`supplier_id`, `SharedProducts`.`duration_flexible`, `SharedProducts`.`stop_sales`, `SharedProducts`.`availability_time_limit`, `SharedProducts`.`requires_confirmation`, `SharedProducts`.`min_per_purchase`, `SharedProducts`.`requires_mobile`, `SharedProducts`.`route_id`, `SharedProducts`.`requires_dni`, `SharedProducts`.`in_inbox`, `SharedProducts`.`no_day_required`, `SharedProducts`.`experience_order`, `SharedProducts`.`sms_notifications`, `SharedProducts`.`reservations_email`, `SharedProducts`.`enterprise_id`, `SharedProducts`.`validation_type`, `SharedProducts`.`no_notification_to_reservations`, `SharedProducts`.`meeting_point_lat`, `SharedProducts`.`meeting_point_lon`, `SharedProducts`.`lower_price_criteria`, `SharedProducts`.`auto_refund`, `SharedProducts`.`availability_type`, `SharedProducts`.`config`, `SharedProducts`.`deleted`, `SharedProducts`.`deleted_date`, `ExperiencesProduct`.`id`, `ExperiencesProduct`.`experience_id`, `ExperiencesProduct`.`product_id`, `ExperiencesProduct`.`order`, `ExperiencesProduct`.`created`, `ExperiencesProduct`.`modified`, `ExperiencesProduct`.`modified_user_id`, `ExperiencesProduct`.`deleted`, `ExperiencesProduct`.`deleted_date` FROM `vte_core`.`products` AS `SharedProducts` JOIN `vte_core`.`experiences_products` AS `ExperiencesProduct` ON (`ExperiencesProduct`.`experience_id` = 618 AND `ExperiencesProduct`.`product_id` = `SharedProducts`.`id`) | 0 | 0 | 0 | |
SELECT `Experience`.`id`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug` FROM `vte_core`.`experiences` AS `Experience` LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `Experience`.`id` = 603 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 `vte_core`.`subcategories` AS `Subcategory` JOIN `vte_core`.`experiences_subcategories` AS `ExperiencesSubcategory` ON (`ExperiencesSubcategory`.`experience_id` = 603 AND `ExperiencesSubcategory`.`subcategory_id` = `Subcategory`.`id`) WHERE `category_id` IN (16, 19) ORDER BY `ExperiencesSubcategory`.`id` ASC | 5 | 5 | 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 `vte_core`.`subcategories` AS `Subcategory` inner JOIN `vte_core`.`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 `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `Subcategory`.`id` = 96 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 `vte_core`.`categories` AS `Category` inner JOIN `vte_core`.`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 `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `Category`.`id` = 16 AND `Category`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.*, `I18n_name_spa`.`content`, `Product`.`id`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__description`.`content`) AS `Product__i18n_description`, (`I18n__menu`.`content`) AS `Product__i18n_menu`, (`I18n__aditional_information`.`content`) AS `Product__i18n_aditional_information`, (`I18n__restrictions_info`.`content`) AS `Product__i18n_restrictions_info`, (`I18n__pickup_schedule`.`content`) AS `Product__i18n_pickup_schedule`, (`I18n__meeting_point_name`.`content`) AS `Product__i18n_meeting_point_name`, (`I18n__booking_confirmation`.`content`) AS `Product__i18n_booking_confirmation`, (`I18n__booking_process_information`.`content`) AS `Product__i18n_booking_process_information`, (`I18n__confirmation_email_info`.`content`) AS `Product__i18n_confirmation_email_info`, (`I18n__buy_widget_info`.`content`) AS `Product__i18n_buy_widget_info` FROM `vte_core`.`products` AS `Product` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Product' AND `I18n_name_spa`.`foreign_key` = `Product`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Product`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Product' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__description` ON (`Product`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Product' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__menu` ON (`Product`.`id` = `I18n__menu`.`foreign_key` AND `I18n__menu`.`model` = 'Product' AND `I18n__menu`.`field` = 'menu' AND `I18n__menu`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__aditional_information` ON (`Product`.`id` = `I18n__aditional_information`.`foreign_key` AND `I18n__aditional_information`.`model` = 'Product' AND `I18n__aditional_information`.`field` = 'aditional_information' AND `I18n__aditional_information`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__restrictions_info` ON (`Product`.`id` = `I18n__restrictions_info`.`foreign_key` AND `I18n__restrictions_info`.`model` = 'Product' AND `I18n__restrictions_info`.`field` = 'restrictions_info' AND `I18n__restrictions_info`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__pickup_schedule` ON (`Product`.`id` = `I18n__pickup_schedule`.`foreign_key` AND `I18n__pickup_schedule`.`model` = 'Product' AND `I18n__pickup_schedule`.`field` = 'pickup_schedule' AND `I18n__pickup_schedule`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__meeting_point_name` ON (`Product`.`id` = `I18n__meeting_point_name`.`foreign_key` AND `I18n__meeting_point_name`.`model` = 'Product' AND `I18n__meeting_point_name`.`field` = 'meeting_point_name' AND `I18n__meeting_point_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__booking_confirmation` ON (`Product`.`id` = `I18n__booking_confirmation`.`foreign_key` AND `I18n__booking_confirmation`.`model` = 'Product' AND `I18n__booking_confirmation`.`field` = 'booking_confirmation' AND `I18n__booking_confirmation`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__booking_process_information` ON (`Product`.`id` = `I18n__booking_process_information`.`foreign_key` AND `I18n__booking_process_information`.`model` = 'Product' AND `I18n__booking_process_information`.`field` = 'booking_process_information' AND `I18n__booking_process_information`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__confirmation_email_info` ON (`Product`.`id` = `I18n__confirmation_email_info`.`foreign_key` AND `I18n__confirmation_email_info`.`model` = 'Product' AND `I18n__confirmation_email_info`.`field` = 'confirmation_email_info' AND `I18n__confirmation_email_info`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__buy_widget_info` ON (`Product`.`id` = `I18n__buy_widget_info`.`foreign_key` AND `I18n__buy_widget_info`.`model` = 'Product' AND `I18n__buy_widget_info`.`field` = 'buy_widget_info' AND `I18n__buy_widget_info`.`locale` = 'deu') WHERE `experience_id` = 618 AND `Product`.`cancelled` = '0' AND `Product`.`deleted` = '0' ORDER BY CASE
WHEN `I18n__name`.`content` like '%sur%' OR `I18n__name`.`content` like '%south%' THEN 9
WHEN `I18n__name`.`content` like '%norte%' OR `I18n__name`.`content` like '%north%' THEN 8
ELSE 0
END ASC, `experience_order` ASC | 1 | 1 | 1 | |
SELECT `ProductRate`.`id`, `ProductRate`.`product_id`, `ProductRate`.`products_time_id`, `ProductRate`.`product_option_id`, `ProductRate`.`highlighted`, `ProductRate`.`product_option_rate_id`, `ProductRate`.`days_products_hash`, `ProductRate`.`prDyTmBtnRateId`, `ProductRate`.`neto`, `ProductRate`.`pvp`, `ProductRate`.`percentage`, `ProductRate`.`comission`, `ProductRate`.`offer_pvp`, `ProductRate`.`offer_expire`, `ProductRate`.`products_supplier_id`, `ProductRate`.`requieres_identification`, `ProductRate`.`min_pax`, `ProductRate`.`max_pax`, `ProductRate`.`customer_type_ids`, `ProductRate`.`iacpos_id`, `ProductRate`.`iacpos_name`, `ProductRate`.`deleted`, `ProductRate`.`deleted_date`, `ProductRate`.`old_product_id`, `ProductRate`.`modified_user_id` FROM `vte_core`.`product_rates` AS `ProductRate` WHERE `ProductRate`.`deleted` = '0' AND `ProductRate`.`product_id` = (1544) ORDER BY `pvp` asc | 2 | 2 | 1 | maybe slow |
SELECT `CustomerType`.`id`, `CustomerType`.`customer_type_clasification_id`, `CustomerType`.`cancelled`, `CustomerType`.`deleted`, `CustomerType`.`deleted_date`, `CustomerTypesProductRate`.`id`, `CustomerTypesProductRate`.`product_rate_id`, `CustomerTypesProductRate`.`customer_type_id`, `CustomerTypesProductRate`.`deleted`, `CustomerTypesProductRate`.`deleted_date` FROM `vte_core`.`customer_types` AS `CustomerType` JOIN `vte_core`.`customer_types_product_rates` AS `CustomerTypesProductRate` ON (`CustomerTypesProductRate`.`product_rate_id` IN (20183, 20182) AND `CustomerTypesProductRate`.`customer_type_id` = `CustomerType`.`id`) | 4 | 4 | 0 | |
SELECT `WeekDaysProduct`.`id`, `WeekDaysProduct`.`product_id`, `WeekDaysProduct`.`week_day_id`, `WeekDaysProduct`.`specific_capacity`, `WeekDaysProduct`.`cancelled`, `WeekDaysProduct`.`deleted`, `WeekDaysProduct`.`deleted_date` FROM `vte_core`.`week_days_products` AS `WeekDaysProduct` WHERE `WeekDaysProduct`.`product_id` = (1544) | 0 | 0 | 0 | |
SELECT `ProductsTime`.`id`, `ProductsTime`.`product_id`, `ProductsTime`.`time_id`, `ProductsTime`.`cancelled`, `ProductsTime`.`range_ends_at_time_id`, `ProductsTime`.`max_pax`, `ProductsTime`.`deleted`, `ProductsTime`.`deleted_date` FROM `vte_core`.`products_times` AS `ProductsTime` WHERE `ProductsTime`.`product_id` = (1544) | 0 | 0 | 0 | |
SELECT `PickupPointsProduct`.`id`, `PickupPointsProduct`.`product_id`, `PickupPointsProduct`.`pickup_point_id`, `PickupPointsProduct`.`time`, `PickupPointsProduct`.`has_many_times`, `PickupPointsProduct`.`products_supplier_id`, `PickupPointsProduct`.`created`, `PickupPointsProduct`.`modified`, `PickupPointsProduct`.`deleted`, `PickupPointsProduct`.`deleted_date` FROM `vte_core`.`pickup_points_products` AS `PickupPointsProduct` WHERE `PickupPointsProduct`.`product_id` = (1544) | 0 | 0 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO`, `Language`.`disabled`, `Language`.`deleted`, `Language`.`deleted_date`, `LanguagesProduct`.`id`, `LanguagesProduct`.`language_id`, `LanguagesProduct`.`product_id`, `LanguagesProduct`.`deleted`, `LanguagesProduct`.`deleted_date` FROM `vte_core`.`languages` AS `Language` JOIN `vte_core`.`languages_products` AS `LanguagesProduct` ON (`LanguagesProduct`.`product_id` = 1544 AND `LanguagesProduct`.`language_id` = `Language`.`id`) | 5 | 5 | 0 | |
SELECT `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `CustomerType__i18n_name` FROM `vte_core`.`customer_types` AS `CustomerType` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'CustomerType' AND `I18n_name_spa`.`foreign_key` = `CustomerType`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`CustomerType`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'CustomerType' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `CustomerType`.`id` = 135 LIMIT 1 | 1 | 1 | 0 | |
SELECT `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `CustomerType__i18n_name` FROM `vte_core`.`customer_types` AS `CustomerType` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'CustomerType' AND `I18n_name_spa`.`foreign_key` = `CustomerType`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`CustomerType`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'CustomerType' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `CustomerType`.`id` = 19 LIMIT 1 | 1 | 1 | 0 | |
SELECT `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `CustomerType__i18n_name` FROM `vte_core`.`customer_types` AS `CustomerType` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'CustomerType' AND `I18n_name_spa`.`foreign_key` = `CustomerType`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`CustomerType`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'CustomerType' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `CustomerType`.`id` = 134 LIMIT 1 | 1 | 1 | 0 | |
SELECT `I18n_name_spa`.`content`, (`I18n__name`.`content`) AS `CustomerType__i18n_name` FROM `vte_core`.`customer_types` AS `CustomerType` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'CustomerType' AND `I18n_name_spa`.`foreign_key` = `CustomerType`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`CustomerType`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'CustomerType' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `CustomerType`.`id` = 19 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Transport`.`id`, `Transport`.`cancelled`, `Transport`.`image_id`, `Transport`.`deleted`, `Transport`.`deleted_date`, (`I18n__name`.`content`) AS `Transport__i18n_name`, `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date` FROM `vte_core`.`transports` AS `Transport` LEFT JOIN `vte_core`.`images` AS `Image` ON (`Transport`.`image_id` = `Image`.`id`) LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Transport`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Transport' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `Transport`.`id` = 9 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductRate`.`id`, `ProductRate`.`product_id`, `ProductRate`.`products_time_id`, `ProductRate`.`product_option_id`, `ProductRate`.`highlighted`, `ProductRate`.`product_option_rate_id`, `ProductRate`.`days_products_hash`, `ProductRate`.`prDyTmBtnRateId`, `ProductRate`.`neto`, `ProductRate`.`pvp`, `ProductRate`.`percentage`, `ProductRate`.`comission`, `ProductRate`.`offer_pvp`, `ProductRate`.`offer_expire`, `ProductRate`.`products_supplier_id`, `ProductRate`.`requieres_identification`, `ProductRate`.`min_pax`, `ProductRate`.`max_pax`, `ProductRate`.`customer_type_ids`, `ProductRate`.`iacpos_id`, `ProductRate`.`iacpos_name`, `ProductRate`.`deleted`, `ProductRate`.`deleted_date`, `ProductRate`.`old_product_id`, `ProductRate`.`modified_user_id`, `Product`.`id`, `Product`.`remote_product_provider_id`, `Product`.`sku`, `Product`.`overall_capacity`, `Product`.`cancelled`, `Product`.`duration`, `Product`.`duration_days`, `Product`.`min_pax`, `Product`.`max_pax`, `Product`.`transport_id`, `Product`.`neto`, `Product`.`pvp`, `Product`.`percentage`, `Product`.`comission`, `Product`.`experience_id`, `Product`.`accommodation`, `Product`.`schedules_for_week_day`, `Product`.`location_id`, `Product`.`location_pickup_id`, `Product`.`supplier_id`, `Product`.`duration_flexible`, `Product`.`stop_sales`, `Product`.`availability_time_limit`, `Product`.`requires_confirmation`, `Product`.`min_per_purchase`, `Product`.`requires_mobile`, `Product`.`route_id`, `Product`.`requires_dni`, `Product`.`in_inbox`, `Product`.`no_day_required`, `Product`.`experience_order`, `Product`.`sms_notifications`, `Product`.`reservations_email`, `Product`.`enterprise_id`, `Product`.`validation_type`, `Product`.`no_notification_to_reservations`, `Product`.`meeting_point_lat`, `Product`.`meeting_point_lon`, `Product`.`lower_price_criteria`, `Product`.`auto_refund`, `Product`.`availability_type`, `Product`.`config`, `Product`.`deleted`, `Product`.`deleted_date`, `ProductsTime`.`id`, `ProductsTime`.`product_id`, `ProductsTime`.`time_id`, `ProductsTime`.`cancelled`, `ProductsTime`.`range_ends_at_time_id`, `ProductsTime`.`max_pax`, `ProductsTime`.`deleted`, `ProductsTime`.`deleted_date`, `ProductsSupplier`.`id`, `ProductsSupplier`.`product_id`, `ProductsSupplier`.`supplier_id`, `ProductsSupplier`.`week_day_id`, `ProductsSupplier`.`time_id`, `ProductsSupplier`.`route_id`, `ProductsSupplier`.`deleted`, `ProductsSupplier`.`deleted_date` FROM `vte_core`.`product_rates` AS `ProductRate` LEFT JOIN `vte_core`.`products` AS `Product` ON (`ProductRate`.`product_id` = `Product`.`id`) LEFT JOIN `vte_core`.`products_times` AS `ProductsTime` ON (`ProductRate`.`products_time_id` = `ProductsTime`.`id`) LEFT JOIN `vte_core`.`products_suppliers` AS `ProductsSupplier` ON (`ProductRate`.`products_supplier_id` = `ProductsSupplier`.`id`) WHERE `ProductRate`.`product_id` = 1544 AND `ProductRate`.`deleted` = '0' | 2 | 2 | 3 | maybe slow |
SELECT `PickuplocationsProductRate`.`id`, `PickuplocationsProductRate`.`location_id`, `PickuplocationsProductRate`.`product_rate_id`, `PickuplocationsProductRate`.`pvp`, `PickuplocationsProductRate`.`neto`, `PickuplocationsProductRate`.`deleted`, `PickuplocationsProductRate`.`deleted_date` FROM `vte_core`.`pickuplocations_product_rates` AS `PickuplocationsProductRate` WHERE `PickuplocationsProductRate`.`product_rate_id` IN (20182, 20183) | 0 | 0 | 0 | |
SELECT `DaysProductsProductRate`.`id`, `DaysProductsProductRate`.`days_product_id`, `DaysProductsProductRate`.`product_rate_id`, `DaysProductsProductRate`.`deleted`, `DaysProductsProductRate`.`deleted_date` FROM `vte_core`.`days_products_product_rates` AS `DaysProductsProductRate` WHERE `DaysProductsProductRate`.`product_rate_id` IN (20182, 20183) | 0 | 0 | 0 | |
SELECT `DaysProductsTimesProductRate`.`id`, `DaysProductsTimesProductRate`.`days_products_time_id`, `DaysProductsTimesProductRate`.`product_rate_id`, `DaysProductsTimesProductRate`.`deleted`, `DaysProductsTimesProductRate`.`deleted_date` FROM `vte_core`.`days_products_times_product_rates` AS `DaysProductsTimesProductRate` WHERE `DaysProductsTimesProductRate`.`product_rate_id` IN (20182, 20183) | 0 | 0 | 0 | |
SELECT `CompoundProductRate`.`id`, `CompoundProductRate`.`compound_products_base_product_id`, `CompoundProductRate`.`compound_product_rate_id`, `CompoundProductRate`.`base_product_rate_id`, `CompoundProductRate`.`commission_percentage` FROM `vte_core`.`compound_product_rates` AS `CompoundProductRate` WHERE `CompoundProductRate`.`compound_product_rate_id` IN (20182, 20183) | 2 | 2 | 0 | |
SELECT `CustomerType`.`id`, `CustomerType`.`customer_type_clasification_id`, `CustomerType`.`cancelled`, `CustomerType`.`deleted`, `CustomerType`.`deleted_date`, `CustomerTypesProductRate`.`id`, `CustomerTypesProductRate`.`product_rate_id`, `CustomerTypesProductRate`.`customer_type_id`, `CustomerTypesProductRate`.`deleted`, `CustomerTypesProductRate`.`deleted_date` FROM `vte_core`.`customer_types` AS `CustomerType` JOIN `vte_core`.`customer_types_product_rates` AS `CustomerTypesProductRate` ON (`CustomerTypesProductRate`.`product_rate_id` IN (20182, 20183) AND `CustomerTypesProductRate`.`customer_type_id` = `CustomerType`.`id`) | 4 | 4 | 0 | |
SELECT `PickuplocationsProductRate`.`id`, `PickuplocationsProductRate`.`location_id`, `PickuplocationsProductRate`.`product_rate_id`, `PickuplocationsProductRate`.`pvp`, `PickuplocationsProductRate`.`neto`, `Location`.*, `I18n`.`content` AS `LocationName` FROM `vte_core`.`pickuplocations_product_rates` AS `PickuplocationsProductRate` inner JOIN `vte_core`.`locations` AS `Location` ON (`Location`.`id` = `PickuplocationsProductRate`.`location_id`) inner JOIN `vte_core`.`i18n` AS `I18n` ON (`I18n`.`foreign_key` = `PickuplocationsProductRate`.`location_id` AND `I18n`.`model` = 'Location' AND `I18n`.`field` = 'name' AND `I18n`.`locale` = 'deu') WHERE `product_rate_id` IN (20182, 20183) | 0 | 0 | 2 | maybe slow |
SELECT `Location`.`id`, `Location`.`wide_location_id`, `Location`.`municipio_id`, `Location`.`deleted`, `Location`.`deleted_date`, (`I18n__name`.`content`) AS `Location__i18n_name` FROM `vte_core`.`locations` AS `Location` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Location`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Location' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `Location`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 3743 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (3743) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (3743) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (3743) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (3743) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (3743) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 3743 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (3743) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (3743) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (3743) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (3743) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (3743) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 3746 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (3746) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (3746) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (3746) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (3746) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (3746) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 3746 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (3746) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (3746) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (3746) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (3746) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (3746) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 3747 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (3747) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (3747) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (3747) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (3747) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (3747) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 3747 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (3747) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (3747) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (3747) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (3747) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (3747) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 3749 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (3749) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (3749) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (3749) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (3749) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (3749) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 3749 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (3749) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (3749) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (3749) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (3749) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (3749) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 3788 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (3788) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (3788) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (3788) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (3788) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (3788) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 3788 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (3788) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (3788) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (3788) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (3788) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (3788) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 4348 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (4348) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (4348) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (4348) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (4348) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (4348) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 4348 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (4348) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (4348) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (4348) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (4348) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (4348) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 4349 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (4349) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (4349) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (4349) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (4349) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (4349) | 0 | 0 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 4349 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ExperienceHint`.`id`, `ExperienceHint`.`image_id`, `ExperienceHint`.`deleted`, `ExperienceHint`.`deleted_date` FROM `vte_core`.`experience_hints` AS `ExperienceHint` WHERE `ExperienceHint`.`image_id` = (4349) | 0 | 0 | 0 | |
SELECT `ExperiencesImage`.`id`, `ExperiencesImage`.`experience_id`, `ExperiencesImage`.`image_id`, `ExperiencesImage`.`order`, `ExperiencesImage`.`is_main`, `ExperiencesImage`.`is_portrait`, `ExperiencesImage`.`deleted`, `ExperiencesImage`.`deleted_date` FROM `vte_core`.`experiences_images` AS `ExperiencesImage` WHERE `ExperiencesImage`.`image_id` = (4349) | 1 | 1 | 0 | |
SELECT `ImagesHotel`.`id`, `ImagesHotel`.`image_id`, `ImagesHotel`.`hotel_id`, `ImagesHotel`.`is_main`, `ImagesHotel`.`order`, `ImagesHotel`.`deleted`, `ImagesHotel`.`deleted_date` FROM `vte_core`.`images_hotels` AS `ImagesHotel` WHERE `ImagesHotel`.`image_id` = (4349) | 0 | 0 | 0 | |
SELECT `ArticlesImage`.`id`, `ArticlesImage`.`article_id`, `ArticlesImage`.`image_id`, `ArticlesImage`.`order`, `ArticlesImage`.`deleted`, `ArticlesImage`.`deleted_date` FROM `vte_core`.`articles_images` AS `ArticlesImage` WHERE `ArticlesImage`.`image_id` = (4349) | 0 | 0 | 0 | |
SELECT `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id`, `ProductsImage`.`is_main`, `ProductsImage`.`order`, `ProductsImage`.`deleted`, `ProductsImage`.`deleted_date` FROM `vte_core`.`products_images` AS `ProductsImage` WHERE `ProductsImage`.`image_id` = (4349) | 0 | 0 | 0 | |
SELECT `ExperienceDescriptionTitle`.`id`, `ExperienceDescriptionTitle`.`available`, `ExperienceDescriptionTitle`.`deleted`, `ExperienceDescriptionTitle`.`deleted_date`, (`I18n__name`.`content`) AS `ExperienceDescriptionTitle__i18n_name` FROM `vte_core`.`experience_description_titles` AS `ExperienceDescriptionTitle` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`ExperienceDescriptionTitle`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ExperienceDescriptionTitle' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `ExperienceDescriptionTitle`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Location`.`id`, `Location`.`wide_location_id`, `Location`.`municipio_id`, `Location`.`deleted`, `Location`.`deleted_date`, (`I18n__name`.`content`) AS `Location__i18n_name` FROM `vte_core`.`locations` AS `Location` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Location`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Location' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `Location`.`id` = 21 LIMIT 1 | 1 | 1 | 0 | |
SELECT `WideLocation`.`id`, `WideLocation`.`image_id`, `WideLocation`.`disabled`, `WideLocation`.`island_id`, `WideLocation`.`deleted`, `WideLocation`.`deleted_date`, (`I18n__name`.`content`) AS `WideLocation__i18n_name`, (`I18n__url`.`content`) AS `WideLocation__i18n_url` FROM `vte_core`.`wide_locations` AS `WideLocation` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`WideLocation`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'WideLocation' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`WideLocation`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'WideLocation' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') WHERE `WideLocation`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, (`I18n__name`.`content`) AS `Image__i18n_name`, (`I18n__alt`.`content`) AS `Image__i18n_alt`, (COALESCE(`I18n__url`.`content`, `I18n__url_spa`.`content`)) AS `Image__i18n_url` FROM `vte_core`.`images` AS `Image` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Image`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Image' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__alt` ON (`Image`.`id` = `I18n__alt`.`foreign_key` AND `I18n__alt`.`model` = 'Image' AND `I18n__alt`.`field` = 'alt' AND `I18n__alt`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url` ON (`Image`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'Image' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__url_spa` ON (`Image`.`id` = `I18n__url_spa`.`foreign_key` AND `I18n__url_spa`.`model` = 'Image' AND `I18n__url_spa`.`field` = 'url' AND `I18n__url_spa`.`locale` = 'spa') WHERE `Image`.`id` = 16 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id` FROM `vte_core`.`products` AS `Product` WHERE `experience_id` = 618 AND `Product`.`cancelled` = '0' AND `Product`.`deleted` = '0' | 1 | 1 | 0 | |
SELECT `ProductRate`.`id`, `ProductRate`.`product_id`, `ProductRate`.`products_time_id`, `ProductRate`.`product_option_id`, `ProductRate`.`highlighted`, `ProductRate`.`product_option_rate_id`, `ProductRate`.`days_products_hash`, `ProductRate`.`prDyTmBtnRateId`, `ProductRate`.`neto`, `ProductRate`.`pvp`, `ProductRate`.`percentage`, `ProductRate`.`comission`, `ProductRate`.`offer_pvp`, `ProductRate`.`offer_expire`, `ProductRate`.`products_supplier_id`, `ProductRate`.`requieres_identification`, `ProductRate`.`min_pax`, `ProductRate`.`max_pax`, `ProductRate`.`customer_type_ids`, `ProductRate`.`iacpos_id`, `ProductRate`.`iacpos_name`, `ProductRate`.`deleted`, `ProductRate`.`deleted_date`, `ProductRate`.`old_product_id`, `ProductRate`.`modified_user_id` FROM `vte_core`.`product_rates` AS `ProductRate` WHERE `ProductRate`.`product_id` = 1544 AND `ProductRate`.`deleted` = '0' | 2 | 2 | 6 | maybe slow |
SELECT `PickuplocationsProductRate`.`id`, `PickuplocationsProductRate`.`location_id`, `PickuplocationsProductRate`.`product_rate_id`, `PickuplocationsProductRate`.`pvp`, `PickuplocationsProductRate`.`neto` FROM `vte_core`.`pickuplocations_product_rates` AS `PickuplocationsProductRate` WHERE `product_rate_id` IN (20182, 20183) | 0 | 0 | 0 | |
SELECT `Hotel`.`id`, `Hotel`.`web`, `Hotel`.`email`, `Hotel`.`gps_lat`, `Hotel`.`gps_long`, `Hotel`.`location_id`, `Hotel`.`deleted`, `Hotel`.`deleted_date`, `Hotel`.`uuid`, (`I18n__name`.`content`) AS `Hotel__i18n_name`, (`I18n__description`.`content`) AS `Hotel__i18n_description` FROM `vte_core`.`hotels` AS `Hotel` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Hotel`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Hotel' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__description` ON (`Hotel`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Hotel' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'deu') WHERE `Hotel`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT `Supplier`.`id`, `Supplier`.`enterprise_id`, `Supplier`.`name`, `Supplier`.`cif`, `Supplier`.`web`, `Supplier`.`email`, `Supplier`.`is_payer`, `Supplier`.`street`, `Supplier`.`location`, `Supplier`.`province`, `Supplier`.`reservations_email`, `Supplier`.`reservations_phone`, `Supplier`.`admin_email`, `Supplier`.`admin_phone`, `Supplier`.`account`, `Supplier`.`payment_period_id`, `Supplier`.`image_id`, `Supplier`.`cancel_min_anticip`, `Supplier`.`deleted`, `Supplier`.`deleted_date`, (`I18n__description`.`content`) AS `Supplier__i18n_description`, `Image`.`id`, `Image`.`url`, `Image`.`deleted`, `Image`.`deleted_date`, `PaymentPeriod`.`id`, `PaymentPeriod`.`name`, `PaymentPeriod`.`days`, `PaymentPeriod`.`active`, `PaymentPeriod`.`deleted`, `PaymentPeriod`.`deleted_date` FROM `vte_core`.`suppliers` AS `Supplier` LEFT JOIN `vte_core`.`images` AS `Image` ON (`Supplier`.`image_id` = `Image`.`id`) LEFT JOIN `vte_core`.`payment_periods` AS `PaymentPeriod` ON (`Supplier`.`payment_period_id` = `PaymentPeriod`.`id`) LEFT JOIN `vte_core`.`i18n` AS `I18n__description` ON (`Supplier`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Supplier' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'deu') WHERE `Supplier`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT `Difficulty`.`id`, `Difficulty`.`available`, `Difficulty`.`deleted`, `Difficulty`.`deleted_date`, (`I18n__name`.`content`) AS `Difficulty__i18n_name` FROM `vte_core`.`difficulties` AS `Difficulty` LEFT JOIN `vte_core`.`i18n` AS `I18n__name` ON (`Difficulty`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Difficulty' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'deu') WHERE `Difficulty`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `sectioni18`.`content` AS `Name` FROM `vte_core`.`articles` AS `Article` inner JOIN `vte_core`.`articles_sections` AS `arts` ON (`Article`.`id` = `arts`.`article_id`) inner JOIN `vte_core`.`sections` AS `s` ON (`arts`.`section_id` = `s`.`id`) inner JOIN `vte_core`.`section_i18ns` AS `sectioni18` ON (`s`.`id` = `sectioni18`.`foreign_key`) WHERE `Article`.`subcategory_id` = (94) AND `sectioni18`.`locale` = 'deu' AND `sectioni18`.`field` = 'slug' LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Experience`.*, `I18n_name_spa`.`content`, `I18n_image_name_def`.`content` AS `name`, `I18n_image_alt_def`.`content` AS `alt`, COALESCE (I18n_image_url.content, I18n_image_url_spa.content) AS url, `I18n_image_port_alt_def`.`content` AS `alt`, `I18n_image_port_name_def`.`content` AS `name`, `I18n_loc_name_def`.`content` AS `name`, `I18n_wideloc_name_def`.`content` AS `name`, `I18n_island_name_def`.`content` AS `name`, `Image`.*, `ExperiencesImage`.*, `ExperiencesImagePort`.*, `ImagePort`.*, `Location`.*, `WideLocation`.*, `WideIcon`.`content` AS `url`, `Experience`.`id`, (`I18n__short_name`.`content`) AS `Experience__i18n_short_name`, (`I18n__description`.`content`) AS `Experience__i18n_description`, (`I18n__short_description`.`content`) AS `Experience__i18n_short_description`, (`I18n__aditional_information`.`content`) AS `Experience__i18n_aditional_information`, (`I18n__address`.`content`) AS `Experience__i18n_address`, (`I18n__menu`.`content`) AS `Experience__i18n_menu`, (`I18n__accommodation_text`.`content`) AS `Experience__i18n_accommodation_text`, (`I18n__titulo_seo`.`content`) AS `Experience__i18n_titulo_seo`, (`I18n__descripcion_seo`.`content`) AS `Experience__i18n_descripcion_seo`, (`I18n__h1`.`content`) AS `Experience__i18n_h1`, (`I18n__h2`.`content`) AS `Experience__i18n_h2`, (`I18n__survey_url`.`content`) AS `Experience__i18n_survey_url`, (`I18n__lang_hide`.`content`) AS `Experience__i18n_lang_hide`, (`I18n__promoted_volcano`.`content`) AS `Experience__i18n_promoted_volcano`, (`I18n__home_featured`.`content`) AS `Experience__i18n_home_featured`, (`I18n__buy_widget_info`.`content`) AS `Experience__i18n_buy_widget_info`, (`I18n__description_summary`.`content`) AS `Experience__i18n_description_summary`, (`I18n__video_id`.`content`) AS `Experience__i18n_video_id`, (`I18n__section_description_name`.`content`) AS `Experience__i18n_section_description_name`, (`I18n__section_description_short_name`.`content`) AS `Experience__i18n_section_description_short_name`, (`I18n__section_book_name`.`content`) AS `Experience__i18n_section_book_name`, (`I18n__section_book_short_name`.`content`) AS `Experience__i18n_section_book_short_name`, (`I18n__section_information_name`.`content`) AS `Experience__i18n_section_information_name`, (`I18n__section_information_short_name`.`content`) AS `Experience__i18n_section_information_short_name`, (`I18n__section_faqs_name`.`content`) AS `Experience__i18n_section_faqs_name`, (`I18n__section_faqs_short_name`.`content`) AS `Experience__i18n_section_faqs_short_name`, (`I18n__section_reviews_name`.`content`) AS `Experience__i18n_section_reviews_name`, (`I18n__section_reviews_short_name`.`content`) AS `Experience__i18n_section_reviews_short_name`, (`I18n__name`.`content`) AS `Experience__i18n_name`, (`I18n__slug`.`content`) AS `Experience__i18n_slug` FROM `vte_core`.`experiences` AS `Experience` inner JOIN `vte_core`.`i18n` AS `I18n_name_spa` ON (`I18n_name_spa`.`model` = 'Experience' AND `I18n_name_spa`.`foreign_key` = `Experience`.`id` AND `I18n_name_spa`.`field` = 'name' AND `I18n_name_spa`.`locale` = 'spa') left JOIN `vte_core`.`experiences_images` AS `ExperiencesImage` ON (`ExperiencesImage`.`experience_id` = `Experience`.`id` AND `ExperiencesImage`.`is_main` = '1') left JOIN `vte_core`.`images` AS `Image` ON (`ExperiencesImage`.`image_id` = `Image`.`id`) left JOIN `vte_core`.`experiences_images` AS `ExperiencesImagePort` ON (`ExperiencesImagePort`.`experience_id` = `Experience`.`id` AND `ExperiencesImagePort`.`is_portrait` = '1') left JOIN `vte_core`.`images` AS `ImagePort` ON (`ExperiencesImagePort`.`image_id` = `ImagePort`.`id`) left JOIN `vte_core`.`i18n` AS `I18n_image_url` ON (`I18n_image_url`.`model` = 'Image' AND `I18n_image_url`.`foreign_key` = `Image`.`id` AND `I18n_image_url`.`field` = 'url' AND `I18n_image_url`.`locale` = 'deu') left JOIN `vte_core`.`i18n` AS `I18n_image_url_spa` ON (`I18n_image_url_spa`.`model` = 'Image' AND `I18n_image_url_spa`.`foreign_key` = `Image`.`id` AND `I18n_image_url_spa`.`field` = 'url' AND `I18n_image_url_spa`.`locale` = 'spa') left JOIN `vte_core`.`i18n` AS `I18n_image_name_def` ON (`I18n_image_name_def`.`model` = 'Image' AND `I18n_image_name_def`.`foreign_key` = `Image`.`id` AND `I18n_image_name_def`.`field` = 'name' AND `I18n_image_name_def`.`locale` = 'deu') left JOIN `vte_core`.`i18n` AS `I18n_image_alt_def` ON (`I18n_image_alt_def`.`model` = 'Image' AND `I18n_image_alt_def`.`foreign_key` = `Image`.`id` AND `I18n_image_alt_def`.`field` = 'name' AND `I18n_image_alt_def`.`locale` = 'deu') left JOIN `vte_core`.`i18n` AS `I18n_image_port_name_def` ON (`I18n_image_port_name_def`.`model` = 'Image' AND `I18n_image_port_name_def`.`foreign_key` = `ImagePort`.`id` AND `I18n_image_port_name_def`.`field` = 'name' AND `I18n_image_port_name_def`.`locale` = 'deu') left JOIN `vte_core`.`i18n` AS `I18n_image_port_alt_def` ON (`I18n_image_port_alt_def`.`model` = 'Image' AND `I18n_image_port_alt_def`.`foreign_key` = `ImagePort`.`id` AND `I18n_image_port_alt_def`.`field` = 'alt' AND `I18n_image_port_alt_def`.`locale` = 'deu') left JOIN `vte_core`.`locations` AS `Location` ON (`Location`.`id` = `Experience`.`location_id`) left JOIN `vte_core`.`i18n` AS `I18n_loc_name_def` ON (`I18n_loc_name_def`.`model` = 'Location' AND `I18n_loc_name_def`.`foreign_key` = `Location`.`id` AND `I18n_loc_name_def`.`field` = 'name' AND `I18n_loc_name_def`.`locale` = 'spa') left JOIN `vte_core`.`wide_locations` AS `WideLocation` ON (`WideLocation`.`id` = `Location`.`wide_location_id`) left JOIN `vte_core`.`i18n` AS `I18n_wideloc_name_def` ON (`I18n_wideloc_name_def`.`model` = 'WideLocation' AND `I18n_wideloc_name_def`.`foreign_key` = `WideLocation`.`id` AND `I18n_wideloc_name_def`.`field` = 'name' AND `I18n_wideloc_name_def`.`locale` = 'deu') left JOIN `vte_core`.`islands` AS `Island` ON (`Island`.`id` = `Experience`.`island_id`) left JOIN `vte_core`.`i18n` AS `I18n_island_name_def` ON (`I18n_island_name_def`.`model` = 'Island' AND `I18n_island_name_def`.`foreign_key` = `Island`.`id` AND `I18n_island_name_def`.`field` = 'name' AND `I18n_island_name_def`.`locale` = 'spa') left JOIN `vte_core`.`i18n` AS `WideIcon` ON (`WideIcon`.`model` = 'Image' AND `WideIcon`.`foreign_key` = `WideLocation`.`image_id` AND `WideIcon`.`field` = 'url' AND `WideIcon`.`locale` = 'spa') LEFT JOIN `vte_core`.`i18n` AS `I18n__short_name` ON (`Experience`.`id` = `I18n__short_name`.`foreign_key` AND `I18n__short_name`.`model` = 'Experience' AND `I18n__short_name`.`field` = 'short_name' AND `I18n__short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__description` ON (`Experience`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Experience' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__short_description` ON (`Experience`.`id` = `I18n__short_description`.`foreign_key` AND `I18n__short_description`.`model` = 'Experience' AND `I18n__short_description`.`field` = 'short_description' AND `I18n__short_description`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__aditional_information` ON (`Experience`.`id` = `I18n__aditional_information`.`foreign_key` AND `I18n__aditional_information`.`model` = 'Experience' AND `I18n__aditional_information`.`field` = 'aditional_information' AND `I18n__aditional_information`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__address` ON (`Experience`.`id` = `I18n__address`.`foreign_key` AND `I18n__address`.`model` = 'Experience' AND `I18n__address`.`field` = 'address' AND `I18n__address`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__menu` ON (`Experience`.`id` = `I18n__menu`.`foreign_key` AND `I18n__menu`.`model` = 'Experience' AND `I18n__menu`.`field` = 'menu' AND `I18n__menu`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__accommodation_text` ON (`Experience`.`id` = `I18n__accommodation_text`.`foreign_key` AND `I18n__accommodation_text`.`model` = 'Experience' AND `I18n__accommodation_text`.`field` = 'accommodation_text' AND `I18n__accommodation_text`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__titulo_seo` ON (`Experience`.`id` = `I18n__titulo_seo`.`foreign_key` AND `I18n__titulo_seo`.`model` = 'Experience' AND `I18n__titulo_seo`.`field` = 'titulo_seo' AND `I18n__titulo_seo`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__descripcion_seo` ON (`Experience`.`id` = `I18n__descripcion_seo`.`foreign_key` AND `I18n__descripcion_seo`.`model` = 'Experience' AND `I18n__descripcion_seo`.`field` = 'descripcion_seo' AND `I18n__descripcion_seo`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__h1` ON (`Experience`.`id` = `I18n__h1`.`foreign_key` AND `I18n__h1`.`model` = 'Experience' AND `I18n__h1`.`field` = 'h1' AND `I18n__h1`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__h2` ON (`Experience`.`id` = `I18n__h2`.`foreign_key` AND `I18n__h2`.`model` = 'Experience' AND `I18n__h2`.`field` = 'h2' AND `I18n__h2`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__survey_url` ON (`Experience`.`id` = `I18n__survey_url`.`foreign_key` AND `I18n__survey_url`.`model` = 'Experience' AND `I18n__survey_url`.`field` = 'survey_url' AND `I18n__survey_url`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__lang_hide` ON (`Experience`.`id` = `I18n__lang_hide`.`foreign_key` AND `I18n__lang_hide`.`model` = 'Experience' AND `I18n__lang_hide`.`field` = 'lang_hide' AND `I18n__lang_hide`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__promoted_volcano` ON (`Experience`.`id` = `I18n__promoted_volcano`.`foreign_key` AND `I18n__promoted_volcano`.`model` = 'Experience' AND `I18n__promoted_volcano`.`field` = 'promoted_volcano' AND `I18n__promoted_volcano`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__home_featured` ON (`Experience`.`id` = `I18n__home_featured`.`foreign_key` AND `I18n__home_featured`.`model` = 'Experience' AND `I18n__home_featured`.`field` = 'home_featured' AND `I18n__home_featured`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__buy_widget_info` ON (`Experience`.`id` = `I18n__buy_widget_info`.`foreign_key` AND `I18n__buy_widget_info`.`model` = 'Experience' AND `I18n__buy_widget_info`.`field` = 'buy_widget_info' AND `I18n__buy_widget_info`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__description_summary` ON (`Experience`.`id` = `I18n__description_summary`.`foreign_key` AND `I18n__description_summary`.`model` = 'Experience' AND `I18n__description_summary`.`field` = 'description_summary' AND `I18n__description_summary`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__video_id` ON (`Experience`.`id` = `I18n__video_id`.`foreign_key` AND `I18n__video_id`.`model` = 'Experience' AND `I18n__video_id`.`field` = 'video_id' AND `I18n__video_id`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_description_name` ON (`Experience`.`id` = `I18n__section_description_name`.`foreign_key` AND `I18n__section_description_name`.`model` = 'Experience' AND `I18n__section_description_name`.`field` = 'section_description_name' AND `I18n__section_description_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_description_short_name` ON (`Experience`.`id` = `I18n__section_description_short_name`.`foreign_key` AND `I18n__section_description_short_name`.`model` = 'Experience' AND `I18n__section_description_short_name`.`field` = 'section_description_short_name' AND `I18n__section_description_short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_book_name` ON (`Experience`.`id` = `I18n__section_book_name`.`foreign_key` AND `I18n__section_book_name`.`model` = 'Experience' AND `I18n__section_book_name`.`field` = 'section_book_name' AND `I18n__section_book_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_book_short_name` ON (`Experience`.`id` = `I18n__section_book_short_name`.`foreign_key` AND `I18n__section_book_short_name`.`model` = 'Experience' AND `I18n__section_book_short_name`.`field` = 'section_book_short_name' AND `I18n__section_book_short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_information_name` ON (`Experience`.`id` = `I18n__section_information_name`.`foreign_key` AND `I18n__section_information_name`.`model` = 'Experience' AND `I18n__section_information_name`.`field` = 'section_information_name' AND `I18n__section_information_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_information_short_name` ON (`Experience`.`id` = `I18n__section_information_short_name`.`foreign_key` AND `I18n__section_information_short_name`.`model` = 'Experience' AND `I18n__section_information_short_name`.`field` = 'section_information_short_name' AND `I18n__section_information_short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_faqs_name` ON (`Experience`.`id` = `I18n__section_faqs_name`.`foreign_key` AND `I18n__section_faqs_name`.`model` = 'Experience' AND `I18n__section_faqs_name`.`field` = 'section_faqs_name' AND `I18n__section_faqs_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_faqs_short_name` ON (`Experience`.`id` = `I18n__section_faqs_short_name`.`foreign_key` AND `I18n__section_faqs_short_name`.`model` = 'Experience' AND `I18n__section_faqs_short_name`.`field` = 'section_faqs_short_name' AND `I18n__section_faqs_short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_reviews_name` ON (`Experience`.`id` = `I18n__section_reviews_name`.`foreign_key` AND `I18n__section_reviews_name`.`model` = 'Experience' AND `I18n__section_reviews_name`.`field` = 'section_reviews_name' AND `I18n__section_reviews_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`i18n` AS `I18n__section_reviews_short_name` ON (`Experience`.`id` = `I18n__section_reviews_short_name`.`foreign_key` AND `I18n__section_reviews_short_name`.`model` = 'Experience' AND `I18n__section_reviews_short_name`.`field` = 'section_reviews_short_name' AND `I18n__section_reviews_short_name`.`locale` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') LEFT JOIN `vte_core`.`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` = 'deu') WHERE `Experience`.`id` = (NULL) AND `Experience`.`cancelled` = '0' AND `Experience`.`deleted` = '0' GROUP BY `Experience`.`id` ORDER BY `Experience`.`sort_order` ASC | 0 | 0 | 3 | maybe slow |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`code2`, `Language`.`code3`, `Language`.`codeISO` FROM `vte_core`.`languages` AS `Language` WHERE `Language`.`disabled` = '0' AND NOT (`Language`.`code2` IS NULL) | 8 | 8 | 0 | |