Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `GalleryGroup`.`id`, `GalleryGroup`.`name`, `GalleryGroup`.`sort`, (`I18n__name`.`content`) AS `GalleryGroup__i18n_name` FROM `c1nyirmix`.`nyirmix_gallery_groups` AS `GalleryGroup` LEFT JOIN `c1nyirmix`.`nyirmix_gallery_group_i18ns` AS `I18n__name` ON (`GalleryGroup`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'GalleryGroup' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'hun') WHERE 1 = 1 ORDER BY `GalleryGroup`.`sort` ASC | 2 | 2 | 0 | |
SELECT `GalleryPicture`.`id`, `GalleryPicture`.`gallery_group_id`, `GalleryPicture`.`picture`, `GalleryPicture`.`title`, `GalleryPicture`.`created` FROM `c1nyirmix`.`nyirmix_gallery_pictures` AS `GalleryPicture` WHERE `GalleryPicture`.`gallery_group_id` IN ('SECOND', 'MAIN') | 41 | 41 | 0 | |
SELECT `SiteSetting`.`id`, `SiteSetting`.`seo_title`, `SiteSetting`.`seo_description`, `SiteSetting`.`seo_keywords`, `SiteSetting`.`copyright` FROM `c1nyirmix`.`nyirmix_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 `c1nyirmix`.`nyirmix_route_based_seo` AS `RouteBasedSeo` WHERE `RouteBasedSeo`.`route_alias` = '/galeriak' 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 `c1nyirmix`.`nyirmix_contact_manager` AS `ContactManager` LEFT JOIN `c1nyirmix`.`nyirmix_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 `c1nyirmix`.`nyirmix_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 | 5 | 5 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1nyirmix`.`nyirmix_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Kezdőlap' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1nyirmix`.`nyirmix_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Galéria' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1nyirmix`.`nyirmix_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Üzemünk képekben' LIMIT 1 | 1 | 1 | 0 | |
SELECT `GalleryPicture`.`id`, `GalleryPicture`.`gallery_group_id`, `GalleryPicture`.`picture`, `GalleryPicture`.`title`, `GalleryPicture`.`created`, (`I18n__title`.`content`) AS `GalleryPicture__i18n_title` FROM `c1nyirmix`.`nyirmix_gallery_pictures` AS `GalleryPicture` LEFT JOIN `c1nyirmix`.`nyirmix_gallery_picture_i18ns` AS `I18n__title` ON (`GalleryPicture`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'GalleryPicture' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') WHERE `GalleryPicture`.`gallery_group_id` = 'SECOND' ORDER BY `GalleryPicture`.`id` ASC | 37 | 37 | 0 | |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link`, `CommunityProfile`.`api_code`, `CommunityProfile`.`button_code` FROM `c1nyirmix`.`nyirmix_community_profiles` AS `CommunityProfile` WHERE 1 = 1 | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1nyirmix`.`nyirmix_routes` AS `Route` LEFT JOIN `c1nyirmix`.`nyirmix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1nyirmix`.`nyirmix_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') 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1nyirmix`.`nyirmix_routes` AS `Route` LEFT JOIN `c1nyirmix`.`nyirmix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1nyirmix`.`nyirmix_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') WHERE `Route`.`menu_id` = 'CEG' | 3 | 3 | 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1nyirmix`.`nyirmix_routes` AS `Route` LEFT JOIN `c1nyirmix`.`nyirmix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1nyirmix`.`nyirmix_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') WHERE `Route`.`menu_id` = 'OTHERS' | 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` FROM `c1nyirmix`.`nyirmix_product_categories` AS `ProductCategory` LEFT JOIN `c1nyirmix`.`nyirmix_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 `c1nyirmix`.`nyirmix_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 `c1nyirmix`.`nyirmix_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 `c1nyirmix`.`nyirmix_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 `c1nyirmix`.`nyirmix_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') WHERE 1 = 1 ORDER BY `sort` ASC | 10 | 10 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1nyirmix`.`nyirmix_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Írja ide a keresendő kifejezést' LIMIT 1 | 1 | 1 | 0 | |