Astrum Wine Cellars

Code

Filter by:

Sql Logs

default

Total Time: 7 ms
Total Queries: 40 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` = '/bar' AND `FrontpageRewrite`.`status` = 1 LIMIT 1	0	0	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` 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` = '/bar' LIMIT 1	1	1	0
SELECT `FrontpagePage`.`nleft`, `FrontpagePage`.`nright` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 51 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` <= 66 AND `FrontpagePage`.`nright` >= 71 ORDER BY `FrontpagePage`.`nleft` asc	2	2	0
SELECT `FrontpageContentCategory`.`id` FROM `astrum`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` WHERE `FrontpageContentCategory`.`slug` = 'hero' LIMIT 1	1	1	0
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`, `FrontpageContentCategory`.`id`, `FrontpageContentCategory`.`name`, `FrontpageContentCategory`.`slug`, `FrontpageContentCategory`.`created`, `FrontpageContentCategory`.`modified`, `Image`.`id`, `Image`.`parent_id`, `Image`.`uid`, `Image`.`name`, `Image`.`caption`, `Image`.`ext`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`extract`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Image`.`sorting`, `Image`.`status`, `Image`.`path`, `Image`.`tags`, `Image`.`crop_params`, `Image`.`flash_video_ready`, `Image`.`video_thumbnail_ready`, `Image`.`asset_folder_id`, `Image`.`object`, `Image`.`object_id`, `Image`.`object_alias`, `Image`.`google_drive_file_id`, `Quote`.`id`, `Quote`.`uid`, `Quote`.`title`, `Quote`.`text`, `Quote`.`quotee`, `Quote`.`image_id`, `Quote`.`sorting`, `Quote`.`status`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `astrum`.`oc_frontpage_contents` AS `FrontpageContent` 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`) WHERE `FrontpageContent`.`frontpage_page_id` = 51 AND `FrontpageContent`.`status` = 1 AND `FrontpageContent`.`frontpage_content_category_id` = 1 ORDER BY `FrontpageContent`.`sorting` asc	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` = (89) 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` = 89 AND `FrontpageContentsFrontpageElement`.`frontpage_element_id` = `FrontpageElement`.`id`)	1	1	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` = 'spirit' ORDER BY `ProductCategory`.`sorting` asc	2	2	0
SELECT `ProductCategoriesProduct`.`product_id` FROM `astrum`.`oc_product_categories_products` AS `ProductCategoriesProduct` WHERE `product_category_id` IN (6, 14)	200	200	1
SELECT `Product`.`geography_region_id`, `Product`.`code`, `Product`.`title`, `ProductProducer`.`name`, `ProductDistributor`.`title`, `ProductProducer`.`id`, `ProductDistributor`.`id` FROM `astrum`.`oc_products` AS `Product` LEFT JOIN `astrum`.`oc_product_producers` AS `ProductProducer` ON (`Product`.`product_producer_id` = `ProductProducer`.`id`) LEFT JOIN `astrum`.`oc_product_distributors` AS `ProductDistributor` ON (`Product`.`product_distributor_id` = `ProductDistributor`.`id`) WHERE `Product`.`status` = '1' AND `Product`.`id` IN (303, 304, 305, 306, 308, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 857, 858, 468, 475, 496, 511, 512, 513, 514, 515, 516, 517, 518, 538, 551, 552, 553, 557, 558, 601, 602, 604, 610, 611, 612, 613, 614, 615, 616, 618, 619, 621, 620, 622, 644, 645, 647, 662, 663, 666, 689, 690, 691, 692, 694, 695, 698, 699, 700, 701, 704, 856, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 722, 723, 735, 738, 739, 740, 748, 755, 756, 763, 777, 778, 781, 784, 785, 786, 800, 811, 812, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 833, 853, 859, 860, 861, 862, 863, 864, 878, 879, 887, 888, 889, 890, 891, 892, 917, 918, 919, 963, 852, 988, 989, 1008, 1173, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1018, 1036, 1095, 1127, 1147, 1148, 1151, 1150, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1174, 1263, 1096, 307, 309, 536, 537, 1109, 1110, 1111, 1184, 1192, 1212, 1213, 1235, 1264, 1265, 1291, 1292, 1293) ORDER BY `Product`.`title` asc	101	101	3
SELECT `GeographyRegion`.`id`, `GeographyRegion`.`geography_country_id` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` WHERE `id` IN (13, 22, 45, 19, 18, 25, 14, 35, 50)	9	9	0
SELECT `GeographyRegion`.`id`, `GeographyRegion`.`slug`, `GeographyRegion`.`title`, `GeographyCountry`.`id`, `GeographyCountry`.`slug`, `GeographyCountry`.`title`, `GeographyCountry`.`image_area_coordinates`, `GeographyCountry`.`image_area_coordinates_spirit` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` LEFT JOIN `astrum`.`oc_geography_countries` AS `GeographyCountry` ON (`GeographyRegion`.`geography_country_id` = `GeographyCountry`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`GeographyRegion`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`GeographyRegion`.`modified_by` = `ModifiedBy`.`id`) WHERE `GeographyRegion`.`id` IN (13, 22, 45, 19, 18, 25, 14, 35, 50) AND `GeographyRegion`.`status` = '1' AND `GeographyCountry`.`status` = '1' ORDER BY `GeographyCountry`.`title` asc, `GeographyRegion`.`sorting` asc	8	8	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` = 2300 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` = 2300 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`)	1	1	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` = 2300 AND `AssetTagsAsset`.`asset_tag_id` = `AssetTag`.`id`) ORDER BY `AssetTagsAsset`.`sorting` ASC	0	0	0
SELECT `FrontpageContentCategory`.`id` FROM `astrum`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` WHERE `FrontpageContentCategory`.`slug` = 'article' LIMIT 1	1	1	0
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`, `FrontpageContentCategory`.`id`, `FrontpageContentCategory`.`name`, `FrontpageContentCategory`.`slug`, `FrontpageContentCategory`.`created`, `FrontpageContentCategory`.`modified`, `Image`.`id`, `Image`.`parent_id`, `Image`.`uid`, `Image`.`name`, `Image`.`caption`, `Image`.`ext`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`extract`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Image`.`sorting`, `Image`.`status`, `Image`.`path`, `Image`.`tags`, `Image`.`crop_params`, `Image`.`flash_video_ready`, `Image`.`video_thumbnail_ready`, `Image`.`asset_folder_id`, `Image`.`object`, `Image`.`object_id`, `Image`.`object_alias`, `Image`.`google_drive_file_id`, `Quote`.`id`, `Quote`.`uid`, `Quote`.`title`, `Quote`.`text`, `Quote`.`quotee`, `Quote`.`image_id`, `Quote`.`sorting`, `Quote`.`status`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `astrum`.`oc_frontpage_contents` AS `FrontpageContent` 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`) WHERE `FrontpageContent`.`frontpage_page_id` = 51 AND `FrontpageContent`.`status` = 1 AND `FrontpageContent`.`frontpage_content_category_id` = 2 ORDER BY `FrontpageContent`.`sorting` asc	1	1	0
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` = (90) 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` = 90 AND `FrontpageContentsFrontpageElement`.`frontpage_element_id` = `FrontpageElement`.`id`)	1	1	0
SELECT `ProductHighlight`.`id`, `ProductHighlight`.`product_id`, `ProductHighlight`.`status`, `ProductHighlight`.`sorting`, `ProductHighlight`.`created`, `ProductHighlight`.`created_by`, `ProductHighlight`.`modified`, `ProductHighlight`.`modified_by`, `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` FROM `astrum`.`oc_product_highlights` AS `ProductHighlight` LEFT JOIN `astrum`.`oc_products` AS `Product` ON (`ProductHighlight`.`product_id` = `Product`.`id`) WHERE `ProductHighlight`.`status` = '1' AND `Product`.`status` = '1' ORDER BY `ProductHighlight`.`sorting` asc	0	0	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	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` = 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` = 51 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` <= 66 AND `FrontpagePage`.`nright` >= 71 ORDER BY `FrontpagePage`.`nleft` asc	2	2	0
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, 51) 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, 51)	1	1	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, 51) 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` = 51 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc	2	2	0
SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'footer' AND `FrontpagePage`.`type` = 'folder' LIMIT 1	1	1	0
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 2 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc	3	3	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.19 MB

Message	Memory use
Component initialization	2.44 MB
Controller action start	4.37 MB
Controller render start	4.49 MB
View render complete	8.42 MB

Timers

Total Request Time: 303 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	52.77
Event: Controller.initialize	31.91
Event: Controller.startup	0.94
Controller action	0.70
Event: Controller.beforeRender	19.67
» Processing toolbar data	19.37
Rendering View	151.23
» Event: View.beforeRender	0.05
» Rendering APP/Plugin/Product/View/Spirits/map.ctp	88.91
» Rendering APP/Plugin/Frontpage/View/Elements/single-column.ctp	94.24
» » » Rendering APP/Plugin/Quote/View/Elements/quote/display.ctp	0.44
» » Rendering APP/Plugin/Frontpage/View/Elements/template/single-column/hero.ctp	58.34
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/title.ctp	0.40
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/subtitle.ctp	0.40
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/image.ctp	0.41
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/text.ctp	0.40
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/documents.ctp	0.41
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/embed.ctp	0.39
» » » Rendering APP/Plugin/Frontpage/View/Elements/section/element.ctp	53.35
» » » » Rendering APP/Plugin/Product/View/Elements/product/map-search.ctp	52.57
» Rendering APP/Plugin/Product/View/Elements/product/map.ctp #2	70.31
» » » » » » Rendering APP/Plugin/Product/View/Elements/product/search.ctp	4.39
» » » » » » Rendering APP/Plugin/Frontpage/View/Elements/corner.ctp	0.41
» » Rendering APP/Plugin/Frontpage/View/Elements/single-column.ctp #2	17.63
» » » Rendering APP/Plugin/Quote/View/Elements/quote/display.ctp #2	0.41
» » » Rendering APP/Plugin/Frontpage/View/Elements/template/single-column/article.ctp	12.37
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/title.ctp #2	0.38
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/subtitle.ctp #2	0.38
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/image.ctp #2	0.37
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/text.ctp #2	0.37
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/documents.ctp #2	0.26
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/embed.ctp #2	0.39
» » » » Rendering APP/Plugin/Frontpage/View/Elements/section/element.ctp #2	7.81
» » » » » Rendering APP/Plugin/Product/View/Elements/product/highlights.ctp	7.12
» Event: View.afterRender	0.19
» Event: View.beforeLayout	0.05
» Rendering APP/Plugin/Frontpage/View/Layouts/default.ctp	36.12
» » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp	2.74
» » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #2	2.37
» » Rendering APP/Plugin/Frontpage/View/Elements/document/header.ctp	1.27
» » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/navigation.ctp #3	0.76
» » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp	0.29
» » Rendering APP/Plugin/Frontpage/View/Elements/page/header.ctp #2	7.71
» » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp #2	0.44
» » » Rendering APP/Plugin/Frontpage/View/Elements/social_sharing.ctp	2.55
» » » » Rendering APP/Plugin/Frontpage/View/Elements/share.ctp	1.67
» » Rendering APP/Plugin/Frontpage/View/Elements/sidebar.ctp	12.49
» » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav.ctp	11.83
» » » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav_item.ctp	1.21
» » Rendering APP/Plugin/Frontpage/View/Elements/page/footer.ctp	2.84
» » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #4	2.04
» » Rendering APP/Plugin/Frontpage/View/Elements/document/footer.ctp #2	0.81
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- title_for_layoutAstrum Wine Cellars | Bar
- crumbs(array)
  0(array)
  titleHome
  url/
  options(null)
  1(array)
  titleBar
  url/bar
  options(null)
- ProductLib(object)
  data(array)
  categories(array)
  0(array)
  ProductCategory(array)
  id6
  slugspirits-liqueurs
  combo_titleSpirits & Liqueurs (101)
  1(array)
  ProductCategory(array)
  id14
  slugbeer
  combo_titleBeer (0)
  categoryOptions(array)
  spirits-liqueursSpirits & Liqueurs (101)
  beerBeer (0)
  productsOptions(array)
  DQ033Amaretto, Antica Distilleria Quaglia
  CZ002Amaro Laziale, Colazingari Liquori
  DQ038Americano 1907 Barrel Finished Cocktail, Mr. Quail & J.T
  DQ020Aperitivo, Bèrto
  SM1067Barbados Rhapsody Blended Rum (2022 Edition), Samaroli
  SM1020Barbados Rum Cask 1 (2021 Edition) 2001, Samaroli
  DQ021Bitter , Bèrto
  VZ110Brandy 10Yrs, Villa Zarri
  VZ124Brandy 23Yrs, Villa Zarri
  VZ310Cherry Brandy, Villa Zarri
  VZ410Coffee Brandy, Villa Zarri
  SM1032Cognac Grande Champagne N.72 (2021 Edition), Samaroli
  SM1036Demerara Rum Cask N.1700051 (2020 Edition), Samaroli
  CV030Distillato di Albicocche Val Venosta, Capovilla Distillati
  CV027Distillato di Bacche di Sambuco, Capovilla Distillati
  CV008Distillato di Ciliegie Duroni, Capovilla Distillati
  CV013Distillato di Lamponi Selvatici, Capovilla Distillati
  CV024Distillato di Mele Decio di Belfiore, Capovilla Distillati
  CV006Distillato di Pere Williams, Capovilla Distillati
  CV009Distillato di Pesche Saturno, Capovilla Distillati
  CV010Distillato di Prugne Selvatiche, Capovilla Distillati
  CV025Distillato di Prunus Aurum , Capovilla Distillati
  CV023Distillato di Ribes Nero, Capovilla Distillati
  CV005Distillato di Uva Isabella, Capovilla Distillati
  CV016Distillato di Vino (Brandy), Capovilla Distillati
  VZ846Dusk Manhatten Cherry Brandy, Villa Zarri
  VZ845Dusk Negroni Brandy, Villa Zarri
  CZ003Genziana Superiore, Colazingari Liquori
  DQ022Gin, Bèrto
  DQ055Gin Juniperus Cask Finish, Bèrto
  DQ009Grappa Classica, Antica Distilleria Quaglia
  CV003Grappa di Amarone, Capovilla Distillati
  CV001Grappa di Bassano, Capovilla Distillati
  CV015Grappa di Brunello di Montalcino, Capovilla Distillati
  CV032Grappa di Cabernet Sauvignon, Capovilla Distillati
  CV004Grappa di Moscato Giallo, Capovilla Distillati
  CV031Grappa di Nebbiolo, Capovilla Distillati
  DQ054Grappa di Nebbiolo (Barrel Aged), Antica Distilleria Quaglia
  CV021Grappa di Ribolla Gravner, Capovilla Distillati
  CV020Grappa Tabacco Amarone, Capovilla Distillati
  SM1066Haiti Rum Cask N.23 (2022 Edition), Samaroli
  SM1050Islay Single Malt Scotch Whisky (2022 Edition), Samaroli
  SM1055Islay Single Malt Scotch Whisky Caol Ila Cask N.2100012 (2022 Edition), Samaroli
  SM1004Islay Single Malt Scotch Whisky Caol Ila Cask N.301632 (2021 Edition), Samaroli
  DQ063Italian Espresso Coffee Liqueur Ninebar, Antica Distilleria Quaglia
  SM1061Jamaica Rhapsody Blended Rum (2022 Edition), Samaroli
  SM1027Jamaica Rum Cask N.435083 (2021 Edition), Samaroli
  DQ036Jerry Thomas Instant Age Classic Oak Aromatic Bitter , Antica Distilleria Quaglia
  IP0115Limoncello di Amalfi, Terra di Limoni
  IP0522Limoncello Primitivo, Terra di Limoni
  DQ007Liquore di Assenzio Bianco (Absinthe Liqueur), Antica Distilleria Quaglia
  DQ006Liquore di Bergamotto (Bergamot Liqueur), Antica Distilleria Quaglia
  DQ004Liquore di Camomilla (Chamomile Liqueur), Antica Distilleria Quaglia
  DQ018Liquore di China (Cinchona Liqueur), Antica Distilleria Quaglia
  DQ005Liquore di Chinotto, Antica Distilleria Quaglia
  DQ049Liquore di Ciliegia (Cherry Liqueur), Antica Distilleria Quaglia
  DQ031Liquore di Doppio-Carvi (Caraway Liqueur), Antica Distilleria Quaglia
  DQ023Liquore di Fernet, Antica Distilleria Quaglia
  DQ056Liquore di Gelsomino (Jasmine Liqueur), Antica Distilleria Quaglia
  DQ030Liquore di Lampone (Raspberry Liqueur), Antica Distilleria Quaglia
  DQ029Liquore di Nocciola (Hazelnut Liqueur), Antica Distilleria Quaglia
  DQ008Liquore di Pino Mugo (Pine Liqueur), Antica Distilleria Quaglia
  DQ050Liquore di Rabarbaro (Rhubarb Liqueur), Antica Distilleria Quaglia
  DQ011Liquore di Rosa (Rose Liqueur), Antica Distilleria Quaglia
  DQ028Liquore di Sambuco (Elderflower Liqueur), Antica Distilleria Quaglia
  DQ058Liquore di Tamarindo (Tamarind Liqueur), Antica Distilleria Quaglia
  DQ059Liquore di Uva Fragola (Fox Grape Liqueur), Antica Distilleria Quaglia
  DQ052Liquore di Violetta (Violet Liqueur), Antica Distilleria Quaglia
  DQ015Liquore di Zafferano (Saffron Liqueur), Antica Distilleria Quaglia
  DQ057Liquore di Zenzero (Ginger Liqueur), Antica Distilleria Quaglia
  VZ210Liquore Nocino - Organic, Villa Zarri
  DQ040Martinez 1887 Barrel Finished Cocktail, Mr. Quail & J.T
  DQ039Negroni 1919 Barrel Finished Cocktail, Mr. Quail & J.T
  VZ847New Orange Brandy , Villa Zarri
  DQ053Old Tom Gin , Bèrto
  DQ051AOrange Brandy, Antica Distilleria Quaglia
  SM1030AOrange Liquor (2021 Edition), Samaroli
  SM1038Pacific Oblivion Rum Cask N.50 (2021 Edition), Samaroli
  CV090Rhum Rhum Blanc Agricole (Green), Rhum Rhum
  CV091Rhum Rhum Blanc Agricole (Orange), Rhum Rhum
  CV092Rhum Rhum Libération 45% (NLA), Rhum Rhum
  CV093Rhum Rhum Libération 58% (NLA), Rhum Rhum
  TI001Rose Gin, Tinkture
  SM1069Samba Blended Rum (2022 Edition), Samaroli
  CZ001Sambuca Fina, Colazingari Liquori
  SM1033Single Malt Irish Whisky Cask N.10049 (2021 Edition), Samaroli
  SM1021ASingle Malt Scotch Whisky Bowmore Sherry Cask N.54 (2021 Edition), Samaroli
  SM1589Single Malt Scotch Whisky Magnifico Macallan Cask N.1219 (2022 Edition), Samaroli
  SM1078Single Malt Scotch Whisky Magnifico Springbank Cask N.567 (2022 Edition), Samaroli
  SM2095Single Malt Scotch Whisky Magnifico Springbank Cask N.63 (2021 Edition), Samaroli
  SM1051Speyside Single Malt Scotch Whisky (2022 Edition), Samaroli
  SM1057Speyside Single Malt Scotch Whisky Braeval Cask N.165697 (2022 Edition), Samaroli
  SM1056Speyside Single Malt Scotch Whisky Glentauchers Cask N.901229 (2022 Edition), Samaroli
  SM1060SPQR Blended Rum (2022 Edition), Samaroli
  DQ010Vermouth Bianco, Bèrto
  DQ025Vermouth di Torino Superiore Bianco, Bèrto
  DQ024Vermouth di Torino Superiore Rosso, Bèrto
  DQ001Vermouth Rosso, Bèrto
  SM1062Yehmon Classic Blended Rum (2022 Edition), Samaroli
  SM1064Yehmon Retro Blended Rum (2022 Edition), Samaroli
  SM1063Yehmon Vintage Blended Rum (2022 Edition), Samaroli
  regionOptions(array)
  Guadeloupe(array)
  marie-galanteMarie Galante (4)
  Italy(array)
  piemontePiemonte (38)
  venetoVeneto (20)
  emilia-romagnaEmilia Romagna (8)
  lazioLazio (3)
  campaniaCampania (1)
  The United Kingdom(array)
  edinburghEdinburgh (25)
  cornwallCornwall (1)
  regions(array)
  0(array)
  GeographyRegion(array)
  id35
  slugmarie-galante
  titleMarie Galante
  GeographyCountry(array)
  id9
  slugguadeloupe
  titleGuadeloupe
  image_area_coordinates443,45,447,51,447,58,452,58,459,66,467,62,463,58,471,58,467,62,459,66,442,67,442,63,435,62,435,70,439,70,439,78,450,82,454,81,454,77,460,77,460,86,455,86,455,91,450,91,450,82,439,78,436,79,435,90,430,91,430,89,434,89,434,83,426,83,426,79,422,79,422,62,418
  image_area_coordinates_spirit24,199,25,20,226,20,225,198
  1(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
  2(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
  3(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
  4(array)
  GeographyRegion(array)
  id22
  sluglazio
  titleLazio
  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
  5(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
  6(array)
  GeographyRegion(array)
  id45
  slugedinburgh
  titleEdinburgh
  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
  7(array)
  GeographyRegion(array)
  id50
  slugcornwall
  titleCornwall
  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)
  guadeloupeGuadeloupe (4)
  italyItaly (70)
  the-united-kingdomThe United Kingdom (26)
  countries(array)
  guadeloupe(array)
  id9
  slugguadeloupe
  titleGuadeloupe
  image_area_coordinates443,45,447,51,447,58,452,58,459,66,467,62,463,58,471,58,467,62,459,66,442,67,442,63,435,62,435,70,439,70,439,78,450,82,454,81,454,77,460,77,460,86,455,86,455,91,450,91,450,82,439,78,436,79,435,90,430,91,430,89,434,89,434,83,426,83,426,79,422,79,422,62,418
  image_area_coordinates_spirit24,199,25,20,226,20,225,198
  count4
  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
  count70
  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
  count26
- groupspirit
- activePages(array)
  01
  151
- page(array)
  FrontpagePage(array)
  id51
  parent_id1
  nleft66
  nright71
  level0
  sorting0
  nameBar
  titleBar
  slugbar
  typepage
  url/bar
  external_url
  folder_key(null)
  alias_id(null)
  meta_title
  meta_keywords
  meta_description
  in_sitemap(true)
  sitemap_modified2018-09-17 09:17:09
  sitemap_changesmonthly
  sitemap_priority0.9
  is_homepage(false)
  in_routes(true)
  in_navigation(true)
  logged_in_only(false)
  logged_out_only(false)
  user_landing_page(false)
  overlay(false)
  is_404page(false)
  layout_filedefault
  layout_file_recursive0
  view_filesingle-column
  view_file_recursive0
  use_url_as_view0
  meta_title_template(null)
  options(null)
  options_local(null)
  tags
  notes(null)
  created2018-09-17 09:17:09
  created_by(null)
  modified2024-10-02 12:34:53
  modified_by9
  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)
- 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	ZwFXRYZz0tO8UT4wzD@wigAAAMw
Redirect Redirect Script Url	/bar
Redirect Redirect Script Uri	https://www.astrumwinecellars.com/bar
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	ZwFXRYZz0tO8UT4wzD@wigAAAMw
Redirect Script Url	/bar
Redirect Script Uri	https://www.astrumwinecellars.com/bar
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	ZwFXRYZz0tO8UT4wzD@wigAAAMw
Script Url	/bar
Script Uri	https://www.astrumwinecellars.com/bar
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.236.112.101
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http Accept Language	en-US,en;q=0.5
Http Accept Encoding	br,gzip
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.236.112.101
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	34274
Redirect Query String	/bar
Redirect Url	/app/webroot/bar
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String	/bar
Request Uri	/bar
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1728141125.9906
Request Time	1728141125

====

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
  GeographyAdmin(array)
  Config(array)
  0GeographyAdmin/Config/bootstrap.php
  1GeographyAdmin/Config/routes.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/SpiritsController.php
  1Product/Controller/ProductsController.php
  2Product/Controller/ProductAppController.php
  Plugin(array)
  0Product/Lib/ProductLib.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
  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
====

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 7 ms Total Queries: 40 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 7 ms
Total Queries: 40 queries