Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `c1devkp`.`kenese_simple_blog_categories` AS `SimpleBlogCategory` WHERE 1 = 1 | 3 | 3 | 1 | maybe slow |
SELECT `SimpleBlogEntry`.`id`, `SimpleBlogEntry`.`simple_blog_category_id`, `SimpleBlogEntry`.`seo_title`, `SimpleBlogEntry`.`seo_desc`, `SimpleBlogEntry`.`seo_keyw`, `SimpleBlogEntry`.`title`, `SimpleBlogEntry`.`sub_title`, `SimpleBlogEntry`.`prolog`, `SimpleBlogEntry`.`content`, `SimpleBlogEntry`.`rooms`, `SimpleBlogEntry`.`sizes`, `SimpleBlogEntry`.`picture`, `SimpleBlogEntry`.`enabled`, `SimpleBlogEntry`.`manual_date`, `SimpleBlogEntry`.`connected_items`, `SimpleBlogEntry`.`created` FROM `c1devkp`.`kenese_simple_blog_entries` AS `SimpleBlogEntry` WHERE `SimpleBlogEntry`.`simple_blog_category_id` IN ('ACCOMMODATIONS', 'ATTRACTIONS', 'FAQ') | 6 | 6 | 0 | |
SELECT `SimpleBlogEntry`.`id`, `SimpleBlogEntry`.`simple_blog_category_id`, `SimpleBlogEntry`.`seo_title`, `SimpleBlogEntry`.`seo_desc`, `SimpleBlogEntry`.`seo_keyw`, `SimpleBlogEntry`.`title`, `SimpleBlogEntry`.`sub_title`, `SimpleBlogEntry`.`prolog`, `SimpleBlogEntry`.`content`, `SimpleBlogEntry`.`rooms`, `SimpleBlogEntry`.`sizes`, `SimpleBlogEntry`.`picture`, `SimpleBlogEntry`.`enabled`, `SimpleBlogEntry`.`manual_date`, `SimpleBlogEntry`.`connected_items`, `SimpleBlogEntry`.`created`, `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `c1devkp`.`kenese_simple_blog_entries` AS `SimpleBlogEntry` LEFT JOIN `c1devkp`.`kenese_simple_blog_categories` AS `SimpleBlogCategory` ON (`SimpleBlogEntry`.`simple_blog_category_id` = `SimpleBlogCategory`.`id`) WHERE `SimpleBlogEntry`.`enabled` = '1' AND `SimpleBlogEntry`.`simple_blog_category_id` = 'NEWS' LIMIT 12 | 0 | 0 | 1 | maybe slow |
SELECT `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `c1devkp`.`kenese_simple_blog_categories` AS `SimpleBlogCategory` WHERE `SimpleBlogCategory`.`id` = 'NEWS' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `SiteSetting`.`id`, `SiteSetting`.`seo_title`, `SiteSetting`.`seo_description`, `SiteSetting`.`seo_keywords`, `SiteSetting`.`copyright` FROM `c1devkp`.`kenese_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`id` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `RouteBasedSeo`.`id`, `RouteBasedSeo`.`route_alias`, `RouteBasedSeo`.`seo_title`, `RouteBasedSeo`.`seo_desc`, `RouteBasedSeo`.`seo_keyw` FROM `c1devkp`.`kenese_route_based_seo` AS `RouteBasedSeo` WHERE `RouteBasedSeo`.`route_alias` = '/hirek' LIMIT 1 | 0 | 0 | 16 | maybe slow |
SELECT `ContactManager`.`id`, `ContactManager`.`title`, `ContactManager`.`value` FROM `c1devkp`.`kenese_contact_manager` AS `ContactManager` WHERE 1 = 1 | 6 | 6 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1devkp`.`kenese_routes` AS `Route` LEFT JOIN `c1devkp`.`kenese_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'ATTRACTIONSDETAILS' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1devkp`.`kenese_routes` AS `Route` LEFT JOIN `c1devkp`.`kenese_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'HOME' LIMIT 1 | 1 | 1 | 0 | |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link`, `CommunityProfile`.`api_code`, `CommunityProfile`.`button_code` FROM `c1devkp`.`kenese_community_profiles` AS `CommunityProfile` WHERE 1 = 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1devkp`.`kenese_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Az oldal betöltése...' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1devkp`.`kenese_routes` AS `Route` LEFT JOIN `c1devkp`.`kenese_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'MAINMENU' | 8 | 8 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1devkp`.`kenese_routes` AS `Route` LEFT JOIN `c1devkp`.`kenese_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'MAINMENU' | 8 | 8 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1devkp`.`kenese_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Kövessen minket!' LIMIT 1 | 1 | 1 | 0 | |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link`, `CommunityProfile`.`api_code`, `CommunityProfile`.`button_code` FROM `c1devkp`.`kenese_community_profiles` AS `CommunityProfile` WHERE 1 = 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1devkp`.`kenese_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Kenese-völgy Villahotel' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1devkp`.`kenese_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Varázslatos villahotel, amely a Balatontól pár lépésnyire, Budapesttől pedig mindössze 45 percre található. Privát, családbarát, csendes és kényelmes.' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1devkp`.`kenese_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Elérhetőségeink' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1devkp`.`kenese_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Címünk' LIMIT 1 | 1 | 1 | 10 | maybe slow |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1devkp`.`kenese_routes` AS `Route` LEFT JOIN `c1devkp`.`kenese_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'OTHERS' | 3 | 3 | 0 | |
SELECT `StaticPage`.`id`, `StaticPage`.`short_id`, `StaticPage`.`title`, `StaticPage`.`link`, `StaticPage`.`seo_title`, `StaticPage`.`seo_desc`, `StaticPage`.`seo_keyw`, `StaticPage`.`prolog`, `StaticPage`.`content`, `StaticPage`.`public`, `StaticPage`.`created`, `StaticPage`.`modified`, `StaticPage`.`sort` FROM `c1devkp`.`kenese_static_pages` AS `StaticPage` WHERE `StaticPage`.`short_id` = 'COOKIE' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1devkp`.`kenese_routes` AS `Route` LEFT JOIN `c1devkp`.`kenese_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'COOKIE' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1devkp`.`kenese_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Tudjon meg még többet.' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1devkp`.`kenese_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Rendben' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1devkp`.`kenese_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Nem, nem járulok hozzá' LIMIT 1 | 1 | 1 | 0 | |