immigration Content Categories

English 中文

Spouse

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.

Spouse

14 queries took 13 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `content_categories`	11	11	7
2	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0f2041d10245eaeb7c7b8de4792a16b6'	1	1	0
3	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '3b84e2dc46280e273da4e759096ffb84'	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:1328786264;s:4:\"rand\";i:1667110379;s:7:\"timeout\";i:9;}', 1328786264, '3b84e2dc46280e273da4e759096ffb84')	1		4
5	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0f2041d10245eaeb7c7b8de4792a16b6'	1	1	0
6	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0f2041d10245eaeb7c7b8de4792a16b6'	1		0
7	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '3b84e2dc46280e273da4e759096ffb84'	1	1	0
8	SELECT `ContentCategory`.`lft`, `ContentCategory`.`rght` FROM `content_categories` AS `ContentCategory` WHERE `ContentCategory`.`id` = 35 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` <= 50 AND `ContentCategory`.`rght` >= 51 ORDER BY `ContentCategory`.`lft` asc	2	2	0
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` = 35 LIMIT 1	1	1	1
13	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '3b84e2dc46280e273da4e759096ffb84'	1	1	1
14	UPDATE `cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:32:\"0a82c5483ae9a296e86eafd3c2effa9c\";s:4:\"time\";i:1328786264;s:4:\"rand\";i:1667110379;s:7:\"timeout\";i:10;}', `expires` = 1328786264 WHERE `id` = '3b84e2dc46280e273da4e759096ffb84'	1		0

14 queries took 13 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `content_categories`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0f2041d10245eaeb7c7b8de4792a16b6'

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

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0f2041d10245eaeb7c7b8de4792a16b6'

DELETE FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0f2041d10245eaeb7c7b8de4792a16b6'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '3b84e2dc46280e273da4e759096ffb84'

SELECT `ContentCategory`.`lft`, `ContentCategory`.`rght` FROM `content_categories` AS `ContentCategory` WHERE `ContentCategory`.`id` = 35 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` <= 50 AND `ContentCategory`.`rght` >= 51 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` = '3b84e2dc46280e273da4e759096ffb84'

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