immigration Content Categories

English 中文

Parent

FAMILY CLASS
This class was formed to help reunite families of Canadian citizens and landed immigrants. Immigration regulations allow a person who is a Canadian citizen or a Permanent Resident of Canada to sponsor the following persons for admission: spouse, common-law or conjugal par tners, dependent children, parents and grandparents.

Parent

14 queries took 22 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `content_categories`	11	11	10
2	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'dad47d88d1127e554de31f2c544105ad'	1	1	0
3	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ef2207113c07290ae0e264327c7f60b8'	1	1	0
4	INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config\|a:4:{s:9:\"userAgent\";s:32:\"0a82c5483ae9a296e86eafd3c2effa9c\";s:4:\"time\";i:1328786038;s:4:\"rand\";i:1667110379;s:7:\"timeout\";i:9;}', 1328786038, 'ef2207113c07290ae0e264327c7f60b8')	1		4
5	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'dad47d88d1127e554de31f2c544105ad'	1	1	2
6	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'dad47d88d1127e554de31f2c544105ad'	1		1
7	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ef2207113c07290ae0e264327c7f60b8'	1	1	1
8	SELECT `ContentCategory`.`lft`, `ContentCategory`.`rght` FROM `content_categories` AS `ContentCategory` WHERE `ContentCategory`.`id` = 36 LIMIT 1	1	1	0
9	SELECT `ContentCategory`.`id`, `ContentCategory`.`sort`, `ContentCategory`.`parent_id`, `ContentCategory`.`lft`, `ContentCategory`.`rght`, `ContentCategory`.`name`, `ContentCategory`.`name_cn`, `ContentCategory`.`description`, `ContentCategory`.`description_cn`, `ContentCategory`.`created`, `ContentCategory`.`modified` FROM `content_categories` AS `ContentCategory` WHERE 1 = 1 AND `ContentCategory`.`lft` <= 52 AND `ContentCategory`.`rght` >= 53 ORDER BY `ContentCategory`.`lft` asc	2	2	1
10	SELECT `ContentCategory`.`lft`, `ContentCategory`.`rght` FROM `content_categories` AS `ContentCategory` WHERE 1 = 1 AND `ContentCategory`.`id` = 30 LIMIT 1	1	1	0
11	SELECT `ContentCategory`.`id`, `ContentCategory`.`sort`, `ContentCategory`.`parent_id`, `ContentCategory`.`lft`, `ContentCategory`.`rght`, `ContentCategory`.`name`, `ContentCategory`.`name_cn`, `ContentCategory`.`description`, `ContentCategory`.`description_cn`, `ContentCategory`.`created`, `ContentCategory`.`modified` FROM `content_categories` AS `ContentCategory` WHERE 1 = 1 AND `ContentCategory`.`rght` < 62 AND `ContentCategory`.`lft` > 43 ORDER BY `ContentCategory`.`lft` asc	9	9	0
12	SELECT `ContentCategory`.`id`, `ContentCategory`.`sort`, `ContentCategory`.`parent_id`, `ContentCategory`.`lft`, `ContentCategory`.`rght`, `ContentCategory`.`name`, `ContentCategory`.`name_cn`, `ContentCategory`.`description`, `ContentCategory`.`description_cn`, `ContentCategory`.`created`, `ContentCategory`.`modified` FROM `content_categories` AS `ContentCategory` WHERE `ContentCategory`.`id` = 36 LIMIT 1	1	1	0
13	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ef2207113c07290ae0e264327c7f60b8'	1	1	0
14	UPDATE `cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:32:\"0a82c5483ae9a296e86eafd3c2effa9c\";s:4:\"time\";i:1328786038;s:4:\"rand\";i:1667110379;s:7:\"timeout\";i:10;}', `expires` = 1328786038 WHERE `id` = 'ef2207113c07290ae0e264327c7f60b8'	1		3

14 queries took 22 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `content_categories`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'dad47d88d1127e554de31f2c544105ad'

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ef2207113c07290ae0e264327c7f60b8'

INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:4:{s:9:\"userAgent\";s:32:\"0a82c5483ae9a296e86eafd3c2effa9c\";s:4:\"time\";i:1328786038;s:4:\"rand\";i:1667110379;s:7:\"timeout\";i:9;}', 1328786038, 'ef2207113c07290ae0e264327c7f60b8')

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'dad47d88d1127e554de31f2c544105ad'

DELETE FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'dad47d88d1127e554de31f2c544105ad'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ef2207113c07290ae0e264327c7f60b8'

SELECT `ContentCategory`.`lft`, `ContentCategory`.`rght` FROM `content_categories` AS `ContentCategory` WHERE `ContentCategory`.`id` = 36 LIMIT 1

SELECT `ContentCategory`.`id`, `ContentCategory`.`sort`, `ContentCategory`.`parent_id`, `ContentCategory`.`lft`, `ContentCategory`.`rght`, `ContentCategory`.`name`, `ContentCategory`.`name_cn`, `ContentCategory`.`description`, `ContentCategory`.`description_cn`, `ContentCategory`.`created`, `ContentCategory`.`modified` FROM `content_categories` AS `ContentCategory` WHERE 1 = 1 AND `ContentCategory`.`lft` <= 52 AND `ContentCategory`.`rght` >= 53 ORDER BY `ContentCategory`.`lft` asc

SELECT `ContentCategory`.`lft`, `ContentCategory`.`rght` FROM `content_categories` AS `ContentCategory` WHERE 1 = 1 AND `ContentCategory`.`id` = 30 LIMIT 1

SELECT `ContentCategory`.`id`, `ContentCategory`.`sort`, `ContentCategory`.`parent_id`, `ContentCategory`.`lft`, `ContentCategory`.`rght`, `ContentCategory`.`name`, `ContentCategory`.`name_cn`, `ContentCategory`.`description`, `ContentCategory`.`description_cn`, `ContentCategory`.`created`, `ContentCategory`.`modified` FROM `content_categories` AS `ContentCategory` WHERE 1 = 1 AND `ContentCategory`.`rght` < 62 AND `ContentCategory`.`lft` > 43 ORDER BY `ContentCategory`.`lft` asc

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ef2207113c07290ae0e264327c7f60b8'

UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:32:\"0a82c5483ae9a296e86eafd3c2effa9c\";s:4:\"time\";i:1328786038;s:4:\"rand\";i:1667110379;s:7:\"timeout\";i:10;}', `expires` = 1328786038 WHERE `id` = 'ef2207113c07290ae0e264327c7f60b8'