Query | Affected | Num. rows | Took (ms) | Actions |
---|
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 `c1profix`.`profix_user_groups` AS `UserGroup` LEFT JOIN `c1profix`.`profix_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`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `c1profix`.`profix_users` AS `User` WHERE `User`.`user_group_id` = (2) | 8680 | 8680 | 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 `c1profix`.`profix_user_groups` AS `UserGroup` LEFT JOIN `c1profix`.`profix_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`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `c1profix`.`profix_users` AS `User` WHERE `User`.`user_group_id` = (2) | 8680 | 8680 | 1 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`classification`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`mainpage1`, `ProductCategory`.`mainpage2`, `ProductCategory`.`new`, `ProductCategory`.`fabric_filter`, `ProductCategory`.`size_filter`, `ProductCategory`.`color_filter`, `ProductCategory`.`certificate_filter`, `ProductCategory`.`type_filter`, `ProductCategory`.`layer_filter`, `ProductCategory`.`category_filter`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified` FROM `c1profix`.`profix_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 33 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `c1profix`.`profix_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 33 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`classification`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`mainpage1`, `ProductCategory`.`mainpage2`, `ProductCategory`.`new`, `ProductCategory`.`fabric_filter`, `ProductCategory`.`size_filter`, `ProductCategory`.`color_filter`, `ProductCategory`.`certificate_filter`, `ProductCategory`.`type_filter`, `ProductCategory`.`layer_filter`, `ProductCategory`.`category_filter`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified` FROM `c1profix`.`profix_product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 36 AND `ProductCategory`.`rght` >= 37 ORDER BY `ProductCategory`.`lft` asc | 2 | 2 | 0 | |
SELECT `ProductProfile`.`id`, `ProductProfile`.`title`, `ProductProfile`.`definition` FROM `c1profix`.`profix_product_profiles` AS `ProductProfile` WHERE `ProductProfile`.`id` = 'DEFAULT' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`custom_one`, `Product`.`custom_two`, `Product`.`custom_three`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`short_details`, `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`.`scale`, `Product`.`vat`, `Product`.`connected_items`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (extractValue(profile_data, '/profile/recap')) AS `Product__recap`, (extractValue(profile_data, '/profile/fabric')) AS `Product__fabric`, (extractValue(profile_data, '/profile/color')) AS `Product__color`, (extractValue(profile_data, '/profile/layer')) AS `Product__layer`, (extractValue(profile_data, '/profile/perforations')) AS `Product__perforations`, (extractValue(profile_data, '/profile/size')) AS `Product__size`, (extractValue(profile_data, '/profile/package')) AS `Product__package`, (extractValue(profile_data, '/profile/pack')) AS `Product__pack`, (extractValue(profile_data, '/profile/weight')) AS `Product__weight`, (extractValue(profile_data, '/profile/singlepack')) AS `Product__singlepack`, (extractValue(profile_data, '/profile/cust_sheet')) AS `Product__cust_sheet`, (extractValue(profile_data, '/profile/dist_sheet')) AS `Product__dist_sheet` FROM `c1profix`.`profix_products` AS `Product` inner JOIN `c1profix`.`profix_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `ProductsCategories`.`product_category_id` = 33) WHERE `Product`.`enabled` = '1' ORDER BY `Product`.`sort` ASC LIMIT 12 | 3 | 3 | 2 | maybe slow |
SELECT `PricingBase`.`id`, `PricingBase`.`product_id`, `PricingBase`.`price_dependency_id`, `PricingBase`.`price_dependency_definition`, `PricingBase`.`base_price`, `PricingBase`.`base_price_eur`, `PricingBase`.`special_price`, `PricingBase`.`special_price_eur`, `PricingBase`.`transport_price`, `PricingBase`.`created`, `PricingBase`.`modified`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price`, (if(`PricingBase`.`special_price_eur` > 0, `PricingBase`.`special_price_eur`, `PricingBase`.`base_price_eur`)) AS `PricingBase__current_price_eur` FROM `c1profix`.`profix_pricing_base` AS `PricingBase` WHERE ((((`PricingBase`.`price_dependency_id` = 'BYUSERGROUP') AND (`PricingBase`.`price_dependency_definition` = '2'))) OR (`PricingBase`.`price_dependency_id` IS NULL)) AND `PricingBase`.`product_id` IN (109, 130, 108) | 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 `c1profix`.`profix_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`extra_charge_item_id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`custom_one`, `Product`.`custom_two`, `Product`.`custom_three`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`short_details`, `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`.`scale`, `Product`.`vat`, `Product`.`connected_items`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (extractValue(profile_data, '/profile/recap')) AS `Product__recap`, (extractValue(profile_data, '/profile/fabric')) AS `Product__fabric`, (extractValue(profile_data, '/profile/color')) AS `Product__color`, (extractValue(profile_data, '/profile/layer')) AS `Product__layer`, (extractValue(profile_data, '/profile/perforations')) AS `Product__perforations`, (extractValue(profile_data, '/profile/size')) AS `Product__size`, (extractValue(profile_data, '/profile/package')) AS `Product__package`, (extractValue(profile_data, '/profile/pack')) AS `Product__pack`, (extractValue(profile_data, '/profile/weight')) AS `Product__weight`, (extractValue(profile_data, '/profile/singlepack')) AS `Product__singlepack`, (extractValue(profile_data, '/profile/cust_sheet')) AS `Product__cust_sheet`, (extractValue(profile_data, '/profile/dist_sheet')) AS `Product__dist_sheet` FROM `c1profix`.`profix_products` AS `Product` WHERE `Product`.`id` = 108 LIMIT 1 | 1 | 1 | 1 | |
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 `c1profix`.`profix_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`extra_charge_item_id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`custom_one`, `Product`.`custom_two`, `Product`.`custom_three`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`short_details`, `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`.`scale`, `Product`.`vat`, `Product`.`connected_items`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (extractValue(profile_data, '/profile/recap')) AS `Product__recap`, (extractValue(profile_data, '/profile/fabric')) AS `Product__fabric`, (extractValue(profile_data, '/profile/color')) AS `Product__color`, (extractValue(profile_data, '/profile/layer')) AS `Product__layer`, (extractValue(profile_data, '/profile/perforations')) AS `Product__perforations`, (extractValue(profile_data, '/profile/size')) AS `Product__size`, (extractValue(profile_data, '/profile/package')) AS `Product__package`, (extractValue(profile_data, '/profile/pack')) AS `Product__pack`, (extractValue(profile_data, '/profile/weight')) AS `Product__weight`, (extractValue(profile_data, '/profile/singlepack')) AS `Product__singlepack`, (extractValue(profile_data, '/profile/cust_sheet')) AS `Product__cust_sheet`, (extractValue(profile_data, '/profile/dist_sheet')) AS `Product__dist_sheet` FROM `c1profix`.`profix_products` AS `Product` WHERE `Product`.`id` = 130 LIMIT 1 | 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 `c1profix`.`profix_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`extra_charge_item_id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`custom_one`, `Product`.`custom_two`, `Product`.`custom_three`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`short_details`, `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`.`scale`, `Product`.`vat`, `Product`.`connected_items`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (extractValue(profile_data, '/profile/recap')) AS `Product__recap`, (extractValue(profile_data, '/profile/fabric')) AS `Product__fabric`, (extractValue(profile_data, '/profile/color')) AS `Product__color`, (extractValue(profile_data, '/profile/layer')) AS `Product__layer`, (extractValue(profile_data, '/profile/perforations')) AS `Product__perforations`, (extractValue(profile_data, '/profile/size')) AS `Product__size`, (extractValue(profile_data, '/profile/package')) AS `Product__package`, (extractValue(profile_data, '/profile/pack')) AS `Product__pack`, (extractValue(profile_data, '/profile/weight')) AS `Product__weight`, (extractValue(profile_data, '/profile/singlepack')) AS `Product__singlepack`, (extractValue(profile_data, '/profile/cust_sheet')) AS `Product__cust_sheet`, (extractValue(profile_data, '/profile/dist_sheet')) AS `Product__dist_sheet` FROM `c1profix`.`profix_products` AS `Product` WHERE `Product`.`id` = 109 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`classification`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`mainpage1`, `ProductCategory`.`mainpage2`, `ProductCategory`.`new`, `ProductCategory`.`fabric_filter`, `ProductCategory`.`size_filter`, `ProductCategory`.`color_filter`, `ProductCategory`.`certificate_filter`, `ProductCategory`.`type_filter`, `ProductCategory`.`layer_filter`, `ProductCategory`.`category_filter`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1profix`.`profix_product_categories` AS `ProductCategory` JOIN `c1profix`.`profix_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (109, 130, 108) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 6 | 6 | 0 | |
SELECT `FilterCategory`.`id`, `FilterCategory`.`title`, `FilterCategory`.`sort`, `FilterCategoriesProduct`.`id`, `FilterCategoriesProduct`.`product_id`, `FilterCategoriesProduct`.`filter_category_id` FROM `c1profix`.`profix_filter_categories` AS `FilterCategory` JOIN `c1profix`.`profix_filter_categories_products` AS `FilterCategoriesProduct` ON (`FilterCategoriesProduct`.`product_id` IN (109, 130, 108) AND `FilterCategoriesProduct`.`filter_category_id` = `FilterCategory`.`id`) | 6 | 6 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`classification`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`mainpage1`, `ProductCategory`.`mainpage2`, `ProductCategory`.`new`, `ProductCategory`.`fabric_filter`, `ProductCategory`.`size_filter`, `ProductCategory`.`color_filter`, `ProductCategory`.`certificate_filter`, `ProductCategory`.`type_filter`, `ProductCategory`.`layer_filter`, `ProductCategory`.`category_filter`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified` FROM `c1profix`.`profix_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`enabled` = '1' ORDER BY `ProductCategory`.`sort` ASC, `ProductCategory`.`created` ASC | 30 | 30 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`custom_one`, `Product`.`custom_two`, `Product`.`custom_three`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`short_details`, `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`.`scale`, `Product`.`vat`, `Product`.`connected_items`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (extractValue(profile_data, '/profile/recap')) AS `Product__recap`, (extractValue(profile_data, '/profile/fabric')) AS `Product__fabric`, (extractValue(profile_data, '/profile/color')) AS `Product__color`, (extractValue(profile_data, '/profile/layer')) AS `Product__layer`, (extractValue(profile_data, '/profile/perforations')) AS `Product__perforations`, (extractValue(profile_data, '/profile/size')) AS `Product__size`, (extractValue(profile_data, '/profile/package')) AS `Product__package`, (extractValue(profile_data, '/profile/pack')) AS `Product__pack`, (extractValue(profile_data, '/profile/weight')) AS `Product__weight`, (extractValue(profile_data, '/profile/singlepack')) AS `Product__singlepack`, (extractValue(profile_data, '/profile/cust_sheet')) AS `Product__cust_sheet`, (extractValue(profile_data, '/profile/dist_sheet')) AS `Product__dist_sheet`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `c1profix`.`profix_products` AS `Product` LEFT JOIN `c1profix`.`profix_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) inner JOIN `c1profix`.`profix_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `ProductsCategories`.`product_category_id` = 33) WHERE `Product`.`enabled` = '1' | 3 | 3 | 1 | maybe slow |
SELECT `ProductProfile`.`id`, `ProductProfile`.`title`, `ProductProfile`.`definition` FROM `c1profix`.`profix_product_profiles` AS `ProductProfile` WHERE `ProductProfile`.`id` = 'DEFAULT' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`title` FROM `c1profix`.`profix_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`enabled` = '1' AND `ProductCategory`.`parent_id` = 33 ORDER BY `sort` ASC | 0 | 0 | 0 | |
SELECT `FilterCategory`.`id`, `FilterCategory`.`title` FROM `c1profix`.`profix_filter_categories` AS `FilterCategory` WHERE `FilterCategory`.`id` IS NULL ORDER BY `sort` ASC | 0 | 0 | 0 | |
SELECT `SiteSetting`.`id`, `SiteSetting`.`seo_title`, `SiteSetting`.`seo_description`, `SiteSetting`.`seo_keywords`, `SiteSetting`.`copyright` FROM `c1profix`.`profix_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 `c1profix`.`profix_route_based_seo` AS `RouteBasedSeo` WHERE `RouteBasedSeo`.`route_alias` = '/termekek/escon-crepe/33' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `ContactManager`.`id`, `ContactManager`.`title`, `ContactManager`.`value` FROM `c1profix`.`profix_contact_manager` AS `ContactManager` WHERE 1 = 1 | 7 | 7 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'HOME' 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) 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 `c1profix`.`profix_user_groups` AS `UserGroup` LEFT JOIN `c1profix`.`profix_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`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `c1profix`.`profix_users` AS `User` WHERE `User`.`user_group_id` = (2) | 8680 | 8680 | 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 `c1profix`.`profix_user_groups` AS `UserGroup` LEFT JOIN `c1profix`.`profix_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`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`sort` FROM `c1profix`.`profix_users` AS `User` WHERE `User`.`user_group_id` = (2) | 8680 | 8680 | 1 | |
SELECT `ProductProfile`.`id`, `ProductProfile`.`title`, `ProductProfile`.`definition` FROM `c1profix`.`profix_product_profiles` AS `ProductProfile` WHERE `ProductProfile`.`id` = 'DEFAULT' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`custom_one`, `Product`.`custom_two`, `Product`.`custom_three`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`short_details`, `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`.`scale`, `Product`.`vat`, `Product`.`connected_items`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (extractValue(profile_data, '/profile/recap')) AS `Product__recap`, (extractValue(profile_data, '/profile/fabric')) AS `Product__fabric`, (extractValue(profile_data, '/profile/color')) AS `Product__color`, (extractValue(profile_data, '/profile/layer')) AS `Product__layer`, (extractValue(profile_data, '/profile/perforations')) AS `Product__perforations`, (extractValue(profile_data, '/profile/size')) AS `Product__size`, (extractValue(profile_data, '/profile/package')) AS `Product__package`, (extractValue(profile_data, '/profile/pack')) AS `Product__pack`, (extractValue(profile_data, '/profile/weight')) AS `Product__weight`, (extractValue(profile_data, '/profile/singlepack')) AS `Product__singlepack`, (extractValue(profile_data, '/profile/cust_sheet')) AS `Product__cust_sheet`, (extractValue(profile_data, '/profile/dist_sheet')) AS `Product__dist_sheet` FROM `c1profix`.`profix_products` AS `Product` WHERE `Product`.`enabled` = '1' AND `Product`.`featured_product` = '1' ORDER BY rand() ASC LIMIT 4 | 4 | 4 | 1 | maybe slow |
SELECT `PricingBase`.`id`, `PricingBase`.`product_id`, `PricingBase`.`price_dependency_id`, `PricingBase`.`price_dependency_definition`, `PricingBase`.`base_price`, `PricingBase`.`base_price_eur`, `PricingBase`.`special_price`, `PricingBase`.`special_price_eur`, `PricingBase`.`transport_price`, `PricingBase`.`created`, `PricingBase`.`modified`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price`, (if(`PricingBase`.`special_price_eur` > 0, `PricingBase`.`special_price_eur`, `PricingBase`.`base_price_eur`)) AS `PricingBase__current_price_eur` FROM `c1profix`.`profix_pricing_base` AS `PricingBase` WHERE ((((`PricingBase`.`price_dependency_id` = 'BYUSERGROUP') AND (`PricingBase`.`price_dependency_definition` = '2'))) OR (`PricingBase`.`price_dependency_id` IS NULL)) AND `PricingBase`.`product_id` IN (164, 162, 165, 161) | 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 `c1profix`.`profix_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`extra_charge_item_id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`custom_one`, `Product`.`custom_two`, `Product`.`custom_three`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`short_details`, `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`.`scale`, `Product`.`vat`, `Product`.`connected_items`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (extractValue(profile_data, '/profile/recap')) AS `Product__recap`, (extractValue(profile_data, '/profile/fabric')) AS `Product__fabric`, (extractValue(profile_data, '/profile/color')) AS `Product__color`, (extractValue(profile_data, '/profile/layer')) AS `Product__layer`, (extractValue(profile_data, '/profile/perforations')) AS `Product__perforations`, (extractValue(profile_data, '/profile/size')) AS `Product__size`, (extractValue(profile_data, '/profile/package')) AS `Product__package`, (extractValue(profile_data, '/profile/pack')) AS `Product__pack`, (extractValue(profile_data, '/profile/weight')) AS `Product__weight`, (extractValue(profile_data, '/profile/singlepack')) AS `Product__singlepack`, (extractValue(profile_data, '/profile/cust_sheet')) AS `Product__cust_sheet`, (extractValue(profile_data, '/profile/dist_sheet')) AS `Product__dist_sheet` FROM `c1profix`.`profix_products` AS `Product` WHERE `Product`.`id` = 161 LIMIT 1 | 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 `c1profix`.`profix_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`extra_charge_item_id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`custom_one`, `Product`.`custom_two`, `Product`.`custom_three`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`short_details`, `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`.`scale`, `Product`.`vat`, `Product`.`connected_items`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (extractValue(profile_data, '/profile/recap')) AS `Product__recap`, (extractValue(profile_data, '/profile/fabric')) AS `Product__fabric`, (extractValue(profile_data, '/profile/color')) AS `Product__color`, (extractValue(profile_data, '/profile/layer')) AS `Product__layer`, (extractValue(profile_data, '/profile/perforations')) AS `Product__perforations`, (extractValue(profile_data, '/profile/size')) AS `Product__size`, (extractValue(profile_data, '/profile/package')) AS `Product__package`, (extractValue(profile_data, '/profile/pack')) AS `Product__pack`, (extractValue(profile_data, '/profile/weight')) AS `Product__weight`, (extractValue(profile_data, '/profile/singlepack')) AS `Product__singlepack`, (extractValue(profile_data, '/profile/cust_sheet')) AS `Product__cust_sheet`, (extractValue(profile_data, '/profile/dist_sheet')) AS `Product__dist_sheet` FROM `c1profix`.`profix_products` AS `Product` WHERE `Product`.`id` = 164 LIMIT 1 | 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 `c1profix`.`profix_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`extra_charge_item_id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`custom_one`, `Product`.`custom_two`, `Product`.`custom_three`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`short_details`, `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`.`scale`, `Product`.`vat`, `Product`.`connected_items`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (extractValue(profile_data, '/profile/recap')) AS `Product__recap`, (extractValue(profile_data, '/profile/fabric')) AS `Product__fabric`, (extractValue(profile_data, '/profile/color')) AS `Product__color`, (extractValue(profile_data, '/profile/layer')) AS `Product__layer`, (extractValue(profile_data, '/profile/perforations')) AS `Product__perforations`, (extractValue(profile_data, '/profile/size')) AS `Product__size`, (extractValue(profile_data, '/profile/package')) AS `Product__package`, (extractValue(profile_data, '/profile/pack')) AS `Product__pack`, (extractValue(profile_data, '/profile/weight')) AS `Product__weight`, (extractValue(profile_data, '/profile/singlepack')) AS `Product__singlepack`, (extractValue(profile_data, '/profile/cust_sheet')) AS `Product__cust_sheet`, (extractValue(profile_data, '/profile/dist_sheet')) AS `Product__dist_sheet` FROM `c1profix`.`profix_products` AS `Product` WHERE `Product`.`id` = 165 LIMIT 1 | 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 `c1profix`.`profix_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`extra_charge_item_id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`custom_one`, `Product`.`custom_two`, `Product`.`custom_three`, `Product`.`seo_title`, `Product`.`seo_desc`, `Product`.`seo_keyw`, `Product`.`enable_og_meta`, `Product`.`transport_time`, `Product`.`transport_price`, `Product`.`short_details`, `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`.`scale`, `Product`.`vat`, `Product`.`connected_items`, `Product`.`created`, `Product`.`modified`, `Product`.`sort`, (extractValue(profile_data, '/profile/recap')) AS `Product__recap`, (extractValue(profile_data, '/profile/fabric')) AS `Product__fabric`, (extractValue(profile_data, '/profile/color')) AS `Product__color`, (extractValue(profile_data, '/profile/layer')) AS `Product__layer`, (extractValue(profile_data, '/profile/perforations')) AS `Product__perforations`, (extractValue(profile_data, '/profile/size')) AS `Product__size`, (extractValue(profile_data, '/profile/package')) AS `Product__package`, (extractValue(profile_data, '/profile/pack')) AS `Product__pack`, (extractValue(profile_data, '/profile/weight')) AS `Product__weight`, (extractValue(profile_data, '/profile/singlepack')) AS `Product__singlepack`, (extractValue(profile_data, '/profile/cust_sheet')) AS `Product__cust_sheet`, (extractValue(profile_data, '/profile/dist_sheet')) AS `Product__dist_sheet` FROM `c1profix`.`profix_products` AS `Product` WHERE `Product`.`id` = 162 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`classification`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`mainpage1`, `ProductCategory`.`mainpage2`, `ProductCategory`.`new`, `ProductCategory`.`fabric_filter`, `ProductCategory`.`size_filter`, `ProductCategory`.`color_filter`, `ProductCategory`.`certificate_filter`, `ProductCategory`.`type_filter`, `ProductCategory`.`layer_filter`, `ProductCategory`.`category_filter`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1profix`.`profix_product_categories` AS `ProductCategory` JOIN `c1profix`.`profix_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (164, 162, 165, 161) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 4 | 4 | 0 | |
SELECT `FilterCategory`.`id`, `FilterCategory`.`title`, `FilterCategory`.`sort`, `FilterCategoriesProduct`.`id`, `FilterCategoriesProduct`.`product_id`, `FilterCategoriesProduct`.`filter_category_id` FROM `c1profix`.`profix_filter_categories` AS `FilterCategory` JOIN `c1profix`.`profix_filter_categories_products` AS `FilterCategoriesProduct` ON (`FilterCategoriesProduct`.`product_id` IN (164, 162, 165, 161) AND `FilterCategoriesProduct`.`filter_category_id` = `FilterCategory`.`id`) | 4 | 4 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTDETAILS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link`, `CommunityProfile`.`api_code`, `CommunityProfile`.`button_code` FROM `c1profix`.`profix_community_profiles` AS `CommunityProfile` WHERE 1 = 1 | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'MAINMENU' | 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) 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`.`classification`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`sort`, `ProductCategory`.`mainpage1`, `ProductCategory`.`mainpage2`, `ProductCategory`.`new`, `ProductCategory`.`fabric_filter`, `ProductCategory`.`size_filter`, `ProductCategory`.`color_filter`, `ProductCategory`.`certificate_filter`, `ProductCategory`.`type_filter`, `ProductCategory`.`layer_filter`, `ProductCategory`.`category_filter`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified` FROM `c1profix`.`profix_product_categories` AS `ProductCategory` WHERE 1 = 1 ORDER BY `sort` ASC | 31 | 31 | 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'INFORMATIONS' | 6 | 6 | 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`menu_id` = 'FOOTER' | 3 | 3 | 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` FROM `c1profix`.`profix_static_pages` AS `StaticPage` 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` FROM `c1profix`.`profix_static_pages` AS `StaticPage` 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'REGISTER' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1profix`.`profix_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Kérem, várjon...' 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`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1profix`.`profix_routes` AS `Route` LEFT JOIN `c1profix`.`profix_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) WHERE `Route`.`short_id` = 'PRODUCTDETAILS' 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` FROM `c1profix`.`profix_static_pages` AS `StaticPage` WHERE `StaticPage`.`short_id` = 'POPUP' LIMIT 1 | 1 | 1 | 0 | |