Friends of the Art Museum: The Chinese University of Hong Kong:

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllermain
- actionindex
- named(empty)
- pass(empty)
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllermain
  actionindex
  plugin(null)
- template/
====

Sql Logs

default

Total Time: 1351 ms
Total Queries: 172 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Language`.`id`, `Language`.`alias`, `Language`.`name` FROM `cam_foam`.`languages` AS `Language` WHERE `Language`.`alias` = 'en' LIMIT 1	1	1	1345	maybe slow
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`parent_category_id` IS NULL AND `WebCategory`.`is_active` = '1' ORDER BY `WebCategory`.`priority` ASC	2	2	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_category_id` IN (1, 28) ORDER BY `ChildCategory`.`priority` ASC	4	4	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`is_active` = 1 AND `ChildCategory`.`parent_category_id` IN (2, 8, 20, 24) ORDER BY `ChildCategory`.`priority` ASC	16	16	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`is_active` = 1 AND `ChildCategory`.`parent_category_id` IN (3, 25, 29, 9, 22, 10, 26, 4, 12, 5, 23, 6, 27, 7, 18, 19) ORDER BY `ChildCategory`.`priority` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`is_active` = 1 AND `ChildCategory`.`parent_category_id` IN (13, 17, 14) ORDER BY `ChildCategory`.`priority` ASC	0	0	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (13, 17, 14)	3	3	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (3, 25, 29, 9, 22, 10, 26, 4, 12, 5, 23, 6, 27, 7, 18, 19)	16	16	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (2, 8, 20, 24)	4	4	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (1, 28)	2	2	0
SELECT `WebVariable`.`alias`, `WebVariable`.`value` FROM `cam_foam`.`web_variables` AS `WebVariable` WHERE 1 = 1	3	3	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date`, `ParentCategory`.`id`, `ParentCategory`.`parent_category_id`, `ParentCategory`.`alias`, `ParentCategory`.`web_category_type_id`, `ParentCategory`.`web_template_id`, `ParentCategory`.`is_active`, `ParentCategory`.`priority`, `ParentCategory`.`modified_date`, `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name`, `WebTemplate`.`id`, `WebTemplate`.`alias`, `WebTemplate`.`name` FROM `cam_foam`.`web_categories` AS `WebCategory` LEFT JOIN `cam_foam`.`web_categories` AS `ParentCategory` ON (`WebCategory`.`parent_category_id` = `ParentCategory`.`id`) LEFT JOIN `cam_foam`.`web_category_types` AS `WebCategoryType` ON (`WebCategory`.`web_category_type_id` = `WebCategoryType`.`id`) LEFT JOIN `cam_foam`.`web_templates` AS `WebTemplate` ON (`WebCategory`.`web_template_id` = `WebTemplate`.`id`) WHERE 1 = 1 ORDER BY `WebCategory`.`priority` ASC	29	29	1
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	24	24	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	29	29	0
SELECT `WebArticle`.`id`, `WebArticle`.`web_category_id`, `WebArticle`.`image_file`, `WebArticle`.`document_file_1`, `WebArticle`.`document_file_2`, `WebArticle`.`priority`, `WebArticle`.`modified_date` FROM `cam_foam`.`web_articles` AS `WebArticle` WHERE `WebArticle`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	119	119	1
SELECT `WebEvent`.`id`, `WebEvent`.`web_category_id`, `WebEvent`.`start_date`, `WebEvent`.`end_date`, `WebEvent`.`image_file_1`, `WebEvent`.`image_file_2`, `WebEvent`.`image_file_3`, `WebEvent`.`priority`, `WebEvent`.`modified_date` FROM `cam_foam`.`web_events` AS `WebEvent` WHERE `WebEvent`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	128	128	1
SELECT `WebOrgInfo`.`id`, `WebOrgInfo`.`web_category_id`, `WebOrgInfo`.`tel1`, `WebOrgInfo`.`tel2`, `WebOrgInfo`.`tel3`, `WebOrgInfo`.`fax1`, `WebOrgInfo`.`fax2`, `WebOrgInfo`.`fax3`, `WebOrgInfo`.`email1`, `WebOrgInfo`.`email2`, `WebOrgInfo`.`email3`, `WebOrgInfo`.`address`, `WebOrgInfo`.`priority`, `WebOrgInfo`.`modified_date` FROM `cam_foam`.`web_org_infos` AS `WebOrgInfo` WHERE `WebOrgInfo`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	1	1	0
SELECT `WebPhotoAlbum`.`id`, `WebPhotoAlbum`.`web_category_id`, `WebPhotoAlbum`.`priority`, `WebPhotoAlbum`.`modified_date` FROM `cam_foam`.`web_photo_albums` AS `WebPhotoAlbum` WHERE `WebPhotoAlbum`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	7	7	0
SELECT `WebVideo`.`id`, `WebVideo`.`web_category_id`, `WebVideo`.`video_file`, `WebVideo`.`thumbnail_file`, `WebVideo`.`priority`, `WebVideo`.`modified_date` FROM `cam_foam`.`web_videos` AS `WebVideo` WHERE `WebVideo`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	0	0	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 10	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (10)	1	1	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 4	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (4)	2	2	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 5	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (5)	2	2	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 4	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (4)	2	2	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 6	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (6)	1	1	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 11	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (11)	1	1	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 5	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (5)	2	2	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`parent_category_id` IS NULL AND `WebCategory`.`is_active` = '1' ORDER BY `WebCategory`.`priority` ASC	2	2	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_category_id` IN (1, 28) ORDER BY `ChildCategory`.`priority` ASC	4	4	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`is_active` = 1 AND `ChildCategory`.`parent_category_id` IN (2, 8, 20, 24) ORDER BY `ChildCategory`.`priority` ASC	16	16	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`is_active` = 1 AND `ChildCategory`.`parent_category_id` IN (3, 25, 29, 9, 22, 10, 26, 4, 12, 5, 23, 6, 27, 7, 18, 19) ORDER BY `ChildCategory`.`priority` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`is_active` = 1 AND `ChildCategory`.`parent_category_id` IN (13, 17, 14) ORDER BY `ChildCategory`.`priority` ASC	0	0	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (13, 17, 14)	3	3	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (3, 25, 29, 9, 22, 10, 26, 4, 12, 5, 23, 6, 27, 7, 18, 19)	16	16	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (2, 8, 20, 24)	4	4	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (1, 28)	2	2	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date`, `ParentCategory`.`id`, `ParentCategory`.`parent_category_id`, `ParentCategory`.`alias`, `ParentCategory`.`web_category_type_id`, `ParentCategory`.`web_template_id`, `ParentCategory`.`is_active`, `ParentCategory`.`priority`, `ParentCategory`.`modified_date`, `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name`, `WebTemplate`.`id`, `WebTemplate`.`alias`, `WebTemplate`.`name` FROM `cam_foam`.`web_categories` AS `WebCategory` LEFT JOIN `cam_foam`.`web_categories` AS `ParentCategory` ON (`WebCategory`.`parent_category_id` = `ParentCategory`.`id`) LEFT JOIN `cam_foam`.`web_category_types` AS `WebCategoryType` ON (`WebCategory`.`web_category_type_id` = `WebCategoryType`.`id`) LEFT JOIN `cam_foam`.`web_templates` AS `WebTemplate` ON (`WebCategory`.`web_template_id` = `WebTemplate`.`id`) WHERE 1 = 1 ORDER BY `WebCategory`.`priority` ASC	29	29	1
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	24	24	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	29	29	0
SELECT `WebArticle`.`id`, `WebArticle`.`web_category_id`, `WebArticle`.`image_file`, `WebArticle`.`document_file_1`, `WebArticle`.`document_file_2`, `WebArticle`.`priority`, `WebArticle`.`modified_date` FROM `cam_foam`.`web_articles` AS `WebArticle` WHERE `WebArticle`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	119	119	1
SELECT `WebEvent`.`id`, `WebEvent`.`web_category_id`, `WebEvent`.`start_date`, `WebEvent`.`end_date`, `WebEvent`.`image_file_1`, `WebEvent`.`image_file_2`, `WebEvent`.`image_file_3`, `WebEvent`.`priority`, `WebEvent`.`modified_date` FROM `cam_foam`.`web_events` AS `WebEvent` WHERE `WebEvent`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	128	128	1
SELECT `WebOrgInfo`.`id`, `WebOrgInfo`.`web_category_id`, `WebOrgInfo`.`tel1`, `WebOrgInfo`.`tel2`, `WebOrgInfo`.`tel3`, `WebOrgInfo`.`fax1`, `WebOrgInfo`.`fax2`, `WebOrgInfo`.`fax3`, `WebOrgInfo`.`email1`, `WebOrgInfo`.`email2`, `WebOrgInfo`.`email3`, `WebOrgInfo`.`address`, `WebOrgInfo`.`priority`, `WebOrgInfo`.`modified_date` FROM `cam_foam`.`web_org_infos` AS `WebOrgInfo` WHERE `WebOrgInfo`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	1	1	0
SELECT `WebPhotoAlbum`.`id`, `WebPhotoAlbum`.`web_category_id`, `WebPhotoAlbum`.`priority`, `WebPhotoAlbum`.`modified_date` FROM `cam_foam`.`web_photo_albums` AS `WebPhotoAlbum` WHERE `WebPhotoAlbum`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	7	7	0
SELECT `WebVideo`.`id`, `WebVideo`.`web_category_id`, `WebVideo`.`video_file`, `WebVideo`.`thumbnail_file`, `WebVideo`.`priority`, `WebVideo`.`modified_date` FROM `cam_foam`.`web_videos` AS `WebVideo` WHERE `WebVideo`.`web_category_id` IN (1, 25, 21, 29, 9, 3, 2, 4, 17, 13, 26, 10, 8, 22, 20, 23, 14, 12, 11, 5, 24, 27, 6, 15, 16, 7, 28, 18, 19)	0	0	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 10	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (10)	1	1	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 4	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (4)	2	2	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 5	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (5)	2	2	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 4	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (4)	2	2	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 2	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (2)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 6	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (6)	1	1	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 1	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (1)	6	6	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 11	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (11)	1	1	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 5	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (5)	2	2	0
SELECT `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name` FROM `cam_foam`.`web_category_types` AS `WebCategoryType` WHERE `WebCategoryType`.`id` = 3	1	1	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`web_category_type_id` = (3)	10	10	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `WebCategory` WHERE `WebCategory`.`parent_category_id` IS NULL AND `WebCategory`.`is_active` = '1' ORDER BY `WebCategory`.`priority` ASC	2	2	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_category_id` IN (1, 28) ORDER BY `ChildCategory`.`priority` ASC	4	4	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`is_active` = 1 AND `ChildCategory`.`parent_category_id` IN (2, 8, 20, 24) ORDER BY `ChildCategory`.`priority` ASC	16	16	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`is_active` = 1 AND `ChildCategory`.`parent_category_id` IN (3, 25, 29, 9, 22, 10, 26, 4, 12, 5, 23, 6, 27, 7, 18, 19) ORDER BY `ChildCategory`.`priority` ASC	3	3	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`is_active` = 1 AND `ChildCategory`.`parent_category_id` IN (13, 17, 14) ORDER BY `ChildCategory`.`priority` ASC	0	0	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (13, 17, 14)	3	3	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (3, 25, 29, 9, 22, 10, 26, 4, 12, 5, 23, 6, 27, 7, 18, 19)	16	16	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (2, 8, 20, 24)	4	4	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`language_id` = "1" AND `WebCategoryTranslation`.`web_category_id` IN (1, 28)	2	2	0
SELECT `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date`, `ParentCategory`.`id`, `ParentCategory`.`parent_category_id`, `ParentCategory`.`alias`, `ParentCategory`.`web_category_type_id`, `ParentCategory`.`web_template_id`, `ParentCategory`.`is_active`, `ParentCategory`.`priority`, `ParentCategory`.`modified_date`, `WebCategoryType`.`id`, `WebCategoryType`.`alias`, `WebCategoryType`.`name`, `WebTemplate`.`id`, `WebTemplate`.`alias`, `WebTemplate`.`name` FROM `cam_foam`.`web_categories` AS `WebCategory` LEFT JOIN `cam_foam`.`web_categories` AS `ParentCategory` ON (`WebCategory`.`parent_category_id` = `ParentCategory`.`id`) LEFT JOIN `cam_foam`.`web_category_types` AS `WebCategoryType` ON (`WebCategory`.`web_category_type_id` = `WebCategoryType`.`id`) LEFT JOIN `cam_foam`.`web_templates` AS `WebTemplate` ON (`WebCategory`.`web_template_id` = `WebTemplate`.`id`) WHERE `WebCategory`.`alias` = 'home' ORDER BY `WebCategory`.`priority` ASC LIMIT 1	1	1	0
SELECT `ChildCategory`.`id`, `ChildCategory`.`parent_category_id`, `ChildCategory`.`alias`, `ChildCategory`.`web_category_type_id`, `ChildCategory`.`web_template_id`, `ChildCategory`.`is_active`, `ChildCategory`.`priority`, `ChildCategory`.`modified_date` FROM `cam_foam`.`web_categories` AS `ChildCategory` WHERE `ChildCategory`.`parent_category_id` = (1)	4	4	0
SELECT `WebCategoryTranslation`.`id`, `WebCategoryTranslation`.`web_category_id`, `WebCategoryTranslation`.`language_id`, `WebCategoryTranslation`.`title` FROM `cam_foam`.`web_category_translations` AS `WebCategoryTranslation` WHERE `WebCategoryTranslation`.`web_category_id` = (1)	1	1	0
SELECT `WebArticle`.`id`, `WebArticle`.`web_category_id`, `WebArticle`.`image_file`, `WebArticle`.`document_file_1`, `WebArticle`.`document_file_2`, `WebArticle`.`priority`, `WebArticle`.`modified_date` FROM `cam_foam`.`web_articles` AS `WebArticle` WHERE `WebArticle`.`web_category_id` = (1)	5	5	0
SELECT `WebEvent`.`id`, `WebEvent`.`web_category_id`, `WebEvent`.`start_date`, `WebEvent`.`end_date`, `WebEvent`.`image_file_1`, `WebEvent`.`image_file_2`, `WebEvent`.`image_file_3`, `WebEvent`.`priority`, `WebEvent`.`modified_date` FROM `cam_foam`.`web_events` AS `WebEvent` WHERE `WebEvent`.`web_category_id` = (1)	0	0	0
SELECT `WebOrgInfo`.`id`, `WebOrgInfo`.`web_category_id`, `WebOrgInfo`.`tel1`, `WebOrgInfo`.`tel2`, `WebOrgInfo`.`tel3`, `WebOrgInfo`.`fax1`, `WebOrgInfo`.`fax2`, `WebOrgInfo`.`fax3`, `WebOrgInfo`.`email1`, `WebOrgInfo`.`email2`, `WebOrgInfo`.`email3`, `WebOrgInfo`.`address`, `WebOrgInfo`.`priority`, `WebOrgInfo`.`modified_date` FROM `cam_foam`.`web_org_infos` AS `WebOrgInfo` WHERE `WebOrgInfo`.`web_category_id` = (1)	0	0	0
SELECT `WebPhotoAlbum`.`id`, `WebPhotoAlbum`.`web_category_id`, `WebPhotoAlbum`.`priority`, `WebPhotoAlbum`.`modified_date` FROM `cam_foam`.`web_photo_albums` AS `WebPhotoAlbum` WHERE `WebPhotoAlbum`.`web_category_id` = (1)	1	1	0
SELECT `WebVideo`.`id`, `WebVideo`.`web_category_id`, `WebVideo`.`video_file`, `WebVideo`.`thumbnail_file`, `WebVideo`.`priority`, `WebVideo`.`modified_date` FROM `cam_foam`.`web_videos` AS `WebVideo` WHERE `WebVideo`.`web_category_id` = (1)	0	0	0
SELECT `WebArticle`.`id`, `WebArticle`.`web_category_id`, `WebArticle`.`image_file`, `WebArticle`.`document_file_1`, `WebArticle`.`document_file_2`, `WebArticle`.`priority`, `WebArticle`.`modified_date`, `WebCategory`.`id`, `WebCategory`.`parent_category_id`, `WebCategory`.`alias`, `WebCategory`.`web_category_type_id`, `WebCategory`.`web_template_id`, `WebCategory`.`is_active`, `WebCategory`.`priority`, `WebCategory`.`modified_date` FROM `cam_foam`.`web_articles` AS `WebArticle` LEFT JOIN `cam_foam`.`web_categories` AS `WebCategory` ON (`WebArticle`.`web_category_id` = `WebCategory`.`id`) WHERE `web_category_id` = 1 ORDER BY `WebArticle`.`priority` asc, `WebArticle`.`modified_date` desc	5	5	0
SELECT `WebArticleTag`.`id`, `WebArticleTag`.`web_article_id`, `WebArticleTag`.`tag_name` FROM `cam_foam`.`web_article_tags` AS `WebArticleTag` WHERE `WebArticleTag`.`web_article_id` IN (374, 357, 338, 335, 327)	0	0	0
SELECT `WebArticleTranslation`.`id`, `WebArticleTranslation`.`web_article_id`, `WebArticleTranslation`.`language_id`, `WebArticleTranslation`.`title`, `WebArticleTranslation`.`description` FROM `cam_foam`.`web_article_translations` AS `WebArticleTranslation` WHERE `WebArticleTranslation`.`web_article_id` IN (374, 357, 338, 335, 327)	5	5	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 7.13 MB

