New Orange Brandy < Astrum Wine Cellars

Filter by:

New Orange Brandy

Villa Zarri
Emilia Romagna, Italy

Method & Production

This liqueur is made by infusing Villa Zarri Brandy (which is aged for 7 years in 350 litre French oak barrels), with fresh orange peel and adding sugar. The oranges come exclusively from Italian orange groves.

Tasting notes

Topaz in colour with a mahogany sheen. It releases sophisticated hints of candied orange, ginger, vanilla, eucalyptus, cinnamon, pastry, and tea leaves on the nose. The palate is won over by the impact of the precious balance between warmth and sweetness. Enveloping, slightly spicy, long, and seductive personality. The lingering aftertaste of candied fruit and sweet tobacco is endless.

Food matching

The New Villa Zarri Orange Brandy can be consumed neat or with ice, at the end of a meal, but can also be used to create excellent cocktails, or in cooking, for the preparation of deliciously boozy desserts.

Details

Code: VZ847

Please log in to see prices Product Fact SheetDetails

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent3c457399d45c1effc9f86f4954ab0471
  time1730383781
  countdown10
====
Request
+
Request

Cake Params
- pluginproduct
- controllerproducts
- actiondisplay
- named(array)
  page24
  limit12
- pass(array)
  0VZ847
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(array)
  __page/products/details
- defaults(array)
  pluginproduct
  controllerproducts
  actiondisplay
