CakePHP: the rapid development php framework: ScheduleManagers: index

home

Schedule Manager

shedule an exhibit

Page 1 of 9, showing 10 records out of 82 total, starting on record 1, ending on 10

common_name	animal_type	room	start_date	end_date
Anaconda	Jungles	Lobby	Dec 27th 2009, 15:25	Jan 10th 2009, 15:25
Giraffe	Jungles	Lobby	Jan 10th 2009, 09:43	Feb 12th 2009, 09:43
Cat	Barnyards	South Wing	Dec 27th 2009, 15:24	Feb 16th 2009, 15:24
Angel Fish	SeaCreatures	Lobby	Dec 27th 2009, 15:54	Mar 2nd 2009, 15:54
Sloth	Jungles	East Wing	Dec 27th 2009, 15:25	Mar 15th 2009, 15:25
Rhinoceros	Jungles	South Wing	Feb 27th 2009, 15:23	Apr 27th 2009, 15:23
Turkey	Barnyards	Lobby	Dec 27th 2009, 15:24	Apr 27th 2009, 15:24
Rooster	Barnyards	South Wing	Dec 27th 2009, 15:24	May 10th 2009, 15:24
Whale	SeaCreatures	East Wing	Dec 14th 2009, 09:09	May 14th 2009, 09:09
Cheetah	Jungles	West Wing	Dec 27th 2009, 15:25	Jun 5th 2009, 15:25

<< previous

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 next >>

(default) 9 queries took 9 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `animal_relations`	6	6	3
2	DESCRIBE `animals_rooms`	10	10	1
3	DESCRIBE `rooms`	2	2	1
4	DESCRIBE `barnyards`	5	5	1
5	DESCRIBE `jungles`	5	5	1
6	DESCRIBE `sea_creatures`	5	5	1
7	SELECT DISTINCT SUBSTRING(AnimalRelation.common_name, 1, 1) FROM `animal_relations` AS `AnimalRelation` WHERE 1 = 1 ORDER BY `AnimalRelation`.`common_name` asc	16	16	0
8	SELECT COUNT(*) AS `count` FROM `animals_rooms` AS `AnimalsRoom` inner JOIN animal_relations AS `Anim_Rel` ON (`AnimalsRoom`.`animal_relation_id` = `Anim_Rel`.`id` AND `Anim_Rel`.`common_name` LIKE '%') LEFT JOIN `animal_relations` AS `AnimalRelation` ON (`AnimalsRoom`.`animal_relation_id` = `AnimalRelation`.`id`) LEFT JOIN `rooms` AS `Room` ON (`AnimalsRoom`.`room_id` = `Room`.`id`) WHERE 1 = 1	1	1	1
9	SELECT `AnimalsRoom`.`id`, `AnimalsRoom`.`animal_id`, `AnimalsRoom`.`animal_type`, `AnimalsRoom`.`animal_relation_id`, `AnimalsRoom`.`room_id`, `AnimalsRoom`.`start_date`, `AnimalsRoom`.`end_date`, `AnimalsRoom`.`priority`, `AnimalRelation`.`common_name`, `Room`.`name`, `AnimalRelation`.`id`, `Room`.`id` FROM `animals_rooms` AS `AnimalsRoom` inner JOIN animal_relations AS `Anim_Rel` ON (`AnimalsRoom`.`animal_relation_id` = `Anim_Rel`.`id` AND `Anim_Rel`.`common_name` LIKE '%') LEFT JOIN `animal_relations` AS `AnimalRelation` ON (`AnimalsRoom`.`animal_relation_id` = `AnimalRelation`.`id`) LEFT JOIN `rooms` AS `Room` ON (`AnimalsRoom`.`room_id` = `Room`.`id`) WHERE 1 = 1 ORDER BY `AnimalsRoom`.`end_date` asc LIMIT 10	10	10	0

(default) 9 queries took 9 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `animal_relations`

DESCRIBE `animals_rooms`

DESCRIBE `rooms`

DESCRIBE `barnyards`

DESCRIBE `jungles`

DESCRIBE `sea_creatures`

SELECT DISTINCT SUBSTRING(AnimalRelation.common_name, 1, 1) FROM `animal_relations` AS `AnimalRelation` WHERE 1 = 1 ORDER BY `AnimalRelation`.`common_name` asc

SELECT COUNT(*) AS `count` FROM `animals_rooms` AS `AnimalsRoom` inner JOIN animal_relations AS `Anim_Rel` ON (`AnimalsRoom`.`animal_relation_id` = `Anim_Rel`.`id` AND `Anim_Rel`.`common_name` LIKE '%') LEFT JOIN `animal_relations` AS `AnimalRelation` ON (`AnimalsRoom`.`animal_relation_id` = `AnimalRelation`.`id`) LEFT JOIN `rooms` AS `Room` ON (`AnimalsRoom`.`room_id` = `Room`.`id`) WHERE 1 = 1

SELECT `AnimalsRoom`.`id`, `AnimalsRoom`.`animal_id`, `AnimalsRoom`.`animal_type`, `AnimalsRoom`.`animal_relation_id`, `AnimalsRoom`.`room_id`, `AnimalsRoom`.`start_date`, `AnimalsRoom`.`end_date`, `AnimalsRoom`.`priority`, `AnimalRelation`.`common_name`, `Room`.`name`, `AnimalRelation`.`id`, `Room`.`id` FROM `animals_rooms` AS `AnimalsRoom` inner JOIN animal_relations AS `Anim_Rel` ON (`AnimalsRoom`.`animal_relation_id` = `Anim_Rel`.`id` AND `Anim_Rel`.`common_name` LIKE '%') LEFT JOIN `animal_relations` AS `AnimalRelation` ON (`AnimalsRoom`.`animal_relation_id` = `AnimalRelation`.`id`) LEFT JOIN `rooms` AS `Room` ON (`AnimalsRoom`.`room_id` = `Room`.`id`) WHERE 1 = 1 ORDER BY `AnimalsRoom`.`end_date` asc LIMIT 10