Message	Memory use
Component initialization	783 KB
Controller action start	1.59 MB
Controller render start	1.70 MB
View render complete	1.88 MB

Timers

Total Request Time: 2674 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	1129.97
Event: Controller.initialize	1410.82
Event: Controller.startup	0.39
Controller action	7.52
Event: Controller.beforeRender	8.40
» Processing toolbar data	8.33
Rendering View	2.04
» Event: View.beforeRender	0.01
» Rendering APP/View/Main/index.ctp	0.35
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	1.38
» » Rendering APP/View/Elements/header_menu.ctp	0.90
» » Rendering APP/View/Elements/footer.ctp	0.02
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- showBreadcrumb(false)
- banners(array)
  0(array)
  id374
  title
  description
  image_urlhttps://cuhkmuseumfriends.com/files/articles/Screenshot 2020-10-23 at 10.29.09 AM_23-10-2020-02-37-27.jpg
  document1_url
  document2_url
  modified_date2020-10-23 10:37:27
  1(array)
  id357
  title
  description
  image_urlhttps://cuhkmuseumfriends.com/files/articles/Front Cover v2_14-11-2018-11-48-53.png
  document1_url
  document2_url
  modified_date2018-11-14 19:48:53
  2(array)
  id338
  title
  description
  image_urlhttps://cuhkmuseumfriends.com/files/articles/Website Front Cover 2_15-08-2017-08-47-16resize.jpg
  document1_url
  document2_url
  modified_date2017-08-15 16:47:16
  3(array)
  id335
  title
  description
  image_urlhttps://cuhkmuseumfriends.com/files/articles/Front cover webpage v2_08-03-2017-08-01-39.png
  document1_url
  document2_url
  modified_date2017-03-08 16:01:39
  4(array)
  id327
  title
  description
  image_urlhttps://cuhkmuseumfriends.com/files/articles/Website BeFunky Collage _15-09-2016-10-54-43.jpg
  document1_url
  document2_url
  modified_date2016-09-15 18:54:43
