Arcum < Astrum Wine Cellars

Filter by:

Arcum

L'Arco
Veneto, Italy

Method & Production

Practising organic. The grapes are from the Classico zone, around the villages of Negrar and San Pietro in Cariano, planted on gravel and moraine soils formed from an ancient riverbed between. Hand-harvested fruit, from estate owned grapes. After harvest, the grapes are pressed immediately. After some days of maceration with the skins, alcoholic fermentation starts and lasts for around seven days. The wine is made in the Ripasso style, passing previously dried and pressed grapes through the juice. It's then aged in Slavonian oak barrels for one year. No fining with a delicate filtering.

Details

Code: LR0220

Please log in to see prices Product Fact SheetDetails

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

Cake Params
- pluginproduct
- controllerproducts
- actiondisplay
- named(array)
  page3
  limit12
  regionveneto
- pass(array)
  0LR0220
- 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: 67 ms
Total Queries: 47 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	0
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/LR0220/page:3/limit:12/region:veneto' 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	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`.`url` = '/products/details' LIMIT 1	1	1	0
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` = 'LR0220' 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` = (1227) ORDER BY `ProductImage`.`sorting` asc	1	1	1
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` = (1227)	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` = (1227) ORDER BY `ProductGrapeVarietyProduct`.`percentage` desc	3	3	31	maybe slow
SELECT `ProductGrapeVariety`.`title` FROM `astrum`.`oc_product_grape_varieties` AS `ProductGrapeVariety` WHERE `ProductGrapeVariety`.`id` = 53	1	1	0
SELECT `ProductGrapeVariety`.`title` FROM `astrum`.`oc_product_grape_varieties` AS `ProductGrapeVariety` WHERE `ProductGrapeVariety`.`id` = 55	1	1	0
SELECT `ProductGrapeVariety`.`title` FROM `astrum`.`oc_product_grape_varieties` AS `ProductGrapeVariety` WHERE `ProductGrapeVariety`.`id` = 58	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` = 1227 AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`)	1	1	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` = 4018 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` = 4018 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` = 4018 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` = 4018 LIMIT 1	1	1	0
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` = 4018 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` = 4018 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	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` = 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)	1478	1478	2
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) ORDER BY `Product`.`title` asc	389	389	10
SELECT `GeographyRegion`.`id`, `GeographyRegion`.`geography_country_id` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` WHERE `id` IN (56, 25, 19, 32, 13, 21, 18, 17, 7, 65, 59, 60, 27, 26, 8, 57, 16, 15, 51, 62, 52, 4, 23, 29, 2, 39, 24, 61, 64, 67, 55, 1, 11, 31, 48, 33, 49, 28, 40, 20, 43, 5)	42	42	11	maybe slow
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, 17, 7, 65, 59, 60, 27, 26, 8, 57, 16, 15, 51, 62, 52, 4, 23, 29, 2, 39, 24, 61, 64, 67, 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	42	42	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	212	212	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	1	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 14.12 MB

Message	Memory use
Component initialization	2.41 MB
Controller action start	4.30 MB
Controller render start	5.85 MB
View render complete	9.01 MB

Timers

