CakePHP: the rapid development php framework: Bars

Search for Bars

We have 2000 bars in our database. Use the form below to search based on your perferences. Selecting more preferences returns more results.

Feature clear \| select all	Scene clear \| select all	Neighborhood clear \| select all

(default) 11 queries took 95 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `bars`	12	12	1
2	DESCRIBE `features`	4	4	0
3	DESCRIBE `bars_features`	3	3	0
4	DESCRIBE `neighborhoods`	4	4	0
5	DESCRIBE `bars_neighborhoods`	3	3	0
6	DESCRIBE `scenes`	4	4	0
7	DESCRIBE `bars_scenes`	3	3	0
8	SELECT COUNT(*) AS `count` FROM `bars` AS `Bar` WHERE 1 = 1	1	1	85
9	SELECT `BarsFeature`.`feature_id`, COUNT(`BarsFeature`.`feature_id`), `Feature`.`name` FROM `bars_features` AS `BarsFeature` inner JOIN features AS `Feature` ON (`Feature`.`id` = `BarsFeature`.`feature_id`) WHERE 1 = 1 GROUP BY `BarsFeature`.`feature_id` ORDER BY COUNT(`BarsFeature`.`feature_id`) DESC	15	15	4
10	SELECT `BarsScene`.`scene_id`, COUNT(`BarsScene`.`scene_id`), `Scene`.`name` FROM `bars_scenes` AS `BarsScene` inner JOIN scenes AS `Scene` ON (`Scene`.`id` = `BarsScene`.`scene_id`) WHERE 1 = 1 GROUP BY `BarsScene`.`scene_id` ORDER BY COUNT(`BarsScene`.`scene_id`) DESC	10	10	3
11	SELECT `BarsNeighborhood`.`neighborhood_id`, COUNT(`BarsNeighborhood`.`neighborhood_id`), `Neighborhood`.`name` FROM `bars_neighborhoods` AS `BarsNeighborhood` inner JOIN neighborhoods AS `Neighborhood` ON (`Neighborhood`.`id` = `BarsNeighborhood`.`neighborhood_id`) WHERE 1 = 1 GROUP BY `BarsNeighborhood`.`neighborhood_id` ORDER BY COUNT(`BarsNeighborhood`.`neighborhood_id`) DESC	37	37	2