- allWebCategories(array)
  0(array)
  WebCategory(array)
  id1
  parent_category_id(null)
  aliashome
  web_category_type_id10
  web_template_id1
  is_active(true)
  priority1
  modified_date2014-06-13 19:41:59
  ChildCategory(array)
  0(array)
  id2
  parent_category_id1
  aliaswho
  web_category_type_id1
  web_template_id(null)
  is_active(true)
  priority1
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id28
  web_category_id2
  language_id1
  titleWho we are
  ChildCategory(array)
  0(array)
  id3
  parent_category_id2
  aliaswho_team
  web_category_type_id2
  web_template_id2
  is_active(true)
  priority1
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id29
  web_category_id3
  language_id1
  titleWho we are and our team
  1(array)
  id4
  parent_category_id2
  aliaswho_chair
  web_category_type_id3
  web_template_id3
  is_active(true)
  priority2
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id30
  web_category_id4
  language_id1
  titleOur Chair's message
  2(array)
  id5
  parent_category_id2
  aliaswho_history
  web_category_type_id2
  web_template_id2
  is_active(true)
  priority3
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id31
  web_category_id5
  language_id1
  titleOur history
  3(array)
  id6
  parent_category_id2
  aliaswho_sponsor
  web_category_type_id2
  web_template_id3
  is_active(true)
  priority4
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id32
  web_category_id6
  language_id1
  titleSponsorships and awards
  4(array)
  id7
  parent_category_id2
  aliaswho_achievement
  web_category_type_id3
  web_template_id3
  is_active(true)
  priority5
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id33
  web_category_id7
  language_id1
  titleStudent awards
  1(array)
  id8
  parent_category_id1
  aliaswhat
  web_category_type_id1
  web_template_id(null)
  is_active(true)
  priority2
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id34
  web_category_id8
  language_id1
  titleWhat we do
  ChildCategory(array)
  0(array)
  id9
  parent_category_id8
  aliaswhat_event
  web_category_type_id4
  web_template_id4
  is_active(true)
  priority1
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id35
  web_category_id9
  language_id1
  titleEvent calendar
  1(array)
  id10
  parent_category_id8
  aliaswhat_young
  web_category_type_id3
  web_template_id3
  is_active(true)
  priority2
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id36
  web_category_id10
  language_id1
  titleYoung friends and students
  2(array)
  id12
  parent_category_id8
  aliaswhat_travel_tour
  web_category_type_id4
  web_template_id4
  is_active(true)
  priority3
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id48
  web_category_id12
  language_id1
  titleTravel with friends
  ChildCategory(array)
  0(array)
  id13
  parent_category_id12
  aliaswhat_travel_report
  web_category_type_id3
  web_template_id3
  is_active(true)
  priority2
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id49
  web_category_id13
  language_id1
  titleTrip reports
  1(array)
  id14
  parent_category_id12
  aliaswhat_travel_photo
  web_category_type_id5
  web_template_id5
  is_active(true)
  priority3
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id50
  web_category_id14
  language_id1
  titlePhoto gallery
  3(array)
  id27
  parent_category_id8
  aliaswhat_study_group
  web_category_type_id3
  web_template_id7
  is_active(true)
  priority4
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id68
  web_category_id27
  language_id1
  titleStudy with friends
  ChildCategory(array)
  0(array)
  id17
  parent_category_id27
  aliaswhat_study_resource
  web_category_type_id2
  web_template_id7
  is_active(true)
  priority2
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id53
  web_category_id17
  language_id1
  titleResource library
  4(array)
  id18
  parent_category_id8
  aliaswhat_shop
  web_category_type_id5
  web_template_id8
  is_active(true)
  priority5
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id54
  web_category_id18
  language_id1
  titleShop with friends
  5(array)
  id19
  parent_category_id8
  aliaswhat_newsletter
  web_category_type_id3
  web_template_id9
  is_active(true)
  priority6
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id55
  web_category_id19
  language_id1
  titleNewsletter
  2(array)
  id20
  parent_category_id1
  aliasmembership
  web_category_type_id1
  web_template_id(null)
  is_active(true)
  priority3
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id56
  web_category_id20
  language_id1
  titleMembership
  ChildCategory(array)
  0(array)
  id29
  parent_category_id20
  aliasmembership_newform
  web_category_type_id2
  web_template_id2
  is_active(true)
  priority1
  modified_date2020-09-04 15:41:47
  WebCategoryTranslation(array)
  0(array)
  id70
  web_category_id29
  language_id1
  titleMembership form
  1(array)
  id22
  parent_category_id20
  aliasmembership_collector
  web_category_type_id3
  web_template_id2
  is_active(true)
  priority2
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id63
  web_category_id22
  language_id1
  titleCollector's circle
  2(array)
  id23
  parent_category_id20
  aliasmembership_partner
  web_category_type_id3
  web_template_id2
  is_active(true)
  priority3
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id64
  web_category_id23
  language_id1
  titleOur sponsors and partners
  3(array)
  id24
  parent_category_id1
  aliascontactus
  web_category_type_id1
  web_template_id(null)
  is_active(true)
  priority4
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id65
  web_category_id24
  language_id1
  titleContact us
  ChildCategory(array)
  0(array)
  id25
  parent_category_id24
  aliascontactus_info
  web_category_type_id3
  web_template_id11
  is_active(true)
  priority1
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id66
  web_category_id25
  language_id1
  titleContact us
  1(array)
  id26
  parent_category_id24
  aliascontactus_volunteer
  web_category_type_id3
  web_template_id2
  is_active(true)
  priority2
  modified_date2014-06-13 19:41:59
  WebCategoryTranslation(array)
  0(array)
  id67
  web_category_id26
  language_id1
  titleVolunteer
  WebCategoryTranslation(array)
  0(array)
  id27
  web_category_id1
  language_id1
  titleMain page
  1(array)
  WebCategory(array)
  id28
  parent_category_id(null)
  aliasvariables
  web_category_type_id11
  web_template_id12
  is_active(true)
  priority5
  modified_date2015-02-12 16:15:28
  ChildCategory(empty)
  WebCategoryTranslation(array)
  0(array)
  id69
  web_category_id28
  language_id1
  titleVariables