Total Request Time: 568 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	54.49
Event: Controller.initialize	48.29
Event: Controller.startup	0.84
Controller action	72.03
Event: Controller.beforeRender	31.58
» Processing toolbar data	31.25
Rendering View	251.96
» Event: View.beforeRender	0.07
» Rendering APP/Plugin/Product/View/Products/display.ctp	60.71
» » Rendering APP/Plugin/Product/View/Elements/product/gallery.ctp	20.21
» » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp	0.43
» » Rendering APP/Plugin/Product/View/Elements/product/facts.ctp	4.60
» » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp #2	0.42
» » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp #3	0.40
» » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp #4	0.42
» » Rendering APP/Plugin/Product/View/Elements/product/breadcrumbs.ctp	29.57
» » Rendering APP/Plugin/Product/View/Elements/product/content.ctp	0.47
» » Rendering APP/Plugin/Product/View/Elements/product/cta.ctp	3.54
» » » Rendering APP/Plugin/Product/View/Elements/product/pricing.ctp	0.65
» » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp #5	0.43
» Event: View.afterRender	0.18
» Event: View.beforeLayout	0.05
» Rendering APP/Plugin/Frontpage/View/Layouts/product-filters.ctp	175.13
» » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp	3.17
» » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #2	3.45
» » Rendering APP/Plugin/Frontpage/View/Elements/document/header.ctp	1.93
» » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/navigation.ctp #3	1.19
» » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp	0.44
» » Rendering APP/Plugin/Frontpage/View/Elements/page/header.ctp #2	8.35
» » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp #2	0.44
» » » Rendering APP/Plugin/Frontpage/View/Elements/social_sharing.ctp	2.58
» » » » Rendering APP/Plugin/Frontpage/View/Elements/share.ctp	1.67
» » Rendering APP/Plugin/Frontpage/View/Elements/sidebar.ctp	74.05
» » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav.ctp	73.36
» » » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav_item.ctp	1.51
» » Rendering APP/Plugin/Product/View/Elements/product/filters.ctp	70.65
» » Rendering APP/Plugin/Frontpage/View/Elements/page/footer.ctp	3.89
» » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #4	2.95
» » Rendering APP/Plugin/Frontpage/View/Elements/document/footer.ctp #2	1.25
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)
  id1227
  uid977224391
  titleArcum
  slugarcum
  codeLR0220
  business_price21.03
  product_category_id(null)
  product_grape_variety_id(null)
  geography_region_id18
  vintage2020
  vineage(null)
  product_producer_id166
  product_distributor_id(null)
  product_range_id(null)
  soilMorainic
  trainingPergola
  yield(null)
  ageing1 year in Slavonian oak
  vinification1 year in Slavonian oak
  alcohol14.5
  product_bottle_closure_type_id10
  product_bottle_size_id4
  product_case_size_id2
  ph_level
  acidity5.35
  residual_sugar_content6.4
  method_and_production<p>Practising organic. The grapes are from the Classico zone, around the villages of Negrar and San Pietro in Cariano, planted on gravel and moraine soils formed from an ancient riverbed between. Hand-harvested fruit, from estate owned grapes. After harvest, the grapes are pressed immediately. After some days of maceration with the skins, alcoholic fermentation starts and lasts for around seven days. The wine is made in the Ripasso style, passing previously dried and pressed grapes through the juice. It's then aged in Slavonian oak barrels for one year. No fining with a delicate filtering. </p>
  tasting_notes
  food_match
  status(true)
  sorting(null)
  created2024-02-23 14:25:12
  created_by9
  modified2024-08-14 15:00:42
  modified_by9
  ProductProducer(array)
  nameL'Arco
  slugl-arco
  ProductDistributor(array)
  title(null)
  slug(null)
  ProductCaseSize(array)
  title6
  ProductBottleSize(array)
  title0.75lt
  ProductBottleClosureType(array)
  titleCork
  GeographyRegion(array)
  titleVeneto
  slugveneto
  geography_country_id5
  GeographyCountry(array)
  titleItaly
  slugitaly
  ProductImage(array)
  0(array)
  titleRosso del Veronese Arcum, L'Arco - Verona, Italy
  image_id4018
  product_id1227
  ProductBox(empty)
  ProductGrapeVarietyProduct(array)
  0(array)
  percentage60
  product_grape_variety_id53
  product_id1227
  ProductGrapeVariety(array)
  titleCorvina
  1(array)
  percentage30
  product_grape_variety_id55
  product_id1227
  ProductGrapeVariety(array)
  titleRondinella
  2(array)
  percentage10
  product_grape_variety_id58
  product_id1227
  ProductGrapeVariety(array)
  titleMolinara
  ProductCategory(array)
  0(array)
  titleRed Wine
  ProductCategoriesProduct(array)
  id16726
  product_id1227
  product_category_id1
