Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `c1hajdurt`.`hajdu_simple_blog_categories` AS `SimpleBlogCategory` WHERE 1 = 1 | 5 | 5 | 0 | |
SELECT `SimpleBlogEntry`.`id`, `SimpleBlogEntry`.`simple_blog_category_id`, `SimpleBlogEntry`.`seo_title`, `SimpleBlogEntry`.`seo_desc`, `SimpleBlogEntry`.`seo_keyw`, `SimpleBlogEntry`.`title`, `SimpleBlogEntry`.`prolog`, `SimpleBlogEntry`.`content`, `SimpleBlogEntry`.`picture`, `SimpleBlogEntry`.`enabled`, `SimpleBlogEntry`.`manual_date`, `SimpleBlogEntry`.`connected_items`, `SimpleBlogEntry`.`views`, `SimpleBlogEntry`.`created`, `SimpleBlogEntry`.`sort`, (`I18n__title`.`content`) AS `SimpleBlogEntry__i18n_title`, (`I18n__seo_title`.`content`) AS `SimpleBlogEntry__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `SimpleBlogEntry__i18n_seo_desc`, (`I18n__seo_keyw`.`content`) AS `SimpleBlogEntry__i18n_seo_keyw`, (`I18n__prolog`.`content`) AS `SimpleBlogEntry__i18n_prolog`, (`I18n__content`.`content`) AS `SimpleBlogEntry__i18n_content`, `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `c1hajdurt`.`hajdu_simple_blog_entries` AS `SimpleBlogEntry` LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_categories` AS `SimpleBlogCategory` ON (`SimpleBlogEntry`.`simple_blog_category_id` = `SimpleBlogCategory`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__title` ON (`SimpleBlogEntry`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'SimpleBlogEntry' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__seo_title` ON (`SimpleBlogEntry`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'SimpleBlogEntry' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__seo_desc` ON (`SimpleBlogEntry`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'SimpleBlogEntry' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__seo_keyw` ON (`SimpleBlogEntry`.`id` = `I18n__seo_keyw`.`foreign_key` AND `I18n__seo_keyw`.`model` = 'SimpleBlogEntry' AND `I18n__seo_keyw`.`field` = 'seo_keyw' AND `I18n__seo_keyw`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__prolog` ON (`SimpleBlogEntry`.`id` = `I18n__prolog`.`foreign_key` AND `I18n__prolog`.`model` = 'SimpleBlogEntry' AND `I18n__prolog`.`field` = 'prolog' AND `I18n__prolog`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__content` ON (`SimpleBlogEntry`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'SimpleBlogEntry' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'hun') WHERE `SimpleBlogEntry`.`id` = 106 LIMIT 1 | 1 | 1 | 3 | maybe slow |
SELECT `SimpleBlogComment`.`id`, `SimpleBlogComment`.`simple_blog_entry_id`, `SimpleBlogComment`.`name`, `SimpleBlogComment`.`email`, `SimpleBlogComment`.`message`, `SimpleBlogComment`.`enabled`, `SimpleBlogComment`.`created` FROM `c1hajdurt`.`hajdu_simple_blog_comments` AS `SimpleBlogComment` WHERE `SimpleBlogComment`.`enabled` = '1' AND `SimpleBlogComment`.`simple_blog_entry_id` = (106) | 0 | 0 | 0 | |
SELECT `SimpleBlogSubcategory`.`id`, `SimpleBlogSubcategory`.`parent_id`, `SimpleBlogSubcategory`.`lft`, `SimpleBlogSubcategory`.`rght`, `SimpleBlogSubcategory`.`title`, `SimpleBlogSubcategory`.`sub_title`, `SimpleBlogSubcategory`.`seo_title`, `SimpleBlogSubcategory`.`seo_desc`, `SimpleBlogSubcategory`.`seo_keyw`, `SimpleBlogSubcategory`.`details`, `SimpleBlogSubcategory`.`picture`, `SimpleBlogSubcategory`.`sort`, `SimpleBlogSubcategory`.`enabled`, `SimpleBlogSubcategory`.`featured`, `SimpleBlogSubcategory`.`faq`, `SimpleBlogSubcategory`.`created`, `SimpleBlogSubcategory`.`modified`, `SimpleBlogSubCategoriesEntry`.`id`, `SimpleBlogSubCategoriesEntry`.`simple_blog_entry_id`, `SimpleBlogSubCategoriesEntry`.`simple_blog_subcategory_id` FROM `c1hajdurt`.`hajdu_simple_blog_subcategories` AS `SimpleBlogSubcategory` JOIN `c1hajdurt`.`hajdu_simple_blog_sub_categories_entries` AS `SimpleBlogSubCategoriesEntry` ON (`SimpleBlogSubCategoriesEntry`.`simple_blog_entry_id` = 106 AND `SimpleBlogSubCategoriesEntry`.`simple_blog_subcategory_id` = `SimpleBlogSubcategory`.`id`) | 0 | 0 | 0 | |
SELECT `SimpleBlogTag`.`id`, `SimpleBlogTag`.`title`, `SimpleBlogTag`.`enabled`, `SimpleBlogTag`.`created`, `SimpleBlogTag`.`sort`, `SimpleBlogTagsEntry`.`id`, `SimpleBlogTagsEntry`.`simple_blog_entry_id`, `SimpleBlogTagsEntry`.`simple_blog_tag_id` FROM `c1hajdurt`.`hajdu_simple_blog_tags` AS `SimpleBlogTag` JOIN `c1hajdurt`.`hajdu_simple_blog_tags_entries` AS `SimpleBlogTagsEntry` ON (`SimpleBlogTagsEntry`.`simple_blog_entry_id` = 106 AND `SimpleBlogTagsEntry`.`simple_blog_tag_id` = `SimpleBlogTag`.`id`) | 0 | 0 | 0 | |
BEGIN | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `c1hajdurt`.`hajdu_simple_blog_entries` AS `SimpleBlogEntry` WHERE `SimpleBlogEntry`.`id` = 106 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `c1hajdurt`.`hajdu_simple_blog_entries` AS `SimpleBlogEntry` WHERE `SimpleBlogEntry`.`id` = 106 | 1 | 1 | 0 | |
UPDATE `c1hajdurt`.`hajdu_simple_blog_entries` SET `views` = 1430 WHERE `c1hajdurt`.`hajdu_simple_blog_entries`.`id` = '106' | 1 | 1 | 4 | maybe slow |
COMMIT | 1 | 1 | 4 | maybe slow |
SELECT `GalleryGroup`.`id`, `GalleryGroup`.`name`, `GalleryGroup`.`sort` FROM `c1hajdurt`.`hajdu_gallery_groups` AS `GalleryGroup` WHERE `GalleryGroup`.`id` = '' | 0 | 0 | 0 | |
SELECT `SimpleBlogEntry`.`id`, `SimpleBlogEntry`.`simple_blog_category_id`, `SimpleBlogEntry`.`seo_title`, `SimpleBlogEntry`.`seo_desc`, `SimpleBlogEntry`.`seo_keyw`, `SimpleBlogEntry`.`title`, `SimpleBlogEntry`.`prolog`, `SimpleBlogEntry`.`content`, `SimpleBlogEntry`.`picture`, `SimpleBlogEntry`.`enabled`, `SimpleBlogEntry`.`manual_date`, `SimpleBlogEntry`.`connected_items`, `SimpleBlogEntry`.`views`, `SimpleBlogEntry`.`created`, `SimpleBlogEntry`.`sort`, (`I18n__title`.`content`) AS `SimpleBlogEntry__i18n_title`, (`I18n__seo_title`.`content`) AS `SimpleBlogEntry__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `SimpleBlogEntry__i18n_seo_desc`, (`I18n__seo_keyw`.`content`) AS `SimpleBlogEntry__i18n_seo_keyw`, (`I18n__prolog`.`content`) AS `SimpleBlogEntry__i18n_prolog`, (`I18n__content`.`content`) AS `SimpleBlogEntry__i18n_content`, `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `c1hajdurt`.`hajdu_simple_blog_entries` AS `SimpleBlogEntry` LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_categories` AS `SimpleBlogCategory` ON (`SimpleBlogEntry`.`simple_blog_category_id` = `SimpleBlogCategory`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__title` ON (`SimpleBlogEntry`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'SimpleBlogEntry' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__seo_title` ON (`SimpleBlogEntry`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'SimpleBlogEntry' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__seo_desc` ON (`SimpleBlogEntry`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'SimpleBlogEntry' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__seo_keyw` ON (`SimpleBlogEntry`.`id` = `I18n__seo_keyw`.`foreign_key` AND `I18n__seo_keyw`.`model` = 'SimpleBlogEntry' AND `I18n__seo_keyw`.`field` = 'seo_keyw' AND `I18n__seo_keyw`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__prolog` ON (`SimpleBlogEntry`.`id` = `I18n__prolog`.`foreign_key` AND `I18n__prolog`.`model` = 'SimpleBlogEntry' AND `I18n__prolog`.`field` = 'prolog' AND `I18n__prolog`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_simple_blog_entry_i18ns` AS `I18n__content` ON (`SimpleBlogEntry`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'SimpleBlogEntry' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'hun') WHERE `SimpleBlogEntry`.`id` IS NULL | 0 | 0 | 0 | |
SELECT `SiteSetting`.`id`, `SiteSetting`.`seo_title`, `SiteSetting`.`seo_description`, `SiteSetting`.`seo_keywords`, `SiteSetting`.`copyright` FROM `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_based_seo` AS `RouteBasedSeo` WHERE `RouteBasedSeo`.`route_alias` = '/hir/harmadaval-novelte-arbevetelet-a-hajdu/106' LIMIT 1 | 0 | 0 | 0 | |
SELECT `ContactManager`.`id`, `ContactManager`.`title`, `ContactManager`.`value`, (`I18n__title`.`content`) AS `ContactManager__i18n_title`, (`I18n__value`.`content`) AS `ContactManager__i18n_value` FROM `c1hajdurt`.`hajdu_contact_manager` AS `ContactManager` LEFT JOIN `c1hajdurt`.`hajdu_contact_manager_i18ns` AS `I18n__title` ON (`ContactManager`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'ContactManager' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_contact_manager_i18ns` AS `I18n__value` ON (`ContactManager`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'ContactManager' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'hun') WHERE 1 = 1 | 11 | 11 | 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'NEWS' 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') 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 `c1hajdurt`.`hajdu_community_profiles` AS `CommunityProfile` WHERE 1 = 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1hajdurt`.`hajdu_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Keresés az oldalon...' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_community_profiles` AS `CommunityProfile` WHERE 1 = 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'FAQ' 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__seo_title`.`content`) AS `ProductCategory__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `ProductCategory__i18n_seo_desc`, (`I18n__seo_keyw`.`content`) AS `ProductCategory__i18n_seo_keyw`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`I18n__enabled`.`content`) AS `ProductCategory__i18n_enabled` FROM `c1hajdurt`.`hajdu_product_categories` AS `ProductCategory` LEFT JOIN `c1hajdurt`.`hajdu_product_category_i18ns` AS `I18n__title` ON (`ProductCategory`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'ProductCategory' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_category_i18ns` AS `I18n__seo_title` ON (`ProductCategory`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'ProductCategory' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_category_i18ns` AS `I18n__seo_desc` ON (`ProductCategory`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'ProductCategory' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_category_i18ns` AS `I18n__seo_keyw` ON (`ProductCategory`.`id` = `I18n__seo_keyw`.`foreign_key` AND `I18n__seo_keyw`.`model` = 'ProductCategory' AND `I18n__seo_keyw`.`field` = 'seo_keyw' AND `I18n__seo_keyw`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_category_i18ns` AS `I18n__enabled` ON (`ProductCategory`.`id` = `I18n__enabled`.`foreign_key` AND `I18n__enabled`.`model` = 'ProductCategory' AND `I18n__enabled`.`field` = 'enabled' AND `I18n__enabled`.`locale` = 'hun') WHERE `parent_id` IS NULL AND `enabled` = '1' ORDER BY `sort` ASC | 14 | 14 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`details`, `Product`.`specifications`, `Product`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`connected_items`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1hajdurt`.`hajdu_products` AS `Product` JOIN `c1hajdurt`.`hajdu_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` IN (65, 93, 79, 85, 50, 89, 92, 51, 52, 91, 53, 90, 56, 86) AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 24 | 24 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`locale_code`, `Language`.`locale_dir`, `Language`.`enabled`, `Language`.`set_as_default` FROM `c1hajdurt`.`hajdu_languages` AS `Language` WHERE `Language`.`enabled` = '1' | 5 | 5 | 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'MAINMENU' | 7 | 7 | 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'CEGTOR' | 5 | 5 | 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'OTHERS' | 1 | 1 | 0 | |
SELECT `DownloadCategory`.`id`, `DownloadCategory`.`parent_id`, `DownloadCategory`.`lft`, `DownloadCategory`.`rght`, `DownloadCategory`.`title`, `DownloadCategory`.`sub_title`, `DownloadCategory`.`seo_title`, `DownloadCategory`.`seo_desc`, `DownloadCategory`.`seo_keyw`, `DownloadCategory`.`details`, `DownloadCategory`.`enabled`, `DownloadCategory`.`created`, `DownloadCategory`.`modified`, `DownloadCategory`.`sort`, (`I18n__title`.`content`) AS `DownloadCategory__i18n_title`, (`I18n__seo_title`.`content`) AS `DownloadCategory__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `DownloadCategory__i18n_seo_desc`, (`I18n__seo_keyw`.`content`) AS `DownloadCategory__i18n_seo_keyw`, (`I18n__details`.`content`) AS `DownloadCategory__i18n_details` FROM `c1hajdurt`.`hajdu_download_categories` AS `DownloadCategory` LEFT JOIN `c1hajdurt`.`hajdu_download_category_i18ns` AS `I18n__title` ON (`DownloadCategory`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'DownloadCategory' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_download_category_i18ns` AS `I18n__seo_title` ON (`DownloadCategory`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'DownloadCategory' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_download_category_i18ns` AS `I18n__seo_desc` ON (`DownloadCategory`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'DownloadCategory' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_download_category_i18ns` AS `I18n__seo_keyw` ON (`DownloadCategory`.`id` = `I18n__seo_keyw`.`foreign_key` AND `I18n__seo_keyw`.`model` = 'DownloadCategory' AND `I18n__seo_keyw`.`field` = 'seo_keyw' AND `I18n__seo_keyw`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_download_category_i18ns` AS `I18n__details` ON (`DownloadCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'DownloadCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') WHERE `enabled` = '1' ORDER BY `sort` asc | 98 | 98 | 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'MAINMENU' | 7 | 7 | 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'CEGTOR' | 5 | 5 | 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'OTHERS' | 1 | 1 | 0 | |
SELECT `DownloadCategory`.`id`, `DownloadCategory`.`parent_id`, `DownloadCategory`.`lft`, `DownloadCategory`.`rght`, `DownloadCategory`.`title`, `DownloadCategory`.`sub_title`, `DownloadCategory`.`seo_title`, `DownloadCategory`.`seo_desc`, `DownloadCategory`.`seo_keyw`, `DownloadCategory`.`details`, `DownloadCategory`.`enabled`, `DownloadCategory`.`created`, `DownloadCategory`.`modified`, `DownloadCategory`.`sort`, (`I18n__title`.`content`) AS `DownloadCategory__i18n_title`, (`I18n__seo_title`.`content`) AS `DownloadCategory__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `DownloadCategory__i18n_seo_desc`, (`I18n__seo_keyw`.`content`) AS `DownloadCategory__i18n_seo_keyw`, (`I18n__details`.`content`) AS `DownloadCategory__i18n_details` FROM `c1hajdurt`.`hajdu_download_categories` AS `DownloadCategory` LEFT JOIN `c1hajdurt`.`hajdu_download_category_i18ns` AS `I18n__title` ON (`DownloadCategory`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'DownloadCategory' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_download_category_i18ns` AS `I18n__seo_title` ON (`DownloadCategory`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'DownloadCategory' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_download_category_i18ns` AS `I18n__seo_desc` ON (`DownloadCategory`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'DownloadCategory' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_download_category_i18ns` AS `I18n__seo_keyw` ON (`DownloadCategory`.`id` = `I18n__seo_keyw`.`foreign_key` AND `I18n__seo_keyw`.`model` = 'DownloadCategory' AND `I18n__seo_keyw`.`field` = 'seo_keyw' AND `I18n__seo_keyw`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_download_category_i18ns` AS `I18n__details` ON (`DownloadCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'DownloadCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') WHERE `enabled` = '1' ORDER BY `sort` asc | 98 | 98 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1hajdurt`.`hajdu_translations` AS `Translation` WHERE `Translation`.`string_key` = 'További oldalaink' 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'ANOTHER' | 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'FFOOTER' | 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`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'NKFI' 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__static_link`.`content`) AS `Route__i18n_static_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1hajdurt`.`hajdu_routes` AS `Route` LEFT JOIN `c1hajdurt`.`hajdu_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_route_i18ns` AS `I18n__static_link` ON (`Route`.`id` = `I18n__static_link`.`foreign_key` AND `I18n__static_link`.`model` = 'Route' AND `I18n__static_link`.`field` = 'static_link' AND `I18n__static_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'GINOP' LIMIT 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__seo_title`.`content`) AS `StaticPage__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `StaticPage__i18n_seo_desc`, (`I18n__seo_keyw`.`content`) AS `StaticPage__i18n_seo_keyw`, (`I18n__prolog`.`content`) AS `StaticPage__i18n_prolog`, (`I18n__content`.`content`) AS `StaticPage__i18n_content` FROM `c1hajdurt`.`hajdu_static_pages` AS `StaticPage` LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_static_page_i18ns` AS `I18n__seo_keyw` ON (`StaticPage`.`id` = `I18n__seo_keyw`.`foreign_key` AND `I18n__seo_keyw`.`model` = 'StaticPage' AND `I18n__seo_keyw`.`field` = 'seo_keyw' AND `I18n__seo_keyw`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_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 `c1hajdurt`.`hajdu_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') WHERE `StaticPage`.`short_id` = 'COOKIE' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1hajdurt`.`hajdu_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Elfogadom' LIMIT 1 | 1 | 1 | 0 | |