Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `GallerySetting`.`id`, `GallerySetting`.`max_width`, `GallerySetting`.`max_height`, `GallerySetting`.`storage_dir`, `GallerySetting`.`create_thumbnails`, `GallerySetting`.`thumb_width`, `GallerySetting`.`thumb_height` FROM `c1verbatanya`.`verbanew_gallery_settings` AS `GallerySetting` WHERE `GallerySetting`.`id` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `GalleryPicture`.`id`, `GalleryPicture`.`gallery_group_id`, `GalleryPicture`.`picture`, `GalleryPicture`.`created` FROM `c1verbatanya`.`verbanew_gallery_pictures` AS `GalleryPicture` WHERE `GalleryPicture`.`gallery_group_id` = 'SZOBA1' ORDER BY `GalleryPicture`.`id` ASC | 7 | 7 | 0 | |
SELECT `GalleryGroup`.`id`, `GalleryGroup`.`name`, `GalleryGroup`.`sort` FROM `c1verbatanya`.`verbanew_gallery_groups` AS `GalleryGroup` WHERE `GalleryGroup`.`id` = 'SZOBA1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `GalleryPicture`.`id`, `GalleryPicture`.`gallery_group_id`, `GalleryPicture`.`picture`, `GalleryPicture`.`created` FROM `c1verbatanya`.`verbanew_gallery_pictures` AS `GalleryPicture` WHERE `GalleryPicture`.`gallery_group_id` = ('SZOBA1') | 7 | 7 | 0 | |
SELECT `SiteSetting`.`id`, `SiteSetting`.`seo_title`, `SiteSetting`.`seo_description`, `SiteSetting`.`seo_keywords`, `SiteSetting`.`copyright` FROM `c1verbatanya`.`verbanew_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 `c1verbatanya`.`verbanew_route_based_seo` AS `RouteBasedSeo` WHERE `RouteBasedSeo`.`route_alias` = '/galeria/SZOBA1' LIMIT 1 | 0 | 0 | 0 | |
SELECT `ContactManager`.`id`, `ContactManager`.`title`, `ContactManager`.`value` FROM `c1verbatanya`.`verbanew_contact_manager` AS `ContactManager` WHERE 1 = 1 | 6 | 6 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'MAINMENU' | 5 | 5 | 0 | |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link` FROM `c1verbatanya`.`verbanew_community_profiles` AS `CommunityProfile` WHERE `CommunityProfile`.`short_id` = 'facebook' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'SUBNAVI' | 7 | 7 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'GUESTHOUSESUB' | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'RESTAURANTSUB' | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'FISHINGPONDSUB' | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'EVENTSSUB' | 2 | 2 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'OPINION' | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'CARTE' | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'DRINKS' | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'MAINMENU' | 5 | 5 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'SUBNAVI' | 7 | 7 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'GUESTHOUSESUB' | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'RESTAURANTSUB' | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'FISHINGPONDSUB' | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'EVENTSSUB' | 2 | 2 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'OPINION' | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'CARTE' | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'DRINKS' | 0 | 0 | 0 | |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link` FROM `c1verbatanya`.`verbanew_community_profiles` AS `CommunityProfile` WHERE `CommunityProfile`.`short_id` = 'facebook' LIMIT 1 | 1 | 1 | 0 | |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link` FROM `c1verbatanya`.`verbanew_community_profiles` AS `CommunityProfile` WHERE `CommunityProfile`.`short_id` = 'facebook' LIMIT 1 | 1 | 1 | 0 | |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link` FROM `c1verbatanya`.`verbanew_community_profiles` AS `CommunityProfile` WHERE `CommunityProfile`.`short_id` = 'facebook' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'MAINMENU' | 5 | 5 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'SUBNAVI' | 7 | 7 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'GUESTHOUSESUB' | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'RESTAURANTSUB' | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'FISHINGPONDSUB' | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'EVENTSSUB' | 2 | 2 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'CARTE' | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1verbatanya`.`verbanew_routes` AS `Route` LEFT JOIN `c1verbatanya`.`verbanew_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'DRINKS' | 0 | 0 | 0 | |