- template/products/details/*
====

Sql Log

Sql Logs

default

Total Time: 24 ms
Total Queries: 45 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `AppPreference`.`id`, `AppPreference`.`application_name`, `AppPreference`.`email`, `AppPreference`.`mail_recipients`, `AppPreference`.`logo_id`, `AppPreference`.`intro_top`, `AppPreference`.`intro_detail`, `AppPreference`.`intro_link_id`, `AppPreference`.`404_not_found_page_id`, `AppPreference`.`smtp_host`, `AppPreference`.`smtp_port`, `AppPreference`.`smtp_username`, `AppPreference`.`smtp_password`, `AppPreference`.`meta_title`, `AppPreference`.`meta_show_title`, `AppPreference`.`meta_reverse_title`, `AppPreference`.`pdf_cover_details`, `AppPreference`.`pdf_inside_cover_file`, `AppPreference`.`pdf_introduction`, `AppPreference`.`pdf_details`, `AppPreference`.`pdf_terms_and_conditions`, `AppPreference`.`google_analytics`, `AppPreference`.`ga_username`, `AppPreference`.`ga_password`, `AppPreference`.`ga_report_id`, `AppPreference`.`userlog_record_limit`, `AppPreference`.`userlog_time_limit`, `AppPreference`.`created`, `AppPreference`.`modified` FROM `astrum`.`oc_app_preferences` AS `AppPreference` WHERE 1 = 1 LIMIT 1	1	1	1
SELECT `AppPreferenceExpanded`.`id`, `AppPreferenceExpanded`.`app_preference_id`, `AppPreferenceExpanded`.`key`, `AppPreferenceExpanded`.`value`, `AppPreferenceExpanded`.`created`, `AppPreferenceExpanded`.`modified` FROM `astrum`.`oc_app_preferences_extended` AS `AppPreferenceExpanded` WHERE `AppPreferenceExpanded`.`app_preference_id` = (1)	10	10	0
SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`frontpage_page_id`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_frontpage_rewrites` AS `FrontpageRewrite` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRewrite`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRewrite`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRewrite`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRewrite`.`old` = '/products/details/VZ847/page:24/limit:12' AND `FrontpageRewrite`.`status` = 1 LIMIT 1	0	0	1	maybe slow
SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`frontpage_page_id`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_frontpage_rewrites` AS `FrontpageRewrite` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRewrite`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRewrite`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRewrite`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRewrite`.`old` LIKE '%*' AND `FrontpageRewrite`.`status` = 1	0	0	1	maybe slow
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`url` = '/products/details' LIMIT 1	1	1	1
SELECT `FrontpagePage`.`nleft`, `FrontpagePage`.`nright` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 33 LIMIT 1	1	1	0
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE 1 = 1 AND `FrontpagePage`.`nleft` <= 63 AND `FrontpagePage`.`nright` >= 64 ORDER BY `FrontpagePage`.`nleft` asc	3	3	0
SELECT `Product`.`id`, `Product`.`uid`, `Product`.`title`, `Product`.`slug`, `Product`.`code`, `Product`.`business_price`, `Product`.`product_category_id`, `Product`.`product_grape_variety_id`, `Product`.`geography_region_id`, `Product`.`vintage`, `Product`.`vineage`, `Product`.`product_producer_id`, `Product`.`product_distributor_id`, `Product`.`product_range_id`, `Product`.`soil`, `Product`.`training`, `Product`.`yield`, `Product`.`ageing`, `Product`.`vinification`, `Product`.`alcohol`, `Product`.`product_bottle_closure_type_id`, `Product`.`product_bottle_size_id`, `Product`.`product_case_size_id`, `Product`.`ph_level`, `Product`.`acidity`, `Product`.`residual_sugar_content`, `Product`.`method_and_production`, `Product`.`tasting_notes`, `Product`.`food_match`, `Product`.`status`, `Product`.`sorting`, `Product`.`created`, `Product`.`created_by`, `Product`.`modified`, `Product`.`modified_by`, `ProductProducer`.`name`, `ProductProducer`.`slug`, `ProductDistributor`.`title`, `ProductDistributor`.`slug`, `ProductCaseSize`.`title`, `ProductBottleSize`.`title`, `ProductBottleClosureType`.`title`, `GeographyRegion`.`title`, `GeographyRegion`.`slug`, `GeographyRegion`.`geography_country_id` FROM `astrum`.`oc_products` AS `Product` LEFT JOIN `astrum`.`oc_product_producers` AS `ProductProducer` ON (`Product`.`product_producer_id` = `ProductProducer`.`id`) LEFT JOIN `astrum`.`oc_product_distributors` AS `ProductDistributor` ON (`Product`.`product_distributor_id` = `ProductDistributor`.`id`) LEFT JOIN `astrum`.`oc_product_case_sizes` AS `ProductCaseSize` ON (`Product`.`product_case_size_id` = `ProductCaseSize`.`id`) LEFT JOIN `astrum`.`oc_product_bottle_sizes` AS `ProductBottleSize` ON (`Product`.`product_bottle_size_id` = `ProductBottleSize`.`id`) LEFT JOIN `astrum`.`oc_product_bottle_closure_types` AS `ProductBottleClosureType` ON (`Product`.`product_bottle_closure_type_id` = `ProductBottleClosureType`.`id`) LEFT JOIN `astrum`.`oc_geography_regions` AS `GeographyRegion` ON (`Product`.`geography_region_id` = `GeographyRegion`.`id`) WHERE `Product`.`code` = 'VZ847' AND `Product`.`status` = '1' LIMIT 1	1	1	2	maybe slow
SELECT `GeographyCountry`.`title`, `GeographyCountry`.`slug` FROM `astrum`.`oc_geography_countries` AS `GeographyCountry` WHERE `GeographyCountry`.`id` = 5	1	1	0
SELECT `ProductImage`.`title`, `ProductImage`.`image_id`, `ProductImage`.`product_id` FROM `astrum`.`oc_product_images` AS `ProductImage` WHERE `ProductImage`.`status` = '1' AND `ProductImage`.`product_id` = (1111) ORDER BY `ProductImage`.`sorting` asc	1	1	0
SELECT `ProductBox`.`id`, `ProductBox`.`product_id`, `ProductBox`.`title`, `ProductBox`.`text`, `ProductBox`.`image_id`, `ProductBox`.`document_id`, `ProductBox`.`document_title`, `ProductBox`.`status`, `ProductBox`.`sorting`, `ProductBox`.`created`, `ProductBox`.`created_by`, `ProductBox`.`modified`, `ProductBox`.`modified_by` FROM `astrum`.`oc_product_boxes` AS `ProductBox` WHERE `ProductBox`.`product_id` = (1111)	0	0	0
SELECT `ProductGrapeVarietyProduct`.`percentage`, `ProductGrapeVarietyProduct`.`product_grape_variety_id`, `ProductGrapeVarietyProduct`.`product_id` FROM `astrum`.`oc_product_grape_variety_products` AS `ProductGrapeVarietyProduct` WHERE `ProductGrapeVarietyProduct`.`product_id` = (1111) ORDER BY `ProductGrapeVarietyProduct`.`percentage` desc	1	1	0
SELECT `ProductGrapeVariety`.`title` FROM `astrum`.`oc_product_grape_varieties` AS `ProductGrapeVariety` WHERE `ProductGrapeVariety`.`id` = 4	1	1	0
SELECT `ProductCategory`.`title`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `astrum`.`oc_product_categories` AS `ProductCategory` JOIN `astrum`.`oc_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` = 1111 AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`)	2	2	0
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`extract`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`asset_folder_id`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`path`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `SourceAsset`.`id`, `SourceAsset`.`parent_id`, `SourceAsset`.`uid`, `SourceAsset`.`name`, `SourceAsset`.`caption`, `SourceAsset`.`ext`, `SourceAsset`.`size`, `SourceAsset`.`width`, `SourceAsset`.`height`, `SourceAsset`.`extract`, `SourceAsset`.`created`, `SourceAsset`.`created_by`, `SourceAsset`.`modified`, `SourceAsset`.`modified_by`, `SourceAsset`.`sorting`, `SourceAsset`.`status`, `SourceAsset`.`path`, `SourceAsset`.`tags`, `SourceAsset`.`crop_params`, `SourceAsset`.`flash_video_ready`, `SourceAsset`.`video_thumbnail_ready`, `SourceAsset`.`asset_folder_id`, `SourceAsset`.`object`, `SourceAsset`.`object_id`, `SourceAsset`.`object_alias`, `SourceAsset`.`google_drive_file_id`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_assets` AS `Asset` LEFT JOIN `astrum`.`oc_asset_folders` AS `AssetFolder` ON (`Asset`.`asset_folder_id` = `AssetFolder`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `SourceAsset` ON (`Asset`.`parent_id` = `SourceAsset`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 3516 LIMIT 1	1	1	1
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `astrum`.`oc_asset_categories` AS `AssetCategory` JOIN `astrum`.`oc_asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 3516 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`)	0	0	0
SELECT `AssetTag`.`id`, `AssetTag`.`name`, `AssetTag`.`slug`, `AssetTag`.`used`, `AssetTag`.`created`, `AssetTag`.`created_by`, `AssetTag`.`modified`, `AssetTag`.`modified_by`, `AssetTagsAsset`.`id`, `AssetTagsAsset`.`asset_id`, `AssetTagsAsset`.`asset_tag_id`, `AssetTagsAsset`.`created`, `AssetTagsAsset`.`modified`, `AssetTagsAsset`.`sorting`, `AssetTagsAsset`.`created_by`, `AssetTagsAsset`.`modified_by` FROM `astrum`.`oc_asset_tags` AS `AssetTag` JOIN `astrum`.`oc_asset_tags_assets` AS `AssetTagsAsset` ON (`AssetTagsAsset`.`asset_id` = 3516 AND `AssetTagsAsset`.`asset_tag_id` = `AssetTag`.`id`) ORDER BY `AssetTagsAsset`.`sorting` ASC	0	0	0
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`extract`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`asset_folder_id`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`path`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `SourceAsset`.`id`, `SourceAsset`.`parent_id`, `SourceAsset`.`uid`, `SourceAsset`.`name`, `SourceAsset`.`caption`, `SourceAsset`.`ext`, `SourceAsset`.`size`, `SourceAsset`.`width`, `SourceAsset`.`height`, `SourceAsset`.`extract`, `SourceAsset`.`created`, `SourceAsset`.`created_by`, `SourceAsset`.`modified`, `SourceAsset`.`modified_by`, `SourceAsset`.`sorting`, `SourceAsset`.`status`, `SourceAsset`.`path`, `SourceAsset`.`tags`, `SourceAsset`.`crop_params`, `SourceAsset`.`flash_video_ready`, `SourceAsset`.`video_thumbnail_ready`, `SourceAsset`.`asset_folder_id`, `SourceAsset`.`object`, `SourceAsset`.`object_id`, `SourceAsset`.`object_alias`, `SourceAsset`.`google_drive_file_id`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_assets` AS `Asset` LEFT JOIN `astrum`.`oc_asset_folders` AS `AssetFolder` ON (`Asset`.`asset_folder_id` = `AssetFolder`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `SourceAsset` ON (`Asset`.`parent_id` = `SourceAsset`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 3516 LIMIT 1	1	1	1
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `astrum`.`oc_asset_categories` AS `AssetCategory` JOIN `astrum`.`oc_asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 3516 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`)	0	0	0
SELECT `AssetTag`.`id`, `AssetTag`.`name`, `AssetTag`.`slug`, `AssetTag`.`used`, `AssetTag`.`created`, `AssetTag`.`created_by`, `AssetTag`.`modified`, `AssetTag`.`modified_by`, `AssetTagsAsset`.`id`, `AssetTagsAsset`.`asset_id`, `AssetTagsAsset`.`asset_tag_id`, `AssetTagsAsset`.`created`, `AssetTagsAsset`.`modified`, `AssetTagsAsset`.`sorting`, `AssetTagsAsset`.`created_by`, `AssetTagsAsset`.`modified_by` FROM `astrum`.`oc_asset_tags` AS `AssetTag` JOIN `astrum`.`oc_asset_tags_assets` AS `AssetTagsAsset` ON (`AssetTagsAsset`.`asset_id` = 3516 AND `AssetTagsAsset`.`asset_tag_id` = `AssetTag`.`id`) ORDER BY `AssetTagsAsset`.`sorting` ASC	0	0	0
SELECT `FrontpagePage`.`title`, `FrontpagePage`.`url`, `FrontpageContent`.`id` FROM `astrum`.`oc_frontpage_contents` AS `FrontpageContent` inner JOIN `astrum`.`oc_frontpage_contents_frontpage_elements` AS `FrontpageContentsFrontpageElement` ON (`FrontpageContentsFrontpageElement`.`frontpage_content_id` = `FrontpageContent`.`id`) inner JOIN `astrum`.`oc_frontpage_elements` AS `FrontpageElement` ON (`FrontpageElement`.`id` = `FrontpageContentsFrontpageElement`.`frontpage_element_id` AND `FrontpageElement`.`id` = 3) LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageContent`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` ON (`FrontpageContent`.`frontpage_content_category_id` = `FrontpageContentCategory`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `Image` ON (`FrontpageContent`.`image_id` = `Image`.`id`) LEFT JOIN `astrum`.`oc_quotes` AS `Quote` ON (`FrontpageContent`.`quote_id` = `Quote`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageContent`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageContent`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageContent`.`status` = '1' AND `FrontpagePage`.`status` = '1' AND `FrontpageElement`.`id` = 3 LIMIT 1	1	1	1
SELECT `FrontpageContentDocument`.`id`, `FrontpageContentDocument`.`frontpage_content_id`, `FrontpageContentDocument`.`document_id`, `FrontpageContentDocument`.`created`, `FrontpageContentDocument`.`created_by`, `FrontpageContentDocument`.`modified`, `FrontpageContentDocument`.`modified_by`, `FrontpageContentDocument`.`status` FROM `astrum`.`oc_frontpage_content_documents` AS `FrontpageContentDocument` WHERE `FrontpageContentDocument`.`frontpage_content_id` = (16) ORDER BY `FrontpageContentDocument`.`created` desc	0	0	0
SELECT `FrontpageElement`.`id`, `FrontpageElement`.`name`, `FrontpageElement`.`path`, `FrontpageElement`.`created`, `FrontpageElement`.`modified`, `FrontpageContentsFrontpageElement`.`id`, `FrontpageContentsFrontpageElement`.`frontpage_element_id`, `FrontpageContentsFrontpageElement`.`frontpage_content_id` FROM `astrum`.`oc_frontpage_elements` AS `FrontpageElement` JOIN `astrum`.`oc_frontpage_contents_frontpage_elements` AS `FrontpageContentsFrontpageElement` ON (`FrontpageContentsFrontpageElement`.`frontpage_content_id` = 16 AND `FrontpageContentsFrontpageElement`.`frontpage_element_id` = `FrontpageElement`.`id`)	1	1	0
SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'header' AND `FrontpagePage`.`type` = 'folder' LIMIT 1	1	1	0
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 26 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc	5	5	1	maybe slow
SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'main' AND `FrontpagePage`.`type` = 'folder' LIMIT 1	1	1	0
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 1 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc	7	7	1	maybe slow
SELECT `CookieCompliance`.`id`, `CookieCompliance`.`content`, `CookieCompliance`.`page_id`, `CookieCompliance`.`created`, `CookieCompliance`.`created_by`, `CookieCompliance`.`modified`, `CookieCompliance`.`modified_by`, `CookieCompliance`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_cookie_compliances` AS `CookieCompliance` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`CookieCompliance`.`page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`CookieCompliance`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`CookieCompliance`.`modified_by` = `ModifiedBy`.`id`) WHERE 1 = 1 LIMIT 1	1	1	1
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`extract`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`asset_folder_id`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`path`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `SourceAsset`.`id`, `SourceAsset`.`parent_id`, `SourceAsset`.`uid`, `SourceAsset`.`name`, `SourceAsset`.`caption`, `SourceAsset`.`ext`, `SourceAsset`.`size`, `SourceAsset`.`width`, `SourceAsset`.`height`, `SourceAsset`.`extract`, `SourceAsset`.`created`, `SourceAsset`.`created_by`, `SourceAsset`.`modified`, `SourceAsset`.`modified_by`, `SourceAsset`.`sorting`, `SourceAsset`.`status`, `SourceAsset`.`path`, `SourceAsset`.`tags`, `SourceAsset`.`crop_params`, `SourceAsset`.`flash_video_ready`, `SourceAsset`.`video_thumbnail_ready`, `SourceAsset`.`asset_folder_id`, `SourceAsset`.`object`, `SourceAsset`.`object_id`, `SourceAsset`.`object_alias`, `SourceAsset`.`google_drive_file_id`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_assets` AS `Asset` LEFT JOIN `astrum`.`oc_asset_folders` AS `AssetFolder` ON (`Asset`.`asset_folder_id` = `AssetFolder`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `SourceAsset` ON (`Asset`.`parent_id` = `SourceAsset`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 3503 LIMIT 1	1	1	1
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `astrum`.`oc_asset_categories` AS `AssetCategory` JOIN `astrum`.`oc_asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 3503 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`)	0	0	0
SELECT `AssetTag`.`id`, `AssetTag`.`name`, `AssetTag`.`slug`, `AssetTag`.`used`, `AssetTag`.`created`, `AssetTag`.`created_by`, `AssetTag`.`modified`, `AssetTag`.`modified_by`, `AssetTagsAsset`.`id`, `AssetTagsAsset`.`asset_id`, `AssetTagsAsset`.`asset_tag_id`, `AssetTagsAsset`.`created`, `AssetTagsAsset`.`modified`, `AssetTagsAsset`.`sorting`, `AssetTagsAsset`.`created_by`, `AssetTagsAsset`.`modified_by` FROM `astrum`.`oc_asset_tags` AS `AssetTag` JOIN `astrum`.`oc_asset_tags_assets` AS `AssetTagsAsset` ON (`AssetTagsAsset`.`asset_id` = 3503 AND `AssetTagsAsset`.`asset_tag_id` = `AssetTag`.`id`) ORDER BY `AssetTagsAsset`.`sorting` ASC	0	0	0
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 33 LIMIT 1	1	1	0
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpagePage`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpagePage`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpagePage`.`nleft` <= 63 AND `FrontpagePage`.`nright` >= 64 ORDER BY `FrontpagePage`.`nleft` asc	3	3	1	maybe slow
SELECT `FrontpageContent`.`id`, `FrontpageContent`.`frontpage_page_id`, `FrontpageContent`.`frontpage_content_category_id`, `FrontpageContent`.`image_id`, `FrontpageContent`.`image_alignment`, `FrontpageContent`.`image_link`, `FrontpageContent`.`uid`, `FrontpageContent`.`sorting`, `FrontpageContent`.`title`, `FrontpageContent`.`subtitle`, `FrontpageContent`.`content`, `FrontpageContent`.`style`, `FrontpageContent`.`external_url`, `FrontpageContent`.`quote_id`, `FrontpageContent`.`embed`, `FrontpageContent`.`created`, `FrontpageContent`.`created_by`, `FrontpageContent`.`modified`, `FrontpageContent`.`modified_by`, `FrontpageContent`.`status` FROM `astrum`.`oc_frontpage_contents` AS `FrontpageContent` WHERE `FrontpageContent`.`frontpage_page_id` IN (1, 12, 33) ORDER BY `FrontpageContent`.`sorting` asc	2	2	0
SELECT `FrontpageRoute`.`id`, `FrontpageRoute`.`route`, `FrontpageRoute`.`plugin`, `FrontpageRoute`.`controller`, `FrontpageRoute`.`action`, `FrontpageRoute`.`named`, `FrontpageRoute`.`pass`, `FrontpageRoute`.`frontpage_page_id`, `FrontpageRoute`.`route_class`, `FrontpageRoute`.`status`, `FrontpageRoute`.`sorting`, `FrontpageRoute`.`created`, `FrontpageRoute`.`created_by`, `FrontpageRoute`.`modified`, `FrontpageRoute`.`modified_by` FROM `astrum`.`oc_frontpage_routes` AS `FrontpageRoute` WHERE `FrontpageRoute`.`frontpage_page_id` IN (1, 12, 33)	2	2	0
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`used`, `Tag`.`tag_object_count`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`created_by`, `Tag`.`modified_by`, `TagObject`.`id`, `TagObject`.`tag_id`, `TagObject`.`object`, `TagObject`.`object_id`, `TagObject`.`sorting`, `TagObject`.`created`, `TagObject`.`modified` FROM `astrum`.`oc_tags` AS `Tag` JOIN `astrum`.`oc_tags_objects` AS `TagObject` ON (`TagObject`.`object_id` IN (1, 12, 33) AND `TagObject`.`tag_id` = `Tag`.`id`) WHERE `TagObject`.`object` = 'FrontpagePage' ORDER BY `TagObject`.`sorting` asc	0	0	0
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 12 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc	2	2	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`slug`, (CONCAT(`ProductCategory`.`title`, " (", `ProductCategory`.`product_count`, ")")) AS `ProductCategory__combo_title` FROM `astrum`.`oc_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`status` = '1' AND `ProductCategory`.`group` = 'wine' ORDER BY `ProductCategory`.`sorting` asc	10	10	0
SELECT `ProductCategoriesProduct`.`product_id` FROM `astrum`.`oc_product_categories_products` AS `ProductCategoriesProduct` WHERE `product_category_id` IN (4, 2, 3, 1, 5, 9, 10, 11, 12, 13)	1485	1485	1
SELECT `Product`.`geography_region_id`, `Product`.`code`, `Product`.`title`, `ProductProducer`.`name`, `ProductDistributor`.`title`, `ProductProducer`.`id`, `ProductDistributor`.`id` FROM `astrum`.`oc_products` AS `Product` LEFT JOIN `astrum`.`oc_product_producers` AS `ProductProducer` ON (`Product`.`product_producer_id` = `ProductProducer`.`id`) LEFT JOIN `astrum`.`oc_product_distributors` AS `ProductDistributor` ON (`Product`.`product_distributor_id` = `ProductDistributor`.`id`) WHERE `Product`.`status` = '1' AND `Product`.`id` IN (31, 32, 33, 34, 35, 36, 37, 38, 39, 41, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 157, 158, 159, 160, 163, 164, 165, 166, 167, 168, 169, 171, 172, 173, 174, 176, 177, 178, 179, 180, 181, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 201, 202, 203, 204, 205, 206, 207, 208, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 232, 233, 234, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 253, 254, 255, 256, 257, 259, 260, 261, 262, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 300, 301, 302, 307, 309, 327, 328, 329, 330, 332, 333, 334, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 354, 355, 356, 357, 358, 359, 360, 361, 363, 366, 367, 369, 370, 371, 372, 373, 374, 375, 376, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 393, 394, 396, 397, 398, 399, 400, 402, 403, 404, 405, 407, 408, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 426, 427, 428, 429, 430, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 469, 470, 471, 472, 476, 477, 478, 479, 480, 481, 482, 483, 484, 487, 488, 489, 490, 491, 492, 493, 494, 495, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 519, 520, 521, 522, 523, 524, 525, 526, 527, 529, 532, 533, 534, 535, 536, 537, 539, 540, 541, 543, 544, 545, 546, 547, 548, 549, 550, 554, 555, 556, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 578, 579, 580, 581, 582, 583, 584, 586, 587, 588, 589, 590, 591, 593, 594, 595, 596, 597, 598, 599, 600, 605, 606, 607, 608, 609, 617, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 638, 639, 640, 641, 642, 643, 646, 648, 649, 650, 651, 653, 654, 655, 656, 657, 658, 659, 660, 661, 664, 665, 667, 668, 669, 670, 671, 672, 673, 674, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 693, 696, 697, 702, 703, 704, 705, 706, 707, 708, 709, 710, 721, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 736, 737, 742, 743, 744, 745, 746, 747, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 779, 780, 782, 783, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 813, 814, 815, 816, 834, 835, 836, 837, 838, 839, 840, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 854, 855, 865, 866, 867, 868, 869, 870, 871, 873, 874, 876, 877, 880, 882, 884, 885, 886, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1047, 1048, 1049, 1050, 1051, 1052, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1077, 1078, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1149, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1266, 1267, 1268, 1269, 1270, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1289, 1294, 1295, 1296, 1297, 1298, 1299, 1300) ORDER BY `Product`.`title` asc	397	397	7
SELECT `GeographyRegion`.`id`, `GeographyRegion`.`geography_country_id` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` WHERE `id` IN (56, 25, 19, 32, 13, 21, 18, 67, 17, 7, 65, 59, 60, 27, 26, 8, 57, 16, 68, 15, 51, 62, 52, 4, 23, 29, 2, 39, 24, 61, 64, 55, 1, 11, 31, 48, 33, 49, 28, 40, 20, 43, 5)	43	43	0
SELECT `GeographyRegion`.`id`, `GeographyRegion`.`slug`, `GeographyRegion`.`title`, `GeographyCountry`.`id`, `GeographyCountry`.`slug`, `GeographyCountry`.`title`, `GeographyCountry`.`image_area_coordinates`, `GeographyCountry`.`image_area_coordinates_spirit` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` LEFT JOIN `astrum`.`oc_geography_countries` AS `GeographyCountry` ON (`GeographyRegion`.`geography_country_id` = `GeographyCountry`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`GeographyRegion`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`GeographyRegion`.`modified_by` = `ModifiedBy`.`id`) WHERE `GeographyRegion`.`id` IN (56, 25, 19, 32, 13, 21, 18, 67, 17, 7, 65, 59, 60, 27, 26, 8, 57, 16, 68, 15, 51, 62, 52, 4, 23, 29, 2, 39, 24, 61, 64, 55, 1, 11, 31, 48, 33, 49, 28, 40, 20, 43, 5) AND `GeographyRegion`.`status` = '1' AND `GeographyCountry`.`status` = '1' ORDER BY `GeographyCountry`.`title` asc, `GeographyRegion`.`sorting` asc	43	43	1
SELECT `ProductGrapeVariety`.`slug`, (CONCAT(`ProductGrapeVariety`.`title`, " (", `ProductGrapeVariety`.`product_count`, ")")) AS `ProductGrapeVariety__combo_title` FROM `astrum`.`oc_product_grape_varieties` AS `ProductGrapeVariety` WHERE `ProductGrapeVariety`.`status` = '1' ORDER BY `ProductGrapeVariety`.`title` asc	214	214	1
SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'footer' AND `FrontpagePage`.`type` = 'folder' LIMIT 1	1	1	0
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 2 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc	3	3	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 18.30 MB

Message	Memory use
Component initialization	4.92 MB
Controller action start	8.52 MB
Controller render start	10.20 MB
View render complete	15.42 MB

Timers

Total Request Time: 297 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	55.05
Event: Controller.initialize	42.92
Event: Controller.startup	1.19
Controller action	21.75
Event: Controller.beforeRender	16.52
» Processing toolbar data	16.17
Rendering View	101.18
» Event: View.beforeRender	0.07
» Rendering APP/Plugin/Product/View/Products/display.ctp	29.23
» » Rendering APP/Plugin/Product/View/Elements/product/gallery.ctp	13.42
» » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp	0.26
» » Rendering APP/Plugin/Product/View/Elements/product/facts.ctp	2.25
» » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp #2	0.21
» » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp #3	0.17
» » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp #4	0.17
» » Rendering APP/Plugin/Product/View/Elements/product/breadcrumbs.ctp	10.08
» » Rendering APP/Plugin/Product/View/Elements/product/content.ctp	0.37
» » Rendering APP/Plugin/Product/View/Elements/product/cta.ctp	1.91
» » » Rendering APP/Plugin/Product/View/Elements/product/pricing.ctp	0.43
» » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp #5	0.19
» Event: View.afterRender	0.08
» Event: View.beforeLayout	0.04
» Rendering APP/Plugin/Frontpage/View/Layouts/product-filters.ctp	70.22
» » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp	3.10
» » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #2	2.96
» » Rendering APP/Plugin/Frontpage/View/Elements/document/header.ctp	1.57
» » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/navigation.ctp #3	0.48
» » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp	0.19
» » Rendering APP/Plugin/Frontpage/View/Elements/page/header.ctp #2	6.17
» » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp #2	0.18
» » » Rendering APP/Plugin/Frontpage/View/Elements/social_sharing.ctp	1.90
» » » » Rendering APP/Plugin/Frontpage/View/Elements/share.ctp	1.45
» » Rendering APP/Plugin/Frontpage/View/Elements/sidebar.ctp	8.34
» » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav.ctp	8.10
» » » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav_item.ctp	1.05
» » Rendering APP/Plugin/Product/View/Elements/product/filters.ctp	38.66
» » Rendering APP/Plugin/Frontpage/View/Elements/page/footer.ctp	3.18
» » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #4	2.63
» » Rendering APP/Plugin/Frontpage/View/Elements/document/footer.ctp #2	1.08
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- title_for_layoutAstrum Wine Cellars | Details < Wine
- crumbs(array)
 0(array)
 titleHome
 url/
 options(null)
 1(array)
 titleWine
 url/products
 options(null)
 2(array)
 titleDetails
 url/products/details
 options(null)
- data(array)
 Product(array)
 id1111
 uid931935978
 titleNew Orange Brandy
 slugnew-orange-brandy
 codeVZ847
 business_price35.84
 product_category_id(null)
 product_grape_variety_id(null)
 geography_region_id19
 vintage(null)
 vineage(null)
 product_producer_id59
 product_distributor_id(null)
 product_range_id(null)
 soil
 training
 yield(null)
 ageing
 vinification
 alcohol40.0
 product_bottle_closure_type_id12
 product_bottle_size_id3
 product_case_size_id2
 ph_level
 acidity
 residual_sugar_content
 method_and_productionThis liqueur is made by infusing Villa Zarri Brandy (which is aged for 7 years in 350 litre French oak barrels), with fresh orange peel and adding sugar. The oranges come exclusively from Italian orange groves.
 tasting_notesTopaz in colour with a mahogany sheen. It releases sophisticated hints of candied orange, ginger, vanilla, eucalyptus, cinnamon, pastry, and tea leaves on the nose. The palate is won over by the impact of the precious balance between warmth and sweetness. Enveloping, slightly spicy, long, and seductive personality. The lingering aftertaste of candied fruit and sweet tobacco is endless.
 food_matchThe New Villa Zarri Orange Brandy can be consumed neat or with ice, at the end of a meal, but can also be used to create excellent cocktails, or in cooking, for the preparation of deliciously boozy desserts. 
 status(true)
 sorting(null)
 created2022-03-31 10:13:19
 created_by9
 modified2023-07-20 09:16:12
 modified_by9
 ProductProducer(array)
 nameVilla Zarri
 slugvilla-zarri
 ProductDistributor(array)
 title(null)
 slug(null)
 ProductCaseSize(array)
 title6
 ProductBottleSize(array)
 title0.5lt
 ProductBottleClosureType(array)
 titleStopper
 GeographyRegion(array)
 titleEmilia Romagna
 slugemilia-romagna
 geography_country_id5
 GeographyCountry(array)
 titleItaly
 slugitaly
 ProductImage(array)
 0(array)
 titleNew Orange Brandy, Villa Zarri
 image_id3516
 product_id1111
 ProductBox(empty)
 ProductGrapeVarietyProduct(array)
 0(array)
 percentage(null)
 product_grape_variety_id4
 product_id1111
 ProductGrapeVariety(array)
 titleGlera
 ProductCategory(array)
 0(array)
 titleVegan
 ProductCategoriesProduct(array)
 id15272
 product_id1111
 product_category_id12
 1(array)
 titleSpirits & Liqueurs
 ProductCategoriesProduct(array)
 id15271
 product_id1111
 product_category_id6
- hidePrice0
- ProductLib(object)
 data(array)
 categories(array)
 0(array)
 ProductCategory(array)
 id4
 slugsparkling-wine
 combo_titleSparkling Wine (21)
 1(array)
 ProductCategory(array)
 id2
 slugwhite-wine
 combo_titleWhite Wine (141)
 2(array)
 ProductCategory(array)
 id3
 slugrose-wine
 combo_titleRosé Wine (7)
 3(array)
 ProductCategory(array)
 id1
 slugred-wine
 combo_titleRed Wine (202)
 4(array)
 ProductCategory(array)
 id5
 slugdessert-wine
 combo_titleDessert Wine (17)
 5(array)
 ProductCategory(array)
 id9
 slugorganic
 combo_titleOrganic (55)
 6(array)
 ProductCategory(array)
 id10
 slugbiodynamic
 combo_titleBiodynamic (2)
 7(array)
 ProductCategory(array)
 id11
 slugorange-wine
 combo_titleOrange Wine (1)
 8(array)
 ProductCategory(array)
 id12
 slugvegan
 combo_titleVegan (272)
 9(array)
 ProductCategory(array)
 id13
 slugnatural
 combo_titleNatural (4)
 categoryOptions(array)
 sparkling-wineSparkling Wine (21)
 white-wineWhite Wine (141)
 rose-wineRosé Wine (7)
 red-wineRed Wine (202)
 dessert-wineDessert Wine (17)
 organicOrganic (55)
 biodynamicBiodynamic (2)
 orange-wineOrange Wine (1)
 veganVegan (272)
 naturalNatural (4)
 productsOptions(array)
 TF0319 Cornas 'Les Versantes', Thomas Farge
 TF0121 Saint-Joseph Rouge 'Grand Angle', Thomas Farge
 LL0523Aglianico Beneventano, Lapilli
 PI0719Aglianico Quirico, Pietracupa
 BZ0122Albana di Romagna 'Isola', Balìa di Zola
 LA0123Albariño, Lagar de Costa
 LA0823Albariño Natural, Lagar de Costa
 LA0221Albariño Tradición, Lagar de Costa
 ET4520Alta Langa DOCG Extra Brut, Ettore Germano
 PG0320Alta Valle della Greve 'Capogatto', Poggio Scalette
 PG0220Alta Valle della Greve 'Il Carbonaione', Poggio Scalette
 PG0420Alta Valle della Greve 'Piantonaia', Poggio Scalette
 LR0719Amarone della Valpolicella Classico, L'Arco
 SP0407Amarone della Valpolicella Classico Sant'Urbano, Speri
 SP0404Amarone della Valpolicella Classico Sant'Urbano, Speri
 SP0411Amarone della Valpolicella Classico Sant'Urbano, Speri
 SP0419Amarone della Valpolicella Classico Sant'Urbano, Speri
 MN0717Amarone della Valpolicella Riserva, Monte Tondo
 LR0220Arcum, L'Arco
 VI0819Asolo Prosecco Superiore DOCG Extra Dry , Vinvita
 PB0220Barbaresco, Produttori del Barbaresco
 PB1520Barbaresco - Magnum, Produttori del Barbaresco
 PB1620Barbaresco Double - Magnum, Produttori del Barbaresco
 PB0519Barbaresco Riserva 'Asili', Produttori del Barbaresco
 PB3316Barbaresco Riserva 'Don Fiorino', Produttori del Barbaresco
 PB0319Barbaresco Riserva 'Montefico' , Produttori del Barbaresco
 PB0719Barbaresco Riserva 'Montestefano' , Produttori del Barbaresco
 PB1219Barbaresco Riserva 'Muncagota' , Produttori del Barbaresco
 PB0419Barbaresco Riserva 'Ovello' , Produttori del Barbaresco
 PB0819Barbaresco Riserva 'Pajé' , Produttori del Barbaresco
 PB0619Barbaresco Riserva 'Pora', Produttori del Barbaresco
 PB0919Barbaresco Riserva 'Rabajà', Produttori del Barbaresco
 PB1119Barbaresco Riserva 'Rio Sordo' , Produttori del Barbaresco
 FR1021Barbera D'Alba, Francesco Rinaldi
 FB1022Barbera d'Asti, Folli & Benato
 OD0322Barbera d'Asti Superiore Nizza , Oddero
 FR0119Barolo , Francesco Rinaldi
 AR0218Barolo 'Undicicomuni', ArnaldoRivera
 FR0217Barolo Brunate, Francesco Rinaldi
 OD1018Barolo Brunate, Oddero
 OD4518Barolo Brunate - Magnum , Oddero
 AR0916Barolo Bussia, ArnaldoRivera
 FR0317Barolo Cannubi, Francesco Rinaldi
 AR0716Barolo Castello , ArnaldoRivera
 ET0519Barolo Cerretta, Ettore Germano
 OD0820Barolo Classico, Oddero
 OD4719Barolo Classico - Magnum , Oddero
 ET2719Barolo Prapò, Ettore Germano
 AR0816Barolo Ravera, ArnaldoRivera
 OD0717Barolo Riserva Bussia Vigna Mondoca, Oddero
 OD0917ABarolo Riserva Vignarionda, Oddero
 OD4115Barolo Riserva Vignarionda - Magnum , Oddero
 OD4117Barolo Riserva Vignarionda - Magnum , Oddero
 ET0720Barolo Serralunga, Ettore Germano
 ET1720Barolo Serralunga - Half Bottle, Ettore Germano
 ET3217Barolo Serralunga - Magnum, Ettore Germano
 AR0517Barolo Vignarionda , ArnaldoRivera
 OD0619Barolo Villero, Oddero
 AZ0123Beaujolais Villages 'Stellogonie', Domaine Azzara
 MI7022Bianco Friuli Colli Orientali, Miani
 TG0220Boca - Organic, Tenute Guardasole
 VD0124Bollicine Rosé, Serafini & Vidotto
 PD0123Bourgogne Chardonnay, Domaine de la Pierre des Dames
 VW0222Bourgogne Chardonnay, Vincent Wengier
 PD0423Bourgogne Pinot Noir, Domaine de la Pierre des Dames
 VW0822Bourgogne Pinot Noir 'Les Ardillers', Vincent Wengier
 TL0515Bramaterra, Tenute Sella
 NO0719Bramaterra Rocce di Luce, Noah
 NO0619Bramaterra Salero, Noah
 PM0123Branco, Passagem
 VZ110Brandy 10Yrs, Villa Zarri
 VZ124Brandy 23Yrs, Villa Zarri
 CR0119Brunello di Montalcino, Castello Romitorio
 CA9719Brunello di Montalcino, Caparzo
 CA9812Brunello di Montalcino 'La Casa', Caparzo
 CA9817Brunello di Montalcino 'La Casa', Caparzo
 CA9519Brunello di Montalcino - Half Bottle, Caparzo
 CA9418Brunello di Montalcino - Magnum, Caparzo
 CR0319Brunello di Montalcino Filo di Seta, Castello Romitorio
 CA9319Brunello di Montalcino Rio Cassero, Caparzo
 CA9916Brunello di Montalcino Riserva, Caparzo
 HI0124Brut Reserve, Highweald Wine Estate
 IC0623Cabernet Franc, I Clivi
 TC0313Calabria Bianco 'Manere', Tenuta del Conte
 AS0121Canaiolo, Ascione-Alongi
 GB0521Cannonau di Sardegna 'Lillové', Gabbas
 GB0616Cannonau di Sardegna Riserva Dule, Gabbas
 PC0120Carema Classico , Produttori del Carema
 FE0319Carema Etichetta Bianca, Ferrando
 FE0718Carema Etichetta Bianca - Magnum, Ferrando
 FE0419Carema Etichetta Nera , Ferrando
 FE0818Carema Etichetta Nera - Magnum, Ferrando
 PC0519Carema Riserva, Produttori del Carema
 PC0716Carema Selezione, Produttori del Carema
 GU0521Carjcanti - Organic, Gulfi
 GU0723Cerasuolo di Vittoria, Gulfi
 VW0322Chablis, Vincent Wengier
 VW0522Chablis - Half Bottle, Vincent Wengier
 EM0121Chablis Archives, Domaine des Pérégrins
 EM0720Chablis Archives Vieilles Vignes, Domaine des Pérégrins
 EM0620Chablis Pérégrinations Chronique, Domaine des Pérégrins
 EM0521Chablis Premier Cru Côte de Jouan, Domaine des Pérégrins
 BM0122Chablis Premier Cru Vaillons, Domaine Begue-Mathiot
 LH0514Champagne Grand Cru Blanc de Blancs 'Les Sillons', Legras & Haas
 LH0423Champagne Grand Cru Blanc de Blancs Extra Brut 'L’Évidence', Legras & Haas
 LH0621Champagne Grand Cru Blanc de Blancs Extra Brut 'L’Évidence' - Magnum, Legras & Haas
 LH0914Champagne Grand Cru Blanc de Blancs Millésime, Legras & Haas
 LH0223Champagne Intuition Brut , Legras & Haas
 LH0321Champagne Intuition Rosé Brut, Legras & Haas
 BA0124Champagne L’Éloquente Brut , Jean de la Fontaine
 WS0721Chardonnay, Winzerhof Stahl
 HI0422Chardonnay, Highweald Wine Estate
 FD0122Chardonnay 'Monopolia Sannicola', Fondo Indizeno
 MI7222Chardonnay Friuli Colli Orientali, Miani
 TE6622Chardonnay Kreuth, Cantina Terlano
 TE7822Chardonnay Kreuth - Magnum, Cantina Terlano
 CD1023Chardonnay Somereto, Cantina Andriano
 TE0223Chardonnay Tradition, Cantina Terlano
 MO0616Château-Chalon, Domaine Jean-Luc Mouillard
 OF0622Châteauneuf du Pape Blanc, Olivier & Lafont
 OF0820Châteauneuf du Pape Rouge, Olivier & Lafont
 VZ310Cherry Brandy, Villa Zarri
 SA0123Chianti 'Biskero' - Organic, Salcheto
 SA2123Chianti 'Biskero' - Organic - Magnum, Salcheto
 PG0122Chianti Classico, Poggio Scalette
 LC4822Chianti Classico - Half Bottle - Organic, Villa Le Corti - Principe Corsini
 LC4522Chianti Classico - Organic, Villa Le Corti - Principe Corsini
 LC4620Chianti Classico Riserva 'Cortevecchia' - Organic, Villa Le Corti - Principe Corsini
 SE0122Chiaretto Riviera del Garda Classico 'San Donino', Selva Capuzza
 RC0221Cialla Bianco , Ronchi di Cialla
 RC2521Cialla Bianco - Magnum, Ronchi di Cialla
 TC0122Cirò Bianco - Organic, Tenuta del Conte
 TC0522Cirò Rosato - Organic, Tenuta del Conte
 TC0218Cirò Rosso Classico Superiore - Organic, Tenuta del Conte
 VZ410Coffee Brandy, Villa Zarri
 BP0122Colección Malbec, Bodega Privada
 CU0119Colline Novaresi DOC Agamium, Antichi Vigneti di Cantalupo
 TF0723Collines Rhodaniennes Syrah 'Les Jardins de Chavagnac', Thomas Farge
 MN0422Corvina, Monte Tondo
 TM0120Costa Toscana Birillo - Organic, Tenuta Marsiliana - Principe Corsini
 NO0323Coste della Sesia 'Rossonoah', Noah
 TL0222Coste della Sesia Nebbiolo 'Orbello', Tenute Sella
 TL0723Coste della Sesia Rosato 'Majoli', Tenute Sella
 DL0123Côtes de Gascogne Blanc, Domaine de Papolle
 ME0123Côtes de Provence Rosé, Maison Étoilée
 MO0122Côtes du Jura Chardonnay 'Bas de la Chaux' , Domaine Jean-Luc Mouillard
 MO0518Côtes du Jura Savagnin, Domaine Jean-Luc Mouillard
 MO0220Côtes du Jura Savagnin 'Le Curieux' , Domaine Jean-Luc Mouillard
 OF0123Côtes du Rhône Blanc, Olivier & Lafont
 OF0221Côtes du Rhône Rouge, Olivier & Lafont
 MA0917Croatina Colli Tortonesi 'Montemirano', Claudio Mariotto
 OF0519Crozes-Hermitage, Olivier & Lafont
 HT0522Cuvée Auslese, Weingut Tschida Angerhof
 RU0622Doi Raps, Russolo
 FR2023Dolcetto D'Alba Roussot, Francesco Rinaldi
 AR1122Dolcetto Diano d'Alba 'Sorì del Cascinotto', ArnaldoRivera
 VZ846Dusk Manhatten Cherry Brandy, Villa Zarri
 VZ845Dusk Negroni Brandy, Villa Zarri
 FE0122Erbaluce di Caluso Etichetta Verde, Ferrando
 ML0123Etna Bianco, Monteleone
 FZ0121Etna Bianco Gamma, Federico Curtaz
 ML0322Etna Rosso, Monteleone
 FZ0220Etna Rosso Il Purgatorio, Federico Curtaz
 ET4024Extra Brut Rosé Metodo Classico 'Rosanna' , Ettore Germano
 LP0122Falanghina Beneventano, Lapilli
 PI0222Fiano, Pietracupa
 PI0420Fiano 'Il Cupo', Pietracupa
 CF0423Fiano - Organic, Caiaffa
 MZ0223Fiano Puglia, Mezzogiorno
 MA0421Freisa Colli Tortonesi Braghé, Claudio Mariotto
 RG2522Friulano Buri Bellaria, Ronco del Gnemiz
 IC0221Friulano Collio 'San Lorenzo', I Clivi
 MI7122Friulano Friuli Colli Orientali, Miani
 VS0323Furmint, Verus
 TR0318Gattinara Riserva , Travaglini
 TR1218Gattinara Riserva - Double Magnum, Travaglini
 TR1018Gattinara Riserva - Magnum, Travaglini
 TR0221Gattinara Selezione , Travaglini
 TR1320Gattinara Selezione - Double Magnum, Travaglini
 TR0919Gattinara Selezione - Magnum, Travaglini
 TR0519Gattinara Tre Vigne, Travaglini
 FB0123Gavi, Folli & Benato
 FR3023Gavi, Francesco Rinaldi
 FB0223Gavi del Comune di Gavi, Folli & Benato
 TE3223Gewürztraminer Tradition, Cantina Terlano
 CU0715Ghemme Anno Primo, Antichi Vigneti di Cantalupo
 CU0315Ghemme Collis Breclemae , Antichi Vigneti di Cantalupo
 CU0307Ghemme Collis Breclemae , Antichi Vigneti di Cantalupo
 CU0313Ghemme Collis Breclemae , Antichi Vigneti di Cantalupo
 CU0215Ghemme Collis Carellae, Antichi Vigneti di Cantalupo
 CU0208Ghemme Collis Carellae, Antichi Vigneti di Cantalupo
 HI0524Ghyll Valley White, Highweald Wine Estate
 PI0122Greco, Pietracupa
 LL0222Greco di Tufo , Lapilli
 CE0123Grillo 'Lumà', Cantine Cellaro
 CP0222Grillo 'Rocce di Pietra Longa' - Organic, Centopassi
 CP0122Grillo-Catarratto Giato Bianco - Organic, Centopassi
 BS0123Grüner Veltliner - Organic, Besas
 HT0918Grüner Veltliner Beerenauslese - Half Bottle, Weingut Tschida Angerhof
 IS0223Kerner, Cantina Valle Isarco
 IS0720Kerner 'Aristos', Cantina Valle Isarco
 MO0318L'Etoile Sélection , Domaine Jean-Luc Mouillard
 CD0723Lagrein 'Rubeno', Cantina Andriano
 TE1021Lagrein Riserva 'Gries', Cantina Terlano
 TE1720Lagrein Riserva 'Porphyr' , Cantina Terlano
 TE0923Lagrein Rosé Tradition, Cantina Terlano
 FR2322Langhe Freisa, Francesco Rinaldi
 AR0122Langhe Nascetta del Comune di Novello, ArnaldoRivera
 OD0121Langhe Nebbiolo, Oddero
 PB0122Langhe Nebbiolo , Produttori del Barbaresco
 ET1221Langhe Riesling Hérzu , Ettore Germano
 NO0419Lessona, Noah
 TL0619Lessona, Tenute Sella
 TL1513Lessona San Sebastiano allo Zoppo , Tenute Sella
 VZ210Liquore Nocino - Organic, Villa Zarri
 SE0222Lugana 'Selva', Selva Capuzza
 VG0119Lussac-Saint-Émilion 'Château Chéreau', Vignobles Silvestrini
 VG0211Lussac-Saint-Émilion 'L'Egérie du Château Chéreau', Vignobles Silvestrini
 PD0223Macon Prissé, Domaine de la Pierre des Dames
 IC0122Malvasia Collio 'Vigna 80 Anni', I Clivi
 OR0123Malvasia-Chardonnay, Ortonese
 VD0921Manzoni Bianco, Serafini & Vidotto
 AL0621McLaren Vale Shiraz, Adelina
 VL0122Mencía La Premisa, Vinos Valtuille
 MI1620Merlot Friuli Colli Orientali Buri, Miani
 MI0709Merlot Friuli Colli Orientali Filip, Miani
 RU0922Merlot Massarac , Russolo
 TR4018Metodo Classico Pas Dosé 'Nebolè', Travaglini
 CM0622Montepulciano d'Abruzzo 'Malandrino' - Organic, Cataldi Madonna
 AT0323Montepulciano d'Abruzzo - Organic, Amoterra
 RH0122Morgon Charmes, Domaine Raphaël Chopin
 SC0123Moscato d'Asti , Paolo Saracco
 SC0223Moscato d'Asti - Half Bottle , Paolo Saracco
 TK0523Mtsvane, Tiko Estate
 CD0523Müller-Thurgau, Cantina Andriano
 WS0123Nachschlag 'Bright Side of Life', Winzerhof Stahl
 TR0123Nebbiolo Coste della Sesia, Travaglini
 CF0222Negroamaro - Organic , Caiaffa
 CP2121Nerello Mascalese 'Pietre a Purtedda da Ginestra' - Organic, Centopassi
 MZ0423Nero d'Avola Terre Siciliane, Mezzogiorno
 CP0522Nero d'Avola-Perricone Giato Rosso - Organic, Centopassi
 CF0919Nero di Troia 'Lampryris' - Organic, Caiaffa
 CF0322Nero di Troia - Organic, Caiaffa
 CF0823Nero di Troia Rosato Pét-Nat Ancestrale - Organic, Caiaffa
 GU0319NeroBaronj - Organic, Gulfi
 GU0119NeroBufaleffj - Organic, Gulfi
 GU0219NeroSanloré - Organic, Gulfi
 GU0216NeroSanloré - Organic, Gulfi
 VZ847New Orange Brandy , Villa Zarri
 SA9022Obvius Bianco - Organic, Salcheto
 TK0222Orange Kisi, Tiko Estate
 LR0320Pario, L'Arco
 SO0321Passito di Pantelleria, Solidea
 CM0223Pecorino 'Giulia', Cataldi Madonna
 LC5221Per Filo - Organic, Villa Le Corti - Principe Corsini
 VD0421Phigaia 'After The Red', Serafini & Vidotto
 TL0121Piemonte Bianco 'Piandoro', Tenute Sella
 CD0123Pinot Bianco 'Finado' , Cantina Andriano
 TE4011Pinot Bianco Rarity , Cantina Terlano
 TE1221Pinot Bianco Riserva 'Vorberg' , Cantina Terlano
 TE3121Pinot Bianco Riserva 'Vorberg' - Magnum , Cantina Terlano
 TE1623Pinot Bianco Tradition, Cantina Terlano
 CD0223Pinot Grigio, Cantina Andriano
 RU0323Pinot Grigio Ronco Calaj, Russolo
 TE0423Pinot Grigio Tradition , Cantina Terlano
 VI0223Pinot Grigio Veneto, Vinvita
 VS0223Pinot Gris , Verus
 JR1920Pinot Noir Gumpoldskirchen Grillenhügel - Organic, Familie Reinisch
 JR1717Pinot Noir Holzspur - Organic, Familie Reinisch
 TE2521Pinot Noir Riserva 'Monticol', Cantina Terlano
 JR0722Pinot Noir Tattendorf - Organic, Familie Reinisch
 JR0622Pinot Noir Tattendorf - Organic, Familie Reinisch
 TE3023Pinot Noir Tradition, Cantina Terlano
 VG0318Pomerol 'Domaine de la Pointe', Vignobles Silvestrini
 PM0924Port 10 Year Old Tawny, Passagem
 PM0818Port Late Bottle Vintage, Passagem
 TO0622Premium Furmint Nagy Somlói, Tornai Pincészet
 CF0122Primitivo - Organic, Caiaffa
 GP0821Primitivo di Manduria 'Magnifico Rosso Fuoco', Magnifico
 MZ0522Primitivo Puglia , Mezzogiorno
 TS0122Priorat DOQ '90 Minuts', Trossos del Priorat
 VI0122Prosecco Spumante DOC Extra Dry, Vinvita
 VD0321Recantina , Serafini & Vidotto
 LR0517Recioto della Valpolicella Classico, L'Arco
 SP0520Recioto della Valpolicella Classico La Roggia, Speri
 RU0820Refosco dal Peduncolo Rosso, Russolo
 MI1820Refosco Friuli Colli Orientali Cossut, Miani
 RH0222Régnié Archambault, Domaine Raphaël Chopin
 RC0123Ribolla Gialla , Ronchi di Cialla
 MI8321Ribolla Gialla Friuli Colli Orientali Pettarin, Miani
 VS0422Riesling , Verus
 BU0123Rioja Alavesa, Bodegas Estraunza
 CX0120Rioja Alavesa 'letras minúsculas', Bodegas Tierra - Creaciones Exeo
 CX0320Rioja Alavesa Garnacha Blanca 'Cifras', Bodegas Tierra - Creaciones Exeo
 CX0221Rioja Alavesa Garnacha Tinta 'Cifras', Bodegas Tierra - Creaciones Exeo
 CX0420Rioja Alavesa Malvasia 'La Greña', Bodegas Tierra - Creaciones Exeo
 TK0422Rkatsiteli, Tiko Estate
 MZ0623Rosato Puglia, Mezzogiorno
 HI0324Rosé, Highweald Wine Estate
 RG5121Rosso Buri Bellaria, Ronco del Gnemiz
 LR0120Rosso del Veronese, L'Arco
 VD0518Rosso dell'Abazia, Serafini & Vidotto
 CA9221Rosso di Montalcino, Caparzo
 AA0119Rosso di Montefalco , Adanti
 RG5021Rosso Dottor Palazzolo, Ronco del Gnemiz
 MI1520Rosso Friuli Colli Orientali, Miani
 GU0622Rossojbleo - Organic, Gulfi
 JR1022Roter Eiswein - Half Bottle - Organic, Familie Reinisch
 JR1821Rotgipfler 'Satzing' - Organic, Familie Reinisch
 JR0222Rotgipfler - Organic, Familie Reinisch
 LR0618Rùbeo, L'Arco
 AA0810Sagrantino di Montefalco Riserva 'Il Domenico', Adanti
 PD0323Saint Véran, Domaine de la Pierre des Dames
 TF0219Saint-Joseph Blanc 'Grand Angle', Thomas Farge
 HT0304Sämling Trockenbeerenauslese - Half Bottle, Weingut Tschida Angerhof
 HT0312Sämling Trockenbeerenauslese - Half Bottle, Weingut Tschida Angerhof
 SE0322San Martino della Battaglia 'Campo del Soglio', Selva Capuzza
 FN0122Sancerre 'Silex' - Organic, François Le Saint
 BZ0321Sangiovese di Romagna Superiore 'Balitore', Balìa di Zola
 CA9022Sangiovese di Toscana, Caparzo
 VI0622Sangiovese Rubicone, Vinvita
 OR0423Sangiovese-Merlot, Ortonese
 TK0321Saperavi, Tiko Estate
 TE0522Sauvignon 'Quarz', Cantina Terlano
 TE2722Sauvignon 'Quarz' - Magnum, Cantina Terlano
 TE0323Sauvignon 'Winkl' , Cantina Terlano
 VS0123Sauvignon Blanc , Verus
 FD0323Sauvignon Blanc, Fondo Indizeno
 CD2522Sauvignon Blanc Andrius, Cantina Andriano
 BC0122Sauvignon Blanc Earth Series, Black Cottage
 MI7322Sauvignon Friuli Colli Orientali, Miani
 MI8021Sauvignon Friuli Colli Orientali Casa Rossa , Miani
 MI8221Sauvignon Friuli Colli Orientali Saurint, Miani
 MI8121Sauvignon Friuli Colli Orientali Zitelle , Miani
 RG2920Sauvignon Iris , Ronco del Gnemiz
 RG2722Sauvignon Lozeta , Ronco del Gnemiz
 RG2022Sauvignon Peri, Ronco del Gnemiz
 RG3922Sauvignon Serena , Ronco del Gnemiz
 RG3822Sauvignon Sol, Ronco del Gnemiz
 WS0520Scheurebe 'Cyriakusberg', Winzerhof Stahl
 RG4021Schioppettino, Ronco del Gnemiz
 RC0617Schioppettino di Cialla, Ronchi di Cialla
 RC0521Schioppettino RiNera, Ronchi di Cialla
 WS0322Silvaner , Winzerhof Stahl
 SI0122Sirkel Chenin Blanc, Scali
 SI0220Sirkel Shiraz Viognier , Scali
 MN0223Soave Classico, Monte Tondo
 MN0323Soave Classico - Half Bottle, Monte Tondo
 MN0922Soave Classico Casette Foscarino, Monte Tondo
 MN0123Soave Mito, Monte Tondo
 HT1522Spätlese Merlot, Weingut Tschida Angerhof
 JR0820St. Laurent - Organic, Familie Reinisch
 IS1019Sylvaner 'Sabiona', Cantina Valle Isarco
 CE0422Syrah 'Lumà' , Cantine Cellaro
 PI0517Taurasi, Pietracupa
 TE0123Terlaner Cuvée, Cantina Terlano
 TE3523Terlaner Cuvée - Half Bottle, Cantina Terlano
 TE5523Terlaner Cuvée - Magnum, Cantina Terlano
 TE0821Terlaner Cuvée Riserva 'Nova Domus', Cantina Terlano
 TE5221Terlaner Cuvée Riserva 'Nova Domus' - Magnum, Cantina Terlano
 TE5021Terlaner I Grande Cuvée Primo, Cantina Terlano
 TE51121Terlaner I Grande Cuvée Primo - Magnum
 MA0122Timorasso Colli Tortonesi Bricco San Michele, Claudio Mariotto
 MA0320Timorasso Colli Tortonesi Cavallina, Claudio Mariotto
 PM0221Tinto, Passagem
 CR0322Toscana Rosso Brio , Castello Romitorio
 CR0421Toscana Rosso Romitorio, Castello Romitorio
 AT0123Trebbiano d'Abruzzo - Organic, Amoterra
 VI0523Trebbiano Rubicone, Vinvita
 AD7024Valdobbiadene DOCG Prosecco Superiore 'Bosco di Gica' , Adami
 AD7124Valdobbiadene DOCG Prosecco Superiore 'Bosco di Gica' - Half Bottle, Adami
 AD7524Valdobbiadene DOCG Prosecco Superiore 'Bosco di Gica' - Magnum, Adami
 AD8923Valdobbiadene DOCG Prosecco Superiore Rive di Farra di Soligo 'Col Credas', Adami
 AD6022Valdobbiadene DOCG Prosecco Superiore Sui Lieviti Brut Nature 'Col Fondo', Adami
 SP0123Valpolicella Classico, Speri
 SP0221Valpolicella Classico Superiore Ripasso , Speri
 SP0320Valpolicella Classico Superiore Sant'Urbano, Speri
 GP0122Veneto Rosso IGT, Gran Passione
 AT0523Verdicchio di Matelica - Organic, Amoterra
 AR1222Verduno Pelaverga, ArnaldoRivera
 RC1583Verduzzo di Cialla, Ronchi di Cialla
 RC1018Verduzzo di Cialla - Half Bottle, Ronchi di Cialla
 GB0123Vermentino di Sardegna Manzanile , Gabbas
 PA0123Vernaccia di San Gimignano - Organic, Panizzi
 PA0320Vernaccia di San Gimignano Riserva - Organic, Panizzi
 PA0222Vernaccia di San Gimignano Vigna Santa Margherita - Organic, Panizzi
 MO0717Vin de Paille, Domaine Jean-Luc Mouillard
 LC6006Vin Santo 'Sant'Andrea Corsini', Villa Le Corti - Principe Corsini
 SA1018Vino Nobile di Montepulciano 'Salco' - Organic, Salcheto
 SA0320Vino Nobile di Montepulciano - Half Bottle - Organic , Salcheto
 SA0619Vino Nobile di Montepulciano - Magnum - Organic, Salcheto
 SA0520Vino Nobile di Montepulciano - Organic, Salcheto
 AL0122Watervale Riesling, Adelina
 WS0222Weissburgunder, Winzerhof Stahl
 PF1523Wien.1 , Pfaffl
 PF1623Wien.2 , Pfaffl
 JR0522Zweigelt - Organic, Familie Reinisch
 regionOptions(array)
 Argentina(array)
 mendozaMendoza (1)
 Australia(array)
 clare-valleyClare Valley (1)
 mclaren-valeMcLaren Vale (1)
 Austria(array)
 thermenregionThermenregion (9)
 traisentalTraisental (1)
 neusiedlerseeNeusiedlersee (5)
 weinviertelWeinviertel (2)
 France(array)
 burgundyBurgundy (13)
 champagneChampagne (7)
 bordeauxBordeaux (3)
 loire-valleyLoire Valley (1)
 provenceProvence (1)
 rhone-valleyRhône Valley (9)
 gasconyGascony (1)
 beaujolais-1Beaujolais (3)
 juraJura (6)
 Georgia(array)
 kakhetiKakheti (4)
 Germany(array)
 frankenFranken (5)
 Hungary(array)
 somloSomlo (1)
 Italy(array)
 piemontePiemonte (92)
 lombardiaLombardia (3)
 trentino-alto-adigeTrentino-Alto Adige (33)
 friuli-venezia-giuliaFriuli Venezia-Giulia (37)
 venetoVeneto (34)
 emilia-romagnaEmilia Romagna (12)
 marcheMarche (1)
 toscanaToscana (34)
 pugliaPuglia (11)
 abruzzoAbruzzo (5)
 campaniaCampania (8)
 siciliaSicilia (19)
 sardegnaSardegna (3)
 umbriaUmbria (2)
 calabriaCalabria (4)
 New Zealand(array)
 marlboroughMarlborough (1)
 Portugal(array)
 douroDouro (4)
 Slovenia(array)
 ormozOrmoz (4)
 South Africa(array)
 northern-paarlNorthern Paarl (2)
 Spain(array)
 prioratPriorat (1)
 rias-baixasRias Baixas (3)
 riojaRioja (5)
 bierzo-1Bierzo (1)
 The United Kingdom(array)
 sussexSussex (4)
 regions(array)
 0(array)
 GeographyRegion(array)
 id51
 slugmendoza
 titleMendoza
 GeographyCountry(array)
 id14
 slugargentina
 titleArgentina
 image_area_coordinates
 image_area_coordinates_spirit
 1(array)
 GeographyRegion(array)
 id43
 slugclare-valley
 titleClare Valley
 GeographyCountry(array)
 id13
 slugaustralia
 titleAustralia
 image_area_coordinates602,31,610,39,610,46,630,67,630,87,626,91,621,95,662,99,614,108,610,103,606,107,593,95,589,95,586,91,581,91,577,86,554,87,554,91,541,91,542,95,537,95,534,91,534,76,530,75,534,71,533,63,530,63,529,60,538,59,537,55,546,55,563,38,566,42,570,43,570,39,578,39,
 image_area_coordinates_spirit
 2(array)
 GeographyRegion(array)
 id61
 slugmclaren-vale
 titleMcLaren Vale
 GeographyCountry(array)
 id13
 slugaustralia
 titleAustralia
 image_area_coordinates602,31,610,39,610,46,630,67,630,87,626,91,621,95,662,99,614,108,610,103,606,107,593,95,589,95,586,91,581,91,577,86,554,87,554,91,541,91,542,95,537,95,534,91,534,76,530,75,534,71,533,63,530,63,529,60,538,59,537,55,546,55,563,38,566,42,570,43,570,39,578,39,
 image_area_coordinates_spirit
 3(array)
 GeographyRegion(array)
 id1
 slugthermenregion
 titleThermenregion
 GeographyCountry(array)
 id1
 slugaustria
 titleAustria
 image_area_coordinates269,209,290,208,298,215,295,229,272,230,263,223,229,225,226,217,270,217
 image_area_coordinates_spirit
 4(array)
 GeographyRegion(array)
 id2
 slugtraisental
 titleTraisental
 GeographyCountry(array)
 id1
 slugaustria
 titleAustria
 image_area_coordinates269,209,290,208,298,215,295,229,272,230,263,223,229,225,226,217,270,217
 image_area_coordinates_spirit
 5(array)
 GeographyRegion(array)
 id4
 slugneusiedlersee
 titleNeusiedlersee
 GeographyCountry(array)
 id1
 slugaustria
 titleAustria
 image_area_coordinates269,209,290,208,298,215,295,229,272,230,263,223,229,225,226,217,270,217
 image_area_coordinates_spirit
 6(array)
 GeographyRegion(array)
 id5
 slugweinviertel
 titleWeinviertel
 GeographyCountry(array)
 id1
 slugaustria
 titleAustria
 image_area_coordinates269,209,290,208,298,215,295,229,272,230,263,223,229,225,226,217,270,217
 image_area_coordinates_spirit
 7(array)
 GeographyRegion(array)
 id7
 slugburgundy
 titleBurgundy
 GeographyCountry(array)
 id2
 slugfrance
 titleFrance
 image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
 image_area_coordinates_spirit
 8(array)
 GeographyRegion(array)
 id8
 slugchampagne
 titleChampagne
 GeographyCountry(array)
 id2
 slugfrance
 titleFrance
 image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
 image_area_coordinates_spirit
 9(array)
 GeographyRegion(array)
 id39
 slugbordeaux
 titleBordeaux
 GeographyCountry(array)
 id2
 slugfrance
 titleFrance
 image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
 image_area_coordinates_spirit
 10(array)
 GeographyRegion(array)
 id49
 slugloire-valley
 titleLoire Valley
 GeographyCountry(array)
 id2
 slugfrance
 titleFrance
 image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
 image_area_coordinates_spirit
 11(array)
 GeographyRegion(array)
 id52
 slugprovence
 titleProvence
 GeographyCountry(array)
 id2
 slugfrance
 titleFrance
 image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
 image_area_coordinates_spirit
 12(array)
 GeographyRegion(array)
 id56
 slugrhone-valley
 titleRhône Valley
 GeographyCountry(array)
 id2
 slugfrance
 titleFrance
 image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
 image_area_coordinates_spirit
 13(array)
 GeographyRegion(array)
 id62
 sluggascony
 titleGascony
 GeographyCountry(array)
 id2
 slugfrance
 titleFrance
 image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
 image_area_coordinates_spirit
 14(array)
 GeographyRegion(array)
 id67
 slugbeaujolais-1
 titleBeaujolais
 GeographyCountry(array)
 id2
 slugfrance
 titleFrance
 image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
 image_area_coordinates_spirit
 15(array)
 GeographyRegion(array)
 id68
 slugjura
 titleJura
 GeographyCountry(array)
 id2
 slugfrance
 titleFrance
 image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
 image_area_coordinates_spirit
 16(array)
 GeographyRegion(array)
 id55
 slugkakheti
 titleKakheti
 GeographyCountry(array)
 id15
 sluggeorgia
 titleGeorgia
 image_area_coordinates396,167,425,181,435,176,455,195,476,190,492,210,495,223,483,224,477,215,470,224,446,222,434,213,419,215,426,202,396,181
 image_area_coordinates_spirit
 17(array)
 GeographyRegion(array)
 id57
 slugfranken
 titleFranken
 GeographyCountry(array)
 id3
 sluggermany
 titleGermany
 image_area_coordinates209,111,224,112,231,119,271,122,270,142,273,164,243,179,263,205,256,211,216,210,213,189,196,187,193,175,197,164,208,163,211,134,194,127,216,126
 image_area_coordinates_spirit
 18(array)
 GeographyRegion(array)
 id11
 slugsomlo
 titleSomlo
 GeographyCountry(array)
 id4
 slughungary
 titleHungary
 image_area_coordinates309,214,333,217,338,209,350,204,360,205,359,225,348,236,331,243,315,243,303,229
 image_area_coordinates_spirit
 19(array)
 GeographyRegion(array)
 id13
 slugpiemonte
 titlePiemonte
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 20(array)
 GeographyRegion(array)
 id15
 sluglombardia
 titleLombardia
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 21(array)
 GeographyRegion(array)
 id16
 slugtrentino-alto-adige
 titleTrentino-Alto Adige
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 22(array)
 GeographyRegion(array)
 id17
 slugfriuli-venezia-giulia
 titleFriuli Venezia-Giulia
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 23(array)
 GeographyRegion(array)
 id18
 slugveneto
 titleVeneto
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 24(array)
 GeographyRegion(array)
 id19
 slugemilia-romagna
 titleEmilia Romagna
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 25(array)
 GeographyRegion(array)
 id20
 slugmarche
 titleMarche
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 26(array)
 GeographyRegion(array)
 id21
 slugtoscana
 titleToscana
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 27(array)
 GeographyRegion(array)
 id23
 slugpuglia
 titlePuglia
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 28(array)
 GeographyRegion(array)
 id24
 slugabruzzo
 titleAbruzzo
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 29(array)
 GeographyRegion(array)
 id25
 slugcampania
 titleCampania
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 30(array)
 GeographyRegion(array)
 id26
 slugsicilia
 titleSicilia
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 31(array)
 GeographyRegion(array)
 id27
 slugsardegna
 titleSardegna
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 32(array)
 GeographyRegion(array)
 id33
 slugumbria
 titleUmbria
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 33(array)
 GeographyRegion(array)
 id60
 slugcalabria
 titleCalabria
 GeographyCountry(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 34(array)
 GeographyRegion(array)
 id28
 slugmarlborough
 titleMarlborough
 GeographyCountry(array)
 id6
 slugnew-zealand
 titleNew Zealand
 image_area_coordinates594,274,611,304,624,305,625,321,605,342,572,385,563,385,545,382,551,361,575,337,594,332,589,322,597,308,581,283
 image_area_coordinates_spirit(null)
 35(array)
 GeographyRegion(array)
 id65
 slugdouro
 titleDouro
 GeographyCountry(array)
 id16
 slugportugal
 titlePortugal
 image_area_coordinates33,304,55,304,52,317,45,336,43,354,44,373,23,359,23,339,35,332
 image_area_coordinates_spirit
 36(array)
 GeographyRegion(array)
 id29
 slugormoz
 titleOrmoz
 GeographyCountry(array)
 id7
 slugslovenia
 titleSlovenia
 image_area_coordinates298,236,303,245,284,258,271,256,273,248,277,239
 image_area_coordinates_spirit
 37(array)
 GeographyRegion(array)
 id40
 slugnorthern-paarl
 titleNorthern Paarl
 GeographyCountry(array)
 id11
 slugsouth-africa
 titleSouth Africa
 image_area_coordinates592,173,605,162,613,158,618,160,623,168,623,176,626,181,631,184,631,195,623,207,618,218,602,233,586,239,568,242,557,246,548,239,545,233,548,222,541,214,534,202,542,198,556,205,559,175,564,181,564,190,573,191,573,177,581,183,593,182
 image_area_coordinates_spirit(null)
 38(array)
 GeographyRegion(array)
 id31
 slugpriorat
 titlePriorat
 GeographyCountry(array)
 id8
 slugspain
 titleSpain
 image_area_coordinates31,277,110,280,117,289,136,290,146,296,159,298,159,311,125,338,129,348,124,363,104,377,64,380,53,369,51,347,56,315,60,300,32,297,22,288
 image_area_coordinates_spirit
 39(array)
 GeographyRegion(array)
 id32
 slugrias-baixas
 titleRias Baixas
 GeographyCountry(array)
 id8
 slugspain
 titleSpain
 image_area_coordinates31,277,110,280,117,289,136,290,146,296,159,298,159,311,125,338,129,348,124,363,104,377,64,380,53,369,51,347,56,315,60,300,32,297,22,288
 image_area_coordinates_spirit
 40(array)
 GeographyRegion(array)
 id48
 slugrioja
 titleRioja
 GeographyCountry(array)
 id8
 slugspain
 titleSpain
 image_area_coordinates31,277,110,280,117,289,136,290,146,296,159,298,159,311,125,338,129,348,124,363,104,377,64,380,53,369,51,347,56,315,60,300,32,297,22,288
 image_area_coordinates_spirit
 41(array)
 GeographyRegion(array)
 id64
 slugbierzo-1
 titleBierzo
 GeographyCountry(array)
 id8
 slugspain
 titleSpain
 image_area_coordinates31,277,110,280,117,289,136,290,146,296,159,298,159,311,125,338,129,348,124,363,104,377,64,380,53,369,51,347,56,315,60,300,32,297,22,288
 image_area_coordinates_spirit
 42(array)
 GeographyRegion(array)
 id59
 slugsussex
 titleSussex
 GeographyCountry(array)
 id10
 slugthe-united-kingdom
 titleThe United Kingdom
 image_area_coordinates71,49,95,48,92,60,108,62,106,72,97,85,114,110,127,136,140,139,142,146,139,157,141,164,125,179,107,181,90,184,69,187,67,178,81,165,72,153,87,149,87,139,78,138,91,131,78,111,63,122,52,115,36,113,60,88,57,69
 image_area_coordinates_spirit246,214,451,213,450,395,245,394
 countryOptions(array)
 argentinaArgentina (1)
 australiaAustralia (2)
 austriaAustria (17)
 franceFrance (44)
 georgiaGeorgia (4)
 germanyGermany (5)
 hungaryHungary (1)
 italyItaly (298)
 new-zealandNew Zealand (1)
 portugalPortugal (4)
 sloveniaSlovenia (4)
 south-africaSouth Africa (2)
 spainSpain (10)
 the-united-kingdomThe United Kingdom (4)
 countries(array)
 argentina(array)
 id14
 slugargentina
 titleArgentina
 image_area_coordinates
 image_area_coordinates_spirit
 count1
 australia(array)
 id13
 slugaustralia
 titleAustralia
 image_area_coordinates602,31,610,39,610,46,630,67,630,87,626,91,621,95,662,99,614,108,610,103,606,107,593,95,589,95,586,91,581,91,577,86,554,87,554,91,541,91,542,95,537,95,534,91,534,76,530,75,534,71,533,63,530,63,529,60,538,59,537,55,546,55,563,38,566,42,570,43,570,39,578,39,
 image_area_coordinates_spirit
 count2
 austria(array)
 id1
 slugaustria
 titleAustria
 image_area_coordinates269,209,290,208,298,215,295,229,272,230,263,223,229,225,226,217,270,217
 image_area_coordinates_spirit
 count17
 france(array)
 id2
 slugfrance
 titleFrance
 image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
 image_area_coordinates_spirit
 count44
 georgia(array)
 id15
 sluggeorgia
 titleGeorgia
 image_area_coordinates396,167,425,181,435,176,455,195,476,190,492,210,495,223,483,224,477,215,470,224,446,222,434,213,419,215,426,202,396,181
 image_area_coordinates_spirit
 count4
 germany(array)
 id3
 sluggermany
 titleGermany
 image_area_coordinates209,111,224,112,231,119,271,122,270,142,273,164,243,179,263,205,256,211,216,210,213,189,196,187,193,175,197,164,208,163,211,134,194,127,216,126
 image_area_coordinates_spirit
 count5
 hungary(array)
 id4
 slughungary
 titleHungary
 image_area_coordinates309,214,333,217,338,209,350,204,360,205,359,225,348,236,331,243,315,243,303,229
 image_area_coordinates_spirit
 count1
 italy(array)
 id5
 slugitaly
 titleItaly
 image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
 image_area_coordinates_spirit247,20,449,20,449,198,248,197
 count298
 new-zealand(array)
 id6
 slugnew-zealand
 titleNew Zealand
 image_area_coordinates594,274,611,304,624,305,625,321,605,342,572,385,563,385,545,382,551,361,575,337,594,332,589,322,597,308,581,283
 image_area_coordinates_spirit(null)
 count1
 portugal(array)
 id16
 slugportugal
 titlePortugal
 image_area_coordinates33,304,55,304,52,317,45,336,43,354,44,373,23,359,23,339,35,332
 image_area_coordinates_spirit
 count4
 slovenia(array)
 id7
 slugslovenia
 titleSlovenia
 image_area_coordinates298,236,303,245,284,258,271,256,273,248,277,239
 image_area_coordinates_spirit
 count4
 south-africa(array)
 id11
 slugsouth-africa
 titleSouth Africa
 image_area_coordinates592,173,605,162,613,158,618,160,623,168,623,176,626,181,631,184,631,195,623,207,618,218,602,233,586,239,568,242,557,246,548,239,545,233,548,222,541,214,534,202,542,198,556,205,559,175,564,181,564,190,573,191,573,177,581,183,593,182
 image_area_coordinates_spirit(null)
 count2
 spain(array)
 id8
 slugspain
 titleSpain
 image_area_coordinates31,277,110,280,117,289,136,290,146,296,159,298,159,311,125,338,129,348,124,363,104,377,64,380,53,369,51,347,56,315,60,300,32,297,22,288
 image_area_coordinates_spirit
 count10
 the-united-kingdom(array)
 id10
 slugthe-united-kingdom
 titleThe United Kingdom
 image_area_coordinates71,49,95,48,92,60,108,62,106,72,97,85,114,110,127,136,140,139,142,146,139,157,141,164,125,179,107,181,90,184,69,187,67,178,81,165,72,153,87,149,87,139,78,138,91,131,78,111,63,122,52,115,36,113,60,88,57,69
 image_area_coordinates_spirit246,214,451,213,450,395,245,394
 count4
- groupwine
- activePages(array)
 01
 112
 233
- page(array)
 FrontpagePage(array)
 id33
 parent_id12
 nleft63
 nright64
 level0
 sorting0
 nameDetails
 titleDetails
 slugdetails
 typepage
 url/products/details
 external_url(null)
 folder_key(null)
 alias_id(null)
 meta_title
 meta_keywords
 meta_description
 in_sitemap(false)
 sitemap_modified2012-10-15 11:58:51
 sitemap_changesnever
 sitemap_priority0.8
 is_homepage(false)
 in_routes(true)
 in_navigation(false)
 logged_in_only(false)
 logged_out_only(false)
 user_landing_page(false)
 overlay(false)
 is_404page(false)
 layout_fileproduct-filters
 layout_file_recursive0
 view_filedefault
 view_file_recursive0
 use_url_as_view0
 meta_title_template(null)
 options(null)
 options_local(null)
 tags
 notes(null)
 created2012-10-15 11:59:26
 created_by4
 modified2018-04-23 11:43:53
 modified_by5
 status1
 Alias(array)
 id(null)
 parent_id(null)
 nleft(null)
 nright(null)
 level(null)
 sorting(null)
 name(null)
 title(null)
 slug(null)
 type(null)
 url(null)
 external_url(null)
 folder_key(null)
 alias_id(null)
 meta_title(null)
 meta_keywords(null)
 meta_description(null)
 in_sitemap(null)
 sitemap_modified(null)
 sitemap_changes(null)
 sitemap_priority(null)
 is_homepage(null)
 in_routes(null)
 in_navigation(null)
 logged_in_only(null)
 logged_out_only(null)
 user_landing_page(null)
 overlay(null)
 is_404page(null)
 layout_file(null)
 layout_file_recursive(null)
 view_file(null)
 view_file_recursive(null)
 use_url_as_view(null)
 meta_title_template(null)
 options(null)
 options_local(null)
 tags(null)
 notes(null)
 created(null)
 created_by(null)
 modified(null)
 modified_by(null)
 status(null)
- $request->data(empty)
- $this->validationErrors(array)
 AppPreference(empty)
 AppPreferenceExpanded(empty)
 FrontpageRewrite(empty)
 FrontpagePage(empty)
 Tag(empty)
 Aco(empty)
 Aro(empty)
 CreatedBy(empty)
 ModifiedBy(empty)
 Alias(empty)
 Product(empty)
 ProductCategory(empty)
 ProductProducer(empty)
 ProductDistributor(empty)
 ProductGrapeVarietyProduct(empty)
 ProductGrapeVariety(empty)
 ProductBottleClosureType(empty)
 ProductBottleSize(empty)
 ProductCaseSize(empty)
 ProductImage(empty)
 GeographyRegion(empty)
 GeographyCountry(empty)
 ProductBox(empty)
 ProductCategoriesProduct(empty)
- Loaded Helpers(array)
 0Frontpage
 1Cache
 2AppTable
 3Form
 4Asset
 5AssetCompress
 6CookieCompliance
 7FrontpageSitemap
 8Html
 9Js
 10Pager
 11Text
 12Time
 13Number
 14GoogleMapV3
 15Avatar
 16SimpleGraph
 17DebugTimer
 18Toolbar
 19AppJqueryEngine
 20Session
 21HtmlToolbar
====

Environment

App Constants

Constant	Value
GWINE	wine
GSPIRIT	spirit

CakePHP Constants

Constant	Value
APP	/var/www/app/
APP_DIR	app
APPLIBS	/var/www/app/Lib/
CACHE	/var/www/app/tmp/cache/
CAKE	/var/www/cake/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/cake/lib
CORE_PATH	/var/www/cake/lib/
CAKE_VERSION	2.4.6
CSS	/var/www/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://127.0.0.1:8020
IMAGES	/var/www/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/app/webroot/js/
JS_URL	js/
LOGS	/var/www/app/tmp/logs/
ROOT	/var/www
TESTS	/var/www/app/Test/
TMP	/var/www/app/tmp/
VENDORS	/var/www/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40
Php Extra Configure Args	--enable-fpm --with-fpm-user=www-data --with-fpm-group=www-data --disable-cgi
Hostname	71c6e6872272
Php Ini Dir	/usr/local/etc/php
Shlvl	1
Home	/home/www-data
Php Ldflags	-Wl,-O1 -Wl,--hash-style=both -pie
Php Cflags	-fstack-protector-strong -fpic -fpie -O2
Php Md5
Gpg Keys	0BD78B5F97500D450838F95DFE857D9A90D90EC1 6E4F6AB321FDC07F2C332E3AC2BF0BC433CFC8B3
Php Cppflags	-fstack-protector-strong -fpic -fpie -O2
Php Asc Url	https://secure.php.net/get/php-5.6.40.tar.xz.asc/from/this/mirror
Php Url	https://secure.php.net/get/php-5.6.40.tar.xz/from/this/mirror
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
Phpize Deps	autoconf dpkg-dev dpkg file g++ gcc libc-dev make pkgconf re2c
Pwd	/var/www/app
Php Sha256	1369a51eee3995d7fbd1c5342e5cc917760e276d561595b6052b21ace2656d1c
User	www-data
Fcgi Role	RESPONDER
Query String
Request Method	GET
Content Type
Content Length
Script Name	/index.php
Request Uri	/products/details/VZ847/page:24/limit:12
Document Uri	/index.php
Document Root	/var/www/app/webroot
Server Protocol	HTTP/1.0
Request Scheme	http
Gateway Interface	CGI/1.1
Server Software	nginx/1.27.2
Remote Addr	172.18.0.1
Remote Port	48282
Server Addr	172.18.0.3
Server Port	80
Server Name
Redirect Status	200
Script Filename	/var/www/app/webroot/index.php
Http Host	127.0.0.1:8020
Http Connection	close
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br, zstd, deflate
Http Referer	https://astrumwinecellars.com/products/details/VZ847/page:24/limit:12
Php Self	/index.php
Request Time Float	1730369381.2969
Request Time	1730369381
Argc	0

====

Include
+
Included Files

Include Paths
- 0/var/www/lib
- 2/usr/local/lib/php
- 3-> /var/www/cake/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  1CORE/Model/Behavior/TreeBehavior.php
  2CORE/Model/Behavior/AclBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/RequestHandlerComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/AuthComponent.php
  Config(array)
  0CORE/Config/config.php
  Configure(array)
  0CORE/Configure/PhpReader.php
  1CORE/Configure/ConfigReaderInterface.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  4CORE/Model/Aco.php
  5CORE/Model/AclNode.php
  6CORE/Model/Aro.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/CakeNumber.php
  4CORE/Utility/Debugger.php
  5CORE/Utility/String.php
  6CORE/Utility/ClassRegistry.php
  7CORE/Utility/Set.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/config.php
  3APP/Config/routes.php
  4APP/Config/database.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  AclBase(array)
  Behavior(array)
  0AclBase/Model/Behavior/AclBaseBehavior.php
  Admin(array)
  Config(array)
  0Admin/Config/bootstrap.php
  1Admin/Config/routes.php
  App(array)
  Controller(array)
  0App/Controller/AppController.php
  Model(array)
  0App/Model/AppPreference.php
  1App/Model/AppModel.php
  2App/Model/AppPreferenceExpanded.php
  Component(array)
  0App/Controller/Component/AppComponent.php
  AppAdmin(array)
  Config(array)
  0AppAdmin/Config/bootstrap.php
  1AppAdmin/Config/routes.php
  Asset(array)
  Config(array)
  0Asset/Config/bootstrap.php
  1Asset/Config/routes.php
  AssetAdmin(array)
  Config(array)
  0AssetAdmin/Config/bootstrap.php
  1AssetAdmin/Config/routes.php
  AssetCompress(array)
  Config(array)
  0AssetCompress/Config/routes.php
  Attachment(array)
  Config(array)
  0Attachment/Config/routes.php
  CakePdf(array)
  Config(array)
  0CakePdf/Config/bootstrap.php
  Config(array)
  Config(array)
  0Config/Controller/Component/IniComponent.php
  ContactAdmin(array)
  Config(array)
  0ContactAdmin/Config/bootstrap.php
  1ContactAdmin/Config/routes.php
  CookieComplianceAdmin(array)
  Config(array)
  0CookieComplianceAdmin/Config/bootstrap.php
  1CookieComplianceAdmin/Config/routes.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Enews(array)
  Config(array)
  0Enews/Config/bootstrap.php
  1Enews/Config/routes.php
  EnewsAdmin(array)
  Config(array)
  0EnewsAdmin/Config/bootstrap.php
  1EnewsAdmin/Config/routes.php
  Expandable(array)
  Behavior(array)
  0Expandable/Model/Behavior/ExpandableBehavior.php
  Frontpage(array)
  Config(array)
  0Frontpage/Config/bootstrap.php
  1Frontpage/Config/routes.php
  Plugin(array)
  0Frontpage/Lib/Routing/Route/FrontpagePageRoute.php
  Component(array)
  0Frontpage/Controller/Component/FrontpageComponent.php
  Model(array)
  0Frontpage/Model/FrontpagePage.php
  1Frontpage/Model/FrontpageAppModel.php
  2Frontpage/Model/FrontpageRewrite.php
  Behavior(array)
  0Frontpage/Model/Behavior/FrontpagePageBehavior.php
  FrontpageAdmin(array)
  Config(array)
  0FrontpageAdmin/Config/bootstrap.php
  1FrontpageAdmin/Config/routes.php
  FrontpageUser(array)
  Model(array)
  0FrontpageUser/Model/FrontpageUser.php
  1FrontpageUser/Model/FrontpageUserAppModel.php
  FrontpageUserAdmin(array)
  Config(array)
  0FrontpageUserAdmin/Config/bootstrap.php
  1FrontpageUserAdmin/Config/routes.php
  Gapi(array)
  Config(array)
  0Gapi/Config/routes.php
  Geography(array)
  Model(array)
  0Geography/Model/GeographyRegion.php
  1Geography/Model/GeographyAppModel.php
  2Geography/Model/GeographyCountry.php
  GeographyAdmin(array)
  Config(array)
  0GeographyAdmin/Config/bootstrap.php
  1GeographyAdmin/Config/routes.php
  Google(array)
  Behavior(array)
  0Google/Model/Behavior/GoogleMapCoordinateBehavior.php
  HabtmCounterCache(array)
  Behavior(array)
  0HabtmCounterCache/Model/Behavior/HabtmCounterCacheBehavior.php
  News(array)
  Config(array)
  0News/Config/bootstrap.php
  NewsAdmin(array)
  Config(array)
  0NewsAdmin/Config/bootstrap.php
  1NewsAdmin/Config/routes.php
  Product(array)
  Config(array)
  0Product/Config/bootstrap.php
  Controller(array)
  0Product/Controller/ProductsController.php
  1Product/Controller/ProductAppController.php
  Plugin(array)
  0Product/Lib/ProductLib.php
  Model(array)
  0Product/Model/Product.php
  1Product/Model/ProductAppModel.php
  2Product/Model/ProductCategory.php
  3Product/Model/ProductProducer.php
  4Product/Model/ProductDistributor.php
  5Product/Model/ProductGrapeVarietyProduct.php
  6Product/Model/ProductGrapeVariety.php
  7Product/Model/ProductBottleClosureType.php
  8Product/Model/ProductBottleSize.php
  9Product/Model/ProductCaseSize.php
  10Product/Model/ProductImage.php
  11Product/Model/ProductBox.php
  ProductAdmin(array)
  Config(array)
  0ProductAdmin/Config/bootstrap.php
  1ProductAdmin/Config/routes.php
  Quote(array)
  Config(array)
  0Quote/Config/bootstrap.php
  QuoteAdmin(array)
  Config(array)
  0QuoteAdmin/Config/bootstrap.php
  1QuoteAdmin/Config/routes.php
  Slug(array)
  Behavior(array)
  0Slug/Model/Behavior/SluggableBehavior.php
  Sorting(array)
  Behavior(array)
  0Sorting/Model/Behavior/IncrementalBehavior.php
  Tag(array)
  Behavior(array)
  0Tag/Model/Behavior/TaggableBehavior.php
  Model(array)
  0Tag/Model/Tag.php
  1Tag/Model/TagAppModel.php
  UniqueKey(array)
  Behavior(array)
  0UniqueKey/Model/Behavior/UniqueKeyBehavior.php
  User(array)
  Behavior(array)
  0User/Model/Behavior/LoggingBehavior.php
  Model(array)
  0User/Model/User.php
  UserAdmin(array)
  Config(array)
  0UserAdmin/Config/bootstrap.php
  1UserAdmin/Config/routes.php
====

Specifications

Viticulture

Vinification