Astrum Wine Cellars | Search

Slug

Filter by:

Country

Region

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

Cake Params
- pluginproduct
- controllerproduct_producers
- actionsearch
- named(array)
  countryargentina
  region(null)
  limit4
- pass(empty)
- isAjax(false)
- paging(array)
  ProductProducer(array)
  page1
  current0
  count0
  prevPage(false)
  nextPage(false)
  pageCount0
  order(array)
  ProductProducer.nameasc
  limit4
  options(array)
  limit4
  paramTypenamed
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/producers/search
- defaults(array)
  pluginproduct
  controllerproduct_producers
  actionsearch
- template/producers/search/*
====

Sql Log

Sql Logs

default

Total Time: 22 ms
Total Queries: 29 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `AppPreference`.`id`, `AppPreference`.`application_name`, `AppPreference`.`email`, `AppPreference`.`mail_recipients`, `AppPreference`.`logo_id`, `AppPreference`.`intro_top`, `AppPreference`.`intro_detail`, `AppPreference`.`intro_link_id`, `AppPreference`.`404_not_found_page_id`, `AppPreference`.`smtp_host`, `AppPreference`.`smtp_port`, `AppPreference`.`smtp_username`, `AppPreference`.`smtp_password`, `AppPreference`.`meta_title`, `AppPreference`.`meta_show_title`, `AppPreference`.`meta_reverse_title`, `AppPreference`.`pdf_cover_details`, `AppPreference`.`pdf_inside_cover_file`, `AppPreference`.`pdf_introduction`, `AppPreference`.`pdf_details`, `AppPreference`.`pdf_terms_and_conditions`, `AppPreference`.`google_analytics`, `AppPreference`.`ga_username`, `AppPreference`.`ga_password`, `AppPreference`.`ga_report_id`, `AppPreference`.`userlog_record_limit`, `AppPreference`.`userlog_time_limit`, `AppPreference`.`created`, `AppPreference`.`modified` FROM `astrum`.`oc_app_preferences` AS `AppPreference` WHERE 1 = 1 LIMIT 1	1	1	1
SELECT `AppPreferenceExpanded`.`id`, `AppPreferenceExpanded`.`app_preference_id`, `AppPreferenceExpanded`.`key`, `AppPreferenceExpanded`.`value`, `AppPreferenceExpanded`.`created`, `AppPreferenceExpanded`.`modified` FROM `astrum`.`oc_app_preferences_extended` AS `AppPreferenceExpanded` WHERE `AppPreferenceExpanded`.`app_preference_id` = (1)	10	10	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` = '/producers/search/country:argentina' AND `FrontpageRewrite`.`status` = 1 LIMIT 1	0	0	1	maybe slow
SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`frontpage_page_id`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_frontpage_rewrites` AS `FrontpageRewrite` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRewrite`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRewrite`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRewrite`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRewrite`.`old` LIKE '%*' AND `FrontpageRewrite`.`status` = 1	0	0	1	maybe slow
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`url` = '/producers/search' LIMIT 1	1	1	1
SELECT `FrontpagePage`.`nleft`, `FrontpagePage`.`nright` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 35 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` <= 55 AND `FrontpagePage`.`nright` >= 56 ORDER BY `FrontpagePage`.`nleft` asc	3	3	1	maybe slow
SELECT `GeographyRegion`.`id` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` LEFT JOIN `astrum`.`oc_geography_countries` AS `GeographyCountry` ON (`GeographyRegion`.`geography_country_id` = `GeographyCountry`.`id`) WHERE `GeographyCountry`.`slug` = 'argentina' AND `GeographyRegion`.`status` = '1'	1	1	1
SELECT `ProductProducer`.`id`, `ProductProducer`.`uid`, `ProductProducer`.`name`, `ProductProducer`.`slug`, `ProductProducer`.`address`, `ProductProducer`.`geography_region_id`, `ProductProducer`.`telephone`, `ProductProducer`.`fax`, `ProductProducer`.`email`, `ProductProducer`.`website`, `ProductProducer`.`year_established`, `ProductProducer`.`total_hectares`, `ProductProducer`.`vintner_names`, `ProductProducer`.`description`, `ProductProducer`.`quotes`, `ProductProducer`.`logo_id`, `ProductProducer`.`latitude`, `ProductProducer`.`longitude`, `ProductProducer`.`pdf_new`, `ProductProducer`.`status`, `ProductProducer`.`sorting`, `ProductProducer`.`created`, `ProductProducer`.`created_by`, `ProductProducer`.`modified`, `ProductProducer`.`modified_by`, `GeographyRegion`.`title`, `GeographyRegion`.`slug`, `GeographyRegion`.`geography_country_id` FROM `astrum`.`oc_product_producers` AS `ProductProducer` LEFT JOIN `astrum`.`oc_geography_regions` AS `GeographyRegion` ON (`ProductProducer`.`geography_region_id` = `GeographyRegion`.`id`) WHERE `ProductProducer`.`status` = '1' AND `ProductProducer`.`geography_region_id` = (51) ORDER BY `ProductProducer`.`name` asc LIMIT 4	0	0	1	maybe slow
SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'header' AND `FrontpagePage`.`type` = 'folder' LIMIT 1	1	1	0
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 26 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc	5	5	1	maybe slow
SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'main' AND `FrontpagePage`.`type` = 'folder' LIMIT 1	1	1	0
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 1 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc	7	7	1	maybe slow
SELECT `CookieCompliance`.`id`, `CookieCompliance`.`content`, `CookieCompliance`.`page_id`, `CookieCompliance`.`created`, `CookieCompliance`.`created_by`, `CookieCompliance`.`modified`, `CookieCompliance`.`modified_by`, `CookieCompliance`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_cookie_compliances` AS `CookieCompliance` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`CookieCompliance`.`page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`CookieCompliance`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`CookieCompliance`.`modified_by` = `ModifiedBy`.`id`) WHERE 1 = 1 LIMIT 1	1	1	1
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`extract`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`asset_folder_id`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`path`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `SourceAsset`.`id`, `SourceAsset`.`parent_id`, `SourceAsset`.`uid`, `SourceAsset`.`name`, `SourceAsset`.`caption`, `SourceAsset`.`ext`, `SourceAsset`.`size`, `SourceAsset`.`width`, `SourceAsset`.`height`, `SourceAsset`.`extract`, `SourceAsset`.`created`, `SourceAsset`.`created_by`, `SourceAsset`.`modified`, `SourceAsset`.`modified_by`, `SourceAsset`.`sorting`, `SourceAsset`.`status`, `SourceAsset`.`path`, `SourceAsset`.`tags`, `SourceAsset`.`crop_params`, `SourceAsset`.`flash_video_ready`, `SourceAsset`.`video_thumbnail_ready`, `SourceAsset`.`asset_folder_id`, `SourceAsset`.`object`, `SourceAsset`.`object_id`, `SourceAsset`.`object_alias`, `SourceAsset`.`google_drive_file_id`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_assets` AS `Asset` LEFT JOIN `astrum`.`oc_asset_folders` AS `AssetFolder` ON (`Asset`.`asset_folder_id` = `AssetFolder`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `SourceAsset` ON (`Asset`.`parent_id` = `SourceAsset`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 3503 LIMIT 1	1	1	1
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `astrum`.`oc_asset_categories` AS `AssetCategory` JOIN `astrum`.`oc_asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 3503 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`)	0	0	1	maybe slow
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` = 35 LIMIT 1	1	1	1
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` <= 55 AND `FrontpagePage`.`nright` >= 56 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, 11, 35) 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, 11, 35)	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, 11, 35) 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` = 11 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc	2	2	1	maybe slow
SELECT `ProductProducer`.`slug`, `ProductProducer`.`name` FROM `astrum`.`oc_product_producers` AS `ProductProducer` WHERE `ProductProducer`.`status` = '1' ORDER BY `ProductProducer`.`name` asc	95	95	1
SELECT `GeographyCountry`.`slug`, (CONCAT(`GeographyCountry`.`title`, " (", `GeographyCountry`.`product_producer_count`, ")")) AS `GeographyCountry__product_producer_combo_title`, `GeographyCountry`.`id` FROM `astrum`.`oc_geography_countries` AS `GeographyCountry` LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`GeographyCountry`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`GeographyCountry`.`modified_by` = `ModifiedBy`.`id`) WHERE `GeographyCountry`.`status` = '1' ORDER BY `GeographyCountry`.`title` asc	16	16	1	maybe slow
SELECT `GeographyRegion`.`id`, `GeographyRegion`.`uid`, `GeographyRegion`.`geography_country_id`, `GeographyRegion`.`product_count`, `GeographyRegion`.`product_producer_count`, `GeographyRegion`.`title`, `GeographyRegion`.`slug`, `GeographyRegion`.`status`, `GeographyRegion`.`sorting`, `GeographyRegion`.`created`, `GeographyRegion`.`created_by`, `GeographyRegion`.`modified`, `GeographyRegion`.`modified_by`, (CONCAT(`GeographyRegion`.`title`, " (", `GeographyRegion`.`product_count`, ")")) AS `GeographyRegion__product_combo_title`, (CONCAT(`GeographyRegion`.`title`, " (", `GeographyRegion`.`product_producer_count`, ")")) AS `GeographyRegion__product_producer_combo_title` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` WHERE `GeographyRegion`.`geography_country_id` IN (14, 13, 1, 2, 15, 3, 9, 4, 5, 6, 16, 7, 11, 8, 12, 10)	62	62	1
SELECT `GeographyRegion`.`slug`, `GeographyCountry`.`title`, (CONCAT(`GeographyRegion`.`title`, " (", `GeographyRegion`.`product_producer_count`, ")")) AS `GeographyRegion__product_producer_combo_title` 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`.`status` = '1' AND `GeographyCountry`.`status` = '1' AND `GeographyRegion`.`product_producer_count` >= 1 ORDER BY `GeographyCountry`.`title` asc, `GeographyRegion`.`sorting` asc	43	43	1
SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'footer' AND `FrontpagePage`.`type` = 'folder' LIMIT 1	1	1	1
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 17.22 MB

Message	Memory use
Component initialization	4.90 MB
Controller action start	8.45 MB
Controller render start	9.27 MB
View render complete	13.89 MB

Timers

Total Request Time: 237 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	35.53
Event: Controller.initialize	34.54
Event: Controller.startup	0.98
Controller action	10.13
Event: Controller.beforeRender	20.72
» Processing toolbar data	20.26
Rendering View	73.31
» Event: View.beforeRender	0.09
» Rendering APP/Plugin/Product/View/ProductProducers/search.ctp	0.35
» Event: View.afterRender	0.08
» Event: View.beforeLayout	0.04
» Rendering APP/Plugin/Frontpage/View/Layouts/producer-filters.ctp	71.23
» » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp	3.61
» » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #2	3.90
» » Rendering APP/Plugin/Frontpage/View/Elements/document/header.ctp	1.71
» » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/navigation.ctp #3	0.58
» » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp	0.20
» » Rendering APP/Plugin/Frontpage/View/Elements/page/header.ctp #2	15.69
» » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp #2	0.22
» » » Rendering APP/Plugin/Frontpage/View/Elements/social_sharing.ctp	2.63
» » » » Rendering APP/Plugin/Frontpage/View/Elements/share.ctp	1.97
» » Rendering APP/Plugin/Frontpage/View/Elements/sidebar.ctp	15.55
» » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav.ctp	15.23
» » » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav_item.ctp	2.09
» » Rendering APP/Plugin/Product/View/Elements/product_producer/filters.ctp	17.62
» » Rendering APP/Plugin/Frontpage/View/Elements/page/footer.ctp	4.96
» » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #4	4.29
» » Rendering APP/Plugin/Frontpage/View/Elements/document/footer.ctp #2	1.35
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- title_for_layoutAstrum Wine Cellars | Search < Producers
- crumbs(array)
  0(array)
  titleHome
  url/
  options(null)
  1(array)
  titleProducers
  url/producers
  options(null)
  2(array)
  titleSearch
  url/producers/search
  options(null)
- data(empty)
- ProductLib(object)
- activePages(array)
  01
  111
  235
- page(array)
  FrontpagePage(array)
  id35
  parent_id11
  nleft55
  nright56
  level0
  sorting0
  nameSearch
  titleSearch
  slugsearch
  typepage
  url/producers/search
  external_url(null)
  folder_key(null)
  alias_id(null)
  meta_title
  meta_keywords
  meta_description
  in_sitemap(true)
  sitemap_modified2012-10-25 13:48:22
  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_fileproducer-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-25 13:49:00
  created_by4
  modified2012-10-26 17:00:11
  modified_by4
  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)
  GeographyRegion(empty)
  GeographyCountry(empty)
  ProductProducer(empty)
  ProductProducerImage(empty)
- Loaded Helpers(array)
  0Frontpage
  1Cache
  2AppTable
  3Form
  4Asset
  5AssetCompress
  6CookieCompliance
  7FrontpageSitemap
  8Html
  9Js
  10Pager
  11Text
  12Time
  13Number
  14GoogleMapV3
  15Avatar
  16SimpleGraph
  17Paginator
  18DebugTimer
  19Toolbar
  20AppJqueryEngine
  21Session
  22HtmlToolbar
====

Environment

App Constants

Constant	Value
GWINE	wine
GSPIRIT	spirit

CakePHP Constants

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

PHP Environment

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

====

Include
+
Included Files

Include Paths
- 0/var/www/lib
- 2/usr/local/lib/php
- 3-> /var/www/cake/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  1CORE/Model/Behavior/TreeBehavior.php
  2CORE/Model/Behavior/AclBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/RequestHandlerComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/AuthComponent.php
  4CORE/Controller/Component/PaginatorComponent.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
  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/ProductProducersController.php
  1Product/Controller/ProductAppController.php
  Plugin(array)
  0Product/Lib/ProductLib.php
  Model(array)
  0Product/Model/ProductProducer.php
  1Product/Model/ProductAppModel.php
  2Product/Model/ProductProducerImage.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
====

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 22 ms Total Queries: 29 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 22 ms
Total Queries: 29 queries