Query | Affected | Num. rows | Took (ms) | Actions |
---|
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`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__transport_time`.`content`) AS `Product__i18n_transport_time`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`I18n__specifications`.`content`) AS `Product__i18n_specifications`, (`I18n__seo_title`.`content`) AS `Product__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `Product__i18n_seo_desc`, (`I18n__seo_keyw`.`content`) AS `Product__i18n_seo_keyw`, (`I18n__enabled`.`content`) AS `Product__i18n_enabled` FROM `c1hajdurt`.`hajdu_products` AS `Product` LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__name` ON (`Product`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Product' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__transport_time` ON (`Product`.`id` = `I18n__transport_time`.`foreign_key` AND `I18n__transport_time`.`model` = 'Product' AND `I18n__transport_time`.`field` = 'transport_time' AND `I18n__transport_time`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__details` ON (`Product`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'Product' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__specifications` ON (`Product`.`id` = `I18n__specifications`.`foreign_key` AND `I18n__specifications`.`model` = 'Product' AND `I18n__specifications`.`field` = 'specifications' AND `I18n__specifications`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__seo_title` ON (`Product`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Product' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__seo_desc` ON (`Product`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Product' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__seo_keyw` ON (`Product`.`id` = `I18n__seo_keyw`.`foreign_key` AND `I18n__seo_keyw`.`model` = 'Product' AND `I18n__seo_keyw`.`field` = 'seo_keyw' AND `I18n__seo_keyw`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__enabled` ON (`Product`.`id` = `I18n__enabled`.`foreign_key` AND `I18n__enabled`.`model` = 'Product' AND `I18n__enabled`.`field` = 'enabled' AND `I18n__enabled`.`locale` = 'hun') WHERE `Product`.`id` = 91 LIMIT 1 | 1 | 1 | 13 | maybe slow |
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`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__transport_time`.`content`) AS `Product__i18n_transport_time`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`I18n__specifications`.`content`) AS `Product__i18n_specifications`, (`I18n__seo_title`.`content`) AS `Product__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `Product__i18n_seo_desc`, (`I18n__seo_keyw`.`content`) AS `Product__i18n_seo_keyw`, (`I18n__enabled`.`content`) AS `Product__i18n_enabled`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `c1hajdurt`.`hajdu_products` AS `Product` LEFT JOIN `c1hajdurt`.`hajdu_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__name` ON (`Product`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Product' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__transport_time` ON (`Product`.`id` = `I18n__transport_time`.`foreign_key` AND `I18n__transport_time`.`model` = 'Product' AND `I18n__transport_time`.`field` = 'transport_time' AND `I18n__transport_time`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__details` ON (`Product`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'Product' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__specifications` ON (`Product`.`id` = `I18n__specifications`.`foreign_key` AND `I18n__specifications`.`model` = 'Product' AND `I18n__specifications`.`field` = 'specifications' AND `I18n__specifications`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__seo_title` ON (`Product`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Product' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__seo_desc` ON (`Product`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Product' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__seo_keyw` ON (`Product`.`id` = `I18n__seo_keyw`.`foreign_key` AND `I18n__seo_keyw`.`model` = 'Product' AND `I18n__seo_keyw`.`field` = 'seo_keyw' AND `I18n__seo_keyw`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__enabled` ON (`Product`.`id` = `I18n__enabled`.`foreign_key` AND `I18n__enabled`.`model` = 'Product' AND `I18n__enabled`.`field` = 'enabled' AND `I18n__enabled`.`locale` = 'hun') WHERE `Product`.`id` = 91 LIMIT 1 | 1 | 1 | 8 | maybe slow |
SELECT `ProductPicture`.`id`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`sort` FROM `c1hajdurt`.`hajdu_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` = (91) | 2 | 2 | 1 | maybe slow |
SELECT `PricingBase`.`id`, `PricingBase`.`product_id`, `PricingBase`.`price_dependency_id`, `PricingBase`.`price_dependency_definition`, `PricingBase`.`base_price`, `PricingBase`.`special_price`, `PricingBase`.`transport_price`, `PricingBase`.`created`, `PricingBase`.`modified`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `c1hajdurt`.`hajdu_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` = (91) | 0 | 0 | 0 | |
SELECT `PricingExtended`.`id`, `PricingExtended`.`product_id`, `PricingExtended`.`extra_charge_item_group_id`, `PricingExtended`.`extra_charge_item_id`, `PricingExtended`.`price_dependency_id`, `PricingExtended`.`price_dependency_definition`, `PricingExtended`.`price_as_group`, `PricingExtended`.`null_price`, `PricingExtended`.`price`, `PricingExtended`.`created`, `PricingExtended`.`modified` FROM `c1hajdurt`.`hajdu_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` = (91) | 0 | 0 | 0 | |
SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `c1hajdurt`.`hajdu_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` = (91) | 0 | 0 | 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`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1hajdurt`.`hajdu_product_categories` AS `ProductCategory` JOIN `c1hajdurt`.`hajdu_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` = 91 AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 1 | 1 | 1 | |
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 `ProductCategory`.`enabled` = '1' ORDER BY `ProductCategory`.`sort` ASC, `ProductCategory`.`created` ASC | 33 | 33 | 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 (58, 65, 66, 71, 74, 76, 81, 82, 83, 87, 88, 67, 93, 68, 79, 84, 69, 85, 50, 70, 73, 80, 89, 92, 51, 52, 91, 53, 54, 90, 56, 72, 86) AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 87 | 87 | 0 | |
SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `c1hajdurt`.`hajdu_product_comments` AS `ProductComment` WHERE `ProductComment`.`enabled` = '1' AND `ProductComment`.`product_id` = 91 | 0 | 0 | 0 | |
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `c1hajdurt`.`hajdu_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 80 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 1 = 1 AND `ProductCategory`.`lft` <= 42 AND `ProductCategory`.`rght` >= 43 ORDER BY `ProductCategory`.`lft` asc | 2 | 2 | 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`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__transport_time`.`content`) AS `Product__i18n_transport_time`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`I18n__specifications`.`content`) AS `Product__i18n_specifications`, (`I18n__seo_title`.`content`) AS `Product__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `Product__i18n_seo_desc`, (`I18n__seo_keyw`.`content`) AS `Product__i18n_seo_keyw`, (`I18n__enabled`.`content`) AS `Product__i18n_enabled`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `c1hajdurt`.`hajdu_products` AS `Product` LEFT JOIN `c1hajdurt`.`hajdu_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) inner JOIN `c1hajdurt`.`hajdu_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `Product`.`id` <> 91 AND `ProductsCategories`.`product_category_id` = 80) LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__name` ON (`Product`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Product' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__transport_time` ON (`Product`.`id` = `I18n__transport_time`.`foreign_key` AND `I18n__transport_time`.`model` = 'Product' AND `I18n__transport_time`.`field` = 'transport_time' AND `I18n__transport_time`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__details` ON (`Product`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'Product' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__specifications` ON (`Product`.`id` = `I18n__specifications`.`foreign_key` AND `I18n__specifications`.`model` = 'Product' AND `I18n__specifications`.`field` = 'specifications' AND `I18n__specifications`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__seo_title` ON (`Product`.`id` = `I18n__seo_title`.`foreign_key` AND `I18n__seo_title`.`model` = 'Product' AND `I18n__seo_title`.`field` = 'seo_title' AND `I18n__seo_title`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__seo_desc` ON (`Product`.`id` = `I18n__seo_desc`.`foreign_key` AND `I18n__seo_desc`.`model` = 'Product' AND `I18n__seo_desc`.`field` = 'seo_desc' AND `I18n__seo_desc`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__seo_keyw` ON (`Product`.`id` = `I18n__seo_keyw`.`foreign_key` AND `I18n__seo_keyw`.`model` = 'Product' AND `I18n__seo_keyw`.`field` = 'seo_keyw' AND `I18n__seo_keyw`.`locale` = 'hun') LEFT JOIN `c1hajdurt`.`hajdu_product_i18ns` AS `I18n__enabled` ON (`Product`.`id` = `I18n__enabled`.`foreign_key` AND `I18n__enabled`.`model` = 'Product' AND `I18n__enabled`.`field` = 'enabled' AND `I18n__enabled`.`locale` = 'hun') WHERE 1 = 1 ORDER BY rand() ASC LIMIT 3 | 3 | 3 | 11 | maybe slow |
SELECT `ProductPicture`.`id`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`sort` FROM `c1hajdurt`.`hajdu_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` IN (16, 15, 86) | 6 | 6 | 0 | |
SELECT `PricingBase`.`id`, `PricingBase`.`product_id`, `PricingBase`.`price_dependency_id`, `PricingBase`.`price_dependency_definition`, `PricingBase`.`base_price`, `PricingBase`.`special_price`, `PricingBase`.`transport_price`, `PricingBase`.`created`, `PricingBase`.`modified`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `c1hajdurt`.`hajdu_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` IN (16, 15, 86) | 0 | 0 | 0 | |
SELECT `PricingExtended`.`id`, `PricingExtended`.`product_id`, `PricingExtended`.`extra_charge_item_group_id`, `PricingExtended`.`extra_charge_item_id`, `PricingExtended`.`price_dependency_id`, `PricingExtended`.`price_dependency_definition`, `PricingExtended`.`price_as_group`, `PricingExtended`.`null_price`, `PricingExtended`.`price`, `PricingExtended`.`created`, `PricingExtended`.`modified` FROM `c1hajdurt`.`hajdu_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` IN (16, 15, 86) | 0 | 0 | 0 | |
SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `c1hajdurt`.`hajdu_product_comments` AS `ProductComment` WHERE `ProductComment`.`product_id` IN (16, 15, 86) | 0 | 0 | 0 | |
SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `c1hajdurt`.`hajdu_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` IN (16, 15, 86) | 0 | 0 | 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`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1hajdurt`.`hajdu_product_categories` AS `ProductCategory` JOIN `c1hajdurt`.`hajdu_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (16, 15, 86) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 3 | 3 | 0 | |
SELECT `Shelf`.`id`, `Shelf`.`user_id`, `Shelf`.`product_id` FROM `c1hajdurt`.`hajdu_shelf` AS `Shelf` WHERE `Shelf`.`user_id` IS NULL AND `Shelf`.`product_id` = 91 LIMIT 1 | 0 | 0 | 0 | |
SELECT `Download`.`id`, `Download`.`title`, `Download`.`details`, `Download`.`picture`, `Download`.`filename`, `Download`.`downloads`, `Download`.`enabled`, `Download`.`created`, `Download`.`modified` FROM `c1hajdurt`.`hajdu_downloads` AS `Download` WHERE `Download`.`id` IN (647, 648, 649, 650, 651, 659) | 6 | 6 | 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`, `DownloadCategoriesDownload`.`id`, `DownloadCategoriesDownload`.`download_id`, `DownloadCategoriesDownload`.`download_category_id` FROM `c1hajdurt`.`hajdu_download_categories` AS `DownloadCategory` JOIN `c1hajdurt`.`hajdu_download_categories_downloads` AS `DownloadCategoriesDownload` ON (`DownloadCategoriesDownload`.`download_id` IN (647, 648, 649, 650, 651, 659) AND `DownloadCategoriesDownload`.`download_category_id` = `DownloadCategory`.`id`) | 6 | 6 | 1 | maybe slow |
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` = '/termek/hajdu-ide-f-erp-sztea/91' 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` = 'PRODUCTS' 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 `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1hajdurt`.`hajdu_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Rövid leírás' 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` = 'Műszaki adatok' 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 | |