Query | Affected | Num. rows | Took (ms) | Actions |
---|
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`, (`I18n__title`.`content`) AS `StaticPage__i18n_title`, (`I18n__link`.`content`) AS `StaticPage__i18n_link`, (`I18n__prolog`.`content`) AS `StaticPage__i18n_prolog`, (`I18n__content`.`content`) AS `StaticPage__i18n_content`, (`I18n__seo_title`.`content`) AS `StaticPage__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `StaticPage__i18n_seo_desc`, (`I18n__seo_keys`.`content`) AS `StaticPage__i18n_seo_keys` FROM `c1miloprstg`.`milop_static_pages` AS `StaticPage` LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__title` ON (`StaticPage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'StaticPage' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__link` ON (`StaticPage`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'StaticPage' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__prolog` ON (`StaticPage`.`id` = `I18n__prolog`.`foreign_key` AND `I18n__prolog`.`model` = 'StaticPage' AND `I18n__prolog`.`field` = 'prolog' AND `I18n__prolog`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__content` ON (`StaticPage`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'StaticPage' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__seo_title` ON (`StaticPage`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'StaticPage' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__seo_desc` ON (`StaticPage`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'StaticPage' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__seo_keys` ON (`StaticPage`.`id` = `I18n__seo_keys`.`foreign_key` AND `I18n__seo_keys`.`model` = 'StaticPage' AND `I18n__seo_keys`.`field` = 'seo_keys' AND `I18n__seo_keys`.`locale` = 'hun') WHERE `StaticPage`.`short_id` = 'CATALOG' LIMIT 1 | 1 | 1 | 11 | maybe slow |
SELECT `SiteSetting`.`id`, `SiteSetting`.`seo_title`, `SiteSetting`.`seo_description`, `SiteSetting`.`seo_keywords`, `SiteSetting`.`copyright` FROM `c1miloprstg`.`milop_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 `c1miloprstg`.`milop_route_based_seo` AS `RouteBasedSeo` WHERE `RouteBasedSeo`.`route_alias` = '/katalogus' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `ContactManager`.`id`, `ContactManager`.`title`, `ContactManager`.`value` FROM `c1miloprstg`.`milop_contact_manager` AS `ContactManager` WHERE 1 = 1 | 0 | 0 | 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`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1miloprstg`.`milop_routes` AS `Route` LEFT JOIN `c1miloprstg`.`milop_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__name` ON (`Route`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Route' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'HOME' LIMIT 1 | 1 | 1 | 4 | maybe slow |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link`, `CommunityProfile`.`api_code`, `CommunityProfile`.`button_code` FROM `c1miloprstg`.`milop_community_profiles` AS `CommunityProfile` WHERE 1 = 1 | 1 | 1 | 1 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1miloprstg`.`milop_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Írja ide a keresett kifejezést...' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1miloprstg`.`milop_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Keresés' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`locale_code`, `Language`.`locale_dir`, `Language`.`enabled`, `Language`.`set_as_default` FROM `c1miloprstg`.`milop_languages` AS `Language` WHERE `Language`.`enabled` = '1' | 4 | 4 | 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`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1miloprstg`.`milop_routes` AS `Route` LEFT JOIN `c1miloprstg`.`milop_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__name` ON (`Route`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Route' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'MAINMENU' | 4 | 4 | 3 | 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`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1miloprstg`.`milop_routes` AS `Route` LEFT JOIN `c1miloprstg`.`milop_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__name` ON (`Route`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Route' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'FOOTER' | 2 | 2 | 2 | |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link`, `CommunityProfile`.`api_code`, `CommunityProfile`.`button_code` FROM `c1miloprstg`.`milop_community_profiles` AS `CommunityProfile` WHERE 1 = 1 | 1 | 1 | 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`, (`I18n__title`.`content`) AS `StaticPage__i18n_title`, (`I18n__link`.`content`) AS `StaticPage__i18n_link`, (`I18n__prolog`.`content`) AS `StaticPage__i18n_prolog`, (`I18n__content`.`content`) AS `StaticPage__i18n_content`, (`I18n__seo_title`.`content`) AS `StaticPage__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `StaticPage__i18n_seo_desc`, (`I18n__seo_keys`.`content`) AS `StaticPage__i18n_seo_keys` FROM `c1miloprstg`.`milop_static_pages` AS `StaticPage` LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__title` ON (`StaticPage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'StaticPage' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__link` ON (`StaticPage`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'StaticPage' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__prolog` ON (`StaticPage`.`id` = `I18n__prolog`.`foreign_key` AND `I18n__prolog`.`model` = 'StaticPage' AND `I18n__prolog`.`field` = 'prolog' AND `I18n__prolog`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__content` ON (`StaticPage`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'StaticPage' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__seo_title` ON (`StaticPage`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'StaticPage' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__seo_desc` ON (`StaticPage`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'StaticPage' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__seo_keys` ON (`StaticPage`.`id` = `I18n__seo_keys`.`foreign_key` AND `I18n__seo_keys`.`model` = 'StaticPage' AND `I18n__seo_keys`.`field` = 'seo_keys' AND `I18n__seo_keys`.`locale` = 'hun') WHERE `StaticPage`.`short_id` = 'COOKIE' LIMIT 1 | 1 | 1 | 2 | maybe slow |
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`, (`I18n__title`.`content`) AS `StaticPage__i18n_title`, (`I18n__link`.`content`) AS `StaticPage__i18n_link`, (`I18n__prolog`.`content`) AS `StaticPage__i18n_prolog`, (`I18n__content`.`content`) AS `StaticPage__i18n_content`, (`I18n__seo_title`.`content`) AS `StaticPage__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `StaticPage__i18n_seo_desc`, (`I18n__seo_keys`.`content`) AS `StaticPage__i18n_seo_keys` FROM `c1miloprstg`.`milop_static_pages` AS `StaticPage` LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__title` ON (`StaticPage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'StaticPage' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__link` ON (`StaticPage`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'StaticPage' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__prolog` ON (`StaticPage`.`id` = `I18n__prolog`.`foreign_key` AND `I18n__prolog`.`model` = 'StaticPage' AND `I18n__prolog`.`field` = 'prolog' AND `I18n__prolog`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__content` ON (`StaticPage`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'StaticPage' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__seo_title` ON (`StaticPage`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'StaticPage' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__seo_desc` ON (`StaticPage`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'StaticPage' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_static_page_i18ns` AS `I18n__seo_keys` ON (`StaticPage`.`id` = `I18n__seo_keys`.`foreign_key` AND `I18n__seo_keys`.`model` = 'StaticPage' AND `I18n__seo_keys`.`field` = 'seo_keys' AND `I18n__seo_keys`.`locale` = 'hun') 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`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1miloprstg`.`milop_routes` AS `Route` LEFT JOIN `c1miloprstg`.`milop_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__name` ON (`Route`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Route' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1miloprstg`.`milop_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'COOKIE' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1miloprstg`.`milop_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 `c1miloprstg`.`milop_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Elfogadom a Cookie-kat' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1miloprstg`.`milop_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Nem, nem járulok hozzá' LIMIT 1 | 1 | 1 | 0 | |