Cikkszám: GR040001000
3-as elem ágyazható
No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__type`.`content`) AS `Product__i18n_type`, (`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` FROM `c1milo`.`milol_products` AS `Product` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_i18ns` AS `I18n__type` ON (`Product`.`id` = `I18n__type`.`foreign_key` AND `I18n__type`.`model` = 'Product' AND `I18n__type`.`field` = 'type' AND `I18n__type`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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`.`id` = 427 LIMIT 1 | 1 | 1 | 12 | maybe slow |
SELECT `ProductProfile`.`id`, `ProductProfile`.`title`, `ProductProfile`.`definition` FROM `c1milo`.`milol_product_profiles` AS `ProductProfile` WHERE `ProductProfile`.`id` = 'CSS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__type`.`content`) AS `Product__i18n_type`, (`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`, (extractValue(profile_data, '/profile/outerwidth')) AS `Product__outerwidth`, (extractValue(profile_data, '/profile/outerlength')) AS `Product__outerlength`, (extractValue(profile_data, '/profile/outerwidth2')) AS `Product__outerwidth2`, (extractValue(profile_data, '/profile/lyingsurfacewidth')) AS `Product__lyingsurfacewidth`, (extractValue(profile_data, '/profile/lyingsurfacelength')) AS `Product__lyingsurfacelength`, (extractValue(profile_data, '/profile/sittingheight')) AS `Product__sittingheight`, (extractValue(profile_data, '/profile/sittingdepth')) AS `Product__sittingdepth`, (extractValue(profile_data, '/profile/sittingdepthwithpillow')) AS `Product__sittingdepthwithpillow`, (extractValue(profile_data, '/profile/backrest')) AS `Product__backrest`, (extractValue(profile_data, '/profile/fullheight')) AS `Product__fullheight`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `c1milo`.`milol_products` AS `Product` LEFT JOIN `c1milo`.`milol_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_i18ns` AS `I18n__type` ON (`Product`.`id` = `I18n__type`.`foreign_key` AND `I18n__type`.`model` = 'Product' AND `I18n__type`.`field` = 'type' AND `I18n__type`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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`.`id` = 427 LIMIT 1 | 1 | 1 | 14 | maybe slow |
SELECT `ProductPicture`.`id`, `ProductPicture`.`list_index`, `ProductPicture`.`title`, `ProductPicture`.`sub_title`, `ProductPicture`.`serial`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`gallery_pict`, `ProductPicture`.`sort` FROM `c1milo`.`milol_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` = (427) ORDER BY `sort` ASC | 9 | 9 | 5 | maybe slow |
SELECT `Fabric`.`id`, `Fabric`.`title`, `Fabric`.`details`, `Fabric`.`profile`, `Fabric`.`picture`, `Fabric`.`sort`, `ProductPicturesFabric`.`id`, `ProductPicturesFabric`.`product_picture_id`, `ProductPicturesFabric`.`fabric_id` FROM `c1milo`.`milol_fabrics` AS `Fabric` JOIN `c1milo`.`milol_product_pictures_fabrics` AS `ProductPicturesFabric` ON (`ProductPicturesFabric`.`product_picture_id` IN (8478, 8479, 8480, 8481, 8482, 8483, 1834, 1836, 2733) AND `ProductPicturesFabric`.`fabric_id` = `Fabric`.`id`) | 3 | 3 | 2 | maybe slow |
SELECT `ProductSize`.`id`, `ProductSize`.`product_id`, `ProductSize`.`title`, `ProductSize`.`details`, `ProductSize`.`price`, `ProductSize`.`upper` FROM `c1milo`.`milol_product_sizes` AS `ProductSize` WHERE `ProductSize`.`product_id` = (427) | 3 | 3 | 1 | maybe slow |
SELECT `PricingBase`.`id`, `PricingBase`.`product_id`, `PricingBase`.`price_dependency_id`, `PricingBase`.`price_dependency_definition`, `PricingBase`.`base_price`, `PricingBase`.`special_price`, `PricingBase`.`transport_price`, `PricingBase`.`created`, `PricingBase`.`modified`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `c1milo`.`milol_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` = (427) | 0 | 0 | 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 `c1milo`.`milol_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` = (427) | 0 | 0 | 0 | |
SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `c1milo`.`milol_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` = (427) | 0 | 0 | 1 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` = 427 AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) ORDER BY `lft` desc | 1 | 1 | 1 | |
SELECT `ProductSizeProfile`.`id`, `ProductSizeProfile`.`product_id`, `ProductSizeProfile`.`size_id`, `ProductSizeProfile`.`outerwidth`, `ProductSizeProfile`.`outerlength`, `ProductSizeProfile`.`lyingsurfacewidth`, `ProductSizeProfile`.`lyingsurfacelength`, `ProductSizeProfile`.`sittingheight`, `ProductSizeProfile`.`backrest`, `ProductSizeProfile`.`outerwidth2`, `ProductSizeProfile`.`sittingdepth`, `ProductSizeProfile`.`lyingheight`, `ProductSizeProfile`.`height`, `ProductSizeProfile`.`fullheight`, `ProductSizeProfile`.`sittingdepthwithpillow`, `ProductSizeProfile`.`sittingwidth`, `ProductSizeProfile`.`headheight` FROM `c1milo`.`milol_product_size_profiles` AS `ProductSizeProfile` WHERE `ProductSizeProfile`.`product_id` = 427 | 3 | 3 | 1 | maybe slow |
SELECT `ProductPicture`.`id`, `ProductPicture`.`list_index`, `ProductPicture`.`title`, `ProductPicture`.`sub_title`, `ProductPicture`.`serial`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`gallery_pict`, `ProductPicture`.`sort`, (`I18n__title`.`content`) AS `ProductPicture__i18n_title`, (`I18n__sub_title`.`content`) AS `ProductPicture__i18n_sub_title` FROM `c1milo`.`milol_product_pictures` AS `ProductPicture` LEFT JOIN `c1milo`.`milol_product_picture_i18ns` AS `I18n__title` ON (`ProductPicture`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'ProductPicture' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_product_picture_i18ns` AS `I18n__sub_title` ON (`ProductPicture`.`id` = `I18n__sub_title`.`foreign_key` AND `I18n__sub_title`.`model` = 'ProductPicture' AND `I18n__sub_title`.`field` = 'sub_title' AND `I18n__sub_title`.`locale` = 'hun') WHERE `product_id` = 427 ORDER BY `sort` asc, `list_index` asc | 9 | 9 | 508 | maybe slow |
SELECT `Fabric`.`id`, `Fabric`.`title`, `Fabric`.`details`, `Fabric`.`profile`, `Fabric`.`picture`, `Fabric`.`sort`, `ProductPicturesFabric`.`id`, `ProductPicturesFabric`.`product_picture_id`, `ProductPicturesFabric`.`fabric_id` FROM `c1milo`.`milol_fabrics` AS `Fabric` JOIN `c1milo`.`milol_product_pictures_fabrics` AS `ProductPicturesFabric` ON (`ProductPicturesFabric`.`product_picture_id` IN (8478, 8479, 8480, 8481, 8482, 8483, 1834, 2733, 1836) AND `ProductPicturesFabric`.`fabric_id` = `Fabric`.`id`) | 3 | 3 | 1 | maybe slow |
SELECT `Fabric`.`id`, `Fabric`.`title`, `Fabric`.`details`, `Fabric`.`profile`, `Fabric`.`picture`, `Fabric`.`sort`, (`I18n__title`.`content`) AS `Fabric__i18n_title`, (`I18n__details`.`content`) AS `Fabric__i18n_details`, (`I18n__profile`.`content`) AS `Fabric__i18n_profile` FROM `c1milo`.`milol_fabrics` AS `Fabric` LEFT JOIN `c1milo`.`milol_fabric_i18ns` AS `I18n__title` ON (`Fabric`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Fabric' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_fabric_i18ns` AS `I18n__details` ON (`Fabric`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'Fabric' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_fabric_i18ns` AS `I18n__profile` ON (`Fabric`.`id` = `I18n__profile`.`foreign_key` AND `I18n__profile`.`model` = 'Fabric' AND `I18n__profile`.`field` = 'profile' AND `I18n__profile`.`locale` = 'hun') WHERE `Fabric`.`id` = 660 LIMIT 1 | 1 | 1 | 6 | maybe slow |
SELECT `Fabric`.`id`, `Fabric`.`title`, `Fabric`.`details`, `Fabric`.`profile`, `Fabric`.`picture`, `Fabric`.`sort`, (`I18n__title`.`content`) AS `Fabric__i18n_title`, (`I18n__details`.`content`) AS `Fabric__i18n_details`, (`I18n__profile`.`content`) AS `Fabric__i18n_profile` FROM `c1milo`.`milol_fabrics` AS `Fabric` LEFT JOIN `c1milo`.`milol_fabric_i18ns` AS `I18n__title` ON (`Fabric`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Fabric' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_fabric_i18ns` AS `I18n__details` ON (`Fabric`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'Fabric' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_fabric_i18ns` AS `I18n__profile` ON (`Fabric`.`id` = `I18n__profile`.`foreign_key` AND `I18n__profile`.`model` = 'Fabric' AND `I18n__profile`.`field` = 'profile' AND `I18n__profile`.`locale` = 'hun') WHERE `Fabric`.`id` = 662 LIMIT 1 | 1 | 1 | 4 | maybe slow |
SELECT `Fabric`.`id`, `Fabric`.`title`, `Fabric`.`details`, `Fabric`.`profile`, `Fabric`.`picture`, `Fabric`.`sort`, (`I18n__title`.`content`) AS `Fabric__i18n_title`, (`I18n__details`.`content`) AS `Fabric__i18n_details`, (`I18n__profile`.`content`) AS `Fabric__i18n_profile` FROM `c1milo`.`milol_fabrics` AS `Fabric` LEFT JOIN `c1milo`.`milol_fabric_i18ns` AS `I18n__title` ON (`Fabric`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Fabric' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_fabric_i18ns` AS `I18n__details` ON (`Fabric`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'Fabric' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_fabric_i18ns` AS `I18n__profile` ON (`Fabric`.`id` = `I18n__profile`.`foreign_key` AND `I18n__profile`.`model` = 'Fabric' AND `I18n__profile`.`field` = 'profile' AND `I18n__profile`.`locale` = 'hun') WHERE `Fabric`.`id` = 663 LIMIT 1 | 1 | 1 | 4 | maybe slow |
SELECT `ProductSize`.`id`, `ProductSize`.`product_id`, `ProductSize`.`title`, `ProductSize`.`details`, `ProductSize`.`price`, `ProductSize`.`upper`, (`I18n__title`.`content`) AS `ProductSize__i18n_title`, (`I18n__details`.`content`) AS `ProductSize__i18n_details` FROM `c1milo`.`milol_product_sizes` AS `ProductSize` LEFT JOIN `c1milo`.`milol_product_size_i18ns` AS `I18n__title` ON (`ProductSize`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'ProductSize' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_product_size_i18ns` AS `I18n__details` ON (`ProductSize`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductSize' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') WHERE `product_id` = 427 | 3 | 3 | 20 | maybe slow |
SELECT `ProductSizeProfile`.`id`, `ProductSizeProfile`.`product_id`, `ProductSizeProfile`.`size_id`, `ProductSizeProfile`.`outerwidth`, `ProductSizeProfile`.`outerlength`, `ProductSizeProfile`.`lyingsurfacewidth`, `ProductSizeProfile`.`lyingsurfacelength`, `ProductSizeProfile`.`sittingheight`, `ProductSizeProfile`.`backrest`, `ProductSizeProfile`.`outerwidth2`, `ProductSizeProfile`.`sittingdepth`, `ProductSizeProfile`.`lyingheight`, `ProductSizeProfile`.`height`, `ProductSizeProfile`.`fullheight`, `ProductSizeProfile`.`sittingdepthwithpillow`, `ProductSizeProfile`.`sittingwidth`, `ProductSizeProfile`.`headheight` FROM `c1milo`.`milol_product_size_profiles` AS `ProductSizeProfile` WHERE `ProductSizeProfile`.`size_id` IN (985, 987, 988) | 3 | 3 | 1 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `ProductCategory`.`enabled` = '1' ORDER BY `ProductCategory`.`sort` ASC, `ProductCategory`.`created` ASC | 13 | 13 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_products` AS `Product` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` IN (21, 1, 16, 2, 11, 12, 5, 3, 4, 17, 18, 7, 20) AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 880 | 880 | 0 | |
SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `c1milo`.`milol_product_comments` AS `ProductComment` WHERE `ProductComment`.`enabled` = '1' AND `ProductComment`.`product_id` = 427 | 0 | 0 | 1 | maybe slow |
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE 1 = 1 AND `ProductCategory`.`lft` <= 9 AND `ProductCategory`.`rght` >= 10 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__type`.`content`) AS `Product__i18n_type`, (`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`, (extractValue(profile_data, '/profile/outerwidth')) AS `Product__outerwidth`, (extractValue(profile_data, '/profile/outerlength')) AS `Product__outerlength`, (extractValue(profile_data, '/profile/outerwidth2')) AS `Product__outerwidth2`, (extractValue(profile_data, '/profile/lyingsurfacewidth')) AS `Product__lyingsurfacewidth`, (extractValue(profile_data, '/profile/lyingsurfacelength')) AS `Product__lyingsurfacelength`, (extractValue(profile_data, '/profile/sittingheight')) AS `Product__sittingheight`, (extractValue(profile_data, '/profile/sittingdepth')) AS `Product__sittingdepth`, (extractValue(profile_data, '/profile/sittingdepthwithpillow')) AS `Product__sittingdepthwithpillow`, (extractValue(profile_data, '/profile/backrest')) AS `Product__backrest`, (extractValue(profile_data, '/profile/fullheight')) AS `Product__fullheight` FROM `c1milo`.`milol_products` AS `Product` inner JOIN `c1milo`.`milol_product_categories_products` AS `ProductsCategories` ON (`Product`.`id` = `ProductsCategories`.`product_id` AND `Product`.`id` <> 427 AND `ProductsCategories`.`product_category_id` = 5) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_i18ns` AS `I18n__type` ON (`Product`.`id` = `I18n__type`.`foreign_key` AND `I18n__type`.`model` = 'Product' AND `I18n__type`.`field` = 'type' AND `I18n__type`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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' GROUP BY `Product`.`serial` ORDER BY rand() ASC LIMIT 8 | 8 | 8 | 841 | maybe slow |
SELECT `ProductSize`.`id`, `ProductSize`.`product_id`, `ProductSize`.`title`, `ProductSize`.`details`, `ProductSize`.`price`, `ProductSize`.`upper` FROM `c1milo`.`milol_product_sizes` AS `ProductSize` WHERE `ProductSize`.`product_id` IN (456, 218, 422, 783, 414, 473, 780, 435) ORDER BY `price` desc | 26 | 26 | 1 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (456, 218, 422, 783, 414, 473, 780, 435) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) ORDER BY `lft` desc | 10 | 10 | 1 | maybe slow |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `ProductCategory`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_products` AS `Product` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` = 5 AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 61 | 61 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `ProductCategory`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_products` AS `Product` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` = 5 AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 61 | 61 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `ProductCategory`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_products` AS `Product` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` = 5 AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 61 | 61 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `ProductCategory`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_products` AS `Product` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` = 15 AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 88 | 88 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `ProductCategory`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_products` AS `Product` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` = 5 AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 61 | 61 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `ProductCategory`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_products` AS `Product` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` = 5 AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 61 | 61 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `ProductCategory`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_products` AS `Product` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` = 15 AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 88 | 88 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `ProductCategory`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_products` AS `Product` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_category_id` = 5 AND `ProductCategoriesProduct`.`product_id` = `Product`.`id`) | 61 | 61 | 0 | |
SELECT `Shelf`.`id`, `Shelf`.`user_id`, `Shelf`.`product_id` FROM `c1milo`.`milol_shelf` AS `Shelf` WHERE `Shelf`.`user_id` IS NULL AND `Shelf`.`product_id` = 427 LIMIT 1 | 0 | 0 | 0 | |
SELECT `Pictogram`.`id`, `Pictogram`.`title`, `Pictogram`.`picture`, `Pictogram`.`sort`, (`I18n__title`.`content`) AS `Pictogram__i18n_title` FROM `c1milo`.`milol_pictograms` AS `Pictogram` LEFT JOIN `c1milo`.`milol_pictogram_i18ns` AS `I18n__title` ON (`Pictogram`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Pictogram' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') WHERE `Pictogram`.`id` IN (4, 16, 18) ORDER BY `Pictogram`.`sort` asc | 3 | 3 | 1 | maybe slow |
SELECT `Label`.`id`, `Label`.`title`, `Label`.`sort`, (`I18n__title`.`content`) AS `Label__i18n_title` FROM `c1milo`.`milol_labels` AS `Label` LEFT JOIN `c1milo`.`milol_label_i18ns` AS `I18n__title` ON (`Label`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Label' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') WHERE `Label`.`id` = (12) ORDER BY `Label`.`sort` asc | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`price_dependency_id`, `Product`.`serial`, `Product`.`name`, `Product`.`type`, `Product`.`direction`, `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`.`pictograms`, `Product`.`labels`, `Product`.`infos`, `Product`.`videos`, `Product`.`gif`, `Product`.`stock`, `Product`.`ratings`, `Product`.`rating_users`, `Product`.`enabled`, `Product`.`created`, `Product`.`modified`, (`I18n__name`.`content`) AS `Product__i18n_name`, (`I18n__type`.`content`) AS `Product__i18n_type`, (`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`, (extractValue(profile_data, '/profile/outerwidth')) AS `Product__outerwidth`, (extractValue(profile_data, '/profile/outerlength')) AS `Product__outerlength`, (extractValue(profile_data, '/profile/outerwidth2')) AS `Product__outerwidth2`, (extractValue(profile_data, '/profile/lyingsurfacewidth')) AS `Product__lyingsurfacewidth`, (extractValue(profile_data, '/profile/lyingsurfacelength')) AS `Product__lyingsurfacelength`, (extractValue(profile_data, '/profile/sittingheight')) AS `Product__sittingheight`, (extractValue(profile_data, '/profile/sittingdepth')) AS `Product__sittingdepth`, (extractValue(profile_data, '/profile/sittingdepthwithpillow')) AS `Product__sittingdepthwithpillow`, (extractValue(profile_data, '/profile/backrest')) AS `Product__backrest`, (extractValue(profile_data, '/profile/fullheight')) AS `Product__fullheight`, `PriceDependency`.`id`, `PriceDependency`.`descriptor_name`, `PriceDependency`.`display_name`, `PriceDependency`.`definition`, `PriceDependency`.`created` FROM `c1milo`.`milol_products` AS `Product` LEFT JOIN `c1milo`.`milol_price_dependencies` AS `PriceDependency` ON (`Product`.`price_dependency_id` = `PriceDependency`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_i18ns` AS `I18n__type` ON (`Product`.`id` = `I18n__type`.`foreign_key` AND `I18n__type`.`model` = 'Product' AND `I18n__type`.`field` = 'type' AND `I18n__type`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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`.`serial` = 'GR040' ORDER BY `Product`.`direction` ASC | 1 | 1 | 30 | maybe slow |
SELECT `ProductPicture`.`id`, `ProductPicture`.`list_index`, `ProductPicture`.`title`, `ProductPicture`.`sub_title`, `ProductPicture`.`serial`, `ProductPicture`.`product_id`, `ProductPicture`.`filename`, `ProductPicture`.`main_pict`, `ProductPicture`.`list_pict`, `ProductPicture`.`gallery_pict`, `ProductPicture`.`sort` FROM `c1milo`.`milol_product_pictures` AS `ProductPicture` WHERE `ProductPicture`.`product_id` = (427) ORDER BY `sort` ASC | 9 | 9 | 0 | |
SELECT `ProductSize`.`id`, `ProductSize`.`product_id`, `ProductSize`.`title`, `ProductSize`.`details`, `ProductSize`.`price`, `ProductSize`.`upper` FROM `c1milo`.`milol_product_sizes` AS `ProductSize` WHERE `ProductSize`.`product_id` = (427) | 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`, (if(`PricingBase`.`special_price` > 0, `PricingBase`.`special_price`, `PricingBase`.`base_price`)) AS `PricingBase__current_price` FROM `c1milo`.`milol_pricing_base` AS `PricingBase` WHERE `PricingBase`.`product_id` = (427) | 0 | 0 | 0 | |
SELECT `PricingExtended`.`id`, `PricingExtended`.`product_id`, `PricingExtended`.`extra_charge_item_group_id`, `PricingExtended`.`extra_charge_item_id`, `PricingExtended`.`price_dependency_id`, `PricingExtended`.`price_dependency_definition`, `PricingExtended`.`price_as_group`, `PricingExtended`.`null_price`, `PricingExtended`.`price`, `PricingExtended`.`created`, `PricingExtended`.`modified` FROM `c1milo`.`milol_pricing_extended` AS `PricingExtended` WHERE `PricingExtended`.`product_id` = (427) | 0 | 0 | 0 | |
SELECT `ProductComment`.`id`, `ProductComment`.`parent_id`, `ProductComment`.`product_id`, `ProductComment`.`name`, `ProductComment`.`email`, `ProductComment`.`message`, `ProductComment`.`enabled`, `ProductComment`.`created` FROM `c1milo`.`milol_product_comments` AS `ProductComment` WHERE `ProductComment`.`product_id` = (427) | 0 | 0 | 0 | |
SELECT `ProductUpvote`.`id`, `ProductUpvote`.`user_id`, `ProductUpvote`.`product_id` FROM `c1milo`.`milol_product_upvotes` AS `ProductUpvote` WHERE `ProductUpvote`.`product_id` = (427) | 0 | 0 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` JOIN `c1milo`.`milol_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` = 427 AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 1 | 1 | 1 | |
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`, `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `c1milo`.`milol_simple_blog_entries` AS `SimpleBlogEntry` LEFT JOIN `c1milo`.`milol_simple_blog_categories` AS `SimpleBlogCategory` ON (`SimpleBlogEntry`.`simple_blog_category_id` = `SimpleBlogCategory`.`id`) WHERE `SimpleBlogEntry`.`id` IS NULL ORDER BY `SimpleBlogEntry`.`sort` asc | 0 | 0 | 0 | |
SELECT `SimpleBlogEntry`.`id`, `SimpleBlogEntry`.`simple_blog_category_id`, `SimpleBlogEntry`.`seo_title`, `SimpleBlogEntry`.`seo_desc`, `SimpleBlogEntry`.`seo_keyw`, `SimpleBlogEntry`.`title`, `SimpleBlogEntry`.`prolog`, `SimpleBlogEntry`.`content`, `SimpleBlogEntry`.`picture`, `SimpleBlogEntry`.`enabled`, `SimpleBlogEntry`.`manual_date`, `SimpleBlogEntry`.`connected_items`, `SimpleBlogEntry`.`created`, `SimpleBlogEntry`.`sort`, `SimpleBlogCategory`.`id`, `SimpleBlogCategory`.`name`, `SimpleBlogCategory`.`enable_manual_date`, `SimpleBlogCategory`.`enable_comments`, `SimpleBlogCategory`.`use_picture_profile` FROM `c1milo`.`milol_simple_blog_entries` AS `SimpleBlogEntry` LEFT JOIN `c1milo`.`milol_simple_blog_categories` AS `SimpleBlogCategory` ON (`SimpleBlogEntry`.`simple_blog_category_id` = `SimpleBlogCategory`.`id`) WHERE `SimpleBlogEntry`.`id` IS NULL ORDER BY `SimpleBlogEntry`.`sort` asc | 0 | 0 | 0 | |
SELECT `FabricProfile`.`id`, `FabricProfile`.`title` FROM `c1milo`.`milol_fabric_profiles` AS `FabricProfile` WHERE 1 = 1 | 5 | 5 | 0 | |
SELECT `SiteSetting`.`id`, `SiteSetting`.`seo_title`, `SiteSetting`.`seo_description`, `SiteSetting`.`seo_keywords`, `SiteSetting`.`copyright` FROM `c1milo`.`milol_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 `c1milo`.`milol_route_based_seo` AS `RouteBasedSeo` WHERE `RouteBasedSeo`.`route_alias` = '/termek/milo-butor--izabell-ulogarnitura/427' 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 `c1milo`.`milol_contact_manager` AS `ContactManager` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 | 8 | 8 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`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`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'PRODUCTS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'HOME' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = '* A képernyőn látható szövet és termék színek eltérhetnek a valóságban a monitor beállításainak és panel típusok miatt.' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = '* A képernyőn látható szövet és termék színek eltérhetnek a valóságban a monitor beállításainak és panel típusok miatt.' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = '* A képernyőn látható szövet és termék színek eltérhetnek a valóságban a monitor beállításainak és panel típusok miatt.' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Cikkszám' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Tulajdonságok és méretek' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'cm' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'cm' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'cm' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'cm' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'cm' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'cm' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'cm' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'cm' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'cm' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'cm' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Szövetek' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'FABRICS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'További információt a szövetekről <b>itt</b> talál' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Hasonló termékeink' LIMIT 1 | 1 | 1 | 0 | |
SELECT `CommunityProfile`.`id`, `CommunityProfile`.`short_id`, `CommunityProfile`.`profile_name`, `CommunityProfile`.`profile_link`, `CommunityProfile`.`api_code`, `CommunityProfile`.`button_code` FROM `c1milo`.`milol_community_profiles` AS `CommunityProfile` WHERE 1 = 1 | 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`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'TOPMENU' | 5 | 5 | 0 | |
SELECT `Language`.`id`, `Language`.`name`, `Language`.`locale_code`, `Language`.`locale_dir`, `Language`.`enabled`, `Language`.`set_as_default` FROM `c1milo`.`milol_languages` AS `Language` WHERE `Language`.`enabled` = '1' | 4 | 4 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'MAINMENU' | 1 | 1 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `enabled` = '1' ORDER BY `sort` ASC | 13 | 13 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'MOBILEMENU' | 3 | 3 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`product_profile_id`, `ProductCategory`.`title`, `ProductCategory`.`seo_title`, `ProductCategory`.`seo_desc`, `ProductCategory`.`seo_keyw`, `ProductCategory`.`details`, `ProductCategory`.`picture`, `ProductCategory`.`silhouette`, `ProductCategory`.`sort`, `ProductCategory`.`main_page`, `ProductCategory`.`enabled`, `ProductCategory`.`created`, `ProductCategory`.`modified`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title`, (`I18n__details`.`content`) AS `ProductCategory__i18n_details`, (`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__silhouette`.`content`) AS `ProductCategory__i18n_silhouette` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__details` ON (`ProductCategory`.`id` = `I18n__details`.`foreign_key` AND `I18n__details`.`model` = 'ProductCategory' AND `I18n__details`.`field` = 'details' AND `I18n__details`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_product_category_i18ns` AS `I18n__silhouette` ON (`ProductCategory`.`id` = `I18n__silhouette`.`foreign_key` AND `I18n__silhouette`.`model` = 'ProductCategory' AND `I18n__silhouette`.`field` = 'silhouette' AND `I18n__silhouette`.`locale` = 'hun') WHERE `enabled` = '1' ORDER BY `sort` ASC | 13 | 13 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Keresés' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Írja ide a keresett terméket...' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Miló Bútor Kft.' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'A weboldalon szereplő megnevezések, ábrák és fotók a Miló Bútor Kft. tulajdonát képezik, szerzői jogvédelem alatt állnak, engedély nélküli felhasználásuk jogi lépéseket von maga után. © 2022.' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`menu_id` = 'FOOTER' | 2 | 2 | 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__link`.`content`) AS `StaticPage__i18n_link`, (`I18n__prolog`.`content`) AS `StaticPage__i18n_prolog`, (`I18n__content`.`content`) AS `StaticPage__i18n_content`, (`I18n__seo_title`.`content`) AS `StaticPage__i18n_seo_title`, (`I18n__seo_desc`.`content`) AS `StaticPage__i18n_seo_desc`, (`I18n__seo_keys`.`content`) AS `StaticPage__i18n_seo_keys` FROM `c1milo`.`milol_static_pages` AS `StaticPage` LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_static_page_i18ns` AS `I18n__link` ON (`StaticPage`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'StaticPage' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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') LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_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 `c1milo`.`milol_static_page_i18ns` AS `I18n__seo_keys` ON (`StaticPage`.`id` = `I18n__seo_keys`.`foreign_key` AND `I18n__seo_keys`.`model` = 'StaticPage' AND `I18n__seo_keys`.`field` = 'seo_keys' AND `I18n__seo_keys`.`locale` = 'hun') WHERE `StaticPage`.`short_id` = 'COOKIE' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Elfogadom' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Keresés' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Keresés a termék nevére' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Kezdje el begépelni a termék nevét...' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Keresés' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Részletes keresés' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'A kategória kiválasztása után, az illusztráció alapján megadhatja a bútor méreteit.<br>Nem szükséges minden mezőt kitölteni!' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductCategory`.`id`, (`I18n__title`.`content`) AS `ProductCategory__i18n_title` FROM `c1milo`.`milol_product_categories` AS `ProductCategory` LEFT JOIN `c1milo`.`milol_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') WHERE `ProductCategory`.`enabled` = '1' AND `ProductCategory`.`product_profile_id` IS NOT NULL | 13 | 13 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Kérem, válasszon termék kategóriát...' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Keresés' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'PARTNERS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`string_key`, `Translation`.`string_translations`, `Translation`.`created` FROM `c1milo`.`milol_translations` AS `Translation` WHERE `Translation`.`string_key` = 'Hol vásárolhatom meg?' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'COMPETITIONS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'APPLICATIONS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`route_type`, `Route`.`menu_id`, `Route`.`short_id`, `Route`.`parent_of`, `Route`.`name`, `Route`.`route_alias`, `Route`.`controller`, `Route`.`action`, `Route`.`param_pass_mode`, `Route`.`static_parameters`, `Route`.`enabled`, `Route`.`sort`, `Route`.`plugin`, `Route`.`static_link`, `Route`.`dynamic`, `Route`.`dynamic_link`, `Route`.`sitemap`, (`I18n__name`.`content`) AS `Route__i18n_name`, (`I18n__route_alias`.`content`) AS `Route__i18n_route_alias`, (`I18n__dynamic_link`.`content`) AS `Route__i18n_dynamic_link`, `Menu`.`id`, `Menu`.`name`, `Menu`.`enabled` FROM `c1milo`.`milol_routes` AS `Route` LEFT JOIN `c1milo`.`milol_menus` AS `Menu` ON (`Route`.`menu_id` = `Menu`.`id`) LEFT JOIN `c1milo`.`milol_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 `c1milo`.`milol_route_i18ns` AS `I18n__route_alias` ON (`Route`.`id` = `I18n__route_alias`.`foreign_key` AND `I18n__route_alias`.`model` = 'Route' AND `I18n__route_alias`.`field` = 'route_alias' AND `I18n__route_alias`.`locale` = 'hun') LEFT JOIN `c1milo`.`milol_route_i18ns` AS `I18n__dynamic_link` ON (`Route`.`id` = `I18n__dynamic_link`.`foreign_key` AND `I18n__dynamic_link`.`model` = 'Route' AND `I18n__dynamic_link`.`field` = 'dynamic_link' AND `I18n__dynamic_link`.`locale` = 'hun') WHERE `Route`.`short_id` = 'COMPETITIONSERFA' LIMIT 1 | 1 | 1 | 0 |
Peak Memory Use 63.61 MB
Message | Memory use |
---|---|
Component initialization | 1.54 MB |
Controller action start | 2.69 MB |
Controller render start | 11.65 MB |
Component initialization #2 | 13.18 MB |
Controller action start #2 | 13.35 MB |
Component initialization #3 | 13.47 MB |
Controller action start #3 | 13.56 MB |
View render complete | 13.57 MB |
Total Request Time: 2242 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 9.46 | |
Event: Controller.initialize | 4.54 | |
Event: Controller.startup | 0.65 | |
Controller action | 1702.94 | |
Event: Controller.beforeRender | 232.03 | |
» Processing toolbar data | 219.58 | |
Rendering View | 39.38 | |
» Event: View.beforeRender | 1.69 | |
» Rendering ROOT/plugins/Webshop/View/Products/view_product.ctp | 13.00 | |
» Event: View.afterRender | 0.04 | |
» Event: View.beforeLayout | 0.03 | |
» Rendering APP/View/Layouts/default.ctp | 23.20 | |
» » Rendering ROOT/plugins/Webshop/View/Elements/product_searchbar.ctp | 0.56 | |
» » Event: Controller.initialize #2 | 0.91 | |
» » Event: Controller.startup #2 | 0.10 | |
Controller action #2 | 0.00 | |
» » » Event: Controller.shutdown | 0.05 | |
» » » Event: Controller.initialize #3 | 0.66 | |
» » » Event: Controller.startup #3 | 0.16 | |
Controller action #3 | 0.00 | |
» » » » Event: Controller.shutdown #2 | 0.08 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
BASEPATH | /var/www/clients/client1/web153/web/app/webroot/images/ |
WATERMARK | /var/www/clients/client1/web153/web/app/webroot/images/watermark.png |
SHOPCONFIG | /var/www/clients/client1/web153/web/plugins/Webshop/Config/shopconfig.json |
CURRENCIES | /var/www/clients/client1/web153/web/plugins/Webshop/Config/currencies.json |
SORTABLE | 1 |
EXPORTABLE | 2 |
IMPORTABLE | 4 |
TRANSLATABLE | 8 |
MODELCONFIG | /var/www/clients/client1/web153/web/ecp/Model/behavior_config.json |
PICTDIR | /var/www/clients/client1/web153/web/app/webroot/images/products/ |
Constant | Value |
---|---|
APP | /var/www/clients/client1/web153/web/app/ |
APP_DIR | app |
APPLIBS | /var/www/clients/client1/web153/web/app/Lib/ |
CACHE | /var/www/clients/client1/web153/web/app/tmp/cache/ |
CAKE | /var/www/clients/client1/web153/web/lib/Cake/ |
CAKE_CORE_INCLUDE_PATH | /var/www/clients/client1/web153/web/lib |
CORE_PATH | /var/www/clients/client1/web153/web/lib/ |
CAKE_VERSION | 2.6.10 |
CSS | /var/www/clients/client1/web153/web/app/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | https://milobutor.hu |
IMAGES | /var/www/clients/client1/web153/web/app/webroot/img/ |
IMAGES_URL | img/ |
JS | /var/www/clients/client1/web153/web/app/webroot/js/ |
JS_URL | js/ |
LOGS | /var/www/clients/client1/web153/web/app/tmp/logs/ |
ROOT | /var/www/clients/client1/web153/web |
TESTS | /var/www/clients/client1/web153/web/app/Test/ |
TMP | /var/www/clients/client1/web153/web/app/tmp/ |
VENDORS | /var/www/clients/client1/web153/web/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /var/www/clients/client1/web153/web/app/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 5.6.40-0+deb8u8 |
Php Document Root | /var/www/clients/client1/web153 |
Phprc | /etc/php5/cgi/ |
Pwd | /var/www/php-fcgi-scripts/web153 |
Php Fcgi Max Requests | 5000 |
Shlvl | 0 |
Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin |
Content Length | 0 |
Http Connection | close |
Script Name | /app/webroot/index.php |
Request Uri | /termek/milo-butor--izabell-ulogarnitura/427 |
Query String | |
Request Method | GET |
Server Protocol | HTTP/1.1 |
Gateway Interface | CGI/1.1 |
Redirect Url | /app/webroot/termek/milo-butor--izabell-ulogarnitura/427 |
Remote Port | 44612 |
Script Filename | /var/www/milobutor.hu/web/app/webroot/index.php |
Server Admin | webmaster@milobutor.hu |
Context Document Root | /var/www/milobutor.hu/web |
Context Prefix | |
Request Scheme | https |
Document Root | /var/www/milobutor.hu/web |
Remote Addr | 18.216.190.167 |
Server Port | 443 |
Server Addr | 193.138.125.124 |
Server Name | milobutor.hu |
Server Software | Apache/2.4.25 |
Server Signature | <address>Apache/2.4.25 Server at milobutor.hu Port 443</address> |
Http Host | milobutor.hu |
Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Http Accept | */* |
Ssl Tls Sni | milobutor.hu |
Https | on |
Script Uri | https://milobutor.hu/termek/milo-butor--izabell-ulogarnitura/427 |
Script Url | /termek/milo-butor--izabell-ulogarnitura/427 |
Redirect Status | 200 |
Redirect Ssl Tls Sni | milobutor.hu |
Redirect Https | on |
Redirect Script Uri | https://milobutor.hu/termek/milo-butor--izabell-ulogarnitura/427 |
Redirect Script Url | /termek/milo-butor--izabell-ulogarnitura/427 |
Redirect Redirect Status | 200 |
Redirect Redirect Ssl Tls Sni | milobutor.hu |
Redirect Redirect Https | on |
Redirect Redirect Script Uri | https://milobutor.hu/termek/milo-butor--izabell-ulogarnitura/427 |
Redirect Redirect Script Url | /termek/milo-butor--izabell-ulogarnitura/427 |
Fcgi Role | RESPONDER |
Php Self | /app/webroot/index.php |
Request Time Float | 1714134941.4772 |
Request Time | 1714134941 |