Pine Shadows Motel

Gallery

Condos

Motel

(default) 8 queries took 30 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `contents`	10	10	2
2	DESCRIBE `callouts`	5	5	1
3	SELECT `Content`.`id`, `Content`.`title`, `Content`.`introText`, `Content`.`bodyText`, `Content`.`keywords`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`created`, `Content`.`modified`, `Content`.`ranking`, `Parentpage`.`id`, `Parentpage`.`title`, `Parentpage`.`introText`, `Parentpage`.`bodyText`, `Parentpage`.`keywords`, `Parentpage`.`slug`, `Parentpage`.`parent_id`, `Parentpage`.`created`, `Parentpage`.`modified`, `Parentpage`.`ranking` FROM `contents` AS `Content` LEFT JOIN `contents` AS `Parentpage` ON (`Content`.`parent_id` = `Parentpage`.`id`) WHERE `Content`.`id` = 19 LIMIT 1	1	1	3
4	SELECT `Childpage`.`id`, `Childpage`.`title`, `Childpage`.`introText`, `Childpage`.`bodyText`, `Childpage`.`keywords`, `Childpage`.`slug`, `Childpage`.`parent_id`, `Childpage`.`created`, `Childpage`.`modified`, `Childpage`.`ranking` FROM `contents` AS `Childpage` WHERE `Childpage`.`parent_id` = (19)	0	0	6
5	SELECT `Callout`.`id`, `Callout`.`content_id`, `Callout`.`title`, `Callout`.`content`, `Callout`.`image` FROM `callouts` AS `Callout` WHERE `Callout`.`content_id` = (19)	0	0	7
6	SELECT `Content`.`id`, `Content`.`title`, `Content`.`introText`, `Content`.`bodyText`, `Content`.`keywords`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`created`, `Content`.`modified`, `Content`.`ranking`, `Parentpage`.`id`, `Parentpage`.`title`, `Parentpage`.`introText`, `Parentpage`.`bodyText`, `Parentpage`.`keywords`, `Parentpage`.`slug`, `Parentpage`.`parent_id`, `Parentpage`.`created`, `Parentpage`.`modified`, `Parentpage`.`ranking` FROM `contents` AS `Content` LEFT JOIN `contents` AS `Parentpage` ON (`Content`.`parent_id` = `Parentpage`.`id`) WHERE `Content`.`parent_id` IS NULL ORDER BY `Content`.`ranking` ASC	7	7	5
7	SELECT `Childpage`.`id`, `Childpage`.`title`, `Childpage`.`introText`, `Childpage`.`bodyText`, `Childpage`.`keywords`, `Childpage`.`slug`, `Childpage`.`parent_id`, `Childpage`.`created`, `Childpage`.`modified`, `Childpage`.`ranking` FROM `contents` AS `Childpage` WHERE `Childpage`.`parent_id` IN (1, 15, 17, 21, 19, 20, 18)	0	0	3
8	SELECT `Callout`.`id`, `Callout`.`content_id`, `Callout`.`title`, `Callout`.`content`, `Callout`.`image` FROM `callouts` AS `Callout` WHERE `Callout`.`content_id` IN (1, 15, 17, 21, 19, 20, 18)	1	1	3

(default) 8 queries took 30 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `contents`

DESCRIBE `callouts`

SELECT `Content`.`id`, `Content`.`title`, `Content`.`introText`, `Content`.`bodyText`, `Content`.`keywords`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`created`, `Content`.`modified`, `Content`.`ranking`, `Parentpage`.`id`, `Parentpage`.`title`, `Parentpage`.`introText`, `Parentpage`.`bodyText`, `Parentpage`.`keywords`, `Parentpage`.`slug`, `Parentpage`.`parent_id`, `Parentpage`.`created`, `Parentpage`.`modified`, `Parentpage`.`ranking` FROM `contents` AS `Content` LEFT JOIN `contents` AS `Parentpage` ON (`Content`.`parent_id` = `Parentpage`.`id`) WHERE `Content`.`id` = 19 LIMIT 1

SELECT `Childpage`.`id`, `Childpage`.`title`, `Childpage`.`introText`, `Childpage`.`bodyText`, `Childpage`.`keywords`, `Childpage`.`slug`, `Childpage`.`parent_id`, `Childpage`.`created`, `Childpage`.`modified`, `Childpage`.`ranking` FROM `contents` AS `Childpage` WHERE `Childpage`.`parent_id` = (19)

SELECT `Callout`.`id`, `Callout`.`content_id`, `Callout`.`title`, `Callout`.`content`, `Callout`.`image` FROM `callouts` AS `Callout` WHERE `Callout`.`content_id` = (19)

SELECT `Callout`.`id`, `Callout`.`content_id`, `Callout`.`title`, `Callout`.`content`, `Callout`.`image` FROM `callouts` AS `Callout` WHERE `Callout`.`content_id` IN (1, 15, 17, 21, 19, 20, 18)