- 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 (136)
  2(array)
  ProductCategory(array)
  id3
  slugrose-wine
  combo_titleRosé Wine (6)
  3(array)
  ProductCategory(array)
  id1
  slugred-wine
  combo_titleRed Wine (201)
  4(array)
  ProductCategory(array)
  id5
  slugdessert-wine
  combo_titleDessert Wine (16)
  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 (271)
  9(array)
  ProductCategory(array)
  id13
  slugnatural
  combo_titleNatural (4)
  categoryOptions(array)
  sparkling-wineSparkling Wine (21)
  white-wineWhite Wine (136)
  rose-wineRosé Wine (6)
  red-wineRed Wine (201)
  dessert-wineDessert Wine (16)
  organicOrganic (55)
  biodynamicBiodynamic (2)
  orange-wineOrange Wine (1)
  veganVegan (271)
  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
  SP0407Amarone della Valpolicella Classico Sant'Urbano, Speri
  SP0419Amarone della Valpolicella Classico Sant'Urbano, Speri
  SP0404Amarone della Valpolicella Classico Sant'Urbano, Speri
  SP0411Amarone della Valpolicella Classico Sant'Urbano, Speri
  MN0715Amarone 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
  OD0321Barbera 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
  OD0819Barolo 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
  MI7022Bianco Friuli Colli Orientali, Miani
  TG0220Boca - Organic, Tenute Guardasole
  VD0124Bollicine Rosé, Serafini & Vidotto
  VW0222Bourgogne Chardonnay, Vincent Wengier
  PD0123Bourgogne Chardonnay, Domaine de la Pierre des Dames
  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
  CA9719Brunello di Montalcino, Caparzo
  CR0119Brunello di Montalcino, Castello Romitorio
  CA9817Brunello di Montalcino 'La Casa', Caparzo
  CA9812Brunello 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
  HI0422Chardonnay, Highweald Wine Estate
  WS0721Chardonnay, Winzerhof Stahl
  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
  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
  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
  FR2022Dolcetto 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
  TR0220Gattinara 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
  PI0121Greco, 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
  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
  PB0122Langhe Nebbiolo , Produttori del Barbaresco
  OD0121Langhe Nebbiolo, Oddero
  ET1221Langhe Riesling Hérzu , Ettore Germano
  TL0619Lessona, Tenute Sella
  NO0419Lessona, Noah
  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
  TR0120Nebbiolo 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
  TK0221Orange Kisi, Tiko Estate
  LR0319Pario, 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
  CD0122Pinot 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
  JR0622Pinot Noir Tattendorf - Organic, Familie Reinisch
  JR0722Pinot 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
  RU0819Refosco 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
  SP0122Valpolicella 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
  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 (2)
  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 (33)
  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)
  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
  16(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
  17(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
  18(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
  19(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
  20(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
  21(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
  22(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
  23(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
  24(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
  25(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
  26(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
  27(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
  28(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
  29(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
  30(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
  31(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
  32(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
  33(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)
  34(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
  35(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
  36(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)
  37(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
  38(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
  39(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
  40(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
  41(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 (37)
  georgiaGeorgia (4)
  germanyGermany (5)
  hungaryHungary (1)
  italyItaly (297)
  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
  count37
  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
  count297
  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/vhosts/astrumwinecellars.com/httpdocs/live/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/Lib/
CACHE	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/tmp/cache/
CAKE	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib
CORE_PATH	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib/
CAKE_VERSION	2.4.6
CSS	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://www.astrumwinecellars.com
IMAGES	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/tmp/logs/
ROOT	/var/www/vhosts/astrumwinecellars.com/httpdocs/live
TESTS	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/Test/
TMP	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/tmp/
VENDORS	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40
User	astrum
Home	/var/www/vhosts/astrumwinecellars.com
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	ZtPBy8ZidReRqFPTc7wQ@QAAAI4
Redirect Redirect Script Url	/products/details/LR0220/page:3/limit:12/region:veneto
Redirect Redirect Script Uri	https://www.astrumwinecellars.com/products/details/LR0220/page:3/limit:12/region:veneto
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Passenger Compile Native Support Binary	0
Redirect Redirect Passenger Download Native Support Binary	0
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	ZtPBy8ZidReRqFPTc7wQ@QAAAI4
Redirect Script Url	/products/details/LR0220/page:3/limit:12/region:veneto
Redirect Script Uri	https://www.astrumwinecellars.com/products/details/LR0220/page:3/limit:12/region:veneto
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Passenger Compile Native Support Binary	0
Redirect Passenger Download Native Support Binary	0
Redirect Https	on
Redirect Status	200
Unique Id	ZtPBy8ZidReRqFPTc7wQ@QAAAI4
Script Url	/products/details/LR0220/page:3/limit:12/region:veneto
Script Uri	https://www.astrumwinecellars.com/products/details/LR0220/page:3/limit:12/region:veneto
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Passenger Compile Native Support Binary	0
Passenger Download Native Support Binary	0
Https	on
Proxy-nokeepalive	1
Http Host	www.astrumwinecellars.com
Http X Real Ip	3.145.56.59
Http X Accel Internal	/internal-nginx-static-location
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/LR0220/page:3/limit:12/region:veneto
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.astrumwinecellars.com
Server Addr	10.2.132.5
Server Port	443
Remote Addr	3.145.56.59
Document Root	/var/www/vhosts/astrumwinecellars.com/httpdocs/live
Request Scheme	https
Context Prefix
Context Document Root	/var/www/vhosts/astrumwinecellars.com/httpdocs/live
Server Admin	root@localhost
Script Filename	/var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/index.php
Remote Port	34356
Redirect Query String	/products/details/LR0220/page:3/limit:12/region:veneto
Redirect Url	/app/webroot/products/details/LR0220/page:3/limit:12/region:veneto
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String	/products/details/LR0220/page:3/limit:12/region:veneto
Request Uri	/products/details/LR0220/page:3/limit:12/region:veneto
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1725153739.9441
Request Time	1725153739

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/astrumwinecellars.com/httpdocs/live/lib
- 2/opt/plesk/php/5.6/share/pear
- 3-> /var/www/vhosts/astrumwinecellars.com/httpdocs/live/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

Arcum

Method & Production

Details

default

Total Time: 67 ms
Total Queries: 47 queries

Query Explain:

Memory

Timers

Specifications

Viticulture

Vinification

Arcum

Method & Production

Details

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 67 ms Total Queries: 47 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 67 ms
Total Queries: 47 queries