- webCategory(array)
  1(array)
  aliashome
  controllerpages
  25(array)
  aliascontactus_info
  controllerWebArticles
  21(array)
  aliasmembership_form
  controllerWebArticles
  29(array)
  aliasmembership_newform
  controllerWebArticles
  9(array)
  aliaswhat_event
  controllerWebEvents
  3(array)
  aliaswho_team
  controllerWebArticles
  2(array)
  aliaswho
  controllerpages
  4(array)
  aliaswho_chair
  controllerWebArticles
  17(array)
  aliaswhat_study_resource
  controllerWebArticles
  13(array)
  aliaswhat_travel_report
  controllerWebArticles
  26(array)
  aliascontactus_volunteer
  controllerWebArticles
  10(array)
  aliaswhat_young
  controllerWebArticles
  8(array)
  aliaswhat
  controllerpages
  22(array)
  aliasmembership_collector
  controllerWebArticles
  20(array)
  aliasmembership
  controllerpages
  23(array)
  aliasmembership_partner
  controllerWebArticles
  14(array)
  aliaswhat_travel_photo
  controllerWebPhotoAlbums
  12(array)
  aliaswhat_travel_tour
  controllerWebEvents
  11(array)
  aliaswhat_travel
  controllerpages
  5(array)
  aliaswho_history
  controllerWebArticles
  24(array)
  aliascontactus
  controllerpages
  27(array)
  aliaswhat_study_group
  controllerWebArticles
  6(array)
  aliaswho_sponsor
  controllerWebArticles
  15(array)
  aliaswhat_travel_video
  controllerWebVideoes
  16(array)
  aliaswhat_study
  controllerpages
  7(array)
  aliaswho_achievement
  controllerWebArticles
  28(array)
  aliasvariables
  controllerpages
  18(array)
  aliaswhat_shop
  controllerWebPhotos
  19(array)
  aliaswhat_newsletter
  controllerWebArticles
