info@btandsons.hu
A kosara jelenleg üres.
A legfontosabb tényező nálunk a minőség, ezért termékeink CE minősítéssel és ISO tanúsítvánnyal rendelkeznek és a legszigorúbb minőség ellenőrzésen esnek át mielőtt elhagyják a gyárat. Ha a Lengyelkapu termékeit választja a rozsdával többé nem kell számolnia!
Termékeinket több mint 26 éves gyártási tapasztalat, precíz tervezés és innováció jellemzi
tovább...
A legfontosabb tényező nálunk a minőség, ezért termékeink CE minősítéssel és ISO tanúsítvánnyal rendelkeznek és a legszigorúbb minőség ellenőrzésen esnek át mielőtt elhagyják a gyárat. Ha a Lengyelkapu termékeit választja a rozsdával többé nem kell számolnia!
tovább...
Termékeinket több mint 26 éves gyártási tapasztalat, precíz tervezés és innováció jellemzi
tovább...
No post data.
No querystring data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `SiteSetting`.`id`, `SiteSetting`.`seo_title`, `SiteSetting`.`seo_description`, `SiteSetting`.`seo_keywords`, `SiteSetting`.`copyright` FROM `btandsons`.`btandsons_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 `btandsons`.`btandsons_route_based_seo` AS `RouteBasedSeo` WHERE `RouteBasedSeo`.`route_alias` = '/' 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 `btandsons`.`btandsons_contact_manager` AS `ContactManager` LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `SliderPicture`.`id`, `SliderPicture`.`slider_group_id`, `SliderPicture`.`title`, `SliderPicture`.`sub_title`, `SliderPicture`.`description`, `SliderPicture`.`link`, `SliderPicture`.`picture`, `SliderPicture`.`sort`, `SliderPicture`.`created`, `SliderPicture`.`modified`, (`I18n__title`.`content`) AS `SliderPicture__i18n_title`, (`I18n__sub_title`.`content`) AS `SliderPicture__i18n_sub_title`, (`I18n__description`.`content`) AS `SliderPicture__i18n_description`, (`I18n__link`.`content`) AS `SliderPicture__i18n_link` FROM `btandsons`.`btandsons_slider_pictures` AS `SliderPicture` LEFT JOIN `btandsons`.`btandsons_slider_picture_i18ns` AS `I18n__title` ON (`SliderPicture`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'SliderPicture' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `btandsons`.`btandsons_slider_picture_i18ns` AS `I18n__sub_title` ON (`SliderPicture`.`id` = `I18n__sub_title`.`foreign_key` AND `I18n__sub_title`.`model` = 'SliderPicture' AND `I18n__sub_title`.`field` = 'sub_title' AND `I18n__sub_title`.`locale` = 'hun') LEFT JOIN `btandsons`.`btandsons_slider_picture_i18ns` AS `I18n__description` ON (`SliderPicture`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'SliderPicture' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'hun') LEFT JOIN `btandsons`.`btandsons_slider_picture_i18ns` AS `I18n__link` ON (`SliderPicture`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'SliderPicture' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'hun') WHERE `SliderPicture`.`slider_group_id` = 'MAIN' ORDER BY `SliderPicture`.`sort` ASC, `SliderPicture`.`created` ASC | 0 | 0 | 0 | |
| SELECT `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `btandsons`.`btandsons_simple_blog_categories` AS `SimpleBlogCategory` WHERE 1 = 1 | 3 | 3 | 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`.`created`, `SimpleBlogEntry`.`sort` FROM `btandsons`.`btandsons_simple_blog_entries` AS `SimpleBlogEntry` WHERE `SimpleBlogEntry`.`simple_blog_category_id` IN ('MISSION', 'NEWS', 'SERVICES') | 10 | 10 | 0 | |
| SELECT `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `btandsons`.`btandsons_simple_blog_categories` AS `SimpleBlogCategory` WHERE `SimpleBlogCategory`.`id` = 'MISSION' LIMIT 1 | 1 | 1 | 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`.`created`, `SimpleBlogEntry`.`sort` FROM `btandsons`.`btandsons_simple_blog_entries` AS `SimpleBlogEntry` WHERE `SimpleBlogEntry`.`simple_blog_category_id` = ('MISSION') | 3 | 3 | 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`.`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 `btandsons`.`btandsons_simple_blog_entries` AS `SimpleBlogEntry` LEFT JOIN `btandsons`.`btandsons_simple_blog_categories` AS `SimpleBlogCategory` ON (`SimpleBlogEntry`.`simple_blog_category_id` = `SimpleBlogCategory`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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`.`simple_blog_category_id` = 'MISSION' ORDER BY `SimpleBlogEntry`.`created` DESC | 3 | 3 | 0 | |
| SELECT `SimpleBlogComment`.`id`, `SimpleBlogComment`.`simple_blog_entry_id`, `SimpleBlogComment`.`name`, `SimpleBlogComment`.`email`, `SimpleBlogComment`.`message`, `SimpleBlogComment`.`enabled`, `SimpleBlogComment`.`created` FROM `btandsons`.`btandsons_simple_blog_comments` AS `SimpleBlogComment` WHERE `SimpleBlogComment`.`enabled` = '1' AND `SimpleBlogComment`.`simple_blog_entry_id` IN (8, 7, 6) | 0 | 0 | 0 | |
| SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`short_id` = 'PRODUCTDETAILS' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Kiemelt termékeink' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `UserGroup`.`id`, `UserGroup`.`profile_schema_id`, `UserGroup`.`title`, `UserGroup`.`use_for_registration`, `UserGroup`.`can_enter_ecp_admin`, `UserGroup`.`can_change_engine_settings`, `UserGroup`.`created`, `UserGroup`.`modified`, `UserGroup`.`can_handle_users`, `UserGroup`.`can_handle_user_groups`, `UserGroup`.`can_handle_documents`, `UserGroup`.`can_handle_products`, `UserGroup`.`can_handle_offer_requests`, `ProfileSchema`.`id`, `ProfileSchema`.`title`, `ProfileSchema`.`definition` FROM `btandsons`.`btandsons_user_groups` AS `UserGroup` LEFT JOIN `btandsons`.`btandsons_profile_schemas` AS `ProfileSchema` ON (`UserGroup`.`profile_schema_id` = `ProfileSchema`.`id`) WHERE `UserGroup`.`use_for_registration` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`sap`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `btandsons`.`btandsons_users` AS `User` WHERE `User`.`user_group_id` = (2) | 902 | 902 | 2 | |
| 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`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`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`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `btandsons`.`btandsons_products` AS `Product` LEFT JOIN `btandsons`.`btandsons_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Product`.`enabled` = '1' AND `Product`.`featured_product` = '1' ORDER BY rand() ASC LIMIT 10 | 10 | 10 | 470 | maybe slow |
| SELECT `ProductPicture`.`id`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`sort` FROM `btandsons`.`btandsons_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` IN (41, 160, 13, 119, 29, 195, 92, 21, 106, 81) | 22 | 22 | 1 | |
| 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`, `PricingBase`.`sort`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `btandsons`.`btandsons_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` IN (41, 160, 13, 119, 29, 195, 92, 21, 106, 81) | 10 | 10 | 1 | maybe slow |
| 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 `btandsons`.`btandsons_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` IN (41, 160, 13, 119, 29, 195, 92, 21, 106, 81) | 0 | 0 | 0 | |
| SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `btandsons`.`btandsons_product_comments` AS `ProductComment` WHERE `ProductComment`.`product_id` IN (41, 160, 13, 119, 29, 195, 92, 21, 106, 81) | 0 | 0 | 0 | |
| SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `btandsons`.`btandsons_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` IN (41, 160, 13, 119, 29, 195, 92, 21, 106, 81) | 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`.`icon`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id`, `ProductCategoriesProduct`.`sort` FROM `btandsons`.`btandsons_product_categories` AS `ProductCategory` JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (41, 160, 13, 119, 29, 195, 92, 21, 106, 81) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 19 | 19 | 1 | maybe slow |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Szolgáltatásaink' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `btandsons`.`btandsons_simple_blog_categories` AS `SimpleBlogCategory` WHERE 1 = 1 | 3 | 3 | 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`.`created`, `SimpleBlogEntry`.`sort` FROM `btandsons`.`btandsons_simple_blog_entries` AS `SimpleBlogEntry` WHERE `SimpleBlogEntry`.`simple_blog_category_id` IN ('MISSION', 'NEWS', 'SERVICES') | 10 | 10 | 0 | |
| SELECT `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `btandsons`.`btandsons_simple_blog_categories` AS `SimpleBlogCategory` WHERE `SimpleBlogCategory`.`id` = 'SERVICES' LIMIT 1 | 1 | 1 | 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`.`created`, `SimpleBlogEntry`.`sort` FROM `btandsons`.`btandsons_simple_blog_entries` AS `SimpleBlogEntry` WHERE `SimpleBlogEntry`.`simple_blog_category_id` = ('SERVICES') | 6 | 6 | 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`.`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 `btandsons`.`btandsons_simple_blog_entries` AS `SimpleBlogEntry` LEFT JOIN `btandsons`.`btandsons_simple_blog_categories` AS `SimpleBlogCategory` ON (`SimpleBlogEntry`.`simple_blog_category_id` = `SimpleBlogCategory`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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`.`simple_blog_category_id` = 'SERVICES' ORDER BY `SimpleBlogEntry`.`created` DESC | 6 | 6 | 0 | |
| SELECT `SimpleBlogComment`.`id`, `SimpleBlogComment`.`simple_blog_entry_id`, `SimpleBlogComment`.`name`, `SimpleBlogComment`.`email`, `SimpleBlogComment`.`message`, `SimpleBlogComment`.`enabled`, `SimpleBlogComment`.`created` FROM `btandsons`.`btandsons_simple_blog_comments` AS `SimpleBlogComment` WHERE `SimpleBlogComment`.`enabled` = '1' AND `SimpleBlogComment`.`simple_blog_entry_id` IN (14, 13, 12, 11, 10, 9) | 0 | 0 | 0 | |
| SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`short_id` = 'NEWSDETAILS' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Friss hírek, aktualitások' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `btandsons`.`btandsons_simple_blog_categories` AS `SimpleBlogCategory` WHERE 1 = 1 | 3 | 3 | 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`.`created`, `SimpleBlogEntry`.`sort` FROM `btandsons`.`btandsons_simple_blog_entries` AS `SimpleBlogEntry` WHERE `SimpleBlogEntry`.`simple_blog_category_id` IN ('MISSION', 'NEWS', 'SERVICES') | 10 | 10 | 0 | |
| SELECT `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `btandsons`.`btandsons_simple_blog_categories` AS `SimpleBlogCategory` WHERE `SimpleBlogCategory`.`id` = 'NEWS' LIMIT 1 | 1 | 1 | 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`.`created`, `SimpleBlogEntry`.`sort` FROM `btandsons`.`btandsons_simple_blog_entries` AS `SimpleBlogEntry` WHERE `SimpleBlogEntry`.`simple_blog_category_id` = ('NEWS') | 1 | 1 | 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`.`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 `btandsons`.`btandsons_simple_blog_entries` AS `SimpleBlogEntry` LEFT JOIN `btandsons`.`btandsons_simple_blog_categories` AS `SimpleBlogCategory` ON (`SimpleBlogEntry`.`simple_blog_category_id` = `SimpleBlogCategory`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 NOT (`SimpleBlogEntry`.`simple_blog_category_id` IN ('BLOG', 'EVENTS', 'SUCCESSES')) ORDER BY `SimpleBlogEntry`.`created` DESC | 10 | 10 | 0 | |
| SELECT `SimpleBlogComment`.`id`, `SimpleBlogComment`.`simple_blog_entry_id`, `SimpleBlogComment`.`name`, `SimpleBlogComment`.`email`, `SimpleBlogComment`.`message`, `SimpleBlogComment`.`enabled`, `SimpleBlogComment`.`created` FROM `btandsons`.`btandsons_simple_blog_comments` AS `SimpleBlogComment` WHERE `SimpleBlogComment`.`enabled` = '1' AND `SimpleBlogComment`.`simple_blog_entry_id` IN (15, 14, 13, 12, 11, 10, 9, 8, 7, 6) | 0 | 0 | 1 | maybe slow |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'tovább...' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'tovább...' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'tovább...' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'tovább...' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'tovább...' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'tovább...' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'tovább...' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'tovább...' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'tovább...' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'tovább...' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Iratkozzon fel hírlevelünkre!' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Iratkozzon fel e-mail címével és értesüljön akcióinkról, újdonságainkról első kézből!' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Írja ide e-mail címét' 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`short_id` = 'GDPR' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Feliratkozás' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link`, `CommunityProfile`.`api_code`, `CommunityProfile`.`button_code` FROM `btandsons`.`btandsons_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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`menu_id` = 'LOGIN' | 2 | 2 | 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`menu_id` = 'MAINMENU' | 4 | 4 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Nyitvatartás' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Termékeink' 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`short_id` = 'PRODUCTDETAILS' 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `UserGroup`.`id`, `UserGroup`.`profile_schema_id`, `UserGroup`.`title`, `UserGroup`.`use_for_registration`, `UserGroup`.`can_enter_ecp_admin`, `UserGroup`.`can_change_engine_settings`, `UserGroup`.`created`, `UserGroup`.`modified`, `UserGroup`.`can_handle_users`, `UserGroup`.`can_handle_user_groups`, `UserGroup`.`can_handle_documents`, `UserGroup`.`can_handle_products`, `UserGroup`.`can_handle_offer_requests`, `ProfileSchema`.`id`, `ProfileSchema`.`title`, `ProfileSchema`.`definition` FROM `btandsons`.`btandsons_user_groups` AS `UserGroup` LEFT JOIN `btandsons`.`btandsons_profile_schemas` AS `ProfileSchema` ON (`UserGroup`.`profile_schema_id` = `ProfileSchema`.`id`) WHERE `UserGroup`.`use_for_registration` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`sap`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `btandsons`.`btandsons_users` AS `User` WHERE `User`.`user_group_id` = (2) | 902 | 902 | 2 | |
| 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`.`icon`, `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 `btandsons`.`btandsons_product_categories` AS `ProductCategory` LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `enabled` = '1' ORDER BY `sort` 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`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id`, `ProductCategoriesProduct`.`sort` FROM `btandsons`.`btandsons_products` AS `Product` JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` IN (1, 2, 3, 4, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37, 38) AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 392 | 392 | 1 | |
| SELECT `UserGroup`.`id`, `UserGroup`.`profile_schema_id`, `UserGroup`.`title`, `UserGroup`.`use_for_registration`, `UserGroup`.`can_enter_ecp_admin`, `UserGroup`.`can_change_engine_settings`, `UserGroup`.`created`, `UserGroup`.`modified`, `UserGroup`.`can_handle_users`, `UserGroup`.`can_handle_user_groups`, `UserGroup`.`can_handle_documents`, `UserGroup`.`can_handle_products`, `UserGroup`.`can_handle_offer_requests`, `ProfileSchema`.`id`, `ProfileSchema`.`title`, `ProfileSchema`.`definition` FROM `btandsons`.`btandsons_user_groups` AS `UserGroup` LEFT JOIN `btandsons`.`btandsons_profile_schemas` AS `ProfileSchema` ON (`UserGroup`.`profile_schema_id` = `ProfileSchema`.`id`) WHERE `UserGroup`.`use_for_registration` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`sap`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `btandsons`.`btandsons_users` AS `User` WHERE `User`.`user_group_id` = (2) | 902 | 902 | 2 | |
| 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`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`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`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `btandsons`.`btandsons_products` AS `Product` LEFT JOIN `btandsons`.`btandsons_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) inner JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `Product`.`enabled` = '1' AND `Product`.`featured_product` = '1' AND `ProductsCategories`.`product_category_id` = '1') LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE 1 = 1 GROUP BY `Product`.`id` ORDER BY rand() ASC LIMIT 3 | 3 | 3 | 85 | maybe slow |
| SELECT `ProductPicture`.`id`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`sort` FROM `btandsons`.`btandsons_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` IN (30, 25, 85) | 10 | 10 | 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`, `PricingBase`.`sort`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `btandsons`.`btandsons_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` IN (30, 25, 85) | 3 | 3 | 1 | maybe slow |
| 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 `btandsons`.`btandsons_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` IN (30, 25, 85) | 0 | 0 | 0 | |
| SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `btandsons`.`btandsons_product_comments` AS `ProductComment` WHERE `ProductComment`.`product_id` IN (30, 25, 85) | 0 | 0 | 0 | |
| SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `btandsons`.`btandsons_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` IN (30, 25, 85) | 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`.`icon`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id`, `ProductCategoriesProduct`.`sort` FROM `btandsons`.`btandsons_product_categories` AS `ProductCategory` JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (30, 25, 85) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 7 | 7 | 1 | maybe slow |
| SELECT `UserGroup`.`id`, `UserGroup`.`profile_schema_id`, `UserGroup`.`title`, `UserGroup`.`use_for_registration`, `UserGroup`.`can_enter_ecp_admin`, `UserGroup`.`can_change_engine_settings`, `UserGroup`.`created`, `UserGroup`.`modified`, `UserGroup`.`can_handle_users`, `UserGroup`.`can_handle_user_groups`, `UserGroup`.`can_handle_documents`, `UserGroup`.`can_handle_products`, `UserGroup`.`can_handle_offer_requests`, `ProfileSchema`.`id`, `ProfileSchema`.`title`, `ProfileSchema`.`definition` FROM `btandsons`.`btandsons_user_groups` AS `UserGroup` LEFT JOIN `btandsons`.`btandsons_profile_schemas` AS `ProfileSchema` ON (`UserGroup`.`profile_schema_id` = `ProfileSchema`.`id`) WHERE `UserGroup`.`use_for_registration` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`sap`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `btandsons`.`btandsons_users` AS `User` WHERE `User`.`user_group_id` = (2) | 902 | 902 | 2 | |
| 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`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`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`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `btandsons`.`btandsons_products` AS `Product` LEFT JOIN `btandsons`.`btandsons_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) inner JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `Product`.`enabled` = '1' AND `Product`.`featured_product` = '1' AND `ProductsCategories`.`product_category_id` = '9') LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE 1 = 1 GROUP BY `Product`.`id` ORDER BY rand() ASC LIMIT 3 | 3 | 3 | 104 | maybe slow |
| SELECT `ProductPicture`.`id`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`sort` FROM `btandsons`.`btandsons_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` IN (150, 171, 169) | 0 | 0 | 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`, `PricingBase`.`sort`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `btandsons`.`btandsons_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` IN (150, 171, 169) | 3 | 3 | 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 `btandsons`.`btandsons_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` IN (150, 171, 169) | 0 | 0 | 0 | |
| SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `btandsons`.`btandsons_product_comments` AS `ProductComment` WHERE `ProductComment`.`product_id` IN (150, 171, 169) | 0 | 0 | 0 | |
| SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `btandsons`.`btandsons_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` IN (150, 171, 169) | 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`.`icon`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id`, `ProductCategoriesProduct`.`sort` FROM `btandsons`.`btandsons_product_categories` AS `ProductCategory` JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (150, 171, 169) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 6 | 6 | 1 | maybe slow |
| SELECT `UserGroup`.`id`, `UserGroup`.`profile_schema_id`, `UserGroup`.`title`, `UserGroup`.`use_for_registration`, `UserGroup`.`can_enter_ecp_admin`, `UserGroup`.`can_change_engine_settings`, `UserGroup`.`created`, `UserGroup`.`modified`, `UserGroup`.`can_handle_users`, `UserGroup`.`can_handle_user_groups`, `UserGroup`.`can_handle_documents`, `UserGroup`.`can_handle_products`, `UserGroup`.`can_handle_offer_requests`, `ProfileSchema`.`id`, `ProfileSchema`.`title`, `ProfileSchema`.`definition` FROM `btandsons`.`btandsons_user_groups` AS `UserGroup` LEFT JOIN `btandsons`.`btandsons_profile_schemas` AS `ProfileSchema` ON (`UserGroup`.`profile_schema_id` = `ProfileSchema`.`id`) WHERE `UserGroup`.`use_for_registration` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`sap`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `btandsons`.`btandsons_users` AS `User` WHERE `User`.`user_group_id` = (2) | 902 | 902 | 2 | |
| 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`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`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`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `btandsons`.`btandsons_products` AS `Product` LEFT JOIN `btandsons`.`btandsons_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) inner JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `Product`.`enabled` = '1' AND `Product`.`featured_product` = '1' AND `ProductsCategories`.`product_category_id` = '10') LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE 1 = 1 GROUP BY `Product`.`id` ORDER BY rand() ASC LIMIT 3 | 3 | 3 | 101 | maybe slow |
| SELECT `ProductPicture`.`id`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`sort` FROM `btandsons`.`btandsons_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` IN (113, 33, 124) | 3 | 3 | 2 | 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`, `PricingBase`.`sort`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `btandsons`.`btandsons_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` IN (113, 33, 124) | 4 | 4 | 1 | maybe slow |
| 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 `btandsons`.`btandsons_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` IN (113, 33, 124) | 0 | 0 | 1 | maybe slow |
| SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `btandsons`.`btandsons_product_comments` AS `ProductComment` WHERE `ProductComment`.`product_id` IN (113, 33, 124) | 0 | 0 | 0 | |
| SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `btandsons`.`btandsons_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` IN (113, 33, 124) | 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`.`icon`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id`, `ProductCategoriesProduct`.`sort` FROM `btandsons`.`btandsons_product_categories` AS `ProductCategory` JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (113, 33, 124) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 6 | 6 | 1 | maybe slow |
| SELECT `UserGroup`.`id`, `UserGroup`.`profile_schema_id`, `UserGroup`.`title`, `UserGroup`.`use_for_registration`, `UserGroup`.`can_enter_ecp_admin`, `UserGroup`.`can_change_engine_settings`, `UserGroup`.`created`, `UserGroup`.`modified`, `UserGroup`.`can_handle_users`, `UserGroup`.`can_handle_user_groups`, `UserGroup`.`can_handle_documents`, `UserGroup`.`can_handle_products`, `UserGroup`.`can_handle_offer_requests`, `ProfileSchema`.`id`, `ProfileSchema`.`title`, `ProfileSchema`.`definition` FROM `btandsons`.`btandsons_user_groups` AS `UserGroup` LEFT JOIN `btandsons`.`btandsons_profile_schemas` AS `ProfileSchema` ON (`UserGroup`.`profile_schema_id` = `ProfileSchema`.`id`) WHERE `UserGroup`.`use_for_registration` = '1' LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `User`.`id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`sap`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `btandsons`.`btandsons_users` AS `User` WHERE `User`.`user_group_id` = (2) | 902 | 902 | 3 | |
| 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`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`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`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `btandsons`.`btandsons_products` AS `Product` LEFT JOIN `btandsons`.`btandsons_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) inner JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `Product`.`enabled` = '1' AND `Product`.`featured_product` = '1' AND `ProductsCategories`.`product_category_id` = '11') LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE 1 = 1 GROUP BY `Product`.`id` ORDER BY rand() ASC LIMIT 3 | 0 | 0 | 2 | maybe slow |
| SELECT `UserGroup`.`id`, `UserGroup`.`profile_schema_id`, `UserGroup`.`title`, `UserGroup`.`use_for_registration`, `UserGroup`.`can_enter_ecp_admin`, `UserGroup`.`can_change_engine_settings`, `UserGroup`.`created`, `UserGroup`.`modified`, `UserGroup`.`can_handle_users`, `UserGroup`.`can_handle_user_groups`, `UserGroup`.`can_handle_documents`, `UserGroup`.`can_handle_products`, `UserGroup`.`can_handle_offer_requests`, `ProfileSchema`.`id`, `ProfileSchema`.`title`, `ProfileSchema`.`definition` FROM `btandsons`.`btandsons_user_groups` AS `UserGroup` LEFT JOIN `btandsons`.`btandsons_profile_schemas` AS `ProfileSchema` ON (`UserGroup`.`profile_schema_id` = `ProfileSchema`.`id`) WHERE `UserGroup`.`use_for_registration` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`sap`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `btandsons`.`btandsons_users` AS `User` WHERE `User`.`user_group_id` = (2) | 902 | 902 | 1 | |
| 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`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`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`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `btandsons`.`btandsons_products` AS `Product` LEFT JOIN `btandsons`.`btandsons_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) inner JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `Product`.`enabled` = '1' AND `Product`.`featured_product` = '1' AND `ProductsCategories`.`product_category_id` = '12') LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE 1 = 1 GROUP BY `Product`.`id` ORDER BY rand() ASC LIMIT 3 | 3 | 3 | 34 | maybe slow |
| SELECT `ProductPicture`.`id`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`sort` FROM `btandsons`.`btandsons_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` IN (63, 70, 61) | 12 | 12 | 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`, `PricingBase`.`sort`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `btandsons`.`btandsons_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` IN (63, 70, 61) | 3 | 3 | 1 | maybe slow |
| 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 `btandsons`.`btandsons_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` IN (63, 70, 61) | 0 | 0 | 0 | |
| SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `btandsons`.`btandsons_product_comments` AS `ProductComment` WHERE `ProductComment`.`product_id` IN (63, 70, 61) | 0 | 0 | 0 | |
| SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `btandsons`.`btandsons_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` IN (63, 70, 61) | 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`.`icon`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id`, `ProductCategoriesProduct`.`sort` FROM `btandsons`.`btandsons_product_categories` AS `ProductCategory` JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (63, 70, 61) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 6 | 6 | 1 | maybe slow |
| SELECT `UserGroup`.`id`, `UserGroup`.`profile_schema_id`, `UserGroup`.`title`, `UserGroup`.`use_for_registration`, `UserGroup`.`can_enter_ecp_admin`, `UserGroup`.`can_change_engine_settings`, `UserGroup`.`created`, `UserGroup`.`modified`, `UserGroup`.`can_handle_users`, `UserGroup`.`can_handle_user_groups`, `UserGroup`.`can_handle_documents`, `UserGroup`.`can_handle_products`, `UserGroup`.`can_handle_offer_requests`, `ProfileSchema`.`id`, `ProfileSchema`.`title`, `ProfileSchema`.`definition` FROM `btandsons`.`btandsons_user_groups` AS `UserGroup` LEFT JOIN `btandsons`.`btandsons_profile_schemas` AS `ProfileSchema` ON (`UserGroup`.`profile_schema_id` = `ProfileSchema`.`id`) WHERE `UserGroup`.`use_for_registration` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`sap`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `btandsons`.`btandsons_users` AS `User` WHERE `User`.`user_group_id` = (2) | 902 | 902 | 2 | |
| 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`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`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`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `btandsons`.`btandsons_products` AS `Product` LEFT JOIN `btandsons`.`btandsons_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) inner JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `Product`.`enabled` = '1' AND `Product`.`featured_product` = '1' AND `ProductsCategories`.`product_category_id` = '13') LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE 1 = 1 GROUP BY `Product`.`id` ORDER BY rand() ASC LIMIT 3 | 3 | 3 | 13 | maybe slow |
| SELECT `ProductPicture`.`id`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`sort` FROM `btandsons`.`btandsons_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` IN (71, 72, 73) | 9 | 9 | 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`, `PricingBase`.`sort`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `btandsons`.`btandsons_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` IN (71, 72, 73) | 3 | 3 | 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 `btandsons`.`btandsons_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` IN (71, 72, 73) | 0 | 0 | 0 | |
| SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `btandsons`.`btandsons_product_comments` AS `ProductComment` WHERE `ProductComment`.`product_id` IN (71, 72, 73) | 0 | 0 | 0 | |
| SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `btandsons`.`btandsons_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` IN (71, 72, 73) | 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`.`icon`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id`, `ProductCategoriesProduct`.`sort` FROM `btandsons`.`btandsons_product_categories` AS `ProductCategory` JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (71, 72, 73) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 9 | 9 | 0 | |
| SELECT `UserGroup`.`id`, `UserGroup`.`profile_schema_id`, `UserGroup`.`title`, `UserGroup`.`use_for_registration`, `UserGroup`.`can_enter_ecp_admin`, `UserGroup`.`can_change_engine_settings`, `UserGroup`.`created`, `UserGroup`.`modified`, `UserGroup`.`can_handle_users`, `UserGroup`.`can_handle_user_groups`, `UserGroup`.`can_handle_documents`, `UserGroup`.`can_handle_products`, `UserGroup`.`can_handle_offer_requests`, `ProfileSchema`.`id`, `ProfileSchema`.`title`, `ProfileSchema`.`definition` FROM `btandsons`.`btandsons_user_groups` AS `UserGroup` LEFT JOIN `btandsons`.`btandsons_profile_schemas` AS `ProfileSchema` ON (`UserGroup`.`profile_schema_id` = `ProfileSchema`.`id`) WHERE `UserGroup`.`use_for_registration` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `User`.`id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`sap`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `btandsons`.`btandsons_users` AS `User` WHERE `User`.`user_group_id` = (2) | 902 | 902 | 2 | |
| 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`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`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`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `btandsons`.`btandsons_products` AS `Product` LEFT JOIN `btandsons`.`btandsons_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) inner JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `Product`.`enabled` = '1' AND `Product`.`featured_product` = '1' AND `ProductsCategories`.`product_category_id` = '14') LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE 1 = 1 GROUP BY `Product`.`id` ORDER BY rand() ASC LIMIT 3 | 1 | 1 | 8 | maybe slow |
| SELECT `ProductPicture`.`id`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`sort` FROM `btandsons`.`btandsons_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` = (75) | 3 | 3 | 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`, `PricingBase`.`sort`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `btandsons`.`btandsons_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` = (75) | 1 | 1 | 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 `btandsons`.`btandsons_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` = (75) | 0 | 0 | 0 | |
| SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `btandsons`.`btandsons_product_comments` AS `ProductComment` WHERE `ProductComment`.`product_id` = (75) | 0 | 0 | 0 | |
| SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `btandsons`.`btandsons_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` = (75) | 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`.`icon`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id`, `ProductCategoriesProduct`.`sort` FROM `btandsons`.`btandsons_product_categories` AS `ProductCategory` JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` = 75 AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 3 | 3 | 1 | maybe slow |
| SELECT `UserGroup`.`id`, `UserGroup`.`profile_schema_id`, `UserGroup`.`title`, `UserGroup`.`use_for_registration`, `UserGroup`.`can_enter_ecp_admin`, `UserGroup`.`can_change_engine_settings`, `UserGroup`.`created`, `UserGroup`.`modified`, `UserGroup`.`can_handle_users`, `UserGroup`.`can_handle_user_groups`, `UserGroup`.`can_handle_documents`, `UserGroup`.`can_handle_products`, `UserGroup`.`can_handle_offer_requests`, `ProfileSchema`.`id`, `ProfileSchema`.`title`, `ProfileSchema`.`definition` FROM `btandsons`.`btandsons_user_groups` AS `UserGroup` LEFT JOIN `btandsons`.`btandsons_profile_schemas` AS `ProfileSchema` ON (`UserGroup`.`profile_schema_id` = `ProfileSchema`.`id`) WHERE `UserGroup`.`use_for_registration` = '1' LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `User`.`id`, `User`.`user_group_id`, `User`.`username`, `User`.`email`, `User`.`sap`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `btandsons`.`btandsons_users` AS `User` WHERE `User`.`user_group_id` = (2) | 902 | 902 | 4 | |
| 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`.`product_profile_id`, `Product`.`profile_data`, `Product`.`new_product`, `Product`.`featured_product`, `Product`.`popular_product`, `Product`.`for_offer_request`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__details`.`content`) AS `Product__i18n_details`, (`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`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `btandsons`.`btandsons_products` AS `Product` LEFT JOIN `btandsons`.`btandsons_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) inner JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `Product`.`enabled` = '1' AND `Product`.`featured_product` = '1' AND `ProductsCategories`.`product_category_id` = '38') LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE 1 = 1 GROUP BY `Product`.`id` ORDER BY rand() ASC LIMIT 3 | 3 | 3 | 65 | maybe slow |
| SELECT `ProductPicture`.`id`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`sort` FROM `btandsons`.`btandsons_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` IN (96, 77, 90) | 15 | 15 | 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`, `PricingBase`.`sort`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `btandsons`.`btandsons_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` IN (96, 77, 90) | 3 | 3 | 1 | maybe slow |
| 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 `btandsons`.`btandsons_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` IN (96, 77, 90) | 0 | 0 | 0 | |
| SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `btandsons`.`btandsons_product_comments` AS `ProductComment` WHERE `ProductComment`.`product_id` IN (96, 77, 90) | 0 | 0 | 0 | |
| SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `btandsons`.`btandsons_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` IN (96, 77, 90) | 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`.`icon`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id`, `ProductCategoriesProduct`.`sort` FROM `btandsons`.`btandsons_product_categories` AS `ProductCategory` JOIN `btandsons`.`btandsons_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (96, 77, 90) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 9 | 9 | 1 | maybe slow |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Termék vagy kifejezés keresése...' 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`short_id` = 'PRODUCTDETAILS' 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`short_id` = 'OVERVIEW' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'termék' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'A kosara jelenleg üres.' 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`menu_id` = 'MOBILE' | 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') 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`.`icon`, `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 `btandsons`.`btandsons_product_categories` AS `ProductCategory` LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 | 33 | 33 | 1 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Hasznos linkek' LIMIT 1 | 1 | 1 | 1 | |
| 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`menu_id` = 'USEFUL' | 4 | 4 | 0 | |
| SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link`, `CommunityProfile`.`api_code`, `CommunityProfile`.`button_code` FROM `btandsons`.`btandsons_community_profiles` AS `CommunityProfile` WHERE `CommunityProfile`.`short_id` = 'facebook' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link`, `CommunityProfile`.`api_code`, `CommunityProfile`.`button_code` FROM `btandsons`.`btandsons_community_profiles` AS `CommunityProfile` WHERE 1 = 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Rólunk' 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`menu_id` = 'ABOUT' | 3 | 3 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Fizetés' 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 `btandsons`.`btandsons_static_pages` AS `StaticPage` LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `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 `btandsons`.`btandsons_static_pages` AS `StaticPage` LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `btandsons`.`btandsons_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 `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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `btandsons`.`btandsons_routes` AS `Route` LEFT JOIN `btandsons`.`btandsons_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `btandsons`.`btandsons_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 `btandsons`.`btandsons_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') WHERE `Route`.`short_id` = 'COOKIE' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Tudjon meg még többet.' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Elfogadom a Cookie-kat' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `btandsons`.`btandsons_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Nem, nem járulok hozzá' LIMIT 1 | 1 | 1 | 0 |
Peak Memory Use 23.46 MB
| Message | Memory use |
|---|---|
| Component initialization | 1.44 MB |
| Controller action start | 2.38 MB |
| Controller render start | 2.46 MB |
| Component initialization #2 | 3.36 MB |
| Controller action start #2 | 3.40 MB |
| Component initialization #3 | 3.79 MB |
| Controller action start #3 | 4.22 MB |
| Component initialization #4 | 4.89 MB |
| Controller action start #4 | 5.67 MB |
| Component initialization #5 | 6.56 MB |
| Controller action start #5 | 6.65 MB |
| Component initialization #6 | 6.75 MB |
| Controller action start #6 | 6.85 MB |
| Component initialization #7 | 7.22 MB |
| Controller action start #7 | 7.34 MB |
| Component initialization #8 | 9.86 MB |
| Controller action start #8 | 9.97 MB |
| Component initialization #9 | 10.14 MB |
| Controller action start #9 | 10.26 MB |
| Component initialization #10 | 10.42 MB |
| Controller action start #10 | 10.54 MB |
| Component initialization #11 | 10.70 MB |
| Controller action start #11 | 10.82 MB |
| Component initialization #12 | 10.92 MB |
| Controller action start #12 | 11.03 MB |
| Component initialization #13 | 11.28 MB |
| Controller action start #13 | 11.40 MB |
| Component initialization #14 | 11.58 MB |
| Controller action start #14 | 11.70 MB |
| Component initialization #15 | 11.82 MB |
| Controller action start #15 | 11.94 MB |
| Component initialization #16 | 12.16 MB |
| Controller action start #16 | 12.41 MB |
| Component initialization #17 | 12.51 MB |
| Controller action start #17 | 12.58 MB |
| Component initialization #18 | 12.72 MB |
| Controller action start #18 | 12.80 MB |
| View render complete | 12.76 MB |
Total Request Time: 1711 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 11.00 | |
| Event: Controller.initialize | 5.52 | |
| Event: Controller.startup | 0.75 | |
| Controller action | 0.73 | |
| Event: Controller.beforeRender | 69.09 | |
| » Processing toolbar data | 64.89 | |
| Rendering View | 1450.22 | |
| » Event: View.beforeRender | 2.17 | |
| » Rendering APP/View/StaticPages/home.ctp | 614.70 | |
| » » Rendering ROOT/plugins/Slider/View/Elements/slider.ctp | 10.89 | |
| » » » Event: Controller.initialize #2 | 0.37 | |
| » » » Event: Controller.startup #2 | 0.14 | |
| Controller action #2 | 0.00 | |
| » » » » Event: Controller.shutdown | 0.09 | |
| » » » Rendering ROOT/plugins/SimpleBlog/View/Elements/mission.ctp | 20.90 | |
| » » » » Event: Controller.initialize #3 | 9.24 | |
| » » » » Event: Controller.startup #3 | 0.26 | |
| Controller action #3 | 0.00 | |
| » » » » » Event: Controller.shutdown #2 | 0.09 | |
| » » » » Rendering ROOT/plugins/Webshop/View/Elements/featured_products.ctp | 535.90 | |
| » » » » » Event: Controller.initialize #4 | 24.74 | |
| » » » » » Event: Controller.startup #4 | 0.37 | |
| Controller action #4 | 0.00 | |
| » » » » » » Event: Controller.shutdown #3 | 0.12 | |
| » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp | 0.70 | |
| » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #2 | 0.59 | |
| » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #3 | 0.50 | |
| » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #4 | 0.48 | |
| » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #5 | 0.52 | |
| » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #6 | 0.54 | |
| » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #7 | 0.81 | |
| » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #8 | 0.56 | |
| » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #9 | 0.55 | |
| » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #10 | 0.89 | |
| » » » » » Rendering ROOT/plugins/SimpleBlog/View/Elements/services.ctp | 21.57 | |
| » » » » » » Event: Controller.initialize #5 | 9.84 | |
| » » » » » » Event: Controller.startup #5 | 0.34 | |
| Controller action #5 | 0.00 | |
| » » » » » » » Event: Controller.shutdown #4 | 0.14 | |
| » » » » » » Rendering ROOT/plugins/SimpleBlog/View/Elements/simple_blog_entries_box.ctp | 20.04 | |
| » » » » » » » Event: Controller.initialize #6 | 3.05 | |
| » » » » » » » Event: Controller.startup #6 | 0.29 | |
| Controller action #6 | 0.00 | |
| » » » » » » » » Event: Controller.shutdown #5 | 0.11 | |
| » » » » » » Event: View.afterRender | 0.05 | |
| » » » » » » Event: View.beforeLayout | 0.05 | |
| » » » » » » Rendering APP/View/Layouts/default.ctp | 831.91 | |
| » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/patchwork.ctp | 777.26 | |
| » » » » » » » » Event: Controller.initialize #7 | 16.34 | |
| » » » » » » » » Event: Controller.startup #7 | 0.33 | |
| Controller action #7 | 0.00 | |
| » » » » » » » » » Event: Controller.shutdown #6 | 0.10 | |
| » » » » » » » » » Event: Controller.initialize #8 | 18.94 | |
| » » » » » » » » » Event: Controller.startup #8 | 0.32 | |
| Controller action #8 | 0.00 | |
| » » » » » » » » » » Event: Controller.shutdown #7 | 0.13 | |
| » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #11 | 0.76 | |
| » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #12 | 0.57 | |
| » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #13 | 0.85 | |
| » » » » » » » » » » Event: Controller.initialize #9 | 28.79 | |
| » » » » » » » » » » Event: Controller.startup #9 | 0.47 | |
| Controller action #9 | 0.00 | |
| » » » » » » » » » » » Event: Controller.shutdown #8 | 0.11 | |
| » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #14 | 0.66 | |
| » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #15 | 0.53 | |
| » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #16 | 0.66 | |
| » » » » » » » » » » » Event: Controller.initialize #10 | 19.97 | |
| » » » » » » » » » » » Event: Controller.startup #10 | 0.43 | |
| Controller action #10 | 0.00 | |
| » » » » » » » » » » » » Event: Controller.shutdown #9 | 0.14 | |
| » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #17 | 0.73 | |
| » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #18 | 0.48 | |
| » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #19 | 0.48 | |
| » » » » » » » » » » » » Event: Controller.initialize #11 | 25.86 | |
| » » » » » » » » » » » » Event: Controller.startup #11 | 0.46 | |
| Controller action #11 | 0.00 | |
| » » » » » » » » » » » » » Event: Controller.shutdown #10 | 0.11 | |
| » » » » » » » » » » » » » Event: Controller.initialize #12 | 16.97 | |
| » » » » » » » » » » » » » Event: Controller.startup #12 | 0.27 | |
| Controller action #12 | 0.00 | |
| » » » » » » » » » » » » » » Event: Controller.shutdown #11 | 0.12 | |
| » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #20 | 0.62 | |
| » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #21 | 0.51 | |
| » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #22 | 0.45 | |
| » » » » » » » » » » » » » » Event: Controller.initialize #13 | 22.25 | |
| » » » » » » » » » » » » » » Event: Controller.startup #13 | 0.42 | |
| Controller action #13 | 0.00 | |
| » » » » » » » » » » » » » » » Event: Controller.shutdown #12 | 0.12 | |
| » » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #23 | 0.95 | |
| » » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #24 | 0.84 | |
| » » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #25 | 0.86 | |
| » » » » » » » » » » » » » » » Event: Controller.initialize #14 | 27.04 | |
| » » » » » » » » » » » » » » » Event: Controller.startup #14 | 0.57 | |
| Controller action #14 | 0.00 | |
| » » » » » » » » » » » » » » » » Event: Controller.shutdown #13 | 0.22 | |
| » » » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #26 | 0.81 | |
| » » » » » » » » » » » » » » » » Event: Controller.initialize #15 | 33.10 | |
| » » » » » » » » » » » » » » » » Event: Controller.startup #15 | 0.50 | |
| Controller action #15 | 0.00 | |
| » » » » » » » » » » » » » » » » » Event: Controller.shutdown #14 | 0.09 | |
| » » » » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #27 | 0.60 | |
| » » » » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #28 | 0.45 | |
| » » » » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_box.ctp #29 | 0.47 | |
| » » » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/product_searchbar.ctp | 0.70 | |
| » » » » » » » » » » » » » » » » Rendering ROOT/plugins/Webshop/View/Elements/cart_sidebar.ctp | 9.03 | |
| » » » » » » » » » » » » » » » » » Event: Controller.initialize #16 | 2.39 | |
| » » » » » » » » » » » » » » » » » Event: Controller.startup #16 | 0.29 | |
| Controller action #16 | 0.00 | |
| » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #15 | 0.12 | |
| » » » » » » » » » » » » » » » » » Event: Controller.initialize #17 | 1.00 | |
| » » » » » » » » » » » » » » » » » Event: Controller.startup #17 | 0.30 | |
| Controller action #17 | 0.00 | |
| » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #16 | 0.10 | |
| » » » » » » » » » » » » » » » » » » Event: Controller.initialize #18 | 0.88 | |
| » » » » » » » » » » » » » » » » » » Event: Controller.startup #18 | 0.28 | |
| Controller action #18 | 0.00 | |
| » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #17 | 0.12 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| SORTABLE | 1 |
| EXPORTABLE | 2 |
| IMPORTABLE | 4 |
| TRANSLATABLE | 8 |
| MODELCONFIG | /var/www/html/ecp/Model/behavior_config.json |
| SHOPCONFIG | /var/www/html/plugins/Webshop/Config/shopconfig.json |
| Constant | Value |
|---|---|
| APP | /var/www/html/app/ |
| APP_DIR | app |
| APPLIBS | /var/www/html/app/Lib/ |
| CACHE | /var/www/html/app/tmp/cache/ |
| CAKE | /var/www/html/lib/Cake/ |
| CAKE_CORE_INCLUDE_PATH | /var/www/html/lib |
| CORE_PATH | /var/www/html/lib/ |
| CAKE_VERSION | 2.6.10 |
| CSS | /var/www/html/app/webroot/css/ |
| CSS_URL | css/ |
| DS | / |
| FULL_BASE_URL | https://btas.hu |
| IMAGES | /var/www/html/app/webroot/img/ |
| IMAGES_URL | img/ |
| JS | /var/www/html/app/webroot/js/ |
| JS_URL | js/ |
| LOGS | /var/www/html/app/tmp/logs/ |
| ROOT | /var/www/html |
| TESTS | /var/www/html/app/Test/ |
| TMP | /var/www/html/app/tmp/ |
| VENDORS | /var/www/html/vendors/ |
| WEBROOT_DIR | webroot |
| WWW_ROOT | /var/www/html/app/webroot/ |
| Environment Variable | Value |
|---|---|
| Php Version | 5.6.40-65+0~20230214.72+debian10~1.gbp473a1b |
| Redirect Unique Id | Zz5kURRKOM-gpJmnR0E6jAAAAAo |
| Redirect Script Url | / |
| Redirect Script Uri | https://btas.hu/ |
| Redirect Https | on |
| Redirect Ssl Tls Sni | btas.hu |
| Redirect Status | 200 |
| Unique Id | Zz5kURRKOM-gpJmnR0E6jAAAAAo |
| Script Url | / |
| Script Uri | https://btas.hu/ |
| Https | on |
| Ssl Tls Sni | btas.hu |
| Http Accept | */* |
| Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Http Accept Encoding | gzip, br, zstd, deflate |
| Http Host | btas.hu |
| Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin |
| Server Signature | |
| Server Software | Apache |
| Server Name | btas.hu |
| Server Addr | 185.208.227.208 |
| Server Port | 443 |
| Remote Addr | 3.141.2.191 |
| Document Root | /var/www/html |
| Request Scheme | https |
| Context Prefix | |
| Context Document Root | /var/www/html |
| Server Admin | webmaster@localhost |
| Script Filename | /var/www/html/app/webroot/index.php |
| Remote Port | 53103 |
| Redirect Url | / |
| Gateway Interface | CGI/1.1 |
| Server Protocol | HTTP/1.1 |
| Request Method | GET |
| Query String | |
| Request Uri | / |
| Script Name | /app/webroot/index.php |
| Php Self | /app/webroot/index.php |
| Request Time Float | 1732142161.243 |
| Request Time | 1732142161 |