- allWebVariables(array)
  FOOTER_EMAILchair@friendscuhk.com
  FOOTER_TEL
  FOOTER_COPYRIGHT© 2014 Friends of the Art Museum, the Chinese University of Hong Kong. All rights reserved
- language(array)
  Language(array)
  id1
  aliasen
  nameEnglish
- $request->data(empty)
- $this->validationErrors(array)
  Language(empty)
  WebCategory(empty)
  ChildCategory(empty)
  WebCategoryTranslation(empty)
  WebVariable(empty)
  ParentCategory(empty)
  WebCategoryType(empty)
  WebTemplate(empty)
  WebArticle(empty)
  WebEvent(empty)
  WebOrgInfo(empty)
  WebPhotoAlbum(empty)
  WebVideo(empty)
  WebArticleTag(empty)
  WebArticleTranslation(empty)
- Loaded Helpers(array)
  0Cms
  1Web
  2Number
  3SimpleGraph
  4DebugTimer
  5Toolbar
  6Html
  7HtmlToolbar
  8Form
====

Environment

App Constants

Constant	Value
CONFIG	/home/cuhkmf/app/Config/

CakePHP Constants

Constant	Value
APP	/home/cuhkmf/app/
APP_DIR	app
APPLIBS	/home/cuhkmf/app/Lib/
CACHE	/home/cuhkmf/app/tmp/cache/
CAKE	/home/cuhkmf/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/cuhkmf/lib
CORE_PATH	/home/cuhkmf/lib/
CAKE_VERSION	2.10.18
CSS	/home/cuhkmf/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://cuhkmuseumfriends.com
IMAGES	/home/cuhkmf/app/webroot/img/
IMAGES_URL	img/
JS	/home/cuhkmf/app/webroot/js/
JS_URL	js/
LOGS	/home/cuhkmf/app/tmp/logs/
ROOT	/home/cuhkmf
TESTS	/home/cuhkmf/app/Test/
TMP	/home/cuhkmf/app/tmp/
VENDORS	/home/cuhkmf/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/cuhkmf/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.4.16
User	apache
Home	/usr/share/httpd
Script Name	/app/webroot/index.php
Request Uri	/
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/
Remote Port	40706
Script Filename	/home/cuhkmf/app/webroot/index.php
Server Admin	jason@jasonofficial.net
Context Document Root	/home/cuhkmf
Context Prefix
Request Scheme	https
Document Root	/home/cuhkmf
Remote Addr	3.227.0.150
Server Port	443
Server Addr	103.6.48.170
Server Name	cuhkmuseumfriends.com
Server Software	Apache/2.4.46 (Fedora) OpenSSL/1.1.1g
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Connection	Keep-Alive
Http Host	cuhkmuseumfriends.com
Http Accept Encoding	br,gzip
Http If Modified Since	Wed, 14 Apr 2021 05:32:27 GMT
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Proxy-nokeepalive	1
Ssl Tls Sni	cuhkmuseumfriends.com
Https	on
Http Authorization
Unique Id	YJQbWUwq5BKWoRgeAwKaOgAAABI
Redirect Status	200
Redirect Ssl Tls Sni	cuhkmuseumfriends.com
Redirect Https	on
Redirect Unique Id	YJQbWUwq5BKWoRgeAwKaOgAAABI
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1620319065.515
Request Time	1620319065

====

Include
+
Included Files

Include Paths
- 0/home/cuhkmf/lib
- 2/usr/share/pear
- 3/usr/share/php
- 4-> /home/cuhkmf/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/RequestHandlerComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/AuthComponent.php
  3CORE/Controller/Component/Auth/FormAuthenticate.php
  4CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.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/ConnectionManager.php
  3CORE/Model/ModelBehavior.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/CakeObject.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
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/Img2ThumbComponent.php
  1APP/Controller/Component/UploadedImageProcessorComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/MainController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Language.php
  1APP/Model/AppModel.php
  2APP/Model/WebCategory.php
  3APP/Model/WebCategoryTranslation.php
  4APP/Model/WebVariable.php
  5APP/Model/WebCategoryType.php
  6APP/Model/WebTemplate.php
  7APP/Model/WebArticle.php
  8APP/Model/WebEvent.php
  9APP/Model/WebPhotoAlbum.php
  10APP/Model/WebArticleTag.php
  11APP/Model/WebArticleTranslation.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/autoload.php
  2APP/Vendor/composer/autoload_real.php
  3APP/Vendor/composer/ClassLoader.php
  4APP/Vendor/composer/autoload_namespaces.php
  5APP/Vendor/composer/autoload_psr4.php
  6APP/Vendor/composer/autoload_classmap.php
  7APP/Lib/PublicAssetPathBuilder.php
- plugins(array)
  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
  Usermin(array)
  Config(array)
  0Usermin/Config/routes.php
====

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 1351 ms Total Queries: 172 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 1351 ms
Total Queries: 172 queries